RPM v. MPH Excel 'sheet

[frank s]

My version is an attempt to update John's original RPM v. MPH worksheet (left-most set) by adding the Six-speed manual ratios.

I have very small Excel/math skills, and wonder if there is a local expert who can check it for us.

Thank you for your attention (and forbearance, if needed).

https://www.dropbox.com/s/2x2hhozngjwru3k/RPM_vs_Speed~16SpeedAdded_COPY1.xls

 

[Boaisy]

It looks ok. Most of the MPH formula is "absolute" references so that data should stay fixed when called for if it was simply copied to the other cells.

What, no reverse MPH? :/


Cosmetically,

A2-C2 should be Merged & Centered
I2-K2 should be Merged & Centered
T2-V2 should be Merged & Centered

This allows you to have one heading centered above each section without having to type in more than one cell.

The labels below the Transmission heading Width, Profile, etc. you can just highlight each group and do a "Merge Across." This helps it retain the right alignment, and each row is merged for 2 columns.

 

[BruceH]

Why not go here?

http://www.wallaceracing.com/Calculators.htm

 

[frank s]

Boaisy: Thank you for your help. I'm better educated, noe.

BruceH: Thank you for the link; it's a new one for me. It didn't occur to me to look beyond what I had in hand.

Again, thanks.

 

[Racer47]

Here's an excel sheet that I made that you may like. It does everything I was looking for.

http://s197forum.com/forum/showpost.php?p=2025824&postcount=37

 

[frank s]

Here's an excel sheet that I made that you may like. It does everything I was looking for.

http://s197forum.com/forum/showpost.php?p=2025824&postcount=37

Very good! Thank you.

 

[Racer47]

you're welcome. here is the direct link, i originally posted a link to a link, either way you end up in the same place

http://s197forum.com/forum/showpost.php?p=1657770&postcount=54

 

[Norm Peterson]

I think any spreadsheet that computes speeds in gears should be able to either use the "revs per mile" for whatever tire size (available at Tire Rack and other sites) or include a correction factor for tire tread compression effects if the sheet calculates from the tire nominal size. Typically this correction yields speeds ~3% lower than the speeds that every calculator I've ever seen (except one) predicts. Once in a while the 3% matters.


I've been picking away at this for a while and have a sheet that has a lookup function so you don't have to manually type the actual gear ratios for many transmissions (72 different ones at last count). I may change the correction factor to become a user input, haven't decided for sure yet.


Here's a screenshot of a comparison I did a while ago. There is actually room to compare four different situations, I just snipped out the two blocks of speeds in gears that I wasn't using.

Norm