<!--
 ╔══════════════════════════════════════════════════════════════╗
 ║  PharmLink — HCP Override Calculator (v1.2)                 ║
 ║  Created: 29 Mar 2026                                       ║
 ║  Author:  Claude (Anthropic) for PharmLink                  ║
 ║  Type:    Standalone HTML tool — serve via local HTTP server ║
 ║                                                             ║
 ║  MISSION                                                    ║
 ║  ─────────────────────────────────────────────────────────── ║
 ║  Provides a manual HCP override calculator and live record  ║
 ║  updater for PharmLink operators. Two modes:                ║
 ║                                                             ║
 ║  MODE 1 — CALCULATOR (offline)                              ║
 ║  Enter supplier cost and market/benchmark prices manually.  ║
 ║  The calculator runs the HCP Engine v1.8 waterfall and      ║
 ║  shows the resulting HCP, Product Cost, Gross Markup %,     ║
 ║  Pharmacy Profit, and PharmLink Profit. Operators can also  ║
 ║  set HCP directly to model "what if" scenarios.             ║
 ║                                                             ║
 ║  MODE 2 — LIVE LOOKUP + WRITE-BACK (requires PAT)          ║
 ║  Enter a Variant Key, GTIN, or Product Name fragment to     ║
 ║  search PRC_Pricing_Engine in Base 03. The tool loads the   ║
 ║  live record (including all formula fields), populates      ║
 ║  the calculator, and allows the operator to write a new     ║
 ║  Home Care Price (ex GST) back to the record.               ║
 ║                                                             ║
 ║  PRODUCT COST FORMULA (mirrors Airtable formula)            ║
 ║  ─────────────────────────────────────────────────────────── ║
 ║  Product Cost = Supplier Best Net + (Gross Profit ×         ║
 ║                 Pharmacy Profit Share %)                     ║
 ║  Where: Gross Profit = HCP − Supplier Best Net              ║
 ║  This is the cost to PharmLink — what the pharmacy takes    ║
 ║  home (their buy price plus their share of the margin).     ║
 ║  PharmLink Profit = HCP − Product Cost                      ║
 ║                   = Gross Profit × PharmLink %              ║
 ║                                                             ║
 ║  PRICING LOGIC (mirrors HCP Engine v1.8)                    ║
 ║  ─────────────────────────────────────────────────────────── ║
 ║  1. IA path: midpoint(IA, marked-up RRP) or discount × IA  ║
 ║  2. Other Market path: midpoint or discount × market        ║
 ║  3. RRP-only path: marked-up RRP used directly              ║
 ║  4. Supplier floor: cost × floor multiplier                 ║
 ║                                                             ║
 ║  PROFIT SPLIT (from CTRL_Profit_Settings)                   ║
 ║  ─────────────────────────────────────────────────────────── ║
 ║  Band     | Lower | Upper | Pharmacy % | PharmLink %        ║
 ║  <0%      |   —   |   0%  |   100%     |    0%              ║
 ║  0–15%    |   0%  |  15%  |    85%     |   15%              ║
 ║  15–30%   |  15%  |  30%  |    80%     |   20%              ║
 ║  30–45%   |  30%  |  45%  |    75%     |   25%              ║
 ║  45–60%   |  45%  |  60%  |    70%     |   30%              ║
 ║  >60%     |  60%  |   —   |    65%     |   35%              ║
 ║                                                             ║
 ║  CHANGES FROM v1.1                                          ║
 ║  ─────────────────────────────────────────────────────────── ║
 ║  - Write-back now writes BOTH override fields in a single   ║
 ║    PATCH: "HCP Override Price (ex GST)" AND                 ║
 ║    "Home Care Price (ex GST)".                              ║
 ║  - Supplier Override: new writable field allows operator     ║
 ║    to override supplier cost. Writes to                     ║
 ║    "Supplier Override Price (ex GST)" on PRC_Pricing_Engine.║
 ║  - Both override fields are editable before writing.        ║
 ║  - Clear overrides button: clears both override fields      ║
 ║    on the record (sets to null) so pipeline recalculates.   ║
 ║                                                             ║
 ║  CHANGES FROM v1.0                                          ║
 ║  ─────────────────────────────────────────────────────────── ║
 ║  - Product Cost formula corrected: now includes Pharmacy    ║
 ║    Profit Share (was incorrectly using raw supplier net).   ║
 ║  - Live record lookup: search PRC_Pricing_Engine by         ║
 ║    Variant Key, GTIN, or Product Name (requires PAT).      ║
 ║  - Write-back: push overridden HCP back to Base 03          ║
 ║    PRC_Pricing_Engine "Home Care Price (ex GST)" field.     ║
 ║  - PAT sanitisation matches Publish Review portal pattern.  ║
 ║                                                             ║
 ║  SERVE VIA: python3 -m http.server 8080                     ║
 ╚══════════════════════════════════════════════════════════════╝
-->
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>PharmLink — HCP Override Calculator v1.2</title>
<link rel="preconnect" href="https://fonts.googleapis.com">
<link href="https://fonts.googleapis.com/css2?family=DM+Sans:ital,opsz,wght@0,9..40,300;0,9..40,400;0,9..40,500;0,9..40,600;0,9..40,700;1,9..40,400&family=JetBrains+Mono:wght@400;500;600&display=swap" rel="stylesheet">
<style>
:root{--bg:#0f1117;--surface:#181b23;--surface-2:#1f232e;--surface-3:#272c3a;--border:#2a2f3e;--border-focus:#4a7cff;--text:#e4e7ef;--text-muted:#8891a5;--text-dim:#5c6478;--accent:#4a7cff;--accent-glow:rgba(74,124,255,.15);--green:#34d399;--green-bg:rgba(52,211,153,.08);--green-border:rgba(52,211,153,.25);--amber:#fbbf24;--amber-bg:rgba(251,191,36,.08);--amber-border:rgba(251,191,36,.25);--red:#f87171;--red-bg:rgba(248,113,113,.08);--teal:#2dd4bf;--teal-bg:rgba(45,212,191,.08);--purple:#a78bfa;--radius:10px;--radius-sm:6px;--mono:'JetBrains Mono',monospace;--sans:'DM Sans',-apple-system,sans-serif}
*{margin:0;padding:0;box-sizing:border-box}
body{font-family:var(--sans);background:var(--bg);color:var(--text);min-height:100vh;line-height:1.5;-webkit-font-smoothing:antialiased}
.app{max-width:1120px;margin:0 auto;padding:32px 24px 64px}
.header{margin-bottom:28px;padding-bottom:20px;border-bottom:1px solid var(--border)}
.header-row{display:flex;align-items:baseline;gap:12px;flex-wrap:wrap}
.header h1{font-size:22px;font-weight:600;letter-spacing:-.3px}
.header .version{font-family:var(--mono);font-size:12px;color:var(--accent);background:var(--accent-glow);padding:2px 8px;border-radius:4px;font-weight:500}
.header p{color:var(--text-muted);font-size:14px;margin-top:4px}
.layout{display:grid;grid-template-columns:1fr 1fr;gap:20px}
@media(max-width:780px){.layout{grid-template-columns:1fr}}
.card{background:var(--surface);border:1px solid var(--border);border-radius:var(--radius);padding:20px;margin-bottom:16px}
.card-title{font-size:12px;font-weight:600;text-transform:uppercase;letter-spacing:.8px;color:var(--text-muted);margin-bottom:16px;display:flex;align-items:center;gap:8px}
.card-title .dot{width:8px;height:8px;border-radius:50%;display:inline-block}
.field{margin-bottom:14px}
.field:last-child{margin-bottom:0}
.field label{display:block;font-size:11px;font-weight:500;color:var(--text-muted);margin-bottom:5px;letter-spacing:.3px}
.field input,.field select{width:100%;background:var(--surface-2);border:1px solid var(--border);border-radius:var(--radius-sm);padding:9px 12px;font-family:var(--mono);font-size:13px;color:var(--text);transition:border-color .15s,box-shadow .15s;outline:none}
.field input:focus,.field select:focus{border-color:var(--border-focus);box-shadow:0 0 0 3px var(--accent-glow)}
.field input::placeholder{color:var(--text-dim);font-weight:400}
.field .hint{font-size:10px;color:var(--text-dim);margin-top:3px}
.field-row{display:grid;grid-template-columns:1fr 1fr;gap:10px}
.divider{height:1px;background:var(--border);margin:16px 0}
.toggle-row{display:flex;align-items:center;gap:10px;margin-bottom:14px;cursor:pointer;user-select:none}
.toggle-row input[type="checkbox"]{width:16px;height:16px;accent-color:var(--accent);cursor:pointer}
.toggle-row span{font-size:12px;font-weight:500;color:var(--text-muted)}
.result-grid{display:grid;grid-template-columns:1fr 1fr;gap:12px}
.result-item{background:var(--surface-2);border:1px solid var(--border);border-radius:var(--radius-sm);padding:14px;transition:border-color .2s}
.result-item.highlight-green{border-color:var(--green-border);background:var(--green-bg)}
.result-item.highlight-amber{border-color:var(--amber-border);background:var(--amber-bg)}
.result-item.highlight-red{background:var(--red-bg);border-color:rgba(248,113,113,.25)}
.result-item .label{font-size:10px;font-weight:500;text-transform:uppercase;letter-spacing:.6px;color:var(--text-muted);margin-bottom:4px}
.result-item .value{font-family:var(--mono);font-size:20px;font-weight:600;letter-spacing:-.5px}
.result-item .sub{font-size:11px;color:var(--text-dim);margin-top:3px;font-family:var(--mono)}
.method-badge{display:inline-block;font-family:var(--mono);font-size:11px;font-weight:600;padding:3px 9px;border-radius:4px;background:var(--accent-glow);color:var(--accent);letter-spacing:.3px}
.method-badge.direct{background:rgba(45,212,191,.12);color:var(--teal)}
.band-row{display:flex;gap:3px;margin-top:12px;margin-bottom:6px}
.band-segment{flex:1;height:5px;border-radius:3px;background:var(--surface-3);transition:background .3s}
.band-segment.active{background:var(--accent)}
.band-segment.negative{background:var(--red)}
.band-labels{display:flex;gap:3px;margin-bottom:10px}
.band-labels span{flex:1;text-align:center;font-size:9px;font-family:var(--mono);color:var(--text-dim);font-weight:500}
.band-labels span.active{color:var(--accent);font-weight:600}
.band-labels span.negative{color:var(--red);font-weight:600}
.trace{margin-top:12px;padding:12px 14px;background:var(--surface-2);border:1px solid var(--border);border-radius:var(--radius-sm);font-family:var(--mono);font-size:11px;line-height:1.8;color:var(--text-muted);white-space:pre-wrap;max-height:260px;overflow-y:auto}
.trace .step{color:var(--text-dim)}.trace .hit{color:var(--green)}.trace .miss{color:var(--text-dim);opacity:.5}.trace .override{color:var(--amber)}
.profit-table{width:100%;border-collapse:collapse;margin-top:10px;font-size:12px}
.profit-table th{text-align:left;font-size:10px;font-weight:600;text-transform:uppercase;letter-spacing:.5px;color:var(--text-dim);padding:6px 0;border-bottom:1px solid var(--border)}
.profit-table td{padding:8px 0;border-bottom:1px solid var(--border);color:var(--text-muted)}
.profit-table td:last-child{text-align:right;font-family:var(--mono);font-weight:500;color:var(--text)}
.profit-table tr:last-child td{border-bottom:none}
.profit-table .pharmacy-row td{color:var(--green)}.profit-table .pharmlink-row td{color:var(--accent)}.profit-table .neg td:last-child{color:var(--red)}
.btn{padding:8px 18px;border:none;border-radius:var(--radius-sm);font-family:var(--sans);font-weight:600;font-size:12px;cursor:pointer;transition:opacity .15s}
.btn:hover{opacity:.85}
.btn:disabled{opacity:.4;cursor:not-allowed}
.btn-accent{background:var(--accent);color:#fff}
.btn-green{background:var(--green);color:#0f1117}
.btn-red{background:var(--red);color:#fff}
.status-msg{font-size:11px;font-family:var(--mono);padding:8px 12px;border-radius:var(--radius-sm);margin-top:10px;display:none}
.status-msg.show{display:block}
.status-msg.ok{background:var(--green-bg);color:var(--green);border:1px solid var(--green-border)}
.status-msg.err{background:var(--red-bg);color:var(--red);border:1px solid rgba(248,113,113,.25)}
.status-msg.loading{background:var(--accent-glow);color:var(--accent);border:1px solid rgba(74,124,255,.3)}
.record-info{font-size:11px;color:var(--text-dim);font-family:var(--mono);margin-top:6px;line-height:1.6}
.footer{margin-top:28px;padding-top:14px;border-top:1px solid var(--border);font-size:11px;color:var(--text-dim);font-family:var(--mono);text-align:center}
</style>
</head>
<body>
<div class="app">
  <div class="header">
    <div class="header-row">
      <h1>HCP Override Calculator</h1>
      <span class="version">v1.2</span>
    </div>
    <p>Manual price calculator + live record lookup/write-back — mirrors HCP Engine v1.9</p>
  </div>

  <!-- ═══ CONNECTION PANEL ═══ -->
  <div class="card" style="margin-bottom:20px;">
    <div class="card-title"><span class="dot" style="background:var(--amber)"></span> Airtable Connection (optional — for live lookup)</div>
    <div class="field-row">
      <div class="field">
        <label>Airtable PAT</label>
        <input type="password" id="pat" placeholder="pat..." autocomplete="off">
      </div>
      <div class="field">
        <label>Base 03 ID (Commercial)</label>
        <input type="text" id="base03" value="app4drhOqGOeIXZW0" placeholder="app...">
      </div>
    </div>
    <div class="field-row" style="margin-top:10px;">
      <div class="field">
        <label>Search (Variant Key, GTIN, Product Name, or PharmLink ID)</label>
        <input type="text" id="searchTerm" placeholder="e.g. GTIN14:0932... or bandage or 1234">
      </div>
      <div class="field" style="display:flex;align-items:flex-end;gap:8px;">
        <button class="btn btn-accent" id="searchBtn" onclick="doSearch()">Search</button>
        <button class="btn btn-red" id="clearBtn" onclick="clearRecord()" style="display:none;">Clear</button>
      </div>
    </div>
    <div class="field-row" style="margin-top:6px;">
      <div class="field">
        <label>Base 04 ID (Publish — for PharmLink ID lookup)</label>
        <input type="text" id="base04" value="appihcZNsiprkv26J" placeholder="app...">
        <div class="hint">Only needed when searching by PharmLink ID number</div>
      </div>
      <div class="field"></div>
    </div>
    <div id="searchStatus" class="status-msg"></div>
    <div id="recordInfo" class="record-info" style="display:none;"></div>
  </div>

  <div class="layout">
    <!-- ═══ LEFT: Inputs ═══ -->
    <div>
      <div class="card">
        <div class="card-title"><span class="dot" style="background:var(--accent)"></span> Supplier Cost</div>
        <div class="field">
          <label>Best Supplier Net Price (ex GST)</label>
          <input type="text" id="supplierNet" placeholder="0.00" inputmode="decimal">
          <div class="hint">Lowest net cost across CH2/Symbion</div>
        </div>
      </div>
      <div class="card">
        <div class="card-title"><span class="dot" style="background:var(--green)"></span> Market Prices</div>
        <div class="field">
          <label>IA Price (ex GST)</label>
          <input type="text" id="iaPrice" placeholder="0.00" inputmode="decimal">
        </div>
        <div class="field">
          <label>Other Market Price (ex GST)</label>
          <input type="text" id="otherMarket" placeholder="0.00" inputmode="decimal">
        </div>
        <div class="field">
          <label>RRP (ex GST)</label>
          <input type="text" id="rrp" placeholder="0.00" inputmode="decimal">
        </div>
      </div>
      <div class="card">
        <div class="card-title"><span class="dot" style="background:var(--purple)"></span> Engine Settings</div>
        <div class="field-row">
          <div class="field"><label>Market Discount %</label><input type="text" id="marketDiscount" value="97" inputmode="decimal"></div>
          <div class="field"><label>Supplier Floor %</label><input type="text" id="floorMultiplier" value="18" inputmode="decimal"></div>
        </div>
        <div class="field-row">
          <div class="field"><label>RRP Markup %</label><input type="text" id="rrpMarkup" value="0" inputmode="decimal"></div>
          <div class="field"><label>GST Rate %</label>
            <select id="gstRate"><option value="0" selected>GST Free (0%)</option><option value="10">Standard GST (10%)</option></select>
          </div>
        </div>
      </div>
      <div class="card">
        <div class="card-title"><span class="dot" style="background:var(--teal)"></span> Direct Override</div>
        <div class="toggle-row" onclick="toggleDirect()">
          <input type="checkbox" id="directToggle">
          <span>Set HCP directly (bypass waterfall)</span>
        </div>
        <div class="field" id="directField" style="display:none;">
          <label>Home Care Price (ex GST)</label>
          <input type="text" id="directHcp" placeholder="0.00" inputmode="decimal">
        </div>
      </div>
      <!-- Write-back -->
      <div class="card" id="writeBackCard" style="display:none;">
        <div class="card-title"><span class="dot" style="background:var(--amber)"></span> Write Overrides to Base 03</div>
        <div class="field">
          <label>HCP Override Price (ex GST)</label>
          <input type="text" id="writeHcp" placeholder="Calculated HCP" inputmode="decimal">
          <div class="hint">Writes to "HCP Override Price (ex GST)" + "Home Care Price (ex GST)"</div>
        </div>
        <div class="field">
          <label>Supplier Override Price (ex GST)</label>
          <input type="text" id="writeSupplier" placeholder="Leave blank to keep pipeline value" inputmode="decimal">
          <div class="hint">Writes to "Supplier Override Price (ex GST)" — overrides MIN(CH2,Symbion)</div>
        </div>
        <div style="display:flex;gap:8px;margin-top:10px;">
          <button class="btn btn-green" id="writeBtn" onclick="doWriteBack()">Write Overrides</button>
          <button class="btn btn-red" id="clearOverridesBtn" onclick="doClearOverrides()">Clear All Overrides</button>
        </div>
        <div id="writeStatus" class="status-msg"></div>
      </div>
    </div>

    <!-- ═══ RIGHT: Results ═══ -->
    <div>
      <div class="card">
        <div class="card-title"><span class="dot" style="background:var(--green)"></span> Calculated Output</div>
        <div style="margin-bottom:12px;"><span class="method-badge" id="methodBadge">—</span></div>
        <div class="result-grid">
          <div class="result-item" id="hcpResult">
            <div class="label">Home Care Price (ex GST)</div>
            <div class="value" id="hcpValue">—</div>
            <div class="sub" id="hcpIncGst"></div>
          </div>
          <div class="result-item" id="costResult">
            <div class="label">Product Cost (ex GST)</div>
            <div class="value" id="costValue">—</div>
            <div class="sub" id="costIncGst"></div>
          </div>
        </div>
        <div style="height:12px;"></div>
        <div class="result-grid">
          <div class="result-item" id="markupResult">
            <div class="label">Gross Markup %</div>
            <div class="value" id="markupValue">—</div>
            <div class="sub" id="markupDollar"></div>
          </div>
          <div class="result-item" id="bandResult">
            <div class="label">Markup Band</div>
            <div class="value" id="bandValue" style="font-size:16px;">—</div>
          </div>
        </div>
        <div class="band-row" id="bandVisual">
          <div class="band-segment" data-band="<0%"></div>
          <div class="band-segment" data-band="0-15%"></div>
          <div class="band-segment" data-band="15-30%"></div>
          <div class="band-segment" data-band="30-45%"></div>
          <div class="band-segment" data-band="45-60%"></div>
          <div class="band-segment" data-band=">60%"></div>
        </div>
        <div class="band-labels" id="bandLabels">
          <span data-band="<0%">&lt;0%</span><span data-band="0-15%">0–15</span><span data-band="15-30%">15–30</span><span data-band="30-45%">30–45</span><span data-band="45-60%">45–60</span><span data-band=">60%">&gt;60%</span>
        </div>
      </div>
      <div class="card">
        <div class="card-title"><span class="dot" style="background:var(--amber)"></span> Profit Breakdown</div>
        <table class="profit-table">
          <thead><tr><th>Line Item</th><th style="text-align:right;">Amount</th></tr></thead>
          <tbody id="profitBody"><tr><td colspan="2" style="color:var(--text-dim);text-align:center;padding:20px 0;">Enter prices above</td></tr></tbody>
        </table>
      </div>
      <div class="card">
        <div class="card-title"><span class="dot" style="background:var(--text-dim)"></span> Waterfall Trace</div>
        <div class="trace" id="traceOutput">Waiting for input…</div>
      </div>
    </div>
  </div>
  <div class="footer">PharmLink · HCP Override Calculator v1.2 · Mirrors HCP Engine v1.9 · Product Cost = SupplierNet + (GrossProfit × PharmacyShare%) · 29 Mar 2026</div>
</div>

<script>
// ═══ PROFIT BANDS (from CTRL_Profit_Settings CSV) ═══
const PROFIT_BANDS = [
  { name: "<0%",    lower: null, upper: 0,    pharmacyPct: 1.00, pharmlinkPct: 0.00 },
  { name: "0-15%",  lower: 0,    upper: 0.15, pharmacyPct: 0.85, pharmlinkPct: 0.15 },
  { name: "15-30%", lower: 0.15, upper: 0.30, pharmacyPct: 0.80, pharmlinkPct: 0.20 },
  { name: "30-45%", lower: 0.30, upper: 0.45, pharmacyPct: 0.75, pharmlinkPct: 0.25 },
  { name: "45-60%", lower: 0.45, upper: 0.60, pharmacyPct: 0.70, pharmlinkPct: 0.30 },
  { name: ">60%",   lower: 0.60, upper: null, pharmacyPct: 0.65, pharmlinkPct: 0.35 },
];

// ═══ State ═══
let currentRecord = null; // { id, fields } from Airtable

// ═══ Helpers ═══
function parseNum(id) {
  const v = document.getElementById(id).value.replace(/[$,\s]/g, '');
  const n = parseFloat(v);
  return isFinite(n) && n > 0 ? n : null;
}
function parsePct(id) {
  const v = document.getElementById(id).value.replace(/[%,\s]/g, '');
  const n = parseFloat(v);
  return isFinite(n) ? n : null;
}
function fmt(n) { return (n === null || n === undefined) ? '—' : '$' + n.toFixed(2); }
function fmtPct(n) { return (n === null || n === undefined) ? '—' : n.toFixed(1) + '%'; }
function round2(n) { return Math.round(n * 100) / 100; }
function esc(s) { return s.replace(/&/g,'&amp;').replace(/</g,'&lt;').replace(/>/g,'&gt;'); }

function getBand(markupDecimal) {
  for (const b of PROFIT_BANDS) {
    const aboveLower = (b.lower === null) || (markupDecimal >= b.lower);
    const belowUpper = (b.upper === null) || (markupDecimal < b.upper);
    if (aboveLower && belowUpper) return b;
  }
  return PROFIT_BANDS[PROFIT_BANDS.length - 1];
}

function parseCurrency(v) {
  if (v === null || v === undefined) return null;
  if (typeof v === 'number') return v;
  const s = String(v).replace(/[$,\s]/g, '');
  const n = parseFloat(s);
  return isFinite(n) ? n : null;
}

// ═══ HCP Waterfall (mirrors HCP Engine v1.8) ═══
function calcHCP(supplierBest, iaPrice, otherMarket, rrp, settings) {
  const trace = [];
  const floorMult = 1 + (settings.floorPct / 100);
  const mktDiscount = settings.marketDiscountPct / 100;
  const rrpMult = 1 + (settings.rrpMarkupPct / 100);

  trace.push(`Supplier Net:    ${fmt(supplierBest)}`);
  trace.push(`IA Price:        ${fmt(iaPrice)}`);
  trace.push(`Other Market:    ${fmt(otherMarket)}`);
  trace.push(`RRP:             ${fmt(rrp)}`);
  trace.push(`──────────────────────────────`);
  trace.push(`Floor mult:      ${floorMult.toFixed(2)}×`);
  trace.push(`Market discount: ${(mktDiscount * 100).toFixed(0)}%`);
  trace.push(`RRP markup:      ${settings.rrpMarkupPct}%`);
  trace.push(``);

  if (supplierBest === null || supplierBest <= 0) {
    trace.push(`✗ No supplier cost → NO_SUPPLIER`);
    return { price: null, method: 'NO_SUPPLIER', trace };
  }

  const floor = round2(supplierBest * floorMult);
  const effectiveRRP = (rrp !== null) ? round2(rrp * rrpMult) : null;

  trace.push(`Supplier floor:  ${fmt(floor)}  (${fmt(supplierBest)} × ${floorMult.toFixed(2)})`);
  if (effectiveRRP !== null && rrpMult !== 1)
    trace.push(`Effective RRP:   ${fmt(effectiveRRP)}  (${fmt(rrp)} × ${rrpMult.toFixed(2)})`);
  trace.push(``);

  let candidatePrice = null, candidateMethod = null;

  if (iaPrice !== null) {
    trace.push(`→ IA path`);
    if (effectiveRRP !== null && effectiveRRP > iaPrice) {
      candidatePrice = round2((iaPrice + effectiveRRP) / 2);
      candidateMethod = 'IA_RRP_MKP_MIDPOINT';
      trace.push(`  ✓ RRP > IA → midpoint(${fmt(iaPrice)}, ${fmt(effectiveRRP)}) = ${fmt(candidatePrice)}`);
    } else {
      candidatePrice = round2(mktDiscount * iaPrice);
      candidateMethod = 'IA_97PCT';
      if (effectiveRRP !== null) trace.push(`  ✗ RRP ≤ IA — no midpoint`);
      trace.push(`  ✓ ${(mktDiscount*100).toFixed(0)}% × ${fmt(iaPrice)} = ${fmt(candidatePrice)}`);
    }
  } else if (otherMarket !== null) {
    trace.push(`→ Other Market path`);
    if (effectiveRRP !== null && effectiveRRP > otherMarket) {
      candidatePrice = round2((otherMarket + effectiveRRP) / 2);
      candidateMethod = 'OTHER_RRP_MKP_MIDPOINT';
      trace.push(`  ✓ RRP > market → midpoint(${fmt(otherMarket)}, ${fmt(effectiveRRP)}) = ${fmt(candidatePrice)}`);
    } else {
      candidatePrice = round2(mktDiscount * otherMarket);
      candidateMethod = 'OTHER_97PCT';
      if (effectiveRRP !== null) trace.push(`  ✗ RRP ≤ market — no midpoint`);
      trace.push(`  ✓ ${(mktDiscount*100).toFixed(0)}% × ${fmt(otherMarket)} = ${fmt(candidatePrice)}`);
    }
  } else if (effectiveRRP !== null) {
    trace.push(`→ RRP-only path`);
    candidatePrice = effectiveRRP;
    candidateMethod = 'RRP_ONLY';
    trace.push(`  ✓ Using marked-up RRP: ${fmt(effectiveRRP)}`);
  } else {
    trace.push(`✗ No market data → NO_BENCHMARK`);
    return { price: null, method: 'NO_BENCHMARK', trace };
  }

  trace.push(``);
  if (floor > candidatePrice) {
    trace.push(`⚠ Floor ${fmt(floor)} > candidate ${fmt(candidatePrice)} → SUPPLIER_FLOOR`);
    return { price: floor, method: 'SUPPLIER_FLOOR', trace };
  }

  trace.push(`✓ Candidate ${fmt(candidatePrice)} > floor ${fmt(floor)} → ${candidateMethod}`);
  return { price: candidatePrice, method: candidateMethod, trace };
}

// ═══ Direct toggle ═══
function toggleDirect() {
  const cb = document.getElementById('directToggle');
  cb.checked = !cb.checked;
  document.getElementById('directField').style.display = cb.checked ? 'block' : 'none';
  recalc();
}
document.getElementById('directToggle').addEventListener('click', function(e) {
  e.stopPropagation();
  document.getElementById('directField').style.display = this.checked ? 'block' : 'none';
  recalc();
});

// ═══ Main recalculation ═══
function recalc() {
  const supplierNet = parseNum('supplierNet');
  const iaPrice     = parseNum('iaPrice');
  const otherMarket = parseNum('otherMarket');
  const rrp         = parseNum('rrp');
  const directMode  = document.getElementById('directToggle').checked;
  const directHcp   = parseNum('directHcp');
  const gstRate     = parseFloat(document.getElementById('gstRate').value) / 100;

  const settings = {
    floorPct:          parsePct('floorMultiplier') ?? 18,
    marketDiscountPct: parsePct('marketDiscount') ?? 97,
    rrpMarkupPct:      parsePct('rrpMarkup') ?? 0,
  };

  let hcp, method, traceLines;

  if (directMode && directHcp !== null) {
    hcp = directHcp;
    method = 'DIRECT_OVERRIDE';
    traceLines = [`Direct override: ${fmt(hcp)}`, `Supplier Net:    ${fmt(supplierNet)}`, ``, `✓ HCP set manually — waterfall bypassed`];
  } else if (directMode) {
    updateUI(null, null, null, null, 'DIRECT_OVERRIDE', ['Waiting for direct HCP input…']);
    return;
  } else {
    const result = calcHCP(supplierNet, iaPrice, otherMarket, rrp, settings);
    hcp = result.price;
    method = result.method;
    traceLines = result.trace;
  }

  updateUI(hcp, supplierNet, gstRate, getBandForCalc(hcp, supplierNet), method, traceLines);
}

function getBandForCalc(hcp, supplierNet) {
  if (hcp === null || supplierNet === null || supplierNet <= 0) return null;
  const markupDecimal = (hcp - supplierNet) / supplierNet;
  return getBand(markupDecimal);
}

function updateUI(hcp, supplierNet, gstRate, band, method, traceLines) {
  // Method badge
  const badge = document.getElementById('methodBadge');
  badge.textContent = method || '—';
  badge.className = 'method-badge' + (method === 'DIRECT_OVERRIDE' ? ' direct' : '');

  // HCP
  document.getElementById('hcpValue').textContent = fmt(hcp);
  document.getElementById('hcpIncGst').textContent =
    hcp !== null && gstRate !== null ? `inc GST: ${fmt(round2(hcp * (1 + gstRate)))}` : '';

  // Gross Profit & Markup
  let grossProfit = null, markupPct = null;
  if (hcp !== null && supplierNet !== null && supplierNet > 0) {
    grossProfit = round2(hcp - supplierNet);
    markupPct = round2(((hcp - supplierNet) / supplierNet) * 100);
  }

  // Product Cost (corrected v1.1 formula)
  // Product Cost = Supplier Net + (Gross Profit × Pharmacy Profit Share %)
  let productCost = null;
  if (hcp !== null && supplierNet !== null && supplierNet > 0 && band) {
    productCost = round2(supplierNet + (grossProfit * band.pharmacyPct));
  }

  // PharmLink Profit = HCP - Product Cost = Gross Profit × PharmLink%
  let pharmlinkProfit = null;
  if (hcp !== null && productCost !== null) {
    pharmlinkProfit = round2(hcp - productCost);
  }

  // Cost display
  document.getElementById('costValue').textContent = fmt(productCost);
  document.getElementById('costIncGst').textContent =
    productCost !== null && gstRate !== null ? `inc GST: ${fmt(round2(productCost * (1 + gstRate)))}` : '';

  // Markup
  const markupEl = document.getElementById('markupResult');
  document.getElementById('markupValue').textContent = markupPct !== null ? fmtPct(markupPct) : '—';
  document.getElementById('markupDollar').textContent = grossProfit !== null ? `Gross profit: ${fmt(grossProfit)}` : '';
  markupEl.className = 'result-item';
  if (markupPct !== null) {
    if (markupPct < 0) markupEl.className += ' highlight-red';
    else if (markupPct >= 30) markupEl.className += ' highlight-green';
    else if (markupPct >= 15) markupEl.className += ' highlight-amber';
  }

  // Band
  document.getElementById('bandValue').textContent = band ? band.name : '—';
  document.querySelectorAll('.band-segment').forEach(el => {
    el.className = 'band-segment';
    if (band && el.dataset.band === band.name)
      el.className += band.name === '<0%' ? ' negative' : ' active';
  });
  document.querySelectorAll('.band-labels span').forEach(el => {
    el.className = '';
    if (band && el.dataset.band === band.name)
      el.className = band.name === '<0%' ? 'negative' : 'active';
  });

  // Profit breakdown
  const profitBody = document.getElementById('profitBody');
  if (hcp === null || supplierNet === null || supplierNet <= 0 || grossProfit === null || !band) {
    profitBody.innerHTML = '<tr><td colspan="2" style="color:var(--text-dim);text-align:center;padding:20px 0;">Enter prices above</td></tr>';
  } else {
    const pharmacyProfit = round2(grossProfit * band.pharmacyPct);
    const pharmlinkGross = round2(grossProfit * band.pharmlinkPct);
    const isNeg = grossProfit < 0;
    profitBody.innerHTML = `
      <tr><td>Home Care Price (ex GST)</td><td>${fmt(hcp)}</td></tr>
      <tr><td>− Supplier Best Net (ex GST)</td><td>${fmt(supplierNet)}</td></tr>
      <tr class="${isNeg ? 'neg' : ''}"><td><strong>= Gross Profit</strong></td><td><strong>${fmt(grossProfit)}</strong></td></tr>
      <tr><td colspan="2" style="padding:2px 0;border:none;"></td></tr>
      <tr><td style="color:var(--text-dim);">Pharmacy share (${(band.pharmacyPct*100).toFixed(0)}%)</td><td style="color:var(--text-dim);">${fmtPct(band.pharmacyPct*100)}</td></tr>
      <tr class="pharmacy-row"><td>Pharmacy Profit</td><td>${fmt(pharmacyProfit)}</td></tr>
      <tr><td colspan="2" style="padding:2px 0;border:none;"></td></tr>
      <tr><td style="color:var(--text-dim);">PharmLink share (${(band.pharmlinkPct*100).toFixed(0)}%)</td><td style="color:var(--text-dim);">${fmtPct(band.pharmlinkPct*100)}</td></tr>
      <tr class="pharmlink-row"><td>PharmLink Gross Profit</td><td>${fmt(pharmlinkGross)}</td></tr>
      <tr><td colspan="2" style="padding:2px 0;border:none;"></td></tr>
      <tr><td><strong>Product Cost (ex GST)</strong></td><td><strong>${fmt(productCost)}</strong></td></tr>
      <tr><td style="color:var(--text-dim);font-size:10px;">= SupplierNet + (GrossProfit × PharmacyShare%)</td><td></td></tr>
    `;
  }

  // Write-back field — auto-populate HCP when record loaded and value changes
  if (hcp !== null && currentRecord) {
    const writeEl = document.getElementById('writeHcp');
    // Only auto-fill if the field is currently empty or matches previous auto-fill
    if (!writeEl.dataset.userEdited) {
      writeEl.value = hcp.toFixed(2);
    }
  }

  // Write-back field — auto-populate supplier override from the supplier cost input
  if (supplierNet !== null && currentRecord) {
    const writeSupEl = document.getElementById('writeSupplier');
    if (!writeSupEl.dataset.userEdited) {
      writeSupEl.value = supplierNet.toFixed(2);
    }
  }

  // Trace
  const traceEl = document.getElementById('traceOutput');
  if (traceLines && traceLines.length) {
    traceEl.innerHTML = traceLines.map(line => {
      if (line.startsWith('✓')) return `<span class="hit">${esc(line)}</span>`;
      if (line.startsWith('✗')) return `<span class="miss">${esc(line)}</span>`;
      if (line.startsWith('⚠')) return `<span class="override">${esc(line)}</span>`;
      if (line.startsWith('→')) return `<span class="step">${esc(line)}</span>`;
      return esc(line);
    }).join('\n');
  } else {
    traceEl.textContent = 'Waiting for input…';
  }
}

// ═══ Airtable API helpers ═══
function getPat() { return (document.getElementById('pat').value || '').trim(); }
function getBase03() { return (document.getElementById('base03').value || '').trim(); }

async function atFetch(url) {
  const pat = getPat();
  const resp = await fetch(url, { headers: { 'Authorization': `Bearer ${pat}` } });
  return resp;
}

async function atPatch(url, body) {
  const pat = getPat();
  const resp = await fetch(url, {
    method: 'PATCH',
    headers: { 'Authorization': `Bearer ${pat}`, 'Content-Type': 'application/json' },
    body: JSON.stringify(body),
  });
  return resp;
}

function setSearchStatus(msg, cls) {
  const el = document.getElementById('searchStatus');
  el.textContent = msg;
  el.className = 'status-msg show ' + cls;
}
function clearSearchStatus() {
  document.getElementById('searchStatus').className = 'status-msg';
}
function setWriteStatus(msg, cls) {
  const el = document.getElementById('writeStatus');
  el.textContent = msg;
  el.className = 'status-msg show ' + cls;
}

// ═══ Search PRC_Pricing_Engine ═══
async function doSearch() {
  const pat = getPat();
  const base03 = getBase03();
  let term = (document.getElementById('searchTerm').value || '').trim();

  if (!pat || !base03) { setSearchStatus('Enter PAT and Base 03 ID.', 'err'); return; }
  if (!term) { setSearchStatus('Enter a search term.', 'err'); return; }

  setSearchStatus('Searching…', 'loading');

  try {
    // Detect PharmLink ID format: pure number, or PL-xxxxx prefix
    let pharmLinkId = null;
    const plMatch = term.match(/^(?:PL[- ]?)?\s*(\d+)\s*$/i);
    if (plMatch) {
      // Strip PL- prefix and leading zeros → raw integer string
      pharmLinkId = String(parseInt(plMatch[1], 10));
    }

    let variantKeyFromPLID = null;

    // If it looks like a PharmLink ID, try Base 04 lookup first
    if (pharmLinkId) {
      const base04 = (document.getElementById('base04').value || '').trim();
      if (base04) {
        setSearchStatus(`Searching PharmLink ID ${pharmLinkId} in Publish Ready…`, 'loading');

        // Try exact match on the normalised ID
        const pubUrl = new URL(`https://api.airtable.com/v0/${base04}/PUB_Publish_Ready`);
        pubUrl.searchParams.set('filterByFormula', `{PharmLink ID}="${pharmLinkId}"`);
        pubUrl.searchParams.set('pageSize', '1');
        pubUrl.searchParams.append('fields[]', 'Variant Key');
        pubUrl.searchParams.append('fields[]', 'PharmLink ID');

        const pubResp = await atFetch(pubUrl.toString());
        if (pubResp.ok) {
          const pubData = await pubResp.json();
          if (pubData.records && pubData.records.length > 0) {
            variantKeyFromPLID = pubData.records[0].fields['Variant Key'];
          }
        }

        // If exact match failed, also try with the original term (in case stored with leading zeros)
        if (!variantKeyFromPLID && pharmLinkId !== term) {
          const pubUrl2 = new URL(`https://api.airtable.com/v0/${base04}/PUB_Publish_Ready`);
          pubUrl2.searchParams.set('filterByFormula', `{PharmLink ID}="${term}"`);
          pubUrl2.searchParams.set('pageSize', '1');
          pubUrl2.searchParams.append('fields[]', 'Variant Key');
          pubUrl2.searchParams.append('fields[]', 'PharmLink ID');

          const pubResp2 = await atFetch(pubUrl2.toString());
          if (pubResp2.ok) {
            const pubData2 = await pubResp2.json();
            if (pubData2.records && pubData2.records.length > 0) {
              variantKeyFromPLID = pubData2.records[0].fields['Variant Key'];
            }
          }
        }
      }
    }

    // Build filterByFormula for PRC_Pricing_Engine
    let formula;
    if (variantKeyFromPLID) {
      // Exact match on Variant Key found via PharmLink ID
      formula = `{Variant Key}="${variantKeyFromPLID}"`;
      setSearchStatus(`PharmLink ID → ${variantKeyFromPLID.substring(0, 35)}… — loading Pricing Engine…`, 'loading');
    } else {
      // Standard search: Variant Key OR Product Name partial match
      const searchTerm = term.replace(/"/g, '\\"');
      formula = `OR(SEARCH("${searchTerm}",{Variant Key}),SEARCH("${searchTerm.toLowerCase()}",LOWER({Product Name})))`;
    }

    const url = new URL(`https://api.airtable.com/v0/${base03}/PRC_Pricing_Engine`);
    url.searchParams.set('filterByFormula', formula);
    url.searchParams.set('pageSize', '10');
    // No fields[] filter — required to get formula fields

    const resp = await atFetch(url.toString());
    if (!resp.ok) {
      const err = await resp.json().catch(() => ({}));
      setSearchStatus(`API error ${resp.status}: ${err?.error?.message || 'Unknown'}`, 'err');
      return;
    }

    const data = await resp.json();
    if (!data.records || data.records.length === 0) {
      const plNote = pharmLinkId ? ` (tried PharmLink ID ${pharmLinkId} in Publish Ready, then Variant Key + Product Name in Pricing Engine)` : '';
      setSearchStatus(`No records found for "${term}"${plNote}.`, 'err');
      return;
    }

    // Take first match
    const rec = data.records[0];
    currentRecord = rec;
    populateFromRecord(rec);

    const total = data.records.length;
    const via = variantKeyFromPLID ? ` (via PharmLink ID ${pharmLinkId})` : '';
    setSearchStatus(`Found ${total} record${total > 1 ? 's' : ''}${via} — loaded first match.`, 'ok');
    document.getElementById('clearBtn').style.display = '';
    document.getElementById('writeBackCard').style.display = '';

  } catch (e) {
    setSearchStatus(`Error: ${e.message}`, 'err');
  }
}

function populateFromRecord(rec) {
  const f = rec.fields;

  // Populate input fields from the record
  const supplierNet = parseCurrency(f['Supplier Best Net Price (ex GST)']);
  const iaPrice     = parseCurrency(f['IA Price (ex GST)']);
  const bsPrice     = parseCurrency(f['BrightSky Price (ex GST)']);
  const medisaPrice = parseCurrency(f['Medisa Price (ex GST)']);
  const rrp         = parseCurrency(f['RRP (ex GST)']);
  const benchCalc   = parseCurrency(f['Benchmark Price (ex GST) (Calculated)']);
  const hcpCurrent  = parseCurrency(f['Home Care Price (ex GST)']);
  const hcpOverride = parseCurrency(f['HCP Override Price (ex GST)']);
  const supplierOverride = parseCurrency(f['Supplier Override Price (ex GST)']);

  // Other Market = benchmark calculated (which is the best of BrightSky/Medisa/Family)
  let otherMarket = benchCalc;
  if (!otherMarket && bsPrice) otherMarket = bsPrice;
  if (!otherMarket && medisaPrice) otherMarket = medisaPrice;

  document.getElementById('supplierNet').value = supplierNet !== null ? supplierNet.toFixed(2) : '';
  document.getElementById('iaPrice').value = iaPrice !== null ? iaPrice.toFixed(2) : '';
  document.getElementById('otherMarket').value = otherMarket !== null ? otherMarket.toFixed(2) : '';
  document.getElementById('rrp').value = rrp !== null ? rrp.toFixed(2) : '';

  // GST Rate
  const gstStr = f['GST Rate'] || '';
  if (gstStr.includes('10')) document.getElementById('gstRate').value = '10';
  else document.getElementById('gstRate').value = '0';

  // Pre-fill write-back fields with existing overrides (or current values)
  document.getElementById('writeHcp').value =
    hcpOverride !== null ? hcpOverride.toFixed(2) :
    hcpCurrent !== null ? hcpCurrent.toFixed(2) : '';
  document.getElementById('writeSupplier').value =
    supplierOverride !== null ? supplierOverride.toFixed(2) : '';

  // Show record info
  const infoEl = document.getElementById('recordInfo');
  infoEl.style.display = 'block';
  const overrideFlags = [];
  if (hcpOverride !== null) overrideFlags.push(`HCP Override: ${fmt(hcpOverride)}`);
  if (supplierOverride !== null) overrideFlags.push(`Supplier Override: ${fmt(supplierOverride)}`);
  const overrideStr = overrideFlags.length > 0
    ? `<span style="color:var(--amber);">🔒 ${overrideFlags.join(' · ')}</span>`
    : '<span style="color:var(--text-dim);">No overrides set</span>';

  infoEl.innerHTML = [
    `<strong>Record:</strong> ${rec.id}`,
    `<strong>Variant Key:</strong> ${f['Variant Key'] || '—'}`,
    `<strong>Product Name:</strong> ${f['Product Name'] || '—'}`,
    `<strong>HCP Method:</strong> ${f['HCP Method']?.name || f['HCP Method'] || '—'}`,
    `<strong>Current HCP:</strong> ${fmt(hcpCurrent)}`,
    `<strong>Mark Up Band:</strong> ${f['Mark Up Band']?.name || f['Mark Up Band'] || '—'}`,
    overrideStr,
  ].join('<br>');

  recalc();
}

function clearRecord() {
  currentRecord = null;
  document.getElementById('supplierNet').value = '';
  document.getElementById('iaPrice').value = '';
  document.getElementById('otherMarket').value = '';
  document.getElementById('rrp').value = '';
  document.getElementById('recordInfo').style.display = 'none';
  document.getElementById('clearBtn').style.display = 'none';
  document.getElementById('writeBackCard').style.display = 'none';
  document.getElementById('writeHcp').value = '';
  document.getElementById('writeHcp').dataset.userEdited = '';
  document.getElementById('writeSupplier').value = '';
  document.getElementById('writeSupplier').dataset.userEdited = '';
  clearSearchStatus();
  recalc();
}

// ═══ Write overrides back to PRC_Pricing_Engine ═══
async function doWriteBack() {
  if (!currentRecord) { setWriteStatus('No record loaded.', 'err'); return; }

  const pat = getPat();
  const base03 = getBase03();
  if (!pat || !base03) { setWriteStatus('PAT/Base ID missing.', 'err'); return; }

  const hcpVal = parseFloat(document.getElementById('writeHcp').value);
  const supplierVal = parseFloat(document.getElementById('writeSupplier').value);

  if (!isFinite(hcpVal) || hcpVal <= 0) {
    setWriteStatus('HCP Override is required (must be > 0).', 'err');
    return;
  }

  // Build fields to write
  const fields = {
    "HCP Override Price (ex GST)": hcpVal,
    "Home Care Price (ex GST)": hcpVal,
  };

  // Supplier override is optional — only write if a value is entered
  if (isFinite(supplierVal) && supplierVal > 0) {
    fields["Supplier Override Price (ex GST)"] = supplierVal;
  }

  const fieldList = Object.entries(fields).map(([k,v]) => `${k}: ${fmt(v)}`).join(', ');
  setWriteStatus(`Writing ${fieldList}…`, 'loading');

  try {
    const url = `https://api.airtable.com/v0/${base03}/PRC_Pricing_Engine`;
    const body = {
      records: [{
        id: currentRecord.id,
        fields: fields,
      }]
    };

    const resp = await atPatch(url, body);
    if (!resp.ok) {
      const err = await resp.json().catch(() => ({}));
      setWriteStatus(`PATCH failed ${resp.status}: ${err?.error?.message || 'Unknown'}`, 'err');
      return;
    }

    const vk = currentRecord.fields['Variant Key'] || currentRecord.id;
    setWriteStatus(`✓ Overrides written to ${vk}`, 'ok');

  } catch (e) {
    setWriteStatus(`Error: ${e.message}`, 'err');
  }
}

// ═══ Clear all overrides on the current record ═══
async function doClearOverrides() {
  if (!currentRecord) { setWriteStatus('No record loaded.', 'err'); return; }

  const pat = getPat();
  const base03 = getBase03();
  if (!pat || !base03) { setWriteStatus('PAT/Base ID missing.', 'err'); return; }

  if (!confirm('Clear ALL overrides on this record? The next HCP Engine run will recalculate from pipeline data.')) return;

  setWriteStatus('Clearing overrides…', 'loading');

  try {
    const url = `https://api.airtable.com/v0/${base03}/PRC_Pricing_Engine`;
    const body = {
      records: [{
        id: currentRecord.id,
        fields: {
          "HCP Override Price (ex GST)": null,
          "Supplier Override Price (ex GST)": null,
        }
      }]
    };

    const resp = await atPatch(url, body);
    if (!resp.ok) {
      const err = await resp.json().catch(() => ({}));
      setWriteStatus(`PATCH failed ${resp.status}: ${err?.error?.message || 'Unknown'}`, 'err');
      return;
    }

    const vk = currentRecord.fields['Variant Key'] || currentRecord.id;
    document.getElementById('writeHcp').value = '';
    document.getElementById('writeSupplier').value = '';
    setWriteStatus(`✓ Overrides cleared on ${vk} — next HCP Engine run will recalculate.`, 'ok');

  } catch (e) {
    setWriteStatus(`Error: ${e.message}`, 'err');
  }
}

// ═══ Event listeners ═══
['supplierNet','iaPrice','otherMarket','rrp','directHcp','marketDiscount','floorMultiplier','rrpMarkup','gstRate'].forEach(id => {
  document.getElementById(id).addEventListener('input', recalc);
  document.getElementById(id).addEventListener('change', recalc);
});

document.getElementById('searchTerm').addEventListener('keydown', function(e) {
  if (e.key === 'Enter') doSearch();
});

// Track manual edits to write fields so auto-populate doesn't overwrite user input
document.getElementById('writeHcp').addEventListener('input', function() {
  this.dataset.userEdited = '1';
});
document.getElementById('writeSupplier').addEventListener('input', function() {
  this.dataset.userEdited = '1';
});

recalc();
</script>
</body>
</html>