Excel LADZ
patreon
Excel LADZ - Fixture & League Table Generator
🕑 Added 2023-09-19 22:45:27 +0000 UTCG'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!
Comments
Danial Hogg
Also, the 5 teams function is not working. Can we get a fix on this?
Danial Hogg
Hey, is there a way to remove the home ground option as the games are played at neutral or different venues?
David Recio
How do I increase the team list to 40 teams
Excel LADZ
Hi lad, you raise a great point (which is correct) 🔥 I'll look into it over the next couple of weeks and see if I can make the home/away sorting formula more efficient. I'll let you know if I make any changes 👍
BayW1deDraws
I created my first draw 10 teams I round = 2 teams with 6 home & 3 Away .. Should have been a 5 / 4 split for home & away id think ??? Thanks in advance for the reply and cheers Mike steel
