ElectricMotorcycleForum.com

  • June 25, 2017, 11:21:46 PM
  • Welcome, Guest
Please login or register.

Login with username, password and session length
Advanced search  

News:

Electric Motorcycle Forum is live!

Pages: [1]

Author Topic: OPTITRIP EV calculator v1.3 You will love it !  (Read 302 times)

Doctorbass

  • Battery tech
  • Hero Member
  • *****
  • Posts: 773
    • View Profile
    • Endless-sphere.com
OPTITRIP EV calculator v1.3 You will love it !
« on: June 04, 2017, 10:42:15 PM »

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..  ;D

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

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

« Last Edit: June 06, 2017, 06:11:28 AM by Doctorbass »
Logged
-Fastest ebike 106km/h  on flat , 19.875 sec on the 1/4 mile drag racing!
113kmh Giant_http://www.evalbum.com/3406
E-trike_]http://www.evalbum.com/3776]

T w i t t e r  :     http://twitter.com/DocbassMelancon

Killroy

  • Sr. Member
  • ****
  • Posts: 370
    • View Profile
Re: OPTITRIP EV calculator You will love it !
« Reply #1 on: June 04, 2017, 11:10:20 PM »

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.
Logged

Killroy

  • Sr. Member
  • ****
  • Posts: 370
    • View Profile
Re: OPTITRIP EV calculator You will love it !
« Reply #2 on: June 04, 2017, 11:16:44 PM »

Note, that the saved excel file does not have any calculation from Wh/km to kWh/km and there appears to be a error. 
« Last Edit: June 05, 2017, 08:51:11 AM by Killroy »
Logged

Doctorbass

  • Battery tech
  • Hero Member
  • *****
  • Posts: 773
    • View Profile
    • Endless-sphere.com
Re: OPTITRIP EV calculator You will love it !
« Reply #3 on: June 05, 2017, 01:00:02 AM »

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
Logged
-Fastest ebike 106km/h  on flat , 19.875 sec on the 1/4 mile drag racing!
113kmh Giant_http://www.evalbum.com/3406
E-trike_]http://www.evalbum.com/3776]

T w i t t e r  :     http://twitter.com/DocbassMelancon

Doctorbass

  • Battery tech
  • Hero Member
  • *****
  • Posts: 773
    • View Profile
    • Endless-sphere.com
Re: OPTITRIP EV calculator You will love it !
« Reply #4 on: June 05, 2017, 01:05:44 AM »

Error corrected from V1.2 to V1.3
« Last Edit: June 06, 2017, 06:05:51 AM by Doctorbass »
Logged
-Fastest ebike 106km/h  on flat , 19.875 sec on the 1/4 mile drag racing!
113kmh Giant_http://www.evalbum.com/3406
E-trike_]http://www.evalbum.com/3776]

T w i t t e r  :     http://twitter.com/DocbassMelancon

BrianTRice

  • Hero Member
  • *****
  • Posts: 2038
  • Nerdy Adventurer
    • View Profile
    • Personal site
Re: OPTITRIP EV calculator You will love it !
« Reply #5 on: June 05, 2017, 06:27:36 AM »

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.)
« Last Edit: June 05, 2017, 06:40:38 AM by BrianTRice »
Logged
2016 Zero DSR, 2013 Zero DS, 2012 Suzuki DL-650 V-Strom Adv

BrianTRice

  • Hero Member
  • *****
  • Posts: 2038
  • Nerdy Adventurer
    • View Profile
    • Personal site
Re: OPTITRIP EV calculator You will love it !
« Reply #6 on: June 05, 2017, 06:39:38 AM »

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.
Logged
2016 Zero DSR, 2013 Zero DS, 2012 Suzuki DL-650 V-Strom Adv

Doctorbass

  • Battery tech
  • Hero Member
  • *****
  • Posts: 773
    • View Profile
    • Endless-sphere.com
Re: OPTITRIP EV calculator You will love it !
« Reply #7 on: June 05, 2017, 08:18:19 PM »

V1.3 working and corrected now

Doc
« Last Edit: June 06, 2017, 06:06:27 AM by Doctorbass »
Logged
-Fastest ebike 106km/h  on flat , 19.875 sec on the 1/4 mile drag racing!
113kmh Giant_http://www.evalbum.com/3406
E-trike_]http://www.evalbum.com/3776]

T w i t t e r  :     http://twitter.com/DocbassMelancon

Doctorbass

  • Battery tech
  • Hero Member
  • *****
  • Posts: 773
    • View Profile
    • Endless-sphere.com
Re: OPTITRIP EV calculator v1.3 You will love it !
« Reply #8 on: June 06, 2017, 06:09:47 AM »

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
Logged
-Fastest ebike 106km/h  on flat , 19.875 sec on the 1/4 mile drag racing!
113kmh Giant_http://www.evalbum.com/3406
E-trike_]http://www.evalbum.com/3776]

T w i t t e r  :     http://twitter.com/DocbassMelancon

BrianTRice

  • Hero Member
  • *****
  • Posts: 2038
  • Nerdy Adventurer
    • View Profile
    • Personal site
Re: OPTITRIP EV calculator v1.3 You will love it !
« Reply #9 on: June 07, 2017, 12:38:08 AM »

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.
Logged
2016 Zero DSR, 2013 Zero DS, 2012 Suzuki DL-650 V-Strom Adv
Pages: [1]