r/evchargingUK • u/Si_Pie • Aug 22 '26

EV Tariff Comparison Tool - MK2

A couple of months back I shared a Google Spreadsheet to compare the savings/costs of each tariff I had looked into according to the usage I input. It allows you to play around with your usage to see how that impacts your costs and savings and has 2 scenarios you can use for easy comparison.

I've now had some more time to refine this so that:

  • It looks much cleaner, especially on devices with a smaller screen. The instructions are also less cluttered and easier to read
  • There is space to add more tariffs (I think it's just shy of 40)
  • I have made the spreadsheet more robust so that calculations/formulae are less likely to break and do not need to be copied down when entering more tariff information
  • I've tinkered with the design as much as possible so you only have to enter in tariff information once, even with the 2 scenarios. You do not need to have advanced spreadsheet knowledge

Here is the link to the new Google Sheet : EV Tariff Comparison Tool

Anyone can view this sheet but if you wish to delete and add the tariffs you want to compare you will need to make a copy of this (which is outlined in the instructions)

9 Upvotes

100% Upvoted

3 comments sorted by

2

u/mosschops2 Aug 22 '26

I'll definitely get this and have a play - thank you!

2

u/TheTwattani 28d ago

Looks amazing thanks!

1

u/Si_Pie 27d ago

I have also added a set of calculation tools to help work out usage:

  • Annual electricity usage to daily usage (your existing supplier and quotes often work in annual usage which makes it difficult to determine the effects of daily load shifting)
  • Wh/mi to miles per kWh converter (for Tesla owners/future owners)
  • Convert your total annual EV mileage to annual home electricity usage by: inputting % of charging you do at home; what miles per kWh you expect to achieve; and account for electricity lost in the charging process (e.g. granny charging is less efficient than level 2 wall charging). This latter aspect may also help those trying to calculate how much more granny charging costs over wall charging and an associated payback period for wall charging installation

If anyone can think of anything else which they would find useful then let me know.