Excel tool repairs
- or -
Post a project like this3212
£25(approx. $31)
- Posted:
- Proposals: 1
- Remote
- #805180
- Awarded
Description
Experience Level: Intermediate
Industry: Education
Description of excel work: There are issue with the column headers on all tabs, 'Starts & Leaver Analysis' and 'Agreed Break in Learning' tabs in the attached CMD tool.
Column headers in the Candidate Mailing Data spreadsheet (Row 2) are not being displayed on the data tabs in the CMD tool.
The data tabs in the CMD tool need to display the correct column headers from the candidate mailing date (hence row 1 being coloured grey).
Starts & Leaver Analysis:
This table should display, for the last 12 months (months along the bottom of the table, and number up the side):
- Number of starts per month: the number of records with a date in column M (bar to be colour blue)
- Number of leavers per month without achievement: number of records with a date in column BI, but no date in column O (bar to be colour Red)
- Number of leavers per month with achievement: : number of records with a date in column BI, and a date in column O (bar to be colour Green)
Agreed Break in Learning:
This tab should list all records with code 6 in column BM
Extra notes: I've attached a new CMD tool, which I've called version 4. It includes a bigger data set (candidate mailing data), to give you an idea of the size of data our customers are likely to analyse, but you can always slim it down for your purposes, although I'll be testing with it.
Description of excel work: There are issue with the column headers on all tabs, 'Starts & Leaver Analysis' and 'Agreed Break in Learning' tabs in the attached CMD tool.
Column headers in the Candidate Mailing Data spreadsheet (Row 2) are not being displayed on the data tabs in the CMD tool.
The data tabs in the CMD tool need to display the correct column headers from the candidate mailing date (hence row 1 being coloured grey).
Starts & Leaver Analysis:
This table should display, for the last 12 months (months along the bottom of the table, and number up the side):
- Number of starts per month: the number of records with a date in column M (bar to be colour blue)
- Number of leavers per month without achievement: number of records with a date in column BI, but no date in column O (bar to be colour Red)
- Number of leavers per month with achievement: : number of records with a date in column BI, and a date in column O (bar to be colour Green)
Agreed Break in Learning:
This tab should list all records with code 6 in column BM
Extra notes: I've attached a new CMD tool, which I've called version 4. It includes a bigger data set (candidate mailing data), to give you an idea of the size of data our customers are likely to analyse, but you can always slim it down for your purposes, although I'll be testing with it.
Peter L.
100% (15)Projects Completed
10
Freelancers worked with
4
Projects awarded
100%
Last project
18 Sep 2018
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