{
  "id": "sales-ledger-q1",
  "kind": "spreadsheets",
  "version": "v1",
  "answers": [
    {
      "key": "error_count",
      "question": "How many planted problems does the sheet contain (errors plus warnings)?",
      "answer": 10,
      "type": "number",
      "unit": null,
      "tolerance": 0,
      "evidence": [],
      "errors": 9,
      "warnings": 1
    },
    {
      "key": "error_cells",
      "question": "Which cells are involved in planted problems?",
      "answer": [
        "B5",
        "H17",
        "F28",
        "A33",
        "A34",
        "B39",
        "D41",
        "F45",
        "B50",
        "H52",
        "A58",
        "H58",
        "H63",
        "H70",
        "H71"
      ],
      "type": "list",
      "unit": null,
      "tolerance": null,
      "evidence": [],
      "order_matters": false
    },
    {
      "key": "corrected_grand_total",
      "question": "What is the grand total of line totals after fixing every error?",
      "answer": "42616.70",
      "type": "money",
      "unit": "USD",
      "tolerance": 0.005,
      "evidence": [],
      "computed_from": "H63 after applying every fix",
      "note": "The F45 outlier is left as is (it needs confirmation)."
    },
    {
      "key": "corrected_total_units",
      "question": "What are the total units after fixing every error?",
      "answer": 438,
      "type": "number",
      "unit": null,
      "tolerance": 0,
      "evidence": [],
      "computed_from": "F63 after applying every fix"
    },
    {
      "key": "e01-wrong_reference",
      "question": "Which line-total formula multiplies by the unit price from the wrong row?",
      "answer": {
        "error_type": "wrong_reference",
        "cells": [
          "H17"
        ],
        "severity": "error",
        "description": "Line total uses the unit price of the row above (G16) instead of its own row (G17).",
        "fix": "=F17*G17"
      },
      "type": "object",
      "unit": null,
      "tolerance": null,
      "evidence": [
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "=F17*G16",
          "bbox": null,
          "cell": "H17",
          "line": null
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "269.55",
          "bbox": null,
          "cell": "H17",
          "line": 17
        }
      ]
    },
    {
      "key": "e02-duplicate_row",
      "question": "Which order appears twice?",
      "answer": {
        "error_type": "duplicate_row",
        "cells": [
          "A33",
          "A34"
        ],
        "severity": "error",
        "description": "Row 34 repeats row 33 (SO-2026-0032) field for field, so the order is counted twice.",
        "fix": "Delete row 34."
      },
      "type": "object",
      "unit": null,
      "tolerance": null,
      "evidence": [
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "SO-2026-0032",
          "bbox": null,
          "cell": "A33",
          "line": null
        },
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "SO-2026-0032",
          "bbox": null,
          "cell": "A34",
          "line": null
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "SO-2026-0032",
          "bbox": null,
          "cell": "A33",
          "line": 33
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "SO-2026-0032",
          "bbox": null,
          "cell": "A34",
          "line": 34
        }
      ]
    },
    {
      "key": "e03-outlier",
      "question": "Which quantity is far outside the normal range?",
      "answer": {
        "error_type": "outlier",
        "cells": [
          "F45"
        ],
        "severity": "warning",
        "description": "Quantity 40 where every other order is between 1 and 12 units; probably a keying error.",
        "fix": "Confirm with the customer; do not correct without a source.",
        "typical_range": [
          1,
          12
        ]
      },
      "type": "object",
      "unit": null,
      "tolerance": null,
      "evidence": [
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "40",
          "bbox": null,
          "cell": "F45",
          "line": null
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "40",
          "bbox": null,
          "cell": "F45",
          "line": 45
        }
      ]
    },
    {
      "key": "e04-number_as_text",
      "question": "Which quantity is stored as text instead of a number?",
      "answer": {
        "error_type": "number_as_text",
        "cells": [
          "F28"
        ],
        "severity": "error",
        "description": "F28 holds the text '5'. The line total still works (Excel coerces text in arithmetic) but SUM(F2:F61) skips it, so the total units are understated.",
        "fix": "Convert F28 to a number."
      },
      "type": "object",
      "unit": null,
      "tolerance": null,
      "evidence": [
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "5",
          "bbox": null,
          "cell": "F28",
          "line": null
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "5",
          "bbox": null,
          "cell": "F28",
          "line": 28
        }
      ]
    },
    {
      "key": "e05-mixed_date_formats",
      "question": "Which order dates are text in a different format?",
      "answer": {
        "error_type": "mixed_date_formats",
        "cells": [
          "B5",
          "B39",
          "B50"
        ],
        "severity": "error",
        "description": "Three dates are text in other formats (MM/DD/YYYY, D Mon YYYY, YYYY.MM.DD) instead of real dates; they sort and filter wrongly, and B5 (01/09/2026) could be read month-first or day-first.",
        "fix": "Convert to real dates: B5=2026-01-09, B39=2026-02-14, B50=2026-02-22.",
        "intended": {
          "B5": "2026-01-09",
          "B39": "2026-02-14",
          "B50": "2026-02-22"
        }
      },
      "type": "object",
      "unit": null,
      "tolerance": null,
      "evidence": [
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "01/09/2026",
          "bbox": null,
          "cell": "B5",
          "line": null
        },
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "14 Feb 2026",
          "bbox": null,
          "cell": "B39",
          "line": null
        },
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "2026.02.22",
          "bbox": null,
          "cell": "B50",
          "line": null
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "01/09/2026",
          "bbox": null,
          "cell": "B5",
          "line": 5
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "14 Feb 2026",
          "bbox": null,
          "cell": "B39",
          "line": 39
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "2026.02.22",
          "bbox": null,
          "cell": "B50",
          "line": 50
        }
      ]
    },
    {
      "key": "e06-hidden_row",
      "question": "Which hidden row is included in the totals but should not be?",
      "answer": {
        "error_type": "hidden_row",
        "cells": [
          "A58",
          "H58"
        ],
        "severity": "error",
        "description": "Row 58 is hidden and holds a test order (999.00) that SUM and SUMIF still include.",
        "fix": "Delete row 58."
      },
      "type": "object",
      "unit": null,
      "tolerance": null,
      "evidence": [
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "TEST-0000",
          "bbox": null,
          "cell": "A58",
          "line": null,
          "hidden_row": true
        },
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "=F58*G58",
          "bbox": null,
          "cell": "H58",
          "line": null,
          "hidden_row": true
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "TEST-0000",
          "bbox": null,
          "cell": "A58",
          "line": 58
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "999.00",
          "bbox": null,
          "cell": "H58",
          "line": 58
        }
      ]
    },
    {
      "key": "e07-inconsistent_category",
      "question": "Which region value is misspelled, and what does it break?",
      "answer": {
        "error_type": "inconsistent_category",
        "cells": [
          "D41",
          "H70"
        ],
        "severity": "error",
        "description": "Region 'Esat' in D41 matches no SUMIF, so the region totals add up to less than the grand total.",
        "fix": "Change D41 to East."
      },
      "type": "object",
      "unit": null,
      "tolerance": null,
      "evidence": [
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "Esat",
          "bbox": null,
          "cell": "D41",
          "line": null
        },
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "=SUM(H66:H69)",
          "bbox": null,
          "cell": "H70",
          "line": null
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "Esat",
          "bbox": null,
          "cell": "D41",
          "line": 41
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "44834.80",
          "bbox": null,
          "cell": "H70",
          "line": 70
        }
      ]
    },
    {
      "key": "e08-hardcoded_value",
      "question": "Which line total is a typed-in number instead of a formula, and wrong?",
      "answer": {
        "error_type": "hardcoded_value",
        "cells": [
          "H52"
        ],
        "severity": "error",
        "description": "H52 is the constant 354.30, not =F52*G52, and differs from quantity x unit price.",
        "fix": "=F52*G52"
      },
      "type": "object",
      "unit": null,
      "tolerance": null,
      "evidence": [
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "354.30",
          "bbox": null,
          "cell": "H52",
          "line": null
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "354.30",
          "bbox": null,
          "cell": "H52",
          "line": 52
        }
      ]
    },
    {
      "key": "e09-formula_range",
      "question": "Which total formula leaves out a data row?",
      "answer": {
        "error_type": "formula_range",
        "cells": [
          "H63"
        ],
        "severity": "error",
        "description": "The grand total sums H2:H60 and misses the last order in row 61.",
        "fix": "=SUM(H2:H61)"
      },
      "type": "object",
      "unit": null,
      "tolerance": null,
      "evidence": [
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "=SUM(H2:H60)",
          "bbox": null,
          "cell": "H63",
          "line": null
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "44312.70",
          "bbox": null,
          "cell": "H63",
          "line": 63
        }
      ]
    },
    {
      "key": "e10-mismatched_total",
      "question": "Which reported figure disagrees with the computed total?",
      "answer": {
        "error_type": "mismatched_total",
        "cells": [
          "H71",
          "H63"
        ],
        "severity": "error",
        "description": "'Reported to finance' is a typed-in 41431.10 that matches neither the sheet's grand total nor the corrected total.",
        "fix": "=H63"
      },
      "type": "object",
      "unit": null,
      "tolerance": null,
      "evidence": [
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "41431.10",
          "bbox": null,
          "cell": "H71",
          "line": null
        },
        {
          "file": "sales-ledger-q1.xlsx",
          "page": null,
          "quote": "=SUM(H2:H60)",
          "bbox": null,
          "cell": "H63",
          "line": null
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "41431.10",
          "bbox": null,
          "cell": "H71",
          "line": 71
        },
        {
          "file": "sales-ledger-q1.csv",
          "page": null,
          "quote": "44312.70",
          "bbox": null,
          "cell": "H63",
          "line": 63
        }
      ]
    }
  ]
}