Puzzled by Gas energy calculation.

JohnB47

This is not a big problem - my Eversmart Energy gas bills are pretty close to my own calculations, although they are a few quid out whereas my electricity costs are, at worst, a few pence out. I'm just curious about how the costs are calculated.

On my latest Invoice, the top line shows my own start and end readings which equate to 25 cubic feet used (I have an imperial meter). This line also quotes 786.4 'Units' and 70.8 m3.

The next line does a calculation based on the 70.8 m3 figure, as follows:

70.8 x 1.022640 x 39.100 ÷ 3.6 = 786.4 units X 0.02966 = £23.32

My question is, how is the figure 70.8 m3 arrived at?

Thomas_Edison

25 cubic feet = 70.8 M3 and then the rest is the normal gas calculation to get it to kWh

70.8 M3 = 786.4 kwh

dogshome

On an your Imperial meter, each meter unit delivers 100 cubic feet of gas, equates to *appx 31.5 Kwh
* It varies slightly from bill to bill, depending on the quality of the gas

So your 25 units x 31.5 produces a bill for appx 787 kwh

bonus2010

just to add, a nice wee explanation of converting gas volume to kWh

https://www.gov.uk/guidance/gas-meter-readings-and-bill-calculation#metric-or-imperial

Game_Over

JohnB47 wrote: »

This is not a big problem - my Eversmart Energy gas bills are pretty close to my own calculations, although they are a few quid out whereas my electricity costs are, at worst, a few pence out. I'm just curious about how the costs are calculated.

On my latest Invoice, the top line shows my own start and end readings which equate to 25 cubic feet used (I have an imperial meter). This line also quotes 786.4 'Units' and 70.8 m3.

The next line does a calculation based on the 70.8 m3 figure, as follows:

70.8 x 1.022640 x 39.100 ÷ 3.6 = 786.4 units X 0.02966 = £23.32

My question is, how is the figure 70.8 m3 arrived at?

Imperial gas meters register consumption in 100s of cubic feet

Thomas_Edison wrote: »

25 cubic feet = 70.8 M3 ...

No, 2500 cubic feet = 70.8 M3

Game_Over

JohnB47 wrote: »

Thanks everyone. That explains it.

I have another slight adjustment to make to my spreadsheet, to make it align more accurately with the Invoice.

In my spreadsheet, I calculate the m3 figure as 70.79 and even if I set the cell to display 70.8 (ie rounded up) my calculation elsewhere still uses 70.79

Eversmart uses the rounded up 70.8 figure, so my estimate is always lower then the Invoice.

I know this isn't specifically an excel thread but does anyone know how I can get my spreadsheets calculation to use the value displayed in a cell (the rounded up value), rather than the actual cell content (not rounded up)?

I'll start a new thread if I don't get a response after a while.

Yes, I know.

Use the ROUND function

It's all explained in the Excel Help pages

JohnB47

Thank you.

You must have posted that just as I deleted my message. I've just found the ROUND function by doing a search!

At least you've quoted my deleted post, so hopefully it won't confuse anyone.

Thanks again.