Effort calculation with different Calendars in Microsoft Project for the Web!

Hi,

today I will show you how Microsoft Project for the Web calculate effort when Resources have different Calendars.

First of all let’s see Calendars for two Resources: Tim and Ellen:

image

and:

image

Let’s see Ellen’s Calendar:

image

and finally:

image

Believe me, Ellen has this work hours for each and every working day, because I set it up Calendar for her.

Now, let’s see Tim’s Calendar:

image

OK, let me create brand new Project:

image

First of all I will put 4 days duration for all Tasks:

image

So, for Ellen’s Task Effort is 16 hours (4 days * 4 hours per day – from 09:00 AM to 01:00 PM). For Tim’s Task Effort is 32 hours (4 days * 8 hors per day – from 09:00 AM to 05:00 PM). Finally for Ellen’s and Tim’s Task Effort is 48 hours (Ellen’s 16 hours + Tim’s 32 hours),

Now I will erase Duration, so I will have:

image

Now I will put 16 hours for Ellen’s Task, 32 hours for Tim’s Task and 48 hours for Ellen’s and Tim’s Task, and I will get:

image

WOW! Duration for every Task is 1 day! Do not forget, that in Project for the Web, Task Type is Fixed Duration. and cannot be changed!

I will now change duration for ever Tasks from 1 to 4 days, and I will get:

image

As you can see now, Calendars are not respected, but instead effort is multiplied by 4, e.g.:

  • Ellen’s Task has 64 hours (1 day was 16 hours, so 4 days is 64 hours)
  • Tim’s Task has 128 hours (1 day was 32 hours, so 4 days is 128 hours)
  • Ellen’s and Tim’s Task ad 192 hours (1 day way 48 hours, so 4 days is 192 hours)

To conclude, you can get confused when Duration and effort is combined. The best expected result will be if you enter Duration, and Let Project for the web to calculate effort!

Regards

Advertisement

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 for the Web, Project for the Web, Project for Web, 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 )

Connecting to %s