Skip to content
ProjectControls.com
Microsoft Project

Progressed bar does not give the correct result

In the Open Standard
Andrew OwensonMember for 20 years 11 months
Created
4
5
0
This has probably been asked before, but I will ask again. I have a chart in which I am comparing planned against actual. the planned start is 05.06.07 the duration is 54 days and the planned finish is 17.08.07. I have run a macro giving the planned % as 35. The actual start is 25.06.07, the actual % is 33% this gives a remaining duration of around 36 days. However, the progress bar has moved to 25.06.07 thats ok, but the progress infill goes to a third of the bar but the end date for the bar is still 54 days away from the 25.06.07. It should be 36 days from 02.07.07. If I have done a third of the duration in the first week surely the duration should adjust itself to reflect the remaining duration ??

Andrew
Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    James Griffiths ·
    #1
    Hi Andrew,

    The % Complete of duration is actually a bit funny in the way it calculates it at summary level. However, in essence, it looks at the durations of each individual activity and calculates the summary based on the sum total of those durations.

    Example: two activities. A1=20 days, A2=10 days. Total activity days = 20+10=30 days. If A1=20% complete (4 days) and A2=80% complete (8 days), the summary % Complete will be [4+8]/30= 40% Complete. It DOES NOT look at the duration of the summary bar itself.

    HTH

    James.
    Report
  2. 0
    Andrew Owenson ·
    #2
    James

    Thanks for replying, the bar is not a summary bar its a normal activity bar. my main point being is that I have done a third of the duration in the first week, but the progress shows a third done but over the whole original period, which makes the end date for that activity wrong. The progress line is showing that the activity is ahead of programme % wise but finishes late due to the late start.

    Best Regards

    Andrew
    Report
  3. 0
    Nicolas Igersheim ·
    #3
    Hi Andrew

    Didnt you check the
    "fixed duration" on that task? ({Shift}{F2})
    In that case it seems normal that the duration
    does not change?

    hth

    Nicolas
    Report
  4. 0
    Kamarul Bahrin Hassan ·
    #4
    Hi Nicolas,

    A)please check your calender day.. did you put any holiday ?

    B) go tool > option > calculation ... check all the command.


    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?