Spreadsheet: 92974d1292491518-month-wise-datas-change-if-the-common-factor-change-power
Sheet: 2009-2010

 | Particulars | 2009-04-01 00:00:00 |  |  | 2009-05-01 00:00:00 |  |  | 2009-06-01 00:00:00 |  |  | 2009-07-01 00:00:00 |  |  | 2009-08-01 00:00:00 |  |  | 2009-09-01 00:00:00 |  |  | 2009-10-01 00:00:00 |  |  | 2009-11-01 00:00:00 |  |  | 2009-12-01 00:00:00 |  |  | 2010-01-01 00:00:00 |  |  | 2010-02-01 00:00:00 |  |  | 2010-03-01 00:00:00 |  |  | YTD-2009-2010 |  |  | Co.as a whole
 |  | HHD | HHG | HHH | HHD | HHG | HHH | HHD | HHG | HHH | HHD | HHG | HHH | HHD | HHG | HHH | HHD | HHG | HHH | HHD | HHG | HHH | HHD | HHG | HHH | HHD | HHG | HHH | HHD | HHG | HHH | HHD | HHG | HHH | HHD | HHG | HHH | HHD | HHG | HHH | YTD
 | Production (Nos) | 129671 | 132154 | 103228 | 140266 | 135181 | 107472 | 128408 | 128484 | 108153 | 142893 | 143253 | 107385 | 135624 | 141029 | 120875 | 136428 | 135462 | 119570 | 125081 | 113215 | 115253 | 134689 | 129579 | 119776 | 120275 | 118113 | 134844 | 136077 | 138278 | 121756 | 129983 | 131625 | 115171 | 140059 | 146090 | 130844
 | Fuel Consumption (Ltr) :
 | - FO | 859472.4 | 1191022.38 | 0 | 1015663.98 | 1256960.28 | 0 | 995611.8 | 1216151.61 | 0 | 1056618 | 1313670.24 | 0 | 1041397.56 | 1206840.03 | 0 | 984235.74 | 1265742.48 | 0 | 857504.82 | 1068842.7 | 0 | 772967.22 | 1024662.42 | 0 | 722051.88 | 941219.892 | 0 | 836682.54 | 1095755.4 | 0 | 754800 | 1018438.38 | 0 | 905101.08 | 1172964.3 | 0
 | - HSD | 5324 | 41959 | 56250.5 | 24700 | 57534 | 59368.9 | 24690 | 76918 | 67301 | 22690 | 114510 | 75250 | 62715 | 215311 | 155961 | 15420 | 121336 | 115458 | 1910 | 34425 | 87921 | 2495 | 89159 | 64625 | 5490 | 114012 | 66232 | 28960 | 53020 | 101597 | 5115 | 47674 | 82526 | 5788 | 139691 | 94333
 | Total Fuel Consumption
 | [NAME] (Rs)
 | - FO | 16.99522203647004 | 17.24789978491327 | 0 | 18.42878346522238 | 18.53862550453862 | 0 | 20.63712910834464 | 20.58075265944844 | 0 | 22.11516605676455 | 22.55442269347595 | 0 | 23.2186006224758 | 23.333281146135 | 0 | 24.5079200126744 | 24.4629587710448 | 0 | 24.26732397078969 | 24.15640233422561 | 0 | 24.415879257025 | 24.36789782902353 | 0 | 25.22019376772744 | 25.15917491850034 | 0 | 25.85247180479375 | 25.89142246362646 | 0 | 25.82498518918919 | 25.1895020977116 | 0 | 26.04202534360501 | 26.25099680425056 | 0
 | - HSD | 27.42924981590574 | 28.32479010306317 | 27.51355400262058 | 27.43001814708692 | 27.51490160974179 | 27.47795405292285 | 27.440826625387 | 27.35403801576264 | 27.44634269817799 | 28.69637119548164 | 28.02912536443149 | 28.67842706313294 | 29.19344266459671 | 29.07879601067017 | 29.04858667391896 | 29.26680115146147 | 29.15604976647679 | 29.21876779518275 | 29.26929338327091 | 29.14173970491081 | 29.26479517068706 | 29.27170721649485 | 29.15215108705531 | 29.2647951623111 | 29.27915831134565 | 29.17166566720238 | 29.28168210059172 | 29.29367028092657 | 29.17403335649757 | 29.29462273318872 | 29.29074283158341 | 29.1855036742382 | 29.29631253362022 | 31.10479898204278 | 30.86753541808742 | 30.50630728810605
 | Wt.Avg.rate
 | Fuels Consumption Cost (Rs)
 | - FO
 | - HSD
 | Total Fuel Consumption Cost
 | Add/Less:-Manual Adj.for Discount | 0 | -215494.77 | 0 | 0 | -82925.9 | 0 | 0 | 33246.38 | 0 | 0 | 37426.79 | 0 | 0 | -69432.13 | 0 | 0 | -57863.18 | 0 | 0 | -20428 | 0 | 0 | -101285.1 | 0 | 0 | -30936.91 | 0 | 0 | -86956.06 | 0 | 0 | 131246.04 | 0 | 0 | 24196.37 | 0
 | Net Fuel Consumption Cost (A)
 | Power Purchased (kwh) | 556000 | 0 | 1633975 | 540068 | 0 | 1831025 | 454479 | 0 | 1861650 | 554161 | 0 | 1958075 | 482875 | 0 | 1781675 | 511142 | 0 | 1894200 | 392700 | 0 | 1616300 | 420008 | 0 | 1658300 | 391431 | 0 | 1794450 | 208239 | 0 | 1491700 | 255769 | 0 | 1419600 | 299116 | 0 | 1662675
 | Av Cost per kwh Rs (Purchase)
 | Total Power Purchase Cost (B) | 2421234 | 0 | 5912249 | 2370672 | 0 | 6038246 | 1989826 | 0 | 6564780 | 2425995 | 0 | 6828934 | 2133676 | 0 | 6198514 | 2233194 | 0 | 6656522 | 1722162 | 0 | 7053527 | 1835186 | 0 | 7440442 | 1750037 | 0 | 7723494 | 923444 | 0 | 6811770 | 1142409 | 0 | 6233227 | 1316387 | 0 | 7506245
 | KWH [NAME] | 3630023 | 4896887 | 203600 | 4332944 | 5312480 | 218200 | 4248076 | 5193313 | 242600 | 4555217 | 5683523 | 277100 | 4639996 | 5625997 | 560300 | 4211356 | 5516883 | 404600 | 3614730 | 4427717 | 307300 | 3292209 | 4440030 | 228300 | 3090751 | 4032057 | 244360 | 3668360 | 4504523 | 360900 | 3177021 | 4217490 | 306200 | 3795181 | 5025442 | 346800
 | Cost/KWH [NAME]
 | Power generated / ltr (kwh)
 | Power Consumed/Veh (kwh)
 | Fuel Cost / Veh ( A )
 | Power Cost / Veh ( B )
 | Power and Fuel Cost ( A +B )
 | Other Fuel Cost          ( C ) | 17.51024733180375 | -0.104154166830529 | 16.67333747215476 | 19.67968638815531 | -1.902467685657624 | 9.663048083476891 | 30.29908823615185 | -2.285771363721844 | 11.31645631716109 | 19.88566171196681 | -2.300412405192568 | 13.45756133071887 | 20.95968831791598 | -1.855296614550225 | 5.937723795234132 | 25.70231592275097 | -2.814122244358018 | -1.897741507871626 | 24.85777589069684 | -1.644133926966871 | 2.061813000945947 | 32.79274400534985 | 0.8058982661483403 | 3.004762662266605 | 44.49319573409962 | 8.393591597461079 | 23.82163656605863 | 60.64466973662813 | 22.56347555821246 | 23.75815437576978 | 45.40539408704562 | 8.437618829510859 | 23.18790044238964 | 41.1980348967769 | 17.94207542687354 | 18.95376535867974
 | Total Power and Fuel Cost-( A+B +C )
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T/B-Amt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Veh.