Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Comparison between Planned & Actual Progress

23 replies [Last post]
Wed, 2010-07-07 03:48
Athar Hashmi
User offline. Last seen 3 years 32 weeks ago. Offline
Joined: 21 Mar 2009
Posts: 38
Groups: Civil Engineering
Dear friends
How can I show Planned Progress and Actual Progress in columns? For actual i can show Performane % complete but for baseline which % type i have to choose
Top

Replies

Tue, 2011-12-06 12:56
#1
Bert Ella
User offline. Last seen 10 years 13 weeks ago. Offline
Joined: 16 Feb 2011
Posts: 21
Groups: Civil Engineering, Pinoy Planning Planet Community

Rodel, 

 

It's Great! I tried ur instruction. It Works!

 

Thanks and Regards,

Top
Thu, 2011-10-20 11:06
#2
AB Timo
User offline. Last seen 9 years 5 weeks ago. Offline
Joined: 22 Jun 2011
Posts: 108
Groups: None

Rodel,

Thanks for the sharing information.one issue if you further clarify.

Activity spreadsheet window- --> right click ---> spreadsheet option ---->click "calculate average" --->here i have to enter 1853469.89 (cost is 185346989 Sr / 100 = 1853469.89) , but it is not taking complete value i,e not taking more than 5 digits number). can you check this option and solve the issue????

 

Regards,

Top
Wed, 2011-10-19 14:19
#3
zhang ting
User offline. Last seen 6 years 14 weeks ago. Offline
Joined: 24 Aug 2011
Posts: 11
Groups: Petro-Chem / Oil & Gas

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!

 

 

 

   

Top
Sat, 2010-07-10 08:45
#4
Rodel Marasigan
User offline. Last seen 1 day 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
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.
Top
Sat, 2010-07-10 08:28
#5
Anbin Ponnith
User offline. Last seen 8 years 5 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
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
Top
Sat, 2010-07-10 07:55
#6
PINAN T.
User offline. Last seen 5 years 44 weeks ago. Offline
Joined: 20 Jul 2007
Posts: 102
Groups: Pinoy Planning Planet Community
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)."
Top
Sat, 2010-07-10 07:12
#7
Anbin Ponnith
User offline. Last seen 8 years 5 weeks ago. Offline
Joined: 8 Jun 2009
Posts: 158
Groups: Civil Engineering
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
Top
Sat, 2010-07-10 05:51
#8
Athar Hashmi
User offline. Last seen 3 years 32 weeks ago. Offline
Joined: 21 Mar 2009
Posts: 38
Groups: Civil Engineering
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 %
Top
Sat, 2010-07-10 04:24
#9
Rodel Marasigan
User offline. Last seen 1 day 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Athar,
For Plan % use Schedule % complete and for Actual % use Performance % Complete.
Top
Sat, 2010-07-10 03:04
#10
Athar Hashmi
User offline. Last seen 3 years 32 weeks ago. Offline
Joined: 21 Mar 2009
Posts: 38
Groups: Civil Engineering
Hey Rodel,
I want to show the Percentage in WBS band also. for this which percentage i’ve to use for Planed & Actual?
Athar
Top
Fri, 2010-07-09 05:53
#11
Rodel Marasigan
User offline. Last seen 1 day 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Alfon,
If you follow my instruction on my post #8 you should have same result.
Top
Fri, 2010-07-09 03:48
#12
Alfon Lyndon Joson
User offline. Last seen 7 years 5 weeks ago. Offline
Joined: 28 Mar 2004
Posts: 35
Groups: None
Rodel

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

Regards

Alfon
Top
Thu, 2010-07-08 05:37
#13
Rodel Marasigan
User offline. Last seen 1 day 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Joel,
Why you need to do that when it’s already available in P6 without any manual progress like you did?
See sample below:
Plan Prog

Best Regards,
Rodel
Top
Thu, 2010-07-08 03:53
#14
Joel Villanueva
User offline. Last seen 12 years 6 weeks ago. Offline
Joined: 7 Mar 2010
Posts: 21
Groups: Civil Engineering, Pinoy Planning Planet Community
Rodel,

Plan % will be the baseline activity % complete to be updated manually according to planned progress % complete without moving the data date.
For showing the time scale interval IMHO, this need to be done by attaching another copy of baseline program updated according to plan. In p6 u can show up to 2baseline % Complete (BL Project & BL1) so you will have 2 update period comparison of Actual and Plan % complete. The only setback is your limited for only two update interval.

Regards,
Joel
Top
Thu, 2010-07-08 02:21
#15
Rodel Marasigan
User offline. Last seen 1 day 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Joel,
On your approach how can you show Plan % on timescale interval?

Note: Schedule % Complete is Plan % based on Baseline and datadate.
Top
Thu, 2010-07-08 02:11
#16
Joel Villanueva
User offline. Last seen 12 years 6 weeks ago. Offline
Joined: 7 Mar 2010
Posts: 21
Groups: Civil Engineering, Pinoy Planning Planet Community
Athar,

Okay, manually update your baseline % complete but DON’T run schedule the planned dates will not move and you can show BL%compelte.

HTH,
Joel
Top
Thu, 2010-07-08 01:56
#17
Rodel Marasigan
User offline. Last seen 1 day 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
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)
Top
Thu, 2010-07-08 01:35
#18
Athar Hashmi
User offline. Last seen 3 years 32 weeks ago. Offline
Joined: 21 Mar 2009
Posts: 38
Groups: Civil Engineering
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.
Top
Thu, 2010-07-08 01:09
#19
Joel Villanueva
User offline. Last seen 12 years 6 weeks ago. Offline
Joined: 7 Mar 2010
Posts: 21
Groups: Civil Engineering, Pinoy Planning Planet Community
Athar,

Make a copy of your baseline program update it as progress as planned then run schedule to move the data date same as your current program. Make this as your Project baseline or Primary baseline, you can now show Baseline column % Complete as your planned % complete compared to your current progress. Hope this will help.

Regards,
Joel
Top
Wed, 2010-07-07 23:51
#20
Athar Hashmi
User offline. Last seen 3 years 32 weeks ago. Offline
Joined: 21 Mar 2009
Posts: 38
Groups: Civil Engineering
Dear
My program is cost loaded & resource loaded
Top
Wed, 2010-07-07 09:10
#21
Rodel Marasigan
User offline. Last seen 1 day 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
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.
Top
Wed, 2010-07-07 06:46
#22
Athar Hashmi
User offline. Last seen 3 years 32 weeks ago. Offline
Joined: 21 Mar 2009
Posts: 38
Groups: Civil Engineering
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?
Top
Wed, 2010-07-07 04:59
#23
Rodel Marasigan
User offline. Last seen 1 day 1 hour ago. Offline
Joined: 25 Oct 2006
Posts: 1699
Groups: Petro-Chem / Oil & Gas
Schedule % Complete = Planned % Complete. Terminology change depends on which Industries selected when installing P6.
Top