SheetBrain Detector Set v0.1

Identity

SheetBrain Detector Set v0.1 is the archived detector bundle referenced by SheetBrain audit reports generated under detector set v0.1. Its detector list, severity mapping, verdict thresholds, and hash remain immutable.

Standard version	v0.1
Detector set name	SheetBrain Detector Set v0.1
Detector set version	v0.1
Release date	2026-04-29
Status	Archived and immutable

Content hash:

fb627b72c250bcf01da3c11c572e49431a356504794c1af7b72171fdd17c4be9

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.
`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.1.

Scope limits

Detector Set v0.1 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 header cells are excluded from the evaluated data-cell count.
Cross-sheet duplicate-key checks are intentionally out of scope in v0.1.

Limitations

Detector Set v0.1 checks spreadsheet structure, formulas, type consistency, and selected data-quality risks. It does not verify source data accuracy, certify business assumptions, validate external data sources, or replace review by a qualified decision-maker.

A Trusted verdict means no v0.1 critical formula integrity risks or unresolved structural data issues were found in the evaluated scope. It is not a guarantee that the spreadsheet's business conclusion is correct.

v0.1 changelog

2026-04-29: Initial published detector set for verdict-first public audit reports.

Added broken_reference as an error-class detector.
Added mixed_text_number as a warning-class detector.
Added duplicate_lookup_key as a warning-class detector.
Published Standard v0.1 verdict thresholds and detector-set hash.