I'm setting up a ranking and league system for our tennis club. The ranking should work according to the following rules:
1 – Players in each division will be arranged in order of the number of matches they have won in the round. Win = 3 points, Loss = 1 point, Forfeited/Defaulted player = 0 points.
2 – If 2 players finish with the same amount of wins, the higher position will go to the player who won the head to head match between those 2 players (if played).
3 – If 3 or more players have the same amount of wins, or if 2 players have tied but have not played each other, then the positions of these players will be decided by the most matches played. If this decides 1 or more of the players positions, but still leaves 2 players equal, the positions of those 2 players will go back to the head to head result.
I'm struggling with a way to automate ranking for Rule Number 2. Has anyone done something similar?
Table 1 = Players: https://airtable.com/appFy71oMkN3Qrb0G/shr95h5Ingg97O3sz
Table 2 = Matches: https://airtable.com/appFy71oMkN3Qrb0G/shr5eb6KZ4U7WMVFA
Appreciate any suggestions!!
