Skip to content
Skills Library
Finance & accounting · Building & coding

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.

Repository
AI-SKILLS ↗
Licence
MIT
Last repository change
05.09.2026

Assessment and security

90/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content25 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
1
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 05.09.2026, without references to retired models or APIs.

Licence

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

  1. Method
  2. Boundaries
Original SKILL.md headings · 37 lines, 236 words
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

RepositoryScoreLicence
This page · Amey-Thakur/AI-SKILLS90MIT
mkurman/zorai100MIT

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…

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.