Reporting resources unavailability

[Pai_da_malta]

After entering vacation calendar for all resources, I would like to be able
to print them in a consolidated report. Is it possible? How?
Thanks,


Pai_da_malta

 

[Salilu]

MSP (to my knowledge) does not provide calendar report. This is something
that I am looking forward to since long. For the calendars I have in my
project, I want a report that lists --

Weekly Work pattern for each day of the week
Block Exceptions (exceptions for a continuous period,)
Daily exceptions ( including vacation)

For example:

Calendar Name: My Projet Calendar

Weekly Pattern
Mon - Thu -- Working -- 8:00 - 12:00, 13:00- 17:00
Fri -- Working -- 8:00 - 12:00
Sat - Sun --- Non-working

Exceptions:
1. 7/1/05-7/5/05 -- 8:00 - 12:00, 13:00 - 19:00
2. 8/1/05 - 8/15/05 -- Non-working.

A report of this nature would be extremely useful, when you have many
resources in project and would like to quickly see their work
pattern/vacation without going through their calendars individually within
the application.

 

[Jan De Messemaeker]

Hi,

On my website there is a VBA program that turns calendar data into tasks.
If you know VBA you could modify it to turn absences into anything for
instance Excel rows, etc.
HTH

 

[Sarah]

Salilu,

I created a VBA macro that extracts out-of-office time to Excel and
formats it like a calendar. Every month, I emailed the next month's
report to all of my resources for them to validate their out-of-office
time as entered in MS Project. If this sounds like something you could
use, please email me separately at kikos AT nationwide DOT com. You
will have to do some modification of the code, as it was specific to my
system at the time.

Sarah K

 

[Jason]

Sarah,
Hello, my name is Jason and I am technician with Mithril Technology, an
IT consulting firm. I am interested in something that you had written in this
thread regarding calendar reporting from Microsoft Project. In the thread
you wrote: "I created a VBA macro that extracts out-of-office time to Excel
and formats it like a calendar."
My company is having trouble scheduling our resources and viewing
time-off trends, and I think from what you’ve described, that your Macro or a
variation on it would do the trick! Would it be possible to get a copy of
this code so that I could try it out for myself? Are there any prerequisites
for your code to be able to work properly? I attempted to send you an e-mail
to the address listed in your reply, but it bounced back. Any help here would
be greatly appreciated.

Sincerely,
Jason H.

 

[Jan De Messemaeker]

Hi Jason,

In cas you wouldn't foind anything, I wrote a macro that creates "nonworking
tasks" from absences; it is on my website, and although it isn't exactly
what you look for, it may help you locate the appropriate objects.
HTH

 

[Patrick]

Is there anyway to import individual's Outlook Calendar entries (vacation,
training) to Project as non-working time? Sounds like you can't directly but
how about importing from Excel to Project? I want to avoid doing it manually.

 

[JulieS]

Hello Patrick,

Sorry, no, not to the best of my knowledge. There may be a method
by developing some VBA code. If you have some skills in that area,
try posting to the project developer newsgroup and someone there may
be able to lend some guidance.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project