Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Doctorbass]

Ok guys, i have something for you that it's now time to share.
I made a tool in Excel to calculate AT WITCH SPEED IT IS BETTER TO RUN to get from point A to point B in the less time as possible to optimize your actions and manage your trip.
 It take account of charging power, initial battery SOC, battery size, time to  install charging setup the speed you have to run at, etc... I made it about 3 years ago for my 2000km trip and it work PERFECT !!

At first i tought i could make an apps with it and make money but hey.. money is not what make me more happy.. it's you all that discover the great benefit of EV transport guys and all great comments i receive from you for my various contributions.. 

so... time to pay it forward guys..!

Corrected version( June 5 2017)
Here is OPTITRIP EV calculator v1.3

[Killroy]

This is awesome.  I have wanted to do this myself. 

The most time efficient speed looks like 70 to 75 km/hr which is 43 to 47 miles/hr.  -Too Slow.

You can try back roads, but you are going to be adding miles and stops to that trip.

I see that you measured Wh/km.  Its important to take a good average on a smooth flat road.  If you are just looking at a instant value, then there will be some variance. 

It would be nice to see how sprocket changes effect this.

[Killroy]

Note, that the saved excel file does not have any calculation from Wh/km to kWh/km and there appears to be a error. 

[Doctorbass]

This is awesome.  I have wanted to do this myself. 

The most time efficient speed looks like 70 to 75 km/hr which is 43 to 47 miles/hr.  -Too Slow.

You can try back roads, but you are going to be adding miles and stops to that trip.

I see that you measured Wh/km.  Its important to take a good average on a smooth flat road.  If you are just looking at a instant value, then there will be some variance. 

It would be nice to see how sprocket changes effect this.

I made various test and measured the Wh/km at all speed and unless you run your motor in the field weakening region ( above 4000rpm for the average  Zero model), it will remain nearly the same efficiency. I also measured the variation of using a 75-7 motor on my 66V actual 2012 powertrain at 90kmh and also using it but with the 75-7 hybrid witch is a motor with faster speed for the same volt  and it does not affect alot efficiency. As i said if you keep it under 4000rpm it will remain efficient from my experience

Doc

[Doctorbass]

Error corrected from V1.2 to V1.3

[BrianTRice@gmail.com]

Thank you! This certainly adds in a number of factors that reveal planning nuances.

I should note that my work in progress spreadsheets manage to work in US customary units, and it was quite a task to convert your energy consumption figures to that accurately, since I needed to cross-verify my modeling. (Often even a good tool like Mathematica doesn't make unit work straightforward when working in different dimensions.)

[BrianTRice@gmail.com]

Okay, this spreadsheet indicates that a stock 2016-2017 4-brick bike (~12 kWh usable) with a 0.95C charge rate (default Zero setting without an override, yielding 11.4kW) has an optimum travel (air) speed of about 65mph, which is fair.

For a single J station producing 6.6kW, that immediately goes to 55mph.

A 5-brick bike (power tank) doesn't budge the 6.6/55 figure (appropriate), but 1C on that 5-brick bike does budge the speed up to a broad 65-70mph, mainly because it's not iterating trip legs very much.

So, this seems to be working analogously to the planning tables I'd worked out.

[Doctorbass]

V1.3 working and corrected now

Doc

[Doctorbass]

Next correction:

Display 0 for each speed below the max efficient speed  in the column where the "Extra charge time from optimum".

I have somme difficulty with some "IF" formula and case...

Doc

[BrianTRice@gmail.com]

As I found with your earlier metric tabulations, the drag / energy consumption curve is very difficult to convert to imperial measurements, or there is still some error in your curve, if the 145Wh/mi at 60mph data prediction is consistent.

This curve is more conservative than before, indicating a 65mph optimum speed for 24kW rate / 15kWh usable capacity.

For the 1C 2016 4-brick model, 11.4kW rate / 12kWh usable capacity yields an optimum speed of 52mph.