Once you enter the scores display your results in the standings section. The scores you will input in the Fixtures section will affect the Standings section so that it could rank the teams according to their scores automatically. Now you can continute with Standings section of your Excel League Schedule Maker. Lastly, the “Delete matchless scores” warning indicates that there are scores in unrelated cells on the scoreboard. For example, if the problem is caused by undeleted scores, the arrow will be PINK and if there are unentered scores the arrows will be ORANGE.Īlos, if there is an indication for “There are matches without scores” this means you have not completed the league’s all scores. Moreover, if there is an issue with the old scores the column will point you to the row which causes the problem with related colors. So, once the Fixture has been formed all you have to do is input the scores of the teams. FIXTURES:Īfter inputting teams and venues in the settings section of this Excel League Schedule Maker, the team fixture will be formed. Thus, the template will set the ranking according to the priority. So, you may easily adjust the priority of each rule to rank the teams from the Tie Breaker section. SETTINGS:įirstly, a settings part has been formed to be able to adjust your fantasy league settings. Excel League Schedule Maker Features:īasically, this tool lets you input the name of the teams and optionally the venues of the matches. The template will let you display and analyze the results of the scores of the teams and rank the teams automatically.

Determine the rules to determine the champion.The amount of matches teams will play each other.Additionally, you may input the venues and edit the rules you may adjust such as This Excel League Schedule Maker will help you to create a fantasy football league between the input teams and rank them according to the scores.

Excel microsoft free template schedule