Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Task Duration question

Status
Not open for further replies.

greg13

Technical User
Mar 9, 2010
2
US
If I have a duration of 1600 hrs, what can I do to have the duration automatically reduce, based on the number of resources assigned to the task.
 
It's as easy as 1-2-3.

First: you need to know this formula
W = U * D
U = W/D
D = W/U

Work = Units * Duration
Units = Work/Duration
Duration = Work/Units

Work is the amount of effort spent to do the task
Duration is the calendar time between the Start and Finish of the task.
Units is the number of resources assigned to the task.

There is a task field called "Type"

If you set task Type to Fixed Work
change Units and Project recalculates Duration
change Duration and Project recalculates Units.
If you set task Type to Fixed Units
change Work and Project recalculates Duration
change Duration and project recalculates Work.
If you set task Type to Fixed Duration
change Work and Project recalculates Units
change Units and Project recalculates Work.

So the first thing you need to do is set the task type to "Fixed Work" or "Fixed Units". If you set it to Fixed Duration then any changes you make will not affect the duration.


Second, you need to know about the "Effort Driven" flag

Effort Driven checked means "share the work among the resources"

Effort Driven unchecked means "each resource is doing his/her work".


Third, you need to know that the flag is in effect *ONLY* when you add a new resource to a task or delete an existing resource from a task.

Now you're ready to go:

1. Set the task Type to fixed duration (as discussed above).
2. Set the Effort Driven flag to checked if the existing amount of work is to be shared among all resources when a new resource is added/deleted.
3. Add your new resource.


 
Sigh ... I accidentally hit "Submit" when I meant to hit "Edit".

There's a *serous* error right at the end.

I wrote:

"1. Set the task Type to fixed duration (as discussed above)."

I should have written:
"1. Set the task Type to anything EXCEPT fixed duration (as discussed above)."

Sigh. Sorry if I've inconvenienced anyone.
 
Wow! Excellent!
This formula and it's definition was never explained to me. That makes things crystal clear...Thanks Much!

Greg
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top