VanillaPM
Sign in Get started free Dashboard
Free calculator

PERT / three-point estimate calculator

A free PERT and three-point estimating calculator — enter optimistic, most likely and pessimistic estimates to get the beta-PERT and triangular expected values, the standard deviation and 68%, 95% and 99.7% ranges.

Expect O ≤ M ≤ P.

Expected (PERT)(O + 4M + P) ÷ 6
σ(P − O) ÷ 6
95% range±2σ
Triangular(O + M + P) ÷ 3
Expected = (O + 4M + P) ÷ 6
σ = (P − O) ÷ 6
Variance = σ²
68% range (±1σ)
95% range (±2σ)
99.7% range (±3σ)
Download as Excel (.xlsx) The spreadsheet has live formulas: change the yellow cells and it recalculates.

Why three points

A single-number estimate hides how uncertain it is. Three-point estimating asks for three:

  • O, optimistic: if things go well (not the miracle case).
  • M, most likely: what usually happens.
  • P, pessimistic: if things go badly (not the disaster case).

Beta-PERT, (O + 4M + P) ÷ 6, weights the most likely value four times. Triangular, (O + M + P) ÷ 3, weights all three equally, so it comes out higher when the pessimistic case is far away.

Turning the spread into a commitment

The standard deviation, (P − O) ÷ 6, measures the uncertainty. Roughly 68% of outcomes fall within ±1σ of the expected value, 95% within ±2σ and 99.7% within ±3σ. If you need to commit to a date or a budget, the ±2σ upper bound is one you can usually stand behind.

To combine activities along a path, add their variances (σ²), not their standard deviations, then take the square root.

On a real project

The schedule lesson uses three-point estimates on the Coral Ridge sample, and shows why the critical path decides which of them matter.

See it used on a real project: Pr8 · Plan and manage schedule