Excel LADZ - Fixture & League Table Generator (Patreon)

G'day lads, I've created a 'Fixture & League Table Generator' on Excel where you can input a number of teams as well as the amount of games they play against each other. The file will then produce a competition fixture list, as well as a compiled table of the results (after you've entered the scores for matches). All you will have to input are the clubs in your competition, and their home ground 🔥

The Legacy version (without dynamic array formulas) is now UP! 💪 

Note, for competitions with an odd number of teams, there must be at least one BYE every round. To account for this, when you enter the number of teams in your competition within the 'Fixtures', e.g. 11 teams, the model will produce 12 teams. For the 12th club, you must write "BYE" like below.

Obviously, the scores for each match can be inserted within columns D and F for the Home and Away Teams respectively. Enjoy!