R010 — High Fan-In Hardcodes

Purpose¶

R010 flags a hardcoded cell whose downstream reach is unusually wide — one feeding more dependent formula cells than a fan-in threshold. It is a distinct check from R001 (Hardcoded Cells): R001 flags a hardcode because it breaks a row's consistent formula pattern; R010 flags a hardcode because of how far its influence reaches, independent of whether it sits in a consistent row at all.

Detection Logic¶

Every hardcoded cell whose direct dependent count exceeds a fan-in threshold is examined further along three dimensions: the structural classification of the worksheet it sits on (an Input or Interface sheet suggests the value is an intentional, managed assumption; a Calculation sheet suggests it is more likely an embedded constant that should have been an input reference); the cell's immediate local context (how formula-dense its neighborhood is); and the scale of its downstream influence (how many cells and worksheets are transitively affected). Severity and remediation guidance are derived from the combination of these signals rather than fixed — the same hardcoded value can be flagged as a low-severity, likely intentional input in one context and a high-severity embedded constant in another.

Why It Matters¶

A hardcoded value that feeds only one or two formulas is a contained risk. A hardcoded value that feeds dozens of downstream cells across multiple worksheets means that if the value should have been a controlled, changeable input — and is not — every one of those downstream cells is silently locked to a value that cannot be updated except by finding and editing this one specific cell directly, with no visible indication elsewhere in the model of how far its influence spreads.

Evidence Produced¶

A triggered R010 finding's evidence identifies the specific cell, states its direct and transitive downstream dependent counts, the number of worksheets its influence reaches, the worksheet's structural classification, the cell's classified local context, and the specific signals that informed that classification — so a reviewer can see not just that the cell is high fan-in, but why it was, or was not, judged likely to be an intentional input.

Severity¶

High (class-level default; per-finding severity is context-derived, ranging from an informational note for a confidently classified intentional input up to high for an embedded constant reaching a wide, cross-sheet audience). Weight 7.0. R010 is not one of the five critical-override rules.

Example¶

Trigger. A cell on a worksheet classified as Calculation contains a hardcoded discount rate that feeds 40 downstream formula cells across 4 separate worksheets, including a valuation summary sheet. R010 flags this cell at high severity: the worksheet context and wide, cross-sheet downstream reach both point away from an intentional, well-placed input.

Non-trigger context (still evaluated, lower severity). The same fan-in count, but the cell sits on a worksheet classified as Input, alongside data validation and named ranges consistent with a managed assumption register. R010 still evaluates the cell but assigns a markedly lower severity, since the surrounding context strongly suggests this is an intentional, properly located input rather than an embedded constant.

Recommended Remediation¶

Where the context suggests an embedded constant rather than an intentional input, extract the value into a named, controlled input cell and update every downstream formula to reference it, following the same remediation pattern as R001. Where the context already suggests an intentional, well-placed input, confirm that classification is correct rather than treating the finding as an automatic defect.

Related Rules¶

R010 shares the Structural taxonomy category with the other Structural-category rules published in the Rule Reference, and is closely related in concept to R001 — Hardcoded Cells — see the Rule Taxonomy page for the full category membership.

Related Articles¶

• Hardcoded Formulas in Financial Models — the Knowledge Centre's buyer-facing technical guide to hardcoded values generally.

Version History¶

No version-specific changes to R010's severity, weight, or category are recorded as of engine version 2.1.0. This section will be updated in the same edit as any future change to the rule's declared attributes.