Holiday is about to over. In some countries, the new academic year is starting from July and at some other is starting from August. There are some requests came in about modifying my yearly calendar into a specific calendar template that started from July or August and ended in the some month in the following year. I made a simple one to fulfill that request where this template can only be used for year 2009/2010 with a feature to mark the date with corresponding academic exams, events or holiday.
It’s been a year since I wrote the template for Italian Serie A Competition. And now, the Italian Serie A fixtures is already released by FIGC, so I can make the complete fixtures for season 2009/2010 in Excel template after three weeks publishing the blank template. I make a few changes on layout but I haven’t made any correction regarding head-to-head standing in this version. Probably in the next version I will add this function, so season 2008/2009 problem regarding AC Milan vs Juventus and Fiorentina Vs Genoa position in the template won’t be happen again.
By the way, I still miss Kaka in serie A, and I hope AC Milan can do their best without Kaka in this season.
As I mention before, there is a slight layout changes I made to make it more adaptable for fixtures data entried by yourself. The first changes I made is to combine the team setup together with the deduction sheet in my previous template before, as you can see in the picture. I have put all 20 teams and their home stadium. You can put any deduction if any before or within the season.
The second worksheet, the league table, is remain the same, except I changes the month hyperlink with week hyperlink, so, it will link to the corresponding week once you fill the fixtures.
There are some comments and requests through email asking about the possibility of having automatic fixtures list in my football standing league creator table. So, if they finished filling the name of the teams, fixtures list will be automatically created, so they don’t have to manually typing the team’s name and thinking about team’s matches schedules.
In the beginning, I created that spreadsheet to automate the standing table based on ready made matches or fixtures. But the people who using this template is correct about asking possibility of creating totally new competition and matches where they have to design all from the scratch.
Understanding that concerns, I tried to figure out about automate this fixtures list. And I found out that creating fixtures list is not an easy task. Especially if it is involved many teams, or when the number of teams are odd where impossible to have all matches at the same time.
It took several nights just to find the logic to create this fixtures list manually, and it took additional nights to find the right formula and function in excel to map the logic without using excel macros. Fortunately Manchester United vs Arsenal and Barcelona vs Chelsea Champion League matches accompany me to stay awake with matches results I expected :-).
This spreadsheet can be used to create matches schedules for other sport events that have competition style, like volley ball, futsal, badminton, basketball or others.
This spreadsheet can create fixtures lists for maximum 40 teams. The reason I limit the teams until 40 teams because of the size of excel file. I don’t feel comfortable creating the template with filesize more than 1.5 Mb, but this is a consequence if you create excel template with many “if condition” without macros. If you want to create the fixtures lists with the number of teams more than 40, you can continue the formula I created inside the spreadsheet.
This spreadsheet only consists of three worksheet, one is setup worksheet where you have to set the number of your teams, the competition type and your team’s name. There is two choices of competition type, full competition where each team will meet twice, or half competition where each team only meet once.