Spreadsheet: 772241d1647103010-help-filling-a-table-from-another-table-call-taker-mealbreak-sheet-centralised-blank-matt_hooks_79-
Sheet: Call Taker Day Breaks

999 required | 999 available | 999 variance | 999 % variance | 999 [NAME] off | HCP req | HCP available | HCP Variance | HCP % variance | HCP Max off | Total req | Total avail | Total var | Total % variance | Total [NAME] off | 999 NUMBER OFF | HCP NUMBER OFF | Total off | Start Time | EAST |  |  |  |  | WEST |  |  |  |  | NORTH |  |  | HCP/SEND | HCP/SEND | HCP/SEND | HCP/SEND |  |  | West |  | East |  | North |  | requirements from intra day report |  |  |  |  |  | W 999 | W HCP | E 999 | E HCP | N 999 | N HCP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 999 | HCP | 999 | HCP | 999 | HCP | 999 | HCP | 999 total | HCP total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 | 10 |  | 8 | 4 | 4 | 3 | 19 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  |  |  |  |  |  | 19 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 |  |  |  |  |  |  | 17 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  | 7 | 3 |  |  | 17 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00 |  |  |  | 5 | 3 |  | 17 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | 9 |  |  |  | 2 |  | 15 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 | 8 |  |  |  |  |  | 15 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 |  |  | 6 | 3 | 1 |  | 13 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 |  |  |  |  |  | 2 | 11 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00 | 7 |  |  |  |  |  | 11 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00 | 4 |  |  |  |  |  | 9 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 |  |  |  |  |  |  | 9 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CH name | start time hh:[NAME] | duration mins | 999/  HCP |  | CH name | start time | end time | hours worked | break allowed | break taken
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:45:00