Gear Ratios ... RPM vs. SPEED spreadsheet - Hyundai Genesis Forum
Transmission and Drivetrain This section is reserved for talking about transmission and drivetrain discussions.

Reply
 
LinkBack Thread Tools Display Modes
post #1 of 20 Old 02-15-2009, 09:47 AM Thread Starter
Senior Member
 
orange3.9stang's Avatar
 
Join Date: Feb 2009
Location: N.E. Wisconsin
Posts: 82
orange3.9stang is on a distinguished road
(Thread Starter)
Gear Ratios ... RPM vs. SPEED spreadsheet

I made a spreadsheet in Lotus 1-2-3 to compare engine RPM vs. MPH between the new Genesis 2.0T & 3.8, new V6 Camaro, V6 Mustang and previous V6 Mustang's I've owned. Also added other Manual Transmission / RWD cars currently available as well as 2009 MINI Clubman S, and 2008 Tiburon models. Also did 3 collums with changed rear gears in the 2.0T & 3.8 using 3.8 gears in the 2.0T and 4.6 Senan gears in both the 2.0T & 3.8. All in all on 2 landscape pages, info on 18 different cars can be compared.

Spreadsheet does all the math, all you need to change to check a different car is the transmission gear ratios, final drive ratio, tire section height, and rim diameter.

Also have rows for Vehicle, HP, Torque, Curb wgt., lb./HP ratio, EPA mileage, fuel tank size, and range per tank that you can edit for each car you want to compare.

Not sure if this type of file can be attached or inserted in a thread. If anyone is familiar with Lotus 1-2-3 and wants a copy of this spreadsheet to play with (or would know how to post it in the forum), PM me with your e-mail address and I'll send you a copy.

Doug
orange3.9stang is offline  
post #2 of 20 Old 02-15-2009, 10:20 AM
Moderator
 
Tufast's Avatar
 
Join Date: Sep 2008
Location: Columbus, GA
Posts: 10,780
Tufast is on a distinguished road
Thanks alot Doug, pm my email now

Sponsored By: Columbus Body Works / ARK Performance / Modern Automotive Performance / Forged Performance
Tufast is offline  
post #3 of 20 Old 02-15-2009, 12:35 PM
Poser!
 
Sabbasaun's Avatar
 
Join Date: Jul 2008
Posts: 2,997
Sabbasaun is on a distinguished road
Thumbs up

Quote:
Originally Posted by orange3.9stang View Post
I made a spreadsheet in Lotus 1-2-3 to compare engine RPM vs. MPH between the new Genesis 2.0T & 3.8, new V6 Camaro, V6 Mustang and previous V6 Mustang's I've owned. Also added other Manual Transmission / RWD cars currently available as well as 2009 MINI Clubman S, and 2008 Tiburon models. Also did 3 collums with changed rear gears in the 2.0T & 3.8 using 3.8 gears in the 2.0T and 4.6 Senan gears in both the 2.0T & 3.8. All in all on 2 landscape pages, info on 18 different cars can be compared.

Spreadsheet does all the math, all you need to change to check a different car is the transmission gear ratios, final drive ratio, tire section height, and rim diameter.

Also have rows for Vehicle, HP, Torque, Curb wgt., lb./HP ratio, EPA mileage, fuel tank size, and range per tank that you can edit for each car you want to compare.

Not sure if this type of file can be attached or inserted in a thread. If anyone is familiar with Lotus 1-2-3 and wants a copy of this spreadsheet to play with (or would know how to post it in the forum), PM me with your e-mail address and I'll send you a copy.

Doug
Awesome thanks Orange! Can't wait to see the file. You should also be able to insert or attache the file, give it a go.
Sabbasaun is offline  
 
post #4 of 20 Old 02-15-2009, 01:00 PM Thread Starter
Senior Member
 
orange3.9stang's Avatar
 
Join Date: Feb 2009
Location: N.E. Wisconsin
Posts: 82
orange3.9stang is on a distinguished road
(Thread Starter)
Quote:
Originally Posted by Sabbasaun View Post
Awesome thanks Orange! Can't wait to see the file. You should also be able to insert or attache the file, give it a go.
I e-mailed a copy of the file to Tufast, hopefully he can get it up on here.

Added a 3rd page and 5 more '09 RWD 6-Speed cars I thought of (23 total with room for 4 more) to the spreadsheet too.

Doug
orange3.9stang is offline  
post #5 of 20 Old 02-15-2009, 02:44 PM
Moderator
 
Tufast's Avatar
 
Join Date: Sep 2008
Location: Columbus, GA
Posts: 10,780
Tufast is on a distinguished road
Quote:
Originally Posted by orange3.9stang View Post
I e-mailed a copy of the file to Tufast, hopefully he can get it up on here.

Added a 3rd page and 5 more '09 RWD 6-Speed cars I thought of (23 total with room for 4 more) to the spreadsheet too.

Doug
Thanks Doug, I received it, but my computer don't like it. So, It'll take a while to figure out how to convert it & eventually get up on here. I'm sorry, but I'm not too computer savvy.

Sponsored By: Columbus Body Works / ARK Performance / Modern Automotive Performance / Forged Performance
Tufast is offline  
post #6 of 20 Old 02-15-2009, 02:58 PM Thread Starter
Senior Member
 
orange3.9stang's Avatar
 
Join Date: Feb 2009
Location: N.E. Wisconsin
Posts: 82
orange3.9stang is on a distinguished road
(Thread Starter)
Quote:
Originally Posted by Tufast View Post
Thanks Doug, I received it, but my computer don't like it. So, It'll take a while to figure out how to convert it & eventually get up on here. I'm sorry, but I'm not too computer savvy.
Neither am I ... figured someone one here would be !!
orange3.9stang is offline  
post #7 of 20 Old 02-15-2009, 04:26 PM
Poser!
 
Sabbasaun's Avatar
 
Join Date: Jul 2008
Posts: 2,997
Sabbasaun is on a distinguished road
Send it to me, I'll try to convert it...
Sabbasaun is offline  
post #8 of 20 Old 02-15-2009, 09:53 PM
The Dude
 
Lord Calvert's Avatar
 
Join Date: Aug 2008
Location: Puyallup,Wa
Posts: 2,120
Lord Calvert is on a distinguished road
I didn't even know that Lotus 1-2-3 was still around. I remmeber that from the early to mid 90's, do they still make it?
Lord Calvert is offline  
post #9 of 20 Old 02-16-2009, 01:31 AM Thread Starter
Senior Member
 
orange3.9stang's Avatar
 
Join Date: Feb 2009
Location: N.E. Wisconsin
Posts: 82
orange3.9stang is on a distinguished road
(Thread Starter)
Quote:
Originally Posted by Lord Calvert View Post
I didn't even know that Lotus 1-2-3 was still around. I remmeber that from the early to mid 90's, do they still make it?
Last I knew it was called Lotus SmartSuite ... have a copy of this at work as well as the old stand-by Version 2.4 (DOS) which is what I still do Quotes on and is from the '80's !! This program is so old, it will not work with new printers so I got an old HP Laser Jet 4 still next to my desk.

Doug
orange3.9stang is offline  
post #10 of 20 Old 02-16-2009, 01:32 AM Thread Starter
Senior Member
 
orange3.9stang's Avatar
 
Join Date: Feb 2009
Location: N.E. Wisconsin
Posts: 82
orange3.9stang is on a distinguished road
(Thread Starter)
Quote:
Originally Posted by Sabbasaun View Post
Send it to me, I'll try to convert it...
You'll need to PM me with your e-mail address !!

Doug
orange3.9stang is offline  
Reply

Tags
Gear Ratio Spreadsheet , RPM vs MPH , RPM vs Speed , spreadsheet

Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



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
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome