Elmoto v2.0 Data sheet

[Coninsan]

Hello

You may know the Lennon rodgers excel sheet which you can use to predict the range and top speed for your electric motorcycle build.
Well, that is what I consider version the elmoto sheet version 1.0, or stricly speaking 1.5.

The elmoto sheet as made by Lennon Rodgers features feature for:
- Calculating your electric motorcycles;
Weight based on the weight of the rider, components and rolling chassis.
Range based on your batteries specifications.
Top speed based on your motors RPM.
And power required based on aerodynamic requirements.

I've been working on improving the look, feel and workings of Lennon Rodgers sheet as well as bring new features to its capabilities in form of the Elmoto excel sheet V2.0, and here it is.

We are currently up to version 2.18

Version 2.0 Has a number of added features and improvements over the Elmoto 1.0 sheet.
- The user interface has been boiled down for easier viewing
- Full support for and all readouts now in Metric form as well as Imperial.
- Added support for incremental motor readouts, dynomometer readouts.
This feature supports:
Any known motor types and strengths.
Motor output up to 8000 RPM.
- Added graphical interpretaion of motor readout.
- Added a more accurate method of determening top speed.
Graphical readout off motor power up against aerodynamic and rolling resistances.
And if this method doesn't pinpoint your motorcycles topspeed then this sheet also features RPM limited top speed.

Changelog - All the changes and additions made since version 2.0

Version 2.1
- Improved the interface slightly.
- Improved calculations regarding motor readout.
- Added graphical interpretations of Range, Acceleration and Costs.
- Added calculations for determinating the 0-60, 0-100, 1/4 mile times and time to top speed.
- Now factors Aerodynamic drag and Chain resistances in all calculations where these are relevant.

Version 2.15
- Added note stating origin of the sheet.
- Minor fixes of spelling mistakes or bugs.
- Some small tweaks to the graphs to prevent them from going out of control.
- Added support for limited motor opperation.
The motor output is now scaled according to battery limit in the form of rated continuous discharge.
- Battery life and costs now also factor battery rated continuous discharge.

Version 2.16
- Now factors both Max and continuous battery discharge.
- Limited motor operation is now based on Maximum battery discharge and not continuous (how foolish of me)
- Amps at City, Country road and Highway speeds added under the Range tap.

Version 2.18
- Added a "controller specifications" box.
- Controller efficiency now factors in range calculations.
- Thanks to DaveAK motor output is now regulated as a function of controller and battery rating.
- Voltage Sag now factors in motor performance, range, top speed and acceleration calculations.

To view this sheet you need either Microsoft Excel 97 or newer, or any program which is combatible with the .xls format.

You are welcome to post any problems you find with this sheet or any suggestions you might have.

Enjoy

[frodus]

Hey, I'm gonna try to plug in all my crap and see what I come up with.

Thanks a lot Steffen

[Coninsan]

Hey, I'm gonna try to plug in all my crap and see what I come up with.
Thanks a lot Steffen

Your welcome, just let me know how it fairs and if any problems arise.

[Nuts & Volts]

Nice work
Couple things I noticed
-You should make frontal area a user inputed parameter
-You should have HP be automatically calculated from RPM and torque (RPM*torque(ftlbs)/5252=HP)
-Your max Amps of the motor can be very misleading because it doesnt take into account voltage sag and for AC it doesnt take into account difference between V Supply and V Motor
-I dont really think continuous power is appropriate to calculate because it is thermally depended

Some more in depth additions.
-You could make a graph that plots range at different speeds, just use 2 or 5 mph increments
-Any easy way to take into account voltage sag at different limits
-You may be able to create a crude 0-60 acceleration using the max torque values at each motor speed (i have an excel sheet at home that does this, ill upload later)

Not trying to complain, just trying to help. I love the layout and it works much simpler than the Lennon Spreadsheet
Thanks!

[Coninsan]

Nice work
Couple things I noticed
Not trying to complain, just trying to help. I love the layout and it works much simpler than the Lennon Spreadsheet
Thanks!

This is very good input, keep it up. To make this much more user friendly than the Lennon Rodgers sheet was also one of my major goals, so many of the parameters which were just used for calculations have been moved to a seperate sheet.

-You should make frontal area a user inputed parameter

It already is, I just forgot to mark it as such.

-You should have HP be automatically calculated from RPM and torque (RPM*torque(ftlbs)/5252=HP)

From trying it out on my own data, it seems pretty spot on, but is this accurate enough for all motor types?

-Your max Amps of the motor can be very misleading because it doesnt take into account voltage sag and for AC it doesnt take into account difference between V Supply and V Motor
-I dont really think continuous power is appropriate to calculate because it is thermally depended

I hear you on these, the data you've mentioned is useless anyway, not used in any calculations, so if it's in the way it'll be removed in the next version.

Some more in depth additions.
-You could make a graph that plots range at different speeds, just use 2 or 5 mph increments

Functionality for this feature is already built into the sheet, though it is not in such small increments since it is based on motor RPM. My focus has mainly been to get the major and most common speeds integrated. But a graph might sneak inn in the future, should be simple enough.

-Any easy way to take into account voltage sag at different limits

I am sorry but that is beyond my skill, yet if you can find a way to take it into account please do tell.

-You may be able to create a crude 0-60 acceleration using the max torque values at each motor speed (i have an excel sheet at home that does this, ill upload later)

Thanks, lets see if we can get that into a future version.

[Coninsan]

-You may be able to create a crude 0-60 acceleration using the max torque values at each motor speed (i have an excel sheet at home that does this, ill upload later)

No excel sheet yet what gives?

But basicly, I've just finished a fomula based on the info given here
Which gives the specific time it takes to reach a given speed based on the motors HP. This leans on the fact that 1 HP = 550 ft-lbs/sec.

Basicly:
Time-to-speedX=(HP*550)/(Weight/32,2*SpeedX-in-ft/sec^2)

And when the Elmoto sheet already contains data for speeds given at different motor RPM's this fomula would give a crude curve for acceleration based on motor HP.

I guess I'll be working late tonight

[Nuts & Volts]

Shoot man. I completely forgot, i even wrote it down to do it. Ill send myself an email to remind me to upload it tonight. Basically the sheet factors in gearing and weight but ignores aero drag. It calculates the constant torque range of the motor then the constant power state of the motor in 5mph increments. It then calculates the time inbetween each step.

Hopefully I get my act together tonight

[Coninsan]

Ahh no problem.

Basicly what I've worked out just now plots out the acceleration curve in a graph
With time in seconds on the Y-axis and speed on the X-axis
It's based on speed at increments of 500 in motor RPM, the motors HP at said RPM and the motrocycles weight.

I'm figuring that aerodynamic resistance wouldn't matter much as long as the power at said speed is more than required by aerodynamic and rolling resistances. And these figures are accounted for in the top speed graph.

[Nuts & Volts]

Ahh no problem.

Basicly what I've worked out just now plots out the acceleration curve in a graph
With time in seconds on the Y-axis and speed on the X-axis
It's based on speed at increments of 500 in motor RPM, the motors HP at said RPM and the motrocycles weight.

I'm figuring that aerodynamic resistance wouldn't matter much as long as the power at said speed is more than required by aerodynamic and rolling resistances. And these figures are accounted for in the top speed graph.

Thats exactly what the one I have does but it just asks for max torque and base speed. You're a smart man sir! If I can remember I may try to implement a formula/model to take into account aero, it gets tricky with the v^2 term.

I have always wanted to update this spreadsheet, but excel has always frustrated me and i donta have enough matlab experience. Keep up the great work and ill try to keep helping

[Coninsan]

Thats exactly what the one I have does but it just asks for max torque and base speed. You're a smart man sir! If I can remember I may try to implement a formula/model to take into account aero, it gets tricky with the v^2 term.

I have always wanted to update this spreadsheet, but excel has always frustrated me and i donta have enough matlab experience. Keep up the great work and ill try to keep helping

If you can get aero to factor and show me how I would be gratefull
Rigth now I'm working on implemening the features you suggested earlier, easy stuff compared to getting the top speed graph working.

Anything else I should look into?