F650 and F650GS Gear vs. RPM vs. Speedo
by Kristian #562
You can Change the RED Cells and the Speed or the RPM Will Change Automatically.
For practical reasons, the figures are rounded to the nearest multiple of 50 rpm.
GEAR SPEED (kph) EXPECTED RPM GEAR SPEED (mph) EXPECTED RPM GEAR RPM EXPECTED SPEED (kph) GEAR RPM EXPECTED SPEED (mph)
1st 20 2600 1st 15 3150 1st 2600 20 1st 3150 15
  40 5200   25 5250   5200 40   5250 25
2nd 40 3300 2nd 25 3350 2nd 3300 40 2nd 3350 25
  60 5000   30 4000   5000 60   4000 30
  80 6650   35 4650   6650 80   4650 35
3rd 40 2500 3rd 25 2500 3rd 2500 40 3rd 2500 25
  60 3750   35 3500   3750 60   3500 35
  80 5000   40 4000   5000 80   4000 40
  100 6200   45 4500   6200 100   4500 45
4th 60 2950 4th 35 2800 4th 2950 60 4th 2800 35
  80 3950   45 3600   3950 80   3600 45
  100 4950   55 4400   4950 100   4400 55
  120 5950   65 5200   5950 120   5200 65
  140 6950   75 6000   6950 140   6000 75
5th 60 2500 5th 55 3650 5th 2500 60 5th 3650 55
  80 3300   65 4350   3300 80   4350 65
  100 4150   75 5000   4150 100   5000 75
  120 5000   85 5650   5000 121   5650 85
  140 5800   90 6000   5800 140   6000 90
  160 6650   100 6650   6650 160   6650 100
For Stock 16T Front, 47T Rear Sprocket Ratios 1.946   (KPH)  
17" Rear Wheel, 130/80 Tyre 15.720 2.750 1st  32
Cut it out, stick it on your Screen 10.004 1.750 2nd  50
Choose an Empty Road and Test it. 7.506 1.313 3rd  67
Perhaps use a Passenger to read the Dial while you DRIVE. 5.974 1.045 4th  84
5.002 0.875 5th  100
2.938 16  
Teeth 47 Gear (MPH)
RIM 17 1st  20
Tyre 130 2nd  31
1.609347 kms/Miles Tyre 80 3rd  41
If you want to know the Speed at a certain RPM, change this Figure:   4,150 4th  52
5th  62
While rounding to the closest 50rpm is considered adequate, if you want to know the Exact Figures, remove "MROUND(" from the beginning of the formulas and ",50)" from the end.
You MUST Install the Excel Analysis Toolpak to Run this Function. Tools, Addins, Check "AnalysisToolpak" For the Spreadsheet in Excel Format, Click the Link