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.

export from P3 into xls including grouping structu

6 replies [Last post]
Sun, 2005-05-29 03:16
Eckart Schenck
User offline. Last seen 5 years 17 weeks ago. Offline
Joined: 25 May 2005
Posts: 28
Groups: None
Hi,

is there a way to export a P3 schedule to excel without losing the grouping structure?

Thanks!

Heinz
Top

Replies

Wed, 2005-10-05 22:40
#1
Zhang Haixiang
User offline. Last seen 4 years 36 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
What you need to do is just sort your activities then add a group title.

if you have too many to add, try excel’s outline worksheet function.( I’m using excel 2002,it has the ability to group rows/columns)
Top
Fri, 2005-09-30 11:57
#2
MK TSE
User offline. Last seen 5 years 2 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Is web publish is an alternative?
Top
Sun, 2005-05-29 07:24
#3
Razi Khan
User offline. Last seen 8 years 38 weeks ago. Offline
Joined: 17 Jun 2004
Posts: 74
Groups: None
Then why don’t you give report in pdf format instead of Excel.
Top
Sun, 2005-05-29 04:12
#4
Eckart Schenck
User offline. Last seen 5 years 17 weeks ago. Offline
Joined: 25 May 2005
Posts: 28
Groups: None
I’m familiar with sorting by act codes in xls.

The problem comes when you communicate with somebody who doesn’t know well the act code structure and doesn’t have P3 either. In such case it would be good to have an excel export with the grouping...

Heinz
Top
Sun, 2005-05-29 03:49
#5
Razi Khan
User offline. Last seen 8 years 38 weeks ago. Offline
Joined: 17 Jun 2004
Posts: 74
Groups: None
Hi,

Export with "Activity Code" Columns also and then sort and group in Excel as per requirement.

Cheers.
Top
Sun, 2005-05-29 03:47
#6
Jaco Stadler
User offline. Last seen 18 years 35 weeks ago. Offline
Joined: 9 Sep 2004
Posts: 299
Groups: None
Henk Export the Activity Codes as Well then when you are in XLS you just sort or Subtotal By Structure
Top