The purpose of a League Schedule Maker is to create a fantasy football league between the input teams and rank the teams according to the scores and rules that you determine. You may also input the venues and edit the rules you may adjust such as ;
Points for win
Points for Lose
The amount of matches teams will play each other.
Points for Draw
Determine the rules to determine the champion.
The template will let you display and analyze the results of the scores of the teams and rank the teams automatically.
League Schedule Maker Features:
The League Schedule Maker lets you input the name of the teams and optionally the venues of the matches.
A settings part has been formed to be able to adjust your fantasy league settings. You may easily adjust the priority of each rule to rank the teams from the Tie Breaker section.
The ranking will be set according to priority.
After inputting teams and venues in the settings section, the team fixture will be formed. Once the Fixture has been formed all you have to do is input the scores of the teams.
If there is an issue with the old scores the column will point you the row which causing the problem with related colors. For example, if the problem caused by undeleted scores, the arrow will be PINK and if there are unentered scores the arrows will be ORANGE.
If there is an indication for “There are matches without scores” this means you have not completed league’s all scores. “Delete matchless scores” indicates that there are scores in unrelated cells on the scoreboard.
The scores you will input in Fixtures section will affect the Standings section so that it could rank the teams according to their scores automatically.
Once you enter the scores display your results in the standings section. You do not need to input any information on the standings section. The formulas will calculate your scores automatically and change the ranks each time you input another score.
If the points of two or more teams are equal, the template will list the ranking according to the tie breaker options you set.
Go ahead and create your league schedule!
League Schedule Maker Features Summary:
Track scores and standings in Excel
Full Print Ready Schedules for use offline
Informational notes included
No installation needed. Ready to use.
Works both on Mac and Windows
Compatible with Excel 2010 and later versions
Does not include any VBA macros