When to use Task Calendar in MS Project 2019

Hi, I have very good question form one Blog reader: “Hello Nenad. I found your website while trying to solve a very particular problem in MS Project. Unfortunately, I haven’t been able to find a solution and was hoping that you could help. I have a task that is 18 days in duration called Lab Testing. This task is automatically scheduled so that any delay’s to the previous task will push this task out. The Lab will be shut down for 1 month in September, but our task is currently scheduled to finish before then. However, if we encounter delays to our schedule, it is possible that we will have 8 days prior to the lab shutting down and then will have to complete the 10 days after it opens back up. Is there anyway to schedule this such that the Lab Testing schedule will “float” or “adjust” itself around the fixed Lab Shutdown dates, so that the total amount of testing time (18 days) is the same?”

I will show the solution, using MS PROJECT 2019.

In this solution I will NOT use Lab as resource, and I will use Task Calendar.

Here is Scenario:

image

Now, let’s say that in March 2019, Lab is going to be shutdown, and Task need Lab cannot be done in this period.

First I will going to create Lab shutdown Calendar:

image

and:

image

Now I will apply this new calendar to the Task:

image

Now, lets say that Task 1 is 100% completed, and Task need Lab has 8 days actual work:

image

and:

image

and:

image

and I will get:

image

Let’s say that this is all work done until 28.02.2019 (end of February). I will move uncompleted part after that date like this:

image

and:

image

and I will get:

image

The rest of Task need Lab is here:

image

Of course, another way is to create Lab as Resource, and put in it’s calendar March as exceptions. but in that case that Resource should be assigned to that Task, and work is calculated in hours as well.

Hop this helps.

Regards!

Advertisements

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)!
This entry was posted in MICROSOFT PROJECT, MICROSOFT PROJECT 2019 and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s