{
  "object": "evidence",
  "slug": "duke-oh-ds",
  "checked_at": "2026-10-07T03:07:18+00:00",
  "summary": {
    "examples": 14,
    "passing": 14,
    "external_oracle_examples": 14,
    "external_oracle_passing": 14
  },
  "provenance_legend": {
    "oracle": "expected values come from the utility's own published calculator/bill - an external check",
    "derived_from_encoding": "expected values were computed from the encoded rates - a regression check, not an external one"
  },
  "results": [
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: May (month 5), DS01, 10,000 kWh, 30 kW, single phase, no supplier",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=5, L3=No, L4=10000, L6=30, L9=1, L7=N. June revision's built-in May case (calculator_2026 DS!A26 = $1,311.93) is reproduced cent-exact by the revised workbook: M62 = 1311.926 -> displays $1,311.93. Line values = each line's workbook cell(s) rounded to cents.",
      "billing_period": {
        "end": "2026-05-31",
        "start": "2026-05-01"
      },
      "inputs": {
        "billing_month": 5,
        "customer_choice": false,
        "kw": 30,
        "kwh": 10000,
        "phase": 1,
        "rate_code": "DS01"
      },
      "expected_total": 1311.93,
      "computed_total": 1311.93,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: JANUARY rates (month 1), DS01, 10,000 kWh, 30 kW, single phase, no supplier",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=1, L3=No, L4=10000, L6=30, L9=1, L7=N. June revision's built-in January case (calculator_2026 DS!A22 = $1,319.25) reproduced by the revised workbook: M62 = 1319.246 -> $1,319.25. Exercises the month-keyed rider tables against the May row.",
      "billing_period": {
        "end": "2026-01-31",
        "start": "2026-01-01"
      },
      "inputs": {
        "billing_month": 1,
        "customer_choice": false,
        "kw": 30,
        "kwh": 10000,
        "phase": 1,
        "rate_code": "DS01"
      },
      "expected_total": 1319.25,
      "computed_total": 1319.25,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: Load Management (DS03), May (month 5), 10,000 kWh, 30 kW, single phase, no supplier",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=5, L3=Yes, L4=10000, L6=30, L9=1, L7=N. Revised workbook with Load Management = Yes (DS03 per the rate-code table DS!C47:E52): M62 = 1320.766 -> $1,320.77. Percent-rider base H28 = 23 + 209.03 + 7.50 = 239.53. PINS the LMR-in-base semantic (Sheets 76/82 + 77/80/103/105): an encoding that excludes LMR from the base (the superseded June hidden-matrix reading, which gave $1,319.43) fails replay here.",
      "billing_period": {
        "end": "2026-05-31",
        "start": "2026-05-01"
      },
      "inputs": {
        "billing_month": 5,
        "customer_choice": false,
        "kw": 30,
        "kwh": 10000,
        "phase": 1,
        "rate_code": "DS03"
      },
      "expected_total": 1320.77,
      "computed_total": 1320.77,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: Customer Choice, May (month 5), DS01, 10,000 kWh, 30 kW, single phase, supplier at $0.0406/kWh",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=5, L3=No, L4=10000, L6=30, L9=1, L7=Y, L8=0.0406. Revised workbook with Customer Choice = Y, supplier rate 0.0406: M62 = 849.386 -> $849.39. Generation lines AER-R/RC/RE/SCR zero; supplier charge = L8 x entered kWh (L60).",
      "billing_period": {
        "end": "2026-05-31",
        "start": "2026-05-01"
      },
      "inputs": {
        "billing_month": 5,
        "customer_choice": true,
        "kw": 30,
        "kwh": 10000,
        "phase": 1,
        "rate_code": "DS01",
        "supplier_rate": 0.0406
      },
      "expected_total": 849.39,
      "computed_total": 849.39,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: June (month 6), DS01, 10,000 kWh, 30 kW, single phase, no supplier",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=6, L3=No, L4=10000, L6=30, L9=1, L7=N. First newly published month: M62 = 1363.1060000000002 -> $1,363.11. Exercises the June ESRR (2.44%) and RC/RE (Sheets 111.18/112.18) rows.",
      "billing_period": {
        "end": "2026-06-30",
        "start": "2026-06-01"
      },
      "inputs": {
        "billing_month": 6,
        "customer_choice": false,
        "kw": 30,
        "kwh": 10000,
        "phase": 1,
        "rate_code": "DS01"
      },
      "expected_total": 1363.11,
      "computed_total": 1363.11,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: July (month 7), DS01, 10,000 kWh, 30 kW, single phase, no supplier",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=7, L3=No, L4=10000, L6=30, L9=1, L7=N. M62 = 1361.756 -> $1,361.76. Exercises the July DCI (18.124%), DR-ECF (0.96%), AER-R (0.000426) and SCR (-0.008156) rows.",
      "billing_period": {
        "end": "2026-07-31",
        "start": "2026-07-01"
      },
      "inputs": {
        "billing_month": 7,
        "customer_choice": false,
        "kw": 30,
        "kwh": 10000,
        "phase": 1,
        "rate_code": "DS01"
      },
      "expected_total": 1361.76,
      "computed_total": 1361.76,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: NON-DEFAULT: August (month 8), Load Management (DS03), three phase, 25,000 kWh, 75.5 kW",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=8, L3=Yes, L4=25000, L6=75.5, L9=3, L7=N. M62 = 3393.1431000000002 -> $3,393.14. Fractional kW makes the demand charge 526.071 (base uses ROUND -> 526.07; percent base 46 + 526.07 + 7.50 = 579.57); 25,000 kWh reaches OET tier 3 and RC blocks 1-3 (block edges 11,325 / 22,650 kWh).",
      "billing_period": {
        "end": "2026-08-31",
        "start": "2026-08-01"
      },
      "inputs": {
        "billing_month": 8,
        "customer_choice": false,
        "kw": 75.5,
        "kwh": 25000,
        "phase": 3,
        "rate_code": "DS03"
      },
      "expected_total": 3393.14,
      "computed_total": 3393.14,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: NON-DEFAULT: September (month 9, summer), Customer Choice at $0.0999/kWh, DS01, three phase, 10,000 kWh, 100 kW",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=9, L3=No, L4=10000, L6=100, L9=3, L7=Y, L8=0.0999. M62 = 2280.4 -> $2,280.40. Summer-month Customer Choice: the revised workbook bills the distribution demand charge (the June revision's T18 zeroed it in summer under Customer Choice - a workbook bug fixed in this revision; the encoding never zeroed it).",
      "billing_period": {
        "end": "2026-09-30",
        "start": "2026-09-01"
      },
      "inputs": {
        "billing_month": 9,
        "customer_choice": true,
        "kw": 100,
        "kwh": 10000,
        "phase": 3,
        "rate_code": "DS01",
        "supplier_rate": 0.0999
      },
      "expected_total": 2280.4,
      "computed_total": 2280.4,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: Revised workbook built-in saved case: October (month 10), DS01, three phase, 10,000 kWh, 100 kW, no supplier",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=10, L3=No, L4=10000, L6=100, L9=3, L7=N. Read directly from the workbook's CACHED cell values as saved by Duke (M62 = 2414.142 -> $2,414.14); pycel re-evaluation agrees. Exercises the October PIPP, BTR, RTEP, DCI, AER-R and SCR rows.",
      "billing_period": {
        "end": "2026-10-31",
        "start": "2026-10-01"
      },
      "inputs": {
        "billing_month": 10,
        "customer_choice": false,
        "kw": 100,
        "kwh": 10000,
        "phase": 3,
        "rate_code": "DS01"
      },
      "expected_total": 2414.14,
      "computed_total": 2414.14,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: NON-DEFAULT: October (month 10), Load Management (DS03), three phase, 1,000,000 kWh, 2,000 kW",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=10, L3=Yes, L4=1000000, L6=2000, L9=3, L7=N. M62 = 111322.65359999999 -> $111,322.65. Large-load case: PIPP crosses its 833,000 kWh block (833,000 x 0.0024282 + 167,000 x 0.000469), OET tier 3, RC block 4 (100,000 kWh beyond 450 kWh/kW).",
      "billing_period": {
        "end": "2026-10-31",
        "start": "2026-10-01"
      },
      "inputs": {
        "billing_month": 10,
        "customer_choice": false,
        "kw": 2000,
        "kwh": 1000000,
        "phase": 3,
        "rate_code": "DS03"
      },
      "expected_total": 111322.65,
      "computed_total": 111322.65,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: February (month 2), DS01, three phase, 20,000 kWh, 40 kW (high load factor)",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=2, L3=No, L4=20000, L6=40, L9=3, L7=N. M62 = 2265.428 -> $2,265.43. Exercises the month-2 rider row and Rider RC block 4 at the month 1-5 rate (2,000 kWh beyond 450 kWh/kW).",
      "billing_period": {
        "end": "2026-02-28",
        "start": "2026-02-01"
      },
      "inputs": {
        "billing_month": 2,
        "customer_choice": false,
        "kw": 40,
        "kwh": 20000,
        "phase": 3,
        "rate_code": "DS01"
      },
      "expected_total": 2265.43,
      "computed_total": 2265.43,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: March (month 3), Load Management (DS07), single phase, 3,500 kWh, 12 kW",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=3, L3=Yes, L4=3500, L6=12, L9=1, L7=N. M62 = 517.7683999999999 -> $517.77. Exercises the month-3 row (ETCJA 2.75%, UE-ED 1.32, UE-GEN 0.24 first month) and an LMR small-business code; percent base 23 + 83.61 + 7.50 = 114.11. The workbook's displayed total is one cent below the sum of cent-rounded lines (unrounded OET/PIPP/BTR/AER-R/SCR cells) - the encoding's workbook-exact rounding reproduces it.",
      "billing_period": {
        "end": "2026-03-31",
        "start": "2026-03-01"
      },
      "inputs": {
        "billing_month": 3,
        "customer_choice": false,
        "kw": 12,
        "kwh": 3500,
        "phase": 1,
        "rate_code": "DS07"
      },
      "expected_total": 517.77,
      "computed_total": 517.77,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: April (month 4), Load Management (DS08), three phase, 50,000 kWh, 150 kW",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=4, L3=Yes, L4=50000, L6=150, L9=3, L7=N. M62 = 6440.44 -> $6,440.44. Exercises the month-4 row (DCI 18.611%, AER-R 0.000763, SCR -0.008327 first month) and OET tier 3; percent base 46 + 1045.17 + 7.50 = 1098.67.",
      "billing_period": {
        "end": "2026-04-30",
        "start": "2026-04-01"
      },
      "inputs": {
        "billing_month": 4,
        "customer_choice": false,
        "kw": 150,
        "kwh": 50000,
        "phase": 3,
        "rate_code": "DS08"
      },
      "expected_total": 6440.44,
      "computed_total": 6440.44,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    },
    {
      "version_id": "duke_oh_ds@2026-01-01",
      "name": "Revised-workbook oracle: September (month 9, summer), DS01, single phase, 6,000 kWh, 50 kW (low load factor)",
      "provenance": "oracle",
      "source": "Expected values minted by evaluating calculator_2026_oct's OWN cell formulas with pycel 1.0b30 (fidelity check first: all 642 formula cells on both sheets reproduce the workbook's cached values at its saved inputs, 0 mismatches). UI inputs L2=9, L3=No, L4=6000, L6=50, L9=1, L7=N. M62 = 1337.6480000000001 -> $1,337.65. Exercises the month-9 generation rows (AER-R, RC block 1 only, RE, SCR) that the Customer Choice month-9 fixture zeroes.",
      "billing_period": {
        "end": "2026-09-30",
        "start": "2026-09-01"
      },
      "inputs": {
        "billing_month": 9,
        "customer_choice": false,
        "kw": 50,
        "kwh": 6000,
        "phase": 1,
        "rate_code": "DS01"
      },
      "expected_total": 1337.65,
      "computed_total": 1337.65,
      "lines_checked": 26,
      "line_mismatches": {},
      "tolerance_usd": 0.01,
      "pass": true
    }
  ]
}