spreadsheet-auditor skillA

spreadsheet-auditor is agent-read markdown (skill) from petehottelet/spreadsheet-auditor: Audits an existing Excel workbook or financial model (.xlsx, .xlsm) for errors and pins each to a cell: #REF! and other live errors, broken references, totals that skip rows or double-count, formulas that break the pattern of their neighbors, hardcoded plugs, circular references, hidden rows or sheets feeding totals, and row and column totals that do not tie out. Use when someone wants a spreadsheet they already have checked, reviewed, audited, QA'd or debugged: finding the mistakes before a mod.

Indexed from public GitHub and served as immutable, content-addressed versions. Install it pinned to an exact SHA-256 with the mdr CLI, and every file is verified against the hash recorded here before it reaches your agent. The deterministic audit below grades the latest version, and the same file always earns the same grade.

What the file says

# Spreadsheet Auditor

`scripts/audit.py` finds candidate defects and pins each to a cell. It matches patterns and cannot see intent: on real workbooks about one finding in four is a false alarm, usually a total, net or summary line that differs from its neighbors by design. Run it, check each candidate in context, and tell the user what is actually wrong. The user's workbook is read-only throughout.

## Workflow

Copy this checklist and work through it:

- [ ] 1. Run the audit
- [ ] 2. Read the summary and the report
- [ ] 3. Check each candidate in context
- [ ] 4. Answer the user

### 1. Run the audit

```bash
python scripts/audit.py WORKBOOK --out audit_report.md --json findings.json --summary
```

Write the outputs in the user's working folder. Exit codes 0, 1 and 2 all mean the audit finished (1: Critical findings present); 3 to 5 mean it did not, and stderr says why:

- openpyxl missing: run `pip install openpyxl` (Python 3.11+), then rerun.
- `.xls`, `.xlsb`, `.ods` or a password-protected file: convert with `soffice --headless --convert-to xlsx FILE` when LibreOffice is installed, otherwise ask for an unprotected `.xlsx`. Say which copy you audited.
…

Read the whole file at its exact version.

How to install

Latest version
mdr add petehottelet/spreadsheet-auditor/spreadsheet-auditor@git:20260923.2887803
Exact content
mdr add petehottelet/spreadsheet-auditor/spreadsheet-auditor@sha256:7f80161d32208408

Pin to a label to follow the author's releases, or to a sha256 to freeze the exact bytes forever. Either way the resolved hash is written to mdr.lock, and mdr install reproduces it on any machine.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_ibdkfdr3vwnuaxnh.svg)](https://markdownregistry.com/a/art_ibdkfdr3vwnuaxnh)

1 badge views in 30 days

Versions

versioncommittedcommitsizeaudit
git:20260923.2887803 latest2026-09-23 2887803 6,006 BA view · diff
git:20260923.a8c707e2026-09-23 a8c707e 5,743 BA view · diff
git:20260914.2c834d32026-09-14 2c834d3 4,128 BA view · diff
git:20260617.ff4feb82026-06-17 ff4feb8 4,208 BA view · diff
git:20260617.f66698e2026-06-17 f66698e 3,895 BA view

Audit of the latest version

A  17 of 17 checks passed. Deterministic, no model, same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (6006 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

petehottelet/spreadsheet-auditor · 6 stars · license MIT · pushed 2026-09-24 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_ibdkfdr3vwnuaxnh
GET https://markdownregistry.com/api/v1/resolve?ref=petehottelet/spreadsheet-auditor/spreadsheet-auditor
GET https://markdownregistry.com/api/v1/blob/7f80161d3220840829c18edf0852654e2974e9a98ac5ed267a424755f7358df6

Your agent does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Browse by kind, by grade A, or by owner.