Results 1 to 9 of 9
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Houston, Texas
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Percent that Should Be Complete (2000/SR-1)

    How do I determine the % of the project that should be complete as of a given date? I want to compare this to the % Complete to see what the variance is.

    Thanks,
    Caroline

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Percent that Should Be Complete (2000/SR-1)

    Try comparing the fields % Complete to % Work Complete.
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Star Lounger
    Join Date
    Nov 2001
    Location
    Houston, Texas
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Percent that Should Be Complete (2000/SR-1)

    That doesn't seem to work. What I am trying to reach is one percentage that represents actual overall progress against target overall progress as of a given date. Our tasks are duration-driven.

    Thanks,
    Caroline

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Percent that Should Be Complete (2000/SR-1)

    OK, we need to clarify a few items. How are you measuring progress? Based entirely on task durations or are you taking the resource loading into consideration as well? You may actually need two percentages. One measures progress as in duration of planned vs actual, the other measuring work based on resources. Is this what you are after? How are you measuring the actual work complete. Are you putting in a percent complete and letting MS Project do the calculations or other means?

    Sorry for the questions but I need to get a better grip on what you are trying to accomplish before I can try to answer the question. What may help is posting an example such as for Task A, Duration is 100 Days. Percent complete is 60%. Baseline Duration is 200 Days. What would the percentages be? I am sure we can get this to work.
    Regards,

    Gary
    (It's been a while!)

  5. #5
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Percent that Should Be Complete (2000/SR-1)

    OK, Strictly speaking in terms of duration and ignoring the work completed by resources, lets review what we have to work with.

    Fields available are:

    Baseline Start, Baseline Finish, Baseline Duration, Start, Finish, Duration, and Percent Complete.

    You could do a calculation that does the following:
    Baseline - (Calculate number of days from Task Baseline Start to Current Date)/Baseline Duration *100 to get a percentage of where you should be based on the baseline and compare this to

    Start - (Calculate number of days from Task Start to Current Start)/ Duration * 100 to get a percentage of what is really happening.

    I would also do a comparison of Baseline Duration / Duration to review if the task duration has increased or decreased.

    You should also review the current percent complete.

    Thus, your analysis would have the following for each task:

    % Complete, Calc Baseline % Complete, Calc Start % Complete, Current % Duration as compared to original duration.

    Hopefully, this will give you some ideas.
    Regards,

    Gary
    (It's been a while!)

  6. #6
    Star Lounger
    Join Date
    Nov 2001
    Location
    Houston, Texas
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Percent that Should Be Complete (2000/SR-1)

    Gary, I'm sorry but I'm not understanding the equations that you provided. I think that I am not using the right fields or I am not putting the parentheses in the right places in the formulas.

    For the first formula, I am using:

    [Baseline Start]-([Baseline Start]-[Current Date])/[Baseline Duration]*100

    but am receiving an error message #ERROR.

    For the second formula, I am using:

    [Start]-([Baseline Start]-[Start])/[Duration]*100

    but again am getting #ERROR.

    Can you please let me know what I am doing wrong?

    Thanks,
    Caroline

  7. #7
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Percent that Should Be Complete (2000/SR-1)

    Try something like this.
    - Add the Number1 field to the gantt chart and right click on it
    - Select Customize Fields
    - Select the Number1 Field
    - Under Custom Attributes, Select the Formula Radio button and press the Formula Button
    - Input the Following Formula and press OK

    (now()-[Baseline Start])/[Baseline Duration]*100

    Now() - Baseline Start determines the days used since the baseline start date. Divide by Baseline Duration and multiply by 100 to get the percentage. This formula shouldn't be used on tasks that start in the future as it will give negative results.

    This is a start. I don't know if I would truly go this way but it may meet your needs.

    Let me know if this works or you want to try another work around.

    HTH
    Regards,

    Gary
    (It's been a while!)

  8. #8
    Star Lounger
    Join Date
    Nov 2001
    Location
    Houston, Texas
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Percent that Should Be Complete (2000/SR-1)

    I found something that works perfectly in the Microsoft KB Q137673. It's a macro that uses DateDifference to calculate Planned % Complete. If you already are using the Text1 field though, you will need to change it in the macro, as it writes the Planned % Complete into this field.

    Thanks for all of your help!

    Caroline

  9. #9
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Percent that Should Be Complete (2000/SR-1)

    Glad you found what you were looking for. The equation I gave you essentially does the same thing, but the macro is much more elegant.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •