The Pipeline Forecast Worksheet

Every quarter begins with a quiet moment—father's ledger book on the table, Marley asleep at my feet, and the five phases laid out like stanzas in a hymn. This worksheet is where we sing that hymn into numbers.

Phase I: The Seed (Lead Qualification)

What it is: Not every prospect is soil ready for planting. This phase filters the wind-blown seeds from the ones meant to grow.

The Metric: Qualified leads × Historical conversion rate = Seeds worthy of watering.

My grandmother taught me: "Don't waste water on stones."

Phase II: The Root (Discovery & Needs Analysis)

What it is: Digging deep enough to find the water table. Discovery isn't asking questions; it's listening for the heartbeat beneath the soil.

The Metric: Opportunities with documented pain points × Budget verification = Rooted prospects.

Phase III: The Stem (Solution Design & Proposal)

What it is: Building the trellis that will bear the fruit. Every proposal must match the unique architecture of the client's needs.

The Metric: Proposals sent × Win-rate-at-this-stage = Stems ready to climb.

Phase IV: The Bloom (Negotiation & Commitment)

What it is: The moment the flower opens—fragile, precious, demanding perfect conditions. Negotiation is tending the bloom, not forcing it.

The Metric: Active negotiations × Average deal size × Close probability = Blooms on the vine.

Phase V: The Harvest (Closing & Handoff)

What it is: Gathering what was grown. But even in harvest, we save seed for next season—referrals, renewals, expansion.

The Metric: Closed-won deals × Expansion multiplier = Harvest plus seed.

THE FORECAST EQUATION (grounded in Q7216332):

Forecast = Σ(Open Deals at Phase N × Avg Deal Size × Conversion Rate N→N+1)

Where each Phase is a stanza, and the sum is the song.

Live Forecast Calculator

Phase Active Deals Avg. Value ($) Close % Weighted Value ($)
I: Seed $0
II: Root $0
III: Stem $0
IV: Bloom $0
V: Harvest $0
TOTAL FORECAST: $0
Enter your numbers, then press calculate. The forecast will appear here.

Grounded in reality: This worksheet draws from the Wikidata definition of forecasting (Q7216332)—"making predictions of the future based on past and present data"—and the economic concept of sales (Q194189) as "exchange of goods for money over a targeted time period."

Live knowledge:

Neighbor's wisdom:

brittany-hinesvisit brittany-hines.4ort.net →