📊 Actualizar Excel — Revisiones Renta COL 0326

Sube el Excel original. El procesador añade las 3 filas en la hoja \"Esf. Comercial\" preservando todo el formato, fórmulas y estilos del archivo original.

\n\n

RENEWALREGUS ESP028, S.L. — Martínez Villergas, 49 · UE 225079 · 1.125 m² · 16 €/m²/mes · Apr-26 → Mar-30

NEW LETTINGNEPTUNE NORTH SPAIN S.L.U. — Castellana, 52 · UE 225041 · 928 m² · 38 €/m²/mes · May-26 → May-33

RE-LETNASH21 WORLDWIDE, S.L. — Don Ramón de la Cruz, 84 · UE 225142 · 477 m² · 31 €/m²/mes · Mar-26 → Mar-31

\n\n

⚠️ Nota: En \"Esf. Comercial (Offices)\" y \"Mov 2026\" estos contratos ya existen y son correctos. Solo se modificará la hoja \"Esf. Comercial\".

\n\n \n

\n\n`;\n return new Response(html, {headers: {'Content-Type': 'text/html; charset=utf-8'}});\n }\n\n // ── POST: Procesar Excel ──────────────────────────────────────────────────\n if (req.method === 'POST') {\n try {\n const fd = await req.formData();\n const file = fd.get('excel') as File;\n if (!file) return new Response('No se proporcionó archivo.', {status: 400});\n\n const buf = await file.arrayBuffer();\n const wb = XLSX.read(new Uint8Array(buf), {\n type: 'array',\n cellStyles: true,\n cellNF: true,\n cellFormula: true,\n cellDates: true,\n sheetStubs: true\n });\n\n const SHEET = 'Esf. Comercial';\n if (!wb.SheetNames.includes(SHEET)) {\n return new Response(`Error: hoja \"${SHEET}\" no encontrada. Hojas disponibles: ${wb.SheetNames.join(', ')}`, {status: 400});\n }\n\n const ws = wb.Sheets[SHEET];\n const log: string[] = [];\n\n // Buscar filas de referencia (de abajo a arriba para insertar en orden)\n const autoregRow = findRowByTenant(ws, 'AUTOREGULACI'); // RE-LET → NASH21 después\n const sorecoRow = findRowByTenant(ws, 'SORECO'); // NEW LETTING → NEPTUNE después\n const salvatRow = findRowByTenant(ws, 'SALVAT'); // RENEWAL → REGUS después\n\n // Insertar de abajo hacia arriba para no desplazar las filas siguientes\n if (autoregRow > 0) {\n insertRowAfter(ws, autoregRow, NASH21_ROW);\n log.push(`✅ NASH21 insertado (fila ${autoregRow + 2}, RE-LET SURFACES)`);\n } else {\n log.push('⚠️ ASOC. AUTOREGULACIÓN no encontrada → NASH21 no insertado');\n }\n\n if (sorecoRow > 0) {\n insertRowAfter(ws, sorecoRow, NEPTUNE_ROW);\n log.push(`✅ NEPTUNE NORTH SPAIN insertado (fila ${sorecoRow + 2}, NEW LETTINGS)`);\n } else {\n log.push('⚠️ SORECO AUDIT no encontrado → NEPTUNE no insertado');\n }\n\n if (salvatRow > 0) {\n insertRowAfter(ws, salvatRow, REGUS_ROW);\n log.push(`✅ REGUS ESP028 insertado (fila ${salvatRow + 2}, RENEWALS)`);\n } else {\n log.push('⚠️ EDITORIAL SALVAT no encontrado → REGUS no insertado');\n }\n\n const outBuf = XLSX.write(wb, {type: 'array', bookType: 'xlsx', cellStyles: true});\n const outName = file.name.replace(/\\.(xlsx|xls)$/i, '_ACTUALIZADO.xlsx');\n\n return new Response(outBuf, {\n status: 200,\n headers: {\n 'Content-Type': 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',\n 'Content-Disposition': `attachment; filename=\"${outName}\"`,\n 'X-Log': log.join(' | '),\n 'Access-Control-Allow-Origin': '*'\n }\n });\n\n } catch (e: any) {\n return new Response(`Error: ${e.message}\\n${e.stack}`, {status: 500});\n }\n }\n\n return new Response('Method not allowed', {status: 405});\n}\n","label",[127],"963de823-1949-46ff-a17d-82e238df533b",["D",1781678005997],[27],"370681fa-21ad-4c18-bbde-7ceba56bfbeb","generate_reconstructed.ts","ac6a3b5a-69b0-11f1-a79d-1607ee4eb77e",11,["D",1781634339612],1,"import ExcelJS from \"npm:exceljs\";\n\nconst ops = [\n {\n block: \"RENEWALS\", tipo: \"Novación modificativa / prórroga\", pdf: \"0326 - Preparador Regus.pdf\",\n ue: \"225079\", contract: \"94019096\", tenant: \"REGUS ESP028, S.L.\", asset: \"MARTÍNEZ VILLERGAS, 49\", localidad: \"Madrid\",\n use: \"Offices\", floor: \"1\", superficie: 1125, rentUnit: 16.00, rentMonthly: 18000.00, annualRent: 216000.00,\n initial: \"01/04/2026\", economic: \"01/06/2026\", signat: \"12/03/2026\", boDate: \"31/03/2030\", expiry: \"31/03/2030\",\n boMonths: 48, voidMonths: 2, gastosUnit: 5.50, gastosMonthly: 6187.50, luzUnit: 1.90, luzMonthly: 2137.50,\n gastosTotal: 8325.00, fianza: 39965.14, aval: 0, parkingSpaces: \"\", parkingRent: \"\", refcat: \"4373101VK4747C0001EB\",\n review: \"REVISAR: comentarios de cesión societaria/desimplantación; mantener trazabilidad legal.\"\n },\n {\n block: \"NEW LETTINGS\", tipo: \"Alta de contrato\", pdf: \"0326 - Preparador Neptune.pdf\",\n ue: \"225041\", contract: \"\", tenant: \"NEPTUNE NORTH SPAIN S.L.U.\", asset: \"CASTELLANA, 52\", localidad: \"Madrid\",\n use: \"Offices\", floor: \"2\", superficie: 928, rentUnit: 38.00, rentMonthly: 35264.00, annualRent: 423168.00,\n initial: \"04/05/2026\", economic: \"04/09/2026\", signat: \"04/02/2026\", boDate: \"\", expiry: \"04/05/2033\",\n boMonths: 42, voidMonths: 4, gastosUnit: 7.90, gastosMonthly: 9001.60, luzUnit: 2.00, luzMonthly: 1856.00,\n gastosTotal: 10947.60, fianza: 71248.00, aval: 213744.00, parkingSpaces: 2, parkingRent: 360.00, refcat: \"1766807VK4716F0001JK\",\n review: \"REVISAR: contrato no informado; discrepancia gastos oficinas: 928 x 7,90 = 7.331,20 pero PDF muestra 9.001,60. Incluye 2 plazas parking a 180 €/plaza/mes y contribución obra 30.000 €.\"\n },\n {\n block: \"RE-LET SURFACES\", tipo: \"Alta de contrato\", pdf: \"0326 - Preparador Nash21.pdf\",\n ue: \"225142\", contract: \"\", tenant: \"NASH21 WORLDWIDE, S.L.\", asset: \"DON RAMÓN DE LA CRUZ, 84\", localidad: \"Madrid\",\n use: \"Offices\", floor: \"Ground floor (módulos 2 y 3)\", superficie: 476.52, rentUnit: 31.00, rentMonthly: 14772.12, annualRent: 177265.44,\n initial: \"23/03/2026\", economic: \"23/03/2026\", signat: \"24/02/2026\", boDate: \"23/03/2029\", expiry: \"23/03/2031\",\n boMonths: 36, voidMonths: 0, gastosUnit: 6.00, gastosMonthly: 2859.12, luzUnit: 1.50, luzMonthly: 714.78,\n gastosTotal: 3573.90, fianza: 29544.24, aval: 88632.72, parkingSpaces: \"\", parkingRent: \"\", refcat: \"3056301VK4735E0001DM\",\n review: \"REVISAR: contrato no informado. BO al final del tercer año con preaviso 6 meses.\"\n }\n];\n\nconst movHeaders = [\"PDF\", \"Tipo operación\", \"Nº U.E.\", \"Contrato\", \"Arrendatario\", \"Inmueble\", \"Localidad\", \"Objeto / Comentarios\", \"Uso\", \"Planta\", \"Superficie\", \"Renta €/m²/mes\", \"Renta mensual\", \"Renta anual\", \"Plazas parking\", \"Renta parking mensual\", \"Carencia meses\", \"Obligado cumplimiento meses\", \"Fecha vigencia contrato\", \"Fecha vigencia económica\", \"Fecha BO\", \"Fecha vencimiento\", \"Gastos €/m²/mes\", \"Gastos mensuales\", \"Luz €/m²/mes\", \"Luz mensual\", \"Gastos total mensual\", \"Fianza\", \"Aval\", \"Referencia catastral\", \"REVISAR\"];\nconst esfHeaders = [\"Asset\", \"Contract\", \"Tenant\", \"Use\", \"Floor\", \"Initial Date\", \"Signat. Date\", \"BO Date\", \"Expiry Date\", \"BO months\", \"Expiry years\", \"Void months\", \"Signed sq m\", \"Signed Rent €/m²/month\", \"Signed Rent mensual\", \"Annual Rent\", \"Parking spaces\", \"Parking rent mensual\", \"Service charges €/m²\", \"Service charges mensual\", \"Light €/m²\", \"Light mensual\", \"Total expenses mensual\", \"Deposit\", \"Bank guarantee\", \"Nº U.E.\", \"Type\", \"Comments / REVISAR\"];\n\nfunction fmtDate(s: string) {\n if (!s) return \"\";\n const [d,m,y] = s.split(\"/\").map(Number);\n return new Date(y, m - 1, d);\n}\nfunction monthYear(s: string) {\n const dt = fmtDate(s); if (!dt) return \"\";\n return dt.toLocaleString(\"en-US\", {month:\"short\", year:\"2-digit\"}).replace(\" \", \"-\");\n}\n\nfunction styleHeader(row: any, fill = \"1F4E78\") {\n row.eachCell((cell: any) => {\n cell.font = {bold: true, color: {argb: \"FFFFFFFF\"}};\n cell.fill = {type: \"pattern\", pattern: \"solid\", fgColor: {argb: fill}};\n cell.alignment = {vertical: \"middle\", horizontal: \"center\", wrapText: true};\n cell.border = {top:{style:\"thin\"}, left:{style:\"thin\"}, bottom:{style:\"thin\"}, right:{style:\"thin\"}};\n });\n}\nfunction styleTable(ws: any) {\n ws.eachRow((row: any, n: number) => {\n row.eachCell((cell: any) => {\n cell.border = {top:{style:\"thin\", color:{argb:\"FFD9E2F3\"}}, left:{style:\"thin\", color:{argb:\"FFD9E2F3\"}}, bottom:{style:\"thin\", color:{argb:\"FFD9E2F3\"}}, right:{style:\"thin\", color:{argb:\"FFD9E2F3\"}}};\n cell.alignment = {vertical: \"middle\", wrapText: true};\n });\n });\n}\nfunction addTitle(ws: any, title: string, subtitle?: string) {\n ws.mergeCells(\"A1:H1\");\n const c = ws.getCell(\"A1\"); c.value = title; c.font = {bold:true, size:16, color:{argb:\"FFFFFFFF\"}}; c.fill = {type:\"pattern\", pattern:\"solid\", fgColor:{argb:\"FF17365D\"}}; c.alignment={vertical:\"middle\"};\n ws.getRow(1).height = 24;\n if (subtitle) { ws.mergeCells(\"A2:H2\"); ws.getCell(\"A2\").value = subtitle; ws.getCell(\"A2\").font = {italic:true, color:{argb:\"FF666666\"}}; }\n}\nfunction addMovSheet(wb: any) {\n const ws = wb.addWorksheet(\"Mov 2026\", {views:[{state:\"frozen\", ySplit:4}]});\n addTitle(ws, \"Mov 2026\", \"Reconstrucción generada por AI a partir de PDFs de preparador 0326\");\n const h = ws.addRow(movHeaders); styleHeader(h);\n ops.forEach(o => ws.addRow([o.pdf,o.tipo,o.ue,o.contract,o.tenant,o.asset,o.localidad,o.tipo,o.use,o.floor,o.superficie,o.rentUnit,o.rentMonthly,o.annualRent,o.parkingSpaces,o.parkingRent,o.voidMonths,o.boMonths,fmtDate(o.initial),fmtDate(o.economic),fmtDate(o.boDate),fmtDate(o.expiry),o.gastosUnit,o.gastosMonthly,o.luzUnit,o.luzMonthly,o.gastosTotal,o.fianza,o.aval,o.refcat,o.review]));\n ws.columns = movHeaders.map((h,i)=>({width: i===30?55: Math.min(Math.max(String(h).length+4, 12), 26)}));\n [11,12,13,14,16,23,24,25,26,27,28,29].forEach(i=>ws.getColumn(i).numFmt = '#,##0.00');\n [19,20,21,22].forEach(i=>ws.getColumn(i).numFmt = 'dd/mm/yyyy');\n styleTable(ws); ws.autoFilter = {from:\"A3\", to:\"AE3\"};\n}\nfunction addEsfSheet(wb: any, name: string, officesOnly = false) {\n const ws = wb.addWorksheet(name, {views:[{state:\"frozen\", ySplit:5}]});\n addTitle(ws, \"COMMERCIAL EFFORT (sq m)\", name + \" · 03.26 · Archivo reconstruido (no sustituye al libro maestro original)\");\n ws.addRow([]);\n const h = ws.addRow(esfHeaders); styleHeader(h, \"4472C4\");\n const blocks = [\"RENEWALS\", \"NEW LETTINGS\", \"RE-LET SURFACES\"];\n blocks.forEach(block => {\n const br = ws.addRow([block]); ws.mergeCells(`A${br.number}:AB${br.number}`); br.getCell(1).font={bold:true,color:{argb:\"FFFFFFFF\"}}; br.getCell(1).fill={type:\"pattern\",pattern:\"solid\",fgColor:{argb:block===\"RENEWALS\"?\"FF70AD47\":block===\"NEW LETTINGS\"?\"FFF4B183\":\"FF9E7CC1\"}};\n ops.filter(o => o.block === block && (!officesOnly || /^Office/i.test(o.use))).forEach(o => ws.addRow([o.asset,o.contract,o.tenant,o.use,o.floor,monthYear(o.initial),monthYear(o.signat),monthYear(o.boDate),monthYear(o.expiry),o.boMonths, o.expiry ? Math.round((fmtDate(o.expiry).getTime()-fmtDate(o.initial).getTime())/31557600000*10)/10 : \"\", o.voidMonths,o.superficie,o.rentUnit,o.rentMonthly,o.annualRent,o.parkingSpaces,o.parkingRent,o.gastosUnit,o.gastosMonthly,o.luzUnit,o.luzMonthly,o.gastosTotal,o.fianza,o.aval,o.ue,o.tipo,o.review]));\n const tr = ws.addRow([`TOTAL ${block}`]); tr.font={bold:true}; tr.fill={type:\"pattern\",pattern:\"solid\",fgColor:{argb:\"FFD9EAD3\"}};\n });\n ws.columns = esfHeaders.map((h,i)=>({width: i===27?58: Math.min(Math.max(String(h).length+3, 11), 25)}));\n [13,14,15,16,18,19,20,21,22,23,24,25].forEach(i=>ws.getColumn(i).numFmt = '#,##0.00');\n styleTable(ws); ws.autoFilter = {from:\"A4\", to:\"AB4\"};\n}\nfunction addSummary(wb: any) {\n const ws = wb.addWorksheet(\"Resumen AI\");\n addTitle(ws, \"Resumen de generación AI\", \"Copia reconstruida por limitación técnica de acceso binario al workbook original\");\n ws.addRow([]);\n const h=ws.addRow([\"Concepto\", \"Valor\"]); styleHeader(h, \"7030A0\");\n [[\"PDFs procesados\",3],[\"Operaciones detectadas\",3],[\"Hojas operativas generadas\",\"Mov 2026, Esf. Comercial, Esf. Comercial (Offices)\"],[\"Advertencia\",\"Este archivo es una reconstrucción aproximada; no preserva fórmulas/formatos exactos del libro maestro original.\"],[\"REVISAR NEPTUNE\",\"Discrepancia de gastos oficinas: unitario 7,90 €/m² no cuadra con total 9.001,60 €/mes.\"],[\"REVISAR contratos\",\"NASH21 y NEPTUNE no informan número de contrato en PDF.\"]].forEach(r=>ws.addRow(r));\n ws.columns=[{width:28},{width:100}]; styleTable(ws);\n}\n\nexport default async function handler(req: Request): Promise {\n const wb = new ExcelJS.Workbook();\n wb.creator = \"Colonial AI Lab\"; wb.created = new Date();\n addSummary(wb); addMovSheet(wb); addEsfSheet(wb, \"Esf. Comercial\"); addEsfSheet(wb, \"Esf. Comercial (Offices)\", true);\n const buffer = await wb.xlsx.writeBuffer();\n return new Response(buffer, {headers:{\"Content-Type\":\"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\"Content-Disposition\":\"attachment; filename=\\\"Copia de Revisiones renta COL 0326 (2) - generado AI.xlsx\\\"\",\"Cache-Control\":\"no-store\"}});\n}\n",[142],"22758a27-5567-4fd1-a5ee-01d652b01206","fetchtest.ts","254ea0fe-69a9-11f1-aa0a-1607ee4eb77e",9,["D",1781631882109],5,"export default async function handler(req: Request): Promise {\n const urls = [\n \"https://liquidlab1.sharepoint.com/:x:/r/sites/LiquidLab/Shared%20Documents/Esfuerzo%20comercial/Copia%20de%20Revisiones%20renta%20COL%200326%20(2).xlsx?d=w5c3f4221006b495d901571193a9bc73d&download=1\",\n \"https://liquidlab1.sharepoint.com/:x:/r/sites/LiquidLab/Shared%20Documents/Esfuerzo%20comercial/Copia%20de%20Revisiones%20renta%20COL%200326%20(2).xlsx?d=w5c3f4221006b495d901571193a9bc73d&csf=1&web=0&e=hvi7Hd\",\n \"https://liquidlab1.sharepoint.com/sites/LiquidLab/Shared%20Documents/Esfuerzo%20comercial/Copia%20de%20Revisiones%20renta%20COL%200326%20(2).xlsx?download=1\"\n ];\n const out=[];\n for (const url of urls) {\n const r = await fetch(url, {redirect:\"follow\"});\n const ab=await r.arrayBuffer();\n out.push({url, status:r.status, finalUrl:r.url, contentType:r.headers.get(\"content-type\"), len:ab.byteLength, first:Array.from(new Uint8Array(ab.slice(0,8))), txt:new TextDecoder().decode(ab.slice(0,60))});\n }\n return Response.json(out);\n}",[150],"pulls","branches","forks","envVars",{"_164":58,"_166":58},"connections",{"_164":58,"_165":58},"count","unfilledCount","emptyCount",{"_40":149,"_31":150,"_29":151,"_129":-5,"_38":39,"_37":152,"_131":117,"_35":181,"_13":154,"_32":134,"_33":155,"_23":24,"_136":-5,"_172":182,"_26":183},{"_40":141,"_31":142,"_29":143,"_129":-5,"_38":39,"_37":144,"_131":117,"_35":178,"_13":146,"_32":134,"_33":147,"_23":24,"_136":-5,"_172":179,"_26":180},{"_40":138,"_31":27,"_29":30,"_129":-5,"_38":39,"_37":14,"_131":24,"_35":175,"_13":58,"_32":20,"_33":34,"_23":24,"_136":-5,"_172":176,"_26":177},{"_40":126,"_31":127,"_29":128,"_129":-5,"_38":39,"_37":130,"_131":117,"_35":171,"_13":133,"_32":134,"_33":135,"_23":24,"_136":-5,"_172":173,"_26":174},["D",1781626453560],"children",[],[127],["D",1781678005997],[],[27],["D",1781634339612],[],[142],["D",1781631882109],[],[150],["D",1781612571402],{"_92":91,"_99":95},{"_92":91,"_93":-5,"_94":95,"_18":52,"_96":97,"_98":24},{"_13":81,"_31":82,"_40":39,"_83":41,"_84":-5,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":42,"_90":91},"ctx",{"_74":-5,"_119":221,"_222":223,"_224":225,"_226":24,"_227":24,"_228":24,"_229":117,"_230":-5,"_231":-7,"_232":-7,"_233":58,"_234":24,"_235":24,"_236":-5,"_237":24,"_238":24,"_239":24,"_240":-5},"ENV",{"_192":193,"_194":195,"_196":82,"_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 · v12