{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Datos entrada","Presupuesto","Nota Informativa","Solicitud","Tarificador","Tasas","Recargos por fracc","Primas servicios proveedores"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":42,"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":"Datos entrada","index":0,"n_rows":101,"n_cols":20,"rows_kept":101,"cut":false,"hidden":false,"merged":[[10,1,10,3],[39,0,39,1],[32,0,32,1],[13,0,13,1],[30,0,30,1],[37,0,37,1],[18,0,18,1],[19,0,19,1],[21,0,21,1],[27,0,27,1]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PROFESIÓN",null,"MUERTE","IPA","COMPLEMENTARIOS ACC.","DEPORTE","REGLAS DE SUSCRIPCION PARA TODAS LAS GARANTÍAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ABOGADO/A",{"$f":"LOWER(N2)","v":"abogado/a"},"-","-","-","Sin práctica deportiva/ocio de riesgo","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ADMINISTRATIVO/A",{"$f":"LOWER(N3)","v":"administrativo/a"},"-","-","-","Deporte Profesional","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AGENTE COMERCIAL","agente comercial","-","-","-","Aerobic","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AGENTE DE SEGUROS","agente de seguros","-","-","-","Ala Delta","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AGENTE DE VIAJES","agente de viajes","-","-","-","Artes marciales","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AGRICULTOR","agricultor","-",1,0.5,"Atletismo","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ALBAÑIL","albañil","-",1,1,"Bádminton","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AMA/O DE CASA ","ama/o de casa ","-","-","-","Baloncesto","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ANDAMIAJE (Colocación alturas)","andamiaje (colocación alturas)","Retenido","Retenido","Retenido","Béisbol","Sin recargo"]
[null,"Tarificador Seguro Asisa Vida Mujer",null,null,null,null,null,null,null,null,null,null,null,"ARQUITECTO/A","arquitecto/a","-","-","-","Biatlón/Triatlón/Pentatlón","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ARQUITECTO/A TECNICO","arquitecto/a tecnico","Retenido","Retenido","Retenido","Bolos","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ASESOR/A FISCAL","asesor/a fiscal","-","-","-","Bouldering (escalada en roca sin protección)","Retenido"]
["Datos de entrada de la asegurada",140000,null,null,null,null,null,null,null,null,null,null,null,"AUXILIAR ADMINISTRATIVO","auxiliar administrativo","-","-","-","Boxeo","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AUXILIAR DE CLÍNICA","auxiliar de clínica","-","-","-","Buceo deportivo","Retenido"]
["Fecha efecto","2017-01-01",null,null,null,null,null,null,null,null,null,null,null,"AUXILIAR DE ENFERMERIA","auxiliar de enfermeria","-","-","-","Canoa","Sin recargo"]
["(fecha en que tomará efecto la póliza en Asisa Vida)",null,null,null,null,null,null,null,null,null,null,null,null,"BARRENDERO","barrendero","-",1,1,"Carreras automóviles","Retenido"]
[null,null,null,null,null,null,null,"Si",null,null,null,10000,null,"BIOLOGO/A","biologo/a","-","-","-","Carreras motocicletas","Retenido"]
["Fecha de nacimiento",39,"1967-03-20",null,null,null,null,"No","Hombre",null,null,20000,null,"BOMBERO","bombero","Retenido","Retenido","Retenido","Caza","Retenido"]
["Nombre y apellidos",null,"Sra.Silvia Pose",null,null,null,null,null,"Mujer",null,null,30000,null,"CAMARERO","camarero","-","-","-","Ciclismo","Sin recargo"]
["Sexo",null,"Mujer",null,null,null,null,null,{"$f":"YEARFRAC(B16,C19)","v":49.780555555555559},{"$f":"INT(I21)","v":49},{"$f":"IF((I21-J21)>=0.5,INT(I21)+1,INT(I21))","v":50},null,null,"CAMIONERO","camionero","-",1,1,"Críquet","Sin recargo"]
["NIF",null,"xxxxx",null,null,null,null,null,null,null,null,null,null,"CARNICERO/A","carnicero/a","-","-","-","Escalada ","Retenido"]
["Edad actuarial",null,{"$f":"IF(K21<18,\"Edad actuarial inferior al límite legal\",IF(K21>64,\"Edad de entrada superior al límite\",K21))","v":50},null,null,null,null,"Anual",null,null,null,null,null,"CARTERO/A","cartero/a","-","-","-","Espelología","Retenido"]
["Deportes/ocio (*)",null,"Sin práctica deportiva/ocio de riesgo",null,null,null,null,"Semestral",null,null,null,null,null,"COCINERO/A","cocinero/a","-","-","-","Esquí acuático","Sin recargo"]
["Profesión (*)",null,"administrativo/a",null,null,null,null,"Trimestral",null,null,null,null,null,"COMERCIAL","comercial","-","-","-","Esquí de velocidad","Retenido"]
["(*) Otros Deportes/ocio y profesiones consultar",null,null,null,null,null,null,"Mensual",null,null,null,null,null,"COMERCIANTE","comerciante","-","-","-","Esquí nieve","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CONDUCTOR VEHÍCULO MATERIAL PELIGROSO","conductor vehículo material peligroso","Retenido","Retenido","Retenido","Esquí nieve fuera pistas","Retenido"]
["Modalidades del seguro",null,null,null,null,null,null,null,null,null,null,null,null,"CONDUCTOR VEHÍCULO PESADO","conductor vehículo pesado","-",1,1,"Exhibición aérea, carreras aéreas","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTABLE","contable","-","-","-","Fútbol","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DELINEANTE","delineante","-","-","-","Fútbol Americano amateur","Retenido"]
["Ejecutiva",null,"SI",null,null,null,null,null,null,null,null,null,null,"DEPENDIENTE/A","dependiente/a","-","-","-","Gimnasia","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DISEÑADOR/A","diseñador/a","-","-","-","Globo","Sin recargo"]
["Capitales",null,null,null,null,null,null,null,null,null,null,null,null,"DISEÑADOR/A GRAFICO/A","diseñador/a grafico/a","-","-","-","Golf","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ECONOMISTA","economista","-","-","-","Halterofilia","Retenido"]
["Capital fallecimiento",100000,"(mínimo 18.000 €, máximo 300.000 €)",null,null,null,null,null,null,null,null,null,null,"EDUCADOR/A INFANTIL","educador/a infantil","-","-","-","Hípica","Sin recargo"]
["Capital cáncer femenino",10000,"(Elegir 10.000 €, 20.000 € o 30.000 €)",null,null,null,null,null,null,null,null,null,null,"ELECTRICISTA ALTA TENSIÓN","electricista alta tensión","Retenido","Retenido","Retenido","Hockey (hierba, hielo)","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ELECTRICISTA BAJA TENSIÓN","electricista baja tensión","-",1,0.5,"Karts","Retenido"]
["Forma de pago",null,"Anual",null,null,null,null,null,null,null,null,null,null,"EMPLEADO/A DE BANCA","empleado/a de banca","-","-","-","Kayak","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"EMPLEADO/A DE HOGAR","empleado/a de hogar","-","-","-","Kitesurf (surf con cometa)","Retenido"]
["Total prima anual primera anualidad",null,{"$f":"IF(Tarificador!J6=\"Retenido\",\"Consultar prima por profesión\",IF(Tarificador!J5=\"Retenido\",\"Consultar prima por deporte\",IF(Tarificador!Q22<50,\"Prima inferior al límite mínimo\",IF(Tarificador!G7<30,\"Recibo inferior al límite mínimo\",IF(B36>B35,\"Capital cáncer superior al capital de fallecimiento\",IF(B35<18000,\"Capital por debajo del límite mínimo\",Tarificador!Q22))))))","v":567.01810618333366},null,null,null,null,null,null,null,null,null,null,"ENFERMERO/A O D.U.E.","enfermero/a o d.u.e.","-","-","-","Lanchas motoras","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ESTETICIEN/ESTETICISTA","esteticien/esteticista","-","-","-","Levantamiento de pesas","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ESTIBADOR","estibador","Retenido","Retenido","Retenido","Lucha extrema","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ESTUDIANTE, BECARIO","estudiante, becario","-","-","-","Montañismo/Alpinismo","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FARMACEUTICO (SIN FABRIC. DE PRODUCTOS)","farmaceutico (sin fabric. de productos)","-","-","-","Natación","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FARMACEUTICO/A","farmaceutico/a","-","-","-","Padel","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FISIOTERAPEUTA","fisioterapeuta","-","-","-","Paracaidismo, caída libre","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FONTANERO","fontanero","-",1,0.5,"Parapente","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FORESTAL","forestal","Retenido","Retenido","Retenido","Parkour o yamakasi (saltar entre edificios)","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FUNCIONARIO PRISIONES (ADMINISTRATIVO)","funcionario prisiones (administrativo)","-","-","-","Planeador","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FUNCIONARIO PRISIONES (GUARDIA)","funcionario prisiones (guardia)","-",0.5,0.5,"Polo","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GERENTE","gerente","-","-","-","Puenting","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GUARDIA CIVIL","guardia civil","-",0.5,0.5,"Quad","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GUARDIA CIVIL (EXPLOSIVOS)","guardia civil (explosivos)","Retenido","Retenido","Retenido","Raquetas de nieve","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"HIGIENISTA DENTAL","higienista dental","-","-","-","Remo","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"HOSTELERIA","hosteleria","-","-","-","Rugby","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"INFORMATICO/A","informatico/a","-","-","-","Salto base (desde sitios fijos con paracaídas)","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"INGENIERO DE CAMINOS CANALES Y PUERTOS","ingeniero de caminos canales y puertos","-","-","-","Senderismo","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"INGENIERO INDUSTRIAL","ingeniero industrial","-","-","-","Skydiving (paracaidismo con instructor)","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"INGENIERO TECNICO","ingeniero tecnico","-","-","-","Skysurfing (surfeo aéreo con tabla)","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"INGENIERO/A","ingeniero/a","-","-","-","Squash","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"INGENIERO/A DE TELECOMUNICACIONES","ingeniero/a de telecomunicaciones","-","-","-","Streetluge (trineo de asfalto)","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"INGENIERO/A INFORMATICO","ingeniero/a informatico","-","-","-","Surf, surfski","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPIADOR/A","limpiador/a","-",1,0.5,"Tiro olímpico","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LIMPIEZA DOMÉSTICA/LOCALES","limpieza doméstica/locales","-",1,0.5,"Trekking","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MECÁNICO AERONAVES","mecánico aeronaves","-","-","-","Ultraligero","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MECÁNICO COCHES/MOTOS","mecánico coches/motos","-",0.5,0.5,"Vela (amateur aguas costeras)","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MEDICO",{"$f":"LOWER(N67)","v":"medico"},"-","-","-","Vela (amateur mar adentro y transoceánico)","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MILITAR (OFICIAL)","militar (oficial)","-","-",0.5,"Waterpolo","Sin recargo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MILITAR (OTROS RANGOS)","militar (otros rangos)",null,0.5,1,"Wingsuit (traje aéreo, paracaidismo)","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MILITAR (RESERVA)","militar (reserva)","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MONTADOR ANDAMIAJE","montador andamiaje","Retenido","Retenido","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ODONTOLOGO/A","odontologo/a","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OPERADOR ALTURA","operador altura","Retenido","Retenido","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OPERADOR GRÚA","operador grúa","Retenido","Retenido","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OPERADOR PLANTA REFINO","operador planta refino","-",2,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OPERARIO CADENA PRODUCCIÓN","operario cadena producción","-",0.5,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OTROS (CONSTRUCCION)","otros (construccion)","-",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PELUQUERO/A","peluquero/a","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PEÓN","peón","-",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PERIODISTA","periodista","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PILOTO comercial mercancias","piloto comercial mercancias","Retenido","Retenido","Retenido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PILOTO comercial tripulación","piloto comercial tripulación","-","-",0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PINTOR","pintor","-",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"POLICIA LOCAL","policia local","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"POLICIA NACIONAL, MOSSO D'ESQUADRA","policia nacional, mosso d'esquadra","-",0.5,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PROFESOR/A O MAESTRO/A","profesor/a o maestro/a","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PSICOLOGO/A","psicologo/a","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PSICOLOGO/A CLINICA","psicologo/a clinica","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PUBLICISTA","publicista","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"QUIMICO/A","quimico/a","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"RECEPCIONISTA","recepcionista","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SECRETARIO/A","secretario/a","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TAXISTA","taxista","-",0.5,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TECNICO MANTENIMIENTO","tecnico mantenimiento","-",0.5,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TRABAJADOR/A SOCIAL","trabajador/a social","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TRADUCTOR/A","traductor/a","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTISTA","transportista","-",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VENDEDOR/A","vendedor/a","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VIGILANTE SEGURIDAD","vigilante seguridad","-",0.5,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"YESERO","yesero","-",1,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Presupuesto","index":1,"n_rows":62,"n_cols":7,"rows_kept":62,"cut":false,"hidden":true,"merged":[[22,1,22,2],[27,1,27,3],[28,1,29,1],[28,2,29,2],[28,3,29,3],[16,1,16,12],[17,1,17,12],[21,1,21,2],[19,1,19,3],[20,2,20,3],[54,1,54,3],[55,1,55,3],[23,1,23,2],[53,1,53,3],[24,1,24,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Presupuesto de Seguro Asisa Vida Mujer"]
[]
[]
[null,null,"Fecha efecto",{"$f":"'Datos entrada'!$B$16","v":"2017-01-01"}]
[]
[]
[null,"A continuación le presentamos su presupuesto personalizado de Vida Riesgo, que ha sido diseñado especialmente para usted de acuerdo con la información que nos ha facilitado. "]
[]
[null,null,null,null,null,1,"Anual"]
[null,"Datos del asegurado",null,null,null,2,"Semestral"]
[null,"Nombre:",{"$f":"'Datos entrada'!C20","v":"Sra.Silvia Pose"},null,null,4,"Trimestral"]
[null,"Fecha de nacimiento:",null,{"$f":"'Datos entrada'!C19","v":"1967-03-20"},null,12,"Mensual"]
[null,"Edad actuarial:",null,{"$f":"'Datos entrada'!C23","v":50}]
[null,"Sexo:",null,{"$f":"'Datos entrada'!C21","v":"Mujer"}]
[null,"NIF:",null,{"$f":"'Datos entrada'!C22","v":"xxxxx"}]
[null,"Forma de pago",null,{"$f":"'Datos entrada'!C38","v":"Anual"}]
[]
[null,"Servicios, garantías, capitales solicitados y prima"]
[null,"Servicios y garantías","Capitales asegurados"]
[]
[null,"Testamento on-line","Incluido"]
[null,"Testamento vital","Incluido"]
[null,"Servicio ayuda a domicilio","Incluido"]
[null,"Gastos para adquisición peluca","Incluido"]
[null,"Gastos de lavado de peluca y cabeza","Incluido"]
[null,"Gastos para cursos de estética","Incluido"]
[null,"Asesoramiento médico telefónico 24 x 365","Incluido"]
[null,"Revisión dental","Incluido"]
[null,"Acceso exclusivo club Asisa Mujer","Incluido"]
[null,"Donación 5% prima neta al Centro Nacional de Investigaciones Oncológicas Carlos III","Incluido"]
[null,"Adecuación vivienda por IPA por accidente",{"$f":"IF('Datos entrada'!C31=\"No\",\"No incluido\", \"Incluido\")","v":"Incluido"}]
[null,"Adecuación vehiculo por IPA por accidente",{"$f":"IF('Datos entrada'!C31=\"No\",\"No incluido\", \"Incluido\")","v":"Incluido"}]
[null,"Asesoramiento jurídico telefónico",{"$f":"IF('Datos entrada'!C31=\"No\",\"No incluido\", \"Incluido\")","v":"Incluido"}]
[null,"Servicio de ayuda legal 24 horas",{"$f":"IF('Datos entrada'!C31=\"No\",\"No incluido\", \"Incluido\")","v":"Incluido"}]
[null,"Cancer ginecológico",{"$f":"Tarificador!B10","v":10000}]
[null,"Fallecimiento",{"$f":"Tarificador!B9","v":100000}]
[null,"Incapacidad permanente absoluta",{"$f":"Tarificador!B11","v":100000}]
[null,"Total prima neta:",null,{"$f":"IF('Datos entrada'!B35<18000,\"-\",IF('Datos entrada'!B36>'Datos entrada'!B35,\"-\",IF(Tarificador!Q22<50,\"-\",IF(Tarificador!G7<30,\"-\",Tarificador!O22))))","v":553.22923333333358}]
[null,"Total impuestos repercutibles:",null,{"$f":"IF('Datos entrada'!B35<18000,\"-\",IF('Datos entrada'!B36>'Datos entrada'!B35,\"-\",IF(Tarificador!Q22<50,\"-\",IF(Tarificador!G7<30,\"-\",Tarificador!P22))))","v":13.788872850000004}]
[null,"Total prima primera anualidad:",null,{"$f":"IF(Tarificador!G7<30,\"Recibo inferior al límite mínimo\",IF(Tarificador!Q22<50,\"Prima inferior límite mínimo\",IF('Datos entrada'!B36>'Datos entrada'!B35,\"Capital cáncer superior al capital de fallecimiento\",IF('Datos entrada'!B35<18000,\"Capital por debajo del límite mínimo\",Tarificador!Q22))))","v":567.01810618333366}]
[null,"Importe primer recibo:",null,{"$f":"IF(Tarificador!G7<30,\"-\",Tarificador!G7)","v":"-"}]
[null,"Importe recibos siguientes:",null,{"$f":"IF(Tarificador!G7<30,\"-\",Tarificador!G6)","v":"-"}]
[]
[null,"(*) Este presupuesto es de carácter informativo y no vincula a la aceptación del capital, garantías y primas en él reflejadas que"]
[null,"dependen de la valoración y aceptación del riesgo en base a la política de suscripción Asisa Vida. "]
[]
[]
[null,"ASISA VIDA SEGUROS, S.A."]
[null,"C.I.F.: A87425070",null,"Inscrita al Tomo 34.096, Folio 49, Sección 8 Hoja"]
[null,"Domicilio social: c/ Juan Ignacio Luca de Tena, 12, 28027 Madrid",null,"M-613345, Inscripción 1ª. C"]
[]
[null,null,{"$f":"CONCATENATE(Tarificador!K4,Tarificador!K9)","v":"Ref.-"}]

{"sheet":"Nota Informativa","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Solicitud","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tarificador","index":4,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":true,"merged":[[16,0,16,1],[19,0,19,1]]}
["Tarificador TAR Asisa Vida Mujer"]
[]
[]
[null,null,null,"PRIMA ANUAL ",{"$f":"Q22","v":567.01810618333366},null,null,null,null,null,"Ref.","Versión"]
["Edad:",{"$f":"'Datos entrada'!C23","v":50},null,"Prima anual sin consorcio",null,null,{"$f":"IF(B7=\"Anual\",\"-\",H22+I22+J22+K22+L22)","v":"-"},null,{"$f":"'Datos entrada'!C24","v":"Sin práctica deportiva/ocio de riesgo"},{"$f":"VLOOKUP(I5,'Datos entrada'!S2:T69,2,0)","v":"Sin recargo"}]
[null,null,null,"Importe por recibo",null,null,{"$f":"IF(B7=\"Anual\",\"-\",IF(B7=\"Anual\",(H22+I22+J22)/1,IF(B7=\"Semestral\",(H22+I22+J22)/2,IF(B7=\"Trimestral\",(H22+I22+J22)/4,(H22+I22+J22)/12))))","v":"-"},null,{"$f":"'Datos entrada'!C25","v":"administrativo/a"},{"$f":"VLOOKUP(I6,'Datos entrada'!O2:R100,2,0)","v":"-"},{"$f":"VLOOKUP(I6,'Datos entrada'!O2:R100,3,0)","v":"-"},{"$f":"VLOOKUP(I6,'Datos entrada'!O2:R100,4,0)","v":"-"}]
["Periodicidad",{"$f":"'Datos entrada'!C38","v":"Anual"},null,"Importe primer recibo",null,null,{"$f":"IF(B7=\"Anual\",\"-\",G6+L22+K22)","v":"-"},null,null,{"$f":"IF(J6=\"Retenido\",\"No\",\"Si\")","v":"Si"},{"$f":"IF(K6=\"Retenido\",\"No\",\"Si\")","v":"Si"},"Si"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J7=\"Si\",IF(J6=\"-\",0,J6),\"\")","v":0},{"$f":"IF(K7=\"Si\",IF(K6=\"-\",0,K6),\"\")","v":0},0]
["Capital fallec.",{"$f":"'Datos entrada'!B35","v":100000},null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Retenido\",\"-\",K6)","v":"-"},{"$f":"IF(L6=\"Retenido\",\"-\",L6)","v":"-"}]
["Capital cancer",{"$f":"'Datos entrada'!B36","v":10000}]
["Capital IPA",{"$f":"IF('Datos entrada'!C30=\"Si\",0,B9)","v":100000}]
[]
["Gastos internos",0.1]
["Gastos externos",0.4]
[null,null,null,null,null,null,null,null,"Recargo",null,null,null,null,"Garantias","Prima total",null,"Prima total"]
[null,null,null,"Prima Pura","Gastos interno","Gasto fijo","Gastos externos","Prima comercial neta","Fracci.","IPS","CLEA","Consorcio","Prima total","Seleccionadas","neta","Solo Impuestos","primera anualidad"]
["Fallecimiento",null,null,{"$f":"VLOOKUP(B5,Tasas!A2:K59,6,0)/1000*B9*(1+J8)","v":183.90000000000003},{"$f":"$B$13*D17","v":18.390000000000004},0,{"$f":"$B$14*H17","v":134.86000000000004},{"$f":"D17*(1+$B$13)/(1-$B$14)","v":337.15000000000009},{"$f":"VLOOKUP($B$7,'Recargos por fracc'!$A$1:$B$4,2,0)*H17","v":0},null,null,{"$f":"($B$9/1000)*0.005","v":0.5},{"$f":"SUM(H17:L17)","v":337.65000000000009},"Si",{"$f":"IF(N17=\"Si\",H17+I17,0)","v":337.15000000000009},{"$f":"IF(N17=\"Si\",SUM(J17:L17),0)","v":0.5},{"$f":"IF(N17=\"Si\",M17,0)","v":337.65000000000009}]
["Cancer ginecologico",null,null,{"$f":"VLOOKUP(B5,Tasas!A2:K59,8,0)/1000*B10","v":37.1175},{"$f":"$B$13*D18","v":3.7117500000000003},0,{"$f":"$B$14*H18","v":27.219500000000007},{"$f":"D18*(1+$B$13)/(1-$B$14)","v":68.048750000000013},{"$f":"VLOOKUP($B$7,'Recargos por fracc'!$A$1:$B$4,2,0)*H18","v":0},{"$f":"(H18+I18)*0.06","v":4.0829250000000004},{"$f":"(H18+I18)*0.0015","v":0.10207312500000001},null,{"$f":"SUM(H18:L18)","v":72.23374812500002},"Si",{"$f":"IF(N18=\"Si\",H18+I18,0)","v":68.048750000000013},{"$f":"IF(N18=\"Si\",SUM(J18:L18),0)","v":4.1849981250000008},72.23374812500002]
["Pack A servicios",null,null,{"$f":"('Primas servicios proveedores'!B3+'Primas servicios proveedores'!B19)*(1+21%)","v":7.3325999999999993},0.73326000000000002,0,5.3772400000000005,13.443100000000001,{"$f":"VLOOKUP($B$7,'Recargos por fracc'!$A$1:$B$4,2,0)*H19","v":0},{"$f":"(H19+I19)*0.06","v":0.80658600000000003},{"$f":"(H19+I19)*0.0015","v":2.0164650000000003E-2},null,{"$f":"SUM(H19:L19)","v":14.26985065},"Si",{"$f":"IF(N19=\"Si\",H19+I19,0)","v":13.443100000000001},{"$f":"IF(N19=\"Si\",SUM(J19:L19),0)","v":0.82675065000000003},14.26985065]
["IPA",null,null,{"$f":"VLOOKUP(B5,Tasas!A2:K59,10,0)/1000*B11*(1+K8)","v":70.350000000000009},7.035000000000001,0,51.590000000000025,128.97500000000005,{"$f":"VLOOKUP($B$7,'Recargos por fracc'!$A$1:$B$4,2,0)*H20","v":0},7.7385000000000028,0.19346250000000009,null,{"$f":"SUM(H20:L20)","v":136.90696250000008},{"$f":"'Datos entrada'!C31","v":"SI"},{"$f":"IF(N20=\"Si\",H20+I20,0)","v":128.97500000000005},{"$f":"IF(N20=\"Si\",SUM(J20:L20),0)","v":7.9319625000000027},136.90696250000008]
["Pack B servicios",null,null,{"$f":"IF(N21=\"No\",0,'Primas servicios proveedores'!B12*(1+21%))","v":3.0612999999999997},0.30613000000000001,0,2.2449533333333336,5.6123833333333337,{"$f":"VLOOKUP($B$7,'Recargos por fracc'!$A$1:$B$4,2,0)*H21","v":0},0.33674300000000001,8.4185750000000011E-3,null,{"$f":"SUM(H21:L21)","v":5.9575449083333343},{"$f":"IF(N20=\"Si\",\"Si\",\"No\")","v":"Si"},{"$f":"IF(N21=\"Si\",H21+I21,0)","v":5.6123833333333337},{"$f":"IF(N21=\"Si\",SUM(J21:L21),0)","v":0.345161575},5.9575449083333343]
["Totales",null,null,{"$f":"SUM(D17:D21)","v":301.76140000000009},30.176140000000004,0,221.29169333333343,553.22923333333358,0,12.964754000000005,0.32411885000000007,0.5,567.01810618333366,null,{"$f":"SUM(O17:O21)","v":553.22923333333358},{"$f":"SUM(P17:P21)","v":13.788872850000004},{"$f":"IF(B9>300000,\"Capital superior al limite\",SUM(Q17:Q21))","v":567.01810618333366}]

{"sheet":"Tasas","index":5,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["Edades","Tasa reaseguro neta fallecimiento pdo. Mujer","Tasa reaseguro neta cáncer femenino pdo. Mujer","Tasa reaseguro neta IPA pdo. Mujer","PASEM 2010 mujeres publicada DGSFP","Tasa directo fallecimiento (75% pasem 2010 mujeres)","Margen sobre tasa reaseguro fallecimiento","Tasa directo neta cáncer femenino","Margen sobre tasa reaseguro cancer","Tasa directo neta IPA","Margen sobre tasa reaseguro ipa"]
[18,0.19500000000000001,2.1000000000000001E-2,0.2,0.3,{"$f":"E2*75%","v":0.22499999999999998},{"$f":"(F2-B2)/B2","v":0.15384615384615369},{"$f":"C2*1.05","v":2.2050000000000004E-2},{"$f":"(H2-C2)/C2","v":5.0000000000000107E-2},{"$f":"D2*1.05","v":0.21000000000000002},{"$f":"(J2-D2)/D2","v":5.0000000000000044E-2},null,18,0.19,0.247]
[19,0.20280000000000001,2.4E-2,0.2,0.312,{"$f":"E3*75%","v":0.23399999999999999},{"$f":"(F3-B3)/B3","v":0.15384615384615374},{"$f":"C3*1.05","v":2.52E-2},{"$f":"(H3-C3)/C3","v":4.9999999999999989E-2},{"$f":"D3*1.05","v":0.21000000000000002},{"$f":"(J3-D3)/D3","v":5.0000000000000044E-2},null,19,0.19,0.247]
[20,0.20670000000000002,0.03,0.2,0.318,0.23849999999999999,0.15384615384615366,3.15E-2,5.0000000000000044E-2,0.21000000000000002,5.0000000000000044E-2,null,20,0.19,0.247]
[21,0.20735000000000001,0.04,0.2,0.31900000000000001,0.23925000000000002,0.15384615384615391,4.2000000000000003E-2,5.0000000000000044E-2,0.21000000000000002,5.0000000000000044E-2,null,21,0.19,0.247]
[22,0.20605000000000001,5.1999999999999998E-2,0.2,0.317,0.23775000000000002,0.15384615384615385,5.4600000000000003E-2,5.00000000000001E-2,0.21000000000000002,5.0000000000000044E-2,null,22,0.19,0.247]
[23,0.20475000000000002,6.6000000000000003E-2,0.2,0.315,0.23625000000000002,0.15384615384615383,6.93E-2,4.9999999999999961E-2,0.21000000000000002,5.0000000000000044E-2,null,23,0.19,0.247]
[24,0.20605000000000001,8.5999999999999993E-2,0.2,0.317,0.23775000000000002,0.15384615384615385,9.0299999999999991E-2,4.9999999999999982E-2,0.21000000000000002,5.0000000000000044E-2,null,24,0.19,0.247]
[25,0.20930000000000001,0.109,0.2,0.32200000000000001,0.24149999999999999,0.15384615384615374,0.11445000000000001,5.0000000000000093E-2,0.21000000000000002,5.0000000000000044E-2,null,25,0.19,0.247]
[26,0.19564999999999999,0.13800000000000001,0.2,0.30099999999999999,0.22575000000000001,0.15384615384615394,0.14490000000000003,5.0000000000000121E-2,0.21000000000000002,5.0000000000000044E-2,null,26,0.19,0.247]
[27,0.1885,0.17299999999999999,0.2,0.28999999999999998,0.21749999999999997,0.15384615384615369,0.18165000000000001,5.0000000000000114E-2,0.21000000000000002,5.0000000000000044E-2,null,27,0.19,0.247]
[28,0.18460000000000001,0.21299999999999999,0.2,0.28400000000000003,0.21300000000000002,0.15384615384615388,0.22365000000000002,5.00000000000001E-2,0.21000000000000002,5.0000000000000044E-2,null,28,0.19,0.247]
[29,0.18330000000000002,0.26200000000000001,0.2,0.28200000000000003,0.21150000000000002,0.15384615384615385,0.27510000000000001,0.05,0.21000000000000002,5.0000000000000044E-2,null,29,0.19,0.247]
[30,0.18005000000000002,0.31900000000000001,0.18,0.27700000000000002,0.20775000000000002,0.15384615384615385,0.33495000000000003,5.0000000000000058E-2,0.189,5.0000000000000044E-2,null,30,0.19,0.247]
[31,0.19564999999999999,0.38500000000000001,0.18,0.30099999999999999,0.22575000000000001,0.15384615384615394,0.40425000000000005,5.0000000000000114E-2,0.189,5.0000000000000044E-2,null,31,0.19,0.247]
[32,0.21320000000000003,0.46200000000000002,0.18,0.32800000000000001,0.246,0.15384615384615369,0.48510000000000003,5.0000000000000017E-2,0.189,5.0000000000000044E-2,null,32,0.19,0.247]
[33,0.23530000000000004,0.55600000000000005,0.18,0.36200000000000004,0.27150000000000002,0.15384615384615374,0.5838000000000001,5.0000000000000079E-2,0.189,5.0000000000000044E-2,null,33,0.19,0.247]
[34,0.26910000000000001,0.66300000000000003,0.18,0.41399999999999998,0.3105,0.15384615384615383,0.69615000000000005,5.0000000000000017E-2,0.189,5.0000000000000044E-2,null,34,0.19,0.247]
[35,0.31070000000000003,0.78700000000000003,0.2,0.47800000000000004,0.35850000000000004,0.15384615384615385,0.82635000000000003,4.9999999999999996E-2,0.21000000000000002,5.0000000000000044E-2,null,35,0.2,0.28399999999999997]
[36,0.3614,0.92600000000000005,0.2,0.55599999999999994,0.41699999999999993,0.15384615384615363,0.97230000000000005,0.05,0.21000000000000002,5.0000000000000044E-2,null,36,0.21,0.28399999999999997]
[37,0.41665000000000002,1.075,0.2,0.64100000000000001,0.48075000000000001,0.15384615384615383,1.1287499999999999,4.9999999999999968E-2,0.21000000000000002,5.0000000000000044E-2,null,37,0.23,0.28399999999999997]
[38,0.4758,1.234,0.2,0.73199999999999998,0.54899999999999993,0.15384615384615372,1.2957000000000001,5.0000000000000072E-2,0.21000000000000002,5.0000000000000044E-2,null,38,0.26,0.28399999999999997]
[39,0.55120000000000002,1.3959999999999999,0.2,0.84799999999999998,0.63600000000000001,0.15384615384615383,1.4658,5.0000000000000065E-2,0.21000000000000002,5.0000000000000044E-2,null,39,0.28000000000000003,0.28399999999999997]
[40,0.63569999999999993,1.5620000000000001,0.24,0.97799999999999987,0.73349999999999993,0.15384615384615385,1.6401000000000001,5.0000000000000037E-2,0.252,5.0000000000000044E-2,null,40,0.31,0.33]
[41,0.72604999999999997,1.732,0.27,1.117,0.83774999999999999,0.15384615384615388,1.8186,5.000000000000001E-2,0.28350000000000003,5.0000000000000044E-2,null,41,0.34,0.377]
[42,0.81314999999999993,1.9119999999999999,0.3,1.2509999999999999,0.93824999999999992,0.15384615384615385,2.0076000000000001,5.0000000000000072E-2,0.315,5.0000000000000044E-2,null,42,0.36,0.42899999999999999]
[43,0.89049999999999996,2.1040000000000001,0.35,1.3699999999999999,1.0274999999999999,0.15384615384615374,2.2092000000000001,4.9999999999999982E-2,0.36749999999999999,5.0000000000000044E-2,null,43,0.39,0.48599999999999999]
[44,0.96005000000000007,2.306,0.4,1.4770000000000001,1.10775,0.15384615384615377,2.4213,4.9999999999999982E-2,0.42000000000000004,5.0000000000000044E-2,null,44,0.42,0.54700000000000004]
[45,1.0308999999999999,2.516,0.43,1.5859999999999999,1.1894999999999998,0.15384615384615372,2.6417999999999999,4.9999999999999968E-2,0.45150000000000001,5.0000000000000044E-2,null,45,0.45,0.61]
[46,1.10955,2.7309999999999999,0.48,1.7070000000000001,1.2802500000000001,0.15384615384615391,2.86755,5.0000000000000065E-2,0.504,5.0000000000000044E-2,null,46,0.49,0.65600000000000003]
[47,1.2025000000000001,2.9430000000000001,0.52,1.85,1.3875000000000002,0.15384615384615388,3.0901500000000004,5.0000000000000114E-2,0.54600000000000004,5.0000000000000044E-2,null,47,0.53,0.70899999999999996]
[48,1.3110500000000003,3.1509999999999998,0.55000000000000004,2.0170000000000003,1.5127500000000003,0.1538461538461538,3.3085499999999999,5.0000000000000031E-2,0.57750000000000012,5.0000000000000142E-2,null,48,0.57999999999999996,0.77]
[49,1.4417,3.3479999999999999,0.6,2.218,1.6635,0.15384615384615385,3.5154000000000001,5.0000000000000065E-2,0.63,5.0000000000000044E-2,null,49,0.62,0.83699999999999997]
[50,1.5938000000000003,3.5350000000000001,0.67,2.4520000000000004,1.8390000000000004,0.15384615384615385,3.7117500000000003,5.0000000000000051E-2,0.70350000000000013,5.0000000000000128E-2,null,50,0.68,0.91200000000000003]
[51,1.7712500000000002,3.7050000000000001,0.7,2.7250000000000001,2.0437500000000002,0.1538461538461538,3.8902500000000004,5.0000000000000093E-2,0.73499999999999999,5.0000000000000044E-2,null,51,0.73,0.998]
[52,1.9578,3.8650000000000002,0.75,3.012,2.2589999999999999,0.1538461538461538,4.0582500000000001,4.9999999999999975E-2,0.78750000000000009,5.0000000000000121E-2,null,52,0.79,1.093]
[53,2.1320000000000001,4.0119999999999996,0.8,3.28,2.46,0.15384615384615377,4.2126000000000001,5.0000000000000142E-2,0.84000000000000008,5.0000000000000044E-2,null,53,0.86,1.1739999999999999]
[54,2.2860500000000004,4.1479999999999997,0.9,3.5170000000000003,2.6377500000000005,0.15384615384615388,4.3553999999999995,4.9999999999999954E-2,0.94500000000000006,5.0000000000000044E-2,null,54,0.94,1.262]
[55,2.4258000000000002,4.2670000000000003,1,3.7320000000000002,2.7990000000000004,0.15384615384615391,4.4803500000000005,5.0000000000000031E-2,1.05,5.0000000000000044E-2,null,55,1.02,1.3520000000000001]
[56,2.56555,4.3600000000000003,1.2210000000000001,3.9470000000000001,2.9602500000000003,0.15384615384615397,4.5780000000000003,4.9999999999999989E-2,1.2820500000000001,5.0000000000000037E-2,null,56,1.1100000000000001,1.6719999999999999]
[57,2.7098499999999999,4.431,1.331,4.1689999999999996,3.1267499999999995,0.15384615384615372,4.6525500000000006,5.0000000000000128E-2,1.3975500000000001,5.0000000000000086E-2,null,57,1.21,1.782]
[58,2.8554499999999998,4.4829999999999997,1.452,4.3929999999999998,3.2947499999999996,0.1538461538461538,4.7071499999999995,4.9999999999999968E-2,1.5246,0.05,null,58,1.32,1.883]
[59,2.9887000000000001,4.5170000000000003,1.573,4.5979999999999999,3.4485000000000001,0.15384615384615383,4.7428500000000007,5.0000000000000072E-2,1.6516500000000001,5.0000000000000072E-2,null,59,1.43,1.9830000000000001]
[60,3.1206500000000004,4.5380000000000003,1.7270000000000001,4.8010000000000002,3.6007500000000001,0.15384615384615374,4.7649000000000008,5.0000000000000121E-2,1.8133500000000002,5.0000000000000086E-2,null,60,1.57,2.073]
[61,3.2694999999999999,4.5439999999999996,1.881,5.0299999999999994,3.7724999999999995,0.15384615384615374,4.7711999999999994,4.9999999999999968E-2,1.9750500000000002,5.00000000000001E-2,null,61,1.71,2.1539999999999999]
[62,3.4404500000000002,4.5350000000000001,2.0569999999999999,5.2930000000000001,3.9697500000000003,0.15384615384615385,4.7617500000000001,0.05,2.15985,5.0000000000000051E-2,null,62,1.87,2.2320000000000002]
[63,3.6387,4.5140000000000002,2.2440000000000002,5.5979999999999999,4.1985000000000001,0.15384615384615385,4.7397,4.9999999999999954E-2,2.3562000000000003,5.0000000000000031E-2,null,63,2.04,2.34]
[64,3.8896000000000002,4.476,2.4529999999999998,5.984,4.4879999999999995,0.15384615384615369,4.6997999999999998,4.9999999999999947E-2,2.57565,5.0000000000000065E-2,null,64,2.23,2.4380000000000002]
[65,4.2256499999999999,4.4180000000000001,2.6970000000000001,6.5009999999999994,4.87575,0.15384615384615388,4.6389000000000005,5.0000000000000072E-2,2.8318500000000002,5.0000000000000051E-2]
[66,4.6462000000000003,4.4180000000000001,2.9670000000000001,7.1479999999999997,5.3609999999999998,0.15384615384615372,4.6389000000000005,5.0000000000000072E-2,3.1153500000000003,5.0000000000000065E-2]
[67,5.1551500000000008,4.4180000000000001,3.2629999999999999,7.9310000000000009,5.9482500000000007,0.1538461538461538,4.6389000000000005,5.0000000000000072E-2,3.4261500000000003,5.0000000000000107E-2]
[68,5.7707000000000006,null,null,8.8780000000000001,6.6585000000000001,0.15384615384615374]
[69,6.4947999999999997,null,null,9.9919999999999991,7.4939999999999998,0.15384615384615385]
[70,7.32355,null,null,11.266999999999999,8.4502500000000005,0.15384615384615391]
[71,8.2582500000000003,null,null,12.705,9.5287500000000005,0.15384615384615385]
[72,9.3034499999999998,null,null,14.312999999999999,10.734749999999998,0.15384615384615369]
[73,11.425700000000001,null,null,17.577999999999999,13.183499999999999,0.15384615384615363]
[74,14.0829,null,null,21.666,16.249500000000001,0.15384615384615388]
[75,17.475249999999999,null,null,26.884999999999998,20.16375,0.15384615384615394]

{"sheet":"Recargos por fracc","index":6,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Anual",0]
["Trimestral",0.01]
["Semestral",0.02]
["Mensual",0.03]

{"sheet":"Primas servicios proveedores","index":7,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Precio servicios","Primas cobradas por los proveedores","Nombre proveedor"]
[]
["PACK A",5.31,"Europ Assistance"]
[]
["Testamento online"]
["Testamento vital"]
["Gasto adquisicion peluca"]
["Gasto de lavado de peluca y cabeza"]
["Gasto para curso de estética"]
["Servicios ayuda a domicilio"]
[]
["PACK B",2.5299999999999998,"Europ Assistance"]
[]
["Adecuación vivivenda por IPA por acc."]
["Adecuación vehículo por IPA por acc."]
["Asesoramiento jurídico telefónico"]
["Servicio ayuda legal 24 horas"]
[]
["PACK C",0.75]
[]
["Asesoramiento medico telefonocio 24x 365",null,"Asiser"]
["Revisión dental",null,"Asisa dental"]