PMC Pilot
Website language
Menu
XLSX /

AI tools and documents for engineering and project management.

Activity Duration Estimate Worksheet

Record and review activity duration estimates and the evidence supporting them.

How to use this template

This Excel template contains prepared working sheets and completion notes on a separate sheet. Enter your project data and review the completed workbook before use.

Prepare project brief

The form prepares a separate brief; it does not fill the Word or Excel file.

Read product descriptions in your language. The Word and Excel template files are in English.

Selected page preview · XLSX

Only selected pages are shown. This is not the complete template. The full editable Word or Excel file is supplied with purchase.

Learning

How to use this template

When you need it

Use this worksheet when a schedule activity needs a defensible duration estimate and the planner must make quantity, productivity, resource, calendar, uncertainty, and selected-duration assumptions visible for review before scheduling.

What it helps you decide

It explains how a duration was selected and what could change it, helping teams challenge unrealistic productivity assumptions and avoid treating one optimistic planning number as an established delivery commitment.

How to complete it

  1. Identify Activity ID and Work / quantity / unit, then record Estimation method and Productivity / resource basis using relevant production evidence or justified assumptions.
  2. Specify Calendar / time unit and assess Optimistic duration, Most likely duration, and Pessimistic duration on consistent work boundaries and resource assumptions for comparison.
  3. Explain Selected duration using Source / assumption and Estimator / review, preserving uncertainty instead of implying that the worksheet automatically determines a reliable programme duration.

Who prepares and reviews it

A planner or estimator typically prepares the worksheet with supervisors, engineering, procurement, and relevant trade specialists. Package owners review productivity and resource assumptions, while the planning authority decides how the selected duration enters the programme.

A mistake to avoid

Dividing quantity by headline productivity while ignoring access, calendar, resource availability, and interfaces can produce a duration that is numerically tidy but operationally unrealistic.

Illustrative example

Illustrative example: a contractor estimates trench installation for a constrained utility corridor. The worksheet records quantity, crew basis, access limitations, and a working calendar, then compares plausible duration outcomes. The reviewer selects a planning duration that reflects the access evidence and flags the condition requiring reassessment.

Explore the wider topic

Document contents

  • Activity ID
  • Work / quantity / unit
  • Estimation method
  • Productivity / resource basis
  • Calendar / time unit
  • Optimistic duration
  • Most likely duration
  • Pessimistic duration
  • Selected duration
  • Source / assumption
  • Estimator / review

Required inputs

  • Project name, location, company, document number and revision
  • Actual project scope, source records and responsible roles

Practical tools.
Professional judgment.

Confirm the adopted edition, local amendments, National Annex where relevant, and contract requirements.

Prepare project brief