spreadsheet-modeling
/spreadsheet-modeling
Build spreadsheet models that are auditable and hard to break, separating inputs, calculations, and outputs. Use when modelling finances, forecasts, or scenarios.
- Author
- Amey-Thakur ↗
- Repository
- AI-SKILLS ↗
- Licence
- MIT
- Last repository change
- 05.09.2026
Assessment and security
- Files in this package
- 1
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 05.09.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
Build spreadsheet models that are auditable and hard to break, separating inputs, calculations, and outputs. Use when modelling finances, forecasts, or scenarios.
Original author description
Build spreadsheet models that are auditable and hard to break, separating inputs, calculations, and outputs. Use when modelling finances, forecasts, or scenarios.
How it works
- Method
- Boundaries
SKILL.md preview
--- name: spreadsheet-modeling description: Build spreadsheet models that are auditable and hard to break, separating inputs, calculations, and outputs. Use when modelling finances, forecasts, or scenarios. --- # Spreadsheet modelling Spreadsheets are the most used and least engineered software in most organisations. Errors are common, consequential, and hard to spot, because nothing enforces structure and everything looks equally authoritative. ## Method 1. **Separate inputs, calculations, and outputs.** Distinct areas or sheets, with inputs clearly marked, so a reader knows what is an assumption and what is derived. 2. **Never hardcode a number inside a formula.** Every constant is an input cell with a label, since buried constants are the classic undiscoverable error. 3. **Keep one formula per row or column.** Consistency lets you copy across and makes an inconsistent cell visible as an anomaly. 4. **Name ranges for anything referenced repeatedly.** Named references read as meaning rather than as coordinates. 5. **Build in checks.** Totals that must reconcile, balances that must be zero, flagged visibly, which is the spreadsheet equivalent of a test (see assertion-density). 6. **Document assumptions on the sheet.** A model without its assumptions is unusable by anyone else and by you in six months. 7. **Version deliberately.** Spreadsheets are copied and edited in parallel, so a clear naming and ownership convention prevents competing truths. ## Boundaries Spreadsheets suit modelling and analysis, not production data processing or multi-user workflows, where a database and an application belong (see schema-design). Complex models become unmaintainable and should move to code. Financial models used for decisions need review by someone who did not build them.
Versions
| Repository | Score | Licence |
|---|---|---|
| This page · Amey-Thakur/AI-SKILLS | 90 | MIT |
| mkurman/zorai | 100 | MIT |
Database snapshot: 13.11.2026 · package version 5a38f6cc9f85 (SHA-256 digest of the entire package)
Downloads in the last 30 days: 1 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 100spreadsheet-model-builder
Structures spreadsheet models a second analyst can audit - separated input/calc/output sheets, one-formula-per-row hygiene, built-in error checks, and a documented cover sheet. Use when someone asks "how should I structure this model", "clean up this spreadsheet before the board… - 86forecast-modeling
Use when designing, tuning, or auditing revenue forecast models. - 90financial-modeling
Builds and stress-tests financial models for forecasting, scenario planning, and decision support — revenue build, cost structure, driver logic, and the sensitivities that show where a plan breaks. Use this to model a decision's financial consequence, build a forecast or… - 95forecast-scenarios
Model best-case, worst-case, and likely revenue scenarios with sensitivity analysis for strategic planning. Use when: building financial forecasts; presenting board scenarios; planning headcount around revenue uncertainty; modeling pricing changes impact; preparing investor…