Skip to content

Lesson Learned in P5

Armando MorilesMember for 23 years 8 months
Created
8
4
0
Guys,

I’m currently using P5, and I just wanted to share a little lesson I learned myself in using P5 regarding a report that our project required. With this, I am also hoping that I could get comment(s) or correction(s) from anybody if what I did is the right or best practice...

Case:
I’ve been doing a weekly summary bar chart report (P5) containing BL & remaining bars and at the bottom is the Activity Usage Profile based on cost or value showing the histograms of actual, bl & estimated plus the s-curve.

Problem:
My big boss required an additional report using exactly the same format but containing the % accomplishments instead of the values (y axis 0% to 100%).

Solution:
Step 1. I created a copy of the programme for both baseline and working;
Step 2. Using global change: budget cost/total budget * 100;
Step 3. Store performance period performance because it created negative this period values;
Step 4. Change the currency symbol to %.

The above did worked for me although I had a hard time debugging the curve at the start ’coz it won’t reach 100%, only 96%. Later I found out that several activities zero out durations after the global change.

Penalty:
Although it generated the report, but the penalty is that I’ll be updating both files each week (just a 2,500 activity contract programme).


Again,any best practice comment(s) or correction(s) to what i did would be highly appreciated.


Many thanks in advance...

Regards,

Arman

8 replies

Oldest first
  1. 0
    Anoon Iimos ·
    do it in excel
  2. 0
    Oliver Melling ·
    Run CSV to excel and manipulate there.

    Everyone in your company will have excel.
  3. 0
    Armando Moriles ·
    Thanks a lot for your comments guys, I apologize that I forgot to say in the first time that I did tried in excel but it was rejected because the big boss wants it exactly the same format. In other words, it can’t be excel but Primavera only...

    Regards,

    Arman
  4. 0
    Anoon Iimos ·
    so this is where your communications skills will come in, i.e. convincing power, you can explain to your boss that you are applying some kind of flexibility...
  5. 0
    Armando Moriles ·
    That won’t be possible either cause the big boss is in Hong Kong. I haven’t even seen him personally. Our project manager here at site an expat himself have clear instruction to generate the report as requested which is a very rare case in our company’s organization that the guy did asked such report.

    But that’s a good suggestion, engineering communication...I do admit struggling specifically breaking that communication barrier as English is not really our language.

    Regards,
  6. 0
    Kamyar Sanandaji ·
    If you want to show your graph bty % there is no need to change your buget! just simply on your "activity usage profile" window right click on your curves then from the menu select "Activity Usage profile Options..." on the Graph Tab at the bottom you will see an option to check "Calculate average".

    Check that, then put a devisable number based on your total budget there so after calculation from your Total you see the Total 100% in your Curve.
  7. 0
    Armando Moriles ·
    Kamyar,

    That was great!!!...You know, it took me 2 days to solve my problem in the very long way around with headache. Where in fact it is only a 10 seconds job doing it the right way...

    Really appreciate your help...


    Regards,

    Arman
  8. 0
    Kamyar Sanandaji ·
    you Bet

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?