Gas & Electricity cost calculator

[hypersonic]

I have written a spreadsheet program to calculate the annual cost of gas and electricity based on the kilowatt hours used or in the case of gas, either kilowatt hours, cubic meters or cubic feet. To use the program you also need standing charge details and cost per kilowatt hour of both fuels from your supplier. There are three sheets to allow a comparison of 3 suppliers. The program allows the input of both standing charge and non standing charge tariffs and can be in excel (xls) or openoffice spreadsheet (ods) format. If anybody is interested, I will upload to this thread. :beer:

[wetdog]

im interested dude, very interested.

mick.

[flyingpig]

Yep - interested.,.,

[hypersonic]

The data already entered in the green boxes are typical examples and sheets 1,2 & 3 are examples of three different suppliers. The Gas calculation works on kwhrs ~ If you enter the cubic metres used or cubic feet(x100) then the yellow box next to the green input box will calculate the kwhr ~ just enter this figure into the green kwhr box. ~ only the green boxes allow data input all the other boxes are locked to prevent you overwriting the formulae ~ the supplier box also allows you to change supplier name. If you need help pls post or pm. (error in daily standing charge calculation ~ should read daily charge = annual charge/365x100)

The programs are attached below

[mlhifi]

I have written a spreadsheet program to calculate the annual cost of gas and electricity based on the kilowatt hours used or in the case of gas, either kilowatt hours, cubic meters or cubic feet. To use the program you also need standing charge details and cost per kilowatt hour of both fuels from your supplier. There are three sheets to allow a comparison of 3 suppliers. The program allows the input of both standing charge and non standing charge tariffs and can be in excel (xls) or openoffice spreadsheet (ods) format. If anybody is interested, I will upload to the downloads section. :beer:

I'm definitely interested. I had a similar spreadsheet for some years, downloaded from I-can't-remember-where and I lost it in a "crash". I used it extensively, so I'm hoping yours is a good, or BETTER, alternative.
Thanks,
Mike

[adamgrafton]

calculator may come in real handy while I'm chasing a cheaper tariff.
Downside had to register to dowload rar, heyho more junk email.

[hypersonic]

calculator may come in real handy while I'm chasing a cheaper tariff.
Downside had to register to dowload rar, heyho more junk email.

Let me know if you have any problems with it.

[fandm]

i have got einstien working mine out he's been at it for 3 years and still not cracked it

[Cod3waX]

there was a government thing afew weeks ago about gas and electric being made to put people onto the lowest tariffs if they werent already on it

[GastonJ]

there was a government thing afew weeks ago about gas and electric being made to put people onto the lowest tariffs if they werent already on it

That would be so they could announce this week that in order to subsidise renewable energy in future that prices would have to go up again. Give ?100 with one hand, take ?120 with the other. Still it gives people the impression that the government is on their side, doing something for them.

[hypersonic]

If the energy companies are forced to put everybody on the lowest tariff, they will just raise the lowest tariff to be the same as the highest tarriff, then everybody will be on the same highest/lowest tarriff ~ more profit for the energy companies ~ simples! The politicians won't suffer as they can claim their energy costs on expenses ! :argh:

[GastonJ]

and now you can look forward to prices going up again

There has been a historic shift in the UN climate talks in Qatar, with the prospect of rich nations having to compensate poor nations for losses due to climate change.

The US has fiercely opposed the measure - it says the cost could be unlimited.

But after angry tussles throughout the night the principle of Loss and Damage is now in the final negotiating text.

Already poor nations are bitter that rich nations, particularly the US are dragging their feet over a promise made at the failed Copenhagen climate summit to mobilise $100bn by 2020 to help poor nations get clean energy and adapt to climate change.

The developing countries say the original sum was too low - especially in the light of Mr Obama's request to Congress for Sandy damages of $60bn, and the UK's bid to raise ?200bn for clean energy by 2020.

BBC News - Doha climate talks: US faces dilemma over final text (http://www.bbc.co.uk/news/science-environment-20650534)

How nice of the government to pay, since it's with our money not theirs. I doubt China, Russia and others will bother to pay anything.

[kudus]

calculator may come in real handy while I'm chasing a cheaper tariff. Downside had to register to dowload rar, heyho more junk email.

[wudwurks]

Please upload you spread sheet pls.

wudwurks

[bloggins]

Just been stung by a massive energy bill. The weasels snuck in a tiered rate with a much higher upper band just as the weather turned cold! Hope this spreadsheet helps sort the wheat from my current chaff

[GastonJ]

Always been curious on this one. If they estimate your bill, and as a result charge you at the higher rate, then a year later read it, and the average means that you woud never have hit the higher rate that they estimated, do they stick their hands up and give you money back?

[hypersonic]

Please upload you spread sheet pls.

wudwurks

Spread sheet is still there in post 4

Hyper

[hypersonic]

Always been curious on this one. If they estimate your bill, and as a result charge you at the higher rate, then a year later read it, and the average means that you woud never have hit the higher rate that they estimated, do they stick their hands up and give you money back?

There are two basic tariffs and then variations on each one.
There is a basic rate per kilowatt hour for both electricity and Gas, then they add a daily service charge, usually in pence per day, then 5% VAT. If the kilowatt hour rate appears to be cheap then beware of the daily standing charge which will ramp up the cost.
Then there is the non standing charge tariff which hits you with an extortionate rate per kilowatt hour for the first few hundred kilowatt hours and then the rate is reduced for the remaining useage.
For the average user there is no difference in annual cost between the 2 basic tariffs. If you know the number of kilowatt hours you use over the year then use my spreadsheet to compare all the suppliers.

[cablefreejunkie]

could i get a copy please ? very handy to have
cheers