Glad you like it Paul. Actually, I’ve been taking a look at it and there’s a fair few errors in the version I gave you and I also didn’t like the way some of the features worked. I’ve attached a (hopefully) less buggy version, which also has a few additions. You'll need to change the file extension again.
The 1st/2nd half races option is for championships which split the races into 2 halves and limit the number of races that drivers can score in. As I said, the initial idea behind the project was to create something to enable me to record a GPL 1969 season manually. In that year, there were 11 races, split into 2 halves. The 1st half was 6 races, but only the best 5 finishes counted. The 2nd half was 5 races long and the best 4 finishes counted. To create this in the spreadsheet, you enter 5 from 6 for the 1st half races and 4 from 5 for the 2nd half.
For most seasons you wouldn’t need any of this and would just enter the number of races in the bottom box (or the 1st Half Races ‘From’ box). And all this actually does is reduce the number of events visible on the results page, so even this isn't strictly necessary.
Joint Final Positions doesn’t really do anything, other than change the numbering down the side of the drivers standings table. If you have say, 3 drivers with the same point total, they might show as joint 2nd with JFP on, or 2nd, 3rd and 4th with it off.
Inputting a figure in the Fastest Lap points box (and now Pole Position points as well), open up a new column on the Results sheet where you indicate a fastest lap (or pole position) with an ‘x’ (actually, you can put anything in, in reality). The sheet then totals up the entries, multiplies them by the number you input and adds the result to the total points.
Points Adjustment simply opens up a new row on the Results table that allows you to adjust the points scored in an individual race by double, half or quarter. It’s for endurance races, or races shortened due to bad weather (yes, I know it’s not going to happen in a simulator, but I never claimed that everything in it was useful!). You could, for instance, replicate GTR2’s endurance races by separating the race into 3 events, awarding half points for the first 2 (the quarter and half distance points) and full points for the 3rd event (the final race finishing position).
There’s a new entry on this screen called Shared Drives. Normally, if you enter the same finishing position for 2 drivers, then they would both get the full points allocation for that position. If you select Shared Drives, then the points will be shared equally between however many drivers finished in that position. Note that if you do enter the same position for multiple drivers, the numbers will turn red. This is just to warn you that you have put the same finishing position in more than once.
I'm happy to answer any more questions if I haven’t explained things properly, or there's anything else you want to ask.
David
