#1
|
|||
|
|||
Managing Resource Individual Calendars
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 Code:
Resource name | Base Calendar | Week1 | Week2 | Weekn -------------------------------------------------------------------------------------- Anna | Standard | Holiday | | ... Bob | Standard | | Holiday | ... |
#2
|
|||
|
|||
OK, so I found some VBA that does exactly what I want. Check out this blogpost by Stefan Waldherr.
I was indeed afraid it was going to be VBA. However, part of my question still stands: How do I create custom columns showing the weekly availability of people? |
#3
|
|||
|
|||
Sorry - but to the best of my knowledge you're not going to accomplish that in the Resource Sheet. While Project may look like Excel, it is actually a SQL database in the back end - so adding columns to things like the Resource Sheet are limited by the fields in the database.
If you are using Project 2010, you can print a list of resource's non-working time through a report. Create a new resource report and on the Details tab, select Calendar. That will show each resource and their non-working time exceptions. The resource usage view also shows shading for each resource during his/her non-working time exception. By the way, there is no direct method in Project for scheduling a task when both resources are available. It can be accomplished through Task calendars - but it is a work around. |
Thread Tools | |
Display Modes | |
|
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 |