I need someone who can automate a large excel spreadsheet (An Excel Whiz)
- or -
Post a project like this3254
£100(approx. $125)
- Posted:
- Proposals: 13
- Remote
- #762525
- Awarded
Google Sheets Automation, Apps script, Excel VBA Expert, Qlikview, WordPress Hack Fix, Proofreading
Bangalore
296326208270422098486495516719613591665266852663918105936669938591
Description
Experience Level: Intermediate
General information for the business: Large spreadsheet needs automating. Needs to be a flexible spreadsheet.
Industry: Education
Description of excel work: Good Evening,
I have created a spreadsheet that I use to analyse my school examination data and use it to create a pdf for teachers.
I am currently carrying out all this work manually. I would like to automate the process as much as possible.
There are a number of things that will change each time I use the spreadsheet as obviously each exam is different and the numbers of students/classes sitting the exam varies.
The spreadsheet is created for use when the students are sitting 2 examinations however sometimes there is only 1 exam so I would very much like the spreadsheet to be usable if only one exam is sat also.
Please see excel spreadsheet attached
I would very much like to be able to simply drop on the "Working out" sheet data that is highlighted in blue (sourced elsewhere) and complete the "exam paper details" sheet and the spreadsheet does the rest.
As you can see from the example I would like the spreadsheet to have the capacity to show the data for 20 classes (only 6 in use/created at the moment) and up to 30 questions on each paper.
Once the data is generated I would then just highlight the pages I have used and print to pdf. I would like it if questions that were not used were not on the data as blank spaces (eg 20 question exam so the remaining 10 questions would not show on the document as blanks.)
I am more than happy to change the format if you believe we can achieve the same results but in a more effective manner.
I have attached the excel spreadsheet I have created and the pdf i turned it into. All the work has been done manually i have used very few formulas and some conditional formatting.
With regards the price I was unsure as to how much this kind of job should cost so I am happy to move on price should i need to.
I hope I have given you enough info to consider this work.
Anything else just drop me a message.
Thanks
Andrew
Extra notes:
Industry: Education
Description of excel work: Good Evening,
I have created a spreadsheet that I use to analyse my school examination data and use it to create a pdf for teachers.
I am currently carrying out all this work manually. I would like to automate the process as much as possible.
There are a number of things that will change each time I use the spreadsheet as obviously each exam is different and the numbers of students/classes sitting the exam varies.
The spreadsheet is created for use when the students are sitting 2 examinations however sometimes there is only 1 exam so I would very much like the spreadsheet to be usable if only one exam is sat also.
Please see excel spreadsheet attached
I would very much like to be able to simply drop on the "Working out" sheet data that is highlighted in blue (sourced elsewhere) and complete the "exam paper details" sheet and the spreadsheet does the rest.
As you can see from the example I would like the spreadsheet to have the capacity to show the data for 20 classes (only 6 in use/created at the moment) and up to 30 questions on each paper.
Once the data is generated I would then just highlight the pages I have used and print to pdf. I would like it if questions that were not used were not on the data as blank spaces (eg 20 question exam so the remaining 10 questions would not show on the document as blanks.)
I am more than happy to change the format if you believe we can achieve the same results but in a more effective manner.
I have attached the excel spreadsheet I have created and the pdf i turned it into. All the work has been done manually i have used very few formulas and some conditional formatting.
With regards the price I was unsure as to how much this kind of job should cost so I am happy to move on price should i need to.
I hope I have given you enough info to consider this work.
Anything else just drop me a message.
Thanks
Andrew
Extra notes:
Andrew D.
100% (15)Projects Completed
28
Freelancers worked with
26
Projects awarded
31%
Last project
12 Sep 2017
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