The Wonderful Energy Excel Spreadsheet

jasmin10

A number of months ago there was a post with an Excel Spreadsheet for you to work out gas and electricity cost by meter readings. What a fantastic spreadsheet I have used it religiously every week since it was put on year so thank you to the creator.

My question is (Don't know if you've seen my other post for the Owl Monitor), is that I have now gone onto Eco20:20 and unsure how to amend the spread sheet.
The Peak bands starts at 7am, the first band A is 17.50p kwh for the first 900kw used and then drops to Band B which is 10.36p kwh. Then after 9pm it goes eco to 8.28

On the spreadsheet I have change the primary to 17.50 and the secondary to 10.36 and put 900 in the "primary rates apply to", but where do I put the Eco rate of 8.28?

Thank you all again for any assistance.

jd87

Hi. If you mean the spreadsheet I created and posted in this thread: http://forums.moneysavingexpert.com/showthread.html?t=1184735

I'm afraid making it so that it can do economy 7, economy 10 or eco20:20 is a bit complicated and I don't have time to do it right now. Sorry!

jasmin10

That's ok, I will just put the higher tariff in, I would rather be over estimated than under.

I would like to say a big thank you for it. It really is a fantastic tool.