Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

percent complete issue

22 replies [Last post]
Yusuke Kamui
User offline. Last seen 14 years 36 weeks ago. Offline
Joined: 18 May 2008
Posts: 56
Groups: None
Hi,
I’m using P5.
I have a schedule (baseline, let’s call it Schedule A) wherein it was the orignal schedule submitted to the client. In this schedule resources are not loaded and it is simply showing the Start / Finish date of every tasks and the work/units (budgetted units) per task.

Now, I have an actual schedule (let’s call it Schedule B) which we are now using to enter the actuals.

Question is if I want to know our progress in comparison to Schedle A, how to do it? Say today is June 6 and each tasks on Schedule B has some percent % complete how to compare it to Schedule A?

Just like this....
Schedule A:
Task 1: Build wall, Start (May 30), Finish (June 7) = meaning by June 7 should be 100% complete

Schedule B:
Task 1: Build wall, Actual Start (May 30), percent complete only 10% (today is already June 6)

So, how to know the percent complete of Task 1 in Schedule A as of June 6? Like asking a question, if our actual percent complete is 10% as of June 6 (as per Scheudle B), how many % complete we should have been as per the target on Schedule A?



Thanks.

Replies

Barry Fullarton
User offline. Last seen 11 years 1 week ago. Offline
Joined: 27 Aug 2008
Posts: 101
Groups: None
but guys in p6 , how does one apply the global "time" resource , when it doesnt do graphic curves?

and does p6 allow you to asign "time" as a resource, if so how does one doe this

thanks
A D
User offline. Last seen 3 years 51 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Hi guys,

I think actual question was how some will know the planned % complete against actual % complete.

here in the exaple stated, Say Activity 01 in Schedule A is supposed to complete 95% and same Activity 01 in Schedule B is only 10% complete, then he needs a column to display both values.

In that case, u can go to Columns--> percent completes And then add

- Schedule % complete (Planned)
- Activity % Complete (Actual, u have to enter manually or can update in excel if no resources are there)

Daniel,

U Dont require to define OD as BQ in P6. There is an option to define percent complete in DURATIONS. That was required in P3, so that u can compare apple to apple, if resources are not there.

If u want to know duration % complete, then u can add one more column as Duration % complete (Default in P6)

Cheers,

Rav
Alex Wong
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Anoon

Provided if you do not have a base line, your plan % complete is base on your plan date (BL).

If you do have a baseline then its your baseline start and finish date

HTH

Alex
Daniel Limson
User offline. Last seen 5 years 15 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None
Yusuke,

Another way of doing it is to have a common unit of measure so that you are actually comparing eggs against eggs.

Since your baseline programme (Schedule ’A’) is not resource loaded, I suggest you resource load it by using "time" as your unit of measure. In other words your "budgeted quantity" is equal "original duration". YOu can do this using global feature. First you need to define a resource in your resource data, let us call it "time" now using your global feature you can assign "time" as a common resource to all activities. Once you have assigned "time" to all your activities, you then go back to global features and assign budgeted quantity = original duration for all activities. Once you have done this, you now have a resource loaded programme based on time. You can produce a resource tabular report to produce your progress curve using "time" as your units of measure either define per week or per month depending on how often you update your programme. You now have a target plan % complete.

DO the same on your current programme. (Schedule ’B’)But remember that actuals should be measured physically based on estimated quantities.

YOu can use excel to plot your plan % complete and update you actuals on a weekly basis to have comparison and to see how you are doing against your plan.

Regards,
Daniel
Anoon Iimos
User offline. Last seen 2 years 42 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Alex,

mind if i ask you where did you get your formula for planned physical % complete? (post #13)?

Yusuke,

the way I understand it, Planned % Progress (whatever planning unit used) come from Baseline/Target Schedules progressed/updated exactly as planned (using any status/data date).
Yusuke Kamui
User offline. Last seen 14 years 36 weeks ago. Offline
Joined: 18 May 2008
Posts: 56
Groups: None
Thanks Alex, I’ll give it a shot, so basically the "schedule % complete" is the progressed completion of my baseline schedule once I update/scheduled it using P5s "F9" key. That is the expected % completion, right?

Thanks again.
Alex Wong
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
http://img293.imageshack.us/img293/3848/picat8.jpg

As you can see the column schedule % complete can be display without any setting at all ... Yusuke ... may be you need some training to use the system, because simply you dont need to manually calculate the % complete, the system will give you that ....

Ask you boss to enrol you into a P5 course

Alex
Yusuke Kamui
User offline. Last seen 14 years 36 weeks ago. Offline
Joined: 18 May 2008
Posts: 56
Groups: None
Hi Trevor,
Thanks, I’m using P5, but you’re right, it is easy to get what I need using MSP, since there is tool there to progress a given schedule as per the status date. Then automatically calculate the % completion (expected completion) of all tasks. Now I’m using P5 and it’s giving me a headache.

Hi Alex,
Thanks again for your reply, nice graphs by the way. Going back to the issue at hand, so it means to get the expected % complete (duration) I need to manually calculate the % complete (duration) of every tasks of my baseline schedule??


Alex Wong
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
[url=http://img237.imageshack.us/my.php?image=picqb0.jpg][img=http://img237.imageshack.us/img237/8360/picqb0.th.jpg][/url]
Alex Wong
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
[URL=http://img237.imageshack.us/my.php?image=picqb0.jpg][IMG]http://img237.imageshack.us/img237/8360/picqb0.th.jpg[/IMG][/URL]

Yellow s-curve is your plan curve and Green is your remaining (forecast) and Blue is the actual

HTH

ALex
Alex Wong
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Hi Yusuke

Plan % complete is base on your plan start date and plan finish date

Plan Duration % Complete = Total Duration * (Data date - Plan Start) / (Plan finish - Plan Start)

Plan Physical % Complete = Total Physical Unit * (Data date - Plan Start) / (Plan finish - Plan Start)

Plan Unit % Complete = Total labor Unit * (Data date - Plan Start) / (Plan finish - Plan Start)

Since your baseline schedule do not have any resource assignment, you can only use Plan Duration % Complete in the system.

In addition, to assign a baseline you can use baseline - add - use current schedule.

To answer your question with actual unit, you plan % complete (BQTP) calculation did not involve any actual unit, so it doesn’t matter whether your schedule is progress updated or not

HTH

Alex
Alex Wong
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Trevor

Yusuke is not using MSP... Please read it carefully

Alex
Trevor Rabey
User offline. Last seen 1 year 49 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
Did you read my previous suggestion?
Is it clear?
Did you try it?
What was wrong with it?

You want the as planned % Complete as of some given date.
For simplicity say it is today, but it can be any date.
Set the Status Date to that date, select all Tasks and hit the second button from the left on the Tracking Toolbar (Update As Scheduled).
MSP will update every task from its planned earliest start date (ie Start, which will automatically become the Actual Start Date) up to the Status Date.

Re your last line "% complete can either be, Duration or Physical completion". This is absolutely incorrect. It can be only Actual Duration/Total Duration.
Yusuke Kamui
User offline. Last seen 14 years 36 weeks ago. Offline
Joined: 18 May 2008
Posts: 56
Groups: None
Hi Alex,
Thanks for the reply, I already done those things but the main question still remains:

If my actual schedule (Schedule B) is 10% complete as of today, what should have been the expected % complete in reference to Schedule A? How to get the % complete of the baseline schedule (Schedule A) as of today?

Please take note the baseline schedule (schedule A) is constant and we never enter any actuals on that so how to get the % complete of the baseline schedule?
% complete can either be, Duration or Physical completion.


Thanks.


Alex Wong
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Yusuke

I guess you don’t want to compare MSP to P5 - this might be offence to some of the MSP planner. As MSP we refer to as the Mikey Mouse Tools.

What you need to do is to create a baseline using your existing schedule and/or schedule B. Then you can update your schedule with % complete, remaining duration, remaining cost, forecast finish date. Then you change your data date, press F9, save your period performance, then you can compare your progress with the original planned dates, resource loading, forecast finish units / costs...

HTH

Alexx
Yusuke Kamui
User offline. Last seen 14 years 36 weeks ago. Offline
Joined: 18 May 2008
Posts: 56
Groups: None
Hi,
How do you "update progress" in P5?

I found out that in MsProj there is a cool tool called "Tracking - Update Project - Update work as complete through (date range)". Using this I can progress schedule A and comapre it to the actual progress of Schedule B.

Any idea?
Abu Lana
User offline. Last seen 5 years 4 weeks ago. Offline
Joined: 17 May 2008
Posts: 24
Groups: None
Hi all
Why don’t you try "update progress"

Back up a copy of your baseline project, update progress as of D.DATE, and use thiscopy as your new target, the progress will be logicaly updated as linked and will takes the E.S/E.F as actuals. it’s as much like P3.

Hope it will help.
Darren Kosa
User offline. Last seen 7 years 37 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
Trevor,

I think he’s using Primavera (P5).

Regards,

Darren
Trevor Rabey
User offline. Last seen 1 year 49 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
Question is if I want to know our progress in comparison to Schedle A, how to do it? Say today is June 6 and each tasks on Schedule B has some percent % complete how to compare it to Schedule A?

Just like this....
Schedule A:
Task 1: Build wall, Start (May 30), Finish (June 7) = meaning by June 7 should be 100% complete

Schedule B:
Task 1: Build wall, Actual Start (May 30), percent complete only 10% (today is already June 6)

So, how to know the percent complete of Task 1 in Schedule A as of June 6? Like asking a question, if our actual percent complete is 10% as of June 6 (as per Scheudle B), how many % complete we should have been as per the target on Schedule A?

If you mean by "our actual percent complete is 10% as of June 6" that the Actual Duration is 10% of the Total Duration (which is what it means) then your Actual Duration must be 80/100 day. But Sched A says you hoped to have 7 days out of 8, or (7/8)x 100 = 87.5%

You don’t need resources, work, cost or EV to figure this out. This interpretation works easy for MSP.
Trevor Rabey
User offline. Last seen 1 year 49 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
See microsoft.public.project newsgroup for answers to your post there.
Alex Wong
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
% completed can be use as - Duration complete (which is what Ronn describe) however, for this type of activity, it is not applicable.
Unit % Complete - you need to load the resource in order to indciate the true EV. And my guess is your 10% complete is base on either the Unit % Complete or the Physical % Complete.

What I suggest is since you don’t have resource loaded to your schedule, it is still recommended to use the physical / unit % complete to update your schedule B

In addition, you should also update the remaining duration for the activity so the your schedule can reflect a more accurate completion date base on the CPM
HTH

Alex
Ronn Chester Baluyot
User offline. Last seen 9 years 17 weeks ago. Offline
Joined: 27 Feb 2008
Posts: 33
So you say that your programme is not resource loaded.
Task 1 original duration is from May 30-June 7 (assuming all are working days) or 9 days.
In this case, 1 finished day is equivalent to 11.11% completed. So at June 6, 8 days had passed so 8 x 11.11% = 88.88%.
Your 10% completion is equivalent to actually less than of a day of work.