Complete Gas and Electric Calculator
Record the annual cost and usage of your Gas and Electric
This comprehensive calculator allows you to enter your tariff (kilowatt hour rate)and Standard day charge (cost per day) for your Gas and Electric, You can record your usage and costs and also enter your payments so that you can track your debit/ credit balance.
Excel instructions
If you have downloaded the Excel calculator, for your desktop or laptop computers, once downloaded click File/save as/ to Desktop or if you saved to documents right click to make a short cut to your desktop. You can also download to your mobile.
Google sheets instruction
If you have chosen the Google Sheet calculator to download you will have to sign in to open an account and password to be able to use the calculator, all entries that you make will be automatically saved.
To check a comparison site details out against your details it would be better for you to open another calculator, to do this you will need to click File/ Copy/ then Name, change to something different that you can easily identify from your other calculator, you will now have two sheets that you can use with different details.
Below a choice of two downloads. Google sheets or Microsoft Excel.
To track my own Gas and Electric cost and usage download calculator here (Microsoft Excel version)
To track my own Gas and Electric cost and usage download calculator here (Google Sheet version)
energybillcalculator 
Difficulty in reading calculator
Hi Bill
Forget Microsoft!! Use Libre office like I do and its free. Also, Apple and Google (sheets) have their own spreadsheet formats all of which are compatible with Excel and have file converters.
LikeLiked by 1 person
Hi DmcC
Yes I agree, but I would be a bit doubtful about Google Sheets It tends miss out parts of formulars.
LikeLike
Hi Bill, I downloaded Libre Office and was able to access your calculator OK and it works. The only thing is when it opens it is in read only mode and I had to click on edit document for it to work so it may be worth adding a tip stating this fact as not everyone may be aware of this.
LikeLiked by 1 person
Hi Pat thanks for that, Yes if the calculator comes up as read you can also save it and open it again will do the same thing.
Bill
LikeLike
Looking at the calculator to check and compare shouldn’t the Annual costs be including VAT and not as it reads excluding VAT
LikeLike
What’s the formula to convert the gas meter reading units into Kw. We have the pence per Kw, but the meter units are not Kw (unlike the electric meter units) and need to check the supplier is using correct numbers in billing when they convert ?
LikeLike
The answer is shown in the blue section based upon the calorific value in the entry column
LikeLike