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.

GLOBAL CHANGE - WBS

3 replies [Last post]
PRASAD KUKUNURI
User offline. Last seen 35 weeks 5 days ago. Offline
Joined: 24 Feb 2013
Posts: 11
Groups: None
Hello frineds,
 
Hope you all are doing great.
I Have construction Acitivtes (Physical %) which are assinged with labor Units (Direct) & Cost not loaded. That means during the update of scheudle I will have BL Units, Planned Units, Earned Units. Now I would like to see Activity Plan % & Earned % at the activity level, WbS & SubWBS  level also.
So, I have created One UDF as integer and I applied the Global change 
UDF = Planned units/BL Units * 100%; This is successed for Acitivity level. But How to get the Plan % & Earned % at the WBS Level ?
 
Finally My goal is see the Plan % & Earned % at the Acitivy & WBS level also.
 
Hope I have cleared myself.
 
Thanking you.
 
Prasad -
prasad.e3@gmail.com

Replies

David Kelly
User offline. Last seen 7 weeks 3 days ago. Offline
Joined: 19 Oct 2004
Posts: 563

Prasad,

 

I only use two of the twenty % complete fields in layouts:

Performance % complete is Earned Value  (BCWP/BC * 100)

Schedule % complete is Planned Value  (BCWS/BC * 100)

Note that thees are both cost related. If your baseline was created before you made each resource $1.00 per hour, Schedule % complete will not roll up.  You may need to:

Restore the baseline

Reset the resource costs (under the "tools" menu in the windows client)

make it a baseline again

 

PRASAD KUKUNURI
User offline. Last seen 35 weeks 5 days ago. Offline
Joined: 24 Feb 2013
Posts: 11
Groups: None
Dear David, Iam greatful to your reply. Thank u somuch. I will immediatly assign a cost to the units ( @ 1 $/MHr) & I will check. & I hope it will roleup gives me the Plan % at Activity/WBS level also. But, can u please suggest me that for which Field (Column name) I can see the Rollup % or If I needs to apply what will be the Global change Formula for the UDF " Plan %" .? Thanks again. Prasad
David Kelly
User offline. Last seen 7 weeks 3 days ago. Offline
Joined: 19 Oct 2004
Posts: 563

Prasad,

My understanding of your query is that you are doing Earned Value Analysis in Manhours, not Money.

That you cannot see summary values suggests you are using P6.

P6 does not do earned value in quantity properly.

You will need to set the value of all resources to $1.00 per hour in both the current and baseline plan.

Then you will see the WBS  values, weighted by cost but with $1.00 per hour, cost=quantity