# Forecast rollup

A reusable skill the "Skip the Monday forecast scramble" recipe pulls in. Add it once and every agent on the team can use it.

Aggregate every open deal into one forecast total by rep, stage, and commit category.

## Method
1. Pull every open deal from the CRM.
2. Group deals by rep, then by stage, then by commit category: commit, best-case, pipeline.
3. Sum deal value within each group to build the rollup totals.
4. Cross-check the rollup total against a fresh CRM export a second time before publishing.
5. If the two totals don't tie out exactly, hold the run and flag the mismatch instead of publishing.

## Rules
- The CRM field that marks commit category is set on first run, then stored in memory.
- The rollup total must tie out exactly against a second, independent CRM pull — no approximate match.
- Never publish a rollup that failed its tie-out check; flag the mismatch and hold instead.

## Output
A rollup table — rep, stage, commit category, dollar total — written into the weekly-forecast view.