Camaro5 Chevy Camaro Forum / Camaro ZL1, SS and V6 Forums - Camaro5.com
 
Nightowl LED
Go Back   Camaro5 Chevy Camaro Forum / Camaro ZL1, SS and V6 Forums - Camaro5.com > General Camaro Forums > 5th Gen Camaro SS LS LT General Discussions

5th Gen Camaro SS LS LT General Discussions General 5th generation Camaro topics not covered by other subforums.

Reply
 
Thread Tools
Old 04-09-2009, 10:53 AM   #1
dougmac
 
Drives: 2011 V6 MCA & 1969 GT Mustang
Join Date: Mar 2009
Location: N.E. Wisconsin
Posts: 112
Post 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
dougmac is offline   Reply With Quote
Old 04-09-2009, 11:22 AM   #2
Hooy
Will Drive For Food
 
Drives: Acura TL
Join Date: Jan 2009
Location: Houston
Posts: 261
You should finalize it and post it up! I'd definitely like to take a look at this. Thanks!
Hooy is offline   Reply With Quote
Old 04-09-2009, 01:13 PM   #3
dougmac
 
Drives: 2011 V6 MCA & 1969 GT Mustang
Join Date: Mar 2009
Location: N.E. Wisconsin
Posts: 112
Quote:
Originally Posted by Hooy View Post
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
dougmac is offline   Reply With Quote
Old 04-10-2009, 03:58 AM   #4
Hooy
Will Drive For Food
 
Drives: Acura TL
Join Date: Jan 2009
Location: Houston
Posts: 261
Thanks very much! Great work.
Hooy is offline   Reply With Quote
Old 04-10-2009, 04:13 AM   #5
Milk 1027
Camaro➎ moderator
 
Milk 1027's Avatar
 
Drives: '13 BLK 1LE
Join Date: Aug 2008
Location: AZ
Posts: 13,536
contact Tran. He should know what to do
__________________
Milk 1027 is offline   Reply With Quote
Old 04-10-2009, 09:21 PM   #6
DGthe3
Moderator.ca
 
DGthe3's Avatar
 
Drives: 05 Grand Am GT
Join Date: Jul 2007
Location: Niagara, Canada
Posts: 22,196
Send a message via MSN to DGthe3
Quote:
Originally Posted by dougmac View Post
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.
__________________
Note, if I've gotten any facts wrong in the above, just ignore any points I made with them
__________________
don't believe a thing you read about the next gen Camaro -- as history has proven time and time again:

WE DO NOT TALK ABOUT FUTURE PRODUCT PLANS PERIOD FbodFather
__________________

Camaro5 Fest sub-forum
DGthe3 is offline   Reply With Quote
Old 04-11-2009, 09: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
dougmac is offline   Reply With Quote
Old 04-20-2009, 07:15 PM   #8
Tran
Administrator
 
Tran's Avatar
 
Drives: 2010 Camaro of course....
Join Date: Apr 2006
Location: NE baby
Posts: 5,040
Doug's gear ratio spreadsheet is now available for download (HERE)! Sorry for the delay, I forgot
Tran is offline   Reply With Quote
Old 04-20-2009, 07:19 PM   #9
Milk 1027
Camaro➎ moderator
 
Milk 1027's Avatar
 
Drives: '13 BLK 1LE
Join Date: Aug 2008
Location: AZ
Posts: 13,536
nice
__________________
Milk 1027 is offline   Reply With Quote
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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 03: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 10:44 PM
Fifth Gear - Dodge Challenger SRT8 ihc95 General Automotive + Other Cars Discussion 27 10-01-2008 04:57 PM
blew second gear. carguy_z28 4th Generation Camaros 5 09-18-2008 12:14 AM


All times are GMT -5. The time now is 12:24 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.