My excel file for speed based on gear ratios

[shiboujin]

I made an excel file that takes gear ratios, final drive ratios and tire size to calculate what speed you are at a given rpm.



File:

http://slidewaysonline.com/files/E30%20gear%20ratios.zip

My tire diameter is bigger than stock. I think stock is like 23.2. You can get the diameter by plugging your tire size into the miata tire calculator (http://www.miata.net/garage/tirecalc.html).

When the excel file loads, GR260 ratios are on the left, ZF are on the right. If you want other transmissions, go here: http://e30performance.info/viewtopic...&t=941&p=28445

[AndrewBird]

Nice work. I made something similar, but a bit less complicated:

http://www.mgexperience.net/article/mgb/mgb-tire-gear-speed-calculator.xls

The numbers that are in it are for an MGB, but you can change all the parameters. It also tells you what percentage your speedo is off like the Miata calculator.

[Click]

I use a slightly modified diffs online spreadsheet....

[nando]

why not share the file? :)

-just a nit pick, but the ix uses a planetary gear to split torque, not the VC. the VC is a slip limiting device (there are AWD systems that use a VC to split torque, and they suck).

[shiboujin]

lol so many ppl just want to upstage me. My file is just plain and simple. I put a graph on it though. :)

[Click]

Updated



Download

[lbreevesii]

here is a web based calculator a friend put together for one of his fiero sites. If someone wants to host it he has said he is more than happy to make a BMW transmission specific version.

http://gafiero.org/speedcalc.shtml