View Single Post
Old 01-24-2018, 03:20 AM   #1 (permalink)
redpoint5
Human Environmentalist
 
redpoint5's Avatar
 
Join Date: Aug 2010
Location: Oregon
Posts: 12,467

Acura TSX - '06 Acura TSX
90 day: 24.19 mpg (US)

Lafawnda - CBR600 - '01 Honda CBR600 F4i
90 day: 47.32 mpg (US)

Big Yeller - Dodge/Cummins - '98 Dodge Ram 2500 base
90 day: 21.82 mpg (US)

Chevy ZR-2 - '03 Chevrolet S10 ZR2
90 day: 17.14 mpg (US)

Model Y - '24 Tesla Y LR AWD
Thanks: 4,213
Thanked 4,391 Times in 3,365 Posts
Vehicle Total Cost of Ownership Calculator

A few years ago I searched for a website that would allow me to compare total cost of ownership of any two vehicles given my estimated costs. Not finding anything, I put together a spreadsheet and shared it on Google Drive.

I've now updated it to allow plug-in hybrids, and fixed other minor issues. It's now capable of comparing any two vehicles that use petrol, electricity, or a combination of both. It also provides lots of other data such as fuel or electricity cost per mile.

Make sure you enter values in each cell even if the number is 0, or you don't know what to put. You can skip some of the fields by entering 0 and still get a relative cost difference between vehicles. You can enter info for just 1 vehicle if you only want to know the total cost of ownership, but aren't interested in a comparison with another vehicle.

Since this is a public sheet, some fields are locked to prevent the formula or description getting messed up. I recommend downloading it so you have full control to modify, and won't accidentally fight someone else who is using it at the same time.

Let me know if there are errors, I need to clarify something, or add features.

Note that the "Estimated % of miles driven on battery alone" field must be answered. If the vehicle is petrol only, enter 0. If it's EV only, enter 100. If it's a plug-in hybrid, estimate what percentage of miles will be run on battery alone.

Here it is: https://drive.google.com/open?id=1rb...2dCJSLxp5ne6Q4

The link is in my signature too.

__________________
Gas and Electric Vehicle Cost of Ownership Calculator







Give me absolute safety, or give me death!
  Reply With Quote
The Following 3 Users Say Thank You to redpoint5 For This Useful Post:
Daox (01-24-2018), LeanBurn (01-24-2018), Xist (01-24-2018)