Jump to content
Sign in to follow this  
Guest Ari Gold

Gear Ratio Calculator Spreadsheet

Recommended Posts

Guest Ari Gold

Hello all,

Has anyone come across a speadsheet that you can punch in diff and gear ratios to get car speed for given engine rpm?

I'm in the middle of writing one in excel, but I figure I'd work smarter, not harder and see if anyone has on on their computer.

Posted Image

Share this post


Link to post
Share on other sites

I've got one, has diff ratio, tyre & rim size inputs.

And I think Pando then modified it with a slider bar for the diff ratio, and added BMW gearbox ratios.

Also has a graph page gran turismo styles.

Was posted on the old forum many moons ago.

Share this post


Link to post
Share on other sites

I have a very good excel version at home - does tyre size, diff ratio, gear ratios etc. You can set a shift point too, and it gives you a graph with the speed at every 1000 rpms, and the rpm drop at each gear change.

It's been very handy for sorting ratios for the Subaru box to put in my VW :lol:

If you want it emailed, PM your email address... I just realised it's locked though, so you can't mod it... but it's very handy :-)

Share this post


Link to post
Share on other sites

Yip, I did take Glen's and flashed it up, then proceeded to post it here and then it got lost....(goes off to search for it)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...