Speed related calculators

[JoshH]

I made a spreadsheet a while back to calculate RPMs based on speed that I had posted on DP. I had later modified the calculator to be a little more user friendly. Unfortunately, before I could ever post it, I lost it.

Anyway, I made up some new calculators today. I didn't really know where to post the spreadsheet, so I figure I'll throw it in here.

The first spread tab is the same spreadsheet I made before. It's pretty self explanatory, but if you have questions, feel free to ask.

The second tab is a comparison that can compare either speed or RPM between two different setups. You can compare different tire sizes, axle ratios, gears, or transfer case ranges in any combination.

The third tab is a speedo calculator thing. It calculates how tire sizes change your speedometer, and it will help calibrate your speedo with EFI if you have a GPS.

Let me know if you have any problems and how you like it.

 

[sweetdiesel]

Thanks Josh! I love spread sheets

 

[sweetdiesel]

Those are some fancy formulas you got in there Josh

What does this represent in formulas $

 

[JoshH]

It keeps a row or column value in a formula from changing as it is drug across a range of cells. For instance. If I were to type $B16 in a formula, I could drag that formula down into lower cells and the B would not change. I could then drag it across and the 16 would change. Whereas if I were to type B$16, the B would change as I drug it down, but the 16 would not change as I drug it across. If I were to combine both as $B$16 then neither would change as I drug the formula down or across. Make sense?

 

[sweetdiesel]

Make sense?

Sure does and good to know

 

[05smoker]

Thanks Josh.

We should make a suggestion to change the board to allow excel spreadsheets to be posted. I tried this one the other day for ecc_33 and couldn't.

I'm a CPA so I like spreadsheets.

 

[Kat]

Thanks Josh.

We should make a suggestion to change the board to allow excel spreadsheets to be posted. I tried this one the other day for ecc_33 and couldn't.

I'm a CPA so I like spreadsheets.

All you have to do is zip it and then attach it

 

[JoshH]

Thanks Josh.

We should make a suggestion to change the board to allow excel spreadsheets to be posted. I tried this one the other day for ecc_33 and couldn't.

I'm a CPA so I like spreadsheets.

Make sure you look at the tabs at the bottom. I believe the calculator in the second tab would be very useful for someone who is a sled puller...