Multinational Calendars and how to use them in MS PROJECT 2013?

Hi,

again, I have a question from one of my Blog readers:
“Okay I have a question not certain if it belongs in this thread. I’m managing a project for resources in multiple locations using MS Project 2007: US and 3 countries in Europe. I have multiple resource calendars to reflect the different countries. One (1) of my German resources started a task on Nov 28 which is a holiday for the US. When I attempt to change it to Nov 28th MS Project states that Nov. 28th is a non-working day; this is correct for US resources. However since Nov 28th is a working day for the German resource why is MS Project giving me this error. I understand that the standard calendar is used for the Project tasks, how can I use the resource calendar assigned to the task versus the standard calendar. Hope this question is clear thank you in advance.”

I will show you how to do it in MS PROJECT 2013!

First, I’m going to create a brand new Project:

Now suppose that in my project I have a guy from USA, and a guy from Germany. And suppose that in USA we have two holidays: one at Thursday, Jan 8th, and second at Monday, Jan 12th. I will create Calendar with name “USA Calendar”:

and then:

Forget about reoccurrence for a moment, it doesn’t matter in this Scenario.

Now suppose that in Germany we have two holidays: one at Tuesday, Jan 13th, and second at Friday, Jan 16th. I will create another Calendar with name “Germany Calendar”, at the same way I did with USA Calendar. I will get:

And now, I am going to create two Resources, John from USA, and Hans from Germany:

As you can see, John has USA Calendar as Base Calendar, and Hans has Germany Calendar as Base Calendar.

Finally I will assign both of them to my Task:

As you can see, Duration is now 12 days. Let’s see at the Task Usage View:

As you can see, John will not work at USA Holiday, and Hans at German’s Holidays. Both of them will work 80 hours per Task (because initial Duration was 10 days, and that means 10 days * 8 hours per day = 80 hours).

But they will work according to they own Calendar.

Hope this helps.

Regards

About Nenad Trajkovski

Location: Zagreb, Croatia Occupation: Project Manager Interests: Project Management and MS PROJECT He was born in Zagreb, Croatia at 1963. After completing his college he started working on projects in different business areas (banking, manufacturing, automotive industry, distribution, oil companies, etc.) developing and implementing ERP systems into different companies. He has got a lot of experience working with people in different business processes and also possesses great knowledge in information technologies and financial services. Today he works as a business consultant, adn Project Manager in PERPETUUM MOBILE d.o.o. Zagreb. He is a regular lecturer for Project Management in MS Innovation Center in Varaždin, Logosoft Sarajevo in Bosnia and Herzegovina and SEAVUS GROUP in Skopje Macedonia. He was named the best lecturer of WINDAYS 2008 while his lecture was also voted as the best. In addition, he was in TOP 10 lecturers at the MS SINERGY 2009 and MS VISIA 2009, 2010. Shares first place as the best lecturer of KulenDays 2009 and 2010 and PMI Conference 2009 in Zagreb. He is also a regular lecturer in the MS Community. He is a Certified Accountant and a PMP (Project Manager Professional) and a PMI-RMP (Risk Manager Professional), MCP, MCT, and Microsoft Certified Technical Specialist - Microsoft Project 2010. From 01.01.2012 awarded with MVP (Microsoft Most Valuable Proffesional - Microsoft Project)!

View all posts by Nenad Trajkovski →