Joined
·
8,047 Posts
after a meet is had with Watford Ioniq the other week, he gave me a copy of spreadsheet he had created for cost per mile of the EV
I have taken the idea a stage further and used it to create a sheet to compare the costs of the 3 variants
sheet 1 compares the costs, you can enter mpg, cost per litre, cost per KHW (peak / offpeak) and it shows the cost per charge, and cost for 10100 miles / day in 10 miles steps
the PHEV takes into account the cost of electric and petrol according to the number of miles you do compared to EV mode range
sheet 2 is the mpg figures based on the percentage of EV mode you do
only alter the number s in red and you can see how the 3 models cost you
there are no macros, just basic formula
I have taken the idea a stage further and used it to create a sheet to compare the costs of the 3 variants
sheet 1 compares the costs, you can enter mpg, cost per litre, cost per KHW (peak / offpeak) and it shows the cost per charge, and cost for 10100 miles / day in 10 miles steps
the PHEV takes into account the cost of electric and petrol according to the number of miles you do compared to EV mode range
sheet 2 is the mpg figures based on the percentage of EV mode you do
only alter the number s in red and you can see how the 3 models cost you
there are no macros, just basic formula
Attachments

11.1 KB Views: 657