Following the soccer fixtures and excel calendar 2009 I made, I got another idea about putting my favourite teams fixtures in calendar, and try to make it automatic, so I can changed the date, the team or add the new date or team easily or even combine the soccer league fixtures, the champions league fixtures and Formula 1 schedules. That is the first idea, because there are still many ideas that can be implemented in this event calendar.
I have divided this excel spreadsheet into three different layouts. And the first one is one month layout. I add the capability to change not just the month but also the year, so you can use this every year.
Less than two months we will enter the year of 2009. Usually around this time, I am looking for the new design of excel calendar, but this year is different. I plan to make my own excel calendar, so I can define anything I want in this calendar.
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.