Excel file to help gear ratio tuning |
Post Reply|
|
Thread Tools |
|
Oct 09 2005, 8:38 PM
#1
The first file trantuner.xls, is from NoQuarter from his post at
http://granturismoforum.com/showthre...threadid=59769 http://forums.gttimes.com/viewtopic.php?p=148006 http://hgt.themaille.com/forum/index...ew=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 http://www.gtplanet.net/forum/showpo...14&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
Last edited by sucahyo; Jun 12 2006 at 1:47 AM.
|
|
Oct 10 2005, 3:46 AM
#2
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
|
|
Oct 10 2005, 5:38 PM
#3
My calculator is better
Last edited by Jmac279; Oct 12 2005 at 3:57 AM.
|
|
Oct 10 2005, 9:40 PM
#4
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.
|
|
|
Oct 11 2005, 8:02 PM
#5
I try it with my dirtiest method and can only make in 4th  .
|
|
|
Oct 11 2005, 9:53 PM
#6
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 ...
Last edited by Jmac279; Oct 12 2005 at 3:59 AM.
|
|
Oct 12 2005, 3:58 AM
#7
Updated ...
Last edited by Jmac279; Oct 12 2005 at 5:27 PM.
|
|
Oct 12 2005, 4:39 AM
#8
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 ............
|
|
|
Oct 12 2005, 6:04 AM
#9
Here are a couple replays I did tonight ... didn't exactly drive well, but I won ...
|
|
Oct 12 2005, 5:30 PM
#10
Updated again ... Changes: Added *rough* optimum shift points for stock transmissions Corrected *rough* optimum shift points for all calculators Minor layout changes
Last edited by Jmac279; Oct 12 2005 at 5:34 PM.
|
|
|
Oct 12 2005, 10:36 PM
#11
. 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)! 
|
|
|
Oct 12 2005, 11:23 PM
#12
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" ... |
|
Oct 13 2005, 12:39 AM
#13
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 ......... 
Last edited by sucahyo; Oct 13 2005 at 1:34 AM.
|
|
|
Oct 13 2005, 3:12 AM
#14
|
|
|
Oct 13 2005, 4:48 AM
#15
|
|
|
Oct 13 2005, 7:17 AM
#16
|
|
|
Oct 13 2005, 2:03 PM
#17
Okay, well, I'll just use Fraps to record the replays then ...
|
|
Oct 13 2005, 8:57 PM
#18
|
|
|
Apr 26 2006, 10:51 PM
#19
|
|
|
Apr 26 2006, 11:31 PM
#20
|
|
| Thread Tools | |
Join GTPlanet
Become a member of the largest online community dedicated to sim-racing. It's free!
Become a member of the largest online community dedicated to sim-racing. It's free!
Got News?
Find something interesting? Let us know.
Find something interesting? Let us know.
Advertising
Got a cool product? You've found the right audience - contact us to learn more.
Got a cool product? You've found the right audience - contact us to learn more.