
Extract data, produce charts in Excel, paste into a Word template + format
5548
£250(approx. $336)
- Posted:
- Proposals: 6
- Remote
- #50308
- Archived
Mobile App Development, Python, Power BI, Flutter, Angular, Android, IOS, Developer, Django, Ionic Framework, React JS, PHP, Web, Startup


12653412767811316698555129070119290
Description
Experience Level: Expert
Overall task:
Fill a presentation template (provided) with nicely formatted charts based on the data provided
Tasks:
1) Extract data from English reports (provided in PDF format, text can be copied) into Excel (ca. 5 charts)
2) Extract data from Portuguese reports (provided in PDF format, some text re-keying required for chart titles, no translation necessary) into Excel (ca. datasets/5 charts)
3) Extract data from several Excel files (copying and reformatting) into another Excel file (from which charts will be produced) - ca. 10-12 datasets
4) Produce 20-22 charts in Excel from the above collected data, using chart styles from a provided template
5) Copy/embed the charts into a Word document (template provided), add title and data sources captions with numbering
Notes:
- All input data files will provided in various formats (PDF, .doc, Excel) and output formatting templates will be provided in Office 2007 format.
- Almost all charts are bar or line charts for 1 or 2 data series (sometimes on 2 axes). Most consist of 5 to 12 datapoints in a series.
- The final presentation will be in Word 2007 format and will contain about 20-25 charts on 20 pages.
It is expected that the job should take about a day for someone proficient with Office 2007 and great attention to details.
Deadline - COB January 2nd, 2011.
There is a possibility of a steady flow of similar projects if happy with the results.
Fill a presentation template (provided) with nicely formatted charts based on the data provided
Tasks:
1) Extract data from English reports (provided in PDF format, text can be copied) into Excel (ca. 5 charts)
2) Extract data from Portuguese reports (provided in PDF format, some text re-keying required for chart titles, no translation necessary) into Excel (ca. datasets/5 charts)
3) Extract data from several Excel files (copying and reformatting) into another Excel file (from which charts will be produced) - ca. 10-12 datasets
4) Produce 20-22 charts in Excel from the above collected data, using chart styles from a provided template
5) Copy/embed the charts into a Word document (template provided), add title and data sources captions with numbering
Notes:
- All input data files will provided in various formats (PDF, .doc, Excel) and output formatting templates will be provided in Office 2007 format.
- Almost all charts are bar or line charts for 1 or 2 data series (sometimes on 2 axes). Most consist of 5 to 12 datapoints in a series.
- The final presentation will be in Word 2007 format and will contain about 20-25 charts on 20 pages.
It is expected that the job should take about a day for someone proficient with Office 2007 and great attention to details.
Deadline - COB January 2nd, 2011.
There is a possibility of a steady flow of similar projects if happy with the results.
Konstantin K.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
5 Jan 2011
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies