Spreadsheet: 866749d1713646673-stuck-on-power-query-dec17-23-wk1
Sheet: data

EE | Last | First
 | [NAME] | Thompson |  |  |  |  |  |  | DO
3342 | Mark | Holloway | DO |  |  |  |  |  | DO
3351 | Grace | [NAME] | VAC | VAC | VAC | VAC | VAC | DO | DO
3378 | Emily | [NAME] | DO | PLP#3 | TRN |  |  | VAC | DO
3558 | Ava | [NAME] | DO |  |  |  |  | VAC | DO
4031 | [NAME] | White | DO |  |  |  |  |  | DO
4076 | [NAME] | [NAME] | DO |  |  | V | V | V | DO
4099 | [NAME] | [NAME] | DO |  |  |  |  |  | DO
4109 | [NAME] | Turner | DO | VAC | VAC | VAC | VAC | VAC | DO
7073 | [NAME] | [NAME] | VAC | VAC | VAC | VAC | VAC | DO | DO |  |  |  |  | m1
117839 | Sophia | Martin | DO |  |  |  |  |  | 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)))
120233 | [NAME] | [NAME] | DO | VAC | VAC | VAC | VAC | VAC | 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))
121022 | Olivia | Rodriguez | DO | VAC | VAC | VAC | VAC | VAC | DO
121952 | [NAME] | Lewis | DO |  |  |  |  | VAC | DO
124094 | [NAME] | Hall | DO | VAC |  |  |  |  | DO
127100 | Amelia | King |  |  |  |  |  | DO | DO
130300 | [NAME] | Young | DO | efefefefef |  |  | Sick | Sick | DO
133213 | [NAME] | Brooks | DO |  |  |  | PLP#1 |  | DO
135455 | Lucas | [NAME] |  |  |  |  |  | DO | DO
135683 | [NAME] | Hernandez | VAC | VAC | VAC | VAC | VAC | DO | DO
136113 | Logan | Scott | DO |  |  |  |  |  | DO
138427 | [NAME] | [NAME] | DO | Sick |  |  |  | VAC | DO
143687 | [NAME] | Moore | DO |  |  |  |  |  | DO
156368 | Victoria | [NAME] | DO |  |  |  |  |  | DO
159557 | [NAME] | Reed | DO |  |  |  | Lt |  | DO
167090 | Emma | Green | DO | EV |  |  | Sick |  | 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
sd |  |  | 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 |  |  | 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 | sdfsdf
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A