How to use this spreadsheet:
There are seven user pages to the spreadsheet:
This shows you a quick overview of the composition of the eight groups and the teams' April 2010 rankings.
Rate your favourite teams with 1 - 5 stars and then the GoupStage page will show you which games you most want to see.
Select your time zone from the pull-down list —the zones shown are already adjusted for daylight saving times for the tournament period. A message at the top of the page informs you where today falls in the competition calendar.
Compare the outlook for any two groups and team profiles side-by-side or click the link images on top to get the latest from the web.
Enter scores here. Group matches here are sorted by date, showing the group and stadium location. The interest rating is based on how closely paired and highly ranked the teams are, and whether any are your favourites.
Print this page for a nice one page schedule of the Group Stage matches.
One of the best features
is that each game has cleverly designed comments that change depending
on the outcome of the game
—including whether a team has qualified early or been eliminated.
(You can overwrite the match schedules or the Ultimate Couch Potato comments by entering your local TV coverage schedule or your own comments.)
Check out the scores sorted by groups, as well as the league system scoring table and the results according to three different models (see Models). If lots are drawn to settle tie breaks enter a 1 or a 2 in the cell (just follow the instructions).
This page is really useful to see if there is any chance of your team making it to the next round, and what the ranking in the groups is.
Score the elimination rounds. There is an extra set of boxes for every game if you need to enter overtime goals (or penalty shootouts). You can enter TV schedules to the right of the cells marked 'TV: '. The ball will settle down as we near the end, squat, and finally ... lay a golden egg — definitely worth waiting for if you ain't got a life.
Get a bird's-eye view of the competition, the thinning ranks of teams as the survivors fight on, plus awards or raspberries for performance in the group stages. You'll see the ranking after each set of matches in the group stage round. Will the top 4 teams be the ones to make it to the semi-final games?
If something doesn't work the way you expected, chances are you'll get a clue there. Or not.