Use an Excel Template to Track FIFA 2010 World Cup Schedules

FIFA World cup 2010 is going to start from June 11 and there is already some craze among the soccer fans. Here is a nice way to keep a schedule of all the matches in your hard drive.

Diego Oppenheimer, one of the employees of the Microsoft Excel product team has created an Excel template which can be used to keep track of all the upcoming world cup games, venues, league matches, match timings and also the points table.

Here is how the template looks:

Filter the matches of a particular team: The left column shows all the matches from the preliminary group stage. You can search and filter the matches of a particular team by using the search box at the top.

Let’s say you are a fan of Brazil and want to know the dates when Brazil has matches. Just enter the team name in the search box, hit Enter and the dates are highlighted as shown below:

Filter Match Dates of FIFA World cup

Maintain the points table: After a match is over, you can enter the winning team and the losing team in the pink text box and the points table will be automatically updated.

This will decide the toppers of the Group standings and you can know the schedule of matches to be played in the next round. You can know which team is going to face a particular team in the Quarter finals, semi finals etc.

Sure, you are going to have a small text leaflet containing the match schedules, but why not use the same thing in a geeky way ?

Also see some iPhone and iPad apps to watch FIFA 2010 matches.

Tip: Create Timelines in Excel

Email this article

Written by on Tuesday, May 25th, 2010

    Add Your Comment

    All Comments are Moderated.

    YOUR COMMENT

    About This Site

    Ampercent is a technology blog on computer tutorials, software guides, how to tricks and web tools. The blog is updated daily and written by two computer science students from India. Read More »

    Tip Us »

    Have a great tip which you want to share with fellow readers? Send in your ideas to tips@ampercent.com