2
Critical
Issues that need attention
Sample report — Financial model
Synthetic example. No workbook was analyzed.
- Sheets:
- 5
- Hidden:
- 2
- Formula cells:
- 1248
- Cells scanned:
- 12430
- Analyzer
- v0.8.4
0
High
Important issues
13
Review
Suggestions to review
3
Info
FYI items
Show
5 of 5 sheets have findings
All sheets with findings: 18 findings
- Critical2
- High0
- Review13
- Info3
X-Ray
OverviewInspect workbook structure, cell composition, and direct formula relationships.
Explore sheets, inspect cells, and trace direct dependencies in a full workspace.
- Formula cells
- 1,248
- Numeric constants
- 188
- Text cells
- 290
- Hidden sheets
- 2
10% of scanned cells
1.5% of scanned cells
2.3% of scanned cells
40% of total sheets
Workbook facts
- Sheets
- 5
- Visible
- 3
- Hidden
- 1
- Very hidden
- 1
- Cells scanned
- 12,430
- Exact one-hop links
- 2,997
Cell composition
- Formula
- Numeric
- Text
- Other
Workbook at a glance
High formula density
This workbook has more formula cells than constants or text combined.
1 very hidden sheet
This sheet is hidden very deeply and is easy to overlook.
2,997 exact one-hop links
Built from exact cell references to power Trace and navigation.
Composition by sheet
| Sheet | Formula % | Constants % | Text % | Hidden |
|---|---|---|---|---|
| Summary | 73% | 8.3% | 16.7% | Visible |
| Revenue | 77.4% | 7.3% | 14.7% | Visible |
| P&L | 79.3% | 5.6% | 14.8% | Visible |
| Debt | 71.4% | 11.7% | 15.6% | Very hidden |
| Assumptions | 20.3% | 46.4% | 29% | Hidden |
Most referenced
Longest formulas
What you can do here
Explore structure
See how your workbook is organized.
Inspect any cell
Understand formulas, values, and context.
Trace relationships
See precedents and dependents at a glance.
Jump with confidence
Navigate directly to what matters.
Showing a bounded structural window starting at C8
Fit
- Formula
- Numeric constant
- Error
- Text
- Boolean
- Date
- Styled empty
- Other
Worksheet map is bounded for this sheet. Some cells may not be shown.
A1:R56
Fit
Enter a cell such as A1 or Sheet!A1.
- Critical
- High
- Review
- Info
- Workbook error
- Selected
- Trace
Use Arrow keys to move one cell. Tab leaves the worksheet.
readyFindings
18 total18 findings visible| Severity | Sheet | Cell / range | What was found |
|---|---|---|---|
Formula error | SheetDebt | Cell / rangeH22 | What was found This cell shows an error value (#DIV/0!). A reviewer will see it too. |
Formula error | SheetSummary | Cell / rangeC18 | What was found This cell shows an error value (#REF!). A reviewer will see it too. |
Hardcode in formula block | SheetAssumptions | Cell / rangeE22 in E20:E25 | What was found A typed-in number appears inside a formula-driven pattern (E20:E25). Review whether the hardcode is intentional. |
Volatile function | SheetAssumptions | Cell / rangeF7 | What was found This formula uses INDIRECT. It works, but it makes the model harder to follow because the referenced cell is not visible in the formula. |
Hardcode in formula block | SheetAssumptions | Cell / rangeJ14 in G14:L14 | What was found A typed-in number appears inside a formula-driven pattern (G14:L14). Review whether the hardcode is intentional. |
Hardcode in formula block | SheetDebt | Cell / rangeK12 in H12:M12 | What was found A typed-in number appears inside a formula-driven pattern (H12:M12). Review whether the hardcode is intentional. |
Hidden sheet | SheetDebt | Cell / rangeWhole sheet | What was found The sheet "Debt" is set to very-hidden, which a reader cannot unhide from Excel's normal menu. Worth disclosing that it is there. |
Formula inconsistency | SheetP&L | Cell / rangeG42 in E42:J42 | What was found This cell's formula has a different shape from the others in the same row (E42:J42). Review whether the difference is intentional before changing it. |
Blank in formula run | SheetP&L | Cell / rangeH28 in G28:I28 | What was found There is an empty cell in the middle of a row of formulas (G28:I28). It may be a gap that should have a formula. |
External link | SheetRevenue | Cell / rangeG8 | What was found This formula points to another workbook (Budget_inputs.xlsx). Links like this often stop working when the file moves. |
Formula inconsistency | SheetRevenue | Cell / rangeH16 in E16:J16 | What was found This cell's formula has a different shape from the others in the same row (E16:J16). Review whether the difference is intentional before changing it. |
Out-of-view formulas or numbers | SheetRevenue | Cell / rangeJ24 | What was found This visible sheet contains formulas or numbers in rows or columns that are out of view. |
Formula error | SheetSummary | Cell / rangeB9 | What was found This cell shows #N/A. That can be intentional in lookup logic, so it is worth a closer look. |
Out-of-view formulas or numbers | SheetSummary | Cell / rangeC18 | What was found This visible sheet contains formulas or numbers in rows or columns that are out of view. |
Circularity disclosure | SheetSummary | Cell / rangeWhole sheet | What was found This workbook has iterative calculation switched on, which usually means there is a circular reference inside. That can be intentional, but a reader should know. |
Hidden sheet | SheetAssumptions | Cell / rangeWhole sheet | What was found The sheet "Assumptions" is hidden. That may be fine, so just make sure you meant to leave it out of view. |
Volatile function | SheetRevenue | Cell / rangeWhole sheet | What was found This model uses volatile functions (TODAY (2)), which recalculate every time the file changes. Usually fine, and noted so you are aware. |
Volatile function | SheetSummary | Cell / rangeWhole sheet | What was found This model uses volatile functions (NOW (1), RAND (1)), which recalculate every time the file changes. Usually fine, and noted so you are aware. |