open the project

select Projects

then Resource Assignments

select your resource on the left 

roll up your resource 

on the right select what ever time scale you want months, weeks etc.

on the right click on the first month and the summary number press shift and control hold it down scroll to the right until you get to the last month or week with any data in it and highlight that data (STILL HOLD SHIFT AND CONTROL)

then select edit and copy 

now paste into excel 

 

 

Dear All,

 

Please I need to Extract Resources ( Manpower & Equipment ) Milestone wise can any one help me with step by step procedure.

 

Thanks

Khan

Dear all.

How we can creat Global Change with colum name 1 week look ahead but value in this colum we get from data Resour Usage Spreadsheet ?

Yes I can, I havent try daily, but spread by week, month and years are the one I always used comparing both baseline and current project on a timely basis. Levelled resources using external is the one I also havent tried. I can automatically update resource budget, actual, remaining and progress.

David,


Others may say it correct and others may say it difficult specially if they are not familiar on how to set tabular report, selecting columns and fields to show, selecting the spread range, group & sorting and filtering of what data to select. An advance user like you or me which know how to customize the report even without the used of the wizard then I will definitely agree with you because once it was created properly according to required data and suit to the report required. It can also run every week without pressing any button and by the used of job services it will run automatic on the set time period required and automatically email it to the recipients.

But for the beginners, defends on their perceptions and capability.

Hi David,

You mentioned only one of the ways to get the report but there is a lot of ways even without opening Primavera itself. I used excel SDK which is much faster, complete and error free. I can have it by WBS, Account code, Activity code and even by resource code or resource without any hassle and just a press of a button even Primavera is not opened. It can be spread by weeks, months or year and produce S-Curve at the same time.

The method I posted is the most basic procedure (copy & paste) which can be done easily by every one. To mentioned the some of the other ways are by using ODBC, database, SQL and other external software interfaced with Primavera.

Glenn,

As Ferdinand say, it is just highlight, copy and paste from P6 to excel spreadsheet. You might be on the wrong module that is why it is not working.

Here are the simple steps:

1) Click the assignment icon on the left or select Project -> Resource Assignment on the menu.
2) Select View and make sure Resource Usage Spreadsheet is tick.
3) Organise (Sort & Group) the way you want to copy it on the spreadsheet.
4) Highlight all by pressing Ctrl+A then press Ctrl+C to copy.
5) Open your excel and on place the cursor to 1st cell or any where on the spreadsheet where ever you want to place the data then press Ctrl+V to paste.

It should copy and paste the data that you have on P6 to Excel

hi

try resource assignment from directory view

open layout activity resource assignment

you can copy this to excel now