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.

%complete of baseline condidering the weight factors...

1 reply [Last post]
Fri, 2015-01-02 17:31
Nassir Sh
User offline. Last seen 9 years 37 weeks ago. Offline
Joined: 1 Jan 2015
Posts: 6
Groups: None

Dear Friends,

I need to display the %complete of the "baseline" AND "actual %complete" and I need the formula to consider the weight factors of the activities as well. I have tried many formulas, but they end up displaying "ERROR" or 100% completed (even for the activities that have not been started yet in the baseline).

I am really in a hurry, please help me solve this problem.

Thank you

Top

Replies

Mon, 2015-01-12 14:42
#1
Leonardo Caoile
User offline. Last seen 3 years 11 weeks ago. Offline
Joined: 11 Jul 2011
Posts: 22
Groups: Civil Engineering, Pinoy Planning Planet Community

Dear Nassir,

I presume that you put your weight factors in the "Cost" field and it is showing 100 at the Project Summary Level.

If yes, then just insert the column "BCWS" and rename it as "Planned % Progress". Then insert another column "Actual Cost" and rename it as "Actual % Progress".

 

If you have a Cost-Loaded schedule, then you need to customize 3 fields (e.g. Cost1, Cost2, and Cost3)

1) Insert these 3 new columns (try Cost1, Cost2, and Cost3)

2) Rename the columns with "% Wt.", "Planned % Complete", and "Actual % Complete", respectively.

3) Right click on the title, then select "Customize Fields" (a pop-up window will open).

4) In "Custom Attributes" select "Formula" (another pop-up window will open)

5) Assuming the total Baseline Cost of the project is 4,500,000.00, try to do the following:

For Cost1, type-in: ([Baseline Cost]/4500000)*100

For Cost2, type-in: ([BCWS]/4500000)*100

For Cost3, type-in: ([Actual Cost]/4500000)*100

 

6) For "Calculation for Task and Group Summary Rows", select "Use Formula".

7) While updating, type-in the "% Complete" for related tasks on any given "Status Date" and you shall see the desired results.

 

There are tons of complex formulas that you can use but I like it this simple and It works for me. I hope it would help solve your problem.

 

Cheers,

Leonardo

Top