ACC Endurance Planner 1.4

Version 1.4 can be found on the link below, simply go to File>Make a Copy and save anywhere on your drive:

ACC Endurance Planner 1.4

docs.google.com

• The main change visually are the cells, it is the inverse of the previous versions. Now, you enter data in the white cells.
• Time Left column and Stint column are pre-filled with the maximum amount of laps possible in a stint, according to the lap time and fuel consumption for each driver.
• Stint column now updates in orange the necessary time for the last stint + 2 laps.
• Added Set column, to enter the tyre set used for each stint for reference.
• Fuel column now shows required fuel for number of laps in the stint.
  • It will highlight in orange if the fuel needed is near the max possible for the car (J1), and in red if it is more than the max.

Version 1.3:

ACC Endurance Planner 1.3

docs.google.com

• Replaced the Strategy column with the Damage column: enter here the amount of time spent repairing damage during the pitstop before the start of the stint
• The Weather column is now named Temp
• Added one more Time Zone slot
• Added calculation result for pressures for next stint of a New Driver, automatically calculated in X8-AA8
• Fixed race table to properly display the race length in terms of Hours, Minutes and Seconds in B4-D4 (was showing only the equivalent hours, and was showing 0 in a 24h race)

Thank you @Trifo for the feedback! Enjoy

• Time left and Stint are now both highlighted in orange if the Time Left is lower than max stint + 1.5 (orange stint is the last stint of the race)
• Updated the Clock column (I12) to pick from your own selection of Time Zones (S1, T1 and U1)
• Replaced Errors with 0 (zero) for stints where the Driver is "blank"
• Included examples of strategy names for the drivers, change these to whatever weather conditions you test together
• Updated some comments for more simplicity
• Added a Pressure Delta calculator which also updates the NEW tyre pressures for the following stint
• Added new tab with Notes - this will be continuously improved even if there is no new update

Changed Stint and Time Left formulas so that they are no longer circular, as this was causing issues.

• By default, Stint is now = max stint - 0.5
  you can manually change these values, both before and during the race.
• Time Left works the same way as before
  It will now be highlighted in orange if it is lower than max stint + 1.5

Also implemented minor layout changes. Thanks to @Matteo68 for the continuous feedback! Other updates will come in the future