How to use Sales Pipeline Forecast
- Paste a CSV table or choose a CSV file with id, value, probability, expected_date and currency headers. Deal IDs must be unique.
- Choose monthly or quarterly grouping and enter a scenario adjustment in percentage points.
- Run the forecast. Compare unweighted totals, base weighted values and scenario weighted values within each currency.
- Download the forecast and keep its probability and expected-close assumptions with the source deals. The result is not a payment schedule or a predicted outcome.
Example: Sales Pipeline Forecast
Group weighted deals by expected close period and currency.
Supported inputs and limits
- At most 2,000 deals, 80 CSV columns and 2 MiB.
- Deal amounts have two decimal places and are nonnegative.
- Probabilities range from 0 to 100; a scenario adjustment ranges from -100 to 100 percentage points and the resulting probability is clipped to 0–100.
- Dates are valid calendar dates from 1900 through 2200.
- Three-letter currency labels form separate totals.
More details
No exchange rates, win-probability estimation, receipt timing or accounting revenue recognition are supplied.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Questions about Sales Pipeline Forecast
Does the forecast predict whether a deal will close?
The calculation uses the probability you enter. It multiplies that assumption by the deal value; it does not estimate a new probability from sales history.
How is the scenario adjustment applied?
An adjustment of 10 changes 25 percent to 35 percent. It adds percentage points rather than multiplying the original probability by 1.10.
Why are currencies reported on separate rows?
Adding different currencies would produce a misleading total. Each period and entered currency label gets its own weighted and unweighted results.