Skip to main content

Report Template — Workbook Auditor

This file locks the output format for both Mode A and Mode B digests. Follow this structure exactly; do not improvise headers, bullet phrasing, or ordering.


Mode A — Calc/Field Change Digest​

## Field & Calc Changes: [Datasource Name]
Compared against snapshot from [snapshot date/time if available, otherwise "prior baseline"].

Body (grouped by change type, in this order)​

Inferred Renames (if any):

- [Inferred rename: "Old Name" → "New Name" — same formula/type, name changed]

New Fields (if any):

- New: "[Field Name]" ([dataType], [role]) — [calculated/native]
- Formula (if calc): [formula text, first 120 chars; full if shorter]

Removed Fields (if any):

- Removed: "[Field Name]" ([dataType], [role]) — [calculated/native]
- Prior formula (if calc): [formula text from snapshot]

Formula Changes (if any):

- Formula edit: "[Field Name]"
- Was: [prior formula, first 120 chars]
- Now: [current formula, first 120 chars]
- (Textual diff only — behavioral equivalence not confirmed)

Type/Role Changes (if any):

- Type change: "[Field Name]" — [prior dataType/role] → [current dataType/role]
[N] total changes ([breakdown by type]).

Zero-Change Output​

No field or calc changes detected since the last snapshot.

Mode B — Workbook Change Digest​

Header​

## Workbook Change Digest: [Workbook Name]
Compared against snapshot from [snapshot date/time if available, otherwise "prior baseline"].

Summary Line (always present before detail)​

Summary: [N] datasource(s) changed, [N] worksheet(s) changed, [N] dashboard(s) changed, [N] field/calc changes across all datasources.

Body (grouped by dimension, in this severity order)​

Datasources (highest signal):

- Datasource removed: "[Name]" — [connection type if known]. This may indicate an unintentional disconnect.
- Datasource added: "[Name]" — [connection type if known].

Dashboards:

- Dashboard added: "[Name]"
- Dashboard removed: "[Name]"
- Dashboard membership changed: "[Name]" — [sheets added/removed list]

Worksheets:

- Worksheet added: "[Name]"
- Worksheet removed: "[Name]"
- [Inferred rename: "Old Name" → "New Name" — same shelf contents, name changed]

Fields & Calcs (per datasource; see Formatting Rules below for the 50-99 / 100+ field-count bands):

[Datasource: "Name"] — [N] changes:

Then use the same bullet format as Mode A (Inferred Renames, New, Removed, Formula Changes, Type/Role Changes).

[N] total changes across [N] dimensions.

Zero-Change Output​

No changes detected since the last snapshot.

Formatting Rules​

  • Always bulleted list (never a table for the digest itself).
  • Group headers in bold, not markdown heading level (avoid colliding with the top-level digest header).
  • Omit any group that has zero items (don't render "New Fields: (none)").
  • Formula text longer than 120 characters: show first 120 + "..." in the bullet, offer full formula on request.
  • For 50-99 fields in a single datasource in Mode B: sub-group by change type with a datasource sub-header.
  • For 100+ fields in a single datasource in Mode B: same sub-grouping, plus a one-line count-by-type summary before the detail bullets (e.g., "Orders: 12 new, 3 removed, 4 formula changes").
  • For 5+ datasources in Mode B: present summary counts first, then expand only datasources with changes.