{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["COTIZACION"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"COTIZACION","index":0,"n_rows":108,"n_cols":24,"rows_kept":108,"cut":false,"hidden":false,"merged":[[29,15,29,18],[6,1,7,3],[11,2,11,3],[48,2,48,3],[82,1,82,3],[15,1,15,3],[25,2,25,3],[104,1,104,3],[105,1,105,3],[106,1,106,3],[107,1,107,3],[1,5,1,6],[8,2,8,3],[9,2,9,3],[10,2,10,3],[12,2,12,3],[7,5,7,6],[8,5,8,6],[97,1,97,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tasas:",null,null,"Tipo de Poliza:",null,null,"Coberturas:",null,null,null,"Rubros:"]
[null,null,null,{"$f":"NOW()","v":"2016-07-01T12:23:43.010"},null,"CUADRO DE TASAS",null,null,null,null,"Control coberturas",null,null,"Incendio y sublimites",{"$f":"IF(M7=0,0.16%,0.2%)","v":1.6000000000000001E-3},null,"Riesgos Nombrados",null,null,"Remocion de Escombros  ",null,null,null,"Edificio e Instalaciones"]
[null,null," ",null,null,null,null,null,null,"Robo",{"$f":"C23*25%","v":7500},null,null,"Robo",7.0000000000000001E-3,null,"Todo Riesgo para Propiedades",null,null,"Honorarios de Ingenieros, Arquitectos y Topografos  ",null,null,null,"Contenido"]
[null,null,null,null,null,null,null,null,null,"Rc",{"$f":"IF((C22+C23)>K22,K21,(C22+C23)*50%)","v":56500},null,null,"Responsabilidad Civil",7.0000000000000001E-3,null,null,null,null,"Documentos y Modelos",null,null,null,"Equipo Electrónico"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipo Electrónico",8.0000000000000002E-3,null,"Clasificacion:",null,null,"Clausula Electrica",null,null,null,"Mercaderias"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Maremoto","NO",0,null,"Casa Habitacion",null,null,"Gastos de Extincion de Incendio",null,null,null,"Maquinarias"]
[null,"COTIZACIÓN INCENDIO CASA HABITACION",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(G11,N6:O7,2)","v":0},"SI",1,null,"Condominio de Apartamentos",null,null,"Vidrios y Cristales"]
[null,null,null,null,null,"ADJUNTOS A IMPRIMIR",null,null,null,null,null,null,null,null,null,null,null,null,null,"Arrendamiento USD$ 500 por mes, maximo 3 meses"]
[null,"EJECUTIVO (a)",null,null,null,"Anexo Asitencia Hogar"]
[null,"BROKER:"]
[null,"CLIENTE:",null,null,null,"DESEA COBERTURA DE MAREMOTO?","NO",null,null,null,"Rango EE"]
[null,"CLASIFICACION:","Casa - Habitacion",null,null,null,null,null,null,null,0]
[null,"TIPO DE DOCUMENTO:","Poliza Nueva",null,null,null,null,null,null,{"$f":"C24","v":3000},{"$f":"IF(C24>L13,K12,C23*10%)","v":3000},{"$f":"C23*10%","v":3000}]
[]
[null,"UBICACIÓN:",null,null,null,null,null,null,{"$f":"C22","v":80000},null,"rango robo","rango SA"]
[null,null,null,null,null,null,null,null,{"$f":"C23","v":30000},null,0,1]
[null,"DETALLE DE RUBROS :","SUMA ASEGURADA",null,null,null,null,null,null,{"$f":"C23*30%","v":9000},{"$f":"IF(C23>70000,70000,C23*30%)","v":9000},1000000]
[null,"Incendio: Incendio, Caida de Rayo, Terremoto, Temblor, Lluvia e Inundación, Erupción Volcánica, Conmoción",null,null,null,null,null,null,null,null,null,null,null,null,null,"INTERES",15]
[null,"Civil, Huelga, Motín, Alborotos Populares, Explosión, Cobertura Extendida, Explosion, Daños por Agua, Colapso,",null,null,null,null,null,null,null,null,"Rango RC",null,null,null,null,"CUOTA MINIMA",50]
[null,{"$f":"IF(M7=1,\"Incluye Maremoto.\",\"Excluye Maremoto.\")","v":"Excluye Maremoto."},null,null,null,null,null,null,null,{"$f":"C22+C23+C24","v":113000},0,null,null,null,null,"cuota",{"$f":"ROUND(D52/C50,2)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,"accidentes",null,{"$f":"IF(L21>100000,K22,(C22+C23+C24)*50%)","v":56500},{"$f":"(C22+C23+C24)*50%","v":56500},null,null,null,"total",{"$f":"Q20*I18","v":{"$error":"#VALUE!"}}]
[null,"Edificio e Instalaciones",80000,null,null,null,null,null,5000,null,100000,null,null,null,null,"diferencia",{"$f":"I19-Q21","v":{"$error":"#VALUE!"}}]
[null,"Contenido",30000,null,null,null,null,null,1000,null,"descuento",null,null,null,null,"cuota inicial",{"$f":"Q20+Q22","v":{"$error":"#VALUE!"}},{"$f":"Q20*(I18-1)","v":{"$error":"#VALUE!"}},{"$f":"R23+Q23","v":{"$error":"#VALUE!"}},"."]
[null,"Equipo Electrónico:",3000,null,null,null,null,null,500,null,0.03,null,null,null,null,"ncuotas",{"$f":"C50-1","v":{"$error":"#VALUE!"}}]
[null,null," ",null,null,null,null,null,100,null,{"$f":"D47*K24","v":26.184899999999999}]
[null,"SUMA ASEGURADA TOTAL INCENDIO:",{"$f":"IF(C22+C23+C24>500000,\"ERROR: SOLO PUEDE COTIZAR HASTA $500.000\",C22+C23+C24)","v":113000},null,null,null,null,null,null,null,{"$f":"ROUND(D47-K25,2)","v":846.65}]
[null,null,null,{"$f":"C26*O2","v":180.8},null,null,null,null,0]
[null,"COBERTURAS ADICIONALES:",0.3,null,null,null,null,null,1,35]
[null,"Robo y/o Asalto a Primer Riesgo ( Contenido):",9000,{"$f":"C29*O3","v":63},null,null,null,"Pago de Accidentes",2,{"$f":"2*35*95%","v":66.5},null,null,null,null,3.5000000000000003E-2]
[null,"Equipo Electrónico (Incluye Robo):",3000,{"$f":"C30*O5","v":24},null,null,null,{"$f":"VLOOKUP(C33,I27:J37,2,FALSE)","v":35},3,{"$f":"2*35*90%","v":63},null,null,null,null,5.0000000000000001E-3,"calculo de derecho de póliza"]
[null,"Responsabilidad Civil:",56500,{"$f":"C31*O4","v":395.5},null,null,null,null,4,{"$f":"2*35*85%","v":59.5},null,null,null,null,{"$f":"Q31","v":3},null,{"$f":"SUM(Q32:Q37)","v":3}]
[null,null,null,{"$f":"35","v":35},null,null,null,"Prima Minima",5,{"$f":"2*35*80%","v":56},null,null,null,null,null,0.5,{"$f":"IF($D$40>=R32,IF($D$40<=S32,P32,0),0)","v":0},0,251]
[null,"ACCIDENTES PERSONALES (Miembros de la Familia):",1,{"$f":"IF(C33>9,\" (Hasta 70 años)\", \" \")","v":" "},null,null,null,{"$f":"ROUND(SUM(D27:D34),2)","v":733.3},6,{"$f":"2*35*80%","v":56},null,null,null,{"$f":"VLOOKUP(C49,P42:S43,3,FALSE)","v":3},null,1,0,251,501]
[null,"Muerte Accidental e Invalidez hasta $ 5.000 C/U",{"$f":"I22*C33","v":5000},{"$f":"H30","v":35},null,null,null,100,7,56,null,null,null,null,null,3,3,501,1001]
[null,"Gastos Medicos hasta $ 1.000 C/U",{"$f":"I23*C33","v":1000},null,null,null,null,null,8,56,null,null,null,null,0.12,5,0,1001,2001]
[null,"Gastos de Sepelio",{"$f":"IF(H30>0,500,0)","v":500},null,null,null,null,null,9,56,null,null,null,null,null,7,0,2001,4001]
[null,"Gastos de Ambulancia",{"$f":"IF(H30>0,100,0)","v":100},null,null,null,null,null,10,56,null,null,null,null,null,9,0,4001,999999]
[null,"COSTOS:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C49,P42:S44,4,FALSE)","v":""}]
[]
[null,"Prima Neta:",null,{"$f":"IF(H33<100,H34,H33)","v":733.3}]
[null,"Super Intendencia de Bancos 3.5%",null,{"$f":"ROUND(D40*3.5%,2)","v":25.67},null,null,null,null,null,3,null,null,null,null,null,"tipos de crédito"]
[null,"Seguro Social Campesino 0.50%",null,{"$f":"ROUND(D40*0.5%,2)","v":3.67},null,null,null,null,null,6,null,null,null,null,null,"Contado","",3,""]
[null,"Derecho de Emision",null,{"$f":"O31","v":3},null,null,null,null,null,12,null,null,null,null,null,"Diferido con Tarjeta de Credito",2,2,"Cuotas"]
[null,"Subtotal:",null,{"$f":"ROUND(SUM(D40:D43),2)","v":765.64}]
[null,"Iva 14%",null,{"$f":"ROUND(D44*14%,2)","v":107.19}]
[]
[null,"PRIMA TOTAL",null,{"$f":"ROUND(SUM(D44:D45),2)","v":872.83}]
[]
[null,"FORMAS DE PAGO:","Contado"]
[null,{"$f":"VLOOKUP(C49,P42:S43,4,FALSE)","v":""}," "]
[null,null,null,{"$f":"IF(N33=2,\"___________\",\"\")","v":""}]
[null,{"$f":"IF(N33=3,\"Valor a Pagar con Descuento\", \"Valor a Pagar\")","v":"Valor a Pagar con Descuento"},null,{"$f":"IF(N33=2,F45+D47,K26)","v":846.65}]
[]
[null,{"$f":"IF(N33<>3,\"Cuota inicial de \",\"\")","v":""},{"$f":"IF(N33<>3,Q23,\"\")","v":""}]
[null,{"$f":"IF(N33<>3,CONCATENATE(\"Y \",Q24,\" \",O38,\" de\"),\"\")","v":""},{"$f":"IF(N33<>3,Q20,\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,{"$f":"NOW()","v":"2016-07-01T12:23:43.010"}]
[]
[null,"CONDICIONES A REFLEJARSE EN IMPRESIÓN FINAL:"]
[]
[]
[]
[null,"SUBLIMITES INCLUIDOS EN LA SUMA ASEGURADA:"]
[null,{"$f":"IF(C33>0,\"Coberturas de Accidentes Personales Empleados Domesticos ( Por Evento y en Agregado), hasta 2 personas\",\" \")","v":"Coberturas de Accidentes Personales Empleados Domesticos ( Por Evento y en Agregado), hasta 2 personas"}]
[null,"Gastos de Arriendo en caso de no accesibilidad a la vivienda (500 mensuales, hasta 3 meses)"]
[null,"Remocion de Escombros ( Por Evento y en Agregado)",null,10000]
[null,"Honorarios de Ingenieros, Arquitectos y Topografos (Por Evento y en Agregado)",null,5000]
[null,"Rotura de Vidrios (Por Evento y en Agregado)",null,2500]
[null,"Rotura de Maquinaria",null,2000]
[null,{"$f":"IF(C23>0,\"Clausula Electrica\",\" \")","v":"Clausula Electrica"},null,{"$f":"IF(C23>0,2500,\" \")","v":2500}]
[]
[null,"AMPAROS ADICIONALES"]
[]
[null,"Asistencia Hogar"]
[null,"Pago de Prima (15 días)"]
[null,"Cancelación de Póliza (30 días)"]
[null,"Plazo para reportar siniestros (7 días)"]
[null,"Destrucción Preventiva"]
[null,"Autoridad Civil"]
[null,"Restitución Automatica de la Suma Asegurada "]
[]
[null,"EXCLUSIONES:"]
[]
[null,"Bienes Excluidos:"]
[null,"Terreno y cimientos."]
[null,"Títulos y/o valores"]
[null,"Dinero, joyas, pieles"]
[null,"Vehículos"]
[null,"Obras de Arte"]
[null,{"$f":"IF(C24>0,\"Equipos fuera del Predio Asegurado (Portabilidad)\",\" \")","v":"Equipos fuera del Predio Asegurado (Portabilidad)"}]
[]
[null,"DEDUCIBLES:"]
[]
[null,"Fenómenos de la Naturaleza y demás Eventos Catastróficos:"]
[null,"2% de la suma total asegurada, no menor a USD 2.000"]
[null,"Otros eventos Daños Materiales:"]
[null,"10% del valor del siniestro, minimo USD 250.00"]
[null,{"$f":"IF(C33>0,\"Accidentes Personales:\",\" \")","v":"Accidentes Personales:"}]
[null,{"$f":"IF(C33>0,\"USD 50.00 Gastos Medicos\",\" \")","v":"USD 50.00 Gastos Medicos"}]
[]
[]
[null,"Notas: La presente cotizacion tendra validez por 30 dias y sus Condiciones estan sujetas a la inspeccion del predio."]
[null,"             En caso de Siniestro el Asegurado deberá contar con los documentos que demuestren la preexistencia de los "]
[null,"             bienes asegurados, caso contrario proporcionará un listado detallado y valorizado de los bienes que superen "]
[null,"             individualmente los USD 500.00, previo a la emision de la Poliza."]