{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["TOMA DE DATOS","RESULTADOS"],"not_rendered":{"charts":0,"images":4,"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":"TOMA DE DATOS","index":0,"n_rows":70,"n_cols":26,"rows_kept":70,"cut":false,"hidden":false,"merged":[[27,11,27,12],[34,0,34,1],[54,8,55,8],[61,1,61,3],[59,1,59,2],[28,0,28,1],[32,0,32,4],[29,7,30,8],[31,0,31,4],[30,0,30,4],[29,0,29,4],[62,8,63,8],[53,1,53,3],[36,1,36,3],[36,5,36,7],[53,4,53,7],[61,4,61,7],[51,1,51,2],[4,0,4,8],[6,0,6,8],[10,4,10,7],[11,4,11,7],[12,4,12,7],[19,4,19,7],[8,4,8,7],[9,4,9,7],[26,0,26,4],[28,2,28,3],[13,4,13,7],[14,4,14,7],[16,4,16,7],[17,4,17,7],[18,4,18,7],[62,12,62,13],[62,14,62,15],[62,16,62,17],[67,12,67,13],[67,14,67,15],[67,16,67,17]]}
[]
[]
[]
[]
["TARIFICADOR SIMULACIÓN SEGURO MULTIRRIESGO GENERALI HOGAR CAMINOS 2021"]
[]
["CUMPLIMENTACIÓN DE DATOS:"]
[]
["Fecha de efecto:",null,null,null,null,null,null,null,null,null,null,"Principal"]
["Nombre Asegurado:",null,null,null,null,null,null,null,null,null,null,"Secundaria"]
["N.I.F.:",null,null,null,null,null,null,null,null,null,null,"Piso"]
["Teléfono de contacto:",null,null,null,null,null,null,null,null,null,null,"Chalet"]
["Fecha de nacimiento:",null,null,null,null,null,null,null,null,null,null,"Si"]
["Estado Civil:",null,null,null,null,null,null,null,null,null,null,"No"]
["Correo electrónico:"]
[]
["Ubicación del Riesgo:",null,null,"Calle"]
[null,null,null,"Código Postal"]
[null,null,null,"Localidad"]
[null,null,null,"Provincia"]
[]
["Residencia a asegurar:",null,null,"Principal / Secundaria","Principal"]
[null,null,null,"Piso / Chalet","Piso"]
[null,null,null,"Protección teléfono móvil","No",{"$f":"IF(E22<>\"\",IF(E24<>\"\",IF(E24=\"Si\",IF(C70<>0,\"\",\"Debe asegurarse contenido\"),\"\"),\"\"),\"\")","v":""}]
[null,null,null,"Descuento %",0]
[]
["INTRODUCIR m2 (incluidas terrazas, trasteros, anexos, etc.)"]
[null,null,null,null,null,null,null,null,null,null,null,"COSTE m2"]
["Superficie construida Vivienda",null,null,null,"m2","RECOMENDADO","FACILITADO CLIENTE",null,null,null,null,2020,2021]
["Capital a asegurar Continente",null,null,null,null,{"$f":"IF(E23=\"Piso\",C29*M30,C29*M31)","v":0},null,"SÓLO RELLENAR SI EL CLIENTE DESEA CAPITALES DISTINTOS A LOS RECOMENDADOS",null,null,null,865,1000]
["Capital estándar de Contenido recomendado (igual al 30% del valor de Cte.)",null,null,null,null,{"$f":"+F30*30%","v":0},null,null,null,null,null,968,1300]
["Objetos especiales: Valor individual >15% cdo. Ó 20.000 euros de valor unitario",null,null,null,null,{"$f":"IF(F31=0,0,((IF(D39>0,C39,0))+(IF(D40>0,C40,0))+(IF(D41>0,C41,0))+(IF(D42>0,C42,0))+(IF(D43>0,C43,0))+(IF(D44>0,C44,0))+(IF(D45>0,C45,0))+(IF(D46>0,C46,0))+(IF(D47>0,C47,0))+(IF(D48>0,C48,0))))","v":0},{"$f":"IF(G31=0,0,(((IF(H39>0,G39,0))+(IF(H40>0,G40,0))+(IF(H41>0,G41,0))+(IF(H42>0,G42,0))+(IF(H43>0,G43,0))+(IF(H44>0,G44,0))+(IF(H45>0,G45,0))+(IF(H46>0,G46,0))+(IF(H47>0,G47,0))+(IF(H48>0,G48,0)))))","v":0}]
["SUMA 15% CONTENIDO:              ",null,null,null,null,{"$f":"+F31*15%","v":0},{"$f":"+G31*15%","v":0},null,null,null,null,"SUMA DE CAPITALES",{"$f":"$B70+$C70","v":0},null,null,"CONTINENTE",{"$f":"$B70","v":0},null,null,"CONTENIDO",{"$f":"$C70","v":0},null,null,"OBJETOS ESPECIALES"]
[]
["DETALLE OBJETOS ESPECIALES:",null,{"$f":"IF(OR(F31<SUM(C39:C48),G31<SUM(G39:G48)),\"ERROR: El valor de objetos especiales debe estar incluido en el capital de contenido.\",\"\")","v":""},null,null,null,null,null,null,null,null,"PRIMA NETA",{"$f":"$I70","v":0},null,null,"PRIMA NETA",{"$f":"$I70-F70-G70-H70","v":0},null,null,"PRIMA NETA",{"$f":"$I70-E70-G70","v":0},null,null,"PRIMA NETA",{"$f":"$I70-E70-F70-H70","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"ARBITRIO",{"$f":"+M35*2.5%","v":0},"Prima neta * 2,5%",null,"ARBITRIO",{"$f":"+Q35*2.5%","v":0},"Prima neta * 2,5%",null,"ARBITRIO",{"$f":"+U35*2.5%","v":0},"Prima neta * 2,5%",null,"ARBITRIO",{"$f":"+Y35*2.5%","v":0},"Prima neta * 2,5%"]
[null,"PARA OPCIÓN DE CAPITALES RECOMENDADOS",null,null,null,"PARA OPCIÓN CAPITALES FACILITADOS CLIENTE",null,null,null,null,null,"TLEA",{"$f":"+M35*0.15%","v":0},"Prima neta * 0,15%",null,"TLEA",{"$f":"+Q35*0.15%","v":0},"Prima neta * 0,15%",null,"TLEA",{"$f":"+U35*0.15%","v":0},"Prima neta * 0,15%",null,"TLEA",{"$f":"+Y35*0.15%","v":0},"Prima neta * 0,15%"]
[null,"OBJETO","VALOR","Valor exceso objeto especial",null,"OBJETO","VALOR","Valor exceso objeto especial",null,null,null,"IPS",{"$f":"+(M35+M36)*8%","v":0},"(Prima neta + Arbitrio) * 8%",null,"IPS",{"$f":"+(Q35+Q36)*8%","v":0},"(Prima neta + Arbitrio) * 8%",null,"IPS",{"$f":"+(U35+U36)*8%","v":0},"(Prima neta + Arbitrio) * 8%",null,"IPS",{"$f":"+(Y35+Y36)*8%","v":0},"(Prima neta + Arbitrio) * 8%"]
[1,null,null,{"$f":"IF(AND($F$31*15%>20000,C39>20000),C39-20000,IF(C39>$F$31*15%,C39-($F$31*15%),0))","v":0},1,null,null,{"$f":"IF(AND($G$31*15%>20000,G39>20000),G39-20000,IF(G39>$G$31*15%,G39-($G$31*15%),0))","v":0},null,null,null,"CONSORCIO",{"$f":"+M33*0.0735/1000","v":0},"Suma de capitales * 0,0735 / 1000",null,"CONSORCIO",{"$f":"+Q33*0.0735/1000","v":0},"Suma de capitales * 0,0735 / 1000",null,"CONSORCIO",{"$f":"+U33*0.0735/1000","v":0},"Suma de capitales * 0,0735 / 1000",null,"CONSORCIO",{"$f":"+Y33*0.0735/1000","v":0},"Suma de capitales * 0,0735 / 1000"]
[2,null,null,{"$f":"IF(AND($F$31*15%>20000,C40>20000),C40-20000,IF(C40>$F$31*15%,C40-($F$31*15%),0))","v":0},2,null,null,{"$f":"IF(AND($G$31*15%>20000,G40>20000),G40-20000,IF(G40>$G$31*15%,G40-($G$31*15%),0))","v":0},null,null,null,"TOTAL RECIBO",{"$f":"SUM(M35:M39)","v":0},"Prima neta + Arbitrio + TLEA + IPS + Consorcio",null,"TOTAL RECIBO",{"$f":"SUM(Q35:Q39)","v":0},"Prima neta + Arbitrio + TLEA + IPS + Consorcio",null,"TOTAL RECIBO",{"$f":"SUM(U35:U39)","v":0},"Prima neta + Arbitrio + TLEA + IPS + Consorcio",null,"TOTAL RECIBO",{"$f":"SUM(Y35:Y39)","v":0},"Prima neta + Arbitrio + TLEA + IPS + Consorcio"]
[3,null,null,0,3,null,null,0]
[4,null,null,0,4,null,null,0,null,null,null,"COMISION",{"$f":"+M35*25%","v":0},"Prima neta * 25%",null,"COMISION",{"$f":"+Q35*25%","v":0},"Prima neta * 25%",null,"COMISION",{"$f":"+U35*25%","v":0},"Prima neta * 25%",null,"COMISION",{"$f":"+Y35*25%","v":0},"Prima neta * 25%"]
[5,null,null,0,5,null,null,0,null,null,null,"LIQUIDO",{"$f":"+M40-M42","v":0},"Prima total - Comisión",null,"LIQUIDO",{"$f":"+Q40-Q42","v":0},"Prima total - Comisión",null,"LIQUIDO",{"$f":"+U40-U42","v":0},"Prima total - Comisión",null,"LIQUIDO",{"$f":"+Y40-Y42","v":0},"Prima total - Comisión"]
[6,null,null,0,6,null,null,0]
[7,null,null,0,7,null,null,0,null,null,null,"Detalle del recibo:",null,null,null,"Detalle del recibo:",null,null,null,"Detalle del recibo:",null,null,null,"Detalle del recibo:"]
[8,null,null,0,8,null,null,0]
[9,null,null,0,9,null,null,0,null,null,null,"PRIMAS (Prima neta + Arbitrio)",{"$f":"+M35+M36","v":0},null,{"$f":"Q47+U47+Y47","v":0},"PRIMAS (Prima neta + Arbitrio)",{"$f":"+Q35+Q36","v":0},null,null,"PRIMAS (Prima neta + Arbitrio)",{"$f":"+U35+U36","v":0},null,null,"PRIMAS (Prima neta + Arbitrio)",{"$f":"+Y35+Y36","v":0}]
[10,null,null,0,10,null,null,0,null,null,null,"CONSORCIO",{"$f":"+M39","v":0},null,{"$f":"Q48+U48+Y48","v":0},"CONSORCIO",{"$f":"+Q39","v":0},null,null,"CONSORCIO",{"$f":"+U39","v":0},null,null,"CONSORCIO",{"$f":"+Y39","v":0}]
[null,null,null,{"$f":"SUM(D39:D48)","v":0},null,null,null,{"$f":"SUM(H39:H48)","v":0},null,null,null,"TASA LEA",{"$f":"+M37","v":0},null,{"$f":"Q49+U49+Y49","v":0},"TASA LEA",{"$f":"+Q37","v":0},null,null,"TASA LEA",{"$f":"+U37","v":0},null,null,"TASA LEA",{"$f":"+Y37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"IPS",{"$f":"+M38","v":0},null,{"$f":"Q50+U50+Y50","v":0},"IPS",{"$f":"+Q38","v":0},null,null,"IPS",{"$f":"+U38","v":0},null,null,"IPS",{"$f":"+Y38","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL RECIBO",{"$f":"SUM(M47:M50)","v":0},null,{"$f":"Q51+U51+Y51","v":0},"TOTAL RECIBO",{"$f":"SUM(Q47:Q50)","v":0},null,null,"TOTAL RECIBO",{"$f":"SUM(U47:U50)","v":0},null,null,"TOTAL RECIBO",{"$f":"SUM(Y47:Y50)","v":0}]
["A","RESIDENCIA HABITUAL"]
[null,null,null,null,null,null,null,null,null,null,null,2019]
[null,"CAPITAL",null,null,"PRIMA NETA ANUAL",null,null,null,"TOTAL NETA",null,null,null,"CONTINENTE","CONTENIDO","OBJETOS ESPECIALES"]
[null,"CONTINENTE","CONTENIDO","EXCESO OBJETOS ESPECIALES","CONTINENTE","CONTENIDO","OBJETOS ESPECIALES","TELÉFONO MÓVIL",{"$f":"+E56+F56+G56+H56","v":0},null,null,"Residencia principal",1.1695E-3,4.7184999999999996E-3,1.6434000000000001E-2]
[null,{"$f":"IF(G30<>\"\"=AND(G30<>F30),G30,F30)","v":0},{"$f":"IF(G31<>\"\"=AND(G31<>F31),G31,F31)","v":0},{"$f":"IF(H49>0,H49,D49)","v":0},{"$f":"(B56*M65/100)-(B56*M65/100)*E25","v":0},{"$f":"(C56*M66/100)-(C56*M66/100)*E25","v":0},{"$f":"(D56*M67/100)-(D56*M67/100)*E25","v":0},{"$f":"IF(E22<>\"\",IF(E24<>\"\",IF(E24=\"Si\",IF(C56<>0,+M68,\"Debe asegurarse contenido\"),0),\"\"),\"\")","v":0},null,null,null,"Residencia secundaria",1.2849999999999999E-3,5.6629999999999996E-3,1.9709999999999998E-2]
[]
[null,"PRIMA MÍNIMA",null,null,{"$f":"+(I58)*E56/(I55-H56)","v":{"$error":"#DIV/0!"}},{"$f":"+I58*F56/(I55-H56)","v":{"$error":"#DIV/0!"}},{"$f":"+I58*G56/(I55-H56)","v":{"$error":"#DIV/0!"}},null,{"$f":"80+H56","v":80},{"$f":"SUM(E58:G58)","v":{"$error":"#DIV/0!"}},null,2020]
[null,null,null,null,null,null,null,null,null,null,null,null,"CONTINENTE","CONTENIDO","OBJETOS ESPECIALES"]
["B","RESIDENCIA SECUNDARIA",null,null,null,null,null,null,null,null,null,"Residencia principal",1.1645E-3,4.7134999999999998E-3,1.6434000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,"Residencia secundaria",1.2800000000000001E-3,5.6579999999999998E-3,1.9709999999999998E-2]
[null,"CAPITAL",null,null,"PRIMA NETA ANUAL",null,null,null,"TOTAL NETA"]
[null,"CONTINENTE","CONTENIDO","EXCESO OBJETOS ESPECIALES","CONTINENTE","CONTENIDO","OBJETOS ESPECIALES","TELÉFONO MÓVIL",{"$f":"+E64+F64+G64+H64","v":0},null,null,null,"TASAS NETAS (%)",null,"TASAS TOTALES (%) 2020",null,"TASAS TOTALES (%) 2021"]
[null,{"$f":"+B56","v":0},{"$f":"+C56","v":0},{"$f":"+D56","v":0},{"$f":"(B64*N65/100)-(B64*N65/100)*E25","v":0},{"$f":"(C64*N66/100)-(C64*N66/100)*E25","v":0},{"$f":"(D64*N67/100)-(D64*N67/100)*E25","v":0},{"$f":"IF(E22<>\"\",IF(E24<>\"\",IF(E24=\"Si\",IF(C56<>0,+M68,\"Debe asegurarse contenido\"),0),\"\"),\"\")","v":0},null,null,null,null,"PRINCIPAL","SECUNDARIA","PRINCIPAL","SECUNDARIA","PRINCIPAL","SECUNDARIA"]
[null,null,null,null,null,null,null,null,null,null,null,"Continente",0.1003,0.1109,0.1176,0.12914999999999999,0.11849999999999999,0.1303]
[null,"PRIMA MÍNIMA",null,null,{"$f":"+I66*E64/(I63-H64)","v":{"$error":"#DIV/0!"}},{"$f":"+I66*F64/(I63-H64)","v":{"$error":"#DIV/0!"}},{"$f":"+I66*G64/(I63-H64)","v":{"$error":"#DIV/0!"}},null,{"$f":"80+H64","v":80},{"$f":"SUM(E66:G66)","v":{"$error":"#DIV/0!"}},null,"Contenido",0.42649999999999999,0.51329999999999998,0.47249999999999998,0.56699999999999995,0.48010000000000003,0.57630000000000003]
[null,null,null,null,null,null,null,null,null,null,null,"Valor especial",1.5105,1.8116000000000001,1.6434,1.9710000000000001,0.17480000000000001,0.13830000000000001]
[null,null,null,null,null,null,null,null,null,null,null,"Teléfono Móvil",6,null,6.53,null,6.65]
[]
[null,{"$f":"IF(E22=\"PRINCIPAL\",B56,B64)","v":0},{"$f":"IF(E22=\"PRINCIPAL\",C56,C64)","v":0},{"$f":"IF(F22=\"PRINCIPAL\",D56,D64)","v":0},{"$f":"IF(E22=\"PRINCIPAL\",E56,E64)","v":0},{"$f":"IF(E22=\"PRINCIPAL\",F56,F64)","v":0},{"$f":"IF(E22=\"PRINCIPAL\",G56,G64)","v":0},{"$f":"IF(H22=\"PRINCIPAL\",H56,H64)","v":0},{"$f":"IF(E22=\"PRINCIPAL\",I55,I63)","v":0}]

{"sheet":"RESULTADOS","index":1,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[5,1,5,9],[8,5,8,8],[10,5,10,8],[30,5,30,8],[31,5,31,8],[17,5,17,8],[19,5,19,8],[20,5,20,8],[21,5,21,8],[11,5,11,8],[12,5,12,8],[13,5,13,8],[14,5,14,8],[15,5,15,8],[9,5,9,8],[18,5,18,8],[33,5,33,8],[32,1,32,9],[22,5,22,8],[26,5,26,8],[27,5,27,8],[28,5,28,8],[29,5,29,8],[69,1,69,9],[36,5,36,8],[37,5,37,8],[47,1,49,9],[43,1,43,9],[52,2,52,4],[54,2,54,4]]}
[]
[]
[]
[]
[]
[null,"SIMULACIÓN SEGURO MULTIRRIESGO HOGAR CAMINOS 2021"]
[]
[]
[null,null,"Tomador:",null,null,"CORPORACIÓN BANCO CAMINOS, S.L.U."]
[null,null,"Fecha de efecto:",null,null,{"$f":"+'TOMA DE DATOS'!E9","v":"00:00:00"}]
[null,null,"Nombre Asegurado:",null,null,{"$f":"+'TOMA DE DATOS'!E10","v":0}]
[null,null,"N.I.F.:",null,null,{"$f":"+'TOMA DE DATOS'!E11","v":0}]
[null,null,"Teléfono de contacto:",null,null,{"$f":"+'TOMA DE DATOS'!E12","v":0}]
[null,null,"Fecha de nacimiento:",null,null,{"$f":"+'TOMA DE DATOS'!E13","v":"00:00:00"}]
[null,null,"Estado Civil:",null,null,{"$f":"+'TOMA DE DATOS'!E14","v":0}]
[null,null,"Correo electrónico:",null,null,{"$f":"+'TOMA DE DATOS'!E15","v":0}]
[]
[null,null,"Residencia a asegurar:",null,null,{"$f":"+'TOMA DE DATOS'!E22","v":"Principal"}]
[null,null,"Tipo de Vivienda:",null,null,{"$f":"+'TOMA DE DATOS'!E23","v":"Piso"}]
[null,null,"Ubicación del Riesgo:",null,null,{"$f":"+'TOMA DE DATOS'!E17","v":0}]
[null,null,null,null,null,{"$f":"+'TOMA DE DATOS'!E18","v":0}]
[null,null,null,null,null,{"$f":"+'TOMA DE DATOS'!E19","v":0}]
[null,null,null,null,null,{"$f":"+'TOMA DE DATOS'!E20","v":0}]
[]
[]
[]
[null,null,"Capital a asegurar Continente:",null,null,{"$f":"'TOMA DE DATOS'!B70","v":0}]
[]
[null,null,"Capital a asegurar Contenido:",null,null,{"$f":"'TOMA DE DATOS'!C70","v":0}]
[]
[null,null,"Valor exceso Objetos especiales (1): ",null,null,{"$f":"'TOMA DE DATOS'!D70","v":0}]
[]
[null,"(1) Objetos especiales: Valor individual >15% cdo. Ó 20.000 euros de valor unitario"]
[]
[]
[]
[null,null,"Prima Total Anual CONTINENTE:",null,null,{"$f":"'TOMA DE DATOS'!Q40","v":0}]
[null,null,"Prima Total Anual CONTENIDO:",null,null,{"$f":"'TOMA DE DATOS'!U40","v":0}]
[null,null,"Prima Total Anual OBJETOS ESPECIALES:",null,null,null,null,null,{"$f":"'TOMA DE DATOS'!Y40","v":0}]
[null,null,null,"PRIMA TOTAL ANUAL:",null,null,null,null,{"$f":"SUM(F37:I39)","v":0}]
[]
[null,null,null,"APLICACIÓN PRIMA MÍNIMA ANUAL (*):",null,null,null,null,{"$f":"IF(I40<80,\"80,00 €\",\"--\")","v":"80,00 €"}]
[]
[null,"(*) Si la prima total anual es inferior a 80 euros, será de aplicación una PRIMA MÍNIMA de este importe"]
[]
[]
[]
[null,"La presente simulación tiene carácter meramente informativo, pudiendo variar en el momento de la contratación efectiva del seguro, para lo cual, el asegurado deberá cumplimentar el Boletín de Inscripción en la Póliza y firmarlo en prueba de adhesión al mismo."]
[]
[]
[]
[]
[null,null,"Conforme, el asegurado:"]
[]
[null,null,"Lugar, fecha y firma del asegurado:"]