Spreadsheet: 212609d1360174499-would-like-some-help-to-make-my-div-0-equal-0-holiday-tracker-201314
Sheet: BAKERY

Week Commencing Sunday |  |  |  |  | 31/03 | 07/04 | 14/04 | 21/04 | 28/04 | 05/05 | 12/05 | 19/05 | 26/05 | 02/06 | 09/06 | 16/06 | 23/06 | 30/06 | 07/07 | 14/07 | 21/07 | 28/07 | 04/08 | 11/08 | 18/08 | 25/08 | 01/09 | 08/09 | 15/09 | 22/09 | 29/09 | 06/10 | 13/10 | 20/10 | 27/10 | 03/11 | 10/11 | 17/11 | 24/11 | 01/12 | 08/12 | 15/12 | 22/12 | 29/12 | 05/01 | 12/01 | 19/01 | 26/01 | 02/02 | 09/02 | 16/02 | 23/02 | 02/03 | 09/03 | 16/03 | 23/03 | Total Holidays Booked | Holidays Remaining
Name |  | Contracted Hours | Holiday Entitlement (Days) |  | Period 2 |  |  |  | Period 3 |  |  |  | Period 4 |  |  |  |  | Period 5 |  |  |  | Period 6 |  |  |  | Period 7 |  |  |  |  | Period 8 |  |  |  | Period 9 |  |  |  | Period 10 |  |  |  |  | Period 11 |  |  |  | Period 12 |  |  |  | Period 1
 |  |  |  |  | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5
1 |  |  | 25 | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 25
 |  |  |  | Days
2 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
3 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
4 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
5 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
6 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
7 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
8 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
9 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
10 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
11 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
12 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
13 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
14 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
15 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
16 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
17 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
18 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
19 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
20 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
21 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
22 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
23 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
24 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
25 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
26 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
27 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
28 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
29 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
30 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
31 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
32 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
33 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
34 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
35 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
36 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
37 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
38 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
39 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
40 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
41 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
42 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
43 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
44 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
45 |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  | Days
Total Contract HoursPer Week |  |  | 25 | Total Hol Hours | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 | 25
0 |  |  |  | Total Hol Days | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Period Holiday Target (%) |  |  |  |  | 0.041 |  |  |  | 0.0469 |  |  |  | 0.108 |  |  |  |  | 0.1225 |  |  |  | 0.1229 |  |  |  | 0.1184 |  |  |  |  | 0.0987 |  |  |  | 0.0871 |  |  |  | 0.0471 |  |  |  |  | 0.0316 |  |  |  | 0.0873 |  |  |  | 0.0884 |  |  |  |  | 0.9999000000000001
Period Holiday Target (Hours) |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0
Period Holiday Target (Days) |  |  |  |  | 1.025 |  |  |  | 1.1725 |  |  |  | 2.7 |  |  |  |  | 3.0625 |  |  |  | 3.0725 |  |  |  | 2.96 |  |  |  |  | 2.4675 |  |  |  | 2.1775 |  |  |  | 1.1775 |  |  |  |  | 0.79 |  |  |  | 2.1825 |  |  |  | 2.21 |  |  |  |  | 24.9975
Period Holiday Actual (%) |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  |  | #N/A
 |  |  | Hours | 1-15 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 16-30 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 31-45 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | Total | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  | Days | 1-15 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 16-30 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | 31-45 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  | Total | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  | Green (low) |  | 0.038 |  |  |  | 0.04389999999999999 |  |  |  | 0.105 |  |  |  |  | 0.1195 |  |  |  | 0.1199 |  |  |  | 0.1154 |  |  |  |  | 0.0957 |  |  |  | 0.0841 |  |  |  | 0.0441 |  |  |  |  | 0.0286 |  |  |  | 0.0843 |  |  |  | 0.0854
 |  |  | Green (high) |  | 0.044 |  |  |  | 0.0499 |  |  |  | 0.1119 |  |  |  |  | 0.1255 |  |  |  | 0.1259 |  |  |  | 0.1214 |  |  |  |  | 0.1017 |  |  |  | 0.0901 |  |  |  | 0.05010000000000001 |  |  |  |  | 0.03460000000000001 |  |  |  | 0.0903 |  |  |  | 0.09140000000000001
 |  |  | Amber Bottom (low) |  | 0.035 |  |  |  | 0.0409 |  |  |  | 0.102 |  |  |  |  | 0.1165 |  |  |  | 0.1169 |  |  |  | 0.1124 |  |  |  |  | 0.09269999999999999 |  |  |  | 0.08109999999999999 |  |  |  | 0.0411 |  |  |  |  | 0.0256 |  |  |  | 0.0813 |  |  |  | 0.0824
 |  |  | Amber Bottom (high) |  | 0.0379 |  |  |  | 0.0438 |  |  |  | 0.1049 |  |  |  |  | 0.1194 |  |  |  | 0.1198 |  |  |  | 0.1153 |  |  |  |  | 0.09559999999999999 |  |  |  | 0.08399999999999999 |  |  |  | 0.044 |  |  |  |  | 0.0285 |  |  |  | 0.0842 |  |  |  | 0.0853
 |  |  | Amber Top (low) |  | 0.0441 |  |  |  | 0.05 |  |  |  | 0.1111 |  |  |  |  | 0.1256 |  |  |  | 0.126 |  |  |  | 0.1215 |  |  |  |  | 0.1018 |  |  |  | 0.0902 |  |  |  | 0.0502 |  |  |  |  | 0.0347 |  |  |  | 0.09040000000000001 |  |  |  | 0.09150000000000001
 |  |  | Amber Top (high) |  | 0.047 |  |  |  | 0.0529 |  |  |  | 0.114 |  |  |  |  | 0.1285 |  |  |  | 0.1289 |  |  |  | 0.1244 |  |  |  |  | 0.1047 |  |  |  | 0.0931 |  |  |  | 0.0531 |  |  |  |  | 0.0376 |  |  |  | 0.09330000000000001 |  |  |  | 0.09440000000000001