DENOMINATOR
91 / 110 = 82.7273%
Pool successes and eligible cases. Averaging the group rates, 10% and 90%, would produce 50%.
AI WORKFLOW / AGENT ENGINEERING
An agent computes 140. The real engineering question is whether it knows what that number leaves out.
A reproducible local tool workflow that binds results to sources, preserves analytical definitions and keeps release decisions explicit.
Synthetic data. Actual Python execution. No live model benchmark.
Known revenue subtotal
One missing price. A complete revenue total is unknown.
01 / SYSTEM DESIGN
A small, inspectable boundary between a host that requests work and a local executor that can prove what it did.
Purpose, definitions, authority and current state survive the conversation.
AGENTS.md + contracts/Inspect inputs, then request a supported tool with the current source digest.
JSON in · fixed toolsValidate arguments, calculate, check eligibility and retain artifacts.
Python · standard libraryRecheck source and result integrity. Carry limitations into the next step.
Result + receiptNative application review and human release approval remain outside this executor. A successful run cannot grant either.
The prototype accepts three named tools through a strict JSON contract. It does not turn model-generated text into a shell command. That makes behavior and failure paths easier to inspect.
The host and operating system still control permissions and isolation. Path checks and an allowlist are application controls. This project does not claim to be an OS sandbox.
02 / FAILURE EXPLORER
This browser illustration explains the contract. Selecting a scenario does not execute Python or call a model.
The arithmetic is valid for the known contributions. Missing price and duplicated customer keys restrict the answer.
Known subtotal: 140 fictional units across 4 of 5 rows. Complete total unknown. Customer-segment join blocked by duplicate C2.
Next action: resolve the missing price and customer-key conflict through the data owner; retain the current qualified result.
03 / ANALYTICAL CONTRACT
The fixture is small enough to recompute by hand. These semantics are preserved before an agent interprets the result.
DENOMINATOR
Pool successes and eligible cases. Averaging the group rates, 10% and 90%, would produce 50%.
MEANING OF ZERO
Filling a blank price with zero can leave the displayed subtotal unchanged while making a false completeness claim.
JOIN CARDINALITY
A repeated dimension key can multiply transaction rows. Deduplication requires an explicit rule, not a silent repair.
| Transaction | Quantity | Unit price | Discount | Contribution |
|---|---|---|---|---|
| T1 | 2 | 100 | 10% | 180 |
| T2 | −1 | 100 | 10% | −90 |
| T3 | 1 | 50 | 0% | 50 |
| T4 | 1 | Missing | 0% | Unknown |
| T5 | 1 | 0 | 0% | 0 |
Known subtotal: 180 − 90 + 50 + 0 = 140. Four of five rows are known. No revenue-coverage percentage or causal conclusion follows.
04 / EXECUTION EVIDENCE
This section presents a retained local run. It does not check your current filesystem or certify a model host.
Read the retained logs for the exact test scope and limitations.
python -B examples/run_demo.py --workspace . --output-dir runs/my-reviewUse a new output directory for each demonstration. Python 3.10+ is the intended baseline; see the report for the version actually tested.
Loading bundled receipt...
05 / ENGINEERING JUDGMENT
Persistent rules and hash-bound inputs travel with the project. Actual loading, tool calling and permissions still depend on the host.
Checksums can detect changed bytes. They do not authenticate the author, establish source truth or protect records from an actor who controls them all.
A standard-library runner keeps this example inspectable. It does not provide centralized lineage, production concurrency or infrastructure isolation.
Excel/BI and managed plugins can belong in the broader workflow. Their availability and native acceptance must be demonstrated in the actual application.
Specific comparisons, not a claim of industry certification.
NEXT VERIFIED MILESTONE
The next step is a named Claude or open-weight execution host, a fresh-session loading check and a bounded evaluation plan. This prototype makes that integration reviewable; it does not claim it has happened.
Read the host integration procedure