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.

Generate S-Curve & MPL

6 replies [Last post]
Thu, 2006-09-07 01:24
Redzuan Samsudin
User offline. Last seen 14 years 20 weeks ago. Offline
Joined: 27 Jun 2006
Posts: 11
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Good day

Q1 : How do I extract data from P3 (or let P3 generate) to create S-Curve.?

My usual method in MSP is listed below;
1 - VIEW | TASK USAGE
2 - Copy Work Hours distribution from day 1 to project complete sate.
3 - Paste in Excel & gnerate S-Curve (progress %) as Excel Chart.

Q2 : Can P3 do it per WBS/Activity Codes or discipline etc.?

Q3 : How do I generate Manpower Loading (unlevel) in P3.

MSP method:
1 - VIEW | REPORTS
2 - WORKLOAD | RESOURCE USAGE
3 - CROSSTAB
3.1 Row = Resources, Peak Unit
3.2 Column = 1, Days

All input very much appreciated.

Cheers
Top

Replies

Mon, 2006-09-11 09:45
#1
John Lawson
User offline. Last seen 11 years 42 weeks ago. Offline
Joined: 6 Oct 2004
Posts: 113
Groups: Petro-Chem / Oil & Gas
Hi

If you check out and follow reply of the 07-Sept..

You should then be able to export the data from P3 in an Excel format.

The data will be by manhours by time period (i.e. how you have specified - weekly/monthly etc).

You then need to add rows etc and set up the standard calculations for working out percentage complete etc.


Regards

John
Top
Sun, 2006-09-10 19:08
#2
Alex Wong
User offline. Last seen 11 years 48 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Hi

Try the method suggested by us. That will give you a good S-Curve facility, especailly in Layout View.

Alex
Top
Thu, 2006-09-07 08:33
#3
HASHIM ODIPATTIL
User offline. Last seen 14 years 47 weeks ago. Offline
Joined: 25 Dec 2005
Posts: 3
Groups: Petro-Chem / Oil & Gas
I would like to extract percentage completion distributed by time-period from Primavera. Can anybody help me?
Many thanks in advance.

Hashim
Top
Thu, 2006-09-07 05:38
#4
John Lawson
User offline. Last seen 11 years 42 weeks ago. Offline
Joined: 6 Oct 2004
Posts: 113
Groups: Petro-Chem / Oil & Gas
Hi

To view in Layout you will need to go into "Page Setup" and tick the box "Resource/Cost Dispay".

The layout will display the Histogramme / Curve at the bottom of the schedule. It is verry effective for a high level plan especially if displayed on a single sheet.

To get the data as you require you need to use the "select" and "dispay" buttons, can be a bit of a problem when first setting up.

Regards

John

Top
Thu, 2006-09-07 04:20
#5
Alex Wong
User offline. Last seen 11 years 48 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Just 2 points as well:

1. You can view the S-Curve in Layout as well (View - Layout)

2. Remember to you save period actuals

Then you S-Curve will have a more accurate result in Earned Value and Actual.

This concept is differ from MSP

Alex


Top
Thu, 2006-09-07 02:12
#6
John Lawson
User offline. Last seen 11 years 42 weeks ago. Offline
Joined: 6 Oct 2004
Posts: 113
Groups: Petro-Chem / Oil & Gas
Hi

Q1 : How do I extract data from P3 (or let P3 generate) to create S-Curve.?

Try: Tools / Tabular Reports / Resource / Loading

You will need to set up the P3 window options with your resources / selection etc. Once run it will generate a stread sheet format that you can make into S’Curve / Histogram etc, and save as excel format etc

Or try: Tools / Tabular Reports / Resource / Tabular

This will give you a hard copy of data, that you will need to key into a Curve etc.


Q3 - Paste in Excel & gnerate S-Curve (progress %) as Excel Chart.

Yes - see above - just add calculations to the excel spread sheet.

Q2 : Can P3 do it per WBS/Activity Codes or discipline etc.?

Yes, its all done when you set up the P3 windows, its a bit messy first time, but try using the P3 Help option if you get stuck.

Q3 : How do I generate Manpower Loading (unlevel) in P3.

Use the above, the info generated is in Man hours so just set up your excel spread sheet with a simple calculation.

regards

John

Top