{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CasaPLUS","CasaMAR"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"CasaPLUS","index":0,"n_rows":105,"n_cols":33,"rows_kept":105,"cut":false,"hidden":false,"merged":[[41,2,41,4],[42,2,42,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[39,2,40,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,22],[39,9,40,9],[39,10,40,10],[39,5,40,7],[19,29,19,30],[19,27,19,28],[19,25,19,26],[33,5,34,5],[15,13,15,14],[19,5,20,5],[19,8,19,9],[33,6,34,6],[17,15,17,17],[33,8,34,8],[33,9,34,9],[33,10,34,10],[22,8,27,8],[22,9,27,9],[22,10,27,10],[33,7,34,7],[1,2,1,22],[8,3,8,22],[7,17,7,18],[7,11,7,13],[7,4,7,8],[5,11,5,13],[5,14,5,18],[7,14,7,16],[43,2,43,4],[44,2,44,4],[45,2,46,4],[51,2,51,4],[47,2,47,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[52,2,52,4],[53,2,53,4],[131,2,131,3],[132,2,132,3],[55,2,55,4],[80,2,80,8],[76,2,76,3],[54,2,54,4],[69,2,69,22],[77,2,78,22],[57,2,57,21],[45,5,46,5],[25,19,25,20],[29,19,29,20],[32,19,32,20],[39,19,39,20],[41,19,41,20],[23,5,26,7],[45,6,46,6],[45,7,46,7],[39,8,40,8],[40,11,40,18],[133,2,133,3],[83,2,83,22],[129,2,129,3],[130,2,130,3],[100,2,104,2],[12,21,12,22],[12,18,12,19],[12,15,12,16],[26,11,26,22],[3,3,3,22],[10,14,10,16],[9,14,9,16],[19,11,20,22],[22,5,22,7],[21,2,21,22],[19,6,20,6],[19,7,20,7],[22,2,27,4],[19,2,20,4]]}
[]
[null,null,"COTIZACIÓN SEGURO DOMICILIARIO CASAPLUS "]
[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,"Dólares ( US$ )",null,"A. Programa Básico",null,null,null,"Concreto Armado"]
[null,null,"Contratante",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sol ( S/ )",null,"B. Programa Básico + Programa Full",null,null,null,"Ladrillo y Cemento"]
[null,null,"Asegurado",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,null,"Estructura de Acero"]
[null,null,"Corredor",null,null,null,null,null,null,null,"Oficina ",null,null,null,"Ejecutivo Comercial ",null,null,null,null,null,null,null,null,null,null,null,"Tipo de Cambio",4,null,null,null,null,"Madera y/o Adobe y/o quincha"]
[null,null,"Ubicación del riesgo"]
[null,null,"Datos SBS","Tipo Estructura","Concreto Armado",null,null,null,null,{"$f":"IF(E8=AG6,\"No cotizar\",\" \")","v":" "},"Año Construc.",null,null,null,"Nro. Pisos",null,null,null,null,"Nro. Sótanos"]
[null,null,"COBERTURAS SOLICITADAS","B. Programa Básico + Programa Full"]
[null,null,"Vigencia","1 Año ",null,null,null,null,null,null,"Fecha de Cotización",null,null,null,{"$f":"TODAY()","v":"2020-01-15"}]
[null,null,"Moneda","Dólares ( US$ )",null,null,null,null,null,null,"Validez de la Cotización",null,null,null,"15 días "]
[]
[null,null,"Valores Declarados",{"$f":"D11","v":"Dólares ( US$ )"},null,null,null,null,null,null,"Primas ",null,null,null,null,"Plan Estandar",null,null,"Plan Premium",null,null,"Plan Gold"]
[null,null," - Vivienda (Edificio)",40000,null,null,null,null,null,null,"Prima Comercial",null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF(AND($D$11=\"Dólares ( US$ )\",(I99<100)),100,IF(AND($D$11=\"Sol ( S/ )\",I99<325),325,I99))","v":100},null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF(AND($D$11=\"Dólares ( US$ )\",(J99<100)),100,IF(AND($D$11=\"Sol ( S/ )\",J99<325),325,J99))","v":"No Aplica"},null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF(AND($D$11=\"Dólares ( US$ )\",(K99<100)),100,IF(AND($D$11=\"Sol ( S/ )\",K99<325),325,K99))","v":"No aplica"}]
[null,null," - Contenido",0,null,null,null,null,null,null,"Prima Comercial + IGV Anual",null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"+Q14*1.18","v":118},null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF(T14=\"No Aplica\",\"No aplica\",T14*1.18)","v":"No aplica"},null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF(W14=\"No aplica\",\"No aplica\",W14*1.18)","v":"No aplica"}]
[null,null,"TOTAL ASEGURADO",{"$f":"SUM(D14:D15)","v":40000},null,null,null,null,null,null,"Descuento",null,null,0,null,{"$f":"IF(N16>0%,\"Ver con Area Técnica LP\",\" \")","v":" "}]
[null,null,null,{"$f":"+IF(D9=AC3,1,0)","v":0},null,null,null,null,null,null,"Prima Comercial + IGV Anual",null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF(AND($D$11=\"Dólares ( US$ )\",(Q14*(1-N16)<118)),118,IF(AND($D$11=\"Sol ( S/ )\",Q14*(1-N16)<400),400,Q15*(1-N16)))","v":118},null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF(T14=\"No Aplica\",\"No aplica\",IF(AND($D$11=\"Dólares ( US$ )\",(T15*(1-N16)<118)),118,IF(AND($D$11=\"Sol ( S/ )\",T15*(1-N16)<383.5),383.5,T15*(1-N16))))","v":"No aplica"},null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF(W14=\"No aplica\",\"No aplica\",IF(AND($D$11=\"Dólares ( US$ )\",(W15*(1-N16)<118)),118,IF(AND($D$11=\"Sol ( S/ )\",W15*(1-N16)<383.5),383.5,W15*(1-N16))))","v":"No aplica"}]
[]
[]
[null,null,"Coberturas Principales",null,null,"SA Maxima Plan Estandar","SA Maxima Plan Premium","SA Maxima Plan Gold","Suma Asegurada",null,{"$f":"+D11","v":"Dólares ( US$ )"},"Deducibles",null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan Estandar",null,"Plan Premium",null,"Plan Gold",null,"deducibles minimos en dolares"]
[null,null,null,null,null,null,null,null,"P. Estandar","P. Premium","P. Gold",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SA Dolares","SA Soles ","SA Dolares","SA Soles ","SA Dolares","SA Soles "]
[null,null,"I. PROGRAMA BASICO"]
[null,null,"Incendio, Riesgos de la Naturaleza y Riesgos Politicos \nEste seguro cubre la destrucción o daño físico directo de la vivienda y su contenido como consecuencia directa de: incendio, explosión, daños por agua, lluvia e inundación, terremoto, temblor, erupción volcánica, maremoto (Tsunami), caída de aeronaves, impacto de vehículos, daños por humo, huelga y conmoción civil, daño malicioso, vandalismo y/o terrorismo.",null,null,null,null,null,{"$f":"+D16","v":40000},{"$f":"+D16","v":40000},{"$f":"+D16","v":40000},"Todo evento cubierto: 10% del Monto Indemnizable mínimo"]
[null,null,null,null,null,"Hasta el 100% de la Suma Asegurada (SA) de la Vivienda + Contenido",null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF24,(AF24*$AB$6))","v":200},",excepto:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200]
[null,null,null,null,null,null,null,null,null,null,null,"Huelga, conmoción civil, daño malicioso, vandalismo y/o  terrorismo: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200]
[null,null,null,null,null,null,null,null,null,null,null,"5% del monto indemnizable mínimo",null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF25,(AF25*$AB$6))","v":200}]
[null,null,null,null,null,null,null,null,null,null,null,"Terremoto, temblor erupción volcánica, maremoto (tsunami), salida de mar, marejada, oleaje: 1% de la Suma Asegurada de la Vivienda ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500]
[null,null,null,null,null,null,null,null,null,null,null,"+ Contenido, minimo",null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF27,(AF27*$AB$6))","v":500},null,",lo que resulte mayor"]
[null,null,"Coberturas Adicionales "]
[null,null,"Rotura de vidrios, espejos y unidades sanitarias, hasta el 20% de la Suma Asegurada de la Vivienda, máximo: ",null,null,10000,20000,30000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z30,AA30)","v":8000},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB30,AC30)","v":8000},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD30,AE30)","v":8000},"10% del Monto Indemnizable, mínimo",null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF30,(AF30*$AB$6))","v":30},null,null,null,null,null,{"$f":"IF($D$14*0.2<F30,$D$14*0.2,F30)","v":8000},{"$f":"IF($D$14*0.2<F30*$AB$6,$D$14*0.2,F30*$AB$6)","v":8000},{"$f":"IF($D$14*0.2<G30,$D$14*0.2,G30)","v":8000},{"$f":"IF($D$14*0.2<G30*$AB$6,$D$14*0.2,G30*$AB$6)","v":8000},{"$f":"IF($D$14*0.2<H30,$D$14*0.2,H30)","v":8000},{"$f":"IF($D$14*0.2<H30*$AB$6,$D$14*0.2,H30*$AB$6)","v":8000},30]
[null,null,"Gastos de remoción de escombros, hasta el 20% de la Suma Asegurada de la Vivienda + Contenido, máximo:",null,null,30000,40000,50000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z31,AA31)","v":8000},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB31,AC31)","v":8000},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD31,AE31)","v":8000},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$16*0.2<F31,$D$16*0.2,F31)","v":8000},{"$f":"IF($D$16*0.2<F31*$AB$6,$D$16*0.2,F31*$AB$6)","v":8000},{"$f":"IF($D$16*0.2<G31,$D$16*0.2,G31)","v":8000},{"$f":"IF($D$16*0.2<G31*$AB$6,$D$16*0.2,G31*$AB$6)","v":8000},{"$f":"IF($D$16*0.2<H31,$D$16*0.2,H31)","v":8000},{"$f":"IF($D$16*0.2<H31*$AB$6,$D$16*0.2,H31*$AB$6)","v":8000}]
[null,null,"Gastos de extinción y contención del siniestro, hasta el 20% de la Suma Asegurada de la Vivienda + Contenido, máximo:",null,null,30000,40000,50000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z32,AA32)","v":8000},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB32,AC32)","v":8000},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD32,AE32)","v":8000},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$16*0.2<F32,$D$16*0.2,F32)","v":8000},{"$f":"IF($D$16*0.2<F32*$AB$6,$D$16*0.2,F32*$AB$6)","v":8000},{"$f":"IF($D$16*0.2<G32,$D$16*0.2,G32)","v":8000},{"$f":"IF($D$16*0.2<G32*$AB$6,$D$16*0.2,G32*$AB$6)","v":8000},{"$f":"IF($D$16*0.2<H32,$D$16*0.2,H32)","v":8000},{"$f":"IF($D$16*0.2<H32*$AB$6,$D$16*0.2,H32*$AB$6)","v":8000}]
[null,null,"Robo de instalaciones fijas, hasta el 20% de la Suma Asegurada de la Vivienda, máximo:",null,null,10000,20000,30000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z33,AA33)","v":8000},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB33,AC33)","v":8000},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD33,AE33)","v":8000},"15% del Monto Indemnizable, mínimo",null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF33,(AF33*$AB$6))","v":200},null,null,null,null,null,{"$f":"IF($D$14*0.2<F33,$D$14*0.2,F33)","v":8000},{"$f":"IF($D$14*0.2<F33*$AB$6,$D$14*0.2,F33*$AB$6)","v":8000},{"$f":"IF($D$14*0.2<G33,$D$14*0.2,G33)","v":8000},{"$f":"IF($D$14*0.2<G33*$AB$6,$D$14*0.2,G33*$AB$6)","v":8000},{"$f":"IF($D$14*0.2<H33,$D$14*0.2,H33)","v":8000},{"$f":"IF($D$14*0.2<H33*$AB$6,$D$14*0.2,H33*$AB$6)","v":8000},200]
[null,null,null,null,null,50000,100000,150000,{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",Z35,AA35))","v":50000},{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",AB35,AC35))","v":100000},{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",AD35,AE35))","v":150000}]
[null,null,"Responsabilidad Civil Extracontractual Frente a Terceros, hasta:",null,null,null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF35,(AF35*$AB$6))","v":200},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F34","v":50000},{"$f":"+F34*AB6","v":200000},{"$f":"+G34","v":100000},{"$f":"+G34*AB6","v":400000},{"$f":"+H34","v":150000},{"$f":"+H34*AB6","v":600000},200]
[null,null,"Gastos por emergencias médicas a terceros hasta US$ 1,000 por persona, y en agregado vigencia máximo:",null,null,1000,2000,3000,{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",Z36,AA36))","v":1000},{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",AB36,AC36))","v":2000},{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",AD36,AE36))","v":3000},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F36","v":1000},{"$f":"+F36*AB6","v":4000},{"$f":"+G36","v":2000},{"$f":"+G36*AB6","v":8000},{"$f":"+H36","v":3000},{"$f":"+H36*AB6","v":12000}]
[null,null,"Responsabilidad Civil Patronal (frente al trabajador del hogar), por evento y en agregado vigencia hasta:",null,null,10000,15000,20000,{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",Z37,AA37))","v":10000},{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",AB37,AC37))","v":15000},{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",AD37,AE37))","v":20000},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F37","v":10000},{"$f":"+F37*AB6","v":40000},{"$f":"+G37","v":15000},{"$f":"+G37*AB6","v":60000},{"$f":"+H37","v":20000},{"$f":"+H37*AB6","v":80000}]
[null,null,"Responsabilidad civil por posesión de mascotas, hasta:",null,null,1000,2000,3000,{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",Z38,AA38))","v":1000},{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",AB38,AC38))","v":2000},{"$f":"IF(I33=0,0,IF($D$11=\"Dólares ( US$ )\",AD38,AE38))","v":3000},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F38","v":1000},{"$f":"+F38*AB6","v":4000},{"$f":"+G38","v":2000},{"$f":"+G38*AB6","v":8000},{"$f":"+H38","v":3000},{"$f":"+H38*AB6","v":12000}]
[null,null,"II. PROGRAMA FULL"]
[null,null,"Robo de Bienes Contenidos en la Vivienda hasta:",null,null,"Hasta el 100% de la Suma Asegurada del Contenido",null,null,{"$f":"IF($D$15<1,\"No Aplica\",$D$15)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",$D$15)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",$D$15)","v":"No Aplica"},"15% del Monto Indemnizable, mínimo",null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF40,(AF40*$AB$6))","v":500},null,null,null,null,null,null,null,null,null,null,null,500]
[]
[null,null,"Robo de Contenidos Especiales (joyas, alhajas, perlas, platería, relojes personales, obras de arte, pieles, instrumentos musicales y colecciones en general) dentro o fuera de los predios, con un límite por bien de US$1,000. La Suma Asegurada está limitada al 30% de la suma asegurada del Contenido, hasta: ",null,null,3000,5000,15000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z42,AA42)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB42,AC42)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD42,AE42)","v":"No Aplica"},"15% del Monto Indemnizable, mínimo",null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF42,(AF42*$AB$6))","v":300},null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.3<F42,$D$15*0.3,F42))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.3<F42*$AB$6,$D$15*0.3,F42*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.3<G42,$D$15*0.3,G42))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.3<G42*$AB$6,$D$15*0.3,G42*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.3<H42,$D$15*0.3,H42))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.3<H42*$AB$6,$D$15*0.3,H42*$AB$6))","v":"No Aplica"},300]
[null,null,"Robo de dinero en Efectivo dentro de la Vivienda, hasta:",null,null,500,750,1000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z43,AA43)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB43,AC43)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD43,AE43)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF43,(AF43*$AB$6))","v":50},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",F43)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",F43*$AB$6)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",G43)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",G43*$AB$6)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",H43)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",H43*$AB$6)","v":"No Aplica"},50]
[null,null,"Robo de dinero en tránsito solo por asalto, hasta:",null,null,500,750,1000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z44,AA44)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB44,AC44)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD44,AE44)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF44,(AF44*$AB$6))","v":50},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15<1,\"No Aplica\",F44)","v":"No Aplica"},{"$f":"IF(D15<1,\"No Aplica\",F44*$AB$6)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",G44)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",G44*$AB$6)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",H44)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",H44*$AB$6)","v":"No Aplica"},50]
[null,null,"Daños internos de equipos electrónicos y equipos eléctricos, hasta el 10% de la Suma Asegurada del Contenido, máximo:",null,null,3000,4000,5000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z45,AA45)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB45,AC45)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD45,AE45)","v":"No Aplica"},"10% del Monto Indemnizable, mínimo",null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF45,(AF45*$AB$6))","v":50},null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<F45,$D$15*0.1,F45))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<F45*$AB$6,$D$15*0.1,F45*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<G45,$D$15*0.1,G45))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<G45*$AB$6,$D$15*0.1,G45*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<H45,$D$15*0.1,H45))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<H45*$AB$6,$D$15*0.1,H45*$AB$6))","v":"No Aplica"},50]
[null,null,"Asistencia médica urgente por lesiones en un robo con un límite por persona de US$1,000 y en agregado vigencia máximo:",null,null,5000,7500,10000]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z47,AA47)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB47,AC47)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD47,AE47)","v":"No Aplica"},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",F46)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",F46*$AB$6)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",G46)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",G46*$AB$6)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",H46)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",H46*$AB$6)","v":"No Aplica"}]
[null,null,"Alojamiento temporal por inhabilitación de la vivienda, con un límite mensual de US$ 1,000 y en agregado vigencia máximo: ",null,null,3000,5000,10000,{"$f":"IF(I47=\"No Aplica\",\" No Aplica\",IF($D$11=\"Dólares ( US$ )\",Z48,AA48))","v":" No Aplica"},{"$f":"IF(I47=\"No Aplica\",\" No Aplica\",IF($D$11=\"Dólares ( US$ )\",AB48,AC48))","v":" No Aplica"},{"$f":"IF(I47=\"No Aplica\",\" No Aplica\",IF($D$11=\"Dólares ( US$ )\",AD48,AE48))","v":" No Aplica"},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F48","v":3000},{"$f":"F48*$AB$6","v":12000},{"$f":"G48","v":5000},{"$f":"G48*$AB$6","v":20000},{"$f":"H48","v":10000},{"$f":"H48*$AB$6","v":40000}]
[null,null,"Daños durante el traslado del contenido asegurado al alojamiento temporal, hasta el  50% de la Suma Asegurada del Contenido, máximo:",null,null,3000,5000,10000,"No Aplica","No Aplica","No Aplica","10% del Monto Indemnizable, mínimo",null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF49,(AF49*$AB$6))","v":50},null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.5<F49,$D$15*0.5,F49))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.5<F49*$AB$6,$D$15*0.5,F49*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.5<G49,$D$15*0.5,G49))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.5<G49*$AB$6,$D$15*0.5,G49*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.5<H49,$D$15*0.5,H49))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.5<H49*$AB$6,$D$15*0.5,H49*$AB$6))","v":"No Aplica"},50]
[null,null,"Perdida de alimentos en equipos de refrigeración, hasta el 5% de la Suma Asegurada del Contenido, máximo:",null,null,750,1000,1500,"No Aplica","No Aplica","No Aplica","10% del Monto Indemnizable, mínimo",null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF50,(AF50*$AB$6))","v":50},null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.05<F50,$D$15*0.05,F50))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.05<F50*$AB$6,$D$15*0.05,F50*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.05<G50,$D$15*0.05,G50))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.05<G50*$AB$6,$D$15*0.05,G50*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.05<H50,$D$15*0.05,H50))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.05<H50*$AB$6,$D$15*0.05,H50*$AB$6))","v":"No Aplica"},50]
[null,null,"Pérdida de equipaje por viaje dentro o fuera del país, hasta el 10% de la Suma Asegurada del Contenido, máximo:",null,null,750,1000,1500,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z51,AA51)","v":"No Aplica"},"No Aplica","No Aplica","10% del Monto Indemnizable, mínimo",null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF51,(AF51*$AB$6))","v":50},null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<F51,$D$15*0.1,F51))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<F51*$AB$6,$D$15*0.1,F51*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<G51,$D$15*0.1,G51))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<G51*$AB$6,$D$15*0.1,G51*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<H51,$D$15*0.1,H51))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF($D$15*0.1<H51*$AB$6,$D$15*0.1,H51*$AB$6))","v":"No Aplica"},50]
[null,null,"Deshonestidad o apropiación ilícita de trabajadores del hogar, hasta:",null,null,750,1000,2000,"No Aplica","No Aplica","No Aplica","10% del Monto Indemnizable, mínimo",null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AF52,(AF52*$AB$6))","v":200},null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",F52)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(F52*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",G52)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(G52*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",H52)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(H52*$AB$6))","v":"No Aplica"},200]
[null,null,"Compensación por Muerte accidental del Asegurado o de su cónyuge o conviviente ",null,null,7500,10000,20000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z53,AA53)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB53,AC53)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD53,AE53)","v":"No Aplica"},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",F53)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(F53*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",G53)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(G53*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",H53)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(H53*$AB$6))","v":"No Aplica"}]
[null,null,"Gastos de Curación de empleados (Trabajadores del hogar), hasta  US$ 1,000 por evento, y en agregado vigencia hasta:",null,null,1000,2000,3000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z54,AA54)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB54,AC54)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD54,AE54)","v":"No Aplica"},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",F54)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(F54*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",G54)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(G54*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",H54)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(H54*$AB$6))","v":"No Aplica"}]
[null,null,"Gastos de sepelio para el asegurado o su cónyuge o hijos, hasta",null,null,1000,2000,3000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z55,AA55)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB55,AC55)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD55,AE55)","v":"No Aplica"},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15<1,\"No Aplica\",F55)","v":"No Aplica"},{"$f":"IF(D15<1,\"No Aplica\",(F55*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",G55)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(G55*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",H55)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(H55*$AB$6))","v":"No Aplica"}]
[null,null,"Gastos de sepelio para el trabajador del hogar, hasta",null,null,1000,2000,3000,{"$f":"IF($D$11=\"Dólares ( US$ )\",Z56,AA56)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AB56,AC56)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",AD56,AE56)","v":"No Aplica"},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15<1,\"No Aplica\",F56)","v":"No Aplica"},{"$f":"IF(D15<1,\"No Aplica\",(F56*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",G56)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(G56*$AB$6))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",H56)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(H56*$AB$6))","v":"No Aplica"}]
[]
[null,null,"Claúsulas y Condiciones Especiales "]
[null,null," - POLIZA DE SEGURO DOMICILIARIO"]
[null,null," - 003 CL ROBO DE INSTALACIONES FIJAS",null,null,null,null,null,null,null," - 012 CL DAÑOS DURANTE EL TRASLADO DEL CONTENIDO ASEGURADO AL ALOJAMIENTO TEMPORAL"]
[null,null," - 004 CL MUERTE ACCIDENTAL DEL ASEGURADO O DE SU CONYUGE O CONVIVIENTE",null,null,null,null,null,null,null," - 013 CL PERDIDA DE ALIMENTOS EN EQUIPOS DE REFRIGERACIÓN"]
[null,null," - 005 CL GASTOS DE CURACION DE EMPLEADOS (TRABAJADORES DEL HOGAR)",null,null,null,null,null,null,null," - 014 CL GASTOS POR EMERGENCIAS MÉDICAS A TERCEROS"]
[null,null," - 006 CL DAÑOS INTERNOS DE EQUIPOS ELECTRÓNICOS Y EQUIPOS ELÉCTRICOS",null,null,null,null,null,null,null," - 015 CL RESPONSABILIDAD CIVIL PATRONAL (FRENTE AL TRABAJADOR DEL HOGAR)"]
[null,null," - 007 CL ROBO CONTENIDOS ESPECIALES DENTRO O FUERA DE LOS PREDIOS",null,null,null,null,null,null,null," - 016 CL PERDIDA DE EQUIPAJE POR VIAJE DENTRO O FUERA DEL PAIS"]
[null,null," - 008 CL DINERO EN TRÁNSITO SOLO POR ASALTO",null,null,null,null,null,null,null," - 017 CL DESHONESTIDAD O APROPIACION ILICITA DE TRABAJADORES DEL HOGAR"]
[null,null," - 009 CL DINERO EN EFECTIVO DENTRO DE LA VIVIENDA",null,null,null,null,null,null,null," - 019 CL GASTOS DE SEPELIO PARA EL ASEGURADO O SU CONYUGE O HIJOS"]
[null,null," - 010 CL ASISTENCIA MÉDICA URGENTE POR LESIONES EN UN ROBO",null,null,null,null,null,null,null," - 020 CL GASTOS DE SEPELIO PARA EL TRABAJADOR DEL HOGAR"]
[null,null," - 011 CL ALOJAMIENTO TEMPORAL POR INHABILITACIÓN DE LA VIVIENDA",null,null,null,null,null,null,null," - 021 CL RESPONSABILIDAD CIVIL POR POSESION DE MASCOTAS"]
[null,null," - Las Sumas Aseguradas son límites únicos para la vigencia del seguro y se encuentran sujetas a los limites por evento indicados en cada cobertura."]
[]
[]
[null,null,"Beneficios "]
[null,null,"Linea Positiva Salud"]
[null,null," - Consejería médica gratuita vía telefónica "]
[null,null," - Consulta médica domiciliaria, en la comodidad de su hogar. Se brinda a través de nuestro staff de médicos en las especialidades de medicina general y pediatría. (Sólo en Lima)."]
[null,null," - Envío de ambulancia por accidente o emergencia (En coordinación con la empresa)."]
[null,null,"Linea Positiva Hogar"]
[null,null," - Atención de emergencias en el hogar, eléctricas, de gasfitería, cerrajería, electricista, vidriería, fumigación interna y de áreas verdes, exterminación de roedores, traslado, recojo o envío de paquetes, Análisis de la estructura del hogar y envío y pago de especialistas en puertas levadizas por emergencias a domicilio. El servicio no incluye materiales"]
[]
[null,null,"Asistencia de Seguridad"]
[null,null," - Valet Parking, en caso de evento en la casa del Asegurado"]
[null,null," - Guardián, en caso de evento o robo e inhabitalidad de la casa del Asegurado.\n"]
[null,null," - Coordinación de bloqueo de tarjetas"]
[null,null,"Estos beneficios están disponibles en algunas ciudades, sujetos al tipo de servicio requerido y al radio de acción. Se aplican restricciones por zona y horario. \nLas presentes asistencias se encuentran sujetas al pago de un deducible a cargo del Asegurado por cada evento."]
[]
[null,null,"Exclusiones "]
[null,null," - Viviendas en cuyo interior se efectúen labores comerciales, industriales o de servicios"]
[null,null," - Viviendas ubicadas a una distancia menor a 500 metros del mar "]
[null,null," - Viviendas, casas y departamentos cuyo material de construcción predomínate NO sea ladrillo, cemento y fierro "]
[null,null," - Viviendas ubicadas en asentamientos informales o asentamientos humanos o en lotes no urbanizados o en lotes rurales o en condición de infravivienda"]
[]
[null,null,"Importante"]
[null,null," - El Asegurado deberá completar y firmar la Solicitud de Seguro"]
[]
[]
[]
[null,null,"TASA NETA ANUAL COBERTURA PRINCIPAL (Aplicado al Valor Declarado de Vivienda + Contenido asegurada)",null,null,null,null,null,1.65E-3,1.65E-3,1.65E-3]
[null,null,"TASA NETA ANUAL COB. ESPECIALES (Aplicado al Valor Declarado del contenido Asegurado",null,null,null,null,null,7.0000000000000001E-3,0.01,1.2E-2]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$17=1,($D$16*I97)*1.03,(($D$16*I97)+($D$15*I98))*1.03)","v":67.98},{"$f":"IF(D15=0,\"No Aplica\",IF($D$17=1,($D$16*J97)*1.03,(($D$16*J97)+($D$15*J98))*1.03))","v":"No Aplica"},{"$f":"IF(D15=0,\"No aplica\",IF($D$17=1,($D$16*K97)*1.03,((($D$16*K97)+($D$15*K98))*1.03)))","v":"No aplica"}]
[null,null,null,null,null,null,null,null,{"$f":"+I99/1.2","v":56.650000000000006},{"$f":"+J99/1.2","v":{"$error":"#VALUE!"}},{"$f":"+K99/1.2","v":{"$error":"#VALUE!"}}]
[null,null,"DESCUENTO",0]
[null,null,null,0.05]
[null,null,null,0.1]
[null,null,null,0.15]
[null,null,null,0.2]

{"sheet":"CasaMAR","index":1,"n_rows":130,"n_cols":29,"rows_kept":130,"cut":false,"hidden":false,"merged":[[91,12,91,13],[94,15,94,16],[9,15,9,16],[7,13,7,14],[7,9,7,10],[1,2,1,17],[3,3,3,17],[8,3,8,17],[21,2,21,17],[5,7,5,8],[5,12,5,14],[5,9,5,11],[5,15,5,17],[22,2,28,4],[23,5,28,5],[23,6,28,6],[10,15,10,16],[13,15,13,16],[14,15,14,16],[19,2,20,4],[19,5,20,5],[19,7,20,17],[40,2,41,4],[40,5,41,5],[40,6,41,6],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,17],[39,2,39,3],[52,2,52,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,48,4],[47,5,48,5],[47,7,48,8],[49,2,49,4],[50,2,50,4],[51,2,51,4],[54,2,54,4],[55,2,55,4],[56,2,56,4],[57,2,57,4],[58,2,58,4],[126,2,126,3],[127,2,127,3],[128,2,128,3],[17,15,17,16],[41,16,41,17],[78,2,78,16],[80,2,80,17],[124,2,124,3],[125,2,125,3],[60,2,60,17],[73,2,73,17],[75,4,77,6],[76,2,76,3],[76,7,76,13],[77,2,77,3],[53,2,53,4]]}
[]
[null,null,"COTIZACIÓN DE SEGURO DOMICILIARIO CASAMAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dólares ( US$ )",null,"A. Programa Básico",null,null,null,"Concreto Armado"]
[null,null,"Contratante",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sol ( S/ )",null,"B. Programa Básico + Programa Full",null,null,null,"Ladrillo y Cemento"]
[null,null,"Asegurado",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,"Estructura de Acero"]
[null,null,"Corredor",null,null,null,null,"Oficina ",null,null,null,null,"Ejecutivo Comercial ",null,null,null,null,null,null,null,null,null,"Tipo de Cambio",3.25,null,null,null,null,"Madera y/o Adobe y/o quincha"]
[null,null,"Ubicación del riesgo"]
[null,null,"Datos SBS","Tipo de Estructura","Concreto Armado",null,{"$f":"IF(E8=AC6,\"No cotizar\",\" \")","v":" "},"Año Construc.",null,0,null,"Nro. Pisos",null,0,null,"Nro. Sótanos",null,0]
[null,null,"COBERTURAS SOLICITADAS","B. Programa Básico + Programa Full"]
[null,null,"Vigencia","1 Año ",null,null,null,null,null,null,"Fecha de Cotización",null,null,null,null,{"$f":"TODAY()","v":"2020-01-15"},null,null,null,null,null,"https://exceltotal.com/ocultar-datos-en-excel-con-formato-condicional/"]
[null,null,"Moneda","Dólares ( US$ )",null,null,null,null,null,null,"Validez de la Cotización",null,null,null,null,"15 días ",null,null,null,null,null,"http://www.compartir-tecnologias.es/ocultar-mostrar-filas-autoamticamente-pro-medio-formula-o-funcion-ayuda-204308052.html"]
[]
[null,null,"Valores Declarados",{"$f":"D11","v":"Dólares ( US$ )"},null,null,null,null,null,null,"Primas "]
[null,null," - Vivienda (Edificio)",100000,null,null,null,null,null,null,"Prima Comercial",null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF(AND(D11=\"Dólares ( US$ )\",(M92<150)),150,IF(AND(D11=\"Sol ( S/ )\",M92<500),500,M92))","v":195.70000000000002}]
[null,null," - Contenido",null,null,null,null,null,null,null,"Prima Comercial + IGV Anual",null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"+P14*1.18","v":230.92600000000002}]
[null,null,"TOTAL ASEGURADO",{"$f":"SUM(D14:D15)","v":100000},null,null,null,null,null,null,"Descuento",null,null,null,0,{"$f":"IF(O16>0%,\"Ver con Area Técnica LP\",\" \")","v":" "}]
[null,null,null,{"$f":"+IF(D9=Y3,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Prima Comercial + IGV Anual",null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF(AND($D$11=\"Dólares ( US$ )\",(P14*(1-O16)<150)),(150*1.18),IF(AND($D$11=\"Sol ( S/ )\",P15*(1-O16)<500),(500*1.18),P15*(1-O16)))","v":230.92600000000002}]
[]
[null,null,"Coberturas",null,null,"Suma Asegurada Maxima ","Suma Asegurada","Deducibles"]
[null,null,null,null,null,null,{"$f":"+D11","v":"Dólares ( US$ )"},null,null,null,null,null,null,null,null,null,null,null,null,null,"SA Dolares","SA Soles ","deducibles minimos en dolares"]
[null,null,"I. PROGRAMA BASICO"]
[null,null,"Incendio, Riesgos de la Naturaleza y Riesgos Politicos \nEste seguro cubre la destrucción o daño físico directo de la vivienda y su contenido como consecuencia directa de: incendio, explosión, daños por agua, lluvia e inundación, terremoto, temblor, erupción volcánica, maremoto (Tsunami), caída de aeronaves, impacto de vehículos, daños por humo, huelga y conmoción civil, daño malicioso, vandalismo y/o terrorismo."]
[null,null,null,null,null,"Hasta el 100% de la Suma Asegurada (SA) de la Vivienda\n+ Contenido",{"$f":"+D16","v":100000}," - Todo evento cubierto: 10% del Monto Indemnizable mínimo",null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W24,(W24*$X$6))","v":500},", excepto:",null,null,null,null,null,500]
[null,null,null,null,null,null,null," - Huelga y conmoción civil, daño malicioso, vandalismo y/o terrorismo: 5% del ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,500]
[null,null,null,null,null,null,null,"monto indemnizable mínimo",null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W25,(W25*$X$6))","v":500}]
[null,null,null,null,null,null,null," - Terremoto, temblor erupción volcánica, maremoto (tsunami), salida de mar, "]
[null,null,null,null,null,null,null,"marejada, oleaje: 1% de la Suma  Asegurada de la Vivienda + Contenido, mínimo "]
[null,null,null,null,null,null,null,"20% del Monto Indemnizable o, ",null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W29,(W29*$X$6))","v":2000},",lo que resulte mayor",null,null,null,null,null,null,null,null,2000]
[null,null,"Rotura de vidrios, espejos y unidades sanitarias, hasta el 10% de la Suma Asegurada de la Vivienda, máximo:",null,null,15000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U30,V30)","v":10000},"10% del Monto Indemnizable, mínimo",null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W30,(W30*$X$6))","v":30},null,null,null,null,null,null,{"$f":"IF(D14*0.1<F30,D14*0.1,F30)","v":10000},{"$f":"IF(D14*0.1<F30*$X$6,D14*0.1,F30*$X$6)","v":10000},30]
[null,null,"Gastos de remoción de escombros, hasta el 10% de la Suma Asegurada de la Vivienda + Contenido, máximo:",null,null,30000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U31,V31)","v":10000},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D16*0.1<F31,D16*0.1,F31)","v":10000},{"$f":"IF(D16*0.1<F31*$X$6,D16*0.1,F31*$X$6)","v":10000}]
[null,null,"Gastos de extinción y contención del siniestro, hasta el 10% de la Suma Asegurada de la Vivienda + Contenido, máximo:",null,null,30000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U32,V32)","v":10000},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D16*0.1<F32,D16*0.1,F32)","v":10000},{"$f":"IF(D16*0.1<F32*$X$6,D16*0.1,F32*$X$6)","v":10000}]
[null,null,"Robo de Instalaciones fijas, hasta el 20% de la Suma Asegurada de la Vivienda máximo",null,null,10000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U33,V33)","v":10000},"15% del Monto Indemnizable, mínimo",null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W33,(W33*$X$6))","v":200},null,null,null,null,null,null,{"$f":"IF(D14*0.2<F33,D14*0.2,F33)","v":10000},{"$f":"IF(D14*0.2<F33*$X$6,D14*0.2,F33*$X$6)","v":20000},200]
[null,null,"Responsabilidad Civil"]
[null,null,"Responsabilidad civil Extracontractual Frente a Terceros, hasta:",null,null,100000,{"$f":"IF(G33=0,0,IF($D$11=\"Dólares ( US$ )\",U35,V35))","v":100000},{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W35,(W35*$X$6))","v":200},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F35","v":100000},{"$f":"+F35*X6","v":325000},200]
[null,null,"Gastos por emergencias médicas de terceros, hasta US$ 1,000 por persona, y en agregado vigencia máximo:",null,null,3000,{"$f":"IF(G33=0,0,IF($D$11=\"Dólares ( US$ )\",U36,V36))","v":3000},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F36","v":3000},{"$f":"+F36*X6","v":9750}]
[null,null,"Responsabilidad Civil Patronal (frente al trabajador del hogar), por evento y en el agregado vigencia hasta:",null,null,20000,{"$f":"IF(G33=0,0,IF($D$11=\"Dólares ( US$ )\",U37,V37))","v":20000},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F37","v":20000},{"$f":"+F37*X6","v":65000}]
[null,null,"1.2.4 - Responsabilidad Civil por los daños personales que ocasione la posesión de mascotas, hasta:",null,null,30000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U38,V38)","v":30000},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+F38","v":30000},{"$f":"+F38*X6","v":97500}]
[null,null,"II. PROGRAMA FULL"]
[null,null,"Robo",null,null,null,null,"Eventos ocurridos entre:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,500]
[null,null,"Robo de Bienes Contenidos en la Vivienda hasta ",null,null,"Hasta el 100% de la Suma Asegurada del Contenido",{"$f":"IF($D$15<1,\"No Aplica\",D15)","v":"No Aplica"},"Diciembre a Abril: 10% del Monto Indemnizable, mínimo ",null,null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W40,(W40*$X$6))","v":500},null,null,null,null,null,2500]
[null,null,null,null,null,null,null,"Mayo a Noviembre: 15% del Monto Indemnizable, mínimo",null,null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W41,(W41*$X$6))","v":2500}]
[null,null,"2.1.2 Contenidos Especiales (joyas, alhajas, perlas, platería, relojes personales, obras de arte, pieles, instrumentos musicales y colecciones en general) que se encuentren dentro de la vivienda y con un límite por bien de US$1,000. La Suma Asegurada está limitada al 30% de la suma asegurada del Contenido, máximo:",null,null,15000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U43,V43)","v":0},"10% del Monto Indemnizable, mínimo",null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W43,(W43*$X$6))","v":300},null,null,null,null,null,null,null,{"$f":"IF(D15*0.3<F43,D15*0.3,F43)","v":0},{"$f":"IF(D15*0.3<F43*$X$6,D15*0.3,F43*$X$6)","v":0},300]
[null,null,"Robo de Dinero en efectivo dentro de la vivienda, hasta US$ 1,000 por evento, máximo ",null,null,3000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U44,V44)","v":"No Aplica"},{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W44,(W44*$X$6))","v":50},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",F44)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",F44*$X$6)","v":"No Aplica"},50]
[null,null,"2.1.4 - Dinero en Tránsito solo por Asalto, maximo",null,null,2000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U45,V45)","v":0},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15=0,0,F45)","v":0},{"$f":"IF(D15=0,0,F45*$X$6)","v":0}]
[null,null,"Especiales"]
[null,null,"Daños internos de equipos electrónicos y equipos eléctricos, hasta el 10% de la Suma Asegurada del Contenido, máximo:",null,null,5000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U47,V47)","v":"No Aplica"},"10% del Monto Indemnizable, mínimo",null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W47,(W47*$X$6))","v":50},null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",IF(D15*0.1<F47,D15*0.1,F47))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF(D15*0.1<F47*$X$6,D15*0.1,F47*$X$6))","v":"No Aplica"},50]
[null,null,"Asistencia médica urgente por lesiones en un robo con un límite por persona de US$1,000 y en la vigencia hasta:",null,null,5000,null,"Sin Deducible"]
[null,null,null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",U49,V49)","v":"No Aplica"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",F48)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",F48*$X$6)","v":"No Aplica"}]
[null,null,"Alojamiento temporal por inhabilitación de la vivienda, con un límite mensual de  US$ 1,000 y en la vigencia hasta: ",null,null,3000,{"$f":"IF(G33=0,0,IF($D$11=\"Dólares ( US$ )\",U50,V50))","v":3000},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"F50","v":3000},{"$f":"F50*$X$6","v":9750}]
[null,null,"Daños durante el traslado del contenido asegurado al alojamiento temporal, hasta el 50% de la Suma Asegurada del Contenido, máximo:",null,null,7500,"No Aplica","10% del Monto Indemnizable, mínimo",null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W51,(W51*$X$6))","v":50},null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",IF(D15*0.5<F51,D15*0.5,F51))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF(D15*0.5<F51*$X$6,D15*0.5,F51*$X$6))","v":"No Aplica"},50]
[null,null,"Perdida de alimentos en equipos de refrigeración, hasta el 5% de la Suma Asegurada del Contenido, máximo:",null,null,1500,"No Aplica","10% del Monto Indemnizable, mínimo",null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W52,(W52*$X$6))","v":50},null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",IF(D15*0.05<F52,D15*0.05,F52))","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",IF(D15*0.05<F52*$X$6,D15*0.05,F52*$X$6))","v":"No Aplica"},50]
[null,null,"2.2.6 Pérdida de equipaje y/o de los bienes portados por el Asegurado y/o cónyuge y/o hijos en caso de viaje dentro o fuera del país, hasta el 10% de la Suma Asegurada del Contenido, máximo:",null,null,5000,0,"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15*0.1<F53,D15*0.1,F53)","v":0},{"$f":"IF(D15*0.1<F53*$X$6,D15*0.1,F53*$X$6)","v":0}]
[null,null,"Deshonestidad o apropiación ilícita de trabajadores del hogar, hasta:",null,null,1500,"No Aplica","10% del Monto Indemnizable, mínimo",null,null,null,null,{"$f":"IF($D$11=\"Dólares ( US$ )\",\"US$\",\"S/\")","v":"US$"},{"$f":"IF($D$11=\"Dólares ( US$ )\",W54,(W54*$X$6))","v":200},null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",F54)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(F54*$X$6))","v":"No Aplica"},200]
[null,null,"Accidentes Personales "]
[null,null,"Compensación por Muerte accidental del Asegurado o de su cónyuge o conviviente ",null,null,10000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U56,V56)","v":"No Aplica"},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",F56)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(F56*$X$6))","v":"No Aplica"}]
[null,null,"Gastos de Curación de empleados (Trabajadores del hogar), hasta US$ 1,000 por evento, maximo:",null,null,3000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U57,V57)","v":"No Aplica"},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$15<1,\"No Aplica\",F57)","v":"No Aplica"},{"$f":"IF($D$15<1,\"No Aplica\",(F57*$X$6))","v":"No Aplica"}]
[null,null,"2.3.3 Gastos de Sepelio del Asegurado y/o conyuge y/o hijos",null,null,3000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U58,V58)","v":0},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15=0,0,F58)","v":0},{"$f":"IF(D15=0,0,(F58*$X$6))","v":0}]
[null,null,"2.3.4 Gastos de Sepelio por muerte del trabajador del hogar",null,null,3000,{"$f":"IF($D$11=\"Dólares ( US$ )\",U59,V59)","v":0},"Sin Deducible",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D15=0,0,F59)","v":0},{"$f":"IF(D15=0,0,(F59*$X$6))","v":0}]
[]
[null,null,"Claúsulas y Condiciones Especiales "]
[null,null," - POLIZA DE SEGURO DOMICILIARIO",null,null,null,{"$f":"+CasaPLUS!C68","v":" - 011 CL ALOJAMIENTO TEMPORAL POR INHABILITACIÓN DE LA VIVIENDA"}]
[null,null,{"$f":"+CasaPLUS!K62","v":" - 014 CL GASTOS POR EMERGENCIAS MÉDICAS A TERCEROS"},null,null,null,{"$f":"+CasaPLUS!C67","v":" - 010 CL ASISTENCIA MÉDICA URGENTE POR LESIONES EN UN ROBO"}]
[null,null,{"$f":"+CasaPLUS!K65","v":" - 017 CL DESHONESTIDAD O APROPIACION ILICITA DE TRABAJADORES DEL HOGAR"},null,null,null,{"$f":"+CasaPLUS!C63","v":" - 006 CL DAÑOS INTERNOS DE EQUIPOS ELECTRÓNICOS Y EQUIPOS ELÉCTRICOS"}]
[null,null,{"$f":"+CasaPLUS!K63","v":" - 015 CL RESPONSABILIDAD CIVIL PATRONAL (FRENTE AL TRABAJADOR DEL HOGAR)"},null,null,null,{"$f":"+CasaPLUS!C61","v":" - 004 CL MUERTE ACCIDENTAL DEL ASEGURADO O DE SU CONYUGE O CONVIVIENTE"}]
[null,null,{"$f":"+CasaPLUS!C60","v":" - 003 CL ROBO DE INSTALACIONES FIJAS"},null,null,null,{"$f":"+CasaPLUS!C66","v":" - 009 CL DINERO EN EFECTIVO DENTRO DE LA VIVIENDA"}]
[null,null,{"$f":"+CasaPLUS!K60","v":" - 012 CL DAÑOS DURANTE EL TRASLADO DEL CONTENIDO ASEGURADO AL ALOJAMIENTO TEMPORAL"},null,null,null,{"$f":"+CasaPLUS!K61","v":" - 013 CL PERDIDA DE ALIMENTOS EN EQUIPOS DE REFRIGERACIÓN"}]
[null,null,{"$f":"+CasaPLUS!C62","v":" - 005 CL GASTOS DE CURACION DE EMPLEADOS (TRABAJADORES DEL HOGAR)"}]
[null,null," - Las Sumas Aseguradas son límites únicos para la vigencia del seguro y se encuentran sujetas a los limites por evento indicados en cada cobertura."]
[]
[null,null,null,null,null,null," - 022 CE Todo Riesgo",null,null,null,null," - 008 CL Robo de dinero en efectivo fuera de la vivienda "]
[null,null," - 019 CE Gastos de sepelio por muerte del Asegurado"," - 018 CL Robo contenidos especiales dentro de los predios ",null,null," - 021 CE RC por posesion de mascotas",null,null,null,null," - 016 CE Perdida de equipaje por viaje "]
[]
[null,null,"Beneficios "]
[null,null,"Linea Positiva Salud",null,"Linea Positiva Hogar",null,null,"Asistencia de Seguridad"]
[null,null," - Consejería médica gratuita vía telefónica ",null," - Atención de emergencias en el hogar, eléctricas, de gasfitería, cerrajería, electricista, vidriería, fumigación interna y de áreas verdes, exterminación de roedores, traslado, recojo o envío de paquetes, Análisis de la estructura del hogar y envío y pago de especialistas en puertas levadizas por emergencias a domicilio. El servicio no incluye materiales",null,null," - Valet Parking, en caso de evento en la casa del Asegurado"]
[null,null," - Consulta médica domiciliaria, en la comodidad de su hogar. Se brinda a través de nuestro staff de médicos en las especialidades de medicina general y pediatría. (Sólo en Lima).",null,null,null,null," - Guardián, en caso de evento o robo e inhabitalidad de la casa del Asegurado.\n - Coordinación de bloqueo de tarjetas"]
[null,null," - Envío de ambulancia por accidente o emergencia (En coordinación con la empresa)."]
[null,null,"Estos beneficios están disponibles en algunas ciudades, sujetos al tipo de servicio requerido y al radio de acción. Se aplican restricciones por zona y horario. \nLas presentes asistencias se encuentran sujetas al pago de un deducible a cargo del Asegurado por cada evento."]
[]
[null,null,"Exclusiones "]
[null,null," - Viviendas en cuyo interior se efectúen labores comerciales, industriales o de servicios"]
[null,null," - Viviendas ubicadas a una distancia menor a 100 metros del mar "]
[null,null," - Viviendas, casas y departamentos cuyo material de construcción predomínate NO sea ladrillo, cemento y fierro "]
[null,null," - Viviendas ubicadas en asentamientos informales o asentamientos humanos o en lotes no urbanizados o en lotes rurales o en condición de infravivienda"]
[]
[]
[null,null,"Importante"]
[null,null," - El Asegurado deberá completar y firmar la Solicitud de Seguro"]
[]
[]
[null,null,"TASA NETA ANUAL COBERTURA PRINCIPAL (Aplicado al Valor Declarado de Vivienda + Contenido asegurada)",null,null,null,null,null,null,null,1.9E-3,null,{"$f":"IF(D17=1,(D16*K92)*1.03,((D16*K92)+(D15*K93))*1.03)","v":195.70000000000002}]
[null,null,"TASA NETA ANUAL COB. ESPECIALES (Aplicado al Valor Declarado del contenido Asegurado",null,null,null,null,null,null,null,8.0000000000000002E-3,null,null,"Prima minima?",null,{"$f":"IF(O14=\"S/\",650*1.18,200*1.18)","v":236}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRIMA NETA ANUAL "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D3*Q103/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Q34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Q55+Q57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q108:Q109)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Q107-Q108-Q109","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(Q107-Q110)/D3*1000","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Porcentaje Participacion Real %"]
[]
[null,null,{"$f":"+Q108/Q107%","v":{"$error":"#DIV/0!"}},{"$f":"+#REF!/#REF!%","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,{"$f":"+Q109/Q107%","v":{"$error":"#DIV/0!"}},{"$f":"+#REF!/#REF!%","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,30]
[]
[null,null,{"$f":"+Q111/Q107%","v":{"$error":"#DIV/0!"}},{"$f":"+#REF!/#REF!%","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100-Q116-Q117","v":43}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Observaciones"]
[null,null,"3.1.5       Robo de dinero en efectivo fuera de la vivienda asegurada portada por el Asegurado y/o su conyuge",null,null,2000,{"$f":"IF($D$16>0,F125,0)","v":2000},"SD",null,null,null,null,null,null,null,"nueva cobertura"]
[null,null,"2.4. Responsabilidad Civil por posesión de mascotas",null,null,30000,{"$f":"IF($D$16>0,F126,0)","v":30000},"SD",null,null,null,null,null,null,null,"nueva cobertura"]
[null,null,"3.2.6       Pérdida de equipaje y/o de los bienes portados por el Asegurado y/o cónyuge y/o hijos en caso de viaje dentro o fuera del país, hasta el 10% de la Suma Asegurada del Contenido, máximo:",null,null,5000,{"$f":"IF($D$15*0.1<F127,$D$15*0.1,F127)","v":0},"SD"]
[null,null,"3.3.3       Gastos de Sepelio del Asegurado y/o conyuge y/o hijos",null,null,3000,{"$f":"IF($D$16>0,F128,0)","v":3000},"SD",null,null,null,null,null,null,null,"nueva cobertura"]
[null,null,"3.3.4       Gastos de Sepelio por muerte del trabajador del hogar",null,null,3000,{"$f":"IF($D$16>0,F129,0)","v":3000},"SD",null,null,null,null,null,null,null,"nueva cobertura"]
[null,null,"PRIMA COMERCIAL + IGV"]