Identity
SheetBrain Detector Set v0.2 is the archived detector bundle referenced by SheetBrain audit reports generated under detector set v0.2. Its detector list, severity mapping, verdict thresholds, and hash remain immutable.
| Standard version | v0.1 |
|---|---|
| Detector set name | SheetBrain Detector Set v0.2 |
| Detector set version | v0.2 |
| Release date | 2026-04-30 |
| Status | Archived and immutable |
Content hash:
445792adb43c484cc1efea7f71e8eb377019ff37862a97890d3e2279d7324e43
Once published, this detector set version is not silently edited. Detector additions, removals, severity changes, and verdict-policy changes require a new detector set version.
Included detectors
| Issue type | Severity | What it checks |
|---|---|---|
broken_reference |
error | Flags active formula failures such as #REF! outputs and lookup formulas that request a column or row outside the referenced range. |
visible_formula_error |
error | Flags formula cells returning visible error values: #N/A, #VALUE!, #DIV/0!, #NAME?, #NUM!, #NULL!, or #ERROR!. Literal text values are not flagged. |
mixed_text_number |
warning | Flags columns that mix numeric and text-stored values, a common source of silent SUMIFS, COUNTIFS, and AVERAGEIFS mistakes. |
duplicate_lookup_key |
warning | Flags lookup-key columns with duplicate values when used by VLOOKUP or XLOOKUP, because those formulas silently return the first matching row. |
Verdict thresholds
| Verdict | Threshold |
|---|---|
| Critical | errorCount > 0 |
| Has open issues | errorCount === 0 && warningCount > 0 |
| Trusted | errorCount === 0 && warningCount === 0 |
Informational findings do not affect the verdict in v0.2.
Scope limits
Detector Set v0.2 evaluates the bounded data sent to the SheetBrain backend for the audit. Public reports describe this as data cells evaluated (headers excluded).
- Maximum evaluated rows per sheet: 1,000 data rows.
- Maximum evaluated columns per sheet: 50 columns.
- Headers are used for context but are not counted as evaluated data cells.
- The scan evaluates the workbook snapshot sent at audit-generation time, not future changes.
Limitations
- Does not verify source data accuracy, completeness, authorization, or business assumptions.
- Does not certify that a spreadsheet is suitable for a specific legal, tax, audit, investment, or procurement decision.
- Does not validate external data sources, API integrations, named-range references outside the evaluated scope, or third-party add-on output.
- Does not detect formula drift after a column move or rename. SheetBrain Repair handles that separately with a schema snapshot and AI-assisted rewrites.
v0.2 changelog
- Added
visible_formula_erroras an error detector for formula cells returning #N/A, #VALUE!, #DIV/0!, #NAME?, #NUM!, #NULL!, or #ERROR!. - Kept
#REF!underbroken_referenceto preserve the more specific broken-reference explanation and lookup-index auto-fix behavior. - Kept verdict thresholds, scope limits, report schema version, and Standard version unchanged from v0.1.
Prior detector set: SheetBrain Detector Set v0.1.