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



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

Nifty!

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

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;

aaahhh graphs...

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

and then do one for the NC30

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.

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