Spreadsheet: 275249-vlookup-help-roster-query2-elb
Sheet: Friday

FRIDAY
 |  |  |  | Date | 2013-11-01 00:00:00 |  |  |  | CS 5/13
Staff | Name | Key | Rostered Shift | Overtime | Remarks - Reason For Overtime
Number
533497 | R Miller | CS1 | 0430-1430
530504 | M Limon | C | 0345-1145 | 1145-1215
u | Uncovered | P7 | 0445-1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
u | Uncovered | P1 | 0445-1145 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
741078 | A Dray | 1 | 0430-1230
826406 | A Hatch | F1 | 0445-1430 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 826406
885369 | R Price | 18 | 0845-1415 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 885369 | 885369
142354 | R Murray | P6 | 1300-1945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142354 | 142354
134948 | R Gillis | CP1 | 0930-1330
206953 | K Phelan | P4 | 1245-2015 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 206953
169566 | N Wilson | P3 | 1430-1945 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169566 | 169566
115862 | C Canhan | F2 | 1415-2215 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115862
528648 | M Keast | B | 1415-2215 | 1200-1415
226967 | D MacQueen | CS2 | 1215-2015
104159 | A [NAME] | AB | 0800-1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 104159
 |  | QC1 | 1000-1630
 |  | QC2 | 0445-1145
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 826406 | 154218 | u
Rostered Off |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 826406 | 154218 | u
 |  |  |  | O/T Avail ? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 826406 | 154218 | u
516643 | R Carr | A | OFF |  |  |  |  |  |  | 969
128557 | M Bindoraho | F3 | OFF |  |  |  |  |  |  | 967 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 128557
169565 | S Amadio | P2 | OFF |  |  |  |  |  |  | 971 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 169565 | 169565
154218 | L Rosier | P5 | OFF |  |  |  |  |  |  | 973 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 154218 | 154218
771140 | C Smith | 19 | OFF |  |  |  |  |  |  | 975 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 771140
u | Uncovered | 20 | OFF |  |  |  |  |  |  | 977 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u | u | u
812409 | S Barber | CP2 | OFF
Wooksheets Required
Week Commencing |  |  | 2013-11-01 00:00:00
812409 | S Barber |  | CP2
533497 | R Miller |  | CS1
226967 | D MacQueen |  | CS2
134948 | R Gillis |  | CP1
516643 | R Carr |  | A
528648 | M Keast |  | B
530504 | M Limon |  | C
741078 | A Dray |  | 1
826406 | A Hatch |  | F1
317947 | J [NAME] |  | L
539671 | A.Saunders |  | L
206953 | K Phelan |  | P4
115862 | C Canhan |  | F2
104159 | A [NAME] |  | AB
128557 | M Bindoraho |  | F3
771140 | C Smith |  | 19
885369 | R Price |  | 18
154218 | L Rosier |  | P5
142354 | R Murray |  | P6
169566 | N Wilson |  | P3
169565 | S Amadio |  | P2
318474 | P Thomson |  | SL
101770 | J [NAME] |  | -
 |  |  | -
u | Uncovered |  | P1
u | Uncovered |  | P7
u | Uncovered |  | 20
u | Uncovered |  | -
u | Uncovered |  | -
u | Uncovered |  | -