Example What If Calculation Spreadsheet

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.

If you would like to purchase one or more of the tools, please email me at webmaster@southnetdesign.com

Back to the What If Page