Gear Ratio/RPM/MPH Spreadsheet in MS Excel ... - Camaro5 Chevy Camaro Forum / Camaro ZL1, SS and V6 Forums

dougmac · 04-09-2009, 09:53 AM

>> DOWNLOAD SPREADSHEET HERE <<

You enter transmission gear ratios, diff ratio, rim diameter, and tire section height.
Rim dia. & section height calculates tire dia. & revs per mile which when multiplied with the gear ratios calculates RPM in all gears at 60 MPH, MPH in all gears at 2000 RPM, plus a few other cacualtions that I could fit on the page.

Here is an example of 1 column ...

Camaro 1LS
V6 MT
Displacement 3.6L / 217.3c.i.
Horsepower 304 @ 6400
Torque 273 @ 5200
Curb Wgt. 3741 lbs.
Wgt. : HP ratio 12.3
EPA Mileage 17/29 MPG
Fuel Tank Size 19.0 Gal.
Range per tank 323/551 Miles
437 ave.

1st Gear 4.480 :1
2nd Gear 2.580 :1
3rd Gear 1.630 :1
4th Gear 1.190 :1
5th Gear 1.000 :1
Overdrive 0.750 :1
Differential 3.270 :1

Tire Size (rear) 245/55- 18
Section Height 5.305
Tire Dia. 28.610
Revolution/Mile 727

1st @ 2000 RPM 11 MPH
2st @ 2000 RPM 20 MPH
3rd @ 2000 RPM 31 MPH
4th @ 2000 RPM 42 MPH
5th @ 2000 RPM 50 MPH
O.D. @ 1000 RPM 34 MPH
O.D. @ 1500 RPM 50 MPH
O.D. @ 2000 RPM 67 MPH
O.D. @ 2500 RPM 84 MPH
O.D. @ 3000 RPM 101 MPH
O.D. @ 3500 RPM 118 MPH

1st @ 60 MPH * 10651 RPM
2st @ 60 MPH * 6134 RPM
3rd @ 60 MPH 3875 RPM
4th @ 60 MPH 2829 RPM
5th @ 60 MPH 2377 RPM
O.D. @ 60 MPH 1783 RPM
O.D. @ 75 MPH 2229 RPM

... looks MUCH BETTER in the spreadsheet !!

Spreadsheet is in landscape format and is currently 5 pages wide with 8 cars per page (40 cars total). Page 1 is all the 2010 Camaro variations, Page 2-5 is all the Mustang, Challenger, Genesis Coupe variations as well as 6 other sporty RWD coupes and 10 4-door RWD sedans.

Inital reason for making this was I wanted to compare the 2010 Mustang, Camaro, and Genesis Coupe specs to my previous 1994, 1998, & current 2004 Mustang. Started as a comparison for potential MPG & mile range per tank, but it could easily be altered to show performance stats like MPH in each gear at Redline, etc.

>> DOWNLOAD SPREADSHEET HERE <<

Doug

Hooy · 04-09-2009, 10:22 AM

You should finalize it and post it up! I'd definitely like to take a look at this. Thanks!

dougmac · 04-09-2009, 12:13 PM

Quote:

Originally Posted by Hooy

You should finalize it and post it up! I'd definitely like to take a look at this. Thanks!

The actual spreadsheet is pretty much finalized, I just don't know HOW to post it !!

Hooy:

I just e-mailed you a copy as well as two others (20camaro10 & alex33x) that requested it. If any of you guys know how to post it in the forum, feel free to do so.

Anyone else want a copy, send me a PM with your e-mail address !!

Doug

Hooy · 04-10-2009, 02:58 AM

Thanks very much! Great work.

*Milk 1027* · 04-10-2009, 03:13 AM

contact Tran. He should know what to do

*DGthe3* · 04-10-2009, 08:21 PM

Quote:

Originally Posted by dougmac

You enter transmission gear ratios, diff ratio, rim diameter, and tire section height.
Rim dia. & section height calculates tire dia. & revs per mile which when multiplied with the gear ratios calculates RPM in all gears at 60 MPH, MPH in all gears at 2000 RPM, plus a few other cacualtions that I could fit on the page.

Here is an example of 1 column ...

Camaro 1LS
V6 MT
Displacement 3.6L / 217.3c.i.
Horsepower 304 @ 6400
Torque 273 @ 5200
Curb Wgt. 3741 lbs.
Wgt. : HP ratio 12.3
EPA Mileage 17/29 MPG
Fuel Tank Size 19.0 Gal.
Range per tank 323/551 Miles
437 ave.

1st Gear 4.480 :1
2nd Gear 2.580 :1
3rd Gear 1.630 :1
4th Gear 1.190 :1
5th Gear 1.000 :1
Overdrive 0.750 :1
Differential 3.270 :1

Tire Size (rear) 245/55- 18
Section Height 5.305
Tire Dia. 28.610
Revolution/Mile 727

1st @ 2000 RPM 11 MPH
2st @ 2000 RPM 20 MPH
3rd @ 2000 RPM 31 MPH
4th @ 2000 RPM 42 MPH
5th @ 2000 RPM 50 MPH
O.D. @ 1000 RPM 34 MPH
O.D. @ 1500 RPM 50 MPH
O.D. @ 2000 RPM 67 MPH
O.D. @ 2500 RPM 84 MPH
O.D. @ 3000 RPM 101 MPH
O.D. @ 3500 RPM 118 MPH

1st @ 60 MPH * 10651 RPM
2st @ 60 MPH * 6134 RPM
3rd @ 60 MPH 3875 RPM
4th @ 60 MPH 2829 RPM
5th @ 60 MPH 2377 RPM
O.D. @ 60 MPH 1783 RPM
O.D. @ 75 MPH 2229 RPM

... looks MUCH BETTER in the spreadsheet !!

Spreadsheet is in landscape format and is currently 5 pages wide with 8 cars per page (40 cars total). Page 1 is all the 2010 Camaro variations, Page 2-5 is all the Mustang, Challenger, Genesis Coupe variations as well as 6 other sporty RWD coupes and 10 4-door RWD sedans.

Inital reason for making this was I wanted to compare the 2010 Mustang, Camaro, and Genesis Coupe specs to my previous 1994, 1998, & current 2004 Mustang. Started as a comparison for potential MPG & mile range per tank, but it could easily be altered to show performance stats like MPH in each gear at Redline, etc.

Anyone interested in looking at & playing with this spreadsheet send me a PM with your e-mail address.

Any mods interested in putting this somewhere on the web site, let me know.

Doug

I remember working on something like that but I lost it when I had to reformat my computer. Send it to Tran and he can get it posted for you.

dougmac · 04-11-2009, 08:51 AM

Thanks everyone,

I have been in contact with Tran and sent it to him yesterday.

If anyone else wants their OWN copy before it officially gets posted, PM me with your e-mail address.

Doug

Tran · 04-20-2009, 06:15 PM

Doug's gear ratio spreadsheet is now available for download (HERE)! Sorry for the delay, I forgot

*Milk 1027* · 04-20-2009, 06:19 PM

nice

04-09-2009, 09:53 AM	#1
dougmac Drives: 2011 V6 MCA & 1969 GT Mustang Join Date: Mar 2009 Location: N.E. Wisconsin Posts: 112	Gear Ratio/RPM/MPH Spreadsheet in MS Excel ... >> DOWNLOAD SPREADSHEET HERE << You enter transmission gear ratios, diff ratio, rim diameter, and tire section height. Rim dia. & section height calculates tire dia. & revs per mile which when multiplied with the gear ratios calculates RPM in all gears at 60 MPH, MPH in all gears at 2000 RPM, plus a few other cacualtions that I could fit on the page. Here is an example of 1 column ... Camaro 1LS V6 MT Displacement 3.6L / 217.3c.i. Horsepower 304 @ 6400 Torque 273 @ 5200 Curb Wgt. 3741 lbs. Wgt. : HP ratio 12.3 EPA Mileage 17/29 MPG Fuel Tank Size 19.0 Gal. Range per tank 323/551 Miles 437 ave. 1st Gear 4.480 :1 2nd Gear 2.580 :1 3rd Gear 1.630 :1 4th Gear 1.190 :1 5th Gear 1.000 :1 Overdrive 0.750 :1 Differential 3.270 :1 Tire Size (rear) 245/55- 18 Section Height 5.305 Tire Dia. 28.610 Revolution/Mile 727 1st @ 2000 RPM 11 MPH 2st @ 2000 RPM 20 MPH 3rd @ 2000 RPM 31 MPH 4th @ 2000 RPM 42 MPH 5th @ 2000 RPM 50 MPH O.D. @ 1000 RPM 34 MPH O.D. @ 1500 RPM 50 MPH O.D. @ 2000 RPM 67 MPH O.D. @ 2500 RPM 84 MPH O.D. @ 3000 RPM 101 MPH O.D. @ 3500 RPM 118 MPH 1st @ 60 MPH * 10651 RPM 2st @ 60 MPH * 6134 RPM 3rd @ 60 MPH 3875 RPM 4th @ 60 MPH 2829 RPM 5th @ 60 MPH 2377 RPM O.D. @ 60 MPH 1783 RPM O.D. @ 75 MPH 2229 RPM ... looks MUCH BETTER in the spreadsheet !! Spreadsheet is in landscape format and is currently 5 pages wide with 8 cars per page (40 cars total). Page 1 is all the 2010 Camaro variations, Page 2-5 is all the Mustang, Challenger, Genesis Coupe variations as well as 6 other sporty RWD coupes and 10 4-door RWD sedans. Inital reason for making this was I wanted to compare the 2010 Mustang, Camaro, and Genesis Coupe specs to my previous 1994, 1998, & current 2004 Mustang. Started as a comparison for potential MPG & mile range per tank, but it could easily be altered to show performance stats like MPH in each gear at Redline, etc. >> DOWNLOAD SPREADSHEET HERE << Doug

04-10-2009, 03:13 AM	#5
Milk 1027 Camaro➎ moderator Drives: '13 BLK 1LE Join Date: Aug 2008 Location: AZ Posts: 13,567 View My Garage	contact Tran. He should know what to do __________________

04-20-2009, 06:19 PM	#9
Milk 1027 Camaro➎ moderator Drives: '13 BLK 1LE Join Date: Aug 2008 Location: AZ Posts: 13,567 View My Garage	nice __________________

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Camaro on Top Gear	chewy4ce	5th Gen Camaro SS LS LT General Discussions	234	03-22-2010 02:14 AM
Do you think it was right that the mustang got to use the trackpack in the comparison	perfxn	Chevy Camaro vs...	91	03-30-2009 09:44 PM
Fifth Gear - Dodge Challenger SRT8	ihc95	General Automotive + Other Cars Discussion	27	10-01-2008 03:57 PM
blew second gear.	carguy_z28	4th Generation Camaros	5	09-17-2008 11:14 PM

04-09-2009, 10:22 AM	#2
Hooy Will Drive For Food Drives: Acura TL Join Date: Jan 2009 Location: Houston Posts: 261 View My Garage	You should finalize it and post it up! I'd definitely like to take a look at this. Thanks!

04-10-2009, 02:58 AM	#4
Hooy Will Drive For Food Drives: Acura TL Join Date: Jan 2009 Location: Houston Posts: 261 View My Garage	Thanks very much! Great work.

04-11-2009, 08:51 AM	#7
dougmac Drives: 2011 V6 MCA & 1969 GT Mustang Join Date: Mar 2009 Location: N.E. Wisconsin Posts: 112	Thanks everyone, I have been in contact with Tran and sent it to him yesterday. If anyone else wants their OWN copy before it officially gets posted, PM me with your e-mail address. Doug

04-20-2009, 06:15 PM	#8
Tran Administrator Drives: 2010 Camaro of course.... Join Date: Apr 2006 Location: NE baby Posts: 5,616 View My Garage	Doug's gear ratio spreadsheet is now available for download (HERE)! Sorry for the delay, I forgot