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 Ill do it for you and also I will attach the steps on how to do it.
When you say to use Resource Assignment, do you mean modify the report RA-01 Resource Assignments, All Activities? Ive 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.
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?
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.
Member for
18 years 6 monthsRE: resource export for project only
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 Ill do it for you and also I will attach the steps on how to do it.
HTH
Regards,
Arnold
Member for
22 years 4 monthsRE: resource export for project only
Hi Arnold
When you say to use Resource Assignment, do you mean modify the report RA-01 Resource Assignments, All Activities? Ive 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
Member for
18 years 6 monthsRE: resource export for project only
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
Member for
22 years 4 monthsRE: resource export for project only
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?
Member for
18 years 5 monthsRE: resource export for project only
Gr8,
Thanks a ton Arnold.
Member for
18 years 6 monthsRE: 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