Required vs Available Torque spreadsheet

4 posts / 0 new
Last post
jdh2550_1
jdh2550_1's picture
Offline
Last seen: 7 years 4 months ago
Joined: Tuesday, July 17, 2007 - 09:35
Points: 2335
Required vs Available Torque spreadsheet

Hi - I just posted this on my blog but you probably don't read that - so here it is again.

I've created a spreadsheet based off of Bob Brant's Build Your Own Electric Vehicle and John Bidwell's Secrets of El-Ninja. I used BYOEV for the required torque formulas, and I used El-Ninja for the available torque formulas (they were presented as a nice short list in the Bidwell book!). I used the co-efficient of drag and frontal area figures from the defaults on the electricmotorcycles.net calculator (http://electricmotorcycles.net/modules/toolbox/battery_worksheet.php)

You can see the spreadsheet at: http://www.editgrid.com/user/jdh2550/CB-72V - if you want to use it yourself then you can get a free edit grid account (takes 5 minutes to setup) and do a Save As ... and create your own copy because you can't edit this sheet directly. BTW, the graph is on the summary tab and all the gory details are on the calcs tab. The other tabs are all work in progress for my CB-72V conversion.

Look it over and let me know if you think any of it's flawed (such as the coeff of drag figure).

If you want I can save this as an Excel spreadsheet and clean out my CB-750 bits and post it to the Download library.

It even produces a pretty graph (what more could you want?).

I hope you find this useful.

echuckj5
echuckj5's picture
Offline
Last seen: 10 years 8 months ago
Joined: Wednesday, November 29, 2006 - 07:13
Points: 394
Re: Required vs Available Torque spreadsheet

Whoa,

looked at that chart, said wow, thats some serious torque, then I thought, must be in inch/lbs, then I snapped, thats the torque at the wheel, still a lot of torque.

chuck

[b]AGM BATTERIES[/b]

jdh2550_1
jdh2550_1's picture
Offline
Last seen: 7 years 4 months ago
Joined: Tuesday, July 17, 2007 - 09:35
Points: 2335
Re: Required vs Available Torque spreadsheet

This is a motorbike - not some pedal cycle ... }:)

John H. Founder of Current Motor Company - opinions on this site belong to me; not to my employer
Remember: " 'lectric for local. diesel for distance" - JTH, Amp Bros || "No Gas.

echuckj5
echuckj5's picture
Offline
Last seen: 10 years 8 months ago
Joined: Wednesday, November 29, 2006 - 07:13
Points: 394
Re: Required vs Available Torque spreadsheet

he he,

my bike is faster than your bike, got rid of the dumbbells, a long time ago, (inside joke)

1hp=(torque*rpm)/5252
motor is 3000rpm and 1 horsepower
torque=1hp*5252/3000=1.75ftlbs

torque at the wheel=(f*ratio)/(radius of wheel, in feet). my gear ratio is 30 to 1. Changing that ratio as we speak. You will not out do me. Now my torque is bigger than your torque. ha ha

torque=(1.75*30)/1.13=46ftlbs ,,, now what da ya say!!!!

whoops, no problem climbing that hill, just ain't climbing real fast, what happened?

"chuckles" is going real slow now

[b]AGM BATTERIES[/b]

Log in or register to post comments


Who's online

There are currently 0 users online.

Who's new

  • Naadu_b@
  • SolarRichT
  • victoria098
  • PtheDude
  • Gilles

Customize This