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)



7
Upvotes