- 11,169
- Sweden
- eran0004
What is the Endurance Race Calculator?
I saw the following question in another thread here at GTPlanet:
This made me think of the possibility to create an endurance race calculator. Using different variables, such as track length, gap to leader, gain/loss per lap and even pit strategy and tyre compound this calculator would give you the answer of how much you need to improve your time in order to win, and even tell you what the best pit stop strategy would be, based on track length and tyre compound.
So, using Microsoft Excel I've been creating this calculator and it's just about ready for some testing. The download link will be provided below.
Thanks to the excellent data collected and published by chuyler1 here, I have been able to create a basic model of the differences in tyre compound. The data was collected using a Nissan Calsonic IMPUL GT-R (Super GT) '08 on Nürburgring GP/F, so it's not 100% valid for other track/car combinations, but it should be fairly representative.
The calculator requires Microsoft Excel. I'm using Excel 2007, but it should work on other versions as well. I hope.
Download link
Here is the link to the Caculator on Google Docs (it doesn't work on Google Docs so you need to download it and run it in Microsoft Excel)
Here is the direct download link from Google Docs.
What it doesn't do (yet?)
The calculator does not work with rain yet. Partly because I don't have any rain data and partly because even if I had rain data it would be extremely complicated given all the variations of tyres and wet % of the track. However, if someone would like to collect a bunch of rain data it might be added in the future, although I suspect it would take about a week to implement those changes.
Fuel consumption is another thing that the calculator doesn't do. With +1000 cars and different fuel consumption rates I don't ever see a fuel consumption function being possible. There is a "fuel factor" though, compensating for the fact that while you pit stop for tyre change you can also take a small amount of fuel without adding extra time, which in turn saves you some time later on.
Screenshots
I saw the following question in another thread here at GTPlanet:
I'm currently 20 hours into the 24h Nürburgring A-spec endurance race. The problem is that I'm between 5 and 6 minutes behind the leader (due to poor driving and pit strategy while raining overnight). It is currently dry and I'm gaining between 5 and 10 seconds a lap (if I don't make mistakes). At this rate, I think 4 hours isn't enough time left to catch the leader.
So, is there any conceivable way that I can still win this race? (I really don't feel like doing another 24 hours.)
This made me think of the possibility to create an endurance race calculator. Using different variables, such as track length, gap to leader, gain/loss per lap and even pit strategy and tyre compound this calculator would give you the answer of how much you need to improve your time in order to win, and even tell you what the best pit stop strategy would be, based on track length and tyre compound.
So, using Microsoft Excel I've been creating this calculator and it's just about ready for some testing. The download link will be provided below.
Thanks to the excellent data collected and published by chuyler1 here, I have been able to create a basic model of the differences in tyre compound. The data was collected using a Nissan Calsonic IMPUL GT-R (Super GT) '08 on Nürburgring GP/F, so it's not 100% valid for other track/car combinations, but it should be fairly representative.
The calculator requires Microsoft Excel. I'm using Excel 2007, but it should work on other versions as well. I hope.
Download link
Here is the link to the Caculator on Google Docs (it doesn't work on Google Docs so you need to download it and run it in Microsoft Excel)
Here is the direct download link from Google Docs.
What it doesn't do (yet?)
The calculator does not work with rain yet. Partly because I don't have any rain data and partly because even if I had rain data it would be extremely complicated given all the variations of tyres and wet % of the track. However, if someone would like to collect a bunch of rain data it might be added in the future, although I suspect it would take about a week to implement those changes.
Fuel consumption is another thing that the calculator doesn't do. With +1000 cars and different fuel consumption rates I don't ever see a fuel consumption function being possible. There is a "fuel factor" though, compensating for the fact that while you pit stop for tyre change you can also take a small amount of fuel without adding extra time, which in turn saves you some time later on.
Screenshots
