Football (Soccer) League Simulator
This is a Football (Soccer) League Simulator that runs simulations based on your team ratings. You can score teams by rating their attack, defence, and consistency (e.g., their performance reliability). Editable cells are highlighted in yellow.
Parts of the spreadsheet are protected to prevent accidental deletion of formulas. To unprotect the sheet, go to Home > Format > Unprotect Sheet…
This simulator was created for fun and to explore Excel’s capabilities. Please note, this spreadsheet uses macros.
The latest spreadsheet can be found here on GitHub: SaharaHex/FootballLeagueSimulator
Running the Simulation
– Open the Excel file (.xlsm).
– Enable macros when prompted.
Setting Up Teams
– Go to the “Teams” tab.
– Set the number of teams, rounds, and the points system.
– Enter each team’s name and rating.
Handling Limits
– If any text fields turn red, it means the system has reached its limit.
– For example, with 40 teams and 2 rounds, the total number of games is 1560, which exceeds the spreadsheet’s capacity. Reduce the number of teams or rounds to fix this.
Normalizing Teams
– For the best simulation results, keep team ratings for attack, defence, and consistency between 70 and 100.
– The range must be narrow; if it spans too widely (from the highest to the lowest number), it will produce unusual results.
League Table Tab
– Displays the current simulation run based on your scoring.
Fixtures Tab
– Randomizes scores.
– Enter a number to reset the randomization.
– Copy columns KO and KP to columns N and O. This has to be “Paste As Value” (if zeros are displayed in all of columns N and O, it means it has not copied over correctly).
Simulation Tab
– Run the simulation here.
– Set the number of simulation runs.
– Click “Run Simulation” to get the results.
– To remove anomalies, set the field to 1 for a clearer chart.
– To run the simulation again, either increase the number of runs by adding to the current number in the field and then the “Run Simulation” button.
Or click “Reset” and then “Run Simulation”, (this will start again the simulation, and not add to the existing one).
If running the maximum of 1000 simulations, the calculation time may vary based on your computer’s performance.
SaharaHex 