Drawing of Stakeholder map

Project Management Templates | FREE Downloads Word, Excel, PDF, Visio

Essential Microsoft Project: The 20% You Need to Know
  • Concise, focused guide that cuts through the clutter
  • Step-by-step instructions for creating a project plan in under a day
  • Master essential skills like work breakdowns and task sequencing
  • Real-world troubleshooting for 20 common scheduling challenges
  • Rapidly get up to speed if you're new to Microsoft Project
  • Includes glossary, support resources, and sample plans
The cover of the book 'Essential Microsoft Project: The 20% You Need to Know'

Duration Estimates Template | FREE Download

by | reviewed 04/03/2022
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. Get a Duration Estimation worksheet.

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)

Get a Activity Cost Estimate Template - this PMBOK template includes labor, physical and reserve costs.

Get a Simple Project Budgeting worksheet - track materials, labor, tools, actual and estimate costs.

Duration Estimation Worksheet - develop parametric, analogous and three-point estimates using this worksheet. Includes formulas for PERT Beta distribution and Triangular distribution.

Marketing Budget Template - this is a super simple template that prompts you to think about all the key costs you need to consider when creating a marketing budget.

Other Project Templates to download