{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["INGRESO DE DATOS","Exclusive","Privilege","Advantage (Mundial)","Advantage (LA)","Secure","Essential","Critical","Resumen tarifas anuales","Comparacion de Beneficios","Tablas"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INGRESO DE DATOS","index":0,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,0,7,9],[11,3,11,9],[20,3,20,9]]}
[]
[null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null," "," "," "," "]
[]
["COTIZACION DE SEGURO MEDICO INTERNACIONAL"]
[]
["1. INGRESE LOS DATOS DEL PROPUESTO ASEGURADO:"]
[]
[null,null,"Nombre del Asegurado principal:","NOMBRE COMPLETO"]
[]
[null,null,null,null,null,"Número de adultos en la póliza: ",1,null,"Número de hijos en la póliza:",0]
[]
[null,null,null,null,null," Edad del titular:",18,null,"Edad de cónyuge:",18]
[]
[]
["2. INGRESE EL NOMBRE DE LA AGENCIA ASESORA:"]
[]
[null,null,"Nombre de la Agencia:","AGENTE"]
[]
[]
["3. ESCOJA EL PRODUCTO PARA VISUALIZAR LA COTIZACION RESPECTIVA:"]

{"sheet":"Exclusive","index":1,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,5,50,12],[48,0,49,1],[48,2,49,3],[34,0,34,1],[45,0,45,1],[40,0,40,1],[41,0,41,1],[45,2,45,3],[43,0,43,1],[44,0,44,1],[42,0,42,1],[47,0,47,1],[47,2,47,3],[35,0,35,1],[36,0,38,1],[36,2,38,3],[46,0,46,1],[19,0,19,1],[26,0,26,1],[21,2,21,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[25,0,25,1],[26,2,26,3],[27,0,27,1],[20,0,21,1],[28,0,28,1],[31,2,31,3],[27,2,27,3],[29,0,29,1],[30,0,31,1],[9,2,9,12],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[23,2,23,3],[30,2,30,3],[46,2,46,3],[17,2,18,3],[29,2,29,3],[24,2,24,3],[19,2,19,3],[20,2,20,3],[22,2,22,3],[40,2,40,3],[35,2,35,3],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[12,0,12,1],[17,0,18,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[51,0,51,1],[51,2,51,3],[50,0,50,1],[50,2,50,3],[28,2,28,3],[32,0,32,1],[33,0,33,1],[32,2,32,3],[44,2,44,3],[39,0,39,1],[34,2,34,3],[33,2,33,3],[41,2,41,3],[42,2,42,3],[39,2,39,3],[43,2,43,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa EXCLUSIVE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T11:14:05.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null," ",false]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,4,TRUE)","v":10105},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":6685},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":4731},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":3310},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":2602}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$33)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":10105},{"$f":"SUM(J31:J34)","v":6685},{"$f":"SUM(K31:K34)","v":4731},{"$f":"SUM(L31:L34)","v":3310},{"$f":"SUM(M31:M34)","v":2602}]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL :",null,"n/a",{"$f":"SUM(I35:I36)","v":10180},{"$f":"SUM(J35:J36)","v":6760},{"$f":"SUM(K35:K36)","v":4806},{"$f":"SUM(L35:L36)","v":3385},{"$f":"SUM(M35:M36)","v":2677}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,4,TRUE)","v":5355.6500000000005},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":3543.05},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":2507.4300000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":1754.3000000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":1379.0600000000002}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$66)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":5355.6500000000005},{"$f":"SUM(J40:J43)","v":3543.05},{"$f":"SUM(K40:K43)","v":2507.4300000000003},{"$f":"SUM(L40:L43)","v":1754.3000000000002},{"$f":"SUM(M40:M43)","v":1379.0600000000002}]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,"n/a",{"$f":"SUM(I44:I45)","v":5430.6500000000005},{"$f":"SUM(J44:J45)","v":3618.05},{"$f":"SUM(K44:K45)","v":2582.4300000000003},{"$f":"SUM(L44:L45)","v":1829.3000000000002},{"$f":"SUM(M44:M45)","v":1454.0600000000002}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":5355.6500000000005},{"$f":"J44","v":3543.05},2507.4300000000003,1754.3000000000002,1379.0600000000002]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[]
[null,null,null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[null," "]

{"sheet":"Privilege","index":2,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[49,5,50,12],[33,0,33,1],[34,0,34,1],[29,0,29,1],[41,2,41,3],[37,0,37,1],[38,0,38,1],[34,2,34,3],[39,0,39,1],[40,0,40,1],[41,0,41,1],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[35,0,35,1],[42,0,42,1],[19,0,19,1],[17,0,18,1],[20,0,21,1],[46,0,47,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[32,0,32,1],[9,2,9,12],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,18,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[21,2,21,3],[46,2,47,3],[11,7,11,12],[37,2,37,3],[38,2,38,3],[11,0,11,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[22,2,22,3],[31,2,31,3],[26,2,26,3],[20,2,20,3],[25,2,25,3],[32,2,32,3],[29,2,29,3],[27,2,27,3],[28,2,28,3],[49,0,49,1],[49,2,49,3],[48,0,48,1],[48,2,48,3],[13,7,13,12],[17,5,17,6],[16,5,16,6],[16,0,16,1],[35,2,35,3],[36,0,36,1],[42,2,42,3],[36,2,36,3],[43,0,43,1],[43,2,43,3],[39,2,39,3],[40,2,40,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa PRIVILEGE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T11:14:05.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null," ",false]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,4,TRUE)","v":8500},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":5844},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":4107},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":2858},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":2177}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$167)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":8500},{"$f":"SUM(J31:J34)","v":5844},{"$f":"SUM(K31:K34)","v":4107},{"$f":"SUM(L31:L34)","v":2858},{"$f":"SUM(M31:M34)","v":2177}]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL :",null,"n/a",{"$f":"SUM(I35:I36)","v":8575},{"$f":"SUM(J35:J36)","v":5919},{"$f":"SUM(K35:K36)","v":4182},{"$f":"SUM(L35:L36)","v":2933},{"$f":"SUM(M35:M36)","v":2252}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,4,TRUE)","v":4505},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":3097.32},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":2176.71},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":1514.74},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":1153.81}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$200)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":4505},{"$f":"SUM(J40:J43)","v":3097.32},{"$f":"SUM(K40:K43)","v":2176.71},{"$f":"SUM(L40:L43)","v":1514.74},{"$f":"SUM(M40:M43)","v":1153.81}]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,"n/a",{"$f":"SUM(I44:I45)","v":4580},{"$f":"SUM(J44:J45)","v":3172.32},{"$f":"SUM(K44:K45)","v":2251.71},{"$f":"SUM(L44:L45)","v":1589.74},{"$f":"SUM(M44:M45)","v":1228.81}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":4505},{"$f":"J44","v":3097.32},2176.71,1514.74,1153.81]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[]
[null,null,null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[null," "]

{"sheet":"Advantage (Mundial)","index":3,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[51,5,52,12],[44,0,44,1],[46,0,46,1],[45,2,45,3],[45,0,45,1],[51,2,52,3],[51,0,52,1],[50,2,50,3],[46,2,46,3],[44,2,44,3],[49,0,49,1],[50,0,50,1],[47,0,47,1],[48,0,48,1],[49,5,49,12],[19,0,19,1],[30,2,30,3],[33,2,33,3],[31,2,31,3],[35,0,41,1],[26,0,26,1],[26,2,26,3],[27,2,27,3],[33,0,33,1],[34,0,34,1],[29,0,29,1],[34,2,34,3],[32,2,32,3],[32,0,32,1],[27,0,27,1],[28,0,28,1],[42,0,42,1],[20,0,21,1],[22,0,23,1],[24,2,24,3],[42,2,42,3],[24,0,24,1],[25,0,25,1],[30,0,31,1],[35,2,39,3],[40,2,41,3],[28,2,28,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,18,3],[49,2,49,3],[13,7,13,12],[17,5,17,6],[16,5,16,6],[48,2,48,3],[25,2,25,3],[23,2,23,3],[21,2,21,3],[22,2,22,3],[19,2,19,3],[9,2,9,12],[11,7,11,12],[11,0,11,3],[12,0,12,1],[54,0,54,1],[54,2,54,3],[53,0,53,1],[53,2,53,3],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[47,2,47,3],[29,2,29,3],[20,2,20,3],[17,0,18,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T11:14:05.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,false,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,4,TRUE)","v":5604},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":4213},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":3196},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":2391},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":1896}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$301)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$302)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$302)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$302)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$302)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$302)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":5604},4213,3196,2391,1896]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL :",null,"n/a",{"$f":"SUM(I36:I37)","v":5679},{"$f":"SUM(J36:J37)","v":4288},{"$f":"SUM(K36:K37)","v":3271},{"$f":"SUM(L36:L37)","v":2466},{"$f":"SUM(M36:M37)","v":1971}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,4,TRUE)","v":2970.1200000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":2232.8900000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":1693.88},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":1267.23},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":1004.88}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$334)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$335)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$335)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$335)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$335)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$335)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":2970.1200000000003},2232.8900000000003,1693.88,1267.23,1004.88]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,"n/a",{"$f":"SUM(I46:I47)","v":3045.1200000000003},{"$f":"SUM(J46:J47)","v":2307.8900000000003},{"$f":"SUM(K46:K47)","v":1768.88},{"$f":"SUM(L46:L47)","v":1342.23},{"$f":"SUM(M46:M47)","v":1079.8800000000001}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2970.1200000000003},{"$f":"J46","v":2232.8900000000003},1693.88,1267.23,1004.88]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[]
[null,null,null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[]
[null," "]

{"sheet":"Advantage (LA)","index":4,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":true,"merged":[[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
["Bupa Advantage Care (cobertura solo en Latinoamérica)",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
["Cobertura Máxima anual",null,"US $ 3,500,000"]
["Cobertura Geografica",null,"Limitada a Latinoamérica excluyendo México",null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENTE"}]
["Condiciones médicas cubiertas",null,"Todas las condiciones médicas"]
["Redes de proveedores",null,"Red de Proveedores \"Bupa Advantage\"",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
["Opciones fuera de la Red",null,"NO, solo en casos de emergencia",null,null,"FECHA DE COTIZACION :"]
["Requiere preautorización",null,"SI, 30% de penalización por omitir prenotificación",null,null,{"$f":"NOW()","v":"2023-08-16T11:14:05.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
["Número máximo de días de hospitalización",null,"Ilimitado",null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
["Habitación y alimentación",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
["Cuidados Intensivos",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null," "]
["Cobertura de Maternidad",null,"$5,000 (Excepto planes 4,5, y 6)",null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Cobertura Provisional de Recién Nacido",null,"$30,000 por los primeros 90 días",null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Cuidado del Recién Nacido saludable",null,"Ya incluída dentro del beneficio de Maternidad",null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
["Cobertura de Complicaciones de Maternidad",null,"Disponible a través de cobertura opcional adicional"]
["Trasplante de Organos",null,"$1,000,000 de por vida, por diagnóstico"]
["Condiciones congénitas y hereditarias",null,"<18 años $300,000 de por vida; >=18 al 100%",null,null,"Tarifas Anuales"]
["Coberturas opcionales (Riders)",null,"Complicaciones de Maternidad por $500,000",null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,4,TRUE)","v":4338},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":3254},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":2470},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":1844},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":1454}]
[null,null,"Trasplante de órganos por $ 300,000 adicionales",null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,8,TRUE)))","v":0}]
["Acompañamiento de menores hospitalizados",null,"$300 por día",null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":0}]
["Ambulancia aérea",null,"$100,000 por año y ticket aéreo de retorno",null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$368)","v":0}]
["Repatriación restos mortales",null,1,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$369)","v":0}]
["Medicamentos por receta",null,"$6,000 por Asegurado, por año póliza",null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":4338},3254,2470,1844,1454]
["Almacenamiento de sangre de cordon umbilical",null,"$500  (Excepto planes 4,5, y 6)",null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL :",null,"n/a",{"$f":"SUM(I36:I37)","v":4413},{"$f":"SUM(J36:J37)","v":3329},{"$f":"SUM(K36:K37)","v":2545},{"$f":"SUM(L36:L37)","v":1919},{"$f":"SUM(M36:M37)","v":1529}]
["Atención médica en el hogar",null,"100% de usual/acostumbrado y razonable"]
["Rehabilitación",null,"100% de usual/acostumbrado y razonable",null,null,"Tarifas Semestrales"]
["Residencia y cuidados paliativos",null,"100% de usual/acostumbrado y razonable",null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,4,TRUE)","v":2299.1400000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":1724.6200000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":1309.1000000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":977.32},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":770.62}]
["Cobertura de actividades peligrosas",null,1,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,8,TRUE)))","v":0}]
["Chequeos generales de rutina",null,"Hasta US$150 por año póliza.Sin deducible",null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":0}]
["Cobertura de VIH, SIDA, CAS",null,"Solo como efecto de transfusión de sangre",null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$401)","v":0}]
["Cobertura de brazos y piernas artificiales",null,"$30,000 por año y hasta $120,000 de por vida",null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$402)","v":0}]
["Cobertura extendida para dependientes en caso de muerte de asegurado principal",null,"2 años sin costo",null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":2299.1400000000003},1724.6200000000001,1309.1000000000001,977.32,770.62]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,"n/a",{"$f":"SUM(I46:I47)","v":2374.1400000000003},{"$f":"SUM(J46:J47)","v":1799.6200000000001},{"$f":"SUM(K46:K47)","v":1384.1000000000001},{"$f":"SUM(L46:L47)","v":1052.3200000000002},{"$f":"SUM(M46:M47)","v":845.62}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2299.1400000000003},{"$f":"J46","v":1724.6200000000001},1309.1000000000001,977.32,770.62]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2013"]

{"sheet":"Secure","index":5,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,5,53,12],[33,2,33,3],[31,2,31,3],[47,0,48,1],[47,2,48,3],[45,2,45,3],[46,0,46,1],[45,0,45,1],[33,0,33,1],[34,0,34,1],[35,0,41,1],[44,0,44,1],[34,2,34,3],[40,2,41,3],[43,2,43,3],[44,2,44,3],[42,2,42,3],[42,0,42,1],[43,0,43,1],[35,2,39,3],[49,5,49,12],[46,2,46,3],[49,0,49,1],[49,2,49,3],[16,0,16,1],[19,0,19,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,0,29,1],[26,0,26,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[20,0,21,1],[20,2,20,3],[17,2,18,3],[32,0,32,1],[32,2,32,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,2,22,3],[21,2,21,3],[25,2,25,3],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[15,0,15,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa SECURE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T11:14:05.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,false,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,4,TRUE)","v":3946},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":3095},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":2359},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":2004},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":1528}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$435)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$435)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$435)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$435)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$435)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$436)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$436)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$436)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$436)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$436)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":3946},3095,2359,2004,1528]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL :",null,"n/a",{"$f":"SUM(I36:I37)","v":4021},{"$f":"SUM(J36:J37)","v":3170},{"$f":"SUM(K36:K37)","v":2434},{"$f":"SUM(L36:L37)","v":2079},{"$f":"SUM(M36:M37)","v":1603}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,4,TRUE)","v":2091.38},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":1640.3500000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":1250.27},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":1062.1200000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":809.84}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$468)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$468)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$468)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$468)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$468)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$469)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$469)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$469)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$469)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$469)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":2091.38},1640.3500000000001,1250.27,1062.1200000000001,809.84]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,"n/a",{"$f":"SUM(I46:I47)","v":2166.38},{"$f":"SUM(J46:J47)","v":1715.3500000000001},{"$f":"SUM(K46:K47)","v":1325.27},{"$f":"SUM(L46:L47)","v":1137.1200000000001},{"$f":"SUM(M46:M47)","v":884.84}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2091.38},{"$f":"J46","v":1640.3500000000001},1250.27,1062.1200000000001,809.84]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2023"]
[null," "]
[null," ",null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Essential","index":6,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,5,53,12],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[19,2,19,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[29,2,29,3],[30,2,30,3],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[35,2,39,3],[33,0,33,1],[34,0,34,1],[35,0,41,1],[40,2,41,3],[33,2,33,3],[23,2,23,3],[24,2,24,3],[49,0,49,1],[49,2,49,3],[42,0,42,1],[34,2,34,3],[47,2,48,3],[47,0,48,1],[45,2,45,3],[46,2,46,3],[43,2,43,3],[45,0,45,1],[46,0,46,1],[43,0,43,1],[44,0,44,1],[44,2,44,3],[42,2,42,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa ESSENTIAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T11:14:05.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,false,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,4,TRUE)","v":2762},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":2163},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":1650},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":1403},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":1063}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$502)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$503)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":2762},2163,1650,1403,1063]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL :",null,"n/a",{"$f":"SUM(I36:I37)","v":2837},{"$f":"SUM(J36:J37)","v":2238},{"$f":"SUM(K36:K37)","v":1725},{"$f":"SUM(L36:L37)","v":1478},{"$f":"SUM(M36:M37)","v":1138}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,4,TRUE)","v":1463.8600000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":1146.3900000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":874.5},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":743.59},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":563.39}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$535)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$536)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":1463.8600000000001},1146.3900000000001,874.5,743.59,563.39]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,"n/a",{"$f":"SUM(I46:I47)","v":1538.8600000000001},{"$f":"SUM(J46:J47)","v":1221.3900000000001},{"$f":"SUM(K46:K47)","v":949.5},{"$f":"SUM(L46:L47)","v":818.59},{"$f":"SUM(M46:M47)","v":638.39}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":1463.8600000000001},{"$f":"J46","v":1146.3900000000001},874.5,743.59,563.39]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[null," "]
[null," ",null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Critical","index":7,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,5,54,12],[35,8,35,9],[36,8,36,9],[25,10,25,11],[26,10,26,11],[27,10,27,11],[32,10,32,11],[31,8,31,9],[32,8,32,9],[33,8,33,9],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[49,5,49,12],[34,8,34,9],[45,0,45,1],[23,5,24,7],[25,5,26,7],[27,5,28,7],[29,5,30,7],[31,5,32,7],[33,5,34,7],[35,5,36,7],[44,2,44,3],[26,0,26,1],[43,2,43,3],[40,0,40,1],[41,0,41,1],[42,0,42,1],[42,2,42,3],[40,2,40,3],[19,0,19,1],[41,2,41,3],[44,0,44,1],[32,0,32,1],[35,0,39,1],[33,0,33,1],[34,0,34,1],[43,0,43,1],[22,0,23,1],[24,0,24,1],[30,2,31,3],[27,0,27,1],[28,0,28,1],[34,2,34,3],[29,0,29,1],[30,0,31,1],[20,0,21,1],[21,2,21,3],[22,2,22,3],[25,0,25,1],[25,2,25,3],[23,2,23,3],[24,2,24,3],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[45,2,45,3],[35,2,39,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[32,2,32,3],[33,2,33,3],[23,10,24,11],[33,10,36,12],[21,5,22,7],[21,8,22,9],[9,2,9,12],[26,2,26,3],[17,2,18,3],[19,2,19,3],[20,2,20,3],[16,2,16,3],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[21,10,22,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[14,0,14,1],[13,0,13,1],[15,0,15,1],[16,0,16,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa CRITICAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T11:14:05.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,null,true,null,null,{"$f":"IF(M16>=M18,M16,M18)","v":18}]
[]
[null,null,null,null,null,"CONDICION CRITICA CUBIERTA",null,null,"MAXIMO POR AÑO POLIZA",null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,"Enfermedades neurológicas y accidentes cerebro-vasculares",null,null,150000,null,"Tipo de trasplante",null,"Máximo Vitalicio"]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,null,null,"por persona"]
[null,null,null,null,null,"Cirugías cardíacas y angioplastías",null,null,150000,null,"Corazón",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Corazón y Pulmón (simultáneamente)",null,300000]
[null,null,null,null,null,"Tratamiento de cáncer",null,null,200000,null,"Pulmón",null,250000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Pancreas",null,250000]
[null,null,null,null,null,"Trauma grave (Politraumatismos)",null,null,150000,null,"Pancreas y Riñón (simultáneamente)",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Riñón",null,200000]
[null,null,null,null,null,"Insuficiencia renal crónica (Diálisis)",null,null,100000,null,"Hígado",null,200000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Médula ósea",null,250000]
[null,null,null,null,null,"Quemaduras graves ",null,null,300000,null,"La cobertura de trasplante de órganos está limitada a la Red de Proveedores para Procedimiento de Trasplante de la Compañía y no se proporcionará cobertura en proveedores fuera de esta Red especializada."]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[null,null,null,null,null,"Desorden infeccioso grave (Septicemia)",null,null,150000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[null,null,null,null,null,"Fuera del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima por plan individual :",null,{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,3,TRUE)),0)","v":2661},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,6,TRUE)),0)","v":2318},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,9,TRUE)),0)","v":1985},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,12,TRUE)),0)","v":1525},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,15,TRUE)),0)","v":1083},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,18,TRUE)),0)","v":609}]
[null,null,null,null,null,"Prima por plan para 2 personas :",null,{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,4,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,7,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,10,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,13,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,16,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,19,TRUE)),0)","v":0}]
[null,null,null,null,null,"Prima por plan familiar :",null,{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,5,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,8,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,11,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,14,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,17,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,20,TRUE)),0)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":2661},{"$f":"SUM(I44:I46)","v":2318},1985,1525,1083,609]
[null," ",null,null,null,"Costo Administrativo Anual :",null,75,75,75,75,75,75]
[null," ",null,null,null,"GRAN TOTAL :",null,{"$f":"SUM(H47:H48)","v":2736},2393,2060,1600,1158,684]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[]
[]
[null,null,null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Resumen tarifas anuales","index":8,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,41,7],[37,0,37,7],[28,0,28,1],[21,0,21,1],[26,0,26,1],[29,0,29,1],[30,0,30,1],[36,0,36,1],[27,0,27,1],[25,0,25,1],[25,2,25,7],[32,0,32,1],[35,2,35,7],[13,2,13,7],[15,2,15,7],[19,0,19,1],[18,0,18,1],[11,2,11,7]]}
[]
[null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null," "," "," "," "]
[]
[]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - BUPA CARE "]
[]
[null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENTE"}]
[]
[null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2023-08-16T11:14:05.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null," "," "," "]
["Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
["PRODUCTOS",null,"Tarifas Anuales"]
["Bupa Exclusive Care",null,"n/a",{"$f":"+Exclusive!I37","v":10180},{"$f":"+Exclusive!J37","v":6760},{"$f":"+Exclusive!K37","v":4806},{"$f":"+Exclusive!L37","v":3385},{"$f":"+Exclusive!M37","v":2677}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":8575},{"$f":"+Privilege!J37","v":5919},{"$f":"+Privilege!K37","v":4182},{"$f":"+Privilege!L37","v":2933},{"$f":"+Privilege!M37","v":2252}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":5679},{"$f":"+'Advantage (Mundial)'!J38","v":4288},{"$f":"+'Advantage (Mundial)'!K38","v":3271},{"$f":"+'Advantage (Mundial)'!L38","v":2466},{"$f":"+'Advantage (Mundial)'!M38","v":1971}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":4021},{"$f":"+Secure!J38","v":3170},{"$f":"+Secure!K38","v":2434},{"$f":"+Secure!L38","v":2079},{"$f":"+Secure!M38","v":1603}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":2837},{"$f":"+Essential!J38","v":2238},{"$f":"+Essential!K38","v":1725},{"$f":"+Essential!L38","v":1478},{"$f":"+Essential!M38","v":1138}]
[]
["Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Dentro del pais de residencia",null,2000,3500,5000,10000,20000,50000]
["Fuera del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[null,null,"Tarifas Anuales"]
["Bupa Critical Care",null,{"$f":"+Critical!H49","v":2736},{"$f":"+Critical!I49","v":2393},{"$f":"+Critical!J49","v":2060},{"$f":"+Critical!K49","v":1600},{"$f":"+Critical!L49","v":1158},{"$f":"+Critical!M49","v":684}]
["Tarifas en US $ -  Válidas desde 01 enero 2023"]
[]
["Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Comparacion de Beneficios","index":9,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[32,3,33,3],[32,4,33,4],[32,5,33,5],[24,0,26,0],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4],[27,0,28,0],[29,0,30,0],[31,0,33,0],[31,1,33,1],[31,2,33,2],[0,0,4,6],[56,0,57,0],[9,0,11,0],[13,0,14,0],[15,0,16,0],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[31,6,33,6],[39,4,41,4],[39,5,41,5],[38,6,41,6],[17,0,19,0],[37,0,41,0],[25,5,26,5]]}
["2023 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":551,"n_cols":20,"rows_kept":551,"cut":false,"hidden":true,"merged":[[540,14,540,16],[540,17,540,19],[547,14,547,16],[547,17,547,19],[545,0,545,19],[540,2,540,4],[547,2,547,4],[547,5,547,7],[547,8,547,10],[546,0,546,1],[546,2,546,6],[540,5,540,7],[540,8,540,10],[547,11,547,13],[540,11,540,13],[539,0,539,1],[471,0,471,7],[472,0,472,1],[472,2,472,6],[504,0,504,7],[505,0,505,1],[505,2,505,6],[538,0,538,19],[537,0,537,19],[539,2,539,6],[304,2,304,6],[336,0,336,7],[437,0,437,7],[438,0,438,1],[438,2,438,6],[304,0,304,1],[370,0,370,7],[371,0,371,1],[371,2,371,6],[337,0,337,7],[338,0,338,1],[338,2,338,6],[470,0,470,7],[403,0,403,7],[404,0,404,7],[405,0,405,1],[405,2,405,6],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[303,0,303,7],[269,0,269,7],[270,0,270,7],[271,0,271,1],[271,2,271,6],[170,2,170,6],[202,0,202,7],[236,0,236,7],[237,0,237,1],[237,2,237,6],[204,0,204,1],[204,2,204,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6]]}
[]
["EXCLUSIVE",null,null,null,null,null,null,null,null,"FACTOR SEMESTRAL :",null,0.53]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6"]
[18,"18-24",null,10105,6685,4731,3310,2602,null,0,0,0,0,0]
[25,"25-29",null,10599,7384,5237,3660,2881,null,0,0,0,0,0]
[30,"30-34",null,11023,7916,5863,4382,3457,null,0,0,0,0,0]
[35,"35-39",null,12349,8865,6569,4911,3871,null,0,0,0,0,0]
[40,"40-44",null,14310,9687,7291,5393,4253,null,0,0,0,0,0]
[45,"45-49",null,15995,10836,8140,6030,4753,null,0,0,0,0,0]
[50,"50-54",null,20470,14210,10624,8515,6717,null,0,0,0,0,0]
[55,"55-59",null,21774,15121,11303,9058,7148,null,0,0,0,0,0]
[60,"60",null,23717,16496,12999,10907,8878,null,0,0,0,0,0]
[61,"61",null,25484,17724,13955,11722,9535,null,0,0,0,0,0]
[62,"62",null,27902,19406,15291,12827,10438,null,0,0,0,0,0]
[63,"63",null,29662,20633,16251,13647,11101,null,0,0,0,0,0]
[64,"64",null,32085,22328,17583,14760,12008,null,0,0,0,0,0]
[65,"65",null,41934,29118,22226,19679,16928,null,0,0,0,0,0]
[66,"66",null,48714,33829,25827,22869,19668,null,0,0,0,0,0]
[67,"67",null,53211,36945,28209,24976,21478,null,0,0,0,0,0]
[68,"68",null,58914,40906,31230,27658,23789,null,0,0,0,0,0]
[69,"69",null,64825,45014,34359,30425,26170,null,0,0,0,0,0]
[70,"70",null,79776,54801,40449,35452,30776,null,0,0,0,0,0]
[71,"71",null,82907,56956,42036,36847,31985,null,0,0,0,0,0]
[72,"72",null,85258,58558,43221,37888,32898,null,0,0,0,0,0]
[73,"73",null,88388,60711,44810,39285,34103,null,0,0,0,0,0]
[74,"74",null,89951,61783,45606,39975,34705,null,0,0,0,0,0]
[75,"75+",null,93867,64477,47588,41718,36218,null,0,0,0,0,0]
[1,"1 Child",null,3510,2582,2108,1743,1361,null,0,0,0,0,0]
[2,"2 Children",null,5576,4112,3348,2769,2155,null,0,0,0,0,0]
[3,"3+ Children",null,8177,6018,4909,4060,3163,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,0,0,225,225,225]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6",null,3,7,11,15,19]
[18,"18-24",null,{"$f":"$L$2*D6","v":5355.6500000000005},{"$f":"$L$2*E6","v":3543.05},2507.4300000000003,1754.3000000000002,1379.0600000000002,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D7","v":5617.47},3913.52,2775.61,1939.8000000000002,1526.93,null,0,0,0,0,0]
[30,"30-34",null,5842.1900000000005,4195.4800000000005,3107.3900000000003,2322.46,1832.21,null,0,0,0,0,0]
[35,"35-39",null,6544.97,4698.45,3481.57,2602.83,2051.63,null,0,0,0,0,0]
[40,"40-44",null,7584.3,5134.1100000000006,3864.23,2858.29,2254.09,null,0,0,0,0,0]
[45,"45-49",null,8477.35,5743.08,4314.2,3195.9,2519.09,null,0,0,0,0,0]
[50,"50-54",null,10849.1,7531.3,5630.72,4512.95,3560.01,null,0,0,0,0,0]
[55,"55-59",null,11540.220000000001,8014.13,5990.59,4800.7400000000007,3788.44,null,0,0,0,0,0]
[60,"60",null,12570.01,8742.880000000001,6889.47,5780.71,4705.34,null,0,0,0,0,0]
[61,"61",null,13506.52,9393.7200000000012,7396.1500000000005,6212.6600000000008,5053.55,null,0,0,0,0,0]
[62,"62",null,14788.060000000001,10285.18,8104.2300000000005,6798.31,5532.14,null,0,0,0,0,0]
[63,"63",null,15720.86,10935.49,8613.0300000000007,7232.9100000000008,5883.5300000000007,null,0,0,0,0,0]
[64,"64",null,17005.05,11833.84,9318.99,7822.8,6364.2400000000007,null,0,0,0,0,0]
[65,"65",null,22225.02,15432.54,11779.78,10429.870000000001,8971.84,null,0,0,0,0,0]
[66,"66",null,25818.420000000002,17929.370000000003,13688.310000000001,12120.57,10424.040000000001,null,0,0,0,0,0]
[67,"67",null,28201.83,19580.850000000002,14950.77,13237.28,11383.34,null,0,0,0,0,0]
[68,"68",null,31224.420000000002,21680.18,16551.900000000001,14658.740000000002,12608.17,null,0,0,0,0,0]
[69,"69",null,34357.25,23857.420000000002,18210.27,16125.25,13870.1,null,0,0,0,0,0]
[70,"70",null,42281.279999999999,29044.530000000002,21437.97,18789.560000000001,16311.28,null,0,0,0,0,0]
[71,"71",null,43940.71,30186.68,22279.08,19528.91,16952.05,null,0,0,0,0,0]
[72,"72",null,45186.740000000005,31035.74,22907.13,20080.64,17435.940000000002,null,0,0,0,0,0]
[73,"73",null,46845.64,32176.83,23749.300000000003,20821.05,18074.59,null,0,0,0,0,0]
[74,"74",null,47674.03,32744.99,24171.18,21186.75,18393.650000000001,null,0,0,0,0,0]
[75,"75+",null,49749.51,34172.810000000005,25221.640000000003,22110.54,19195.54,null,0,0,0,0,0]
[1,"1 Child",null,1860.3000000000002,1368.46,1117.24,923.79000000000008,721.33,null,0,0,0,0,0]
[2,"2 Children",null,2955.28,2179.36,1774.44,1467.5700000000002,1142.1500000000001,null,0,0,0,0,0]
[3,"3+ Children",null,4333.8100000000004,3189.54,2601.77,2151.8000000000002,1676.39,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D33*$L$2","v":0},0,119.25,119.25,119.25]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["DIAMOND (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["PRIVILEGE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6",null,2,6,10,14,18]
[18,"18-24",null,8500,5844,4107,2858,2177,null,0,0,0,0,0]
[25,"25-29",null,8918,6461,4551,3167,2418,null,0,0,0,0,0]
[30,"30-34",null,9320,6925,5098,3837,2926,null,0,0,0,0,0]
[35,"35-39",null,10433,7750,5711,4297,3277,null,0,0,0,0,0]
[40,"40-44",null,12077,8489,6350,4737,3615,null,0,0,0,0,0]
[45,"45-49",null,13486,9489,7105,5291,4044,null,0,0,0,0,0]
[50,"50-54",null,17630,12511,9324,7551,5771,null,0,0,0,0,0]
[55,"55-59",null,18759,13311,9922,8036,6144,null,0,0,0,0,0]
[60,"60",null,20429,14459,11286,9561,7675,null,0,0,0,0,0]
[61,"61",null,21945,15529,12123,10268,8242,null,0,0,0,0,0]
[62,"62",null,24023,17007,13278,11242,9030,null,0,0,0,0,0]
[63,"63",null,25543,18077,14114,11952,9599,null,0,0,0,0,0]
[64,"64",null,27627,19558,15269,12930,10386,null,0,0,0,0,0]
[65,"65",null,36110,25510,19308,17238,14641,null,0,0,0,0,0]
[66,"66",null,41953,29636,22431,20031,17017,null,0,0,0,0,0]
[67,"67",null,45825,32373,24497,21878,18579,null,0,0,0,0,0]
[68,"68",null,50743,35843,27133,24234,20573,null,0,0,0,0,0]
[69,"69",null,55824,39433,29848,26655,22637,null,0,0,0,0,0]
[70,"70",null,68699,48012,35131,31063,26627,null,0,0,0,0,0]
[71,"71",null,71395,49890,36515,32277,27671,null,0,0,0,0,0]
[72,"72",null,73409,51309,37547,33195,28454,null,0,0,0,0,0]
[73,"73",null,76120,53191,38925,34413,29502,null,0,0,0,0,0]
[74,"74",null,77463,54134,39610,35021,30022,null,0,0,0,0,0]
[75,"75+",null,80832,56484,41337,36547,31330,null,0,0,0,0,0]
[1,"1 Child",null,2948,2154,1669,1383,1024,null,0,0,0,0,0]
[2,"2 Children",null,4691,3431,2654,2201,1627,null,0,0,0,0,0]
[3,"3+ Children",null,6872,5027,3891,3223,2387,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,0,0,225,225,225]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6",null,3,7,11,15,19]
[18,"18-24",null,{"$f":"$L$2*D140","v":4505},{"$f":"$L$2*E140","v":3097.32},2176.71,1514.74,1153.81,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D141","v":4726.54},3424.3300000000004,2412.0300000000002,1678.51,1281.54,null,0,0,0,0,0]
[30,"30-34",null,4939.6000000000004,3670.25,2701.94,2033.6100000000001,1550.78,null,0,0,0,0,0]
[35,"35-39",null,5529.4900000000007,4107.5,3026.83,2277.4100000000003,1736.8100000000002,null,0,0,0,0,0]
[40,"40-44",null,6400.81,4499.17,3365.5,2510.61,1915.95,null,0,0,0,0,0]
[45,"45-49",null,7147.58,5029.17,3765.65,2804.23,2143.3200000000002,null,0,0,0,0,0]
[50,"50-54",null,9343.9,6630.83,4941.72,4002.03,3058.63,null,0,0,0,0,0]
[55,"55-59",null,9942.27,7054.83,5258.66,4259.08,3256.32,null,0,0,0,0,0]
[60,"60",null,10827.37,7663.27,5981.58,5067.33,4067.75,null,0,0,0,0,0]
[61,"61",null,11630.85,8230.3700000000008,6425.1900000000005,5442.04,4368.26,null,0,0,0,0,0]
[62,"62",null,12732.19,9013.7100000000009,7037.34,5958.26,4785.9000000000005,null,0,0,0,0,0]
[63,"63",null,13537.79,9580.8100000000013,7480.42,6334.56,5087.47,null,0,0,0,0,0]
[64,"64",null,14642.310000000001,10365.74,8092.5700000000006,6852.9000000000005,5504.58,null,0,0,0,0,0]
[65,"65",null,19138.3,13520.300000000001,10233.24,9136.1400000000012,7759.7300000000005,null,0,0,0,0,0]
[66,"66",null,22235.09,15707.08,11888.43,10616.43,9019.01,null,0,0,0,0,0]
[67,"67",null,24287.25,17157.690000000002,12983.41,11595.34,9846.8700000000008,null,0,0,0,0,0]
[68,"68",null,26893.79,18996.79,14380.490000000002,12844.02,10903.69,null,0,0,0,0,0]
[69,"69",null,29586.720000000001,20899.490000000002,15819.44,14127.150000000001,11997.61,null,0,0,0,0,0]
[70,"70",null,36410.47,25446.36,18619.43,16463.39,14112.310000000001,null,0,0,0,0,0]
[71,"71",null,37839.35,26441.7,19352.95,17106.810000000001,14665.630000000001,null,0,0,0,0,0]
[72,"72",null,38906.770000000004,27193.77,19899.91,17593.350000000002,15080.62,null,0,0,0,0,0]
[73,"73",null,40343.599999999999,28191.230000000003,20630.25,18238.89,15636.060000000001,null,0,0,0,0,0]
[74,"74",null,41055.39,28691.02,20993.3,18561.13,15911.660000000002,null,0,0,0,0,0]
[75,"75+",null,42840.959999999999,29936.52,21908.61,19369.91,16604.900000000001,null,0,0,0,0,0]
[1,"1 Child",null,1562.44,1141.6200000000001,884.57,732.99,542.72,null,0,0,0,0,0]
[2,"2 Children",null,2486.23,1818.43,1406.6200000000001,1166.53,862.31000000000006,null,0,0,0,0,0]
[3,"3+ Children",null,3642.1600000000003,2664.31,2062.23,1708.19,1265.1100000000001,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D167*$L$2","v":0},0,119.25,119.25,119.25]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["COMPLETE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["ADVANTAGE (WORLDWIDE)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6",null,6,10,14,18,22]
[18,"18-24",null,5604,4213,3196,2391,1896,null,0,0,0,0,0]
[25,"25-29",null,6232,4702,3558,2666,2100,null,0,0,0,0,0]
[30,"30-34",null,7219,5524,4230,3159,2441,null,0,0,0,0,0]
[35,"35-39",null,7999,6151,4705,3603,2708,null,0,0,0,0,0]
[40,"40-44",null,9026,6970,5332,4025,3057,null,0,0,0,0,0]
[45,"45-49",null,10485,8026,6007,4576,3555,null,0,0,0,0,0]
[50,"50-54",null,11487,9023,6999,5142,3904,null,0,0,0,0,0]
[55,"55-59",null,13575,10414,7747,5947,4610,null,0,0,0,0,0]
[60,"60",null,14998,11527,8521,6565,5099,null,0,0,0,0,0]
[61,"61",null,16874,12976,9584,7392,5746,null,0,0,0,0,0]
[62,"62",null,18759,14419,10650,8216,6380,null,0,0,0,0,0]
[63,"63",null,20635,15862,11721,9039,7031,null,0,0,0,0,0]
[64,"64",null,22514,17310,12793,9864,7672,null,0,0,0,0,0]
[65,"65",null,24336,18833,13941,10743,8731,null,0,0,0,0,0]
[66,"66",null,25778,19951,14763,11379,9249,null,0,0,0,0,0]
[67,"67",null,28650,22169,16412,12649,10277,null,0,0,0,0,0]
[68,"68",null,31511,24388,18050,13914,11302,null,0,0,0,0,0]
[69,"69",null,32948,25498,18878,14550,11823,null,0,0,0,0,0]
[70,"70",null,33377,25904,19164,14824,11979,null,0,0,0,0,0]
[71,"71",null,37555,29146,21563,16681,13477,null,0,0,0,0,0]
[72,"72",null,41729,32396,23965,18538,14975,null,0,0,0,0,0]
[73,"73",null,45906,35628,26362,20398,16481,null,0,0,0,0,0]
[74,"74",null,50083,38876,28765,22254,17978,null,0,0,0,0,0]
[75,"75+",null,54783,43360,32987,24357,20632,null,0,0,0,0,0]
[1,"1 Child",null,2497,1778,1392,1205,868,null,0,0,0,0,0]
[2,"2 Children",null,4061,2805,2206,1901,1276,null,0,0,0,0,0]
[3,"3+ Children",null,5945,4088,3203,2760,1939,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6",null,7,11,15,19,23]
[18,"18-24",null,{"$f":"$L$2*D274","v":2970.1200000000003},{"$f":"$L$2*E274","v":2232.8900000000003},1693.88,1267.23,1004.88,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D275","v":3302.96},2492.06,1885.74,1412.98,1113,null,0,0,0,0,0]
[30,"30-34",null,3826.07,2927.7200000000003,2241.9,1674.27,1293.73,null,0,0,0,0,0]
[35,"35-39",null,4239.47,3260.03,2493.65,1909.5900000000001,1435.24,null,0,0,0,0,0]
[40,"40-44",null,4783.7800000000007,3694.1000000000004,2825.96,2133.25,1620.21,null,0,0,0,0,0]
[45,"45-49",null,5557.05,4253.7800000000007,3183.71,2425.2800000000002,1884.15,null,0,0,0,0,0]
[50,"50-54",null,6088.1100000000006,4782.1900000000005,3709.4700000000003,2725.26,2069.12,null,0,0,0,0,0]
[55,"55-59",null,7194.75,5519.42,4105.91,3151.9100000000003,2443.3000000000002,null,0,0,0,0,0]
[60,"60",null,7948.9400000000005,6109.31,4516.13,3479.4500000000003,2702.4700000000003,null,0,0,0,0,0]
[61,"61",null,8943.2200000000012,6877.2800000000007,5079.5200000000004,3917.76,3045.38,null,0,0,0,0,0]
[62,"62",null,9942.27,7642.0700000000006,5644.5,4354.4800000000005,3381.4,null,0,0,0,0,0]
[63,"63",null,10936.550000000001,8406.86,6212.13,4790.67,3726.4300000000003,null,0,0,0,0,0]
[64,"64",null,11932.42,9174.3000000000011,6780.29,5227.92,4066.1600000000003,null,0,0,0,0,0]
[65,"65",null,12898.08,9981.49,7388.7300000000005,5693.79,4627.43,null,0,0,0,0,0]
[66,"66",null,13662.34,10574.03,7824.39,6030.87,4901.97,null,0,0,0,0,0]
[67,"67",null,15184.5,11749.57,8698.36,6703.97,5446.81,null,0,0,0,0,0]
[68,"68",null,16700.830000000002,12925.640000000001,9566.5,7374.42,5990.06,null,0,0,0,0,0]
[69,"69",null,17462.440000000002,13513.94,10005.34,7711.5,6266.1900000000005,null,0,0,0,0,0]
[70,"70",null,17689.810000000001,13729.12,10156.92,7856.72,6348.87,null,0,0,0,0,0]
[71,"71",null,19904.150000000001,15447.380000000001,11428.390000000001,8840.93,7142.81,null,0,0,0,0,0]
[72,"72",null,22116.370000000003,17169.88,12701.45,9825.1400000000012,7936.75,null,0,0,0,0,0]
[73,"73",null,24330.18,18882.84,13971.86,10810.94,8734.93,null,0,0,0,0,0]
[74,"74",null,26543.99,20604.280000000002,15245.45,11794.62,9528.34,null,0,0,0,0,0]
[75,"75+",null,29034.99,22980.800000000003,17483.11,12909.210000000001,10934.960000000001,null,0,0,0,0,0]
[1,"1 Child",null,1323.41,942.34,737.76,638.65,460.04,null,0,0,0,0,0]
[2,"2 Children",null,2152.33,1486.65,1169.18,1007.5300000000001,676.28000000000009,null,0,0,0,0,0]
[3,"3+ Children",null,3150.8500000000004,2166.6400000000003,1697.5900000000001,1462.8000000000002,1027.67,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D301*$L$2","v":119.25},119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,159,159,159,159,159]
[]
["ADVANTAGE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,null,null,null,null,null,null,6,10,14,18,22]
[18,"18-24",null,4338,3254,2470,1844,1454,null,0,0,0,0,0]
[25,"25-29",null,4827,3633,2751,2058,1621,null,0,0,0,0,0]
[30,"30-34",null,5593,4279,3273,2443,1882,null,0,0,0,0,0]
[35,"35-39",null,6203,4763,3640,2788,2090,null,0,0,0,0,0]
[40,"40-44",null,7003,5400,4135,3112,2360,null,0,0,0,0,0]
[45,"45-49",null,8131,6219,4658,3542,2743,null,0,0,0,0,0]
[50,"50-54",null,8914,7000,5437,3990,3020,null,0,0,0,0,0]
[55,"55-59",null,10536,8075,6011,4614,3565,null,0,0,0,0,0]
[60,"60",null,11644,8946,6618,5095,3955,null,0,0,0,0,0]
[61,"61",null,13104,10072,7442,5734,4450,null,0,0,0,0,0]
[62,"62",null,14569,11198,8275,6375,4955,null,0,0,0,0,0]
[63,"63",null,16027,12322,9107,7025,5455,null,0,0,0,0,0]
[64,"64",null,17493,13440,9942,7663,5947,null,0,0,0,0,0]
[65,"65",null,18914,14634,10838,8348,6783,null,0,0,0,0,0]
[66,"66",null,20027,15495,11476,8839,7179,null,0,0,0,0,0]
[67,"67",null,22256,17227,12761,9829,7985,null,0,0,0,0,0]
[68,"68",null,24488,18954,14038,10816,8786,null,0,0,0,0,0]
[69,"69",null,25605,19817,14676,11309,9184,null,0,0,0,0,0]
[70,"70",null,25943,20128,14903,11525,9305,null,0,0,0,0,0]
[71,"71",null,29194,22654,16773,12968,10479,null,0,0,0,0,0]
[72,"72",null,32430,25181,18635,14418,11641,null,0,0,0,0,0]
[73,"73",null,35690,27699,20511,15861,12810,null,0,0,0,0,0]
[74,"74",null,38939,30219,22382,17312,13980,null,0,0,0,0,0]
[75,"75+",null,42589,33706,25673,18953,16046,null,0,0,0,0,0]
[1,"1 Child",null,1936,1382,1084,941,679,null,0,0,0,0,0]
[2,"2 Children",null,3159,2181,1717,1481,995,null,0,0,0,0,0]
[3,"3+ Children",null,4626,3177,2501,2143,1510,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,null,null,null,null,null,null,7,11,15,19,23]
[18,"18-24",null,{"$f":"$L$2*D341","v":2299.1400000000003},{"$f":"$L$2*E341","v":1724.6200000000001},1309.1000000000001,977.32,770.62,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D342","v":2558.31},1925.49,1458.03,1090.74,859.13,null,0,0,0,0,0]
[30,"30-34",null,2964.29,2267.87,1734.69,1294.79,997.46,null,0,0,0,0,0]
[35,"35-39",null,3287.59,2524.3900000000003,1929.2,1477.64,1107.7,null,0,0,0,0,0]
[40,"40-44",null,3711.59,2862,2191.5500000000002,1649.3600000000001,1250.8,null,0,0,0,0,0]
[45,"45-49",null,4309.43,3296.07,2468.7400000000002,1877.26,1453.79,null,0,0,0,0,0]
[50,"50-54",null,4724.42,3710,2881.61,2114.7000000000003,1600.6000000000001,null,0,0,0,0,0]
[55,"55-59",null,5584.08,4279.75,3185.8300000000004,2445.42,1889.45,null,0,0,0,0,0]
[60,"60",null,6171.3200000000006,4741.38,3507.54,2700.35,2096.15,null,0,0,0,0,0]
[61,"61",null,6945.1200000000008,5338.16,3944.26,3039.02,2358.5,null,0,0,0,0,0]
[62,"62",null,7721.5700000000006,5934.9400000000005,4385.75,3378.75,2626.15,null,0,0,0,0,0]
[63,"63",null,8494.3100000000013,6530.6600000000008,4826.71,3723.25,2891.15,null,0,0,0,0,0]
[64,"64",null,9271.2900000000009,7123.2000000000007,5269.26,4061.3900000000003,3151.9100000000003,null,0,0,0,0,0]
[65,"65",null,10024.42,7756.02,5744.14,4424.4400000000005,3594.9900000000002,null,0,0,0,0,0]
[66,"66",null,10614.310000000001,8212.35,6082.2800000000007,4684.67,3804.8700000000003,null,0,0,0,0,0]
[67,"67",null,11795.68,9130.3100000000013,6763.33,5209.37,4232.05,null,0,0,0,0,0]
[68,"68",null,12978.640000000001,10045.620000000001,7440.14,5732.4800000000005,4656.58,null,0,0,0,0,0]
[69,"69",null,13570.650000000001,10503.01,7778.2800000000007,5993.77,4867.5200000000004,null,0,0,0,0,0]
[70,"70",null,13749.79,10667.84,7898.59,6108.25,4931.6500000000005,null,0,0,0,0,0]
[71,"71",null,15472.820000000002,12006.62,8889.69,6873.04,5553.87,null,0,0,0,0,0]
[72,"72",null,17187.900000000001,13345.93,9876.5500000000011,7641.54,6169.7300000000005,null,0,0,0,0,0]
[73,"73",null,18915.7,14680.470000000001,10870.83,8406.33,6789.3,null,0,0,0,0,0]
[74,"74",null,20637.670000000002,16016.070000000002,11862.460000000001,9175.36,7409.4000000000005,null,0,0,0,0,0]
[75,"75+",null,22572.170000000002,17864.18,13606.69,10045.09,8504.380000000001,null,0,0,0,0,0]
[1,"1 Child",null,1026.0800000000002,732.46,574.52,498.73,359.87,null,0,0,0,0,0]
[2,"2 Children",null,1674.27,1155.93,910.01,784.93000000000006,527.35,null,0,0,0,0,0]
[3,"3+ Children",null,2451.7800000000002,1683.8100000000002,1325.53,1135.79,800.30000000000007,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["SECURE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6",null,6,10,14,18,22]
[18,"18-24",null,3946,3095,2359,2004,1528,null,0,0,0,0,0]
[25,"25-29",null,4344,3480,2625,2230,1691,null,0,0,0,0,0]
[30,"30-34",null,4977,4093,3048,2591,1962,null,0,0,0,0,0]
[35,"35-39",null,5487,4579,3389,2878,2174,null,0,0,0,0,0]
[40,"40-44",null,6156,5233,3832,3260,2448,null,0,0,0,0,0]
[45,"45-49",null,7087,6123,4463,3787,2852,null,0,0,0,0,0]
[50,"50-54",null,7728,6746,4892,4157,3112,null,0,0,0,0,0]
[55,"55-59",null,9088,8051,5800,4917,3683,null,0,0,0,0,0]
[60,"60",null,9507,8601,6137,5205,3891,null,0,0,0,0,0]
[61,"61",null,10701,9685,6912,5865,4388,null,0,0,0,0,0]
[62,"62",null,11896,10767,7682,6524,4879,null,0,0,0,0,0]
[63,"63",null,13089,11837,8454,7175,5370,null,0,0,0,0,0]
[64,"64",null,14282,12928,9224,7833,5865,null,0,0,0,0,0]
[65,"65",null,14300,13052,9283,7876,5890,null,0,0,0,0,0]
[66,"66",null,14319,13168,9336,7915,5911,null,0,0,0,0,0]
[67,"67",null,15908,14638,10382,8796,6568,null,0,0,0,0,0]
[68,"68",null,17505,16104,11421,9684,7233,null,0,0,0,0,0]
[69,"69",null,18302,16836,11944,10121,7563,null,0,0,0,0,0]
[70,"70",null,18334,17121,12068,10220,7598,null,0,0,0,0,0]
[71,"71",null,20637,19266,13584,11510,8555,null,0,0,0,0,0]
[72,"72",null,22931,21419,15095,12798,9512,null,0,0,0,0,0]
[73,"73",null,25233,23560,16609,14072,10468,null,0,0,0,0,0]
[74,"74",null,27529,25700,18123,15359,11423,null,0,0,0,0,0]
[75,"75+",null,30003,28195,19820,16798,12479,null,0,0,0,0,0]
[1,"1 Child",null,1903,1123,951,804,596,null,0,0,0,0,0]
[2,"2 Children",null,3207,1669,1493,1273,941,null,0,0,0,0,0]
[3,"3+ Children",null,4711,2399,2172,1843,1360,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6",null,7,11,15,19,23]
[18,"18-24",null,{"$f":"$L$2*D408","v":2091.38},{"$f":"$L$2*E408","v":1640.3500000000001},1250.27,1062.1200000000001,809.84,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D409","v":2302.3200000000002},1844.4,1391.25,1181.9000000000001,896.23,null,0,0,0,0,0]
[30,"30-34",null,2637.81,2169.29,1615.44,1373.23,1039.8600000000001,null,0,0,0,0,0]
[35,"35-39",null,2908.11,2426.8700000000003,1796.17,1525.3400000000001,1152.22,null,0,0,0,0,0]
[40,"40-44",null,3262.6800000000003,2773.4900000000002,2030.96,1727.8000000000002,1297.44,null,0,0,0,0,0]
[45,"45-49",null,3756.11,3245.19,2365.3900000000003,2007.1100000000001,1511.5600000000002,null,0,0,0,0,0]
[50,"50-54",null,4095.84,3575.38,2592.7600000000002,2203.21,1649.3600000000001,null,0,0,0,0,0]
[55,"55-59",null,4816.6400000000003,4267.0300000000007,3074,2606.0100000000002,1951.99,null,0,0,0,0,0]
[60,"60",null,5038.71,4558.5300000000007,3252.61,2758.65,2062.23,null,0,0,0,0,0]
[61,"61",null,5671.5300000000007,5133.05,3663.36,3108.4500000000003,2325.6400000000003,null,0,0,0,0,0]
[62,"62",null,6304.88,5706.51,4071.46,3457.7200000000003,2585.8700000000003,null,0,0,0,0,0]
[63,"63",null,6937.17,6273.6100000000006,4480.62,3802.75,2846.1000000000004,null,0,0,0,0,0]
[64,"64",null,7569.46,6851.84,4888.72,4151.49,3108.4500000000003,null,0,0,0,0,0]
[65,"65",null,7579,6917.56,4919.9900000000007,4174.2800000000007,3121.7000000000003,null,0,0,0,0,0]
[66,"66",null,7589.0700000000006,6979.04,4948.08,4194.95,3132.8300000000004,null,0,0,0,0,0]
[67,"67",null,8431.24,7758.14,5502.46,4661.88,3481.04,null,0,0,0,0,0]
[68,"68",null,9277.65,8535.1200000000008,6053.13,5132.5200000000004,3833.4900000000002,null,0,0,0,0,0]
[69,"69",null,9700.0600000000013,8923.08,6330.3200000000006,5364.13,4008.3900000000003,null,0,0,0,0,0]
[70,"70",null,9717.02,9074.130000000001,6396.04,5416.6,4026.94,null,0,0,0,0,0]
[71,"71",null,10937.61,10210.980000000001,7199.52,6100.3,4534.1500000000005,null,0,0,0,0,0]
[72,"72",null,12153.43,11352.07,8000.35,6782.9400000000005,5041.3600000000006,null,0,0,0,0,0]
[73,"73",null,13373.49,12486.800000000001,8802.77,7458.1600000000008,5548.04,null,0,0,0,0,0]
[74,"74",null,14590.37,13621,9605.19,8140.27,6054.1900000000005,null,0,0,0,0,0]
[75,"75+",null,15901.59,14943.35,10504.6,8902.94,6613.87,null,0,0,0,0,0]
[1,"1 Child",null,1008.59,595.19000000000005,504.03000000000003,426.12,315.88,null,0,0,0,0,0]
[2,"2 Children",null,1699.71,884.57,791.29000000000008,674.69,498.73,null,0,0,0,0,0]
[3,"3+ Children",null,2496.83,1271.47,1151.1600000000001,976.79000000000008,720.80000000000007,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D435*$L$2","v":119.25},119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,{"$f":"+D436*$L$2","v":159},159,159,159,159]
[]
["ESSENTIAL"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"ET2","ET3","ET4","ET5","ET6",null,6,10,14,18,22]
[18,"18-24",null,2762,2163,1650,1403,1063,null,0,0,0,0,0]
[25,"25-29",null,3039,2441,1834,1569,1184,null,0,0,0,0,0]
[30,"30-34",null,3484,2872,2135,1821,1369,null,0,0,0,0,0]
[35,"35-39",null,3843,3209,2376,2024,1522,null,0,0,0,0,0]
[40,"40-44",null,4315,3668,2683,2289,1716,null,0,0,0,0,0]
[45,"45-49",null,4971,4297,3124,2663,1999,null,0,0,0,0,0]
[50,"50-54",null,5419,4735,3429,2921,2189,null,0,0,0,0,0]
[55,"55-59",null,6375,5654,4062,3468,2587,null,0,0,0,0,0]
[60,"60",null,6675,6042,4308,3671,2739,null,0,0,0,0,0]
[61,"61",null,7515,6801,4852,4134,3092,null,0,0,0,0,0]
[62,"62",null,8358,7562,5392,4601,3443,null,0,0,0,0,0]
[63,"63",null,9193,8325,5943,5063,3789,null,0,0,0,0,0]
[64,"64",null,10040,9082,6483,5524,4134,null,0,0,0,0,0]
[65,"65",null,10045,9171,6517,5559,4151,null,0,0,0,0,0]
[66,"66",null,10058,9253,6562,5586,4159,null,0,0,0,0,0]
[67,"67",null,11175,10291,7293,6213,4630,null,0,0,0,0,0]
[68,"68",null,12304,11320,8026,6839,5099,null,0,0,0,0,0]
[69,"69",null,12859,11836,8394,7143,5339,null,0,0,0,0,0]
[70,"70",null,12888,12039,8484,7216,5364,null,0,0,0,0,0]
[71,"71",null,14507,13549,9548,8127,6035,null,0,0,0,0,0]
[72,"72",null,16118,15063,10614,9033,6717,null,0,0,0,0,0]
[73,"73",null,17744,16570,11679,9944,7387,null,0,0,0,0,0]
[74,"74",null,19359,18082,12743,10851,8069,null,0,0,0,0,0]
[75,"75+",null,21101,19830,13942,11871,8814,null,0,0,0,0,0]
[1,"1 Child",null,1342,794,670,574,425,null,0,0,0,0,0]
[2,"2 Children",null,2261,1178,1050,896,666,null,0,0,0,0,0]
[3,"3+ Children",null,3316,1690,1526,1301,961,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"ET2","ET3","ET4","ET5","ET6",null,7,11,15,19,23]
[18,"18-24",null,{"$f":"$L$2*D475","v":1463.8600000000001},{"$f":"$L$2*E475","v":1146.3900000000001},874.5,743.59,563.39,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D476","v":1610.67},1293.73,972.0200000000001,831.57,627.52,null,0,0,0,0,0]
[30,"30-34",null,1846.52,1522.16,1131.55,965.13,725.57,null,0,0,0,0,0]
[35,"35-39",null,2036.7900000000002,1700.77,1259.28,1072.72,806.66000000000008,null,0,0,0,0,0]
[40,"40-44",null,2286.9500000000003,1944.0400000000002,1421.99,1213.17,909.48,null,0,0,0,0,0]
[45,"45-49",null,2634.63,2277.4100000000003,1655.72,1411.39,1059.47,null,0,0,0,0,0]
[50,"50-54",null,2872.07,2509.5500000000002,1817.3700000000001,1548.13,1160.17,null,0,0,0,0,0]
[55,"55-59",null,3378.75,2996.6200000000003,2152.86,1838.0400000000002,1371.1100000000001,null,0,0,0,0,0]
[60,"60",null,3537.75,3202.26,2283.2400000000002,1945.63,1451.67,null,0,0,0,0,0]
[61,"61",null,3982.9500000000003,3604.53,2571.56,2191.02,1638.76,null,0,0,0,0,0]
[62,"62",null,4429.74,4007.86,2857.76,2438.5300000000002,1824.7900000000002,null,0,0,0,0,0]
[63,"63",null,4872.29,4412.25,3149.79,2683.3900000000003,2008.17,null,0,0,0,0,0]
[64,"64",null,5321.2,4813.46,3435.9900000000002,2927.7200000000003,2191.02,null,0,0,0,0,0]
[65,"65",null,5323.85,4860.63,3454.01,2946.27,2200.0300000000002,null,0,0,0,0,0]
[66,"66",null,5330.7400000000007,4904.09,3477.86,2960.58,2204.27,null,0,0,0,0,0]
[67,"67",null,5922.75,5454.2300000000005,3865.2900000000004,3292.8900000000003,2453.9,null,0,0,0,0,0]
[68,"68",null,6521.12,5999.6,4253.7800000000007,3624.67,2702.4700000000003,null,0,0,0,0,0]
[69,"69",null,6815.27,6273.08,4448.8200000000006,3785.79,2829.67,null,0,0,0,0,0]
[70,"70",null,6830.64,6380.67,4496.5200000000004,3824.48,2842.92,null,0,0,0,0,0]
[71,"71",null,7688.71,7180.97,5060.4400000000005,4307.3100000000004,3198.55,null,0,0,0,0,0]
[72,"72",null,8542.5400000000009,7983.39,5625.42,4787.4900000000007,3560.01,null,0,0,0,0,0]
[73,"73",null,9404.32,8782.1,6189.87,5270.3200000000006,3915.11,null,0,0,0,0,0]
[74,"74",null,10260.27,9583.4600000000009,6753.79,5751.0300000000007,4276.5700000000006,null,0,0,0,0,0]
[75,"75+",null,11183.53,10509.9,7389.26,6291.63,4671.42,null,0,0,0,0,0]
[1,"1 Child",null,711.26,420.82,355.1,304.22000000000003,225.25,null,0,0,0,0,0]
[2,"2 Children",null,1198.3300000000002,624.34,556.5,474.88,352.98,null,0,0,0,0,0]
[3,"3+ Children",null,1757.48,895.7,808.78000000000009,689.53000000000009,509.33000000000004,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D502*$L$2","v":119.25},119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,159,159,159,159,159]
[]
["CRITICAL"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","CR1",null,null,"CR2",null,null,"CR3",null,null,"CR4",null,null,"CR5",null,null,"CR6"]
[null,null,"INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR"]
[18,"-  49",2661,4838,7021,2318,4121,5929,1985,3592,5188,1525,2725,3924,1083,1897,2713,609,1011,1419]
[50,"o más",3420,5603,7783,2978,4777,6583,2550,4149,5744,1945,3142,4343,1361,2187,2993,752,1157,1566]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","CR1",null,null,"CR2",null,null,"CR3",null,null,"CR4",null,null,"CR5",null,null,"CR6"]
[null,null,"INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR"]
[18,"-  25",{"$f":"+C543*$L$2","v":1410.3300000000002},2564.1400000000003,3721.13,1228.54,2184.13,3142.3700000000003,1052.05,1903.76,2749.6400000000003,808.25,1444.25,2079.7200000000003,573.99,1005.4100000000001,1437.89,322.77000000000004,535.83000000000004,752.07]
[75,"o más",{"$f":"+C544*$L$2","v":1812.6000000000001},2969.59,4124.99,1578.3400000000001,2531.81,3488.9900000000002,1351.5,2198.9700000000003,3044.32,1030.8500000000001,1665.26,2301.79,721.33,1159.1100000000001,1586.2900000000002,398.56,613.21,829.98]