{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["RESUMEN EJECUTIVO","SIMULADOR","DATOS DEL CLIENTE ","DATOS"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":3,"defined_names":26,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RESUMEN EJECUTIVO","index":0,"n_rows":89,"n_cols":18,"rows_kept":89,"cut":false,"hidden":false,"merged":[[88,4,88,11],[44,1,44,14],[45,1,45,14],[19,8,19,9],[18,10,18,11],[18,12,18,13],[26,10,26,11],[22,8,22,9],[21,10,21,11],[21,12,21,13],[28,11,28,14],[24,10,24,12],[41,10,41,11],[41,12,41,13],[40,10,40,11],[40,12,40,13],[43,9,43,11],[39,6,39,8],[41,6,41,8],[37,10,37,11],[27,8,27,13],[34,8,34,9],[32,8,32,9],[30,8,30,9],[37,12,37,13],[39,10,39,11],[39,12,39,13],[29,12,29,13],[30,12,30,13],[32,12,32,13],[34,12,34,13],[30,10,30,11],[32,10,32,11],[34,10,34,11],[29,10,29,11],[27,3,27,4],[9,12,11,14],[24,8,24,9],[25,8,25,9],[26,8,26,9],[24,3,24,4],[25,3,25,4],[26,3,26,4],[25,10,25,11],[28,8,28,10],[19,1,19,2],[19,3,19,5],[22,3,22,4],[23,3,23,4],[22,12,22,13],[7,1,7,14],[9,4,9,5],[15,4,15,5],[15,12,15,14],[47,1,47,14],[17,1,17,14],[11,4,11,8],[13,4,13,8],[22,10,22,11],[28,3,28,4],[30,3,30,4],[32,3,32,4],[29,3,29,4],[30,5,30,6],[29,5,29,6],[32,5,32,6]]}
[]
[]
[]
[]
[]
[null,"RESUMEN EJECUTIVO DE VENTA"]
[]
[null,"DATOS DEL CLIENTE"]
[]
[null,"TIPO DE CONTRATO:",null,null,{"$f":"'DATOS DEL CLIENTE '!S4","v":0},null,null,null,null,null,null,"CORREO:",{"$f":"IF('DATOS DEL CLIENTE '!S4=\"PERSONA FISICA \",'DATOS DEL CLIENTE '!P9,IF('DATOS DEL CLIENTE '!S4=\"PERSONA MORAL\",'DATOS DEL CLIENTE '!E48&'DATOS DEL CLIENTE '!A23&'DATOS DEL CLIENTE '!P57&'DATOS DEL CLIENTE '!A23&'DATOS DEL CLIENTE '!P65,IF('DATOS DEL CLIENTE '!S4=\"COPROPIEDAD \",'DATOS DEL CLIENTE '!P24&'DATOS DEL CLIENTE '!A23&'DATOS DEL CLIENTE '!P32,\"\")))","v":""}]
[]
[null,"NOMBRE DE EMPRESA:",null,null,{"$f":"'DATOS DEL CLIENTE '!E46:AD46","v":0}]
[]
[null,"NOMBRE DEL CLIENTE:",null,null,{"$f":"IF('DATOS DEL CLIENTE '!S4=\"PERSONA FISICA \",'DATOS DEL CLIENTE '!H7,IF('DATOS DEL CLIENTE '!S4=\"PERSONA MORAL\",'DATOS DEL CLIENTE '!H55&'DATOS DEL CLIENTE '!A23&'DATOS DEL CLIENTE '!H63,IF('DATOS DEL CLIENTE '!S4=\"COPROPIEDAD \",'DATOS DEL CLIENTE '!H22&'DATOS DEL CLIENTE '!A23&'DATOS DEL CLIENTE '!H30,\"\")))","v":""}]
[]
[null,"USO DE PROPIEDAD:",null,null,{"$f":"'DATOS DEL CLIENTE '!H4","v":0},null,null,null,null,null,null,"TEL.: ",{"$f":"IF('DATOS DEL CLIENTE '!S4=\"PERSONA FISICA \",'DATOS DEL CLIENTE '!AF7,IF('DATOS DEL CLIENTE '!S4=\"PERSONA MORAL\",'DATOS DEL CLIENTE '!AF46&'DATOS DEL CLIENTE '!A23&'DATOS DEL CLIENTE '!AF55&'DATOS DEL CLIENTE '!A23&'DATOS DEL CLIENTE '!AF30,IF('DATOS DEL CLIENTE '!S4=\"COPROPIEDAD \",'DATOS DEL CLIENTE '!AF22&'DATOS DEL CLIENTE '!A23&'DATOS DEL CLIENTE '!AF30,\"\")))","v":""}]
[]
[null,"INFORMACIÓN  DE VENTA"]
[]
[null,"REFRERENCIA",null,{"$f":"SIMULADOR!M8","v":"15SUR_57B"}]
[]
[null,null,null,null,null,null,null,null,null,null,"SIN/IVA",null,"C/IVA"]
[null,"M2:",null,{"$f":"SIMULADOR!F15","v":400},null,null,null,null,"A FINANCIAR:",null,{"$f":"SIMULADOR!K23","v":3519084.66},null,{"$f":"SIMULADOR!M23","v":3969527.4964800002}]
[null,"TIPO:",null,{"$f":"SIMULADOR!E14","v":"NAVE"}]
[null,"P. U. LISTA: ",null,{"$f":"SIMULADOR!F17","v":14786.07},null,null,null,null,"TEMPORALIDAD:",null,{"$f":"SIMULADOR!G22","v":10}]
[null,"DESCUENTO:",null,{"$f":"SIMULADOR!N15","v":0.15},null,null,null,null,"TASA DE INTERÉS:",null,{"$f":"SIMULADOR!G23/12","v":3},null,{"$f":"SIMULADOR!H23","v":0}]
[null,"P.U. DESCUENTO:",null,{"$f":"SIMULADOR!F18","v":12568.1595},null,null,null,null,"TASA DE INTERÉS:",null,{"$f":"SIMULADOR!G24/12","v":7},null,{"$f":"SIMULADOR!H24","v":0.02}]
[null,"ENGANCHE",{"$f":"SIMULADOR!N18","v":0.3},{"$f":"SIMULADOR!K18","v":1508179.14}]
[null,"Desc. 10% Enganche:",null,{"$f":"SIMULADOR!K19","v":0},null,null,null,null,{"$f":"SIMULADOR!J37","v":"ENGANCHE DIFERIDO:"},null,null,{"$f":"SIMULADOR!K37","v":"NAVE-CDA 10%,10% 10%"}]
[null,null,null,"SIN/IVA",null,"C/IVA",null,null,null,null,{"$f":"IF(SIMULADOR!J37=\"ENGANCHE DIFERIDO:\",\"SIN/IVA\",\"\")","v":"SIN/IVA"},null,{"$f":"IF(SIMULADOR!J37=\"ENGANCHE DIFERIDO:\",\"C/IVA\",\"\")","v":"C/IVA"}]
[null,"ENGANCHE REAL",null,{"$f":"SIMULADOR!K21","v":1508179.14},null,{"$f":"SIMULADOR!M21","v":1701226.0699199999},null,null,{"$f":"SIMULADOR!K39","v":"PAGO INMEDIATO"},null,{"$f":"SIMULADOR!L39","v":502726.38},null,{"$f":"SIMULADOR!N39","v":567075.35664000001},null,{"$f":"IF(SIMULADOR!J37=\"ENGANCHE DIFERIDO:\",\"NO INCLUYE MENSUALIDAD\",\"\")","v":"NO INCLUYE MENSUALIDAD"}]
[]
[null,"TOTAL A PAGAR",null,{"$f":"SIMULADOR!K22","v":5027263.8},null,{"$f":"SIMULADOR!M22","v":5670753.5663999999},null,null,{"$f":"SIMULADOR!K40","v":12},null,{"$f":"SIMULADOR!L40","v":502726.38},null,{"$f":"SIMULADOR!N40","v":567075.35664000001},null,{"$f":"IF(SIMULADOR!J37=\"ENGANCHE DIFERIDO:\",\"NO INCLUYE MENSUALIDAD\",\"\")","v":"NO INCLUYE MENSUALIDAD"}]
[]
[null,null,null,null,"2025-01-01",null,null,null,{"$f":"SIMULADOR!K41","v":24},null,{"$f":"SIMULADOR!L41","v":502726.38},null,{"$f":"SIMULADOR!N41","v":567075.35664000001},null,{"$f":"IF(SIMULADOR!J37=\"ENGANCHE DIFERIDO:\",\"NO INCLUYE MENSUALIDAD\",\"\")","v":"NO INCLUYE MENSUALIDAD"}]
[null,"MES DE ENTREGA",null,null,{"$f":"IF(SIMULADOR!H9=\"AEROPUERTO (Lote)\",18,IF(SIMULADOR!H9=\"AEROPUERTO (Nave)\",18,IF(SIMULADOR!H9=\"PEDRO ESCOBEDO (Lote)\",24,IF(SIMULADOR!H9=\"PEDRO ESCOBEDO (NAVE)\",24,IF(SIMULADOR!H9=\"GAMMA II ETAPA 1\",6,IF(SIMULADOR!H9=\"GAMMA II ETAPA 2\",6,IF(SIMULADOR!H9=\"CELTA\",36,IF(SIMULADOR!H9=\"STA ROSA (Nave)\",4,IF(AND(SIMULADOR!H9=\"CALAMANDA (NAVE)\",SIMULADOR!G20=\"FINANCIAMIENTO 1\"),36,IF(AND(SIMULADOR!H9=\"CALAMANDA (NAVE)\",SIMULADOR!G20=\"FINANCIAMIENTO 2\"),24,IF(AND(SIMULADOR!H9=\"CALAMANDA (LOCAL)\",SIMULADOR!F13=\"A\"),24,IF(AND(SIMULADOR!H9=\"CALAMANDA (LOCAL)\",SIMULADOR!F13=\"B\"),36,IF(SIMULADOR!H9=\"SUR_57\",36,\"\")))))))))))))","v":36}]
[]
[null,"FECHA DE ENTREGA",null,null,{"$f":"VLOOKUP(E36,Table_1[#All],2)","v":"2028-02-05"},null,null,null,null,null,"SIN/IVA",null,"C/IVA"]
[]
[null,"FECHA DE 1RA MENSUALIDAD",null,null,{"$f":"SIMULADOR!F50","v":"2025-03-05"},null,{"$f":"SIMULADOR!J27","v":1},null,null,{"$f":"SIMULADOR!K27","v":36},{"$f":"SIMULADOR!L27","v":29325.705500000004},null,{"$f":"SIMULADOR!N27","v":33079.395804}]
[]
[null,"PLUSVALÍA CONTRATO",null,null,{"$f":"IF($D$20=\"AEROPUERTO (Lote)\",\"\",IF($D$20=\"AEROPUERTO (Nave)\",\"\",IF($D$20=\"PEDRO ESCOBEDO (Nave)\",\"\",IF($D$20=\"PEDRO ESCOBEDO (Lote)\",\"\",IF($D$20=\"SAN LUIS POTOSI (Nave)\",20%,IF($D$20=\"GAMMA II ETAPA 1\",\"\",IF($D$20=\"GAMMA II ETAPA 2\",\"\",IF($D$20=\"CELTA\",\"\",IF($D$20=\"STA ROSA (Nave)\",\"\",\"\")))))))))","v":""},null,{"$f":"SIMULADOR!J28","v":37},null,null,{"$f":"SIMULADOR!K28","v":120},{"$f":"SIMULADOR!L28","v":60785.389500428922},null,{"$f":"SIMULADOR!N28","v":68565.919356483821}]
[]
[null,"FECHA DE APARTADO",null,null,"2025-01-15","2023-03-05"]
[null,"PROMOCIÓN:"]
[null,{"$f":"SIMULADOR!E46","v":"EL GRAN FIN: VIGENCIA 30 DE NOVIEMNRE 2024"}]
[]
[null,"ACUERDOS ADICIONALES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"VO. BO. AUTORIZA"]

{"sheet":"SIMULADOR","index":1,"n_rows":173,"n_cols":17,"rows_kept":173,"cut":false,"hidden":false,"merged":[[4,11,4,13],[6,11,6,13],[66,2,72,2],[7,12,7,13],[47,4,47,13],[25,4,25,5],[19,4,19,5],[44,4,44,13],[45,4,45,13],[46,4,46,13],[38,4,41,8],[8,12,8,13],[8,7,8,8],[7,7,7,8]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ACTUALIZACIÓN 08-01-2025"]
[]
[null,null,null,null,null,null,null,null,null,null,"FECHA DE COTIZACIÓN "]
[null,null,null,null,null,null,"CLIENTE:",null,null,null,null,"REFERENCIA:",{"$f":"F14&H9&F13","v":"15SUR_57B"}]
[null,null,null,null,null,null,"PARQUE:","SUR_57",null,{"$f":"IF(H9=\"AEROPUERTO (NAVE)\",\"AEROPUERTO\",IF(H9=\"AEROPUERTO (LOTE)\",\"AEROPUERTO\",IF(H9=\"CELTA\",\"CELTA\",IF(H9=\"GAMMA II ETAPA 2\",\"GAMMA_II\",IF(H9=\"CALAMANDA (NAVE)\",\"CALAMANDA\",IF(H9=\"CALAMANDA (LOCAL)\",\"CALAMANDA\",IF(H9=\"SUR_57\",\"SUR_57.\",\"\")))))))","v":"SUR_57."}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$14=\"LOTE\",0%,IF($E$14=\"NAVE\",12.8%,IF($E$14=\"LOCAL\",12.8%,\"\")))","v":0.128}]
[]
[null,null,null,null,null,null,null,null,null,"IMPORTES:","SUBTOTAL","IVA","IMPORTE TOTAL","DESCUENTO"]
[null,null,null,null,"Módulo:","B",null,null,null,null,{"$f":"IF(Q17>\"0\",K18-K19,\"\")","v":""}]
[null,null,null,null,{"$f":"IF($H$9=\"AEROPUERTO (Lote)\",\"LOTE\",IF($H$9=\"AEROPUERTO (Nave)\",\"NAVE\",IF($H$9=\"PEDRO ESCOBEDO (Nave)\",\"NAVE\",IF($H$9=\"PEDRO ESCOBEDO (Lote)\",\"LOTE\",IF($H$9=\"SAN LUIS POTOSI (Nave)\",\"NAVE\",IF($H$9=\"SAN LUIS POTOSI (Lote)\",\"LOTE\",IF($H$9=\"GAMMA II ETAPA 1\",\"NAVE\",IF($H$9=\"GAMMA II ETAPA 2\",\"NAVE\",IF($H$9=\"CELTA\",\"LOTE\",IF($H$9=\"STA ROSA (Nave)\",\"NAVE\",IF($H$9=\"CALAMANDA (NAVE)\",\"NAVE\",IF($H$9=\"CALAMANDA (LOCAL)\",\"LOCAL\",IF($H$9=\"SUR_57\",\"NAVE\",\"\")))))))))))))","v":"NAVE"},15,null,null,null,"Precio de Lista:",{"$f":"F15*F17","v":5914428},{"$f":"IF(OR($L$10=0%,$L$10=\"\"),\"\",K14*($L$10))","v":757046.78399999999},{"$f":"SUM(K14:L14)","v":6671474.784}]
[null,null,null,null,"M2",400,null,null,null,"Descuento: ",{"$f":"IF(AND(H9=\"CALAMANDA (LOCAL)\",F13=\"A\"),80000,IF(AND(H9=\"CALAMANDA (LOCAL)\",F13=\"B\"),70000,(K14*N15)))","v":887164.2},{"$f":"IF(OR($L$10=0%,$L$10=\"\"),\"\",K15*($L$10))","v":113557.01759999999},{"$f":"SUM(K15:L15)","v":1000721.2176},0.15]
[null,null,null,null,"TIPO:","ESTANDAR",null,null,null,null,null,0,null,null,null,null,{"$f":"$N$18","v":0.3}]
[null,null,null,null,"P.u Lista:",14786.07,null,null,null,"Importe de Operación:",{"$f":"K14-K15-K16","v":5027263.8},643489.76639999996,5670753.5663999999,null,680095.28]
[null,null,null,null,"P.u Descuento:",{"$f":"F17-(F17*N15)","v":12568.1595},null,null,null,"Enganche: ",{"$f":"$K$17*$N$18","v":1508179.14},193046.92992,1701226.0699199999,{"$f":"IF($H$9=\"AEROPUERTO (Lote)\",10%,IF($H$9=\"AEROPUERTO (Nave)\",30%,IF($H$9=\"PEDRO ESCOBEDO (Nave)\",30%,IF($H$9=\"PEDRO ESCOBEDO (Lote)\",30%,IF($H$9=\"GAMMA II ETAPA 1\",30%,IF($H$9=\"GAMMA II ETAPA 2\",20%,IF($H$9=\"CELTA\",30%,IF($H$9=\"STA ROSA (NAve)\",50%,IF($H$9=\"CALAMANDA (NAve)\",30%,IF($H$9=\"CALAMANDA (LOCAL)\",30%,IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 1\"),10%,IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 2\"),30%,IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 3\"),30%,\"\")))))))))))))","v":0.3},{"$f":"O17/K14","v":0.11498918914897603}]
[null,null,null,null,null,null,null,null,null,"Descuento en el Enganche:",{"$f":"IF($H$9=\"AEROPUERTO (Lote)\",K18*0.1*N19,IF($H$9=\"AEROPUERTO (Nave)\",K17*0.1*N19,IF($H$9=\"PEDRO ESCOBEDO (Nave)\",K17*0*N19,IF($H$9=\"PEDRO ESCOBEDO (Lote)\",K17*0*N19,IF($H$9=\"GAMMA II ETAPA 1\",K17*0*N19,IF($H$9=\"GAMMA II ETAPA 2\",K17*0*N19,IF($H$9=\"CELTA\",K17*0.1*N19,IF($H$9=\"CALAMANDA (NAVE)\",K17*0.1*N19,IF($H$9=\"CALAMANDA (LOCAL)\",K17*0*N19,IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 1\"),K17*0*N19,IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 2\"),K17*0*N19,IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 3\"),K17*0*N19,\"\"))))))))))))","v":0},0,0]
[null,null,null,null,"FINANCIAMIENTO:",null,"FINANCIAMIENTO 3",null,null,"Enganche extra",{"$f":"IF(Q17>K18,Q17-(K18-K19),\"0\")","v":"0"},0,0]
[null,null,null,null,null,null,null,null,null,"ENGANCHE A PAGAR:",{"$f":"K18-K19+K20","v":1508179.14},193046.92992,1701226.0699199999,{"$f":"K21/K17","v":0.3}]
[null,null,null,null,null,null,{"$f":"H22/12","v":10},{"$f":"IF($H$9=\"AEROPUERTO (Lote)\",36,IF($H$9=\"AEROPUERTO (Nave)\",36,IF($H$9=\"PEDRO ESCOBEDO (Nave)\",60,IF($H$9=\"PEDRO ESCOBEDO (Lote)\",60,IF($H$9=\"GAMMA II ETAPA 1\",18,IF($H$9=\"GAMMA II ETAPA 2\",6,IF($H$9=\"CELTA\",60,IF($H$9=\"STA ROSA (Nave)\",10,IF($H$9=\"CALAMANDA (NAVE)\",60,IF(AND(SIMULADOR!H9=\"CALAMANDA (LOCAL)\",SIMULADOR!F13=\"B\"),36,IF(AND(SIMULADOR!H9=\"CALAMANDA (LOCAL)\",SIMULADOR!F13=\"A\"),24,IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 1\"),36,IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 2\"),60,IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 3\"),120,\"\"))))))))))))))","v":120},null,"TOTAL A PAGAR:",{"$f":"SUM(K21+K23)","v":5027263.8},643489.76639999996,5670753.5663999999]
[null,null,null,null,1,{"$f":"G23","v":36},{"$f":"IF($H$9=\"AEROPUERTO (NAVE)\",18,IF($H$9=\"AEROPUERTO (Lote)\",18,IF($H$9=\"PEDRO ESCOBEDO (Nave)\",24,IF($H$9=\"PEDRO ESCOBEDO (Lote)\",24,IF($H$9=\"GAMMA II ETAPA 1\",6,IF($H$9=\"GAMMA II ETAPA 2\",6,IF($H$9=\"CELTA\",36,IF($H$9=\"STA ROSA (Nave)\",4,IF(AND(SIMULADOR!H9=\"CALAMANDA (NAVE)\",G20=\"FINANCIAMIENTO 1\"),36,IF(AND(SIMULADOR!H9=\"CALAMANDA (NAVE)\",G20=\"FINANCIAMIENTO 2\"),24,IF(AND(SIMULADOR!H9=\"CALAMANDA (LOCAL)\",SIMULADOR!F13=\"B\"),36,IF(AND(SIMULADOR!H9=\"CALAMANDA (LOCAL)\",SIMULADOR!F13=\"A\"),24,IF(SIMULADOR!H9=\"SUR_57\",36,\"\")))))))))))))","v":36},0,null,"IMPORTE A FINANCIAR:",{"$f":"K17-$K$18-K20","v":3519084.66},450442.83648000006,3969527.4964800002]
[null,null,null,null,{"$f":"F23+1","v":37},{"$f":"H22","v":120},{"$f":"IF($H$9=\"AEROPUERTO (lote)\",18,IF($H$9=\"AEROPUERTO (Nave)\",18,IF($H$9=\"PEDRO ESCOBEDO (Nave)\",36,IF($H$9=\"PEDRO ESCOBEDO (Lote)\",36,IF($H$9=\"GAMMA II ETAPA 1\",12,IF($H$9=\"GAMMA II ETAPA 2\",0,IF($H$9=\"CELTA\",24,IF($H$9=\"STA ROSA (Nave)\",6,IF(AND(SIMULADOR!H9=\"CALAMANDA (NAVE)\",G20=\"FINANCIAMIENTO 1\"),24,IF(AND(SIMULADOR!H9=\"CALAMANDA (NAVE)\",G20=\"FINANCIAMIENTO 2\"),36,IF($H$9=\"CALAMANDA (LOCAL)\",\"\",IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 1\"),\"\",IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 2\"),24,IF(AND(SIMULADOR!H9=\"SUR_57\",G20=\"FINANCIAMIENTO 3\"),84,\"\"))))))))))))))","v":84},{"$f":"IF($E$14=\"LOTE\",2%,IF($E$14=\"NAVE\",2%,\"\"))","v":0.02}]
[null,null,null,null,null,null,null,null,null,"MENSUALIDADES:",null,"SUBTOTAL","IVA","IMPORTE TOTAL"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"E23","v":1},{"$f":"G23","v":36},{"$f":"IF($L$10=12.8%,(N27/1.128),IF($M$27=\"\",_xludf.AGGREGATE(9,6,M27:N27)))","v":29325.705500000004},{"$f":"IF($L$10=12.8%,N27-(N27/1.128),\"\")","v":3753.6903039999961},{"$f":"IFERROR(-PMT(H23,$H$22,O27),0)","v":33079.395804},{"$f":"M23","v":3969527.4964800002}]
[null,null,null,null,null,null,null,null,null,{"$f":"E24","v":37},{"$f":"H22","v":120},{"$f":"IF($L$10=12.8%,(N28/1.128),IF($M$27=\"\",_xludf.AGGREGATE(9,6,M28:N28)))","v":60785.389500428922},{"$f":"IF($L$10=12.8%,N28-(N28/1.128),\"\")","v":7780.5298560548981},{"$f":"IFERROR(-PMT(H24,$H$22-G23,O28),0)","v":68565.919356483821},{"$f":"IF(H23=0,O27-(G23*N27),O27-(-CUMPRINC(H23,H22,O27,1,G23,0)))","v":2778669.2475360003}]
[]
[null,null,null,null,"Documentación Requerida:",null,"Moral:",null,null,{"$f":"IF(J37=\"ENGANCHE DIFERIDO:\",\"MENSUALIDAD + ENGANCHE\",\"\")","v":"MENSUALIDAD + ENGANCHE"},null,{"$f":"IF(J37=\"ENGANCHE DIFERIDO:\",\"SUBTOTAL\",\"\")","v":"SUBTOTAL"},{"$f":"IF(J37=\"ENGANCHE DIFERIDO:\",\"IVA\",\"\")","v":"IVA"},{"$f":"IF(J37=\"ENGANCHE DIFERIDO:\",\"IMPORTE TOTAL\",\"\")","v":"IMPORTE TOTAL"}]
[null,null,null,null,"Física.",null,"*Identificación oficial del representante legal vigente."]
[null,null,null,null,"*Identificación oficial vigente.",null,"*Acta de nacimiento del representante legal.",null,null,null,{"$f":"IF(AND($K$37=\"NAVE-CDA 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),12,IF(AND($K$37=\"GMA II 20%,15%,15%\",J37=\"ENGANCHE DIFERIDO:\"),2,IF(AND($K$37=\"NAVE-CALAMANDA 15%,10%,5%\",J37=\"ENGANCHE DIFERIDO:\"),12,IF(AND($K$37=\"LOTE-AE,CELTA, 10%,10%,10%\",J37=\"ENGANCHE DIFERIDO:\"),12,IF(AND($K$37=\"LOCAL B CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),12,IF(AND($K$37=\"LOCAL A CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),12,IF(AND($K$37=\"NAVE-AE 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),6,\"\")))))))","v":12},{"$f":"IF($L$10=12.8%,(N32/1.128),IF($M$27=\"\",_xludf.AGGREGATE(9,6,M32:N32)))","v":532052.08550000004},{"$f":"IF($L$10=12.8%,N32-(N32/1.128),\"\")","v":68102.666943999939},{"$f":"VLOOKUP(K32,SIMULADOR!$E$49:$M$172,4,0)+N40","v":600154.75244399998}]
[null,null,null,null,"*Acta de nacimiento.",null,"*Acta constitutiva"]
[null,null,null,null,"*Acta de matrimonio ( en caso de ser casado).",null,"*Constancia de situacón fiscal empre y representante legal",null,null,null,{"$f":"IF(AND($K$37=\"NAVE-CDA 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),24,IF(AND($K$37=\"GMA II 20%,15%,15%\",J37=\"ENGANCHE DIFERIDO:\"),3,IF(AND($K$37=\"GMA II 10%,10%,10%\",J37=\"ENGANCHE DIFERIDO:\"),3,IF(AND($K$37=\"NAVE-CALAMANDA 15%,10%,5%\",J37=\"ENGANCHE DIFERIDO:\"),24,IF(AND($K$37=\"LOTE-AE,CELTA, 10%,10%,10%\",J37=\"ENGANCHE DIFERIDO:\"),24,IF(AND($K$37=\"LOCAL A CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),20,IF(AND($K$37=\"LOCAL B CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),24,IF(AND($K$37=\"NAVE-AE 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),12,\"\"))))))))","v":24},{"$f":"IF($L$10=12.8%,(N34/1.128),IF($M$27=\"\",_xludf.AGGREGATE(9,6,M34:N34)))","v":532052.08550000004},68102.666943999939,{"$f":"VLOOKUP(K34,SIMULADOR!$E$49:$M$172,4,0)+N41","v":600154.75244399998}]
[null,null,null,null,"*Constancia de situación fiscal",null,"*CURP del representante legal"]
[null,null,null,null,"*CURP .",null,"*Comprobante de Domicilio (Empresa y Representante legal)."]
[null,null,null,null,"*Comprobante de domicilio",null,"*Poder en el que ostenta las facultades otorgadas al representante legal",null,null,"ENGANCHE DIFERIDO:",{"$f":"IF(J37=\"N/A\",\"\",IF(AND(H9=DATOS!D20,F13=\"A\"),DATOS!D33,IF(AND(H9=DATOS!D20,F13=\"B\"),DATOS!D34,IF(H9=DATOS!D15,DATOS!D32,IF(H9=DATOS!D16,DATOS!D35,IF(H9=DATOS!D17,DATOS!D32,IF(H9=DATOS!D18,DATOS!D35,IF(H9=DATOS!D23,DATOS!D31,IF(H9=DATOS!D22,DATOS!D32,IF(H9=DATOS!D19,DATOS!D31,IF(AND(H9=DATOS!D21,SIMULADOR!G20=\"FINANCIAMIENTO 2\"),DATOS!D31,IF(AND(H9=DATOS!D21,SIMULADOR!G20=\"FINANCIAMIENTO 3\"),DATOS!D31,\"\"))))))))))))","v":"NAVE-CDA 10%,10% 10%"},{"$f":"IF(J37=\"ENGANCHE DIFERIDO:\",\"SUBTOTAL\",\"\")","v":"SUBTOTAL"},{"$f":"IF(J37=\"ENGANCHE DIFERIDO:\",\"IVA\",\"\")","v":"IVA"},{"$f":"IF(J37=\"ENGANCHE DIFERIDO:\",\"IMPORTE TOTAL\",\"\")","v":"IMPORTE TOTAL"}]
[]
[null,null,null,null,"* En caso de estar CASADOS por sociedad conyugal o COOPROPIEDAD, \n anexar toda la documentacion mencionada de ambas partes. ",null,null,null,null,{"$f":"IF(AND($K$37=\"NAVE-CDA 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"LOTE-AE,CELTA, 10%,10%,10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"NAVE-AE,SLP 20%,5%,5%\",J37=\"ENGANCHE DIFERIDO:\"),20%,IF(AND($K$37=\"GMA II 20%,15%,15%\",J37=\"ENGANCHE DIFERIDO:\"),20%,IF(AND($K$37=\"NAVE-CALAMANDA 15%,10%,5%\",J37=\"ENGANCHE DIFERIDO:\"),15%,IF(AND($K$37=\"LOCAL A CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"LOCAL B CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"NAVE-AE 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,\"\"))))))))","v":0.1},{"$f":"IF(J37=\"ENGANCHE DIFERIDO:\",\"PAGO INMEDIATO\",\"\")","v":"PAGO INMEDIATO"},{"$f":"(K17*J39)-K19","v":502726.38},{"$f":"IF(OR($L$10=0%,$L$10=\"\"),\"\",L39*($L$10))","v":64348.976640000001},{"$f":"SUM(L39:M39)","v":567075.35664000001}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($K$37=\"NAVE-CDA 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"LOTE-AE,CELTA, 10%,10%,10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"GMA II 20%,15%,15%\",J37=\"ENGANCHE DIFERIDO:\"),15%,IF(AND($K$37=\"NAVE-CALAMANDA 15%,10%,5%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"LOCAL A CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"LOCAL B CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"NAVE-AE 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,\"\")))))))","v":0.1},{"$f":"IF(AND($K$37=\"NAVE-CDA 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),12,IF(AND($K$37=\"LOTE-AE,CELTA, 10%,10%,10%\",J37=\"ENGANCHE DIFERIDO:\"),12,IF(AND($K$37=\"GMA II 20%,15%,15%\",J37=\"ENGANCHE DIFERIDO:\"),2,IF(AND($K$37=\"NAVE-CALAMANDA 15%,10%,5%\",J37=\"ENGANCHE DIFERIDO:\"),12,IF(AND($K$37=\"LOCAL A CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),12,IF(AND($K$37=\"LOCAL B CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),12,IF(AND($K$37=\"NAVE-AE 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),6,\"\")))))))","v":12},{"$f":"K17*J40","v":502726.38},{"$f":"IF(OR($L$10=0%,$L$10=\"\"),\"\",L40*($L$10))","v":64348.976640000001},567075.35664000001]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($K$37=\"NAVE-CDA 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"LOTE-AE,CELTA, 10%,10%,10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"GMA II 20%,15%,15%\",J37=\"ENGANCHE DIFERIDO:\"),15%,IF(AND($K$37=\"NAVE-CALAMANDA 15%,10%,5%\",J37=\"ENGANCHE DIFERIDO:\"),5%,IF(AND($K$37=\"LOCAL A CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"LOCAL B CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,IF(AND($K$37=\"NAVE-AE 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),10%,\"\")))))))","v":0.1},{"$f":"IF(AND($K$37=\"NAVE-CDA 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),24,IF(AND($K$37=\"LOTE-AE,CELTA, 10%,10%,10%\",J37=\"ENGANCHE DIFERIDO:\"),20,IF(AND($K$37=\"GMA II 20%,15%,15%\",J37=\"ENGANCHE DIFERIDO:\"),3,IF(AND($K$37=\"NAVE-CALAMANDA 15%,10%,5%\",J37=\"ENGANCHE DIFERIDO:\"),24,IF(AND($K$37=\"LOCAL A CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),20,IF(AND($K$37=\"LOCAL B CDA 10%, 10%, 10%\",J37=\"ENGANCHE DIFERIDO:\"),24,IF(AND($K$37=\"NAVE-AE 10%,10% 10%\",J37=\"ENGANCHE DIFERIDO:\"),12,\"\")))))))","v":24},{"$f":"K17*J41","v":502726.38},{"$f":"IF(OR($L$10=0%,$L$10=\"\"),\"\",L41*($L$10))","v":64348.976640000001},567075.35664000001]
[]
[]
[]
[null,null,null,null,"PROMOCION"]
[null,null,null,null,"EL GRAN FIN: VIGENCIA 30 DE NOVIEMNRE 2024"]
[null,null,null,null,"Precios Sujetos a cambio sin sin previo  aviso."]
[null,null,null,null,"DESGLOSE DE FINANCIAMIENTO A MESES SIN INTERESES"]
[null,null,null,null,"PERIODO","FECHA","SALDO INICIAL","MENSUALIDAD","ABONOS","PAGADO","INTERÉS","ABONO A CAPITAL","SALDO FINAL","%INTERES"]
[null,null,null,null,1,{"$f":"IF(DAY('RESUMEN EJECUTIVO'!E44)>5,DATE(YEAR('RESUMEN EJECUTIVO'!E35),MONTH(EDATE('RESUMEN EJECUTIVO'!E44,2)),5),EDATE('RESUMEN EJECUTIVO'!E44,1))","v":"2025-03-05"},{"$f":"$O$27","v":3969527.4964800002},{"$f":"IF($G50>IF($E50<=$G$23,$N$27,IF($E50<=$G$24+$G$23,$N$28,\"\")),IF($E50<=$G$23,$N$27,IF($E50<=$G$24+$G$23,$N$28,\"\")),$G50+$K50)","v":33079.395804},null,{"$f":"SUM(H50:I50)","v":33079.395804},{"$f":"G50*N50","v":0},{"$f":"J50-K50","v":33079.395804},{"$f":"G50-L50","v":3936448.1006760001},{"$f":"IF($E50<=$G$23,$H$23,IF($E50<=$G$24+$G$23,$H$24,\"\"))","v":0}]
[null,null,null,null,{"$f":"IF(E50<$H$22,E50+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":2},{"$f":"EDATE($F$50,E50)","v":"2025-04-05"},{"$f":"M50","v":3936448.1006760001},{"$f":"IF($G51>IF($E51<=$G$23,$N$27,IF($E51<=$G$24+$G$23,$N$28,\"\")),IF($E51<=$G$23,$N$27,IF($E51<=$G$24+$G$23,$N$28,\"\")),$G51+$K51)","v":33079.395804},null,{"$f":"SUM(H51:I51)","v":33079.395804},{"$f":"G51*N51","v":0},{"$f":"J51-K51","v":33079.395804},{"$f":"G51-L51","v":3903368.704872},{"$f":"IF($E51<=$G$23,$H$23,IF($E51<=$G$24+$G$23,$H$24,\"\"))","v":0}]
[null,null,null,null,{"$f":"IF(E51<$H$22,E51+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":3},{"$f":"EDATE($F$50,E51)","v":"2025-05-05"},{"$f":"M51","v":3903368.704872},33079.395804,null,33079.395804,0,33079.395804,3870289.3090679999,0]
[null,null,null,null,{"$f":"IF(E52<$H$22,E52+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":4},"2025-06-05",3870289.3090679999,33079.395804,null,33079.395804,0,33079.395804,3837209.9132639999,0]
[null,null,null,null,{"$f":"IF(E53<$H$22,E53+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":5},"2025-07-05",3837209.9132639999,33079.395804,null,33079.395804,0,33079.395804,3804130.5174599998,0]
[null,null,null,null,{"$f":"IF(E54<$H$22,E54+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":6},"2025-08-05",3804130.5174599998,33079.395804,null,33079.395804,0,33079.395804,3771051.1216559997,0]
[null,null,null,null,{"$f":"IF(E55<$H$22,E55+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":7},"2025-09-05",3771051.1216559997,33079.395804,null,33079.395804,0,33079.395804,3737971.7258519996,0]
[null,null,null,null,{"$f":"IF(E56<$H$22,E56+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":8},"2025-10-05",3737971.7258519996,33079.395804,null,33079.395804,0,33079.395804,3704892.3300479995,0]
[null,null,null,null,{"$f":"IF(E57<$H$22,E57+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":9},"2025-11-05",3704892.3300479995,33079.395804,null,33079.395804,0,33079.395804,3671812.9342439994,0]
[null,null,null,null,{"$f":"IF(E58<$H$22,E58+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":10},"2025-12-05",3671812.9342439994,33079.395804,null,33079.395804,0,33079.395804,3638733.5384399993,0]
[null,null,null,null,{"$f":"IF(E59<$H$22,E59+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":11},"2026-01-05",3638733.5384399993,33079.395804,null,33079.395804,0,33079.395804,3605654.1426359992,0]
[null,null,null,null,{"$f":"IF(E60<$H$22,E60+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":12},"2026-02-05",3605654.1426359992,33079.395804,null,33079.395804,0,33079.395804,3572574.7468319992,0]
[null,null,null,null,{"$f":"IF(E61<$H$22,E61+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":13},"2026-03-05",3572574.7468319992,33079.395804,null,33079.395804,0,33079.395804,3539495.3510279991,0]
[null,null,null,null,{"$f":"IF(E62<$H$22,E62+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":14},"2026-04-05",3539495.3510279991,33079.395804,null,33079.395804,0,33079.395804,3506415.955223999,0]
[null,null,null,null,{"$f":"IF(E63<$H$22,E63+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":15},"2026-05-05",3506415.955223999,33079.395804,null,33079.395804,0,33079.395804,3473336.5594199989,0]
[null,null,null,null,{"$f":"IF(E64<$H$22,E64+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":16},"2026-06-05",3473336.5594199989,33079.395804,null,33079.395804,{"$f":"G65*N65","v":0},33079.395804,3440257.1636159988,0]
[null,null,null,null,{"$f":"IF(E65<$H$22,E65+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":17},"2026-07-05",3440257.1636159988,33079.395804,null,33079.395804,0,33079.395804,3407177.7678119987,0]
[null,null,null,null,{"$f":"IF(E66<$H$22,E66+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":18},"2026-08-05",3407177.7678119987,33079.395804,null,33079.395804,0,33079.395804,3374098.3720079986,0]
[null,null,null,null,{"$f":"IF(E67<$H$22,E67+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":19},"2026-09-05",3374098.3720079986,33079.395804,null,33079.395804,0,33079.395804,3341018.9762039986,0]
[null,null,null,null,{"$f":"IF(E68<$H$22,E68+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":20},"2026-10-05",3341018.9762039986,33079.395804,null,33079.395804,0,33079.395804,3307939.5803999985,0]
[null,null,null,null,{"$f":"IF(E69<$H$22,E69+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":21},"2026-11-05",3307939.5803999985,33079.395804,null,33079.395804,0,33079.395804,3274860.1845959984,0]
[null,null,null,null,{"$f":"IF(E70<$H$22,E70+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":22},"2026-12-05",3274860.1845959984,33079.395804,null,33079.395804,0,33079.395804,3241780.7887919983,0]
[null,null,null,null,{"$f":"IF(E71<$H$22,E71+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":23},"2027-01-05",3241780.7887919983,33079.395804,null,33079.395804,0,33079.395804,3208701.3929879982,0]
[null,null,null,null,{"$f":"IF(E72<$H$22,E72+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":24},"2027-02-05",3208701.3929879982,33079.395804,null,33079.395804,{"$f":"G73*N73","v":0},33079.395804,3175621.9971839981,0]
[null,null,null,null,{"$f":"IF(E73<$H$22,E73+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":25},"2027-03-05",3175621.9971839981,33079.395804,null,33079.395804,0,33079.395804,3142542.601379998,0]
[null,null,null,null,{"$f":"IF(E74<$H$22,E74+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":26},"2027-04-05",3142542.601379998,33079.395804,null,33079.395804,0,33079.395804,3109463.2055759979,0]
[null,null,null,null,{"$f":"IF(E75<$H$22,E75+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":27},"2027-05-05",3109463.2055759979,33079.395804,null,33079.395804,0,33079.395804,3076383.8097719979,0]
[null,null,null,null,{"$f":"IF(E76<$H$22,E76+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":28},"2027-06-05",3076383.8097719979,33079.395804,null,33079.395804,0,33079.395804,3043304.4139679978,0]
[null,null,null,null,{"$f":"IF(E77<$H$22,E77+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":29},"2027-07-05",3043304.4139679978,33079.395804,null,33079.395804,0,33079.395804,3010225.0181639977,0]
[null,null,null,null,{"$f":"IF(E78<$H$22,E78+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":30},"2027-08-05",3010225.0181639977,33079.395804,null,33079.395804,0,33079.395804,2977145.6223599976,0]
[null,null,null,null,{"$f":"IF(E79<$H$22,E79+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":31},"2027-09-05",2977145.6223599976,33079.395804,null,33079.395804,0,33079.395804,2944066.2265559975,0]
[null,null,null,null,{"$f":"IF(E80<$H$22,E80+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":32},"2027-10-05",2944066.2265559975,33079.395804,null,33079.395804,0,33079.395804,2910986.8307519974,0]
[null,null,null,null,{"$f":"IF(E81<$H$22,E81+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":33},"2027-11-05",2910986.8307519974,33079.395804,null,33079.395804,0,33079.395804,2877907.4349479973,0]
[null,null,null,null,{"$f":"IF(E82<$H$22,E82+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":34},"2027-12-05",2877907.4349479973,33079.395804,null,33079.395804,0,33079.395804,2844828.0391439972,0]
[null,null,null,null,{"$f":"IF(E83<$H$22,E83+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":35},"2028-01-05",2844828.0391439972,33079.395804,null,33079.395804,0,33079.395804,2811748.6433399972,0]
[null,null,null,null,{"$f":"IF(E84<$H$22,E84+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":36},"2028-02-05",2811748.6433399972,33079.395804,null,33079.395804,0,33079.395804,2778669.2475359971,0]
[null,null,null,null,{"$f":"IF(E85<$H$22,E85+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":37},"2028-03-05",2778669.2475359971,68565.919356483821,null,68565.919356483821,55573.384950719941,12992.534405763879,2765676.7131302333,0.02]
[null,null,null,null,{"$f":"IF(E86<$H$22,E86+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":38},"2028-04-05",2765676.7131302333,68565.919356483821,null,68565.919356483821,55313.534262604669,13252.385093879151,2752424.3280363544,0.02]
[null,null,null,null,{"$f":"IF(E87<$H$22,E87+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":39},"2028-05-05",2752424.3280363544,68565.919356483821,null,68565.919356483821,{"$f":"G88*N88","v":55048.486560727091},13517.432795756729,2738906.8952405974,0.02]
[null,null,null,null,{"$f":"IF(E88<$H$22,E88+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":40},"2028-06-05",2738906.8952405974,68565.919356483821,null,68565.919356483821,{"$f":"G89*N89","v":54778.137904811949},13787.781451671872,2725119.1137889256,0.02]
[null,null,null,null,{"$f":"IF(E89<$H$22,E89+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":41},"2028-07-05",2725119.1137889256,68565.919356483821,null,68565.919356483821,{"$f":"G90*N90","v":54502.382275778509},14063.537080705311,2711055.5767082204,0.02]
[null,null,null,null,{"$f":"IF(E90<$H$22,E90+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":42},"2028-08-05",2711055.5767082204,68565.919356483821,null,68565.919356483821,54221.111534164411,14344.80782231941,2696710.7688859012,0.02]
[null,null,null,null,{"$f":"IF(E91<$H$22,E91+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":43},"2028-09-05",2696710.7688859012,68565.919356483821,null,68565.919356483821,53934.215377718028,14631.703978765792,2682079.0649071354,0.02]
[null,null,null,null,{"$f":"IF(E92<$H$22,E92+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":44},"2028-10-05",2682079.0649071354,68565.919356483821,null,68565.919356483821,53641.581298142708,14924.338058341113,2667154.7268487941,0.02]
[null,null,null,null,{"$f":"IF(E93<$H$22,E93+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":45},"2028-11-05",2667154.7268487941,68565.919356483821,null,68565.919356483821,53343.094536975885,15222.824819507936,2651931.9020292861,0.02]
[null,null,null,null,{"$f":"IF(E94<$H$22,E94+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":46},"2028-12-05",2651931.9020292861,68565.919356483821,null,68565.919356483821,53038.638040585727,15527.281315898093,2636404.6207133881,0.02]
[null,null,null,null,{"$f":"IF(E95<$H$22,E95+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":47},"2029-01-05",2636404.6207133881,68565.919356483821,null,68565.919356483821,52728.092414267761,15837.826942216059,2620566.7937711719,0.02]
[null,null,null,null,{"$f":"IF(E96<$H$22,E96+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":48},"2029-02-05",2620566.7937711719,68565.919356483821,null,68565.919356483821,52411.335875423443,16154.583481060377,2604412.2102901116,0.02]
[null,null,null,null,{"$f":"IF(E97<$H$22,E97+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":49},"2029-03-05",2604412.2102901116,68565.919356483821,null,68565.919356483821,52088.244205802235,16477.675150681585,2587934.5351394298,0.02]
[null,null,null,null,{"$f":"IF(E98<$H$22,E98+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":50},"2029-04-05",2587934.5351394298,68565.919356483821,null,68565.919356483821,51758.690702788597,16807.228653695223,2571127.3064857344,0.02]
[null,null,null,null,{"$f":"IF(E99<$H$22,E99+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":51},"2029-05-05",2571127.3064857344,68565.919356483821,null,68565.919356483821,51422.54612971469,17143.37322676913,2553983.9332589651,0.02]
[null,null,null,null,{"$f":"IF(E100<$H$22,E100+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":52},"2029-06-05",2553983.9332589651,68565.919356483821,null,68565.919356483821,{"$f":"G101*N101","v":51079.678665179301},17486.24069130452,2536497.6925676605,0.02]
[null,null,null,null,{"$f":"IF(E101<$H$22,E101+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":53},"2029-07-05",2536497.6925676605,68565.919356483821,null,68565.919356483821,{"$f":"G102*N102","v":50729.95385135321},17835.965505130611,2518661.7270625299,0.02]
[null,null,null,null,{"$f":"IF(E102<$H$22,E102+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":54},"2029-08-05",2518661.7270625299,68565.919356483821,null,68565.919356483821,50373.234541250597,18192.684815233224,2500469.0422472968,0.02]
[null,null,null,null,{"$f":"IF(E103<$H$22,E103+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":55},"2029-09-05",2500469.0422472968,68565.919356483821,null,68565.919356483821,50009.380844945939,18556.538511537881,2481912.5037357588,0.02]
[null,null,null,null,{"$f":"IF(E104<$H$22,E104+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":56},"2029-10-05",2481912.5037357588,68565.919356483821,null,68565.919356483821,49638.250074715179,18927.669281768642,2462984.8344539902,0.02]
[null,null,null,null,{"$f":"IF(E105<$H$22,E105+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":57},"2029-11-05",2462984.8344539902,68565.919356483821,null,68565.919356483821,49259.696689079807,19306.222667404014,2443678.6117865862,0.02]
[null,null,null,null,{"$f":"IF(E106<$H$22,E106+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":58},"2029-12-05",2443678.6117865862,68565.919356483821,null,68565.919356483821,48873.572235731728,19692.347120752092,2423986.2646658341,0.02]
[null,null,null,null,{"$f":"IF(E107<$H$22,E107+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":59},"2030-01-05",2423986.2646658341,68565.919356483821,null,68565.919356483821,48479.725293316682,20086.194063167139,2403900.0706026671,0.02]
[null,null,null,null,{"$f":"IF(E108<$H$22,E108+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":60},"2030-02-05",2403900.0706026671,68565.919356483821,null,68565.919356483821,48078.001412053345,20487.917944430475,2383412.1526582367,0.02]
[null,null,null,null,{"$f":"IF(E109<$H$22,E109+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":61},{"$f":"EDATE($F$50,E109)","v":"2030-03-05"},2383412.1526582367,68565.919356483821,null,68565.919356483821,47668.243053164733,20897.676303319087,2362514.4763549175,0.02]
[null,null,null,null,{"$f":"IF(E110<$H$22,E110+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":62},"2030-04-05",2362514.4763549175,68565.919356483821,null,68565.919356483821,47250.28952709835,21315.629829385471,2341198.8465255322,0.02]
[null,null,null,null,{"$f":"IF(E111<$H$22,E111+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":63},"2030-05-05",2341198.8465255322,68565.919356483821,null,68565.919356483821,46823.976930510646,21741.942425973175,2319456.9040995589,0.02]
[null,null,null,null,{"$f":"IF(E112<$H$22,E112+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":64},"2030-06-05",2319456.9040995589,68565.919356483821,null,68565.919356483821,46389.138081991179,22176.781274492641,2297280.1228250661,0.02]
[null,null,null,null,{"$f":"IF(E113<$H$22,E113+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":65},"2030-07-05",2297280.1228250661,68565.919356483821,null,68565.919356483821,45945.602456501321,22620.316899982499,2274659.8059250838,0.02]
[null,null,null,null,{"$f":"IF(E114<$H$22,E114+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":66},"2030-08-05",2274659.8059250838,{"$f":"IF($G115>IF($E115<=$G$23,$N$27,IF($E115<=$G$24+$G$23,$N$28,\"\")),IF($E115<=$G$23,$N$27,IF($E115<=$G$24+$G$23,$N$28,\"\")),$G115+$K115)","v":68565.919356483821},null,{"$f":"SUM(H115:I115)","v":68565.919356483821},45493.196118501677,{"$f":"J115-K115","v":23072.723237982143},{"$f":"G115-L115","v":2251587.0826871018},{"$f":"IF($E115<=$G$23,$H$23,IF($E115<=$G$24+$G$23,$H$24,\"\"))","v":0.02}]
[null,null,null,null,{"$f":"IF(E115<$H$22,E115+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":67},{"$f":"EDATE($F$50,E115)","v":"2030-09-05"},{"$f":"M115","v":2251587.0826871018},68565.919356483821,null,68565.919356483821,{"$f":"G116*N116","v":45031.741653742036},23534.177702741785,2228052.9049843601,0.02]
[null,null,null,null,{"$f":"IF(E116<$H$22,E116+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":68},"2030-10-05",2228052.9049843601,68565.919356483821,null,68565.919356483821,{"$f":"G117*N117","v":44561.058099687201},24004.861256796619,2204048.0437275637,{"$f":"IF($E117<=$G$23,$H$23,IF($E117<=$G$24+$G$23,$H$24,\"\"))","v":0.02}]
[null,null,null,null,{"$f":"IF(E117<$H$22,E117+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":69},"2030-11-05",2204048.0437275637,68565.919356483821,null,68565.919356483821,44080.960874551274,24484.958481932546,2179563.0852456312,0.02]
[null,null,null,null,{"$f":"IF(E118<$H$22,E118+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":70},"2030-12-05",2179563.0852456312,68565.919356483821,null,68565.919356483821,43591.261704912627,24974.657651571193,2154588.4275940601,0.02]
[null,null,null,null,{"$f":"IF(E119<$H$22,E119+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":71},"2031-01-05",2154588.4275940601,68565.919356483821,null,68565.919356483821,43091.7685518812,25474.150804602621,2129114.2767894575,0.02]
[null,null,null,null,{"$f":"IF(E120<$H$22,E120+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":72},"2031-02-05",2129114.2767894575,68565.919356483821,null,68565.919356483821,42582.285535789153,25983.633820694668,2103130.6429687627,0.02]
[null,null,null,null,{"$f":"IF(E121<$H$22,E121+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":73},"2031-03-05",2103130.6429687627,68565.919356483821,null,68565.919356483821,42062.612859375251,26503.30649710857,2076627.336471654,0.02]
[null,null,null,null,{"$f":"IF(E122<$H$22,E122+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":74},"2031-04-05",2076627.336471654,68565.919356483821,null,68565.919356483821,41532.546729433081,27033.37262705074,2049593.9638446032,0.02]
[null,null,null,null,{"$f":"IF(E123<$H$22,E123+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":75},"2031-05-05",2049593.9638446032,68565.919356483821,null,68565.919356483821,{"$f":"G124*N124","v":40991.879276892061},27574.040079591759,2022019.9237650114,0.02]
[null,null,null,null,{"$f":"IF(E124<$H$22,E124+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":76},"2031-06-05",2022019.9237650114,68565.919356483821,null,68565.919356483821,{"$f":"G125*N125","v":40440.39847530023},28125.520881183591,1993894.4028838277,0.02]
[null,null,null,null,{"$f":"IF(E125<$H$22,E125+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":77},"2031-07-05",1993894.4028838277,68565.919356483821,null,68565.919356483821,39877.888057676551,28688.031298807269,1965206.3715850203,0.02]
[null,null,null,null,{"$f":"IF(E126<$H$22,E126+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":78},"2031-08-05",1965206.3715850203,68565.919356483821,null,68565.919356483821,39304.127431700406,29261.791924783414,1935944.5796602368,0.02]
[null,null,null,null,{"$f":"IF(E127<$H$22,E127+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":79},"2031-09-05",1935944.5796602368,68565.919356483821,null,68565.919356483821,38718.891593204738,29847.027763279082,1906097.5518969577,0.02]
[null,null,null,null,{"$f":"IF(E128<$H$22,E128+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":80},"2031-10-05",1906097.5518969577,68565.919356483821,null,68565.919356483821,38121.951037939158,30443.968318544663,1875653.5835784131,0.02]
[null,null,null,null,{"$f":"IF(E129<$H$22,E129+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":81},"2031-11-05",1875653.5835784131,68565.919356483821,null,68565.919356483821,37513.071671568265,31052.847684915556,1844600.7358934975,0.02]
[null,null,null,null,{"$f":"IF(E130<$H$22,E130+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":82},"2031-12-05",1844600.7358934975,68565.919356483821,null,68565.919356483821,36892.014717869948,31673.904638613873,1812926.8312548837,0.02]
[null,null,null,null,{"$f":"IF(E131<$H$22,E131+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":83},"2032-01-05",1812926.8312548837,68565.919356483821,null,68565.919356483821,36258.536625097673,32307.382731386147,1780619.4485234974,0.02]
[null,null,null,null,{"$f":"IF(E132<$H$22,E132+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":84},"2032-02-05",1780619.4485234974,68565.919356483821,null,68565.919356483821,35612.388970469947,32953.530386013874,1747665.9181374835,0.02]
[null,null,null,null,{"$f":"IF(E133<$H$22,E133+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":85},"2032-03-05",1747665.9181374835,68565.919356483821,null,68565.919356483821,34953.318362749669,33612.600993734151,1714053.3171437494,0.02]
[null,null,null,null,{"$f":"IF(E134<$H$22,E134+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":86},"2032-04-05",1714053.3171437494,68565.919356483821,null,68565.919356483821,34281.06634287499,34284.85301360883,1679768.4641301406,0.02]
[null,null,null,null,{"$f":"IF(E135<$H$22,E135+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":87},"2032-05-05",1679768.4641301406,68565.919356483821,null,68565.919356483821,33595.369282602813,34970.550073881008,1644797.9140562597,0.02]
[null,null,null,null,{"$f":"IF(E136<$H$22,E136+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":88},"2032-06-05",1644797.9140562597,68565.919356483821,null,68565.919356483821,{"$f":"G137*N137","v":32895.958281125197},35669.961075358624,1609127.9529809011,0.02]
[null,null,null,null,{"$f":"IF(E137<$H$22,E137+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":89},"2032-07-05",1609127.9529809011,68565.919356483821,null,68565.919356483821,{"$f":"G138*N138","v":32182.559059618023},36383.360296865794,1572744.5926840354,0.02]
[null,null,null,null,{"$f":"IF(E138<$H$22,E138+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":90},"2032-08-05",1572744.5926840354,68565.919356483821,null,68565.919356483821,31454.89185368071,37111.02750280311,1535633.5651812323,0.02]
[null,null,null,null,{"$f":"IF(E139<$H$22,E139+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":91},"2032-09-05",1535633.5651812323,68565.919356483821,null,68565.919356483821,30712.671303624647,37853.24805285917,1497780.3171283731,0.02]
[null,null,null,null,{"$f":"IF(E140<$H$22,E140+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":92},"2032-10-05",1497780.3171283731,68565.919356483821,null,68565.919356483821,29955.606342567462,38610.313013916355,1459170.0041144567,0.02]
[null,null,null,null,{"$f":"IF(E141<$H$22,E141+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":93},"2032-11-05",1459170.0041144567,68565.919356483821,null,68565.919356483821,29183.400082289136,39382.519274194681,1419787.484840262,0.02]
[null,null,null,null,{"$f":"IF(E142<$H$22,E142+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":94},"2032-12-05",1419787.484840262,68565.919356483821,null,68565.919356483821,28395.74969680524,40170.169659678577,1379617.3151805834,0.02]
[null,null,null,null,{"$f":"IF(E143<$H$22,E143+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":95},"2033-01-05",1379617.3151805834,68565.919356483821,null,68565.919356483821,27592.34630361167,40973.573052872147,1338643.7421277112,0.02]
[null,null,null,null,{"$f":"IF(E144<$H$22,E144+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":96},"2033-02-05",1338643.7421277112,68565.919356483821,null,68565.919356483821,26772.874842554225,41793.044513929592,1296850.6976137816,0.02]
[null,null,null,null,{"$f":"IF(E145<$H$22,E145+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":97},"2033-03-05",1296850.6976137816,68565.919356483821,null,68565.919356483821,25937.013952275633,42628.905404208184,1254221.7922095733,0.02]
[null,null,null,null,{"$f":"IF(E146<$H$22,E146+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":98},"2033-04-05",1254221.7922095733,68565.919356483821,null,68565.919356483821,25084.435844191466,43481.483512292354,1210740.3086972809,0.02]
[null,null,null,null,{"$f":"IF(E147<$H$22,E147+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":99},"2033-05-05",1210740.3086972809,68565.919356483821,null,68565.919356483821,24214.806173945621,44351.113182538204,1166389.1955147428,0.02]
[null,null,null,null,{"$f":"IF(E148<$H$22,E148+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":100},"2033-06-05",1166389.1955147428,68565.919356483821,null,68565.919356483821,23327.783910294856,45238.135446188964,1121151.0600685538,0.02]
[null,null,null,null,{"$f":"IF(E149<$H$22,E149+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":101},"2033-07-05",1121151.0600685538,68565.919356483821,null,68565.919356483821,22423.021201371077,46142.898155112744,1075008.161913441,0.02]
[null,null,null,null,{"$f":"IF(E150<$H$22,E150+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":102},"2033-08-05",1075008.161913441,68565.919356483821,null,68565.919356483821,21500.163238268822,47065.756118214995,1027942.405795226,0.02]
[null,null,null,null,{"$f":"IF(E151<$H$22,E151+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":103},"2033-09-05",1027942.405795226,68565.919356483821,null,68565.919356483821,{"$f":"G152*N152","v":20558.848115904519},48007.071240579302,979935.33455464663,0.02]
[null,null,null,null,{"$f":"IF(E152<$H$22,E152+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":104},"2033-10-05",979935.33455464663,68565.919356483821,null,68565.919356483821,{"$f":"G153*N153","v":19598.706691092932},48967.212665390893,930968.12188925571,0.02]
[null,null,null,null,{"$f":"IF(E153<$H$22,E153+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":105},"2033-11-05",930968.12188925571,68565.919356483821,null,68565.919356483821,18619.362437785116,49946.556918698705,881021.564970557,0.02]
[null,null,null,null,{"$f":"IF(E154<$H$22,E154+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":106},"2033-12-05",881021.564970557,68565.919356483821,null,68565.919356483821,17620.431299411139,50945.488057072682,830076.07691348437,0.02]
[null,null,null,null,{"$f":"IF(E155<$H$22,E155+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":107},"2034-01-05",830076.07691348437,68565.919356483821,null,68565.919356483821,16601.521538269688,51964.397818214129,778111.67909527023,0.02]
[null,null,null,null,{"$f":"IF(E156<$H$22,E156+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":108},"2034-02-05",778111.67909527023,68565.919356483821,null,68565.919356483821,15562.233581905404,53003.685774578415,725107.99332069186,0.02]
[null,null,null,null,{"$f":"IF(E157<$H$22,E157+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":109},"2034-03-05",725107.99332069186,68565.919356483821,null,68565.919356483821,14502.159866413838,54063.759490069984,671044.23383062193,0.02]
[null,null,null,null,{"$f":"IF(E158<$H$22,E158+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":110},"2034-04-05",671044.23383062193,68565.919356483821,null,68565.919356483821,{"$f":"G159*N159","v":13420.884676612439},55145.03467987138,615899.19915075053,0.02]
[null,null,null,null,{"$f":"IF(E159<$H$22,E159+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":111},"2034-05-05",615899.19915075053,68565.919356483821,null,68565.919356483821,{"$f":"G160*N160","v":12317.98398301501},56247.935373468812,559651.26377728174,0.02]
[null,null,null,null,{"$f":"IF(E160<$H$22,E160+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":112},"2034-06-05",559651.26377728174,68565.919356483821,null,68565.919356483821,11193.025275545635,57372.894080938189,502278.36969634355,0.02]
[null,null,null,null,{"$f":"IF(E161<$H$22,E161+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":113},"2034-07-05",502278.36969634355,68565.919356483821,null,68565.919356483821,10045.567393926871,58520.351962556946,443758.0177337866,0.02]
[null,null,null,null,{"$f":"IF(E162<$H$22,E162+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":114},"2034-08-05",443758.0177337866,68565.919356483821,null,68565.919356483821,8875.1603546757324,59690.759001808088,384067.25873197854,0.02]
[null,null,null,null,{"$f":"IF(E163<$H$22,E163+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":115},"2034-09-05",384067.25873197854,68565.919356483821,null,68565.919356483821,7681.3451746395713,60884.574181844248,323182.68455013429,0.02]
[null,null,null,null,{"$f":"IF(E164<$H$22,E164+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":116},"2034-10-05",323182.68455013429,68565.919356483821,null,68565.919356483821,6463.6536910026862,62102.265665481136,261080.41888465316,0.02]
[null,null,null,null,{"$f":"IF(E165<$H$22,E165+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":117},"2034-11-05",261080.41888465316,68565.919356483821,null,68565.919356483821,5221.6083776930636,63344.31097879076,197736.10790586239,0.02]
[null,null,null,null,{"$f":"IF(E166<$H$22,E166+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":118},"2034-12-05",197736.10790586239,68565.919356483821,null,68565.919356483821,3954.722158117248,64611.197198366572,133124.91070749582,0.02]
[null,null,null,null,{"$f":"IF(E167<$H$22,E167+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":119},"2035-01-05",133124.91070749582,68565.919356483821,null,68565.919356483821,2662.4982141499163,65903.4211423339,67221.489565161915,0.02]
[null,null,null,null,{"$f":"IF(E168<$H$22,E168+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":120},"2035-02-05",67221.489565161915,68565.91935646515,null,68565.91935646515,1344.4297913032383,67221.489565161915,0,0.02]
[null,null,null,null,{"$f":"IF(E169<$H$22,E169+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":""},"2035-03-05",0,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},""]
[null,null,null,null,{"$f":"IF(E170<$H$22,E170+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"IF(E171<$H$22,E171+1,IF(Table_1[[#This Row],[SALDO INICIAL]]<=0,\"\"))","v":""},{"$error":"#VALUE!"},null,null,null,null,null,null,null,""]
[null,null,null,null,{"$f":"SUBTOTAL(102,SIMULADOR!$E$50:$E$172)","v":120},{"$f":"VLOOKUP(E173,SIMULADOR!$E$49:$M$172,2,0)","v":"2035-02-05"},null,null,{"$f":"SUBTOTAL(109,SIMULADOR!$I$50:$I$172)","v":0},{"$f":"SUBTOTAL(109,SIMULADOR!$J$51:$J$169)","v":6917316.0790846311},{"$f":"SUBTOTAL(109,SIMULADOR!$K$50:$K$172)","v":{"$error":"#VALUE!"}},{"$f":"SUBTOTAL(109,SIMULADOR!$L$50:$L$172)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(E173,SIMULADOR!$E$49:$M$172,9,0)-SIMULADOR!$I$173","v":0}]

{"sheet":"DATOS DEL CLIENTE ","index":2,"n_rows":93,"n_cols":32,"rows_kept":93,"cut":false,"hidden":false,"merged":[[76,44,76,46],[78,1,78,46],[80,1,80,22],[80,24,80,45],[90,27,91,46],[76,1,76,6],[76,7,76,9],[76,10,76,14],[76,15,76,17],[76,23,76,30],[76,31,76,41],[75,1,75,6],[75,7,75,14],[75,15,75,16],[75,17,75,26],[75,27,75,31],[75,32,75,46],[73,31,73,33],[73,34,73,46],[74,1,74,6],[74,7,74,14],[74,15,74,16],[74,17,74,26],[74,27,74,31],[74,32,74,46],[73,1,73,6],[73,7,73,14],[73,15,73,18],[73,19,73,23],[73,24,73,25],[73,26,73,30],[72,1,72,6],[72,7,72,9],[72,10,72,14],[72,15,72,27],[72,28,72,31],[72,32,72,46],[68,44,68,46],[70,1,70,6],[70,7,70,29],[70,31,70,46],[71,1,71,6],[71,7,71,46],[68,1,68,6],[68,7,68,9],[68,10,68,14],[68,15,68,17],[68,23,68,30],[68,31,68,41],[67,1,67,6],[67,7,67,14],[67,15,67,16],[67,17,67,26],[67,27,67,31],[67,32,67,46],[65,31,65,33],[65,34,65,46],[66,1,66,6],[66,7,66,14],[66,15,66,16],[66,17,66,26],[66,27,66,31],[66,32,66,46],[65,1,65,6],[65,7,65,14],[65,15,65,18],[65,19,65,23],[65,24,65,25],[65,26,65,30],[64,1,64,6],[64,7,64,9],[64,10,64,14],[64,15,64,27],[64,28,64,31],[64,32,64,46],[60,44,60,46],[62,1,62,6],[62,7,62,29],[62,31,62,46],[63,1,63,6],[63,7,63,46],[60,1,60,6],[60,7,60,9],[60,10,60,14],[60,15,60,17],[60,23,60,30],[60,31,60,41],[59,1,59,6],[59,7,59,14],[59,15,59,16],[59,17,59,26],[59,27,59,31],[59,32,59,46],[57,31,57,33],[57,34,57,46],[58,1,58,6],[58,7,58,14],[58,15,58,16],[58,17,58,26],[58,27,58,31],[58,32,58,46],[57,1,57,6],[57,7,57,14],[57,15,57,18],[57,19,57,23],[57,24,57,25],[57,26,57,30],[56,1,56,6],[56,7,56,9],[56,10,56,14],[56,15,56,27],[56,28,56,31],[56,32,56,46],[52,1,52,5],[52,6,52,27],[54,1,54,6],[54,7,54,29],[54,31,54,46],[55,1,55,6],[55,7,55,46],[50,1,50,5],[50,6,50,27],[50,28,50,35],[50,36,50,46],[51,1,51,5],[51,6,51,27],[51,28,51,35],[51,36,51,46],[47,27,47,30],[47,31,47,46],[48,1,48,45],[49,1,49,5],[49,6,49,27],[49,28,49,35],[49,36,49,46],[47,1,47,3],[47,4,47,12],[47,13,47,14],[47,15,47,19],[47,20,47,21],[47,22,47,26],[43,44,43,46],[44,1,44,46],[45,1,45,3],[45,4,45,29],[45,31,45,46],[46,1,46,3],[46,4,46,46],[43,15,43,17],[43,1,43,6],[43,7,43,9],[43,10,43,14],[43,23,43,30],[43,31,43,41],[42,1,42,6],[42,7,42,14],[42,15,42,16],[42,17,42,26],[42,27,42,31],[42,32,42,46],[40,31,40,33],[40,34,40,46],[41,1,41,6],[41,7,41,14],[41,15,41,16],[41,17,41,26],[41,27,41,31],[41,32,41,46],[40,1,40,6],[40,7,40,14],[40,15,40,18],[40,19,40,23],[40,24,40,25],[40,26,40,30],[39,1,39,6],[39,7,39,9],[39,10,39,14],[39,15,39,27],[39,28,39,31],[39,32,39,46],[35,44,35,46],[37,1,37,6],[37,7,37,29],[37,31,37,46],[38,1,38,6],[38,7,38,46],[35,1,35,6],[35,7,35,9],[35,10,35,14],[35,15,35,17],[35,23,35,30],[35,31,35,41],[34,1,34,6],[34,7,34,14],[34,15,34,16],[34,17,34,26],[34,27,34,31],[34,32,34,46],[32,31,32,33],[32,34,32,46],[33,1,33,6],[33,7,33,14],[33,15,33,16],[33,17,33,26],[33,27,33,31],[33,32,33,46],[32,1,32,6],[32,7,32,14],[32,15,32,18],[32,19,32,23],[32,24,32,25],[32,26,32,30],[31,1,31,6],[31,7,31,9],[31,10,31,14],[31,15,31,27],[31,28,31,31],[31,32,31,46],[27,44,27,46],[29,1,29,6],[29,7,29,29],[29,31,29,46],[30,1,30,6],[30,7,30,46],[27,1,27,6],[27,7,27,9],[27,10,27,14],[27,15,27,17],[27,23,27,30],[27,31,27,41],[26,1,26,6],[26,7,26,14],[26,15,26,16],[26,17,26,26],[26,27,26,31],[26,32,26,46],[24,26,24,30],[24,31,24,33],[24,34,24,46],[25,1,25,6],[25,7,25,14],[25,15,25,16],[25,17,25,26],[25,27,25,31],[25,32,25,46],[23,1,23,6],[23,7,23,9],[23,15,23,27],[23,28,23,31],[23,32,23,46],[24,1,24,6],[24,7,24,14],[24,15,24,18],[24,19,24,23],[24,24,24,25],[20,1,20,46],[21,1,21,6],[21,7,21,29],[21,31,21,46],[22,1,22,6],[22,7,22,46],[19,1,19,6],[19,7,19,14],[19,15,19,16],[19,17,19,26],[19,27,19,31],[19,32,19,46],[17,31,17,33],[17,34,17,46],[18,1,18,6],[18,7,18,14],[18,15,18,16],[18,17,18,26],[18,27,18,31],[18,32,18,46],[17,1,17,6],[17,7,17,14],[17,15,17,18],[17,19,17,23],[17,24,17,25],[17,26,17,30],[16,1,16,6],[16,7,16,9],[16,10,16,14],[16,15,16,27],[16,28,16,31],[16,32,16,46],[12,44,12,46],[14,1,14,6],[14,7,14,29],[14,31,14,46],[15,1,15,6],[15,7,15,46],[12,15,12,17],[12,1,12,6],[12,7,12,9],[12,10,12,14],[12,23,12,30],[12,31,12,41],[11,1,11,6],[11,7,11,14],[11,15,11,16],[11,17,11,26],[11,27,11,31],[11,32,11,46],[10,1,10,6],[10,7,10,14],[10,15,10,16],[10,17,10,26],[10,27,10,31],[10,32,10,46],[8,1,8,6],[8,7,8,9],[8,10,8,14],[8,15,8,27],[8,28,8,31],[8,32,8,46],[9,1,9,6],[9,7,9,14],[9,15,9,18],[9,19,9,23],[9,24,9,25],[9,26,9,30],[9,31,9,33],[9,34,9,46],[4,16,4,20],[5,1,5,46],[3,12,3,17],[3,1,3,6],[1,19,2,46],[6,1,6,6],[6,7,6,29],[6,31,6,46],[7,1,7,6],[7,7,7,46],[3,18,3,23],[3,7,3,11]]}
[]
[null,"INFORMACIÓN DEL CLIENTE"]
[]
[null,"USO DE PROPIEDAD:",null,null,null,null,null,null,null,null,null,null,"TIPO DE CONTRATO:"]
[]
[null,"DATOS DE PERSONA FISICA"]
[null,"NOMBRE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL:"]
[null,"DOMILICIO:"]
[null,"VIVES EN CASA:",null,null,null,null,null,"OTRO",null,null,"CORREO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NACIONALIDAD:"]
[null,"LUGAR DE NACIMIENTO:",null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE NACIMIENTO:",null,null,null,null,null,null,null,null,"RFC:",null,null,null,null,null,null,"CURP:"]
[null,"ESTUDIOS:",null,null,null,null,null,"OTRO",null,null,null,null,null,null,null,"EMPREA LABORA:",null,null,null,null,null,null,null,null,null,null,null,"ANTIGÜEDAD:"]
[null,"ESPECIFICAR:",null,null,null,null,null,null,null,null,null,null,null,null,null,"PUESTO:",null,null,null,null,null,null,null,null,null,null,null,"TELÉFONO:"]
[null,"ESTADO CIVIL:",null,null,null,null,null,"SOLTERO",null,null,"APLICA BIENES:",null,null,null,null,"NO"]
[]
[null,"NOMBRE CONYUGE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL:"]
[null,"DOMILICIO:"]
[null,"VIVES EN CASA:",null,null,null,null,null,"OTRO",null,null,"CORREO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NACIONALIDAD:"]
[null,"LUGAR DE NACIMIENTO:",null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE NACIMIENTO:",null,null,null,null,null,null,null,null,"RFC:",null,null,null,null,null,null,"CURP:"]
[null,"ESTUDIOS:",null,null,null,null,null,"OTRO",null,null,null,null,null,null,null,"EMPREA LABORA:",null,null,null,null,null,null,null,null,null,null,null,"ANTIGÜEDAD:"]
[null,"ESPECIFICAR:",null,null,null,null,null,null,null,null,null,null,null,null,null,"PUESTO:",null,null,null,null,null,null,null,null,null,null,null,"TELÉFONO:"]
[null,"DATOS COPROPIEDAD"]
[null,"NOMBRE 1:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL:"]
[";","DOMILICIO:"]
[null,"VIVES EN CASA:",null,null,null,null,null,"OTRO",null,null,null,"CORREO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NACIONALIDAD:"]
[null,"LUGAR DE NACIMIENTO:",null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE NACIMIENTO:",null,null,null,null,null,null,null,null,"RFC:",null,null,null,null,null,null,"CURP:"]
[null,"ESTUDIOS:",null,null,null,null,null,"OTRO",null,null,null,null,null,null,null,"EMPREA LABORA:",null,null,null,null,null,null,null,null,null,null,null,"ANTIGÜEDAD:"]
[null,"ESPECIFICAR:",null,null,null,null,null,null,null,null,null,null,null,null,null,"PUESTO:",null,null,null,null,null,null,null,null,null,null,null,"TELÉFONO:"]
[null,"ESTADO CIVIL:",null,null,null,null,null,"OTRO",null,null,"APLICA BIENES:",null,null,null,null,"NO"]
[]
[null,"NOMBRE 2:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL:"]
[null,"DOMILICIO:"]
[null,"VIVES EN CASA:",null,null,null,null,null,"OTRO",null,null,"CORREO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NACIONALIDAD:"]
[null,"LUGAR DE NACIMIENTO:",null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE NACIMIENTO:",null,null,null,null,null,null,null,null,"RFC:",null,null,null,null,null,null,"CURP:"]
[null,"ESTUDIOS:",null,null,null,null,null,"OTRO",null,null,null,null,null,null,null,"EMPREA LABORA:",null,null,null,null,null,null,null,null,null,null,null,"ANTIGÜEDAD:"]
[null,"ESPECIFICAR:",null,null,null,null,null,null,null,null,null,null,null,null,null,"PUESTO:",null,null,null,null,null,null,null,null,null,null,null,"TELÉFONO:"]
[null,"ESTADO CIVIL:",null,null,null,null,null,"OTRO",null,null,"APLICA BIENES:",null,null,null,null,"NO"]
[]
[null,"NOMBRE 3:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL:"]
[null,"DOMILICIO:"]
[null,"VIVES EN CASA:",null,null,null,null,null,"OTRO",null,null,"CORREO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NACIONALIDAD:"]
[null,"LUGAR DE NACIMIENTO:",null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE NACIMIENTO:",null,null,null,null,null,null,null,null,"RFC:",null,null,null,null,null,null,"CURP:"]
[null,"ESTUDIOS:",null,null,null,null,null,"OTRO",null,null,null,null,null,null,null,"EMPREA LABORA:",null,null,null,null,null,null,null,null,null,null,null,"ANTIGÜEDAD:"]
[null,"ESPECIFICAR:",null,null,null,null,null,null,null,null,null,null,null,null,null,"PUESTO:",null,null,null,null,null,null,null,null,null,null,null,"TELÉFONO:"]
[null,"ESTADO CIVIL:",null,null,null,null,null,"OTRO",null,null,"APLICA BIENES:",null,null,null,null,"NO"]
[null,"DATOS DE PERSONA MORAL"]
[null,"NOMBRE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL:"]
[null,"DOMILICIO:"]
[null,"CORREO:",null,null,null,null,null,null,null,null,null,null,null,"RFC:",null,null,null,null,null,null,"GIRO:",null,null,null,null,null,null,"ACTIVIDAD:"]
[null,"ACTA CONSTITUTIVA"]
[null,"FOLIO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIUDAD DE REGISTRO:"]
[null,"FECHA DE REGISTRO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OBJETO SOCIAL:"]
[null,"No NOTARIA: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOLIO MERCANTIL:"]
[null,"NOMBRE NOTARIO:"]
[]
[null,"REPRESENTANTE LEGAL 1:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL:"]
[null,"DOMILICIO:"]
[null,"VIVES EN CASA:",null,null,null,null,null,"OTRO",null,null,"CORREO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NACIONALIDAD:"]
[null,"LUGAR DE NACIMIENTO:",null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE NACIMIENTO:",null,null,null,null,null,null,null,null,"RFC:",null,null,null,null,null,null,"CURP:"]
[null,"ESTUDIOS:",null,null,null,null,null,"OTRO",null,null,null,null,null,null,null,"EMPREA LABORA:",null,null,null,null,null,null,null,null,null,null,null,"ANTIGÜEDAD:"]
[null,"ESPECIFICAR:",null,null,null,null,null,null,null,null,null,null,null,null,null,"PUESTO:",null,null,null,null,null,null,null,null,null,null,null,"TELÉFONO:"]
[null,"ESTADO CIVIL:",null,null,null,null,null,"OTRO",null,null,"APLICA BIENES:",null,null,null,null,"NO"]
[]
[null,"REPRESENTANTE LEGAL 2:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL:"]
[null,"DOMILICIO:"]
[null,"VIVES EN CASA:",null,null,null,null,null,"OTRO",null,null,"CORREO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NACIONALIDAD:"]
[null,"LUGAR DE NACIMIENTO:",null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE NACIMIENTO:",null,null,null,null,null,null,null,null,"RFC:",null,null,null,null,null,null,"CURP:"]
[null,"ESTUDIOS:",null,null,null,null,null,"OTRO",null,null,null,null,null,null,null,"EMPREA LABORA:",null,null,null,null,null,null,null,null,null,null,null,"ANTIGÜEDAD:"]
[null,"ESPECIFICAR:",null,null,null,null,null,null,null,null,null,null,null,null,null,"PUESTO:",null,null,null,null,null,null,null,null,null,null,null,"TELÉFONO:"]
[null,"ESTADO CIVIL:",null,null,null,null,null,"OTRO",null,null,"APLICA BIENES:",null,null,null,null,"NO"]
[]
[null,"REPRESENTANTE LEGAL 3:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CEL:"]
[null,"DOMILICIO:"]
[null,"VIVES EN CASA:",null,null,null,null,null,"OTRO",null,null,"CORREO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NACIONALIDAD:"]
[null,"LUGAR DE NACIMIENTO:",null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE NACIMIENTO:",null,null,null,null,null,null,null,null,"RFC:",null,null,null,null,null,null,"CURP:"]
[null,"ESTUDIOS:",null,null,null,null,null,"OTRO",null,null,null,null,null,null,null,"EMPREA LABORA:",null,null,null,null,null,null,null,null,null,null,null,"ANTIGÜEDAD:"]
[null,"ESPECIFICAR:",null,null,null,null,null,null,null,null,null,null,null,null,null,"PUESTO:",null,null,null,null,null,null,null,null,null,null,null,"TELÉFONO:"]
[null,"ESTADO CIVIL:",null,null,null,null,null,"OTRO",null,null,"APLICA BIENES:",null,null,null,null,"NO"]
[]
[null,"DOCUMENTACIÓN ENTREGADA"]
[null,"ESCRITURACIÓN"]
[null,"PERSONA FÍSICA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERSONA MORAL"]
[null,null,"*Identificación oficial vigente.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Identificación oficial del representante legal vigente."]
[null,null,"*Acta de nacimiento.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Acta de nacimiento del representante legal."]
[null,null,"*Acta de matrimonio ( en caso de ser casado).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Acta constitutiva"]
[null,null,"*Constancia de situación fiscal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Constancia de situacón fiscal empre y representante legal"]
[null,null,"*CURP .",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*CURP del representante legal"]
[null,null,"*Comprobante de domicilio",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Comprobante de Domicilio (Empresa y Representante legal)."]
[null,null,"Adjuntar en ambos casos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Poder en el que ostenta las facultades otorgadas al representante legal"]
[null,null,"Simulador y hoja de Registro"]
[null,null,"Recibo y Voucher, de Apartado y/o enganche.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EN CASO DE SER EXTRANJERO ANEXAR FORMA MIGRATORIA"]
[null,null,"Evidencia de Envio de Proceso de Facturación y Pago.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"En caso de ser casado por sociedad conyugal anexar la documentación de ambas personas"]
[null,null,"Evidencia de Envio de Reglamento de Administración y Contrucción. "]
[null,null,"Anexar Check-lis Firmado por cliente (Despues de firmar contrato anexar).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"En caso de ser por copropiedad anexar documentación de ambos."]

{"sheet":"DATOS","index":3,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
["NOMBRE PARQUES","IMAGEN PARQUE"]
["AEROPUERTO"]
["CELTA"]
["GAMMA II"]
["SANTA ROSA"]
["SUR 57."]
["CALAMANDA"]
[]
[]
[]
[]
[]
[]
[null,null,null,"PARQUES"]
[null,null,null,"CELTA",null,"PROMOCIONES",null,"ESTUDIOS ",null,"SUR 57"]
[null,null,null,"AEROPUERTO (Nave)",null,"PROMOCIONES NAVETEC CUARTO TRIMESTRE \"20 ANIVERSARIOGRUPO CCIMA\"",null,"DOCTORADO",null,"N/A"]
[null,null,null,"AEROPUERTO (Lote)",null,"PROMOCIONES NAVETEC TERCER TRIMESTRE \"DE JULIO A SEPTIEMBRE 2022\"",null,"MAESTRIA",null,"FINANCIAMIENTO 1"]
[null,null,null,"GAMMA II ETAPA 2",null,"PROMOCIONES NAVETEC SEGUNDO TRIMESTRE \"DE ABRIL A JUNIO 2022\"",null,"LICENCIATURA",null,"FINANCIAMIENTO 2"]
[null,null,null,"CALAMANDA (NAVE)",null,"PROMOCIONES NAVETEC PRIMER TRIMESTRE \"ARRANCA 2022\"",null,"INGENIERÍA",null,"FINANCIAMIENTO 3"]
[null,null,null,"CALAMANDA (LOCAL)",null,null,null,"TSU"]
[null,null,null,"SUR_57",null,"ENGANCHE",null,"PREPARATORIA"]
[null,null,null,null,null,"DIFERIDO",null,"SECUNDARIA "]
[null,null,null,null,null,"NORMAL",null,"PRIMARIA "]
[null,null,null,null,null,null,null,"OTRO"]
[null,null,null,"TIPO DE ENGANCHE",null,"ESTADO CIVIL"]
[null,null,null,"N/A",null,"CASADO",null,"VIVE EN CASA "]
[null,null,null,"ENGANCHE DIFERIDO:",null,"SOLTERO",null,"PROPIA"]
[null,null,null,"ENGANCHE DIFERIDO C/IVA:",null,null,null,"RENTA "]
[null,null,null,null,null,null,null,"FAMILIAR "]
[null,null,null,"ENGANCHE DIERIDO",null,"TIPO CONTRATO",null,"OTRO"]
[null,null,null,"NAVE-CDA 10%,10% 10%"]
[null,null,null,"LOTE-AE,CELTA, 10%,10%,10%",null,"PERSONA FISICA ",null,"USO DE PROPIEDAD "]
[null,null,null,"LOCAL A CDA 10%, 10%, 10%",null,"PERSONA MORAL"]
[null,null,null,"LOCAL B CDA 10%, 10%, 10%",null,"COPROPIEDAD ",null,"PATRIMONIO "]
[null,null,null,"NAVE-AE 10%,10% 10%",null,null,null,"INVERSIÓN"]
[null,null,null,null,null,"APLICAN BIENES"]
[null,null,null,"TIPO",null,"NO"]
[null,null,null,"ESTANDAR",null,"SI"]
[null,null,null,"PREMIUM"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"MASTER PARQUES","IMAGEN"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AEROPUERTO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"CELTA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GAMMA II"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SANTA ROSA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SUR 57."]
[null,null,null,null,null,null,null,null,null,null,null,null,"CALAMANDA"]