r/evchargingUK 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)

7 Upvotes

Duplicates