Spreadsheet: 851411d1701660163-sumifs-multiple-criteria-sample-pr-excel-copy-2-lorie-ann-
Sheet: PP3-Jan 29-Feb 11

PR_3 TOTAL |  | TOTAL EMPLOYEES
PayPeriod Start Date |  | 2023-01-29 00:00:00 |  |  |  |  |  |  | TIMESHEET DATA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAYROLL NUMBERS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAYROLL $$
PR #          Stat= | Row # | WORK Date ACTUAL | JOB CODE | FSA | SUB CODE | SUB CODE | SUB CODE | *NEW* WORK TYPE | WORKER First Name | WORKER  Last Name | GL CODE | Unit (Oper) | Unit2 | Unit3 | KM'S  (MOB,  A/R Billable) | KM's (EmpEE Rotation Travel) | HR1 - JOB 1  Field Hours | MOB-YARD HR1 CC15 | MOB MOVE HR1 CC17 | HR2 Shop Hours Misc Travel CC2010 | HR3  MOB Hours  Rotation Travel CC30 | HR4        DROP BONUS HRS | DROP    BONUS PIECES | UNPAID MOB Hours  Rotation Travel CC31 | ADJ Hours PR Corr | GRAND TOTAL HOURS | CELL BONUS - Y/N Once per PP | SUB | Full LOA | No LOA | Notes | HR1  REG FIELD HRS | HR1  REG FIELD RATE | HR2  REG SHOP HRS | HR2  REG SHOP RATE | HR3  ADJ TIME Rotation | HR3  ADJ RATE Rotation | OT HR1  REG OT HRS | OT HR1  FIELD RATE | [NAME] OT HRS | OT HR2  OT SHOP RATE | HR1 + HR 2  TOTAL REG HOURS | OT HR1 + OT HR2  TOTAL OT HOURS | TOTAL HRS | TOTAL HRS-X-REF | SUB | LOA FULL | CELL BONUS | # OF TRUCK RENT | HR1  TOTAL WAGE | HR2  TOTAL WAGE | HR3  WAGE (Rotation) | OT HR1  TOTAL WAGE | [NAME] | STAT PAY | ADJ/PR Corr HRS * APPLICABLE RATE | PROD-BONUS DP1 | VACATION PAY | SUB * 58.00 | LOA-FULL * 130.00 | CELL BONUS 1 X PP @15.00 | TRUCK RENT *60.00
 |  |  |  |  |  |  |  |  | MELISSA | ORANGE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
END WK1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0 |  |  |  |  |  |  |  | Y
END WK2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EMPLOYEE BREAK |  |  |  |  |  |  |  | #REF!
 |  |  |  |  |  |  |  |  | TROY | PURPLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
END WK1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0 |  |  |  |  |  |  |  | Y
END WK2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EMPLOYEE BREAK |  |  |  |  |  |  |  | #REF!
 |  |  |  |  |  |  |  |  | BRENT | GREEN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
END WK1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0 |  |  |  |  |  |  |  | Y
END WK2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EMPLOYEE BREAK |  |  |  |  |  |  |  | #REF!
 |  | 2023-11-19 00:00:00 |  |  |  |  |  |  | BRENT | GREEN |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 38 | 0 | 30 | 0 | 30 | 0 | 57 | 0 | 45 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
PR_24 WK_1 | 7483 | 2023-11-20 00:00:00 | 799 |  | 1010 |  |  | OPH | BRENT | GREEN |  |  |  |  | 0 | 0 | 9.5 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 9.5 |  | 0 | 0 | 1 |  | 8 | 38 | 0 | 30 | 0 | 30 | 1.5 | 57 | 0 | 45 | 8 | 1.5 | 9.5 | 9.5 | 0 | 0 |  | 0 | 304 | 0 | 0 | 85.5 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
PR_24 WK_1 | 7484 | 2023-11-21 00:00:00 | 799 |  | 1010 |  |  | OPH | BRENT | GREEN |  |  |  |  | 0 | 0 | 9.5 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 9.5 |  | 0 | 0 | 1 |  | 8 | 38 | 0 | 30 | 0 | 30 | 1.5 | 57 | 0 | 45 | 8 | 1.5 | 9.5 | 9.5 | 0 | 0 |  | 0 | 304 | 0 | 0 | 85.5 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
PR_24 WK_1 | 7485 | 2023-11-22 00:00:00 | 799 |  | 1010 |  |  | OPH | BRENT | GREEN |  |  |  |  | 0 | 0 | 9.5 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 9.5 |  | 0 | 0 | 1 |  | 8 | 38 | 0 | 30 | 0 | 30 | 1.5 | 57 | 0 | 45 | 8 | 1.5 | 9.5 | 9.5 | 0 | 0 |  | 0 | 304 | 0 | 0 | 85.5 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
PR_24 WK_1 | 7486 | 2023-11-23 00:00:00 | 799 |  | 1010 |  |  | OPH | BRENT | GREEN |  |  |  |  | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 5 |  | 0 | 0 | 1 |  | 5 | 38 | 0 | 30 | 0 | 30 | 0 | 57 | 0 | 45 | 5 | 0 | 5 | 5 | 0 | 0 |  | 0 | 190 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
PR_24 WK_1 | 7487 | 2023-11-24 00:00:00 | 799 |  | 1010 |  |  | OPH | BRENT | GREEN |  |  |  |  | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 10 |  | 0 | 0 | 1 |  | 8 | 38 | 0 | 30 | 0 | 30 | 2 | 57 | 0 | 45 | 8 | 2 | 10 | 10 | 0 | 0 |  | 0 | 304 | 0 | 0 | 114 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
PR_24 WK_1 | 7575 | 2023-11-25 00:00:00 | 799 |  | 1010 |  |  | OPH | BRENT | GREEN |  |  |  |  | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 10 |  | 0 | 0 | 1 |  | 8 | 38 | 0 | 30 | 0 | 30 | 2 | 57 | 0 | 45 | 8 | 2 | 10 | 10 | 0 | 0 |  | 0 | 304 | 0 | 0 | 114 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
END WK1 |  |  |  |  |  |  |  |  | BRENT | GREEN |  |  |  |  | 0 | 0 | 53.5 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 53.5 |  | 0 | 0 | 6 |  | 45 |  | 0 |  | 0 |  | 8.5 |  | 0 | 0 | 45 | 8.5 | 53.5 | 53.5 | 0 | 0 |  | 0 | 1710 | 0 | 0 | 484.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 2023-11-26 00:00:00 |  |  |  |  |  |  | BRENT | GREEN |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 38 | 0 | 30 | 0 | 30 | 0 | 57 | 0 | 45 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
PR_24 WK_2 | 7576 | 2023-11-27 00:00:00 | 795 |  | 1010 |  |  | SHOP | BRENT | GREEN |  |  |  |  | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 10 |  | 0 | 0 | 1 |  | 8 | 38 | 0 | 30 | 0 | 30 | 2 | 57 | 0 | 45 | 8 | 2 | 10 | 10 | 0 | 0 |  | 0 | 304 | 0 | 0 | 114 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
 |  | 2023-11-28 00:00:00 |  |  |  |  |  |  | BRENT | GREEN |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 38 | 0 | 30 | 0 | 30 | 0 | 57 | 0 | 45 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
PR_24 WK_2 | 7577 | 2023-11-29 00:00:00 | 795 |  | 1010 |  |  | SHOP | BRENT | GREEN |  | 70801 |  |  | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 10 |  | 0 | 0 | 1 |  | 8 | 38 | 0 | 30 | 0 | 30 | 2 | 57 | 0 | 45 | 8 | 2 | 10 | 10 | 0 | 0 |  | 0 | 304 | 0 | 0 | 114 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
 |  | 2023-11-30 00:00:00 |  |  |  |  |  |  | BRENT | GREEN |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 38 | 0 | 30 | 0 | 30 | 0 | 57 | 0 | 45 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
 |  | 2023-12-01 00:00:00 |  |  |  |  |  |  | BRENT | GREEN |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 38 | 0 | 30 | 0 | 30 | 0 | 57 | 0 | 45 | 0 | 0 | 0 | 0 | 0 | 0 | N | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
 |  | 2023-12-02 00:00:00 |  |  |  |  |  |  | BRENT | GREEN |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 38 | 0 | 30 | 0 | 30 | 0 | 57 | 0 | 45 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  | 0 | 0 | 0 | 0
END WK2 |  |  |  |  |  |  |  |  | BRENT | GREEN |  |  |  |  | 0 | 0 | 20 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 20 |  | 0 | 0 | 2 |  | 16 |  | 0 |  | 0 |  | 4 |  | 0 | 0 | 16 | 4 | 20 | 20 | 0 | 0 |  | 0 | 608 | 0 | 0 | 228 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PR_24 TOTAL |  |  |  |  |  |  |  |  | BRENT | GREEN |  |  |  |  | 0 | 0 | 73.5 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 73.5 |  | 0 | 0 | 8 |  | 61 |  | 0 |  | 0 |  | 12.5 |  | 0 | 0 | 61 | 12.5 | 73.5 | 73.5 | 0 | 0 |  | 0 | 2318 | 0 | 0 | 712.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EMPLOYEE BREAK |  |  |  |  |  |  | #REF!
 |  |  |  |  |  |  |  |  | CODY | FISH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20
END WK1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 20 |  | 20 |  |  | 0 |  |  |  |  |  |  |  | Y
END WK2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EMPLOYEE BREAK |  |  |  |  |  |  |  | #REF!
 |  |  |  |  |  |  |  |  | DARREN | [NAME] |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0 |  |  |  |  |  |  |  | Y
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
PR_3 WK_1 | 361 |  | 591 |  | 1165 |  |  | MDLK |  |  |  |  |  |  | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 8 |  | 0 | 0 | 1 | 591 AS BUILTS | 8 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
END WK1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
PR_3 [NAME] | 413 |  | 591 |  | 1165 |  |  | MDLK |  |  |  |  |  |  | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 8 |  | 0 | 0 | 1 | 591 AS BUILTS | 8 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
PR_3 [NAME] | 502 |  | 811 |  | 1165 |  |  | MGMT |  |  |  |  |  |  | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 8 |  | 0 | 0 | 1 | 591 AS BUILTS + BC TRANSPO INFO | 8 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 35 | 0 | 30 | 0 | 30 | 0 |  | 0
END WK2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
EMPLOYEE BREAK |  |  |  |  |  |  |  | #REF!
 |  |  |  |  |  |  |  |  | [NAME] | PIE |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20
END WK1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20 |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 20 |  | 20 |  | 20 |  |  | 0 |  |  |  |  |  |  |  | Y
END WK2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0