Bike Gearing Calculator (Excel File) - Kawasaki KLR 650 Forum
2008+ KLR650 Wrenching & Mod Questions For repair, maintaining or modifying discussions related to the newly updated 2008 and beyond, Generation 2 KLR650 Motorcycle.

 1Likes
Reply
 
LinkBack Thread Tools Display Modes
post #1 of 39 Old 09-22-2012, 11:39 AM Thread Starter
Pretty in Pink, dunno why
 
Tom Schmitz's Avatar
 
Join Date: Feb 2009
Location: Redondo Beach
Posts: 7,570
Garage
Arrow Bike Gearing Calculator (Excel File)

I built this Excel file a while ago. Here's what it does:

Sprocket Ratio
This table shows the sprocket ratios for the various front and rear sprocket combinations.

Gearing Selector
Cell D14 is going to tell you what the change in gearing is going to be. A negative number means your gearing is going to be lower;
a positive number means the gearing will be higher

Effect on Chain Length Adjustment
This table will tell you how much you are going to have to move the axle to maintain the chain slack you had prior to changing the
gearing. A negative number means you will be moving the axle backwards, a positive number means the axle moves forward. The
shaded areas indicate what is likely to be possible without adding (or removing) links to the chain.

Indicated Speed Change
Based on the gearing you selected, this is what you can expect to see as indicated speed in 5th gear.

Actual Speed Change
Based on the gearing you selected, this is what you can expect the actual speed to be in 5th gear. The spreadsheet is using the
average of you observed actual speeds to derive the actual speed shown in the table.

RPM at Speed – Revised Gearing, Actual Speed
This table shows the calculated actual speeds you should see with your revised gearing. This table is useful for checking to see if
your revised gearing will have you at comfortable RPM at common speed limits, and for comparing to the stock gearing table below.

Speedometer Correction
A table of corrected speedometer readings.


Since we can't upload Excel files, I had to attach it as a .zip file. It should self-extract when you download it.

T
Attached Files
File Type: zip Bike Gearing R3.zip (22.1 KB, 407 views)
Sonoma likes this.

Tom [email protected]

“She went out slowly. The way she did it hadn’t been learned at business college.” -Philip Marlowe

“'Why' and 'How' are words so important they cannot be too often used.” -Napoleon Bonaparte


Sting like a butterfly.

Last edited by Tom Schmitz; 07-23-2013 at 04:27 PM.
Tom Schmitz is offline  
Sponsored Links
Advertisement
 
post #2 of 39 Old 09-22-2012, 11:45 AM
5th Gear
 
Join Date: Sep 2006
Posts: 4,700
Tom,
YOU ARE THE MAN!!!
Thank you for putting this info in.. I like the KLR's stock gearing for my riding, but I'm changing the ratio on my Triumph and this info's great!!!

Thank you!!
Paper is offline  
post #3 of 39 Old 09-22-2012, 11:57 AM Thread Starter
Pretty in Pink, dunno why
 
Tom Schmitz's Avatar
 
Join Date: Feb 2009
Location: Redondo Beach
Posts: 7,570
Garage
Paper -

Glad you might get some use out of it.

Perhaps I should go back and make the transmission ratios a user-input and add a sixth gear. That would make it less KLR specific.

But a bit later, perhaps. I'm off to Irwindale Raceway for an Antique Motorcycle Show and Swapmeet complete with umbrella girls and hot dogs.

The transmission ratio table is hidden in cells K69-K73.

T

Tom [email protected]

“She went out slowly. The way she did it hadn’t been learned at business college.” -Philip Marlowe

“'Why' and 'How' are words so important they cannot be too often used.” -Napoleon Bonaparte


Sting like a butterfly.
Tom Schmitz is offline  
 
post #4 of 39 Old 09-22-2012, 03:55 PM
2nd Gear
 
pismocycleguy's Avatar
 
Join Date: Nov 2009
Location: Pismo Beach, CA
Posts: 281
Talking Nice Chart

Nice Chart! Very Handy!
Thanks for sharing.
pismocycleguy is offline  
post #5 of 39 Old 09-22-2012, 09:11 PM
Neutral
 
ConstantMesh's Avatar
 
Join Date: Jan 2012
Location: Sierra Vista, AZ - USA
Posts: 11
Nice!

Sent from my ADR6400L using Motorcycle.com Free App
ConstantMesh is offline  
post #6 of 39 Old 09-27-2012, 04:55 PM
5th Gear
 
Join Date: Sep 2006
Posts: 4,700
I also found this.. http://www.gearingcommander.com/

I was wondering if I had to go to less links on my Triumph, since I dropped the front sprocket size from 19 to 18.. Found out it's 108 for both..
Paper is offline  
post #7 of 39 Old 11-16-2012, 09:06 PM
1st Gear
 
Join Date: Nov 2012
Location: Mid Michigan
Posts: 69
Is this file still good?
I can't seem to get it open...
gator is offline  
post #8 of 39 Old 11-16-2012, 10:29 PM Thread Starter
Pretty in Pink, dunno why
 
Tom Schmitz's Avatar
 
Join Date: Feb 2009
Location: Redondo Beach
Posts: 7,570
Garage
Gad. Something wonky with the .zip file.

I'll try to get it fixed.

Sorry!

T

Tom [email protected]

“She went out slowly. The way she did it hadn’t been learned at business college.” -Philip Marlowe

“'Why' and 'How' are words so important they cannot be too often used.” -Napoleon Bonaparte


Sting like a butterfly.
Tom Schmitz is offline  
post #9 of 39 Old 11-16-2012, 10:56 PM Thread Starter
Pretty in Pink, dunno why
 
Tom Schmitz's Avatar
 
Join Date: Feb 2009
Location: Redondo Beach
Posts: 7,570
Garage
OK, I hope it's fixed.

Please have another go at it.

T

Tom [email protected]

“She went out slowly. The way she did it hadn’t been learned at business college.” -Philip Marlowe

“'Why' and 'How' are words so important they cannot be too often used.” -Napoleon Bonaparte


Sting like a butterfly.
Tom Schmitz is offline  
post #10 of 39 Old 11-17-2012, 09:12 AM
1st Gear
 
Join Date: Nov 2012
Location: Mid Michigan
Posts: 69
Still no go, Tom.
Maybe someone else try to open it....could just be me. lol
gator is offline  
Sponsored Links
Advertisement
 
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the Kawasaki KLR 650 Forum forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Similar Threads
Thread Thread Starter Forum Replies Last Post
gearing up for the street Raydog KLR & Other Motorcycle Related Discussion 38 02-29-2016 12:34 AM
Shim Calculator Site DXKLR 1987 to 2007 Wrenching & Mods 4 09-08-2011 09:05 AM
Gearing Question TrabFTW KLR & Other Motorcycle Related Discussion 18 12-21-2010 12:12 PM
Gearing and Top Speed ekms377 KLR & Other Motorcycle Related Discussion 3 04-16-2008 06:53 AM

Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome