Resources and Durations – how are they linked in MS PROJECT 2013!

Hi,

very good friend of mine has a problem:

“Nenad, please help me. I want to have some Resources with different working hours (for Example, John 1 hour per day, Mary 2 hours per day), and when I assign Single Resource (for now) to the Task, I want duration to be changed. But, when I add John to the Task which should have 3 hours of Duration, the Task has the same duration, and nothing changed. What do I do wrong”

Friend of mine sent me an mpp file, and I will show you what was wrong in MS PROJECT 2013!

Here is the Task, with 3 hours Duration:

image

Here it John, as Resource:

image

and modified Standard Calendar for him:

image

When I assign John to the Task I get:

image

As you can see, nothing has changed. Let’s look at Resource Usage View:

image

The main, and only reason for that kind of behavior is because the Task is in Manually Scheduled mode.

I’ll now delete the old Task and I’ll create a new one in Auto Schedule Mode:

image

and again I’ll assign John  to the Task:

image

Voila, duration is changed. Again, let’s look at Resource Usage View:

image

As you can seem John will work three days, one hour per day, and that is exactly what my friend wants.

To conclude, to have all benefits from MS PROJECT 2013, use Auto Schedule Mode whenever you can.

 

Regards.

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, Microsoft Project 2013, PMI, PRoject Management | Tagged , , , , , | Leave a comment

Adding new Resource on the Partial Finished Task in MS PROJECT 2013 – Part 2 of 2!

Hi,

Today I’ll show another way of adding Resource after it is, for example, 40% Finished.

first, I’ll show you pictures from my Previous Post, so I will create on simple Project in MS PROJECT 2013:

image

and I will create tow Resources like this:

image

and I’ll assign John to the Task:

image

Now I will make Task 40% Completed, like this:

image

and:

image

Now I’ll use Detail View with Task form:

image

As you can see, Task is 40% Finished. I’ll now add Mary as Resource form the Gant Chart:

image

and I’ll get:

image

In this case, I will get EXACT what I’ve got in my Previous Post, e.g.:

image

As you can see, Mary will work only 24 hours (not 40) for this Task! Let’s see Task Usage View:

image

As you can see, John is done with work on Monday and Tuesday (this is 40% of Job done), and now wee need Mary. Mary will work 8 house at Wednesday, Thursday, and Friday. Duration remains the same e.g. 5 days.

If I choose this Option:

image

I will get:

image

So duration is shortened, and Total hours (40) are same. Let’s look at Task Usage View:

image

As you can see, John is done with work on Monday and Tuesday (this is 40% of Job done), and now wee need Mary. John and Mary will split the Remaining work (32 hours) at Wednesday (John will work 8 hours, and Mary as well), and Thursday (John will work 4 hours, and Mary as well). So, work distribution will be:

Monday –>        John 8 hours                             TOTAL:   8 hours

Tuesday –>       John 8 Hours                             TOTAL:   8 hours

Wednesday->   John 8 Hours, Mary 8 Hours       TOTAL: 16 hours

Thursday –>      John 4 hours, Mary 4 Hours       TOTAL:  8 hours

                                                             GRAND TOTAL: 40 hours

Finally I’ll choose the Third Option:

image

and I’ll get:

image

Again, I’m going to use Task Usage View with Peak field:

image

Duration remains same, But for the Rest work, John and Mary will work less hours per day. So, work distribution will be:

Monday –>        John 8 hours                             TOTAL:   8 hours

Tuesday –>       John 8 Hours                             TOTAL:   8 hours

Wednesday->   John 4 Hours, Mary 4 Hours       TOTAL:  8 hours

Thursday –>      John 4 hours, Mary 4 Hours       TOTAL:  8 hours

Friday –>           John 4 hours, Mary 4 Hours       TOTAL:  8 hours

                                                             GRAND TOTAL: 40 hours

 

To conclude, if you want to get those three Options do not add additional Resource from Task Form Screen!

 

Regards!

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, Microsoft Project 2013, MS PROJECT 2010 | Tagged , , , | 3 Comments

Adding new Resource on the Partial Finished Task in MS PROJECT 2013 – Part 1 of 2!

Hi,

I had a very good question from one of my Blog Readers:

“Hi Nenad. Can you tell me what is going to  happen if I have one Resource on the Task, and that Task is finished, for example, 40%, and I add new resource to that Task?”

Well, let’s see. I will create on simple Project in MS PROJECT 2013:

image

and I will create tow Resources like this:

image

and I’ll assign John to the Task:

image

Now I will make Task 40% Completed, like this:

image

and:

image

Now I’ll use Detail View with Task form:

image

As you can see, Task is 40% Finished. I’ll now add Mary as Resource form the Task Form:

image

and I’ll get:

image

As you can see, Mary will work only 24 hours (not 40) for this Task! Let’s see Task Usage View:

image

As you can see, John is done with work on Monday and Tuesday (this is 40% of Job done), and now wee need Mary. Mary will work 8 house at Wednesday, Thursday, and Friday. Duration remains the same e.g. 5 days.

But, there is another way in which you can shorten duration or Maximal units when you add Mary later. For that you will have to wait next week.

Regards,

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, Microsoft Project 2013, MS PROJECT 2010 | Tagged , , , | Leave a comment

Strange Duration in MS PROJECT 2013 – Bug or Not!

Hi,

I will show you something that makes MS PROJECT users crazy! Of course I’ll use MS PROJECT 2013.

I will first, create a Brand new Project with one Task with 5 days Duration, like this:

image

Everything is just fine. Now I will add one Resource with 24 Hours Calendar:

image

and I’ll assign this Robot to the Task:

image

or in Task Usage View:

image

So Robot will work 16 hours at Monday (From 8 AM till Midnight), and from 00:00 to 00:00 at Tuesday!

But, as you can see Task Duration is 5 days! WHY? the simplest answer is: Because MS PROJECT works that way.

The Magic Formula is: Duration = Work / Units. So, Work = 40 hours and Units = 100%. Since 1 Day is 8 hours, Duration = 40 / 100% (8 hours) = % Days.

It may look silly (actually it does), but MS PROJECT Calculates duration in that way, no matter which Calendar did you use. Duration of Project Summary Task is, on the other hand, Finish Date – Start date, and it is 2 days!

But, If you want to see “correct” duration for the Task, you can use, for Example, Duration 1 custom field with formula, like this:

image

and then:

image

and finally:

image

Now I will add this Field to the Gantt Chart, and I’ will get:

image

And I got what I wanted.

It’s a little bit Tricky, but well….

 

Regards!

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, Microsoft Project 2013, PMI, PRoject Management | Tagged , , , , , | Leave a comment

24 Hours Calendar – how it works in MS PROJECT 2013

Hi,

I have a lot of questions about MS PROJECT 2013 Calendars, especially about 24 hours Calendar.

I will explain how does it work in MS PROJECT 2013.

First I will Create a very Simple Project with only one Task and only one Resource:

image

and:

image

I will assign Mary to Task:

image

Now let’s Look to Task Usage View:

image

As you can see Mary will work on the Task from Monday till Friday 8 hours per day, because of this:

image

and:

image

and:

image

So 5 days Duration means 5 days * 8 hours per day = 40 hours. Or Magic formula:

Work = Duration * Units ==>> Work = 5 days (5 days * 8 hours per day) * 100% Units for Mary = 40 Hours

Now I will say that Mary will work on 24 Hours Calendar:

image

If I now look at the Task Usage View, I’ll get:

image

As you can see Mary will work 16 hours at Monday (From 08:00 am till 00:00 = 16 hours), and 24 hours  on Tuesday (From 00:00 till 00:00), and that makes in total 16+24 = 40 hours, sop she will finish in two Days.

You should be careful when you are working with that Calendar. Ask yourself this: “Is it really possible that someone will work 24 hours per day?” I don’t think so. So when you can use this Calendar? From my point of View when you are using Machine (Automatic work), and not a human, because Machine can work 24 hours per day.

Regards!

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, Microsoft Project 2013, MS PROJECT 2010, PMI, PRoject Management | Tagged , , , | Leave a comment

Material Resources and Calendars in MS PROJECT 2013 – where is the link?

Hi,

as usual, I have a question from one of my Blog Readers:

“Hi Nenad. i follow your blog step but i added resource as material not as work, but it doesn’t come up to me in the calendars list to adjust its working/non working time. is there a reason for that or is it just a bug?
thanks”

I’ll show you that in MS PROJECT 2013.

Suppose that you want to build a wall:

image

You need two type of Resources: John as Work Resource (he will build the wall), and Bricks as Material Resource (you need Bricks for the wall, don’t you?)

image

As you can see, I can not assign any Calendar to the Material Resource

I will now assign John to the Task, and 100 Bricks for the same Task:

image

 

and I’ll get:

image

 

Let’s say that there is a Holliday at Tuesday 11.3.2014:

 

image

I’ll get:

image

As you can see, the Task will be finished at Monday, 10.03.2014, nota at Friday 14.3.2014, because it needs 5 working days.

And only John is affected (e.g. Working Resources) with Calendars. But why not Material Resources as well?

Because, for example Bricks, are not available at certain period. You have them or not. It is logical. On the other hand, let suppose that you have a machine need for building a wall, and you do not have them available all the time. In that Case, you should create, for example, Machine as work Resource, make a Calendar for it’s availability and then assign them to the Task.

image

Now I will tell to MS PROJECT when the Machine is available for my Project:

image

and I will get:

image

Now let’s look at Resource Usage View:

image

 

As you can see, the Machine is over allocated at Monday, and Tuesday. If I do not use this method, but if I change Calendar for Machine like this:

image

I will get:

image

So the Task will be finished two day latter. let’s see Task Usage View:

image

 

No the Machine is not Over allocated, but there is something wrong with this scenario. I John need the Machine for the work he couldn’t work without it at Monday, and Tuesday .

So you have to be extremely careful when you are using exceptions, and calendars for Resources.

 

Regards

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, Microsoft Project 2013, MS PROJECT 2010, PMI, PRoject Management | Tagged , , , | 1 Comment

Task Calendar in MS PROJECT 2013 – when to use it?

Hi,

Again, I have a request (question) from one of my Blog readers: !

“Hello,

Your tutorials are very helpful – thank you! I was wondering if it is possible to make a particular task not allowed on a particular day? For example, as a rule we do not deploy any projects on a Friday, therefore the task for ‘go live’ would need to automatically be moved to the next working day if it falls on a Friday. This is only valid for that one task and not all of the others therefore changing the calendar for the whole project would not work. Do you know if this is possible?

Many Thanks,
Emily”

I’ll show you how to do it in MS PROJECT PRO 2013.

First of all I am going to create a brand new Calendar, called ”No Friday”:

image

and:

image

and:

image

and:

image

OK! I’m going to Create two Tasks:

image

As you can see, both of them are going to be finished at Friday!

I’ll add Two Resources, and assign them to Tasks:

image

and:

image

Now suppose that, for some reason, I do not want to perform any Action on Task 1 at Friday. I will assign No Friday Calendar to that task:

image

and I will get:

image

as you can see, Task 1 will start on Monday, but it will be Finished at next Monday, because there will be no work performed on Friday.

If you put you cursor on Info column, you will get:

image

Remember that Task Calendar has the highest Priority!

Regards,

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, Microsoft Project 2013, Microsoft Project Server 2010, MS PROJECT 2010, PMI, PRoject Management | Tagged , , | Leave a comment