Creating Calendar Reports

L

Leo

We are currently using a Microsoft Excel spreadsheet to track our project
team's out of office schedule. Organizationally, managers keep track of
their employee's out of office schedule by having the employees create an
"all day" meeting request for the days out and invited their manager as well
as a "Time Out" calendar to the meeting.

We'd like to use Outlook 2003 to merge these two functions into one:
requesting/accepting O-O-O in Outlook while being able to report off the data
in outlook.

The format of the report would be something like this:

Employee|Role|1/1|1/2|1/3
Development
John|Developer|X|X|O
Jen|Developer|X|X|X
Business
Tim|Analyst|O|O|O
Tam|Analyst|O|X|O
Infrastructure
Biff|Analyst|O|O|O
Betty|Analyst|O|X|O

I'm using Xs and Os to indicate In the office and Out in this case, but in
reality it would use whatever format outlook shows (purple box, etc).

The function of this report would be for an overall project manager to get
an idea at functional coverage on a given day/week.

Is there an easy way to get outlook to duplicate this sort of view?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top