Comparison between Planned & Actual Progress

Schedule % Complete = Planned % Complete. Terminology change depends on which Industries selected when installing P6.

i want to compare planned with actual. planned %age will be same as per the status date but actual %age can be more or less or equal depending upon the actual site progress. I want to show both progress, e.g planned is 50% and actual is 40% without changing any date. How can I do this?

Athar,
If your Program is not resource loaded or cost loaded you will not get the planned % complete every month without moving data date. You have to resource load or cost loaded your schedule first.

Dear
My program is cost loaded & resource loaded

Joe
It’s okay. But when i change the activity %complete, dates are changing. i don’t want to change the dates. i want to keep activity date and duration same as it is mentioned.

Athar,
You can use Activity Usage Spreadsheet and Select the following Fields:
1) Under Cumulative and Time Interval ->Earned Value Group:
->Cum Plan Value Cost or Unit
->Cum Earned Value Cost or Unit
->Plan Value Cost or Unit
->Earned Value Cost or Unit

Note: Earned Value is your Physical Progress (Actual)

2) Right click on Spreadsheet table and select Spreadsheet Option then Tick Calculate Average and enter the Budget Unit or Budget Cost over 100 and under unit of measure enter % then click apply or Okay.
Ex: Total budget cost = 10,000,000 /100 = 100,000

It should display the Plan Value and EV % cumulative and time interval. You can change the name to Plan% and Act% if you want.

Note: to match the Progress display on Activity Window Column you must have same cut-off date as timescale.
Ex: Timescale = Monthly = Datadate = July 30 2010 05:00PM
Timescale = Weekly should match on setting First day of the Week (i.e. Mon cut-off/datadate = Sun or Sat)

Joel,
On your approach how can you show Plan % on timescale interval?

Note: Schedule % Complete is Plan % based on Baseline and datadate.

Joel,
Why you need to do that when it’s already available in P6 without any manual progress like you did?
See sample below:


Best Regards,
Rodel

Rodel

Hi, how did you manage to set up the percentages on the lower right area.

Regards

Alfon

Alfon,
If you follow my instruction on my post #8 you should have same result.

Hey Rodel,
I want to show the Percentage in WBS band also. for this which percentage i’ve to use for Planed & Actual?
Athar

Athar,
For Plan % use Schedule % complete and for Actual % use Performance % Complete.

dats fine Rodel,
now one thing more. Why the activity usage spreadsheet showing percentage more than 100(%)? As per your post # 8, I divide the activity usage by 100 and unit of measure %

Dear Rodel,

I have tried this option before.But I faced a problem of entering the number of digits.I could not enter more than 6 digits.

eg.. My project value is 158000000
& For the month is 9675000


Regards,

Anbin

hi athar

this was solved by Arnold Puy already in one of his posts in the forum:

"1. Let say you have 10 digits (e.g. 1234567890).
2. In this case, you can only have the 6 digits as a whole number but you can have as many numbers with decimals places (e.g. 123456.7890).
3. In order to convert the decimal into whole number, you need to delete the period/dot (.) using (<-) backspace or delete on your keyboard.
4. Just simply point your cursor in between the 6 & 7 numbers and delete the point/dot using the No. 3 step. The result 9e.g. from 123456.7890 to 1234567890)."

Hai Pinan T
1.Thanks For ur reply its Work where my Total budget cost 15800000
I gave divide interval by 1580000 & Its Works Fine.
In Another project I am having Total Budget cost of
343509538 .I am able to type as whole number
I want to Divide interval by 3435095.38(to show as 99.77%) its not working
I am able to add decimal only after 6 digit

Regards
Anbin

Anbin,
The technique is to type the 6digit then decimal and add the rest of the number. Remove the decimal but if you required seven digits remove the others and it should work fine. Decimal is nothing if you have more than 6 digit whole number. You should get 100% equivalent.

Mr Rodel：

   I  followed your instruction on your post #8, but after i entered unit of measure "%" ,the unit % of Plan Value and EV % can't display . Moreover how to change the magnitude of the value of Plan Value and EV % Ex: from "1" to "1.00%"                               

    Best regards!