PJD said: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.
paultrafalgar said:SLOWING DOWN ON THE CLIMB is the way to go.
Miles said: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.
paultrafalgar said:Miles said: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.
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. )Eric said: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