Spreadsheet: 865884d1712847339-xlookup-accross-3-tabs-maybe-not-best-solution-real-world
Sheet: Nights

0
 |  |  | EMPLOYEE'S DAILY/WEEKLY TIME RECORD
INDUSTRIAL - NIGHTS
 |  |  | WEEK 2(Pay week#1)
MECHANICS |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2024-03-31 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-04-02 00:00:00 |  | 2024-04-03 00:00:00 |  | 2024-04-04 00:00:00 |  | 2024-04-05 00:00:00 |  | 2024-04-06 00:00:00
BOOKED STAFF |  |  | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN
1 | 1 |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
23:00 - 7:30
145889 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
147436 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
128172 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
3343 | 1 | 1 | Sick | Stat | Sick | 8 | Sick | 8 | Sick | 8 | Sick | 8 | DO |  | DO
124578 | 1 | 1 |  |  |  |  |  |  | S | 6.5 | SICK | 8 | DO |  | DO
133049 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
128818 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
149959 | 1 | 1 |  |  |  |  |  |  |  |  | DO |  | DO |  | Sick | 8
162777 | 1 | 1 | Stat |  | DO
168472 | 1 | 1 |  |  | DO
160332 | 1 | 1 | Stat |  | RES |  | RES |  | RES |  | RES |  | RES |  | DO
145205 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
141572 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
Spares/Rehabs
101610 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
159544 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
156127 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
168489 | 1 | 1 | Stat | Sick | S | 8 | S | 8 | DO |  | DO |  | S | 8 | S | 8
NOTES FROM |  |  |  | 3354 |  | 127097 |  | 127097 |  | 132491 |  | 127097 |  | 3354 |  | 3354
SUPERVISOR
 |  |  | EMPLOYEE'S DAILY/WEEKLY TIME RECORD
INDUSTRIAL - NIGHTS
 |  |  | WEEK 2(pay week#1)
ATTENDANTS |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2024-03-31 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-04-02 00:00:00 |  | 2024-04-03 00:00:00 |  | 2024-04-04 00:00:00 |  | 2024-04-05 00:00:00 |  | 2024-04-06 00:00:00
BOOKED STAFF |  |  | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN
Rochon | Norm |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
23:00 - 07:30
151419 | 1 | 1 |  |  |  |  |  |  | DO |  | DO
159472 | 1 | 1 |  |  | DO |  | DO
165260 | 1 | 1 |  |  |  |  |  |  |  |  | DO |  | DO
131214 | 1 | 1 |  |  | DO |  | DO |  |  |  | SICK | 8
136776 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
3969 | 1 | 1 |  |  |  |  |  |  | EV | 8 | EV | 8 | DO |  | DO
105448 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
138699 | 1 | 1 | Stat |  |  |  |  |  | S | 2 | SICK | 8 |  |  | DO
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  |  | 3354 |  | 127097 |  | 127097 |  | 132491 |  | 127097 |  | 3354 |  | 3354
NOTES FROM
SUPERVISOR
 |  |  | EMPLOYEE'S DAILY/WEEKLY TIME RECORD
INDUSTRIAL - COUNTDOWN
 |  |  | WEEK 2(pay week#1)
ATTENDANTS |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2024-03-31 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-04-02 00:00:00 |  | 2024-04-03 00:00:00 |  | 2024-04-04 00:00:00 |  | 2024-04-05 00:00:00 |  | 2024-04-06 00:00:00
BOOKED STAFF |  |  | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN
Rochon | Norm |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
20:00 - 04:30
136941 | Doumbia | Dramane | DO |  |  |  |  |  |  |  |  |  |  |  | DO
136734 | Donnelly | [NAME] | DO |  |  |  |  |  |  |  |  |  |  |  | DO
120541 | Corneau | [NAME] | DO |  |  |  |  |  | PLP #3 | 8 |  |  |  |  | DO
156603 | Chung | Thanh |  |  | DO |  | DO |  |  |  |  |  |  |  | sick | 8
131971 | McCully | [NAME] | SICK | 8 | SICK | 3 | SICK | 8 | SICK | 8 | DO |  | DO
135983 | Middlemiss | [NAME] |  |  | sick | 4 | SICK | 8 | SICK | 8 | DO |  | DO |  | sick | 8
138425 | Cunningham | [NAME] | DO |  | Sick | 8 |  |  |  |  |  |  |  |  | DO
129627 | [NAME] | [NAME] | DO |  |  |  |  |  |  |  |  |  |  |  | DO
167106 | Peake | Hayden |  |  |  |  | DO |  | DO |  |  |  |  |  | IE
167090 | Large | Chad |  |  |  |  |  |  |  |  | DO |  | DO
167332 | Campbell | Scott |  |  | DO |  | DO |  |  |  |  |  |  |  | sick | 8
157076 | Singh Clair | [NAME] |  |  |  |  |  |  | SICK | 8 | DO |  | DO
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
NOTES FROM |  |  |  | 3354 |  | 127097 |  | 127097 |  | 132491 |  | 127097 |  | 3354 |  | 3354
SUPERVISOR |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
Industrial -Night |  |  | WEEK 2(pay week#1)
 |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
[NAME] |  |  | 2024-03-31 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-04-02 00:00:00 |  | 2024-04-03 00:00:00 |  | 2024-04-04 00:00:00 |  | 2024-04-05 00:00:00 |  | 2024-04-06 00:00:00
 |  |  | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN
BOOKED STAFF |  |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
Rochon | Norm
23:00-07:30
149435 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | DO |  | DO
Spares/Rehabs
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  |  | 127097 |  | 127097 |  | 127097 |  | 132491 |  | 127097 |  | 3354 |  | 3354
NOTES FROM
SUPERVISOR
 |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
MAJOR REPAIR - NIGHTS |  |  | WEEK 2(pay week#1)
 |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
MECHANICS - NIGHTS |  |  | 2024-03-31 00:00:00 |  | 2024-04-01 00:00:00 |  | 2024-04-02 00:00:00 |  | 2024-04-03 00:00:00 |  | 2024-04-04 00:00:00 |  | 2024-04-05 00:00:00 |  | 2024-04-06 00:00:00
 |  |  | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN
BOOKED STAFF |  |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
Rochon | Norm
23:00 - 7:30 |  |  |  |  |  |  |  |  |  |  |  |  | DO |  | DO
Spares/Rehabs
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  |  |  |  |  |  |  |  | 132491
NOTES FROM
SUPERVISOR
CODES: |  |  | DO = DAY OFF   VAC = VACATION   E.V. = EMERGENCY VACATION  B=[NAME] (MUST STATE RELATIONSHIP TO EE)
 |  |  | LT = LATE  U- UNION BUSINESS  SE = SHIFT EXCHANGE NOT WORKED   SEW = SHIFT EXCHANGE WORKED
 |  |  | M = MEDICAL FOR [NAME] (2 HR. MAX.)   T = TRAINING   SU = SUSPENSION   X = REHAB WORKED
 |  |  | E = EXCUSED LEAVE (48 HRS. NOTICE GIVEN)   IE - IN EXCUSED LEAVE (NO NOTICE GIVEN) |  |  |  |  |  |  |  |  |  |  | [NAME] Jury Duty
 |  |  | S = SICK   IL = INVESTIGATORY LEAVE     PL = PARENTAL LEAVE      LTD = LONG TERM DISABILITY    MT = MAKE UP TIME
 |  |  | TI = TRANSFERRED IN FROM OTHER LOCATION   TO = TRANSFERRED OUT TO ANOTHER LOCATION |  |  |  |  |  |  |  |  |  |  |  | Si=isolation leave
 |  |  | … PLP – Personal [NAME] and PLU – Personal Leave Unpaid |  |  |  |  |  |  |  | (Please also add number code i.e. PLP-1)
 |  |  | 1. Personal illness/injury;
 |  |  | 2. Responsibilities related to health or care of any family member;
 |  |  | 3. Responsibilities related to education of any of their family members who are under 18 years of age;
 |  |  | 4. Addressing any urgent matter concerning themselves or their family;
 |  |  | 5. Attending their citizenship ceremony; or,
 |  |  | 6. Other reasons prescribed by regulation.
NOTES FROM
SUPERVISOR