Managing Resource Individual Calendars

JvdP · #1 07-21-2015, 05:22 AM

Planning tasks over holidays is difficult, even more so when there's no strict holiday period. For example, "Anna" takes holiday in week 1 and Bob takes holiday week 2 but a task is dependent on both of them being in the office.

Where I work, we have Excel sheet people fill in to know when they take their holidays. I want to use this data in MS Project.

I know that this is possible through setting resource individual working times by going to the resources sheet, then on a specific resource going to Information > Change Working time. However, this is rather time consuming.

Is it possible to "import" a list of holidays into the project and show this in the resources sheet?

Here's a practical example. Currently the resources sheet looks like this:

Code:

Resource name | Base Calendar
------------------------------------
Anna          | Standard
Bob           | Standard

But I want it to look like this:

Code:

Resource name | Base Calendar | Week1   | Week2   | Weekn
--------------------------------------------------------------------------------------
Anna          | Standard      | Holiday |         | ...
Bob           | Standard      |         | Holiday | ...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Resource Usage View - Is it possible to display resource names	Andrea Schanz	Project	6	09-22-2014 07:47 AM
Resource assignment with resource calendars	joday48	Project	6	08-19-2014 05:49 AM
Over-allocated resource - resource holiday	scott.hannaford	Project	1	10-21-2013 05:32 AM
VBA Code to Print Individual Resource Lists to a pdf File	OTPM	Project	0	05-24-2011 12:21 PM
Resource Calendars	caz46	Project	0	02-12-2011 05:31 AM