650Rider, xs650 hosted by XS650.com

What Happened to 650rider.com?

650 Rider went offline for about a month at the beginning of 2010. In order to save the technical information that was here, XS650.com acquired the site and brought it back online as a read-only archive. If you were a member of 650 Rider, you will need to re-register at XS650.com

Search 650Rider.com and XS650.com using Google!

        650Rider Menu
 Community  Information


xs650 > > Motorcycle Systems > > Drive > > RPM to MPH Spreadsheet


RPM to MPH Spreadsheet
    Forum Index -> Drive
Author Message
pamcopete
650Rider Supporter
650Rider Supporter


Joined: Oct 10, 2008
Posts: 875
Location: South Carolina

PostPosted: August 6, 2009, 9:39 am    Post subject: RPM to MPH Spreadsheet

Here is a useful little Excel spread sheet that will solve for RPM vs MPH for any combination of gearing, sprockets and tire size.

RPM vs MPH Spreadsheet

Click on the orange cells to reveal a pull down for front sprocket, rear sprocket and rolling distance. Select the values you want from the pull down values. The rest of the spreadsheet is protected.

Rolling distance is used instead of tire circumference or diameter because it is impossible to calculate or measure the tire diameter or circumference accurately.

To obtain rolling distance:

1. Mark the rear tire sidewall and floor.
2. Roll the bike forward exactly one revolution of the rear tire.
3. Mark the floor again.
4. Measure the distance between the two marks on the floor. That is the rolling distance.

_________________
Ride.Enjoy.Life is simple


Last edited by pamcopete on August 6, 2009, 6:15 pm; edited 1 time in total
Back to top
yamaman
Support Staff
Support Staff


Joined: Jan 04, 2007
Posts: 1638
Location: Perth Western Australia

PostPosted: August 6, 2009, 10:38 am    Post subject: Re: RPM to MPH Spreadsheet

Cheers Pete, I updated the link in the vault!
_________________
Its not enough to have an aim in life, you have to pull the trigger!
Back to top
Photo Gallery
Joseph
Full Member
Full Member


Joined: May 22, 2007
Posts: 767
Location: NY

PostPosted: August 6, 2009, 5:04 pm    Post subject: Re: RPM to MPH Spreadsheet

I cant get this spread sheet open. When I save and open it or open it ti says page 1 is protected. I can open the other 2 pages but don't see any info. Any help is appreciated.
_________________
Joeymountain
1980sg
Back to top
Photo Gallery
xs1961
650Rider Supporter
650Rider Supporter


Joined: Apr 23, 2007
Posts: 1808
Location: uk

PostPosted: August 6, 2009, 5:29 pm    Post subject: Re: RPM to MPH Spreadsheet

Cant work that out at all mate...What am I supposed to be looking at on the sheet? What am I missing? Embarassed
_________________
1 running 650
2.5 bikes in bits,
no time,
gradually losing intrest... God help me...
Back to top
Photo Gallery
jayel
650Rider Supporter
650Rider Supporter


Joined: Apr 16, 2006
Posts: 3417
Location: SE Iowa 1974 TX650A

PostPosted: August 6, 2009, 5:33 pm    Post subject: Re: RPM to MPH Spreadsheet

www.amckayltd.com/xs650revs.xls

name/password xs650 don't know if you can save it, but it's a fun little toy

_________________
all it takes is time and money -- Where are we going and why are we in this hand basket?
Back to top
Photo Gallery
Joseph
Full Member
Full Member


Joined: May 22, 2007
Posts: 767
Location: NY

PostPosted: August 6, 2009, 5:37 pm    Post subject: Re: RPM to MPH Spreadsheet

I get a canot acces file message it says it may be read only or open elswar. Does it work for you every time jayel?
_________________
Joeymountain
1980sg
Back to top
Photo Gallery
xs1961
650Rider Supporter
650Rider Supporter


Joined: Apr 23, 2007
Posts: 1808
Location: uk

PostPosted: August 6, 2009, 5:38 pm    Post subject: Re: RPM to MPH Spreadsheet

I see the sheet but it looks Dutch to me ... Maybe cos its 11.30 & Ive polished off a bottle of wine ... Confused
_________________
1 running 650
2.5 bikes in bits,
no time,
gradually losing intrest... God help me...
Back to top
Photo Gallery
jayel
650Rider Supporter
650Rider Supporter


Joined: Apr 16, 2006
Posts: 3417
Location: SE Iowa 1974 TX650A

PostPosted: August 6, 2009, 5:40 pm    Post subject: Re: RPM to MPH Spreadsheet

yes it opens and I can change sprockets and stuff like that
here's another one but you have to enter every thing

www.rbracing-rsr.com/gearspeed.html

_________________
all it takes is time and money -- Where are we going and why are we in this hand basket?
Back to top
Photo Gallery
jayel
650Rider Supporter
650Rider Supporter


Joined: Apr 16, 2006
Posts: 3417
Location: SE Iowa 1974 TX650A

PostPosted: August 6, 2009, 5:55 pm    Post subject: Re: RPM to MPH Spreadsheet

xs1961 wrote:
I see the sheet but it looks Dutch to me ... Maybe cos its 11.30 & Ive polished off a bottle of wine ... Confused
Laughing I'm exploring my Germanic heritage (bottle of schanapps) don't do the Irish (Whiskey?) but Schanapp & beer (English?) goes good together don't know what the 1/8 Cherokee thinks of all this Rolling Eyes

_________________
all it takes is time and money -- Where are we going and why are we in this hand basket?
Back to top
Photo Gallery
pamcopete
650Rider Supporter
650Rider Supporter


Joined: Oct 10, 2008
Posts: 875
Location: South Carolina

PostPosted: August 6, 2009, 6:13 pm    Post subject: Re: RPM to MPH Spreadsheet

Click on the orange cells to reveal a pull down for front sprocket, rear sprocket and rolling distance. Select the values you want from the pull down values. The rest of the spreadsheet is protected.

Rolling distance is used instead of tire circumference or diameter because it is impossible to calculate or measure the tire diameter or circumference accurately.

To obtain rolling distance:

1. Mark the rear tire sidewall and floor.
2. Roll the bike forward exactly one revolution of the rear tire.
3. Mark the floor again.
4. Measure the distance between the two marks on the floor. That is the rolling distance.

_________________
Ride.Enjoy.Life is simple
Back to top
 
    Forum Index -> Drive All times are GMT - 5 Hours
Page 1 of 1


 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


   


Check out the new Honda CB750 Forum at CB750.com! A site dedicated to the great Honda SOHC and DOHC CB750.

Check out the new Yamaha XS400 Forum at XS400.com!

Yamaha xs650

xs650, xs, 650, forum, links, chopper, custom, yamaha, parts, forum, info, information, bb, bulletin board, XS650
650Rider, Free Unrestricted xs650 forum, Personal photo albums, Post images in Forum, News columns, Daily blog, Links, Event calendar, Information for Yamaha XS650



Interactive software released under GNU GPL, Code Credits, Privacy Policy