/* Palette lifted from the workbook's cell fills */
:root {
  --navy: #0A1E36; --navy-text: #C6D5E4; --band: #3E6690; --head: #0F2A4A; --head2: #1F3864; --head-red: #8C2A2A; --band-red: #C00000; --band-blue: #2E5395;
  --ink: #182634; --muted: #5A6B7B; --muted2: #595959; --grey: #808080;
  --red: #B23B2E; --orange: #D9670C; --green: #1F7A4D;
  --tint-red: #FBEAE8; --tint-orange: #FDEEE1; --tint-green: #E7F5EC; --tint-blue: #EAF1F8; --zebra: #F3F6F9; --zebra2: #F2F2F2;
  --manual: #FFFBE8; --manual2: #FFFDF2; --pink: #FFF0F0; --pink2: #FFE3E3;
  --border: #D5DCE4; --bg: #F5F7FA; --white: #fff;
  --st-green-bg: #C6EFCE; --st-green-fg: #006100; --st-amber-bg: #FFEB9C; --st-amber-fg: #7F6000; --st-red-bg: #FFC7CE; --st-red-fg: #9C0006;
  --chart-a: #2E5FA8; --chart-b: #D9670C;
}
* { box-sizing: border-box; }
html, body { margin: 0; padding: 0; }
body { font: 13px/1.4 "Segoe UI", system-ui, -apple-system, Arial, sans-serif; color: var(--ink); background: var(--bg); }
button, input, select, textarea { font: inherit; }
a { color: var(--band); }

.topbar { background: var(--navy); color: #fff; display: flex; align-items: center; justify-content: space-between; padding: 10px 20px; height: 64px; }
.brand-title { font-size: 20px; font-weight: 700; letter-spacing: .2px; }
.brand-sub { color: var(--navy-text); font-size: 12px; }
.brand-logo { height: 46px; opacity: .95; }
.tabs { display: flex; gap: 2px; background: #E4E9EF; padding: 6px 12px 0; border-bottom: 1px solid var(--border); overflow-x: auto; }
.tabs a { text-decoration: none; color: var(--ink); background: #F0F3F6; border: 1px solid var(--border); border-bottom: none; padding: 7px 14px; border-radius: 6px 6px 0 0; white-space: nowrap; font-weight: 600; font-size: 12.5px; }
.tabs a.active { background: #fff; color: var(--head); border-color: var(--band); border-bottom: 2px solid #fff; margin-bottom: -1px; }
.view { padding: 16px 20px 40px; max-width: 1600px; margin: 0 auto; }
.view.wide { max-width: none; }

/* toolbar */
.toolbar { display: flex; flex-wrap: wrap; align-items: center; gap: 8px; margin: 0 0 10px; }
.toolbar .spacer { flex: 1; }
.btn { background: var(--head); color: #fff; border: 1px solid var(--head); padding: 6px 12px; border-radius: 4px; cursor: pointer; font-weight: 600; font-size: 12.5px; }
.btn:hover { background: var(--band); border-color: var(--band); }
.btn.secondary { background: #fff; color: var(--head); }
.btn.secondary:hover { background: var(--tint-blue); }
.btn.danger { background: #fff; color: var(--red); border-color: var(--red); }
.btn.danger:hover { background: var(--tint-red); }
.btn:disabled { opacity: .5; cursor: default; }
.hint { color: var(--muted); font-size: 12px; }
.legend { display: inline-flex; align-items: center; gap: 6px; color: var(--muted); font-size: 12px; }
.legend .sw { width: 14px; height: 14px; border: 1px solid var(--border); display: inline-block; }
.sheet-title { background: var(--navy); color: #fff; font-weight: 700; padding: 8px 12px; font-size: 15px; }
.sheet-title.imports { background: var(--head2); }
.sheet-note { color: var(--muted); padding: 6px 12px 10px; }
.sheet-ref { padding: 4px 12px 8px; color: var(--muted2); }
.sheet-ref b { color: var(--head2); }
input.filter { padding: 6px 8px; border: 1px solid var(--border); border-radius: 4px; min-width: 220px; }
input[type=date].asof { padding: 5px 8px; border: 1px solid var(--border); border-radius: 4px; }

/* editable grid */
.grid-wrap { overflow: auto; border: 1px solid var(--border); background: #fff; max-height: calc(100vh - 235px); }
table.grid { border-collapse: separate; border-spacing: 0; font-size: 12.5px; min-width: 100%; }
table.grid th, table.grid td { border-right: 1px solid var(--border); border-bottom: 1px solid var(--border); padding: 0; vertical-align: top; }
table.grid th { position: sticky; top: 0; z-index: 3; background: var(--head); color: #fff; font-weight: 600; text-align: left; padding: 6px 8px; white-space: normal; line-height: 1.2; font-size: 11.5px; min-height: 40px; }
table.grid.imports th { background: var(--head2); }
table.grid th.helper { background: #6b7b8c; }
table.grid th.frozen, table.grid td.frozen { position: sticky; left: 0; z-index: 2; }
table.grid th.frozen { z-index: 4; }
table.grid td.frozen { background: #fff; box-shadow: 1px 0 0 var(--border); }
table.grid th.frozen2, table.grid td.frozen2 { position: sticky; z-index: 2; }
table.grid th.frozen2 { z-index: 4; }
table.grid td.frozen2 { background: #fff; box-shadow: 1px 0 0 var(--border); }
table.grid tr:nth-child(even) td { background: var(--zebra); }
table.grid tr:nth-child(even) td.frozen, table.grid tr:nth-child(even) td.frozen2 { background: var(--zebra); }
table.grid td.manual { background: var(--manual) !important; }
table.grid tr:nth-child(even) td.manual { background: var(--manual2) !important; }
table.grid td .cell { display: block; padding: 5px 8px; min-height: 28px; white-space: pre-wrap; word-break: break-word; }
table.grid td.num .cell, table.grid td.num input { text-align: right; }
table.grid td.manual .cell { cursor: text; }
table.grid td.manual .cell:hover { outline: 1px solid #E5C85A; outline-offset: -1px; }
table.grid td.manual .cell.empty::after { content: '\00a0'; }
table.grid td input, table.grid td select, table.grid td textarea { width: 100%; border: 2px solid var(--band); padding: 3px 6px; background: #fff; outline: none; border-radius: 0; }
table.grid td textarea { min-height: 70px; resize: vertical; }
table.grid td.calc .cell { color: var(--ink); }
table.grid td.bold .cell { font-weight: 700; }
table.grid td.rowtools { text-align: center; white-space: nowrap; }
table.grid td.rowtools button { background: none; border: none; cursor: pointer; color: var(--grey); padding: 4px 6px; font-size: 14px; }
table.grid td.rowtools button:hover { color: var(--red); }
table.grid td.saving { outline: 2px solid #E5C85A; outline-offset: -2px; }
table.grid td.error { outline: 2px solid var(--red); outline-offset: -2px; }
.badge { display: inline-block; padding: 2px 8px; border-radius: 3px; font-weight: 700; font-size: 11.5px; white-space: nowrap; }
.st-ok { background: var(--st-green-bg); color: var(--st-green-fg); }
.st-warn { background: var(--st-amber-bg); color: var(--st-amber-fg); }
.st-bad { background: var(--st-red-bg); color: var(--st-red-fg); }
.st-none { background: transparent; }
table.grid td.hot .cell { background: var(--st-red-bg); color: var(--st-red-fg); font-weight: 700; }
.risk-yes .cell { background: var(--st-red-bg) !important; color: var(--st-red-fg); font-weight: 700; }
.rank-1 .cell { background: var(--st-green-bg); color: var(--st-green-fg); font-weight: 700; }
.empty-state { padding: 30px; text-align: center; color: var(--muted); }

/* dashboard */
.dash { background: #fff; border: 1px solid var(--border); }
.dash-header { background: var(--navy); color: #fff; padding: 12px 16px; display: flex; justify-content: space-between; align-items: center; gap: 12px; }
.dash-header h1 { margin: 0; font-size: 18px; }
.dash-header .sub { color: var(--navy-text); font-size: 12.5px; margin-top: 2px; }
.dash-header .asof { display: flex; align-items: center; gap: 8px; font-size: 12px; color: var(--navy-text); }
.dash-header img { height: 42px; }
.opps { display: grid; grid-template-columns: repeat(3, 1fr); gap: 0; }
.opp { padding: 0; border-right: 1px solid #fff; }
.opp:last-child { border-right: none; }
.opp .opp-head { color: #fff; font-weight: 700; padding: 6px 10px; font-size: 13px; }
.opp .opp-body { padding: 8px 10px 10px; min-height: 150px; }
.opp .opp-sub { color: var(--muted); font-size: 12px; }
.opp .opp-value { font-size: 30px; font-weight: 700; line-height: 1.15; margin: 4px 0 0; }
.opp .opp-unit { color: var(--muted); font-size: 12px; margin-bottom: 8px; }
.opp ul { margin: 0; padding: 0; list-style: none; }
.opp li { color: var(--ink); padding: 2px 0; font-size: 12.5px; }
.opp li:empty::before, .opp li.empty::before { content: '•'; color: var(--grey); }
.opp.crit .opp-head { background: var(--red); } .opp.crit .opp-body { background: var(--tint-red); } .opp.crit .opp-value { color: var(--red); }
.opp.sav .opp-head { background: var(--orange); } .opp.sav .opp-body { background: var(--tint-orange); } .opp.sav .opp-value { color: var(--orange); }
.opp.rev .opp-head { background: var(--green); } .opp.rev .opp-body { background: var(--tint-green); } .opp.rev .opp-value { color: var(--green); }
.band { background: var(--band); color: #fff; font-weight: 700; padding: 6px 12px; font-size: 13px; margin-top: 10px; }
.band.imports { background: var(--head2); }
.band.red { background: var(--band-red); }
.band.blue { background: var(--band-blue); }
.band-note { color: var(--muted2); font-size: 12px; padding: 5px 12px; }
.kpis { display: grid; grid-template-columns: repeat(4, 1fr); gap: 6px; padding: 8px 12px 4px; }
.kpi { background: var(--tint-blue); padding: 8px 10px; border-radius: 3px; }
.kpi .k-label { color: var(--muted); font-weight: 600; font-size: 12px; }
.kpi .k-value { color: var(--head); font-size: 24px; font-weight: 700; margin-top: 2px; }
.kpi .k-value.warn { color: var(--orange); } .kpi .k-value.bad { color: var(--red); }
.foot-note { color: var(--grey); font-size: 11.5px; padding: 4px 12px 8px; }
table.dt { width: 100%; border-collapse: collapse; font-size: 12.5px; }
table.dt th { background: var(--head); color: #fff; text-align: left; padding: 6px 8px; font-weight: 600; font-size: 11.5px; }
table.dt.imports th { background: var(--head2); }
table.dt.red th { background: var(--head-red); }
table.dt td { padding: 5px 8px; border-bottom: 1px solid var(--border); vertical-align: top; }
table.dt tr:nth-child(even) td { background: var(--zebra); }
table.dt.red tr:nth-child(odd) td { background: var(--pink); } table.dt.red tr:nth-child(even) td { background: var(--pink2); }
table.dt td.num, table.dt th.num { text-align: right; }
table.dt td.d, table.dt td.num { white-space: nowrap; }
table.dt td.c, table.dt th.c { text-align: center; }
.dt-wrap { overflow-x: auto; padding: 0 12px 8px; }
.charts { display: grid; grid-template-columns: 1fr 1fr; gap: 16px; padding: 10px 12px; }
.chart-box { border: 1px solid var(--border); padding: 8px; background: #fff; }
.chart-box h4 { margin: 0 0 4px; font-size: 13px; color: var(--head); text-align: center; }
.chart-box canvas { max-height: 280px; }
.stats { display: grid; grid-template-columns: 1fr 1fr; gap: 0 20px; padding: 6px 12px; }
.stat { display: flex; justify-content: space-between; padding: 5px 8px; border-bottom: 1px solid var(--border); }
.stat:nth-child(4n+3), .stat:nth-child(4n+4) { background: var(--zebra2); }
.stat b { color: var(--head2); font-size: 15px; }
.stat b.bad { color: var(--red); }
.delta { font-weight: 700; } .delta.worse { color: var(--red); } .delta.better { color: var(--green); }
.badge-flag { display: inline-block; padding: 1px 8px; border-radius: 3px; font-weight: 700; font-size: 11px; }

/* lists */
.lists { display: grid; grid-template-columns: repeat(auto-fill, minmax(260px, 1fr)); gap: 14px; }
.list-card { background: #fff; border: 1px solid var(--border); }
.list-card h3 { margin: 0; background: var(--head); color: #fff; padding: 6px 10px; font-size: 13px; }
.list-card textarea { width: 100%; border: none; padding: 8px 10px; min-height: 180px; resize: vertical; font-family: inherit; font-size: 12.5px; }
.list-card .foot { padding: 6px 10px; display: flex; justify-content: space-between; align-items: center; border-top: 1px solid var(--border); }

/* auth */
.topbar-right { display: flex; align-items: center; gap: 16px; }
.user-menu { display: flex; align-items: center; gap: 8px; font-size: 12px; color: var(--navy-text); }
.user-menu .u-name { font-weight: 600; color: #fff; }
.user-menu .u-ro { background: rgba(255,255,255,.15); padding: 1px 7px; border-radius: 10px; font-size: 11px; }
.btn.small { padding: 4px 9px; font-size: 11.5px; }
.tabs a.admin-tab { margin-left: auto; color: var(--band); }
.login-wrap { display: flex; justify-content: center; padding: 60px 16px; }
.login-card { background: #fff; border: 1px solid var(--border); border-radius: 8px; width: 100%; max-width: 380px; box-shadow: 0 6px 24px rgba(10,30,54,.08); overflow: hidden; }
.login-card h2 { margin: 0; background: var(--navy); color: #fff; padding: 14px 18px; font-size: 16px; }
.login-card form { padding: 18px; display: grid; gap: 12px; }
.login-card label { display: grid; gap: 4px; font-size: 12px; color: var(--muted); font-weight: 600; }
.login-card input { padding: 8px 10px; border: 1px solid var(--border); border-radius: 4px; font-size: 14px; }
.login-card .err { color: var(--red); font-size: 12.5px; min-height: 16px; }
.login-card .btn { padding: 9px; font-size: 14px; }
/* admin */
.admin-form { background: #fff; border: 1px solid var(--border); padding: 14px; margin-bottom: 14px; display: grid; grid-template-columns: repeat(auto-fit, minmax(180px, 1fr)); gap: 10px; align-items: end; }
.admin-form label { display: grid; gap: 4px; font-size: 12px; color: var(--muted); font-weight: 600; }
.admin-form input, .admin-form select { padding: 6px 8px; border: 1px solid var(--border); border-radius: 4px; }
.admin-form .pages { grid-column: 1 / -1; display: flex; flex-wrap: wrap; gap: 6px 14px; }
.admin-form .pages label, table.users .pages label { display: inline-flex; align-items: center; gap: 4px; font-weight: 400; color: var(--ink); font-size: 12.5px; }
table.users { width: 100%; border-collapse: collapse; background: #fff; font-size: 12.5px; }
table.users th { background: var(--head); color: #fff; text-align: left; padding: 7px 8px; font-size: 11.5px; }
table.users td { padding: 6px 8px; border-bottom: 1px solid var(--border); vertical-align: middle; }
table.users tr:nth-child(even) td { background: var(--zebra); }
table.users td.pages { display: flex; flex-wrap: wrap; gap: 3px 12px; }
table.users input[type=text] { padding: 4px 6px; border: 1px solid var(--border); border-radius: 3px; width: 150px; }
table.users .actions { white-space: nowrap; }
table.users .actions button { margin-right: 4px; }
table.users tr.inactive td { color: var(--grey); }
.pill { display: inline-block; padding: 1px 8px; border-radius: 10px; font-size: 11px; font-weight: 700; }
.pill.admin { background: var(--tint-blue); color: var(--head); } .pill.user { background: var(--zebra2); color: var(--muted2); }
.pill.off { background: var(--tint-red); color: var(--red); }
.pw-reveal { background: var(--tint-green); border: 1px solid var(--green); padding: 10px 14px; margin: 0 0 12px; border-radius: 4px; font-size: 13px; }
.pw-reveal code { font-size: 15px; font-weight: 700; background: #fff; padding: 2px 8px; border-radius: 3px; }

.toast { position: fixed; bottom: 18px; right: 18px; background: var(--navy); color: #fff; padding: 10px 14px; border-radius: 6px; box-shadow: 0 4px 16px rgba(0,0,0,.25); z-index: 100; }
.toast.err { background: var(--red); }

@media (max-width: 900px) { .opps, .kpis, .charts, .stats { grid-template-columns: 1fr 1fr; } }
@media (max-width: 600px) { .opps, .kpis, .charts, .stats { grid-template-columns: 1fr; } .view { padding: 10px; } }
@media print {
  .topbar, .tabs, .toolbar, .asof, .no-print { display: none !important; }
  .view { padding: 0; max-width: none; }
  .dash { border: none; }
  .band, .dash-header, .opp .opp-head, table.dt th, .kpi, .opp .opp-body { -webkit-print-color-adjust: exact; print-color-adjust: exact; }
  .charts { break-inside: avoid; }
}