Task 1 complete. All deliverables are in `output/`. ## Results (October 2026, CAD — provisional) | Metric | Workshop | Course | Combined | |---|---:|---:|---:| | Paid orders | 5 | 4 | 9 | | Gross sales | 1,920.00 | 900.00 | 2,820.00 | | Applied refunds | 240.00 | 60.00 | 300.00 | | Net revenue | 1,680.00 | 840.00 | 2,520.00 | | Ad spend | 300.00 | 150.00 | 450.00 | | Contribution after ads | 1,380.00 | 690.00 | 2,070.00 | | Net revenue / paid order | 336.00 | 210.00 | 280.00 | Provisional because settled refund RF05 (refunds.csv R06) has a missing amount — preserved as unknown, never zero, per policy. ## Handoff **Output files** - `output/cleaned-sales.csv` — 9 paid October orders (source row IDs preserved; S03;S04 collapsed, S10 kept over S09 per latest `updated_at`) - `output/cleaned-refunds.csv` — 2 applied refunds (RF01, RF02; product inherited from linked order) - `output/cleaned-ads.csv` — 5 October ads (AD03 duplicate collapsed, channels normalized) - `output/exceptions.csv` — 13 entries covering all duplicates, the superseded conflict, and every exclusion/flag (pending, cancelled, out-of-period, orphan order N9999, missing refund amount) - `output/summary.md` — full reconciliation, method, assumptions, recommendation (resolve RF05/RF04 first; cautious Workshop budget tilt; contribution ≠ profit since COGS, fees, salaries, overhead are not supplied) - `output/reconcile.py` — reproducible script (stdlib only), identical to the executed version **Checks actually performed** - Ran the script; assertion passed: all 29 raw row IDs accounted for exactly once across cleaned provenance + exclusions (15 sales, 7 refunds, 7 ads) - Hand-calculated totals independently — matched script output - Verified both applied refunds ≤ their order's paid gross (240≤480; 60≤240) - Read back all four output CSVs line by line; fixed two issues found during checks (row-ID accounting logic for collapsed duplicates; duplicate-detail wording) - Raw inputs untouched (only read; sizes listed post-run) **Remaining limitations** - Net revenue/contribution provisional until RF05's amount is recovered (combined floor 2,040.00 if RF05=360.00 cap and RF04=120.00 proves valid) - RF04's order N9999 is absent from sales data — needs source-system follow-up, not resolvable from inputs - No causal ad-attribution or cost data; refund product attribution assumed from linked order (documented in summary.md) - Only Task 1 inputs were supplied; no site/ exists for a Task 3 **Estimated human finish time:** ~20–30 minutes (review exception dispositions, confirm RF05/RF04 externally, sign off) — an estimate, not a measured result.