I need to calculate percentage sickness YTD and am unsure if I am doing it correctly.
This is my data and my current calculation method:
Is this correct or am I going in the complete wrong direction?
I would really appreciate a second pair of eyes.
Many thanks
Sara
This is my data and my current calculation method:
Weekly Campus Project Quicks issued 20220616.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Week | Contracted Hours | Sickness | Cumulative frequency | Percentage | ||
2 | 26/12/2021 | 0 | 0 | 0 | 0% | ||
3 | 02/01/2022 | 0 | 0 | 0 | 0% | ||
4 | 09/01/2022 | 0 | 0 | 0 | 0% | ||
5 | 16/01/2022 | 48 | 0 | 0 | 0% | ||
6 | 23/01/2022 | 48 | 0 | 0 | 0% | ||
7 | 30/01/2022 | 144 | 0 | 0 | 0% | ||
8 | 06/02/2022 | 192 | 0 | 0 | 0% | ||
9 | 13/02/2022 | 288 | 0 | 0 | 0% | ||
10 | 20/02/2022 | 355 | 0 | 0 | 0% | ||
11 | 27/02/2022 | 547 | 0 | 0 | 0% | ||
12 | 06/03/2022 | 499.2 | 0 | 0 | 0% | ||
13 | 13/03/2022 | 499.2 | 0 | 0 | 0% | ||
14 | 20/03/2022 | 499.2 | 38 | 38 | 5% | ||
15 | 27/03/2022 | 499.2 | 67 | 106 | 14% | ||
16 | 03/04/2022 | 547.2 | 48 | 154 | 21% | ||
17 | 10/04/2022 | 547.2 | 58 | 211 | 29% | ||
18 | 17/04/2022 | 547.2 | 67 | 278 | 38% | ||
19 | 24/04/2022 | 547.2 | 58 | 336 | 45% | ||
20 | 01/05/2022 | 595.2 | 0 | 336 | 45% | ||
21 | 08/05/2022 | 595.2 | 0 | 336 | 45% | ||
22 | 15/05/2022 | 595.2 | 0 | 336 | 45% | ||
23 | 22/05/2022 | 595.2 | 0 | 336 | 45% | ||
24 | 29/05/2022 | 739 | 0 | 336 | 45% | ||
25 | 05/06/2022 | 739.2 | 48 | 384 | 52% | ||
Sickness (2) |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2 | D2 | =C2 |
E2:E25 | E2 | =D2/$B$25 |
D3:D25 | D3 | =D2+C3 |
Is this correct or am I going in the complete wrong direction?
I would really appreciate a second pair of eyes.
Many thanks
Sara