How to prevent Resource Overallocations by using the Team Planner–WATCH OUT!

 

Hi,

In MS PROJECT 2010 there is a feature which can automatically prevent Resource Overallocations.

I will add two tasks and two resources to the project:

image

and:

image

Now I will assign them to both, Task 1 and Task 2:

image

and I will get:

image

Now I will open the Team Planner:

image

and then:

image

and I will get:

image

You can see that both resources are overallocated!

Now I will arrange the Team Planner to prevent this situation:

image

and I will get:

image

As you can see, MS PROJECT 2010 has move Task 1 to start after Task 2, and Resources are not Overallocated any more!

But! I will go back to the Gant Chart  and I will add two new Tasks and I will assign Resource 1 and Resource 2 to them:

image

As you can see, both Resources are Overallocated again. But I will now go back to the Team Planner and I will do NOTHING, but I will get:

image

As you can see, all Task are Rescheduled automatically because the Prevent Overallocations button has remained in “turn on” mode:

image

So, DO NOT TURN THIS BUTTON! If you do, and you are 100% sure that you want from MS PROJECT 2010 to do the “leveling”, do not forget to turn this feature off before you are leaving Team Planner. Leveling is hard to “undone”, so use it if you really need it!

 

Best Regards,

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, MS PROJECT 2010, PMI, PRoject Management | Tagged , , , , | 4 Comments

How to Use the Team Planner to Assign Resources

 

Hi,

This is Repost of my two old Posts, and I am doing that because it has to be explained again, since I am in the “ASSIGNING RESOURCE” posts, and it should be mentioned again!

I will show you how you can easily adjust assignments and reschedule your tasks in the project.

First I will add four tasks to my project and they will be in manually scheduled mode, and I will not schedule them for the moment:

Primjer 1 11.05.2011

I will add 3 resources through the Resource sheet (John, Paul, and Mary):

Primjer 2 11.05.2011

I will now start the Team Planner View:

Primjer 3 11.05.2011

You can see that John Paul and Mary don’t have any tasks assigned, and that all tasks are unscheduled (because I left them in manually scheduled mode)

I will assign John to the Task 1 , Paul to the Task 2, and Mary to the Task 3. I will get:

Primjer 4 11.05.2011

 

You can see that those Tasks are assigned but not scheduled. Now I will drag and drop Task 1 and put it to start on Wednesday 11.05.2011:

Primjer 5 11.05.2011

and I will get:

Primjer 6 11.05.2011

You can see that the task is still in manual schedule mode, but it has estimated duration of 1 day.

I will now double click on Task 1 and put 3 day duration in the duration field:

Primjer 7 11.05.2011

and I will get:

Primjer 8 11.05.2011

Now John is assigned to the Task 1 and it is scheduled

I will drag and drop Task 2 from Paul to John and put it to start on Wednesday 11.05.2011 as well, and I will change its duration to 3 days (automatic scheduled). After that I will get:

Primjer 9 11.05.2011

You can see that John appears in a red color, and it means he is “over allocated”. Now I will simply drag and drop Task 2 from John to Paul and I will get:

Primjer 10 11.05.2011

You can see that John is not “over allocated” anymore.

Now I will double click on Task 4 and I will set 3 duration days (automatic scheduled):

Primjer 11 11.05.2011

and I will get:

Primjer 12 11.05.2011

You can see that Task 4 is now scheduled but not assigned.

So, generally you can play with Team Planner View to assign and reassign the Task however you want. You must remember that there are 4 areas in Team Planner View:

Primjer 13 11.05.2011

Finally, if you move a scheduled task (assigned or unassigned) to unscheduled area (assigned e.g. to someone) or unassigned you will actually delete actual work on that task. I will move Task 2 from assigned (to Paul) and scheduled (from 11.05.2011 to 13.05.2011) to unassigned and unscheduled area and I will get a warning:

Primjer 14 11.05.2011

And last, but not least, Tem Planner View is available only in MS PROJECT 2010 PROFESSIONAL VERSION!

Now, I will show what you should pay attention to when you adjust assignments and reschedule your tasks in the project.

First I will add four tasks to my project and they will be in automatic scheduled mode, and I will schedule them:

Primjer 1 12.05.2010

I will add 3 resources through Resource sheet (John, Paul, and Mary):

Primjer 2 12.05.2011

I will now start the Team Planner View:

Primjer 3 12.05.2011

You can see that John Paul and Mary don’t have any tasks assigned, and that all tasks are scheduled.

I will assign John to the Task 1 and Task 4, Paul to the Task 2, and Mary to Task 3. I will do it using drag and drop function:

Primjer 4 12.05.2011

And I will get:

Primjer 5 12.05.2011

You can see that those Tasks are assigned and scheduled. Now I will drag and drop Task 1 and put it as John’s unscheduled task, and I will get a warning:

Primjer 6 12.05.2011

That means that I will actually delete the work of Task 1 since it is no more scheduled.

The same will happen if I move any scheduled task to the unassigned and unscheduled area (for example, Task 2):

Primjer 7 12.05.2011

Now I will reassign John to Task 1 and Task 4, Paul to Task 2, and Mary to Task 3. And again I will get:

image

I want to reassign Task 4 to Mary, and I want the Task 4 to begin on 12.05.2011. First I will drag Task 4 and move it to Mary on 12.05.2011. I will get:

Primjer 8 12.05.2011

Now I will release the mouse button, and I will get:

Primjer 9 12.05.2011

You can see that MS PROJECT did not allow me to reschedule Task 4. It only allows me to move the Task from John to Mary, but not to reschedule it EARLIER. If I had tried to move Task 4 from 19.05.2011 to, for example, 20.05.2011, MS PROJECT would have allowed me to do that.

Now, the Task 4 is assigned to Mary, and the start date is 19.05.2011. Now I will try to move it to 12.05.2011, again. I will get:

Primjer 10 12.05.2011

As you can see, I cannot move (or reschedule) this task to an earlier date without breaking the link. After I click the OK button I will get:

Primjer 9 12.05.2011

Task 4 stays scheduled as it was.

So, the Team Planner View is very powerful, but you must use it with caution.

See you,

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, MS PROJECT 2010, PMI, PRoject Management | Tagged , , , , | 4 Comments

Assigning Resources to Tasks! Some Tips and Tricks!

 

Hi,

Today I will show how can you add and assign a Resource at the same time in MS PROJECT 2010, how can you find a right Resource from a very long list of resource, and finally, how can you pick a resource by their availability

If you are assigning Resource to the Task, and you don’t have that Resource in your Resource sheet, you can do it during assigning. Remember that Let’s say that we have two resources, Ann Smith and John Dow. We are assigning resources to the Read the article Task, and we found out that we need Ann Smith, and John Wayne, and the pair of Glasses, as Material Resources. Firs I will assign Ann Smith:

image

Now In the First blank row I will type John Wayne and press TAB key and I will get:

image

Since I can not fill in this form all necessary details I will double click on John Wayne (or any other field in this row), and I will get:

image

On the General Tab I can fill information shown on the picture above. In the Costs Tab I can fill Standard and Overtime Rate:

image

and finally, on the Notes Tab I can put some notes:

image

Now I will assign John Wayne to the Task, and I will get:

image

For the Glasses, the procedure is the same, and the only difference is that I have to mark it as a Material Resource:

image

 

Now suppose that you have a long list of Resources (hundreds of it). It will be very difficult and complicated to choose the right one, and it will be very easy to make a mistake. Suppose that this is list of your resources:

image

If I need, for example, only Material Resources for my Read the article Task, I will apply the filter:

image

and I will get:

image

As you can see, I get only the Material Resources. That was easy. But, what If I want to choose only Resources from Marketing department. And this is written in the Group field.

I will also apply a filter, but it is not on my list:

image

Whenever you see tree dots (like Group…), you will have to enter the selection criteria. So, after I applied the Group filter I will get:

image

and after that I will get:

image

I’ve got all the Resources fro Marketing department. Do not forget to turn of the filter in your assignment if you want to see all resources, or apply All Resource filter:

image

Now suppose that I have those resource for the project:

image

I will assign Ann Smith with 25%, and John Dow with 75% to the Read the article Task:

image

If I assign them to the Paint the wall Task with their max units (Ann has 50%, and John 100%) they will become over allocated. Now suppose that for the Paint the wall I need a resource who is available 3 days. Of course, I can first apply filter (with, for example, PAINTERS code), and then find resource by their availability. But for this example, let’s say that I want to find out who is available for 3 days from all of my resources:

image

I will put 3d in that field, and I will get:

image

As you already know, only John Wayne is available for 3 days.

 

Until my next post,

 

Best Regards!

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, MS PROJECT 2010, PMI, PRoject Management | Tagged , , , , | 16 Comments

Assigning Resources to Tasks! Assigning Work Resources to the Tasks

 

From this post I will start with “How to assign different type of resources to the Tasks”.

With assigning work resources to the Task, you are answering the question: “WHO WILL PERFORM THE WORK”. From my previous post you know that is Max units field in Resource sheet:

image_thumb1

What does this figure means?

100% means that John Doe is 100% available for the Project, and Ann Smith is available only 50% for the Project.

Now I will create two Tasks:

image_thumb7

and I will assign Ann Smith to the Read the Article Task:

image_thumb10

and I will get:

image_thumb13

As you can see default units for this task is 50% (the Max units form resource sheet).

I will now assign John Dow to the same task. WATCH OUT! After you have assigned Ann Smith to the Read the Article task, DO NOT CLOSE THE ASSIGN RESOURCES WINDOW! Why? Because, that will mean that you have already finish assignment to the Read the Article Task, and that you want to ASSIGN ADDITIONAL RESOURCE, because you have forgot something. I will explain additional resource assigning in my next posts, but for now DO NOT CLOSE ASSIGN RESOURCES.

image_thumb19

I will now close the Assignment window and I will get:

image_thumb22

I will now open the Resource Usage window:

image_thumb24

As you can see Ann Smith will work 4 hours per day (50%), and John Dow 8 hours per day (100%).

Now I will add same resources to the Task Pain the wall but in the Units field in Assignment window I will say that Ann Smith will work 25%, and John Dow 50%:

image_thumb27

I will open the Resource Usage View again an I will get:

image_thumb31

Ann and John are RED, because they are over allocated, but that is now the Subject of this post. For the Paint the wall Task Ann will work 2 hours per day (because I told that she will work only 25%, instead of 50%, and this half of her capacity), and John will work 4 hours per day (because I told that she will work only 50%, instead of 100%, and this half of his capacity).

Now I will change the Resource Calendar for Ann and John.

image_thumb33

When I do the same thing for the John I will get (in the Resource Usage view):

image_thumb3

Ann Smith will work 2 hours per day for the Read the article Task. Why? Because for that task she has 50% units assigned, and that will be 4 hours if I didn’t say in Resource Calendar that the working time is from 08:00 to 12:00. But, because working time is only 4 hours per day (from 08:00 to 12:00), 50% means 2 hours per day!

For the Paint the wall Task Ann Smith will work 1 hour per day! Why? Because for that task she has 25% units assigned, and that will be 2 hours if I didn’t say in Resource Calendar that the working time is from 08:00 to 12:00. But, because working time is only 4 hours per day (from 08:00 to 12:00), 25% means 1 hour per day!

John Dow will work 4 hours per day for the Read the article Task. Why? Because for that task he has 100% units assigned, and that will be 8 hours if I didn’t say in Resource Calendar that the working time is from 08:00 to 12:00. But, because working time is only 4 hours per day (from 08:00 to 12:00), 100% means 4 hours per day!

For the Paint the wall Task Ann Smith will work 2 hours per day! Why? Because for that task he has 50% units assigned, and that will be 4 hours if I didn’t say in Resource Calendar that the working time is from 08:00 to 12:00. But, because working time is only 4 hours per day (from 08:00 to 12:00), 50% means 1 hours per day!

Is it complicated? Of course it is! Can it be more complicated? Yes it can! Continue to read my next posts and you will have a headache! But you can also find some further interesting information.

Best Regards

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, MS PROJECT 2010, PMI, PRoject Management | Tagged , , , , | 6 Comments

Different Resources Types in MS PROJECT 2010 and what do you have to know about them!

 

What are RESOURCES in MS PROJECT 2010. Those are people (human resources), equipment (machines), material (bricks, oil, butter,..) and cost needed to perform the Task(s), and to reach the Project Goals and Objectives.

There are three types of Resources in MS PROJECT 2010: Work Resources, Material Resources i Cost Resources.

  • Work Resources are people and machines, and they need time (hours, days, weeks, etc.) to perform the Tasks
  • Material Resources are consumables like bricks, oil, concrete etc., and they are time independent.
  • Cost Resources are time independent resources, like Airplane tickets. If you are traveling from Zagreb, Croatia (my hometown) to Amsterdam it will cost you, approx. 300€, no matter how long will you travel (1 hour or 1,5 hours). If you are traveling from LA to Boston the price will be different. Those type of Resources is needed in your Project to analyze your costs (from my example, how much money did we spend for the travelling with airplanes).

As you already know you can add resources in MSPROJECT through Resource sheet:

slika1

There are several fields and Resource Type depended:

  • Resource Name: Name of the Resource. Be very careful. If you add two or more resources with the same name, MS PROJECT 2010 will consider them as different resources, even there is obvious mistake. Here is an advice. After you put all Resources in the Resource Sheet, sort them by the name and delete duplicated Resources:

slika2

and after that:

slika3

and you will get:

slika4

Select all duplicated Resources (hold CTRL key and Click on the row heading on the right side of the screen):

Slika5

and press the Delete key. After that you will get:

Slika6

 

After that, DO NOT FORGET TO SORT Your resources by ID:

Slika7

and you will get:

Slika8

 

  • Type: Here you can choose one of the three resource types: Work (Default), Material and Cost. If you are entering only Work or Material resources you can choose the table which contains fields applicable to this particular type of resource: Entry-Work Resources or Entry – Material Resources table:

Slika9

  • Material: If resource type is Material Resources in this field you are putting measure unit (like tons, meters, pieces, etc.). This field is disabled for other resource types.
  • Initials: You can put initials for the Resource (like NT for Nenad Trajkovski), but you can use this field for other purposes. I will write about this in one of my next posts.
  • Group: If you are going to have a group of resources (like Purchase, Vendors, Painters etc.) here is the place to put the name of the group
  • Max: This field is only enabled for the Work Resources. You can put 10%, 50%, 100%, 300%, or any number you want (except 0%). This field is of big, I will tell GREAT importance, and it is used (with other parameters) to calculate the WORK FIELD. It will be explained very briefly in my post where I am going to write about assigning resources to the tasks. For now, just remember that if you are put, for example 100%, for the Max, it means that that Resource is 100% available for your Project.
  • Standard Rate: This is Standard fee (MONEY) for the resource. You can put that fee like, for example 100/hour, /day etc. This is true only for Work type. If, for example, resource has $50/hour, and it will work 5 days and 8hours per day, cost for this resource will be 40 hours X $50 = $2.000. This field is disabled for the Cost type, because for this type of resources you will put the exact cost when you will assign that cost to the Task.
  • Overtime Rate: Same as Standard Rate but here you are going to tell how will your resource be paid by the overtime work. This field is enabled only for Work type of resources (there is no overtime work for bricks, or air ticket, is it? Smile)
  • Cost/Use: That is also known as a Setup fee. For example, if you have Resource named: Nenad – the plumber, and it has $100/hour as a standard fee, and he is charging his travel to your home $50, no matter how long he is going to drive, than you will put $50 in that field. This field is disabled for the Cost type of resource, because it is seamless.
  • Accrue at: You have three choices: Prorated, Start i End. In this field you will decide how will costs be charged, e.g. when will you charge those costs!. Prorated means that if, for example, cost for the task is $1.000, and only 20% of the task is finished, it will be $200 charged! Start means that this $1.000 will be charged as soon as the task begins, and End means that this $1.000 will be charged not before the tasks ends.
  • Base Calendar: You are assigning any specific calendar for the resource if you have one. I wrote about that in one of my previous posts. Obviously, this field is enabled only for Work type.
  • Code: If you have any specific code for you resource put it here.

There are two types of resources: Committed and Proposed. Committed (Default) means that you are 100% sure that this resource is available to your Project. If the Resource is Proposed (TENTATIVE), it means that you NEED that resource, but you do not know if it will be available when you will need it. If you want to make the Resource as Proposed, double click on it and you will get:

Slika10

And, for the end of this post, if you know that your resources are Generic (for example, Developers, so you know their job, but you don’t know their names) you can make them as Generic if you double click on the Resource and after that you will get:

Slika11

Until my next post, best Regards!

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, MS PROJECT 2010, PMI, PRoject Management | Tagged , , , , | 40 Comments

Setting Up Resources in MS PROJECT 2010! Budget Resource, and Detailed Resource information!

 

Hi,

If you have a Budget for your project you can work with it in MS PROJECT 2010. Frankly, the solution with the Budget in MS PROJECT 2010 is not something what make me happy. I think that it could, and should be much better than it is now. But, until next version of MS PROJECT, I will explain how can you work with those resources.

First of all, when you have a Budget Resource, make sure that you put the different name convention to that resource (use UPER CASE, or prefix like B-). Let say that we have four budgeted Resources for our Project:

image

As you can see, two of them are Work type Resources, one is Material type, and one is Cost type. I also put for Work and Material resources Standard rate! But, I know what would you ask! How MS PROJECT 2010 knows that those Resources are Budget type? Obviously not by the B- prefix. Well IT DOES NOT KNOW until you tell it that those are Budget type. Double click on each of Resource for which you want to become a Budget and check:

image

After you check all your Budget Resources you will get:

image

 

As you can see, Max units, and Standard rate are empty now! Why? Because you do not need them. You will assign cost for those budgeted resources to the resources through Task and/or Resource usage Views. When we get to the point where I will Set up a Budget I will show you how can you do it! For now Remember that you can’t assign Budgeted Resources to anything else then PROJECT SUMMARY TASK. That means that if you have budget for one, particular, Task you can not assign that budget to that task, but rather to a project as a whole, and that is something I am not happy about. I will write about this when I come to the Assigning Resources to the Tasks!

If you want to add some additional information for your Resource (like windows account, Email, note, or hyperlink, you can do it very easy.

You can double click on your Resource name, or you can go to the Resource information through Resource Tab:

image

and You will get:

image

I put my email address, and Windows Account. That was in General TAB. If I want put some note about Resource I can do it through Notes Tab:

image

If you want to add a hyperlink to the Resource you can do it like this:

image

After that you can enter the Hyperlink:

image

After that you will see Indicator right from the Resource:

image

Rest your mouse pointer at the Indicator field and you will see:

image

If you want to open the hyperlink, right click to the Indicator field and then follow this:

image

 

Dear fellows that was all of the easy part of Resource. From my next post I will start with Assigning Resources to the Tasks! It will take me some time and posts but those are almost the most significant things to remember If you want to understand the logic of MS PROJECT 2010.

Until then,

All the Best!

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, MS PROJECT 2010, PMI, PRoject Management | Tagged , , , | 11 Comments

Setting Up Resources in MS PROJECT 2010– the story begins! How to import Resources from the Address book, and from the Excel template

 

Hi,

in my last blog post I was finished the Scheduling! In my next posts, I will temporary forget my “Wedding Project”, and I will start to explain how to set up, and manage the Resources in MS PROJECT 2010. It is very important part of MS PROJECT in many ways. If you ever had a problems with resources in your MS PROJECT 2010, you should read those posts very carefully!

You can enter your resources in many ways. The best way is through Resource sheet!

image

Before I start with explanation what each row means, I will show you how can you export your resources from your E-mail address book, and from excel.

If you have your resources in your address book, you do not have to retype them in the Resource sheet. Instead of that, just open the Resource sheet, and click on the Resource Tab, then click on the Add Recourses, and then on the Address Book:

image

and you will get:

image

After you select and Add your resources, click on the OK button and you will get:

image

They are here! It is easy isn’t it? You should fill other fields like Max units, Std. Rate, etc., but it is easier that retype the whole story!

What are the other fields, and what do they mean? You will find out if you will continue to read my next posts!

If you import Resources from excel template, first you should give that template to someone who will fill it! It can be HR department, or someone who is responsible for managing Resources for your Project.

To get the Template you should follow this steps:

Start excel and then choose:

image

and then:

image

When you Double click on this template you will get:

image

and you will get sheet in which you can enter your resources, like I will do in my example:

image

Of course, you can fill the other fields Smile

Now you should save this excel template:

image

and You will get:

image

Now, you can close your excel file, and go back to your Project file.

On the File Tab, click Open:

image

And you will get:

image

Now choose your file:

image

and you will get:

image

and then:

image

 

Because I have already imported some resources from my E-mail book, I will Append those Resources from my Excel file to the existing resources:

 image

And I will get:

image

After that you will get “next” screen. If you did not change the layout of your excel template and layout of Resource sheet n MS PROJECT 2010, you should click on the Finish button:

image

and, finally you will get:

image

That was the easier part of Managing Resources. Next time, we are going to some “serious” business.

 

Until then,

 

Best regards!

Posted in MICROSOFT PROJECT, MS PROJECT 2010, PMI, PRoject Management | Tagged , , , , | 5 Comments

The “Wedding” Project! Building the Schedule? – PART 6 (YEAH! The LAST ONE)

 

Hi,

I will continue my last post!

First, I will change the duration for the wedding night from 1hr to 12 hrs.:

image_thumb48

Now I will arrange my timescale:

image_thumb51

I want in middle Tier to have days:

image_thumb53

and in Bottom Tier to have hours:

image_thumb55

and I will get:

image_thumb63

now I can se the tasks hour by hour in one day. Now suppose that I have a marriage (The Get Married Task) at 16:00. That means that task Go to the Wedding chapel must begin at 15:00. Do I will put in a Start date: 03.09.2011 15 in this task and I will get:

image_thumb67

The final result is that I have my wedding at 16:00, and that is what I want.

There are few things left. I will remove a Task calendar from the Go to the honeymoon task, because this task will be done AFTER wedding party and I will get:

image_thumb70

Now, I know that the married couple will go to the Honeymoon at 06.09.2011 so I will change that date:

image_thumb73

and I will get:

image_thumb76

The duration id 7 days and the start date is 06.09.2011 and the finish date is 14.09.2011. WHY? You know why. Because Saturday and Sunday are not working days. So, our wedding couple should go back to home during the weekend, and then go back to the honeymoon, and the honeymoon will be from 08:00 to 17:00? NO Smile with tongue out. Instead of that I will put 7ed in the duration field and that means that our wedding couple will spend 7 whole days in the honeymoon:

image_thumb79

And for the end we must set a schedule for next Tasks:

image_thumb2

image_thumb4

Let’s go:

image_thumb7

I put 1 eday (the whole day) from 02.09.2011 till 03.09.2011 (the wedding day) for the Task 25 Transport Guest from Airport to the Hotel CAB because I know that they will arrive those days but they will not come with the same plane

I put predecessor 86 with start to start relationship for the Task 26 Transport Guest from Hotel to the Wedding Chapel, because Task 86 is: Go to the Wedding Chapel, and guest must go to the wedding chapel at the same time when the wedding couple go, and I applied the same Wedding Calendar to this task as the Task 86 have

I put predecessor 89 with start to start relationship for the Task 27 Transport Guest from Hotel to the Wedding Chapel, because Task 89 is: Go to the Restaurant, and guest must go to the wedding chapel at the same time when the wedding couple go, and I applied the same Wedding Calendar to this task as the Task 89 have¸

I put predecessor 91 with finish to start relationship for the Task 28 Transport Guest from Restaurant to the Hotel with CAB, because Task 91 is: Give gifts to guests, and after that they can go to the Hotel, and I applied the same Wedding Calendar to this task as the Task 91 have

I put predecessor 28 with finish to start relationship for the Task 29 Transport Guest from Hotel to the Airport with CAB, because the will go back home the day after wedding.

image_thumb9

I put the Start date 03.09.2011 (the wedding date) with 10 am for the Task 40 Ship the Wine from wine-cellar to the Restaurant, because it has to be shipped at the wedding they but BEOFRE THE WEDDING

I did the same thing with tasks:

image_thumb11

image_thumb13

I put predecessor 91 with finish to start relationship for the Task 52 Pay the Band, because Task 91 is: Give gifts to guests, and after that I will pay the Band, because the wedding party is over, and I applied the same Wedding Calendar to this task as the Task 91 have

image_thumb15

Finally, I will set up 05.09.2011 as a start date for the Task: Pick up The Photos and Pay for them, because I can pick them first working date, after the wedding.

image_thumb17

 

That is it. We have a schedule! If you want to download this mpp file, you can do it here: http://dl.dropbox.com/u/35142216/The%20wedding.mpp

From now on, I will torture you with the Resources!

Best Regards,

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, MS PROJECT 2010, PMI, PRoject Management | Tagged , , , , | 3 Comments

The “Wedding” Project! Building the Schedule? – PART 5 (we are almost at the finish)

 

Hi,

In my previous post I have explained that Task no 6: “Call the guests by phone to the wedding” is a Predecessor of lot of other Tasks. I will again apply a filter to see those task:

image

Because there are many of them, I decide to assign all those task to the “Wedding agency”, and it means that I have decided that the wedding couple will not perform or conduct all those tasks by themselves, because it will take a lot of time, and the wedding will be too late. Instead of that I will hire the “Wedding agency”, and that means that the agency has a capacity to conduct all those tasks (with predecessor no 6).

OK. If you remember my wedding should be at Saturday. So I have to examine in my Project plan the nearest Saturday. I have to find know ending date of my project according to my current Project Plan:

image

So, the end date id 29.08.2011. And I suppose that I will find the wedding chapel and the Restaurant which is available the nearest Saturday to that end date. And this is 03.09.2011.

Now the fun begins. There are a couple ways to solve these problems. I will make NOW new calendar for “wedding” tasks:

image

and then I will erase exceptions:

image

No I will set working time from Saturday 08:00 to 00:00 and Sunday from 00:00 to 00:00:

image

and:

image

and finally:

image

Now I will assign this new calendar to my “wedding” Tasks:

image

and I will get:

image

As you can see the start date is 06.08.2011. But this is not what I want.

First I will make a 03.09.2011 as a start date (because THIS IS RIGHT SATHURDAY FOR THE WEDDING):

image

But I still have to fix some things.

And I will fix them in my next blog post.

I promise the next blog will be the last one with the scheduling of my “Wedding” Project!

Until then,

 

Best Regards,

Posted in MICROSOFT PROJECT, Microsoft PRoject 2010, MS PROJECT 2010, PMI, PRoject Management | Tagged , , , , | 4 Comments

The “Wedding” Project! Building the Schedule? – PART 4

 

Hi,

If you remember I had (and I still have) a problem with my “wedding” project. I set up a Wedding Saturday , and Wedding Sunday Task Calendars in MS PROJECT 2010. As I said many times before I did it by the purpose, just to show how can you make a mistake in Project Planning. you can read about this in my blog https://ntrajkovski.wordpress.com/2011/09/12/the-wedding-project-how-to-set-up-calendars-in-ms-project-2010-and-why-part-4/

What was the Idea? As I said, we want to have wedding at Saturday. The party will begin after the wedding, and it will finish at Sunday. When? Who knows?! I was at the wedding party at 17.09.2011 and the party was started at 20:00 and finished next day (Sunday at 08:00). Using a Task Calendar in this situation is not the best approach.

So I will move them out from my tasks, and then I will erase them. Why am I doing that? Because I wanted, and I still want to show different (good, and bed) approaches when using MS PROJECT 2010.

image

I will select them all and remove those calendars:

image

Since I don’t need those two Calendars I will erase them from my Project file. Remember, you can do it only with Organizer.:

image

Now I have to calm down, and resolve my schedule problems. What are they?

1. I have a lot of task which can start immediately after task “Decide the Initially Budget and size and Style of the Wedding. Decide who pays for what” is finished, and after task: “Call the guests by phone to the wedding”. Why? Because at that moment I will know answer to the question: “HOW MUCH MONEY DO I HAVE?”, and the question: “HOW MANY GUEST WILL I HAVE?”. Those task are:

image

OK! Now the trick! I want to see all tasks with Predecessors NO 2, and only them. I can do it with filter:

image

and you will get:

image

Finally you will get:

image

Now I have to decide what to do! I can not Find a Hairdresser and Beautician, Find The Photographer, Find a Jewelry store, choose the Rings and Decide on engraving, and Decide where to go to honeymoon at the same. day! Those are tasks no: 32,69,73, and 77.

I will now turn the filter off:

image

and you will get all your task back on the screen:

image

I have decided to make those task sequential: Task 69 will have Task 32 as Predecessor, Task 73 will have Task 69 as Predecessor, and Task 77 will have Task 73 as Predecessor.

You can see those tasks now:

image

image

image

image

image

As you can see they are in sequential order now.

OK. This problem is solved. What with Task no 6: “Call the guests by phone to the wedding”? It is a Predecessor of lot of other Tasks. That will be explained in my next blog post. And after that we will know the wedding date and we will be ale to schedule unscheduled tasks.

 

Until then,

 

Best regards,

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