Spreadsheet: 865621d1712665198-power-query-help-file-2
Sheet: Days

[EMAIL]
 |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
MERIVALE - DAYS |  |  |  |  |  |  |  |  | WEEK 2
 |  |  | 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
McGrath | [NAME] |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
7:00 - 15:30
128176 | Ryann | Barajas | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
3362 | Brennan | Cortez | DO |  | Stat wrk |  |  |  |  |  |  |  | S | 8 | DO
123981 | Haven | Wilkinson | DO |  | Stat off |  |  |  |  |  |  |  |  |  | DO
3322 | Leonard | Villa | DO |  | Stat off |  |  |  |  |  |  |  |  |  | DO
128167 | [NAME] | Pearson | DO |  | Stat wrk |  | S | 8 |  |  |  |  |  |  | DO
128968 | Gunner | Haley | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
167497 | Addilynn | [NAME] | DO |  | Stat wrk |  |  |  |  |  | Sick | 8 |  |  | DO
Apprentices
155064 | [NAME] | Pena | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
Spares/Rehabs
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  |  |  |  | 123845 |  | 123845 |  | 123845 |  |  |  | 123845
NOTES FROM
SUPERVISOR
 |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
MERIVALE - Day
 |  |  | WEEK 2
[NAME] |  |  | 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
McGrath | [NAME] |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
07:00-15:30
3960 | Nala | Massey | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  |  |  |  | 123845 |  | 123845 |  | 123845 |  |  |  | 123845
NOTES FROM
SUPERVISOR
 |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
MERIVALE - DAYS
 |  |  | WEEK 2
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
McGrath | [NAME] |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
7:00 - 15:30
129386 | [NAME] | [NAME] | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
4052 | [NAME] | [NAME] | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
4083 | [NAME] | Salinas | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
127680 | Royalty | Bailey | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
126246 | Axel | [NAME] | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
4088 | Emma | [NAME] | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
Spares/Rehabs |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
NOTES FROM
SUPERVISOR |  |  |  |  |  | 123845 |  | 123845 |  | 123845 |  |  |  | 123845
 |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
 |  |  | WEEK 2
 |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
MAJOR REPAIR - DAYS |  |  | 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
MECHANICS |  |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
MAJOR REPAIR - DAYS
BOOKED STAFF
McGrath | [NAME]
07:00 - 15:30
123844 | Will | Kent | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
127086 | Jazmine | Pugh | DO |  | Vac | 8 | Vac | 8 | Vac | 8 | Vac | 8 | Vac | 8 | DO
123973 | Judson | Hahn | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
127749 | Fallon | [NAME] | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
119944 | [NAME] | Rodgers | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
Spares/Rehabs |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  | 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
CODES: |  |  | E = EXCUSED LEAVE (48 HRS. NOTICE GIVEN)   IE - IN EXCUSED LEAVE (NO NOTICE GIVEN)
 |  |  | 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
 |  |  | 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;
 |  |  | Supv No. |  | Supv No. |  | Supv No. | 123845 | Supv No. | 123845 | Supv No. |  | Supv No. | 123845 | Supv No.
 |  |  |  |  |  | 123845
SUPERVISOR |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
 |  |  | WEEK 2
 |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
PARA TRANSPO - DAYS |  |  | 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
MECHANICS |  |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
BOOKED STAFF
McGrath | [NAME]
123876 | [NAME] | Cochran | DO |  | Stat wrk |  |  |  |  |  | SICK | 5 |  |  | DO
132412 | [NAME] | Watson |  |  | Stat wrk |  | DO |  | DO
116553 | Greyson | [NAME] | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
3320 | Royal | [NAME] | DO |  | Stat off |  |  |  |  |  |  |  |  |  | DO
Spares/Rehabs
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  |  | 3341 |  | 123845 |  | 123845 |  | 123845 |  |  |  | 123845 |  | 3341
NOTES FROM
SUPERVISOR |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
 |  |  | WEEK 2
 |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
PARA TRANSPO - DAYS |  |  | 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
ATTENDANTS |  |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
BOOKED STAFF
McGrath | [NAME]
7:00 - 15:30
123989 | Ira | [NAME] | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
150452 | Rosalie | Stone | DO |  | Stat wrk |  |  |  |  |  |  |  |  |  | DO
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
Spares/Rehabs |  |  |  |  |  | 123845 |  | 123845 |  | 123845 |  |  |  | 123845
 |  |  | 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) |  |  |  |  |  |  | JD-Jury Duty
CODES: |  |  | 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.