Useful Energy Bill Tool

Gareth56

With respect to Question 6 "What percentage dual fuel or other discount do you receive?" I get a set amount ie £50.40 per year so how do I express this as a %?

boborfrank

jd87 wrote: »

I've created something which I hope people on here will find useful. It's a spreadsheet to accurately figure out energy costs. You just enter information about your tariff, then enter your meter readings, and it tells you how much it costs. I'm hoping it will be useful for a couple of things:

1. If you only receive a bill once every quarter, you can use this part-way through a quarter to calculate the cost of what you have used so far. This will make it easier to ensure your direct debit payments are on track.
2. You might find it useful for comparing tariffs. Enter your meter readings from your last bill, but enter rates from a different tariff and see how much it would have cost if you were to switch.

• It doesn't work if you are on an Economy 7 or 10 tariff.
• You need to know the rates you are paying in pence per kWh. These should be on your bill, or ask your energy company.
• If you want to compare rates of other tariffs you can find them at energyhelpine.com.
• You can use it for single or dual fuel tariffs. To use it for a single fuel, just leave the boxes relating to the other fuel blank.

It's an excel spreadsheet and you can find it here:
Energy Calculator2.xls

(Choose the "download with file factory basic" option, then enter the code you see, and click "Begin Download" and save it to your computer).

or here:
http://www.rapidshare.com/files/149216993/Energy_Calculator2.xls.html

All feedback welcome!

[EDIT] Two tier gas now included.

*Disclaimer* - As this seems to be quite popular, I just want to mention that I can't be held responsible for any problems caused by basing decisions on this spreadsheet. I am by no means an expert on, well, anything!

Been looking for something like this for ages
Thanks

boborfrank

Good morning jd87 I am new here at posting I have sent you a PM

That Calculator is brilliant thank you

gazza975526570

Gareth56 wrote: »

With respect to Question 6 "What percentage dual fuel or other discount do you receive?" I get a set amount ie £50.40 per year so how do I express this as a %?

Anyone know the answer to how to add an amount or change the formula to do this?

KimYeovil

I presume in the white cell to the right of the TOTAL £0.00 in the blue block (L37) you could just type
the formula =K37 - 50.40

(and, of course, 0 in the what percentage deduciton do you receive box)

System

Thanks from me too xxx

jd87

UPDATE

Hi everyone. I hope people out there are still finding my little spreadsheet useful. I've now updated it. It now deals with standing charges properly, and can cope with meter readings where the meter has gone "all the way round". You can download the new version from the same links in the first post of this thread.

Oh and I have an Economy 7 version in the pipeline which I'll be uploading soon!

cons

just found this, punched all my details in and got a rough cost

think its right..

says i have used
Your Costs Electricity £20.55 Gas £138.07 Standing charge £0.00 Discount £0.00 VAT £7.93 TOTAL £166.55
since 11th December 2009

B'stard

Thanks, maybe useful...

MsRed1

Yes, thanks.:j:T