Page 1 of 1
EV conversion range calculator (excel)
Posted: Tue Mar 10, 2020 8:45 pm
by tmotion
Not sure if this is already available, but for my project I made a excel spreadsheet to calculate the expected range. Please feel free to use this as well and to comment if you have improvement suggestions:
https://1drv.ms/x/s!AvneBlSBcjbAjoh231h ... A?e=LUB0mQ
I checked the values with a Nissan leaf 24kwh and my own Zoe 40kwh. They seem to be quite close to the real world. For my own conversion of a VW T3 campervan with a 75kWh pack I end up with a range of 210km when driving 100km/h. But it's a brick house on wheels
When cruising at an 80 km/h average hippie speed this already becomes 275km
Re: EV conversion range calculator (excel)
Posted: Tue Mar 10, 2020 9:07 pm
by arber333
Back in 2012 when i started i recorded my regular route to work with my GPS phone. I recorded in 1s intervals so i wouldnt have too much data.
I setup energy calculation from another EVer document, cant remember who exactly, but i had to disregard regen since i got values in negative side. I simply set that to 0.
I experimented with various configurations but it was absolutely creepy how accurate my calculation came to actual data.
You can get my excell file here...
https://mazdamx3ev.files.wordpress.com/ ... gy-mx3.xls
A
Re: EV conversion range calculator (excel)
Posted: Wed Mar 11, 2020 9:52 am
by Bentto
tmotion wrote: ↑Tue Mar 10, 2020 8:45 pm
Not sure if this is already available, but for my project I made a excel spreadsheet to calculate the expected range. Please feel free to use this as well and to comment if you have improvement suggestions:
https://1drv.ms/x/s!AvneBlSBcjbAjoh240R ... w?e=dqGKsV
password = openinverter
I checked the values with a Nissan leaf 24kwh and my own Zoe 40kwh. They seem to be quite close to the real world. For my own conversion of a VW T3 campervan with a 75kWh pack I end up with a range of 210km when driving 100km/h. But it's a brick house on wheels
When cruising at an 80 km/h average hippie speed this already becomes 275km
Looks like a nice calculation but for me the excel shows static (no calculations, just static values in the cells).
Re: EV conversion range calculator (excel)
Posted: Wed Mar 11, 2020 12:21 pm
by tmotion
Thats an extensive one arber333. I tried to keep it simple. In the end it is all about drag.
@Bentto, I updated the file. If you open in in excel is it still static?
https://1drv.ms/x/s!AvneBlSBcjbAjoh231h ... A?e=LUB0mQ
Re: EV conversion range calculator (excel)
Posted: Wed Mar 11, 2020 3:40 pm
by Bentto
Working like a charm now (also online).
Re: EV conversion range calculator (excel)
Posted: Wed Mar 11, 2020 10:04 pm
by Emyr
When I looked at it earlier, the in-browser view was read-only, but was editable (with formulas) when downloaded.
Re: EV conversion range calculator (excel)
Posted: Sat Apr 04, 2020 2:16 pm
by ZooKeeper
post deleted
Re: EV conversion range calculator (excel)
Posted: Sat Apr 04, 2020 5:13 pm
by MattsAwesomeStuff
I've always used this one:
http://www.enginuitysystems.com/EVCalculator.htm
The one posted above is pretty hardcoded to EV-relevant things 10 years ago.
Also, it defaults to low rolling resistance tires, which have only 10% the rolling resistance of normal tires.
Even at 60mph, normal tires typically double your power requirements. That's why aero drag seems to be the only concern by default.