Creating Visual Reports in MS 2010 for resources with multiple max units assigned

• Monday, 28 May 2012 9:29 AM

   

   
  

  0

  Hello,

  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!

  -Nishant

  • Reply
  • Quote