Spreadsheet: 52790d1252603132-summing-categories-for-each-month-example-1-
Sheet: pay

 |  |  | Sum of Amount | Category
 |  |  | Invoice Month | 5 Year | Driver | Liquid | Mechanical Repairs | N2 | Odor | Parts | PPE | Service | Testing | Tires | Waste Disposal | Grand Total
 |  |  | 2008-10-01 00:00:00 |  |  | 60.69 | 6416.14 | 1105.82 | 1207.44 | 10273.8 | 240.05 |  |  | 923.8900000000001 |  | 20227.83
 |  |  | 2008-11-01 00:00:00 |  |  | 1610.55 | 1009.32 | 620.03 | 1207.44 | 14746.01 | 202.08 | 794.8399999999999 | 473.86 |  |  | 20664.13
 |  |  | 2008-12-01 00:00:00 |  | 5790.75 | 197.23 | 1380 | 1112.24 | 1609.9 | 12291.168 |  | 400.08 | 773.14 |  |  | 23554.508
 |  |  | 2009-01-01 00:00:00 |  | 676.72 | 521.52 | 2119.99 | 1162.97 | 3219.8 | 14356.13 | 202.81 |  |  |  | 1859.6 | 24119.54
 |  |  | 2009-02-01 00:00:00 | 80697 | 2378 | 1590.87 | 4698.86 | 841.75 | 1609.9 | 7522.82 | 391.17 | 400 |  |  |  | 100130.37
 |  |  | 2009-03-01 00:00:00 | 34305.2 | 629 | 73.12 | 1743.35 | 780.46 | 603.72 | 4687.47 |  |  | 96.84 |  |  | 42919.16
 |  |  | 2009-04-01 00:00:00 |  | 154.75 | 1391.4 | 1576.08 | 1102.43 | 1207.44 | 14110.31 | 188.36 |  | 764.5 | 3782.75 | 1205.6 | 25483.62
 |  |  | 2009-07-01 00:00:00 | 14512.44 | 48 | 1379.4 | 4817.65 | 612.82 |  | 13791.14 | 592.48 | 828.2 | 50 | 3852.76 | 1855.6 | 42340.49
Invoice Month | Amount | Category | 2009-08-09 00:00:00 | 20963 |  |  | 941 |  |  |  |  |  |  |  |  | 21904
2008-10-01 00:00:00 | 2983.48 | Mechanical Repairs | Grand Total | 150477.64 | 9677.220000000001 | 6824.780000000001 | 24702.39 | 7338.52 | 10665.64 | 91778.848 | 1816.95 | 2423.12 | 2158.34 | 8559.400000000001 | 4920.799999999999 | 321343.648
2008-10-01 00:00:00 | 313.74 | Mechanical Repairs
2008-10-01 00:00:00 | 2248.92 | Mechanical Repairs
2008-10-01 00:00:00 | 60 | Mechanical Repairs
2008-10-01 00:00:00 | 120 | Mechanical Repairs
2008-10-01 00:00:00 | 60 | Mechanical Repairs
2008-10-01 00:00:00 | 240 | Mechanical Repairs
2008-10-01 00:00:00 | 390 | Mechanical Repairs
2008-10-01 00:00:00 | 542.07 | Tires
2008-10-01 00:00:00 | 27 | Tires
2008-10-01 00:00:00 | 354.82 | Tires
2008-10-01 00:00:00 | 1021.55 | Parts
2008-10-01 00:00:00 | 1003.71 | Parts
2008-10-01 00:00:00 | 456.29 | Parts
2008-10-01 00:00:00 | 369.13 | Parts
2008-10-01 00:00:00 | 936.93 | Parts
2008-10-01 00:00:00 | 939.44 | Parts
2008-10-01 00:00:00 | 2616.35 | Parts
2008-10-01 00:00:00 | 12.98 | Parts
2008-10-01 00:00:00 | 41.46 | Parts
2008-10-01 00:00:00 | 482.3 | N2
2008-10-01 00:00:00 | 297.69 | N2
2008-10-01 00:00:00 | 325.83 | N2
2008-10-01 00:00:00 | 240.05 | PPE
2008-10-01 00:00:00 | 60.69 | Liquid
2008-10-01 00:00:00 | 1207.44 | Odor
2008-10-01 00:00:00 | 329.49 | Parts
2008-10-01 00:00:00 | 190 | Parts
2008-10-01 00:00:00 | 358.18 | Parts
2008-10-01 00:00:00 | 222.79 | Parts
2008-10-01 00:00:00 | 288.98 | Parts
2008-10-01 00:00:00 | 102.17 | Parts
2008-10-01 00:00:00 | 27.9 | Parts
2008-10-01 00:00:00 | 116.31 | Parts
2008-10-01 00:00:00 | 207.84 | Parts
2008-10-01 00:00:00 | 27.35 | Parts
2008-10-01 00:00:00 | 1004.95 | Parts
2008-11-01 00:00:00 | 38.22 | Parts
2008-11-01 00:00:00 | 396.41 | Testing
2008-11-01 00:00:00 | 269.84 | Service
2008-11-01 00:00:00 | 77.45 | Testing
2008-11-01 00:00:00 | 181.51 | Parts
2008-11-01 00:00:00 | 2297.88 | Parts
2008-11-01 00:00:00 | 7409.28 | Parts
2008-11-01 00:00:00 | 46.17 | Parts
2008-11-01 00:00:00 | 2119.97 | Parts
2008-11-01 00:00:00 | 400 | Service
2008-11-01 00:00:00 | 125 | Service
2008-11-01 00:00:00 | 112.21 | Liquid
2008-11-01 00:00:00 | 1414.4 | Liquid
2008-11-01 00:00:00 | 1775.3 | Parts
2008-11-01 00:00:00 | 620.03 | N2
2008-11-01 00:00:00 | 576.44 | Parts
2008-11-01 00:00:00 | 301.24 | Parts
2008-11-01 00:00:00 | 1207.44 | Odor
2008-11-01 00:00:00 | 202.08 | PPE
2008-11-01 00:00:00 | 83.94 | Liquid
2008-11-01 00:00:00 | 619.32 | Mechanical Repairs
2008-11-01 00:00:00 | 60 | Mechanical Repairs
2008-11-01 00:00:00 | 60 | Mechanical Repairs
2008-11-01 00:00:00 | 30 | Mechanical Repairs
2008-11-01 00:00:00 | 60 | Mechanical Repairs
2008-11-01 00:00:00 | 180 | Mechanical Repairs
2008-12-01 00:00:00 | 269.228 | Parts
2008-12-01 00:00:00 | 1383.28 | Parts
2008-12-01 00:00:00 | 491.46 | Parts
2008-12-01 00:00:00 | 1486.88 | Parts
2008-12-01 00:00:00 | 968.73 | Parts
2008-12-01 00:00:00 | 300.52 | Testing
2008-12-01 00:00:00 | 472.62 | Testing
2008-12-01 00:00:00 | 635.92 | N2
2008-12-01 00:00:00 | 16.24 | N2
2008-12-01 00:00:00 | 460.08 | N2
2008-12-01 00:00:00 | 1148.52 | Parts
2008-12-01 00:00:00 | 107.55 | Parts
2008-12-01 00:00:00 | 157.78 | Parts
2008-12-01 00:00:00 | 164.6 | Parts
2008-12-01 00:00:00 | 424 | Parts
2008-12-01 00:00:00 | 275.76 | Parts
2008-12-01 00:00:00 | 1609.9 | Odor
2008-12-01 00:00:00 | 197.23 | Liquid
2008-12-01 00:00:00 | 400.08 | Service
2008-12-01 00:00:00 | 2171.5 | Parts
2008-12-01 00:00:00 | 2998.03 | Parts
2008-12-01 00:00:00 | 243.85 | Parts
2008-12-01 00:00:00 | 5790.75 | Driver
2008-12-01 00:00:00 | 30 | Mechanical Repairs
2008-12-01 00:00:00 | 120 | Mechanical Repairs
2008-12-01 00:00:00 | 30 | Mechanical Repairs
2008-12-01 00:00:00 | 30 | Mechanical Repairs
2008-12-01 00:00:00 | 390 | Mechanical Repairs
2008-12-01 00:00:00 | 270 | Mechanical Repairs
2008-12-01 00:00:00 | 510 | Mechanical Repairs
2009-01-01 00:00:00 | 1859.6 | Waste Disposal
2009-01-01 00:00:00 | 2883.74 | Parts
2009-01-01 00:00:00 | 307.44 | Liquid
2009-01-01 00:00:00 | 116.72 | Liquid
2009-01-01 00:00:00 | 97.36 | Liquid
2009-01-01 00:00:00 | 1537.7 | Parts
2009-01-01 00:00:00 | 1609.9 | Odor
2009-01-01 00:00:00 | 1609.9 | Odor
2009-01-01 00:00:00 | 168.87 | N2
2009-01-01 00:00:00 | 185.11 | N2
2009-01-01 00:00:00 | 623.88 | N2
2009-01-01 00:00:00 | 185.11 | N2
2009-01-01 00:00:00 | 441.87 | Parts
2009-01-01 00:00:00 | 379.5 | Parts
2009-01-01 00:00:00 | 446.6 | Parts
2009-01-01 00:00:00 | 85.98 | Mechanical Repairs
2009-01-01 00:00:00 | 584.7 | Parts
2009-01-01 00:00:00 | 202.81 | PPE
2009-01-01 00:00:00 | 151.55 | Parts
2009-01-01 00:00:00 | 65.7 | Parts
2009-01-01 00:00:00 | 151.43 | Parts
2009-01-01 00:00:00 | 563.44 | Parts
2009-01-01 00:00:00 | 379.5 | Parts
2009-01-01 00:00:00 | 698.22 | Parts
2009-01-01 00:00:00 | 214.66 | Parts
2009-01-01 00:00:00 | 565.18 | Parts
2009-01-01 00:00:00 | 5292.34 | Parts
2009-01-01 00:00:00 | 82.75 | Driver
2009-01-01 00:00:00 | 411.97 | Driver
2009-01-01 00:00:00 | 20 | Driver
2009-01-01 00:00:00 | 958.28 | Mechanical Repairs
2009-01-01 00:00:00 | 20 | Driver
2009-01-01 00:00:00 | 142 | Driver
2009-01-01 00:00:00 | 60 | Mechanical Repairs
2009-01-01 00:00:00 | 330 | Mechanical Repairs
2009-01-01 00:00:00 | 325.73 | Mechanical Repairs
2009-01-01 00:00:00 | 60 | Mechanical Repairs
2009-01-01 00:00:00 | 240 | Mechanical Repairs
2009-01-01 00:00:00 | 60 | Mechanical Repairs
2009-02-01 00:00:00 | 71820 | 5 Year
2009-02-01 00:00:00 | 8877 | 5 Year
2009-02-01 00:00:00 | 860.82 | Parts
2009-02-01 00:00:00 | 514.57 | Parts
2009-02-01 00:00:00 | 84.37 | Liquid
2009-02-01 00:00:00 | -51.83 | Liquid
2009-02-01 00:00:00 | 1609.9 | Odor
2009-02-01 00:00:00 | 202.81 | PPE
2009-02-01 00:00:00 | 1412.09 | Liquid
2009-02-01 00:00:00 | 400 | Service
2009-02-01 00:00:00 | 2914.68 | Mechanical Repairs
2009-02-01 00:00:00 | 73.12 | Liquid
2009-02-01 00:00:00 | 628.5 | N2
2009-02-01 00:00:00 | 2378 | Driver
2009-02-01 00:00:00 | 179.1 | Mechanical Repairs
2009-02-01 00:00:00 | 411.9 | Parts
2009-02-01 00:00:00 | 861.83 | Parts
2009-02-01 00:00:00 | 1570 | Parts
2009-02-01 00:00:00 | 1143.54 | Parts
2009-02-01 00:00:00 | 379.5 | Parts
2009-02-01 00:00:00 | 11.26 | Parts
2009-02-01 00:00:00 | 151.3 | Parts
2009-02-01 00:00:00 | 158.15 | Parts
2009-02-01 00:00:00 | 56.24 | Parts
2009-02-01 00:00:00 | 704.76 | Parts
2009-02-01 00:00:00 | 188.36 | PPE
2009-02-01 00:00:00 | 213.25 | N2
2009-02-01 00:00:00 | 73.12 | Liquid
2009-02-01 00:00:00 | 698.95 | Parts
2009-02-01 00:00:00 | 1605.08 | Mechanical Repairs
2009-03-01 00:00:00 | 30 | Mechanical Repairs
2009-03-01 00:00:00 | 150 | Mechanical Repairs
2009-03-01 00:00:00 | 120 | Mechanical Repairs
2009-03-01 00:00:00 | 540 | Mechanical Repairs
2009-03-01 00:00:00 | 240 | Mechanical Repairs
2009-03-01 00:00:00 | 60 | Mechanical Repairs
2009-03-01 00:00:00 | 390 | Mechanical Repairs
2009-03-01 00:00:00 | 150 | Mechanical Repairs
2009-03-01 00:00:00 | 629 | Driver
2009-03-01 00:00:00 | 33.31 | Mechanical Repairs
2009-03-01 00:00:00 | 9.14 | Parts
2009-03-01 00:00:00 | 96.84 | Testing
2009-03-01 00:00:00 | 30.04 | Mechanical Repairs
2009-03-01 00:00:00 | 213.25 | N2
2009-03-01 00:00:00 | 567.21 | N2
2009-03-01 00:00:00 | 446.6 | Parts
2009-03-01 00:00:00 | 603.72 | Odor
2009-03-01 00:00:00 | 73.12 | Liquid
2009-03-01 00:00:00 | 698.95 | Parts
2009-03-01 00:00:00 | 1551.69 | Parts
2009-03-01 00:00:00 | 1063.02 | Parts
2009-03-01 00:00:00 | 56.24 | Parts
2009-03-01 00:00:00 | 861.83 | Parts
2009-03-01 00:00:00 | 34305.2 | 5 Year
2009-04-01 00:00:00 | 1207.44 | Odor
2009-04-01 00:00:00 | 757.13 | Parts
2009-04-01 00:00:00 | 604.81 | Parts
2009-04-01 00:00:00 | 188.36 | PPE
2009-04-01 00:00:00 | 1391.4 | Liquid
2009-04-01 00:00:00 | 515.27 | Parts
2009-04-01 00:00:00 | 614.5 | Testing
2009-04-01 00:00:00 | 150 | Testing
2009-04-01 00:00:00 | 570.4 | Parts
2009-04-01 00:00:00 | 344.33 | Parts
2009-04-01 00:00:00 | 187.2 | Parts
2009-04-01 00:00:00 | 414.11 | Parts
2009-04-01 00:00:00 | 202.36 | Parts
2009-04-01 00:00:00 | 402.79 | Parts
2009-04-01 00:00:00 | 134.75 | Driver
2009-04-01 00:00:00 | 536.11 | Parts
2009-04-01 00:00:00 | 297.08 | Parts
2009-04-01 00:00:00 | 20 | Driver
2009-04-01 00:00:00 | 1205.6 | Waste Disposal
2009-04-01 00:00:00 | 446.6 | Parts
2009-04-01 00:00:00 | 703.15 | Parts
2009-04-01 00:00:00 | 446.6 | Parts
2009-04-01 00:00:00 | 584.64 | Parts
2009-04-01 00:00:00 | 823.57 | Parts
2009-04-01 00:00:00 | 125.87 | Parts
2009-04-01 00:00:00 | 454.65 | Parts
2009-04-01 00:00:00 | 1291.55 | Parts
2009-04-01 00:00:00 | 4402.09 | Parts
2009-04-01 00:00:00 | 213.25 | N2
2009-04-01 00:00:00 | 269.54 | N2
2009-04-01 00:00:00 | 619.64 | N2
2009-04-01 00:00:00 | 120 | Mechanical Repairs
2009-04-01 00:00:00 | 180 | Mechanical Repairs
2009-04-01 00:00:00 | 166.08 | Mechanical Repairs
2009-04-01 00:00:00 | 60 | Mechanical Repairs
2009-04-01 00:00:00 | 30 | Mechanical Repairs
2009-04-01 00:00:00 | 240 | Mechanical Repairs
2009-04-01 00:00:00 | 240 | Mechanical Repairs
2009-04-01 00:00:00 | 270 | Mechanical Repairs
2009-04-01 00:00:00 | 270 | Mechanical Repairs
2009-04-01 00:00:00 | 1230.92 | Tires
2009-04-01 00:00:00 | 330.22 | Tires
2009-04-01 00:00:00 | 1290.92 | Tires
2009-04-01 00:00:00 | 930.69 | Tires
2009-07-01 00:00:00 | 851.94 | Parts
2009-07-01 00:00:00 | 30 | Testing
2009-07-01 00:00:00 | 20 | Testing
2009-07-01 00:00:00 | 48 | Driver
2009-07-01 00:00:00 | 256.66 | Parts
2009-07-01 00:00:00 | 389.7 | PPE
2009-07-01 00:00:00 | 139.54 | Parts
2009-07-01 00:00:00 | 460.94 | Parts
2009-07-01 00:00:00 | 612.82 | N2
2009-07-01 00:00:00 | 202.78 | PPE
2009-07-01 00:00:00 | 446.6 | Parts
2009-07-01 00:00:00 | 1238.47 | Parts
2009-07-01 00:00:00 | 173.75 | Parts
2009-07-01 00:00:00 | 60.28 | Parts
2009-07-01 00:00:00 | 1379.4 | Liquid
2009-07-01 00:00:00 | 1925.79 | Parts
2009-07-01 00:00:00 | 5901.63 | Parts
2009-07-01 00:00:00 | 2335.54 | Parts
2009-07-01 00:00:00 | 14512.44 | 5 Year
2009-07-01 00:00:00 | 828.2 | Service
2009-07-01 00:00:00 | 1855.6 | Waste Disposal
2009-07-01 00:00:00 | 45 | Mechanical Repairs
2009-07-01 00:00:00 | 120 | Mechanical Repairs
2009-07-01 00:00:00 | 150 | Mechanical Repairs
2009-07-01 00:00:00 | 2690.78 | Mechanical Repairs
2009-07-01 00:00:00 | 150 | Mechanical Repairs
2009-07-01 00:00:00 | 659.76 | Mechanical Repairs
2009-07-01 00:00:00 | 169.46 | Mechanical Repairs
2009-07-01 00:00:00 | 772.65 | Mechanical Repairs
2009-07-01 00:00:00 | 60 | Mechanical Repairs
2009-07-01 00:00:00 | 2461.84 | Tires
2009-07-01 00:00:00 | 1390.92 | Tires
2009-08-09 00:00:00 | 941 | Mechanical Repairs
2009-08-09 00:00:00 | 20963 | 5 Year