Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Ranking for Round Robin Box League (Tennis)

Topic Labels: Automations Data Formulas
514 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Joel1
5 - Automation Enthusiast
5 - Automation Enthusiast

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!!


1 Reply 1

Hmm, I tried to make something here but don't have time to test it much.  If you try it out with some test data and hit a snag let me know and I'll see what I can do

Screenshot 2024-08-18 at 2.28.07 PM.png

Screenshot 2024-08-18 at 2.28.01 PM.png

Screenshot 2024-08-18 at 2.30.37 PM.png