Who this is for, and the moment
Every inherited model has modules nobody dares delete. Referenced By answers one hop at a time, so “does anything read this?” means an afternoon of clicking and a guess at the end. The tests answer it for every module at once, and the action plan says what to do about the one that matters.
The question
The usage area of the test catalogue: five tests, every model.
The result
| Test | What it looks for | Result | By model |
|---|---|---|---|
| 2.1 | Modules nothing reads. A module with two or more calculated line items that no formula outside it reads and no export action uses. | found · 7 | Caldergate FP&A 3 · Caldergate Data Hub 2 · Workforce Planning 1 · Board Reporting 1 |
| 2.2 | Unread modules that repeat a module in use. An unread module whose calculated line items match, in formula and context, line items of a module that is read. | clear · 0 | |
| 2.3 | Calculated line items nothing reads. A calculated line item of 50,000 cells or more that no formula reads, outside the modules above and outside output-style modules. | found · 5 | Caldergate FP&A 5 |
| 2.4 | Data loaded but never read. A module that an import action loads, none of whose line items is read by any formula or used by an export action. | found · 1 | Caldergate Data Hub 1 |
| 2.5 | Names that say leftover. Modules, line items, actions and referenced list items whose name carries a leftover marker (OLD, TEMP, COPY, BACKUP, DO NOT USE, v2, 'Copy of', default names). | found · 4 | Caldergate FP&A 3 · Workforce Planning 1 |
The largest of them, as the action plan carries it
Find out whether anyone still uses the module CAL05 Opex OLD in Caldergate FP&A
A module that no formula reads and no export uses may be left over from earlier work, or it may be read only by pages and views, which the exports do not show. Until someone checks, it can neither be removed nor trusted. In Caldergate FP&A, no formula outside the module CAL05 Opex OLD reads any of its 14 line items and no export reads it; it occupies 70.2M cells and 50.8% of the model's measured calculation effort. That is what it takes up now, not a saving.
- Ask the page builder whether any page, dashboard, saved view or line item subset still uses
CAL05 Opex OLD. - Ask whether another model imports from a saved view on it.
- Record the decision: keep, or retire. If retire: make the change in a development copy first, keep the original for comparison, check the owner's key outputs over a full cycle, then sign off.
Done when every question above has a recorded answer and the owner has signed a keep-or-retire decision. Found by test 2.1; findings F1, F26, F48. Role: model owner with a page builder.
Why it is an investigation and not a change: the evidence is partial. The exports cannot see pages, saved views or subsets, so "nothing reads it" is true of formulas and export actions only. The owner note on this module already says why it is kept.
Evidence drawer · what each chip opens
- RuleG-UNUSEDanaplan-estate checks.py
- RuleH-LEFTOVERanaplan-estate checks.py
- Action planFind out whether anyone still uses the module 'CAL05 Opex OLD'Action plan · #3
Seven modules with no formula reader and no export. Five calculated line items of 50,000 cells or more that nothing reads. One module loaded by an import that nothing uses. Four names that carry a leftover marker, OLD or DO NOT USE and the like.
The evidence
Deterministic rules over the exports, numbered and published in the Model Health Check: G-UNUSED for the readers, H-LEFTOVER for the names. The action card carries the findings it rests on (F1, F26, F48) and the test that found it (2.1).
What to notice
- The biggest unread module is 54% of the model’s cells and half its calculation effort. The plan still calls it an investigation, not a change, because the exports cannot see pages or saved views. “Nothing reads it” is true of formulas and exports, and the card says exactly that.
- Test 2.2 came back clear: none of the unread modules repeats a module in use. Clear is reported with the same weight as found.
- The owner note on CAL05 Opex OLD already says why it is kept. The chat answer on Is it safe to delete reads both the test and the note.
Related
Use cases: Is it safe to delete · The 42 checks · The fix list.