Power calculator

A place to list links to sources for EV related parts and services.
User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Power calculator

Post by Miles » Mar 17 2007 10:17am

This spreadsheet calculator was posted on the Power Assist list sometime ago. Credit for the program to Dave Everett. I've corrected one of the slope conversion formulas, that's all.
Attachments
Ebike powercalc rev.1.zip
(5.96 KiB) Downloaded 1312 times

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Post by Miles » Jun 07 2007 3:44pm

Just tidied this up a bit.
Attachments
Ebike powercalc rev.2.zip
(5.91 KiB) Downloaded 812 times

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Post by Miles » Jun 30 2007 5:03am

Version 3 attached.

The expressions used for the formula in cell G7 were revised to enable the spreadsheet to function correctly on Google Spreadsheets.

You can now use this calculator without the need for Microsoft Excel.

Create an account with Google and upload the file to http://docs.google.com/

Please post any bugs/suggestions here.

Miles

P.S. I'm intending to append a table of "typical values" to the spreadsheet, so that people will be able to enter the value that most closely corresponds to their specific case.
Attachments
Ebike powercalc rev. 3.zip
(6.02 KiB) Downloaded 991 times

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Post by Miles » Sep 05 2007 9:49am

If you don't have spreadsheet software, you can also upload this program to: http://www.editgrid.com/site and use it online. Editgrid seems to be better than Google Docs.

PJD   100 W

100 W
Posts: 227
Joined: Nov 01 2007 8:39pm
Location: Pittsburgh, PA, US

Post by PJD » Nov 01 2007 10:07pm

As far as power calculations for climbing various grades, a while back I set up a spreadsheet so I could use the various slope hills in my area, along with a drag force calculation as a sort of poor-boy dynamometer test.

The spreadsheet is attached. It provided actual motor performance graphs for a hub-motored bike, or it could be modified easily for a chain or reduction gear.

It gives the calculation results and both metric and US units, but the raw data has to be in US units, sorry.

The numbers entered on it representing the actual performance on my e-max.

User avatar
fechter   100 GW

100 GW
Posts: 12894
Joined: Dec 31 2006 3:23pm
Location: California Bay Area, USA

Post by fechter » Nov 02 2007 9:02am

Whoa.. almost 5kw. That's a pretty spunky scooter.
"One test is worth a thousand opinions"

deardancer3   10 kW

10 kW
Posts: 957
Joined: Dec 09 2007 10:43am
Location: Rocky Mtns/ San Diego

Post by deardancer3 » Dec 09 2007 11:57am

I like this power calculator; thought I would share.

(It lets you easily swap out different bike frames with default setting)

http://www.kreuzotter.de/english/espeed.htm


Dick in colorado

User avatar
paultrafalgar   10 kW

10 kW
Posts: 915
Joined: Feb 15 2008 5:41am
Location: Forest of Dean, UK

Re:

Post by paultrafalgar » Jun 11 2008 6:40am

PJD wrote:As far as power calculations for climbing various grades, a while back I set up a spreadsheet so I could use the various slope hills in my area, along with a drag force calculation as a sort of poor-boy dynamometer test.

The spreadsheet is attached. It provided actual motor performance graphs for a hub-motored bike, or it could be modified easily for a chain or reduction gear.

It gives the calculation results and both metric and US units, but the raw data has to be in US units, sorry.

The numbers entered on it representing the actual performance on my e-max.
That's a fascinating spreadsheet, PJD. What I find interesting is comparing Row 12 with Row 16.
You have halved (approx) the speed and EVEN though it's doubled the slope, you use 60% of the power!!!
SLOWING DOWN ON THE CLIMB is the way to go.
If we knew what it was we were doing, it would not be called research, would it? Albert Einstein
A paranoid is someone who has SOME idea of what's going on. Allen Ginsberg(?)
If the greatest pleasure is giving, be selfish - give pleasure.

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Re: Re:

Post by Miles » Jun 11 2008 6:52am

paultrafalgar wrote: SLOWING DOWN ON THE CLIMB is the way to go.
Slowing down makes very little difference to the total energy consumed to climb hills.....

User avatar
paultrafalgar   10 kW

10 kW
Posts: 915
Joined: Feb 15 2008 5:41am
Location: Forest of Dean, UK

Re: Power calculator

Post by paultrafalgar » Jun 11 2008 7:05am

Not according to PJD's spreadsheet.
If we knew what it was we were doing, it would not be called research, would it? Albert Einstein
A paranoid is someone who has SOME idea of what's going on. Allen Ginsberg(?)
If the greatest pleasure is giving, be selfish - give pleasure.

User avatar
paultrafalgar   10 kW

10 kW
Posts: 915
Joined: Feb 15 2008 5:41am
Location: Forest of Dean, UK

Re:

Post by paultrafalgar » Jun 11 2008 7:09am

Miles wrote:If you don't have spreadsheet software, you can also upload this program to: http://www.editgrid.com/site and use it online. Editgrid seems to be better than Google Docs.
Just a little plug for OpenOffice. You don't need to be without a spreadsheet! OpenOffice is FREE for both Windows and Linux (probably Mac as well, I don't know).
IMHO better than Microsoft Excel by far.
:D
If we knew what it was we were doing, it would not be called research, would it? Albert Einstein
A paranoid is someone who has SOME idea of what's going on. Allen Ginsberg(?)
If the greatest pleasure is giving, be selfish - give pleasure.

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Re: Power calculator

Post by Miles » Jun 11 2008 7:14am

If you halve your speed you take twice as long to climb the hill.....

Sure, we know the power required to overcome air resistance goes up with the cube of the speed but if the power required to climb goes up linearly then slowing down on hills will have less effect on the total energy consumed than it would on the flat.

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Re: Re:

Post by Miles » Jun 11 2008 7:16am

paultrafalgar wrote:
Miles wrote:If you don't have spreadsheet software, you can also upload this program to: http://www.editgrid.com/site and use it online. Editgrid seems to be better than Google Docs.
Just a little plug for OpenOffice. You don't need to be without a spreadsheet! OpenOffice is FREE for both Windows and Linux (probably Mac as well, I don't know).
IMHO better than Microsoft Excel by far.
:D
I certainly wouldn't disagree with this :D

I moved from Excel '98 to Open Office Calc after trying Microsofts' latest.......

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Re: Power calculator

Post by Miles » May 13 2009 12:31pm

Latest version, in ODS format:
Attachments
Ebike powercalc Rev. 4.ods
(25.32 KiB) Downloaded 776 times

Eric   10 mW

10 mW
Posts: 32
Joined: Sep 17 2008 9:17am
Location: Maltby, WA

Re: Power calculator

Post by Eric » May 21 2009 8:27pm

Am I the only one who cannot open this due to its password protection? It probably works fine in other spreadsheets, but Xcel is having issues.
Eric

User avatar
paultrafalgar   10 kW

10 kW
Posts: 915
Joined: Feb 15 2008 5:41am
Location: Forest of Dean, UK

Re: Power calculator

Post by paultrafalgar » May 22 2009 3:15am

Eric wrote:Am I the only one who cannot open this due to its password protection? It probably works fine in other spreadsheets, but Xcel is having issues.
Eric
It's an open-source format that OpenOffice uses, I'm not sure if Microsoft recognises/tolerates importation of .ods, but if you ask Miles nicely, he will convert it using Openoffice to Microsoft .xls format! BTW IMHO Openoffice calc is vastly superior to Excel and it's a free download, so why not get a copy that runs on Winders (if you must use a c**p operating system. :D )
If we knew what it was we were doing, it would not be called research, would it? Albert Einstein
A paranoid is someone who has SOME idea of what's going on. Allen Ginsberg(?)
If the greatest pleasure is giving, be selfish - give pleasure.

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Re: Power calculator

Post by Miles » May 22 2009 4:26am

Hi Eric,

Here's an older version in Excel format and a conversion of the latest from .ods to .xls:
Attachments
Ebike powercalc Development Excel.xls
(83 KiB) Downloaded 796 times
Ebike powercalc Development1 Excel.xls
(24.5 KiB) Downloaded 977 times

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Re: Power calculator

Post by Miles » Sep 14 2010 1:37am

Revision 5.

- Added breakdown of torque at the wheel.

- Altered background colours of cells.
Attachments
Ebike powercalc rev.5.ods
(25.53 KiB) Downloaded 464 times

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Re: Power calculator

Post by Miles » Sep 14 2010 8:27am

Revision 6. Simplified version.

- Removed battery characteristics; motor efficiency and torque inputs.

- Removed distance and amps outputs

- Added motor torque output.

OpenOffice format (for Excel format see 2 posts down).
Attachments
Ebike Powercalc Rev. 6.ods
(21.5 KiB) Downloaded 880 times
Powercalc screenshot.jpg

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Re: Power calculator

Post by Miles » Sep 21 2010 7:53am


User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Re: Power calculator

Post by Miles » Sep 21 2010 7:57am

Revision 6 as an Excel file:
Attachments
Ebike Powercalc Rev. 6 (Excel).xls
(24.5 KiB) Downloaded 917 times

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Re: Power calculator

Post by Miles » Jul 17 2011 5:16pm

Good reference for rim/tyre sizes:

http://www.ctc.org.uk/DesktopDefault.aspx?TabID=3802

User avatar
crossbreak   100 MW

100 MW
Posts: 2801
Joined: Aug 02 2011 11:20am
Location: Germany
Contact:

Re: Power calculator

Post by crossbreak » Aug 08 2013 8:54am

thx so much, we should develop this further and add a motor simulator like PeakEff. Then we would have something like the ebikes.ca/simulator as stand alone Excel software :)

User avatar
Miles   100 GW

100 GW
Posts: 11020
Joined: Mar 16 2007 4:15pm
Location: London UK

Re: Power calculator

Post by Miles » Aug 19 2013 2:01am

Feel free to take it in any direction you like CB.. :)

I thought that this would be more useful to others than, in practice, it has been... For most people, the Kreuzotter calculator seems to be sufficient.

User avatar
crossbreak   100 MW

100 MW
Posts: 2801
Joined: Aug 02 2011 11:20am
Location: Germany
Contact:

Re: Power calculator

Post by crossbreak » Aug 19 2013 8:37pm

wasn't aware of this one.. use my own Matlab simulink Simulation which can do something with motor resistance, e-rpm, inductance and so on.... i like the ebikes.ca simulator for the variety of different motors. It's just not sufficient to input "Watts" if a motor is involved IMO. The ebikes.ca simulator shows this very good, but does not take eddy current etc into account. When my Simulink stuff is perfect i'll try to do something similar with Excel

Post Reply