Hi boys! I created a spreadsheet using Google Sheets that calculates the optimum race strategy according to fuel levels and tyre wear. It's not black magic, but it requires a tiny bit of time to fully understand it. I just feel like I have to share my work with you as I love this community.
You can get it from this link:
Copy into your Google Drive
The first and the most important step you have to take it’s to make sure you’re not editing the public release of the sheet. Other people may be online working on the same file at once and get in the way of each other. By copying the Google Sheet on your Drive, you’re sure no one else can edit it. You can still view and edit the sheet even if you haven’t a Google Account, but I highly recommend avoiding it.
Copy into your Google Drive by: File > Create a copy
Items Description
The whole interface is divided into 4 different tabs: Race, Fuel, Tyres and Pitboard; with a total of 7 editable cells, each of these highlighted with a small black triangle in the upper-right corner.
A brief explanation of each cell is shown by hovering the mouse over it and it’s reported here for clarification purposes.
RACE
You can get it from this link:
Copy into your Google Drive
The first and the most important step you have to take it’s to make sure you’re not editing the public release of the sheet. Other people may be online working on the same file at once and get in the way of each other. By copying the Google Sheet on your Drive, you’re sure no one else can edit it. You can still view and edit the sheet even if you haven’t a Google Account, but I highly recommend avoiding it.
Copy into your Google Drive by: File > Create a copy
Items Description
The whole interface is divided into 4 different tabs: Race, Fuel, Tyres and Pitboard; with a total of 7 editable cells, each of these highlighted with a small black triangle in the upper-right corner.
A brief explanation of each cell is shown by hovering the mouse over it and it’s reported here for clarification purposes.
RACE
- Race Length: in minutes. The software can calculate the strategy for VERY long races, but only the first 150 laps are shown, as the Pitboard repeats itself at some point.
- Laptime: in seconds. Expected average laptime in race conditions. Use comma as a decimal separator.
- Estimated Laps: the total amount of laps are estimated based on your average race pace and the race length. The white flag is supposed to be shown only when there is no time left.
- Tank Size: tank capacity, or your starting fuel, if you don't need to stop for refueling.
- Fuel/Lap: amount of fuel consumed every lap. It can be set in Litres, kg or Gallons. Use comma as a decimal separator.
- Fuel Window: In this fuel window, the number of refuels doesn't change. A consumption lower than that means less pit-stops, more otherwise.
- Tyre Wear: you can enable or disable tyre wear by using this toggle.
- Wear/Lap: the amount of tread used per lap. It can be an average value on 4 wheels or the lowest one, based on your personal taste.
- Strategy: aggressive strategy tends to change tyres more often, while Conservative keeps them on longer. Normal is in between.
- Lap: the calculations predicted that you’ll need to box at the end of this lap.
- Elapsed Time: the elapsed time from the beginning of the race when you stop. Useful to plan driver’s swaps during endurance races.
- n° of pits: the total amount of pits predicted to complete the race, even if the pitboard can only show the first seven pit-stops.
Last edited: