Freelance projects

Freelance projects

Combining scanned tables into one Excel spreadsheet with the addition of formulas

Data Processing — incorrectly specified categories?

22 USD

Client's review of cooperation with freelancer

Combining scanned tables into one Excel spreadsheet with the addition of formulas

22 USD

He completed the work very quickly and super professionally. For me, this work with tables was unclear and difficult, and he finished it literally in an hour (maybe less). I didn't even expect such a quick result. I had been doing these tables manually for two years, spending four hours each time, and now the working time has been reduced to literally 40 minutes, without rushing. Mr. Ivan has my huge gratitude and respect as a professional in his field, and my recommendations; this person will help make your life significantly easier.

5.0

Ivan Krendikov

Reciprocal Feedback

31 May

Freelancer's review of cooperation with Ivan Krendikov

Combining scanned tables into one Excel spreadsheet with the addition of formulas

22 USD

Everything went wonderfully. Excellent communication, clearly defined task. I definitely recommend the client for collaboration.

5.0

Profile blocked

Reciprocal Feedback

31 May

Project translated automatically. Log in or register, to view the original

Task: In the attached files, you will see three tables

1. They need to be converted to Excel;

2. They must be in one file, as the data from them affects the following ones;

3. In the first table, all the headings at the top must be preserved, on the left there should be space for the student's first and last name, at the top the names of the subjects (to be listed from bottom to top) this will be important in the next two tables (here are the names of the subjects

Algebra, English, Biology, World History, Geography, Geometry, Foreign Literature, Computer Science, History of Ukraine, Art, Health Basics, Law, Labor Education, Ukrainian Literature, Ukrainian Language, Physics, Physical Education, Chemistry) they must be in this exact order, the middle for grades;

4. The second table, here it is necessary to take into account the data about performance by grades indicated in the scan, we take them from the first table and count the number of grades of that specific category, from the same subject, after the data of one achievement level has been recorded, the percentage for that subject and level must be calculated, this is done using the number of students field, exempted and individual learning are not counted in the statistics;

5. The third table is the most complex, here again the subjects in the same order as in the previous two, for each subject the number of students, the average grade for the subject, but the level table is easier, we simply take the sum of the data levels (beginner, intermediate, etc.) and transfer the total number to the corresponding level in the lower table. The one above here is the overall average grade, regarding the levels we take the average grade from the subjects, count the number by levels and record it (for example, high is 12-10 average grade and how many such average grades were in the lower table);

6. It is very important to preserve the original appearance of the tables so that they are accepted by the administration

Context: The class teacher wants to automate a routine task

Expectations: A working file that will work on both modern Excel and older versions and will make life easier

Deadline: up to three days

Budget: 1000 UAH

Successful completion: testing the table, a maximum of three rounds of edits

Proposals 1

Current freelance projects in the category Data Processing

Collect 1,000+ active Telegram investment/crypto groups

Information Gathering 17 proposals 31 July

Not specified
Collect active Telegram investment/crypto groups with admin and moderator contacts

Information Gathering 15 proposals 30 July

Not specified
Test the application (no experience required)

Testing & QA 44 proposals 29 July

57 USD
Filtering the LMIA database of Canada and manual collection of employer contacts (Email, Social Media)

Information Gathering 22 proposals 29 July

25 USD
Find and add links to photos for 900 airplanes.

Data Parsing 33 proposals 28 July

45 USD

Ivan Krendikov
Kyiv, Ukraine

Projects 1
Rating -
Rating 43

Combining scanned tables into one Excel spreadsheet with the addition of formulas

Client's review of cooperation with freelancer

Combining scanned tables into one Excel spreadsheet with the addition of formulas

5.0

Ivan Krendikov

Freelancer's review of cooperation with Ivan Krendikov

Combining scanned tables into one Excel spreadsheet with the addition of formulas

5.0

Proposals concealed

Proposals are currently absent

Current freelance projects in the category Data Processing

Collect 1,000+ active Telegram investment/crypto groups

Collect active Telegram investment/crypto groups with admin and moderator contacts

Test the application (no experience required)

Filtering the LMIA database of Canada and manual collection of employer contacts (Email, Social Media)

Find and add links to photos for 900 airplanes.