Earned value Analysis?

Hi Kalpesh,



Add resource = WEIGHT in dictionary.



To assign WEIGHT to all activities, use Global Change (Explained below)



Keep IF statement blank & in THEN Statement, Add resource EQ WEIGHT. And run the Global Change.



Use Global Change Again, and write this statement:



If RES EQ WEIGHT



THEN BQ EQ OD





For calculating WEIGHTAGE REPORT refer to post # 3.



Global Change is best explained in P3 / P6 Help. Global Change is not covered in detail in any of the books.



But, make sure u create a back-up before using Global Change.



HTH



Cheers,



Ravi

Hi Ericson,



&T1 is a temporary variable i have used to store the the value.



To run the global change, there are two statements: IF & THEN



In If Statement: use



IF SUBP EQ A

AND RES EQ WEIGHT



In THEN Statement: use



&T1 EQ BQ / z (Sum of all Durations for Phase A)

BQ EQ &T1 * 8



You dont need to write "z" in THEN statement. z=Sum of all durations for Phase A. This value u can calculate by exporting Phase A & then summing up in Excel. Use this value instead of "z".



Cheers,

A very basic question, how to assign resource EQ weight and BQ = OD

Hi Raviraj,



This is very interesting topic going on.



Currently i am working for one big project, where i am calculating Physical percentage via excel,but for getting forecast end date i have to update P6. I always wanted that P6 should calculate the accurate physical perecntage.But i was not aware of teh same. I would be very thankful to you if you explain more to us how to assign the weigthages in P6 and get the end result. Or else send some manual for the same.



My email id is [email protected].



Your input will be highly appreciated.

Hi Ericson,



Weather u do that in excel or in P3, values will always match.



Always 1+1=2



I generate reports using REPORT WRITER and it covers following items:



Weightage Description

Percent Complete

Budgeted Quantity

Planned Cum. Qty. (Or Cost)

Actual Cum. Qty (Or Cost)

Planned This Period (Or Cost)

Actual This Period (Or Cost)

Remaining Qty. (Or Cost)

Planned Finish

Forecast Finish

Variance



Sometimes, u may end-up with doing some mistakes in excel either in formula or during copy-paste. This is not the case with P3. P3 has pre-defined formula, all in-built, so there is no chance of making any mistakes.



Yes, with P3 you can’t make good presentations, but u can tally with what is there in excel.



BTW, my values always match. If it is not matching, then it means there is some mistake in my excel calculation.

The process explained in post#3, is based on pre-defined weightages.



Sometimes, if you are purely doing it on duration basis or on cost basis, you may get some wrong values.



You can draw both the duration and cost curves and then make your best judgement.

Hi Ericson,



Weather you do it in excel or P3, process remains same.



What you can do is this:



- Add resource EQ Weight for all activities and BQ = OD



- Say, there are 13 main sub-phases from say A to I. You can assign weight factors to each of these sub-phases depending on projectv complexity and past experience.



- Assume, u hav assigned 8% for Phase A.



- Run a Global Change

IF SUBP EQ A

RES EQ WEIGHT



&T1 EQ BQ / (Sum of all Durations for Phase A)

BQ EQ &T1 * 8



- Run it.



- Run Similar Global Changes for each sub-phase.



- Generate Earned Value Reports covering data like Planned Cum Qty., Act Cum. Qty., Planned This period, Actual this period, Remianing Qty, Planned Finish & so on others. (Whatever u require)



Note: To calculate sum of all durations for each phase, filter Phase-wise and then export the data to excel and sum it up.



Cheers,



Ravi

Wts. based on what? costs?; durations?; units? You can tailor the wts. to how your software calculates progress.