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 , , , | Leave a comment

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

Status field in MS PROJECT 2013

Hi,

today I’ll show you how Status field works in MS PROJECT 2013.

As usual I am going to Create some Tasks:

image

I will add the Status field in the View:

image  ¸

As you can see Task 1 is On Schedule, because today is Mon 03.03.2014. Other Tasks are in Future Tasks Status. I’m going to change Status date from NA to Sunday, 09.03.2014:

image

and I’ll get:

image

 

As you can see Task 1, Task 2, and Task 3 are late according to Status date. No I’ll make Task 1, and Task 2 completed:

image

and I’ll get:

image

Now, Task 1, and Task 2 are Completed, Task 3 is Late, and Task 4 is Future Task.

This is powerful field. Use it whenever you want. You can sort on it, filter on it etc.

But, be aware that in some situations it will not be change according to changing status Date. It is minor Bug. If it does NOT refresh repeat this steps:

1. Hide the Status field Column

2. Show it again

It will work!

Here is the example. I changed the Status field from NA to 01.04.2014, and I get:

image

It’s wrong. After Hide / Show the same Column I’ll get:

image

Now, everything is OK!

Regards

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