Excel Gradebook With Weighted Grades: Validate the Score State First

Select the code and use your copy shortcut. Changes in this preview are temporary.

<!doctype html>
<html lang="en-US"><head><meta charset="utf-8"><meta name="viewport" content="width=device-width,initial-scale=1"><title>Excel Gradebook With Weighted Grades: Validate the Score State First</title><style>:root{--bg:#f6f0e3;--paper:#fffdf7;--ink:#283f38;--accent:#376548;--tint:#e4efdc;--line:#c3cdbb;--muted:#4c6051;--button:#fff}*{box-sizing:border-box}body{margin:0;background:var(--bg);color:var(--ink);font:17px/1.55 system-ui,sans-serif}main{max-width:1000px;margin:auto;padding:22px clamp(18px,4vw,42px) 38px}header{border-bottom:2px solid var(--accent);padding-bottom:14px;margin-bottom:18px}h1{font-size:clamp(26px,4vw,36px);line-height:1.15;margin:4px 0 10px}h2{font-size:22px;line-height:1.3;margin:0 0 14px}h3{font-size:19px}p{margin:0 0 14px}.eyebrow{font-size:16px;font-weight:750;color:var(--accent)}.lede{max-width:800px}.panel{background:var(--paper);border:1px solid var(--line);border-radius:9px;padding:20px;margin:18px 0}.workbench{border-top:4px solid var(--accent)}.grid{display:grid;grid-template-columns:repeat(2,minmax(0,1fr));gap:16px}.grid>*{min-width:0}label{display:block;font-size:16px;font-weight:650;margin:12px 0 6px}input,textarea,select{font:inherit;color:var(--ink);background:var(--paper);border:1px solid #7b8893;border-radius:5px;padding:10px;width:100%;min-width:0}textarea{resize:vertical;line-height:1.45}input[type=checkbox],input[type=radio]{width:21px;height:21px;vertical-align:middle;margin-right:9px}button{font:650 16px/1.4 system-ui,sans-serif;padding:11px 15px;min-height:46px;background:var(--accent);border:2px solid var(--accent);color:var(--button);border-radius:5px;cursor:pointer}button:disabled{opacity:.55;cursor:default}.buttons{display:flex;gap:9px;flex-wrap:wrap;margin:14px 0}.buttons>*{flex:1 1 auto}button:focus-visible,input:focus-visible,textarea:focus-visible,select:focus-visible,summary:focus-visible{outline:3px solid #c05b00;outline-offset:3px}.result{font:600 17px/1.6 ui-monospace,monospace;white-space:pre-wrap;overflow-wrap:anywhere;background:var(--tint);padding:16px;border-left:4px solid var(--accent);min-height:65px;margin:16px 0}.sample{padding:14px 16px;border-left:3px solid var(--accent);background:var(--tint);margin:12px 0}.muted{color:var(--muted)}pre,code{font:16px/1.6 ui-monospace,monospace;white-space:pre-wrap;overflow-wrap:anywhere}pre{margin:12px 0}table{border-collapse:collapse;width:100%;table-layout:fixed;font-size:16px}th,td{text-align:left;vertical-align:top;padding:10px 8px;border-bottom:1px solid var(--line);overflow-wrap:anywhere}th{background:var(--tint)}svg{max-width:100%;height:auto;display:block}details{margin:20px 0}summary{font-weight:700;cursor:pointer}footer{margin-top:28px;border-top:1px solid var(--line);padding-top:18px;font-size:16px}a{color:var(--accent)}.reading{font-family:Georgia,serif}.codeview{border-radius:0;box-shadow:7px 7px 0 var(--tint)}.token{display:inline-block;padding:8px 12px;margin:4px;border:1px solid var(--line);border-radius:4px;background:var(--paper)}.swatch{min-height:30px}.split{display:grid;grid-template-columns:1.1fr 1fr;gap:22px}ol{padding-left:25px}li{margin:9px 0}@media(max-width:600px){main{padding:16px}.grid,.split{grid-template-columns:1fr}.panel{padding:16px;margin:14px 0}h1{font-size:27px}header{padding-bottom:10px}.buttons{gap:8px}.result{padding:13px}th,td{padding:8px 5px}}</style></head><body><main><header><div class="eyebrow">Original practice fixture · local workbench</div><h1>Zero, blank, and EX are different states</h1><p class="lede">Practice P1 is 8/10 and P2 is 16/20; Project J1 is 18/20. Weights 0.4 and 0.6 give 86%. A recorded P1 zero gives 75.333333%; an unrecorded P1 holds calculation. Authorized EX excludes P1 earned and possible points, giving 86%.</p></header><pre id="result" class="result" role="status" aria-live="polite" aria-atomic="true">Student A: Practice 24/30 × 0.4 + Project 18/20 × 0.6 = 86%.</pre><div class="buttons"><button type="button" id="recorded">Recorded</button><button type="button" id="zero">Recorded zero</button><button type="button" id="blank">Unrecorded</button><button type="button" id="ex">Authorized EX</button></div><p id="state">P1: recorded</p><label for="score">P1 earned · possible 10</label><input id="score" value="8" ><label for="wp">Practice weight</label><input id="wp" value=".4" ><label for="wj">Project weight</label><input id="wj" value=".6" ><div class="buttons"><button type="button" id="calculate">Calculate</button></div><section class="panel"><h2>Fixed included scores</h2><p>P2: Practice 16/20. J1: Project 18/20. Both recorded. EX is only authorized within this fictional policy.</p></section><footer><p>This is a local fictional-policy calculator, not an XLSX workbook or native Excel recalculation.</p><p>Use a prepared HTML explanation in <a href="https://nos-workspace.com/">NOS</a> when reviewing this fictional category-weighted calculator. Eligible static instructions can be revised in visual editing mode; dynamic outputs follow their controls.</p></footer></main><script>
(()=>{'use strict';const $=s=>document.querySelector(s);const out=s=>{$('#result').textContent=s;};const val=id=>$('#'+id).value;const num=id=>{const s=val(id).trim();return s===''?NaN:Number(s);};const on=(id,fn)=>$('#'+id).addEventListener('click',fn);const watch=ids=>{for(const id of ids)for(const event of ['input','change'])$('#'+id).addEventListener(event,()=>out('Inputs changed. Run the action to update this result.'));};const fmt=(n,d=4)=>Math.abs(n)<1e-10?(0).toFixed(d):n.toFixed(d);
let state='recorded';function choose(s){state=s;$('#state').textContent='P1: '+s;out('State changed. Recalculate.');}on('recorded',()=>choose('recorded'));on('zero',()=>{$('#score').value='0';choose('recorded');});on('blank',()=>choose('unrecorded'));on('ex',()=>choose('EX'));watch(['score','wp','wj']);on('calculate',()=>{const w=num('wp'),j=num('wj'),s=num('score');if(![w,j].every(Number.isFinite)||w<0||j<0||Math.abs(w+j-1)>1e-9){out('HOLD: weights must be nonnegative and total 1.');return;}if(state==='unrecorded'){out('HOLD: required P1 score is unrecorded.');return;}if(state==='recorded'&&(!Number.isFinite(s)||s<0||s>10)){out('HOLD: score must be 0–10.');return;}const e=state==='EX'?16:s+16,d=state==='EX'?20:30,a=e/d*w,b=.9*j;out('Practice '+e+'/'+d+'; contribution '+fmt(a*100,6)+' points. Project 18/20; contribution '+fmt(b*100,6)+' points. Overall '+fmt((a+b)*100,6)+'%.');});
})();
</script></body></html>