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.

Calculating Overall Planned Progress

6 replies [Last post]
Thu, 2005-01-13 07:27
kamran hazini
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 10 Jan 2005
Posts: 38
Groups: Petro-Chem / Oil & Gas
Hi there;
My client is asking me to provide them with a report, including planned perecent complete and actual %complete for each activity and overally.
I defined a report in Report Writer to calculate planned perecnt complete by this formula: BCWS/BQ. Now the problem is that this way works for all activities perefct but the overall planned progress could not be calculated and P3 added all these figures for all activities instead of calculating the formula for overall project. I can ask my cleint to devide the overall BCWS by overall BQ manually but I think it is not very convenient.
Did anybody encounter this problem before or any solution for that?
Thanks
Top

Replies

Sat, 2005-01-15 23:59
#1
Jaco Stadler
User offline. Last seen 17 years 27 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
Hi it is very easy.

1) Make a copy of your schedule.
2) Update this schedule automatic (Crtl f9)
3) Assign it as a Target (2)
4) Ask column Target (2) Percent Complete
5) Even if you summarize now it will be correct

So evry week you must just remember to update Progress in the Target 2 Schedule.

Cheers
Top
Sat, 2005-01-15 04:41
#2
kamran hazini
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 10 Jan 2005
Posts: 38
Groups: Petro-Chem / Oil & Gas
Yes you are right. I can calculate and store these planned figures for each activity in a custome data coulmn.
My problem is that P3 can not caluclate it for overall project.(a total %) If you summerize, it shows you all these values added (for example 2400!) I want a figure between 1-100%.
Top
Fri, 2005-01-14 10:37
#3
Dayanidhi Dhandapany
User offline. Last seen 3 years 4 weeks ago. Offline
Joined: 18 Mar 2003
Posts: 470
Groups: None
you can’t find the direct variable of planned % in P3 but you can use global change to represent your calculation and that can be stored in a custom data variable.

HTH
Top
Fri, 2005-01-14 10:37
#4
Dayanidhi Dhandapany
User offline. Last seen 3 years 4 weeks ago. Offline
Joined: 18 Mar 2003
Posts: 470
Groups: None
[Duplicate posting deleted by Moderators.]
Top
Fri, 2005-01-14 02:24
#5
kamran hazini
User offline. Last seen 11 years 32 weeks ago. Offline
Joined: 10 Jan 2005
Posts: 38
Groups: Petro-Chem / Oil & Gas
Thanks for your reply but anyhow if there was any built-in column as Planned %Complete my problem would be solved with your proposed method.
The point is that P3 is not calculating planned progress. It says only planned value (BCWS) which is useless for my client. They are concerned about the progress not value. Could you please inform me where I can find planned %complete coulmn in accordance with my target file? Thanks
Top
Thu, 2005-01-13 09:29
#6
Dayanidhi Dhandapany
User offline. Last seen 3 years 4 weeks ago. Offline
Joined: 18 Mar 2003
Posts: 470
Groups: None
you can use P3->Tools->Option->summarization option to choose the required parameter and use Organisation option and choose "Project" in the group by area and then in the total option to choose "Top" to show overall progress.
(Note: If you set your proper target schedule in the target area, you can display both planned and actual progress as explained in the above manner)
Top