matchupMatrix2 = { // selected week index + data guard const weekIdx = weekNo(weekSlider) - 1; const weekData = weeklyData?.[weekIdx]; if (!weekData || !weekData.length) { return html`

No data for ${weekSlider}.

`; } // column keys / name detection const keys = Object.keys(weekData[0] || {}); const metaKeys = ["timestamp", "email address", "nfl week"]; const nameKey = keys.find(k => /name/i.test(k)) || keys.find(k => /first/i.test(k)) || keys.find(k => !metaKeys.includes(String(k).trim().toLowerCase())) || keys[0]; // normalizer const normalize = s => (s == null ? "" : String(s).trim().replace(/\s+/g, " ").toLowerCase()); // build keyRows (one per week) from the full weeklyData set // safe even if some weeks lack a key row const keyRows = (weeklyData || []).map(w => (w || []).find(r => Object.values(r).some(v => typeof v === "string" && v.trim().toLowerCase() === "key") ) ); // initial matchup keys (sheet order) let matchupKeys = keys.filter(k => / at /i.test(k)); // If the user selected a different sortMode2, compute stats for the current week and reorder matchupKeys if (typeof sortMode2 !== "undefined" && sortMode2 !== "Game Time Order") { const keyRow = keyRows[weekIdx]; if (keyRow) { // compute percent-correct (based on picks in weekData) for each matchup const matchupStats = matchupKeys.map(mk => { let correctCount = 0; let totalCount = 0; for (const row of weekData) { const n = normalize(row[nameKey]); if (!n || n === "key") continue; // skip blank names and the key row totalCount++; if (matchTeam(row[mk], keyRow[mk])) correctCount++; } return { key: mk, total: totalCount, correct: correctCount, pct: totalCount > 0 ? correctCount / totalCount : 0 }; }); if (sortMode2 === "Picks Correct (Greatest to Least)") { matchupStats.sort((a, b) => b.pct - a.pct || b.correct - a.correct); } else if (sortMode2 === "Picks Correct (Least to Greatest)") { matchupStats.sort((a, b) => a.pct - b.pct || a.correct - b.correct); } matchupKeys = matchupStats.map(d => d.key); } // if no keyRow for the week, keep original order } // build name map & participants const nameMap = new Map(); for (const row of weekData) { const n = normalize(row[nameKey]); if (!n) continue; nameMap.set(n, String(row[nameKey]).trim()); } nameMap.delete("key"); // remove the key row label if present const participants = Array.from(nameMap.keys()).map(n => nameMap.get(n)); // colors and sizes const teamAColor = "rgba(78, 124, 196, 0.75)"; const teamBColor = "rgba(201, 74, 74, 0.75)"; const blankColor = "#ffffff"; const checkColor = "#FBC901"; const cellSize = 18; // helper to fuzzy-match team strings function matchTeam(pick, team) { if (!pick || !team) return false; const p = normalize(pick); const t = normalize(team); return p === t || p.includes(t) || t.includes(p); } // total correct up through a given week (sums each week's matchups individually) function totalCorrectThroughWeek(playerName, throughIdx) { const normName = normalize(playerName); let correct = 0; for (let w = 0; w <= throughIdx; w++) { const week = weeklyData[w]; const keyRow = keyRows[w]; if (!week || !keyRow) continue; const keysForWeek = Object.keys(week[0] || {}).filter(k => / at /i.test(k)); const personRow = [...week].reverse().find(r => normalize(r[nameKey]) === normName); if (!personRow) continue; keysForWeek.forEach(mk => { if (matchTeam(personRow[mk], keyRow[mk])) correct++; }); } return correct; } // correct for just the selected week function totalCorrectThisWeek(playerName, weekIdxLocal) { const normName = normalize(playerName); const week = weeklyData[weekIdxLocal]; const keyRow = keyRows[weekIdxLocal]; if (!week || !keyRow) return 0; const personRow = [...week].reverse().find(r => normalize(r[nameKey]) === normName); if (!personRow) return 0; let correct = 0; matchupKeys.forEach(mk => { if (matchTeam(personRow[mk], keyRow[mk])) correct++; }); return correct; } // build table and colgroup (use final matchupKeys order) const table = html`

`; const colgroup = document.createElement("colgroup"); const nameCol = document.createElement("col"); nameCol.style.width = "180px"; colgroup.appendChild(nameCol); const totalCol = document.createElement("col"); totalCol.style.width = "60px"; colgroup.appendChild(totalCol); const weekCol = document.createElement("col"); weekCol.style.width = "60px"; colgroup.appendChild(weekCol); matchupKeys.forEach(() => { const c = document.createElement("col"); c.style.width = `${Math.max(cellSize + 6, 26)}px`; colgroup.appendChild(c); }); table.appendChild(colgroup); // HEADER const thead = html``; const headRow = html``; headRow.append(html`Participant`); headRow.append(html`Totals`); headRow.append(html`Week ${weekSlider}`); matchupKeys.forEach(k => { const parts = k.split(/\s+at\s+/i); const teamA = (parts[0] || "").trim().split(" ").pop(); const teamB = (parts[1] || "").trim().split(" ").pop(); const th = html``; const rot = html`

${teamA} at ${teamB}

`; th.append(rot); headRow.append(th); }); thead.append(headRow); table.append(thead); // BODY const tbody = html``; const sorted = [...participants].sort((a, b) => { const totalA = totalCorrectThroughWeek(a, weekIdx); const totalB = totalCorrectThroughWeek(b, weekIdx); const weekA = totalCorrectThisWeek(a, weekIdx); const weekB = totalCorrectThisWeek(b, weekIdx); return sortMode === "Total Rankings" ? totalB - totalA || a.localeCompare(b) : weekB - weekA || a.localeCompare(b); }); sorted.forEach(displayName => { const normName = normalize(displayName); const personRow = [...weekData].reverse().find(r => normalize(r[nameKey]) === normName); const tr = html``; tr.append(html`${displayName}`); tr.append(html`${totalCorrectThroughWeek(displayName, weekIdx)}`); tr.append(html`${totalCorrectThisWeek(displayName, weekIdx)}`); matchupKeys.forEach(mk => { const pickRaw = personRow?.[mk]; const keyPick = keyRows[weekIdx]?.[mk]; const parts = mk.split(/\s+at\s+/i); const teamA = (parts[0] || "").trim(); const teamB = (parts[1] || "").trim(); let bg = blankColor; if (matchTeam(pickRaw, teamA)) bg = teamAColor; else if (matchTeam(pickRaw, teamB)) bg = teamBColor; const correct = keyPick && matchTeam(pickRaw, keyPick); const td = html`

${correct ? html`✔` : ""}

`; tr.append(td); }); tbody.append(tr); }); // Results row (uses matchupKeys order) const keyRow = keyRows[weekIdx]; if (keyRow) { const tr = html``; tr.append(html`Results`); tr.append(html``); tr.append(html``); matchupKeys.forEach(mk => { const keyPick = keyRow[mk]; const parts = mk.split(/\s+at\s+/i); const teamA = (parts[0] || "").trim(); const teamB = (parts[1] || "").trim(); let bg = blankColor; if (matchTeam(keyPick, teamA)) bg = teamAColor; else if (matchTeam(keyPick, teamB)) bg = teamBColor; const td = html`

✔

`; tr.append(td); }); tbody.append(tr); } table.append(tbody); const wrapper = html`

`; wrapper.append(table); return wrapper; }