CIOPages
The Toolbox

Free worksheet

Reference-Class Estimation Worksheet

A worksheet that turns past projects' overruns into a low, likely and high range for a new project's estimate.

First page of Reference-Class Estimation Worksheet

What's inside

  • A short explanation of reference-class forecasting in three steps.
  • Step 1, a log of past projects: type, initial estimate, actual, the ratio of the two, scope changes and notes, shown with ten sample projects.
  • Step 2, the distribution of ratios: minimum, 10th percentile, median, 90th percentile, maximum and average.
  • Step 3, the ratios applied to a new estimate, with the wording to give stakeholders.
  • The Excel version has a log sheet, a sample sheet and a new-project estimator that calculates the range.

Format: PDF (2 pages) and Excel workbook.

How to use it

Log your own past projects, then quote the range from the estimator instead of a single date.

Get the worksheet

It is free. We email the download link to your work address.

We send a link to your work email. See our privacy policy.

Read more on this

Keep reading

Buyer Guide
Enterprise Agile Planning (EAP)
Free checklist
Sunk-Cost Circuit-Breaker

A kill-criteria checklist that sets the stop conditions for a migration or program before it starts.

Free worksheet
IAM Platform Evaluation Worksheet

Count every identity population, map applications by sign-in protocol, score an IAM shortlist on weighted criteria and price it over three years.

Sunk-Cost Circuit-Breaker