Spreadsheet: 772735d1647447636-summation-of-values-based-on-count-range-suming-payroll
Sheet: Sheet1

Details | Man# | Totals: | January | February | March | Count
(ZCW0075)
B001  BASIC PAY |  |  | 2122.11 | 2122.11 | 2122.11
HT01  LESS THAN FULL SHIFT |  |  | 34 | 27 | 17
I002  LEAVE PAY |  |  | 0 | 0 | 0
I004  PUBLIC HOLIDAY OVERTIME |  |  | 0 | 0 | 0
I016  HOUSING ALLOWANCE |  |  | 636.63 | 636.63 | 636.63
I017  TRANSPORT ALLOWANCE |  |  | 170 | 170 | 170
I018  LUNCH ALLOWANCE |  |  | 140 | 140 | 140
I502  TRANSPORT pro rata |  |  | 0 | 0 | 0
I503  LUNCH pro rata |  |  | 0 | 0 | 0
 | (ZCW0075) | Totals: | if value in 'count column' = 4, sum values in 'january column' into row containing "Totals:" | 3095.74 | 3085.74
(ZCW0079)
B001  BASIC PAY |  |  | 3353.75 | 3353.75 | 3353.75
I002  LEAVE PAY |  |  | 0 | 0 | 0
I004  PUBLIC HOLIDAY OVERTIME |  |  | 186.32 | 0 | 372.64
I016  HOUSING ALLOWANCE |  |  | 1006.12 | 1006.12 | 1006.12
I026  TRANSPORT ALLOWANCE |  |  | 102.4 | 102.4 | 102.4
I502  TRANSPORT pro rata |  |  | 0 | 0 | 0
I503  LUNCH pro rata |  |  | 0 | 0 | 0
I514  LUNCH ALLOWANC |  |  | 120 | 120 | 120
 | (ZCW0079) | Totals: | 0 | 4582.27 | 4954.91
([NAME])
B001  BASIC PAY |  |  | 3732.72 | 3732.72 | 3732.72
I002  LEAVE PAY |  |  | 0 | 0 | 0
I004  PUBLIC HOLIDAY OVERTIME |  |  | 248.85 | 0 | 0
I016  HOUSING ALLOWANCE |  |  | 1119.82 | 1119.82 | 1119.82
I026  TRANSPORT ALLOWANCE |  |  | 102.4 | 102.4 | 102.4
I04A  ABSENTISM ON INCOME |  |  | 0 | 0 | 0
I501  LUN ALLOWANCE |  |  | 0 | 0 | 0
I514  LUNCH ALLOWANC |  |  | 120 | 120 | 120
 | ([NAME]) | Totals: | 0 | 5074.94 | 5074.94
(ZCW0176)
B001  BASIC PAY |  |  | 4606.24 | 4606.24 | 4606.24
I004  PUBLIC HOLIDAY OVERTIME |  |  | 0 | 0 | 307.08
I016  HOUSING ALLOWANCE |  |  | 1169.28 | 1381.87 | 1381.87
I026  TRANSPORT ALLOWANCE |  |  | 86.65 | 102.4 | 102.4
I04A  ABSENTISM ON INCOME |  |  | -708.64 | 0 | 0
I502  TRANSPORT pro rata |  |  | 0 | 0 | 0
I503  LUNCH pro rata |  |  | 0 | 0 | 0
I514  LUNCH ALLOWANC |  |  | 101.54 | 120 | 120
 | (ZCW0176) | Totals: | 0 | 6210.51 | 6517.59
(ZCW0186)
B001  BASIC PAY |  |  | 5991.19 | 5991.19 | 5991.19
I002  LEAVE PAY |  |  | 0 | 0 | 0
I004  PUBLIC HOLIDAY OVERTIME |  |  | 665.69 | 0 | 665.69
I016  HOUSING ALLOWANCE |  |  | 1797.36 | 1797.36 | 1797.36
 | (ZCW0186) | Totals: | 0 | 7788.55 | 8454.24
(ZCW0199)
B001  BASIC PAY |  |  | 2183.65 | 2183.65 | 2183.65
HT01  LESS THAN FULL SHIFT |  |  | 1 | 4 | 1
I002  LEAVE PAY |  |  | 0 | 0 | 0
I004  PUBLIC HOLIDAY OVERTIME |  |  | 218.37 | 0 | 121.31
I016  HOUSING ALLOWANCE |  |  | 655.1 | 655.1 | 655.1
I017  TRANSPORT ALLOWANCE |  |  | 170 | 170 | 170
I018  LUNCH ALLOWANCE |  |  | 140 | 140 | 140
I04A  ABSENTISM ON INCOME |  |  | 0 | 0 | 0
 | (ZCW0199) | Totals: | 0 | 3152.75 | 3271.06
(ZCW0222)
B001  BASIC PAY |  |  | 2183.65 | 2183.65 | 2183.65
HT01  LESS THAN FULL SHIFT |  |  | 2 | 0 | 3
HT02  SHIFT DIFF FULL SHIFT |  |  | 0 | 0 | 0
I002  LEAVE PAY |  |  | 0 | 0 | 0
I004  PUBLIC HOLIDAY OVERTIME |  |  | 0 | 0 | 242.63
I016  HOUSING ALLOWANCE |  |  | 655.1 | 655.1 | 655.1
I017  TRANSPORT ALLOWANCE |  |  | 170 | 170 | 170
I018  LUNCH ALLOWANCE |  |  | 140 | 140 | 140
I04A  ABSENTISM ON INCOME |  |  | 0 | 0 | 0
I502  TRANSPORT pro rata |  |  | 0 | 0 | 0
I503  LUNCH pro rata |  |  | 0 | 0 | 0
 | (ZCW0222) | Totals: | 0 | 3148.75 | 3394.38
(ZCW0223)
B001  BASIC PAY |  |  | 1400.18 | 1400.18 | 1400.18
I004  PUBLIC HOLIDAY OVERTIME |  |  | 62.23 | 0 | 140.02
I016  HOUSING ALLOWANCE |  |  | 420.05 | 420.05 | 420.05
I017  TRANSPORT ALLOWANCE |  |  | 170 | 170 | 170
I018  LUNCH ALLOWANCE |  |  | 140 | 140 | 140
I502  TRANSPORT pro rata |  |  | 0 | 0 | 0
I503  LUNCH pro rata |  |  | 0 | 0 | 0
 | (ZCW0223) | Totals: | 0 | 2130.23 | 2270.25
([NAME])
B001  BASIC PAY |  |  | 1851.93 | 1884.42 | 1581.18
HT01  LESS THAN FULL SHIFT |  |  | 19 | 15 | 18
I019  HOUSING ALLOWANCE PT |  |  | 555.58 | 565.33 | 474.35
I105  Transport Allowance Pt |  |  | 148.77 | 151.38 | 127.02
I106  Lunch Allowance Pt |  |  | 121.41 | 123.54 | 103.66
 | ([NAME]) | Totals: | 0 | 2739.67 | 2304.21
([NAME])
B001  BASIC PAY |  |  | 3803.16 | 3803.16 | 3803.16
I002  LEAVE PAY |  |  | 0 | 0 | 0
I004  PUBLIC HOLIDAY OVERTIME |  |  | 211.29 | 0 | 0
I016  HOUSING ALLOWANCE |  |  | 1140.95 | 1140.95 | 1140.95
I026  TRANSPORT ALLOWANCE |  |  | 102.4 | 102.4 | 102.4
I502  TRANSPORT pro rata |  |  | 0 | 0 | 0
I503  LUNCH pro rata |  |  | 0 | 0 | 0
I514  LUNCH ALLOWANC |  |  | 120 | 120 | 120
 | ([NAME]) | Totals: | 0 | 5166.51 | 5166.51
(ZCW0358)
B001  BASIC PAY |  |  | 2183.65 | 0 | 0
I002  LEAVE PAY |  |  | 0 | 167.97 | 0
I004  PUBLIC HOLIDAY OVERTIME |  |  | 121.31 | 0 | 0
I016  HOUSING ALLOWANCE |  |  | 655.1 | 0 | 0
I017  TRANSPORT ALLOWANCE |  |  | 170 | 0 | 0
I018  LUNCH ALLOWANCE |  |  | 140 | 0 | 0
I04A  ABSENTISM ON INCOME |  |  | 0 | -923.89 | 0
 | (ZCW0358) | Totals: | 0 | -755.92 | 0
(ZCW0376)
B001  BASIC PAY |  |  | 2122.11 | 2122.11 | 342.28
HT01  LESS THAN FULL SHIFT |  |  | 16 | 13 | 9
I002  LEAVE PAY |  |  | 0 | 0 | 26.12
I004  PUBLIC HOLIDAY OVERTIME |  |  | 306.53 | 0 | 0
I016  HOUSING ALLOWANCE |  |  | 636.63 | 636.63 | 102.68
I017  TRANSPORT ALLOWANCE |  |  | 170 | 170 | 0
I018  LUNCH ALLOWANCE |  |  | 140 | 140 | 0
I502  TRANSPORT pro rata |  |  | 0 | 0 | 26.15
I503  LUNCH pro rata |  |  | 0 | 0 | 21.54
 | (ZCW0376) | Totals: | 0 | 3081.74 | 527.77
(ZCW0383)
B001  BASIC PAY |  |  | 2596.6 | 2596.6 | 2596.6
HT01  LESS THAN FULL SHIFT |  |  | 5 | 0 | 3
I002  LEAVE PAY |  |  | 0 | 0 | 0
I004  PUBLIC HOLIDAY OVERTIME |  |  | 0 | 0 | 288.51
I016  HOUSING ALLOWANCE |  |  | 778.98 | 778.98 | 778.98
I017  TRANSPORT ALLOWANCE |  |  | 170 | 170 | 170
I018  LUNCH ALLOWANCE |  |  | 140 | 140 | 140
I026  TRANSPORT ALLOWANCE |  |  | 0 | 0 | 0
I514  LUNCH ALLOWANC |  |  | 0 | 0 | 0
 | (ZCW0383) | Totals: | 0 | 3685.58 | 3977.09
([NAME])
B001  BASIC PAY |  |  | 1288 | 1288 | 0
I004  PUBLIC HOLIDAY OVERTIME |  |  | 157.42 | 0 | 0
I016  HOUSING ALLOWANCE |  |  | 386.4 | 148.62 | 0
I017  TRANSPORT ALLOWANCE |  |  | 170 | 65.38 | 0
I018  LUNCH ALLOWANCE |  |  | 140 | 53.85 | 0
I04A  ABSENTISM ON INCOME |  |  | 0 | -792.64 | 0
 | ([NAME]) | Totals: | 0 | 763.21 | 0