Please insert your answers to the questions below at the top of your application. Thank you!
This tool will collect performance information of the ca100 top leaders of a big organization and summarize the numbers into graphs.
An excel sheet will be copied and sent out by email to about 100 leaders. Each of them will fill in their copy of the excel form and send it back to the Admin. The Admin will then let all the necessary data to be assembled into a database and generate different graphs for a report.
Your job is to create an easy way for the Admin to collect all the excel sheets into a database and then to be able to easily create graphs by selecting different queries.
The solution will be made solely in excel and VBA. It needs to be able to be run both on a PC and Mac, and with different versions of excel.
How I choose contractor
Firstly I look on your grade and reviews. Then I look on how you have answered my three questions (se below). If I like what I read I will contact you over Skype on Monday the 17th of December to see how the communication goes and then hire someone that can start fast.
More tasks in the future
You will probably get more tasks when this one is done.
When you apply for this job, I need to know the following:
1) How much time will you need?
In your application I need a flat time specification. This means that I will pay you for a certain amount of hours, no matter if it takes more or less time for you to finish it. You will need to do a good estimation on your time needed already in this application. Carefully read the whole specification attached to the job posting.
2) What solution will you use?
How will the data from the ca hundred excel sheets be collected into the database? How will the information from the database be picked out by Admin in order to make different graphs? Can the graph be automatically repainted when the list is changed or will you need a “refresh”-button?
3) What deadline will you need?
Are you able to start the 17th of December? When can you be finished?
Please read the whole attached specification document in order to be able to answer the questions!