An Alternate Approach to Hammock Tasks in Microsoft Project

This entry describes the basis for hammock-type summary tasks and introduces an alternate method (and UpdateHammocks macro) for creating and maintaining such tasks in Microsoft Project (MSP) schedules.

Hammocks and LOE Tasks

“Hammock”* and “Level of Effort” (LOE) tasks in project schedules provide two similar approaches to summarizing and reporting the overall time consumed by a collection of other tasks.  Typically, hammock or LOE tasks are used to represent the indirect management and other support activities associated with the primary tasks, and they are often loaded with management and other indirect resources.  Hammock and LOE tasks are essentially the same, though minor differences exist in the implementation by different software.  Since hammocks and LOE tasks do not possess any driving logic, they should be excluded from any formal definition of the Critical Path for the project.

* The “hammock” name refers to the simple method of suspending a sleeping net or cloth (i.e. the hammock) between two trees.  When first described in hand-drawn activity-on-arrow (AOA) network diagrams, the time-summarizing activity took the shape of a simple curved line slung between two nodes – i.e. a hammock.

Hammocks in Primavera

Primavera scheduling tools have long provided explicit activity types for specifying hammock or LOE activities.  Primavera Project Planner (P3) and Primavera SureTrak Project Manager, for example, both included specific hammock activity types that would be specially treated in the schedule calculations.  The start dates for a hammock were defined by its Start-Start predecessors; finish dates came from its Finish-Finish successors; the same activity could not be included in both groups.  Oracle’s Primavera P6, a newer application, allows for LOE activities that inherit their dates from the primary tasks that are included in their “predecessors” and “successors” lists.  They are substantially more flexible than P3’s hammocks.  In most respects the scheduling aspects of these LOE activities are similar to the scheduling of summary bars in P6 schedules (and summary tasks in MSP), with the key difference being that there is no need for common hierarchical structure or activity coding of the related primary activities.

Hammocks in Other Tools

Most other major project scheduling tools also have special-purpose hammock task types.  For example, Phoenix Project Manager, Spider Project, and Deltek Open Plan all provide traditional hammock activity types, whose start and finish are defined by specific logical relationships.  Asta PowerProject also includes a “hammock” task whose construction is more like that of an independent summary activity.  That is, it is not necessary to indicate start/finish relationships.  In general, the number of activities being summarized by the hammocks (or LOEs in P6) are not practically limited.

OLE Hammocks in MSP

MSP has never included an explicit Hammock or LOE task type, and since summary tasks do not provide the needed solution in many cases, a subtle method for constructing simple hammock tasks was created.  As described here, the method involves copying the start/finish dates from two primary tasks and using a paste-special command to link these dates to the dates of the “hammock” task.  The resulting “links” – based on common Windows OLE (object linking and embedding) technology rather than explicit logical schedule relationships – remain essentially hidden and cannot be easily described or audited in an MSP schedule.

MSP’s response to changes in the linked dates is similar to its response when dates are entered manually: i.e. it sets an early constraint (SNET or FNET) and adjusts the task duration so that the task spans between the two linked dates.  Unfortunately, even if the links remain stable and updated (which is not guaranteed), the sources of these adjustments remain hidden.

MSP OLE Hammock Issues

In addition to the absence of auditable schedule information, regular users of linked hammocks may have noticed the following issues, which are present in MSP Professional 2010 and later releases:

  1. OLE hammocks are limited to summarizing only two tasks, one task providing the start date and the other providing the finish.  This limitation seems most consistent with the original description of hammocks in AOA networks, but it doesn’t exist in other modern software.  Often the activities being summarized are potentially concurrent, and it is preferred to allow the software to select dates from the group.
  2. MSP does not prevent the assignment of additional logical links or other constraints that may conflict with the OLE links.
  3. Creating new linked hammocks by copying and modifying existing linked hammocks – say as part of a fragnet replication – doesn’t work well. The resulting links may be subject to corruption and won’t update reliably.  The only reliable way to create such links is to copy and paste-link them one-at-a-time.
  4. Even “automatic” updating of links sometimes fails, with repeated pounding of the F9 key having no affect. In these cases, it’s useful to open the Links window, select all the links, and force an update. (To open the window, the “Edit Links” command needs to be available on one of the ribbons.  It can be added through the “customize the ribbon” dialog.)  This tool is absolutely necessary to make OLE hammocks even slightly bearable.
  5. Resource leveling of linked hammocks can result in unintended consequences. Although most of these can be corrected by a forced update of the links, some changes require that the hammock task be reconstructed.  E.g. removing leveling splits.  The safest course is to assign a priority of 1000 to all linked hammock tasks, thereby exempting them from any leveling actions.

MSP Alternate Hammocks

An alternate approach to hammocks in MSP involves the following steps:

  1. Create the proposed hammock task as either a Fixed Units or Fixed Work task, depending on the nature of the resource loading required.
  2. Specify two predecessors to the proposed hammock task: one Start-to-Start and one Finish-to-Finish, without lags. (These are the same tasks that would otherwise be the sources of the Start and Finish paste-links. Here they are visible and auditable. Do Not paste links.)
  3. Avoid specifying any successors to the hammock.
  4. Create a custom flag field named “Hammock,” and assign a value of “Yes” to the Hammock flag for this task.
  5. Adjust the duration of the task such that it spans between the associated start and finish predecessor dates. (This is done automatically with the macro code below.)
  6. Ensure that the task is assigned a Priority of 1000, which prevents it from being resource-leveled. (This is done automatically with the macro code below.)
  7. Load indirect resources to the task as appropriate.

This alternate approach has the key benefit of presenting an explicit logical basis for the hammock task’s schedule dates, which can be easily checked and modified if necessary.  It also supports the use of Fixed-Work hammocks for allocation of fixed contract costs.  While this alternate approach is no more robust than OLE hammocks when summarizing tasks with potential concurrency, it is far easier to review, modify, and update the associated hammock links when the controlling activities change.

The macro/vba code below is intended to automatically update the durations of all hammock tasks in the active project.  It also automatically removes constraints on hammocks and assigns a priority of 1000 to prevent resource leveling.

This macro/vba code comprises a subroutine and a custom function that should be pasted together into a single module in the Visual Basic Editor.  The “UpdateHammocks” macro may then be assigned to a “hotkey” or ribbon command as appropriate.

[Edit March 2018.  Our MSP add-in, BPC Logic Filter, excludes Hammocks constructed using this method from Longest-Path and Near-Longest-Path reports.  This satisfies the requirement that such tasks not be included in any calculations of the project’s Critical Path.  Since some users have reported inadvertent introduction of splits into hammock tasks during cost updating, I added a little mini-procedure to close all such splits that are 100% in the future, prior to updating the hammock duration.  I also updated the duration calculator to accommodate an assigned resource with a non-standard calendar.  ]

Sub UpdateHammocks()
'15Sep'17 coded by TM Boyle, PSP.
'A code to routinely update the Durations of unlinked, user-managed "hammock" tasks in Microsoft Project.
'A "hammock" task is an indirect/support task that may be resource loaded.  Its schedule
'depends solely on the tasks that it supports/summarizes.
'For this code to work:
'   - All hammock tasks are coded using a custom Flag field (named "Hammock"); Alternately Flag1 is assumed.
'   - Each hammock task has exactly one or two predecessors:
'       - The "Start" predecessor has a Start-to-Start relationship with no lag
'       - The "Finish" predecessor has a Finish-to-Finish relationship with no lag
'       - If there is only one predecessor, then both start and finish of the hammock will come from it.
'   - Each hammock should have NO successors, although this condition is not enforced.
'       - Successors on the hammock can synthetically lengthen the backward path to its "Start" predecessor,
'           thereby reducing Total Slack in that predecessor and its driving chain.
'[21Mar'18 added code to remove splits in hammocks.]
'[22Mar'18 added code for hammock scheduling using a single resource calendar.]


Dim t As Task
Dim d As TaskDependency
Dim StartH As Date
Dim FinishH As Date
Dim i As Integer 'Added 21Mar'18
        
If Not HammockFieldExists Then
    MsgBox ("Couldn't find a Hammock Flag. Aborting")
    Exit Sub
Else
    'Proceed
End If


For Each t In ActiveProject.Tasks
    If Not t Is Nothing Then
        
        StartH = 0
        FinishH = 0
        If t.GetField(FieldNameToFieldConstant("Hammock")) = "Yes" Then
        'If t.Flag1 = True Then 'Flag1 is used to designate Hammock Activities
        
            'Added 21Mar'18
            'First Close Splits if any
            On Error GoTo 0
            If "Proceed" = "Proceed" Then '(change second "Proceed" to another word to bypass for troubleshooting)
                Do While t.SplitParts.Count > 1
                    i = t.SplitParts.Count
                    'Don't remove any splits that begin in the past
                    If ActiveProject.StatusDate < ActiveProject.ProjectFinish Then 'StatusDate Exists
                        If t.SplitParts(i - 1).Finish < ActiveProject.StatusDate Then Exit Do
                    Else ' Use now date
                        If t.SplitParts(i - 1).Finish < Now() Then Exit Do
                    End If
                        t.SplitParts(i).Start = t.SplitParts(i - 1).Finish
                Loop
            End If
            
            If t.PredecessorTasks.Count = 2 Or t.PredecessorTasks.Count = 1 Then
                For Each d In t.TaskDependencies
                    If d.To = t Then
                        If d.Type = pjFinishToStart Or d.Type = pjStartToFinish Then
                            MsgBox ("Hammocks may only have SS or FF predecessors (Check predecessors): " & t.ID & " " & t.Name)
                        Else
                            If d.Type = pjStartToStart Then StartH = d.From.Start
                            If d.Type = pjFinishToFinish Then FinishH = d.From.Finish
                            If t.PredecessorTasks.Count = 1 Then
                                If StartH = 0 Then StartH = d.From.Start
                                If FinishH = 0 Then FinishH = d.From.Finish
                            End If
                            If d.Lag <> 0 Then MsgBox ("Hammocks should not have lag (Check lag): " & t.ID & " " & t.Name)
                        End If
                    Else
                        MsgBox ("Hammocks should not have successors (Check successors): " & t.ID & " " & t.Name)
                    End If
                Next d
            
                    On Error Resume Next
                        t.Duration = Application.DateDifference(StartH, FinishH, t.CalendarObject)
                        If Err.Number <> 0 Then
                            Err.Clear
                            'Added 22Mar'18 - allow for resource calendar controlling task schedule
                            t.Duration = Application.DateDifference(StartH, FinishH, t.Assignments(1).Resource.Calendar)
                            If Err.Number <> 0 Then
                                Err.Clear
                                t.Duration = Application.DateDifference(StartH, FinishH)
                                If Err.Number <> 0 Then
                                    MsgBox ("Failed to update Hammock (Check predecessors): " & t.ID & " " & t.Name)
                                End If
                            End If
                        End If
                        If Err.Number = 0 Then
                            t.Priority = 1000
                            t.ConstraintType = 0
                        End If
            Else
                MsgBox ("There must be 1 or 2 predecessors for this hammock activity. Not Updating: " & t.ID & " " & t.Name)
                
            End If
        End If
    End If
Next t
Application.CalculateProject


End Sub


Function HammockFieldExists() As Boolean
    Dim StrTest As String
    Dim FlagTemp As String

    StrTest = "Hammock"
    On Error Resume Next
        FlagTemp = ActiveProject.ProjectSummaryTask.GetField(FieldNameToFieldConstant(StrTest))
    If Err.Number = 0 Then 'The fieldname exists and will be used
        HammockFieldExists = True
    Else
        HammockFieldExists = False
    End If
End Function

21 thoughts on “An Alternate Approach to Hammock Tasks in Microsoft Project”

  1. Hi Tom!
    This is a very, very good blog. It helped me a lot!

    Thank you for this. As I’m not a programmer I had to fight with the visual basic code. Finally I found out that html has changed by the copy/paste function into html some of your code text.

    1.) appearance: I think about 5 times
    code in your blog: ——-> & t.ID & ” ” & t.Name) & t.ID & ” ” & t.Name) If d.Lag <> 0 Then MsgBox (“Ham If d.Lag 0 Then MsgBox (“Ham If Err.Number <> 0 Then If Err.Number 0 Then <——-

    Nevertheless, I would have never been able to sort this problem by myself.

    Many thanks,
    Markus

    1. Markus,
      Thanks for the kind words. Thanks also for pointing out the issues with the macro code in the blog. I think I may have been careless in pasting that code into the blog entry on a recent update. I hope it’s fixed now.

  2. This blog is just what I need. I have set flag1 as Hammock and set the flag to yes. The module indicated it couldn’t find a hammock task. Not sure what to do.

    1. Glad you found it useful. The module is looking for a specific custom field with an assigned name “Hammock”. This is best done in the Custom Fields dialog (accessed from the Properties group on the Project ribbon). I suspect you simply gave a new title to the Flag1 column of your table – not the same thing. Good luck.

      1. Oh thank you! I did just rename the Flag1 column. It works fine now, so very useful.

          1. Another question, sorry. I renamed my file with a new date and the macro does not appear to have any effect, no errors, just nothing. When I open the new file project asks if I want to enable macros and I selected yes. Any tips.

  3. OK…I think I know. I added a tab on the developer for Hammock Updates and it appears that does not transfer between files? The macro runs if I select “run macro” and not the custom ribbon button.

    1. A macro button that you add to the ribbon contains a link to the original file holding the macro. If the file being linked to is not open, then the macro button is dead. That’s what happens when you save a project file (holding a macro) over to a new name. It’s really a good thing that such links are not routinely duplicated with the file.

      As a rule, I keep all my customizations in the Global.mpt file, which is open whenever Project is open, so I’ve never run into your issue. Keep in mind the global.mpt can become corrupted occasionally, so you’ll want to backup your macro modules somewhere else as well.

  4. Tom,

    Kudos to you for developing this very useful feature–including the VBA code to power it. I–for one–will abandon the old approach to Hammock Tasks (i.e. OLE Links). This is a much better solution–and one that Microsoft should bake into the product. (Hint to the Product Team!)

    The Primavera advocates are quick to spread tales that Microsoft Project Server/Project Online is somehow deficient in it’s ability to build schedules. (Pinning them down to specific issues is an elusive goal.) However, hammock tasks is one area in which they have a legitimate point. Primavera has for a long time had a built-in Task Type called “Hammock Task”.

    Rigorous schedules (e.g. DoD, NASA, Federal Agencies, etc.) will always require Level-of-Effort (LOE) tasks to be included in any schedule. At a minimum, “Project Management” is the one required LOE task. This “Alternate Approach to Hammock Tasks” can provide a bit more confidence to those of us who deploy Project Server/Project Online in the DoD and Federal Government sectors.

    Great job, Tom!

    1. Edward, thanks for the kudos. As noted in the article, MSP is pretty much the only modern-day scheduling tool without a hammock or LOE activity type.

    2. Hello Edward (in case you are still following the comments),

      When it comes to “pinning down Primavera advocates”, as for MS Project schedule calculation quirks
      (Not to use the term “deficiencies”, because it is just a fact of life we have to deal with, where Tom has provided quite a few of solutions.),
      some of Tom’s texts talk about such in (very useful) detail (e.g. the one about Out-of-Sequence activities in MS Project 2010-2016).

      Then also, not to go piece-meal, that old 2011 text by Winter and Evrenosoglu is still a relevant starting point reference summarizing (then) main “quirks” in terms of MS Project vs. P6 (but also MS Project vs. CPM, in a way).
      Relevant, because, all of the features (and, unfortunately, the need for roundabout recipes and tricks) still remain in MS Project even today.
      Text can be easily found online in various versions and with various titles, one of which is “MS Project for Construction Schedulers”, which may be misleading, because it applies to any industry.

  5. Another question – I’m confused about using physical %complete or %complete to update the status of an LOE task? For LOE the BCWS will always equal the BCWP.

    1. Hi Mary Ellen. I don’t often use EV metrics in MSP, so I’m not a good source for which way to go. My gut feel is that for a classic LOE/hammock there is no way to measure Physical %Complete, and the cost/value is essentially realized with the passage of time – i.e. (duration) %Complete. If the start and finish of the hammock is same as baseline, then I guess BCWS=BCWP. But what if the primary activities started a month later than planned, shifting the LOE’s start by 1 month, and there have been additional delays such that the LOE duration has increased from 18 months to 24 months? The Owner is not going to start paying that item a month ahead of time and make the last payment (on a fixed-cost basis) 6 months before the work is done, is he? That’s what he would have to do to make BCWP=BCWS. On a reimbursable cost basis (i.e. fixed-units task), then I can see BCWP=BCWS as long as the start-driving task starts exactly on time.

  6. Your macro code is great & works well but for some reasons of mine I should like to use only functions & fields in-built in MS Project so I tried registering a macro which:
    1 Opens the “Edit Links” windows
    2 selects the links of the hammock
    3 makes the manual update
    3 close the windows
    but, Alas !, the result was an empty macro
    can you help in same way ?
    Thank you

  7. Hi Tom,
    Thank you for this macro, an excellent alternative to the nightmare MSP left us with in managing the hammock tasks.

    Works as described.

  8. Tried to place this Macro into Project365 without success. The VBA editor starts flagging syntax errors throughout.

    First syntax error shows at line
            If t.GetField(FieldNameToFieldConstant(“Hammock”)) = “Yes” Then

    Looks like MS Project has changed VBA once again.

    1. RK,
      Please check that your double quote characters <"> have not been modified when copying/pasting. It is common for text-oriented editors to change standard, symmetrical quote marks to unsymmetrical opening- or closing- quotes. Otherwise I’m at a loss. Good luck, tom

  9. This is great! It was working perfectly until I added % complete values on the Hammock tasks. Then it started splitting the tasks and crashed whenever I ran the macro. Any ideas on how to fix it? I can send you the MSP file if that helps.

Leave a Reply

Your email address will not be published. Required fields are marked *