Custom Points
-
I am putting together a badminton league table and I need some advice on the points system.
Currently, matches are played between 2 teams consisting of 3 pairs of players per team.
Each home pair plays each away pair on a best of 3 games basis.
Maximum games to be played are 9 (3 pairs against 3 pairs on best of 3 – 3×3=9).Now, the points on offer for the match are 3 points per match as follows:-
2 points for a win (e.g., won 5-4)
3 points for a win over 6 (e.g., won 6-3, 7-2, 8-1, 9-0)
1 point for a loss but winning 4 games (e.g., lost 5-4)So, Team A play Team B and Team A win 5-4. In this instance Team A would get 2 points and Team B would get 1 (total of 3 points)
Team C play Team D and Team C win 6-3. In this instance Team C would get 3 points and Team B would get 0 (total of 3 points).
My question is this. How would I go about automating it so that when I put in a score of say Team A 7 vs Team B 2, it would give Team A 3 points and Team B 0?
- The topic ‘Custom Points’ is closed to new replies.