Excel file to help gear ratio tuning

Discussion in 'Gran Turismo 2' started by sucahyo, Oct 10, 2005.

  1. sucahyo

    sucahyo

    Messages:
    2,171
    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 :tup: !


    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 :tup: !

    This is spoon integra with gear tuning vs no tuning at the first race on GT300
    [​IMG]
    [​IMG]

    You can slam other car easier if you can keep up ;)

    Using suggestion from Jmac279 and MacRoadster I can make it faster :tup: !
    [​IMG]
    With this, I can slam the first car :D , 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
     

    Attached Files:

  2. MacRoadster

    MacRoadster

    Messages:
    409
    Nice links :tup:

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

    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 :)
     
  3. Jmac279

    Jmac279

    Messages:
    1,019
    Location:
    Canada
    My calculator is better :)
     
  4. sucahyo

    sucahyo

    Messages:
    2,171
    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.
     
  5. sucahyo

    sucahyo

    Messages:
    2,171
    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 :(.
    [​IMG]
     
  6. Jmac279

    Jmac279

    Messages:
    1,019
    Location:
    Canada
    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 ...
    [​IMG]

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

    Jmac279

    Messages:
    1,019
    Location:
    Canada
    Updated ...
     
  8. sucahyo

    sucahyo

    Messages:
    2,171
    7 Speed!
    Are there any car that have 7 speed in GT2 ?

    BTW, I just found out (after using your car setting :tup: ) 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 ............
     
  9. Jmac279

    Jmac279

    Messages:
    1,019
    Location:
    Canada
    Here are a couple replays I did tonight ... didn't exactly drive well, but I won ...
     

    Attached Files:

  10. Jmac279

    Jmac279

    Messages:
    1,019
    Location:
    Canada
    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
     

    Attached Files:

  11. sucahyo

    sucahyo

    Messages:
    2,171
    Thank you, this is very informative :tup: . 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)
    [​IMG]

    I use harder spring rate and I can make 2nd (using load and save)!
    [​IMG]
     
  12. Jmac279

    Jmac279

    Messages:
    1,019
    Location:
    Canada
    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" ...
     
  13. sucahyo

    sucahyo

    Messages:
    2,171
    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 .........
    [​IMG]
     
  14. MacRoadster

    MacRoadster

    Messages:
    409
    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...
     
  15. sucahyo

    sucahyo

    Messages:
    2,171
    How do you convert it?
     
  16. MacRoadster

    MacRoadster

    Messages:
    409
    With PSXGameEdit
     
  17. Jmac279

    Jmac279

    Messages:
    1,019
    Location:
    Canada
    Okay, well, I'll just use Fraps to record the replays then ...
     
  18. sucahyo

    sucahyo

    Messages:
    2,171
    Thank you! It will worth to wait :)
     
  19. HYBRIDLVR

    HYBRIDLVR

    Messages:
    1,443
    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!
     
  20. Parnelli Bone

    Parnelli Bone Premium

    Messages:
    10,440
    Location:
    United States
    But what if i don't want a 7 speed in all my cars?
     
  21. sucahyo

    sucahyo

    Messages:
    2,171
    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.
     
  22. HYBRIDLVR

    HYBRIDLVR

    Messages:
    1,443

    I'm sure you can figure that out?