AI engineering spreadsheet audit
Check arithmetic, units and formula references with deterministic calculations alongside AI explanations. A fluent explanation is not an independently verified result.
Synthetic evaluation input
row,power_kw,hours,displayed_mwh A,120,3000,360 B,80,2500,200000 Rule: MWh = power_kw * hours / 1000.
Original Inzonex training example, version 1.0. No customer document or real equipment data. No model has been scored on this page.
Expected fields
| Field | Reference answer |
|---|---|
| A_mwh | 360 |
| B_mwh | 200 |
| incorrect_row | "B" |
| output_unit | "MWh" |
Check a structured response
The comparison runs in your browser against this answer key. It checks exact fields and values, not the accuracy of an explanation or a model's general ability.
Recommended workflow
Calculate the reference result with ordinary code or spreadsheet formulas. Use AI to locate and explain discrepancies, not as the sole arithmetic authority.
A spreadsheet audit should start with the intended quantity and unit. Multiplying power by operating time produces energy, but changing the output from kWh to MWh requires a conversion. A correct multiplication with an incorrect label is still a failed calculation.
The packet includes one deliberately inconsistent displayed result. The checker expects the numerical reference, the unit and the identity of the inconsistent row. It does not accept an explanation alone, because a reviewer needs a reproducible calculation.
For an actual workbook, also inspect hidden sheets, named ranges, external links and whether cells contain values or formulas. This small CSV example does not exercise those workbook features. Keep the original workbook unchanged and review proposed changes as a diff.
Failure checks
- Apply the kWh-to-MWh conversion exactly once.
- Flag row B without changing its source inputs.
- Keep the output unit with the result.
What this exercise does not prove
This arithmetic packet does not validate a plant model, an Excel file parser or the assumptions behind an energy study.
For an actual evaluation, keep a separate held-out set, record tool/model version and settings, and log raw outputs, corrections, elapsed time and actual charges. Do not compare tools tested on different inputs as though they ran the same benchmark.
What is checked in AI engineering spreadsheet audit?
Check arithmetic, units and formula references with deterministic calculations alongside AI explanations. A fluent explanation is not an independently verified result.
What does AI engineering spreadsheet audit not prove?
This arithmetic packet does not validate a plant model, an Excel file parser or the assumptions behind an energy study.
Related tasks
Match this workflow to your data requirements
Methodology and reuse
These packets and answer keys are original Inzonex educational material, licensed CC BY 4.0. Attribute Inzonex and link to this task page when reusing the packet. The licence does not cover third-party material linked from this site.
NIST AI 600-1: background on generative AI evaluation and risk. This exercise is not NIST-certified.