dkflameboy
New Member
- Joined
- Nov 28, 2016
- Messages
- 22
- Office Version
- 365
Hi All, I've plagiarised a basic league table template and I've edited it to work almost how I want it to. This will be for a Pool league and I need to add an additional couple of variables for points scoring.
In the league everyone plays best of 5 frames, nobody will ever draw a match, they either win or lose, with 3 points being awarded to the winner, but the following will apply:
There is a fixtures and result worksheet which feeds in to a settings worksheet where all the data is compiled.
What is the best way to calculate these permutations?
In the league everyone plays best of 5 frames, nobody will ever draw a match, they either win or lose, with 3 points being awarded to the winner, but the following will apply:
Where a player wins 3-0 they will be awarded an additional point
Where a losing player wins either 1 frame or 2 frames they will be awarded a point
There is a fixtures and result worksheet which feeds in to a settings worksheet where all the data is compiled.
What is the best way to calculate these permutations?