Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2003
    Location
    Toronto, Ontario, Canada
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up

    [Previously posted in Project forum, with no responses.]
    I have a VBA program in an Excel wrapper that correlates resource calendar non-working times in a common resource pool with entries in a series of Exchange (Outlook) Public folder calendars and the Global Address List (GAL) and presents the data in a spreadsheet for consumption by individual project resource allocation spreadsheets.
    The section that retrieves the resource pool data loops through the resources, then through the months in the target range (usually a year), then through all the days in that month to test if that is a non-working day. We have about 150 resources and this takes a while. Is there a faster way to work through the data? I could skip weekends, but can't think of anything else. Is there a way of looping through the months/days and then the resources for entries on that day?

    Stu Boasman
    Toronto, Canada

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts
    I can see why you wouldn't get many replies - this is a shotgun request on a large piece of highly specialised custom-created code and you haven't provided any specific code to focus on. It sounds like you are taking data from MS Project and Outlook calendars and merging them into an Excel workbook to analyse resourcing for multiple projects and ensure that the relevant outlook calendars include all the allocated tasks.

    I don't understand the question particularly well but I would consider looping through the Project Task entries (or the Outlook calendar entries) rather than the days. Tasks are always associated with days and sometimes with resources. Whereas days are not always associated with tasks and only indirectly with resources. Since your description sounds like it is looping everything then the hierarchy is probably not too important as the loops will have to run eventually anyway.
    Another possibility is to look in MS Project for the concept of Working and Non-working time
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Lounger
    Join Date
    Oct 2003
    Location
    Toronto, Ontario, Canada
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Andrew Lockton' post='786657' date='29-Jul-2009 05:56']I can see why you wouldn't get many replies - this is a shotgun request on a large piece of highly specialised custom-created code and you haven't provided any specific code to focus on. It sounds like you are taking data from MS Project and Outlook calendars and merging them into an Excel workbook to analyse resourcing for multiple projects and ensure that the relevant outlook calendars include all the allocated tasks.

    I don't understand the question particularly well but I would consider looping through the Project Task entries (or the Outlook calendar entries) rather than the days. Tasks are always associated with days and sometimes with resources. Whereas days are not always associated with tasks and only indirectly with resources. Since your description sounds like it is looping everything then the hierarchy is probably not too important as the loops will have to run eventually anyway.
    Another possibility is to look in MS Project for the concept of Working and Non-working time[/quote]

    I have attached the relevant code. I believe that going through the tasks would not show the resource calendar's non-working time; I am trying to look across multiple projects at the resource pool itself, similar to the Tools/Change Working Times function on the Project menu. Individual tasks from one project may not cover that particular vacation period. You are correct in saying that I am looping through everything and that I should probably be looking at the concept; any idea where I could find that?

    Stu
    Attached Files Attached Files

Posting Permissions

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