Task by Task · Free local practice
Use a known-answer dataset to inspect an AI analysis method
Actual locally checked fictional workbook and native control cases. This example runs locally; files selected here stay in browser memory.
Try a boundary that a total misses
- A: 10, 0, unknown
- B: 5
- Stable unique record IDs
A duplicate zero row leaves the sum unchanged. Row counts and key checks reveal the error that a total-only test misses.
Take the technique to your next job
Analyse this small control file before applying the method to my larger file.
Group by the supplied category. Preserve unique record IDs.
Report the known subtotal, numeric count and unavailable count separately.
A blank amount is unknown; an explicit zero is a known number.
Show which source rows contribute to each answer. Stop if a record ID
is duplicated or missing, a group is outside the supplied set, or an
amount contains invalid text. Return the calculation method and actual file.