[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_188":189,"_190":191},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",26,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","shared.ts","latestPath","fileId","e2ce1412-873f-11f1-b2a0-1607ee4eb77e","name","fileType","script","content","// shared.ts — parsing and output building for the Hawaii absentee report val.\n// Runs on Val Town (Deno). Pure functions; no Val Town APIs imported here.\n\nimport { extractText, getDocumentProxy } from \"npm:unpdf\";\nimport * as XLSX from \"npm:xlsx\";\n\nexport const PAGE_URL =\n \"https://elections.hawaii.gov/resources/absentee-voting-report/\";\nexport const BASE = \"https://elections.hawaii.gov/wp-content/uploads\";\n\n// key -> [sheet/tab name, filename prefix]\nexport const REPORTS: [string, string, string][] = [\n [\"State\", \"Statewide\", \"AbsenteeReconState\"],\n [\"01\", \"Honolulu\", \"AbsenteeReconDP-01\"],\n [\"02\", \"Hawaii County\", \"AbsenteeReconDP-02\"],\n [\"03\", \"Kauai\", \"AbsenteeReconDP-03\"],\n [\"04\", \"Maui\", \"AbsenteeReconDP-04\"],\n];\n\nexport const HEADERS = [\n \"ELECT Sent (a)\", \"ELECT Voted (b)\", \"ELECT Invalid (c)\",\n \"EV Voted (d)\", \"MAIL Sent (e)\", \"MAIL Voted (f)\", \"MAIL Invalid (g)\",\n \"VOTED (b + d + f)\", \"TOTAL (a + d + e)\",\n];\n\nconst DP_RE = /^\\d{2}\\/\\d{2}$/;\nconst NUM_RE = /^[\\d,]+$/;\nconst COUNTY_RE = /^(Hawai.{0,2}i|Maui|Kaua.{0,2}i|Honolulu)$/;\n\nexport type Row = [string, ...number[]]; // label + 9 integers\n\nexport async function pdfToTokens(bytes: Uint8Array): Promise {\n const doc = await getDocumentProxy(bytes);\n const { text } = await extractText(doc, { mergePages: true });\n return text.split(/\\s+/).filter((t) => t.length > 0);\n}\n\nexport function parseTokens(tokens: string[]): Row[] {\n const rows: Row[] = [];\n let i = 0;\n while (i < tokens.length) {\n const t = tokens[i];\n if (DP_RE.test(t) || COUNTY_RE.test(t)) {\n const vals: number[] = [];\n let j = i + 1;\n while (j < tokens.length && vals.length < 9) {\n const v = tokens[j];\n if (NUM_RE.test(v)) {\n vals.push(parseInt(v.replace(/,/g, \"\"), 10));\n j++;\n } else break;\n }\n if (vals.length === 9) {\n rows.push([t, ...vals] as Row);\n i = j;\n continue;\n }\n }\n i++;\n }\n if (rows.length === 0) throw new Error(\"Parsed zero data rows from PDF\");\n for (const r of rows) {\n const [label, a, b, , d, e, f, , voted, total] = r as [\n string, number, number, number, number, number, number, number, number, number,\n ];\n if (voted !== b + d + f || total !== a + d + e) {\n throw new Error(`Row ${label} failed arithmetic check: ${r.join(\",\")}`);\n }\n }\n return rows;\n}\n\nexport type Sheets = { name: string; labelHdr: string; rows: Row[] }[];\n\nexport function buildXlsx(sheets: Sheets, dateStr: string): Uint8Array {\n const wb = XLSX.utils.book_new();\n for (const { name, labelHdr, rows } of sheets) {\n const aoa: (string | number | null)[][] = [];\n aoa.push([null, \"ELECTRONIC (Email & Fax Combined)\", null, null,\n \"EARLY VOTING\", \"MAIL (SAB & PAB Combined)\", null, null, null, null]);\n aoa.push([labelHdr, ...HEADERS]);\n for (const r of rows) aoa.push([...r]);\n const ws = XLSX.utils.aoa_to_sheet(aoa);\n\n const start = 3; // first data row (1-indexed)\n rows.forEach((_, idx) => {\n const rn = start + idx;\n ws[`I${rn}`] = { t: \"n\", f: `C${rn}+E${rn}+G${rn}` }; // VOTED\n ws[`J${rn}`] = { t: \"n\", f: `B${rn}+E${rn}+F${rn}` }; // TOTAL\n });\n const tr = start + rows.length;\n ws[`A${tr}`] = { t: \"s\", v: \"TOTAL\" };\n for (let c = 0; c < 9; c++) {\n const col = String.fromCharCode(66 + c); // B..J\n ws[`${col}${tr}`] = { t: \"n\", f: `SUM(${col}${start}:${col}${tr - 1})` };\n }\n const note = tr + 2;\n ws[`A${note}`] = {\n t: \"s\",\n v: `Report date ${fmtDate(dateStr)} — Source: Hawaii Office of ` +\n `Elections voting report (${PAGE_URL})`,\n };\n ws[\"!ref\"] = `A1:J${note}`;\n ws[\"!merges\"] = [\n { s: { r: 0, c: 1 }, e: { r: 0, c: 3 } },\n { s: { r: 0, c: 5 }, e: { r: 0, c: 7 } },\n ];\n ws[\"!cols\"] = [{ wch: 14 }, ...Array(9).fill({ wch: 13 })];\n XLSX.utils.book_append_sheet(wb, ws, name);\n }\n return new Uint8Array(\n XLSX.write(wb, { type: \"array\", bookType: \"xlsx\" }) as ArrayBuffer,\n );\n}\n\nexport function fmtDate(d: string): string {\n return `${d.slice(0, 4)}-${d.slice(4, 6)}-${d.slice(6)}`;\n}\n\n// date \"YYYYMMDD\" -> D/P \"dd/pp\" -> [voted, total]\nexport type DpHist = Record>;\n\nexport function fmtHst(iso: string): string {\n // HST is UTC-10 year-round (no DST).\n const t = new Date(new Date(iso).getTime() - 10 * 3600 * 1000);\n return t.toISOString().slice(0, 19).replace(\"T\", \" \") + \" HST\";\n}\n\nfunction pctOf(voted: number, total: number): string {\n return total ? (voted / total * 100).toFixed(1) + \"%\" : \"—\";\n}\n\n// 2026 Primary Election day (second Saturday of August, HRS §12-2).\nexport const ELECTION_DS = \"20260808\";\n\nfunction dayNum(ds: string): number {\n return Date.UTC(+ds.slice(0, 4), +ds.slice(4, 6) - 1, +ds.slice(6)) / 86400000;\n}\n\n// Best-fit projection of final voted count for one D/P: ordinary least squares\n// over the last 5 report days, evaluated at election day, clamped to\n// [current voted, ballots sent]. Falls back to the current count when there is\n// too little data or no upward trend.\nexport function estimateFinal(\n dp: string,\n current: number,\n totalSent: number,\n history: DpHist,\n): number {\n const pts: [number, number][] = [];\n for (const ds of Object.keys(history).sort()) {\n const e = history[ds][dp];\n if (e) pts.push([dayNum(ds), e[0]]);\n }\n const recent = pts.slice(-5);\n if (recent.length < 2 || totalSent <= 0) return current;\n const n = recent.length;\n let sx = 0, sy = 0, sxx = 0, sxy = 0;\n for (const [x, y] of recent) {\n sx += x; sy += y; sxx += x * x; sxy += x * y;\n }\n const denom = n * sxx - sx * sx;\n if (denom === 0) return current;\n const slope = (n * sxy - sx * sy) / denom;\n const intercept = (sy - slope * sx) / n;\n const est = Math.round(intercept + slope * dayNum(ELECTION_DS));\n return Math.min(totalSent, Math.max(current, est));\n}\n\nexport function buildHtml(\n sheets: Sheets,\n dateStr: string,\n fetchedIso: string,\n history: DpHist,\n): string {\n const nice = fmtDate(dateStr);\n const combined: { dp: string; county: string; nums: number[] }[] = [];\n for (const { name, labelHdr, rows } of sheets) {\n if (labelHdr !== \"D/P\") continue;\n for (const r of rows) {\n combined.push({ dp: r[0], county: name, nums: r.slice(1) as number[] });\n }\n }\n combined.sort((x, y) => {\n const [xd, xp] = x.dp.split(\"/\").map(Number);\n const [yd, yp] = y.dp.split(\"/\").map(Number);\n return xd - yd || xp - yp;\n });\n\n const parts: string[] = [`\n\n\nTurned Out — ${nice}\n\n

Turned Out

Hawaii Voting Report

Report date ${nice} ·\n Data fetched ${fmtHst(fetchedIso)} ·\n Download spreadsheet (.xlsx) ·\n Source: Hawaii Office of Elections.\n Unofficial data, subject to change.\n Click any row to see voting growth over time for that D/P.\n Est. columns: straight-line best fit of each precinct's last 5 reports,\n projected to election day (Aug 8) and capped at ballots sent.

`];\n\n parts.push(\n `` +\n HEADERS.map((h) => ``).join(\"\") +\n `` +\n ``,\n );\n const totals = new Array(9).fill(0);\n let estTotal = 0;\n for (const { dp, county, nums } of combined) {\n nums.forEach((v, i) => totals[i] += v);\n const est = estimateFinal(dp, nums[7], nums[8], history);\n estTotal += est;\n parts.push(\n `` +\n nums.map((v) => ``).join(\"\") +\n `` +\n `` +\n ``,\n );\n }\n parts.push(\n `` +\n totals.map((v) => ``).join(\"\") +\n `` +\n `` +\n `

D/P	County	${h}	% Cast	Est. Voted (Aug 8)	Est. % Cast
${dp}	${county}	${v.toLocaleString(\"en-US\")}	${pctOf(nums[7], nums[8])}	${est.toLocaleString(\"en-US\")}	${pctOf(est, nums[8])}
TOTAL	Statewide	${v.toLocaleString(\"en-US\")}	${pctOf(totals[7], totals[8])}	${estTotal.toLocaleString(\"en-US\")}	${pctOf(estTotal, totals[8])}

`,\n );\n\n parts.push(\n ``,\n );\n // Client script: no backticks or dollar-brace inside, so it can live in this\n // template literal untouched.\n parts.push(``);\n parts.push(\"\");\n return parts.join(\"\\n\");\n}\n","// shared.ts — parsing and output building for the Hawaii absentee report val.\n// Runs on Val Town (Deno). Pure functions; no Val Town APIs imported here.\n\nimport { extractText, getDocumentProxy } from \"npm:unpdf\";\nimport * as XLSX from \"npm:xlsx\";\n\nexport const PAGE_URL =\n \"https://elections.hawaii.gov/resources/absentee-voting-report/\";\nexport const BASE = \"https://elections.hawaii.gov/wp-content/uploads\";\n\n// key -> [sheet/tab name, filename prefix]\nexport const REPORTS: [string, string, string][] = [\n [\"State\", \"Statewide\", \"AbsenteeReconState\"],\n [\"01\", \"Honolulu\", \"AbsenteeReconDP-01\"],\n [\"02\", \"Hawaii County\", \"AbsenteeReconDP-02\"],\n [\"03\", \"Kauai\", \"AbsenteeReconDP-03\"],\n [\"04\", \"Maui\", \"AbsenteeReconDP-04\"],\n];\n\nexport const HEADERS = [\n \"ELECT Sent (a)\", \"ELECT Voted (b)\", \"ELECT Invalid (c)\",\n \"EV Voted (d)\", \"MAIL Sent (e)\", \"MAIL Voted (f)\", \"MAIL Invalid (g)\",\n \"VOTED (b + d + f)\", \"TOTAL (a + d + e)\",\n];\n\nconst DP_RE = /^\\d{2}\\/\\d{2}$/;\nconst NUM_RE = /^[\\d,]+$/;\nconst COUNTY_RE = /^(Hawai.{0,2}i|Maui|Kaua.{0,2}i|Honolulu)$/;\n\nexport type Row = [string, ...number[]]; // label + 9 integers\n\nexport async function pdfToTokens(bytes: Uint8Array): Promise {\n const doc = await getDocumentProxy(bytes);\n const { text } = await extractText(doc, { mergePages: true });\n return text.split(/\\s+/).filter((t) => t.length > 0);\n}\n\nexport function parseTokens(tokens: string[]): Row[] {\n const rows: Row[] = [];\n let i = 0;\n while (i < tokens.length) {\n const t = tokens[i];\n if (DP_RE.test(t) || COUNTY_RE.test(t)) {\n const vals: number[] = [];\n let j = i + 1;\n while (j < tokens.length && vals.length < 9) {\n const v = tokens[j];\n if (NUM_RE.test(v)) {\n vals.push(parseInt(v.replace(/,/g, \"\"), 10));\n j++;\n } else break;\n }\n if (vals.length === 9) {\n rows.push([t, ...vals] as Row);\n i = j;\n continue;\n }\n }\n i++;\n }\n if (rows.length === 0) throw new Error(\"Parsed zero data rows from PDF\");\n for (const r of rows) {\n const [label, a, b, , d, e, f, , voted, total] = r as [\n string, number, number, number, number, number, number, number, number, number,\n ];\n if (voted !== b + d + f || total !== a + d + e) {\n throw new Error(`Row ${label} failed arithmetic check: ${r.join(\",\")}`);\n }\n }\n return rows;\n}\n\nexport type Sheets = { name: string; labelHdr: string; rows: Row[] }[];\n\nexport function buildXlsx(sheets: Sheets, dateStr: string): Uint8Array {\n const wb = XLSX.utils.book_new();\n for (const { name, labelHdr, rows } of sheets) {\n const aoa: (string | number | null)[][] = [];\n aoa.push([null, \"ELECTRONIC (Email & Fax Combined)\", null, null,\n \"EARLY VOTING\", \"MAIL (SAB & PAB Combined)\", null, null, null, null]);\n aoa.push([labelHdr, ...HEADERS]);\n for (const r of rows) aoa.push([...r]);\n const ws = XLSX.utils.aoa_to_sheet(aoa);\n\n const start = 3; // first data row (1-indexed)\n rows.forEach((_, idx) => {\n const rn = start + idx;\n ws[`I${rn}`] = { t: \"n\", f: `C${rn}+E${rn}+G${rn}` }; // VOTED\n ws[`J${rn}`] = { t: \"n\", f: `B${rn}+E${rn}+F${rn}` }; // TOTAL\n });\n const tr = start + rows.length;\n ws[`A${tr}`] = { t: \"s\", v: \"TOTAL\" };\n for (let c = 0; c < 9; c++) {\n const col = String.fromCharCode(66 + c); // B..J\n ws[`${col}${tr}`] = { t: \"n\", f: `SUM(${col}${start}:${col}${tr - 1})` };\n }\n const note = tr + 2;\n ws[`A${note}`] = {\n t: \"s\",\n v: `Report date ${fmtDate(dateStr)} — Source: Hawaii Office of ` +\n `Elections voting report (${PAGE_URL})`,\n };\n ws[\"!ref\"] = `A1:J${note}`;\n ws[\"!merges\"] = [\n { s: { r: 0, c: 1 }, e: { r: 0, c: 3 } },\n { s: { r: 0, c: 5 }, e: { r: 0, c: 7 } },\n ];\n ws[\"!cols\"] = [{ wch: 14 }, ...Array(9).fill({ wch: 13 })];\n XLSX.utils.book_append_sheet(wb, ws, name);\n }\n return new Uint8Array(\n XLSX.write(wb, { type: \"array\", bookType: \"xlsx\" }) as ArrayBuffer,\n );\n}\n\nexport function fmtDate(d: string): string {\n return `${d.slice(0, 4)}-${d.slice(4, 6)}-${d.slice(6)}`;\n}\n\n// date \"YYYYMMDD\" -> D/P \"dd/pp\" -> [voted, total]\nexport type DpHist = Record>;\n\nexport function fmtHst(iso: string): string {\n // HST is UTC-10 year-round (no DST).\n const t = new Date(new Date(iso).getTime() - 10 * 3600 * 1000);\n return t.toISOString().slice(0, 19).replace(\"T\", \" \") + \" HST\";\n}\n\nfunction pctOf(voted: number, total: number): string {\n return total ? (voted / total * 100).toFixed(1) + \"%\" : \"—\";\n}\n\n// 2026 Primary Election day (second Saturday of August, HRS §12-2).\nexport const ELECTION_DS = \"20260808\";\n\nfunction dayNum(ds: string): number {\n return Date.UTC(+ds.slice(0, 4), +ds.slice(4, 6) - 1, +ds.slice(6)) / 86400000;\n}\n\n// Best-fit projection of final voted count for one D/P: ordinary least squares\n// over the last 5 report days, evaluated at election day, clamped to\n// [current voted, ballots sent]. Falls back to the current count when there is\n// too little data or no upward trend.\nexport function estimateFinal(\n dp: string,\n current: number,\n totalSent: number,\n history: DpHist,\n): number {\n const pts: [number, number][] = [];\n for (const ds of Object.keys(history).sort()) {\n const e = history[ds][dp];\n if (e) pts.push([dayNum(ds), e[0]]);\n }\n const recent = pts.slice(-5);\n if (recent.length < 2 || totalSent <= 0) return current;\n const n = recent.length;\n let sx = 0, sy = 0, sxx = 0, sxy = 0;\n for (const [x, y] of recent) {\n sx += x; sy += y; sxx += x * x; sxy += x * y;\n }\n const denom = n * sxx - sx * sx;\n if (denom === 0) return current;\n const slope = (n * sxy - sx * sy) / denom;\n const intercept = (sy - slope * sx) / n;\n const est = Math.round(intercept + slope * dayNum(ELECTION_DS));\n return Math.min(totalSent, Math.max(current, est));\n}\n\n// Result of cross-checking our sums against the OOE web page's summary table.\nexport type WebAudit = {\n when: string; // ISO time of the check\n ok: boolean;\n error?: string;\n diffs: { county: string; column: string; web: number; pdf: number }[];\n};\n\nconst WEB_COUNTY_RE = /(Hawai\\W{0,2}i|Maui|Kaua\\W{0,2}i|Honolulu)((?:\\s+[\\d,]+){9})/g;\n\nfunction alpha(s: string): string {\n return s.replace(/[^A-Za-z]/g, \"\");\n}\n\n// Compare the statewide sheet (from the PDFs) against the county summary table\n// rendered on the OOE web page. Pure: takes the page HTML as a string.\nexport function auditWebSums(pageHtml: string, sheets: Sheets, when: string): WebAudit {\n const text = pageHtml\n .replace(/|/g, \" \")\n .replace(/<[^>]+>/g, \" \")\n .replace(/&#\\d+;|&[a-z]+;/gi, \" \")\n .replace(/\\s+/g, \" \");\n const web: Record = {};\n let lastEnd = -1;\n for (const m of text.matchAll(WEB_COUNTY_RE)) {\n const key = alpha(m[1]);\n if (!(key in web)) {\n web[key] = m[2].trim().split(/\\s+/).map((x) => +x.replace(/,/g, \"\"));\n lastEnd = m.index! + m[0].length;\n }\n }\n if (Object.keys(web).length < 4) {\n return { when, ok: false, error: \"could not parse OOE web table\", diffs: [] };\n }\n // The grand-total row follows the last county row, unlabeled.\n const totalMatch = text.slice(lastEnd).match(/^((?:\\s+[\\d,]+){9})/);\n const webTotal = totalMatch\n ? totalMatch[1].trim().split(/\\s+/).map((x) => +x.replace(/,/g, \"\"))\n : null;\n\n const state = sheets.find((s) => s.labelHdr === \"County\");\n const diffs: WebAudit[\"diffs\"] = [];\n const pdfTotals = new Array(9).fill(0);\n for (const r of state?.rows ?? []) {\n const nums = r.slice(1) as number[];\n nums.forEach((v, i) => pdfTotals[i] += v);\n const w = web[alpha(r[0])];\n if (!w) {\n return { when, ok: false, error: `county ${r[0]} missing from web table`, diffs: [] };\n }\n nums.forEach((v, i) => {\n if (w[i] !== v) diffs.push({ county: r[0], column: HEADERS[i], web: w[i], pdf: v });\n });\n }\n if (webTotal) {\n pdfTotals.forEach((v, i) => {\n if (webTotal[i] !== v) {\n diffs.push({ county: \"Statewide\", column: HEADERS[i], web: webTotal[i], pdf: v });\n }\n });\n } else {\n return { when, ok: false, error: \"could not parse web grand-total row\", diffs };\n }\n return { when, ok: diffs.length === 0, diffs };\n}\n\nexport function buildHtml(\n sheets: Sheets,\n dateStr: string,\n fetchedIso: string,\n history: DpHist,\n audit?: WebAudit,\n): string {\n const nice = fmtDate(dateStr);\n const combined: { dp: string; county: string; nums: number[] }[] = [];\n for (const { name, labelHdr, rows } of sheets) {\n if (labelHdr !== \"D/P\") continue;\n for (const r of rows) {\n combined.push({ dp: r[0], county: name, nums: r.slice(1) as number[] });\n }\n }\n combined.sort((x, y) => {\n const [xd, xp] = x.dp.split(\"/\").map(Number);\n const [yd, yp] = y.dp.split(\"/\").map(Number);\n return xd - yd || xp - yp;\n });\n\n const parts: string[] = [`\n\n\nTurned Out — ${nice}\n\n

Turned Out

Hawaii Voting Report

`];\n\n if (audit) {\n let line: string;\n if (audit.error) {\n line = `⚠ OOE web cross-check unavailable: ${audit.error}`;\n } else if (audit.ok) {\n line = `✓ Cross-checked against the ` +\n `OOE web summary at ${fmtHst(audit.when)}: ` +\n `all county and statewide sums match.`;\n } else {\n line = `⚠ Cross-check vs the OOE web summary ` +\n `at ${fmtHst(audit.when)}: ${audit.diffs.length} value(s) differ ` +\n `(see table at bottom; the web page refreshes during the day while ` +\n `PDFs are a morning snapshot, so small “Sent” drift is normal).`;\n }\n parts.push(`

${line}

`);\n }\n\n parts.push(\n `` +\n HEADERS.map((h) => ``).join(\"\") +\n `` +\n ``,\n );\n const totals = new Array(9).fill(0);\n let estTotal = 0;\n for (const { dp, county, nums } of combined) {\n nums.forEach((v, i) => totals[i] += v);\n const est = estimateFinal(dp, nums[7], nums[8], history);\n estTotal += est;\n parts.push(\n `` +\n nums.map((v) => ``).join(\"\") +\n `` +\n `` +\n ``,\n );\n }\n parts.push(\n `` +\n totals.map((v) => ``).join(\"\") +\n `` +\n `` +\n `

D/P	County	${h}	% Cast	Est. Voted (Aug 8)	Est. % Cast
${dp}	${county}	${v.toLocaleString(\"en-US\")}	${pctOf(nums[7], nums[8])}	${est.toLocaleString(\"en-US\")}	${pctOf(est, nums[8])}
TOTAL	Statewide	${v.toLocaleString(\"en-US\")}	${pctOf(totals[7], totals[8])}	${estTotal.toLocaleString(\"en-US\")}	${pctOf(estTotal, totals[8])}

`,\n );\n\n if (audit && audit.diffs.length > 0) {\n parts.push(\n `

OOE web cross-check differences

` +\n `

This report is built from the official daily PDFs. The OOE web ` +\n `page's summary table refreshes during the day, so its “Sent” counts ` +\n `can run slightly ahead of the morning PDF snapshot.

` +\n `` +\n `` +\n audit.diffs.map((d) =>\n `` +\n `` +\n `` +\n ``\n ).join(\"\") + `

County	Column	OOE web	This report (PDF)	Diff
${d.county}	${d.column}	${d.web.toLocaleString(\"en-US\")}	${d.pdf.toLocaleString(\"en-US\")}	${(d.web - d.pdf >= 0 ? \"+\" : \"\") + (d.web - d.pdf).toLocaleString(\"en-US\")}

`,\n );\n }\n\n parts.push(\n ``,\n );\n // Client script: no backticks or dollar-brace inside, so it can live in this\n // template literal untouched.\n parts.push(``);\n parts.push(\"\");\n return parts.join(\"\\n\");\n}\n","createdAt",["D",1785396571152],"branchVersion","branchId","0779b895-078a-4517-8c5a-557678c2cd34","id","2fd58d17-59dd-4374-9159-cbb0f4c91ad6","turned-out",["D",1784884388277],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","How's the voting turnout going?","imageUrl","4e256467-64f1-4b1d-b7df-84b16185908d","pinnedFileId","0fdbc2fa-879b-11f1-8df9-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f935e-8196-7389-8ecc-21e539474e29","tursoName","2fd58d1759dd43749159cbb0f4c91ad6","tursoHostname","2fd58d1759dd43749159cbb0f4c91ad6-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789473046147],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",35,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","ikaikahussey","handle","displayName","Ikaika Hussey","avatar","https://avatars.githubusercontent.com/u/1045870?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":183,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":184,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":185,"_84":186,"_86":187,"_88":25},"tree",[170,171,172],"files",[170,171,172],"counts",{"_159":63,"_160":161,"_162":63,"_163":164,"_165":166},"contents",[131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":150,"_32":151,"_30":152,"_135":-5,"_41":42,"_40":153,"_136":59,"_38":154,"_13":155,"_33":156,"_35":157,"_24":25,"_139":-5,"_27":158},{"_43":141,"_32":142,"_30":57,"_135":-5,"_41":42,"_40":143,"_136":59,"_38":144,"_13":145,"_33":146,"_35":147,"_24":25,"_139":148,"_27":149},{"_43":134,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_136":25,"_38":137,"_13":138,"_33":34,"_35":37,"_24":25,"_139":-5,"_27":140},"6f6218db-8501-45eb-9272-63ee29b21233","parentId","latest",["D",1785396571152],7,"label",[28],"e4f904a3-41c3-4929-8bed-db2dafedb9f5","http.ts",15,["D",1784923973607],4,"http","// http.ts — Val Town HTTP trigger. Serves the report page and the .xlsx.\n// URL: https://-.val.run/\n\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\"; // scoped to this val\n\n// std/blob's get() throws ValTownBlobNotFoundError on missing keys.\nasync function tryGet(key: string) {\n try {\n return await blob.get(key);\n } catch {\n return null;\n }\n}\n\nexport default async function (req: Request): Promise {\n const path = new URL(req.url).pathname;\n\n if (path === \"/AbsenteeVoting.xlsx\") {\n const b = await tryGet(\"xlsx\");\n if (!b) return new Response(\"Not built yet\", { status: 404 });\n return new Response(await b.arrayBuffer(), {\n headers: {\n \"content-type\":\n \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\n \"content-disposition\": 'attachment; filename=\"AbsenteeVoting.xlsx\"',\n \"cache-control\": \"public, max-age=300\",\n },\n });\n }\n\n const b = await tryGet(\"html\");\n if (!b) {\n return new Response(\n \"Report not built yet. Run the cron val once, then reload.\",\n { status: 503, headers: { \"content-type\": \"text/plain\" } },\n );\n }\n return new Response(await b.text(), {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"public, max-age=300\",\n },\n });\n}","turnedout",[142],"cdc2bd3c-1e72-4b33-bad9-9818687f4b4d","cron.ts","c5c538a4-879a-11f1-95c9-1607ee4eb77e",25,["D",1785396504216],5,"interval","// cron.ts — Val Town CRON trigger. Schedule: 0 14-20 * * 1-5 (hourly 4–10 AM HST weekdays).\n// Fetches the newest report set, parses + verifies, stores outputs in blob storage.\n// Keeps a per-day history of votes per D/P for the growth view.\n\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\"; // scoped to this val\nimport {\n auditWebSums, BASE, buildHtml, buildXlsx, DpHist, PAGE_URL, parseTokens,\n pdfToTokens, REPORTS, Sheets, WebAudit,\n} from \"./shared.ts\";\n\nconst BACKFILL_DAYS = 13;\n\nasync function discoverLatest(): Promise {\n // PDFs generate ~3:11 AM HST at predictable URLs; the page's links lag.\n // Probe today (HST) back through 7 days, then fall back to the page.\n const hstNow = new Date(Date.now() - 10 * 3600 * 1000);\n for (let back = 0; back < 8; back++) {\n const d = new Date(hstNow.getTime() - back * 86400 * 1000);\n const ds = d.toISOString().slice(0, 10).replaceAll(\"-\", \"\");\n const r = await fetch(`${BASE}/AbsenteeReconState-${ds}.pdf`);\n if (r.ok) {\n const head = new Uint8Array((await r.arrayBuffer()).slice(0, 5));\n if (new TextDecoder().decode(head) === \"%PDF-\") return ds;\n }\n }\n const html = await (await fetch(PAGE_URL)).text();\n const dates = [...html.matchAll(/AbsenteeReconState-(\\d{8})\\.pdf/g)]\n .map((m) => m[1]);\n if (dates.length === 0) {\n throw new Error(\"No report found by URL probe or page scrape\");\n }\n return dates.sort().at(-1)!;\n}\n\n// D/P -> [voted, total] from the four county sheets.\nfunction dpMap(sheets: Sheets): Record {\n const m: Record = {};\n for (const { labelHdr, rows } of sheets) {\n if (labelHdr !== \"D/P\") continue;\n for (const r of rows) m[r[0]] = [r[8] as number, r[9] as number];\n }\n return m;\n}\n\n// Fetch + parse the four county PDFs for one past date; null if any is missing\n// (weekends/holidays have no report).\nasync function fetchDay(ds: string): Promise | null> {\n const m: Record = {};\n for (const [key, , prefix] of REPORTS) {\n if (key === \"State\") continue;\n const resp = await fetch(`${BASE}/${prefix}-${ds}.pdf`);\n if (!resp.ok) return null;\n const buf = new Uint8Array(await resp.arrayBuffer());\n if (new TextDecoder().decode(buf.slice(0, 5)) !== \"%PDF-\") return null;\n for (const r of parseTokens(await pdfToTokens(buf))) {\n m[r[0]] = [r[8] as number, r[9] as number];\n }\n }\n return m;\n}\n\nexport default async function () {\n const latest = await discoverLatest();\n const have = (await blob.getJSON(\"meta\") as { report_date?: string } | undefined)\n ?.report_date ?? \"\";\n const history = (await blob.getJSON(\"history\") as DpHist | undefined) ?? {};\n if (have >= latest && history[latest]) {\n console.log(`Already have report ${have}; nothing to do.`);\n return;\n }\n\n const sheets: Sheets = [];\n for (const [key, name, prefix] of REPORTS) {\n const resp = await fetch(`${BASE}/${prefix}-${latest}.pdf`);\n if (!resp.ok) throw new Error(`Fetch failed for ${prefix}-${latest}.pdf`);\n const rows = parseTokens(await pdfToTokens(new Uint8Array(await resp.arrayBuffer())));\n sheets.push({ name, labelHdr: key === \"State\" ? \"County\" : \"D/P\", rows });\n console.log(`${name}: ${rows.length} rows`);\n }\n\n history[latest] = dpMap(sheets);\n // Backfill recent missing days (reports stay up at their dated URLs).\n const base = Date.UTC(\n +latest.slice(0, 4), +latest.slice(4, 6) - 1, +latest.slice(6),\n );\n for (let back = 1; back <= BACKFILL_DAYS; back++) {\n const ds = new Date(base - back * 86400 * 1000)\n .toISOString().slice(0, 10).replaceAll(\"-\", \"\");\n if (history[ds]) continue;\n try {\n const m = await fetchDay(ds);\n if (m) {\n history[ds] = m;\n console.log(`Backfilled ${ds}`);\n }\n } catch (e) {\n console.log(`Backfill ${ds} skipped: ${e}`);\n }\n }\n\n // Cross-check our sums against the OOE web page's summary table. Never\n // aborts the run — the result is published on the page instead.\n let audit: WebAudit;\n try {\n const pageHtml = await (await fetch(PAGE_URL)).text();\n audit = auditWebSums(pageHtml, sheets, new Date().toISOString());\n } catch (e) {\n audit = { when: new Date().toISOString(), ok: false, error: String(e), diffs: [] };\n }\n console.log(\n audit.error\n ? `Web cross-check unavailable: ${audit.error}`\n : audit.ok\n ? \"Web cross-check: all sums match the OOE web table.\"\n : `Web cross-check: ${audit.diffs.length} difference(s) vs OOE web table.`,\n );\n\n // All parsed and verified — only now touch storage.\n await blob.setJSON(\"history\", history);\n await blob.set(\"xlsx\", buildXlsx(sheets, latest));\n await blob.set(\"html\", buildHtml(sheets, latest, new Date().toISOString(), history, audit));\n await blob.setJSON(\"meta\", { report_date: latest, updated: new Date().toISOString() });\n console.log(`Stored report ${latest} (${Object.keys(history).length} days of history).`);\n}\n",[151],"pulls","branches",1,"forks","envVars",{"_167":63,"_169":63},"connections",{"_167":63,"_168":63},"count","unfilledCount","emptyCount",{"_43":150,"_32":151,"_30":152,"_135":-5,"_41":42,"_40":153,"_136":59,"_38":180,"_13":155,"_33":156,"_35":157,"_24":25,"_139":-5,"_174":181,"_27":182},{"_43":141,"_32":142,"_30":57,"_135":-5,"_41":42,"_40":143,"_136":59,"_38":177,"_13":145,"_33":146,"_35":147,"_24":25,"_139":148,"_174":178,"_27":179},{"_43":134,"_32":28,"_30":31,"_135":-5,"_41":42,"_40":14,"_136":25,"_38":173,"_13":138,"_33":34,"_35":37,"_24":25,"_139":-5,"_174":175,"_27":176},["D",1785396571152],"children",[],[28],["D",1784923973607],[],[142],["D",1785396504216],[],[151],["D",1784884388277],["D",1789473046147],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_128":221,"_222":223,"_224":225,"_226":25,"_227":25,"_228":25,"_229":59,"_230":-5,"_231":-7,"_232":-7,"_233":63,"_234":25,"_235":25,"_236":-5,"_237":25,"_238":25,"_239":25,"_240":-5},"ENV",{"_192":193,"_194":195,"_196":90,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212,"_213":214,"_215":216,"_217":218,"_219":220},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v26