resource with 24/7 calendar with varying availability during the day

Home Forums Microsoft Project Discussion Forum resource with 24/7 calendar with varying availability during the day

Viewing 3 reply threads
  • Author
    • #414384

      Hello All
      Is there a way to create a resource with 24/7 calendar but 3 available during the day (300% max unit) and 1 during the night shift (100% max unit)?

      Project Calendar 24/7
      “Drill a hole” takes 20 hrs and is performed by Drilling Team available 24/7
      “Log a hole” takes 8 hrs and is a successor to “Drill a hole” task.
      “Log a hole” is performed by the Logging Team with varying availabilities:
      – 3 Loggers available during Day Shift (6am-6pm) and
      – 1 logger available during night Shift (6pm-6am)


      – how to set-up and then assign the Logging Team to “Log a hole” so that logging team is assigned to the task as per their availabilities (without manual adjustment)?

      Currently, I have separated the Day/Night Shift loggers with 300% and 100% max units respectively and have assigned both to the task. However, MS Project divides the 8hrs between the two shifts and creates a split (if another shift is not available) instead of continues allocation of resources.

      In this case, it doesn’t matter who does how much, it is important to complete the task ASAP. I think the only way is to have 1 resource similar to the Drilling Team, however, I don’t know how to set the Max unit for different times of the day.

      I greatly appreciate your insights


    • #414386
      Larry Christofaro

      Shamim, I know this is not exactly what you are asking but I tend to try a “keep it simple” approach first if it works. What about just assigning the four loggers as a single team and then either know that one of them is a night shift worker or manually reassign based on shift once the logging task is near-term? There might be an option using resource leveling, maybe along with a single night shift resource, but that depends on specific results. Hope that helps…

    • #414391

      Thank you for your time.

      I can’t have a logger as 400% because I wont get the burning man when the night shift is over allocated!
      At the moment I have one 24/7 logger and two 12/7 day shift loggers. I only assign the 24/7 and then if overallocated and if day shift I’ll manually replace it with the 12/7 day shift.

      The reason I’d like to avoid manual adjustments is that each schedule consists of 50+ wells and there will be about 7 of these schedules rolling up into a master schedule as sub projects. The aim is to make a template which can be used for the other 6 as well. This is where Resource assignments become important, ie do we have enough resources…etc.
      I understand, at the end of the day, each schedule requires a few manual adjustments.

      I have to admit, I’ve never come across different resource availabilities within a day before and was wondering how others deal with this situation.
      This could be possibly a good feature to add to MSP (ie let whoever available pick the task up rather than splitting it between resources)

    • #414394

      You have an interesting question, but it’s very difficult to give you a specific recommendation, not know all the intricate details.
      A few questions/considerations first.
      – Is the drill a hole 20 hours calendar duration regardless of how many resources assigned? Meaning will assigning 1 vs 3 resource make the drilling process go faster? I’m assuming it’s 20 hours wall clock duration to Drill and 8 hour wall clock duration to Log.
      – Is the “Log a hole” performed immediately after drilling completes or does it start at the next day shift? Meaning, if the drill starts at 6AM and finishes at 2 AM, does the second shift logger start Logging the hole immediately? Or does Log start with the next shift?
      – Are we setting up the MS Project plan to basically manage when holes will be started/completed, or is it also being used for more detailed resource scheduling/planning?

      I don’t necessarily want answers to all these questions. I’m simply illustrating the complexities that could influence how this might be done.

      It sounds like the critical aspect is of the schedule is having the tasks schedule correctly (with uninterrupted duration) and that the resources can be fluid being assigned as needed when needed. Therefore, I might start experimenting with a more Task based approach to the problem.
      – Try using task calendars instead. For example; Set up a Drilling calendar that is 24/7.
      – Set up a Log calendar that is 12h/day. Assuming it’s always done on first shift. Set it up as 24/7 (or use the same calendar) if it can start immediately after drilling completes.
      – Assign the correct calendar to each task.
      – Set up each resource with 24/7 calendars. Two key reasons for this suggestion. First, it sounds like the assignment to the task needs to control when the task can be completed. Meaning 24/7 or first shift only. Second, resource/task assignments work based on the intersection of both calendars. If the task calendar is 24/7 but the resource calendar is M-F 8-5, then the work is only scheduled M-F 8-5.
      – If needed, try configuring the task to ignore resource calendars. In this case, the task calendar alone will drive when the task schedules/completes. This may be needed if the resource are also used on other non Drill/Log tasks that should only be completed on their normal shift. In which case the resources could have their calendars configured for their specific shifts to handle all other tasks, but when assigned to the Drill/Log tasks, the task calendars override.
      – Configure the Drill task as Fixed duration – 20 hours, the Log task as Fixed Duration 8 hours.
      – Assign the resources to the task as appropriate. It sounds like 2 day shift loggers drill from 6 AM to 6 PM with 1 night shift logger finishing the drill for the remaining 8 hours. So if three loggers are assigned, they would be allocated 12, 12, and 8 hours respectively. Project will show all three starting at the same time, but in reality the night shift logger wouldn’t log hours until 6PM. The key is that the task has a fixed 20 hour duration.
      – Add the Drill/Log dependency which would then start the Log the Hole task at 6 AM the next morning.
      – Set the Log the Hole task up similarly.

      Again, it’s a complex problem that will be difficult to provide a specific answer in a forum like this. I would start with an approach similar to what I suggested and experiment, tweaking as necessary.

      Hope this helps!

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