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.11
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
Findings
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. |