• Hey Guest!
    British Car Forum has been supporting enthusiasts for over 25 years by providing a great place to share our love for British cars. You can support our efforts by upgrading your membership for less than the dues of most car clubs. There are some perks with a member upgrade!
    **Upgrade Now**
    (PS: Upgraded members don't see this banner, nor will you see the Google ads that appear on the site.)
Tips
Tips

Road Speed Calculator

Share this page

8

80spitlizzy

Senior Member
Offline
I posted this on another forum I participate in and thought you gents might find it useful. It's an excel spreadsheet that helps understand drivetrain parameters effect on roadspeed. I built it to help in wheel and tire choice but I've found many other uses. It's set up for a late model spit but if you know the drive ratios, I can be used for any vehicle.

I'd love any feedback you have or any useability suggestion. Send any comments direct to me via email or post them here.

Roadspeed Calculator
 
i have no idea wht to open that with....?

help


mark
 
Sorry Mark,

It's a Microsoft Excel Workbook. You need a version of MS Excel > Excel 97
 
So Mark,
I assume this chart showing a 4speed with OD would be similar to my 5 speed TR7? If so, the chart is deadly accurate with what I find with mine.

Paul
 
Mark:
Handy, and saves me the trouble of doing my own "Sawtooth" charts when I'm changing gear ratios.
Thanks for the link.
Jeff
 
Updated version available!!


I've made some changes to the tool.
Added the ability to store scenarios
Added some "Know Drivetrains"
Added instructions
Added 5 speed capability
Changed print layout.

Drivetrain Model v2
 
Thanks Mark. Only took about 10 seconds to download (even through my dog-slow, dial-up line).
We use a similar Excel program to calculate speeds for our FIRST Robot:

https://npmccabe.tripod.com/robot_main.html

I'll pass this on to the team as an alternate tool for '05.
On a similar note, I've used my hand-held GPS to verify speedometer error in my cars. It works well, even with the top up.
 
Back
Top