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.

Export Resource/Cost Assignment to Excel format.

8 replies [Last post]
Wed, 2011-03-02 10:24
tandyo winarno
User offline. Last seen 13 years 9 weeks ago. Offline
Joined: 14 Jul 2009
Posts: 25
Groups: Petro-Chem / Oil & Gas

Dear All,

 

Would you please advise me how to export Resource/Cost Assignment shown from Assignment menu on the Directory Bar?

 

 

Thanks

Tandyo

Top

Replies

Fri, 2011-03-04 05:26
#1
tandyo winarno
User offline. Last seen 13 years 9 weeks ago. Offline
Joined: 14 Jul 2009
Posts: 25
Groups: Petro-Chem / Oil & Gas

Thanks a lot Arend.

I follow your guidance and it works.

 

 

Regards,
Tandyo

Top
Thu, 2011-03-03 23:51
#2
Arend Kok
User offline. Last seen 10 years 19 weeks ago. Offline
Joined: 19 May 2008
Posts: 38
Groups: Petro-Chem / Oil & Gas

Tandyo,

 

You can also use the report wizzard to set up the fields over the time distribution you need and then output the report to a csv file.

 

Regards,

Arend.

Top
Thu, 2011-03-03 02:59
#3
tandyo winarno
User offline. Last seen 13 years 9 weeks ago. Offline
Joined: 14 Jul 2009
Posts: 25
Groups: Petro-Chem / Oil & Gas

Thanks All,

 

You are right. It works.

I tried on other machine (local database) and it works.

I work in the server database and can not work for such function. 

 

Thanks

Tandyo W. 

Top
Wed, 2011-03-02 12:22
#4
Amit Parmar (PMP)
User offline. Last seen 11 years 33 weeks ago. Offline
Joined: 12 Nov 2010
Posts: 94
Groups: None

Hi,

You can try exporting data to an excel sheet, using the export function. You can design the template and set the data you want to export based on filters and columns

Regards

Amit Parmar

check out my blog on Primavera at http://www.primaverablog.in

Top
Wed, 2011-03-02 12:19
#5
Amit Parmar (PMP)
User offline. Last seen 11 years 33 weeks ago. Offline
Joined: 12 Nov 2010
Posts: 94
Groups: None

Hi,

What all data do you want to export from Primavera?

 

Regards

Amit Parmar

Check out my blog on Primavera at http://www.primaverablog.in

Top
Wed, 2011-03-02 12:07
#6
Raymund de Laza
User offline. Last seen 34 weeks 2 days ago. Offline
Joined: 23 Nov 2009
Posts: 762
Groups: Civil Engineering, Pinoy Planning Planet Community

Hi Tandyo,

I am using P6 and it works well by selecting, copy and paste. In the excel, I can see the loads in time intervals.

272
excel.png

 

Top
Wed, 2011-03-02 11:08
#7
tandyo winarno
User offline. Last seen 13 years 9 weeks ago. Offline
Joined: 14 Jul 2009
Posts: 25
Groups: Petro-Chem / Oil & Gas

Thanks Raymund,

I already did, however it works only for resource description shown in the screen shot at upper left while it doesn't work for the resource assignment shown in upper right (resource assignment for every month/day) 

 

 

Regards,

Tandyo

Top
Wed, 2011-03-02 10:42
#8
Raymund de Laza
User offline. Last seen 34 weeks 2 days ago. Offline
Joined: 23 Nov 2009
Posts: 762
Groups: Civil Engineering, Pinoy Planning Planet Community

Hi,

Select Resources>>> Copy >>> Paste in excel.

 

Hope this will help.

 

Regards,

 

Raymund

Top