It has been more than 2 months since I wrote the last template. I have been stuck in my job so I couldn’t do anything to pay more attention to this site. And within that time, I got a reminder email from English Football Association Agency, where they reminded me not to distribute anything regarding their English Premier League Fixtures and all related material except I paid a license for that. That is the reason why I dropped my English Premier League Fixtures excel spreadsheet from my site.
And in my pending comments boxes, I received a lot of request about the passwords or making other excel spreadsheet for other league.
Before, I decided to make a tutorial on this, but I my time is very limited to write. So, I decided to make a general soccer league table spreadsheet, where you can modify by yourself according to your needs. And there is no password on the excel sheet and the formula, so you can learn all the logic and the formula inside. I just protected the link to my website, and I will be very happy if you don’t remove that link.
Comparing with my previous league sheets, I removed the graph and individual team fixtures due to complicated function that have to be managed to make it general. I am still try to make general and hopefully I can release it in next version.
This soccer spreadsheet consists of 5 sheets, i.e :
1. Initial Setup
2. League Table
3. Fixtures and Results
I hide ‘setting’ sheet, to avoid some misstyping while you are working with this sheet. You will easily unhide the sheet from the sheet menu.
Initial Setup Sheet.
This is basically the first sheet where you have to put a number of team to participate in the league. I limited the maximum number of team to 24 teams. If you need more than 24 teams, try to learn the logic and formula inside and you can have your own excel league table spreadsheet. In this sheet, I put 20 teams and write all 20 sample teams in the corresponding cells. You can just change the sample teams with your teams.
League Table Sheet.
The league table will change automatically based on the name and number of teams you put in the ‘initial setup’ sheet and also the results from ‘fixtures and results’ sheet.
Fixtures and Results Sheet.
You can copy or change the sample teams in this worksheet. Fill the match result in the corresponding boxes.
Perhaps this is just a redundant sheet, because it is needed when there is some team get a point deduction from their corresponding league association.
I made a little survey about some league fixtures that can be created using this templates, some of them are Portugal, Greece, Holland, Belgium, Finland, Sweden, Norway, Turkey, Switzerland League Fixtures. But probably it won’t fit Argentine or Brazil League because of different league format, I don’t know much about African or Asian league but as long as the league is in full competition format, you can use this spreadsheet.
That’s all guys. If you need some support you can leave a comments, but I apologized that probably I cannot answer it in the short time because of my time limitation.
You can download the spreadsheet here.
You can download the spreadsheet for openoffice version here.
Finally, I finished soccer league fixtures and table with automatic fixtures list generator. So, if you want to create competition matches from the scratch where you also have to design the matches schedule, you can use this spreadsheet. You can download it here.