Pipeline value, weighted value, coverage and stale deals

History (optional): opportunities that entered each stage in finished cohorts

Entered Qualified Entered Site assessed Entered Proposal sent Entered Decision Of these, won

Target and cycle (optional)

Target to sign next period (USD) Days from Qualified to Won

Stage	Deals	Open value	Weighted, your %	History %	Weighted, history	Stale value

Measure	Result

The example numbers are invented for illustration, not market data. Deals, average value and stage % describe the open pipeline today. Stage % is your own estimate of the chance a deal in that stage is won. History counts are opportunities that entered each stage in cohorts old enough to be finished; the history rate for a stage is wins divided by those that entered it. Coverage is open value divided by the target, and the late-stage figure counts only Proposal sent and Decision. The sales velocity line uses the formula (opportunities x average value x win rate) / cycle length, with the win rate taken from Qualified; it is a rough single number, not a forecast. Entries accept 12,500 or 0,15; a value such as 1.000 is ambiguous and is rejected, so write 1 or 1000.