Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

Lesson Learned in P5

8 replies [Last post]
armando moriles
User offline. Last seen 14 years 22 weeks ago. Offline
Joined: 2 Feb 2003
Posts: 66
Groups: None
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

Replies

Kamyar Sanandaji
User offline. Last seen 14 years 25 weeks ago. Offline
Joined: 17 Oct 2004
Posts: 6
you Bet
armando moriles
User offline. Last seen 14 years 22 weeks ago. Offline
Joined: 2 Feb 2003
Posts: 66
Groups: None
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
Kamyar Sanandaji
User offline. Last seen 14 years 25 weeks ago. Offline
Joined: 17 Oct 2004
Posts: 6
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.
armando moriles
User offline. Last seen 14 years 22 weeks ago. Offline
Joined: 2 Feb 2003
Posts: 66
Groups: None
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,
Anoon Iimos
User offline. Last seen 3 years 29 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
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...
armando moriles
User offline. Last seen 14 years 22 weeks ago. Offline
Joined: 2 Feb 2003
Posts: 66
Groups: None
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
Oliver Melling
User offline. Last seen 5 years 44 weeks ago. Offline
Joined: 24 Apr 2007
Posts: 595
Groups: The GrapeVine
Run CSV to excel and manipulate there.

Everyone in your company will have excel.
Anoon Iimos
User offline. Last seen 3 years 29 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
do it in excel