Tools · Quarter math

Pipeline Coverage Planner

The quarter math every revenue team redoes in a spreadsheet. Put in the quota, what’s closed, what’s open, and an honest win rate — get your coverage ratio, the finish the pipeline actually supports, and how much you still have to build, per week.

Quarter or month — just keep every input on the same period.

Qualified-stage and later, closing in-period. Not the everything-pipeline.

Dollar-weighted, measured from the same stage you counted above. Use the last 2–4 periods, not the best one.

Coverage on remaining target
Coverage you actually need
Projected finish
Pipeline still to build

The math: coverage = open in-period pipeline ÷ remaining target (quota − closed-won). The famous “3× rule” is just a proxy for 1 ÷ win rate — if you win 25% of qualified dollars you need 4×, not 3×. Projected finish = closed-won + pipeline × win rate; pipeline to build = remaining target ÷ win rate − open pipeline. Win rate must be dollar-weighted and measured from the same stage you count coverage at, or the ratio lies. Late-created pipeline converts worse than early, so treat the weekly build number as a floor. Runs in your browser; nothing is sent anywhere unless you ask for the readout below.

Want this coverage model sanity-checked?

Leave an email and I'll send back your numbers with the three places quarter math usually lies — stage-inflated pipeline, win rates measured from the wrong stage, and coverage padded with next period's deals. Written by me, not a sequence. Usually within a day.

Coverage says how much pipeline the number needs. Capacity says whether the team can close it. Same discipline, other side of the equation — the capacity planner runs the headcount math.

Run the capacity math Email me More tools