<reserved for explanatory notes>
Notes on the sheets:
1. Tiers:
I've only included Tour Legend and Legend tiers for now. If there is a strong demand to include Tour Master, Master, etc, please let me know (and I'll consider if I can add that to the workload).
2. Criteria for Score Inclusion:
I had to set a limit somewhere, so decided to set these criteria: any score that earns credits (i.e. top 70 finish), or a score of par or better, will be included each week. In our first Tour, in practice this meant every TL score in every tourney was included, and typically 2-3 pages of the L leaderboard was included.
3. Course Conditions:
Throughout the Winter Tour conditions were consistent, with TLs having Low wind conditions for most of the tour (but with their typical Champ greens), while Legends had Moderate wind and Tourney greens. This somewhat balanced itself out, making the comparative Score relative to Par potentially our best combined standings option.
4. Updates:
I will update the Standings spreadsheet twice-weekly: 1. On Mondays with final scores from the prior week's tourney. 2. On Tuesdays/Wednesdays, once WGT have completed their score validation, and credit prize-giving.
Thus, the sheet will always be 'in progress'.
5. Workings:
If anyone wants to know how the sheet works, either let me know, or see the Winter Tour edition, where I left visible the background workings of the sheets, for transparency. Please note that I'd also welcome hearing about any errors if you come across them. I'm hoping this can be useful as a template for anyone trying to set up tour events themselves, or in their cc (and I'm available to help do that in exchange for balls, if anyone needs that service).
The Sheets themselves:
Structure:
The spreadsheet has tabs at the bottom that you use to navigate.
There are several color-coded sections:
a) TL standings:
- in cumulative Credits won;
- Points earned (using the same simple model as used in prior WGT Ryder Cup events [30 pts for a win, dropping by a point for each place below that];
- ongoing Average (with requirement of at least 4 rounds);
- cumulative amount Relative to Par;
- and an alphabetically-organized Placings sheet (so you can find yourself in the list and see where you've finished across each tourney).
Those sheets are repeated for b) Legend Tier….
Cross-Tier Comparison:
… and then c) there are a few experimental sheets attempting to get a meaningful comparison across the TL and L tiers, with combined credit standings as one version, and score relative to par as another (including versions that take each player's best 9 scores). A case could also be made for preferring the credit standings as it gives more weight to top finishers...
Obviously, no comparison system will be perfect, but I'd be interested to hear people's feedback and ideas.
Data Sheets:
After the Combined Standings sheets come the data…
d) Every week in the tour has a Leaderboard sheet, including both the TL and L information, copied from the tourney leaderboards (and will include a live link to each of those WGT webpages at the top).
Finally, e) there are some admin sheets: an intermediate place to paste data from WGT, and Player List and Courses sheets, that the standings sheets pull from.