SPB Git

Repository Public Research preview

README.md 2.5 KB 61 lines markdown

1# excel-model-workbook23An Agent Skill for building, auditing and grading Excel model workbooks.45- **Build**: a short standard for workbooks others must trust: inputs, calculations and outputs6  separated, one formula pattern per row, no number buried in a formula, a controls sheet with a7  single "all checks pass" cell, a documentation sheet with a version stamp.8- **Audit**: a dependency-free command-line tool that reads `.xlsx` / `.xlsm` files without Excel9  and reports errors (root causes first), circular references, hard-coded numbers, broken formula10  patterns, failing or fake controls and stale stored values; it also traces precedents and11  dependents across sheets.12- **Grade**: compare a submission with a reference under a rubric, with tolerance,13  formula-required items, partial credit and consistent treatment of carried-forward errors. The14  output is evidence for a human grader, never a final grade.1516## Install1718```bash19skills install @spboucher/excel-model-workbook --client claude-code20```2122or copy the folder into your agent's skills directory (for Claude Code: `~/.claude/skills/`).2324## Use2526```bash27node scripts/xlsx.mjs --help28node scripts/xlsx.mjs report model.xlsx29node scripts/xlsx.mjs grade reference.xlsx student.xlsx --rubric assets/rubric.example.json30```3132Node.js 20 or later, no `npm install`. Nothing in a workbook is executed; the tool writes only33the report or evidence file you ask for, and never overwrites.3435## Contents3637| Path | What |38|---|---|39| `SKILL.md` | Instructions for the agent |40| `scripts/xlsx.mjs` | Command-line auditor, 14 commands, JSON output |41| `scripts/lib/` | Engine, identical to the one in `@spboucher/xlsx-audit-mcp` |42| `references/modeling-standard.md` | Layout standard and an openpyxl skeleton |43| `references/audit-procedure.md` | How to read each result |44| `references/grading.md` | Rubric format and grading policies |45| `references/defects.md` | Defect catalogue |46| `assets/rubric.example.json` | Rubric template |4748## Limits4950`.xlsx` and `.xlsm` only. The built-in evaluator covers arithmetic, comparisons, `SUM`,51`AVERAGE`, `MIN`, `MAX`, `ROUND`, `IF`, references and plain defined names; every other formula52is read from the result stored in the file, and the tool states the share it could not recompute.53Macros, external links, charts, pivot tables, conditional formatting and data validation are not54read. A clean report shows that mechanical defects are absent, not that the model is right.5556The same engine is available as an MCP server: `@spboucher/xlsx-audit-mcp`.5758## License5960MIT61
Files main
Menu

Theme