EV conversion range calculator (excel)

Introduction and miscellaneous that we haven't created categories for, yet
Post Reply
User avatar
tmotion
Posts: 55
Joined: Fri Sep 27, 2019 7:16 pm
Location: Rijswijk, The Netherlands
Has thanked: 2 times
Been thanked: 5 times

EV conversion range calculator (excel)

Post 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
arber333
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)

Post 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
Bentto
Posts: 27
Joined: Thu Feb 13, 2020 6:55 pm
Location: The Netherlands

Re: EV conversion range calculator (excel)

Post 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).
User avatar
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)

Post 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
Bentto
Posts: 27
Joined: Thu Feb 13, 2020 6:55 pm
Location: The Netherlands

Re: EV conversion range calculator (excel)

Post by Bentto »

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
Working like a charm now (also online).
Emyr
Posts: 8
Joined: Thu May 16, 2019 3:13 pm

Re: EV conversion range calculator (excel)

Post by Emyr »

When I looked at it earlier, the in-browser view was read-only, but was editable (with formulas) when downloaded.
User avatar
ZooKeeper
Posts: 507
Joined: Mon Mar 30, 2020 10:23 pm
Location: USA

Re: EV conversion range calculator (excel)

Post by ZooKeeper »

post deleted
Huebner VCU controlling a Gen2 Prius Inverter powering an MGR
"Talent is equally distributed but opportunity is not." - Leila Janah
MattsAwesomeStuff
Posts: 898
Joined: Fri Apr 26, 2019 5:40 pm
Has thanked: 291 times
Been thanked: 177 times

Re: EV conversion range calculator (excel)

Post 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.
Post Reply