The template is fully editable with Excel and can be converted or changed to suit your project requirements. The contents of the template is shown below.
The contents of the Duration estimation Template in Excel
Field
Field Description and Tips to Complete
Document information
Enter the:
- Project name
- Project manager
- Project ID
- Project sponsor
Parametric estimates
- Estimate ID
- WBS ID
- Task/Activity ID
- Effort hours
- Resource quantity
- Percentage available
- Performance factor
- Duration estimate (hours)
Analogous estimates
- Estimate ID
- WBS ID
- Task/Activity ID
- Optimistic duration
- Best quess
- Pessimistic duration
- Expected duration estimates (PERT BETA distribution)
- PERT BETA distribution
- Triangular distribution
Decisions
- Decision number
- Date decision made
- Description
- Impact
- Approver / decision maker
- Evidence (when decision made e.g. meeting details, or email title and date)
Download the template!
Excel 97 - 2003 download - Duration estimation worksheet (.xls)
Excel download - Duration estimation worksheet (.xlsx)
OpenDocument Spreadsheet download - Duration estimation worksheet (.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.
Get a Duration Estimates list - record the estimates of effort and duration for your project's activities.
Marketing Budget Template - this is a easy simple template that prompts you to think about all the key costs you need to consider when creating a marketing budget.
Three-point estimation calculator
Project Templates to download
- Sample Project Charter - FREE example from a real software project
- Excel Project Plan - FREE excel Gantt Chart template for project planning
- WBS Checklist - Download a Free checklist for reviewing Work Breakdown Structures
- Project Management Templates - View our collection of FREE templates for Project Managers
- MS Project schedules - Get a ready made Microsoft Project Plan for your Project.
- Risk Register template - Download a free Risk Register Template for managing your risks.
- Software Project Plan - Get a ready Made Microsoft Project Plan for your Software Implementation Project.
- Sample Statement of Work - Writing a SOW is challenging! That is why we are sharing this free example!
- WBS examples - 22 Examples of real world Work Breakdown Structures.