Gear ratio/ True Groundspeed calculator. Fixed.

Started by BikerTrash, July 01, 2008, 07:39:26 PM

0 Members and 1 Guest are viewing this topic.

BikerTrash

Ok was seriously bored at work today (raining outside and boss said to just chill inside). I have been thinkign about getting a crawl box so i wanted to see just what I could expect and what not so I made this.

http://cid-9fc36ebe53a04aeb.skydrive.live.com/self.aspx/Public/Gear%20calculator.xls

I know there are tons of these on the net already, but I don't know that I have ever seen one that calculates hirange, low,Low Low, and the combined low all at the same time, plus has both the final drive ratios plus the ground speed.

Also I put in some fields where you can enter a MPH and it will give you the RPM you will need to turn to drive that speed. Figured it would be good for guys like us with older trucks that the speedometers cant be recalibarated for gears and tire sizes.

it is an Excel file, I am not sure how common that is (I know I don't have it at home but I live half of my life out here anyway). I hope someone gets some use out of it :D.

P.S. if anyone knows how to make this into a downloadable program that could run without Excel I would love to know it so it would be usefull to more people.

EDIT: I screwed up and locked the Tire size. Not you can actually change the tire size instead of bing stuck at a 32" tire.
There is a fine line between clever and stupid, I just wish I knew when I crossed it.

84 4runner
02 Suzuki V-Strom
95 Honda 1100C1
06 Ram 2500 4x4
(please note, listed in order of preference)

NorCalToy

soon as i get excel itll be sickness! jus gotta find it on the comp first...
:willynilly: '89 truck SAS sittin on 35's, Tacoma rear axle w/ E-Locker, welded front

kneedownnate - You can go through life being scared of the possible, or you can have a little fun and tease the inevitable

iɹǝʌo ǝɯ ııoɹ sıɥʇ pɐǝɹ uɐɔ noʎ ɟı

:flamer: IFS