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.

Filtering and export to excel

3 replies [Last post]
Fri, 2009-11-20 12:02
Christian Viddal
User offline. Last seen 14 years 46 weeks ago. Offline
Joined: 24 Sep 2009
Posts: 24
Groups: Petro-Chem / Oil & Gas
Hi,

Was wondering if someone could help me with a task regarding exporting.

I want to filter out all the activties due in one week and export it to excel together with all colums. I am sitting in Release:6.2(terminal server)

Appreciate if someone could explain it step by step as I have never done exporing to excel before but I have heard it is possible.

Thanks
Christian

Top

Replies

Mon, 2009-11-23 06:56
#1
Arnold Puy
User offline. Last seen 10 years 20 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community

You are welcome..

Top
Mon, 2009-11-23 05:43
#2
Christian Viddal
User offline. Last seen 14 years 46 weeks ago. Offline
Joined: 24 Sep 2009
Posts: 24
Groups: Petro-Chem / Oil & Gas
Perfect, thanks a lot!

Top
Sat, 2009-11-21 01:48
#3
Arnold Puy
User offline. Last seen 10 years 20 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Christian,

You can simply go to Project Menu --> Resource Assignments, try to display all the columns you required by simply right click --> Columns --> Customize. To filter the One (1) week look-ahead try these parameters:

(Any of the following)

Where:      Start “is within range of” DD DD+1WK
Or:      Remaining Early Start “is within range of” DD DD+1WK

When done, go to Edit --> Select All and then right click copy and paste it to Excel sheet.

Or you may try to go to File --> Export --> Spreadsheet - (XLS) and follow the window wizard.

Regards,

Arnold

Top