G
Guest
Would like to see a spreadsheet and chart for Utilities in my home. Also to
see the cost of gas and electricity usage per BTU.
see the cost of gas and electricity usage per BTU.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Your use of BTU suggest you come from the UK and therefore like myself
tracking the cost of gas and electricity is not the simplest matter but can
be done.
Electricity. This is simple in that you need to record meter readings at
billing time and then (new reading-old reading)gives Kw used. Multiply this
by cost per Kw and your done.
Gas. Much more difficult. Generally meters are calibrated in Cu metres so
the start of the process is the same (new reading-old reading)= cu metres
used. This then has to be converted into Kw and multiplied by the calorific
value so:-
(CuM * 1.02264 * 39.6 * cost per Kw) and your nearly there but
not quite. The calorific value of the gas varies month on month so this must
be set up as a variable.
Life then gets considerably more complicated in that generally the first x
CuM consumed are charged at a higher rate and to finally get around to
answering your question I couldn't find an 'off the peg' spredasheet to do
this so you will probably have to write your own.
Mike
tracking the cost of gas and electricity is not the simplest matter but can
be done.
Electricity. This is simple in that you need to record meter readings at
billing time and then (new reading-old reading)gives Kw used. Multiply this
by cost per Kw and your done.
Gas. Much more difficult. Generally meters are calibrated in Cu metres so
the start of the process is the same (new reading-old reading)= cu metres
used. This then has to be converted into Kw and multiplied by the calorific
value so:-
(CuM * 1.02264 * 39.6 * cost per Kw) and your nearly there but
not quite. The calorific value of the gas varies month on month so this must
be set up as a variable.
Life then gets considerably more complicated in that generally the first x
CuM consumed are charged at a higher rate and to finally get around to
answering your question I couldn't find an 'off the peg' spredasheet to do
this so you will probably have to write your own.
Mike
G
Gord Dibben
How are units measured on your billing invoice?
KWH for electricity.........?
1 kwh = 3412.14 btu
Gigajoules for gas.........?
1 gj = 947817.1 btu
Gord Dibben MS Excel MVP
KWH for electricity.........?
1 kwh = 3412.14 btu
Gigajoules for gas.........?
1 gj = 947817.1 btu
Gord Dibben MS Excel MVP
G
Guest
OK, I understand all that, but here in the US we measure in CUFT on gas. I
would settle for a spreadsheet on that, but I would also like to superimpose
the Electricity bill on top of the gas bill. The reason for the btu output
was to compare the cost of heating my house with gas as to electricity. or at
least apples to apples. Maybe I just don't know enough about charts to do
this. so, just go back to CuFt and KWHrs. vs, money in a given month.
would settle for a spreadsheet on that, but I would also like to superimpose
the Electricity bill on top of the gas bill. The reason for the btu output
was to compare the cost of heating my house with gas as to electricity. or at
least apples to apples. Maybe I just don't know enough about charts to do
this. so, just go back to CuFt and KWHrs. vs, money in a given month.
G
Guest
See my reply to Mike
Gord Dibben said:How are units measured on your billing invoice?
KWH for electricity.........?
1 kwh = 3412.14 btu
Gigajoules for gas.........?
1 gj = 947817.1 btu
Gord Dibben MS Excel MVP