Excel file to help gear ratio tuning

sucahyo · Oct 10, 2005

The first file trantuner.xls, is from NoQuarter from his post at
http://granturismoforum.com/showthread.php?threadid=59769
http://forums.gttimes.com/viewtopic.php?p=148006
http://hgt.themaille.com/forum/index.php?showtopic=664020&view=getlastpost

this file calculate the top speed of each gear using top rpm and gear ratio, it also can be used to calculate the gear ratio of different final drive.

The second file Jmac's GT2 Gear Ratio Guide.xls, is from Jmac279, he has gearing tips on
https://www.gtplanet.net/forum/showpost.php?p=1573114&postcount=9

this file is the easiest to use, you just enter lowest 1st gear, highest 4th gear, top rpm, maximum power rpm, and it will calculate the best gear ratio and even the optimal shifting point 👍 !

The third file, gearrpm.xls is from me. This file calculate the start rpm after changing gear (on spesific rpm), it also calculate the gear ratio based on the target start rpm you enter. You can also enter the incremental rpm that you want. Using 0 delta have the exact same result with Jmac's static gearing.
You need to use excel goal seek to maximized the gear. I add second method with calculated suggested gear change based on start rpm you want (you can just enter the start rpm you want on the first method). Also speed estimator is hidden in O & P column. Try it on 1st gear, modify max rpm and tire diameter to get more accurate result.

Tuning the gear is important because it can make you win easier

There is many good gear tuning tips on this forum 👍 !

This is spoon integra with gear tuning vs no tuning at the first race on GT300

You can slam other car easier if you can keep up

Using suggestion from Jmac279 and MacRoadster I can make it faster 👍 !

With this, I can slam the first car

, it doesn't matter how bad I am on corner as long as I have the first corner, the rest of the race is easy............
On whatever file I mostly use 2.500 final drive because it gives me faster 1000m .............

edit: added my newest calculator

MacRoadster · Oct 10, 2005

Nice links 👍

I've got some nice tools long time ago, to calculate gear ratios, but ended by never using them with GT2...

The Spoon Integra is a very nice car, we were beating the All Stars in Red Rock on the "Challenge Me" thread some months ago. Jmac even posted a video of his driving

Jmac279 · Oct 10, 2005

My calculator is better

sucahyo · Oct 11, 2005

Jmac279
My calculator is better

Wow, complete with optimal gear shifting!
I see, using the same start rpm for wide power band and using different start rpm for narrow band .....

I use my file to make lowest 1st ratio and maximum high gear ratio. I use goal seek to make the 4th or 5th gear maximum by changing 2nd gear ratio, with 1st gear is always minimum. But I forgot the include the instructions ..............

If you use my table you can make the high gear maximum on dynamic method too

, I think that you should use highest 5th (not 4th) gear ratio on dynamic method.

sucahyo · Oct 12, 2005

MacRoadster
The Spoon Integra is a very nice car, we were beating the All Stars in Red Rock on the "Challenge Me" thread some months ago. Jmac even posted a video of his driving

Too bad the link is gone ......, do you still have it Jmac?
I try it with my dirtiest method and can only make in 4th

.

Jmac279 · Oct 12, 2005

I've done 5:56 with the Spoon ITR on that race. I find it quite easy to win ... I'm usually in the lead by the end of the first corner and don't usually relinquish the lead from then on ...

I don't have the video anymore, unfortunately ... Maybe I'll record my driving again some time ...

Jmac279 · Oct 12, 2005

Updated ...

sucahyo · Oct 12, 2005

Jmac279
Updated ...

7 Speed!
Are there any car that have 7 speed in GT2 ?

BTW, I just found out (after using your car setting 👍 ) that using higher spring rate can increase your speed in Redrock corner. The fastest lap that I can do is know 11.5xx

. I think I will try it again with 16.0/16.0 spring rate ............

Jmac279 · Oct 12, 2005

Here are a couple replays I did tonight ... didn't exactly drive well, but I won ...

Jmac279 · Oct 12, 2005

sucahyo
7 Speed!
Are there any car that have 7 speed in GT2 ?

The Subaru Pleos have 7-speed transmissions ... they're also popular in hybrids ...

Updated again ...

Changes:

Added *rough* optimum shift points for stock transmissions
Corrected *rough* optimum shift points for all calculators
Minor layout changes

sucahyo · Oct 13, 2005

Jmac279
Here are a couple replays I did tonight ... didn't exactly drive well, but I won ...

Thank you, this is very informative 👍 . It seems that my cornering on corner after the tunnel is wrong, because you have faster speed before the last corner.

BTW is this the right replay ? Because when I play it (three times), your replay have 1:13.605 best lap, 6:15 total, and came in 4th (the computer seems to plays differently on each replay but the end result is the same)

I use harder spring rate and I can make 2nd (using load and save)!

Jmac279 · Oct 13, 2005

No, I didn't run a 6:15 ... I ran a 6:05 and was quite disappointed (although I still won) ...

You must be loading it off the wrong memory card ... The replays should be labeled "Spoon ITR GT-AS RRV" and "RRV2" ...

sucahyo · Oct 13, 2005

Jmac279
You must be loading it off the wrong memory card ... The replays should be labeled "Spoon ITR GT-AS RRV" and "RRV2" ...

Oops, it is wrong memory cards!
But sadly it won't replay properly, in the first replay the integra out accelerate a GT40! and the second one keep hitting the wall. I think I should find NTSC sim disc first .........

MacRoadster · Oct 13, 2005

sucahyo
But sadly it won't replay properly, in the first replay the integra out accelerate a GT40! and the second one keep hitting the wall. I think I should find NTSC sim disc first .........

I've tried the replays too, after converting the saved game to my version, but all i see is the Spoon hitting the wall on the 1st corner, just like you...

sucahyo · Oct 13, 2005

MacRoadster
I've tried the replays too, after converting the saved game to my version, but all i see is the Spoon hitting the wall on the 1st corner, just like you...

How do you convert it?

MacRoadster · Oct 13, 2005

sucahyo
How do you convert it?

With PSXGameEdit

Jmac279 · Oct 13, 2005

Okay, well, I'll just use Fraps to record the replays then ...

sucahyo · Oct 14, 2005

Jmac279
Okay, well, I'll just use Fraps to record the replays then ...

Thank you! It will worth to wait

HYBRIDLVR · Apr 27, 2006

Jmac279
The Subaru Pleos have 7-speed transmissions ... they're also popular in hybrids ...

Updated again ...

Changes:

Added *rough* optimum shift points for stock transmissions
Corrected *rough* optimum shift points for all calculators
Minor layout changes

This Gear Calculator is cool but a GS is so much easier to really tweak the gears and Put a 7Speed in ALL your cars, Nice work though!

Parnelli Bone · Apr 27, 2006

HYBRIDLVR
This Gear Calculator is cool but a GS is so much easier to really tweak the gears and Put a 7Speed in ALL your cars, Nice work though!

But what if I don't want a 7 speed in all my cars?

sucahyo · Apr 27, 2006

I think calculator can help tuning non hybrid or hybrid gearing, since we can get almost exact gear ratio for the speed we need.
The calculator (slightly modified in my signature) really help me in GT4 300mph race, 4 first position with only 16 total hour playing

.
With calculator, I only need few minutes to tweak the gear.

HYBRIDLVR · Apr 27, 2006

Parnelli Bone
But what if i don't want a 7 speed in all my cars?

I'm sure you can figure that out?

Excel file to help gear ratio tuning

sucahyo

Attachments

MacRoadster

Jmac279

sucahyo

sucahyo

Jmac279

Jmac279

sucahyo

Jmac279

Attachments

Jmac279

Attachments

sucahyo

Jmac279

sucahyo

MacRoadster

sucahyo

MacRoadster

Jmac279

sucahyo

HYBRIDLVR

Parnelli Bone

www.gtcarreviews.com

sucahyo

HYBRIDLVR

Similar threads

Latest Posts