Gear Ratio Calculator Spreadsheet

[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.

[*Glenn* 854]

Heres one

http://www.unixnerd.demon.co.uk/revs.html

[E30-323ti 66]

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.

[Ben 0]

I posted a bmw specific one a couple years ago

Visit My Website

[Allanw 1071]

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

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 :-)

[BM WORLD 1283]

this one is good already has preloaded gear ratios for getrag and zf boxes etc

http://members.dodo.com.au/~wawawa/revs.htm

[Carl 3]

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)