Skip to content

Best way to Export & Review Resources externally from P6

Wullie HendryMember for 12 years
Created
5
5
0

Hi

 

I was some of you guys could give me tips on the best way to export and review resources in Excel & PDF.  I have only ever reviewed the resources on my screen and never used the export features to do so.  After playing around with the export I find it really messy and far to many pages and I was wondering if I was doing something wrong.

 

My exports seem to export the activity in 10 lines if it has 10 resources or 12 lines if it has 12 resources assigned to it.

 

What I am looking to do is to export 1 activity per line and then have the list of resources that are assigned to that activity along with the number of resources assigned and the budget hours assigned for e.g  4 Rigger 100 hours.  1 Crane Op 25 etc etc

 

Can anyone help me?   It's driving me crazy

 

Junior Planner

5 replies

Oldest first
  1. 0
    Zoltan Palffy ·

    select Project then resource

    select Project 

    then resource assignments 

    then you can copy using control - C

    then paste to excel using control - V

  2. 0
    Wullie Hendry ·

    Thanks,   I honestly never

    Thanks,

     

    I honestly never knew you could do that.  However it seems to give me the info the opposite way around from what I require.

     

    Is there anyway it can be sorted by Activity...then show the resources allocated to that activity?

  3. 0
    Zoltan Palffy ·

    yes click on the top of

    yes click on the top of activity id column and it will sort by activity id number

     

    you can also add any column that you wish to add

  4. 0
    Zoltan Palffy ·

    yes click on the top of

    yes click on the top of activity id column and it will sort by activity id number

     

    you can also add any column that you wish to add

  5. 0
    Zoltan Palffy ·

    yes click on the top of

    yes click on the top of activity id column and it will sort by activity id number

     

    you can also add any column that you wish to add

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?