Excel Macro for User Usage Statistics
Budget: £20 – £250 GBP
THE OBJECTIVE
The objective is to program an Excel Macro that takes the raw user usage stats from the Excel Spreadsheet output that the backend (Learnsworld) of our Academy (www.TeacherCPDAcademy.com) produces and makes an output Excel spreadsheet that we can create PDFs from to send to our clients.
RESOURCES
Two Spreadsheets are supplied as follows:
Spreadsheet 1 - Learnsworld output user usage
Spreadsheet 2 – Formatted desired output for our client
TASK
To create an excel macro with a small UI that is able to separately take the raw data output from Learnsworld ie Spreadsheet 1 and create and output with the same formatting, calculations and layout as Spreadsheet 2. The ultimate test is that the macro can take any output of form spreadsheet 1 and acurately transform it into a spreadsheet with the correct calculations and formating that can then be used to output a pdf of usage stats to our clients
OTHER REQUIREMENTS
1. There should be an input form that allows the user to enter the school name and the date of the report. This data should be added to the output spreadsheet and used to create the output filename as well.
2. The code should be able to cope with different number of courses/worksheets that are in the raw data
3. The code should be able to cope with different numbers of users
4. The code should be commented in a way that we can make basic changes to the code as we add new fields
The objective is to program an Excel Macro that takes the raw user usage stats from the Excel Spreadsheet output that the backend (Learnsworld) of our Academy (www.TeacherCPDAcademy.com) produces and makes an output Excel spreadsheet that we can create PDFs from to send to our clients.
RESOURCES
Two Spreadsheets are supplied as follows:
Spreadsheet 1 - Learnsworld output user usage
Spreadsheet 2 – Formatted desired output for our client
TASK
To create an excel macro with a small UI that is able to separately take the raw data output from Learnsworld ie Spreadsheet 1 and create and output with the same formatting, calculations and layout as Spreadsheet 2. The ultimate test is that the macro can take any output of form spreadsheet 1 and acurately transform it into a spreadsheet with the correct calculations and formating that can then be used to output a pdf of usage stats to our clients
OTHER REQUIREMENTS
1. There should be an input form that allows the user to enter the school name and the date of the report. This data should be added to the output spreadsheet and used to create the output filename as well.
2. The code should be able to cope with different number of courses/worksheets that are in the raw data
3. The code should be able to cope with different numbers of users
4. The code should be commented in a way that we can make basic changes to the code as we add new fields