Apps & Data · System

A clean total is nota sound model.

Audit a spreadsheet's formula layer - not its numbers - for the faults that silently corrupt a model: error cells, broken links, hardcoded magic numbers, copy-paste inconsistencies, and volatile dependencies.

Get the Auditor — $69one-time · instant download · yours to keep
Five deliverables · runnable
Python formula auditor
runnable
Integrity workbook
.xlsx
Worked sample model
.xlsx
Standards & Audit Playbook
.docx
Fix-It Runbook
.docx
Works alongside
Document Field Validator · Finance & Reporting Kit
01.The Problem

The model looks right. That is exactly the danger.

#REF!

One deleted column leaves an error cell that silently feeds a total three columns over.

0.085

A tax rate baked into a formula instead of an input - invisible, and wrong the day it changes.

1 of N

One overtyped cell in a filled row is the classic error a totals check will never catch.

02.See It Work

Toggle a fault. Watch the gate.

Live audit · toggle a fault on any cell

Ten formula cells from a small budget. Seven are clean and the grand total computes fine — yet the model is BROKEN, because Budget!E7 carries a #REF!. Clear the error on E7 and watch the gate fall to REVIEW.

CellFormulaFaultsScoreVerdict
Budget!D3=B3*C3
100SOUND
Budget!E3=D3*(1+0.085)
60REVIEW
Budget!D4=B4*C4+50
60REVIEW
Budget!E4=D4*(1+$F$2)
100SOUND
Budget!D5=B5*C5
100SOUND
Budget!E5=D5*(1+$F$2)
100SOUND
Budget!D6=B6*C6
100SOUND
Budget!E6=D6*(1+$F$2)
100SOUND
Budget!D7=SUM(D3:D6)
100SOUND
Budget!E7=SUM(#REF!)
100BROKEN

Model verdict

BROKEN

integrity 92 · 7 SOUND / 2 REVIEW / 1 BROKEN · fix first: Budget!E7

Why BROKEN at a 92

A structural fault — an error cell or a broken link — is dispositive: it breaks the whole model no matter how high the integrity score. Hardcodes, inconsistencies, and volatile dependencies only flag a cell for review. A number built on a broken cell is already wrong.

Audits a spreadsheet's formulas, not the correctness of the numbers and not people. It flags what to fix and points to the cell; it never edits or repairs your file. Not accounting or audit advice.

03.The Auditor, Run

Point it at a real .xlsx. Here is the verbatim output.

The shipped sample is a four-line budget with a tidy grand total - integrity score 92, seven cells SOUND. The auditor still calls it BROKEN, because one cell carries a #REF!. A number built on a broken cell is already wrong.

Spreadsheet Formula & Model Integrity Auditor  (SFI-069)
file: sample_model.xlsx
----------------------------------------------------------------------
Budget!E3       REVIEW   score  60  =D3*(1+0.085)
                -> hardcoded 0.085 in formula
Budget!D4       REVIEW   score  60  =B4*C4+50
                -> hardcoded 50 in formula
Budget!E7       BROKEN   score 100  =SUM(#REF!)
                -> error value #REF!
----------------------------------------------------------------------
integrity score: 92   SOUND 7 / REVIEW 2 / BROKEN 1   (10 formula cells)
structural failure present: True
MODEL VERDICT: BROKEN
fix first: Budget!E7

Audits the formula layer, not the numbers' correctness, and not people. Not accounting or audit advice.
04.The Standard

Two tiers of fault, one honest gate.

Structural faults are dispositive

An error cell or a broken external link forces BROKEN - regardless of the integrity score. The score can't outvote a cell that's already producing a wrong number.

Graduated signals only flag

A hardcoded constant, a block inconsistency, or a volatile dependency marks a cell REVIEW and lowers the score. On its own it never breaks the model - it tells you what to clean up.

The score never overrides the gate

Integrity is the mean of the cell scores, shown for context. One BROKEN cell makes the whole model BROKEN at any score. Clean cells can't rescue a broken one.

05.What This Is — And Isn't

A structural integrity check on a file.

It is
  • · A formula-layer auditor: errors, hardcodes, inconsistencies, volatile links
  • · A runnable Python tool that reads your real .xlsx, plus a workbook that reproduces the gate
  • · Deterministic and offline - same file, same verdict, every time
It isn't
  • · A check that your numbers are correct - it audits the formulas, not the answers
  • · A repair tool - it flags and points to the cell; it never edits your file
  • · A financial audit, and it does not score or rank people

Audits a spreadsheet's formulas, not the correctness of the numbers and not people. Not accounting or audit advice; confirm any figure that matters with the person who owns the model.

06.Who It's For

Anyone who ships a number out of a spreadsheet.

  • Analysts and operators who inherit models they didn't build
  • Founders and finance leads sanity-checking a board model before it goes out
  • Consultants who hand clients spreadsheets and need them defensible
  • Anyone who's been burned by a hardcoded number or a stray #REF!
08.Common Questions

The questions operators actually ask before they trust a model.

Because a structural fault is dispositive and a score can't outvote it. The shipped four-line budget has seven SOUND cells, a tidy grand total, and an integrity score of 92 — but Budget!E7 carries =SUM(#REF!), an error cell that's already feeding a wrong number into the total. One error cell forces the whole model BROKEN regardless of the score. The integrity score is the mean of the cell scores, shown for context only; it never rescues a model that has a cell producing garbage. Clear the #REF! and the same model falls to REVIEW — which proves the gate does distinct work from the score.

Trust the formula,
not just the total.

One purchase, lifetime access, 12 months of updates. $69, once.

Sold by RedHub AI LLC · Secured by Stripe · redhub.ai