Tire diameter to gear ratio calculation, Anyone have a spreadsheet? |
|
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG.
This site is not affiliated with Porsche in any way. Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners. |
|
Tire diameter to gear ratio calculation, Anyone have a spreadsheet? |
nine14cats |
Oct 30 2003, 10:50 AM
Post
#1
|
Bill Pickering -- 914-6 GT aka....Leeloo Group: Members Posts: 2,618 Joined: 10-February 03 From: Campbell, CA Member No.: 287 Region Association: None |
Does anyone have a spreadsheet that includes tire diameters to gear ratio calculations? I'm trying to figure out gearing changes to my car.
Example: I am currently running ~23" diameter slick on the back with a 901 gearbox. If I changed to a 24" or a 25", I'd like to know what approx speed change per gear would be. I have upcoming tire testing which includes different diameters and I wanted to have a preliminary idea. Just being lazy....I was hoping someone on the board had already done the work and I could steal it.... (IMG:style_emoticons/default/laugh.gif) Thanks, Bill |
Air_Cooled_Nut |
Oct 30 2003, 10:54 AM
Post
#2
|
914 Ronin - 914 owner who lost his 914club.com Group: Members Posts: 1,748 Joined: 19-April 03 From: Beaverton, Oregon Member No.: 584 Region Association: None |
You ARE lucky because I created an Excel spreadsheet way back for the 5-speed conversion I put in my Squareback (IMG:style_emoticons/default/laugh.gif) I wanted to change the gearing and all my toodling came up with this:
Zipped download (dial-up): http://www.icbm.org/erkson/personal/gearing.zip Raw download (DSL, cable, T1, etc.): http://www.icbm.org/erkson/personal/gearin...ng-analyzer.xls |
nine14cats |
Oct 30 2003, 12:04 PM
Post
#3
|
Bill Pickering -- 914-6 GT aka....Leeloo Group: Members Posts: 2,618 Joined: 10-February 03 From: Campbell, CA Member No.: 287 Region Association: None |
Hi Toby,
WOW (IMG:style_emoticons/default/smilie_pokal.gif) I've got a winner! Now I just have to sit down and enter some values.... Thanks a bunch! Bill |
Brad Roberts |
Oct 30 2003, 01:15 PM
Post
#4
|
914 Freak! Group: Members Posts: 19,148 Joined: 23-December 02 Member No.: 8 Region Association: None |
Bill..
we have a *secret* area on this site where we have some questionable software. http://www.914world.com/downloads/ My gear chart has the 901 ratios and shows a RPM graph. B |
Lo-Fi Version | Time is now: 8th May 2024 - 12:06 AM |
All rights reserved 914World.com © since 2002 |
914World.com is the fastest growing online 914 community! We have it all, classifieds, events, forums, vendors, parts, autocross, racing, technical articles, events calendar, newsletter, restoration, gallery, archives, history and more for your Porsche 914 ... |