I received a message from one of my reader. It states:
I have been reading through your posts but could not really find back an answer on an problem I’m puzzled with.
Let’s say I have a project for performing a testdrive on a prototype car. The testdrive project itself is made up by a series of tasks. The tasks need to be performed by a testdriver (work resource) but he also needs the car to do it. So the testdriver is one resource, the car is the other. I both need them to perform the task, assigning the car resource to the same tasks as the testdriver should not reduce the time it takes to perform the task or should not reduce the workload of the testdriver.
Also another difficulty, the car is not available constantly (it is used by other divisions of the company) so I would like to auto schedule the tasks according to the availability of the car.
Lets say the project takes 10 days in total, but the car is only available 2 days in the first week, 3 days in the second week and 5 days one moth later.
Is there a way to do this ?
Thank you for your valuable response.”
OK! Let me fix this issue.
First let me do the setup.
I will add three Tasks:
and then two Resources:
Be aware that your Tasks are NOT effort driven. Select all Tasks, and then remove effort driven check mark:
I will use Task Calendar! Suppose that you want to perform your testing from 05.03.2012 to 06.03.2012 (2 days), then from 12.03.2012 to 14.03.2012 (3 days), and then from 02.04.2012 to 06.04.2012 (5 days).
I will make a brand new Calendar and I will call it Car Testing:
Now I will fix working days in a way that I will make exceptions:
Now I will assign Resources to my Tasks:
and I will make a Schedule for my project:
Now I will assign my Car Testing Calendar to all of my Tasks:
and I will get:
As you can see, I got what I wanted. Task 1 will be performed at first week, Task 2 in second week, and Task 3 in next month!
And since my Task are not effort driven, time and work are not reduced:
You should keep in mind that if a Task is effort driven but you assign both resources at once, duration and work remains the same. But if you first add one Resource to the Task, and after some time you add another resource then duration and/or work will be shortened, which depends of your task type (fixed units, fixed work or fixed duration), and you can read about this in my previous posts!
Second option is to use Resource Calendar! You want to perform your testing from 05.03.2012 to 06.03.2012 (2 days), then from 12.03.2012 to 14.03.2012 (3 days), and then from 02.04.2012 to 06.04.2012 (5 days).
I will make an exception for the Car Resource since it is available for the testing to the Test Driver Resource in these particular days!
Now I will add those Resources to the Task 1:
Now I will add the same Resources to the Task 2:
Notice that duration is now 4 days instead of 3, because my Car Resource is not available from 07.04.2012 till 11.03.2012, and it is over allocated from 05.03.2012 till 06.03.2012 (because this Car can not be used for Task1 and Task2 at the same time!)
Now I will immediately use Task Inspector. I will right-click on the Task2 and then:
and I will get:
Now the Task 2 has 3 days duration from 12.03.2012 to 14.03.2012 (3 days), and everything is OK.
Finally, I will add Resources to the Task 3, and I will get:
You can see that I have same problem as I had with second Task. I will apply the Task inspector as I did it before, and I will get:
Hope this wad helpful!
Thanks for the wonderful post. Searching your Blog has become my everyday activity.
Can you please let me know how you performed this setp
“and I will make a Schedule for my project:”
Is there any automaic way to do it in MS project.We are using ProChain Tool to do it.
I don’t understand your question. Can you be more specific?
Thanks, and Regards