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.
The guidance for using this spreadsheet are as follows :
1. This is the one month event calendar where you can only see the event only for the month and the year that you fill on the corresponding cells.
2. Enter the date and the corresponding event in the blue cells at the left side. You can fill one by one or just copy the date and event from other sources. You don’t have to fill it in order, as you see in the sample data in the spreadsheets, I put the fixtures of AC Milan from Italian Serie A fixtures and followed by the fixtures from Barcelona. You can put the champions league event or Formula 1 or MotoGP or your lover birthday after that. The formula inside the calendar cell will find the corresponding event automatically.
3. I limit that only 3 (three) events can be shown in the corresponding date, so if there is more than 3 events at the same date, only the top three events in the event columns will be shown.
4. You can change the lay out, the colour or change the cell format, but please be careful with the formula, especially the formula that return error result, since I have to cover it using white colour. I protect this sheet without password, so you can just unprotect this sheet from the excel menu.
5. Finally, if you make some changes in this excel spreadsheet or rename to other name, I would be pleased if you keep my link available in the spreadsheet.
You can download this spreadsheet here.
If you are using Openoffice, you can download openoffice version here