Here is the new, improved and streamlined version of the endurance race calculator. Don't know if it's possible to add it in the same excel file as your strategy calculator? If it's not, maybe they can just be put in the same zip file or something, that's the easiest thing I guess.
Oh, and I upgraded the interface a little bit, now it looks more "Gran Turismo" (actually I stole the design from gran-turismo.com...)
You can download it here:
https://docs.google.com/open?id=0B_nYaY13F28NSzdBS1o5UWR4NEE (for Microsoft Excel 2007 or later).
This is what it looks like:
How it works:
The basics:
It's an excel file with macros (xlsm). I have only tested it in Excel 2007 and can not promise that it will work in any other version (although later versions should be fine I guess). The sheet is locked to prevent things from being deleted or changed by mistake, the only thing you can do is to insert or remove values from the black boxes, as well as clicking the different buttons.
If you want to have a sneek peak on how it looks under the hood you can unlock the sheet with the password provided at the bottom.
Instructions:
1. Here you fill in your lap times. It doesn't matter too much how you write it, 09:05.765 works just as great as 9:5.7 (only a tiny bit less accurate scince 100th and 1000th split seconds are missing). If some value is zero you can just put it blank (or write a 0), it doesn't matter. the blue bottom row displays the average lap time. Clicking the "add" button (+, marked in a yellow circle) will move all the data up one position (except from the first time which will be deleted) and the 10th row will be free to insert a new lap data. the add button does the same with the gap table (2). Clicking the reload button (circle with arrow, marked with red) will clear all data from the lap times.
2. Here you fill in the gap, as displayed in the game. You can work with exact values or rough estimates (if you're 1,5 laps ahead of someone at Nürburgring it might be hard to estimate the exact gap, so just put 1 lap and about half of what a general lap time is...). The plus and minus (left column) works just like in game, if you're in the lead it's -, if you're behind it's +. Clicking the reload button (red circle) will clear all data from the gap table.
3. This is the graph showing the lap times of you and your opponent. It shows lap by lap as well as the average times. Clicking the reload button (top right, green circle) will rescale the vertical axis to an appropriate value.
Horizontal axis shows lap number. Vertical axis shows lap time.
4. This is the race data table. If you're in a timed race (for instance, 4 hours of Nürburgring) you type the total time and the completed time in the appropriate boxes. If you're in a race with fixed laps (for instance, 300 km of Grand Valley) you put the total amount of laps and the completed laps in the appropriate boxes. Clicking the reload button (red circle) will clear all data.
5. This is the prognosis chart. it keeps track of the gap and draws a curve to predict the development. It also shows a line for the average gap, as well as a red dotted line for the zero value (which is where there will be a tie between you and your opponent). Clicking the reload button (green circle) will rescale the vertical and horizontal axis to appropriate values.
Horizontal axis shows lap number (will change accordingly to the number of laps that remains in your race). Vertical axis shows the gap in seconds (red "+" is bad, white "-" is good.)
The only thing to be careful about is putting values that's 0 in the gap table. In some cases the calculator thinks that 0 = no value at all, and in those cases the value will not be registered. It's not a big problem, scince the gap is rarely 0:00.000... but if you want to put a zero in the gap for whatever reason, I recommend that you put 0:00.001, because that value will be registered for sure.
