The example below shows the Initial Points of Teams A to L before the start of the Scenario.
Then the user inputs the type of Win or Loss based on the extent of the win for each team to simulate them playing out the Tournament or Season schedule. This has been done for the next 2 Rounds in the example below.
The Points have been changed to reflect the type of wins and losses. The position column indicates what position each team is now in, and the Top 4 teams are highlighted as in this example the No. of Teams that will contest finals is 4. This is an enterable parameter that can be changed to reflect your league.
Teams | Initial Pts | Game 1 | Points | Total | Position | Game 2 | Points | Total | Position |
Team A | 7 | CW | 5 | 12 | 2 | CW | 5 | 17 | 2 |
Team B | 6 | CW | 5 | 11 | 4 | W | 6 | 17 | 2 |
Team C | 6 | BW | 7 | 13 | 1 | BW | 7 | 20 | 1 |
Team D | 5 | BW | 7 | 12 | 2 | L | 1 | 13 | 4 |
Team E | 2 | W | 6 | 8 | 5 | L | 1 | 9 | 7 |
Team F | 1 | W | 6 | 7 | 6 | W | 6 | 13 | 4 |
Team G | 1 | W | 6 | 7 | 6 | W | 6 | 13 | 4 |
Team H | 0 | L | 1 | 1 | 8 | CL | 2 | 3 | 8 |
Team I | 0 | L | 0 | 0 | 9 | CL | 2 | 2 | 9 |
Result | Pts | Definition | |||||||
L | 1.00 | Loss | |||||||
BL | 0.00 | Big Loss | |||||||
W | 6.00 | Win | |||||||
BW | 7.00 | Big Win | |||||||
CL | 2.00 | CloseLoss | |||||||
CW | 5.00 | Close Win | |||||||
No of Finals Teams | 4 | ||||||||
Once you've completed one scenario, you may want to try it again, but keep the information you
just put in to compare later. There is an additional spreadsheet within the tool where you can
save your scenarios, so you can then compare various "what ifs" and base your decision making on that.