BaselineSnap scans your workbook for hardcoded assumptions, broken formulas, hidden sheets and formula drift — the same risks a senior reviewer would spot in two hours. Detect them before they become million-dollar mistakes.
| Sheet | Cell | Issue | Details | Severity |
|---|---|---|---|---|
| P&L | H14 | Error value #DIV/0! | Critical | |
| Assumptions | C7 | Hardcoded number in formula | Warning | |
| Model | M31 | Inconsistent formula (column) | Warning | |
| (Workbook) | OldRev | Dangling named range | Critical | |
| Inputs | B12 | Volatile function OFFSET | Warning | |
| P&L | K44 | Static value in formula row | Warning | |
| Balance | (entire) | Very-hidden worksheet | Critical |
No cuts, no editing. This is a live capture on a real 12,000-cell model. Click any finding — Excel jumps to the cell. That's the whole product.
Every finding pairs a concrete Excel issue with a plain-English why this matters — because you don't need another linter, you need a co-reviewer.
Any number sneaked into a formula — a stray 1.045, a fixed tax rate, a manual override — is flagged so it can be lifted out into a labelled input.
Buried assumptions are the #1 way a model drifts silently from reality between quarters.
Snapshot your model before a review, edit, or handoff. Compare later to get a color-coded Added / Removed / Formula-changed / Value-drift diff.
Catch a colleague's stray edit before it reaches the IC memo — no more "who changed this?" post-mortems.
Detects every use of OFFSET, INDIRECT, NOW, RAND and RANDBETWEEN — the volatile functions that quietly turn a 200-cell workbook into a 20-second recalc.
The difference between a model that runs in one click and one that grinds Excel to a halt in a board meeting.
Hidden and very-hidden worksheets are flagged with distinct severities so nothing stays out of sight during review.
The stale-data sheet you meant to delete last quarter shouldn't drive today's forecast.
Every finding in the report is a live hyperlink. Click the cell reference and Excel jumps you directly to the flagged location.
You spend seconds fixing issues instead of minutes hunting for them.
Dangling #REF! names, unresolvable references, workbook-vs-sheet scope collisions, and hidden names — all surfaced in one pass.
A single broken named range can cascade into dozens of formula errors. We find them before they cascade.
One-line rules in a hidden Audit_Config sheet let you whitelist known false-positives per issue-type, per range, or per sheet.
Every model has its own conventions. The tool learns yours instead of screaming at you.
The macro writes findings to its own sheets (Audit_Report, Audit_Baseline, Baseline_Diff). Your original workbook is never modified.
You can run it on partner models, client deliverables, board packs — nothing to worry about.
“Ran it on our latest LBO the morning of IC. Found a hardcoded IRR override in the sponsor waterfall that would have blown up the sensitivity table. Ten seconds.”
“The baseline diff is the feature I didn't know I needed. I snapshot on Friday, my analyst edits over the weekend, Monday I see exactly what moved.”
“Replaced our internal Python model-checker with this on day one. Faster, catches more, and doesn't need the model to be uploaded anywhere.”
| Capability | BaselineSnap | Manual review |
|---|---|---|
| Time per model | ~10 seconds | ~2 hours |
| Finds hidden sheets | Automatic | Easy to miss |
| Detects volatile functions | Automatic | Rarely caught |
| Formula drift vs. baseline | Automatic | Not practical |
| Dangling named ranges | Automatic | Manual F5 → Special |
| Circular references | Automatic | Alert only |
| Navigate to any issue | Hyperlinked | Ctrl+F, hope |
| Suppress false positives | Per-range rules | Mental note |
| Cost | From $9/mo | 2 hrs × your rate |
Catch broken references on the acquiror side before your MD does.
Turn a two-day formula audit into a two-minute pre-flight check.
Detect hidden sheets and volatile refs in LBOs before IC votes.
10-second scan on every close file. Auditors will love you.
Show up to the meeting knowing every landmine in their file.
This is the actual output of BaselineSnap on the three sample files below. Ready for the real thing? Download the .bas and run it on your workbook — nothing leaves your machine.
Full result contains 27 findings across 7 sheets — with every row hyperlinked to the exact cell in Excel. Install the module to see the whole thing on your own workbook.
Free download. No sign-up. Runs entirely on your Excel — your workbook never leaves your machine.