This section allows you to check all the results, rankings, and planned matches. Indeed, a maximum of 2 teams can pass from each group.Īfter you fill all of the tables, now the template is ready for you to click the “Prepare Fixture” button and go to the next sections. The last table of this tournament fixture generator in Excel is for setting the number of teams qualified for the playoffs.( GA – goals lost, goals against, GD – goals difference, GF – goals for, totally scored goals, Points – from, win-lose, draw, GR – goal ratio (GF divided by GA), WR – win rate ) The second table asks you set the rule and priorities of the tie breaker.In the first table, you can determine the points system for home and away points (win, draw or lose) and select the number of matches played by each other in the group.There are 3 separate tables you need to set the rules: settings, tiebreaker, and group settings. If you would like to create a tournament from scratch, you can click the “ Clear All” button to delete all the previously specified settings. Please make sure all your settings are set before you go to the other sections. In the Settings section of Excel Tournament Fixture Generator, you should check closely the parameters you define and fill in all the teams’ and groups’ details. Besides that, there is an additional column if you would like to enter the venue name. Please click on each tab to update team name information. The table allows you to specify group and team names. You can define up to 8 groups and each of them can contain up to 10 teams. The template has 5 main parts Settings, Group Standings, All teams Standings, Fixture, and Playoffs.įirst of all, before you go into the fixture, standing, and playoffs, you should define the rules of the tournament from the settings section. All in Excel! Excel Tournament Fixture Generator Features: Additionally, you can create a total structure of a tournament, change the rules of punctuation, and set the tiebreaks.

That’s to say, you can schedule all the matches according to your selections.

This Tournament Fixture Generator in Excel allows you to create a dummy tournament.

Schedule sports creator excel