The “Wedding” Project! How to set up Calendars in MS PROJECT 2010, and why?–PART 2

 

Hi,

In my previous post I have explained how to use the Project Calendar, and how to make an exception (Vacation, New Year etc.). But what if you have different working times over the period. For example, our “Wedding” Project has working time from Monday to Friday from 08:00 to 12:00 and from 13:00 to 17:00. And it will start at 01.08.2011. Suppose that we want to keep that working time from 01.08.2011 to 15.08.2011, and then from 16.08.2011 to 31.08.2011 we want to work from 16:00 to 20:00, and then from 01.09.2011 go back to old working time.

I’ll show you how to do it in my “Wedding” Project, but this is the Example, so I will delete those working times later, because I will not need them in the future

Here it is:

image

Notice that you CAN NOT change the Default row.

Now be very concentrate. If you read my previous post you know that I made an exception in the Project Calendar for my Vacation time:

image

I will now, just for example, put a Auto Scheduled Task which will start (by default) at 01.08.2011 (Project start date), and will have 20 days Duration. I will get:

image

WOW! I have task with 20 days Duration, it will start at 01.08.2011 and it will be finished at 08.09.2011????

Well, now you understand why is SO IMPOTRANT to understand MS PROJECT 2010 calendars. Here is the explanation.

First, when I told that my task will have a 20 days duration, MS PROJECT 2010 has converted 20 days into 20 days X 8 hours per day = 160 hours.

We know that one day has 8 hours from here: On the File Tab click Options, and then Schedule and you will see:

image

The Task will start at 01.08.2011 (The Project Start date). OK. We need 160 hours. And we will get them:

  • From 01.08.2011  (Monday) to 05.08.2011 (Friday) = 5 days X 8 hours / day  = 40 hours
  • From 08.08.2011 (Monday) to 12.08.2011 (Friday) = 5 days X 8 hours / day = 40 hours
  • From 15.08.2011 (Monday) to 21.08.2011 (Sunday), there are no activities on the Task because of Calendar Exception (Vacation, remember???)
  • From 22.08.2011 (Monday) to 26.08.2011 (Friday) = 5 days X 4 hours / day = 20 hours. WHY? Because working time from 16.08.2011 to 31.08.2011 is from 16:00 to 20:00 and it means only 4 hours per day
  • From 29.08.2011 (Monday) to 31.08.2011 (Wednesday) = 3 days X 4 hours / day = 12 hours. WHY? Read one sentence above Smile with tongue out
  • From 01.09.2011 (Thursday) to 02.09.2011 (Friday) = 2 days X 8 hours / day = 16 hours. WHY? We are on the old working time!
  • From 05.09.2011 (Monday) to 08.09.2011 (Thursday) = 4 days X 8 hours / day = 32 hours. WHY? You know very well why Smile with tongue out

And it makes 40+40+20+12+16+32= 160 hours!

What will happens if I remove this working week from 16.08.2011 to 31.08.2011 from my Project Calendar?

image

I will get:

image

The Finish date is 02.09.2011.

  • From 01.08.2011 (Monday) to 05.08.2011 (Friday) = 5 days X 8 hours / day = 40 hours
  • From 08.08.2011 (Monday) to 12.08.2011 (Friday) = 5 days X 8 hours / day = 40 hours
  • From 15.08.2011 (Monday) to 21.08.2011 (Sunday), there are no activities on the Task because of Calendar Exception (Vacation, remember???)
  • From 22.08.2011 (Monday) to 26.08.2011 (Friday) = 5 days X 8 hours / day = 40 hours. WHY? Because I remove working time from 16.08.2011 to 31.08.2011 which was from 16:00 to 20:00 and only 4 hours per day
  • From 29.08.2011 (Monday) to 02.09.2011 (Friday) = 5 days X 8 hours / day = 40 hours. WHY? Read one sentence above Smile with tongue out

And it makes 40+40+40+40= 160 hours!

Now, I will remove my Vacation from exception from MS PROJECT 2010 Calendar:

image

and I will get:

image

The Finish date is 26.08.2011.

  • From 01.08.2011 (Monday) to 05.08.2011 (Friday) = 5 days X 8 hours / day = 40 hours
  • From 08.08.2011 (Monday) to 12.08.2011 (Friday) = 5 days X 8 hours / day = 40 hours
  • From 15.08.2011 (Monday) to 19.08.2011 (Friday) = 5 days X 8 hours / day = 40 hours
  • From 22.08.2011 (Monday) to 26.08.2011 (Friday) = 5 days X 8 hours / day = 40 hours

And it makes 40+40+40+40= 160 hours, again.

At the end of this post, do I have to emphasize that you should be EXTREMLY CAREFUL when you are changing calendars in MS PROJECT 2010, or working time???

If you think that this is complicated you are hitting the target. BUT, the real pain begins with Resource calendars, and the Task Calendars.

In my next post I will start with them! For the example I will leave Exception for the Vacation and 4 hours working days from 16.08.2011 to 31.08.2011, to make the whole thing more complicated.

 

Until my next post,

Best 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, MS PROJECT 2010, PMI, PRoject Management 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s