none
Calculating Actual Duration from Actual Work RRS feed

  • Question

  • Hi everyone,

    Please advise of how Project calculates Actual Duration from the known Actual Work by using the Scheduling Formula Work = Duration * Units.

    For example:

    • If there is a 5-day fixed units task Mo - Fri  with 2 full-time resources R1 and R2 assigned  to it.
    • Resource R2 has a non-working Wednesdays set thought its personal calendar
    • After resources are assigned to the task, Project re-calculates task's Duration from 5d to 6 days ( to account for 1 non-working day of R2),  and Work as 80h (40h per resource)

    Now I enter %Work Complete values for resources: 60% for R1  and 20% for R2 that Project translates into Actual Work values: 24h for R1, and 8h for R2

    Project calculates Actual Duration  as 2 days .

    Please let me know of how it doe it.

    Thank you,

    Alex

    Tuesday, October 25, 2016 11:53 PM

Answers

  • Alex,

    If R1 and R2 have completed 60% and 20% respectively, that means they have completed a total of 32 hrs (actual).

    Assuming each resource's maximum work hours/day is 8 hours then 16 hours will be total actual work per day for both the resources. Now 32 hrs (16*2) is completed it means 2 days of actual duration is displayed.

    You may check Task Usage and Resource Usage views by adding actual work, actual duration and %work completed columns for more clarity.

    Hope your question is clarified.

    Regards,

    Sudhir


    Wednesday, October 26, 2016 4:08 AM

All replies

  • Alex,

    If R1 and R2 have completed 60% and 20% respectively, that means they have completed a total of 32 hrs (actual).

    Assuming each resource's maximum work hours/day is 8 hours then 16 hours will be total actual work per day for both the resources. Now 32 hrs (16*2) is completed it means 2 days of actual duration is displayed.

    You may check Task Usage and Resource Usage views by adding actual work, actual duration and %work completed columns for more clarity.

    Hope your question is clarified.

    Regards,

    Sudhir


    Wednesday, October 26, 2016 4:08 AM
  • Hi Sudhir,

    So basically Actual Duration = Actual Work / Units = 32h / 200% = 2d

    Thank you,

    Alex

    Wednesday, November 2, 2016 12:12 AM