Optimal Shifting Point Calculator
Special thanks to Ramón Paulino and Atsamaz Basiev for their valuable help on this project.
Atsamaz Basiev: dg-edge profile Atsamazing / Instagram account
Instructions
Please note that actual performance may vary, as this is based on a theoretical upshift point.
The file has been uploaded to Google Sheets and is intended for use there. If you prefer to use it in Excel, keep in mind that some formulas may need to be adjusted accordingly. If you have any suggestions, feel free to leave them in the comments section on YouTube.
Please keep in mind that these two versions are different. The first one—the Google Sheets version—is designed to be used directly in Google Sheets. The Excel file is slightly more advanced and updated, but it requires Microsoft Excel to function properly. If you try to use the same file in both platforms, it won’t work as intended. Some formulas will need to be adjusted to ensure compatibility. You can download them simply by clicking on the links.
1. Step
Please add the transmission values from the in-game settings tab to the sheets.
2. Step
Locate the torque curve in the Turbo or ECU section (gray line). Make sure to copy the image and save it to your PC.
Locate the X1 (blue dot), X2 (blue dot), Y1 (red dot), and Y2 (red dot) values to generate the graph data. The app tracks pixels, so you’ll need to manually place the white dots to trace the line accurately.
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, which represents the start of the X-axis, and X2 is the maximum RPM—8.000 in this case.
3. Step
In the upper left corner, you’ll find a few options to export the values from the app. Click on “Copy to clipboard” to copy the values.
IMPORTANT: Adding more points to the graph will result in more accurate results.
Go back to the Google Sheet and paste the copied values into cell A1. Then, click on “Split text to columns” to separate the values properly.
Now that the values are correctly split, the sheet can begin processing the data. Check the progress bar in the upper right corner to confirm that the data is refreshing.
4. Step
Find you optimal shifting points in the “RESULTS” tab.
Remember that while this computation includes seven speeds, the car only has six gears. Therefore, the shift into seventh gear can be disregarded. In this example, I used only 12 reference points on the graph, which affects the accuracy, so the shift points differ from those calculated using more reference points. You can share your results on the Discord server.
