[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_106":107,"_108":109},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","kfieseler","name","ndx-parts-dev","path","_fuelaudit.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":58,"_59":32,"_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":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/kfieseler/ndx-parts-dev/code/_fuelaudit.ts","extension","id","e7d6d6fa-11dd-46c5-9206-89ac6701b04b","fileId","7cd0b3c6-a03b-11f1-b1e9-1607ee4eb77e","parentId","branchId","1ba53fed-b2e4-413d-8a29-62afbe01b059","branchVersion",2420,"latest",true,"createdAt",["D",1787631331721],"version",1,"fileType","script","content","// PRIVATE AUDIT — this chat only, never the app UI, no names, no accusations.\n// (Kaden 8/24: 407/2 read 3% on a machine that had just worked a full shift.)\n//\n// The question: over the last 30 days, how much fuel did each machine RECEIVE\n// on the record, against how much its own burn model says it BURNED?\n//\n// Both sides come from data we already hold or already pull daily:\n// burned = rate_gph x (engine hours between two 5 AM asset snapshots)\n// given = gallons on Tenna fuel entries in the same window\n//\n// A machine that ran and did not quit must have received roughly what it\n// burned. A large negative gap is fuel that went in and was not recorded.\n// READ ONLY. Nothing is written anywhere.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { rows } from \"./core.ts\";\nimport { baseUnit, loadBurn, pullFuelEntries } from \"./fuel_burn.ts\";\n\nconst START = \"2026-07-26\";\nconst END = \"2026-08-24\";\n\nconst burn = await loadBurn();\n\n// engine hours run in the window, from the daily 5 AM snapshots\nconst hrs: Record = {};\nfor (\n const r of rows(await sqlite.execute({\n sql: `SELECT unit, date, hours FROM fl_asset_snap\n WHERE hours IS NOT NULL AND date >= ? AND date <= ? ORDER BY date`,\n args: [START, END],\n }))\n) {\n const u = baseUnit(r.unit), h = Number(r.hours), d = String(r.date);\n if (!hrs[u]) hrs[u] = { h0: h, h1: h, d0: d, d1: d };\n else { hrs[u].h1 = h; hrs[u].d1 = d; }\n}\n\n// gallons recorded against each machine in the window\nconst entries = await pullFuelEntries(START + \"T00:00:00.000Z\");\nconst given: Record = {};\nfor (const e of entries) {\n const ts = Date.parse(String(e.pumped_at_time ?? \"\"));\n if (!isFinite(ts)) continue;\n const d = new Date(ts - 7 * 3600 * 1000).toISOString().slice(0, 10);\n if (d < START || d > END) continue;\n const u = baseUnit(e.asset_fleet);\n const g = Number(e.gallons);\n if (!u || !(g > 0)) continue;\n const x = given[u] ??= { gal: 0, n: 0, sizes: [] };\n x.gal += g;\n x.n++;\n x.sizes.push(Math.round(g));\n}\nconsole.log(\"fuel entries pulled: \" + entries.length + \" | window \" + START + \" .. \" + END);\nconsole.log(\"\");\n\ntype Row = { u: string; name: string; ran: number; burned: number; given: number; gap: number; cap: number; n: number; biggest: number };\nconst out: Row[] = [];\nfor (const u of Object.keys(hrs)) {\n const b = burn[u];\n if (!b || b.rate_gph == null || b.cap == null) continue;\n const ran = Math.round((hrs[u].h1 - hrs[u].h0) * 10) / 10;\n if (ran < 5) continue; // barely moved — nothing to conclude\n const burned = Math.round(b.rate_gph * ran);\n const gv = given[u] ? Math.round(given[u].gal) : 0;\n out.push({\n u, name: String(b.name ?? \"\").trim().slice(0, 26), ran, burned, given: gv,\n gap: gv - burned, cap: b.cap, n: given[u] ? given[u].n : 0,\n biggest: given[u] && given[u].sizes.length ? Math.max(...given[u].sizes) : 0,\n });\n}\nout.sort((a, b2) => (a.gap / Math.max(1, a.burned)) - (b2.gap / Math.max(1, b2.burned)));\n\nconsole.log(\"unit ran(h) burned given gap fills biggest tank name\");\nfor (const r of out) {\n const pct = Math.round((r.gap / Math.max(1, r.burned)) * 100);\n console.log(\n r.u.padEnd(6),\n String(r.ran).padStart(6),\n String(r.burned).padStart(7),\n String(r.given).padStart(6),\n String((r.gap > 0 ? \"+\" : \"\") + r.gap).padStart(6),\n String(pct + \"%\").padStart(6),\n String(r.n).padStart(4),\n String(r.biggest).padStart(7),\n String(r.cap).padStart(6),\n \" \" + r.name,\n );\n}\n\nconst short = out.filter((r) => r.gap < -0.25 * r.burned);\nconst ok = out.filter((r) => Math.abs(r.gap) <= 0.25 * r.burned);\nconst over = out.filter((r) => r.gap > 0.25 * r.burned);\nconsole.log(\"\");\nconsole.log(\"machines audited : \" + out.length);\nconsole.log(\"records add up (±25%) : \" + ok.length);\nconsole.log(\"SHORT by >25% : \" + short.length + \" (fuel went in that was not recorded, or the rate is too high)\");\nconsole.log(\"OVER by >25% : \" + over.length + \" (more recorded than the model thinks it burned)\");\nconsole.log(\"\");\nconsole.log(\"fleet totals: burned \" + out.reduce((a, r) => a + r.burned, 0) +\n \" gal modeled, \" + out.reduce((a, r) => a + r.given, 0) + \" gal recorded\");\n\n// ---- HOW LONG SINCE THE MODEL LAST SAW A TANK ACTUALLY FULL? --------------\n// The level walk can only climb back to full when one fill saturates the tank.\n// If a machine has since run more hours than a full tank could ever cover, the\n// level we are carrying is fiction and the percentage should not be shown.\n// This measures how many machines are in that state, to size the threshold\n// before any of it ships.\nconsole.log(\"\");\nconsole.log(\"unit tankfuls-run-since-last-full modeled level now name\");\nconst { pullFuelEntries: _pf } = await import(\"./fuel_burn.ts\");\nconst allFills = await _pf();\nconst byU: Record = {};\nfor (const e of allFills) {\n const u = baseUnit(e.asset_fleet);\n if (u) (byU[u] ??= []).push(e);\n}\nfor (const u of Object.keys(byU)) {\n byU[u].sort((a, b) => Date.parse(a.pumped_at_time ?? \"\") - Date.parse(b.pumped_at_time ?? \"\"));\n}\nconst live = await sqlite.execute(\"SELECT unit, hours FROM fl_asset_live WHERE hours IS NOT NULL\");\nconst nowH: Record = {};\nfor (const r of rows(live)) nowH[baseUnit(r.unit)] = Number(r.hours);\n\nconst lost: string[] = [];\nlet checked = 0;\nfor (const u of Object.keys(byU)) {\n const b = burn[u];\n if (!b || b.rate_gph == null || b.cap == null) continue;\n const fills = byU[u];\n let level = b.cap, lastFullMeter: number | null = null;\n for (let i = 0; i < fills.length; i++) {\n const g = Number(fills[i].gallons);\n if (i > 0) {\n const dh = Number(fills[i].fuel_entry_asset_hours) - Number(fills[i - 1].fuel_entry_asset_hours);\n if (isFinite(dh) && dh > 0 && dh <= 600) level = Math.max(0, level - b.rate_gph * dh);\n else if (isFinite(dh) && dh > 600) { level = b.cap; lastFullMeter = Number(fills[i - 1].fuel_entry_asset_hours); }\n }\n if (g > 0) {\n level = Math.min(b.cap, level + g);\n if (level >= b.cap - 0.01) lastFullMeter = Number(fills[i].fuel_entry_asset_hours);\n }\n }\n const cur = nowH[u];\n if (cur == null || lastFullMeter == null || !isFinite(lastFullMeter)) continue;\n checked++;\n const tankfuls = Math.round(((cur - lastFullMeter) * b.rate_gph / b.cap) * 10) / 10;\n const pct = Math.round((level / b.cap) * 100);\n if (tankfuls > 1) {\n lost.push(u);\n console.log(u.padEnd(7), String(tankfuls).padStart(10), String(pct + \"%\").padStart(22), \" \" + String(b.name ?? \"\").trim().slice(0, 26));\n }\n}\nconsole.log(\"\");\nconsole.log(\"machines with a full-tank reference : \" + checked);\nconsole.log(\"running on a level we cannot defend : \" + lost.length + \" (more than one tankful since the model last saw it full)\");\n","deleted",false,"label",[14],"1730b37d-28eb-4a6b-8ba7-7294e47bbdb7",["D",1785517935233],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","DEV copy of NDX Parts — staging. Writes to TEST board.","imageUrl","userId","ab88c973-4988-481a-90fe-82231ca2dbda","pinnedFileId","ffd44ea0-8d02-11f1-95b0-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019fb4e5-7efe-7110-bc8f-c886bb63dd3f","tursoName","1730b37d28eb4a6b8ba77294e47bbdb7","tursoHostname","1730b37d28eb4a6b8ba77294e47bbdb7-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789452068287],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_105":100},"org",{"_9":10,"_99":100,"_101":100,"_55":56,"_102":103,"_104":42},"branch",{"_35":89,"_11":90,"_22":28,"_91":45,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":12,"_98":10},"isOwned",2869,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","","avatar","tier","pro","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_139":140,"_141":142,"_143":144,"_145":42,"_146":42,"_147":42,"_148":32,"_149":-5,"_150":-7,"_151":-7,"_152":63,"_153":42,"_154":42,"_155":-5,"_156":42,"_157":42,"_158":42,"_159":-5},"ENV",{"_110":111,"_112":113,"_114":90,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]