#1
|
|||
|
|||
Export Resource Usage sheet into excel
I need to know if anyone knows how to export the resource usage view into excel pivot table. I have attached a file as an example
|
#2
|
|||
|
|||
The file you have attached is not a pivot table - just a table. You can export the resource usage view to Excel as a pivot table using Visual Reports. What version of Project?
|
#3
|
|||
|
|||
I am using MS Project 2016. I understand the file was not a pivot table, but it is the information I am looking to export. I couldn't find out how to do it in the visual reports.
|
#4
|
|||
|
|||
sorry. Not sure if I replied properly.
I am using MS Project 2016. I understand the file was not a pivot table, but it is the information I am looking to export. I couldn't find out how to do it in the visual reports. |
#5
|
|||
|
|||
You'll need to use a Visual Report based upon the Assignment Usage cube. Try the following:
1. Create a visual report selecting "Baseline Work report" 2. Set the level of usage to Days and click View to create the report. 3. Click the Assignment Usage tab in Excel to view the Pivot table. 4. In the Pivot Table field list - select Resources to add the display of resource names. 5. If necessary - drag the Resources to Rows and place it above the Tasks. 6. Drag the Weekly calendar from Filters to Columns and place above the summary values. 7. Turn off Baseline work and actuals. 8. Hide columns and/or rows as needed. Regarding the lack of New template option - sorry - I don't know what is up with that. I hope this helps. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy resource usage to excel | cossie2k | Project | 1 | 11-29-2015 10:05 AM |
Resource Usage View - Is it possible to display resource names | Andrea Schanz | Project | 6 | 09-22-2014 07:47 AM |
Resource Usage view does not correctly export to a Visual Report | cergon | Project | 3 | 04-25-2014 06:10 AM |
Exporting Resource Usage data to Excel | samg54 | Project | 1 | 08-02-2013 05:28 AM |
Resource Usage sheet - options | Andy Bain | Project | 1 | 11-05-2010 12:42 PM |