I think I need to get into a bit more detail here, so I'm going to share an event we recently played in our CC, and the Excel Online Worksheet with the results. Here is the leaderboard from the gross event (this event maintains gross and net leaderboards):
(click the image to see the entire Excel Online spreadsheet)
A word of warning ... the spreadsheet contains active hyperlinks. Anything that is blue and underlined is a hyperlink. If you click on a hyperlink, it will open the webpage associated with the linked text. These are either the player's profile page or the WGT CC Tournament page.
Some of the hyperlinks contain "Screen Tips" (or Titles). If you hover your mouse over the hyperlinks, you can see the screen tips. These are usually under the Score History - Rounds at the top of the worksheet.
Also, be sure to check the tabs at the bottom of the screen. There are 7 tabs in the spreadsheet. (Tournament Info, Leaderboard - Gross, Score History - Gross, Tourney History - Gross, Leaderboard - Net, Score History - Net and Tourney History - Net).
This is the first event of a three or six month event (to be determined by the tournament director).
The leaderboard is a points system that is put together after all four rounds have been played and posted to the Score History and Tourney History worksheets. I put several explanations inside the Excel sheet.
This one gave the same points if there was a tie. Also, participation points were given along with the points received for 1st through 10th place. In this example, 2 participation points were given for each round played. Only the top 10 players in this event received points (from 80 to 8).
The system maintains 3 worksheets for each tournament event. In the worksheet there are two events ... one is gross scores and the other is net scores.
Now, back to my issue. The only time I can actually award points based on the position shown by the WGT leaderboard is if the event is played Gross and just a single-round event.
In this example, if you check out the score history worksheets, you will see that there are players that did not participate in each round. While I can scan through the Tourney History for players that played all four events, the time required to check each member would prove to be extremely time consuming; especially for large CC's.
For net events, there is seldom ties; however it does happen. In this case, I think the best approach is to give the user the option to either award the total points for the player's position or choose a "dead-heat" option of adding together the points and awarding accordingly.
Also, for multiple-round events that are played gross, they can have just these two options (position or dead-heat).
The only issue with multiple-round events like this example, if there is a tie between two players for 1st place, I think that I will need to have the user decide who came in 1st place. After that, the other players will receive the points based on the user's choice (position or dead-heat).
For single tourney events that span over a period of time, I think having the 3rd option of awarding points based on WGT position is possible ... since it's a single round, the time necessary to process the scores won't be that difficult.
Please check out the example and give me your comments for the best method to award points.
Thanks,
Kat ♥