BoostExcel main content

If a task is a non-parent task, it could have dependency tasks. The predecessor tasks determine the dates of the current task. The successor tasks' dates are determined by the current task.

To define dependency relations, use the "Editing Task" window. To open the window, double-click a task name on the Gantt sheet.

There are 4 types of dependencies.

DependencyChartUsage
Finish to startFinish to start dependencyThe predecessor task’s end date determines the successor task’s start date.
Start to startStart to start dependencyThe predecessor task’s start date determines the successor task’s start date.
Finish to finishFinish to finish dependencyThe predecessor task’s end date determines the successor task’s end date.
Start to finishStart to finish dependencyThe predecessor task’s start date determines the successor task’s end date.

A task could have multiple predecessors and multiple successors. If multiple predecessors determine the start date of a task, the latest date is used; likewise, if multiple predecessors determine the end date of a task, the latest date is used.

There is only one dependency relation allowed between two tasks. For example, if there're two tasks A and B, it isn’t allowed to define two dependency relationship between the two tasks.

Also, cyclic dependency should be avoided. For example, if the start date of Task A is determined by Task B, and the start date of Task B is determined by Task C, now you cannot define that the start date of Task C is determined by Task A. The "Refresh All" button on the Excel ribbon can detect this type of dependencies.

For each dependency relation, you can specify a "Lag". The lag is the additional days between the two tasks. For example, if Task A has a "Finish to Start" relationship with Task B, Task A ends on August 1st, and the lag is 2, then Task B starts on August 4th. The calculation of lag does not consider rest days and holidays defined by resources.