Consulting

Results 1 to 5 of 5

Thread: Resource analysis

  1. #1
    VBAX Newbie
    Joined
    Oct 2015
    Posts
    2
    Location

    Resource analysis

    I am trying to look at a person's availability when they've been assigned to multiple projects. Right now, I'm bringing multiple sub projects into 1 blank master project then looking at the resource usage. This shows each person's total amount of time assigned per day for each project but doesn't sum up the time between multiple ones. I need to be able to see all of the projects they are assigned to in order to make resource allocation decisions. How might I do this?

    Thanks,

  2. #2
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location


    Create a custom Table with Field Names ResourceName, ResourceID, and Work

    You might try another table with Fields: Task, TaskProject, ResourceName, ResourceStart, and ResourceFinish, Then sort on ResourceName.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  3. #3
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    Is this a MS PowerPoint question or a MS Project question?
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  4. #4
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    Paul, Thanks. I'll move t.
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

  5. #5
    VBAX Newbie
    Joined
    Oct 2015
    Posts
    2
    Location
    Quote Originally Posted by SamT View Post


    Create a custom Table with Field Names ResourceName, ResourceID, and Work

    You might try another table with Fields: Task, TaskProject, ResourceName, ResourceStart, and ResourceFinish, Then sort on ResourceName.




    Hmmm. Not getting the info I need. Is there a way that I can export the resource usage table into Excel in the same setup as displayed in Project? I haven't had luck doing that either.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •