Explore how dice and AI transform your spreadsheet into a football league simulator.

I’ve developed an innovative football league simulator in Excel, where rolling dice generates match scores and simulates entire seasons.

3 min readMicrosoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

This is exactly the kind of project that shows why spreadsheets remain one of the most versatile tools ever created. A football league simulator built in Excel, powered by dice rolls and automated tables, is not a toy, it is a proof of concept for what happens when a user refuses to accept the limits of a blank grid.

The creator has taken a classic tabletop randomness mechanic, rolling dice to generate match scores, and married it to the logic engine of a spreadsheet. The result is a full football pyramid that updates league tables, calculates goal difference, and manages promotion and relegation across four divisions. No external software. No plugins. Just formulas, cells, and a willingness to push the tool further than most people ever try.

What matters here is not the football. What matters is the demonstration of what a spreadsheet can do when you treat it as a creative platform rather than a static ledger. This user built a system that responds to input, makes decisions, and produces a coherent narrative across an entire season. That is not a simulation of a spreadsheet. That is a spreadsheet acting like an application.

For anyone who has felt frustrated by the rigidity of traditional spreadsheets, this project offers a clear invitation. You do not need to wait for a vendor to build the features you want. You can build them yourself, one cell at a time. The dice mechanic is simple, but it reveals something deeper: the spreadsheet is not a passive container for data. It is a logic engine that can simulate, predict, and play out scenarios as long as you are willing to define the rules.

The creator asked for ideas to improve the simulator. That is the right instinct. The next step is to ask what else this approach could unlock. If dice and formulas can simulate a football league, what else can they simulate? The answer is anything you can describe in rules. And that is the real takeaway here. The tool is already in your hands. The only limit is whether you decide to explore what it can do.

From Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Ive been building a football simulator in Excel where you roll dice to generate match scores and simulate full seasons.

Ive also just finished a 4 division version with a full football pyramid

Read the original at Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community