{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["COTIZADOR","IMPRESION","FACTORES","COTIZADOR APLICATIVO"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"COTIZADOR","index":0,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,7,7,13],[5,7,5,9],[0,1,0,2],[1,7,1,10],[2,7,2,9],[3,7,3,9],[4,7,4,9],[9,1,9,5],[5,2,5,5],[2,1,2,5],[1,1,1,5],[4,3,4,5],[6,3,6,4],[7,3,7,4],[3,3,3,4],[20,1,20,2],[20,3,20,4],[10,1,10,2],[11,1,11,2],[14,1,14,2],[15,1,15,2],[18,1,18,2],[17,1,17,2],[13,1,13,2],[12,1,12,2],[16,1,16,2]]}
["Tarifa (% canon)",{"$f":"IF(C5=\"Básico\",0.2,IF(C5=\"Clásico\",0.3,IF(C5=\"Global\",0.5,IF(B8<800000,0.78,IF(B8<1000000,0.82,IF(B8<1500000,0.87,IF(B8<2000000,0.91,IF(B8<3000000,0.96,1))))))))","v":0.2}]
[null,"PÓLIZA DE SEGURO DE ARRENDAMIENTO INDIVIDUAL",null,null,null,null,null,"¿CÓMO USAR ESTE COTIZADOR?"]
[null,"Datos inmueble",null,null,null,null,null,"Llenar únicamente las casillas en gris"]
[null,"Destinación inmueble","Vivienda","¿Aplica IVA sobre canon?",null,"No",null,"Conoce el video de esta solución",null,null,"Vínculo"]
[null,"Plan de arrendamiento","Básico",null,null,null,null,"Conoce el condicionado general",null,null,"Vínculo"]
[null,"Duración contrato (meses)",8,null,null,null,null,"Conoce los detalles de la solución tradicional",null,null,"Vínculo"]
[null,"Canon mensual (sin IVA)","Administración mensual","Asistencia domiciliaria",null,"Daños y faltantes"]
[null,8000000,0,"No",null,0,null,{"$f":"IF(F8=0,\"\",IF(F8<FACTORES!G13,\"Error: El valor de los daños y faltantes no puede ser menor a $300.000\",IF(AND(C4=\"Vivienda\",F8>FACTORES!H13),\"Error: El valor de los daños y faltantes no puede ser mayor a $20.000.000 en vivienda\",IF(AND(C4=\"Comercial\",F8>FACTORES!H14),\"Error: El valor de los daños y faltantes no puede ser mayor a $40.000.000 en comercial\",\"\"))))","v":""}]
[]
[null,"Coberturas"]
[null,null,null,"Valor asegurado","Prima","IVA",null,{"$f":"IF(AND(C5=\"Global Especial\",C4=\"Comercial\"), \"Error: El plan global especial aplica únicamente para vivienda\",\"\")","v":""}]
[null,"Básico arrendamiento",null,{"$f":"B8*C6","v":64000000},{"$f":"IFERROR(D12*(VLOOKUP(C5&C6,FACTORES!A2:D61,3,FALSE)),0)","v":896358.54341736704},{"$f":"E12*19%","v":170308.12324929974},null,{"$f":"IF(E12=0,\"Error: La duración del plan Global Especial debe ser 12 meses\",\"\")","v":""}]
[null,"Bono inmueble no arrendado",null,{"$f":"IF(C5=\"Global Especial\",6*B8,0)","v":0},{"$f":"IF(C5=\"Global Especial\",IF(OR(B8<600000,B8>6000000),0,LOOKUP(B8,FACTORES!G3:G8,FACTORES!J3:J8)*B8),0)","v":0},0,null,{"$f":"IF(C5=\"Global Especial\",IF(B8<600000,\"Error: El valor del canon en este plan no debe ser menor a $600.000\",IF(B8>6000000,\"Error: El valor del canon en este plan no debe ser mayor a $6.000.000\",\"\")),\"\")","v":""}]
[null,"IVA Inmuebles comerciales",null,{"$f":"IF(AND(C4=\"Comercial\",F4=\"Si\"),B8*0.19*C6,0)","v":0},{"$f":"IFERROR(IF(AND(C4=\"Comercial\",F4=\"Si\"),D14*(VLOOKUP(C5&C6,FACTORES!A2:D61,3,FALSE)),0),0)","v":0},0]
[null,"Administración",null,{"$f":"C8*C6","v":0},{"$f":"IFERROR(D15*(VLOOKUP(C5&C6,FACTORES!A2:D61,3,FALSE)),0)","v":0},0]
[null,"Servicios públicos",null,{"$f":"IF(C5=\"Básico\",0,IF(D12*0.15>15000000,15000000,D12*0.15))","v":0},0,0]
[null,"Daños y faltantes",null,{"$f":"IF(C5=\"Básico\",0,F8)","v":0},{"$f":"D17*0.03","v":0},0]
[null,"Asistencia",null,{"$f":"IF($D$8=\"No\",0,IF($C$4=\"Comercial\",55000,IF($C$4=\"Vivienda\",20000,0)))","v":0},{"$f":"IF($D$8=\"No\",0,IF($C$4=\"Comercial\",55000,IF($C$4=\"Vivienda\",20000,0)))","v":0},0]
[null,"TOTAL VALOR ASEGURADO",null,{"$f":"SUM(D12:D18)","v":64000000},{"$f":"IF(SUM(E12:E18)<150000,150000,SUM(E12:E18))","v":896358.54341736704},{"$f":"IF(E19=150000,E19*0.19,SUM(F12:F18))","v":170308.12324929974}]
[null,"_____________________________________________________________________________________________"]
[null,"TOTAL A PAGAR",null,{"$f":"IF(OR(H8<>\"\",H12<>\"\",H13<>\"\",H11<>\"\"),\"Error\",E19+F19)","v":1066666.6666666667}]

{"sheet":"IMPRESION","index":1,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[18,2,18,3],[19,2,19,3],[3,0,3,4],[4,0,4,4],[5,3,5,4],[6,3,6,4],[12,1,12,4],[15,1,15,4],[14,0,14,4],[16,1,16,4],[17,1,17,4],[39,0,39,4],[35,0,35,4],[36,0,36,4],[37,0,37,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[21,0,21,4],[30,0,30,1],[33,0,33,1],[33,2,33,3],[28,0,28,1],[29,0,29,1],[22,0,22,1],[23,0,23,1],[26,0,26,1],[27,0,27,1],[25,0,25,1],[24,0,24,1]]}
["ÚNICAMENTE LLENAR LA \"INFORMACIÓN GENERAL\" EN ESTA SECCIÓN"]
[]
[]
["PÓLIZA DE SEGURO DE ARRENDAMIENTO INDIVIDUAL"]
["Información General"]
["Fecha cotización",{"$f":"TODAY()","v":"2022-12-16"},"Vigencia final",{"$f":"B6+30","v":"2023-01-15"},{"$f":"COTIZADOR!#REF!","v":{"$error":"#REF!"}}]
["Número solicitud",0,"Código asesor",0,{"$f":"COTIZADOR!#REF!","v":{"$error":"#REF!"}}]
["Identificación tomador"]
["Nombre tomador"]
["Cédula afianzado"]
["Nombre afianzado"]
["Asegurado beneficiario"]
["Dirección inmueble "]
[]
["Datos inmueble"]
["Destinación",{"$f":"COTIZADOR!C4","v":"Vivienda"}]
["Plan de arrendamiento",{"$f":"COTIZADOR!C5","v":"Básico"},{"$f":"COTIZADOR!D5","v":0},{"$f":"COTIZADOR!E5","v":0},{"$f":"COTIZADOR!F5","v":0}]
["Duración contrato",{"$f":"COTIZADOR!C6","v":8}]
["Canon","Administración","Servicios públicos",null,"Daños y faltantes"]
[{"$f":"COTIZADOR!B8","v":8000000},{"$f":"COTIZADOR!C8","v":0},{"$f":"COTIZADOR!D8","v":"No"},null,{"$f":"COTIZADOR!F8","v":0}]
[]
["Coberturas"]
[null,null,"Valor asegurado","Prima","IVA"]
["Básico arrendamiento",null,{"$f":"COTIZADOR!D12","v":64000000},{"$f":"COTIZADOR!E12","v":896358.54341736704},{"$f":"COTIZADOR!F12","v":170308.12324929974}]
["Bono inmueble no arrendado",null,{"$f":"+COTIZADOR!D13","v":0},{"$f":"+COTIZADOR!E13","v":0},{"$f":"+COTIZADOR!F13","v":0}]
["IVA Inmuebles Comerciales",null,{"$f":"COTIZADOR!D14","v":0},{"$f":"COTIZADOR!E14","v":0},{"$f":"COTIZADOR!F14","v":0}]
["Administración",null,{"$f":"COTIZADOR!D15","v":0},{"$f":"COTIZADOR!E15","v":0},{"$f":"COTIZADOR!F15","v":0}]
["Servicios públicos",null,{"$f":"COTIZADOR!D16","v":0},{"$f":"COTIZADOR!E16","v":0},{"$f":"COTIZADOR!F16","v":0}]
["Daños y faltantes",null,{"$f":"COTIZADOR!D17","v":0},{"$f":"COTIZADOR!E17","v":0},{"$f":"COTIZADOR!F17","v":0}]
["Asistencia",null,{"$f":"COTIZADOR!D18","v":0},{"$f":"COTIZADOR!E18","v":0},{"$f":"COTIZADOR!F18","v":0}]
["TOTAL VALOR ASEGURADO",null,{"$f":"SUM(C24:C30)","v":64000000},{"$f":"IF(SUM(D24:D30)<150000,150000,SUM(D24:D30))","v":896358.54341736704},{"$f":"SUM(E24:E30)","v":170308.12324929974}]
[]
["_____________________________________________________________________________________________"]
["TOTAL A PAGAR",null,{"$f":"COTIZADOR!D21","v":1066666.6666666667},{"$f":"COTIZADOR!E21","v":0}]
[]
["La presente cotización no constituye aceptación del riesgo, por parte de Seguros Generales Suramericana S.A. hasta tanto la Compañía se manifieste de manera expresa y en documento escrito. "]

{"sheet":"FACTORES","index":2,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,5,0,7],[11,5,11,7]]}
["Plan","Meses","Tasa","Porcentaje sobre el canon",null,"Tasas Bono Global Especial",null,null,"Tasas iniciales","Nuevas tasas"]
["Básico1",1,1.6806722689075598E-2,0.24,null,1,0,599999,"Valor del canon es inferior o superior al estándar permitido para el plan seleccionado","Valor del canon es inferior o superior al estándar permitido para el plan seleccionado"]
["Básico2",2,1.680672268907563E-2,0.24,null,2,600000,800000,0.77971666666666672,0.15594333333333332]
["Básico3",3,1.680672268907563E-2,0.24,null,3,800001,1000000,0.82463333333333333,0.16492666666666664]
["Básico4",4,1.680672268907563E-2,0.24,null,4,1000001,1500000,0.86955000000000005,0.17390999999999998]
["Básico5",5,1.680672268907563E-2,0.24,null,5,1500001,2000000,0.91446666666666676,0.18289333333333332]
["Básico6",6,1.680672268907563E-2,0.24,null,6,2000001,3000000,0.95938333333333348,0.19187666666666667]
["Básico7",7,1.5406162464985995E-2,0.22,null,7,3000001,6000000,1.0043000000000002,0.20086000000000001]
["Básico8",8,1.4005602240896359E-2,0.2,null,8,6000001,null,"Valor del canon es inferior o superior al estándar permitido para el plan seleccionado","Valor del canon es inferior o superior al estándar permitido para el plan seleccionado"]
["Básico9",9,1.4005602240896401E-2,0.2]
["Básico10",10,1.4005602240896359E-2,0.2]
["Básico11",11,1.4005602240896359E-2,0.2,null,"Daños y faltantes"]
["Básico12",12,1.4005602240896359E-2,0.2,null,"Vivienda",300000,20000000]
["Clásico1",1,2.5210084033613446E-2,0.36,null,"Comercial",300000,40000000]
["Clásico2",2,2.5210084033613401E-2,0.36]
["Clásico3",3,2.5210084033613446E-2,0.36]
["Clásico4",4,2.5210084033613446E-2,0.36]
["Clásico5",5,2.5210084033613446E-2,0.36]
["Clásico6",6,2.5210084033613446E-2,0.36]
["Clásico7",7,2.3109243697478993E-2,0.33]
["Clásico8",8,2.100840336134454E-2,0.3]
["Clásico9",9,2.1008403361344501E-2,0.3]
["Clásico10",10,2.100840336134454E-2,0.3]
["Clásico11",11,2.100840336134454E-2,0.3]
["Clásico12",12,2.100840336134454E-2,0.3]
["Global1",1,4.2016806722689072E-2,0.6]
["Global2",2,4.2016806722689072E-2,0.6]
["Global3",3,4.2016806722689072E-2,0.6]
["Global4",4,4.2016806722689072E-2,0.6]
["Global5",5,4.2016806722689072E-2,0.6]
["Global6",6,4.2016806722689072E-2,0.6]
["Global7",7,3.853501400560224E-2,0.55027999999999999]
["Global8",8,3.5014005602240897E-2,0.5]
["Global9",9,3.5014005602240897E-2,0.5]
["Global10",10,3.5014005602240897E-2,0.5]
["Global11",11,3.5014005602240897E-2,0.5]
["Global12",12,3.5014005602240897E-2,0.5]
["Concesión de Espacios1",1,4.2016806722689072E-2,0.6]
["Concesión de Espacios2",2,4.2016806722689072E-2,0.6]
["Concesión de Espacios3",3,4.2016806722689072E-2,0.6]
["Concesión de Espacios4",4,4.2016806722689072E-2,0.6]
["Concesión de Espacios5",5,4.2016806722689072E-2,0.6]
["Concesión de Espacios6",6,4.2016806722689072E-2,0.6]
["Concesión de Espacios7",7,3.5014005602240897E-2,0.5]
["Concesión de Espacios8",8,3.5014005602240897E-2,0.5]
["Concesión de Espacios9",9,3.5014005602240897E-2,0.5]
["Concesión de Espacios10",10,3.5014005602240897E-2,0.5]
["Concesión de Espacios11",11,3.5014005602240897E-2,0.5]
["Concesión de Espacios12",12,3.5014005602240897E-2,0.5]
["Global Especial1",1,"N/A","N/A"]
["Global Especial2",2,"N/A","N/A"]
["Global Especial3",3,"N/A","N/A"]
["Global Especial4",4,"N/A","N/A"]
["Global Especial5",5,"N/A","N/A"]
["Global Especial6",6,"N/A","N/A"]
["Global Especial7",7,"N/A","N/A"]
["Global Especial8",8,"N/A","N/A"]
["Global Especial9",9,"N/A","N/A"]
["Global Especial10",10,"N/A","N/A"]
["Global Especial11",11,"N/A","N/A"]
["Global Especial12",12,3.5014005602240897E-2,0.5]

{"sheet":"COTIZADOR APLICATIVO","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
["Canon Mensual:","Administración","Servicios Públicos","Daños y Faltantes","Asistencia",null,null,"Tasa Aplicativo",{"$f":"B10*3.56%","v":2278400}]
[{"$f":"COTIZADOR!B8","v":8000000},{"$f":"COTIZADOR!D15","v":0},{"$f":"COTIZADOR!D16","v":0},{"$f":"COTIZADOR!F8","v":0},{"$f":"COTIZADOR!D8","v":"No"},null,null,"Tasa Aplicativo %º",35.6]
[]
[null,"Valor asegurado","Tasa Aplicativo","Valor Prima Antes de IVA"]
["Canon",{"$f":"COTIZADOR!D12","v":64000000},{"$f":"I11","v":14.005602240896362},{"$f":"COTIZADOR!E12","v":896358.54341736704},null,null,null,"Valor Prima Antes de IVA",{"$f":"COTIZADOR!E12","v":896358.54341736704}]
["Administración",{"$f":"B7","v":0},{"$f":"I11","v":14.005602240896362},{"$f":"COTIZADOR!E15","v":0},null,null,null,"Tasa Aplicar",{"$f":"(I10*I7)/I6","v":14.005602240896362}]
["Servicios Públicos",{"$f":"C7","v":0},"-","-",null,null,null,"Tasa Daños y faltantes",52]
["Daños y Faltantes",{"$f":"D7","v":0},{"$f":"I12","v":52},{"$f":"COTIZADOR!E17","v":0}]
["Asistencia",{"$f":"COTIZADOR!D18","v":0},"-",{"$f":"COTIZADOR!E18","v":0}]
[]
[null,null,"Total antes de IVA",{"$f":"SUM(D10:D14)","v":896358.54341736704}]
[null,null,"IVA",{"$f":"SUM(COTIZADOR!F12:F18)","v":170308.12324929974}]
[null,null,"TOTAL",{"$f":"D16+D17","v":1066666.6666666667}]