[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 770
  • Last Modified:

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 Olivares
Jaime Olivares
  • 2
1 Solution
Hello Jamie,
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.

Looking at the first snapshot you see that the first task (Functionality X) has a duration of 55 days and the Task Type has been set to Fixed Work.
Notice in the second snapshot when we change the Units for the assigned resource (Developer 1), the Duration (and Finish Date) is reduced accordingly.
I think this is the response you are looking for.  If not, elaborate...
Bob Segrest
PMP, MCITP, MCT, Microsoft Project Blackbelt


Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now