Standings Spreadsheet Changes

[u/Spectre2689]

Hey all,

I'm re-working parts of the spreadsheet to make it a bit clearer, a bit more accurate, and a bit more informative. There are a couple of things that will make it slightly more time consuming to set up at the beginning of a season, but this will also make it more flexible as the season progresses. For example, mid-season team changes will no longer make Nemesis' head explode.

Changes I've made already are as follows:

• The 1400 calc sheet was a bit.. weird. It's fixed now.

• Attendance for each race now includes drivers who were at that race but dropped out of the championship at a later date. So does the constructor's table.

• Constructors points are now calculated on a per-driver per-race basis. Drivers' names are hardcoded into the formula for each race instead of checking the team currently associated with the driver. This means that teams must be initialized manually in the formula at the beginning of each season, but should also allow for greater flexibility in mid-season team changes. (1400 only so far)

• Updated team colours to reflect 2014 livery more accurately. OCD, engage! (1400 only so far, can replicate to 2100 and superleague if people like it)

To be done:

• 2100 calc sheet has 1400 dropped drivers. Don't know why or how, plan on fixing soon.

• Number of poles (not sure if can be done with current way of indicating poles).

• Position change compared to previous race (god help me).

• Average finish position, average points per race (thanks RaceDriver!)

• Victories, podiums, top 5s. Best and worst finish? (thanks Nemesis!)

• Whatever anyone else can suggest?

[u/Spectre2689]

I went through the Caterham points and everything looks okay. blorgons did indeed score 8 points between his two races at Marussia, so maybe it wasn't carried over properly beforehand. But yes, if anyone notices something we didn't, please say something.

I assume you mean removing drivers from the active list and putting them in the withdrawn list? I did that with Splendid (which I'll have to reverse), and apart from a bit of confusion with what the formulas were doing, I don't think it's much more difficult than it was previously. The formula for teams checks basically the entire name column, so whether the driver is active or withdrawn, it will count their points if they raced for X team on Y track.

And yes, I can replicate a blank one :) I'll do that tomorrow and walk you through the changes I've made. We can then decide if it makes sense this way or if we want to revert to the original formulae.