Hello,
I have prepared a fixture making sheet (automated)- you just need to enter the team details (in row 5 to 14).
Formula used:
Another section is match statistics- which is score details of each team- Team won details will come automatically.
Formula used:
Also conditionally formatted the fixture in a way that, the played matches will automatically reflect in the fixture based on the info. given in match statistics area.
Last section is Points table
Everything is automated in points table.
I have given a weightage to win and margin (goals)- you can change it based on your requirement.
Bookmarks