none
Schedule Task to fill gap between two other tasks RRS feed

  • Question

  • I have a situation as follows where I need to create a task that fills a gap between its predecessor and its successor.  

    - predecessor is auto-scheduled based on a sequence of tasks before it

    - successor is a fixed date

    - the "filler" task is one which is basically a buffer to allow for delays of the predecessors.

    the duration of the "filler" task should be set based on the finish date of the predecessor and the start date of the successor.  I could set the duration of the filler task manually, but I'd prefer that it "float".  For example if I push out the end date of the predecessors I'd like the duration of the filler task to reduce accordingly.

    for example:

    development-task:  10d, start 1-Jun, end 10-Jun

    <filler-task> :  5 days between development & release (but if development takes 1 day longer, filler-task should reduce to 4 days)

    release task:  15-Jun

    Any thoughts on configuring this would be appreciated.  I'm using Project Professional 2013.

    Thanks in advance!

    Wednesday, February 6, 2013 8:11 PM

All replies

  • Bill,

    There are a couple of ways to automate this. The first is by using a hammock task as described in FAQ 19 - Hammock tasks (http://project.mvps.org/faqs.htm). The second would be some VBA to adjust the filler task dates as needed.

    John

    Wednesday, February 6, 2013 8:15 PM
  • John, thanks for the pointers.  I tried the Hammock task approach just now and it's almost exactly what I need.  However setting it up this way causes the Hammock task start/end dates to overlap the end/start dates of its predecessor & successor respectively.

    I fixed the Hammock task end date by setting its end date with a SF-1 relationship to its successor, but the start date is still incorrect.

    Maybe there's some combination of these that will work right ... or maybe it's time to learn VBA :).

    -Bill

    Wednesday, February 6, 2013 9:28 PM
  • Here's an option: http://blogs.catapultsystems.com/epm/archive/2009/06/29/projectpro-setting-buffers-part-1-schedule-buffer.aspx

    ...but I must admit I prefer VBA.


    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

    Thursday, February 7, 2013 2:18 AM
    Moderator
  • Bill,
    Okay, yeah there's a little quirk in Project 2010 with regard to hammock tasks. First, you need to make sure the the filler task is NOT set as fixed duration. Second, the hammock task will link to the start of the day UNLESS you go to File/Options/General group and set the option to show the time along with the date, then it should do what you want.

    Something I didn't caution you on previously. A hammock task uses paste links and they are very prone to causing file corruption. So, warning given.

    John
    Thursday, February 7, 2013 4:08 PM