Skip to main content

Drift Catalog (Locked, 7 Drift Types)

Every finding cites one of these rule IDs. No fabricated rules; no severity reassignment; no drift type outside this catalog.

Severity Baselines​

Every drift type has a locked severity baseline. Cross-DS drift is Info-by-default per HC#12; within-DS drift follows the tier assigned below.

Rule IDDrift TypeBaseline Severity
F-CURRENCY-01Currency-Symbol MismatchWarning
F-DECIMAL-02Decimal-Places MismatchWarning
F-DATE-03Date-Format MismatchWarning
F-SEPARATOR-04Thousands-Separator MismatchWarning
F-FONT-FAMILY-05Font-Family DriftInfo
F-FONT-SIZE-06Font-Size DriftInfo
F-NEGATIVE-07Negative-Number-Treatment DriftWarning

F-CURRENCY-01 Currency-Symbol Mismatch​

Check: every measure placement within the same data source that carries a currency-formatted format string uses the same currency symbol AND the same currency-format convention (Currency (Standard) vs Currency (Custom)).

Signals evaluated:

  • Extract format string from worksheet XML format="..." attribute for the measure placement.
  • Detect currency symbol at start or end of the format string ($, €, £, ¥, CHF, kr, etc.).
  • Compare against the baseline currency symbol for that measure within the DS (first-seen wins per HC#11).

Fires when: two or more placements of the same measure within the same DS use different currency symbols, OR one placement is currency-formatted and another is plain-number for the same measure.

Cross-DS behavior: different currency symbols across DS boundaries are Info-tier per HC#12. Multi-currency reporting is legitimate.

Severity: Warning within DS. Info cross-DS.

Desktop fix: right-click the field on the affected worksheet > Format > Numbers > Currency (Custom) > match the baseline symbol.

F-DECIMAL-02 Decimal-Places Mismatch​

Check: every measure placement within the same DS uses the same decimal-place count for the same measure.

Signals evaluated:

  • Extract decimal-place count from the format string (e.g., #,##0 = 0, #,##0.00 = 2, #,##0.0 = 1).
  • Compare against the baseline decimal count for that measure within the DS.

Fires when: two or more placements of the same measure within the same DS use different decimal-place counts.

Severity: Warning within DS. Info cross-DS.

Desktop fix: right-click the field on the affected worksheet > Format > Numbers > adjust decimal places.

F-DATE-03 Date-Format Mismatch​

Check: every date-pill placement of the same date field uses the same date-format string.

Signals evaluated:

  • Extract date-format string from worksheet XML for each date pill.
  • Compare against the baseline date-format string for that date field within the DS.

Fires when: two or more date-pill placements of the same date field use different format strings (MM/DD/YYYY vs DD-MMM-YYYY vs YYYY-MM-DD).

Severity: Warning within DS. Info cross-DS (legitimate for multi-region reporting).

Desktop fix: right-click the date pill on the affected worksheet > Format > Dates > match the baseline pattern.

F-SEPARATOR-04 Thousands-Separator Mismatch​

Check: every measure placement within the same DS uses the same thousands-separator convention.

Signals evaluated:

  • Extract separator character from the format string (, = 1,234, . = 1.234, space = 1 234, none = 1234).
  • Compare against the baseline separator for that measure within the DS.

Fires when: two or more placements of the same measure within the same DS use different thousands separators, OR one placement uses a separator and another does not.

Severity: Warning within DS. Info cross-DS.

Desktop fix: right-click the field on the affected worksheet > Format > Numbers > Currency (Custom) > match the baseline separator convention.

F-FONT-FAMILY-05 Font-Family Drift​

Check: every text element within a workbook-scope element category (worksheet titles, axis labels, tooltip labels, dashboard text objects) uses the same font family.

Signals evaluated:

  • Extract font-family declaration from worksheet or dashboard XML for each text element.
  • Group text elements by category (title, axis, tooltip, dashboard-text).
  • Compare within each category against the baseline font family (first-seen wins).

Fires when: two or more text elements within the same category use different font families.

Severity: Info by default (fonts are often intentional per design system). Upgrades to Warning when the drift is undocumented AND the workbook has a dashboard-caption reference to a design system that specifies one font.

Desktop fix: right-click the text element > Format > Font > select the baseline family.

F-FONT-SIZE-06 Font-Size Drift​

Check: every text element within a workbook-scope element category uses the same font size.

Signals evaluated:

  • Extract font-size declaration from worksheet or dashboard XML.
  • Group by category (title, axis, tooltip, dashboard-text).
  • Compare within each category against the baseline size.

Fires when: two or more text elements within the same category use different font sizes.

Severity: Info by default. Upgrades to Warning when the drift is greater than 4 points (e.g., 9pt vs 14pt in tooltip labels) OR the drift affects axis labels specifically (axis-label size drift breaks visual hierarchy).

Desktop fix: right-click the text element > Format > Font > size > adjust to baseline.

F-NEGATIVE-07 Negative-Number-Treatment Drift​

Check: every measure placement of the same measure within the same DS uses the same negative-number treatment.

Signals evaluated:

  • Extract negative-number treatment from the format string (parentheses (1,234), minus-sign -1,234, red-color, minus + red).
  • Compare against the baseline for that measure within the DS.

Fires when: two or more placements of the same measure within the same DS use different negative-number treatments.

Severity: Warning within DS. Info cross-DS.

Desktop fix: right-click the field > Format > Numbers > Currency (Custom) > negative-number panel > match baseline.

Inherited vs. Explicit Format Strings​

A placement with no explicit format override inherits the field's default format string. An inherited default is not a divergent value — do not compare it against an explicit override as if both were authored choices. Before firing any of F-CURRENCY-01, F-DECIMAL-02, F-DATE-03, F-SEPARATOR-04, or F-NEGATIVE-07 on a given pair of placements, confirm at least one of the differing values is an explicit override (present as a format="..." attribute on that specific pill/placement in the worksheet XML). If a placement has no explicit override, record it as inherited_default in the finding's differing_format_strings list rather than treating it as a competing baseline candidate, and do not let it win the first-seen baseline in HC#11 over a placement with an explicit override.

Cross-DS Info-by-Default Rule (HC#12)​

For F-CURRENCY-01, F-DECIMAL-02, F-DATE-03, F-SEPARATOR-04, and F-NEGATIVE-07: cross-DS drift is Info-tier by default. Multi-currency, multi-region, or multi-locale reporting produces legitimate cross-DS format differences. Downgrade the Info-tier finding to a not-flagged status if the workbook caption explicitly documents the reason. Upgrade to Warning-tier only if the workbook contains no rationale and the same-symbol convention could reasonably be enforced.

Sentinel Discipline​

If a check cannot run (e.g., get-worksheet-xml fails on a dashboard-bound sheet, or search-workbook-fields fails), record the affected placements as "unscanned" with a rationale in the notes field. Never silently omit a placement.

Refuse to Fabricate​

Every finding cites one of the 7 rule IDs. Never invent a rule. Never reassign severity. Never mark a check "passed" without evaluating its signals against the baseline. Never establish a synthetic baseline; use the first-seen format string per HC#11.