Spreadsheet: 241680d1370699700-how-to-get-monthly-kwh-usage-when-bill-data-spans-months-energy-consumption
Sheet: Sheet2

Period start | Years | Period end | Days | Sum of kWh | Sum of Cost | Sum of Daily Use | Sum of Daily Cost
2006-03-26 00:00:00 | 2006 | Apr | 35 | 4675 | 120.2 | 133.5714285714286 | 3.434285714285714
 |  | Apr Total |  | 4675 | 120.2 | 133.5714285714286 | 3.434285714285714
26-Mar-2006 Total |  |  |  | 4675 | 120.2 | 133.5714285714286 | 3.434285714285714
2006-05-01 00:00:00 | 2006 | May | 8 | 1136.15 |  | 142.01875 | 0
 |  | May Total |  | 1136.15 |  | 142.01875 | 0
1-May-2006 Total |  |  |  | 1136.15 |  | 142.01875 | 0
2006-05-10 00:00:00 | 2006 | Jul | 75 | 1737.6 | 46.96 | 23.168 | 0.6261333333333333
 |  | Jul Total |  | 1737.6 | 46.96 | 23.168 | 0.6261333333333333
10-May-2006 Total |  |  |  | 1737.6 | 46.96 | 23.168 | 0.6261333333333333
2006-07-25 00:00:00 | 2006 | Oct | 98 | 2127.45 | 58.07 | 21.70867346938775 | 0.5925510204081633
 |  | Oct Total |  | 2127.45 | 58.07 | 21.70867346938775 | 0.5925510204081633
25-Jul-2006 Total |  |  |  | 2127.45 | 58.07 | 21.70867346938775 | 0.5925510204081633
2006-11-01 00:00:00 | 2006 | Dec | 60 | 5410 | 201.48 | 90.16666666666667 | 3.358
 |  | Dec Total |  | 5410 | 201.48 | 90.16666666666667 | 3.358
1-Nov-2006 Total |  |  |  | 5410 | 201.48 | 90.16666666666667 | 3.358
2007-01-01 00:00:00 | 2007 | Jan | 30 | 2748.04 |  | 91.60133333333333 | 0
 |  | Jan Total |  | 2748.04 |  | 91.60133333333333 | 0
1-Jan-2007 Total |  |  |  | 2748.04 |  | 91.60133333333333 | 0
2007-02-01 00:00:00 | 2007 | May | 99 | 9054.96 | 240.49 | 91.46424242424241 | 2.429191919191919
 |  | May Total |  | 9054.96 | 240.49 | 91.46424242424241 | 2.429191919191919
1-Feb-2007 Total |  |  |  | 9054.96 | 240.49 | 91.46424242424241 | 2.429191919191919
2007-05-12 00:00:00 | 2007 | Aug | 86 | 2013.97 | 54.31999999999999 | 23.41825581395349 | 0.6316279069767441
 |  | Aug Total |  | 2013.97 | 54.31999999999999 | 23.41825581395349 | 0.6316279069767441
12-May-2007 Total |  |  |  | 2013.97 | 54.31999999999999 | 23.41825581395349 | 0.6316279069767441
2007-08-07 00:00:00 | 2008 | Feb | 183 | 12276.2 | 280.3 | 67.08306010928962 | 1.531693989071038
 |  | Feb Total |  | 12276.2 | 280.3 | 67.08306010928962 | 1.531693989071038
7-Aug-2007 Total |  |  |  | 12276.2 | 280.3 | 67.08306010928962 | 1.531693989071038
2008-02-07 00:00:00 | 2008 | Mar | 53 | 4693 | 276.51 | 88.54716981132076 | 5.217169811320755
 |  | [NAME] |  | 4693 | 276.51 | 88.54716981132076 | 5.217169811320755
7-Feb-2008 Total |  |  |  | 4693 | 276.51 | 88.54716981132076 | 5.217169811320755
2008-04-01 00:00:00 | 2008 | Aug | 127 | 5841.33 |  | 45.99472440944882 | 0
 |  | Aug Total |  | 5841.33 |  | 45.99472440944882 | 0
1-Apr-2008 Total |  |  |  | 5841.33 |  | 45.99472440944882 | 0
2008-08-07 00:00:00 | 2008 | Aug | 17 | 662 | 525.48 | 38.94117647058823 | 30.91058823529412
 |  | Aug Total |  | 662 | 525.48 | 38.94117647058823 | 30.91058823529412
7-Aug-2008 Total |  |  |  | 662 | 525.48 | 38.94117647058823 | 30.91058823529412
2008-08-24 00:00:00 | 2009 | Feb | 170 | 14344.92 |  | 84.38188235294118 | 0
 |  | Feb Total |  | 14344.92 |  | 84.38188235294118 | 0
24-Aug-2008 Total |  |  |  | 14344.92 |  | 84.38188235294118 | 0
2009-02-11 00:00:00 | 2009 | Mar | 36 | 3076 | 281.65 | 85.44444444444444 | 7.82361111111111
 |  | [NAME] |  | 3076 | 281.65 | 85.44444444444444 | 7.82361111111111
11-Feb-2009 Total |  |  |  | 3076 | 281.65 | 85.44444444444444 | 7.82361111111111
2009-03-30 00:00:00 | 2009 | Aug | 133 | 4747.41 |  | 35.69481203007518 | 0
 |  | Aug Total |  | 4747.41 |  | 35.69481203007518 | 0
30-Mar-2009 Total |  |  |  | 4747.41 |  | 35.69481203007518 | 0
2009-08-11 00:00:00 | 2010 | Feb | 196 |  |  | 0 | 0
 |  | Feb Total |  |  |  | 0 | 0
11-Aug-2009 Total |  |  |  |  |  | 0 | 0
2010-02-23 00:00:00 | 2010 | Mar | 11 | 1103 | 245.97 | 100.2727272727273 | 22.36090909090909
 |  | [NAME] |  | 1103 | 245.97 | 100.2727272727273 | 22.36090909090909
23-Feb-2010 Total |  |  |  | 1103 | 245.97 | 100.2727272727273 | 22.36090909090909
2010-03-06 00:00:00 | 2010 | Jun | 90 | 7217 |  | 80.18888888888888 | 0
 |  | Jun Total |  | 7217 |  | 80.18888888888888 | 0
6-Mar-2010 Total |  |  |  | 7217 |  | 80.18888888888888 | 0
2010-06-04 00:00:00 | 2010 | Sep | 111 | 2363 | 88.46 | 21.28828828828829 | 0.7969369369369369
 |  | Sep Total |  | 2363 | 88.46 | 21.28828828828829 | 0.7969369369369369
4-Jun-2010 Total |  |  |  | 2363 | 88.46 | 21.28828828828829 | 0.7969369369369369
2010-09-23 00:00:00 | 2010 | Dec | 89 | 5767 | 171.25 | 64.79775280898876 | 1.924157303370787
 |  | Dec Total |  | 5767 | 171.25 | 64.79775280898876 | 1.924157303370787
23-Sep-2010 Total |  |  |  | 5767 | 171.25 | 64.79775280898876 | 1.924157303370787
2010-12-21 00:00:00 | 2011 | Mar | 77 | 10363 | 287.4 | 134.5844155844156 | 3.732467532467532
 |  | [NAME] |  | 10363 | 287.4 | 134.5844155844156 | 3.732467532467532
21-Dec-2010 Total |  |  |  | 10363 | 287.4 | 134.5844155844156 | 3.732467532467532
2011-03-09 00:00:00 | 2011 | Mar | 22 | 1201 | 195.64 | 54.59090909090909 | 8.892727272727273
 |  | [NAME] |  | 1201 | 195.64 | 54.59090909090909 | 8.892727272727273
9-Mar-2011 Total |  |  |  | 1201 | 195.64 | 54.59090909090909 | 8.892727272727273
2011-04-01 00:00:00 | 2011 | Sep | 173 | 3475 |  | 20.08670520231214 | 0
 |  | Sep Total |  | 3475 |  | 20.08670520231214 | 0
1-Apr-2011 Total |  |  |  | 3475 |  | 20.08670520231214 | 0
2011-09-22 00:00:00 | 2011 | Nov | 40 | 1387 | 54.59999999999999 | 34.675 | 1.365
 |  | Nov Total |  | 1387 | 54.59999999999999 | 34.675 | 1.365
22-Sep-2011 Total |  |  |  | 1387 | 54.59999999999999 | 34.675 | 1.365
2011-11-02 00:00:00 | 2012 | Feb | 92 | 9359 | 303.4 | 101.7282608695652 | 3.297826086956522
 |  | Feb Total |  | 9359 | 303.4 | 101.7282608695652 | 3.297826086956522
2-Nov-2011 Total |  |  |  | 9359 | 303.4 | 101.7282608695652 | 3.297826086956522
2012-02-03 00:00:00 | 2012 | Feb | 23 | 3088 | 342.02 | 134.2608695652174 | 14.8704347826087
 |  | Feb Total |  | 3088 | 342.02 | 134.2608695652174 | 14.8704347826087
3-Feb-2012 Total |  |  |  | 3088 | 342.02 | 134.2608695652174 | 14.8704347826087
2012-02-27 00:00:00 | 2012 | Jun | 100 | 5861 |  | 58.61 | 0
 |  | Jun Total |  | 5861 |  | 58.61 | 0
27-Feb-2012 Total |  |  |  | 5861 |  | 58.61 | 0
2012-06-07 00:00:00 | 2012 | Aug | 80 | 1516 | 63.45 | 18.95 | 0.7931250000000001
 |  | Aug Total |  | 1516 | 63.45 | 18.95 | 0.7931250000000001
7-Jun-2012 Total |  |  |  | 1516 | 63.45 | 18.95 | 0.7931250000000001
2012-08-27 00:00:00 | 2012 | Nov | 91 | 5515 | 178.59 | 60.60439560439561 | 1.962527472527473
 |  | Nov Total |  | 5515 | 178.59 | 60.60439560439561 | 1.962527472527473
27-Aug-2012 Total |  |  |  | 5515 | 178.59 | 60.60439560439561 | 1.962527472527473
2012-11-27 00:00:00 | 2012 | Nov | 3 | 315 | 279.83 | 105 | 93.27666666666666
 |  | Nov Total |  | 315 | 279.83 | 105 | 93.27666666666666
27-Nov-2012 Total |  |  |  | 315 | 279.83 | 105 | 93.27666666666666
2012-12-01 00:00:00 | 2012 | Dec | 1 | 189 |  | 189 | 0
 |  | Dec Total |  | 189 |  | 189 | 0
1-Dec-2012 Total |  |  |  | 189 |  | 189 | 0
2012-12-03 00:00:00 | 2012 | Dec | 28 | 2300 |  | 82.14285714285714 | 0
 |  | Dec Total |  | 2300 |  | 82.14285714285714 | 0
3-Dec-2012 Total |  |  |  | 2300 |  | 82.14285714285714 | 0
2013-01-01 00:00:00 | 2013 | Feb | 50 | 4128 |  | 82.56 | 0
 |  | Feb Total |  | 4128 |  | 82.56 | 0
1-Jan-2013 Total |  |  |  | 4128 |  | 82.56 | 0
2013-02-21 00:00:00 | 2013 | Apr | 54 | 11754 | 525.47 | 217.6666666666667 | 9.730925925925927
 |  | Apr Total |  | 11754 | 525.47 | 217.6666666666667 | 9.730925925925927
21-Feb-2013 Total |  |  |  | 11754 | 525.47 | 217.6666666666667 | 9.730925925925927
2013-04-16 00:00:00 | 2013 | May | 23 | 1450 |  | 63.04347826086956 | 0
 |  | May Total |  | 1450 |  | 63.04347826086956 | 0
16-Apr-2013 Total |  |  |  | 1450 |  | 63.04347826086956 | 0
2013-05-09 00:00:00 | 2013 | May | 12 | 756 |  | 63 | 0
 |  | May Total |  | 756 |  | 63 | 0
9-May-2013 Total |  |  |  | 756 |  | 63 | 0
Grand Total |  |  |  | 153651.03 | 4821.54 | 59.64713897515529 | 1.871715838509317