Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Resources By Labour Group

1 reply [Last post]
Moses Otito
User offline. Last seen 10 years 33 weeks ago. Offline
Joined: 17 Aug 2013
Posts: 4
Groups: None

How do I extract information from MS Project 07 Pro on resources by labour group from a schedule for the duration of my project?

Replies

Ellen Lehnert, Mi...
User offline. Last seen 5 years 47 weeks ago. Offline
Joined: 12 Feb 2011
Posts: 20
Groups: None

If the Labor group was entered into the group fiield on the resource sheet for the resources that field is populated on the task information when an assignemtn is made.  The field is called Resource Group.  Open the file and save as Excel type.  You will then start the export wizard.  Select that the data should come from Taskand that the exported file should have headers.  Then pick the field names that you would like to export.  If you select the start and finsih date that will be the dates the and end dates for the tasks.  As long as you add the resource group you should be able to group the data in Excel.  This same data could also be grouped in Project using the grouping for the Resource group field.

I hope this helps.