Hi, my name is Melina
I hope this mail finds you well.
Please may I ask your help and advise.
I have a spreadsheet that contains many different projects. From the data that is captured in the spreadsheet, I need to create a report, dashboard or graph that shows the KPI's for this data.
The things that need to be measured are:
1. The turnaround time from start to finish.
2. The amount of days it takes from start to CRB, (basically calculate the overdue
days).
3. How many records have been created per project.
4. The status of each record.
I hope this makes sense.
Herewith is a link to a sample of the data.
http://www.2shared.com/file/zsRa-rkF/SAMPLE_WORKBOOK.html
Thank you for your help, it is greatly appreciated.
Melina
I hope this mail finds you well.
Please may I ask your help and advise.
I have a spreadsheet that contains many different projects. From the data that is captured in the spreadsheet, I need to create a report, dashboard or graph that shows the KPI's for this data.
The things that need to be measured are:
1. The turnaround time from start to finish.
2. The amount of days it takes from start to CRB, (basically calculate the overdue
days).
3. How many records have been created per project.
4. The status of each record.
I hope this makes sense.
Herewith is a link to a sample of the data.
http://www.2shared.com/file/zsRa-rkF/SAMPLE_WORKBOOK.html
Thank you for your help, it is greatly appreciated.
Melina