resource export for project only

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

Gr8,

Thanks a ton Arnold.

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?

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

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

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 arnoldpuy31@yahoo.com and I’ll do it for you and also I will attach the steps on how to do it.

HTH

Regards,

Arnold