Trumblog

After missing the first 2 New England Patriots games this season, the first because I was working in New York and couldn’t get the game on the office TV and the second because of having family in town, I realized that I’m not making time for football.  Why was this? Because it was not a part of my weekend schedule.  Football games weren’t in my Outlook schedule, which means that there waren’t on my Blackberry and therefore I wasn’t making time for them.

To remedy that I looked around for a schedule suitable for importing into Outlook like the Red Sox provide.  The Pats aren’t so accommodating.  Their schedule is downloadable as an excel file and PDF, but not for easy importing into MicroSoft Outlook.  I could buy the schedule for importing, but couldn’t bring myself to pay for 16 appointments, no matter how important.

So I made my own Patriots Schedule and am making it available to you for download.  The schedule includes the entire pre-season and regular season, but not the post season (one game at a time guys), shows game locations, TV schedule and an alarm 15 minutes before kickoff.  Remember that the NFL has “flexible scheduling” on Sundays in Weeks 11-17 meaning that game times can be moved, which could impact this schedule. So keep an eye out for that and don’t get caught missing a game.

Here’s what you do if you want to add the Pats schedule to your own Outlook Calendar.

1. Download the New England Patriots 2008 Schedule CSV.
2. Open Outlook and from the top toolbar, click File -> Import and Export
3. Select “Import from another program or file” and click Next
4. Select “Comma Separated Values (Windows)” and click Next
5. Click the Browse button and navigate to where you saved the schedule that you downloaded
6. Select “Do not import duplicate items” and click Next
7. From the “Select destination folder” pop-up, click on Calendar and click Next
8. In the next window, under the box labeled, “The following actions will be performed:”, click the box next to the option labeled, “Import “Patriots_Schedule_2008.csv” into folder: Calendar.”
9. It shouldn’t be necessary, but if you want to, in the Map Custom Fields pop-up window, click and drag the fields from the left window into the right window, as follows:
   * START_DATE to Start Date
   * START_TIME to Start Time (select START_TIME for local time zone, or START_TIME_ET for all ET)
   * SUBJECT to Subject
   * DESCRIPTION to Description
   * LOCATION to Location
   * END_DATE to End Date
   * END_TIME to End Time (select END_TIME for local time zone, or END_TIME_ET for all ET)
   * REMINDER_ON_OFF to Reminder On/Off
   * REMINDER_DATE to Reminder Date
   * REMINDER_TIME to End Time (select REMINDER_TIME for local time zone, or REMINDER_TIME_ET for all ET)
   * SHOWTIMEAS_FREE to Show time as (I like to leave the time free so that I can schedule going out with friends, but you
10. Click OK, then click Finish
11. A status window will appear that says, “Importing Appointments from ‘redsox2008.csv’ into Calendar”
12. Never miss another Pats game

Matt Cassel we’re counting on you.  Go Pats!

(No Ratings Yet)

 Loading ...