Notices
2010-2014 Mustang Information on The S197 {GenII}
Sponsored By:
Sponsored By:

2011 M6 Gearing Spreadsheet

Thread Tools
 
Search this Thread
 
Old 5/27/10, 08:42 AM
  #1  
Mach 1 Member
Thread Starter
 
coffeejolts's Avatar
 
Join Date: November 3, 2009
Location: Atlanta
Posts: 626
Likes: 0
Received 0 Likes on 0 Posts
Exclamation 2011 M6 Gearing Spreadsheet

I have compiled a spreadsheet that details RPMS in each gear at a given speed for 3.31, 3.55, and 3.73 rear gears. There have been many posts recently asking which gears should I choose. This spreadsheet answers all of those questions.
Attached Files
File Type: xls
rpms.xls (23.5 KB, 3619 views)
Old 5/27/10, 10:55 AM
  #2  
Mach 1 Member
 
Gene K's Avatar
 
Join Date: December 24, 2007
Posts: 563
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by coffeejolts
I have compiled a spreadsheet that details RPMS in each gear at a given speed for 3.31, 3.55, and 3.73 rear gears. There have been many posts recently asking which gears should I choose. This spreadsheet answers all of those questions.
Your calculations appear to have some errors. For instance you list 7000 rpm in 4th as 115, 121 and 130 depending on gears.

3.73 - 111.5 mph (18" All-Seasons 765 rpm) - 111.1 mph (19" All-Seasons 768 rpm) - 111.8 mph (19" Summer Rubber 763 rpm)

3.55 - 117.2 mph (18" All-Seasons 765 rpm) - 116.7 mph (19" All-Seasons 768 rpm) - 117.5 mph (19" Summer Rubber 763 rpm)

3.31 - 125.7 mph (18" All-Seasons 765 rpm) - 125.2 mph (19" All-Seasons 768 rpm) - 126.0 mph (19" Summer Rubber 763 rpm)

As you can see you appear to be off by 4 mph on average.
Old 5/27/10, 11:29 AM
  #3  
Mach 1 Member
Thread Starter
 
coffeejolts's Avatar
 
Join Date: November 3, 2009
Location: Atlanta
Posts: 626
Likes: 0
Received 0 Likes on 0 Posts
It all depends upon what you believe is the correct tire diameter / revolutions per mile. I calculated everything from the stock 18" tire size, which is 235/50R18 (27.25196 inch diameter). We all know tire sizes can vary, but I didn't have any solid info on the actual diameter so I went by the size.

765 rev per mile yields a diameter of 26.36355. That's nearly an inch difference, and the reason for the differences in our calculated speeds. Where did you get your information?
Old 5/27/10, 11:48 AM
  #4  
GTR Member
 
Ltngdrvr's Avatar
 
Join Date: February 18, 2010
Location: S.E. Texas
Posts: 4,990
Likes: 0
Received 1 Like on 1 Post
I don't, and am sure others don't, have the software to open the spreadsheet on my computer.

I just use this calculator: http://www.f-body.org/gears/

Easy to use and you can make all the changes you like to it.
Old 5/27/10, 03:13 PM
  #5  
Mach 1 Member
 
hawkeye18's Avatar
 
Join Date: April 20, 2010
Location: Norfolk, VA
Posts: 733
Likes: 0
Received 1 Like on 1 Post
Originally Posted by Ltngdrvr
I don't, and am sure others don't, have the software to open the spreadsheet on my computer.

I just use this calculator: http://www.f-body.org/gears/

Easy to use and you can make all the changes you like to it.
It's called OpenOffice. And, the 21st century. It's not OP's fault that people can't figure out how to use a computer for basic tasks.
Old 5/27/10, 03:56 PM
  #6  
GTR Member
 
Ltngdrvr's Avatar
 
Join Date: February 18, 2010
Location: S.E. Texas
Posts: 4,990
Likes: 0
Received 1 Like on 1 Post
Originally Posted by hawkeye18
It's called OpenOffice. And, the 21st century. It's not OP's fault that people can't figure out how to use a computer for basic tasks.
Well mr. smartguy, just hoped to offer the less computer proficient among us an alternative.
Old 5/27/10, 04:39 PM
  #7  
Mach 1 Member
 
hawkeye18's Avatar
 
Join Date: April 20, 2010
Location: Norfolk, VA
Posts: 733
Likes: 0
Received 1 Like on 1 Post
Originally Posted by Ltngdrvr
Well mr. smartguy, just hoped to offer the less computer proficient among us an alternative.
I'm sorry, but this is like *****ing at a guy who brings you a gallon of milk because you don't have a fridge in your house. It's 2010, you should have some method of viewing spreadsheets on your computer, especially if you're a car guy (because you might need to, oh, look at gear/speed charts).
Old 5/27/10, 05:03 PM
  #8  
GTR Member
 
Ltngdrvr's Avatar
 
Join Date: February 18, 2010
Location: S.E. Texas
Posts: 4,990
Likes: 0
Received 1 Like on 1 Post
Originally Posted by hawkeye18
I'm sorry, but this is like *****ing at a guy who brings you a gallon of milk because you don't have a fridge in your house. It's 2010, you should have some method of viewing spreadsheets on your computer, especially if you're a car guy (because you might need to, oh, look at gear/speed charts).
Don't need to look at gear/speed spread sheets, I just plug the numbers into the calculator I posted the link to and it gives the info I need.
Old 5/27/10, 06:00 PM
  #9  
GT Member
 
BLKCLOUD's Avatar
 
Join Date: April 29, 2010
Location: Knoxville, TN
Posts: 192
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by coffeejolts
It all depends upon what you believe is the correct tire diameter / revolutions per mile. I calculated everything from the stock 18" tire size, which is 235/50R18 (27.25196 inch diameter). We all know tire sizes can vary, but I didn't have any solid info on the actual diameter so I went by the size.

765 rev per mile yields a diameter of 26.36355. That's nearly an inch difference, and the reason for the differences in our calculated speeds. Where did you get your information?
Tirerack lists the 235/50/18 at 765 rev/mile. Click on "Specs"

Pirelli's site has 761.9 revs/mile.

I've been through this discussion with Gene....believe he's got it down pretty good!
Old 5/28/10, 02:59 PM
  #10  
Mach 1 Member
 
Gene K's Avatar
 
Join Date: December 24, 2007
Posts: 563
Likes: 0
Received 0 Likes on 0 Posts
So you used unloaded diameter as opposed to loaded radius or revolutions per mile? That likely would explain the difference.

The listed rpm varies for several tires. I believe the OEM Ford 235/50R18 is 765 rpm (I believe the generic is 762 rpm). However the 763 rpm Summer Tire is for the 255/40R19 XL OEM MB Tire. Ive seen the Ford OEM listed as being 763 rpm / 769 rpm / 769.5 rpm in various places. Im not sure which is acccurate. I simply used the one that gave the closest to your numbers.

Last edited by Gene K; 5/29/10 at 01:33 PM.
Old 6/5/10, 04:33 PM
  #11  
V6 Member
 
Magnamover's Avatar
 
Join Date: May 29, 2010
Location: Seneca Falls NY
Posts: 81
Likes: 0
Received 0 Likes on 0 Posts
I hear others saying that 1st gear is much less usable with 3.73 but this confirms that it shouldn't be an issue. I ordered it for but-o-meter in 2nd, 3rd, and 4th.
Old 6/13/10, 06:40 AM
  #12  
Legacy TMS Member
 
orange3.9stang's Avatar
 
Join Date: September 20, 2004
Location: N.E. Wisconsin
Posts: 883
Likes: 0
Received 4 Likes on 4 Posts
Originally Posted by Gene K
So you used unloaded diameter as opposed to loaded radius or revolutions per mile? That likely would explain the difference.

The listed rpm varies for several tires. I believe the OEM Ford 235/50R18 is 765 rpm (I believe the generic is 762 rpm). However the 763 rpm Summer Tire is for the 255/40R19 XL OEM MB Tire. Ive seen the Ford OEM listed as being 763 rpm / 769 rpm / 769.5 rpm in various places. Im not sure which is acccurate. I simply used the one that gave the closest to your numbers.
I've made a few different Lotus 123 then MS Excel spreadsheets to calculate engine RPM's at various speeds in all gears too and wondered why the RPM's were slightly higher in the "real" world. The spread sheet does almost ALL the calculations, all you need to insert is the gear ratios of the trans, axle, wheel size, and section height.

My '11 theoretically should be turning 1823 RPM @ 75 MPH, but in reality it is closer to 2k.

Doug
Old 12/19/11, 06:31 AM
  #13  
Cobra Member
 
Bucko's Avatar
 
Join Date: December 4, 2011
Location: Central Florida
Posts: 1,418
Likes: 0
Received 2 Likes on 2 Posts
Amazing that folks offer some good info, then get attacked for doing so. To coffeejolts, thanks for posting the info.
Old 12/19/11, 06:40 AM
  #14  
A Man Just Needs Some....
 
AlsCobra's Avatar
 
Join Date: April 9, 2011
Location: Louisiana
Posts: 16,852
Received 34 Likes on 30 Posts
Is it possible to use 5th gear on these and gain any time, or is it a loss between shifts? Just curious. I'm thinking 4.11 and using 5th.

Last edited by AlsCobra; 12/19/11 at 06:42 AM.
Old 12/19/11, 07:29 AM
  #15  
Bullitt Member
 
VTXFrank's Avatar
 
Join Date: September 26, 2011
Location: Santa Rosa Beach, FL
Posts: 278
Likes: 0
Received 1 Like on 1 Post
Originally Posted by AlsCobra
Is it possible to use 5th gear on these and gain any time, or is it a loss between shifts? Just curious. I'm thinking 4.11 and using 5th.
That will completely depend on where you're running out of gear. For instance, if you can up your rev limit to 7400 on the new 5.0L and stay in 4th across the traps, that's what I'd do for the best times. If upping your rev limit won't quite get you there, then you may want to consider going with a shorter tire.

What size tires are you currently running?
Old 12/25/11, 11:24 AM
  #16  
GT Member
 
jimmbbo's Avatar
 
Join Date: April 16, 2011
Location: Las Vegas
Posts: 153
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by coffeejolts
I have compiled a spreadsheet that details RPMS in each gear at a given speed for 3.31, 3.55, and 3.73 rear gears. There have been many posts recently asking which gears should I choose. This spreadsheet answers all of those questions.
Good stuff for the purpose intended, and dead on accurate for my 3.73s with 19 inch Brembo wheels...

Ignore the whiners who want to measure with a micrometer when the part is going to be cut with a chainsaw...
Old 4/18/12, 02:41 AM
  #17  
Cobra Member
 
HizliBullet's Avatar
 
Join Date: October 11, 2009
Posts: 1,126
Likes: 0
Received 4 Likes on 3 Posts
RPM 1st Gear 2nd Gear 3rd Gear 4th Gear 5th Gear 6th Gear
500 3 4 6 8 11 17

im lost in the first line, what does 3,4,6 etc mean? goes to 90 i have no idea what it is
Old 4/18/12, 06:53 AM
  #18  
Shelby GT500 Member
 
kcoTiger's Avatar
 
Join Date: December 20, 2011
Location: CenTex...sort of
Posts: 4,354
Received 53 Likes on 52 Posts
That is the mph in that gear at that rpm with that ratio.
Old 6/9/12, 10:47 AM
  #19  
Bullitt Member
 
jocatch's Avatar
 
Join Date: September 9, 2009
Location: Upstate NY
Posts: 296
Likes: 0
Received 0 Likes on 0 Posts
Do these numbers work for a 2013 GT with the 6 speed manual?

Joe C.
Old 11/4/12, 09:35 PM
  #20  
Member
 
clevor362's Avatar
 
Join Date: July 20, 2012
Location: middle Tenn
Posts: 18
Likes: 0
Received 0 Likes on 0 Posts
The answer!

Originally Posted by coffeejolts
I have compiled a spreadsheet that details RPMS in each gear at a given speed for 3.31, 3.55, and 3.73 rear gears. There have been many posts recently asking which gears should I choose. This spreadsheet answers all of those questions.
Appreciate the info. The spreadsheet does provide an answer to my inquiring mind. Namely, what the hell good is the 1st gear in my transmission with 3:73 axle gears? Answer, I might decide to install a trailer hitch someday so I can tow heavy stuff! Any good tow truck with a MT needs a granny gear. I have less than 300 miles on my Boss and I am already sick of constant shifting in/around town. I'm already considering a set of 3.31:1 axle gears. Then maybe the trans ratios would make sense. The Tremec in my Shelby is much more user friendly and is supposedly stronger as well. Anybody here have the inside track on Ford's thinking/purpose for the granny gear? I guess I'm wondering if there is anywhere on a road course where such a steep first gear is actually an advantage. There, I feel better now.

Bill


Quick Reply: 2011 M6 Gearing Spreadsheet



All times are GMT -6. The time now is 09:56 PM.