Spreadsheet: 50692d1250170103-how-to-summarise-the-worksheet-in-a-quicker-way-book-11
Sheet: Summ(source2)

 | Act |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Act | Act | Act | Act | Act | Act | Act | Budget | Budget | Budget | Budget | Budget
COST | 2008-01-31 00:00:00 | 2008-02-28 00:00:00 | 2008-03-31 00:00:00 | 2008-04-30 00:00:00 | 2008-05-31 00:00:00 | 2008-06-30 00:00:00 | 2008-07-31 00:00:00 | 2008-08-31 00:00:00 | 2008-09-30 00:00:00 | 2008-10-31 00:00:00 | 2008-11-30 00:00:00 | 2008-12-31 00:00:00 | Total |  | Var. |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 2009-02-28 00:00:00 | 2009-03-27 00:00:00 | 2009-04-24 00:00:00 | 2009-05-22 00:00:00 | 2009-06-19 00:00:00 | 2009-07-17 00:00:00 | 2009-08-14 00:00:00 | 2009-09-11 00:00:00 | 2009-10-09 00:00:00 | 2009-11-06 00:00:00 | 2009-12-04 00:00:00
CENTRE | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual |  |  | (BND'000)
NO | 140984.8 | 133883.451896701 | 139517.801896701 | 145117.7400933676 | 145373.8607600343 | 142373.8607600343 | 141293.775826701 | 141134.025826701 | 141134.025826701 | 141367.9861409139 | 141367.9861409139 | 141367.9861409139
ABC1 | 75163.98 | 75380.34890777778 | 75380.34890777778 | 80222.45224777775 | 80222.45224777775 | 80222.45224777775 | 80437.3522477778 | 80437.3522477778 | 80437.3522477778 | 80673.25224777777 | 80673.25224777777 | 80673.25224777777 | 949923.8480455556 |  | 594855.84 |  |  |  |  |  |  |  |  |  |  |  |  |  | 74374.16 | 71050.25 | 75551.56 | 78567.65 | 74624.03 | 76795.98 | 76795.98 | 81228.09119284351 | 81388.08119284351 | 78799.73169284352 | 78959.72169284351 | 78799.73169284352
[NAME] | 22105.85 | 27659.02076157894 | 28014.72076157894 | 28498.50576157895 | 28498.50576157895 | 28498.50576157895 | 29777.50576157894 | 29777.50576157894 | 29777.50576157894 | 29777.50576157894 | 29777.50576157894 | 29777.50576157894 | 341940.1433773683 |  | 261745.78 |  |  |  |  |  |  |  |  |  |  |  |  |  | 35766.56 | 33985.99 | 34306.68 | 35176.11 | 35318.49 | 32360.9 | 32360.9 | 36489.84933333333 | 36489.84933333333 | 36489.84933333333 | 36489.84933333333 | 36489.84933333333
ABC3 | 65820.82 | 58503.10298892322 | 64137.45298892321 | 64895.28784558988 | 65151.40851225654 | 62151.40851225654 | 60856.42357892321 | 60696.67357892321 | 60696.67357892321 | 60694.73389313613 | 60694.73389313613 | 60694.73389313613 | 744993.4532641275 |  | 579927.65 |  |  |  |  |  |  |  |  |  |  |  |  |  | 68100.54 | 36275.94 | 50309.07 | 67038.5 | 73130.05 | 74181.07 | 74181.07 | 123169.0661237326 | 69681.72012373261 | 69523.5061237326 | 69613.5665617326 | 70028.86612373259
[NAME] | 19342.1 | 23381.0786710378 | 23381.0786710378 | 23381.0786710378 | 23381.0786710378 | 23381.0786710378 | 22782.22366021737 | 22782.22366021737 | 22782.22366021737 | 22782.22366021737 | 22782.22366021737 | 22782.22366021737 | 272940.8353164932 |  | 453900.6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9247.8 | 17450.7 | 23196.6 | 24721.3 | 25591.9 | 32380.7 | 32380.7 | 24471.28333333333 | 25641.38055555556 | 20048.84398148148 | 19270.10131172839 | 18216.46819701646
ABC5 | 5657 | 21437.6910091952 | 21437.6910091952 | 21437.6910091952 | 21437.6910091952 | 21437.6910091952 | 21687.29520055067 | 21687.29520055067 | 21687.29520055067 | 21687.29520055067 | 21687.29520055067 | 21687.29520055067 | 242969.22624928 |  | 314657.6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9789.7 | 13318.4 | 22784.1 | 9758.7 | 16863.07 | 16568.5 | 16568.5 | 14905.795 | 15162.86083333333 | 13885.15430555555 | 14565.39668981482 | 14174.95113811728
ABC6 | 2695.7 | 2644.571657060708 | 2644.571657060708 | 2644.571657060708 | 2644.571657060708 | 2644.571657060708 | 2644.571657060708 | 2644.571657060708 | 2644.571657060708 | 2644.571657060708 | 2644.571657060708 | 2644.571657060708 | 31785.98822766779 |  | 61485.31 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11364.52 | 5738.2 | -221.2 | 2651.75 | 770 | 515 | 515 | 1878.958333333333 | 1235.751388888889 | 1478.576620370371 | 1283.047723765432 | 1368.555677726337
ABC7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2764.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1419 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ABC8 | 1115 | 51.1440618917873 | 51.1440618917873 | 51.1440618917873 | 51.1440618917873 | 51.1440618917873 | 51.1440618917873 | 51.1440618917873 | 51.1440618917873 | 51.1440618917873 | 51.1440618917873 | 51.1440618917873 | 1677.58468080966 |  | 6777.25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 110 | 0 | 2759 | 0 | 0 | 481.8055555555555 | 562.1064814814814 | 637.4575617283949 | 743.7004886831274 | 407.8172367969821
ABC9 | 10351.58 | 15348.38771929825 | 18105.18771929825 | 18244.50971929824 | 19504.50971929824 | 19504.50971929824 | 20764.50971929824 | 20764.50971929824 | 20764.50971929824 | 23284.50971929824 | 24544.50971929824 | 24544.50971929824 | 235725.7429122807 |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | 6724.65 | 7984.65 | 7984.65 | 8194.65 | 8080.65 | 8219.65 | 8219.65 | 8904.1275 | 8904.1275 | 10164.1275 | 10164.1275 | 10164.1275
ABC10 | -74468.3 | 2701.277056666666 | 2701.277056666666 | 2701.277056666666 | 2701.277056666666 | 2701.277056666666 | 2701.277056666666 | 2701.277056666666 | 2701.277056666666 | 2701.277056666666 | 2701.277056666666 | 2701.277056666666 | -44754.25237666667 |  | 235108.59 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17615.27 | 16352.19 | 20543.38 | 105182.52 | -23300.77 | 9402.59 | 9402.59 | -35109.76262633453 | -49140.79262633454 | 3749.517373665457 | 3749.517373665458 | 3749.517373665457
ABC11 | -61361.42 | 13126.19385964912 | 13126.19385964912 | 13412.99385964912 | 13412.99385964912 | 13412.99385964912 | 13412.99385964912 | 13412.99385964912 | 13412.99385964912 | 13412.99385964912 | 13412.99385964912 | 13412.99385964912 | 85607.91245614033 |  | 185528.07 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21455.07 | 46677.82 | 52747.41 | 8940.71 | 23819.64 | 31530 | 31530 | 26349.7852106823 | 21686.88921068231 | 24210.78921068231 | 21710.78921068231 | 21710.78921068231
ABC12 | 73398.46 | 79854.05871917497 | 82322.058719175 | 82845.46171917499 | 79826.011719175 | 83902.511719175 | 86921.96171917499 | 84410.801719175 | 84647.60171917499 | 87148.86536311849 | 87148.86536311849 | 87148.86536311849 | 999575.5238427554 |  | 781709.71 |  |  |  |  |  |  |  |  |  |  |  |  |  | 89021.65 | 82042.78 | 85160.37 | 103497.58 | 84405.28 | 91368.43 | 91368.43 | 84677.13057142857 | 84677.13057142857 | 85133.14007142858 | 85133.14007142858 | 85133.14007142858
ABC13 | 32083.96 | 33343.50315789474 | 33343.50315789474 | 33766.02215789475 | 33766.02215789475 | 33766.02215789475 | 33766.02215789475 | 33766.02215789475 | 33766.02215789475 | 33766.02215789475 | 33766.02215789475 | 33766.02215789475 | 402665.1657368421 |  | 557849.17 |  |  |  |  |  |  |  |  |  |  |  |  |  | 35509.22 | 38080.16 | 36223.09 | 36443.19 | 36369.65 | 27330.62 | 27330.62 | 37512.33800000001 | 37512.33800000001 | 37757.91050000001 | 37757.91050000001 | 37757.91050000001
ABC14 | 57381.23 | 55424.6152706775 | 55424.6152706775 | 56487.9212706775 | 56487.9212706775 | 59566.32127067749 | 59803.12127067749 | 59803.12127067749 | 59803.12127067749 | 60012.61722431758 | 60012.61722431758 | 60012.61722431758 | 700219.8398383728 |  | 688868.12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 77525.67 | 73724.87 | 62656.87 | 73777.81 | 71309.37 | 73167.27 | 73167.27 | 90606.48798666667 | 93454.98798666667 | 99725.99465333336 | 99667.68465333336 | 99667.68465333336
ABC15 | 16338.49 | 18504.65475894736 | 18504.65475894736 | 18718.06643894736 | 18718.06643894736 | 18718.06643894736 | 17510.56643894736 | 17510.56643894736 | 17510.56643894736 | 17510.56643894736 | 17510.56643894736 | 17510.56643894736 | 214565.397468421 |  | 176131.12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12582.13 | 12059.92 | 12464.86 | 12708.36 | 13297.71 | 12958.55 | 12958.55 | 9450.151666666665 | 9450.151666666665 | 9517.071666666667 | 9517.071666666667 | 11806.07166666667
ABC16 | 36770.15 | 32469.08826502926 | 32469.08826502926 | 32797.92506502925 | 32797.92506502925 | 32797.92506502925 | 32797.92506502925 | 32797.92506502925 | 32797.92506502925 | 32797.92506502925 | 32797.92506502925 | 32797.92506502925 | 396889.6521153217 |  | 292058.93 |  |  |  |  |  |  |  |  |  |  |  |  |  | 34804.44 | 36431.26 | 33326.66 | 33265.88 | 32544.22 | 32602.84 | 32602.84 | 39716.29488888889 | 39716.29488888889 | 39819.9252888889 | 39819.9252888889 | 39819.9252888889
ABC17 | 91856.25 | 95459.4114276207 | 90101.93642762069 | 91869.1100676207 | 91869.1100676207 | 94666.24756762071 | 94666.24756762071 | 94666.24756762071 | 94666.24756762071 | 94658.3304827755 | 94658.3304827755 | 94658.3304827755 | 1123795.799709292 |  | 901974.95 |  |  |  |  |  |  |  |  |  |  |  |  |  | 127134.4 | 129402.92 | 108775.5 | 112186.83 | 111441.31 | 193752.14 | 193752.14 | 141824.39344 | 144324.39344 | 142707.47576 | 142457.47576 | 142457.4757599999
ABC18 | 13906.73 | 18290.84400544953 | 18290.84400544953 | 18465.26240544953 | 18465.26240544953 | 18465.26240544953 | 18465.26240544953 | 18465.26240544953 | 18465.26240544953 | 18463.32271966245 | 18463.32271966245 | 18463.32271966245 | 216669.9606025836 |  | 117615.86 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14131.53 | 9715.7 | 21034.62 | 11616.69 | 12339.14 | 12011.14 | 12011.14 | 14091.22 | 14091.22 | 14160.1715 | 14160.1715 | 14160.1715
ABC19 | 70285.78 | 75443.75933606763 | 75799.45933606764 | 77740.34807606763 | 77740.34807606763 | 77740.34807606763 | 77740.34807606763 | 77740.34807606763 | 77740.34807606763 | 77734.50922599429 | 77734.50922599429 | 77734.50922599429 | 921174.614806524 |  | 636823.43 |  |  |  |  |  |  |  |  |  |  |  |  |  | 57628.53 | 58140.32 | 68266.97 | 56514.24 | 57796.71 | 47910.88 | 47910.88 | 60149.51549999999 | 62899.51549999999 | 60832.56122499998 | 60582.56122499998 | 61082.56122499998
ABC20 | 38207.09 | 47127.15350877192 | 47127.15350877192 | 47356.34510877191 | 47356.34510877191 | 47356.34510877191 | 47356.34510877191 | 47356.34510877191 | 47356.34510877191 | 47093.34510877191 | 47093.34510877191 | 47093.34510877191 | 557879.5029964912 |  | 284269.18 |  |  |  |  |  |  |  |  |  |  |  |  |  | 48795.31 | 49454.85 | 62547.29 | 63221.78 | 52571.38 | 56670.44 | 56670.44 | 54356.52134008233 | 61283.18134008234 | 54429.56884008233 | 54429.56884008234 | 54429.56884008234
 | 2279654.1 | 1884890.216004407 | 1921576.891004407 | 1929546.901972073 | 1922688.87263874 | 1929640.91013874 | 1932191.324385941 | 1929757.214385942 | 1934994.014385942 | 1958208.996991914 | 1959468.996991914 | 1961640.096991915 | 23558632.86589193 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 751571.1500000001 | 2800666.884699248 | 2751567.915300752 | 2731370.096906546 | 2513724.106906546 | 829726.7 | 829726.7 | 815153.0523502125 | 759021.1873872497 | 803071.3732087928 | 800075.3273916488 | 801425.1829893141