Spreadsheet: 76621d1277162699-staffing-grid-index-match-help-staff-rota
Sheet: Sheet1

 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 420 | 435 | 450 | 465 | 480 | 495 | 510 | 525 | 540 | 555 | 570 | 585 | 600 | 615 | 630 | 645 | 660 | 675 | 690 | 705 | 720 | 735 | 750 | 765 | 780 | 795 | 810 | 825 | 840 | 855 | 870 | 885 | 900 | 915 | 930 | 945 | 960 | 975 | 990 | 1005 | 1020 | 1035 | 1050 | 1065 | 1080 | 1095 | 1110 | 1125 | 1140 | 1155 | 1170 | 1185 | 1200 | 1215 | 1230 | 1245 | 1260 | 1275 | 1290 | 1305 | 1320 | 1335 | 1350 | 1365 | 1380 | 1395 | 1410 | 1425 | 0 | 15 | 30 | 45 | 60 | 75 | 90 | 105 | 120 | 135 | 150 | 165 | 180 | 195 | 210 | 225 | 240 | 255 | 270 | 285 | 300 | 315 | 330 | 345 | 360 | 375 | 390 | 405
Name | Help | Start | 1st Break | Return from Break | Lunch | Return from Lunch | 2nd Break | Return from 2 nd Break | Finish | 07:00:00 | 07:15:00 | 07:30:00 | 07:45:00 | 08:00:00 | 08:15:00 | 08:30:00 | 08:45:00 | 09:00:00 | 09:15:00 | 09:30:00 | 09:45:00 | 10:00:00 | 10:15:00 | 10:30:00 | 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 | 19:00:00 | 19:15:00 | 19:30:00 | 19:45:00 | 20:00:00 | 20:15:00 | 20:30:00 | 20:45:00 | 21:00:00 | 21:15:00 | 21:30:00 | 21:45:00 | 22:00:00 | 22:15:00 | 22:30:00 | 22:45:00 | 23:00:00 | 23:15:00 | 23:30:00 | 23:45:00 | 1900-01-01 00:00:00 | 00:15:00 | 00:30:00 | 00:45:00 | 01:00:00 | 01:15:00 | 01:30:00 | 01:45:00 | 02:00:00 | 02:15:00 | 02:30:00 | 02:45:00 | 03:00:00 | 03:15:00 | 03:30:00 | 03:45:00 | 04:00:00 | 04:15:00 | 04:30:00 | 04:45:00 | 05:00:00 | 05:15:00 | 05:30:00 | 05:45:00 | 06:00:00 | 06:15:00 | 06:30:00 | 06:45:00 |  | Total
Monday |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Person 1 | 1900-01-01 00:00:00 | 09:00:00 |  |  | 13:00:00 | 14:00:00 |  |  | 18:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8.75
Person 2 | 1900-01-01 00:00:00 | 08:00:00 | 09:00:00 | 09:15:00 | 13:00:00 | 14:00:00 | 15:45:00 | 16:00:00 | 17:00:00 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 7.5
Person 3 | 1900-01-01 00:00:00 | 10:00:00 |  |  | 11:30:00 | 12:00:00 |  |  | 16:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 5.75
Person 4 | 1900-01-01 00:00:00 | 05:00:00 | 07:00:00 | 07:30:00 | 11:00:00 | 12:00:00 |  |  | 14:00:00 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 8.25
Person 5 | 1900-01-01 00:00:00 | 22:00:00 |  |  |  |  |  |  | 06:45:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  | 6.75
Person 6 | 1900-01-01 00:00:00 | 22:00:00 | 1900-01-01 00:00:00 | 01:00:00 |  |  |  |  | 06:30:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 |  | 6.5
Person 7 | 1900-01-01 00:00:00 | 22:00:00 | 22:30:00 | 22:45:00 | 11:45:00 | 00:30:00 | 03:00:00 | 03:15:00 | 06:45:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Total |  |  |  |  |  |  |  |  |  | 0 | 0 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 1 |  | 43.5
 |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  | 2 |  |  |  | 2.75 |  |  |  | 4 |  |  |  | 3.5 |  |  |  | 4 |  |  |  | 2.75 |  |  |  | 3 |  |  |  | 2.75 |  |  |  | 2 |  |  |  | 1 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  |  | 3 |  |  |  | 2.25