{/* Header controls */}
02 ? Commissions Model
setShowInactive(v => !v)} style={{ padding:"7px 13px", borderRadius:8, border:`1px solid ${showInactive?c.warn:c.border}`, background:showInactive?c.warnL:c.surface2, color:showInactive?c.warn:c.text3, fontFamily:c.sans, fontSize:11, fontWeight:700, cursor:"pointer" }}>? {showInactive?"Hide":"Show"} Inactive
setCommView("ho")} style={{ padding:"7px 13px", borderRadius:8, border:`1px solid ${c.accent}`, background:c.accentL, color:c.accent, fontFamily:c.sans, fontSize:11, fontWeight:700, cursor:"pointer" }}>? HO View
{/* ?? LEFT COLUMN ?? */}
{/* Deal Parameters */}
Deal Parameters
Reference (from Tab 1)
{st} ? {lender} ? {kw.toFixed(2)} kW ? {battery?"Storage":"Solar Only"} ? Redline: {fmtPPW(redlinePPW)}
Utility
setUtil(e.target.value)}>
{(UTILITIES_BY_STATE[st] || []).map(u => {u} )}
Domestic Content
{}}>No {}}>Yes
Set in Tab 1 ? carries through
Energy Community
setEcOn(false)}>No setEcOn(true)}>Yes
{ecOn &&
? Verify per address
}
{/* Margin Scenarios ? synced with Tab 1 */}
Redline Scenario (synced with Tab 1)
{[0,10,15,20,25,30,35].map(m => {
const isActive = effectiveM === m && customMStr === "";
return { setPresetM(m); }} style={{ padding:"4px 10px", borderRadius:20, border:`1.5px solid ${isActive?"rgba(13,110,110,.4)":c.border}`, background:isActive?c.accentL:c.surface2, color:isActive?c.accent:c.text3, cursor:"pointer", fontFamily:c.sans, fontSize:11, fontWeight:700 }}>{m===0?"Floor":`${m}%`} ;
})}
Active Redline
{fmtPPW(redlinePPW)}
{/* Top Options */}
Top Options
{/* Best Commission */}
? Best Commission
{bestComm &&
{bestComm.lender} ? {bestComm.esc} }
{bestComm ? (
{[["Commission",fmt(bestComm.commission)],["EPC",fmtPPW(bestComm.epc)],["HO Monthly",`$${Math.round(bestComm.monthly)}/mo`]].map(([l,v])=>(
))}
) :
No viable options at current sell rates.
}
{/* Lowest HO Payment */}
? Lowest HO Payment
{lowestPmt &&
{lowestPmt.lender} ? {lowestPmt.esc} }
{lowestPmt ? (
{[["Monthly",`$${Math.round(lowestPmt.monthly)}/mo`],["Solar Rate",`$${lowestPmt.rate.toFixed(3)}/kWh`],["Escalator",lowestPmt.esc]].map(([l,v])=>(
))}
) :
No viable options.
}
{/* ?? RIGHT COLUMN ?? */}
{showOptionPicker ? (
/* ?? OPTION PICKER ?? */
03 ? Select Your Options
{soldPPW > 0 ? `Target: ${fmtPPW(soldPPW)} ? Pick one or more options to run in the waterfall` : "Enter a Gross EPC Sold in Section 09 first"}
{Object.keys(selectedOptions).length > 0 && (
{ setShowOptionPicker(false); setWaterfallLender(Object.keys(selectedOptions)[0]); }} style={{ padding:"9px 20px", background:c.accent, color:"#fff", border:"none", borderRadius:9, fontFamily:c.sans, fontSize:13, fontWeight:700, cursor:"pointer" }}>
Run with {Object.keys(selectedOptions).length} selected ?
)}
{soldPPW <= 0 ? (
Enter a Gross EPC Sold in Section 09 to see lender options.
) : (
activeLenders.filter(l => l !== "Cash").map(lenderKey => {
const meta = LENDER_META_COMM[lenderKey] || {};
const kw = W / 1000;
const closestMatch = commSolveForTarget(lenderKey, st, util, dcOn, ecOn, kw, soldPPW);
const bestSpread = commSolveForBestSpread(lenderKey, st, util, dcOn, ecOn, kw, soldPPW);
const lowestMo = commSolveForLowestMonthly(lenderKey, st, util, dcOn, ecOn, kw, soldPPW);
const options = [
closestMatch ? { type:"closestMatch", label:"? Closest Match", color:c.purple || "#7c3aed", colorL:c.purpleL || "#ede9fe", data:closestMatch } : null,
bestSpread ? { type:"bestComm", label:"? Best Commission", color:c.success, colorL:c.successL, data:bestSpread } : null,
lowestMo ? { type:"lowestPmt", label:"? Lowest HO Payment", color:c.blue, colorL:c.blueL, data:lowestMo } : null,
].filter(Boolean);
if (!options.length) return null;
return (
{lenderKey === "IGS_TX" ? "IGS (Draft ? TX)" : lenderKey}
{meta.product}
{meta.isDraft &&
DRAFT }
{options.map(opt => {
const epc = opt.data.epc;
const commission = Math.max(0, epc * W - redlineVal - adderList);
const spread = epc - redlinePPW;
const selKey = `${lenderKey}_${opt.type}`;
const isSelected = selectedOptions[selKey];
return (
{
setSelectedOptions(prev => {
const next = { ...prev };
if (isSelected) {
delete next[selKey];
} else {
// Deselect other option from same lender
const otherKey = `${lenderKey}_${opt.type === "bestComm" ? "lowestPmt" : "bestComm"}`;
delete next[otherKey];
next[selKey] = { lender:lenderKey, type:opt.type, ...opt.data, commission };
// Update linputs so waterfall will use this combo
setLinputs(p => ({ ...p, [lenderKey]: { escalator:opt.data.escalator, sellRate:opt.data.sellRate, yield:opt.data.yield } }));
}
return next;
});
}}
style={{ borderRadius:10, border:`2px solid ${isSelected ? opt.color : c.border}`, background:isSelected ? opt.colorL : c.surface, cursor:"pointer", padding:14, transition:".12s", position:"relative" }}>
{isSelected &&
? Selected
}
{opt.label}
{[
{ l:"Est. EPC", v:fmtPPW(epc) },
{ l:"HO Monthly", v:`$${Math.round(opt.data.monthly)}/mo` },
{ l:"Sales Spread",v:fmt(commission) },
{ l:"Rate", v:`$${opt.data.sellRate.toFixed(3)}/kWh` },
].map((m,i) => (
))}
{opt.data.escalator} ? {opt.data.yield} kWh/kW
=0?opt.color:c.danger, width:`${Math.min(100,Math.max(2,(epc/(redlinePPW*1.5))*100))}%` }} />
=0?opt.color:c.danger, fontFamily:c.mono, marginTop:3, fontWeight:600 }}>
{spread>=0?"+":""}{spread.toFixed(3)}/W spread
);
})}
);
})
)}
) : (
/* ?? WATERFALL VIEW ?? */
{/* Selected options toggle + back button */}
Selected Options
{ setShowOptionPicker(true); }} style={{ fontSize:11, color:c.accent, background:c.accentL, border:`1px solid rgba(13,110,110,.2)`, borderRadius:7, padding:"4px 12px", cursor:"pointer", fontWeight:700, fontFamily:c.sans }}>? Change Selections
{Object.entries(selectedOptions).map(([selKey, opt]) => {
const isActive = waterfallLender === selKey;
const meta = LENDER_META_COMM[opt.lender] || {};
const typeIcon = opt.type === "bestComm" ? "?" : opt.type === "closestMatch" ? "?" : "?";
return (
{ setWaterfallLender(selKey); setLinputs(p => ({ ...p, [opt.lender]:{ escalator:opt.escalator, sellRate:opt.sellRate, yield:opt.yield } })); }}
style={{ display:"flex", alignItems:"center", gap:7, padding:"7px 13px", borderRadius:9, border:`2px solid ${isActive?(meta.dot||c.accent):c.border}`, background:isActive?"#fff":c.surface2, cursor:"pointer", fontFamily:c.sans, transition:".1s" }}>
{opt.lender === "IGS_TX" ? "IGS TX" : opt.lender}
{typeIcon} {opt.escalator}
{fmtPPW(opt.epc)}
{isActive && ACTIVE }
);
})}
{/* Manual steppers for active lender */}
{wfLenderKey && (() => {
const activeLc = lCalcs.find(l => l.lender === wfLenderKey);
if (!activeLc || activeLc.lender === "Cash") return null;
const meta = LENDER_META_COMM[wfLenderKey] || {};
const escs = meta.escalators?.[st] || [];
const curEsc = getLI(wfLenderKey, "escalator");
const [rMin, rMax] = commGetRateRange(wfLenderKey, st, util, curEsc);
const curRate = Number(getLI(wfLenderKey, "sellRate"));
const yRange = COMM_YIELD_RANGES[wfLenderKey]?.[st] || [900, 1200];
const curYld = Number(getLI(wfLenderKey, "yield")) || Math.round((yRange[0]+yRange[1])/2/100)*100;
const stepRate = dir => { const next = Math.round((curRate + dir * COMM_RATE_STEP) * 1000) / 1000; setLI(wfLenderKey, "sellRate", Math.min(rMax, Math.max(rMin, next))); };
const stepYld = dir => setLI(wfLenderKey, "yield", Math.min(yRange[1], Math.max(yRange[0], curYld + dir * 100)));
const btnSm = (disabled) => ({ width:26, height:28, borderRadius:6, border:`1.5px solid ${c.border2}`, background:disabled?c.surface3:c.surface2, color:disabled?c.text3:c.text, fontSize:14, fontWeight:700, cursor:disabled?"default":"pointer", flexShrink:0 });
return (
{escs.length > 0 && (
Escalator
{ setLI(wfLenderKey,"escalator",e.target.value); const [,nm]=commGetRateRange(wfLenderKey,st,util,e.target.value); if(curRate>nm)setLI(wfLenderKey,"sellRate",nm); }}>
{escs.map(e => {e} )}
)}
Rate ? {rMin.toFixed(3)}?{rMax.toFixed(3)}
stepRate(-1)} disabled={curRate<=rMin} style={btnSm(curRate<=rMin)}>?
${curRate.toFixed(3)}
stepRate(+1)} disabled={curRate>=rMax} style={btnSm(curRate>=rMax)}>+
Yield ? {yRange[0]}?{yRange[1]}
stepYld(-1)} disabled={curYld<=yRange[0]} style={btnSm(curYld<=yRange[0])}>?
{curYld}
stepYld(+1)} disabled={curYld>=yRange[1]} style={btnSm(curYld>=yRange[1])}>+
);
})()}
{showInactive && (INACTIVE_LENDERS[st]||[]).map(({ lender: inL, reason, dot }) => (
))}
{/* 05 ? Commission Waterfall */}
{W > 0 && (activeWF || hasSoldRate) && (
05 ? Commission Waterfall
{/* Waterfall rows */}
{[
{ l:"Contract Value", v:fmt(wfContractVal), sub:hasSoldRate ? `${fmtPPW(soldPPW)} ? ${W.toLocaleString()}W` : `${fmtPPW(activeWF?.epc||0)} ? ${W.toLocaleString()}W`, col:c.text },
{ l:"- Company Redline", v:`(${fmt(redlineVal)})`, sub:`${fmtPPW(redlinePPW)} ? ${st}`, col:c.danger },
].map((r,i) => (
))}
Net After Redline
{fmt(wfCommission)}
Sales Spread
{W>0&&wfCommission>0?`${fmtPPW(wfCommission/W)} spread`:"?"}
{fmt(wfCommission)}
{/* Escrow */}
{(() => {
const showToggle = !campaignOn && !isDealer;
const escrowColor = (isDealer || (campaignOn && campaignSalesPPW <= 0) || (!campaignOn && !escrowOn)) ? c.success : c.warn;
const escrowBg = (isDealer || (campaignOn && campaignSalesPPW <= 0) || (!campaignOn && !escrowOn)) ? c.successL : c.warnL;
const escrowBorder = (isDealer || (campaignOn && campaignSalesPPW <= 0) || (!campaignOn && !escrowOn)) ? "rgba(22,101,52,.2)" : "rgba(180,83,9,.25)";
return (
Sales Personal Expense
{showToggle && (
setEscrowOn(v => !v)} style={{ padding:"2px 9px", borderRadius:12, border:`1px solid ${escrowOn?"rgba(180,83,9,.35)":"rgba(22,101,52,.3)"}`, background:escrowOn?c.warnL:c.successL, color:escrowOn?c.warn:c.success, fontFamily:c.sans, fontSize:10, fontWeight:700, cursor:"pointer" }}>
{escrowOn ? "? 10% ON" : "? OFF"}
)}
{escrowLabel}
{escrowAmt > 0 ? `(${fmt(escrowAmt)})` : "$0"}
);
})()}
{/* Commission Pool */}
Commission Pool
{W>0&&commPool>0?fmtPPW(commPool/W):"?"}
{fmt(commPool)}
{/* Split builder */}
Commission Pool
{["Role","Label","Split","Amount",""].map((h,i) =>
=2?"right":"left" }}>{h}
)}
{splits.map(row => {
const isPPW = row.mode === "ppw";
const ppwVal = parseFloat(row.ppw) || 0;
const pct = isPPW ? (commPool > 0 ? ppwVal * W / commPool * 100 : 0) : (parseFloat(row.pct) || 0);
const dollar = isPPW ? ppwVal * W : commPool * pct / 100;
const updateSplit = (f, v) => setSplits(p => p.map(r => r.id === row.id ? {...r, [f]:v} : r));
return (
updateSplit("role", e.target.value)}>
{ROLES.map(r => {r} )}
{row.role === "Other"
?
updateSplit("custom", e.target.value)} />
:
{row.role}
}
{/* Split input ? % or $/W mode */}
{/* Mode toggle */}
updateSplit("mode", isPPW ? "pct" : "ppw")} style={{ padding:"2px 6px", borderRadius:10, border:`1px solid ${isPPW ? c.accent : c.border2}`, background:isPPW ? c.accentL : c.surface2, color:isPPW ? c.accent : c.text3, fontFamily:c.sans, fontSize:9, fontWeight:700, cursor:"pointer", whiteSpace:"nowrap" }}>
{isPPW ? "$/W" : "%"}
{isPPW ? (
<>
updateSplit("ppw", Math.max(0, Math.round((ppwVal - 0.005) * 1000) / 1000))} style={{ width:22,height:28,borderRadius:5,border:`1.5px solid ${c.border2}`,background:c.surface2,color:c.text,fontSize:13,fontWeight:700,cursor:"pointer" }}>?
updateSplit("ppw", Math.round((ppwVal + 0.005) * 1000) / 1000)} style={{ width:22,height:28,borderRadius:5,border:`1.5px solid ${c.border2}`,background:c.surface2,color:c.text,fontSize:13,fontWeight:700,cursor:"pointer" }}>+
{/* Auto-computed % badge */}
{pct.toFixed(1)}%
) : (
<>
{ const cur=parseFloat(row.pct)||0; if(cur>0) updateSplit("pct",Math.max(0,Math.round((cur-1)*10)/10)); }} style={{ width:24,height:32,borderRadius:6,border:`1.5px solid ${c.border2}`,background:c.surface2,color:c.text,fontSize:14,fontWeight:700,cursor:"pointer" }}>?
updateSplit("pct",Math.min(100,Math.round(((parseFloat(row.pct)||0)+1)*10)/10))} style={{ width:24,height:32,borderRadius:6,border:`1.5px solid ${c.border2}`,background:c.surface2,color:c.text,fontSize:14,fontWeight:700,cursor:"pointer" }}>+
)}
0?c.success:c.text3, fontFamily:c.mono, textAlign:"right" }}>{dollar>0?fmt(dollar):"?"}
setSplits(p => p.filter(r => r.id !== row.id))} style={{ width:24,height:24,borderRadius:6,border:`1px solid ${c.border2}`,background:c.surface2,color:c.text3,fontSize:12,fontWeight:700,cursor:"pointer",display:"flex",alignItems:"center",justifyContent:"center" }}>?
);
})}
setSplits(p => [...p, { id:nextId(), role:"Closer", custom:"", pct:"", mode:"pct", ppw:"0.010" }])} style={{ marginTop:8, background:"transparent", border:`1.5px dashed ${c.border2}`, borderRadius:8, padding:"7px 14px", width:"100%", color:c.text3, fontFamily:c.sans, fontSize:12, fontWeight:600, cursor:"pointer" }}>+ Add Participant
Total Allocated
{totalPct.toFixed(1)}%
{pctExact &&
OK }
{pctOver &&
OVER }
)}
)}
);
}
// ??? DEALER / PARTNER TAB ????????????????????????????????????????????????????
function DealerTab({ c, card, lbl, fmt, fmtPPW, C, st, lender, laborMode }) {
const [dealerName, setDealerName] = useState("");
const [dealerModel, setDealerModel] = useState(1);
const [dealerTargetM, setDealerTargetM] = useState(20);
const [dealerCustomMStr, setDealerCustomMStr] = useState("");
const [showRateSheet, setShowRateSheet] = useState(false);
const [m2RateStr, setM2RateStr] = useState("0.950");
const [showM2RateSheet, setShowM2RateSheet] = useState(false);
const [m3RateStr, setM3RateStr] = useState("0.750");
const [showM3RateSheet, setShowM3RateSheet] = useState(false);
const dealerEffM = useMemo(() => {
if (dealerCustomMStr === "") return dealerTargetM;
const n = parseFloat(dealerCustomMStr);
return isNaN(n) ? dealerTargetM : Math.min(60, Math.max(0, n));
}, [dealerTargetM, dealerCustomMStr]);
const W = C?.W || 13120;
const dealerRedline$ = C ? rl(C.baseAllinNoAdders, dealerEffM) : null;
const dealerRedlinePPW = dealerRedline$ ? dealerRedline$ / W : null;
const today = new Date().toLocaleDateString("en-US", { month: "long", day: "numeric", year: "numeric" });
const seg_s = { display: "flex", gap: 3, background: c.surface3, border: `1.5px solid ${c.border}`, borderRadius: 9, padding: 3 };
const sb = (on) => ({ flex: 1, padding: "7px 4px", borderRadius: 7, border: on ? `1px solid ${c.border}` : "none", background: on ? c.surface : "transparent", color: on ? c.accent : c.text3, cursor: "pointer", fontFamily: c.sans, fontSize: 12, fontWeight: on ? 700 : 600, transition: ".12s" });
// Build adder display groups for Model 1 ? full BOM included, full list prices
const ADDER_DISPLAY_GROUPS = ADDER_SECTIONS.map(sec => ({
title: sec.title,
rows: sec.keys.map(key => {
const a = ADDER_MAP[key];
if (!a) return null;
let price = "?";
if (a.isTrench) price = `$500 base + $35/ft`;
else if (a.isBoringBase) price = `Contractor quote + $500`;
else if (a.isBoringMaterial) price = `$${a.listPFt}/ft`;
else if (a.perW) price = `$${(a.listW || a.seaW).toFixed(3)}/W`;
else if (a.isTeslaLead || a.isTeslaPWX || a.isTeslaACLead || a.isTeslaACPWX || a.isTeslaExp)
price = a.list ? fmt(a.list) : "Dynamic";
else if (a.list != null) price = fmt(a.list);
return { label: a.label, price };
}).filter(Boolean)
})).filter(g => g.rows.length > 0);
return (
{/* ?? PARTNER CONFIG ??????????????????????????????????????????????? */}
Partner Configuration
Partner / Dealer Name
setDealerName(e.target.value)}
placeholder="e.g. Our World Energy"
style={{ background: c.surface2, border: `1.5px solid ${c.border}`, color: c.text, padding: "8px 12px", borderRadius: 8, width: "100%", fontFamily: c.sans, fontSize: 13, fontWeight: 500, outline: "none", boxSizing: "border-box" }}
/>
Reference ? Tab 1 Config
{st} ? {lender} ? {C ? `${(C.W / 1000).toFixed(2)} kW` : "?"} ? {laborMode === "sub" ? "Sub (SEA)" : "Internal"}
Dealer Model
{[
{ n: 1, label: "Model 1 ? Redline", sub: "eEquals supplies BOM", available: true },
{ n: 2, label: "Model 2 ? Install + Admin", sub: "Dealer supplies BOM", available: true },
{ n: 3, label: "Model 3 ? Install Only", sub: "Dealer manages upstream", available: true },
{ n: 4, label: "Model 4 ? ? La Carte", sub: "OWE / partner-style line items", available: false },
].map(m => (
m.available && setDealerModel(m.n)}
style={{ padding: "10px 16px", borderRadius: 9, textAlign: "left", cursor: m.available ? "pointer" : "not-allowed", border: `1.5px solid ${dealerModel === m.n ? "rgba(13,110,110,.4)" : c.border}`, background: dealerModel === m.n ? c.accentL : m.available ? c.surface2 : c.surface3, opacity: m.available ? 1 : 0.45, fontFamily: c.sans }}>
{m.label}
{m.sub}{!m.available ? " ? coming soon" : ""}
))}
{/* ?? MODEL 1: REDLINE RATE CONFIG ????????????????????????????????? */}
{dealerModel === 1 && (
<>
Model 1 ? Dealer Redline Rate
{!C ? (
? Configure a job in the Pricing Calculator tab first ? the dealer redline is derived from your active cost floor.
) : (
<>
{/* Margin selector */}
Target Gross Margin
{MARGIN_PRESETS.map(m => {
const isActive = dealerEffM === m && dealerCustomMStr === "";
const isZero = m === 0;
return
{ setDealerTargetM(m); setDealerCustomMStr(""); }}
style={{ padding: "5px 13px", borderRadius: 20, border: `1.5px solid ${isActive ? (isZero ? "rgba(109,40,217,.3)" : "rgba(13,110,110,.4)") : c.border}`, background: isActive ? (isZero ? c.purpleL : c.accentL) : c.surface2, color: isActive ? (isZero ? c.purple : c.accent) : c.text3, cursor: "pointer", fontFamily: c.sans, fontSize: 12, fontWeight: 700 }}>
{m === 0 ? "Cost Floor" : `${m}%`}
;
})}
Custom:
setDealerCustomMStr("")} style={{ fontSize: 11, color: c.text3, background: "none", border: "none", cursor: "pointer" }}>? }
{/* Redline output cards */}
{[
{ label: "All-In Cost Floor", ppw: fmtPPW(C.baseAllinPPW), sub: fmt(C.baseAllinNoAdders), col: c.text3, bg: c.surface2 },
{ label: "Target Margin", ppw: `${dealerEffM}%`, sub: `? (1 ? ${dealerEffM}%)`, col: c.text2, bg: c.surface2 },
{ label: "Dealer Redline", ppw: fmtPPW(dealerRedlinePPW), sub: fmt(dealerRedline$), col: c.accent, bg: c.accentL },
].map(item => (
{item.label}
{item.ppw}
{item.sub}
))}
What the dealer receives: A flat EPC redline of{" "}
{fmtPPW(dealerRedlinePPW)} ? inclusive of all panels, inverters, racking, labor, permitting, design, and overhead. The dealer earns the spread between their sold EPC and this rate. Adder revenues are additional per the schedule below.
)}
{/* ?? ADDER SCHEDULE ??????????????????????????????????????????? */}
Adder Schedule ? Model 1
All equipment and materials included
BOM INCLUDED
{ADDER_DISPLAY_GROUPS.map(group => (
{group.title}
{group.rows.map((row, i) => (
{row.label}
{row.price}
))}
))}
{/* ?? RATE SHEET GENERATOR ????????????????????????????????????? */}
setShowRateSheet(v => !v)} disabled={!dealerRedlinePPW}
style={{ padding: "12px 32px", background: dealerRedlinePPW ? c.accent : c.surface3, color: dealerRedlinePPW ? "#fff" : c.text3, border: "none", borderRadius: 10, fontSize: 14, fontWeight: 700, cursor: dealerRedlinePPW ? "pointer" : "not-allowed", fontFamily: c.sans, letterSpacing: ".04em" }}>
{showRateSheet ? "? Collapse Rate Sheet" : "? Generate Rate Sheet"}
{showRateSheet && dealerRedlinePPW && C && (
{/* Header */}
eEquals Solar ? Dealer Rate Sheet
{dealerName || "[ Partner Name ]"}
{st} ? {lender} ? Model 1 ? Redline (eEquals supplies BOM)
{/* Base Redline */}
Base EPC Redline
{fmtPPW(dealerRedlinePPW)}
Flat EPC rate charged by eEquals per watt DC installed. Inclusive of all panels, inverters, racking, balance of systems, labor, permitting, structural and electrical design, and overhead. Dealer retains the spread between the homeowner's sold EPC rate and this redline.
{[
["Reference System", `${(C.W/1000).toFixed(2)} kW DC ? ${C.pCnt} panels`],
["Target Gross Margin", `${dealerEffM}%`],
["State / Lender", `${st} ? ${lender}`],
].map(([l, v]) => (
))}
{/* Adder Schedule */}
Adder Schedule
ALL MATERIALS INCLUDED
{ADDER_DISPLAY_GROUPS.map(group => (
{group.title}
{group.rows.map((row, i) => (
{row.label}
{row.price}
))}
))}
{/* Terms */}
Terms & Notes
? Redline rate reflects the cost floor at the stated target margin and is based on current CED Greentech equipment pricing.
? Rates are subject to change with 30 days written notice. Jobs contracted before notice date are honored at the stated rate.
? All adder prices include full equipment, materials, and installed labor (BOM included under Model 1).
? Per-watt adders are charged at actual installed system wattage.
? Trenching and boring adders are charged at actual measured footage. Boring base charge applies in addition to per-foot material charge.
? Ground Mount available for Cash lender only. Domestic Content eligibility determined per-job based on installed equipment.
? Battery adder prices shown are for fully installed systems inclusive of all BOM, BOS, and labor.
eEquals Solar ? CR Solar LLC ? Confidential ? For Dealer Use Only ? {today}
)}
)}
{/* ?? MODEL 2: INSTALL + ADMIN FEE ????????????????????????????????? */}
{dealerModel === 2 && (() => {
const m2Rate = parseFloat(m2RateStr) || 0;
const laborPPW = C?.baseLaborPPW || 0;
const gaPPW_v = C ? C.gaCost / C.W : 0;
const sopsPPW_v = C ? C.sopsCost / C.W : 0;
const ancPPW_v = C ? C.ancillaryCost / C.W : 0;
const m2CostFloor = laborPPW + gaPPW_v + sopsPPW_v + ancPPW_v;
const m2Margin = m2Rate > 0 ? ((m2Rate - m2CostFloor) / m2Rate * 100) : 0;
const m2Col = m2Margin < 0 ? c.danger : m2Margin < 10 ? c.warn : c.success;
const M2_GROUPS = [
{ title: "Electrical Adders", rows: [
{ label: "Main Panel Replacement", cost: "$3,200", unit: "1 Time Charge" },
{ label: "Main Meter Upgrade", cost: "$2,700", unit: "1 Time Charge" },
{ label: "Main Breaker Enclosure", cost: "$2,050", unit: "1 Time Charge" },
{ label: "Sub Panel", cost: "$1,150", unit: "1 Time Charge" },
{ label: "Main Breaker Derate/Replacement", cost: "$600", unit: "1 Time Charge" },
{ label: "Meter Main Combo", cost: "$4,250", unit: "1 Time Charge" },
{ label: "Tap Box", cost: "$500", unit: "1 Time Charge" },
{ label: "Electrical Stamps Adder", cost: "$75", unit: "1 Time Charge" },
{ label: "Ground Rods", cost: "$275", unit: "1 Time Charge" },
]},
{ title: "Roof and Ground Mount Adders", rows: [
{ label: "Steep Roof (>35?)", cost: "$0.060", unit: "Per Watt" },
{ label: "High Roof (3 stories or more)", cost: "$0.060", unit: "Per Watt" },
{ label: "Metal Roof", cost: "$0.070", unit: "Per Watt" },
{ label: "Trenching ($500 base charge)", cost: "$35", unit: "Per Foot" },
{ label: "Boring Labor", cost: "Quote + $250", unit: "Per Foot" },
{ label: "Boring Material Only (0?100 ft)", cost: "$12", unit: "Per Foot" },
{ label: "Boring Material Only (101?200 ft)", cost: "$11", unit: "Per Foot" },
{ label: "Boring Material Only (201+ ft)", cost: "$10", unit: "Per Foot" },
{ label: "Multiple Array Adder", cost: "$350", unit: "Per Array", note: "Starting on 4th array" },
{ label: "Drywall Adders", cost: "Quote", unit: "1 Time Charge" },
{ label: "Small System Adder (12 panels or less)", cost: "$1,500", unit: "1 Time Charge" },
]},
{ title: "Battery Adders ? Labor and BOS Only", bomExcluded: true, rows: [
{ label: "SolarEdge Bat10K w/ Backup", cost: "$5,000", unit: "1 Time Charge" },
{ label: "SolarEdge Bat10K (no backup)", cost: "$3,000", unit: "1 Time Charge" },
{ label: "SolarEdge Battery (Each Additional)", cost: "$1,400", unit: "1 Time Charge" },
{ label: "Tesla Powerwall 3", cost: "$6,000", unit: "1 Time Charge" },
{ label: "Tesla Powerwall 3 (Expansion Battery)", cost: "$800", unit: "1 Time Charge" },
{ label: "Tesla Powerwall 3 (Each Additional)", cost: "$1,200", unit: "1 Time Charge" },
{ label: "Enphase IQ 10C", cost: "$6,450", unit: "1 Time Charge" },
{ label: "Enphase IQ 10C (Each Additional)", cost: "$850", unit: "1 Time Charge" },
{ label: "Enphase IQ 5P", cost: "$7,800", unit: "1 Time Charge" },
{ label: "Enphase IQ 5P (Each Additional)", cost: "$800", unit: "1 Time Charge" },
{ label: "Heat and Smoke Detectors", cost: "$450", unit: "1 Time Charge" },
]},
{ title: "Miscellaneous", rows: [
{ label: "Home Repairs", cost: "$1,000", unit: "1 Time Charge" },
{ label: "Cancel (Post Permit Submitted)", cost: "$1,000", unit: "1 Time Charge" },
{ label: "Permit (>$150)", cost: "Cost ? $150", unit: "1 Time Charge" },
{ label: "Interconnection Passthrough", cost: "NEM fees beyond $150", unit: "1 Time Charge" },
{ label: "Travel Adder (>75 Miles from Warehouse)", cost: "$500", unit: "1 Time Charge" },
]},
];
return (
<>
{/* Rate Config */}
Model 2 ? Install + Admin Rate
{!C ? (
? Configure a job in the Pricing Calculator tab first ? overhead is derived from your active settings.
) : (
<>
Model 2: Dealer purchases all equipment (BOM). eEquals charges a flat $/W rate covering install labor and admin overhead only. Battery adder prices are labor + BOS only ? no hardware included.
{/* Base rate input */}
Base Install + Admin Rate ($/W)
setM2RateStr(v => (Math.max(0.50, Math.round((parseFloat(v)-0.005)*1000)/1000)).toFixed(3))} style={{ width: 28, height: 28, borderRadius: 6, border: `1.5px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 16, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>?
setM2RateStr(v => (Math.min(2.00, Math.round((parseFloat(v)+0.005)*1000)/1000)).toFixed(3))} style={{ width: 28, height: 28, borderRadius: 6, border: `1.5px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 16, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>+
{m2RateStr !== "0.950" && setM2RateStr("0.950")} style={{ fontSize: 10, color: c.text3, background: "none", border: "none", cursor: "pointer", padding: "0 4px" }}>reset }
{m2Rate > 0 ? `${C.W.toLocaleString()}W ? $${m2Rate.toFixed(3)}/W = ${fmt(m2Rate * C.W)} total base charge` : "Enter a rate"}
{/* Cost breakdown */}
{[
{ label: "Install Labor", ppw: fmtPPW(laborPPW), col: c.warn, bg: c.warnL },
{ label: "G&A", ppw: fmtPPW(gaPPW_v), col: c.text2, bg: c.surface2 },
{ label: "Sales Ops", ppw: fmtPPW(sopsPPW_v), col: c.text2, bg: c.surface2 },
{ label: "Ancillary COGS", ppw: fmtPPW(ancPPW_v), col: c.text2, bg: c.surface2 },
{ label: "Total Cost Floor", ppw: fmtPPW(m2CostFloor), col: c.text, bg: c.surface3 },
].map(item => (
))}
{/* Margin output */}
0 ? `${m2Col}12` : c.surface3, border: `1.5px solid ${m2Rate > 0 ? m2Col + "40" : c.border}`, borderRadius: 9, padding: "13px 16px" }}>
0 ? m2Col : c.text3, marginBottom: 3 }}>
{m2Rate > 0 ? (m2Margin < 0 ? "? Below Cost" : "Gross Margin on Base Rate") : "Enter a rate above"}
{m2Rate > 0 ? `$${m2Rate.toFixed(3)}/W charged ? ${fmtPPW(m2CostFloor)} cost = ${fmtPPW(Math.abs(m2Rate - m2CostFloor))} ${m2Margin >= 0 ? "margin" : "shortfall"}` : "Equipment costs excluded ? dealer provides BOM"}
{m2Rate > 0 &&
{m2Margin.toFixed(1)}%
}
)}
{/* Adder Schedule */}
Adder Schedule ? Model 2
Battery adders are labor + BOS only ? hardware not included
BOM EXCLUDED
{M2_GROUPS.map(group => (
{group.title}
{group.bomExcluded &&
LABOR + BOS ONLY }
{group.rows.map((row, i) => (
{row.label}{row.note ? ? {row.note} : null}
{row.unit}
{row.cost}
))}
))}
{/* Rate Sheet Generator */}
setShowM2RateSheet(v => !v)}
style={{ padding: "12px 32px", background: c.accent, color: "#fff", border: "none", borderRadius: 10, fontSize: 14, fontWeight: 700, cursor: "pointer", fontFamily: c.sans, letterSpacing: ".04em" }}>
{showM2RateSheet ? "? Collapse Rate Sheet" : "? Generate Rate Sheet"}
{showM2RateSheet && (
{/* Header */}
? eEquals
Install w/Admin Rate Sheet ? {new Date().toLocaleDateString("en-US",{month:"long",year:"numeric"})}
{dealerName &&
{dealerName}
}
Internal Use Only ? Confidential & Proprietary
{/* Table */}
{/* Column headers */}
{["ADDER DESCRIPTION", "COST", "UNIT OF MEASURE"].map(h => (
{h}
))}
{/* Labor & Admin */}
Labor & Admin
Base Install Labor & Admin
${m2Rate > 0 ? m2Rate.toFixed(3) : "0.950"}
Per Watt ? Subject to change per dealer and/or market
{/* Adder sections */}
{M2_GROUPS.map(group => (
{group.title}
{group.bomExcluded &&
LABOR & BOS ONLY ? HARDWARE NOT INCLUDED }
{group.rows.map((row, i) => (
{row.label}
{row.note ? ? {row.note} : null}
{row.cost}
{row.unit}
))}
))}
{/* NDA Footer */}
Confidentiality Notice & Non-Disclosure Agreement
Proprietary and Confidential
This Dealer Adder Rate Sheet (the "Document") is the exclusive and proprietary property of eEquals Solar and contains confidential trade information, pricing structures, and dealer rate schedules that constitute valuable business and trade secrets.
By receiving this document, you agree to the following:
1. Non-Disclosure: You shall not disclose, distribute, reproduce, copy, transmit, disseminate, sell, publish, broadcast, or circulate this Document, in whole or in part, to any third party without the prior written consent of eEquals Solar.
2. Limited Use: This Document is provided solely for the authorized business purposes of the designated dealer recipient. Any use beyond the scope of the authorized dealer relationship is strictly prohibited.
3. Penalties for Unauthorized Disclosure: Unauthorized disclosure or misuse of this Document may result in immediate termination of the dealer agreement, civil litigation for damages, injunctive relief, and referral for criminal prosecution under applicable trade secret laws including the Defend Trade Secrets Act (18 U.S.C. ? 1836).
4. Return or Destruction: Upon termination of the dealer relationship or upon written request by eEquals Solar, recipient agrees to promptly return or certifiably destroy all copies of this Document.
5. Governing Law: This non-disclosure obligation shall be governed by the laws of the State in which eEquals Solar is headquartered, without regard to conflict of law principles.
eEquals ? Dealer Adder Rates ? {today} ? Internal Use Only ? Do Not Distribute
)}
);
})()}
{/* ?? MODEL 3: INSTALL ONLY ???????????????????????????????????????? */}
{dealerModel === 3 && (() => {
const m3Rate = parseFloat(m3RateStr) || 0;
const laborPPW = C?.baseLaborPPW || 0;
const gaPPW_v = C ? C.gaCost / C.W : 0;
const sopsPPW_v = C ? C.sopsCost / C.W : 0;
// Ancillary excluded from M3 floor ? dealer handles surveys, permits, plan sets
const m3CostFloor = laborPPW + gaPPW_v + sopsPPW_v;
const m3Margin = m3Rate > 0 ? ((m3Rate - m3CostFloor) / m3Rate * 100) : 0;
const m3Col = m3Margin < 0 ? c.danger : m3Margin < 10 ? c.warn : c.success;
const M3_GROUPS = [
{ title: "Electrical Adders", rows: [
{ label: "Main Panel Replacement", cost: "$3,200", unit: "1 Time Charge" },
{ label: "Main Meter Upgrade", cost: "$2,700", unit: "1 Time Charge" },
{ label: "Main Breaker Enclosure", cost: "$2,050", unit: "1 Time Charge" },
{ label: "Sub Panel", cost: "$1,150", unit: "1 Time Charge" },
{ label: "Main Breaker Derate/Replacement", cost: "$600", unit: "1 Time Charge" },
{ label: "Meter Main Combo", cost: "$4,250", unit: "1 Time Charge" },
{ label: "Tap Box", cost: "$500", unit: "1 Time Charge" },
{ label: "Electrical Stamps Adder", cost: "$75", unit: "1 Time Charge" },
{ label: "Ground Rods", cost: "$275", unit: "1 Time Charge" },
]},
{ title: "Roof and Ground Mount Adders", rows: [
{ label: "Steep Roof (>35?)", cost: "$0.060", unit: "Per Watt" },
{ label: "High Roof (3 stories or more)", cost: "$0.060", unit: "Per Watt" },
{ label: "Metal Roof", cost: "$0.070", unit: "Per Watt" },
{ label: "Trenching ($500 base charge)", cost: "$35", unit: "Per Foot" },
{ label: "Boring Labor", cost: "Quote + $250", unit: "Per Foot" },
{ label: "Boring Material Only (0?100 ft)", cost: "$12", unit: "Per Foot" },
{ label: "Boring Material Only (101?200 ft)", cost: "$11", unit: "Per Foot" },
{ label: "Boring Material Only (201+ ft)", cost: "$10", unit: "Per Foot" },
{ label: "Multiple Array Adder", cost: "$350", unit: "Per Array", note: "Starting on 4th array" },
{ label: "Drywall Adders", cost: "Quote", unit: "1 Time Charge" },
{ label: "Small System Adder (12 panels or less)", cost: "$1,500", unit: "1 Time Charge" },
]},
{ title: "Battery Adders ? Labor and BOS Only", bomExcluded: true, rows: [
{ label: "SolarEdge Bat10K w/ Backup", cost: "$5,000", unit: "1 Time Charge" },
{ label: "SolarEdge Bat10K (no backup)", cost: "$3,000", unit: "1 Time Charge" },
{ label: "SolarEdge Battery (Each Additional)", cost: "$1,400", unit: "1 Time Charge" },
{ label: "Tesla Powerwall 3", cost: "$6,000", unit: "1 Time Charge" },
{ label: "Tesla Powerwall 3 (Expansion Battery)", cost: "$800", unit: "1 Time Charge" },
{ label: "Tesla Powerwall 3 (Each Additional)", cost: "$1,200", unit: "1 Time Charge" },
{ label: "Enphase IQ 10C", cost: "$6,450", unit: "1 Time Charge" },
{ label: "Enphase IQ 10C (Each Additional)", cost: "$850", unit: "1 Time Charge" },
{ label: "Enphase IQ 5P", cost: "$7,800", unit: "1 Time Charge" },
{ label: "Enphase IQ 5P (Each Additional)", cost: "$800", unit: "1 Time Charge" },
{ label: "Heat and Smoke Detectors", cost: "$450", unit: "1 Time Charge" },
]},
{ title: "Miscellaneous", rows: [
{ label: "Home Repairs", cost: "$1,000", unit: "1 Time Charge" },
{ label: "Cancel (Post Permit Submitted)", cost: "$1,000", unit: "1 Time Charge" },
{ label: "Permit (>$150)", cost: "Cost ? $150", unit: "1 Time Charge" },
{ label: "Interconnection Passthrough", cost: "NEM fees beyond $150", unit: "1 Time Charge" },
{ label: "Travel Adder (>75 Miles from Warehouse)", cost: "$500", unit: "1 Time Charge" },
]},
];
return (
<>
{/* Rate Config */}
Model 3 ? Install Only Rate
{!C ? (
? Configure a job in the Pricing Calculator tab first ? labor cost is derived from your active settings.
) : (
<>
Model 3: Dealer sells, surveys, permits, and designs the job ? sends it to eEquals install-ready. eEquals charges base install labor only. Ancillary COGS (surveys, permits, plan sets) excluded from cost floor ? dealer bears those costs. Battery adder prices are labor + BOS only, no hardware.
{/* Base rate input */}
Base Install Labor Rate ($/W)
setM3RateStr(v => (Math.max(0.40, Math.round((parseFloat(v)-0.005)*1000)/1000)).toFixed(3))} style={{ width: 28, height: 28, borderRadius: 6, border: `1.5px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 16, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>?
setM3RateStr(v => (Math.min(2.00, Math.round((parseFloat(v)+0.005)*1000)/1000)).toFixed(3))} style={{ width: 28, height: 28, borderRadius: 6, border: `1.5px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 16, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>+
{m3RateStr !== "0.750" && setM3RateStr("0.750")} style={{ fontSize: 10, color: c.text3, background: "none", border: "none", cursor: "pointer", padding: "0 4px" }}>reset }
{m3Rate > 0 ? `${C.W.toLocaleString()}W ? $${m3Rate.toFixed(3)}/W = ${fmt(m3Rate * C.W)} total base charge` : "Enter a rate"}
{/* Cost breakdown ? no ancillary */}
{[
{ label: "Install Labor", ppw: fmtPPW(laborPPW), col: c.warn, bg: c.warnL },
{ label: "G&A", ppw: fmtPPW(gaPPW_v), col: c.text2, bg: c.surface2 },
{ label: "Sales Ops", ppw: fmtPPW(sopsPPW_v), col: c.text2, bg: c.surface2 },
{ label: "Total Cost Floor", ppw: fmtPPW(m3CostFloor), col: c.text, bg: c.surface3 },
].map(item => (
))}
? Ancillary COGS ($0.06/W surveys, permits, plan sets) excluded ? dealer handles these upstream.
{/* Margin output */}
0 ? `${m3Col}12` : c.surface3, border: `1.5px solid ${m3Rate > 0 ? m3Col + "40" : c.border}`, borderRadius: 9, padding: "13px 16px" }}>
0 ? m3Col : c.text3, marginBottom: 3 }}>
{m3Rate > 0 ? (m3Margin < 0 ? "? Below Cost" : "Gross Margin on Base Rate") : "Enter a rate above"}
{m3Rate > 0 ? `$${m3Rate.toFixed(3)}/W charged ? ${fmtPPW(m3CostFloor)} cost = ${fmtPPW(Math.abs(m3Rate - m3CostFloor))} ${m3Margin >= 0 ? "margin" : "shortfall"}` : "Equipment costs excluded ? dealer provides BOM"}
{m3Rate > 0 &&
{m3Margin.toFixed(1)}%
}
)}
{/* Adder Schedule */}
Adder Schedule ? Model 3
Battery adders are labor + BOS only ? hardware not included
BOM EXCLUDED
{M3_GROUPS.map(group => (
{group.title}
{group.bomExcluded &&
LABOR + BOS ONLY }
{group.rows.map((row, i) => (
{row.label}{row.note ? ? {row.note} : null}
{row.unit}
{row.cost}
))}
))}
{/* Rate Sheet Generator */}
setShowM3RateSheet(v => !v)}
style={{ padding: "12px 32px", background: c.accent, color: "#fff", border: "none", borderRadius: 10, fontSize: 14, fontWeight: 700, cursor: "pointer", fontFamily: c.sans, letterSpacing: ".04em" }}>
{showM3RateSheet ? "? Collapse Rate Sheet" : "? Generate Rate Sheet"}
{showM3RateSheet && (
{/* Header */}
? eEquals
Install Only Rate Sheet ? {new Date().toLocaleDateString("en-US", { month: "long", year: "numeric" })}
{dealerName &&
{dealerName}
}
Internal Use Only ? Confidential & Proprietary
{/* Table */}
{["ADDER DESCRIPTION", "COST", "UNIT OF MEASURE"].map(h => (
{h}
))}
{/* Labor section */}
Labor
Base Install Labor
${m3Rate > 0 ? m3Rate.toFixed(3) : "0.750"}
Per Watt ? Subject to change per dealer and/or market
{/* Adder sections */}
{M3_GROUPS.map(group => (
{group.title}
{group.bomExcluded &&
LABOR & BOS ONLY ? HARDWARE NOT INCLUDED }
{group.rows.map((row, i) => (
{row.label}
{row.note ? ? {row.note} : null}
{row.cost}
{row.unit}
))}
))}
{/* NDA Footer */}
Confidentiality Notice & Non-Disclosure Agreement
Proprietary and Confidential
This Dealer Adder Rate Sheet (the "Document") is the exclusive and proprietary property of eEquals Solar and contains confidential trade information, pricing structures, and dealer rate schedules that constitute valuable business and trade secrets.
By receiving this document, you agree to the following:
1. Non-Disclosure: You shall not disclose, distribute, reproduce, copy, transmit, disseminate, sell, publish, broadcast, or circulate this Document, in whole or in part, to any third party without the prior written consent of eEquals Solar.
2. Limited Use: This Document is provided solely for the authorized business purposes of the designated dealer recipient. Any use beyond the scope of the authorized dealer relationship is strictly prohibited.
3. Penalties for Unauthorized Disclosure: Unauthorized disclosure or misuse of this Document may result in immediate termination of the dealer agreement, civil litigation for damages, injunctive relief, and referral for criminal prosecution under applicable trade secret laws including the Defend Trade Secrets Act (18 U.S.C. ? 1836).
4. Return or Destruction: Upon termination of the dealer relationship or upon written request by eEquals Solar, recipient agrees to promptly return or certifiably destroy all copies of this Document.
5. Governing Law: This non-disclosure obligation shall be governed by the laws of the State in which eEquals Solar is headquartered, without regard to conflict of law principles.
eEquals ? Dealer Adder Rates ? {today} ? Internal Use Only ? Do Not Distribute
)}
);
})()}
);
}
function PricingTool() {
// ??? PRICE OVERRIDES (set by PDF parser on BOM tab) ??????????????????????
const [priceOverrides, setPriceOverrides] = useState({});
const [activeTab, setActiveTab] = useState("calculator");
const [pdfParsing, setPdfParsing] = useState(false);
const [pdfDiff, setPdfDiff] = useState(null);
const [pdfSelected, setPdfSelected] = useState({});
const [pdfFileName, setPdfFileName] = useState("");
const [pdfError, setPdfError] = useState("");
const [pdfApplied, setPdfApplied] = useState(false);
const [bosItems, setBosItems] = useState(BOS_MASTER_DATA);
// State
const [st, setSt] = useState("VA");
const [lender, setLender] = useState("Lightreach");
const [wattsStr, setWattsStr] = useState("13120");
const [jobType, setJobType] = useState("solar");
const [laborRate, setLaborRate] = useState(0.60);
const [laborMode, setLaborMode] = useState("sub");
const [partnerBOM, setPartnerBOM] = useState(false);
const [gaPPW, setGaPPW] = useState(GA_PPW_DEFAULT);
const [sopsPPW, setSopsPPW] = useState(SALESOPS_PPW_DEFAULT);
const [ancillaryPPW, setAncillaryPPW] = useState(ANCILLARY_PPW);
const [salesLeadershipPPW, setSalesLeadershipPPW] = useState(SALES_LEADERSHIP_PPW_DEFAULT);
const [proposalPPW, setProposalPPW] = useState(PROPOSAL_PPW);
const [overheadOn, setOverheadOn] = useState({ ancillary:true, ga:true, sops:true, leadership:true, proposal:true });
const [installsPerMonth, setInstallsPerMonth] = useState(100);
// Campaign cost allocation ? per-line ops/sales coverage
const [campaignOn, setCampaignOn] = useState(false);
const [campaignP, setCampaignP] = useState({
setters: 9, days: 12, airbnbPerDay: 70, carPerDay: 40, flightPerRep: 700, installs: 15,
manualOverride: false,
manualClosers: 4, manualSetterCars: 3, manualCloserCars: 2,
dealerMode: false,
coverage: { airbnb: "ops", setterCars: "ops", closerCars: "ops", flights: "ops" },
});
// Commissions tab state
const [util, setUtil] = useState("APCO");
const [ecOn, setEcOn] = useState(true);
const [maxPmtStr, setMaxPmtStr] = useState("");
const [linputs, setLinputs] = useState({});
const [waterfallLender, setWaterfallLender] = useState(null);
const [selectedOptions, setSelectedOptions] = useState({});
const [showOptionPicker, setShowOptionPicker] = useState(true);
const [commView, setCommView] = useState("sales");
const [showInactive, setShowInactive] = useState(false);
const [escrowOn, setEscrowOn] = useState(false);
const [salesView, setSalesView] = useState(false);
const [splits, setSplits] = useState([
{ id:1, role:"Setter", custom:"", pct:"30", mode:"pct", ppw:"0.010" },
{ id:2, role:"Closer", custom:"", pct:"45", mode:"pct", ppw:"0.010" },
{ id:3, role:"Setter Manager", custom:"", pct:"7", mode:"pct", ppw:"0.010" },
{ id:4, role:"Closer Manager", custom:"", pct:"7", mode:"pct", ppw:"0.010" },
{ id:5, role:"Setter Director", custom:"", pct:"5", mode:"pct", ppw:"0.010" },
{ id:6, role:"VP", custom:"", pct:"6", mode:"ppw", ppw:"0.010" },
]);
const [commMode, setCommMode] = useState("sold_rate");
const [soldPPWStr, setSoldPPWStr] = useState("3.800");
const [targetCommStr, setTargetCommStr] = useState("");
const [panelK, setPanelK] = useState("qcell_c_plus");
const [invK, setInvK] = useState("enphase_iq8hc_dom");
const [rackK, setRackK] = useState("unirac_nxt_dom");
const [dcOn, setDcOn] = useState(true);
const [targetM, setTargetM] = useState(25);
const [customMStr, setCustomMStr] = useState("");
const [targetPPWStr, setTargetPPWStr] = useState("");
const [sel, setSel] = useState({});
const [redlineSet, setRedlineSet] = useState(new Set());
const [eqAdj, setEqAdj] = useState({ panel:0, inv:0, rack:0, bos:0, comb:0 });
const [qty, setQty] = useState({});
const [expanded, setExpanded] = useState({});
const [adderSecExpanded, setAdderSecExpanded] = useState(false);
const [trenchFtStr, setTrenchFtStr] = useState("120");
const [boringQuoteStr, setBoringQuoteStr] = useState("0");
const [boringFtStr, setBoringFtStr] = useState("100");
const [roofType, setRoofType] = useState("flush");
const [detached, setDetached] = useState(false);
// Derived scalars
const watts = parseInt(wattsStr) || 0;
const trenchFt = parseInt(trenchFtStr) || 120;
const boringQuote = parseFloat(boringQuoteStr) || 0;
const boringFt = parseInt(boringFtStr) || 100;
const cfg = LENDER_CFG[lender] || LENDER_CFG.Cash;
const isCash = lender === "Cash";
const invBrand = INVERTERS[invK]?.brand || "enphase";
// Memos
const availPanels = useMemo(() => {
const base = cfg.panels || Object.keys(PANELS);
return base.filter(k => {
const p = PANELS[k];
if (p?.stateRestrict) return p.stateRestrict.includes(st);
return true;
});
}, [lender, st]);
const availInverters = useMemo(() => {
const base = cfg.inverters || Object.keys(INVERTERS);
return base.filter(k => {
const inv = INVERTERS[k];
if (inv?.stateRestrict) return inv.stateRestrict.includes(st);
return true;
});
}, [lender, st]);
const effectiveM = useMemo(() => {
if (customMStr === "") return targetM;
const n = parseFloat(customMStr);
return isNaN(n) ? targetM : Math.min(60, Math.max(0, n));
}, [targetM, customMStr]);
const isGroundMount = !!sel["gm"] && !ADDERS.find(a => a.key === "gm")?.blockLenders?.includes(lender);
// Effects
useEffect(() => {
if (!availPanels.includes(panelK)) setPanelK(availPanels[0] || "qcell_c_plus");
if (!availInverters.includes(invK)) setInvK(availInverters[0] || "enphase_iq8hc_dom");
}, [lender, jobType, st]);
useEffect(() => {
const isTeslaDC = invK === "tesla_pw3_dc" || invK === "tesla_pw3_sh";
if (isTeslaDC) {
setSel(p => ({ ...p, bat_tpw1: true }));
setJobType("storage");
} else {
setSel(p => { const n = { ...p }; delete n.bat_tpw1; delete n.bat_texp; delete n.bat_tpwx; return n; });
setQty(p => { const n = { ...p }; delete n.bat_texp; delete n.bat_tpwx; return n; });
setSel(p => { const n = {...p}; delete n.bat_tac1; delete n.bat_tacx; delete n.bat_tace; return n; });
}
// Clear battery adders incompatible with newly selected inverter brand
const newBrand = INVERTERS[invK]?.brand || "enphase";
setSel(p => {
const n = { ...p };
ADDERS.forEach(a => { if (a.blockInvBrand && a.blockInvBrand === newBrand) delete n[a.key]; });
return n;
});
}, [invK]);
useEffect(() => {
const acKeys = new Set(["bat_tac1","bat_tacx","bat_tace"]);
const hasAC = Object.keys(sel).some(k => acKeys.has(k) && sel[k]);
if (hasAC && jobType !== "storage") setJobType("storage");
}, [sel]);
useEffect(() => {
const pw = PANELS[panelK]?.watt || 410;
const current = parseInt(wattsStr) || 0;
if (current >= pw) { const snapped = Math.round(current / pw) * pw; if (snapped !== current) setWattsStr(String(snapped)); }
}, [panelK]);
// Auto-solve lender card inputs whenever soldPPWStr changes
useEffect(() => {
const soldPPW = parseFloat(soldPPWStr) || 0;
if (soldPPW <= 0 || !watts) return;
const kw = watts / 1000;
const solved = {};
(LENDERS_BY_STATE[st] || []).forEach(l => {
const combo = commSolveForTarget(l, st, util, dcOn, ecOn, kw, soldPPW);
if (combo) solved[l] = combo;
});
if (Object.keys(solved).length > 0) setLinputs(solved);
setSelectedOptions({});
setShowOptionPicker(true);
}, [soldPPWStr, st, util, dcOn, ecOn, watts]);
// Handlers
const handleSt = s => { setSt(s); setLender(LENDERS_BY_STATE[s][0]); setUtil(UTILITIES_BY_STATE[s]?.[0] || ""); };
const toggle = k => setSel(p => ({ ...p, [k]: !p[k] }));
const setQtyFor = (k, v) => setQty(p => ({ ...p, [k]: Math.max(1, v) }));
const toggleExp = k => setExpanded(p => ({ ...p, [k]: !p[k] }));
const setPresetM = m => { setTargetM(m); setCustomMStr(""); };
// Main calculation memo
const C = useMemo(() => {
if (!watts || watts < 100) return null;
const panel = PANELS[panelK], inv = INVERTERS[invK], rack = RACKING[rackK];
if (!panel || !inv || !rack) return null;
const W = watts, pCnt = Math.ceil(W / panel.watt);
const isTeslaInv = invK === "tesla_pw3_dc" || invK === "tesla_pw3_sh";
const pw3UnitPrice = inv?.pw3UnitPrice || 7388.88;
// Apply any live price overrides from PDF parser
const effPanelPrice = priceOverrides?.panels?.[panelK] ?? panel.price;
const effInvPrice = priceOverrides?.inverters?.[invK] ?? inv.price;
const effRackPPW = priceOverrides?.racking?.[rackK] ?? rack.ppw;
const effOptPrice = priceOverrides?.optimizers?.[invK] ?? inv.optimizerPrice;
// Equipment costs ? with per-line $/W adjustments
const panelCost = partnerBOM ? 0 : pCnt * effPanelPrice + (eqAdj.panel * W);
const invCostDisplay = (!partnerBOM && !isTeslaInv) ? (inv.perSystem ? effInvPrice : pCnt * effInvPrice) + (eqAdj.inv * W) : 0;
const optCost = partnerBOM ? 0 : ((inv.brand === "solaredge" && effOptPrice) ? pCnt * effOptPrice : 0);
const combCost = partnerBOM ? 0 : (inv.brand === "enphase" ? 910.39 : 0) + (eqAdj.comb * W);
const rackCost = (partnerBOM || isGroundMount) ? 0 : (effRackPPW + eqAdj.rack) * W;
const bosCostBase = partnerBOM ? 0 : (laborMode === "internal" ? Math.round(BOS_PPW * W * BOS_CUSHION * 100) / 100 : 0);
const bosCost = partnerBOM ? 0 : bosCostBase + (eqAdj.bos * W);
// Lender fees
let shFee = 0, shFeeLabel = null;
if (lender === "IGS" && inv.perPanel){ shFee = 20 * pCnt; shFeeLabel = `IGS Safe Harbor Fee ($20 ? ${pCnt} micros)`; }
const taxRate = isCash ? (SALES_TAX_RATE[st] || 0) : 0;
// Adders
const warnings = [], adderRows = [];
let adderSum = 0, listSum = 0, redlineAdderSum = 0, hasBattery = false, batDCEligible = true;
ADDERS.forEach(a => {
if (!sel[a.key]) return;
if (a.blockLenders?.includes(lender)) {
warnings.push({ t: "block", m: `? ${a.label} ? not approved for ${lender}` });
return;
}
if (a.blockInvBrand && a.blockInvBrand === invBrand) {
warnings.push({ t: "block", m: `? ${a.label} ? incompatible with ${invBrand === "enphase" ? "Enphase" : "SolarEdge"} inverter` });
return;
}
if (a.isBattery) hasBattery = true;
if (a.isBattery && BAT_DC_ELIGIBLE[a.key] === false) batDCEligible = false;
const q = a.isQtyAdder ? (qty[a.key] || 1) : 1;
let cost, list;
if (a.isTeslaACLead || a.isTeslaACPWX || (a.isTeslaExp && (a.key === "bat_tace"))) {
cost = calcTeslaACCost(a, laborMode);
list = a.list ?? null;
} else if (a.isTeslaLead || a.isTeslaExp || a.isTeslaPWX) {
cost = calcTeslaCost(a, laborMode, pCnt, pw3UnitPrice);
list = a.list ?? null;
} else if (partnerBOM && a.isBattery) {
cost = laborMode === "sub" ? (a.seaPartner || 0) : (a.intPartner || 0);
list = a.listPartner ?? null;
} else {
cost = adderCostFor(a, laborMode, W, trenchFt, boringQuote, boringFt, isGroundMount, redlineSet);
list = adderListFor(a, W, trenchFt, boringQuote, boringFt, redlineSet);
}
const totalCost = (cost || 0) * q;
const totalList = list != null ? list * q : null;
const isRedlineAdder = redlineSet.has(a.key);
if (!isRedlineAdder && totalCost > 0 && totalList != null && totalCost > totalList)
warnings.push({ t: "cost", m: `? BELOW COST: ${a.label} ? ${fmt(totalCost)} cost vs ${fmt(totalList)} list` });
adderSum += totalCost;
if (isRedlineAdder) redlineAdderSum += totalCost;
else if (totalList != null) listSum += totalList;
adderRows.push({ label: a.label + (q > 1 ? ` ?${q}` : ""), cost: totalCost, list: isRedlineAdder ? null : totalList, isRedline: isRedlineAdder });
});
// Campaign cost allocation ? per-line ops/sales assignment
const cp = campaignP;
const campClosers = cp.manualOverride ? cp.manualClosers : Math.ceil(cp.setters / 2.5);
const campSetterCars = cp.manualOverride ? cp.manualSetterCars : Math.ceil(cp.setters / 4);
const campCloserCars = cp.manualOverride ? cp.manualCloserCars : Math.ceil(campClosers / 2.5);
const campPeople = cp.setters + campClosers;
const campAirbnbAmt = campPeople * cp.airbnbPerDay * cp.days;
const campSetCarAmt = campSetterCars * cp.carPerDay * cp.days;
const campCloseCarAmt = campCloserCars * cp.carPerDay * cp.days;
const campFlightsAmt = campPeople * cp.flightPerRep;
const campTotalCost = campAirbnbAmt + campSetCarAmt + campCloseCarAmt + campFlightsAmt;
const campInstalls = Math.max(1, cp.installs);
const campCostPPW = campInstalls * W > 0 ? campTotalCost / (campInstalls * W) : 0;
const cov = cp.coverage || { airbnb:"ops", setterCars:"ops", closerCars:"ops", flights:"ops" };
const campaignOpsPPW = (campaignOn && !cp.dealerMode)
? ((cov.airbnb==="ops"?campAirbnbAmt:0)+(cov.setterCars==="ops"?campSetCarAmt:0)+(cov.closerCars==="ops"?campCloseCarAmt:0)+(cov.flights==="ops"?campFlightsAmt:0)) / (campInstalls * W)
: 0;
const campaignSalesPPW = (campaignOn && !cp.dealerMode)
? ((cov.airbnb==="sales"?campAirbnbAmt:0)+(cov.setterCars==="sales"?campSetCarAmt:0)+(cov.closerCars==="sales"?campCloseCarAmt:0)+(cov.flights==="sales"?campFlightsAmt:0)) / (campInstalls * W)
: 0;
const campaignOpsCost = campaignOpsPPW * W;
// Cost rollup
const equipSubtotal = panelCost + invCostDisplay + optCost + combCost + rackCost + bosCost + shFee;
const salesTax = taxRate * equipSubtotal;
const equipTotal = equipSubtotal + salesTax;
const equipTotalPPW = equipTotal / W;
const totalEquip = equipTotal + adderSum;
const baseLaborCost = laborRate * W;
const gaCost = (overheadOn.ga ? gaPPW : 0) * W;
const sopsCost = (overheadOn.sops ? sopsPPW : 0) * W;
const ancillaryCost = (overheadOn.ancillary ? ancillaryPPW : 0) * W;
const leadershipCost = (overheadOn.leadership ? salesLeadershipPPW : 0) * W;
const proposalCost = (overheadOn.proposal ? proposalPPW : 0) * W;
const nonflushPrem = (!isGroundMount && roofType === "nonflush") ? NONFLUSH_PPW * W : 0;
const detachPrem = (!isGroundMount && detached) ? DETACH_PPW * W : 0;
const totalAllin = totalEquip + baseLaborCost + gaCost + sopsCost + ancillaryCost + leadershipCost + proposalCost + nonflushPrem + detachPrem + campaignOpsCost;
const allInPPW = totalAllin / W;
// Redline scenarios ? redline adders stay in floor, spread adders excluded
const baseAllinNoAdders = totalAllin - (adderSum - redlineAdderSum);
const mScenarios = MARGIN_PRESETS.map(m => ({
m,
equipOnlyPPW: rl(totalEquip, m) / W,
baseRedlinePPW: rl(baseAllinNoAdders, m) / W,
baseRedline$: rl(baseAllinNoAdders, m),
}));
const targetSc = {
baseRedlinePPW: rl(baseAllinNoAdders, effectiveM) / W,
baseRedline$: rl(baseAllinNoAdders, effectiveM),
allInPPW: rl(totalAllin, effectiveM) / W,
};
// Holdback (Lightreach only)
let hb = null;
if (lender === "Lightreach") {
const boost = dcOn ? (jobType === "storage" ? (cfg.dcBoostPVStorage?.[st] || 0.45) : (cfg.dcBoostPVOnly?.[st] || 0.35)) : 0;
hb = { std: 0.10, dcBoost: boost, total: 0.10 + boost };
}
// DC / FEOC
const modDC = PANEL_DC[panelK] || 0;
const invDCPct = INV_DC[invK] || 0;
const rackDCPct = isGroundMount ? 0 : (RACK_DC[rackK] || 0);
const pvDC = modDC + invDCPct + rackDCPct;
const isSHPanel = !!PANELS[panelK]?.shOnly;
const isSHInv = !!INVERTERS[invK]?.isSH;
const activeDcThreshold = (isSHPanel || isSHInv) ? (cfg.shDcThreshold || 45) : (cfg.dcThreshold || 50);
const dcThreshold = activeDcThreshold;
const storageMode = jobType === "storage";
const batPending = storageMode && !hasBattery;
const batDCNote = hasBattery
? (isTeslaInv ? "Battery DC ? Eligible ? (PW3 ESS qualifies)" : batDCEligible ? "Battery DC ? Eligible ?" : "Battery DC ? Not Eligible 2026 (SE Bat10K)")
: (storageMode ? "Battery DC ? Pending selection" : null);
const feocPVThreshold = cfg.feocThresholdPV || 40;
const feocPVPass = (isTeslaInv && isSHPanel) ? true : isTeslaInv ? true : pvDC >= feocPVThreshold;
const feocBatPass = !hasBattery || batDCEligible;
const safeHarbored = !!cfg.safeHarbored || isSHInv;
// Safe Harbor pairing warnings
if (isSHPanel && !isSHInv)
warnings.push({ t: "sh", m: "? FEOC VIOLATION: LONGi Hi-MO 5 DC requires the Tesla PW3 Safe Harbor inverter (1707000-60-M-LR-2025). This panel is only FEOC-compliant when paired with the SH PW3." });
if (isSHInv && !isSHPanel)
warnings.push({ t: "sh", m: "? Tesla PW3 Safe Harbor inverter selected ? this must be paired with the LONGi Hi-MO 5 DC (LR5-54HPB-405M) panel for FEOC compliance." });
// Tesla inverter cost in 04A = string inverter equivalent + MCI/RSD for full system
const teslaInvCost = isTeslaInv ? (TESLA_STRING_INV + Math.ceil(pCnt / 3) * MCI_PRICE) : 0;
// Warnings
const histPPW = HIST_PPW[st]?.[lender] ?? null;
if (cfg.rackingDomRequired && !RACKING[rackK]?.domestic && !isGroundMount)
warnings.push({ t: "avl", m: `? ${lender} requires domestic racking` });
if (histPPW && targetSc.baseRedlinePPW > histPPW)
warnings.push({ t: "market", m: `? Base redline ($${targetSc.baseRedlinePPW.toFixed(3)}/W) exceeds 2025 market avg ($${histPPW.toFixed(3)}/W)` });
const actualCOGS = getActualCOGS(st, lender, roofType, detached);
return {
W, pCnt, panelCost, invCost: invCostDisplay, isTeslaInv, teslaInvCost,
optCost, combCost, rackCost, bosCost, isGroundMount, partnerBOM,
shFee, shFeeLabel, salesTax, taxRate,
equipSubtotal, equipTotal, equipTotalPPW,
adderRows, adderSum, listSum,
totalEquip, baseLaborPPW: laborRate, baseLaborCost,
gaCost, sopsCost, ancillaryCost, leadershipCost, proposalCost, nonflushPrem, detachPrem,
campaignOpsPPW, campaignSalesPPW, campTotalCost, campCostPPW, campInstalls,
campClosers, campSetterCars, campCloserCars, campPeople, campAirbnbAmt, campSetCarAmt, campCloseCarAmt, campFlightsAmt,
totalAllin, allInPPW, baseAllinNoAdders, baseAllinPPW: baseAllinNoAdders / W,
mScenarios, targetSc, hb, histPPW, warnings,
smallSystem: W < 9000, actualCOGS, laborMode,
pvDC, dcThreshold, batDCNote, batDCEligible,
hasBattery, batPending, storageMode,
feocPVPass, feocBatPass, feocPVThreshold,
safeHarbored, modDC, invDCPct, rackDCPct,
isSHPanel, isSHInv,
};
}, [st, lender, watts, jobType, laborRate, laborMode, partnerBOM, panelK, invK, rackK, dcOn, effectiveM, sel, qty, isCash, trenchFt, boringQuote, boringFt, isGroundMount, invBrand, roofType, detached, priceOverrides, gaPPW, sopsPPW, ancillaryPPW, salesLeadershipPPW, proposalPPW, overheadOn, redlineSet, eqAdj, campaignOn, campaignP]);
// Shortcuts for selected equipment
const panel = PANELS[panelK], inv = INVERTERS[invK], rack = RACKING[rackK];
// ??? THEME + STYLE TOKENS ??????????????????????????????????????????????????
const c = {
bg: "#eef2f7", surface: "#fff", surface2: "#f5f7fa", surface3: "#edf0f5",
border: "#dde3ed", border2: "#c8d0de",
text: "#1a2640", text2: "#4a5878", text3: "#8a96aa",
accent: "#0d6e6e", accentL: "#e6f4f4",
warn: "#b45309", warnL: "#fef3c7",
danger: "#b91c1c", dangerL: "#fee2e2",
success: "#166534", successL: "#dcfce7",
blue: "#1a5fb4", blueL: "#e8f0fb",
purple: "#6d28d9", purpleL: "#ede9fe",
mono: "'IBM Plex Mono',monospace",
sans: "'Inter',system-ui,sans-serif",
};
const card = { background: c.surface, border: `1px solid ${c.border}`, borderRadius: 12, padding: 18, marginBottom: 14, boxShadow: "0 1px 3px rgba(0,0,0,.07)" };
const lbl = { fontSize: 10, color: c.text3, marginBottom: 4, letterSpacing: ".05em", fontWeight: 700, textTransform: "uppercase" };
const sel_s = { background: c.surface2, border: `1.5px solid ${c.border}`, color: c.text, padding: "8px 30px 8px 10px", borderRadius: 8, width: "100%", fontFamily: c.sans, fontSize: 13, fontWeight: 500, outline: "none", appearance: "none", WebkitAppearance: "none", backgroundImage: "url(\"data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='10' height='6'%3E%3Cpath fill='%238a96aa' d='M5 6L0 0h10z'/%3E%3C/svg%3E\")", backgroundRepeat: "no-repeat", backgroundPosition: "right 10px center" };
const inp_s = { background: c.surface2, border: `1.5px solid ${c.border}`, color: c.text, padding: "8px 10px", borderRadius: 8, width: "100%", fontFamily: c.sans, fontSize: 13, fontWeight: 500, outline: "none", textAlign: "center" };
const g2 = { display: "grid", gridTemplateColumns: "1fr 1fr", gap: 10, marginBottom: 12 };
const seg_s = { display: "flex", gap: 3, background: c.surface3, border: `1.5px solid ${c.border}`, borderRadius: 9, padding: 3, marginBottom: 12 };
const sb = (on, warn = false) => ({ flex: 1, padding: "7px 4px", borderRadius: 7, border: on ? `1px solid ${c.border}` : "none", background: on ? (warn ? c.warnL : c.surface) : "transparent", color: on ? (warn ? c.warn : c.accent) : c.text3, cursor: "pointer", fontFamily: c.sans, fontSize: 12, fontWeight: on ? 700 : 600, transition: ".12s", boxShadow: on ? "0 1px 2px rgba(0,0,0,.06)" : "none" });
const drow = { display: "flex", justifyContent: "space-between", alignItems: "center", padding: "6px 0", borderBottom: `1px solid ${c.surface3}`, fontSize: 13 };
const ppwBadge = { fontSize: 10, fontWeight: 500, color: c.text3, background: c.surface3, padding: "2px 5px", borderRadius: 4, whiteSpace: "nowrap", fontFamily: c.mono };
// ??? RENDER ????????????????????????????????????????????????????????????????
// ?? SKU match map for PDF parser ??????????????????????????????????????????
const SKU_MATCH_MAP = [
{ keywords:["Q.PEAK DUO BLK ML-G10.C+","G10.C+"], type:"panels", key:"qcell_c_plus", label:"Q.PEAK DUO BLK ML-G10.C+ 410W" },
{ keywords:["DCA.17 410","DCA.17-410"], type:"panels", key:"qcell_dca_410", label:"QCell DCA.17 410W" },
{ keywords:["DCA.17 415","DCA.17-415"], type:"panels", key:"qcell_dca_415", label:"QCell DCA.17 415W" },
{ keywords:["AC Module","QCELL AC"], type:"panels", key:"qcell_ac_410", label:"QCell AC Module 410W" },
{ keywords:["HIN-T440","BIFACIAL","HYUNDAI 440"], type:"panels", key:"hyundai_440", label:"Hyundai HIN-T440NF 440W" },
{ keywords:["IQ8+-72","IQ8PLUS","IQ8+"], type:"inverters", key:"enphase_iq8plus", label:"Enphase IQ8+" },
{ keywords:["IQ8MC-72","IQ8MC"], type:"inverters", key:"enphase_iq8mc", label:"Enphase IQ8MC" },
{ keywords:["IQ8AC-72","IQ8AC"], type:"inverters", key:"enphase_iq8ac", label:"Enphase IQ8AC" },
{ keywords:["IQ8X-72-2-INT","IQ8X NON"], type:"inverters", key:"enphase_iq8x_nd", label:"Enphase IQ8X Non-Dom" },
{ keywords:["IQ8X-72-M-DOM","IQ8X DOM"], type:"inverters", key:"enphase_iq8x_dom", label:"Enphase IQ8X Dom" },
{ keywords:["IQ8HC-72-M-DOM","IQ8HC DOM"], type:"inverters", key:"enphase_iq8hc_dom", label:"Enphase IQ8HC Dom" },
{ keywords:["IQ8HC-72-2-US","IQ8HC IGS","135.00"], type:"inverters", key:"enphase_iq8hc_igs", label:"Enphase IQ8HC IGS SH" },
{ keywords:["USE11400H","SINGLE SKU","SE SINGLE"], type:"inverters", key:"se_standard", label:"SolarEdge Single SKU 11.4kW" },
{ keywords:["P370","P400","P505","P600","P700","OPTIMIZER"], type:"optimizers",key:"se_standard", label:"SolarEdge Optimizer" },
{ keywords:["315168M-US","DOM SM LIGHT RAIL 168 MILL"], type:"racking", key:"unirac_dom_light_mill", label:"Unirac Dom Mill Light Rail" },
{ keywords:["315168D-US","DOM SM LIGHT RAIL 168 DARK"], type:"racking", key:"unirac_dom_dark", label:"Unirac Dom Dark Rail" },
{ keywords:["185RLM1-US","NXT UMOUNT RAIL","NXT DOM"], type:"racking", key:"unirac_nxt_dom", label:"Unirac NXT Dom Mill" },
{ keywords:["SNAPNRACK","SNAP N RACK"], type:"racking", key:"snapnrack_dom", label:"SnapNrack Dom" },
];
const parsePDF = async (file) => {
setPdfParsing(true); setPdfError(""); setPdfDiff(null); setPdfApplied(false);
try {
const base64Data = await new Promise((res, rej) => {
const r = new FileReader();
r.onload = () => res(r.result.split(",")[1]);
r.onerror = () => rej(new Error("File read failed"));
r.readAsDataURL(file);
});
const response = await fetch("https://api.anthropic.com/v1/messages", {
method: "POST",
headers: { "Content-Type": "application/json" },
body: JSON.stringify({
model: "claude-sonnet-4-20250514",
max_tokens: 1000,
messages: [{
role: "user",
content: [
{ type: "document", source: { type: "base64", media_type: "application/pdf", data: base64Data } },
{ type: "text", text: "Extract every line item with a unit price from this CED Greentech solar equipment quote. Return ONLY a valid JSON array, no markdown, no explanation: [{\"sku\":\"string\",\"description\":\"string\",\"unit_price\":number}]. Include all items." }
]
}]
})
});
const data = await response.json();
const raw = data.content?.find(b => b.type === "text")?.text || "[]";
const items = JSON.parse(raw.replace(/```json|```/g, "").trim());
const matched = [], unmatched = [];
items.forEach(item => {
const descUpper = (item.description + " " + item.sku).toUpperCase();
let found = null;
for (const entry of SKU_MATCH_MAP) {
if (entry.keywords.some(kw => descUpper.includes(kw.toUpperCase()))) { found = entry; break; }
}
if (found) {
const obj = found.type === "panels" ? PANELS[found.key] : found.type === "inverters" ? INVERTERS[found.key] : found.type === "racking" ? RACKING[found.key] : null;
const cur = found.type === "racking" ? obj?.ppw : (obj?.price ?? obj?.optimizerPrice);
if (cur !== undefined) {
matched.push({ ...item, catalogKey: found.key, catalogType: found.type, catalogLabel: found.label, currentPrice: cur, changed: Math.abs((item.unit_price - cur) / cur) > 0.001 });
}
} else { unmatched.push(item); }
});
const sel = {};
matched.forEach((m, i) => { if (m.changed) sel[`m_${i}`] = true; });
setPdfDiff({ matched, unmatched });
setPdfSelected(sel);
} catch(e) { setPdfError("Parse failed: " + e.message); }
setPdfParsing(false);
};
const applyPriceChanges = () => {
if (!pdfDiff) return;
const newOverrides = { ...priceOverrides };
pdfDiff.matched.forEach((m, i) => {
if (!pdfSelected[`m_${i}`]) return;
if (!newOverrides[m.catalogType]) newOverrides[m.catalogType] = {};
newOverrides[m.catalogType][m.catalogKey] = m.unit_price;
});
setPriceOverrides(newOverrides);
setPdfApplied(true);
};
return (
{/* HEADER */}
eEquals Solar ? CR Solar LLC
Pricing Model
Version 3.5 ? April 2026 ? Internal Use Only
{cfg.badge && {lender}: {cfg.badge} }
Cost + Margin Calculator
setSalesView(v => !v)} title="" style={{ width: 26, height: 26, borderRadius: 6, border: `1px solid ${salesView ? c.border2 : "transparent"}`, background: "transparent", color: salesView ? c.text3 : `${c.text3}40`, cursor: "pointer", fontSize: 13, display: "flex", alignItems: "center", justifyContent: "center", flexShrink: 0 }}>?
{/* TAB NAVIGATION */}
{[
{ key: "calculator", label: "Pricing Calculator", icon: "?" },
{ key: "commissions", label: "Commissions Model", icon: "?" },
{ key: "dealer", label: "Dealer / Partner", icon: "?" },
{ key: "bom", label: "BOM Pricing", icon: "?" },
{ key: "bos", label: "BOS Pricing", icon: "?" },
].map(tab => (
setActiveTab(tab.key)} style={{ padding: "10px 22px", border: "none", borderBottom: activeTab === tab.key ? `2.5px solid ${c.accent}` : "2.5px solid transparent", background: "transparent", color: activeTab === tab.key ? c.accent : c.text3, cursor: "pointer", fontFamily: c.sans, fontSize: 13, fontWeight: activeTab === tab.key ? 700 : 500, marginBottom: -2, display: "flex", alignItems: "center", gap: 6, transition: ".15s" }}>
{tab.icon} {tab.label}
))}
{activeTab === "calculator" && <>
{/* ?? ROW 1 ? JOB PARAMETERS ??????????????????????????????????????????? */}
01 ? Job Parameters
{C && {C.pCnt} panels ? {(watts / 1000).toFixed(2)} kW DC }
{cfg.note &&
{cfg.note}
}
{/* Top row */}
State
handleSt(e.target.value)}>{["IL","OH","VA","FL","MA","ME","RI","CT","NH","NJ","MD","VT","PA","TX"].map(s => {s} )}
Lender
setLender(e.target.value)}>{LENDERS_BY_STATE[st].map(l => {l === "IGS_TX" ? "IGS (Draft ? TX)" : l} )}
System Watts
{ const pw = PANELS[panelK]?.watt || 410; const cur = parseInt(wattsStr) || 0; const p = Math.round(cur / pw); if (p > 1) setWattsStr(String((p - 1) * pw)); }} style={{ width: 28, height: 32, borderRadius: 6, border: `1.5px solid ${c.border2}`, background: c.surface2, color: c.text, fontSize: 14, fontWeight: 700, cursor: "pointer", flexShrink: 0 }}>?
{ const pw = PANELS[panelK]?.watt || 410; const cur = parseInt(wattsStr) || 0; const p = Math.round(cur / pw) || 0; setWattsStr(String((p + 1) * pw)); }} style={{ width: 28, height: 32, borderRadius: 6, border: `1.5px solid ${c.border2}`, background: c.surface2, color: c.text, fontSize: 14, fontWeight: 700, cursor: "pointer", flexShrink: 0 }}>+
{watts > 0 &&
{Math.round(watts / (PANELS[panelK]?.watt || 410))}p ? {PANELS[panelK]?.watt}W
}
Job Type
setJobType("solar")}>? Solar Only
setJobType("storage")}>? PV + ESS
Install Mode
setLaborMode("sub")}>Sub (SEA)
setLaborMode("internal")}>Internal
? Labor Rate (?/W)
setLaborRate(r => Math.max(0.50, Math.round((r - 0.05) * 100) / 100))} style={{ width: 28, height: 28, borderRadius: 6, border: `1.5px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 16, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>?
{(laborRate * 100).toFixed(0)}?
setLaborRate(r => Math.min(0.85, Math.round((r + 0.05) * 100) / 100))} style={{ width: 28, height: 28, borderRadius: 6, border: `1.5px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 16, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>+
{[0.50, 0.60, 0.75, 0.85].map(r => (
setLaborRate(r)} style={{ flex: 1, padding: "3px 0", borderRadius: 6, border: `1px solid ${laborRate === r ? c.accent : c.border}`, background: laborRate === r ? c.accentL : c.surface2, color: laborRate === r ? c.accent : c.text3, cursor: "pointer", fontSize: 10, fontWeight: 700, fontFamily: c.sans }}>{(r * 100).toFixed(0)}?
))}
{/* Bottom row */}
BOM Supplied
setPartnerBOM(false)}>eEquals Supplied
setPartnerBOM(true)}>Partner Supplied
Domestic Content
{!cfg.dcMandatory && cfg.dcOptional &&
setDcOn(true)}>? DC Enrolled setDcOn(false)}>Standard
}
{cfg.dcMandatory &&
? DC Required by {lender}
}
{!cfg.dcMandatory && !cfg.dcOptional &&
N/A for {lender}
}
{!isGroundMount &&
Array Layout
setRoofType("flush")}>Flush
setRoofType("nonflush")}>Non-Flush
}
{!isGroundMount &&
Detached Structure
setDetached(true)}>Yes
setDetached(false)}>No
}
{/* ?? ROW 2 ? EQUIPMENT | DC+FEOC | EQUIPMENT COST ??????????????????? */}
{C && C.warnings.length > 0 && (
{C.warnings.map((w, i) => {
const wStyle = { block: { background: c.dangerL, border: `1.5px solid rgba(185,28,28,.25)`, color: c.danger }, cost: { background: c.warnL, border: `1.5px solid rgba(180,83,9,.25)`, color: c.warn }, avl: { background: c.purpleL, border: `1.5px solid rgba(109,40,217,.2)`, color: c.purple }, market: { background: c.blueL, border: `1.5px solid rgba(26,95,180,.2)`, color: c.blue }, sh: { background: "#fef3c7", border: `1.5px solid rgba(146,113,10,.3)`, color: "#92710a" } };
return
{w.t === "block" ? "?" : w.t === "cost" ? "?" : w.t === "avl" ? "?" : w.t === "sh" ? "?" : "?"} {w.m}
;
})}
)}
{/* 02 ? Equipment */}
02 ? Equipment
AVL + FEOC Filtered
Solar Panel
setPanelK(e.target.value)}>{availPanels.map(k => {PANELS[k]?.label} )}
Inverter / Microinverter
setInvK(e.target.value)}>{availInverters.map(k => {INVERTERS[k]?.label} )}
Brand: {invBrand === "enphase" ? "Enphase" : "SolarEdge"} ? incompatible batteries auto-blocked
{(invK === "tesla_pw3_dc" || invK === "tesla_pw3_sh") &&
? Tesla PW3-DC Coupled ? Inverter cost = Tesla String Inv. equiv. ($1,931.82) + MCI/RSD ($39.02 ? ?panels?3?). Battery adder covers PW3 unit, Gateway, BOS, and labor.
}
{invK === "tesla_pw3_sh" &&
? Safe Harbor SKU: 1707000-60-M-LR-2025 ? PW3 unit: $7,965.00. Must pair with LONGi Hi-MO 5 DC panel for FEOC compliance.
}
{panelK === "longi_hi5_405" &&
? LONGi Hi-MO 5 DC ? 38.5% DC ? Safe Harbor program ? IL/Lightreach only. Must pair with Tesla PW3 SH inverter for FEOC compliance. DC threshold: 45%.
}
Racking System{isGroundMount ? " ? ? Ground Mount Override" : ""}
setRackK(e.target.value)} disabled={isGroundMount}>
{Object.entries(RACKING).filter(([, r]) => !cfg.rackingDomRequired || r.domestic).map(([k, r]) => {r.label}{r.domestic ? " (Dom)" : ""} )}
{isGroundMount &&
Ground Mount active ? roof racking zeroed in Equipment Cost.
}
{!isGroundMount && cfg.rackingDomRequired &&
? Non-domestic options hidden ? {lender} requires domestic
}
{/* 04B ? Domestic Content + FEOC */}
{C && (
04B ? Domestic Content + FEOC
PV System DC %
= C.dcThreshold ? c.success : c.danger }}>{C.pvDC.toFixed(1)}%
= C.dcThreshold ? "linear-gradient(90deg,#16a34a,#22c55e)" : "linear-gradient(90deg,#dc2626,#ef4444)", transition: "width .4s" }} />
0%
{C.isSHPanel || C.isSHInv
? `${C.dcThreshold}% ? ? Safe Harbor threshold`
: C.safeHarbored
? `${C.dcThreshold}% ? ? Safe Harbor`
: `${C.dcThreshold}% threshold`}
100%
{[["Module", C.modDC], ["Inverter", C.invDCPct], ["Racking", C.isGroundMount ? null : C.rackDCPct]].map(([l, v]) => (
{l}
0 ? c.success : c.text3 }}>{v === null ? "?" : `${v.toFixed(1)}%`}
))}
{C.storageMode && (
Battery DC
{C.batPending
?
? Pending ? select a battery adder in Section 04
: C.safeHarbored
?
? Safe Harbored ? 2026 rules do not apply
:
}
)}
{[["FEOC ? PV System", `?${C.feocPVThreshold}%`, C.safeHarbored ? "sh" : C.feocPVPass ? "pass" : "fail", C.safeHarbored ? "? Safe Harbored" : C.feocPVPass ? "? PASS" : "? FAIL"], ...(C.storageMode ? [["FEOC ? Battery", "?55%", C.safeHarbored ? "sh" : C.batPending ? "pend" : C.feocBatPass ? "pass" : "fail", C.safeHarbored ? "? Safe Harbored" : C.batPending ? "? Pending" : C.feocBatPass ? "? PASS" : "? FAIL"]] : [])].map(([l, r, t, badge]) => {
const fs = { pass: { background: c.successL, color: c.success }, fail: { background: c.dangerL, color: c.danger }, pend: { background: c.surface3, color: c.text3, border: `1.5px dashed ${c.border2}` }, sh: { background: "#fef9ec", color: "#92710a", border: "1.5px solid rgba(180,135,9,.25)" } };
return
{l} ({r}) {badge}
;
})}
IRS Notice 2025-08 APC tables. FEOC 2026: 40% PV, 55% Battery.{C.safeHarbored ? " ? Safe harbor active." : ""}{C.isSHPanel && C.isSHInv ? " ? LONGi + Tesla PW3 SH: Safe harbor pairing ? FEOC resolved. 45% DC threshold applies. PV + ESS holdbacks eligible." : C.isTeslaInv ? " ? Tesla PW3: Inverter contributes 0% to PV DC. ESS battery is DC-eligible. Both PV + ESS are FEOC compliant." : ""}
)}
{/* 04A ? Equipment Cost */}
03 ? Equipment Cost
{C ? (
<>
{partnerBOM ? (
? Partner Supplied BOM ? equipment costs zeroed.
) : (
<>
Panels ({C.pCnt} ? {fmt(panel?.price || 0)}){eqAdj.panel !== 0 && {eqAdj.panel > 0 ? "+" : ""}{eqAdj.panel.toFixed(2)}/W }
setEqAdj(p => ({...p, panel: Math.round((p.panel-0.01)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>?
setEqAdj(p => ({...p, panel: Math.round((p.panel+0.01)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>+
{eqAdj.panel !== 0 && setEqAdj(p => ({...p, panel:0}))} style={{ fontSize:9,color:c.text3,background:"none",border:"none",cursor:"pointer",padding:"0 2px" }}>reset }
{fmtPPW(C.panelCost/C.W)} {fmt(C.panelCost)}
{C.isTeslaInv
?
Inverter ? Tesla Str. Inv. equiv. (1538000-45-X) + MCI/RSD ? {C.pCnt} panels {fmtPPW(C.teslaInvCost / C.W)} {fmt(C.teslaInvCost)}
: C.invCost > 0 &&
{inv?.perPanel ? `Micros (${C.pCnt} ? ${fmt(inv?.price || 0)})` : "Inverter (system)"}{eqAdj.inv !== 0 && {eqAdj.inv > 0 ? "+" : ""}{eqAdj.inv.toFixed(2)}/W }
setEqAdj(p => ({...p, inv: Math.round((p.inv-0.01)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>?
setEqAdj(p => ({...p, inv: Math.round((p.inv+0.01)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>+
{eqAdj.inv !== 0 && setEqAdj(p => ({...p, inv:0}))} style={{ fontSize:9,color:c.text3,background:"none",border:"none",cursor:"pointer",padding:"0 2px" }}>reset }
{fmtPPW(C.invCost/C.W)} {fmt(C.invCost)}
}
{C.optCost > 0 &&
Optimizers ({C.pCnt} ? {fmt(inv?.optimizerPrice || 0)}) {fmtPPW(C.optCost / C.W)} {fmt(C.optCost)}
}
{inv?.brand === "enphase" &&
Combiner w/ Gateway Cell (IQ5C){eqAdj.comb !== 0 && {eqAdj.comb > 0 ? "+" : ""}{eqAdj.comb.toFixed(3)}/W }
setEqAdj(p => ({...p, comb: Math.round((p.comb-0.005)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>?
setEqAdj(p => ({...p, comb: Math.round((p.comb+0.005)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>+
{eqAdj.comb !== 0 && setEqAdj(p => ({...p, comb:0}))} style={{ fontSize:9,color:c.text3,background:"none",border:"none",cursor:"pointer",padding:"0 2px" }}>reset }
{fmtPPW(C.combCost/C.W)} {fmt(C.combCost)}
}
{C.isGroundMount
?
Roof Racking ? excluded (Ground Mount) $0.00
:
Racking ({rack?.ppw?.toFixed(3)}/W){eqAdj.rack !== 0 && {eqAdj.rack > 0 ? "+" : ""}{eqAdj.rack.toFixed(3)}/W }
setEqAdj(p => ({...p, rack: Math.round((p.rack-0.005)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>?
setEqAdj(p => ({...p, rack: Math.round((p.rack+0.005)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>+
{eqAdj.rack !== 0 && setEqAdj(p => ({...p, rack:0}))} style={{ fontSize:9,color:c.text3,background:"none",border:"none",cursor:"pointer",padding:"0 2px" }}>reset }
{fmtPPW(C.rackCost/C.W)} {fmt(C.rackCost)}
}
{C.laborMode === "internal"
?
BOS ($0.14/W + 15% cushion){eqAdj.bos !== 0 && {eqAdj.bos > 0 ? "+" : ""}{eqAdj.bos.toFixed(3)}/W }
setEqAdj(p => ({...p, bos: Math.round((p.bos-0.01)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>?
setEqAdj(p => ({...p, bos: Math.round((p.bos+0.01)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>+
{eqAdj.bos !== 0 && setEqAdj(p => ({...p, bos:0}))} style={{ fontSize:9,color:c.text3,background:"none",border:"none",cursor:"pointer",padding:"0 2px" }}>reset }
{fmtPPW(C.bosCost/C.W)} {fmt(C.bosCost)}
:
BOS ? included in sub rate{eqAdj.bos !== 0 && {eqAdj.bos > 0 ? "+" : ""}{eqAdj.bos.toFixed(3)}/W }
setEqAdj(p => ({...p, bos: Math.round((p.bos-0.01)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>?
setEqAdj(p => ({...p, bos: Math.round((p.bos+0.01)*1000)/1000}))} style={{ width:16,height:16,borderRadius:3,border:`1px solid ${c.border2}`,background:c.surface,color:c.text,fontSize:11,fontWeight:700,cursor:"pointer",lineHeight:1 }}>+
{eqAdj.bos !== 0 && setEqAdj(p => ({...p, bos:0}))} style={{ fontSize:9,color:c.text3,background:"none",border:"none",cursor:"pointer",padding:"0 2px" }}>reset }
{fmt(C.bosCost)}
}
)}
{C.shFee > 0 &&
{C.shFeeLabel} {fmt(C.shFee)}
}
{C.salesTax > 0 &&
Sales Tax ({(C.taxRate * 100).toFixed(1)}% ? Cash ? {st}) {fmt(C.salesTax)}
}
Total Equipment
{fmtPPW(C.equipTotalPPW)}
{fmt(C.equipTotal)}
) :
Configure job parameters above.
}
{/* end row 2 grid */}
{/* ?? ROW 3 ? ADDERS ?????????????????????????????????????????????????? */}
04 ? Adders
Toggle ? ? for detail
setAdderSecExpanded(v => !v)} style={{ padding: "4px 12px", borderRadius: 20, border: `1px solid ${c.border2}`, background: adderSecExpanded ? c.accentL : c.surface2, color: adderSecExpanded ? c.accent : c.text3, fontFamily: c.sans, fontSize: 11, fontWeight: 700, cursor: "pointer" }}>
{adderSecExpanded ? "? Collapse" : "? Show All Sections"}
{/* Dynamic Redline Adders section */}
{redlineSet.size > 0 && (
? Redline Adders ? included in redline floor ? {redlineSet.size} active
{[...redlineSet].map(key => {
const a = ADDER_MAP[key]; if (!a) return null;
return (
{a.label}
setRedlineSet(prev => { const n = new Set(prev); n.delete(key); return n; })} style={{ fontSize: 9, color: c.success, background: "none", border: "none", cursor: "pointer", padding: "0 2px", fontWeight: 700 }} title="Remove from redline">? remove
);
})}
)}
{ADDER_SECTIONS.filter(sec => {
if (adderSecExpanded) return true;
// Always show electrical and battery sections; collapse the rest
const alwaysVisible = ["Electrical Adders", "Enphase Batteries", "SolarEdge Batteries", "Tesla Batteries ? DC Coupled", "Tesla Batteries ? AC Coupled"];
// Also show if any adder in this section is currently selected
const hasActive = sec.keys.some(k => sel[k]);
return alwaysVisible.includes(sec.title) || hasActive;
}).map(sec => (
{sec.title}
{sec.keys.map(key => {
const a = ADDER_MAP[key]; if (!a) return null;
const isOn = !!sel[a.key], isExp = !!expanded[a.key];
const isTeslaDCInv = invK === "tesla_pw3_dc" || invK === "tesla_pw3_sh";
const teslaLocked = !!a.isTeslaLead && isTeslaDCInv;
const requiresTesla = (a.isTeslaLead || a.key === "bat_texp" || a.key === "bat_tpwx") && !isTeslaDCInv;
const blockedByTesla = (a.isTeslaACLead || a.isTeslaACPWX || a.key === "bat_tace") && isTeslaDCInv;
const blockedLender = a.blockLenders?.includes(lender);
const blockedInv = a.blockInvBrand && a.blockInvBrand === invBrand;
const isInRedline = redlineSet.has(a.key);
const blocked = blockedLender || blockedInv || requiresTesla || blockedByTesla;
const W = watts || 11500;
const pC = Math.ceil(W / (PANELS[panelK]?.watt || 410));
let cost, list;
if (a.isTeslaACLead || a.isTeslaACPWX || (a.isTeslaExp && a.key === "bat_tace")) { cost = calcTeslaACCost(a, laborMode); list = a.list ?? null; }
else if (a.isTeslaLead || a.isTeslaExp || a.isTeslaPWX) { cost = calcTeslaCost(a, laborMode, pC, INVERTERS[invK]?.pw3UnitPrice || 7388.88); list = a.list ?? null; }
else if (partnerBOM && a.isBattery) { cost = laborMode === "sub" ? (a.seaPartner || 0) : (a.intPartner || 0); list = a.listPartner ?? null; }
else { cost = adderCostFor(a, laborMode, W, trenchFt, boringQuote, boringFt, isGroundMount, redlineSet); list = adderListFor(a, W, trenchFt, boringQuote, boringFt, redlineSet); }
const q = a.isQtyAdder ? (qty[a.key] || 1) : 1;
const isBad = isOn && !blocked && list != null && (cost || 0) * q > (list * q);
const d = a.detail;
const blockReason = requiresTesla ? "Requires Tesla PW3-DC Coupled in Section 02" : blockedByTesla ? "? AC Coupled ? incompatible with Tesla DC-Coupled inverter" : blockedLender ? `? ${lender} ? not approved` : blockedInv ? `? Incompatible with ${invBrand === "enphase" ? "Enphase" : "SolarEdge"} inverter` : "";
return (
{/* Adder header row */}
!blocked && !teslaLocked && toggle(a.key)}>
{isOn && !blocked && ? }
{a.label}
{teslaLocked && AUTO }
{isInRedline && REDLINE }
{blocked &&
{blockReason}
}
{isOn && !blocked && !a.isTrench && !a.isBoring && !isInRedline &&
{cost != null ? `${fmt((cost || 0) * q)} cost` : "? pending"}{list != null ? ` ? ${fmt(list * q)} list` : ""}
}
{isOn && !blocked && isInRedline &&
{fmt(cost || 0)} ? adds to redline floor
}
{isOn && !blocked && a.isTrench &&
{trenchFt}ft ? {laborMode === "sub" || laborMode === "sea" ? `SEA ${fmt((a.seaBase || 0) + a.seaPFt * trenchFt)}` : `Int ${fmt(a.intPFt * trenchFt)}`} ? List {fmt(a.listBase + a.listPFt * trenchFt)}
}
{isOn && !blocked && a.isBoringBase &&
Quote ${boringQuote.toFixed(2)} ? List {fmt(boringQuote + 500)}
}
{isOn && !blocked && a.isBoringMaterial &&
{boringFt}ft ? {fmt(cost)} cost ? {fmt(list)} list
}
{ e.stopPropagation(); setRedlineSet(prev => { const n = new Set(prev); n.has(a.key) ? n.delete(a.key) : n.add(a.key); return n; }); }}
style={{ flexShrink: 0, width: 17, height: 17, borderRadius: 4, border: `1.5px solid ${isInRedline ? "rgba(22,101,52,.4)" : c.border}`, background: isInRedline ? c.successL : c.surface2, color: isInRedline ? c.success : c.text3, cursor: "pointer", fontSize: 9, display: "flex", alignItems: "center", justifyContent: "center", marginTop: 1, fontWeight: isInRedline ? 700 : 400 }}>
?
{d &&
{ e.stopPropagation(); toggleExp(a.key); }}>{isExp ? "?" : "?"} }
{/* Inline inputs */}
{isOn && !blocked && a.isBoringBase && (
Quote $:
List: {fmt((parseFloat(boringQuoteStr) || 0) + 500)}
)}
{isOn && !blocked && a.isBoringMaterial && (
Footage:
{boringFt}ft ? ${a.seaPFt}/ft ? ${a.listPFt}/ft list
)}
{isOn && !blocked && a.isQtyAdder && (
Qty:
setQtyFor(a.key, (qty[a.key] || 1) - 1)} style={{ width: 20, height: 20, borderRadius: 5, border: `1.5px solid rgba(13,110,110,.3)`, background: c.surface, color: c.accent, fontSize: 13, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>?
{qty[a.key] || 1}
setQtyFor(a.key, (qty[a.key] || 1) + 1)} style={{ width: 20, height: 20, borderRadius: 5, border: `1.5px solid rgba(13,110,110,.3)`, background: c.surface, color: c.accent, fontSize: 13, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>+
)}
{isOn && !blocked && a.isTrench && (
Footage:
{trenchFt}ft ? {laborMode === "internal" ? `Int $${(a.intPFt * trenchFt).toFixed(0)}` : `Sub $${(a.seaPFt * trenchFt).toFixed(0)}`}
)}
{/* Expand detail */}
{isExp && d && (
{d.summary}
{[["Crew", d.crew], ["Truck Roll", d.truckRoll ? "Yes (~$500?$1k)" : "No"], ["SEA Labor", d.hours.sea], ["Internal", d.hours.internal]].map(([l, v]) => (
))}
{d.bom && d.bom.length > 0 && (
<>
Bill of Materials
{d.bom.map((b, i) =>
{b.item} {b.cost}
)}
)}
{d.note &&
{d.note}
}
{d.rec &&
? {d.rec}
}
)}
))}
{/* Collapsed hint */}
{!adderSecExpanded && (() => {
const hiddenSecs = ADDER_SECTIONS.filter(sec => {
const alwaysVisible = ["Electrical Adders", "Enphase Batteries", "SolarEdge Batteries", "Tesla Batteries ? DC Coupled", "Tesla Batteries ? AC Coupled"];
const hasActive = sec.keys.some(k => sel[k]);
return !alwaysVisible.includes(sec.title) && !hasActive;
});
return hiddenSecs.length > 0 ? (
{hiddenSecs.map(s => s.title).join(" ? ")} ? hidden
setAdderSecExpanded(true)} style={{ fontSize: 11, color: c.accent, background: "none", border: "none", cursor: "pointer", fontWeight: 700, padding: 0 }}>Show All ?
) : null;
})()}
{/* 05 ? Adder Income */}
{C && (
05 ? Adder Income
Cost ? List ? Margin
{C.adderRows.filter(r => !r.isRedline).length > 0 ? (
<>
{(salesView ? ["Adder", "List Price"] : ["Adder", "Cost", "List", "Margin"]).map(h => {h} )}
{C.adderRows.filter(r => !r.isRedline).map((r, i) => {
const gm = r.list != null ? ((r.list - r.cost) / r.list * 100) : null;
return salesView
? {r.label} {r.list != null ? fmt(r.list) : "?"} {r.label} {fmt(r.cost)} {r.list != null ? fmt(r.list) : "?"} {gm != null ? `${gm.toFixed(0)}%` : "?"}
{salesView
? Total List {fmt(C.listSum)} Total {fmt(C.adderSum)} {fmt(C.listSum)} C.adderSum ? c.success : c.danger }}>{C.listSum > 0 ? `${(((C.listSum - C.adderSum) / C.listSum) * 100).toFixed(0)}%` : "?"} Net Adder Income List ? Cost = 0 ? c.success : c.danger }}>{fmt(C.listSum - C.adderSum)}
Rep note: Adder list ({fmt(C.listSum)}) comes out of gross spread before commission.
) :
No spread adders toggled ? activate adders in Section 04.
}
)}
{/* 06 ? Business Overhead */}
06 ? Business Overhead
2026 Budget
{C && (
<>
{[
["Equipment", fmtPPW(C.equipTotalPPW), c.text],
["Install Labor ? " + (laborMode === "sub" ? "Sub" : "Internal") + " ? " + (laborRate * 100).toFixed(0) + "?/W", "+ " + fmtPPW(C.baseLaborPPW), c.warn],
...(C.nonflushPrem > 0 ? [["Non-Flush Premium (+$0.12/W)", "+ " + fmtPPW(NONFLUSH_PPW), c.warn]] : []),
...(C.detachPrem > 0 ? [["Detached Structure (+$0.20/W)", "+ " + fmtPPW(DETACH_PPW), c.warn]] : []),
].map(([l, v, col]) => (
{l} {v}
))}
{/* Ancillary COGS ? adjustable $0.005/W increments */}
setOverheadOn(p => ({...p, ancillary: !p.ancillary}))} style={{ width: 28, padding: "1px 0", borderRadius: 10, border: `1px solid ${overheadOn.ancillary ? c.accent : c.border2}`, background: overheadOn.ancillary ? c.accentL : c.surface2, color: overheadOn.ancillary ? c.accent : c.text3, fontSize: 9, fontWeight: 700, cursor: "pointer" }}>{overheadOn.ancillary ? "ON" : "OFF"}
Ancillary Cost of Goods (surveys, permits, plan sets)
setAncillaryPPW(v => Math.max(0, Math.round((v - 0.005) * 1000) / 1000))} style={{ width: 18, height: 18, borderRadius: 4, border: `1px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 12, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>?
setAncillaryPPW(v => Math.round((v + 0.005) * 1000) / 1000)} style={{ width: 18, height: 18, borderRadius: 4, border: `1px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 12, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>+
{ancillaryPPW !== ANCILLARY_PPW && setAncillaryPPW(ANCILLARY_PPW)} style={{ fontSize: 9, color: c.text3, background: "none", border: "none", cursor: "pointer", padding: "0 2px" }}>reset }
{overheadOn.ancillary ? `+ ${fmtPPW(ancillaryPPW)}` : "?"}
{/* G&A ? adjustable $0.01/W increments */}
setOverheadOn(p => ({...p, ga: !p.ga}))} style={{ width: 28, padding: "1px 0", borderRadius: 10, border: `1px solid ${overheadOn.ga ? c.accent : c.border2}`, background: overheadOn.ga ? c.accentL : c.surface2, color: overheadOn.ga ? c.accent : c.text3, fontSize: 9, fontWeight: 700, cursor: "pointer" }}>{overheadOn.ga ? "ON" : "OFF"}
G&A Expenses
100-install avg
setGaPPW(v => Math.max(0, Math.round((v - 0.01) * 1000) / 1000))} style={{ width: 18, height: 18, borderRadius: 4, border: `1px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 12, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>?
setGaPPW(v => Math.round((v + 0.01) * 1000) / 1000)} style={{ width: 18, height: 18, borderRadius: 4, border: `1px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 12, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>+
{gaPPW !== GA_PPW_DEFAULT && setGaPPW(GA_PPW_DEFAULT)} style={{ fontSize: 9, color: c.text3, background: "none", border: "none", cursor: "pointer", padding: "0 2px" }}>reset }
{overheadOn.ga ? `+ ${fmtPPW(gaPPW)}` : "?"}
{/* Sales Ops ? adjustable $0.005/W increments */}
setOverheadOn(p => ({...p, sops: !p.sops}))} style={{ width: 28, padding: "1px 0", borderRadius: 10, border: `1px solid ${overheadOn.sops ? c.accent : c.border2}`, background: overheadOn.sops ? c.accentL : c.surface2, color: overheadOn.sops ? c.accent : c.text3, fontSize: 9, fontWeight: 700, cursor: "pointer" }}>{overheadOn.sops ? "ON" : "OFF"}
Sales Ops (excl. commissions)
100-install avg
setSopsPPW(v => Math.max(0, Math.round((v - 0.005) * 1000) / 1000))} style={{ width: 18, height: 18, borderRadius: 4, border: `1px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 12, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>?
setSopsPPW(v => Math.round((v + 0.005) * 1000) / 1000)} style={{ width: 18, height: 18, borderRadius: 4, border: `1px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 12, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>+
{sopsPPW !== SALESOPS_PPW_DEFAULT && setSopsPPW(SALESOPS_PPW_DEFAULT)} style={{ fontSize: 9, color: c.text3, background: "none", border: "none", cursor: "pointer", padding: "0 2px" }}>reset }
{overheadOn.sops ? `+ ${fmtPPW(sopsPPW)}` : "?"}
{/* Sales Leadership G&A ? scales with installs, $0.005/W increments */}
setOverheadOn(p => ({...p, leadership: !p.leadership}))} style={{ width: 28, padding: "1px 0", borderRadius: 10, border: `1px solid ${overheadOn.leadership ? c.accent : c.border2}`, background: overheadOn.leadership ? c.accentL : c.surface2, color: overheadOn.leadership ? c.accent : c.text3, fontSize: 9, fontWeight: 700, cursor: "pointer" }}>{overheadOn.leadership ? "ON" : "OFF"}
Sales Leadership G&A
$450k + 21% burden ? 100-install avg
setSalesLeadershipPPW(v => Math.max(0, Math.round((v - 0.005) * 1000) / 1000))} style={{ width: 18, height: 18, borderRadius: 4, border: `1px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 12, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>?
setSalesLeadershipPPW(v => Math.round((v + 0.005) * 1000) / 1000)} style={{ width: 18, height: 18, borderRadius: 4, border: `1px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 12, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>+
{salesLeadershipPPW !== SALES_LEADERSHIP_PPW_DEFAULT && setSalesLeadershipPPW(SALES_LEADERSHIP_PPW_DEFAULT)} style={{ fontSize: 9, color: c.text3, background: "none", border: "none", cursor: "pointer", padding: "0 2px" }}>reset }
{overheadOn.leadership ? `+ ${fmtPPW(salesLeadershipPPW)}` : "?"}
{/* Proposal & Sales Software ? flat constant, $0.005/W increments */}
setOverheadOn(p => ({...p, proposal: !p.proposal}))} style={{ width: 28, padding: "1px 0", borderRadius: 10, border: `1px solid ${overheadOn.proposal ? c.accent : c.border2}`, background: overheadOn.proposal ? c.accentL : c.surface2, color: overheadOn.proposal ? c.accent : c.text3, fontSize: 9, fontWeight: 700, cursor: "pointer" }}>{overheadOn.proposal ? "ON" : "OFF"}
Proposal & Sales Software Ancillary Costs
flat rate
setProposalPPW(v => Math.max(0, Math.round((v - 0.005) * 1000) / 1000))} style={{ width: 18, height: 18, borderRadius: 4, border: `1px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 12, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>?
setProposalPPW(v => Math.round((v + 0.005) * 1000) / 1000)} style={{ width: 18, height: 18, borderRadius: 4, border: `1px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 12, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>+
{proposalPPW !== PROPOSAL_PPW && setProposalPPW(PROPOSAL_PPW)} style={{ fontSize: 9, color: c.text3, background: "none", border: "none", cursor: "pointer", padding: "0 2px" }}>reset }
{overheadOn.proposal ? `+ ${fmtPPW(proposalPPW)}` : "?"}
{/* Installs per month slider */}
Installs / Month
{installsPerMonth}
{installsPerMonth !== 100 && { setInstallsPerMonth(100); setGaPPW(GA_PPW_DEFAULT); setSopsPPW(SALESOPS_PPW_DEFAULT); setSalesLeadershipPPW(SALES_LEADERSHIP_PPW_DEFAULT); }} style={{ fontSize: 9, color: c.text3, background: "none", border: "none", cursor: "pointer", padding: "0 2px" }}>reset }
{
let n = parseInt(e.target.value);
const snap = Math.round(n / 100) * 100;
if (snap >= 100 && Math.abs(n - snap) <= 8) n = snap;
else if (n <= 8) n = 1;
setInstallsPerMonth(n);
setGaPPW(Math.min(0.50, roundUpGA(GA_FIXED_MO / (n * W_STD_INSTALLS))));
setSopsPPW(Math.min(0.070, roundUpSops(SOPS_FIXED_MO / (n * W_STD_INSTALLS))));
setSalesLeadershipPPW(Math.min(0.15, roundUpSops(LEADERSHIP_FIXED_MO / (n * W_STD_INSTALLS))));
}}
style={{ width: "100%", accentColor: c.accent, cursor: "pointer", marginBottom: 6 }}
/>
{[1, 100, 200, 300, 400, 500, 600, 700, 800, 900, 1000].map(v => {
const pct = (v - 1) / (1000 - 1) * 100;
const offset = 8 * (0.5 - pct / 100);
const isActive = installsPerMonth === v;
return (
{ setInstallsPerMonth(v); setGaPPW(Math.min(0.50, roundUpGA(GA_FIXED_MO / (v * W_STD_INSTALLS)))); setSopsPPW(Math.min(0.070, roundUpSops(SOPS_FIXED_MO / (v * W_STD_INSTALLS)))); setSalesLeadershipPPW(Math.min(0.15, roundUpSops(LEADERSHIP_FIXED_MO / (v * W_STD_INSTALLS)))); }}
style={{ position: "absolute", left: `calc(${pct}% + ${offset}px)`, transform: "translateX(-50%)", fontSize: 9, cursor: "pointer", color: isActive ? c.accent : c.text3, fontWeight: isActive ? 700 : 400, whiteSpace: "nowrap" }}>
{v === 1 ? "1" : v}
);
})}
All-In Cost Floor
{fmtPPW(C.baseAllinPPW)}
? Commissions ($0.60/W ? 1099 reps ? excluded from floor)
{/* Campaign Cost Allocation */}
{(() => {
const cp = campaignP;
const setP = (field, val) => setCampaignP(prev => ({ ...prev, [field]: Math.max(0, val) }));
const stepP = (field, delta) => setP(field, cp[field] + delta);
const cov = cp.coverage || {};
const autoClosers = Math.ceil(cp.setters / 2.5);
const autoSetterCars = Math.ceil(cp.setters / 4);
const autoCloserCars = Math.ceil(autoClosers / 2.5);
const dispClosers = cp.manualOverride ? cp.manualClosers : autoClosers;
const dispSetterCars = cp.manualOverride ? cp.manualSetterCars : autoSetterCars;
const dispCloserCars = cp.manualOverride ? cp.manualCloserCars : autoCloserCars;
const inputBox = (label, value, onMinus, onPlus, onChange, disabled = false, highlight = false) => (
);
return (
{/* Header row */}
Campaign Cost Allocation
direct deals only
setCampaignOn(v => !v)} style={{ padding: "4px 12px", borderRadius: 20, border: `1.5px solid ${campaignOn ? c.accent : c.border2}`, background: campaignOn ? c.accentL : c.surface2, color: campaignOn ? c.accent : c.text3, fontFamily: c.sans, fontSize: 11, fontWeight: 700, cursor: "pointer" }}>
{campaignOn ? "? ON" : "? OFF"}
{campaignOn && C && (
<>
{/* Internal / Dealer selector */}
{[{k:false,l:"Internal Deal"},{k:true,l:"Dealer Deal"}].map(({k,l})=>(
setCampaignP(prev=>({...prev, dealerMode:k}))}
style={{ flex:1, padding:"7px 4px", borderRadius:7, border:cp.dealerMode===k?`1px solid ${c.border}`:"none", background:cp.dealerMode===k?c.surface:"transparent", color:cp.dealerMode===k?(k?c.blue:c.accent):c.accent, cursor:"pointer", fontFamily:c.sans, fontSize:12, fontWeight:cp.dealerMode===k?700:600 }}>
{l}
))}
{cp.dealerMode ? (
Dealer mode: Dealer covers their own campaign costs. No amount is withheld from the commission pool on this deal.
) : (
<>
{/* Manual Override toggle */}
Manual Override
{cp.manualOverride?"Free-form inputs active":"Auto-calculating from constraints"}
{
if (!cp.manualOverride) setCampaignP(prev=>({...prev, manualOverride:true, manualClosers:autoClosers, manualSetterCars:autoSetterCars, manualCloserCars:autoCloserCars}));
else setCampaignP(prev=>({...prev, manualOverride:false}));
}} style={{ padding:"4px 10px", borderRadius:16, border:`1px solid ${cp.manualOverride?c.warn:c.border2}`, background:cp.manualOverride?c.warn:c.surface2, color:cp.manualOverride?"#fff":c.text3, fontFamily:c.sans, fontSize:10, fontWeight:700, cursor:"pointer" }}>
{cp.manualOverride?"? Manual":"? Auto"}
{/* Headcount */}
Headcount
{inputBox("Setters", cp.setters, ()=>stepP("setters",-1), ()=>stepP("setters",1), e=>{const v=parseInt(e.target.value);if(!isNaN(v))setP("setters",v);}, false, true)}
{cp.manualOverride
? inputBox("Closers (manual)", cp.manualClosers, ()=>setP("manualClosers",cp.manualClosers-1), ()=>setP("manualClosers",cp.manualClosers+1), e=>{const v=parseInt(e.target.value);if(!isNaN(v))setP("manualClosers",v);})
:
Closers (auto)
{autoClosers}
ceil({cp.setters} ? 2.5)
}
{cp.manualOverride
? inputBox("Setter Cars", cp.manualSetterCars, ()=>setP("manualSetterCars",cp.manualSetterCars-1), ()=>setP("manualSetterCars",cp.manualSetterCars+1), e=>{const v=parseInt(e.target.value);if(!isNaN(v))setP("manualSetterCars",v);})
:
Setter Cars (auto)
{autoSetterCars}
ceil({cp.setters} ? 4)
}
{cp.manualOverride
? inputBox("Closer Cars", cp.manualCloserCars, ()=>setP("manualCloserCars",cp.manualCloserCars-1), ()=>setP("manualCloserCars",cp.manualCloserCars+1), e=>{const v=parseInt(e.target.value);if(!isNaN(v))setP("manualCloserCars",v);})
:
Closer Cars (auto)
{autoCloserCars}
ceil({autoClosers} ? 2.5)
}
{/* Rates */}
Rates
{inputBox("Days", cp.days, ()=>stepP("days",-1), ()=>stepP("days",1), e=>{const v=parseInt(e.target.value);if(!isNaN(v))setP("days",v);})}
{inputBox("Est. Installs", cp.installs, ()=>stepP("installs",-1), ()=>stepP("installs",1), e=>{const v=parseInt(e.target.value);if(!isNaN(v))setP("installs",v);})}
{inputBox("Airbnb/Night ($)", cp.airbnbPerDay, ()=>stepP("airbnbPerDay",-5), ()=>stepP("airbnbPerDay",5), e=>{const v=parseFloat(e.target.value);if(!isNaN(v))setP("airbnbPerDay",v);})}
{inputBox("Car/Day ($)", cp.carPerDay, ()=>stepP("carPerDay",-5), ()=>stepP("carPerDay",5), e=>{const v=parseFloat(e.target.value);if(!isNaN(v))setP("carPerDay",v);})}
{inputBox("Flight/Rep ($)", cp.flightPerRep, ()=>stepP("flightPerRep",-50), ()=>stepP("flightPerRep",50), e=>{const v=parseFloat(e.target.value);if(!isNaN(v))setP("flightPerRep",v);})}
{/* Per-line ops/sales coverage table */}
Cost Coverage ? Ops or Sales
{[
{ key:"airbnb", label:"Airbnb", amt:C.campAirbnbAmt, sub:`${dispClosers+cp.setters} ppl ? $${cp.airbnbPerDay} ? ${cp.days}d` },
{ key:"setterCars", label:"Setter Cars", amt:C.campSetCarAmt, sub:`${dispSetterCars} cars ? $${cp.carPerDay} ? ${cp.days}d` },
{ key:"closerCars", label:"Closer Cars", amt:C.campCloseCarAmt, sub:`${dispCloserCars} cars ? $${cp.carPerDay} ? ${cp.days}d` },
{ key:"flights", label:"Flights", amt:C.campFlightsAmt, sub:`${dispClosers+cp.setters} ppl ? $${cp.flightPerRep}` },
].map(({ key, label, amt, sub }, i, arr) => {
const isOps = cov[key] === "ops";
return (
{label}
{sub} = ${amt.toLocaleString("en-US",{maximumFractionDigits:0})}
${amt.toLocaleString("en-US",{maximumFractionDigits:0})}
setCampaignP(prev=>({...prev,coverage:{...prev.coverage,[key]:"ops"}}))}
style={{ padding:"3px 10px", borderRadius:16, border:"none", background:isOps?"#fee2e2":"transparent", color:isOps?c.danger:c.text3, fontFamily:c.sans, fontSize:10, fontWeight:700, cursor:"pointer" }}>Ops
setCampaignP(prev=>({...prev,coverage:{...prev.coverage,[key]:"sales"}}))}
style={{ padding:"3px 10px", borderRadius:16, border:"none", background:!isOps?c.warnL:"transparent", color:!isOps?c.warn:c.text3, fontFamily:c.sans, fontSize:10, fontWeight:700, cursor:"pointer" }}>Sales
);
})}
{/* Summary totals */}
{[
{ label:"Total Campaign", val:`$${C.campTotalCost.toLocaleString("en-US",{maximumFractionDigits:0})}`, col:c.text },
{ label:"Ops ? Redline", val:`+${fmtPPW(C.campaignOpsPPW)}`, col:c.danger },
{ label:"Sales ? Escrow", val:C.campaignSalesPPW>0?fmtPPW(C.campaignSalesPPW):"$0.000/W", col:C.campaignSalesPPW>0?c.warn:c.text3 },
].map(({label,val,col})=>(
))}
)}
)}
);
})()}
{C.smallSystem &&
? Small system (<9kW) ? fixed costs don't scale. Floor likely understated.
}
{!salesView && C.hb && (
? Lightreach Holdback + DC Boost
Standard Holdback +$0.10/W
{dcOn &&
DC Boost ? {jobType === "storage" ? "PV+Storage" : "PV Only"} ? {st} +${C.hb.dcBoost.toFixed(2)}/W
}
Total M4 Add-Back +${C.hb.total.toFixed(2)}/W
{C.targetSc &&
At {effectiveM}%: portal {fmtPPW(C.targetSc.baseRedlinePPW)} ? backend {fmtPPW(C.targetSc.baseRedlinePPW + C.hb.total)}
}
)}
)}
{/* end row 5 Business Overhead */}
{/* ?? ROW 6 ? TARGET MARGIN (thin full-width bar) ????????????????????? */}
07 ? Target Margin
{MARGIN_PRESETS.map(m => {
const isActive = effectiveM === m && customMStr === "", isZero = m === 0;
return setPresetM(m)} style={{ padding: "5px 13px", borderRadius: 20, border: `1.5px solid ${isActive ? (isZero ? "rgba(109,40,217,.3)" : "rgba(13,110,110,.4)") : c.border}`, background: isActive ? (isZero ? c.purpleL : c.accentL) : c.surface2, color: isActive ? (isZero ? c.purple : c.accent) : c.text3, cursor: "pointer", fontFamily: c.sans, fontSize: 12, fontWeight: 700 }}>{m === 0 ? "Cost Floor" : `${m}%`} ;
})}
Custom %:
setCustomMStr("")}>? }
{C && (
Target $/W:
{impliedMargin.toFixed(1)}% GM ;
})()}
{targetPPWStr && setTargetPPWStr("")}>? }
)}
Active Target
{C &&
{fmtPPW(C.targetSc.baseRedlinePPW)}
}
{effectiveM}%
{/* ?? ROW 7 ? REDLINE SCENARIOS ??????????????????????????????????????? */}
08 ? Redline Scenarios
Base system rate only ? Click any row to switch target
{C ? (
<>
{(() => {
// Build display scenarios ? presets + injected custom row, sorted by margin
const customM = customMStr !== "" ? parseFloat(customMStr) : null;
const validCustomM = customM != null && !isNaN(customM) && !MARGIN_PRESETS.includes(customM) && customM >= 0 && customM <= 60;
const tPPW = parseFloat(targetPPWStr);
const validTPPW = targetPPWStr !== "" && !isNaN(tPPW) && tPPW > 0 && C.baseAllinNoAdders > 0;
const impliedM = validTPPW ? (1 - C.baseAllinNoAdders / (tPPW * C.W)) * 100 : null;
const validImpliedM = impliedM != null && !MARGIN_PRESETS.includes(Math.round(impliedM * 10) / 10);
const allScenarios = [
...C.mScenarios.map(s => ({ ...s, type: "preset" })),
...(validCustomM ? [{ m: customM, type: "custom", label: `${customM}%`, equipOnlyPPW: C.equipTotalPPW, baseRedlinePPW: rl(C.baseAllinNoAdders, customM) / C.W }] : []),
...(validImpliedM && validTPPW ? [{ m: impliedM, type: "targetppw", label: `${impliedM.toFixed(1)}%`, equipOnlyPPW: C.equipTotalPPW, baseRedlinePPW: tPPW }] : []),
].sort((a, b) => a.m - b.m);
const chipStyle = { 0: { background: c.purpleL, color: c.purple, border: `1px solid rgba(109,40,217,.2)` }, low: { background: c.warnL, color: c.warn, border: `1px solid rgba(180,83,9,.2)` }, good: { background: c.accentL, color: c.accent, border: `1px solid rgba(13,110,110,.2)` }, high: { background: c.dangerL, color: c.danger, border: `1px solid rgba(185,28,28,.2)` } };
return (
{["Margin", "Equip Only PPW", "Base Redline PPW"].map(h => {h} )}
{allScenarios.map((s, i) => {
const isActive = Math.abs(s.m - effectiveM) < 0.01;
const isCustom = s.type === "custom";
const isTPPW = s.type === "targetppw";
const isSpecial = isCustom || isTPPW;
const chipK = s.m === 0 ? "0" : s.m <= 15 ? "low" : s.m <= 25 ? "good" : "high";
const rowBg = isActive ? c.accentL : isSpecial ? `${c.accentL}88` : "transparent";
const handleClick = () => {
if (isTPPW) { setCustomMStr(s.m.toFixed(4)); setTargetPPWStr(""); }
else if (isCustom) { /* already active ? no-op */ }
else setPresetM(s.m);
};
return (
{s.m === 0 && !isSpecial ? "Cost Floor" : `${isSpecial ? s.m.toFixed(1) : s.m}%`}
{isCustom && CUSTOM }
{isTPPW && $/W TARGET }
{fmtPPW(s.equipOnlyPPW)}
{fmtPPW(s.baseRedlinePPW)}
);
})}
);
})()}
{!salesView &&
{C.actualCOGS ? (
? Actual COGS ? {st} / {lender} / {roofType === "flush" ? "Flush" : "Non-Flush"}{detached ? " / Detached" : ""}
{[["Median", fmtPPW(C.actualCOGS.median)], ["Avg", fmtPPW(C.actualCOGS.avg)], ["Std Dev", `?${C.actualCOGS.stddev.toFixed(3)}`]].map(([l, v]) => (
))}
Model floor vs. median: = 0 ? c.success : c.danger }}>{(C.allInPPW - C.actualCOGS.median) >= 0 ? "+" : ""}{(C.allInPPW - C.actualCOGS.median).toFixed(3)}/W
{C.actualCOGS.jobs} jobs{C.actualCOGS.lowConf ? " ? ? low confidence" : ""}
) : (
No COGS benchmark for {st} / {lender} yet.
)}
{C.histPPW && (
2025 Market Avg ? {st} / {lender} {fmtPPW(C.histPPW)}
Cushion @ {effectiveM}% redline = 0 ? c.success : c.danger }}>{(C.histPPW - C.targetSc.baseRedlinePPW) >= 0 ? "+" : ""}{(C.histPPW - C.targetSc.baseRedlinePPW).toFixed(3)}/W
)}
}
) :
No data ? configure job parameters above.
}
{/* ?? ROW 8 ? COMMISSION CALCULATOR | OPS P&L ????????????????????????? */}
{/* 09 ? Commission Calculator */}
{C && (() => {
const W = C.W;
const base$ = C.targetSc.baseRedline$;
const adderList$ = C.listSum;
const floor$ = base$ + adderList$;
const floorPPW = floor$ / W;
const soldPPW = parseFloat(soldPPWStr) || 0;
const soldTotal = soldPPW * W;
const grossSpread = soldTotal - base$;
const commTotal = grossSpread - adderList$;
const commPPW = commTotal / W;
const commPct = soldTotal > 0 ? (commTotal / soldTotal * 100) : 0;
const targetComm = parseFloat(targetCommStr) || 0;
const reqTotal = base$ + adderList$ + targetComm;
const reqPPW = reqTotal / W;
const reqCommPct = reqTotal > 0 ? (targetComm / reqTotal * 100) : 0;
return (
09 ? Commission Calculator
Spread ? Adder List = Commission
{
// Solve lender inputs to hit soldPPW before switching tabs
if (soldPPW > 0 && C) {
const kw = C.W / 1000;
const solved = {};
(LENDERS_BY_STATE[st] || []).forEach(l => {
const combo = commSolveForTarget(l, st, util, dcOn, ecOn, kw, soldPPW);
if (combo) solved[l] = combo;
});
if (Object.keys(solved).length > 0) setLinputs(solved);
}
setActiveTab("commissions");
}} style={{ padding:"5px 12px", background:c.accentL, border:`1.5px solid rgba(13,110,110,.3)`, borderRadius:8, color:c.accent, fontFamily:c.sans, fontSize:11, fontWeight:700, cursor:"pointer", letterSpacing:".03em" }}>? Open Commissions Model ?
{/* Summary strip */}
{[["Base Redline", fmtPPW(C.targetSc.baseRedlinePPW), fmt(base$), c.accent], ["Adder List", adderList$ > 0 ? fmt(adderList$) : "$0", adderList$ > 0 ? "Out of spread" : "No adders", c.warn], ["Floor", fmtPPW(floorPPW), fmt(floor$), c.text]].map(([l, v, s, col]) => (
))}
{/* Mode toggle */}
setCommMode("sold_rate")}>Option 1 ? Set Sold EPC
setCommMode("target_comm")}>Option 2 ? Target Commission
{commMode === "sold_rate" ? (
<>
Gross EPC Sold ($/W)
setSoldPPWStr(v => { const n = parseFloat(v) || 0; const d = parseFloat((n / 0.05).toFixed(6)); const f = Math.floor(d); const snapped = Math.abs(f - d) < 0.0001 ? n - 0.05 : f * 0.05; return Math.max(2.50, snapped).toFixed(3); })} style={{ width: 28, height: 28, borderRadius: 6, border: `1.5px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 16, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>?
setSoldPPWStr(v => { const n = parseFloat(v) || 0; const d = parseFloat((n / 0.05).toFixed(6)); const ce = Math.ceil(d); const snapped = Math.abs(ce - d) < 0.0001 ? n + 0.05 : ce * 0.05; return Math.min(5.00, snapped).toFixed(3); })} style={{ width: 28, height: 28, borderRadius: 6, border: `1.5px solid ${c.border2}`, background: c.surface, color: c.text, fontSize: 16, fontWeight: 700, cursor: "pointer", lineHeight: 1 }}>+
$0.05/W increments
setSoldPPWStr(parseFloat(e.target.value).toFixed(3))} style={{ width: "100%", accentColor: c.accent, cursor: "pointer" }} />
$2.50/W $5.00/W
{[
[`Gross EPC Sold (${fmtPPW(soldPPW)})`, fmt(soldTotal), c.text, false],
["Less Base Redline", `(${fmt(base$)})`, c.danger, false],
...(adderList$ > 0 ? [["Less Adder List", `(${fmt(adderList$)})`, c.warn, false]] : []),
["= Gross Sales Spread", fmt(commTotal), commTotal >= 0 ? c.text : c.danger, true],
].map(([l, v, col, bold], i, arr) => (
{l} {v}
))}
= 0 ? c.successL : c.dangerL, border: `1.5px solid ${commTotal >= 0 ? "rgba(22,101,52,.25)" : "rgba(185,28,28,.25)"}`, borderRadius: 9, padding: "13px 15px" }}>
= 0 ? c.success : c.danger, marginBottom: 3 }}>Rep Commission
= 0 ? c.success : c.danger, opacity: .8 }}>{fmtPPW(Math.abs(commPPW))} ? {Math.abs(commPct).toFixed(1)}% of sold
= 0 ? c.success : c.danger, lineHeight: 1 }}>{fmt(Math.abs(commTotal))}
{commTotal < 0 &&
? Sold price is below floor ? deal is at a loss.
}
) : (
<>
{targetComm > 0 ? (
Required Sold EPC
{fmt(reqTotal)} total ? {reqCommPct.toFixed(1)}% commission rate
{fmtPPW(reqPPW)}
) : (
Enter a target commission to see required EPC.
)}
)}
Gross EPC Sold ? less Base Redline ({effectiveM}% GM) = Gross Spread ? less Adder List = Rep Commission.
);
})()}
{/* 10 ? Operations P&L */}
{!salesView && C && (() => {
const W = C.W;
// If a lender option is locked in the commissions tab, use that option's actual EPC
const lockedOpt = waterfallLender ? selectedOptions[waterfallLender] : null;
const lockedEPC = lockedOpt ? lockedOpt.epc : null;
const effectiveSoldPPW = lockedEPC || parseFloat(soldPPWStr) || 0;
const soldTotal = effectiveSoldPPW * W;
const hasSoldRate = commMode === "sold_rate" && effectiveSoldPPW > 0;
const base$ = C.targetSc.baseRedline$;
const adderList$ = C.listSum;
const grossSpread = soldTotal - base$;
const commTotal = hasSoldRate ? Math.max(0, grossSpread - adderList$) : 0;
const allInCost = C.totalAllin;
const grossOpsIncome = hasSoldRate ? soldTotal - allInCost - commTotal : base$ + adderList$ - allInCost;
const opsMarginPct = hasSoldRate && soldTotal > 0 ? (grossOpsIncome / soldTotal * 100) : 0;
const hbPct = C.hb?.total || 0;
const hbAmt = hbPct * W;
const atFunding = hasSoldRate ? soldTotal - allInCost - commTotal : null;
const totalOpsIncome = hasSoldRate ? atFunding + hbAmt : grossOpsIncome;
const equipCost = C.equipTotal;
const laborCost = C.baseLaborCost;
const gaCost = C.gaCost;
const sopsCost = C.sopsCost;
const ancillaryCost = C.ancillaryCost;
const adderCostTotal = C.adderSum;
const premCost = (C.nonflushPrem || 0) + (C.detachPrem || 0);
return (
10 ? Operations P&L
{waterfallLender && lockedEPC && ? {lockedOpt?.lender === "IGS_TX" ? "IGS TX" : (lockedOpt?.lender || waterfallLender)} ? {lockedOpt?.type === "bestComm" ? "?" : lockedOpt?.type === "closestMatch" ? "?" : "?"} ? {fmtPPW(lockedEPC)} }
Expected ops return on this deal
{!hasSoldRate ? (
Set a Sold EPC in Section 09 to see ops P&L.
) : (
<>
{/* Top metric strip */}
{[
["Net Funding", hasSoldRate ? fmt(atFunding) : "?", fmtPPW((atFunding || 0) / W), atFunding >= 0 ? c.success : c.danger],
["+ Holdback Bonus", hbPct > 0 ? fmt(hbAmt) : "None", hbPct > 0 ? `${fmtPPW(hbPct)} post-PTO` : "No holdback this lender", hbPct > 0 ? c.warn : c.text3],
["Total Ops Income", hasSoldRate ? fmt(totalOpsIncome) : "?", hbPct > 0 ? `${((totalOpsIncome / soldTotal) * 100).toFixed(1)}% of sold` : `${opsMarginPct.toFixed(1)}% of sold`, totalOpsIncome >= 0 ? c.success : c.danger],
].map(([l, v, s, col]) => (
))}
{/* Waterfall */}
Revenue & Cost Waterfall
{[
[`Gross EPC Sold (${fmtPPW(effectiveSoldPPW)}${lockedEPC ? ` ? ${lockedOpt?.lender === "IGS_TX" ? "IGS TX" : lockedOpt?.lender} actual` : ""})`, fmt(soldTotal), c.text, false],
["Less: Equipment & Materials", `(${fmt(equipCost)})`, c.text2, false],
["Less: Install Labor", `(${fmt(laborCost)})`, c.text2, false],
["Less: G&A", `(${fmt(gaCost)})`, c.text2, false],
["Less: Sales Ops", `(${fmt(sopsCost)})`, c.text2, false],
["Less: Ancillary COGS", `(${fmt(ancillaryCost)})`, c.text2, false],
...(adderCostTotal > 0 ? [["Less: Adder Costs", `(${fmt(adderCostTotal)})`, c.text2, false]] : []),
...(premCost > 0 ? [["Less: Roof Premiums", `(${fmt(premCost)})`, c.text2, false]] : []),
["= Gross Margin", fmt(soldTotal - allInCost), soldTotal - allInCost >= 0 ? c.text : c.danger, true],
["Less: Rep Commission", `(${fmt(commTotal)})`, c.warn, false],
["= Net Funding", fmt(atFunding || 0), (atFunding || 0) >= 0 ? c.success : c.danger, true],
...(hbPct > 0 ? [[`+ Holdback Bonus (${fmtPPW(hbPct)} post-PTO)`, fmt(hbAmt), c.warn, false], ["= Total Ops Income", fmt(totalOpsIncome), totalOpsIncome >= 0 ? c.success : c.danger, true]] : []),
].map(([l, v, col, bold], i, arr) => (
{l}
{v}
))}
{hbPct > 0 && (
= 0 ? c.successL : c.dangerL, border: `1.5px solid ${totalOpsIncome >= 0 ? "rgba(22,101,52,.25)" : "rgba(185,28,28,.25)"}`, borderRadius: 9, padding: "13px 15px" }}>
= 0 ? c.success : c.danger, marginBottom: 3 }}>Total Ops Income
= 0 ? c.success : c.danger, opacity: .8 }}>{fmt(atFunding || 0)} at funding + {fmt(hbAmt)} holdback bonus
= 0 ? c.success : c.danger, lineHeight: 1 }}>{fmt(totalOpsIncome)}
)}
)}
);
})()}
{/* end row 7 grid */}
eEquals Solar ? CR Solar LLC ? Pricing Model v2.5 ? March 2026 ? Internal Use Only
}{/* end Tab 1 */}
{activeTab === "commissions" &&
}
{activeTab === "dealer" &&
}
{activeTab === "bom" &&
}
{activeTab === "bos" &&
}
);
}
ReactDOM.createRoot(document.getElementById('root')).render(React.createElement(PricingTool));