Here's the 2009-10 version of my Wisconsin football and men's basketball Outlook calendar-importable Excel file. It provides all games, including time and television coverage when available. It also includes the major football bowls, the men's basketball Big Ten Tournament and NCAA Tournament, and the men's hockey Camp Randall Classic and Frozen Four.
Home games are titled in all caps. Games for which the time has not yet been set display as all-day events.
To download the file, click the following link...
http://newmusicandmore.tripod.com/wisconsinsportscalendars.html
To import it into your Outlook calendar, follow these steps (may vary by software version)...
1. Click File > Import and Export...
2. Select Import from another program or file
3. Select Microsoft Excel
4. Click Browse... and locate the downloaded file on your computer
5. Select the calendar to which you'd like to import the file
All times are US Central Time. If you live in another time zone, simply change your computer to US Central Time, import the file, and change back to your local time. This will switch the start times of the events to the correct local time.
By default, all events are categorized as Out of Office. If you'd like to change their categories, simply open the file in Excel and change the number in the last column (Showtimeas) for each event.
I will not be providing updates when future game times and television coverage have been set, so please don't ask! (To avoid duplicate events, it's a lot more convenient to simply update the event that has already been imported into your calendar than to import all games again.)
Feel free to e-mail me with any questions...
Enjoy!
--DanG
