Spreadsheet for SSE home gas usage

parking

Power NI website have a very handy ready reckoner for their customers to calculate estimated usage of electricity since the last bill date.Just inquiring has any clever person created a spreadsheet or ready reckoner for SSE home gas usage?

molerat

The problem is that electric is easy, what you see on the meter is what you pay for, meter units x pp per unit = bill.

Gas is more complicated, so much so that even smart meter IHDs can only estimate the cost.

Firstly there are 2 different metering units in use, cu m and cu ft.  

Then there is the constantly variable calorific value, a reading that is taken several times a day.  Suppliers use an average of that reading over the billed period, different suppliers even seem to use a slight variation on how they calculate that average.

The simplest "guesstimate" is to multiply meter units by 11 for metric and 32 for imperial and multiply that by the unit cost.

edit.  The CV of gas must be between 38.0 and 41.0  which means the actual multiplier can be anywhere between 10.8 to 11.6 for metric and 30.5 to 33.0 for imperial. Smart meters default to a CV of 40 meaning an 11.4 (and 32.2 if an imperial smart meter was available) multiplier is used.  My recent bills have had a CV of 38.5 so multipliers of 10.9 and 31, complicated eh !