Spreadsheet: 273127d1382621841-rota-help-vlookup-book1_reply_2
Sheet: Fri-Days

1 | Ambient |  |  |  |  |  | 0 | Chill |  |  |  |  |  | 1 | FRV |  |  |  |  |  | 0 | Load |  |  |  |  |  | Job Codes Key
19 | Name | [NAME] | Job | Shift | Hours |  | 20 | Name | [NAME] | Job | Shift | Hours |  | 19 | Name | [NAME] | Job | Shift | Hours |  | 20 | Name | [NAME] | Job | Shift | Hours |  | APick | [NAME]
13 | Name 13 |  |  | 06-18 | 10.5 |  |  |  |  |  |  |  |  | 4 | Name 4 |  |  | 10-18 | 7 |  |  |  |  |  |  |  |  | CPick | Chill Pick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FRV Pick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ARec | Amb Reciept
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CRec | Chill Reciept
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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