MICROSOFT EXCEL VERSIONDescription
FOOTBALL LEAGUE FIXTURES GENERATOR | SCORESHEET is an Excel spreadsheet to help you creating a football league with automated fixtures. With this tool, you don’t need to set schedule and pair your team. They will be paired and scheduled automatically based on your league parameter.
It can automate scheduling for up to 40 teams
Here short instruction on how to use it :
1. Set League Parameter
Set all of your football league parameter here. What you need to set are :
- Number of team
- Team name and their home venue name
- Starting competition date
- Competition model
- Scheduling period
2. Managing fixtures
All fixtures will be set automatically, including its date. You can change particular date by replacing the formula in particular date field with your date. Remember, it will break formula in that cell. You need to keep one copy of this tool for future uses.
You can manage this worksheet to show particular information from Filter menu from Excel. Also, once the competition is started, fill actual scores in score column.
3. See Individual Team Schedule and Results
There is one worksheet where you can see particular team schedule and results.
4. See Standings
There are formulas inside these spreadsheets that will adjust team standings automatically based on respective tie-breaker policy
