The cheapest Gas and Electric combination

Cardew

jscalow wrote: »

2.5 units of gas a day !!!! Jesus I only use 4 a week at the moment, I hope they have a big house/family.

His gas units are metric i.e. 2.5 equal approx 28 kWh a day. which is half the UK average consumption.

Are your gas units metric(approx 11kWh) or Imperial(approx 32 kWh)

Even if they are Imperial, to use only 128kWh a week in late Oct is remarkably low.(44 kWh is unbelievable) I used over 800 kWh last week

lightSwitch_3

MY SPREADSHEET

http://spreadsheets.google.com/ccc?key=pwruRCa0Pj0o5jF7LuMXPTg

Those of you who can program spreadsheets can alter it if you want beyond editing just the data.

If you are not sure how to use it just request help here.

Tip: put your browser on full screen mode.

Please read the following if you are to use it:

1. If you are inputting data to get prices and the spreadsheet returns silly figures it means that the format of my spreadsheet and google spreadsheet are incompatible.

2. If the value of your Kwh usage is lower than tier 1 Kwh (eg 900 for EDF but you input 700) then the spreadsheet fails. THis is something I need to fix.

3. The conversion factor of 11.1966 works for MY gas meter with EDF as my biller, not sure if it works with all gas meters/billers.

4. If you alter the days then you must alter the tier 1 value. So if you are looking at 180 days of usage then divide the tier 1 value by 2 (eg EDF's is 900/annum you input 450).

5. Discounts are tricky so I approximate them.
==============================================

A lot of people here quote very low usage but don't mention the details.

jscalow,

4 units a week, I use that in half a day. Tell us what you use gas for. and for how long.

Cardew

lightSwitch wrote: »

3. The conversion factor of 11.1966 works for MY gas meter with EDF as my biller, not sure if it works with all gas meters/billers.

Just a point on gas.

You have a Metric meter.

The conversion factor you use will vary, even for yourself with EDF, as the calorific value of the gas delivered changes, and thus the kWh value of a gas unit varies.
This variation exceptionally can be as high as 10% from lowest to highest.

However the figure you use is pretty representative.

For those with an Imperial meter(a gas unit = 100 cubic feet) the conversion factor is 2.83 times higher. i.e. approx 32

Woby_Tide

Cardew wrote: »

Even if they are Imperial, to use only 128kWh a week in late Oct is remarkably low.(44 kWh is unbelievable) I used over 800 kWh last week

That said 800kWh a week is quite high though. Looking at my records I've never actually used that amount in the whole of OCtober in the 4 years of data I have, this year has been the lowest so far due to the better weather earlier in month but max has still only ever been c.700kWh for the whole month. Do people have really inefficient/un-insulated houses or just kee heating on permananently?

lightSwitch_3

Woby_Tide,

That 800-700 Kwh/week is that from a gas boiler + electrics? Are you using about 9 units a day of gas? Do you have a condensing boiler and how big is your property?

128kwh/week must be without central heating or else the property is super insulated which is possible if you pay thousands to do it. it is also is possible in a normal home if you just take showers plus some cooking.

lightSwitch_3

Updated version of SPREADSHEET

http://spreadsheets.google.com/ccc?key=pwruRCa0Pj0qhgbUAroWPZg


Enjoy

Cardew

Woby_Tide wrote: »

That said 800kWh a week is quite high though. Looking at my records I've never actually used that amount in the whole of OCtober in the 4 years of data I have, this year has been the lowest so far due to the better weather earlier in month but max has still only ever been c.700kWh for the whole month. Do people have really inefficient/un-insulated houses or just keep heating on permananently?[/quote]

It is the servants in the West Wing that are the problem;)

Seriously, what would you consider a % breakdown of consumption, by month, to be normal?

Mine - no idea if it is representative is(rounded to nearest %)
%
Jan = 16
Feb = 15
Mar = 12
Apr = 9
May = 5
Jun = 3
Jul = 3
Jul = 3
Aug = 3
Sep = 4
Oct = 8
Nov = 9
Dec = 13

Yes I know that is 103%

So, if my figures are representative, someone on the UK average of 20,500kWh p.a. would use approx 1,600 kWh in October.

So if you have never used more than 700 kWh in October, then your consumption is pretty low or your consumption pattern is somewhat different to mine.

Woby_Tide

Cardew wrote: »

Woby_Tide wrote: »

That said 800kWh a week is quite high though. Looking at my records I've never actually used that amount in the whole of OCtober in the 4 years of data I have, this year has been the lowest so far due to the better weather earlier in month but max has still only ever been c.700kWh for the whole month. Do people have really inefficient/un-insulated houses or just keep heating on permananently?[/quote]

It is the servants in the West Wing that are the problem;)

Seriously, what would you consider a % breakdown of consumption, by month, to be normal?

Mine - no idea if it is representative is(rounded to nearest %)
%
Jan = 16
Feb = 15
Mar = 12
Apr = 9
May = 5
Jun = 3
Jul = 3
Jul = 3
Aug = 3
Sep = 4
Oct = 8
Nov = 9
Dec = 13

Yes I know that is 103%

So, if my figures are representative, someone on the UK average of 20,500kWh p.a. would use approx 1,600 kWh in October.

So if you have never used more than 700 kWh in October, then your consumption is pretty low or your consumption pattern is somewhat different to mine.

Consumption pattern is reasonably similar, I guess the big difference just comes in the volume used yearly. I guess location may come into it also dependent on where people are located that can turn heating off earlier/later in year. All just interesting stuff to factor in really. An eye-opener if you will

Jan - Dec
18%16%13%3%3%2%3%3%3%4%14%19%

Woby_Tide

lightSwitch wrote: »

Woby_Tide,

That 800-700 Kwh/week is that from a gas boiler + electrics? Are you using about 9 units a day of gas? Do you have a condensing boiler and how big is your property?

128kwh/week must be without central heating or else the property is super insulated which is possible if you pay thousands to do it. it is also is possible in a normal home if you just take showers plus some cooking.

The figure was gas only, non-condensing 15 odd year old boiler in a relatively large 3 bed 1920's detached. It' got central heating and apart from the usual cavity wall insulation(at normal discounted gas company prices) too little loft insulation. The house actually is relatively cold in some parts due to badly thought out radiators in an extension, we're increasing those shortly so will see an increase in usage but certainly not to the rates that some acheive

overworked_underpaid

Correct me if I'm wrong, but my calculations show that for high consumption in the London Area, the cheapest option is Dual Fuel British Gas Click Energy 6 tarrif.

Can somebody confirm this?