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
EV conversion range calculator (excel)
-
- Posts: 3265
- Joined: Mon Dec 24, 2018 1:37 pm
- Location: Slovenia
- Has thanked: 80 times
- Been thanked: 234 times
- Contact:
Re: EV conversion range calculator (excel)
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
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)
Looks like a nice calculation but for me the excel shows static (no calculations, just static values in the cells).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
- tmotion
- Posts: 55
- Joined: Fri Sep 27, 2019 7:16 pm
- Location: Rijswijk, The Netherlands
- Has thanked: 2 times
- Been thanked: 5 times
Re: EV conversion range calculator (excel)
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
@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)
Working like a charm now (also online).tmotion wrote: ↑Wed Mar 11, 2020 12:21 pm 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)
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)
post deleted
Huebner VCU controlling a Gen2 Prius Inverter powering an MGR
"Talent is equally distributed but opportunity is not." - Leila Janah
"Talent is equally distributed but opportunity is not." - Leila Janah
-
- Posts: 898
- Joined: Fri Apr 26, 2019 5:40 pm
- Has thanked: 291 times
- Been thanked: 177 times
Re: EV conversion range calculator (excel)
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.
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.