Duration Estimates Template | FREE Download

The Duration Estimates template is a record of the estimates of effort and duration required to complete the project's activities. stakeholdermap.com
It is a list rather than a worksheet. To calculate your duration estimates you can use this FREE Duration Estimation Worksheet.

Duration estimates come from several sources including the: In the PMBOK Duration Estimates are an output from process 6.4 Estimate Activity Durations (PMBOK Sixth Edition).
Duration Estimates Template

This is a FREE Duration Estimates Template in Excel. The template is fully editable with Microsoft Excel and can be converted or changed to suit your project requirements.

See what is in the Template! Check out the Contents complete with Hints and Tips on how to use.

Check out the contents below or Grab the template now!

The contents of the Duration Estimates Template


Project details

Provide information on the project and document:
  • Project Name and Reference
  • Project Manager
  • Project Sponsor
  • Date of last update

Estimate ID

Give each estimate a unique ID.

WBS or Work Package ID

Link the estimate to the work package in the work breakdown structure.

Task/Activity ID

Link the estimate to the relevant activity ID.

Activity Description

Enter the activity title and description that this estimate relates to.

Effort hours

The estimate of human labour that will be needed. This is usually expressed in hours or days, and may have come from the expert input of your project team or from using a quantitative estimation method, such as parametric, analogous, or three-point estimating.

Often 1 working day is 8 hours and 1 working week is 40 hours. Of course this rule of thumb will vary depending on industry and project type.

Duration estimate

Duration is the length of time it will take to complete the work. This is not the same as effort, taking the example of an IT project, a developer may be needed for 2 hours to kick off, test and wrap up an automated script which has a runtime of 4 hours, giving an activity duration of 6 hours (and effort of 2 hours).

Duration Estimates Template

Excel download - Duration Estimates Template (.xls)

Excel download - Duration Estimates Template (.xlsx)

OpenDocument Spreadsheet download - Duration Estimates Template (.ods)

Duration Estimation Worksheet


Other Project Templates to download