Spreadsheet: 241676d1370696645-how-to-get-monthly-kwh-usage-when-bill-data-spans-months-energy-20consumption-1-
Sheet: Gas bill data

 |  |  |  |  | Gas
Period start | Period end | Supply | Days |  | Units | kWh | Cumulative kWh | p/kWH Primary | p/kWh Secondary | Service GBP | Primary GBP | Secondary GBP | Total | [NAME] read | Units/ day | kWh/ day
2006-03-26 00:00:00 | 2006-04-30 00:00:00 | South |  |  | 185 | 4675 |  | 1.92 |  | 3.85 | 89.76 |  |  | E
2006-05-01 00:00:00 | 2006-05-09 00:00:00 |  |  |  |  | 1136.15 |  | 2.26 |  | 0.91 | 25.68
2006-05-10 00:00:00 | 2006-07-24 00:00:00 | South |  |  | -36 | 1737.6 |  | 2.26 |  | 7.67 | 39.29 |  |  | C
2006-07-25 00:00:00 | 2006-10-31 00:00:00 | South |  |  | 67 | 2127.45 |  | 2.26 |  | 9.99 | 48.08 |  |  | E
2006-11-01 00:00:00 | 2006-12-31 00:00:00 | South |  |  | 259 | 5410 |  | 2.26 |  | 6.16 | 122.27 |  |  | Company
2007-01-01 00:00:00 | 2007-01-31 00:00:00 |  |  |  |  | 2748.04 |  | 2.53 |  | 3.53 | 69.52
2007-02-01 00:00:00 | 2007-05-11 00:00:00 | South |  |  | 287 | 9054.96 |  | 2.53 |  | 11.4 | 229.09 |  |  | E
2007-05-12 00:00:00 | 2007-08-06 00:00:00 | South |  |  | -7 | 2013.97 |  | 2.21 |  | 9.91 | 44.41 |  |  | ?
2007-08-07 00:00:00 | 2008-02-06 00:00:00 | South |  |  | 391 | 12276.2 |  | 2.21 |  | 9 | 271.3 |  |  | ?
2008-02-07 00:00:00 | 2008-03-31 00:00:00 | South |  |  | 336 | 4693 |  | 2.21 |  | 6.16 | 103.71 |  |  | ?
2008-04-01 00:00:00 | 2008-08-06 00:00:00 |  |  |  |  | 5841.33 |  | 2.56 |  | 17.1 | 149.54 |  |  | ?
2008-08-07 00:00:00 | 2008-08-24 00:00:00 | South |  |  | 475 | 662 |  | 2.56 |  | 2.4 | 16.95 |  |  | ?
2008-08-24 00:00:00 | 2009-02-10 00:00:00 |  |  |  |  | 14344.92 |  | 3.37 |  | 22.71 | 483.42 |  |  | ?
2009-02-11 00:00:00 | 2009-03-19 00:00:00 | South |  |  | 247 | 3076 |  | 3.37 |  | 6.28 | 103.66 |  |  | ?
2009-03-30 00:00:00 | 2009-08-10 00:00:00 |  |  |  |  | 4747.41 |  | 3.24 |  | 17.9 | 153.81 |  |  | ?
2009-08-11 00:00:00 | 2010-02-23 00:00:00 | South |  |  | In post
 | TOTAL No, of Days |  |  |  |  |  |  |  |  |  |  | TOTAL COST |  |  |  |  |  | COST PER DAY
2010-02-23 00:00:00 | 2010-03-06 00:00:00 | EDF |  |  | 35 | 1103 |  | 7 | 3.065 |  | 5.67 | 31.23 |  | E
2010-03-06 00:00:00 | 2010-06-04 00:00:00 | EDF |  |  | 229 | 7217 |  | 2.591 |  | 22.08 | 186.99 |  |  | A
2010-06-04 00:00:00 | 2010-09-23 00:00:00 | EDF |  |  | 75 | 2363 |  | 2.591 |  | 27.23 | 61.23 |  |  | E
2010-09-23 00:00:00 | 2010-12-21 00:00:00 | EDF |  |  | 183 | 5767 |  | 2.591 |  | 21.83 | 149.42 |  |  | E
2010-12-21 00:00:00 | 2011-03-08 00:00:00 | EDF |  |  | 328 | 10363 |  | 2.591 |  | 18.89 | 268.51 |  |  | A
2011-03-09 00:00:00 | 2011-03-31 00:00:00 | EDF |  |  | 38 | 1201 |  | 3.353 |  | 38.85 | 40.27 |  |  | E
2011-04-01 00:00:00 | 2011-09-21 00:00:00 | EDF |  |  | 110 | 3475 |  | 3.353 |  |  | 116.52 |  |  | A
2011-09-22 00:00:00 | 2011-11-01 00:00:00 | EDF |  |  | 44 | 1387 |  | 3.353 |  | 8.09 | 46.51 |  |  | C
 | TOTAL No, of Days |  |  |  |  |  |  |  |  |  |  | TOTAL COST |  |  |  |  |  | COST PER DAY
2011-11-02 00:00:00 | 2012-02-02 00:00:00 | Scot |  |  | 297 | 9359 |  | 6.501 | 2.986 |  | 44.27 | 259.13 |  | E
2012-02-03 00:00:00 | 2012-02-26 00:00:00 | Scot |  |  | 98 | 3088 |  | 6.501 | 2.986 |  | 11.38 | 86.98 |  | E
2012-02-27 00:00:00 | 2012-06-06 00:00:00 |  |  |  | 186 | 5861 |  | 6.323 | 2.808 |  | 46.73 | 196.93 |  | C
2012-06-07 00:00:00 | 2012-08-26 00:00:00 | Scot |  |  | 48 | 1516 |  | 6.323 | 2.808 |  | 37.56 | 25.89 |  | C
2012-08-27 00:00:00 | 2012-11-26 00:00:00 | Scot |  |  | 175 | 5515 |  | 6.323 | 2.808 |  | 42.68 | 135.91 |  | E
2012-11-27 00:00:00 | 2012-11-30 00:00:00 | Scot |  |  | 10 | 315 |  | 6.323 | 2.808 |  | 1.83 | 8.03 |  | E
2012-12-01 00:00:00 | 2012-12-02 00:00:00 |  |  |  | 6 | 189 |  | 7.564 | 3.359 |  | 1.06 | 5.88 |  | E
2012-12-03 00:00:00 | 2012-12-31 00:00:00 |  |  |  | 73 | 2300 |  | 7.321 | 3.768 |  | 15.52 | 78.68 |  | E
2013-01-01 00:00:00 | 2013-02-20 00:00:00 |  |  |  | 131 | 4128 |  | 7.321 | 3.768 |  | 27.38 | 141.45 |  | E
 | TOTAL No, of Days |  |  |  |  |  |  |  |  |  |  | TOTAL COST |  |  |  |  |  | COST PER DAY
2013-02-21 00:00:00 | 2013-04-16 00:00:00 | Coop |  |  | 373 | 11754 |  | 3.64 |  | 15.2 | 427.85 |  |  | C
2013-04-16 00:00:00 | 2013-05-09 00:00:00 |  |  |  | 46 | 1450 |  | 3.64 |  |  | 52.78 |  |  | E
2013-05-09 00:00:00 | 2013-05-21 00:00:00 |  |  |  | 24 | 756 |  | 3.92 |  |  | 29.64 |  |  | E
 | TOTAL No, of Days |  |  |  |  |  |  |  |  |  |  | TOTAL COST |  |  |  |  |  | COST PER DAY