Knowledge Base Feedback, Questions on Knowledge Base articles.

Gearing spreadsheet

Thread Tools
 
Search this Thread
 
Old 03-01-2007 | 01:07 AM
  #1  
shayne's Avatar
Thread Starter
Senior Member
SuperSport
 
Joined: Dec 2005
Posts: 963
From: Sunshine Coast, Australia
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
Old 04-20-2007 | 12:00 PM
  #2  
Cleveland's Avatar
Post Whore Junior
MotoGP
 
Joined: Nov 2006
Posts: 4,825
From: Triad, NC
Cleveland is on a distinguished road
linky no worky for me....
Old 04-20-2007 | 06:18 PM
  #3  
mikstr's Avatar
Senior Member
MotoGP
 
Joined: Apr 2005
Posts: 5,631
From: Montreal
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
Old 04-21-2007 | 05:02 AM
  #4  
shayne's Avatar
Thread Starter
Senior Member
SuperSport
 
Joined: Dec 2005
Posts: 963
From: Sunshine Coast, Australia
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.
Old 04-21-2007 | 05:06 AM
  #5  
shayne's Avatar
Thread Starter
Senior Member
SuperSport
 
Joined: Dec 2005
Posts: 963
From: Sunshine Coast, Australia
shayne is on a distinguished road
Originally Posted by Cleveland
linky no worky for me....
New link loaded. You should be right now.
Old 04-21-2007 | 08:30 AM
  #6  
mikstr's Avatar
Senior Member
MotoGP
 
Joined: Apr 2005
Posts: 5,631
From: Montreal
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!)
Old 04-24-2007 | 04:44 AM
  #7  
shayne's Avatar
Thread Starter
Senior Member
SuperSport
 
Joined: Dec 2005
Posts: 963
From: Sunshine Coast, Australia
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.
Old 10-11-2007 | 05:53 PM
  #8  
Slim's Avatar
Senior Member
Back Marker
 
Joined: Sep 2007
Posts: 203
From: Toronto, Ontario, Canada
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?
Old 10-11-2007 | 06:05 PM
  #9  
mini4m3's Avatar
Junior Member
Squid
 
Joined: Sep 2007
Posts: 15
mini4m3 is on a distinguished road
make sure you are changing the yellow boxes not the white?
Old 10-11-2007 | 06:09 PM
  #10  
Slim's Avatar
Senior Member
Back Marker
 
Joined: Sep 2007
Posts: 203
From: Toronto, Ontario, Canada
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.
Old 01-16-2008 | 06:38 PM
  #11  
jim2000VTR's Avatar
Member
Squid
 
Joined: 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
Old 01-16-2008 | 06:44 PM
  #12  
Tweety's Avatar
Out of my mind, back in 5
MotoGP
 
Joined: Nov 2006
Posts: 6,109
From: Skurup, Sweden
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, 83 views)
Old 01-17-2008 | 04:26 PM
  #13  
jim2000VTR's Avatar
Member
Squid
 
Joined: 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
Old 01-19-2008 | 10:57 AM
  #14  
Tweety's Avatar
Out of my mind, back in 5
MotoGP
 
Joined: Nov 2006
Posts: 6,109
From: Skurup, Sweden
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 10:59 AM.
Old 10-23-2008 | 10:31 AM
  #15  
Sablotny's Avatar
ReNoob
Squid
 
Joined: Aug 2008
Posts: 94
From: Sonoma County California
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.
Old 10-23-2008 | 01:16 PM
  #16  
Killemall's Avatar
Senior Member
Superstock
 
Joined: Jul 2007
Posts: 342
From: CA, South of Heaven
Killemall is on a distinguished road
No need for spreadsheets. Gearing commander rulez!

http://www.gearingcommander.com/
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
AC COBRA
Classifieds
10
06-29-2007 09:19 PM
wyldryce
Technical Discussion
14
05-16-2007 08:59 PM
Otto Man
General Discussion
8
03-27-2007 10:49 AM
Otto Man
Technical Discussion
5
01-17-2007 07:47 PM
mikstr
Knowledge Base
2
06-09-2006 06:36 AM




All times are GMT -7. The time now is 11:51 PM.


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.