|
|
The example below shows the Initial Wins and Losses of Teams A to L before the start of the Scenario.
Then the user inputs the 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 Win, Loss and Percentage 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 Wins | Initial Losses | Wins | Loss | Total | Position | Results | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| Team A | 3 | 4 | 2 | 0 | 55.56% | 4 | W | W | ||||||||||||
| Team B | 3 | 4 | 1 | 1 | 44.44% | 5 | W | L | ||||||||||||
| Team C | 2 | 5 | 1 | 1 | 33.33% | 9 | L | W | ||||||||||||
| Team D | 2 | 5 | 0 | 2 | 22.22% | 11 | L | L | ||||||||||||
| Team E | 4 | 3 | 2 | 0 | 66.67% | 1 | W | W | ||||||||||||
| Team F | 3 | 4 | 1 | 1 | 44.44% | 5 | W | L | ||||||||||||
| Team G | 2 | 5 | 1 | 1 | 33.33% | 9 | L | W | ||||||||||||
| Team H | 5 | 2 | 1 | 1 | 66.67% | 1 | L | W | ||||||||||||
| Team I | 4 | 3 | 2 | 0 | 66.67% | 1 | W | W | ||||||||||||
| Team J | 4 | 3 | 0 | 2 | 44.44% | 5 | L | L | ||||||||||||
| Team K | 3 | 4 | 1 | 1 | 44.44% | 5 | W | L | ||||||||||||
| Team L | 1 | 6 | 0 | 2 | 11.11% | 12 | L | L | ||||||||||||
| Result | Pts | |||||||||||||||||||
| W | 1.00 | |||||||||||||||||||
| L | 0.00 | |||||||||||||||||||
| 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.