Gear Ratio Chart

Forum rules
Please can you post items for sale or wanted in the correct For Sale section. Items / bikes for sale here will be removed without warning. Reasons for this are in the FAQ. Thanks
Post Reply
jac_is_smiling
Settled in member
Posts: 65
Joined: Mon Jan 19, 2009 5:39 pm
Bike owned: Cagiva Planet, NC23 x2, FZ 600
Location: Glasgow

Gear Ratio Chart

Post by jac_is_smiling » Thu Mar 25, 2010 3:23 pm

Via the powers of excel made a chart to calculate ground speed given certain rpm and gear selection. Link below.

http://www.mediafire.com/?znvt5mzmtqj

Image

Currently setup for an RRJ using the ratios given in haynes.

Easy enough to change for another bike/different wheels/tyre sizes.

Hope it helps someone, Jac.

p.s. hasnt as such helped me, but I have figured out how to gear the bike to get 1,000,000 mph :ninja:

Wozza
Site Supporter
Site Supporter
Posts: 629
Joined: Wed Aug 06, 2008 9:51 pm

Re: Gear Ratio Chart

Post by Wozza » Thu Mar 25, 2010 9:26 pm

Nifty!

PARUS
Senior Member
Posts: 1160
Joined: Tue Apr 29, 2008 10:01 pm
Bike owned: Already 20% of NC29...
Location: Seattle, USA
Contact:

Re: Gear Ratio Chart

Post by PARUS » Thu Mar 25, 2010 9:50 pm

Send me email and I send you back AFAM calculation for different sprocket\chain link to get different speed.

User avatar
Cammo
Site Supporter
Site Supporter
Posts: 4505
Joined: Thu May 01, 2008 12:35 am
Bike owned: NC30
Location: Melbourne, Australia

Re: Gear Ratio Chart

Post by Cammo » Fri Mar 26, 2010 7:49 am

Nice work, but this one I use has a pretty graph!

http://www.dropbears.com/u/utilities/gearing.htm" onclick="window.open(this.href);return false;
"It's just a ride" Bill Hicks

jac_is_smiling
Settled in member
Posts: 65
Joined: Mon Jan 19, 2009 5:39 pm
Bike owned: Cagiva Planet, NC23 x2, FZ 600
Location: Glasgow

Re: Gear Ratio Chart

Post by jac_is_smiling » Fri Mar 26, 2010 8:43 am

aaahhh graphs...

...depending on how busy i am next couple of days, mine might sprout a graph lol

User avatar
CRM
Admin NWAA
Admin NWAA
Posts: 2972
Joined: Sat Apr 05, 2008 2:06 pm
Location: NorthWest
Contact:

Re: Gear Ratio Chart

Post by CRM » Fri Mar 26, 2010 9:17 pm

and then do one for the NC30 ;)
Insert Signature Here

Wozza
Site Supporter
Site Supporter
Posts: 629
Joined: Wed Aug 06, 2008 9:51 pm

Re: Gear Ratio Chart

Post by Wozza » Tue Apr 06, 2010 11:17 am

Will this help me to calculate how far I have actually travelled when my clock reads say 10km, since I have different sprockets? I have K model which has 15/40 sprockets as standard but I currently have 14/42 sprockets. I'm sure there's an easy way to do this.

jac_is_smiling
Settled in member
Posts: 65
Joined: Mon Jan 19, 2009 5:39 pm
Bike owned: Cagiva Planet, NC23 x2, FZ 600
Location: Glasgow

Re: Gear Ratio Chart

Post by jac_is_smiling » Tue Apr 06, 2010 1:54 pm

Wozza; I think for doing that you take dist. travelled * (new ratio/old ratio).

i.e. 10*((14/42)/(15/40))= 8.88...km travelled instead.

Didnt put that in the spreadsheet right enuf.
As for using the spreadsheet for the RRK only difference is final ratio and 6th gear.
Just type =32/24 or 1.333 in the cell for 6th gear ratio. Then obv the sprocket sizes to suit.

Altho if you take whatever speed at whatever rpm in whatever gear with the new sprocket size, and the same with the original sprocket size you take
[new speed/old speed]*[dist on speedo]=real dist. travelled

Afraid ive been a bit too busy for the spreadsheet to sprout graphs as I was hoping for lol

If someone can find the ratios for an NC30 and post them then its easy enough to plug the numbers in to suit...or any bike tbh

Didnt actually realise there was quite a few of these sorts of things online at the time of making it. I just got carried away and kept going even when it was pointed out there is quite a few ones online already lol

Post Reply