Gomev
Distinguished Member
Following on from another thread where @Vipar wasn't sure whether it would be worthwhile switching to Go from the Standard Variable rate, I have created a simple spreadsheet to show the break even point between the 2 tariffs.
I have kept it very simple, taking no account of standing charge as we all have to pay that regardless. Also, no account of any conversion losses in the charging or of any switching of use from day to night for example washing machines.
If you know how much you use either daily or weekly or annually and the Octopus Go rates in your area this will work out the break even point between staying on a SV rate or switching to Octopus Go or vice versa.
The break even point is the number of kWh per week that you would need to use on the Go overnight rate in addition to the weekly home usage. So....
on Go cost is home use at day rate plus EV use at overnight rate
on SVR cost is home use plus EV use at day rate.
I have attached a spreadsheet so that anyone can use it to enter their own TARIFFS and DAILY consumption. (leave other fields alone to get results as I've not bothered with protecting anything
)
Feel free to improve it if you wish though to suit your own needs.
I have also included a screenshot here of the tariff in my area, Yorkshire with costs based on daily usage of between 5 and 20kWh per day. This should give a flavour for most as costs don't vary too much.
I have kept it very simple, taking no account of standing charge as we all have to pay that regardless. Also, no account of any conversion losses in the charging or of any switching of use from day to night for example washing machines.
If you know how much you use either daily or weekly or annually and the Octopus Go rates in your area this will work out the break even point between staying on a SV rate or switching to Octopus Go or vice versa.
The break even point is the number of kWh per week that you would need to use on the Go overnight rate in addition to the weekly home usage. So....
on Go cost is home use at day rate plus EV use at overnight rate
on SVR cost is home use plus EV use at day rate.
I have attached a spreadsheet so that anyone can use it to enter their own TARIFFS and DAILY consumption. (leave other fields alone to get results as I've not bothered with protecting anything

Feel free to improve it if you wish though to suit your own needs.
I have also included a screenshot here of the tariff in my area, Yorkshire with costs based on daily usage of between 5 and 20kWh per day. This should give a flavour for most as costs don't vary too much.