Spreadsheet: 273127d1382621841-rota-help-vlookup-book1_reply_2
Sheet: Sun-Nights

4 | Ambient |  |  |  |  |  | 5 | Chill |  |  |  |  |  | 4 | FRV |  |  |  |  |  | 5 | Load |  |  |  |  |  | Job Codes Key
16 | Name | [NAME] | Job | Shift | Hours |  | 15 | Name | [NAME] | Job | Shift | Hours |  | 16 | Name | [NAME] | Job | Shift | Hours |  | 15 | Name | [NAME] | Job | Shift | Hours |  | APick | [NAME]
1 | Name 1 |  |  | 18-06 | 10.5 |  | 2 | Name 2 |  |  | 18-06 | 10.5 |  | 8 | Name 8 |  |  | 18-02 | 7 |  | 3 | Name 3 |  |  | 18-06 | 10.5 |  | CPick | Chill Pick
5 | Name 5 |  |  | 18-06 | 10.5 |  | 6 | Name 6 |  |  | 18-06 | 10.5 |  | 12 | Name 12 |  |  | 18-06 | 10.5 |  | 7 | Name 7 |  |  | 18-06 | 10.5 |  | [NAME] | FRV Pick
9 | Name 9 |  |  | 18-06 | 10.5 |  | 10 | Name 10 |  |  | 18-06 | 10.5 |  | 16 | Name 16 |  |  | 18-06 | 10.5 |  | 11 | Name 11 |  |  | 18-06 | 10.5 |  | ARec | Amb Reciept
17 | Name 17 |  |  | 18-06 | 10.5 |  | 14 | Name 14 |  |  | 18-06 | 10.5 |  | 20 | Name 20 |  |  | 18-06 | 10.5 |  | 15 | Name 15 |  |  | 18-06 | 10.5 |  | CRec | Chill Reciept
 |  |  |  |  |  |  | 18 | Name 18 |  |  | 18-06 | 10.5 |  |  |  |  |  |  |  |  | 19 | Name 19 |  |  | 18-06 | 10.5 |  | FRec | FRV Reciept
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Load | Loading
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dekit | Dekit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marsh | Marshalling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol | Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Abs | Absent
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hygiene | Hygiene
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Train | Training
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Meet | Meeting
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Setup | Cage Setup
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Key | Key Partner
 | Agency |  |  |  |  |  |  | Agency |  |  |  |  |  |  | Agency |  |  |  |  |  |  | Ambient
 | Name | [NAME] | Job | Shift | Hours |  |  | Name | [NAME] | Job | Shift | Hours |  |  | Name | [NAME] | Job | Shift | Hours |  |  | Task | Plan | Act | Rate
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Volume
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Pick Hours |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Reciept Hours |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Chill
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Task | Plan | Act | Rate
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Volume
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Pick Hours |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Reciept Hours |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | FRV & Bread
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Task | Plan | Act | Rate
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Volume
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Pick Hours |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Reciept Hours |  | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Loading
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Task | Hours
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Load Hours | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | [NAME] | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | DU's Loaded | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Indirects Hours
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Task | Hours
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Dekit | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Marshalling | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Hygiene | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Training | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Meeting | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Setup | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Key Partners | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Overall Shift Performance
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Holidays | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Absence | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Total Hours | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Pick Hours | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | Total Picked | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | KPI Information
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | CPH | 0
 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0 |  |  | CPAH | 0