In my business I run engagement surveys and need to be able to take the data from engagement surveys and generate reports based on aggregated averaged data from the results of a group of people.
Currently I have an excel csv file which I extract from the engagement survey software program. I upload this data into a macro enabled excel file which is used to populate a macro enabled word document.
The current survey is constructed on the basis of demographic data (age, gender, length of service, professional category, industrial classification etc), 49 different work aspects which each have scores for importance and scores for satisfaction. The likert scale used is between 1-7 with an option for an NA answer (which has to be discounted). These 49 aspects are randomly arranged (grouped) into 7 clusters of statements. They then factor together into seven different motivational areas. Average scores are calculated for each of the seven motivational areas and an overall value provided for that average (high, mod or low).
The averaged results for these 49 aspects of work are also shown in a bar chart.
The third part of the survey has questions for 24 engagement measures and enablers. The measures are used to calculate a bar chart graph for engagement and also an overall average engagement number produced on the report.
I currently import this csv file into a complex calculations file which enables me to calculate averages of data and classifies values of data. I did have something developed for me a few years back using excel and word macro files. This could be used as a start and modified or otherwise if easier to start from the beginning. If this chart is being used some of the worksheets will need to be developed for the new version.
The current version of what has been created is enclosed. Password is because. There are three files - the calculations spreadsheet has the raw data and all of the calculations. See worksheet on first file for instructions on what is required. The group chart was constructed to be able to prepare charts and the word macro enabled document generates the report.
The work I need is as follows....
I have now changed the engagement survey, Instead of 49 work aspects there are now 36. Instead of seven clusters of 7 work aspects each there are now six clusters of six work aspects. I have updated the excel calculations file to re-calculate all of the required formula. What I do need however is someone to adjust this calculations spreadsheet and prepare:
1. Chart outputs - graphs and bar charts
2. Fields which allow me to populate information in the word document
3. Macro enabled word document
take these calculation outputs and prepare graphs, charts, data tables and then what is required to convert to reports. In other words I need a new report generated with new tables, graphs, charts and it needs to be linked to the calculations file.
What I need is for someone to be able to take this data and be able to write macros which can create reports which has demographic data, averaged data, data values and so on. I also need to be able to edit the report once produced.
Ideally I would also like this program to run on Apple Mac as well as a PC based system.
I prefer to be able to explain my new requirements via Skype, phone call so really need someone who has a good command of English language to do this work. I also want someone who is prepared to put some time in front to really understand my requirements and for me to make sure I am confident they can deliver on this work in desired time-frame.