SuperHawk Forum

Knowledge Base Feedback, Questions on Knowledge Base articles.

Gearing spreadsheet

Thread Tools
 
Search this Thread
 
Old 03-01-2007, 12:07 AM
  #1  
Senior Member
SuperSport
Thread Starter
 
shayne's Avatar
 
Join Date: Dec 2005
Location: Sunshine Coast, Australia
Posts: 963
shayne is on a distinguished road
Gearing spreadsheet
http://www.ozfirestorm.com.au/docs/sprocket_gearing.xls

This spreadsheet was originally for an FZ1, but has been updated with the VTR gear ratios. It has ben checked against a GPS and found to be accurate.

Simply type in your sprocket combo, and tyre size, and it will tell you what speeds you are doing at certain revs in each gear.

Cheers,
Shayne
shayne is offline  
Reply
Old 04-20-2007, 11:00 AM
  #2  
Post Whore Junior
MotoGP
 
Cleveland's Avatar
 
Join Date: Nov 2006
Location: Triad, NC
Posts: 4,825
Cleveland is on a distinguished road
linky no worky for me....
Cleveland is offline  
Reply
Old 04-20-2007, 05:18 PM
  #3  
Senior Member
MotoGP
 
mikstr's Avatar
 
Join Date: Apr 2005
Location: Montreal
Posts: 5,631
mikstr is on a distinguished road
Hi Shayne,

I had posted the link to the spreadsheet on the OzFirestorm site in the Knowledge Base quite some time ago
mikstr is offline  
Reply
Old 04-21-2007, 04:02 AM
  #4  
Senior Member
SuperSport
Thread Starter
 
shayne's Avatar
 
Join Date: Dec 2005
Location: Sunshine Coast, Australia
Posts: 963
shayne is on a distinguished road
I didn't know that. I actually put it up again because somebody, I forget who, asked me to. Pretty handy I found when trying to set my Speedohealer.
shayne is offline  
Reply
Old 04-21-2007, 04:06 AM
  #5  
Senior Member
SuperSport
Thread Starter
 
shayne's Avatar
 
Join Date: Dec 2005
Location: Sunshine Coast, Australia
Posts: 963
shayne is on a distinguished road
Originally Posted by Cleveland
linky no worky for me....
New link loaded. You should be right now.
shayne is offline  
Reply
Old 04-21-2007, 07:30 AM
  #6  
Senior Member
MotoGP
 
mikstr's Avatar
 
Join Date: Apr 2005
Location: Montreal
Posts: 5,631
mikstr is on a distinguished road
Hi again

I used the spreadsheet when programming my Speedohealer and it was a snap (15/43 meant reducing by 15.5% and done!)
mikstr is offline  
Reply
Old 04-24-2007, 03:44 AM
  #7  
Senior Member
SuperSport
Thread Starter
 
shayne's Avatar
 
Join Date: Dec 2005
Location: Sunshine Coast, Australia
Posts: 963
shayne is on a distinguished road
Originally Posted by mikstr
Hi again

I used the spreadsheet when programming my Speedohealer and it was a snap (15/43 meant reducing by 15.5% and done!)
My work here is done.
shayne is offline  
Reply
Old 10-11-2007, 04:53 PM
  #8  
Senior Member
Back Marker
 
Slim's Avatar
 
Join Date: Sep 2007
Location: Toronto, Ontario, Canada
Posts: 203
Slim is on a distinguished road
Hey guys, I don't know if there's something wrong with my particular download or what, but when I try changing anything on the spreadsheet nothing happens. I can click on one of the gear ratios, but any input to the keyboard results in, well, nothing.

Any ideas?
Slim is offline  
Reply
Old 10-11-2007, 05:05 PM
  #9  
Junior Member
Squid
 
mini4m3's Avatar
 
Join Date: Sep 2007
Posts: 15
mini4m3 is on a distinguished road
make sure you are changing the yellow boxes not the white?
mini4m3 is offline  
Reply
Old 10-11-2007, 05:09 PM
  #10  
Senior Member
Back Marker
 
Slim's Avatar
 
Join Date: Sep 2007
Location: Toronto, Ontario, Canada
Posts: 203
Slim is on a distinguished road
Originally Posted by mini4m3
make sure you are changing the yellow boxes not the white?
Yup. The boxes with the sprockets are indeed yellow and are indeed the ones i'm trying to change ..... unsuccessfully.
Slim is offline  
Reply
Old 01-16-2008, 05:38 PM
  #11  
Member
Squid
 
jim2000VTR's Avatar
 
Join Date: Dec 2007
Posts: 37
jim2000VTR is on a distinguished road
gearing spreadsheet
He is correct... there is no formula tied to the sprocket cell. Anyone recall how it all worked? I'd be happy to update it, as I am pretty good at Excel, but no idea just how the formula worked.

jim
jim2000VTR is offline  
Reply
Old 01-16-2008, 05:44 PM
  #12  
Out of my mind, back in 5
MotoGP
 
Tweety's Avatar
 
Join Date: Nov 2006
Location: Skurup, Sweden
Posts: 6,109
Tweety is on a distinguished road
Try this... my personal take on it...
Attached Files
File Type: zip
sprocket_gearing VTR3.zip (10.5 KB, 82 views)
Tweety is offline  
Reply
Old 01-17-2008, 03:26 PM
  #13  
Member
Squid
 
jim2000VTR's Avatar
 
Join Date: Dec 2007
Posts: 37
jim2000VTR is on a distinguished road
Thanks! I downloaded it a second time last night, and it worked fine, changing the columns as advertised. But yours is a lot easier, with the dual columns for comparison. Much appreciated!

jim
jim2000VTR is offline  
Reply
Old 01-19-2008, 09:57 AM
  #14  
Out of my mind, back in 5
MotoGP
 
Tweety's Avatar
 
Join Date: Nov 2006
Location: Skurup, Sweden
Posts: 6,109
Tweety is on a distinguished road
All I did was edit the original one, and duplicated the formulae to be able to compare two different setups, other than just compare to stock...

Plus the the layout of the original one had me confused more than once...

Also added formuales making it easy to change the internal gearbox parameters, ie different bike...
Last edited by Tweety; 01-19-2008 at 09:59 AM.
Tweety is offline  
Reply
Old 10-23-2008, 09:31 AM
  #15  
ReNoob
Squid
 
Sablotny's Avatar
 
Join Date: Aug 2008
Location: Sonoma County California
Posts: 94
Sablotny is on a distinguished road
I like Tweety's
Been looking around the forum at a couple different spreadsheets, this is the best. I think the bike is geared too tall, don't like the stock ratios for tight twisties. Some guys say 15/43 is too buzzy, but from the looks of it from this spreadsheet its really not a huge change. Loafing along at 3,500 RPM in 6th is 98 MPH.
Sablotny is offline  
Reply
Old 10-23-2008, 12:16 PM
  #16  
Senior Member
Superstock
 
Killemall's Avatar
 
Join Date: Jul 2007
Location: CA, South of Heaven
Posts: 342
Killemall is on a distinguished road
No need for spreadsheets. Gearing commander rulez!

http://www.gearingcommander.com/
Killemall is offline  
Reply
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
15/43 gearing and sprocket hub
AC COBRA
Classifieds
10
06-29-2007 08:19 PM
Question on Speedo-healers and gearing
wyldryce
Technical Discussion
14
05-16-2007 07:59 PM
15/43 gearing and long trips
Otto Man
General Discussion
8
03-27-2007 09:49 AM
A few questions about gearing, and brand of chains/sprockets
Otto Man
Technical Discussion
5
01-17-2007 06:47 PM
Sprocket gearing spreadsheet
mikstr
Knowledge Base
2
06-09-2006 05:36 AM
Tags
Back to Subforum
Knowledge Base
View Next Unread
radiators




Advanced Search
Quick Reply: Gearing spreadsheet


Reply Closed Thread Share

All times are GMT -7. The time now is 07:34 AM.


Top

© 2024 MH Sub I, LLC dba Internet Brands


When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.