Optimal shifting point

Optimal shifting point

SPECIAL THANK YOU

Special thanks to Ramón Paulino for his help in this project.

INSTRUCTIONS

Please be aware that there may be some variations in actual performance as this is simply a theoretical upshift point.

The file is uploaded to Google Sheets and should be used there. If you want to use the file in Excel, some formulas will need to be adjusted.

Access File

If you have some suggestions please write in the comments section on YouTube. 

1. Step

Optimal shifting point | Image 1615

Add the transmission values from the settings tab in-game to the sheets.

Optimal shifting point | Image 1608

2. Step

Locate the torque curve in the turbo or ECU section (GRAY LINE). Also you need to copy the picture and save it on your PC.

Optimal shifting point | Image 1614
Locate the X1 (blue dot), X2 (blue dot), Y1 (red dot) and Y2 (red dot) values to form graphic values. The app tracks pixels and you have to manually add the white dots to track the line.

Optimal shifting point | Image 1612

Also, you need to enter the X-axis and Y-axis values on the right side of the interface. Y1 is always 0 and Y2 is the peak torque (65 in this case). X1 is 1.000 in this case or the start of x-axis and X2 is max. revs, this case 8.000.

3. Step

In the upper left corner there are a couple of options to export the values from the app. Click on “Copy to clipboard” to copy the values.

Optimal shifting point | Image 1607
IMPORTANT: More points on the graph will lead to more accurate results.

Go back to the Google Sheet and paste the values into cell A1.

Then you will need to click in “Split text to columns” to divide the values.

Optimal shifting point | Image 1609
Now there is the right split of values and the sheets can process the data. Please have a look at the progress bar to see if the data is refreshing (upper right corner).

Optimal shifting point | Image 1606

4. Step

Find you optimal shifting points in the “RESULTS” tab.

Optimal shifting point | Image 1610
Remember that while this computation uses seven speeds, a car only has six. Therefore, shifting up into seventh gear may be disregarded. In this case I used only 12 reference points on the graph and shifting points are different from the one where I used more reference points.

You can add your results on the discord server.

Join Discord!