Hi,
I finished refining a spreadsheet that with the EPA roll-down coefficients predicts the Wh/mi of my 2019 Tesla Model 3 Standard Range Plus. But I need to validate the spreadsheet against other model year EVs.
What I need are:
The difference between your benchmark and the EPA developed, chart will let us know if it is working. Understand there may be tweaks to handle the difference in drivetrain efficiency but they should be fairly small, less than 10%.
If the chart works for you, I'll share the formulas and OpenSource spreadsheet.
Thanks,
Bob Wilson
I finished refining a spreadsheet that with the EPA roll-down coefficients predicts the Wh/mi of my 2019 Tesla Model 3 Standard Range Plus. But I need to validate the spreadsheet against other model year EVs.
What I need are:
- Year
- Manufacturer
- Model
The difference between your benchmark and the EPA developed, chart will let us know if it is working. Understand there may be tweaks to handle the difference in drivetrain efficiency but they should be fairly small, less than 10%.
If the chart works for you, I'll share the formulas and OpenSource spreadsheet.
Thanks,
Bob Wilson