Spreadsheet: 781445d1653328656-need-an-adjustment-to-existing-formula-for-new-position-codes-sample-file
Sheet: SHIFT INFO

BID # | DAYS OFF | HOURS | DEPT | PAY RULE | RATE | SORT CODE | ACCRUALS | CLOCK | BID # | JOB | CODE | VAC | POSITION CHANGE CODE |  |  |  | Differentials received
100 | S/S | 9A-5P - (30 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 | 4000 | LIFT | G | B |  |  | C61C | 25.77
101 | S/S | 9A-5P - (30 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 | 4001 | LOAD | G | B |  |  | C61CJ | 24.7
102 | S/S | 9A-5P - (30 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 | 4005 | DMG/RCP | G | B |  |  | C61Q | 25.97 | Nite
103 | W/TH/S | 9A-7P - (32 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4013 | GW | G | 7 |  |  | C61QJ | 24.9 | Nite
104 | M/T/S | 9A-7P - (34 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4010 | GW | G | 5 |  |  | C65D | 25.87 |  | Cooler
105 | TH/F/S | 9A-7P - (35 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4009 | GW | G | 3 |  |  | C65DJ | 24.8 |  | Cooler
106 | T/W/S | 9A-7P - (31 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4011 | GW | G | 6 |  |  | C65F | 25.87 |  | Cooler
107 | S/TH/S | 9A-7P - (33 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4002 | LOAD | G | R |  |  | C65FJ | 24.8 |  | Cooler
108 | S/M/S | 9A-7P - (39 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4006 | TRAINER | G | S |  |  | C65L | 26.07 | Nite | Cooler
109 | S/T/S | 9A-7P - (40 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4007 | GW | G | T |  |  | C65LJ | 25 | Nite | Cooler
110 | S/T/W | 9A-7P - (41 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4008 | GW | G | U |  |  | C65LK | 19
111 | T/F/S | 9A-7P - (42 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4012 | GW | G | M |  |  | C65S | 26.07 | Nite | Cooler
112 | S/TH/S | 9A-7P - (33 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4000.5 | LIFT | G | R |  |  | [NAME] | 25 | Nite | Cooler
113 | F/S | 9A-5P - (43 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 | 4014 | GW | G | F |  |  | C67G | 26.07 | Nite | Cooler
114 | T/H/S | 9A-7P - (44 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4015 | GW | G | A |  |  | C67GJ | 25 | Nite | Cooler
115 | S/M | 9A-5P - (45 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 | 4016 | GW | G | 2
116 | T/W/TH | 9A-7P (46 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 4017 | GW | G | G
117 | S/S | 9A-5P - (30 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 | 4006.5 | BAILER | G | B
118 | T/S | 9A-5P - (47 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 | 4018 | GW | G | C
119 | H/S | 9A-5P - (48 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 | 4019 | GW | G | 9
120 | S/S | 9A-5P - (30 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 | 4020 | GW | G | B
121 | S/S | 9A-5P - (30 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 | 4005.5 | TRAINER | G | B
140 | S/S | 9A-5P - (30 GROC) | C61CJ | DAY WHSE |  | C61C | 8 | 8 OR 9 | 4004 | JAN | G | B
150 | S/S | 10P-6A - (36 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 | 5000 | REC | G | 0
151 | S/S | 10P-6A - (36 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 | 5006 | GW | G | 0
152 | S/S | 11A-7P - (37 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 | 4003 | LOAD | G | 8 |  | 20216086
153 | S/S | 11P-7A - (38 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 | 5004 | BAILER | G | 1
154 | S/S | 11P-7A - (38 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 | 5005 | LOAD | G | 1
155 | S/S | 11P-7A - (38 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 | 5001 | REC | G | 1
156 | S/S | 11P-7A - (38 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 | 5002 | LIFT | G | 1
157 | S/S | 11P-7A - (38 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 | 5007 | GW | G | 1
158 | S/S | 10P-6A - (36 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 | 5001.5 | LIFT | G | 0
159 | S/S | 11A-7P - (37 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 | 4021 | GW | G | 8 |  | 20216086
160 | F/S | 11A-7P - (49 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 | 4022 | GW | G | H |  | 20216086
190 | S/S | 11P-7A - (38 GROC) | C61QJ | warehouse |  | C61C | 8 | 8 OR 9 | 5003 | JAN | G | 1
200 | S/S | 7A-3P - (00 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 | 6001 | LOAD | D | B
201 | S/S | 7A-3P - (00 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 | 6003 | DMG/RCP | D | B
202 | S/S | 7A-3P - (00 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 | 6000 | LIFT | D | B
203 | S/W/S | 7A-5P (02 DAIRY) | C65D | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 6000.5 | LIFT | D | Q
204 | S/TH/S | 7A-5P (07 DAIRY) | C65D | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 6001.5 | LOAD | D | R
205 | TH/F/S | 7A-5P (01 DAIRY) | C65D | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 6005 | GW | D | 3
206 | S/W/TH | 7A-5P (05 DAIRY) | C65D | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 6006 | GW | D | P
207 | S/S | 7A-3P (00 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 | 6004 | TRAINER | D | B
208 | W/F/S | 7A-5P (04 DAIRY) | C65D | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 6007 | GW | D | K
209 | M/T/S | 7A-5P (06 DAIRY) | C65D | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 6008 | GW | D | 5
210 | S/W/S | 7A-5P (02 DAIRY) | C65D | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 | 6003.5 | TRAINER | D | Q
211 | F/S | 7A-3P (08 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 | 6009 | GW | D | F
212 | T/W | 7A-3P (09 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 | 6011 | GW | D | S
213 | M/T | 7A-3P (10 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 | 6010 | GW | D | T
240 | S/S | 7A-3P - (00 DAIRY) | C65DJ | DAY WHSE |  | C61C | 8 | 8 OR 9 | 6002 | JAN | D | B
250 | S/S | 11P-7A - (03 DAIRY) | C65S | warehouse |  | C61C | 8 | 8 OR 9 | 7000 | REC | D | 1
251 | S/S | 11P-7A - (03 DAIRY) | C65S | warehouse |  | C61C | 8 | 8 OR 9 | 7002 | GW | D | 1
252 | S/S | 11P-7A - (03 DAIRY) | C65S | warehouse |  | C61C | 8 | 8 OR 9 | 7001 | LIFT | D | 1
253 | S/M | 7A-3P - (11 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 | 6012 | GW | D | 2
300 | S/W/TH | 8A-6P - (60 PERISH) | C65F | DAY WHSE 10 |  | C65L | 10 | 1 OR 6 | 1000 | GW | P | P
301 | S/S | 10A-6P - (62 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2008 | LOAD | P | B
302 | S/S | 10A-6P - (62 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2000 | DMG/RCP | P | B
303 | S/S | 10A-6P - (62 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2005 | LIFT | P | B
304 | S/S | 10A-6P - (62 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2006 | FR LIFT | P | B
305 | TH/F/S | 10A-8P - (63 PERISH) | C65L | [NAME] 10 |  | C65L | 10 | 1 OR 6 | 2010 | GW | P | 3
306 | M/T/S | 10A-8P - (64 PERISH) | C65L | [NAME] 10 |  | C65L | 10 | 1 OR 6 | 2011 | GW | P | 5
307 | T/W/S | 10A-8P - (65 PERISH) | C65L | [NAME] 10 |  | C65L | 10 | 1 OR 6 | 2012 | GW | P | 6
308 | W/TH/S | 10A-8P - (66 PERISH) | C65L | [NAME] 10 |  | C65L | 10 | 1 OR 6 | 2013 | GW | P | 7
309 | S/S | 12P-8P - (67 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2009 | LOAD | P | V
310 | S/S | 10A-6P - (62 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2001 | FR DMG/RCP | P | B
311 | S/S | 10A-6P (62 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2007 | TRAINER | P | B
312 | W/F/S | 10A-8P (70 PERISH) | C65L | [NAME] 10 |  | C65L | 10 | 1 OR 6 | 2014 | GW | P | K
313 | S/W/S | 10A-8P (61 PERISH) | C65L | [NAME] 10 |  | C65L | 10 | 1 OR 6 | 2004 | LIFT | P | Q
314 | F/S | 10A-6P - (71 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2015 | GW | P | F
316 | S/M | 10A-6P - (73 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2017 | GW | P | 2
317 | H/S | 10A-6P - (74 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2018 | GW | P | 9
318 | S/S | 10A-6P (62 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2019 | GW | P | B
319 | W/S | 10A-6P (75 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2020 | GW | P | D
320 | S/S | 3P-11P (76 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2009.25 | LOAD | P | U
321 | S/S | 3P-11P (76 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2009.5 | LIFT | P | U
322 | S/W/S | 10A-8P (61 PERISH) | C65L | [NAME] 10 |  | C65L | 10 | 1 OR 6 | 2006.5 | FR LIFT | P | Q
323 | T/W | 10A-6P (77 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 | 2021 | GW | P | S
324 | T/W/TH | 10A-8P (78 PERISH) | C65L | [NAME] 10 |  | C65L | 10 | 1 OR 6 | 2022 | GW | P | G
340 | S/S | 10A-6P - (62 PERISH) | C65LJ | warehouse |  | C65L | 8 | 1 OR 6 | 2003 | JAN | P | B
341 | S/S | 10A-6P - (62 PERISH) | C65LJ | warehouse |  | C65L | 8 | 1 OR 6 | 2002 | FR JAN | P | B
350 | S/S | 10P-6A - (68 PERISH) | C67G | warehouse |  | C65L | 8 | 1 OR 6 | 3001 | GW | P | 0
351 | S/S | 10P-6A - (68 PERISH) | C67G | warehouse |  | C65L | 8 | 1 OR 6 | 3000 | REC | P | 0
352 | S/S | 11P-7A - (69 PERISH) | C67G | warehouse |  | C65L | 8 | 1 OR 6 | 3007 | DMG/RCP | P | 1
353 | S/S | 11P-7A - (69 PERISH) | C67G | warehouse |  | C65L | 8 | 1 OR 6 | 3003 | LIFT | P | 1
354 | S/S | 11P-7A - (69 PERISH) | C67G | warehouse |  | C65L | 8 | 1 OR 6 | 3004 | FR LIFT | P | 1
355 | S/S | 11P-7A - (69 PERISH) | C67G | warehouse |  | C65L | 8 | 1 OR 6 | 3008 | GW | P | 1
356 | S/S | 11P-7A - (69 PERISH) | C67G | warehouse |  | C65L | 8 | 1 OR 6 | 3002 | REC | P | 1
390 | S/S | 11P-7A - (69 PERISH) | C67GJ | warehouse |  | C65L | 8 | 1 OR 6 | 3005 | FR JAN | P | 1
391 | S/S | 11P-7A - (69 PERISH) | C67GJ | warehouse |  | C65L | 8 | 1 OR 6 | 3006 | JAN | P | 1
998 | 1 | 1 | C65LK | 1 |  | C65L | 1 | 1 OR 6 | 1 | CAS | 1 | 999 | 1 | FOR CASUALS ONLY - PUT IN NEW BID #
999 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 999 | 1 | FOR NEW HIRES ONLY - PUT IN OLD BID #
↓UNUSED AT THIS TIME↓
103 | S/S | 9A-5P - (30 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 |  | TRAINER | G | D
109 | S/M/T | 9A-7P (39 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 |  | GW | G | 9
111 | F/S | 9A-5P (41 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 |  | GW | G | F
113 | S/S | 9A-5P - (30 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 |  | GW | G | D
115 | T/TH/S | 9A-7P - (33 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 |  | GW | G | A
116 | T/S | 9A-5P - (42 GROC) | C61C | DAY WHSE |  | C61C | 8 | 8 OR 9 |  | GW | G | C
117 | W/F/S | 9A-7P - (43 GROC) | C61C | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 |  | GW | G | K
154 | S/S | 11A-7P - (37 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 |  | DMG/RCP | G | 8
161 | S/S | 10P-6A - (36 GROC) | C61Q | warehouse |  | C61C | 8 | 8 OR 9 |  | LIFT | G | 0
175 | S/S | 11A-7P - (37 GROC) | C61QJ | warehouse |  | C61C | 8 | 8 OR 9 |  | JAN | G | 8
202 | S/S | 7A-3P - (00 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 |  | TRAINER | D | 4
204 | W/S | 7A-3P - (08 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 |  | GW | D | O
209 | S/S | 9A-5P - (02 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 |  | LIFT | D | D
210 | S/S | 9A-5P - (02 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 |  | LOAD | D | D
211 | F/S | 7A-3P - (04 DAIRY) | C65D | DAY WHSE |  | C61C | 8 | 8 OR 9 |  | GW | D | F
213 | T/W/TH | 7A-5P (06 DAIRY) | C65D | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 |  | GW | D | G
214 | M/F/S | 7A-5P (07 DAIRY) | C65D | DAY WHSE 10 |  | C61C | 10 | 8 OR 9 |  | GW | D | H
302 | S/S | 10A-6P - (62 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 |  | TRAINER | P | B
314 | S/M | 7A-3P - (70 PERISH) | C65F | DAY WHSE |  | C65L | 8 | 1 OR 6 |  | GW | P | 2
316 | M/T/W | 7A-5P - (72 PERISH) | C65F | DAY WHSE 10 |  | C65L | 10 | 1 OR 6 |  | GW | P | L
315 | M/W/S | 10A-8P - (72 PERISH) | C65L | [NAME] 10 |  | C65L | 10 | 1 OR 6 | 2016 | GW | P
318 | M/F/S | 10A-8P - (73 PERISH) | C65L | [NAME] 10 |  | C65L | 10 | 1 OR 6 |  | GW | P | H
319 | T/F/S | 10A-8P - (74 PERISH) | C65L | [NAME] 10 |  | C65L | 10 | 1 OR 6 |  | GW | P | M
320 | F/S | 10A-6P - (60 PERISH) | C65L | warehouse |  | C65L | 8 | 1 OR 6 |  | GW | P | F
321 | F/S | 7A-3P - (61 PERISH) | C65F | DAY WHSE |  | C65L | 8 | 1 OR 6 |  | GW | P | I