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.

P3 TO EXCEL... URGENT

7 replies [Last post]
Tue, 2007-04-03 18:25
musawar Shaikh
User offline. Last seen 17 years 32 weeks ago. Offline
Joined: 26 Sep 2006
Posts: 14
Groups: Petro-Chem / Oil & Gas
Hi
Can anybody explain me how do we export our p3 project to excell..
Its very urgent
Top

Replies

Tue, 2007-05-29 04:08
#1
Claus Wellendorf
User offline. Last seen 16 years 3 hours ago. Offline
Joined: 13 Nov 2006
Posts: 4
Groups: None
Summary activities can also be made as "WBS type" activities and exported as normal activities to excel. That is of course if you use wbs structure in your project and not only coding
Top
Fri, 2007-04-27 12:29
#2
ESSAM RUSHDI
User offline. Last seen 16 years 29 weeks ago. Offline
Joined: 10 Mar 2006
Posts: 3
Groups: None
To transfer summary tasks with activites:

Activity codes should be exported with activities.

then you can finalized in Excel.

Essam Rushdi
Top
Fri, 2007-04-27 01:29
#3
Amri Mansor
User offline. Last seen 3 years 43 weeks ago. Offline
Joined: 12 Dec 2001
Posts: 18
Groups: GPC Malaysia, Petro-Chem / Oil & Gas

Try use the following function.

=min( ) for start date

and

=max( ) for finish date.

Amri
Top
Thu, 2007-04-26 23:55
#4
Santosh Bhat
User offline. Last seen 28 weeks 15 hours ago. Offline
Joined: 15 Apr 2005
Posts: 381
Groups: Civil Engineering
Your "summary tasks" are not in fact tasks at all, but just the organisational summaries. They cannot be exported.
Top
Wed, 2007-04-04 11:12
#5
musawar Shaikh
User offline. Last seen 17 years 32 weeks ago. Offline
Joined: 26 Sep 2006
Posts: 14
Groups: Petro-Chem / Oil & Gas
Thank you for quick reply.
With the guidance of you I figured out p3 to excel . But still I am unable to transfer summary tasks with activites.
Is it possible? to transfer summary task with activities??
Top
Wed, 2007-04-04 08:08
#6
Anoon Iimos
User offline. Last seen 2 years 46 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
just copy & paste
Top
Tue, 2007-04-03 20:11
#7
Eugene K
User offline. Last seen 13 years 21 weeks ago. Offline
Joined: 18 Oct 2006
Posts: 47
Groups: GPC Malaysia
Tools/Project Utility/Export...
select WHAT u wnat to export
remember to export in WK1 format.

MS Excel can open WK1 files.

but read in a thread that says MS Excel 2007 CANNOT open wk1.
Top