percent complete issue

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

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

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

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).

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

[url=http://img237.imageshack.us/my.php?image=picqb0.jpg][img=http://img237…]

[URL=http://img237.imageshack.us/my.php?image=picqb0.jpg][IMG]http://img237…]



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



HTH



ALex

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

Trevor



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



Alex

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



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

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.

Trevor,



I think he’s using Primavera (P5).



Regards,



Darren

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.

See microsoft.public.project newsgroup for answers to your post there.

% 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

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.