Spreadsheet: 866744d1713631398-formula-for-preparing-rotating-roster-rota
Sheet: Sheet1

 |  | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00 | 2024-01-12 00:00:00 | 2024-01-13 00:00:00 | 2024-01-14 00:00:00 | 2024-01-15 00:00:00 | 2024-01-16 00:00:00 | 2024-01-17 00:00:00 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00 | 2024-01-20 00:00:00 | 2024-01-21 00:00:00 | 2024-01-22 00:00:00 | 2024-01-23 00:00:00 | 2024-01-24 00:00:00 | 2024-01-25 00:00:00 | 2024-01-26 00:00:00 | 2024-01-27 00:00:00 | 2024-01-28 00:00:00 | 2024-01-29 00:00:00 | 2024-01-30 00:00:00 | 2024-01-31 00:00:00
Application | [NAME] | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed
Windows | [EMAIL] | 1 | 2 | 2 | 2 | 3 |  |  | 2 | 1 | 2 | 2 | 1 |  |  | 2 | 2 | 2 | 2 | 3 |  |  |  | 2 | 2 | 2 |  |  |  | 1 | 1 | 1
Mac | [EMAIL] | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 2 | 1 | 1 | 2 |  |  | 2 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | 1 | 1 |  |  |  | 3 | 2 | 3
Windows | [EMAIL] | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | 1 | 1 |  |  |  | 1 | 1 | 1 | 2 | 2 |  |  | 2 | 2 | 2 | 2 |  |  |  | 3 | 2 | 2
Both | [EMAIL] | 3 | 3 |  |  | 3 | 1 | 1 | 3 | 3 |  |  | 3 | 1 | 1 | 3 | 3 |  |  | 3 | 1 | 1 | 3 | 3 |  |  | 1 | 1 | 1 | 2 | 2 | 2
Windows | [EMAIL] | 2 | 2 | 2 | 3 | 3 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 1 | 1 |  |  | 1 | 1 | 1 | 3 |  |  |  | 2 | 3 | 3
Windows | [EMAIL] | 1 | 2 | 2 | 2 | 3 |  |  | 2 | 2 | 1 | 1 | 1 |  |  | 2 | 2 | 2 | 2 | 3 |  |  | 1 | 1 | 1 | 1 |  |  |  | 3 | 3
Windows | [EMAIL] | 2 | 2 | 2 | 3 | 3 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | 3 | 3 | 2 | 2 | 2 |  |  | 1 | 1 | 2 |  |  |  |  | 2 | 3 | 3
Windows | [EMAIL] | 2 | 2 | 1 | 2 | 2 |  |  | 3 | 3 | 3 | 3 | 2 |  |  | 2 | 1 | 1 | 2 | 1 |  |  | 3 | 2 | 2 | 1 |  |  |  | 3 | 2 | 3
Mac | [EMAIL] | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 1 | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 1 |  |  |  | 2 | 2 | 3
Mac | [EMAIL] | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 1 | 1 | 1 | 2 |  |  | 2 | 2 | 1 | 1 |  |  |  | 3 | 3 | 3
Mac | [EMAIL] | 2 | 2 | 1 | 2 | 2 |  |  |  | 3 | 3 | 3 | 3 |  |  | 3 | 2 | 2 | 3 | 3 |  |  | 3 | 3 | 2 | 2 | 1 |  |  | 2 | 2 | 2
Mac | [EMAIL] | 1 | 2 | 1 | 3 | 3 |  |  | 2 | 1 | 1 | 1 |  |  |  | 1 | 2 | 2 | 2 | 3 |  |  | 3 | 3 | 3 | 3 | 2 |  |  | 2 |  | 2
Windows | [EMAIL] | 2 | 2 | 1 | 3 | 2 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 1 | 2 | 1 | 1 |  |  | 2 | 2 | 1 | 1 |  |  |  | 3 | 3 | 3
Mac | [EMAIL] | 2 | 2 | 1 | 3 | 2 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 1 | 2 | 1 | 2 |  |  | 2 | 2 | 1 | 2 |  |  |  | 3 | 3 | 3
Windows | [EMAIL] | 3 | 3 | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | 3 | 3 | 3 | 1 | 2 |  |  | 1 | 1 | 1 | 2 |  |  |  | 2 | 2 | 3
Mac | [EMAIL] | 3 | 3 | 2 | 2 | 2 |  |  | 2 | 2 | 3 | 3 | 2 |  |  | 2 | 2 | 2 | 1 | 1 |  |  | 2 | 2 | 2 | 2 |  |  |  | 2 | 3 | 3
Windows | [EMAIL] | 2 | 2 | 2 | 1 | 2 |  |  | 3 | 3 | 2 | 2 | 2 |  |  | 2 | 1 | 1 | 2 | 2 |  |  | 1 | 1 | 3 | 3 |  |  |  | 3 | 2 | 2
Both | [EMAIL] | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 2 |  |  | 2 | 2 | 2 |  |  | 1 | 1 | 1 | 2 |  |  | 1 | 1 |  |  | 2 | 2 | 2 | 3 | 3
Both | [EMAIL] | 1 | 1 | 2 | 2 | 3 | 3 | 3 |  |  | 1 | 1 | 1 | 3 | 3 |  |  | 2 | 2 | 3 | 3 | 3 |  | 2 | 2 | 2 | 2 | 3 | 3 |  |  | 2
Both | [EMAIL] | 1 | 1 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 3 |  |  | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2
Mac | [EMAIL] | 2 | 2 | 2 | 1 | 1 |  |  | 1 | 2 | 2 | 2 | 1 |  |  | 2 | 2 | 2 | 2 | 1 |  |  | 2 | 1 | 3 | 3 |  |  |  |  | 3 | 3
Mac | [EMAIL] | 1 | 1 | 2 | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 1 | 3 | 1 | 2 |  |  | 2 | 2 | 3 | 3 |  |  |  | 1 | 3 | 3
Mac | [EMAIL] | 2 | 2 | 2 | 2 | 2 |  |  | 2 | 2 | 3 | 3 | 2 |  |  | 1 | 1 | 1 | 2 | 2 |  |  | 2 | 3 | 1 | 2 |  |  |  | 3 | 3 | 3
Windows | [EMAIL] | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | 2 | 3 | 1 |  |  | 1 | 1 | 2 | 1 | 2 |  |  | 2 | 2 | 3 |  |  |  |  | 1 | 2
Mac | [EMAIL] | 2 | 2 | 2 | 2 | 2 |  |  | 1 | 1 | 2 | 2 | 1 |  |  | 1 | 2 | 1 | 2 | 1 |  |  | 1 | 1 | 1 | 2 |  |  |  | 2 | 3 | 3