Useful Energy Bill Tool

jd87

Now Updated 02/03/09

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:
http://www.!!!!!!/file/af3c110/n/Energy_Calculator2_2_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://rapidshare.com/files/204248130/Energy_Calculator2.2.xls

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!

fatlad1971

jd87 wrote: »

I've created something which I hope might be able to help a lot of people on here. It's nothing too genius, it's a bit crude, it hasn't been tested by anyone but myself, and it might already have been done, but here goes.

It's a spreadsheet to calcuate the cost of energy bills. You just enter information about your tariff, then enter your meter readings, and it tells you how much your bill should be. 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, but it does work if you are using a two-rate meter originally designed for these tariffs. If people like it, I might create an Economy 7 one.

To use it you have to know the rates you are paying for your electrcity/gas, in pence per kWh. You should be able to find these on your bill, or you can phone your energy company up and ask them. Rates of other tariffs can be found at energyhelpine.com.

You can use if for Electricity-only, Gas-only, or Dual Fuel tariffs. At the moment it allows for primary and secondary rates for Electric, but not for gas. To use it for a single fuel, just leave the boxes relating to the other fuel blank.

It's an excel spreadsheet. If people like it, I'll try uploading it in other formats too. It's currently located here:
http://www.!!!!!!/file/f74c72/n/Energy_Calculator_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.

All feedback welcome!

Very useful tool :beer:

Magentasue

Looks great - thank for sharing!

savemoney

Thanks I notice BG has two tier for gas which isnt on the spreadsheet and provision for two tiers for gas but electric is fine.

https://www.britishgas.co.uk/PriceFinder/ShowPrices/

jd87

savemoney wrote: »

Thanks I notice BG has two tier for gas which isnt on the spreadsheet and provision for two tiers for gas but electric is fine.

https://www.britishgas.co.uk/PriceFinder/ShowPrices/

Yeah two tier gas is something I forgot about until I posted this. I'm going to see if I can include it now. Thanks.

[Update] Done! (download link updated)

savemoney

Thanks anyway jd87 looks good spreadsheet

Curley

Thats great! I've been looking for something like this for ages. I'm too thick to create something like that myself. :rolleyes:

whatatwit

Curley wrote: »

Thats great! I've been looking for something like this for ages. I'm too thick to create something like that myself. :rolleyes:

snap. :rotfl:

Antispam

looks like bandwidth exceed try rapidshare


Sorry, there are currently no free download slots available on this server.

Please try again later, or you can upgrade to FileFactory Premium for instant access.

jd87

Antispam wrote: »

looks like bandwidth exceed try rapidshare

Thanks. I've added a rapidshare link too. Thanks for everyone's comments so far. :j

Secret_Lady

Thanks, have downloaded and will give it a try, will also see if it can be used for Economy 7 for my Mum but will have to check the meter to see if it's possible.