Companion Resource

Downloads

The sample data and the numbers that prove your work.

How the checkpoints work. Clean the messy file, run the book's formulas, and confirm your totals land on the values below. Data is clean when it reconciles, not when it looks tidy.

The clean dataset

Excel · .xlsx

A full year of sales, 320 transactions, as an Excel table named Sales. Total revenue reconciles to 1,486,717.56. For Chapters 6, 8, 9, 10 and 11.

DownloadSales_Transactions.xlsx · 22 KB

The messy edition

Excel · .xlsx

The same year as it really arrives: trailing spaces, European text numbers, mixed dates, a block pasted twice. Clean it and prove your work (Chapter 7).

DownloadSales_Transactions_DIRTY.xlsx · 34 KB

Checkpoints & reference tables

Excel · .xlsx

The reconciliation checkpoints, revenue by region, and per-product price bands for anomaly detection.

DownloadCompanion_Workbook.xlsx · 8 KB

All prompts, as text

Text · .txt

The twelve institutional prompts in one plain-text file.

DownloadPrompt_Library.txt · 7 KB

Reconciliation checkpoints

Every figure below is computed directly from the clean dataset.

CheckpointValue
Total revenue, all rows1,486,717.56
North revenue on the Online channel136,767.11
Revenue by region · North307,047
Revenue by region · South410,292
Revenue by region · East411,678
Revenue by region · West357,700
Gross margin44%