resource export for project only

A
A D 👤 Member for 19 years 1 month
Oracle Primavera - PM6
A
Arnold Puy 👤 Member for 19 years 2 months
· Permalink

Hi Alan,



What I mean, in your Assignments Icon located at the left corner of your screen, you can select all the activities or filter the activities you wanted & hit CTRL+C to copy and paste it to Excel sheet using CTRL+V.



Or you can send me your P5 or P6 files to [email protected] and I’ll do it for you and also I will attach the steps on how to do it.



HTH



Regards,



Arnold

A
Alan Binnie 👤 Member for 23 years
· Permalink

Hi Arnold



When you say to use Resource Assignment, do you mean modify the report RA-01 Resource Assignments, All Activities? I’ve tried various things around what you say but with no success.



Do you have an example of exporting the resource numbers to excel? I would be grateful.

Thanks



Alan

A
Arnold Puy 👤 Member for 19 years 2 months
· Permalink

Hi Alan,



You can use Resource Assignment, after customizing the required column and timescale by day or week you can then

select all the Activities you wanted to export to Excel and select Ctrl+C in your keyboard and open an Excel sheet

& Paste it by using Ctrl+V.



Hope this helps.



Regards,



Arnold

A
Alan Binnie 👤 Member for 23 years
· Permalink

This exports the NAME of the resource, but not the allocation.



Does anyone know how to export the resource allocation spreadsheet to excel, in order to produce decent progress curves? (you know, like in P3?)



I can get a list by activity id which gives the resource allocated to that activity, but I want it listed by resource numbers per day, week or whatever. I can produce that table in P6 by highlighting all the resources and summarising them in the ’Resource Usage Spreadsheet’, but how do I then export THOSE numbers to excel?



Anyone done this in P6?

A
Arnold Puy 👤 Member for 19 years 2 months
· Permalink

Hello Ravs,



Yes. It is possible to export in Excel Sheet.



Open the project you wanted to export resources only which is assigned to your current project. Go to File --> Export --> Spreadsheet - (XLS)--> Next --> Resources --> Next --> Add --> Columns, Filter & Sort. In Filter: Add & Modify, Where "Assigned to Current Project" "equals" "YES" then OK.



Hope this help.



Regards,



Arnold

Forum Sponsor

Top Posters

Trian Asmoro
1 posts
Soheil Barekat
4 posts
Erkan Polater
9 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts