Monday, 28 May 2012 9:29 AM
I am using MS Project 2010 with Windows 7 pro. I generate "Resource Usage" reports from the Visual Reports option in the Project tab. For this I click on the 'new template...' and then use excel as the desired application for the report template. It gives me a weekly resource usage report i.e., who is working on what each week and for how many hours.
Now, I am supposed to represent what resource is fully occupied and who has certain capacity (hours) available during a time window. For this I insert a column 'Max Units' in the report and thereby come to a figure of 'weekly hours'. I then multiply these weekly hours with the number of weeks in the desired time window to get his/her maximum available hours. Then by summing up the actual week on week assignment, I come up with the utilized hours. And finally by deducting these utilized hours from maximum available hours, I come up with the 'available hours' for that resource.
My problem starts when there are resources with multiple 'max units' assigned to them (this is done by going to resource information) for different time periods. The visual report only shows one max unit in the inserted column.
Is there a way possible for me to get all possible max units in the insterted column (or in any other way)?
Apologies for lengthy description and thanks for the help!
Monday, 28 May 2012 2:47 PM
If I go by the end goal stated in the first sentence of your second paragraph, why wouldn't the already existing Work and Remaining Availability fields, meet your needs?
With regard to your actual question, yes you can get the data, but not via visual reports. The data shown in the Resource Sheet for resource availability time periods is that of the current time period only (i.e. whatever it is as of the current date). However the total resource availability over time information can be extracted via VBA, and a VBA macro would be the most flexible approach to getting the desired data into Excel.