Exporting resource unit timephased data to excel

Home Forums Discussion Forum Exporting resource unit timephased data to excel

Viewing 2 reply threads
  • Author
    Posts
    • #380875
      kamlesh Parmessur
      Participant

      Hello everyone

      Is there a way to export the resource unit assigned to task from project to excel (timephased data).
      Only the peak unit can be display in the task usage view and not the unit itself.

      can any body help me (even with VBA code is ok for me)

      I want to find out the number of resources required on a weekly basis for the complete duration of the project.

    • #380879
      Larry Christofaro
      Participant

      Try adding the Percent Allocation detail style to the Resource Usage view. From the Resource Usage view, select Add Details form the Format ribbon. Find and add the Percent Allocation style. Roll up to Outline Level 1 (resource totals only). I hope this helps…

    • #381535

      This might help if you can develop VBA Code
      https://msdn.microsoft.com/en-us/library/ee355231(v=office.12).aspx

Viewing 2 reply threads
  • You must be logged in to reply to this topic.