{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cotizador","Listas","Impresión Comercial","FACTORES","COTIZADOR APLICATIVO"],"not_rendered":{"charts":0,"images":5,"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":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,6,6,12],[4,6,4,8],[0,6,0,9],[1,6,1,8],[2,6,2,8],[3,6,3,8],[8,0,8,4],[4,1,4,4],[1,0,1,4],[0,0,0,4],[3,2,3,4],[5,2,5,3],[6,2,6,3],[2,2,2,3],[17,2,17,4],[17,0,17,1],[9,0,9,1],[10,0,10,1],[12,0,12,1],[13,0,13,1],[16,0,16,1],[15,0,15,1],[11,0,11,1],[14,0,14,1]]}
["PÓLIZA DE SEGURO DE ARRENDAMIENTO INDIVIDUAL",null,null,null,null,null,"¿CÓMO USAR ESTE COTIZADOR?"]
["Datos inmueble",null,null,null,null,null,"Diligenciar únicamente las casillas en azul"]
["Destinación inmueble","Residencial","¿Aplica IVA sobre canon?",null,"No",null,"Conoce el video de esta solución",null,null,"Vínculo"]
["Plan de arrendamiento","Clásico",null,null,null,null,"Conoce el condicionado general",null,null,"Vínculo"]
["Duración contrato (meses)",12,null,null,null,null,"Conoce los detalles de la solución tradicional",null,null,"Vínculo"]
["Canon mensual (sin IVA)","Administración mensual","Asistencia domiciliaria",null,{"$f":"IF(OR(B4=Listas!B2,B4=Listas!B5),\"\",\"Daños y faltantes\")","v":"Daños y faltantes"}]
[1000000,100000,"Si",null,500000,null,{"$f":"IF(E7=0,\"\",IF(E7<FACTORES!G13,\"Error: El valor de los daños y faltantes no puede ser menor a $300.000\",IF(AND(B3=\"Vivienda\",E7>FACTORES!H13),\"Error: El valor de los daños y faltantes no puede ser mayor a $20.000.000 en vivienda\",IF(AND(B3=\"Comercial\",E7>FACTORES!H14),\"Error: El valor de los daños y faltantes no puede ser mayor a $40.000.000 en comercial\",\"\"))))","v":""}]
[]
["Coberturas"]
[null,null,"Valor asegurado","Prima","IVA"]
["Básico arrendamiento",null,{"$f":"A7*B5","v":12000000},{"$f":"IFERROR(C11*(VLOOKUP(B4&B5,FACTORES!A2:D49,3,FALSE)),0)","v":252100.84033613448},{"$f":"D11*19%","v":47899.159663865554}]
["IVA Inmuebles comerciales",null,{"$f":"IF(AND(B3=\"Comercial\",E3=\"Si\"),A7*0.19*B5,0)","v":0},{"$f":"IFERROR(IF(AND(B3=\"Comercial\",E3=\"Si\"),C12*(VLOOKUP(B4&B5,FACTORES!A2:D49,3,FALSE)),0),0)","v":0},0]
["Administración",null,{"$f":"B7*B5","v":1200000},{"$f":"IFERROR(C13*(VLOOKUP(B4&B5,FACTORES!A2:D49,3,FALSE)),0)","v":25210.084033613446},4789.9159663865548]
["Servicios públicos",null,{"$f":"IF(B4=\"Básico\",0,IF(A7<=4000000,A7*2,IF(A7<=7999999,A7*1.5,15000000)))","v":2000000},0,0]
[{"$f":"IF(OR(B4=Listas!B2,B4=Listas!B5),\"\",\"Daños y faltantes\")","v":"Daños y faltantes"},null,{"$f":"IF(B4=\"Básico\",0,E7)","v":500000},{"$f":"C15*0.03","v":15000},2850]
["Asistencia",null,0,{"$f":"IF($C$7=\"No\",0,IF($B$3=\"Comercial\",55000,IF($B$3=\"Residencial\",55000,0)))","v":55000},{"$f":"D16*19%","v":10450}]
["TOTAL VALOR ASEGURADO",null,{"$f":"SUM(C11:C16)","v":15700000},{"$f":"IF(SUM(D11:D16)<150000,150000,SUM(D11:D16))","v":347310.92436974793},{"$f":"IF(D17=150000,D17*0.19,SUM(E11:E16))","v":65989.075630252104}]
["TOTAL A PAGAR",null,{"$f":"IF(G7<>\"\",\"Error\",D17+E17)","v":413300}]

{"sheet":"Listas","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
["Comercial","Básico","Si"]
["Residencial","Clásico","No"]
[null,"Global"]
[null,"Concesión de Espacios"]

{"sheet":"Impresión Comercial","index":2,"n_rows":35,"n_cols":5,"rows_kept":35,"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],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[38,0,38,4],[34,0,34,4],[35,0,35,4],[36,0,36,4],[21,0,21,4],[29,0,29,1],[32,0,32,1],[32,2,32,3],[27,0,27,1],[28,0,28,1],[22,0,22,1],[23,0,23,1],[25,0,25,1],[26,0,26,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":"2024-08-15"},"Vigencia final",{"$f":"B6+30","v":"2024-09-14"},{"$f":"Cotizador!#REF!","v":{"$error":"#REF!"}}]
["Número solicitud",null,"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!B3","v":"Residencial"}]
["Plan de arrendamiento",{"$f":"Cotizador!B4","v":"Clásico"},{"$f":"Cotizador!C4","v":0},{"$f":"Cotizador!D4","v":0},{"$f":"Cotizador!E4","v":0}]
["Duración contrato",{"$f":"Cotizador!B5","v":12}]
["Canon","Administración","Asistencia domiciliaria",null,{"$f":"IF(OR(B17=Listas!B2,B17=Listas!B5),\"\",\"Daños y faltantes\")","v":"Daños y faltantes"}]
[{"$f":"Cotizador!A7","v":1000000},{"$f":"Cotizador!B7","v":100000},{"$f":"Cotizador!C7","v":"Si"},null,{"$f":"Cotizador!E7","v":500000}]
[]
["Coberturas"]
[null,null,"Valor asegurado","Prima","IVA"]
["Básico arrendamiento",null,{"$f":"Cotizador!C11","v":12000000},{"$f":"Cotizador!D11","v":252100.84033613448},{"$f":"Cotizador!E11","v":47899.159663865554}]
["IVA Inmuebles Comerciales",null,{"$f":"Cotizador!C12","v":0},{"$f":"Cotizador!D12","v":0},{"$f":"Cotizador!E12","v":0}]
["Administración",null,{"$f":"Cotizador!C13","v":1200000},{"$f":"Cotizador!D13","v":25210.084033613446},{"$f":"Cotizador!E13","v":4789.9159663865548}]
["Servicios públicos",null,{"$f":"Cotizador!C14","v":2000000},{"$f":"Cotizador!D14","v":0},{"$f":"Cotizador!E14","v":0}]
["Daños y faltantes",null,{"$f":"Cotizador!C15","v":500000},{"$f":"Cotizador!D15","v":15000},{"$f":"Cotizador!E15","v":2850}]
["Asistencia",null,{"$f":"Cotizador!C16","v":0},{"$f":"Cotizador!D16","v":55000},{"$f":"Cotizador!E16","v":10450}]
["TOTAL VALOR ASEGURADO",null,{"$f":"SUM(C24:C29)","v":15700000},{"$f":"IF(SUM(D24:D29)<150000,150000,SUM(D24:D29))","v":347310.92436974793},{"$f":"SUM(E24:E29)","v":65989.075630252104}]
[]
["_____________________________________________________________________________________________"]
["TOTAL A PAGAR",null,{"$f":"Cotizador!C18","v":413300},{"$f":"Cotizador!D18","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":3,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":true,"merged":[[11,5,11,7]]}
["Plan","Meses","Tasa","Porcentaje sobre el canon",null,null,null,null,null,null,"Tasa - Comercial","Tasa - Residencial","Porcentaje sobre el canon - Comercial","Porcentaje sobre el canon - Residencial"]
["Básico1",1,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K2,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L2,\"Revisar\"))","v":1.6806722689075598E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M2,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N2,\"Revisar\"))","v":0.24},null,null,null,null,null,null,1.9607843137254902E-2,1.6806722689075598E-2,0.28000000000000003,0.24]
["Básico2",2,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K3,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L3,\"Revisar\"))","v":1.680672268907563E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M3,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N3,\"Revisar\"))","v":0.24},null,null,null,null,null,null,1.9607843137254902E-2,1.680672268907563E-2,0.28000000000000003,0.24]
["Básico3",3,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K4,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L4,\"Revisar\"))","v":1.680672268907563E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M4,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N4,\"Revisar\"))","v":0.24},null,null,null,null,null,null,1.9607843137254902E-2,1.680672268907563E-2,0.28000000000000003,0.24]
["Básico4",4,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K5,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L5,\"Revisar\"))","v":1.680672268907563E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M5,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N5,\"Revisar\"))","v":0.24},null,null,null,null,null,null,1.9607843137254902E-2,1.680672268907563E-2,0.28000000000000003,0.24]
["Básico5",5,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K6,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L6,\"Revisar\"))","v":1.680672268907563E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M6,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N6,\"Revisar\"))","v":0.24},null,null,null,null,null,null,1.9607843137254902E-2,1.680672268907563E-2,0.28000000000000003,0.24]
["Básico6",6,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K7,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L7,\"Revisar\"))","v":1.680672268907563E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M7,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N7,\"Revisar\"))","v":0.24},null,null,null,null,null,null,1.9607843137254902E-2,1.680672268907563E-2,0.28000000000000003,0.24]
["Básico7",7,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K8,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L8,\"Revisar\"))","v":1.5406162464985995E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M8,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N8,\"Revisar\"))","v":0.22},null,null,null,null,null,null,1.7966666666666666E-2,1.5406162464985995E-2,0.26,0.22]
["Básico8",8,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K9,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L9,\"Revisar\"))","v":1.4005602240896359E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M9,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N9,\"Revisar\"))","v":0.2},null,null,null,null,null,null,1.6333333333333332E-2,1.4005602240896359E-2,0.23,0.2]
["Básico9",9,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K10,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L10,\"Revisar\"))","v":1.4005602240896401E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M10,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N10,\"Revisar\"))","v":0.2},null,null,null,null,null,null,1.6333333333333332E-2,1.4005602240896401E-2,0.23,0.2]
["Básico10",10,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K11,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L11,\"Revisar\"))","v":1.4005602240896359E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M11,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N11,\"Revisar\"))","v":0.2},null,null,null,null,null,null,1.6333333333333332E-2,1.4005602240896359E-2,0.23,0.2]
["Básico11",11,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K12,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L12,\"Revisar\"))","v":1.4005602240896359E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M12,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N12,\"Revisar\"))","v":0.2},null,"Daños y faltantes",null,null,null,null,1.6333333333333332E-2,1.4005602240896359E-2,0.23,0.2]
["Básico12",12,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K13,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L13,\"Revisar\"))","v":1.4005602240896359E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M13,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N13,\"Revisar\"))","v":0.2},null,"Vivienda",300000,20000000,null,null,1.6333333333333332E-2,1.4005602240896359E-2,0.23,0.2]
["Clásico1",1,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K14,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L14,\"Revisar\"))","v":2.5210084033613446E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M14,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N14,\"Revisar\"))","v":0.36},null,"Comercial",300000,40000000,null,null,2.9411764705882353E-2,2.5210084033613446E-2,0.42,0.36]
["Clásico2",2,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K15,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L15,\"Revisar\"))","v":2.5210084033613401E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M15,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N15,\"Revisar\"))","v":0.36},null,null,null,null,null,null,2.9411764705882353E-2,2.5210084033613401E-2,0.42,0.36]
["Clásico3",3,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K16,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L16,\"Revisar\"))","v":2.5210084033613446E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M16,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N16,\"Revisar\"))","v":0.36},null,null,null,null,null,null,2.9411764705882353E-2,2.5210084033613446E-2,0.42,0.36]
["Clásico4",4,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K17,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L17,\"Revisar\"))","v":2.5210084033613446E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M17,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N17,\"Revisar\"))","v":0.36},null,null,null,null,null,null,2.9411764705882353E-2,2.5210084033613446E-2,0.42,0.36]
["Clásico5",5,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K18,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L18,\"Revisar\"))","v":2.5210084033613446E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M18,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N18,\"Revisar\"))","v":0.36},null,null,null,null,null,null,2.9411764705882353E-2,2.5210084033613446E-2,0.42,0.36]
["Clásico6",6,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K19,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L19,\"Revisar\"))","v":2.5210084033613446E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M19,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N19,\"Revisar\"))","v":0.36},null,null,null,null,null,null,2.9411764705882353E-2,2.5210084033613446E-2,0.42,0.36]
["Clásico7",7,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K20,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L20,\"Revisar\"))","v":2.3109243697478993E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M20,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N20,\"Revisar\"))","v":0.33},null,null,null,null,null,null,2.6610648259303721E-2,2.3109243697478993E-2,0.38,0.33]
["Clásico8",8,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K21,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L21,\"Revisar\"))","v":2.100840336134454E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M21,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N21,\"Revisar\"))","v":0.3},null,null,null,null,null,null,2.4509803921568627E-2,2.100840336134454E-2,0.35,0.3]
["Clásico9",9,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K22,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L22,\"Revisar\"))","v":2.1008403361344501E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M22,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N22,\"Revisar\"))","v":0.3},null,null,null,null,null,null,2.4509803921568627E-2,2.1008403361344501E-2,0.35,0.3]
["Clásico10",10,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K23,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L23,\"Revisar\"))","v":2.100840336134454E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M23,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N23,\"Revisar\"))","v":0.3},null,null,null,null,null,null,2.4509803921568627E-2,2.100840336134454E-2,0.35,0.3]
["Clásico11",11,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K24,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L24,\"Revisar\"))","v":2.100840336134454E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M24,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N24,\"Revisar\"))","v":0.3},null,null,null,null,null,null,2.4509803921568627E-2,2.100840336134454E-2,0.35,0.3]
["Clásico12",12,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K25,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L25,\"Revisar\"))","v":2.100840336134454E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M25,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N25,\"Revisar\"))","v":0.3},null,null,null,null,null,null,2.4509803921568627E-2,2.100840336134454E-2,0.35,0.3]
["Global1",1,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K26,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L26,\"Revisar\"))","v":4.2016806722689072E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M26,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N26,\"Revisar\"))","v":0.6},null,null,null,null,null,null,4.2016806722689072E-2,4.2016806722689072E-2,0.6,0.6]
["Global2",2,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K27,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L27,\"Revisar\"))","v":4.2016806722689072E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M27,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N27,\"Revisar\"))","v":0.6},null,null,null,null,null,null,4.2016806722689072E-2,4.2016806722689072E-2,0.6,0.6]
["Global3",3,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K28,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L28,\"Revisar\"))","v":4.2016806722689072E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M28,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N28,\"Revisar\"))","v":0.6},null,null,null,null,null,null,4.2016806722689072E-2,4.2016806722689072E-2,0.6,0.6]
["Global4",4,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K29,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L29,\"Revisar\"))","v":4.2016806722689072E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M29,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N29,\"Revisar\"))","v":0.6},null,null,null,null,null,null,4.2016806722689072E-2,4.2016806722689072E-2,0.6,0.6]
["Global5",5,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K30,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L30,\"Revisar\"))","v":4.2016806722689072E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M30,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N30,\"Revisar\"))","v":0.6},null,null,null,null,null,null,4.2016806722689072E-2,4.2016806722689072E-2,0.6,0.6]
["Global6",6,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K31,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L31,\"Revisar\"))","v":4.2016806722689072E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M31,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N31,\"Revisar\"))","v":0.6},null,null,null,null,null,null,4.2016806722689072E-2,4.2016806722689072E-2,0.6,0.6]
["Global7",7,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K32,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L32,\"Revisar\"))","v":3.853501400560224E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M32,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N32,\"Revisar\"))","v":0.55027999999999999},null,null,null,null,null,null,3.853501400560224E-2,3.853501400560224E-2,0.55000000000000004,0.55027999999999999]
["Global8",8,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K33,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L33,\"Revisar\"))","v":3.5014005602240897E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M33,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N33,\"Revisar\"))","v":0.5},null,null,null,null,null,null,3.5014005602240897E-2,3.5014005602240897E-2,0.5,0.5]
["Global9",9,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K34,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L34,\"Revisar\"))","v":3.5014005602240897E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M34,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N34,\"Revisar\"))","v":0.5},null,null,null,null,null,null,3.5014005602240897E-2,3.5014005602240897E-2,0.5,0.5]
["Global10",10,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K35,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L35,\"Revisar\"))","v":3.5014005602240897E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M35,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N35,\"Revisar\"))","v":0.5},null,null,null,null,null,null,3.5014005602240897E-2,3.5014005602240897E-2,0.5,0.5]
["Global11",11,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K36,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L36,\"Revisar\"))","v":3.5014005602240897E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M36,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N36,\"Revisar\"))","v":0.5},null,null,null,null,null,null,3.5014005602240897E-2,3.5014005602240897E-2,0.5,0.5]
["Global12",12,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K37,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L37,\"Revisar\"))","v":3.5014005602240897E-2},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M37,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N37,\"Revisar\"))","v":0.5},null,null,null,null,null,null,3.5014005602240897E-2,3.5014005602240897E-2,0.5,0.5]
["Concesión de Espacios1",1,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K38,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L38,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M38,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N38,\"Revisar\"))","v":0},null,null,null,null,null,null,2.9411764705882353E-2,null,0.42]
["Concesión de Espacios2",2,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K39,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L39,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M39,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N39,\"Revisar\"))","v":0},null,null,null,null,null,null,2.9411764705882353E-2,null,0.42]
["Concesión de Espacios3",3,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K40,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L40,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M40,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N40,\"Revisar\"))","v":0},null,null,null,null,null,null,2.9411764705882353E-2,null,0.42]
["Concesión de Espacios4",4,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K41,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L41,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M41,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N41,\"Revisar\"))","v":0},null,null,null,null,null,null,2.9411764705882353E-2,null,0.42]
["Concesión de Espacios5",5,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K42,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L42,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M42,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N42,\"Revisar\"))","v":0},null,null,null,null,null,null,2.9411764705882353E-2,null,0.42]
["Concesión de Espacios6",6,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K43,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L43,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M43,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N43,\"Revisar\"))","v":0},null,null,null,null,null,null,2.9411764705882353E-2,null,0.42]
["Concesión de Espacios7",7,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K44,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L44,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M44,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N44,\"Revisar\"))","v":0},null,null,null,null,null,null,2.6610648259303721E-2,null,0.38]
["Concesión de Espacios8",8,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K45,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L45,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M45,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N45,\"Revisar\"))","v":0},null,null,null,null,null,null,2.4509803921568627E-2,null,0.35]
["Concesión de Espacios9",9,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K46,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L46,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M46,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N46,\"Revisar\"))","v":0},null,null,null,null,null,null,2.4509803921568627E-2,null,0.35]
["Concesión de Espacios10",10,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K47,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L47,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M47,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N47,\"Revisar\"))","v":0},null,null,null,null,null,null,2.4509803921568627E-2,null,0.35]
["Concesión de Espacios11",11,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K48,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L48,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M48,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N48,\"Revisar\"))","v":0},null,null,null,null,null,null,2.4509803921568627E-2,null,0.35]
["Concesión de Espacios12",12,{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!K49,IF(Cotizador!$B$3=\"Residencial\",FACTORES!L49,\"Revisar\"))","v":0},{"$f":"IF(Cotizador!$B$3=\"Comercial\",FACTORES!M49,IF(Cotizador!$B$3=\"Residencial\",FACTORES!N49,\"Revisar\"))","v":0},null,null,null,null,null,null,2.4509803921568627E-2,null,0.35]

{"sheet":"COTIZADOR APLICATIVO","index":4,"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":427200}]
[{"$f":"Cotizador!A7","v":1000000},{"$f":"Cotizador!C13","v":1200000},{"$f":"Cotizador!C14","v":2000000},{"$f":"Cotizador!E7","v":500000},{"$f":"Cotizador!C7","v":"Si"},null,null,"Tasa Aplicativo %º",35.6]
[]
[null,"Valor asegurado","Tasa Aplicativo","Valor Prima Antes de IVA"]
["Canon",{"$f":"Cotizador!C11","v":12000000},{"$f":"I11","v":21.008403361344541},{"$f":"Cotizador!D11","v":252100.84033613448},null,null,null,"Valor Prima Antes de IVA",{"$f":"Cotizador!D11","v":252100.84033613448}]
["Administración",{"$f":"B7","v":1200000},{"$f":"I11","v":21.008403361344541},{"$f":"Cotizador!D13","v":25210.084033613446},null,null,null,"Tasa Aplicar",{"$f":"(I10*I7)/I6","v":21.008403361344541}]
["Servicios Públicos",{"$f":"C7","v":2000000},"-","-",null,null,null,"Tasa Daños y faltantes",52]
["Daños y Faltantes",{"$f":"D7","v":500000},{"$f":"I12","v":52},{"$f":"Cotizador!D15","v":15000}]
["Asistencia",{"$f":"Cotizador!C16","v":0},"-",{"$f":"Cotizador!D16","v":55000}]
[]
[null,null,"Total antes de IVA",{"$f":"SUM(D10:D14)","v":347310.92436974793}]
[null,null,"IVA",{"$f":"SUM(Cotizador!E11:E16)","v":65989.075630252104}]
[null,null,"TOTAL",{"$f":"D16+D17","v":413300}]