Spreadsheet: 694308d1599507312-copy-and-paste-formulas-to-go-from-left-to-right-uploadexcel090720
Sheet: PIVOT_EXPENSE

Sum of Row Data | Column Labels
 | 2013 |  |  |  |  |  | 2014 |  |  |  |  |  | Grand Total
 | Qtr3 |  |  | Qtr4 |  |  | Qtr1 |  |  | Qtr2
Row Labels | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun
Expenses | 52069296.53148775 | 56356022.49582963 | 59295576.71597917 | 66035336.61427652 | 67301229.22938971 | 45097398.69576561 | 50066355.56251733 | 52092554.92843205 | 53070431.59746489 | 50396563.73215085 | 58204762.95956457 | 46450165.47207983 | 656435694.5349379
Jutik | 18463152.21877677 | 14945711.67012401 | 19800908.80112004 | 16682046.83286329 | 14443688.17568063 | 11673111.69665018 | 13454628.92131284 | 12890276.55182166 | 16214825.32567578 | 10925297.26456683 | 13415319.13418112 | 18867748.80629327 | 181776715.3990664
Cost Centre | 18463152.21877677 | 14945711.67012401 | 19800908.80112004 | 16682046.83286329 | 14443688.17568063 | 11673111.69665018 | 13454628.92131284 | 12890276.55182166 | 16214825.32567578 | 10925297.26456683 | 13415319.13418112 | 18867748.80629327 | 181776715.3990664
Financial Actual | 8168998.58029242 | 6508016.272957679 | 8797296.020146918 | 7399801.664999639 | 6292597.87327509 | 5862551.4695475 | 7198677.8148285 | 7481708.951167749 | 8690888.616535125 | 6732277.631081 | 8110761.1219655 | 9479913.263008501 | 90723489.27980563
Financial Budget | 10294153.63848435 | 8437695.397166332 | 11003612.78097313 | 9282245.167863648 | 8151090.302405542 | 5810560.227102676 | 6255951.106484336 | 5408567.600653912 | 7523936.709140656 | 4193019.633485826 | 5304558.012215622 | 9387835.54328477 | 91053226.11926079
Kootha | 7559876.635031676 | 10499089.81223506 | 8260899.853567767 | 7792164.967294017 | 7956137.344827306 | 7694784.544562138 | 10490367.3522147 | 8710668.446800804 | 8819914.13248464 | 8912447.452889152 | 9412798.213366484 | 10643892.71130434 | 106753041.4665781
Cost Centre | 7559876.635031676 | 10499089.81223506 | 8260899.853567767 | 7792164.967294017 | 7956137.344827306 | 7694784.544562138 | 10490367.3522147 | 8710668.446800804 | 8819914.13248464 | 8912447.452889152 | 9412798.213366484 | 10643892.71130434 | 106753041.4665781
Financial Actual | 3458288.870133865 | 4778353.352101625 | 3741007.062766114 | 3550828.794550875 | 3646543.42684625 | 3507223.3581475 | 5249820.349499999 | 4419792.682312501 | 4409725.4715 | 4419304.31840625 | 4692799.18359375 | 5350137.22246875 | 51223824.09232748
Financial Budget | 4101587.764897812 | 5720736.460133431 | 4519892.790801653 | 4241336.172743142 | 4309593.917981056 | 4187561.186414638 | 5240547.002714699 | 4290875.764488303 | 4410188.66098464 | 4493143.134482901 | 4719999.029772734 | 5293755.488835588 | 55529217.3742506
Surjek | 26046267.6776793 | 30911221.01347056 | 31233768.06129136 | 41561124.81411922 | 44901403.70888177 | 25729502.45455329 | 26121359.2889898 | 30491609.92980959 | 28035692.13930447 | 30558819.01469487 | 35376645.61201696 | 16938523.95448223 | 367905937.6692934
Cost Centre | 26046267.6776793 | 30911221.01347056 | 31233768.06129136 | 41561124.81411922 | 44901403.70888177 | 25729502.45455329 | 26121359.2889898 | 30491609.92980959 | 28035692.13930447 | 30558819.01469487 | 35376645.61201696 | 16938523.95448223 | 367905937.6692934
Financial Actual | 11339551.17038621 | 13660880.3343936 | 13806947.68028083 | 18511924.38233108 | 20025365.08924089 | 12958942.6435392 | 13987466.3230764 | 16468493.1567156 | 15013580.5802136 | 16135503.0540396 | 18921373.302216 | 8489071.3235328 | 179319099.0399658
Financial Budget | 14706716.50729309 | 17250340.67907696 | 17426820.38101052 | 23049200.43178814 | 24876038.61964088 | 12770559.81101409 | 12133892.9659134 | 14023116.77309398 | 13022111.55909086 | 14423315.96065527 | 16455272.30980096 | 8449452.630949426 | 188586838.6293276
None | 1265.288562 | 1235.767394 | 1202.09117 | 1276.34187 | 1095.479952 | 1137.7122586 | 1333.52897 | 1354.802976 | 1460.905781 | 1390.978332 | 1356.395866 | 1174.010402 | 15283.3035336
Jutik | 484.483982 | 410.481406 | 393.470922 | 350.739132 | 410.1821 | 287.6782326 | 418.404994 | 428.860398 | 372.796417 | 354.882272 | 357.814738 | 360.760668 | 4630.5552616
None | 484.483982 | 410.481406 | 393.470922 | 350.739132 | 410.1821 | 287.6782326 | 418.404994 | 428.860398 | 372.796417 | 354.882272 | 357.814738 | 360.760668 | 4630.5552616
Water Production Actuals | 250.241991 | 206.740703 | 201.235461 | 174.369566 | 204.09105 | 146.356666 | 204.202497 | 217.430199 | 230.9822 | 236.441136 | 241.407369 | 220.380334 | 2533.879171999999
Water Production Budget | 234.241991 | 203.740703 | 192.235461 | 176.369566 | 206.09105 | 141.3215666 | 214.202497 | 211.430199 | 141.814217 | 118.441136 | 116.407369 | 140.380334 | 2096.6760896
Kootha | 353.866582 | 372.887886 | 371.547314 | 382.082186 | 193.192124 | 369.613706 | 368.802878 | 308.17353 | 372.807352 | 342.115728 | 334.573998 | 292.017434 | 4061.680718
None | 353.866582 | 372.887886 | 371.547314 | 382.082186 | 193.192124 | 369.613706 | 368.802878 | 308.17353 | 372.807352 | 342.115728 | 334.573998 | 292.017434 | 4061.680718
Water Production Actuals | 181.933291 | 187.443943 | 184.773657 | 191.541093 | 98.096062 | 185.306853 | 186.901439 | 158.586765 | 191.403676 | 171.057864 | 169.286999 | 142.508717 | 2048.840359
Water Production Budget | 171.933291 | 185.443943 | 186.773657 | 190.541093 | 95.096062 | 184.306853 | 181.901439 | 149.586765 | 181.403676 | 171.057864 | 165.286999 | 149.508717 | 2012.840359
Surjek | 426.937998 | 452.398102 | 437.072934 | 543.520552 | 492.105728 | 480.42032 | 546.321098 | 617.769048 | 715.3020120000001 | 693.980332 | 664.00713 | 521.2323 | 6591.067554
None | 426.937998 | 452.398102 | 437.072934 | 543.520552 | 492.105728 | 480.42032 | 546.321098 | 617.769048 | 715.3020120000001 | 693.980332 | 664.00713 | 521.2323 | 6591.067554
Water Production Actuals | 214.968999 | 228.199051 | 216.536467 | 236.760276 | 232.052864 | 240.21016 | 288.160549 | 306.884524 | 367.6510060000001 | 351.990166 | 362.822 | 260.3123 | 3306.548362
Water Production Budget | 211.968999 | 224.199051 | 220.536467 | 306.760276 | 260.052864 | 240.21016 | 258.160549 | 310.884524 | 347.651006 | 341.990166 | 301.18513 | 260.92 | 3284.519192
Grand Total | 52070561.82004975 | 56357258.26322363 | 59296778.80714916 | 66036612.95614652 | 67302324.70934172 | 45098536.4080242 | 50067689.09148733 | 52093909.73140804 | 53071892.50324589 | 50397954.71048287 | 58206119.35543058 | 46451339.48248182 | 656450977.8384714