Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMForecast & QuotaWeighted Pipeline Forecast

SpreadsheetForecast & QuotaFree

Weighted Pipeline Forecast

Forecast the quarter from open deals: stage probability, close month and the gap to target.

Shown with sample data

Colour

Weighted Pipeline Forecast

Forecast the quarter from open deals: stage probability, close month and the gap to target.

Quarter target
$250,000
Weighted forecast
$209,200
Commit
$120,000
Gap to target
$40,800
Pipeline coverage
1.7
Times target
Weighted value by deal
  • Harbor Logistics, fleet suite$67,200
  • Apex Build, estimating$36,000
  • Northwind Health, analytics$36,000
  • Brightline Retail, POS rollout$26,000
  • Meridian Clinics, scheduling$22,000
  • Summit Legal, document suite$19,200
  • Coastal Foods, inventory$2,800

How to use it

  1. 1Set your target and stage probabilities on the Settings sheet.
  2. 2List every deal expected to close this quarter.
  3. 3Mark only deals with a verbal yes as Commit.
  4. 4Aim for pipeline coverage of 3× the remaining target.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

A forecast you can defend. Each deal carries a stage probability and an expected close month; the sheet calculates weighted value, splits it into commit and best case, and compares the total with your target to show the gap and the pipeline coverage you have.

Who it’s for

  • Weekly forecast calls
  • Checking pipeline coverage early in the quarter
  • Reporting to finance or investors

What’s included

  • Pipeline sheet: One row per deal that could close this quarter.
  • Settings sheet: Stage probabilities and the quarter target.

How to use it

  1. 1Set your target and stage probabilities on the Settings sheet.
  2. 2List every deal expected to close this quarter.
  3. 3Mark only deals with a verbal yes as Commit.
  4. 4Aim for pipeline coverage of 3× the remaining target.
Related searchesweighted pipelinesales forecastpipeline coverageforecast accuracyquota gap

Details

Format
Spreadsheet
Category
Forecast & Quota
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetForecast & QuotaFree

Weighted Pipeline Forecast

Forecast the quarter from open deals: stage probability, close month and the gap to target.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Forecast & Quota
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More forecast & quota templates

View all
Monthly Sales Forecast3 sheets

Forecast revenue

$586,979

Gross profit

$373,235

Gross margin

64%

Forecast revenue by month
$80k
$67k
$54k
$51k
$46k
DecNovOctSepMay
SpreadsheetForecast & Quota

Monthly Sales Forecast

A 12-month forecast by product from base volume, monthly growth and seasonality, with revenue, gross profit and actuals vs forecast.

10 min setupPreview
Sales Quota Attainment Tracker2 sheets

Team attainment

45%

Projected finish

84%

Gap to quota

$347,000

Attainment by rep
81%
49%
42%
38%
27%
Priya NairMia RossiDana WuTom BeckerLeo Park
SpreadsheetForecast & Quota

Sales Quota Attainment Tracker

Bookings against quota for each rep, with pace for the days gone, projected finish, pipeline coverage and the gap to close.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ