How to create an Overview of Non Working time for an entire team?

[Michelle Moulliet]

My company decided not to use Admin projects to track non working time due to
the same issues that have been documented many times in this discusssion
group.

We are using the change working time option in the client to track vacations
& holidays. Is there a way to view only the non working time for an entire
team at a glance? Ideally within a calendar view?

Thanks.

 

[Dale Howard [MVP]]

Michelle --

There is no default way to do what you wish. If we use Administrative
projects to track nonworking time such as vacations, then we can report on
such, but Project Server will not automatically reschedule project work
around nonworking time periods. If we enter nonworking time such as
vacation on each resource's calendar in the Enterprise Resource Pool, then
Project Server will automatically reschedule work around each nonworking
time period, but we cannot report on the nonworking time (at least not using
any of the default reporting tools within Project Server). Sorry.

 

[Rami]

I hope they have changed this in EPM 2007.

Michelle --

There is no default way to do what you wish. If we use Administrative
projects to track nonworking time such as vacations, then we can report on
such, but Project Server will not automatically reschedule project work
around nonworking time periods. If we enter nonworking time such as
vacation on each resource's calendar in the Enterprise Resource Pool, then
Project Server will automatically reschedule work around each nonworking
time period, but we cannot report on the nonworking time (at least not using
any of the default reporting tools within Project Server). Sorry.

 

[Andrew Lavinsky]

You may want to run the Who Does What Report, before printing, select Edit

Details, and click Calendar.

This will show all exceptions (i.e. nonstandard nonworking time) to each
individual's calendar on the report....may not be quite what you are looking
for, but a step in the right direction.

-A

 

[John Sitka]

Maybe this will work if your resource availability is never 24 hours


-Use the Analyse timescales data in Excel (or a macro) to get a grid which represents Work per day per resource
-run this to excel then transform the data so each resource has it's own column and the days start on the left axis at 0 and move up
(ex.one or two months)
-horizontal axis is the list of resources, one resource per column
-each cell represents a single day
-use "task vacations", task constraint must start on<date> scheduling ignores resource calendar, task calendar (or project calendar)
at 24, then assign the resource who is on vacation. based on a 24 hour days 5days = 120hours
-if you run your schedule with no overalocations (levelled) the work per day will show as 24 and conditional formatting in the excel
sheet could be used to show a 24 hour assignment as non working time. (or 12 hour as half day) if resource or project calendar are
somewhat less than 12.
a single column would look like this




day30 8
day29 8
day28 8
day27 8
....
day4 8
day3 24
day2 8
day1 8
0day resourceA

so day3 would be a non working day since 24 is an impossibilty given the availability profile of a resource
except when the assignment uses a vacation task which ignores the resource calendar. (Or obviously is the resource
was indeed expected to be contributing 24 hours of effort.)