Tuesday, August 25, 2009

Calendar Reporting Part 5

When you push the Export Times button, you should get a window like this.

From ForBlog

You’ll note that the dates I picked begin on Monday, 5 October 2009, and end on Friday, 9 October 2009. A note on this: It remembers that last dates you used, so you have to re-set the dates to the current week every Friday. Also, make sure you pick “Recurring Events” and “non-times-tagged items”!

Once you hit export, you should get an Excel window like this. Check out the diagram tab, if you selected “Create Excel Diagram” in the Export Popup!

From ForBlog

Tuesday, August 18, 2009

Calendar Reporting Part 4

Then, I assigned each recurring appointment a category. This will change its color in Outlook. So, let’s say I have a Monday of a week that looks like this (with some content changed to protect the guilty!):

Tuesday, August 11, 2009

Calendar Reporting Part 3

Next, I defined some custom categories in Outlook. Because I sync Outlook with my Treo smartphone, this part was easy. Along with defining the categories, I assigned each custom category a color. Now my category list looks like the following.

Tuesday, August 4, 2009

Calendar Reporting Part 2

First, I grabbed a copy of Outlook Times Addin 1.1 from here: http://outlook-times-addin.wang-sweden-ab.qarchive.org/

All I had to was shut down Outlook, install the product, and then restart Outlook.

I then had a new toolbar in my calendar that looked like this: