Spreadsheet: 118432d1313683609-sumproduct-returning-zeroes-earning-hrs-by-dept
Sheet: Data

Department Paycode Totals
 | Time Period |  |  |  | 8/07/2011  -  8/13/2011 |  |  |  |  |  |  |  | Data Up To Date |  |  |  |  |  |  |  | 40771.52422453704
 | Query |  |  |  | All Home
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed |  |  |  |  |  |  |  | 8/16/2011  12:35:06PM
 | Actual/Adjusted: |  |  |  | Actual hours only
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed For
 | Pay Codes: |  |  |  | (33): |D0334 Supplies deduction|D0709 Meat Purchase|E001 MEAT SNX Addtl Reg Hours|E001 Reg no ot|E001 Reg no shift prem|...
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column E | Column C | Column N | Column S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dept | Code | Hrs | Wage
Department: |  |  |  | 1270
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 5.17 |  |  |  |  | 0 |  |  |  |  |  |  |  | 5.17
 |  | ZZE001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 40.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 45.17 |  |  |  |  | 0
Department: |  |  |  | 2030
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 550.75 |  |  |  |  | 9153.987499999997
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 32.00 |  |  |  |  | 516.8
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 142.62 |  |  |  |  | 3569.10375
 |  | E102 Dbl no shift prem |  |  |  |  |  |  |  | 0 |  |  | 20.40 |  |  |  |  | 619.019999
 |  | ZZE056 Unexcused Absence wo pay |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 745.77 |  |  |  |  | 13858.911249
Department: |  |  |  | 2210
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 156.47 |  |  |  |  | 2662.286667
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 32.22 |  |  |  |  | 814.6487500000001
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 188.68 |  |  |  |  | 3476.935417
Department: |  |  |  | 2310
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 136.00 |  |  |  |  | 2309.6
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 39.13 |  |  |  |  | 983.0762500000001
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 175.13 |  |  |  |  | 3292.67625
Department: |  |  |  | 3030
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 382.47 |  |  |  |  | 6074.034168
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 8.00 |  |  |  |  | 129.2
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 100.22 |  |  |  |  | 2386.3175
 |  | E102 Dbl no shift prem |  |  |  |  |  |  |  | 0 |  |  | 6.48 |  |  |  |  | 195.796667
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 497.17 |  |  |  |  | 8785.348335
 | Time Period |  |  |  | 8/07/2011  -  8/13/2011 |  |  |  |  |  |  |  | Data Up To Date |  |  |  |  |  |  |  | 40771.52422453704
 | Query |  |  |  | All Home
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed |  |  |  |  |  |  |  | 8/16/2011  12:35:06PM
 | Actual/Adjusted: |  |  |  | Actual hours only
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed For
 | Pay Codes: |  |  |  | (33): |D0334 Supplies deduction|D0709 Meat Purchase|E001 MEAT SNX Addtl Reg Hours|E001 Reg no ot|E001 Reg no shift prem|...
Department: |  |  |  | 3045
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 827.83 |  |  |  |  | 11098.564999
 |  | E002 VAC [NAME]A |  |  |  |  |  |  |  | 0 |  |  | 40.00 |  |  |  |  | 552
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 32.00 |  |  |  |  | 427.2
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 88.02 |  |  |  |  | 1779.11875
 |  | ZZE056 LOA |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 987.85 |  |  |  |  | 13856.883749
Department: |  |  |  | 3515
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E056  Absent withOUTpay SNX ONLY |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 32.87 |  |  |  |  | 236.0425
 |  | E408 Addtl SNX Reg |  |  |  |  |  |  |  | 0 |  |  | 0.17 |  |  |  |  | 0
 |  | ZZE001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 265.30 |  |  |  |  | 526
 |  | ZZE002 Vac No OT |  |  |  |  |  |  |  | 0 |  |  | 48.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 346.33 |  |  |  |  | 762.0425
Department: |  |  |  | 3580
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E056  Absent withOUTpay SNX ONLY |  |  |  |  |  |  |  | 0 |  |  | 1.47 |  |  |  |  | 0
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 7.13 |  |  |  |  | 0
 |  | ZZE001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 118.53 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 127.13 |  |  |  |  | 0
Department: |  |  |  | 9551
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 32.27 |  |  |  |  | 0
 |  | E408 Addtl SNX Reg |  |  |  |  |  |  |  | 0 |  |  | 11.87 |  |  |  |  | 0
 |  | ZZE001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 155.87 |  |  |  |  | 0
 |  | ZZE002 Vac No OT |  |  |  |  |  |  |  | 0 |  |  | 16.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 216.00 |  |  |  |  | 0
 | Time Period |  |  |  | 8/07/2011  -  8/13/2011 |  |  |  |  |  |  |  | Data Up To Date |  |  |  |  |  |  |  | 40771.52422453704
 | Query |  |  |  | All Home
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed |  |  |  |  |  |  |  | 8/16/2011  12:35:06PM
 | Actual/Adjusted: |  |  |  | Actual hours only
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed For
 | Pay Codes: |  |  |  | (33): |D0334 Supplies deduction|D0709 Meat Purchase|E001 MEAT SNX Addtl Reg Hours|E001 Reg no ot|E001 Reg no shift prem|...
Department: |  |  |  | 9610
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 781.22 |  |  |  |  | 10230.431666
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 32.00 |  |  |  |  | 425.2
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 40.17 |  |  |  |  | 809.715
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 853.38 |  |  |  |  | 11465.346666
Department: |  |  |  | 9611
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 699.65 |  |  |  |  | 9091.877500999999
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 16.00 |  |  |  |  | 206.4
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 142.65 |  |  |  |  | 2810.81625
 |  | ZZE002 Vac No OT |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  | ZZE056 Unexcused Absence wo pay |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 858.30 |  |  |  |  | 12109.093751
Department: |  |  |  | 9612
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 1,132.95 |  |  |  |  | 14835.459165
 |  | E002 VAC [NAME]A |  |  |  |  |  |  |  | 0 |  |  | 40.00 |  |  |  |  | 526
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 16.00 |  |  |  |  | 213.6
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 191.27 |  |  |  |  | 3793.17875
 |  | ZZE002 Vac No OT |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  | ZZE056 EMPL Laid Off |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  | ZZE056 Unexcused Absence wo pay |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 1,380.22 |  |  |  |  | 19368.237915
Department: |  |  |  | 9613
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 146.85 |  |  |  |  | 1977.425002
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 16.00 |  |  |  |  | 217.2
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 0.77 |  |  |  |  | 15.43125
 |  | ZZE056 LOA |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  | ZZE056 Unexcused Absence wo pay |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 163.62 |  |  |  |  | 2210.056252
 | Time Period |  |  |  | 8/07/2011  -  8/13/2011 |  |  |  |  |  |  |  | Data Up To Date |  |  |  |  |  |  |  | 40771.52422453704
 | Query |  |  |  | All Home
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed |  |  |  |  |  |  |  | 8/16/2011  12:35:06PM
 | Actual/Adjusted: |  |  |  | Actual hours only
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed For
 | Pay Codes: |  |  |  | (33): |D0334 Supplies deduction|D0709 Meat Purchase|E001 MEAT SNX Addtl Reg Hours|E001 Reg no ot|E001 Reg no shift prem|...
Department: |  |  |  | 9619
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 638.35 |  |  |  |  | 8458.444998
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 16.00 |  |  |  |  | 210
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 45.93 |  |  |  |  | 924.3825
 |  | ZZE056 LOA |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  | ZZE056 Unexcused Absence wo pay |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 700.28 |  |  |  |  | 9592.827498
Department: |  |  |  | 9625
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 332.68 |  |  |  |  | 4369.859166
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 88.00 |  |  |  |  | 1160.4
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 20.58 |  |  |  |  | 412.72
 |  | ZZE056 Unexcused Absence wo pay |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 441.27 |  |  |  |  | 5942.979166
Department: |  |  |  | 9648
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 79.93 |  |  |  |  | 1135.053333
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 21.57 |  |  |  |  | 459.37
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 101.50 |  |  |  |  | 1594.423333
Department: |  |  |  | 9667
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 717.80 |  |  |  |  | 9576.84333
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 8.00 |  |  |  |  | 103.2
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 47.42 |  |  |  |  | 958.3412500000001
 |  | ZZE056 Unexcused Absence wo pay |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 773.22 |  |  |  |  | 10638.38458
 | Time Period |  |  |  | 8/07/2011  -  8/13/2011 |  |  |  |  |  |  |  | Data Up To Date |  |  |  |  |  |  |  | 40771.52422453704
 | Query |  |  |  | All Home
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed |  |  |  |  |  |  |  | 8/16/2011  12:35:06PM
 | Actual/Adjusted: |  |  |  | Actual hours only
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed For
 | Pay Codes: |  |  |  | (33): |D0334 Supplies deduction|D0709 Meat Purchase|E001 MEAT SNX Addtl Reg Hours|E001 Reg no ot|E001 Reg no shift prem|...
Department: |  |  |  | 9710
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | D0334 Supplies deduction |  |  |  |  |  |  |  | 10 |  |  | 0.00 |  |  |  |  | 10
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 809.98 |  |  |  |  | 10583.364158
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 24.00 |  |  |  |  | 324
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 69.97 |  |  |  |  | 1383.64875
 |  | ZZE002 Vac No OT |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 10 |  |  |  | 903.95 |  |  |  |  | 12301.012908
Department: |  |  |  | 9711
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 663.48 |  |  |  |  | 8426.121667999998
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 8.00 |  |  |  |  | 103.2
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 175.65 |  |  |  |  | 3438.76625
 |  | [NAME] |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 847.13 |  |  |  |  | 11968.087918
Department: |  |  |  | 9712
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 55.25 |  |  |  |  | 729.1999989999999
 |  | E002 VAC [NAME]A |  |  |  |  |  |  |  | 0 |  |  | 40.00 |  |  |  |  | 516
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 8.00 |  |  |  |  | 105.6
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 2.68 |  |  |  |  | 54.37
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 105.93 |  |  |  |  | 1405.169999
Department: |  |  |  | 9713
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 61.00 |  |  |  |  | 828.75
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 4.18 |  |  |  |  | 85.3575
 |  | ZZE002 Vac No OT |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 65.18 |  |  |  |  | 914.1075000000001
 | Time Period |  |  |  | 8/07/2011  -  8/13/2011 |  |  |  |  |  |  |  | Data Up To Date |  |  |  |  |  |  |  | 40771.52422453704
 | Query |  |  |  | All Home
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed |  |  |  |  |  |  |  | 8/16/2011  12:35:06PM
 | Actual/Adjusted: |  |  |  | Actual hours only
 |  |  |  |  |  |  |  |  |  |  |  |  | Printed For
 | Pay Codes: |  |  |  | (33): |D0334 Supplies deduction|D0709 Meat Purchase|E001 MEAT SNX Addtl Reg Hours|E001 Reg no ot|E001 Reg no shift prem|...
Department: |  |  |  | 9719
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 648.00 |  |  |  |  | 8437.200008000003
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 32.00 |  |  |  |  | 425.6
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 137.85 |  |  |  |  | 2686.225
 |  | [NAME] |  |  |  |  |  |  |  | 0 |  |  | 0.00 |  |  |  |  | 0
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 817.85 |  |  |  |  | 11549.025008
Department: |  |  |  | 9748
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 40.00 |  |  |  |  | 568
 |  | E101 OT no shift prem |  |  |  |  |  |  |  | 0 |  |  | 0.13 |  |  |  |  | 2.84
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 40.13 |  |  |  |  | 570.84
Department: |  |  |  | 9767
 |  |  |  |  |  |  |  | Money |  |  |  | Hours |  |  |  | Wages
 |  | E001 Reg no shift prem |  |  |  |  |  |  |  | 0 |  |  | 43.50 |  |  |  |  | 589.2591659999999
 |  | E002 Vac Counts OT and Cons |  |  |  |  |  |  |  | 0 |  |  | 8.00 |  |  |  |  | 106.8
 |  |  |  |  |  | Department Totals: |  |  |  | 0 |  |  |  | 51.50 |  |  |  |  | 696.059166
 |  |  |  |  |  | Grand Totals: |  |  |  | 10 |  |  | 11,432.70 |  |  |  | 156358.44916