Welcome to Planning Planet, checkout the Guild of Project Controls Knowledge CAR

How to export Resource Usage Spreadsheet from P6 to Excel?

13 replies [Last post]
Nithin Shetty
User offline. Last seen 1 year 30 weeks ago. Offline
Joined: 31 Aug 2004
Posts: 34
Groups: None

Hi Friends,

You are all doing gr8 job helping others.

Can anyone kindly tell me how can I export 'resource usage spreadsheet' from P6 to Excel? Please note that these are resources allocated to portfolio of projects not one project.

I have tried this through reports. But I can't save report as it is showing a message that as the data belongs to multiple projects, report can't be saved.

I really need to export resource usage spread sheet from P6 to Excel. Is there any other convenient way to do so?

thanks in advance. 

Kind Regards,

Nith

Replies

Chris Radecki
User offline. Last seen 6 days 3 hours ago. Offline
Joined: 11 May 2005
Posts: 30

Thanks Zoltan,

 

for other members,  it was the Ctrl + A which seemed to do the trick

 

The Ctrl + C was not copying consistently,  without fiirst doing this.  Maybe a small issue in Primavera ..... or maybe me.

Chris Radecki
User offline. Last seen 6 days 3 hours ago. Offline
Joined: 11 May 2005
Posts: 30

Thanks Zoltan,

 

for other members,  it was the Ctrl + A which seemed to do the trick

 

The Ctrl + C was not copying consistently,  without fiirst doing this.  Maybe a small issue in Primavera ..... or maybe me.

zoltan palffy
User offline. Last seen 3 days 20 hours ago. Offline
Joined: 13 Jul 2009
Posts: 846

go to project resource assignments roll it up highlight the data press control C then go to excedl press control v

Chris Radecki
User offline. Last seen 6 days 3 hours ago. Offline
Joined: 11 May 2005
Posts: 30

Thanks to Sirichai Somthong...

I searched on google for primavera copy to excel from resource assignments

I had an issue with copying  and pasting from resource assignments to excel.  '

I had summarised to a summary level and the selection was just not sticking.

 

It was the Point 2 of his reply Press Ctrl+A that was the missing step.

 

Here it is again .  Thanks.

 

Dear Nith Shetty,

Just you copy from Assigement Resource window in P6. as following steps.

1.You have to be on Assigement Resource window  first.

2. then Press Ctrl+A

3.Press Ctrl+C

4.Paste on Excel

Hope you will be succesfully as the above steps.

Nice to meet you.

Best Regards,

Sirichai S.

Skpye name: josirichai

zoltan palffy
User offline. Last seen 3 days 20 hours ago. Offline
Joined: 13 Jul 2009
Posts: 846

go to project resource assignments 

then select the column that you wish to display budged unit or costs

summarize the data roll it up 

click on the first month that a value appears

Highlight that month and the value below it

press and hold shift+control 

then use your mouse and select the last month and the last value appears 

now select edit then select copy 

go to excel and select paste or control+C

Brandon Atkins
User offline. Last seen 36 weeks 6 days ago. Offline
Joined: 30 Nov 2011
Posts: 8
Groups: None

Copying and pasting works fine for the "Activity Usage Spreadsheet" but does not work for the "Resource Usage Spreadsheet".  Excel asks to use an import wizard after pasting, but no combination of options seems to result in the data being copied.

The difference is whether the resource hours are grouped by the resource or by the activity.

Does anyone know how to export from "Resource Usage Spreadsheet"?

Abuder Shambo
User offline. Last seen 2 years 31 weeks ago. Offline
Joined: 11 Jun 2011
Posts: 8
Groups: GPC Qatar

Thanks

Abuder Shambo
User offline. Last seen 2 years 31 weeks ago. Offline
Joined: 11 Jun 2011
Posts: 8
Groups: GPC Qatar

Thanks

Abuder Shambo
User offline. Last seen 2 years 31 weeks ago. Offline
Joined: 11 Jun 2011
Posts: 8
Groups: GPC Qatar

Thanks Nith Shetty,

Abuder

Dost Hyd
User offline. Last seen 3 years 40 weeks ago. Offline
Joined: 22 Jul 2011
Posts: 4
Groups: None

It would be great if you can share that with the rest of the group.

 

Thanks.

Nithin Shetty
User offline. Last seen 1 year 30 weeks ago. Offline
Joined: 31 Aug 2004
Posts: 34
Groups: None

Thanks Sirichai,

It's working. However I have found an alternate way to do this.

Thanks again.

 

 

 

Sirichai Somthong...
User offline. Last seen 1 year 39 weeks ago. Offline
Joined: 17 Nov 2009
Posts: 4

Dear Nith Shetty,

Just you copy from Assigement Resource window in P6. as following steps.

1.You have to be on Assigement Resource window  first.

2. then Press Ctrl+A

3.Press Ctrl+C

4.Paste on Excel

Hope you will be succesfully as the above steps.

Nice to meet you.

Best Regards,

Sirichai S.

Skpye name: josirichai

Nithin Shetty
User offline. Last seen 1 year 30 weeks ago. Offline
Joined: 31 Aug 2004
Posts: 34
Groups: None

Hi All,

In continuation to my above query, the specific message shown when i tried to save the report is "You may not save a project-level report while you have more than one project open".

I am struct here. Please suggestions people.

Thanks.

Kind Regards,

Nith