I am surprised that they are pasing out gas. I Can see phasing out oil and solid fuel, but natural gas burns extremely clean. Natural Gas is primarily Methane. The byproducst of burning methane is carbon dioxide and water vapor which are the same as what we exhale.
Didn't recognise the avatar change
How does this one work for you: Tesla - Cost to home charge by provider v3 - Advanced
I should change it more often
Ok... and onto how it works... looks great... easy to follow, all good... but I think there may be something up with the calcs.
Looking at a bulb bill I had from 22nd July to 21st August - I used 825Kwh energy (this is pre-EV too!)... so divide by 30, and we're at 27.50Kwh per day.
Pop that into your sheet, and 0 out the special rate. Likewise 80-80 on the charge, so zero cost Gives £5.16 per day on Bulb, so multiply by 30, and it's £154.80.
My bulb bill, including daily (rip off) Standing Charge, and VAT is £123.18 for that same period. So we're a bit out.
I did the same for Aug to Sept - 744 Kwh, total cost inc VAT, standing charge etc.. £112.10 - your sheet says £140.80
And my final bill (Sept to Oct) - 584Kwh over 23 days... Bulb charged £87.55 inc VAT and standing charge - your sheet says: £109.94
Something's bumping the cost up.
It's still great as a comparison tool, and I know, it's designed to look at EV charging, not what'll save you money on your leccy bill, but since you added that to stop people jumping just to charge their EV and falling foul of overall higher cost, I offer the above merely as feedback/validation.
Please please please don't take any of this as criticism from me, that's not what its intended for.
Thanks @phil4 - have you factored in the price increase from Bulb? I'm using the new prices, which I think kicked in for November? (or at least late October). Are you/were you also on the E7 meter? The price calc there is on the E7 prices which are more expensive in the day than the single rate ones
I'll double check the calc, but the house price one doesn't factor in any kind of losses etc.. it is just kWhs * price + standing charge
I moved to Octopus mid Oct, so the prices listed are the old Bulb ones, so that may be the reason for the discrep, although it looks a bit big for that. And no, I wasn't on an E7 meter, just a plain old non-smart meter, so if you're using them and they're more expensive, then it's even stranger that there's a big gap.
These are the current Bulb prices:
Electricity Day Unit Rate: 18.0148p per kWh
Electricity Night Unit Rate: 8.9366p per kWh
Standing charge - 21.0714p per day (£76.91 per year)
There are different tariffs for different areas, so here, the Bulb Varifair E7 tariff is currently:
17.5990 p/kWh peak rate
9.2106 p/kWh off-peak rate
21.1575 p/day standing charge (£77.22 per year)
Cheapest E7 rate here is currently from green.energy:
13.8285 p/kWh peak rate
9.0180 p/kWh off-peak rate
15.0000 p/day standing charge (£54.75 per year)
I believe that many electricity suppliers have different rates for different regions.
95% is a bit high, as a fair bit of the country is off the gas grid (unsurprisingly, we are, as are all the villages around here). The current figures for home heating are about 85% gas, 6% oil, 6% electricity, 3% solid fuel. Gas is planned to be phased out eventually. At some point in the next ten years there is likely to be a ban on fitting gas heating to new homes (was planned to come into force in 2025, but I believe this has been put on hold for now).