Batch job transferring excel charts to word documents
- or -
Post a project like this1330
£100(approx. $125)
- Posted:
- Proposals: 24
- Remote
- #2966806
- PRE-FUNDED
- Completed
Excel Expert |WordPress| Google Sheets |VBA & Google App Script | Woocommerce
Jhelum
Data Entry | Data Scraping | MS Access | Photoshop Design | PDF Conversion | Word Processing
Kathmandu
WordPress Expert✮Shopify Expert✮Graphic Designer✮AutoCAD 2D & 3D✮CV Writer & Designer✮Fullstack developer
Rawalpindi
316067327829774814003476938747549984752884454991644178424043330387349136365732889708
Description
Experience Level: Expert
Estimated project duration: less than 1 week
I am preparing 260 Word reports and need all-ready prepared excel charts pasted into each report. Each individual report has around 20 bespoke charts that need to be pasted into the report in the appropriate place. I also want the completed reports converted into pdf.
I don’t think there is a way of automating this job so it is likely that it has to be done manually. It is a fiddly job that needs patience to ensure that each chart is placed correctly and aligned to the corresponding box and sized properly. I estimate that it takes about 10 minutes to complete each report.
All the charts have been prepared on individual excel worksheets in a single workbook. The charts from the matching worksheet need to be pasted into the corresponding report e.g. charts from worksheet Primary ‘53’ need to be pasted into the Word report titled Primary ‘53’. There are three different report types - Primary (190), Secondary (47) and FE (27) – each with a different range of charts.
Each Word report has a generic chart already present for each of the 20 odd charts required. You will need to delete that holding chart and replace it with the relevant chart from the appropriate worksheet.
You will need to do a trail run, producing a report for me to check before proceeding.
All completed reports need to be provided in Word to be checked. Once approved, the final reports must be provided in Word and pdf formats.
I provide an example of a datasheet, unprepared report and a completed report for you to see what you will be working with and the required standard. Please review these BEFORE submitting a proposal.
I don’t think there is a way of automating this job so it is likely that it has to be done manually. It is a fiddly job that needs patience to ensure that each chart is placed correctly and aligned to the corresponding box and sized properly. I estimate that it takes about 10 minutes to complete each report.
All the charts have been prepared on individual excel worksheets in a single workbook. The charts from the matching worksheet need to be pasted into the corresponding report e.g. charts from worksheet Primary ‘53’ need to be pasted into the Word report titled Primary ‘53’. There are three different report types - Primary (190), Secondary (47) and FE (27) – each with a different range of charts.
Each Word report has a generic chart already present for each of the 20 odd charts required. You will need to delete that holding chart and replace it with the relevant chart from the appropriate worksheet.
You will need to do a trail run, producing a report for me to check before proceeding.
All completed reports need to be provided in Word to be checked. Once approved, the final reports must be provided in Word and pdf formats.
I provide an example of a datasheet, unprepared report and a completed report for you to see what you will be working with and the required standard. Please review these BEFORE submitting a proposal.
Roland M.
100% (7)Projects Completed
18
Freelancers worked with
11
Projects awarded
86%
Last project
14 Nov 2023
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