Resource Assignment table copy and paste in Excel

Hi Everybody,

I want to import my resource sheet from excel to P6. 

I made a sample file in p6.Then I exported it to excel. after that I added my resources below it with same format.I imported it back to p6 successfully, but when I come back to resource sheet, They are not added to my resource sheet. Could you please advise me about it?

Thanks,

Hi Everybody,

I want to import my resource sheet from excel to P6. 

I made a sample file in p6.Then I exported it to excel. after that I added my resources below it with same format.I imported it back to p6 successfully, but when I come back to resource sheet, They are not added to my resource sheet. Could you please advise me about it?

Thanks,

Hi Everybody,

I want to import my resource sheet from excel to P6. 

I made a sample file in p6.Then I exported it to excel. after that I added my resources below it with same format.I imported it back to p6 successfully, but when I come back to resource sheet, They are not added to my resource sheet. Could you please advise me about it?

Thanks,

Hi Everybody,

I want to import my resource sheet from excel to P6. 

I made a sample file in p6.Then I exported it to excel. after that I added my resources below it with same format.I imported it back to p6 successfully, but when I come back to resource sheet, They are not added to my resource sheet. Could you please advise me about it?

Thanks,

Hi Everybody,

I want to import my resource sheet from excel to P6. 

I made a sample file in p6.Then I exported it to excel. after that I added my resources below it with same format.I imported it back to p6 successfully, but when I come back to resource sheet, They are not added to my resource sheet. Could you please advise me about it?

Thanks,

My advice is not to use copy/paste at all.

Export the resource assignments using the tabular report wizard, but include the resource calendar for each resource. Then you can use excel to divide the resource quantitis by a factor determined by each resource's  calendar.

You also have a script to do it again with very few keystokes.

Email me if you want detailed instructions

Hi Jean,

That is correct. You can copy paste the unit but not the WYSWYG (using calculate average function).

If you wish to extract the number of resources required you have two (2) options:

Option 1: Run a timescale report output to *.csv file which can be open on excel

Option 2: Copy and paste the unit into excel and use formula to calculate the number of resource (i.e. units/40hrs/week)