I would like to construct an Excel spreadsheet to compare the fuel cost of an ICE car and the energy cost of the Model S for a given trip. Inputs for the ICE would be fuel cost per gallon and expected MPG. For the MS would be energy used and the cost per kWh from the utility company. Of course there would be an input for the length of the trip. I have a lot of experience with the basic functions of Excel but don't know how to handle the MS portion of the sheet. Your suggestions would be appreciated. Want to keep it reasonably simple. TIA

PM me with what you want to have done specifically. I have an excel guru in the house. can get it to u this weekend.

Others have made similar spreadsheets already: EV Calculations Electric vs Gas Comparison Spreadsheet | Tesla FutureTesla Future YMMV

Thanks for the link. Will have to study that for a bit. I was hoping for something simple, but that might not be possible.