Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-21-2015, 05:22 AM
JvdP JvdP is offline Managing Resource Individual Calendars Windows 7 64bit Managing Resource Individual Calendars Office 2010 64bit
Novice
Managing Resource Individual Calendars
 
Join Date: Jul 2015
Posts: 3
JvdP is on a distinguished road
Default 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
But I want it to look like this:



Code:
Resource name | Base Calendar | Week1   | Week2   | Weekn
--------------------------------------------------------------------------------------
Anna          | Standard      | Holiday |         | ...
Bob           | Standard      |         | Holiday | ...
Reply With Quote
  #2  
Old 07-21-2015, 05:30 AM
JvdP JvdP is offline Managing Resource Individual Calendars Windows 7 64bit Managing Resource Individual Calendars Office 2010 64bit
Novice
Managing Resource Individual Calendars
 
Join Date: Jul 2015
Posts: 3
JvdP is on a distinguished road
Default

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?
Reply With Quote
  #3  
Old 07-21-2015, 12:18 PM
JulieS JulieS is offline Managing Resource Individual Calendars Windows 7 64bit Managing Resource Individual Calendars Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Managing Resource Individual Calendars Resource Usage View - Is it possible to display resource names Andrea Schanz Project 6 09-22-2014 07:47 AM
Managing Resource Individual Calendars Resource assignment with resource calendars joday48 Project 6 08-19-2014 05:49 AM
Managing Resource Individual Calendars 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft