The sheet to keep track of the Hive Poker Series are now complete.. I think.
Feel free to drop any suggestions to improvements you have.
For testing purposes, I have added test names
Structure of the sheet
And a bit of explanation
Point structure
This remains the same as previous:
This can of course be extended to accommodate a larger audience. Finger crossed for that to happen!
The entrants are determinded by number of names in the Participants list.
List of Participants
This one is the least advanced part, and it doesn't really appear that nice either, but it does what I want it to.
I'd call this a fairly simple list. It does have a little check in place - hence the "duplicates" column.
You might also ask "what's with the highlighted cells?". I'll get back to that in a minute, but first, let's explore the duplicates function.
If I accidentally add a player twice to the list or I put in two identical finishes, it will warn me:
When there is an error, the points will not be calculated or distributed in the results of the round.
This rounds results
Here it is. The points distributed for the round.
Obviously there is an error somewhere. We saw that when we set it previosly, so let's remove it and see the new result.
Fixed!
Now, let us have a look at the actual results
So much better!
Now we can also get back to why those highlighted cells are in the participants list.
The Leaderboard
If a name from the Participants list are missing on the leaderboard, it will highlight the participant, to alert me, that this user has to be added to the leaderboard.
Quite clever if you ask me! 😃
In the next example, we are assuming, there has already been played one tourney and the above are the results of the 2nd tourney.
YES!
You may notice the three (3) highlighted from before are missing.
In the leaderboard, there is also some highlighted names. Those are simply being shown to illustrate that they are not participating in this round.
The column to the right has total point-tally before this round. That is "manually" entered by me. By manually, I mean I will copy the values from Total score before I reset for the next round.
Total sheet
I feel it will be irrelevant to show that the highlighted names in the Participants list is no longer highlighted when added to the leaderboard.
However, what is not irrelevant is the total sheet (and of course you can also see I added the bottom line in the leaderboard).
Here it is. Lo and behold. The holy grail.
As mentioned in the beginning, if you have any idea, suggestions, improvement or anything else you want me to add, please let me know.
Last for me to say now is;
see you next time for the reveal of prizemoney 😎
--
Take care friends.
--
The Dealer