I’m really, really sorry about this everyone, but I’ve discovered a major bug in the sheet. I don’t know when this was introduced, but will affect more than just the last release.
The fault is that races 21 to 30 will not record the correct points for the first driver in the list, no other drivers are affected and it shouldn’t affect split seasons. I’d been messing with a new idea a while back, making changes in row 1 only as a test and then forgotten to revert the formulas back when I decided not to pursue the change.
It is simple to fix, if anyone wants to correct a sheet currently in use. Just do the following:
- Reveal the hidden Data sheet by right clicking on any sheet tab, selecting ‘Unhide…’ and then clicking ‘OK’.
- Go to the Data sheet, select cells AX7 to BG7 and then ‘copy’ (Ctrl & c, or from menu).
- Click on cell AX6 and ‘paste’ the copied data (Ctrl & v, or from the menu).
- Hide the Data sheet by right clicking on its tab and selecting ’Hide’ (this step isn’t essential, but will offend my OCD if not performed!).
If anyone doesn’t feel up to this and would like me to correct their sheet for them, please PM me.
Again, my sincerest apologies for this error and I do hope it hasn’t affected anyone’s championship.
I’ve attached copies of the 3 main sheets with the fix already applied. As usual, change the extension back to .xlsm or .ods as appropriate.
Jon, I actually spotted this error whilst looking at a possible solution for your problem. It occurred to me that, in part, the sheet already deals with 60 races, as the first and second halves both have 30 possible rounds. It’s just that, at present, they can’t overlap and the total cannot exceed 30. I thought that I could add a second Results sheet and, with a few additions in the Data sheet, have it able to deal with 60 in total. After initial work, I still think this is feasible and less work than simply adding the capacity for a further 30 races. Of course, it’s still only 60 in total, whereas you’re looking for 66, so I’ll still need to add some extra race slots to make it work properly for you.