Spreadsheet: 272664d1382456796-rota-help-vlookup-book1_reply
Sheet: Sun-Days

Ambient |  |  |  |  |  | Chill |  |  |  |  |  | FRV |  |  |  |  |  | Load |  |  |  |  |  | Job Codes Key
Name | [NAME] | Job | Shift | Hours |  | Name | [NAME] | Job | Shift | Hours |  | Name | [NAME] | Job | Shift | Hours |  | Name | [NAME] | Job | Shift | Hours |  | APick | [NAME]
Name 1 |  |  | 18-06 | 10.5 |  | Name 2 |  |  | 18-06 | 10.5 |  | Name 4 |  |  | 18-06 | 10.5 |  | Name 3 |  |  | 18-06 | 10.5 |  | CPick | Chill Pick
Name 5 |  |  | 18-06 | 10.5 |  | Name 6 |  |  | 18-06 | 10.5 |  | Name 8 |  |  | 18-02 | 7 |  | Name 7 |  |  | 18-06 | 10.5 |  | [NAME] | FRV Pick
Name 9 |  |  | 18-06 | 10.5 |  | Name 10 |  |  | 18-06 | 10.5 |  | Name 12 |  |  | 18-06 | 10.5 |  | Name 11 |  |  | 18-06 | 10.5 |  | ARec | Amb Reciept
Name 13 |  |  | 18-02 | 7 |  | Name 14 |  |  | 18-06 | 10.5 |  | Name 16 |  |  | 18-06 | 10.5 |  | Name 15 |  |  | 18-06 | 10.5 |  | CRec | Chill Reciept
Name 17 |  |  | 18-06 | 10.5 |  | Name 18 |  |  | 18-06 | 10.5 |  | Name 20 |  |  | 18-06 | 10.5 |  | Name 19 |  |  | 18-06 | 10.5 |  | FRec | FRV Reciept
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | Load | Loading
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | Dekit | Dekit
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | Marsh | Marshalling
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | Hol | Holiday
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | Abs | Absent
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | Hygiene | Hygiene
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | Train | Training
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | Meet | Meeting
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | Setup | Cage Setup
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | Key | Key Partner
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
 |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
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