|
|
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 for each team to simulate them playing out the Season schedule. This has been done for the next 2 Rounds in the example below.
The Points Columns have been updated as per the entries. 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 | 114.44 | W | 14.5 | 128.94 | 2 | W | 14.5 | 143.44 | 2 | |
| Team B | 98.23 | W | 14.5 | 112.73 | 4 | W | 14.5 | 127.23 | 4 | |
| Team C | 96.81 | BW | 16 | 112.81 | 3 | BW | 16 | 128.81 | 3 | |
| Team D | 85.77 | W | 14.5 | 100.27 | 6 | L | 4 | 104.27 | 7 | |
| Team E | 85.63 | W | 14.5 | 100.13 | 7 | L | 4 | 104.13 | 8 | |
| Team F | 84.69 | OW | 23 | 107.69 | 5 | L | 4 | 111.69 | 6 | |
| Team G | 75.47 | W | 14.5 | 89.97 | 8 | OW | 23 | 112.97 | 5 | |
| Team H | 73.48 | L | 4 | 77.48 | 9 | L | 4 | 81.48 | 10 | |
| Team I | 65.46 | L | 4 | 69.46 | 10 | W | 14.5 | 83.96 | 9 | |
| Team J | 55.56 | L | 4 | 59.56 | 11 | L | 4 | 63.56 | 11 | |
| Team K | 333.00 | W | 14.5 | 347.50 | 1 | L | 4 | 351.50 | 1 | |
| Team L | 27.13 | L | 4 | 31.13 | 12 | W | 14.5 | 45.63 | 12 | |
| Result | Pts | Definition | ||||||||
| L | 4.00 | Loss (opposite to Win) | ||||||||
| OL | 5.00 | Outright Loss (opposite to Outright Win) | ||||||||
| W | 14.50 | Win (opposite to Loss) | ||||||||
| BW | 16.00 | Big Win (opposite to Loss) | ||||||||
| OW | 23.00 | Outright Win (opposite to Outright Loss) | ||||||||
| 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.