Tutorials

Progress Calculation

OP3 allows you to set and modify completion progress for tasks and milestones individually. You can choose to show or hide the progress indicator for a task or milestone, and you can change its position relative to item’s shape.

The progress is automatically computed for Task Groups and for the entire project following a similar logic, which is described below:

Based on the given progress for a task and the task duration, we compute the total number of completed work days for that task. If we have 2 or more tasks with different completion percentages, we compute the total number of work days that are completed, based on the task progress. It is calculated using the following formula:

TotalWorkDaysCompletedForTask = TaskDurationInDays * TaskCompletionPercentage

Using this formula, we can compute the progress for a task group that has several tasks, which is given bellow.

ProgressForAllTasks = TotalWorkDaysCompletedForAllTasks / TotalDurationOfAllTasks

If a task group has several tasks and milestones, the progress of the task group would be equal to the progress of total tasks. However, if all tasks are complete and at least one milestone is not 100% complete, the task group progress will be 99%.

If a task group has milestones only, the progress is calculated based on the following formula:

ProgressForAllMilestones = NumberOfCompletedMilestones / NumberOfAllMilestones

These two major formulas are used when computing the progress for the entire project, which can be exported to Excel, Smartsheet or Google Sheets, by taking in consideration all tasks and milestones for the entire project.