Earned value Analysis?

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

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

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.

Thanks anoon and ravi, we based these wts on duration. I agree with you ravi that duration basis of wts sometimes give wrong values, so what we do is we just put a weight percent per program on our own judgement and compute progress in excel using this wts.Im also using that BQ=OD in global change, my question is when you update primavera the product is not the same with what we computes in excel? thats why they dont require us or should i say they want basis on the computation of progress and that is not shown in p3 or p6 ryt?correct me if im wrong so we use this wts per program as computation. About the scheme you presented ravi, i will check on that, I think i havent tried that yet. Thanks a lot guys...

Cheers!!

ERic

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.

Hi Ravi,

Thanks again for your response. Ya, ive seen your point already and im lacking of pre-defined formula you jst said.

May i know what does &T1 stands for?I knew somethings missing hir and could not see whats the problem and i cnt run it. Im talking about your formula in post no 3 in global change. I think thats the reason why our values doesnt match in P3 and excel.

Hey ravi, I really appreciate your help and greatful that there r people like you willing to help. Thank you so much guys!

Cheers.

Regards,
Eric

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 Kalpesh.Dalvi@kcm.co.zm.

Your input will be highly appreciated.

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

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,

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