Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

P3 to Excel conversion

2 replies [Last post]
Wed, 2004-05-26 23:05
Doug Norton
User offline. Last seen 19 years 42 weeks ago. Offline
Joined: 20 May 2004
Posts: 3
Groups: Petro-Chem / Oil & Gas
Need instruction on converting P3 to Excel and back again.
Also S curve in P3 with bar chart.
ttereve91@yahoo.com
Top

Replies

Thu, 2004-05-27 10:28
#1
MK TSE
User offline. Last seen 3 years 47 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
By RA, which is available in CD, can export P3 into Excel format.
The revised data in Excel can be imported back to P3.
Top
Thu, 2004-05-27 13:50
#2
Luca Basile
User offline. Last seen 9 years 12 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
To make the s-curve in P3, with the bar chart, use the View->Resource profile (CTRL+F7) option.
Then in the window select the resource You want to show in Your gph, as well as the display option.
To have it print, in page set up You have to flag in the “Resource/Cost display”

To exchange info between P3 and excel You can also do in other two way:
- importing and exporting the information You need;
- Using the ODBC driver capability.
Over the RA engine as per mktse post.



I hope is what You were looking for.
Top