|
|
The example below shows the Initial Points of Teams A to L before the start of the Scenario.
Then the user inputs the Wins (W) and Losses (L) 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 Wins and Losses (and Draws included also) Columns have been updated as per the entries, and the Points have been changed to reflect this. 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 | Wins | Losses | Draws | Points | Position | Results | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| Team A | 3 | 2 | 0 | 0 | 11 | 2 | W | W | ||||||||||||
| Team B | 3 | 1 | 1 | 0 | 7 | 6 | L | W | ||||||||||||
| Team C | 2 | 1 | 1 | 0 | 6 | 8 | W | L | ||||||||||||
| Team D | 2 | 0 | 2 | 0 | 2 | 12 | L | L | ||||||||||||
| Team E | 4 | 2 | 0 | 0 | 12 | 1 | W | W | ||||||||||||
| Team F | 3 | 1 | 1 | 0 | 7 | 6 | L | W | ||||||||||||
| Team G | 2 | 1 | 1 | 0 | 6 | 8 | W | L | ||||||||||||
| Team H | 5 | 1 | 1 | 0 | 9 | 3 | W | L | ||||||||||||
| Team I | 4 | 1 | 1 | 0 | 8 | 5 | L | W | ||||||||||||
| Team J | 4 | 0 | 2 | 0 | 4 | 10 | L | L | ||||||||||||
| Team K | 3 | 1 | 0 | 1 | 9 | 3 | D | W | ||||||||||||
| Team L | 1 | 0 | 1 | 1 | 3 | 11 | D | L | ||||||||||||
| Result | Pts | |||||||||||||||||||
| W | 4.00 | Win | ||||||||||||||||||
| L | 0.00 | Loss | ||||||||||||||||||
| D | 2.00 | Draw | ||||||||||||||||||
| 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.