Spreadsheet: 50692d1250170103-how-to-summarise-the-worksheet-in-a-quicker-way-book-11
Sheet: Summary

 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Budget | Budget | Budget | Budget | Budget
ABC1 | 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 | Total (ACTUAL)
TFR OUT 1 | 5363.767500000001 | 11669.455 | 13186.8525 | 2235.1775 | 5954.91 | 7882.5 | 6353 | 6587.446302670576 | 5421.722302670578 | 6052.697302670578 | 5427.697302670578 | 5427.697302670578 | 52645.66250000001
TFR OUT 2 | 5363.767500000001 | 11669.455 | 13186.8525 | 2235.1775 | 5954.91 | 7882.5 | 6353 | 6587.446302670576 | 5421.722302670578 | 6052.697302670578 | 5427.697302670578 | 5427.697302670578 | 52645.66250000001
TFR OUT 3 | 5363.767500000001 | 11669.455 | 13186.8525 | 2235.1775 | 5954.91 | 7882.5 | 6353 | 6587.446302670576 | 5421.722302670578 | 6052.697302670578 | 5427.697302670578 | 5427.697302670578 | 52645.66250000001
TFR OUT 4 | 5363.767500000001 | 11669.455 | 13186.8525 | 2235.1775 | 5954.91 | 7882.5 | 6353 | 6587.446302670576 | 5421.722302670578 | 6052.697302670578 | 5427.697302670578 | 5427.697302670578 | 52645.66250000001
TFR OUT 5 | 5363.767500000001 | 11669.455 | 13186.8525 | 2235.1775 | 5954.91 | 7882.5 | 6353 | 6587.446302670576 | 5421.722302670578 | 6052.697302670578 | 5427.697302670578 | 5427.697302670578 | 52645.66250000001
Total | 26818.83750000001 | 58347.275 | 65934.26250000001 | 11175.8875 | 29774.55 | 39412.5 | 31765 | 32937.23151335288 | 27108.61151335289 | 30263.48651335289 | 27138.48651335289 | 27138.48651335289 | 263228.3125
Wksht: [NAME] | 74374.16 | 65361.13 | 62692.35000000001 | 63967.02 | 71381.45 | 67056.36 | 70908.80000000002 | 74929.13620000001 | 74929.13620000001 | 71463.63620000001 | 71463.63620000001 | 71463.63620000001
Difference | -47555.32249999999 | -7013.855000000003 | 3241.912500000006 | -52791.1325 | -41606.89999999999 | -27643.86 | -39143.80000000002 | -41991.90468664713 | -47820.52468664712 | -41200.14968664711 | -44325.14968664711 | -44325.14968664711
 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Budget | Budget | Budget | Budget | Budget
[NAME] | 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 | Total (ACTUAL)
TFR OUT 1 | 1672.44283758862 | 1791.168519145175 | 1724.537400871348 | 2278.316071979638 | 1719.623746534173 | 2382.750881261954 | 2765.567794286049 | 2782.479020145217 | 4747.940755015191 | 2801.033961653256 | 2801.033961653256 | 2801.033961653256 | 0
TFR OUT 2 | 1672.44283758862 | 1791.168519145175 | 1724.537400871348 | 2278.316071979638 | 1719.623746534173 | 2382.750881261954 | 2765.567794286049 | 2782.479020145217 | 4747.940755015191 | 2801.033961653256 | 2801.033961653256 | 2801.033961653256 | 0
TFR OUT 3 | 1672.44283758862 | 1791.168519145175 | 1724.537400871348 | 2278.316071979638 | 1719.623746534173 | 2382.750881261954 | 2765.567794286049 | 2782.479020145217 | 4747.940755015191 | 2801.033961653256 | 2801.033961653256 | 2801.033961653256 | 0
TFR OUT 4 | 1672.44283758862 | 1791.168519145175 | 1724.537400871348 | 2278.316071979638 | 1719.623746534173 | 2382.750881261954 | 2765.567794286049 | 2782.479020145217 | 4747.940755015191 | 2801.033961653256 | 2801.033961653256 | 2801.033961653256 | 0
TFR OUT 5 | 1672.44283758862 | 1791.168519145175 | 1724.537400871348 | 2278.316071979638 | 1719.623746534173 | 2382.750881261954 | 2765.567794286049 | 2782.479020145217 | 4747.940755015191 | 2801.033961653256 | 2801.033961653256 | 2801.033961653256 | 0
Total | 8362.214187943098 | 8955.842595725877 | 8622.687004356741 | 11391.58035989819 | 8598.118732670866 | 11913.75440630977 | 13827.83897143025 | 13912.39510072608 | 23739.70377507596 | 14005.16980826628 | 14005.16980826628 | 14005.16980826628 | 0
Wksht: [NAME] | 35766.56 | 33985.99 | 34306.68 | 35176.11 | 35318.49 | 32360.9 | 32360.9 | 36489.84933333333 | 36489.84933333333 | 36489.84933333333 | 36489.84933333333 | 36489.84933333333
Difference | -27404.3458120569 | -25030.14740427412 | -25683.99299564326 | -23784.52964010181 | -26720.37126732913 | -20447.14559369023 | -18533.06102856975 | -22577.45423260725 | -12750.14555825738 | -22484.67952506705 | -22484.67952506705 | -22484.67952506705
 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Budget | Budget | Budget | Budget | Budget | Total (ACTUAL)
ABC3 & ABC 4 | 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 | Total
TFR OUT 1 |  |  |  |  |  |  |  |  |  |  |  |  | 0
TFR OUT 2 |  |  |  |  |  |  |  |  |  |  |  |  | 0
TFR OUT 3 |  |  |  |  |  |  |  |  |  |  |  |  | 0
TFR OUT 4 |  |  |  |  |  |  |  |  |  |  |  |  | 0
TFR OUT 5 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Wksht: [NAME] | 77348.34 | 53726.64 | 73505.67 | 91759.8 | 98721.95000000001 | 106561.77 | 106561.77 | 147640.3494570659 | 95323.10067928817 | 89572.35010521408 | 88883.66787346099 | 88245.33432074904
Difference | -77348.34 | -53726.64 | -73505.67 | -91759.8 | -98721.95000000001 | -106561.77 | -106561.77 | -147640.3494570659 | -95323.10067928817 | -89572.35010521408 | -88883.66787346099 | -88245.33432074904