Spreadsheet: 822853d1679570739-formula-that-restricts-a-certain-value-in-an-adjacent-cells-based-on-the-value-written-test-on-formula-restriction
Sheet: 31-Oct Roster 

 |  | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THUR | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | NOTES | ADO |  |  | Weekend |  |  |  |  |  | WKND SHIFTS | NO. OF WKNDS | NO. OF ON | TOTAL NO. SHIFTS | TOTAL NO. AL | TOTAL NO. HRS | REQ'D HRS | TOTAL PM SHIFTS | TOTAL AM SHIFTS
Date | Section | 2022-10-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Sept | Oct
OVERNIGHT STAFF 1 | HS | 27 | 27 | 4 |  | AL | AL | AL |  | AL | AL | AL | AL |  | AL | 27 | 27 |  |  | 1 | 27 | 27 |  | 7ID/SUP | 27 | 27 | 27 |  | 7PRO | 27 | 27 |  |  | 1 | 27 | 27 |  | AL | AL | AL | AL |  | AL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240
HS1 | HS | OFF | 1 | 1 | 4 | 1 |  |  | 4 | 4 | OFF | 4 | 4 | 1ID/SUP | 7ID/SUP | OCT ADO | 4 | 7ID/SUP | 7ID/SUP | 7ID/SUP | OFF | OFF | ADO | 1 | 1 | 1 | 1 |  |  | 7ID/SUP | 7ID/SUP | 7ID/SUP | OFF | OFF | 7ID/SUP | 7ID/SUP | ADO | 1 | 4 | 27 | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240
HS2 | HS/TB | ADO | 4 | 4 | 4 | 4 |  |  | 4 | 4 | ADO | OFF | 4 | 4TB |  | 4 | 4 | 4 | 4 | 4 |  |  | 4 | 4 | OFF | 4 | 4 | 4TB |  | 4 | 4 | ADO | ADO | ADO |  |  | AL | AL | AL | AL | AL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240
HS3 | HS |  |  | 7ID/SUP | 7ID/SUP | 7ID/SUP | 27 |  |  | 1 | 1 | 4 | 1 |  |  | 4 | 4 | 4 | 4 |  |  |  |  |  | 7ID/SUP | 7ID/SUP |  | 7ID/SUP | 7ID/SUP |  | 1 | 1 | 1 | 1 |  |  |  | AL | AL | AL | AL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 192
HS4 | HS | 1 | 1 | 1 | 1 | 1 |  |  | 4 | ADO | 7ID/SUP | 7ID/SUP | 7ID/SUP |  |  | 1 | 1 | 1 | ADO | 1 | 1ID/SUP | 1ID/SUP | 4 | 4 | OFF | OFF | 4 |  |  | 4 | 4 | 4 | 4 | 4 |  |  | 7ID/SUP | 7ID/SUP | 27 | OFF | OFF | 7ID/SUP | 7ID/SUP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240
HS5 | HS | 4 | 4 | 4 | 4 | AL |  |  | 4 | 4 | 4 | 4 | 4 |  |  | 4 | 4 | 4 | 4 | OFF | 4TB |  | 4 | 4 | 4 | 4 | ADO | OFF | OFF | 4 | 4 | 4 | 4 | 4 |  |  | 4 | OFF | OFF | 4 | 4 | 1ID/SUP | 1ID/SUP |  |  |  |  |  |  |  |  |  |  |  | 1.5 |  |  |  |  | 240
HS6 | HS | 27 | 27 | OFF | OFF | 4 | 7ID/SUP | 7ID/SUP | ADO | 4 | 4 | 4 | 4 |  | 1ID/SUP | 4 | 4 | 4 | 1 | 1 |  |  | LSL | LSL | LSL | LSL | LSL |  |  | LSL | LSL | LSL | LSL | LSL |  |  | LSL | LSL | LSL | LSL | LSL |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.5 |  |  |  |  | 240
HS7 | HS | AL | AL | AL | AL | AL |  |  | AL | AL | AL | AL | AL |  |  | 4 | 4 | 4 | 4 | ADO | 1PL | 1PL | 1 | 1 | 1 | OFF | OFF |  |  | 7PRO | 7PRO | 7PRO | 7PRO | 7PRO |  |  | 1 | 1 | 27 |  |  | 1PL | 1PL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240
HS8 | HS |  | 1 | 1 | 1 | 4 |  |  | 4 | 1 | 4 | 27 |  |  |  | 4 |  | 4 |  |  | 7ID/SUP | 7ID/SUP |  | 4 | 4 | 4 | 4 |  |  | 4 |  |  | 7ID/SUP | 7ID/SUP | 4TB |  | 4 |  | 4 | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 192
HS9 | HS | 7PRO |  |  | 1 |  |  | 27 |  |  |  | 1 | 1 | 7ID/SUP |  |  | 1 | 1 | 7PRO |  |  |  | 1 | OFF |  |  |  | 4PL | 4PL | 1 | 1 |  | 7PRO |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 144
HS10 | HS | 7ID/SUP |  |  |  |  | 1ID/SUP | 1ID/SUP | 7ID/SUP | 7ID/SUP |  | 1 |  |  |  | 1 | 1 |  |  | 4 |  |  | 4 |  |  |  |  | 1ID/SUP | 1ID/SUP | 1 | 27 |  |  | 4 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 144
HS11 | HS |  | 7ID/SUP |  |  |  | 4TB | 4ID |  | 4 | 4 |  | 27 |  |  | 4 | 4 | 4 |  |  |  |  | 7ID/SUP | 7PRO |  |  | 7ID/SUP |  |  | 4 |  |  |  |  | 4PL | 4PL | 4 | 4 |  |  |  | 4TB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 144
HS12 | HS | LSL | LSL | LSL | LSL | LSL |  |  | LSL | LSL | LSL | LSL | LSL |  |  | AL | AL | AL | AL | AL |  |  | AL | AL | AL | AL | AL |  |  | 1 | 1 |  |  |  | 1ID/SUP | 1ID/SUP |  |  | 1 |  | 1 | 4ID | 4ID |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | 192
HS13 | HS | 1 | 1 | 1 | ADO | 1 |  |  | 4 | 1 | 27 | OFF | OFF | 1PL | 1PL | 7ID/SUP | 7ID/SUP | ADO | 7IN | 7IN |  |  | 1 | 1 | 1 | 1 | 1 |  |  | 1 | OFF | 1 | 1 | 1 | 4ID | 4ID | OFF | 1 | 7ID/SUP | 7ID/SUP | 7ID/SUP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240
DAY SHIFT |  |  |  |  |  |  | 9 | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 |  |  |  |  |  |  | 9 | 8
NIGHT SHIFT
SWING SHIFT
OVERNIGHT
Night shift allocation
SR
IN
PRO
ID