Spreadsheet: 773673d1647989270-help-filling-a-table-from-another-table-meal-break-national-spreadsheet-v1-5-8
Sheet: Call Taker Night 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 name | HCP/SEND time | HCP/SEND | HCP/SEND |  |  | W |  | E |  | N |  | requirements from intra day report |  |  |  |  |  |  | W 999 | W HCP | E 999 | E HCP | N 999 | N HCP |  |  | [NAME] | quals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 999 | HCP | 999 | HCP | 999 | HCP | 999 | HCP | 999 total | HCP total |  |  |  |  |  |  |  |  |  |  |  | E | 999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:00:00 |  |  |  |  |  |  | 19 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | W | HCP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00 |  |  |  |  |  |  | 15 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00 |  |  |  |  |  |  | 51 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 |  |  |  |  |  |  | 13 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 |  |  |  |  |  |  | 11 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  |  | 11 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:00:00 |  |  |  |  |  |  | 9 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:00:00 |  |  |  |  |  |  | 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:00:00 |  |  |  |  |  |  | 9 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:00:00 |  |  |  |  |  |  | 7 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 05:00:00 |  |  |  |  |  |  | 9 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 06:00:00 |  |  |  |  |  |  | 9 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Break times |  |  |  | Site | 999/HCP | Hours worked
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CH name | start time hh:[NAME] | duration mins |  |  |  | CH name | start time | end time | hours worked | break allowed | break taken | Site E/W/N | 999/  HCP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 01:00:00 | 38 |  |  |  | [NAME] | 19:00:00 | 05:00:00 |  |  |  | W | 999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 01:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 02:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 03:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 04:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 05:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 05:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 05:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 05:45:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 06:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 06:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 06:30:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 06:45:00