Spreadsheet: 865620d1712665198-power-query-help-file-1
Sheet: Nights

[EMAIL]
 |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
MERIVALE - NIGHTS
 |  |  | WEEK 1
MECHANICS |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2024-04-07 00:00:00 |  | 2024-04-08 00:00:00 |  | 2024-04-09 00:00:00 |  | 2024-04-10 00:00:00 |  | 2024-04-11 00:00:00 |  | 2024-04-12 00:00:00 |  | 2024-04-13 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
[NAME] | Trevor |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
23:00 - 07:30
167638 | Dion | Cortes |  |  |  |  |  |  |  |  |  |  | DO |  | DO
3314 | [NAME] | Harvey | VAC | 8 | VAC | 8 | VAC | 8 | VAC | 8 | VAC | 8 | DO |  | DO
169003 | Cayden | Leonard |  |  |  |  |  |  |  |  |  |  | DO |  | DO
156127 | Demi | Chung |  |  |  |  |  |  |  |  |  |  | DO |  | DO
 |  |  | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. |  | Supv No.
 |  |  | WEEK 1
ATTENDANTS |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2024-04-07 00:00:00 |  | 2024-04-08 00:00:00 |  | 2024-04-09 00:00:00 |  | 2024-04-10 00:00:00 |  | 2024-04-11 00:00:00 |  | 2024-04-12 00:00:00 |  | 2024-04-13 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
[NAME] | Trevor |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
23:00 - 07:30
127099 | [NAME] | Montes |  |  |  |  |  |  |  |  |  |  | DO |  | DO
4054 | [NAME] | Bentley | S | 8 | S | 8 | S | 8 | S | 8 | S | 8 | DO |  | DO
121614 | Jaylin | Solis |  |  |  |  |  |  |  |  |  |  | DO |  | DO
126906 | Ronin | Mendoza |  |  |  |  |  |  |  |  |  |  | DO |  | DO
159416 | [NAME] | Stuart |  |  |  |  |  |  |  |  |  |  | DO |  | DO
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
SUPERVISOR
 |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
MERIVALE - COUNTDOWN
 |  |  | WEEK 1
ATTENDANTS |  |  | SUN. |  | Mon |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2020-07-12 00:00:00 |  | 2020-07-13 00:00:00 |  | 2020-07-14 00:00:00 |  | 2020-07-15 00:00:00 |  | 2020-07-16 00:00:00 |  | 2020-07-17 00:00:00 |  | 2020-07-18 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
Debidin | [NAME] |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
20:00 - 04:30
142479 | Hughes | [NAME] | DO |  |  |  |  |  |  |  |  |  |  |  | DO
125105 | Ranger | [NAME] | DO |  |  |  |  |  |  |  |  |  |  |  | DO
133213 | Schroeder | [NAME] | DO |  |  |  |  |  |  |  |  |  |  |  | DO
154469 | Kelly | [NAME]
154469 | Kelly | [NAME] |  |  | DO |  | DO
156783 | Imran | [NAME] |  |  |  |  |  |  | DO |  | DO
149610 | Ranger | [NAME] |  |  |  |  |  |  |  |  | DO |  | DO
Spares/Rehabs
MERIVALE - COUNTDOWN
 |  |  | WEEK 1
ATTENDANTS |  |  | SUN. |  | Mon |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2024-04-07 00:00:00 |  | 2024-04-08 00:00:00 |  | 2024-04-09 00:00:00 |  | 2024-04-10 00:00:00 |  | 2024-04-11 00:00:00 |  | 2024-04-12 00:00:00 |  | 2024-04-13 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
[NAME] | Trevor |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
20:00 - 04:30
143017 | Paola | Pugh | DO |  | T | 8 | T | 8 | T | 8 |  |  |  |  | DO
148247 | Judson | [NAME] | DO |  |  |  |  |  |  |  |  |  |  |  | DO
149610 | Genevieve | West | DO |  |  |  |  |  |  |  |  |  |  |  | DO
146727 | Diego | [NAME] | DO |  |  |  |  |  |  |  |  |  |  |  | DO
NOTES FROM |  |  | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. |  | Supv No.
SUPERVISOR
[EMAIL]
MAJOR REPAIR - NIGHTS
 |  |  | WEEK 1
MECHANICS - NIGHTS |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2024-04-07 00:00:00 |  | 2024-04-08 00:00:00 |  | 2024-04-09 00:00:00 |  | 2024-04-10 00:00:00 |  | 2024-04-11 00:00:00 |  | 2024-04-12 00:00:00 |  | 2024-04-13 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
[NAME] | Trevor |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
23:00 - 7:30
127091 | [NAME] | McClain |  |  |  |  |  |  |  |  |  |  | DO |  | DO
145809 | Marleigh | Hendrix |  |  |  |  |  |  |  |  |  |  | DO |  | DO
162712 | Korbyn | Coffey |  |  |  |  |  |  |  |  |  |  | DO |  | DO
 |  |  | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. |  | Supv No.
NOTES FROM
PARA TRANSPO - COUNTDOWN
 |  |  | WEEK 1
ATTENDANTS |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2024-04-07 00:00:00 |  | 2024-04-08 00:00:00 |  | 2024-04-09 00:00:00 |  | 2024-04-10 00:00:00 |  | 2024-04-11 00:00:00 |  | 2024-04-12 00:00:00 |  | 2024-04-13 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
[NAME] | Trevor |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
20:00-04:30
125105 | Elora | Atkins |  |  |  |  |  |  |  |  |  |  | DO |  | DO
126812 | Cason | [NAME] | RET |  | RET |  | RET |  | RET |  | RET |  | DO |  | DO
126254 | Sierra | Warner |  |  |  |  |  |  |  |  |  |  | DO |  | DO
 |  |  | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. |  | Supv No.
MECHANICS - NIGHTS-PARA |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2024-04-07 00:00:00 |  | 2024-04-08 00:00:00 |  | 2024-04-09 00:00:00 |  | 2024-04-10 00:00:00 |  | 2024-04-11 00:00:00 |  | 2024-04-12 00:00:00 |  | 2024-04-13 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
[NAME] | Trevor |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
23:00 - 7:30
143020 | Silas | [NAME] |  |  |  |  |  |  |  |  |  |  | DO |  | DO
 |  |  | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. | 110783 | Supv No. |  | Supv No.
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] 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.