openair Posted July 15, 2015 at 02:26 AM Report Share Posted July 15, 2015 at 02:26 AM (edited) Worked up a spreadsheet to calc a MPG Dollar Equivalent using what was spent on KWH to add an amount of gallons that could have been bought for the same amount. Or L/100KM$E as well. Green cells can be changed to enter your own data if anyone is interested in making a copy. The two different sections for each MPG and L/100KM allow data from MFM or within the car. You can specify cost per gallon, litre, kw and a charging efficiency. Will clean it up, make it more user friendly and maybe hide or work in some of the less useful data eventually. Any suggestions or corrections to my math are welcome! https://docs.google.com/spreadsheets/d/1Te_43B1H04qN3R-j3wt-EuyeVWUFKYjq-mZzcRid5EA/edit?usp=sharing Edited July 15, 2015 at 02:29 AM by openair Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.