Who this is for, and the moment
The workspace is at its limit and someone has to say why. The exports never say how big a list is, how many periods the time range holds or how many versions there are. But every line item’s cell count is the product of its factors, and 278 equations are enough to solve for all of them.
The question
Caldergate FP&A, the largest model in the estate.
The result
Where the cells are
| Module | Cells | Line items | Share |
|---|---|---|---|
CAL05 Opex OLD | 70,249,536 | 14 | 54.0% |
CAL03 Opex | 30,106,944 | 6 | 23.2% |
DAT01 Actuals GL | 20,071,296 | 4 | 15.4% |
INP03 Headcount | 5,937,120 | 10 | 4.6% |
INP02 Opex Drivers | 1,110,816 | 58 | 0.9% |
CAL12 Driver Phasing | 593,712 | 31 | 0.5% |
CAL02 Revenue | 435,456 | 12 | 0.3% |
| 23 more modules | 1,496,782 | 143 | 1.2% |
The sizes, solved from the cell counts
| Factor | Size | Line items agreeing |
|---|---|---|
| Cost Centres | 133 | 173 of 173 |
| Accounts | 262 | 32 of 32 |
| Products | 42 | 43 of 43 |
| Roles | 31 | 10 of 10 |
| Departments | 18 | 9 of 9 |
| Currencies | 8 | 4 of 4 |
| Regions | 6 | 35 of 35 |
| Legal Entities | 4 | 15 of 15 |
| Time (Month, Model Calendar) | 36 | 237 of 237 |
| Versions | 4 | 222 of 222 |
What each axis costs
| Axis | Size | Line items on it | Cells on it | Cells it adds |
|---|---|---|---|---|
| Cost Centres | 133 | 173 | 128,817,815 | 127,849,260 |
| Time | 36 | 237 | 129,997,764 | 126,386,715 |
| Accounts | 262 | 32 | 120,429,872 | 119,970,216 |
| Versions | 4 | 222 | 129,994,272 | 97,495,704 |
| Roles | 31 | 10 | 5,937,120 | 5,745,600 |
| Products | 42 | 43 | 1,152,396 | 1,124,958 |
| Regions | 6 | 35 | 1,124,952 | 937,460 |
Over-dimensioned line items, priced
| Line item | Applied | Required | Cells | Saved without the extra axes |
|---|---|---|---|---|
INP03 Headcount.NI Threshold | Cost Centres, Roles, Time, Versions | none, a constant | 593,712 | 593,711 |
INP03 Headcount.NI Rate | Cost Centres, Roles, Time, Versions | none, a constant | 593,712 | 593,711 |
CAL02 Revenue.Actual or Forecast | Products, Regions, Time, Versions | Time | 36,288 | 36,252 |
CAL02 Revenue.Revenue Label | Products, Regions, Time, Versions | Products, Regions | 36,288 | 36,036 |
CAL07 P&L by Cost Centre.Opex Budget | Cost Centres, Time, Versions | Cost Centres, Time | 19,152 | 14,364 |
OUT02 Board Pack.Budget Revenue | Cost Centres, Time, Versions | Cost Centres, Time | 19,152 | 14,364 |
OUT02 Board Pack.Old Budget Revenue | Cost Centres, Time, Versions | Cost Centres, Time | 19,152 | 14,364 |
CAL01 Volumes.Launched? | Products, Time, Versions | Products, Time | 6,048 | 4,536 |
An over-dimensioned line item repeats one value along an axis it applies to; the cells it saves are the cells it would not have without that axis. Whether the repetition is wanted (a rate shown per segment on a view) is the owner's call: mark it and give the reason. Owner note n-9df5c544be says the OUT02 rows keep Versions on purpose, for the board's side-by-side view; note n-adfde53814 says the two NI constants belong in SYS00 Model Settings. 10 formulas aggregate with SUM or its kin to a list the export does not name: on those, the list the aggregation targets is taken as required.
Evidence drawer · what each chip opens
- Line itemINP03 Headcount.NI ThresholdLine Items export
- Line itemOUT02 Board Pack.Old Budget RevenueLine Items export
- Owner notePack views keep Versions on purposen-9df5c544beuser confirmed
- Owner noteINP03 Headcount: the NI constants are in the wrong placen-adfde53814user confirmed
Where the cells are, module by module: one module holds 54% and is the subject of Is it safe to delete. The sizes, solved: 133 cost centres, 262 accounts, 36 months, 4 versions, with how many line items agree on each. What each axis costs in cells. Eight over-dimensioned line items, priced: two constants carried across cost centre, role, month and version.
The evidence
The sizes are inferred from the cell counts and the solution reproduces 278 of 278 counts exactly. A size with fewer line items agreeing would be marked; here every one is unanimous. The evidence drawer shows the applied and the required axes on every line item.
What to notice
- Some repetition is wanted. The two board pack rows keep Versions on purpose so the board sees Actual, Forecast and Budget side by side; an owner note says so, and the row can be marked “keep current design” with that reason. The app then stops raising it.
- The two NI constants are the clearest fix: one number each, held 593,712 times. The note says where they belong and that the move is safe if the readers are repointed in the same change.
- A formula that aggregates to a list the export does not name is listed, not judged. The limits are printed under the table.

Related
Use cases: The 42 checks · The fix list · The estate on day one.