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

[EMAIL]
 |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
INDUSTRIAL - DAYS
 |  |  | 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
7:00 - 15:30
3307 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  | PLP#3 | 8 | DO
3357 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
128692 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
128919 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
129501 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
3946 | 1 | 1 | DO |  | SU |  | SU |  | SU |  |  |  |  |  | DO
119797 | 1 | 1 | DO |  |  |  |  |  |  |  | S | 8 |  |  | DO
4043 | 1 | 1 | DO |  |  |  |  |  |  |  | S | 8 | SICK | 8 | DO
4093 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  | PLP-1 | 8 | DO
126003 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
3321 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
121902 | 1 | 1 | DO
143912 | 1 | 1 |  |  |  |  |  |  |  |  | DO |  | DO |  | DO
145958 | 1 | 1 |  |  | SICK | 8 | SICK | 8 | SICK | 8 | SICK | 8 | DO |  | DO
143926 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  | DO |  | DO
159614 | 1 | 1 | DO |  | DO
166234 | 1 | 1 | DO |  | DO
155051 | 1 | 1 | DO |  | DO
146699 | 1 | 1 | PLP | #1 | DO |  |  |  |  |  |  |  | EV | 8 | DO
134811 | 1 | 1 | DO |  | Sick | 8 | S | 8 | S | 8 | S | 8 | DO
146699 | 1 | 1 |  |  | DO |  |  |  |  |  |  |  | DO
143932 | 1 | 1 | DO |  | DO |  |  |  |  |  |  |  |  |  | DO
147479 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
3344 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
3991 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
Spares/Rehabs
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
154923 | 1 | 1 |  |  |  |  |  |  |  |  |  |  | DO |  | DO
155067 | 1 | 1 | DO |  | School |  | School |  | School |  | School |  | School |  | DO
NOTES FROM |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
SUPERVISOR |  |  |  |  |  | 3338 |  | 3338 |  | 3338 |  | 3338 |  | 3338
 |  |  | EMPLOYEE'S DAILY/WEEKLY TIME RECORD
INDUSTRIAL - DAYS
 |  |  | 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
1 | 1 |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
07:00 - 15:30
127092 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
133204 | 1 | 1 |  |  |  |  |  |  | DO |  | DO
138380 | 1 | 1 |  |  |  |  |  |  | DO |  | DO
4102 | 1 | 1 | DO |  | Sic | 8 | Sic | 8 | Sic | 8 | Sic | 8 | Sic | 8 | DO
133107 | 1 | 1 | DO |  |  |  |  |  |  |  | [NAME] | 8 |  |  | DO
4053 | 1 | 1 | DO |  | Vac | 8 | Vac | 8 | Vac | 8 | Vac | 8 | Vac | 8 | DO
4112 | 1 | 1 | DO |  | S | 8 | S | 8 | S | 8 | S | 8 | S | 8 | DO
4061 | 1 | 1 | DO |  |  |  |  |  |  |  | S | 8 |  |  | DO
132149 | 1 | 1 | DO |  |  |  |  |  | S | 8 |  |  |  |  | DO
124108 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
4061 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
132149 | 1 | 1 |  |  |  |  |  |  |  |  | DO |  | DO
124108 | 1 | 1 | DO |  |  |  |  |  |  |  |  |  |  |  | DO
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  |  |  |  | 133469 |  | 133469 |  | 133469 |  | 133469 |  | 133469
NOTES FROM
SUPERVISOR
 |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
Industrial -Day
 |  |  | WEEK 2(payweek #1)
[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
[NAME] |  |  |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT |  | OUT
07:00-15:30
124575 | Daly | [NAME] | DO |  | VAC | 8 | VAC |  | VAC | 8 | VAC | 8 | VAC | 8 | DO
143076 | [NAME] | Greg | DO |  |  |  |  |  |  |  |  |  |  |  | DO
Spares/Rehabs
 |  |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No. |  | Supv No.
 |  |  |  |  |  | 3338 |  | 3338 |  | 3338 |  | 3338 |  | 3338
NOTES FROM
SUPERVISOR
NOTES FROM
SUPERVISOR