Spreadsheet: 773673d1647989270-help-filling-a-table-from-another-table-meal-break-national-spreadsheet-v1-5-8
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 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 999 | HCP | 999 | HCP | 999 | HCP | 999 | HCP | 999 total | HCP total |  |  |  |  |  |  |  |  |  |  |  | E | 999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:00:00 |  |  |  |  |  |  | 11 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | W | HCP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  |  |  |  |  |  | 11 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 |  |  |  |  |  |  | 15 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  |  |  |  |  | 15 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:00:00 |  |  |  |  |  |  | 15 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 |  |  |  |  |  |  | 17 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:00:00 |  |  |  |  |  |  | 15 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 |  |  |  |  |  |  | 15 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 |  |  |  |  |  |  | 15 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00:00 |  |  |  |  |  |  | 15 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:00:00 |  |  |  |  |  |  | 15 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:00:00 |  |  |  |  |  |  | 17 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:15:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Break times |  |  |  | Site | 999/HCP | Hours worked
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10: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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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