RedHub AI
How the gate works
How the Spreadsheet Formula & Model Integrity gate works
This tool grades a workbook's formula cells for hardcodes, inconsistency, volatile links, and structural breaks. It scores 3 weighted controls into a 0–100 number — then a gate that can only make the verdict worse.
The 3 weighted controls
An error value or broken link on any single cell is dispositive - it forces the whole model to BROKEN no matter how high the integrity score reads. Nine of ten cells can be clean and the average can hit 92; one #REF! still breaks the model, because nothing downstream of a broken cell can be trusted.
Why: Seven of ten formula cells are SOUND and the workbook's overall integrity averages 92 - which would normally read SOUND. But Budget!E7 carries a #REF! error: a structural fault is dispositive, so the gate forces BROKEN regardless of the 92. A number built on a broken cell is already wrong.
A high score didn’t save it. The score is context; the gate is the answer — and it names the one thing to fix first. Audits formulas, not the correctness of your numbers, and never people. It flags what to fix - it doesn't edit or repair your file. Not accounting or audit advice.