Export Resource Usage with task name RRS feed

  • Question

  • I am using Project 2010.  I am trying to generate an expected workload by task for each resource in my schedule.  I am able to use Visual Reports to create a pivot table in Excel that will allow me to view total work by week.  Is there a way to include information about the tasks being worked by the resource on the same report?  For example:

    Resource 1     Week 1   Week 2   Week 3

         Task 1         40           10           0

         Task 2          0            10          10

         Task 3          5            25           10

         Total            45           45          20

         Rem. Availab.-5           -5           20

    Resource 2


    Friday, June 23, 2017 6:44 PM

All replies

  • Hi,

    When you say in the same report, do you mean in the same Excel file? If so, you could go to Visual reports and simply export the assignment cube file (*.cub). Then in your existing Excel report, create a new pivot table using the cube data source. So you can have in the same Excel file both task and resource usage.

    Hope this helps,

    Guillaume Rouyre, MBA, MVP, P-Seller

    Saturday, June 24, 2017 6:24 AM