Formula consistency
Flags formulas that break a repeated horizontal pattern.
ModelSeal
Methodology
ModelSeal runs eight defined structural checks on Excel workbook content. It does not calculate formulas or interpret business assumptions. Each finding comes from a specific rule and points to a workbook condition that can be reviewed directly.
Current structural checks
Hardcoded overrides
Finds numeric values interrupting supported formula regions.
Broken references
Finds #REF! errors and references to missing worksheets.
External workbook links
Shows references to other Excel workbooks.
Formula error values
Finds Excel error constants embedded in formulas.
Hidden worksheets
Lists hidden and very hidden worksheets.
Missing formulas
Flags isolated blanks inside supported horizontal formula regions.
Hardcoded values in formulas
Identifies numeric constants entered directly inside formulas so they can be reviewed as possible embedded assumptions.
Structural Health Score
The score summarizes findings from four components: Formula Integrity (35 points), Reference Integrity (25), Formula Error Safety (25), and Workbook Transparency (15). Each component floors at zero and the total remains between 0 and 100.
| Component | Maximum | Deductions per finding |
|---|---|---|
| Formula Integrity | 35 | MS001: 2 · MS002: 3 · MS007: 2 |
| Reference Integrity | 25 | MS003: 6 · MS004: 2 |
| Formula Error Safety | 25 | MS005: 6 |
| Workbook Transparency | 15 | MS006 very hidden: 2 · hidden: 0 |
Score bands
| Rating | Score |
|---|---|
| Excellent | 95-100 |
| Strong | 85-94 |
| Review Recommended | 70-84 |
| Needs Attention | 50-69 |
| High Risk | 0-49 |
MS008 findings are currently informational observations and do not reduce the Structural Health Score.
Limits of the review
Findings flag observable conditions for investigation. ModelSeal does not calculate formulas, infer business intent, verify assumptions, assess forecast accuracy, judge accounting treatment, evaluate investment merit, or guarantee that a workbook is error-free. Pattern checks are horizontal and intentionally conservative, so legitimate exceptions may be reported and unsupported structures may be missed.