[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_149":150,"_151":152},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_88":-7,"_89":43,"_29":-7,"_90":-5,"_15":91,"_92":93,"_94":95,"_96":97,"_98":99,"_100":-5,"_101":-5,"_102":-5,"_103":38,"_104":105,"_106":107,"_108":-5,"_109":-5,"_110":111},"routes/_app.x.$handle.$name.branches",{"_11":12,"_13":14,"_15":16,"_17":18},"handle","piterchernychko","name","piter-cher","project",{"_20":28,"_13":14,"_22":36,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":-5,"_48":38,"_49":-5,"_50":-5,"_51":52,"_53":54,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":60,"_62":63,"_64":63,"_65":63,"_66":60,"_67":60,"_68":69,"_70":71,"_72":73,"_74":38},"branches",[19],{"_20":21,"_22":23,"_24":25,"_13":26,"_27":28,"_29":30,"_31":-5,"_32":-5,"_33":34,"_35":-5},"id","54a29bc0-57f3-11f1-9587-ee650bb23af1","createdAt",["D",1779683803380],"updatedAt",["D",1779755835131],"main","projectId","54a1c3d0-57f3-11f1-9587-ee650bb23af1","version",20,"forkedBranchId","forkedBranchVersion","lockfileKey","1779755979858-esm.town_v_piterchernychko_piter-cher@20-main","deletedAt",["D",1779683803374],"legacyEnvVars",false,"privacy","public","httpPrivacy","description","","imageUrl","userId","17b54865-9ad6-4808-bacc-de7e7462ab4f","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e5d68-b691-759e-a311-00d7dc76a9b7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_87":83},"org",{"_11":12,"_80":81,"_82":83,"_45":46,"_84":85,"_86":38},"branch",{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_75":-5,"_76":-5,"_77":-5,"_78":14,"_79":12},"isOwned","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Piter Chernychko","avatar","https://lh3.googleusercontent.com/a/ACg8ocKhKGyDJPqCpO0-ue5GxztF00mOGqn4ofOd0ANW-jc-BeiGIA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","path","adoptOrgId",{"_20":28,"_13":14,"_22":145,"_35":-5,"_37":38,"_39":40,"_41":40,"_42":43,"_44":-5,"_45":46,"_47":-5,"_48":38,"_49":-5,"_50":-5,"_51":52,"_53":54,"_55":-5,"_56":-5,"_57":-5,"_58":-5,"_59":60,"_61":60,"_62":63,"_64":63,"_65":63,"_66":60,"_67":60,"_68":146,"_70":147,"_72":148,"_74":38},"tree",[140],"files",[140],"counts",{"_130":52,"_17":131,"_132":52,"_133":134,"_135":136},"contents",[112],"file","upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_20":113,"_13":114,"_115":116,"_117":-5,"_118":21,"_119":30,"_120":107,"_22":121,"_29":122,"_123":124,"_125":126,"_127":38,"_128":-5,"_89":129},"0ae949fe-589b-11f1-9dbe-ee650bb23af1","main.ts","fileId","54a4f406-57f3-11f1-9587-ee650bb23af1","parentId","branchId","branchVersion","latest",["D",1779755835131],19,"fileType","http","content","// XLSX Builder for n8n — paste this into a new HTTP val on val.town.\n//\n// Receives the GAAP allocation rows from n8n's \"GAAP Allocation Code\" node\n// and returns a true .xlsx binary with LIVE EXCEL FORMULAS baked into the\n// computed cells. When someone opens the file in Excel and clicks one of\n// these cells, they see the actual formula, not just the number.\n//\n// Cells that become formulas:\n// • Total Cycle Days = - + 1\n// • Allocated Cost = ROUND( Days / Total Cycle Days * Price, 2)\n// • Allocated Cost (last) = ROUND(Price - SUM(prior months' Allocated Cost), 2)\n//\n// Every other column (original supporting-file columns, divider, per-month\n// \"Days\" counts, dates, etc.) is written as a static value exactly as n8n\n// sends it.\n\nimport * as XLSX from \"npm:xlsx\";\n\nconst MONTH_DAYS_RE =\n /^(January|February|March|April|May|June|July|August|September|October|November|December) Days$/;\n\nconst MONTH_NUM: Record = {\n January: 1, February: 2, March: 3, April: 4, May: 5, June: 6,\n July: 7, August: 8, September: 9, October: 10, November: 11, December: 12,\n};\n\n// Parse an ISO YYYY-MM-DD string (or a Date) to a UTC Date. Returns null otherwise.\nconst parseIsoDate = (v: any): Date | null => {\n if (!v) return null;\n if (v instanceof Date) return isNaN(v.getTime()) ? null : v;\n if (typeof v === \"string\") {\n const m = v.match(/^(\\d{4})-(\\d{2})-(\\d{2})/);\n if (m) {\n const d = new Date(Date.UTC(+m[1], +m[2] - 1, +m[3]));\n return isNaN(d.getTime()) ? null : d;\n }\n }\n return null;\n};\n\n// A \"simple\" row is one whose JS-computed Total Cycle Days equals\n// (Cycle end date − Cycle start date + 1) — i.e. the row spans a SINGLE\n// cycle. Prior-cycle rows (Atomic Mobile mid-cycle activation / Helix\n// straddling prorated windows) accumulate prior-cycle days into\n// Total Cycle Days; their monthly buckets also blend prior + current\n// dollars in a way that can't be expressed as a single per-month\n// =Days/Total*Price formula. For those rows we keep the JS-computed\n// static values exactly as the workflow sent them.\nconst isSimpleSingleCycleRow = (row: Record): boolean => {\n const start = parseIsoDate(row[\"Cycle start date\"]);\n const end = parseIsoDate(row[\"Cycle end date\"]);\n const total = Number(row[\"Total Cycle Days\"]);\n if (!start || !end || !Number.isFinite(total)) return false;\n const currentDays =\n Math.round((end.getTime() - start.getTime()) / 86400000) + 1;\n return Math.abs(currentDays - total) < 0.5;\n};\n\nconst colLetter = (idx0: number): string => {\n let s = \"\";\n let n = idx0 + 1;\n while (n > 0) {\n const rem = (n - 1) % 26;\n s = String.fromCharCode(65 + rem) + s;\n n = Math.floor((n - 1) / 26);\n }\n return s;\n};\n\nexport default async function (req: Request): Promise {\n if (req.method !== \"POST\") {\n return new Response(\"Use POST\", { status: 405 });\n }\n\n let body: any;\n try {\n body = await req.json();\n } catch {\n return new Response(\"Invalid JSON body\", { status: 400 });\n }\n\n const rows: Record[] = Array.isArray(body?.rows)\n ? body.rows\n : [];\n const sheetName = String(body?.sheetName || \"GAAP Allocation\").slice(0, 31);\n const fileName = String(body?.fileName || \"gaap-allocation.xlsx\");\n if (rows.length === 0) return new Response(\"No rows\", { status: 400 });\n\n // Build the union of all column headers across rows, preserving insertion\n // order (which the workflow constructs deliberately: original-file columns\n // first, then divider, then normalized columns, then monthly buckets).\n const headers: string[] = [];\n const seen = new Set();\n for (const row of rows) {\n for (const k of Object.keys(row)) {\n if (!seen.has(k)) {\n seen.add(k);\n headers.push(k);\n }\n }\n }\n\n // Start with everything as static values.\n const ws = XLSX.utils.json_to_sheet(rows, { header: headers });\n\n // Anchor lookups by header name.\n const idx = (name: string) => headers.indexOf(name);\n const startIdx = idx(\"Cycle start date\");\n const endIdx = idx(\"Cycle end date\");\n const priceIdx = idx(\"Price\");\n const totalDaysIdx = idx(\"Total Cycle Days\");\n // Prior-cycle anchors derived from already-visible columns (no helper\n // columns needed): priorStart = Activation Date (Atomic) or Plan\n // Effective Date (Helix); priorEnd = Cycle start − 1; priorPrice =\n // Prorated Charges (Atomic case; Helix straddling rows would\n // over-attribute, but no test data hits that path).\n const activationIdx = idx(\"Activation Date\");\n const planEffectiveIdx = idx(\"Plan Effective Date\");\n const proratedIdx = idx(\"Prorated Charges\");\n\n // Per-month (Days, Prior Days, Allocated Cost) triples in column order.\n // Because the workflow inserts month columns chronologically, the last\n // entry here is the last month chronologically — which is the one that\n // gets the \"remainder\" formula so the row's months sum exactly to Price\n // (or Price + Prior Cycle Price for prior-cycle rows).\n const monthCols: {\n name: string;\n daysIdx: number;\n priorDaysIdx: number;\n allocIdx: number;\n }[] = [];\n for (const h of headers) {\n const m = h.match(MONTH_DAYS_RE);\n if (m) {\n const monthName = m[1];\n monthCols.push({\n name: monthName,\n daysIdx: idx(h),\n priorDaysIdx: idx(`${monthName} Prior Days`),\n allocIdx: idx(`${monthName} Allocated Cost`),\n });\n }\n }\n\n for (let r = 0; r < rows.length; r++) {\n const excelRow = r + 2; // header is row 1; data starts at row 2\n const isSimple = isSimpleSingleCycleRow(rows[r]);\n\n // Per-month Allocated Cost — two paths:\n // Simple row → existing single-cycle formula: ROUND(Days/Total*Price, 2)\n // Prior-cycle row → blend two cycles per month using EOMONTH/DATE math\n // inline. The last chronological month uses a remainder formula so\n // the row's months sum exactly to (Price + PriorPrice).\n if (totalDaysIdx >= 0 && priceIdx >= 0 && monthCols.length > 0) {\n // Pick the priorStart column for this row (same precedence as\n // Total Cycle Days). Atomic Mobile → Activation Date; Helix → Plan\n // Effective Date.\n let priorStartColIdx = -1;\n if (!isSimple) {\n if (activationIdx >= 0 && rows[r][\"Activation Date\"]) {\n priorStartColIdx = activationIdx;\n } else if (planEffectiveIdx >= 0 && rows[r][\"Plan Effective Date\"]) {\n priorStartColIdx = planEffectiveIdx;\n }\n }\n const priorCycleReady = !isSimple &&\n priorStartColIdx >= 0 &&\n proratedIdx >= 0 &&\n rows[r][\"Prorated Charges\"] != null;\n\n // Prior-cycle row we can't formula-ize → keep JS-computed static values.\n if (!isSimple && !priorCycleReady) continue;\n\n for (let m = 0; m < monthCols.length; m++) {\n const { name: monthName, daysIdx, allocIdx } = monthCols[m];\n if (allocIdx < 0 || daysIdx < 0) continue;\n const ref = colLetter(allocIdx) + excelRow;\n const cell = (ws as any)[ref];\n if (!cell) continue;\n\n const isLast = m === monthCols.length - 1;\n\n if (isSimple) {\n // Single-cycle: simple ratio, with last-month remainder.\n if (isLast && monthCols.length > 1) {\n const priorRefs = monthCols\n .slice(0, m)\n .map((mc) => colLetter(mc.allocIdx) + excelRow);\n cell.f = `ROUND(${colLetter(priceIdx)}${excelRow}-SUM(${\n priorRefs.join(\",\")\n }),2)`;\n } else {\n cell.f = `ROUND(${colLetter(daysIdx)}${excelRow}/${\n colLetter(totalDaysIdx)\n }${excelRow}*${colLetter(priceIdx)}${excelRow},2)`;\n }\n } else {\n // Prior-cycle row, cycle-isolated math, derived from existing\n // visible columns only (no Prior Cycle End / Prior Cycle Price\n // helpers needed):\n // priorTotal = Cycle start − priorStart\n // (priorEnd is implicit = Cycle start − 1)\n // priorPrice = Prorated Charges (Atomic case)\n // monthAllocated =\n // ( − ) / (end − start + 1) * Price\n // + / (start − priorStart) * Prorated Charges\n // Last chronological month uses a remainder formula so the row's\n // months sum exactly to (Price + Prorated Charges).\n if (isLast && monthCols.length > 1) {\n const priorRefs = monthCols\n .slice(0, m)\n .map((mc) => colLetter(mc.allocIdx) + excelRow);\n cell.f = `ROUND((${colLetter(priceIdx)}${excelRow}+${\n colLetter(proratedIdx)\n }${excelRow})-SUM(${priorRefs.join(\",\")}),2)`;\n } else {\n const { priorDaysIdx } = monthCols[m];\n if (priorDaysIdx < 0) continue; // sheet missing the helper column → static\n const dRef = `${colLetter(daysIdx)}${excelRow}`;\n const pdRef = `${colLetter(priorDaysIdx)}${excelRow}`;\n const sRef = `${colLetter(startIdx)}${excelRow}`;\n const eRef = `${colLetter(endIdx)}${excelRow}`;\n const pRef = `${colLetter(priceIdx)}${excelRow}`;\n const psRef = `${colLetter(priorStartColIdx)}${excelRow}`;\n const prRef = `${colLetter(proratedIdx)}${excelRow}`;\n cell.f =\n `ROUND((${dRef}-${pdRef})/(${eRef}-${sRef}+1)*${pRef}+${pdRef}/(${sRef}-${psRef})*${prRef},2)`;\n }\n }\n delete cell.v;\n cell.t = \"n\";\n }\n }\n }\n\n const wb = XLSX.utils.book_new();\n XLSX.utils.book_append_sheet(wb, ws, sheetName);\n const buf = XLSX.write(wb, { type: \"array\", bookType: \"xlsx\" }) as Uint8Array;\n\n return new Response(buf, {\n headers: {\n \"Content-Type\":\n \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\n \"Content-Disposition\": `attachment; filename=\"${\n fileName.replace(/\"/g, \"\")\n }\"`,\n },\n });\n}\n","deleted","label",[114],"pulls",1,"forks","envVars",{"_137":52,"_139":52},"connections",{"_137":52,"_138":52},"count","unfilledCount","emptyCount",{"_20":113,"_13":114,"_115":116,"_117":-5,"_118":21,"_119":30,"_120":107,"_22":141,"_29":122,"_123":124,"_125":126,"_127":38,"_128":-5,"_142":143,"_89":144},["D",1779755835131],"children",[],[114],["D",1779683803374],{"_11":12,"_87":83},{"_11":12,"_80":81,"_82":83,"_45":46,"_84":85,"_86":38},{"_29":30,"_13":26,"_20":21,"_27":28,"_31":-5,"_32":-5,"_75":-5,"_76":-5,"_77":-5,"_78":14,"_79":12},"ctx",{"_68":-5,"_109":182,"_183":184,"_185":186,"_187":38,"_188":38,"_189":38,"_190":107,"_191":-5,"_192":-7,"_193":-7,"_194":52,"_195":38,"_196":38,"_197":-5,"_198":38,"_199":38,"_200":38,"_201":-5},"ENV",{"_153":154,"_155":156,"_157":26,"_158":159,"_160":161,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181},"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"]

Branches1

Branches
1