Spreadsheet: 772442d1647275682-not-sure-if-formula-or-code-required-drawing-data-across-sheets-with-cell-value-dependency-test-draft
Sheet: WK1

 |  |  | Hours
 | Staff
 |  |  |  |  |  |  |  |  |  |  |  |  | DAY 1 |  |  |  |  | DAY 2 |  |  |  |  | DAY 3 |  |  |  |  | DAY 4 |  |  |  |  | DAY 5
WEEK 1
 |  |  | MONDAY |  |  |  |  | TUESDAY |  |  |  |  | WEDNESDAY |  |  |  |  | THURSDAY |  |  |  |  | FRIDAY |  |  |  |  | SATURDAY |  |  |  |  | SUNDAY
 | Day |  | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total
POSITION | Night | TYPE | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours
FIELD 1 | D | WA |  |  |  |  |  |  |  |  |  |  | 2 | 10:00:00 | 19:00:00 |  |  | 2 | 07:00:00 | 19:00:00 |  |  | 2 | 07:00:00 | 19:00:00 |  |  | 2 | 07:00:00 | 19:00:00 |  |  | 2 | 07:00:00 | 19:00:00
GATE 1 | D | WA |  |  |  |  |  |  |  |  |  |  | 1 | 10:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00
FIELD 2 | D | WA |  |  |  |  |  |  |  |  |  |  | 1 | 12:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00
FIELD 3 | D | MA |  |  |  |  |  |  |  |  |  |  | 4 | 12:00:00 | 19:00:00 |  |  | 4 | 07:00:00 | 19:00:00 |  |  | 4 | 07:00:00 | 19:00:00 |  |  | 4 | 07:00:00 | 19:00:00 |  |  | 4 | 07:00:00 | 19:00:00
GATE 4 | D | MA |  |  |  |  |  |  |  |  |  |  | 1 | 09:59:00 | 23:59:00 |  |  | 1 | 09:59:00 | 23:59:00 |  |  | 1 | 09:59:00 | 23:59:00 |  |  | 1 | 09:59:00 | 23:59:00 |  |  | 1 | 09:59:00 | 23:59:00
PITCH 1 | D | WA |  |  |  |  |  |  |  |  |  |  | 1 | 10:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00
PITCH 2 | D | SL |  |  |  |  |  |  |  |  |  |  | 1 | 08:30:00 | 13:00:00 |  |  |  |  |  |  |  | 1 | 08:30:00 | 13:00:00
PITCH 5 | D | SL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 08:30:00 | 13:00:00
FIELD 2 | N | WA |  |  |  |  |  |  |  |  |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00
YARD 1 | N | SL |  |  |  |  |  |  |  |  |  |  | 2 | 19:00:00 | 07:00:00 |  |  | 2 | 19:00:00 | 07:00:00 |  |  | 2 | 19:00:00 | 07:00:00 |  |  | 2 | 19:00:00 | 07:00:00 |  |  | 2 | 19:00:00 | 07:00:00
YARD 2 | N | MA |  |  |  |  |  |  |  |  |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00
FIELD 6 | N | SL |  |  |  |  |  |  |  |  |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 19:00:00 | 07:00:00
YARD 3 | N | WA |  |  |  |  |  |  |  |  |  |  | 3 | 19:00:00 | 07:00:00 |  |  | 3 | 19:00:00 | 07:00:00 |  |  | 3 | 19:00:00 | 07:00:00 |  |  | 3 | 19:00:00 | 07:00:00 |  |  | 3 | 19:00:00 | 07:00:00
GATE 7 | N | SL |  |  |  |  |  |  |  |  |  |  | 2 | 16:00:00 | 04:00:00 |  |  | 2 | 16:00:00 | 04:00:00 |  |  | 2 | 16:00:00 | 04:00:00 |  |  | 2 | 16:00:00 | 04:00:00 |  |  | 2 | 16:00:00 | 04:00:00
YARD 5 | D | DG |  |  |  |  |  |  |  |  |  |  | 4 | 08:00:00 | 16:00:00 |  |  | 2 | 10:00:00 | 19:00:00
POSITION A | D | DG |  |  |  |  |  |  |  |  |  |  | 1 | 08:00:00 | 16:00:00 |  |  | 1 | 10:00:00 | 19:00:00
POSITION B | D | WA |  |  |  |  |  |  |  |  |  |  | 1 | 08:00:00 | 16:00:00 |  |  | 1 | 12:00:00 | 19:00:00 |  |  |  |  |  |  |  | 2 | 16:00:00 | 04:00:00
POSITION A | D | MA |  |  |  |  |  |  |  |  |  |  | 1 | 09:30:00 | 19:30:00 |  |  | 4 | 12:00:00 | 19:00:00 |  |  |  |  |  |  |  | 2 | 10:00:00 | 19:00:00
POSITION A | D | WA |  |  |  |  |  |  |  |  |  |  | 2 | 09:30:00 | 19:30:00 |  |  | 1 | 09:59:00 | 23:59:00 |  |  |  |  |  |  |  | 1 | 10:00:00 | 19:00:00 |  |  | 2 | 19:00:00 | 07:00:00
POSITION C | D | DG |  |  |  |  |  |  |  |  |  |  | 3 | 10:00:00 | 16:00:00 |  |  | 1 | 10:00:00 | 19:00:00 |  |  |  |  |  |  |  | 1 | 12:00:00 | 19:00:00 |  |  | 1 | 19:00:00 | 07:00:00
POSITION C | N | MA |  |  |  |  |  |  |  |  |  |  | 1 | 10:00:00 | 18:00:00 |  |  | 1 | 08:30:00 | 13:00:00 |  |  |  |  |  |  |  | 4 | 12:00:00 | 19:00:00 |  |  | 1 | 19:00:00 | 07:00:00
POSITION D | N | DG |  |  |  |  |  |  |  |  |  |  | 1 | 13:00:00 | 19:00:00 |  |  |  |  |  |  |  | 2 | 16:00:00 | 04:00:00 |  |  |  |  |  |  |  | 3 | 19:00:00 | 07:00:00
POSITION E | N | WA |  |  |  |  |  |  |  |  |  |  | 6 | 13:00:00 | 19:00:00 |  |  |  |  |  |  |  | 2 | 10:00:00 | 19:00:00 |  |  |  |  |  |  |  | 2 | 16:00:00 | 04:00:00
POSITION F | N | DG |  |  |  |  |  |  |  |  |  |  | 4 | 16:00:00 | 20:00:00 |  |  |  |  |  |  |  | 1 | 10:00:00 | 19:00:00 |  |  | 2 | 19:00:00 | 07:00:00
POSITION G | N | WA |  |  |  |  |  |  |  |  |  |  | 1 | 16:00:00 | 20:00:00 |  |  |  |  |  |  |  | 1 | 12:00:00 | 19:00:00 |  |  | 1 | 19:00:00 | 07:00:00
POSITION H | N | MA |  |  |  |  |  |  |  |  |  |  | 3 | 08:00:00 | 19:30:00 |  |  |  |  |  |  |  | 4 | 12:00:00 | 19:00:00 |  |  | 1 | 19:00:00 | 07:00:00
POSITION I | N | MA |  |  |  |  |  |  |  |  |  |  | 2 | 12:30:00 | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 19:00:00 | 07:00:00
POSITION I | D | WA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 16:00:00 | 04:00:00
TOTAL HOURS
TOTAL STAFF