Spreadsheet: 812427d1673137618-roster-calculations-trying-to-count-number-of-weeks-worked-calendar-hd
Sheet: 2023

 |  |  |  |  | Non-teaching | Public holiday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public holidays |  | Non-teaching period | Non-teaching start | Non-teaching end
 |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  |  | New Years Day | 2023-01-01 00:00:00 | 1 | 2023-04-11 00:00:00 | 2023-04-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Years Day | 2023-01-02 00:00:00 | 2 | 2023-06-26 00:00:00 | 2023-07-08 00:00:00
Class | Room | Class start | Class finish | Duration | 2023-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Australia day | 2023-01-26 00:00:00 | 3 | 2023-09-18 00:00:00 | 2023-09-30 00:00:00
Class 1 | 1.8b | 09:30:00 | 13:45:00 |  |  |  | Teacher 1 | Teacher 1 | Teacher 1 |  | Teacher 3 | Teacher 3 | Teacher 1 | Teacher 1 | Teacher 1 |  | Teacher 2 | Teacher 2 | Teacher 2 | Teacher 1 | Teacher 1 |  | Teacher 2 | Teacher 2 | Teacher 2 |  | Teacher 1 |  | Teacher 2 | Teacher 2 | Teacher 2 | Teacher 1 | Teacher 1 |  |  | Labour day | 2023-03-13 00:00:00 | 4 | 2023-12-25 00:00:00
Class 2 | 1.8a | 09:30:00 | 13:45:00 |  |  |  | Teacher 4 | Teacher 4 | Teacher 4 |  | Teacher 1 | Teacher 1 | Teacher 4 | Teacher 4 | Teacher 4 |  | Teacher 1 | Teacher 1 | Teacher 1 | Teacher 2 | Teacher 2 |  | Teacher 1 | Teacher 1 | Teacher 1 |  | Teacher 2 |  | Teacher 1 | Teacher 1 | Teacher 1 | Teacher 2 | Teacher 2 |  |  | Good Friday | 2023-04-07 00:00:00
Class 3 | G100 | 09:30:00 | 13:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Easter Saturday | 2023-04-08 00:00:00
Class 4 | 1.8a | 17:30:00 | 20:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  |  | Easter Sunday | 2023-04-09 00:00:00
Class 5 | 1.8a | 09:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  | Easter Monday | 2023-04-10 00:00:00
Class 6 | 1.8a | 17:30:00 | 20:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Anzac Day | 2023-04-25 00:00:00
Class 7 | 1.8a | 09:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | King's Birthday | 2023-06-12 00:00:00
Class 8 | 1.8a | 17:30:00 | 20:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Melb Cup | 2023-11-07 00:00:00
Class 9 | 1.8a | 09:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2023-12-25 00:00:00
 |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  |  | Boxing Day | 2023-12-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Final | 2023-09-22 00:00:00
Class | Room | Class start | Class finish | Duration
 |  |  |  |  | Teacher 2 | Teacher 2 | Teacher 2 | Teacher 1 | Teacher 1 |  | Teacher 2 | Teacher 2 | Teacher 2 | Teacher 1 | Teacher 1 |  | Teacher 3 | Teacher 3 | Teacher 3 | Teacher 2 | Teacher 2 |  | Teacher 3 | Teacher 3 | Teacher 3 | Teacher 2 | Teacher 2 |  | Teacher 3 | Teacher 3 | Teacher 3 | Teacher 2 | Teacher 2
 |  |  |  |  | Teacher 1 | Teacher 1 | Teacher 1 | Teacher 2 | Teacher 2 |  | Teacher 1 | Teacher 1 | Teacher 1 | Teacher 2 | Teacher 2 |  | Teacher 2 | Teacher 2 | Teacher 2 | Teacher 4 | Teacher 4 |  | Teacher 2 | Teacher 2 | Teacher 2 | Teacher 4 | Teacher 4 |  | Teacher 2 | Teacher 2 | Teacher 2 | Teacher 4 | Teacher 4
 |  |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5
 |  |  |  |  |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher 5 |  | Teacher 5
 |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week
Class | Room | Class start | Class finish | Duration
 |  |  |  |  |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3
 |  |  |  |  |  |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5
 |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week
Class |  | Class start | Class finish | Duration
 |  |  |  |  |  |  |  |  |  | Teacher 4 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3
 |  |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5
 |  |  |  |  |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 4 |  |  |  |  |  | Teacher 4 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3
 |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week
Class | Room | Class start | Class finish | Duration
 |  |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  |  |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5
 |  |  |  |  |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3
 |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week
Class | Room | Class start | Class finish | Duration
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher 6 |  |  |  |  |  |  |  |  |  |  |  | Teacher 6
 |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week
Class | Room | Class start | Class finish | Duration
 |  |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5 |  |  |  | Teacher 5 |  | Teacher 5
 |  |  |  |  |  |  |  |  |  | Teacher 6 |  |  |  |  |  | Teacher 6 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3
 |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week
Class | Room | Class start | Class finish | Duration
 |  |  |  |  | Teacher 5 |  | Teacher 3
 |  |  |  |  |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teacher 3
 |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week
Class | Room | Class start | Class finish | Duration
 |  |  |  |  |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3 |  |  |  |  |  | Teacher 3
 |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week
Class | Room | Class start | Class finish | Duration
 |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week |  |  |  |  |  | Week
Class | Room | Class start | Class finish | Duration