[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":121,"_122":-5,"_123":-5,"_124":125},"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":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",3,"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","main.ts","latestPath","fileId","62102b78-697e-11f1-9082-1607ee4eb77e","name","fileType","http","content","import * as XLSX from \"https://cdn.sheetjs.com/xlsx-latest/package/xlsx.mjs\";\n\n// ─── DATOS EXTRAÍDOS DE LOS PDFs Y DEL EXCEL EXISTENTE ───────────────────────\n\n// Columnas Esf. Comercial:\n// 0:M/B 1:LocType 2:Code 3:AssetCode 4:AssetName 5:Contract 6:Tenant 7:Use 8:Floor\n// 9:Initial 10:Signat 11:BO 12:Expiry 13:BOyrs 14:BOann 15:Expyrs 16:Expann\n// 17:VoidM 18:VoidMensual 19:VoidSBO 20:VoidSExp 21:empty 22:PrevSqm 23:PrevRent 24:PrevEm\n// 25:empty 26:Annual 27:empty 28:SgnSqm 29:Yr1 30:Yr2 31:Yr3 32:Yr4\n// 33:RentPm2 34:RentMens 35:BudPm2 36:BudMens 37:ERVpm2 38:ERVmens\n// 39:empty 40:VsPrev 41:VsBudg 42:VsERV 43:empty 44:empty\n// 45:CarenciaEm 46:IngresoEm 47:CarenciaBO 48:empty 49:CurSqm 50:CurRent 51:CurEm\n\nconst RENEWALS_ROWS = [\n [\"B\",\"Secondary\",\"BSecondary\",400058,\"SANT CUGAT\",\"94019531\",\"ERNI CONSULTING ESPAÑA\",\"Offices\",\"Ground Floor (Building A)\",\"Jun-26\",\"Jan-26\",\"May-27\",\"May-31\",1,0,5,0,0.0,0,\"0%\",\"0%\",\"\",551,14.8,8165,\"\",0.1,\"\",551,0,0,0,0,12.5,6888,12.4,6832,12.0,6633,\"\",\"-15.6%\",\"0.8%\",\"3.8%\",\"\",\"\",0.0,0.1,\"0%\",\"\",551,12.5,6888],\n [\"B\",\"CBD\",\"BCBD\",400048,\"VIA AUGUSTA, 21-23\",\"94017420\",\"RESIDENCIA DE ESTUDIANTES\",\"Offices\",\"2\",\"Sep-26\",\"Feb-26\",\"Oct-30\",\"Oct-32\",4,1,6,1,2.0,30960,\"4%\",\"3%\",\"\",645,23.5,15164,\"\",0.2,\"\",645,0,0,0,0,24.0,15480,23.9,15416,24.0,15468,\"\",\"2.1%\",\"0.4%\",\"0.1%\",\"\",\"\",0.0,0.8,\"4%\",\"\",645,24.0,15480],\n [\"M\",\"CBD\",\"MCBD\",400141,\"JOSÉ ABASCAL, 45\",\"94020255\",\"AGENCIA POLACA DE INVERSIÓN Y COMERCIO\",\"Offices\",\"6B\",\"Jul-26\",\"Mar-26\",\"Jun-29\",\"Jun-31\",3,0,5,0,0.0,0,\"0%\",\"0%\",\"\",80,29.1,2328,\"\",0.0,\"\",80,0,0,0,0,31.0,2480,29.0,2320,32.9,2629,\"\",\"6.5%\",\"6.9%\",\"-5.7%\",\"\",\"\",0.0,0.1,\"0%\",\"\",80,31.0,2480],\n [\"B\",\"Secondary\",\"BSecondary\",400199,\"PARC GLORIES\",\"94020624\",\"KING SHARED SERVICES\",\"Offices\",\"1, 13, 14, 15 & 16\",\"Mar-26\",\"Mar-26\",\"Mar-31\",\"Mar-36\",5,11,10,22,2.5,450720,\"4%\",\"2%\",\"\",7038,24.6,172878,\"\",2.2,\"\",7038,0,0,0,0,25.6,180288,25.6,180288,24.8,174446,\"\",\"4.3%\",\"0.0%\",\"3.3%\",\"\",\"\",0.5,10.8,\"4%\",\"\",7038,25.6,180288],\n [\"M\",\"CBD\",\"MCBD\",400070,\"ORTEGA Y GASSET, 100\",\"94020228R\",\"PERMIRA ASESORES (renewal)\",\"Offices\",\"3\",\"Mar-26\",\"Feb-26\",\"Mar-27\",\"Mar-32\",1,0,6,3,0.0,0,\"0%\",\"0%\",\"\",1164,29.2,33967,\"\",0.4,\"\",1164,30.2,31.5,0,0,30.9,35916,29.8,34647,29.0,33756,\"\",\"5.7%\",\"3.7%\",\"6.4%\",\"\",\"\",0.0,0.4,\"0%\",\"\",1164,30.9,35916],\n [\"M\",\"Secondary\",\"MSecondary\",400161,\"TUCUMÁN\",\"94020403R\",\"VERDALIA BIOENERGY SPAIN (renewal)\",\"Offices\",\"4 & 5\",\"Feb-26\",\"Feb-26\",\"Feb-31\",\"Feb-31\",5,2,5,2,0.0,0,\"0%\",\"0%\",\"\",1990,18.4,36636,\"\",0.4,\"\",1990,0,0,0,0,18.4,36644,18.8,37377,17.0,33830,\"\",\"0.0%\",\"-2.0%\",\"8.3%\",\"\",\"\",0.0,2.2,\"0%\",\"\",1990,18.4,36644],\n [\"M\",\"CBD\",\"MCBD\",400141,\"JOSÉ ABASCAL, 45\",\"94020123\",\"INTERNET MEDIA SERVICES EUROPE\",\"Offices\",\"Semibasement\",\"Jun-26\",\"Mar-26\",\"May-28\",\"May-30\",2,0,4,1,0.0,0,\"0%\",\"0%\",\"\",590,21.4,12611,\"\",0.2,\"\",590,0,0,0,0,24.0,14160,22.0,12980,24.0,14160,\"\",\"12.3%\",\"9.1%\",\"0.0%\",\"\",\"\",0.0,0.3,\"0%\",\"\",590,24.0,14160],\n [\"M\",\"Secondary\",\"MSecondary\",400190,\"ARTURO SORIA, 336\",\"94020070\",\"BRUC ENERGY\",\"Offices\",\"7B & C\",\"Mar-26\",\"Mar-26\",\"Mar-28\",\"Mar-28\",2,0,2,0,0.0,0,\"0%\",\"0%\",\"\",567,20.1,11398,\"\",0.1,\"\",567,0,0,0,0,20.0,11332,19.0,10765,19.0,10765,\"\",\"-0.6%\",\"5.3%\",\"5.3%\",\"\",\"\",0.0,0.3,\"0%\",\"\",567,20.0,11332],\n [\"B\",\"CBD\",\"BCBD\",400004,\"DIAGONAL, 609-615 (PRISMA)\",\"94020067\",\"ACCELYA WORLD\",\"Offices\",\"9 A3 & B4\",\"May-26\",\"Mar-26\",\"May-28\",\"May-31\",2,0,5,0,0.0,0,\"0%\",\"0%\",\"\",248,28.6,7085,\"\",0.1,\"\",248,0,0,0,0,29.5,7325,26.0,6448,26.0,6448,\"\",\"3.4%\",\"13.6%\",\"13.6%\",\"\",\"\",0.0,0.2,\"0%\",\"\",248,29.5,7325],\n [\"B\",\"CBD\",\"BCBD\",400004,\"DIAGONAL, 609-615 (DAU)\",\"94019105\",\"GRANT THORNTON\",\"Offices\",\"10\",\"Mar-26\",\"Mar-26\",\"Feb-31\",\"Feb-31\",5,4,5,4,3.0,192852,\"5%\",\"5%\",\"\",1948,28.4,55368,\"\",0.8,\"\",1948,0,0,0,0,33.0,64284,30.0,58440,31.0,60388,\"\",\"16.1%\",\"10.0%\",\"6.5%\",\"\",\"\",0.2,3.9,\"5%\",\"\",1948,33.0,64284],\n [\"M\",\"CBD\",\"MCBD\",400053,\"ALFONSO XII, 62\",\"94019930\",\"RADISSON HOSPITALITY SPAIN\",\"Offices\",\"1A & 7\",\"Jul-26\",\"Mar-26\",\"Jun-29\",\"Jun-31\",3,2,5,4,1.0,61930,\"3%\",\"2%\",\"\",2100,27.8,58467,\"\",0.7,\"\",2100,0,0,0,0,29.5,61930,25.9,54411,26.0,54670,\"\",\"5.9%\",\"13.8%\",\"13.3%\",\"\",\"\",0.1,2.2,\"3%\",\"\",2100,29.5,61930],\n [\"B\",\"CBD\",\"BCBD\",400028,\"AMIGO 11-17\",\"94019207\",\"EDITORIAL SALVAT\",\"Offices\",\"5A &B\",\"May-26\",\"Mar-26\",\"May-29\",\"May-29\",3,0,3,0,0.0,0,\"0%\",\"0%\",\"\",430,25.0,10748,\"\",0.1,\"\",430,0,0,0,0,25.8,11113,24.1,10380,24.6,10568,\"\",\"3.4%\",\"7.1%\",\"5.2%\",\"\",\"\",0.0,0.4,\"0%\",\"\",430,25.8,11113],\n // ★ NUEVO - REGUS (Novación modificativa / RENEWAL)\n [\"M\",\"Secondary\",\"MSecondary\",400091,\"MARTINEZ VILLERGAS, 49\",\"94019096\",\"REGUS ESP028\",\"Offices\",\"1\",\"Apr-26\",\"Apr-26\",\"Mar-30\",\"Mar-30\",4,1,4,1,2.0,36000,\"4%\",\"4%\",\"\",1125,17.8,19982,\"\",0.2,\"\",1125,0,0,0,0,16.0,18000,16.5,18563,15.8,17719,\"\",\"-9.9%\",\"-3.0%\",\"1.6%\",\"\",\"\",0.0,0.9,\"4%\",\"\",1125,16.0,18000],\n];\n\nconst NEW_LETTINGS_ROWS = [\n [\"M\",\"Secondary\",\"MSecondary\",400161,\"TUCUMÁN\",\"94020619\",\"ESCRIBANO MECHANICAL & ENGINEERING\",\"Offices\",\"3 Izq\",\"Feb-26\",\"Feb-26\",\"Feb-29\",\"Feb-31\",3,0,5,1,3.0,35340,\"8%\",\"5%\",\"\",\"-\",\"-\",\"-\",\"\",0.1,\"\",620,0,0,0,0,19.0,11780,17.7,10962,17.0,10540,\"\",\"-\",\"7.5%\",\"11.8%\",\"\",\"\",0.0,0.4,\"8%\",\"\",\"\",\"\"],\n [\"M\",\"Secondary\",\"MSecondary\",400161,\"TUCUMÁN\",\"94020403\",\"VERDALIA BIOENERGY SPAIN (new letting)\",\"Offices\",\"3 Dcha\",\"Feb-26\",\"Feb-26\",\"Feb-31\",\"Feb-31\",5,1,5,1,6.0,66276,\"10%\",\"10%\",\"\",\"-\",\"-\",\"-\",\"\",0.1,\"\",600,0,0,0,0,18.4,11046,17.7,10608,17.0,10200,\"\",\"-\",\"4.1%\",\"8.3%\",\"\",\"\",0.1,0.7,\"10%\",\"\",\"\",\"\"],\n [\"M\",\"City Center\",\"MCity Center\",400209,\"MADNUM\",\"94020630\",\"SORECO AUDIT\",\"Offices\",\"2 Poniente\",\"Mar-26\",\"Mar-26\",\"Mar-32\",\"Mar-36\",6,2,10,3,7.0,155209,\"10%\",\"6%\",\"\",\"-\",\"-\",\"-\",\"\",0.3,\"\",821,0,0,0,0,27.0,22173,27.5,22583,27.4,22522,\"\",\"-\",\"-1.8%\",\"-1.6%\",\"\",\"\",0.2,1.6,\"10%\",\"\",\"\",\"\"],\n // ★ NUEVO - NEPTUNE NORTH (Alta de contrato / NEW LETTING)\n [\"M\",\"CBD\",\"MCBD\",400047,\"CASTELLANA, 52\",\"94020634\",\"NEPTUNE NORTH SPAIN\",\"Offices\",\"2\",\"May-26\",\"Mar-26\",\"Nov-29\",\"May-33\",4,1,7,3,4.0,141056,\"10%\",\"5%\",\"\",\"-\",\"-\",\"-\",\"\",0.4,\"\",928,0,0,0,0,38.0,35264,35.5,32944,35.5,32944,\"\",\"-\",\"7.0%\",\"7.0%\",\"\",\"\",0.1,1.5,\"10%\",\"\",\"\",\"\"],\n];\n\nconst RELETS_ROWS = [\n [\"M\",\"CBD\",\"MCBD\",400171,\"DON RAMÓN DE LA CRUZ, 84\",\"94020603\",\"N26 BANK\",\"Offices\",\"2\",\"Jan-26\",\"Jan-26\",\"Dec-27\",\"Dec-30\",2,2,5,4,2.0,136862,\"8%\",\"3%\",\"\",2106,34.3,72298,\"\",0.8,\"\",2106,0,0,0,0,32.5,68431,31.0,65273,30.2,63508,\"\",\"-5.3%\",\"4.8%\",\"7.8%\",\"\",\"\",0.1,1.6,\"8%\",\"\",2106,32.5,68431],\n [\"B\",\"CBD\",\"BCBD\",400004,\"DIAGONAL, 609-615 (DAU)\",\"94020613\",\"BIORCE ESP\",\"Offices\",\"2\",\"Feb-26\",\"Jan-26\",\"Feb-28\",\"Feb-31\",2,1,5,4,3.0,181164,\"13%\",\"5%\",\"\",1948,28.7,55961,\"\",0.7,\"\",1948,0,0,0,0,31.0,60388,30.0,58440,31.0,60388,\"\",\"7.9%\",\"3.3%\",\"0.0%\",\"\",\"\",0.2,1.4,\"13%\",\"\",1948,31.0,60388],\n [\"B\",\"Secondary\",\"BSecondary\",400199,\"PARC GLORIES\",\"94020548\",\"MICROSOFT IBERICA\",\"Offices\",\"2\",\"Mar-26\",\"Mar-26\",\"Mar-31\",\"Mar-36\",5,3,10,5,2.5,110250,\"4%\",\"2%\",\"\",1800,23.1,41591,\"\",0.5,\"\",1800,0,0,0,0,24.5,44100,25.0,45000,24.8,44615,\"\",\"6.0%\",\"-2.0%\",\"-1.2%\",\"\",\"\",0.1,2.6,\"4%\",\"\",1800,24.5,44100],\n [\"M\",\"CBD\",\"MCBD\",400070,\"ORTEGA Y GASSET, 100\",\"94020228\",\"PERMIRA ASESORES (new letting)\",\"Offices\",\"6 Mod 1\",\"Mar-26\",\"Feb-26\",\"Mar-27\",\"Mar-32\",1,0,6,1,3.0,48221,\"25%\",\"4%\",\"\",527,29.0,15283,\"\",0.2,\"\",527,0,0,0,0,30.5,16074,29.2,15388,29.0,15283,\"\",\"5.2%\",\"4.5%\",\"5.2%\",\"\",\"\",0.0,0.2,\"25%\",\"\",527,30.5,16074],\n [\"M\",\"CBD\",\"MCBD\",400198,\"DISCOVERY BUILDING\",\"94020629\",\"ASOC. AUTOREGULACIÓN DE LA COMUNIC.COMERCIAL\",\"Offices\",\"5\",\"May-26\",\"Mar-26\",\"May-32\",\"May-35\",6,3,9,4,6.0,217221,\"8%\",\"6%\",\"\",1187,29.5,35017,\"\",0.4,\"\",1187,0,0,0,0,30.5,36204,30.5,36204,30.5,36204,\"\",\"3.4%\",\"0.0%\",\"0.0%\",\"\",\"\",0.2,2.6,\"8%\",\"\",1187,30.5,36204],\n // ★ NUEVO - NASH21 WORLDWIDE (Alta / RE-LET porque era superficie de Bankinter/FINAER)\n [\"M\",\"CBD\",\"MCBD\",400171,\"DON RAMÓN DE LA CRUZ, 84\",\"94020633\",\"NASH21 WORLDWIDE\",\"Offices\",\"Ground floor (mod. 2 & 3)\",\"Mar-26\",\"Mar-26\",\"Mar-29\",\"Mar-31\",3,1,5,1,0.0,0,\"0%\",\"0%\",\"\",477,27.5,13105,\"\",0.2,\"\",477,0,0,0,0,31.0,14772,27.0,12866,30.2,14373,\"\",\"12.7%\",\"14.8%\",\"2.8%\",\"\",\"\",0.0,0.5,\"0%\",\"\",477,31.0,14772],\n];\n\n// Cabeceras Esf. Comercial\nconst ESF_COMERCIAL_HEADERS = [\n [\"\",\"03.26\"],\n [],\n [\"\",\"\",\"\",\"\",\"COMMERCIAL EFFORT (sq m)\"],\n [],\n [\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"vs Previous - Excl. New lettings para cálculo de release\"],\n [\"\",\"\",\"\",\"Asset\",\"Contract\",\"Tenant\",\"Use\",\"Floor\",\"Initial\",\"Signat.\",\"BO\",\"Expiry\",\"BO\",\"\",\"Expiry\",\"\",\"Void\",\"\",\"Void\",\"Void\",\"\",\"Previous\",\"\",\"Renta\",\"\",\"Annual.\",\"\",\"Signed\",\"Signed\",\"\",\"\",\"\",\"Renta\",\"Budget\",\"Renta\",\"ERV\",\"Renta\",\"\",\"Signed vs prev.\",\"Signed vs Budget\",\"Signed vs ERV 12/25\",\"\",\"\",\"Carencia\",\"Ingreso €m\",\"Carencia /\",\"\",\"Current\",\"Current\",\"Renta\"],\n [\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"Date\",\"Date\",\"Date\",\"Date\",\"(years)\",\"anualizado\",\"(years)\",\"anualizado\",\"(months)\",\"mensual\",\"s/ BO\",\"s/Expiry\",\"\",\"sq m\",\"Rent\",\"anterior\",\"\",\"Rent (€m)\",\"\",\"sq m\",\"Year 1\",\"Year 2\",\"Year 3\",\"Year 4\",\"Rent\",\"Signed\",\"2026\",\"Budget\",\"12/25\",\"ERV\",\"\",\"\",\"\",\"\",\"\",\"\",\"€m\",\"hasta BO\",\"Ingreso\",\"\",\"sq m\",\"2026\",\"\"],\n];\n\n// Cabeceras Mov 2026\nconst MOV_HEADERS = [\n [\"\",\"Mes en curso\"],\n [\"RL\",\"Re-Lettings\"],\n [\"A\",\"Altas\"],\n [\"R\",\"Renovaciones\"],\n [],\n [\"\",\"\",\"Rescissions\"],\n [\"\",\"UE\",\"Cebe\",\"Inmueble\",\"Fecha Inicio\",\"Fecha Firma\",\"Contrato actual\",\"Arrendatario actual\",\"Superficie SR\",\"Renta año 1\",\"Renta año 2\",\"Renta año 3\",\"Renta año 4\",\"Renta año 5\",\"Renta año 6\",\"Renta año 7\",\"Renta año 8\",\"Renta año 9\",\"Renta año 10\",\"€/m²/mes actual\",\"Carencia (meses)\",\"BO\",\"Fin\",\"Uso\",\"Planta\",\"\",\"Superficie SR anterior\",\"€/m²/mes anterior\",\"Contrato anterior\",\"Previous Tenant\",\"Expiry Date\",\"Months\",\"\",\"\",\"Observaciones\"],\n];\n\n// Datos Mov 2026 - extraídos del CSV\nconst MOV_DATA = [\n // RL entries\n [\"RL\",225142,400171,\"DON RAMÓN DE LA CRUZ, 84\",\"1/1/2026\",\"1/1/2026\",\"94020603\",\"N26 BANK\",2106,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",32.5,2.0,\"31/12/2027\",\"31/12/2030\",\"Offices\",\"2\",\"\",2106,34.3,\"94020072\",\"BANKINTER S.A.\",\"31/10/2025\",2.0,\"\",\"\",\"RELET | Duración: 2+3\"],\n [\"RL\",227002,\"400004D\",\"DIAGONAL, 609-615 (DAU)\",\"2/2/2026\",\"30/1/2026\",\"94020613\",\"BIORCE ESP\",1948,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",31.0,3.0,\"1/2/2028\",\"1/2/2031\",\"Offices\",\"2\",\"\",1948,28.7,\"94020291\",\"ASTRAZENECA\",\"1/2/2026\",0.0,\"\",\"\",\"RELET\"],\n [\"RL\",225167,400199,\"PARC GLORIES\",\"7/3/2026\",\"4/3/2026\",\"94020548\",\"MICROSOFT IBERICA\",1800,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",24.5,2.5,\"6/3/2031\",\"6/3/2036\",\"Offices\",\"2\",\"\",1800,23.1,\"94019847\",\"KING SHARED SERVICES, S.L.\",\"6/3/2026\",0.0,\"\",\"\",\"RELET | Ampliación Planta 2ª\"],\n [\"RL\",225056,400070,\"ORTEGA Y GASSET, 100\",\"2/3/2026\",\"23/2/2026\",\"94020228\",\"PERMIRA ASESORES\",527,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",30.5,3.0,\"4/3/2027\",\"4/3/2032\",\"Offices\",\"6 Mod 1\",\"\",527,29.0,\"94020314\",\"INSTANT OFFICE S.L.U.\",\"28/2/2026\",0.1,\"\",\"\",\"RELET\"],\n [\"RL\",225166,400198,\"DISCOVERY BUILDING\",\"4/5/2026\",\"11/3/2026\",\"94020629\",\"ASOCIACIÓN DE PARA LA AUTOREGULACIÓN DE LA COMUNICACIÓN COMERCIAL\",1187,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",30.5,6.0,\"3/5/2032\",\"3/5/2035\",\"Offices\",\"5\",\"\",1187,29.5,\"94019855\",\"DEVO INC, SUCURSAL EN ESPAÑA\",\"18/4/2026\",0.5,\"\",\"\",\"RELET | Duración: 6+3\"],\n [\"RL\",225142,400171,\"DON RAMÓN DE LA CRUZ, 84\",\"23/3/2026\",\"23/3/2026\",\"94020633\",\"NASH21 WORLDWIDE\",477,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",31.0,0.0,\"23/3/2029\",\"23/3/2031\",\"Offices\",\"Ground floor (mod. 2 & 3)\",\"\",477,27.5,\"94020072\",\"BANKINTER S.A.\",\"31/10/2025\",4.7,\"\",\"\",\"RELET | Duración: 3+2\"],\n // R entries\n [\"R\",225053,400058,\"SANT CUGAT\",\"1/6/2026\",\"30/1/2026\",\"94019531\",\"ERNI CONSULTING ESPAÑA\",551,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",12.5,0.0,\"31/5/2027\",\"31/5/2031\",\"Offices\",\"Ground Floor (Building A)\",\"\",551,14.8,\"94019531\",\"ERNI CONSULTING ESPAÑA\",\"\",\"\",\"\",\"\",\"RENOVACIÓN | Duración: 1+2+2\"],\n [\"R\",225042,400048,\"VIA AUGUSTA, 21-23\",\"14/9/2026\",\"9/2/2026\",\"94017420\",\"RESIDENCIA DE ESTUDIANTES\",645,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",24.0,2.0,\"31/10/2030\",\"31/10/2032\",\"Offices\",\"2\",\"\",645,23.5,\"94017420\",\"RESIDENCIA DE ESTUDIANTES\",\"\",\"\",\"\",\"\",\"NOVACIÓN AMPLIACIÓN\"],\n [\"R\",225112,400141,\"JOSÉ ABASCAL, 45\",\"1/7/2026\",\"3/3/2026\",\"94020255\",\"AGENCIA POLACA DE INVERSIÓN Y COMERCIO\",80,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",31.0,0.0,\"30/6/2029\",\"30/6/2031\",\"Offices\",\"6B\",\"\",80,29.1,\"94020255\",\"AGENCIA POLACA DE INVERSIÓN Y COMERCIO\",\"\",\"\",\"\",\"\",\"RENOVACIÓN | Duración 3+2\"],\n [\"R\",225167,400199,\"PARC GLORIES\",\"7/3/2026\",\"3/3/2026\",\"94020624\",\"KING SHARED SERVICES\",7038,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",25.6,2.5,\"6/3/2031\",\"6/3/2036\",\"Offices\",\"1, 13, 14, 15 & 16\",\"\",7038,24.6,\"94019847\",\"KING SHARED SERVICES, S.L.\",\"\",\"\",\"\",\"\",\"RENOVACIÓN | Duración: 5+3+2\"],\n [\"R\",225056,400070,\"ORTEGA Y GASSET, 100\",\"6/3/2026\",\"23/2/2026\",\"94020228R\",\"PERMIRA ASESORES (RENEWAL)\",1164,30.2,31.5,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",0.0,\"4/3/2027\",\"4/3/2032\",\"Offices\",\"3\",\"\",1164,29.2,\"94020314\",\"INSTANT OFFICE S.L.U.\",\"\",\"\",\"\",\"\",\"RENOVACIÓN\"],\n [\"R\",225112,400141,\"JOSÉ ABASCAL, 45\",\"1/6/2026\",\"17/3/2026\",\"94020123\",\"INTERNET MEDIA SERVICES EUROPE\",590,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",24.0,0.0,\"31/5/2028\",\"31/5/2030\",\"Offices\",\"Semibasement\",\"\",590,21.4,\"94020123\",\"INTERNET MEDIA SERVICES EUROPE\",\"\",\"\",\"\",\"\",\"RENOVACIÓN | Duración 2+2\"],\n [\"R\",225159,400190,\"ARTURO SORIA, 336\",\"16/3/2026\",\"16/3/2026\",\"94020070\",\"BRUC ENERGY\",567,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",20.0,0.0,\"15/3/2028\",\"15/3/2028\",\"Offices\",\"7B & C\",\"\",567,20.1,\"94020070\",\"BRUC ENERGY\",\"\",\"\",\"\",\"\",\"RENOVACIÓN | Duración 2 años\"],\n [\"R\",227002,\"400004P\",\"DIAGONAL, 609-615 (PRISMA)\",\"3/5/2026\",\"20/3/2026\",\"94020067\",\"ACCELYA WORLD\",248,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",29.5,0.0,\"2/5/2028\",\"2/5/2031\",\"Offices\",\"9 A3 & B4\",\"\",248,28.6,\"94020067\",\"ACCELYA WORLD\",\"\",\"\",\"\",\"\",\"RENOVACIÓN | Duración: 2+2+1\"],\n [\"R\",227002,\"400004D\",\"DIAGONAL, 609-615 (DAU)\",\"1/3/2026\",\"6/3/2026\",\"94019105\",\"GRANT THORNTON\",1948,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",33.0,3.0,\"28/2/2031\",\"28/2/2031\",\"Offices\",\"10\",\"\",1948,28.4,\"94019105\",\"GRANT THORNTON\",\"\",\"\",\"\",\"\",\"REVISION RENTA MERCADO\"],\n [\"R\",225050,400053,\"ALFONSO XII, 62\",\"1/7/2026\",\"10/3/2026\",\"94019930\",\"RADISSON HOSPITALITY SPAIN\",2100,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",29.5,1.0,\"30/6/2029\",\"30/6/2031\",\"Offices\",\"1A & 7\",\"\",2100,27.8,\"94019930\",\"RADISSON HOSPITALITY SPAIN\",\"\",\"\",\"\",\"\",\"RENOVACIÓN | Duración: 3+2\"],\n [\"R\",225022,400028,\"AMIGO 11-17\",\"10/5/2026\",\"27/3/2026\",\"94019207\",\"EDITORIAL SALVAT\",430,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",25.8,0.0,\"9/5/2029\",\"9/5/2029\",\"Offices\",\"5A &B\",\"\",430,25.0,\"94019207\",\"EDITORIAL SALVAT\",\"\",\"\",\"\",\"\",\"RENOVACIÓN | Duración: 3+2\"],\n // ★ R - REGUS (Novación modificativa = RENOVACIÓN)\n [\"R\",225079,400091,\"MARTINEZ VILLERGAS, 49\",\"1/4/2026\",\"1/4/2026\",\"94019096\",\"REGUS ESP028\",1125,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",16.0,2.0,\"31/3/2030\",\"31/3/2030\",\"Offices\",\"1\",\"\",1125,17.8,\"94019096\",\"REGUS ESP028\",\"\",\"\",\"\",\"\",\"RENOVACIÓN | Duración: 4 años\"],\n // A entries\n [\"A\",225132,400161,\"TUCUMÁN\",\"9/2/2026\",\"9/2/2026\",\"94020619\",\"ESCRIBANO MECHANICAL & ENGINEERING\",620,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",19.0,3.0,\"8/2/2029\",\"8/2/2031\",\"Offices\",\"3 Izq\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"NUEVO CONTRATO | Duración: 3+2\"],\n [\"A\",225132,400161,\"TUCUMÁN\",\"11/2/2026\",\"11/2/2026\",\"94020403\",\"VERDALIA BIOENERGY SPAIN\",600,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",18.41,6.0,\"10/2/2031\",\"10/2/2031\",\"Offices\",\"3 Dcha\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"NUEVO CONTRATO\"],\n [\"A\",225132,400161,\"TUCUMÁN\",\"11/2/2026\",\"11/2/2026\",\"94020403R\",\"VERDALIA BIOENERGY SPAIN (RENEWAL)\",1990,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",18.41,0.0,\"10/2/2031\",\"10/2/2031\",\"Offices\",\"4 & 5\",\"\",1990,18.4,\"94020403\",\"VERDALIA BIOENERGY SPAIN\",\"\",\"\",\"\",\"\",\"RENOVACIÓN\"],\n [\"A\",225171,400209,\"MADNUM\",\"15/3/2026\",\"15/3/2026\",\"94020630\",\"SORECO AUDIT\",821,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",27.0,7.0,\"14/3/2032\",\"14/3/2036\",\"Offices\",\"2 Poniente\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"ALTA CONTRATO | 6+4\"],\n // ★ A - NEPTUNE NORTH (Alta de contrato / NEW LETTING)\n [\"A\",225041,400047,\"CASTELLANA, 52\",\"4/5/2026\",\"12/3/2026\",\"94020634\",\"NEPTUNE NORTH SPAIN\",928,\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",38.0,4.0,\"3/11/2029\",\"3/5/2033\",\"Offices\",\"2\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"ALTA CONTRATO | 3 AÑOS Y MEDIO + 2 + 1,5 AÑOS. Hall acabado por cliente, aportación Colonial 30.000€\"],\n];\n\nfunction buildEsfComercialSheet(addMissingRows: boolean): any[] {\n const rows: any[] = [];\n \n // Headers\n ESF_COMERCIAL_HEADERS.forEach(h => rows.push(h));\n rows.push([]);\n \n // RENEWALS section title\n rows.push([\"\",\"\",\"RENEWALS\"]);\n \n // Renewals data\n RENEWALS_ROWS.forEach(r => rows.push(r));\n \n // RENEWALS subtotal placeholder\n rows.push([\"\",\"\",\"\",\"RENEWALS SUBTOTAL (valores sin fórmula)\"]);\n rows.push([]);\n \n // NEW LETTINGS section title\n rows.push([\"\",\"\",\"NEW LETTINGS\"]);\n \n // New Lettings data\n NEW_LETTINGS_ROWS.forEach(r => rows.push(r));\n \n // NEW LETTINGS subtotal placeholder\n rows.push([\"\",\"\",\"\",\"NEW LETTINGS SUBTOTAL (valores sin fórmula)\"]);\n rows.push([]);\n \n // RE-LET SURFACES section title\n rows.push([\"\",\"\",\"RE-LET SURFACES\"]);\n \n // RE-LETS data\n RELETS_ROWS.forEach(r => rows.push(r));\n \n // RE-LET subtotal placeholder\n rows.push([\"\",\"\",\"\",\"RE-LET SURFACES SUBTOTAL (valores sin fórmula)\"]);\n \n return rows;\n}\n\nfunction buildMovSheet(): any[] {\n const rows: any[] = [];\n MOV_HEADERS.forEach(h => rows.push(h));\n MOV_DATA.forEach(r => rows.push(r));\n return rows;\n}\n\nexport default async function handler(req: Request): Promise {\n const wb = XLSX.utils.book_new();\n \n // 1. Hoja: Esf. Comercial (PRINCIPAL - con los 3 nuevos añadidos)\n const esfComData = buildEsfComercialSheet(true);\n const wsEsfCom = XLSX.utils.aoa_to_sheet(esfComData);\n XLSX.utils.book_append_sheet(wb, wsEsfCom, \"Esf. Comercial\");\n \n // 2. Hoja: Esf. Comercial (Offices) - idéntica a la principal (ya tenía los 3)\n const wsEsfComOff = XLSX.utils.aoa_to_sheet(esfComData);\n XLSX.utils.book_append_sheet(wb, wsEsfComOff, \"Esf. Comercial (Offices)\");\n \n // 3. Hoja: Mov 2026 - con los 3 contratos\n const movData = buildMovSheet();\n const wsMov = XLSX.utils.aoa_to_sheet(movData);\n XLSX.utils.book_append_sheet(wb, wsMov, \"Mov 2026\");\n \n // 4. Hojas auxiliares - placeholders (mantener estructura de libro)\n const placeholderSheets = [\"Cebes\",\"Contratos ppto 2026\",\"Precios ppto26\",\"Tasación1225\",\"Esf. Cial 1225\"];\n placeholderSheets.forEach(name => {\n const ws = XLSX.utils.aoa_to_sheet([[\"Hoja auxiliar - datos en archivo original\"]]);\n XLSX.utils.book_append_sheet(wb, ws, name);\n });\n \n // Generar buffer xlsx\n const buf: ArrayBuffer = XLSX.write(wb, { type: \"array\", bookType: \"xlsx\" });\n \n return new Response(buf, {\n status: 200,\n headers: {\n \"Content-Type\": \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\n \"Content-Disposition\": 'attachment; filename=\"Copia_de_Revisiones_renta_COL_0326.xlsx\"',\n \"Access-Control-Allow-Origin\": \"*\",\n },\n });\n}\n","import * as XLSX from \"https://cdn.sheetjs.com/xlsx-latest/package/xlsx.mjs\";\n\n// ─── DATOS DE LAS 3 FILAS NUEVAS (52 columnas, extraídas de Esf. Comercial (Offices) + PDFs) ───\n\nconst REGUS_ROW: (string | number | null)[] = [\n \"M\",\"Secondary\",\"MSecondary\",400091,\"MARTINEZ VILLERGAS, 49\",\"94019096\",\"REGUS ESP028\",\n \"Offices\",\"1\",\"Apr-26\",\"Apr-26\",\"Mar-30\",\"Mar-30\",4,1,4,1,2.0,36000,\"4%\",\"4%\",\n null,1125,17.8,19982,null,0.2,null,1125,0,0,0,0,16.0,18000,16.5,18563,15.8,17719,\n null,\"-9.9%\",\"-3.0%\",\"1.6%\",null,null,0.0,0.9,\"4%\",null,1125,16.0,18000\n];\n\nconst NEPTUNE_ROW: (string | number | null)[] = [\n \"M\",\"CBD\",\"MCBD\",400047,\"CASTELLANA, 52\",\"94020634\",\"NEPTUNE NORTH SPAIN\",\n \"Offices\",\"2\",\"May-26\",\"Mar-26\",\"Nov-29\",\"May-33\",4,1,7,3,4.0,141056,\"10%\",\"5%\",\n null,\"-\",\"-\",\"-\",null,0.4,null,928,0,0,0,0,38.0,35264,35.5,32944,35.5,32944,\n null,\"-\",\"7.0%\",\"7.0%\",null,null,0.1,1.5,\"10%\",null,null,null,null\n];\n\nconst NASH21_ROW: (string | number | null)[] = [\n \"M\",\"CBD\",\"MCBD\",400171,\"DON RAMÓN DE LA CRUZ, 84\",\"94020633\",\"NASH21 WORLDWIDE\",\n \"Offices\",\"Ground floor (mod. 2 & 3)\",\"Mar-26\",\"Mar-26\",\"Mar-29\",\"Mar-31\",3,1,5,1,0.0,0,\"0%\",\"0%\",\n null,477,27.5,13105,null,0.2,null,477,0,0,0,0,31.0,14772,27.0,12866,30.2,14373,\n null,\"12.7%\",\"14.8%\",\"2.8%\",null,null,0.0,0.5,\"0%\",null,477,31.0,14772\n];\n\n// ─── BUSCAR FILA POR NOMBRE DEL ARRENDATARIO ──────────────────────────────────\nfunction findRowByTenant(ws: any, search: string): number {\n const range = XLSX.utils.decode_range(ws['!ref'] || 'A1:A1');\n for (let r = range.s.r; r <= range.e.r; r++) {\n for (const col of [5, 6, 7, 8]) {\n const cell = ws[XLSX.utils.encode_cell({r, c: col})];\n if (cell && String(cell.v ?? '').toUpperCase().includes(search.toUpperCase())) {\n return r;\n }\n }\n }\n return -1;\n}\n\n// ─── INSERTAR FILA NUEVA DESPUÉS DE UNA FILA EXISTENTE ────────────────────────\nfunction insertRowAfter(ws: any, afterRow: number, rowData: (string | number | null)[]): void {\n const range = XLSX.utils.decode_range(ws['!ref'] || 'A1:A1');\n const insertAt = afterRow + 1;\n\n // 1. Desplazar todas las filas desde insertAt hacia abajo\n for (let r = range.e.r; r >= insertAt; r--) {\n for (let c = range.s.c; c <= range.e.c; c++) {\n const src = XLSX.utils.encode_cell({r, c});\n const dst = XLSX.utils.encode_cell({r: r + 1, c});\n if (ws[src]) {\n ws[dst] = {...ws[src]};\n } else {\n delete ws[dst];\n }\n }\n }\n\n // 2. Limpiar la fila en la posición de inserción\n for (let c = range.s.c; c <= range.e.c; c++) {\n delete ws[XLSX.utils.encode_cell({r: insertAt, c})];\n }\n\n // 3. Ajustar alturas de fila (!rows)\n if (ws['!rows'] && Array.isArray(ws['!rows'])) {\n const tplRowProp = ws['!rows'][afterRow] ? {...ws['!rows'][afterRow]} : {};\n ws['!rows'].splice(insertAt, 0, tplRowProp);\n }\n\n // 4. Ajustar celdas combinadas (!merges)\n if (ws['!merges'] && Array.isArray(ws['!merges'])) {\n ws['!merges'] = ws['!merges'].map((m: any) => {\n if (m.s.r >= insertAt) return {s: {r: m.s.r + 1, c: m.s.c}, e: {r: m.e.r + 1, c: m.e.c}};\n if (m.e.r >= insertAt) return {s: m.s, e: {r: m.e.r + 1, c: m.e.c}};\n return m;\n });\n }\n\n // 5. Escribir datos de la fila nueva, copiando el estilo de la fila de plantilla\n rowData.forEach((val, c) => {\n if (val === null || val === undefined) return;\n const addr = XLSX.utils.encode_cell({r: insertAt, c});\n const tplAddr = XLSX.utils.encode_cell({r: afterRow, c});\n const tplCell = ws[tplAddr];\n\n const cell: any = {v: val, w: String(val), t: typeof val === 'number' ? 'n' : 's'};\n if (tplCell?.s) cell.s = {...tplCell.s};\n ws[addr] = cell;\n });\n\n // 6. Actualizar rango de la hoja\n range.e.r += 1;\n ws['!ref'] = XLSX.utils.encode_range(range);\n}\n\n// ─── HANDLER PRINCIPAL ────────────────────────────────────────────────────────\nexport default async function handler(req: Request): Promise {\n\n // ── GET: Formulario de subida ─────────────────────────────────────────────\n if (req.method === 'GET') {\n const html = `\n\n\n \n Actualizar Excel – Revisiones Renta COL 0326\n \n\n\n

📊 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","createdAt",["D",1781626453560],"branchVersion","branchId","8d518513-718f-4e97-9bf5-1af3c982cee2","id","da10129f-9c11-4112-b4b2-0a26b41d8dc2","esfuerzo_comercial_excel_updater",["D",1781612571402],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Genera Excel actualizado con SheetJS para Revisiones renta COL","imageUrl","019c294d-f0eb-70cc-8df6-0cedd5a9f689","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019c294d-f0eb-70cc-8df6-10c4077f7c37","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",13,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Brunooo","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM5RDhzc3E2Yk05T25GVEZOM2N6VzBEWHVCTiJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":150,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":151,"_79":152,"_81":153,"_83":25},"tree",[145],"files",[145],"counts",{"_134":61,"_135":136,"_137":61,"_138":139,"_140":141},"contents",[126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":121,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"c55c1897-ef24-4da4-acf9-70a861ade4c3","parentId","latest",["D",1781626453560],2,"label",[28],"pulls","branches",1,"forks","envVars",{"_142":61,"_144":61},"connections",{"_142":61,"_143":61},"count","unfilledCount","emptyCount",{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":121,"_38":146,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_147":148,"_27":149},["D",1781626453560],"children",[],[28],["D",1781612571402],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_123":187,"_188":189,"_190":191,"_192":25,"_193":25,"_194":25,"_195":121,"_196":-5,"_197":-7,"_198":-7,"_199":61,"_200":25,"_201":25,"_202":-5,"_203":25,"_204":25,"_205":25,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":85,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","9e167d8120a57de5d747867e0b686da51bcc19a4","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 · v3