Jaime Olivares
asked on
Microsoft Project - How to use "work units" and have calculated duration
Hello all,
I am stuck with this for a while:
We have a software project which is defined by "work units", like:
- Functionality X: 55 Work Units
- Functionality Y: 36 Work Units
- etc.
A "work unit" has a fixed duration based on developer Performance, like: 1.5 units per day
What I want to do is to enter Start Date and Work Units, then MS Project should calculate the End Date.
I have the Start Date column, as well and End Date (which I want to be a calculated column), but don't know how to enter the Work Unit and the Performance.
Please help me to identify the proper column names and/or dialog fields.
Thanks in advance,
Jaime.
I am stuck with this for a while:
We have a software project which is defined by "work units", like:
- Functionality X: 55 Work Units
- Functionality Y: 36 Work Units
- etc.
A "work unit" has a fixed duration based on developer Performance, like: 1.5 units per day
What I want to do is to enter Start Date and Work Units, then MS Project should calculate the End Date.
I have the Start Date column, as well and End Date (which I want to be a calculated column), but don't know how to enter the Work Unit and the Performance.
Please help me to identify the proper column names and/or dialog fields.
Thanks in advance,
Jaime.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This could be fairly straight forward...
Project scheduling is driven by a simple formula. Duration (elapsed time) multiplied by Units (people) equals Work (effort). Determine any two points, apply a little basic algebra and you have an answer. In your case we come up with Work divided by Units equals Duration.
snap1.png