Managing Future Non-Working Days in Project 2010

I have a template that will be used for multiple projects going forward. This template includes a resource table for our team and a calendar that has been updated with all company holidays and known non-working (vacation) days for each resource. Once multiple projects have been created from this template, how do we go about updating new non-working days as they become known? Will each project have to be updated separately, or is there a way to do this through the original template and refresh the projects created from it? We are trying to avoid having to update many projects each time a resource takes a vacation day.

Thank you!

-------------Problems Reply------------

PAndreNNA,

I hesitate to suggest using a Resource Pool but that is exactly what will allow you to have a central source file for changes to resource calendars. With a resource pool, each of your projects uses resources from the central pool. You will also have the advantage of creating views and reports for those resources across all projects.

The reason I hesitate to suggest a pool structure is that it is a linked structure and can therefore be subject to corruption if not created and managed with the utmost discipline.

Short of a linked pool file structure the only other way I can see to update resource calendar changes is to make the change in your template file and then use the Organizer to transfer the new calendar to each project. This could be automated with some VBA.

Hope this helps.

John

Hello,

It is noteworthy to specify here that you will not see any resource calendar in the Organizer, so you will have to define these calendars as base calendars (New calendar in Change working time)

Hope this helps

Jan,

I didn't think so either but then I did a quick test and indeed the custom resource calendar does appear in the organizer such that it can be copied to other files.

John

Hi John,

Glad it does for you but it doesn't for me. Organizer only shows base calendars. To be precise the resource(s) use standard as a base calendar and are individualised from there.

Greetings,

Jan,

Interesting. Which version of Project are you using? I did my test with Project Pro SP2 and the April 2014 cumulative update.

Just for interest I also ran a test using Project 2007 SP3 and got the same result, that is, I can create a resource calendar that appears in the Calendars tab of the Organizer such that I can copy it to the Global file.

To be precise, I created a custom resource calendar based on the Standard calendar. For example, I have a resource named Joe. I created a calendar called "Joe calendar" and gave Joe a vacation the week of July 14 through July 18 via an exception. On the Resource Sheet I selected Joe calendar as the resource calendar. When I assigned Joe to a 20d task starting July 1st the Resource Usage view shows no work assigned for Joe during the week of vacation, as expected. In the Organizer I selected the Calendar tab, selected the Joe calendar and copied it to my Global. I then closed the test file and opened a new project file. Using the Organizer, I transferred the Joe calendar from the Global to my new file. I set up a resource and set that resource's calendar to the Joe calendar. Again, when I assign that resource to a task, it shows no work during the vacation week.

You are a very experienced Project user, probably more so than me, I can't believe this doesn't work for you. Are we maybe talking about different things?

John

Hi John,

But you don't show "a resource calendar" in the Organizer, what you see is the BASE CALENDAR Joe's Calendar!! When you say "I created a calendar" that means this calendar is a base calendar. The fact that after that you assign it to a resource doesn't change its nature. For instance you could just as well have used Joe's calendar as a project calendar or a task calendar.

A resource calendar is created completely differently. Then you don't change (necessarily) the resource(s )base calendar but instead you look for the resource's name in the selection list of Change Working Time - it is there automatically from the moment you create the resource!! You can update that at will ut it will NOT appear in the organizer. Also, you can't use it elsewhere (as a project calendar nor as a task calendar); it is only and exclusively the resoruce's calendar.

Greetings,

Jan,

As usual you are right, I mis-used the term "custom resource calendar". Thank you for pointing out my error in terminology

Nonetheless rolling back to the poster's original issue, he/she wants a way to more easily update calendars for resources such that they can be easily flowed out to each project from the template. Unless you see a better solution, I believe my method will allow he/she to do that, in the absence of a resource pool file, will it not?

John

John, your methode is right: going back to my first reply, I only Wanted to wa'rn for a misunderstanding tdue to as you call it, a misuse of the term Resource Calendar. Greetings,

One solution I've created for a client of mine is that they export all approved annual leave from their ERP system to Excel. I created a macro that each PM runs that reads the leave spreadsheet and updates the resource and standard calendar if they exist in the project.

This works well and can also be done via SQL Server.

Category:Office Views:0 Time:2013-01-24

Related post

  • How do I include the .NET and Managed DirectX runtime dependencies in my VS 2010 Project? 2011-10-17

    How do I include the .NET and Managed DirectX runtime dependencies in my VS 2010 Project? I've had some difficulty with the setup project in the past and can't quite figure this one out. --------------Solutions------------- Open the References node o

  • MS Project 2010: Managing the Split-tasks 2012-01-29

    Hello, I use MS Project 2010 and I would like to find a way to manage the split-task. i.e. : I have to show a task that happend in three fases with two different lag between; Task 1 Phase 1 Start on 01/01/13 with a duration of 5 days, Task 1 Phase 2

  • Using MS Project 2010 for task management not related to a project 2013-02-01

    I've been tracking action items / tasks in Excel using a template with macros for the last few months. The team and action items / tasks have outgrown the usefulness of Excel for task management. I would like to begin leveraging MS Project for task m

  • MS Project 2010: Suggestion for managing Buffer 2013-11-16

    I am managing projects with MS Project 2010 Professional. I am able to baseline the project, and save a copy of the baseline to store the original Scheduled Finish Date (at baseline). I am also able to store the original Critial Path tasks, with all

  • Working on Time Management on MS Project 2010 2012-12-03

    Hi there, I have a hard time to understand how to change the dates or days for Late Start, Late Finish, Free Slack, and Total Slack on the menu bar MS Project 2010. Why? it because there is no drop-down arrow shown on Late Start, Late Finish, Free Sl

  • MS Project 2010 - Export planned progress to Excel with VBA 2013-11-12

    Hi everyone, I am currently trying to export the planned progress for all the 3rd level tasks of all the subprojects to an Excel. To do so, it seems I'd need to: - Set up the current date, probably with an Input Box - Set the Status Date with this in

  • I lost my MS Project 2010 CD but still have product key on original packaging. Where can i download trial copy and activiate with my product key? 2014-11-25

    as the subject says, "I lost my MS Project 2010 CD but still have product key on original packaging. Where can i download trial copy and activiate with my product key?". I have looked everywhere for project standard 2010 trail download but there only

  • microsoft project 2010 calendar duplication 2015-02-17

    Hi, I work in an office that has 6 project managers. Each project manager has MSP2010 loaded onto their desktop. We have created approx 10-15 individual projects (tasks only). The projects are being saved on a server. I have created 1 Resource Pool a

  • Connect MS Project 2010 to MS Project Server 2010 2010-05-25

    I am trying to get a tutorial or step by step instructions on how to connect MS Project 2010 to MS Project Server 2010. I have installed Server 2008 R2 (64 bit), Sharepoint 2010, and Project 2010 on my server and created a new site using the project

Copyright (C) dskims.com, All Rights Reserved.

processed in 0.184 (s). 11 q(s)