Spreadsheet: 866748d1713646666-stuck-on-power-query-dec10-16-wk2
Sheet: data

EE | Last | First
 | [NAME] | Thompson |  |  |  |  |  |  | DO
3342 | Mark | Holloway | DO | SICK | SICK | SICK | SICK | SICK | DO
3351 | Grace | [NAME] |  |  | VAC | VAC | VAC | DO | DO
3378 | Emily | [NAME] | DO | PLP3 | rrrrrrrr |  |  | VAC | DO
3558 | [NAME] | Hall | DO |  |  |  |  |  | DO |  | m1 | .=MIN( IF(ISNUMBER(Days!D:D) * (Days!D:D >= DATE(1900, 1, 1)),Days!D:D)) |  |  |  |  |  |  |  | m1
4031 | [NAME] | Turner | DO | VAC | VAC | VAC | VAC | VAC | DO |  | a2 | .=LET(A,VSTACK(Days:Nights!A1:Q70),B,UNIQUE(INDEX(A,,1)),C,SORT(FILTER(B,B<>0)),D,DROP(REDUCE("",C,LAMBDA(y,z,VSTACK(y,CHOOSECOLS(FILTER(A,INDEX(A,,1)=z),2,3)))),1),HSTACK(C,IF(D="","",D)))
4076 | [NAME] | [NAME] | DO |  |  | B | B | B | DO |  | d2 | .=LET(A,VSTACK(Days:Nights!A1:Q70),B,UNIQUE(INDEX(A,,1)),C,SORT(FILTER(B,B<>0)),D,DROP(REDUCE("",C,LAMBDA(y,z,VSTACK(y,CHOOSECOLS(FILTER(A,INDEX(A,,1)=z),4,6,8,10,12,14,16)))),1),IF(D="","",D))
4099 | [NAME] | [NAME] | DO |  |  |  |  |  | DO
4109 | [NAME] | [NAME] | DO |  |  |  |  |  | DO
7073 | Amelia | King |  |  |  |  |  | DO | DO
117839 | Sophia | Martin | DO |  |  |  |  |  | DO
120233 | [NAME] | White | DO |  |  |  |  |  | DO
120234 | Charlotte | [NAME] | DO |  |  |  |  |  | DO
121022 | Olivia | Rodriguez | DO | VAC |  |  |  |  | DO
121902 | [NAME] | Lewis | DO |  |  |  |  |  | DO
124094 | Ava | [NAME] | DO |  |  |  |  |  | DO
127100 | [NAME] | Hernandez |  |  |  |  |  | DO | DO
130300 | [NAME] | Young | DO | TO | TO | TO |  |  | DO
133213 | [NAME] | Brooks | DO |  |  |  |  |  | DO
135455 | Lucas | [NAME] |  |  |  |  |  | DO | DO
135683 | [NAME] | [NAME] | T | T | S |  | SICK | DO | DO
136113 | [NAME] | Reed | DO |  |  |  |  |  | DO
138427 | [NAME] | Moore | DO |  |  |  |  | V | DO
143687 | [NAME] | [NAME] | DO |  |  |  |  |  | DO
156368 | Logan | Scott | DO | S |  |  |  |  | DO
159557 | Victoria | [NAME] | DO |  | SICK | Sick | LT |  | DO
167090 | Emma | Green | DO |  |  |  |  |  | DO
15:00 - 23:30
20:00-4:30
23:00 - 07:30
7:00 - 15:30
7:00 - 15:30
ATTENDANTS
BodyShop
BOOKED STAFF |  |  | SUN. | MON. | TUES. | WED. | THURS. | FRI. | SAT.
Brazeau |  |  | SUN. | MON. | TUES. | WED. | THURS. | FRI. | SAT.
CODES: |  |  | SUN. | MON. | TUES. | WED. | THURS. | FRI. | SAT.
MECHANICS |  |  | SUN. | MON. | TUES. | WED. | THURS. | FRI. | SAT.
Minott
NOTES FROM |  |  | CODE | CODE | CODE | CODE | CODE | CODE | CODE
PINECREST - COUNTDOWN |  |  | CODE | CODE | CODE | CODE | CODE | CODE | CODE
PINECREST - DAYS |  |  | CODE | CODE | CODE | CODE | CODE | CODE | CODE
PINECREST - EVENINGS |  |  | CODE | CODE | CODE | CODE | CODE | CODE | CODE
PINECREST - NIGHTS |  |  | CODE | CODE | CODE | CODE | CODE | CODE | CODE
Ploeger |  |  | CODE | CODE | CODE | CODE | CODE | CODE | CODE
Spares/Rehabs |  |  | CODE | CODE | CODE | CODE | CODE | CODE | CODE
SUPERVISOR | [NAME]
[EMAIL] | [NAME]
#N/A |  |  | DO = DAY OFF   VAC = VACATION   E.V. = EMERGENCY VACATION  B=[NAME] (MUST STATE RELATIONSHIP TO EE)
#N/A |  |  | DO = DAY OFF   VAC = VACATION   E.V. = EMERGENCY VACATION  B=[NAME] (MUST STATE RELATIONSHIP TO EE)
#N/A |  |  | SUN. | MON. | TUES. | WED. | THURS. | FRI. | SAT.
#N/A |  |  | SUN. | MON. | TUES. | WED. | THURS. | FRI. | SAT.
#N/A |  |  | SUN. | MON. | TUES. | WED. | THURS. | FRI. | SAT.
#N/A | [NAME]
#N/A | [NAME]
#N/A |  |  | Supv No. | Supv No. | Supv No. | Supv No. | Supv No. | Supv No. | Supv No.
#N/A |  |  | 6. Other reasons prescribed by regulation.
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A | [NAME]
#N/A | [NAME]
#N/A | [NAME]
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A