{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["INGRESO DE DATOS","Exclusive","Privilege","Advantage (Mundial)","Advantage (LA)","Secure","Essential","Critical","Resumen tarifas anuales","Comparacion de Beneficios","Tablas","Sheet1"],"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],[9,1,9,9],[23,0,23,9],[18,0,18,9]]}
[]
[null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null," "," "," "," "]
[]
["COTIZACION DE SEGURO MEDICO INTERNACIONAL"]
[]
["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]
[]
[]
["INGRESE EL NOMBRE DE LA AGENCIA ASESORA:"]
[]
[null,null,"Nombre de la Agencia:","AGENCIA"]
[]
[]
["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":[[51,0,51,1],[51,2,51,3],[49,5,50,12],[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],[40,2,40,3],[35,2,35,3],[28,2,28,3],[27,0,27,1],[34,0,34,1],[45,0,45,1],[40,0,40,1],[41,0,41,1],[45,2,45,3],[43,0,43,1],[35,0,35,1],[36,0,38,1],[36,2,38,3],[19,0,19,1],[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],[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],[31,2,31,3],[27,2,27,3],[20,2,20,3],[22,2,22,3],[46,0,46,1],[44,0,44,1],[42,0,42,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],[20,0,21,1],[28,0,28,1],[29,0,29,1],[30,0,31,1],[50,0,50,1],[50,2,50,3],[47,0,47,1],[47,2,47,3],[48,0,49,1],[48,2,49,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":"AGENCIA"}]
[]
[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:18.050"},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,true,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":12506},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":8273},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":5718},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":3924},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":3089}]
[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":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$33)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$33)","v":225}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":12506},{"$f":"SUM(J31:J34)","v":8273},{"$f":"SUM(K31:K34)","v":5943},{"$f":"SUM(L31:L34)","v":4149},{"$f":"SUM(M31:M34)","v":3314}]
[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":12581},{"$f":"SUM(J35:J36)","v":8348},{"$f":"SUM(K35:K36)","v":6018},{"$f":"SUM(L35:L36)","v":4224},{"$f":"SUM(M35:M36)","v":3389}]
[]
[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":6628.18},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":4384.6900000000005},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":3030.54},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":2079.7200000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":1637.17}]
[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":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$66)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$66)","v":119.25}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":6628.18},{"$f":"SUM(J40:J43)","v":4384.6900000000005},{"$f":"SUM(K40:K43)","v":3149.79},{"$f":"SUM(L40:L43)","v":2198.9700000000003},{"$f":"SUM(M40:M43)","v":1756.42}]
[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":6703.18},{"$f":"SUM(J44:J45)","v":4459.6900000000005},{"$f":"SUM(K44:K45)","v":3224.79},{"$f":"SUM(L44:L45)","v":2273.9700000000003},{"$f":"SUM(M44:M45)","v":1831.42}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":6628.18},{"$f":"J44","v":4384.6900000000005},3149.79,2198.9700000000003,1756.42]
[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,0,49,1],[49,2,49,3],[49,5,50,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[16,0,16,1],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[35,0,35,1],[35,2,35,3],[47,5,47,12],[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],[22,2,22,3],[46,2,47,3],[43,2,43,3],[39,2,39,3],[26,0,26,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,2,29,3],[27,2,27,3],[28,2,28,3],[31,2,31,3],[26,2,26,3],[32,0,32,1],[32,2,32,3],[41,2,41,3],[37,0,37,1],[9,2,9,12],[11,7,11,12],[19,0,19,1],[17,0,18,1],[20,0,21,1],[20,2,20,3],[11,0,11,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[25,0,25,1],[48,0,48,1],[48,2,48,3],[33,0,33,1],[34,0,34,1],[42,2,42,3],[43,0,43,1],[46,0,47,1],[42,0,42,1],[40,2,40,3],[37,2,37,3],[38,2,38,3],[29,0,29,1],[38,0,38,1],[34,2,34,3],[39,0,39,1],[40,0,40,1],[41,0,41,1],[36,0,36,1],[36,2,36,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":"AGENCIA"}]
[]
[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:18.050"},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,true,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":10521},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":7235},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":4964},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":3396},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":2590}]
[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":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$167)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$167)","v":225}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":10521},{"$f":"SUM(J31:J34)","v":7235},{"$f":"SUM(K31:K34)","v":5189},{"$f":"SUM(L31:L34)","v":3621},{"$f":"SUM(M31:M34)","v":2815}]
[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":10596},{"$f":"SUM(J35:J36)","v":7310},{"$f":"SUM(K35:K36)","v":5264},{"$f":"SUM(L35:L36)","v":3696},{"$f":"SUM(M35:M36)","v":2890}]
[]
[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":5576.13},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":3834.55},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":2630.92},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":1799.88},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":1372.7}]
[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":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$200)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$200)","v":119.25}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":5576.13},{"$f":"SUM(J40:J43)","v":3834.55},{"$f":"SUM(K40:K43)","v":2750.17},{"$f":"SUM(L40:L43)","v":1919.13},{"$f":"SUM(M40:M43)","v":1491.95}]
[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":5651.13},{"$f":"SUM(J44:J45)","v":3909.55},{"$f":"SUM(K44:K45)","v":2825.17},{"$f":"SUM(L44:L45)","v":1994.13},{"$f":"SUM(M44:M45)","v":1566.95}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":5576.13},{"$f":"J44","v":3834.55},2750.17,1919.13,1491.95]
[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":[[54,0,54,1],[54,2,54,3],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[35,2,39,3],[40,2,41,3],[20,0,21,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[19,2,19,3],[21,2,21,3],[22,2,22,3],[20,2,20,3],[51,5,52,12],[50,2,50,3],[46,2,46,3],[44,2,44,3],[51,2,52,3],[9,2,9,12],[49,5,49,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],[49,2,49,3],[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],[25,2,25,3],[23,2,23,3],[19,0,19,1],[24,2,24,3],[51,0,52,1],[28,2,28,3],[29,2,29,3],[30,2,30,3],[33,2,33,3],[31,2,31,3],[49,0,49,1],[50,0,50,1],[47,0,47,1],[48,0,48,1],[42,0,42,1],[42,2,42,3],[29,0,29,1],[34,2,34,3],[26,0,26,1],[26,2,26,3],[27,2,27,3],[33,0,33,1],[34,0,34,1],[32,2,32,3],[32,0,32,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[53,0,53,1],[53,2,53,3],[35,0,41,1],[48,2,48,3],[47,2,47,3],[44,0,44,1],[46,0,46,1],[45,2,45,3],[45,0,45,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":"AGENCIA"}]
[]
[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:18.050"},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,true,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":6999},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":5266},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":3872},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":2890},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":2289}]
[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":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$302)","v":300}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":7299},5566,4172,3190,2589]
[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":7374},{"$f":"SUM(J36:J37)","v":5641},{"$f":"SUM(K36:K37)","v":4247},{"$f":"SUM(L36:L37)","v":3265},{"$f":"SUM(M36:M37)","v":2664}]
[]
[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":3709.4700000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":2790.98},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":2052.1600000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":1531.7},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":1213.17}]
[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":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$335)","v":159}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":3868.4700000000003},2949.98,2211.1600000000003,1690.7,1372.17]
[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":3943.4700000000003},{"$f":"SUM(J46:J47)","v":3024.98},{"$f":"SUM(K46:K47)","v":2286.1600000000003},{"$f":"SUM(L46:L47)","v":1765.7},{"$f":"SUM(M46:M47)","v":1447.17}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":3868.4700000000003},{"$f":"J46","v":2949.98},2211.1600000000003,1690.7,1372.17]
[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":[[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],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[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],[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],[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],[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]]}
[]
[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":"AGENCIA"}]
["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:18.050"},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":5419},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":4070},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":2986},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":2227},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":1756}]
[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":5419},4070,2986,2227,1756]
["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":5494},{"$f":"SUM(J36:J37)","v":4145},{"$f":"SUM(K36:K37)","v":3061},{"$f":"SUM(L36:L37)","v":2302},{"$f":"SUM(M36:M37)","v":1831}]
["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":2872.07},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":2157.1},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":1582.5800000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":1180.3100000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":930.68000000000006}]
["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":2872.07},2157.1,1582.5800000000002,1180.3100000000002,930.68000000000006]
[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":2947.07},{"$f":"SUM(J46:J47)","v":2232.1},{"$f":"SUM(K46:K47)","v":1657.5800000000002},{"$f":"SUM(L46:L47)","v":1255.3100000000002},{"$f":"SUM(M46:M47)","v":1005.6800000000001}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2872.07},{"$f":"J46","v":2157.1},1582.5800000000002,1180.3100000000002,930.68000000000006]
[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],[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],[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],[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],[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],[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]]}
[]
[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":"AGENCIA"}]
[]
[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:18.050"},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,true,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":5309},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":4166},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":3074},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":2591},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":1964}]
[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":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$436)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$436)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$436)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$436)","v":300}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":5609},4466,3374,2891,2264]
[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":5684},{"$f":"SUM(J36:J37)","v":4541},{"$f":"SUM(K36:K37)","v":3449},{"$f":"SUM(L36:L37)","v":2966},{"$f":"SUM(M36:M37)","v":2339}]
[]
[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":2813.77},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":2207.98},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":1629.22},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":1373.23},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":1040.92}]
[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":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$469)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$469)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$469)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$469)","v":159}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":2972.77},2366.98,1788.22,1532.23,1199.92]
[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":3047.77},{"$f":"SUM(J46:J47)","v":2441.98},{"$f":"SUM(K46:K47)","v":1863.22},{"$f":"SUM(L46:L47)","v":1607.23},{"$f":"SUM(M46:M47)","v":1274.92}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2972.77},{"$f":"J46","v":2366.98},1788.22,1532.23,1199.92]
[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":"Essential","index":6,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,5,53,12],[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],[49,5,49,12],[42,2,42,3],[49,0,49,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],[29,2,29,3],[30,2,30,3],[33,2,33,3],[27,2,27,3],[24,2,24,3],[49,2,49,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],[16,2,16,3],[20,2,20,3],[17,2,18,3],[23,2,23,3],[19,2,19,3],[22,0,23,1],[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],[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 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":"AGENCIA"}]
[]
[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:18.050"},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,true,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":4501},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":3528},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":2603},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":2191},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":1659}]
[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":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$503)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$503)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$503)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$503)","v":300}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":4801},3828,2903,2491,1959]
[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":4876},{"$f":"SUM(J36:J37)","v":3903},{"$f":"SUM(K36:K37)","v":2978},{"$f":"SUM(L36:L37)","v":2566},{"$f":"SUM(M36:M37)","v":2034}]
[]
[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":2385.5300000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":1869.8400000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":1379.5900000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":1161.23},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":879.2700000000001}]
[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":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$536)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$536)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$536)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$536)","v":159}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":2544.5300000000002},2028.8400000000001,1538.5900000000001,1320.23,1038.27]
[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":2619.5300000000002},{"$f":"SUM(J46:J47)","v":2103.84},{"$f":"SUM(K46:K47)","v":1613.5900000000001},{"$f":"SUM(L46:L47)","v":1395.23},{"$f":"SUM(M46:M47)","v":1113.27}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2544.5300000000002},{"$f":"J46","v":2028.8400000000001},1538.5900000000001,1320.23,1038.27]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2021"]
[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],[17,0,18,1],[12,0,12,1],[14,0,14,1],[13,0,13,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],[35,2,39,3],[34,8,34,9],[27,8,27,9],[28,8,28,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],[45,2,45,3],[23,10,24,11],[33,10,36,12],[28,2,28,3],[29,2,29,3],[32,2,32,3],[33,2,33,3],[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],[21,5,22,7],[21,8,22,9],[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,2,27,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],[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],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[29,8,29,9],[30,8,30,9]]}
[]
[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":"AGENCIA"}]
[]
[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:18.050"},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":3170},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,6,TRUE)),0)","v":2521},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,9,TRUE)),0)","v":2160},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,12,TRUE)),0)","v":1658},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,15,TRUE)),0)","v":1249},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,18,TRUE)),0)","v":808}]
[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":3170},{"$f":"SUM(I44:I46)","v":2521},2160,1658,1249,808]
[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":3245},2596,2235,1733,1324,883]
[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],[13,2,13,7],[15,2,15,7],[19,0,19,1],[18,0,18,1],[11,2,11,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]]}
[]
[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":"AGENCIA"}]
[]
[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:18.050"},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":12581},{"$f":"+Exclusive!J37","v":8348},{"$f":"+Exclusive!K37","v":6018},{"$f":"+Exclusive!L37","v":4224},{"$f":"+Exclusive!M37","v":3389}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":10596},{"$f":"+Privilege!J37","v":7310},{"$f":"+Privilege!K37","v":5264},{"$f":"+Privilege!L37","v":3696},{"$f":"+Privilege!M37","v":2890}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":7374},{"$f":"+'Advantage (Mundial)'!J38","v":5641},{"$f":"+'Advantage (Mundial)'!K38","v":4247},{"$f":"+'Advantage (Mundial)'!L38","v":3265},{"$f":"+'Advantage (Mundial)'!M38","v":2664}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":5684},{"$f":"+Secure!J38","v":4541},{"$f":"+Secure!K38","v":3449},{"$f":"+Secure!L38","v":2966},{"$f":"+Secure!M38","v":2339}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":4876},{"$f":"+Essential!J38","v":3903},{"$f":"+Essential!K38","v":2978},{"$f":"+Essential!L38","v":2566},{"$f":"+Essential!M38","v":2034}]
[]
["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":3245},{"$f":"+Critical!I49","v":2596},{"$f":"+Critical!J49","v":2235},{"$f":"+Critical!K49","v":1733},{"$f":"+Critical!L49","v":1324},{"$f":"+Critical!M49","v":883}]
["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":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[68,0,70,0],[1,1,3,6],[4,1,4,6],[29,5,30,5],[29,6,30,6],[50,6,52,6],[58,4,60,4],[58,5,60,5],[57,6,60,6],[56,0,60,0],[44,1,45,1],[44,2,45,2],[44,3,45,3],[65,0,66,0],[44,4,45,4],[44,5,45,5],[51,3,52,3],[51,4,52,4],[51,5,52,5],[46,0,47,0],[48,0,49,0],[50,0,52,0],[50,1,52,1],[50,2,52,2]]}
[]
[null,"2023 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":565,"n_cols":20,"rows_kept":565,"cut":false,"hidden":true,"merged":[[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],[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],[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],[470,0,470,7],[403,0,403,7],[404,0,404,7],[405,0,405,1],[405,2,405,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],[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],[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]]}
[]
["EXCLUSIVE",null,null,null,null,null,null,null,null,"FACTOR SEMESTRAL :",null,0.53]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6",null,2,6,10,14,18]
[18,"18-24",null,12506,8273,5718,3924,3089,null,0,0,0,0,0]
[25,"25-29",null,13117,9133,6334,4344,3421,null,0,0,0,0,0]
[30,"30-34",null,13638,9803,7091,5198,4101,null,0,0,0,0,0]
[35,"35-39",null,15278,10972,7946,5830,4595,null,0,0,0,0,0]
[40,"40-44",null,17708,12002,8814,6407,5048,null,0,0,0,0,0]
[45,"45-49",null,19799,13416,9851,7160,5645,null,0,0,0,0,0]
[50,"50-54",null,25329,17595,12854,10112,7973,null,0,0,0,0,0]
[55,"55-59",null,26947,18720,13672,10755,8485,null,0,0,0,0,0]
[60,"60",null,29355,20425,15728,12954,10538,null,0,0,0,0,0]
[61,"61",null,31534,21941,16891,13926,11323,null,0,0,0,0,0]
[62,"62",null,34527,24034,18501,15235,12402,null,0,0,0,0,0]
[63,"63",null,36715,25552,19656,16204,13182,null,0,0,0,0,0]
[64,"64",null,39706,27647,21268,17532,14259,null,0,0,0,0,0]
[65,"65",null,51905,36057,26888,23374,20101,null,0,0,0,0,0]
[66,"66",null,60293,41892,31251,27165,23360,null,0,0,0,0,0]
[67,"67",null,65867,45753,34133,29666,25514,null,0,0,0,0,0]
[68,"68",null,72921,50665,37791,32853,28255,null,0,0,0,0,0]
[69,"69",null,80233,55739,41574,36142,31088,null,0,0,0,0,0]
[70,"70",null,98744,67865,48945,42112,36560,null,0,0,0,0,0]
[71,"71",null,102620,70529,50865,43768,38000,null,0,0,0,0,0]
[72,"72",null,105527,72520,52297,45009,39081,null,0,0,0,0,0]
[73,"73",null,109403,75185,54222,46667,40516,null,0,0,0,0,0]
[74,"74",null,111336,76514,55180,47489,41237,null,0,0,0,0,0]
[75,"75+",null,116189,79840,57583,49564,43027,null,0,0,0,0,0]
[1,"1 Child",null,4343,3197,2548,2073,1621,null,0,0,0,0,0]
[2,"2 Children",null,6901,5085,4055,3289,2560,null,0,0,0,0,0]
[3,"3+ Children",null,10119,7458,5937,4827,3759,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":6628.18},{"$f":"$L$2*E6","v":4384.6900000000005},3030.54,2079.7200000000003,1637.17,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D7","v":6952.01},4840.4900000000007,3357.02,2302.3200000000002,1813.13,null,0,0,0,0,0]
[30,"30-34",null,7228.14,5195.59,3758.23,2754.94,2173.5300000000002,null,0,0,0,0,0]
[35,"35-39",null,8097.34,5815.16,4211.38,3089.9,2435.35,null,0,0,0,0,0]
[40,"40-44",null,9385.24,6361.06,4671.42,3395.71,2675.44,null,0,0,0,0,0]
[45,"45-49",null,10493.470000000001,7110.4800000000005,5221.0300000000007,3794.8,2991.8500000000004,null,0,0,0,0,0]
[50,"50-54",null,13424.37,9325.35,6812.62,5359.3600000000006,4225.6900000000005,null,0,0,0,0,0]
[55,"55-59",null,14281.91,9921.6,7246.1600000000008,5700.1500000000005,4497.05,null,0,0,0,0,0]
[60,"60",null,15558.150000000001,10825.25,8335.84,6865.62,5585.14,null,0,0,0,0,0]
[61,"61",null,16713.02,11628.730000000001,8952.23,7380.7800000000007,6001.1900000000005,null,0,0,0,0,0]
[62,"62",null,18299.310000000001,12738.02,9805.5300000000007,8074.55,6573.06,null,0,0,0,0,0]
[63,"63",null,19458.95,13542.560000000001,10417.68,8588.1200000000008,6986.46,null,0,0,0,0,0]
[64,"64",null,21044.18,14652.91,11272.04,9291.9600000000009,7557.27,null,0,0,0,0,0]
[65,"65",null,27509.65,19110.210000000003,14250.640000000001,12388.220000000001,10653.53,null,0,0,0,0,0]
[66,"66",null,31955.29,22202.760000000002,16563.030000000002,14397.45,12380.800000000001,null,0,0,0,0,0]
[67,"67",null,34909.51,24249.09,18090.490000000002,15722.980000000001,13522.42,null,0,0,0,0,0]
[68,"68",null,38648.130000000005,26852.45,20029.23,17412.09,14975.150000000001,null,0,0,0,0,0]
[69,"69",null,42523.490000000005,29541.670000000002,22034.22,19155.260000000002,16476.64,null,0,0,0,0,0]
[70,"70",null,52334.32,35968.450000000004,25940.850000000002,22319.360000000001,19376.8,null,0,0,0,0,0]
[71,"71",null,54388.600000000006,37380.370000000003,26958.45,23197.040000000001,20140,null,0,0,0,0,0]
[72,"72",null,55929.310000000005,38435.599999999999,27717.41,23854.77,20712.93,null,0,0,0,0,0]
[73,"73",null,57983.590000000004,39848.050000000003,28737.66,24733.510000000002,21473.48,null,0,0,0,0,0]
[74,"74",null,59008.08,40552.420000000006,29245.4,25169.170000000002,21855.61,null,0,0,0,0,0]
[75,"75+",null,61580.170000000006,42315.200000000004,30518.99,26268.920000000002,22804.31,null,0,0,0,0,0]
[1,"1 Child",null,2301.79,1694.41,1350.44,1098.69,859.13,null,0,0,0,0,0]
[2,"2 Children",null,3657.53,2695.05,2149.15,1743.17,1356.8000000000002,null,0,0,0,0,0]
[3,"3+ Children",null,5363.0700000000006,3952.7400000000002,3146.61,2558.31,1992.2700000000002,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,10521,7235,4964,3396,2590,null,0,0,0,0,0]
[25,"25-29",null,11039,8008,5502,3760,2863,null,0,0,0,0,0]
[30,"30-34",null,11533,8571,6170,4549,3473,null,0,0,0,0,0]
[35,"35-39",null,12912,9595,6909,5101,3890,null,0,0,0,0,0]
[40,"40-44",null,14944,10511,7689,5624,4293,null,0,0,0,0,0]
[45,"45-49",null,16695,11746,8594,6285,4805,null,0,0,0,0,0]
[50,"50-54",null,21826,15494,11276,8970,6852,null,0,0,0,0,0]
[55,"55-59",null,23219,16485,12006,9542,7298,null,0,0,0,0,0]
[60,"60",null,25286,17906,13657,11349,9119,null,0,0,0,0,0]
[61,"61",null,27165,19224,14672,12202,9790,null,0,0,0,0,0]
[62,"62",null,29735,21058,16068,13360,10721,null,0,0,0,0,0]
[63,"63",null,31619,22389,17080,14200,11400,null,0,0,0,0,0]
[64,"64",null,34200,24224,18479,15360,12337,null,0,0,0,0,0]
[65,"65",null,44706,31593,23364,20488,17393,null,0,0,0,0,0]
[66,"66",null,51936,36710,27147,23807,20213,null,0,0,0,0,0]
[67,"67",null,56725,40099,29647,25993,22076,null,0,0,0,0,0]
[68,"68",null,62813,44392,32841,28798,24443,null,0,0,0,0,0]
[69,"69",null,69105,48834,36122,31674,26896,null,0,0,0,0,0]
[70,"70",null,85044,59470,42518,36905,31637,null,0,0,0,0,0]
[71,"71",null,88388,61802,44188,38356,32884,null,0,0,0,0,0]
[72,"72",null,90891,63554,45439,39443,33806,null,0,0,0,0,0]
[73,"73",null,94231,65889,47114,40888,35058,null,0,0,0,0,0]
[74,"74",null,95896,67049,47942,41618,35677,null,0,0,0,0,0]
[75,"75+",null,100079,69969,50030,43430,37224,null,0,0,0,0,0]
[1,"1 Child",null,3651,2672,2020,1643,1213,null,0,0,0,0,0]
[2,"2 Children",null,5810,4250,3213,2612,1932,null,0,0,0,0,0]
[3,"3+ Children",null,8502,6230,4704,3825,2835,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":5576.13},{"$f":"$L$2*E140","v":3834.55},2630.92,1799.88,1372.7,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D141","v":5850.67},4244.24,2916.06,1992.8000000000002,1517.39,null,0,0,0,0,0]
[30,"30-34",null,6112.4900000000007,4542.63,3270.1000000000004,2410.9700000000003,1840.69,null,0,0,0,0,0]
[35,"35-39",null,6843.3600000000006,5085.3500000000004,3661.77,2703.53,2061.7000000000003,null,0,0,0,0,0]
[40,"40-44",null,7920.3200000000006,5570.83,4075.17,2980.7200000000003,2275.29,null,0,0,0,0,0]
[45,"45-49",null,8848.35,6225.38,4554.8200000000006,3331.05,2546.65,null,0,0,0,0,0]
[50,"50-54",null,11567.78,8211.82,5976.2800000000007,4754.1000000000004,3631.5600000000004,null,0,0,0,0,0]
[55,"55-59",null,12306.070000000002,8737.0500000000011,6363.18,5057.26,3867.94,null,0,0,0,0,0]
[60,"60",null,13401.58,9490.18,7238.21,6014.97,4833.0700000000006,null,0,0,0,0,0]
[61,"61",null,14397.45,10188.720000000001,7776.1600000000008,6467.06,5188.7,null,0,0,0,0,0]
[62,"62",null,15759.550000000001,11160.74,8516.0400000000009,7080.8,5682.13,null,0,0,0,0,0]
[63,"63",null,16758.07,11866.17,9052.4,7526,6042,null,0,0,0,0,0]
[64,"64",null,18126,12838.720000000001,9793.8700000000008,8140.8,6538.6100000000006,null,0,0,0,0,0]
[65,"65",null,23694.18,16744.29,12382.92,10858.640000000001,9218.2900000000009,null,0,0,0,0,0]
[66,"66",null,27526.080000000002,19456.3,14387.91,12617.710000000001,10712.890000000001,null,0,0,0,0,0]
[67,"67",null,30064.25,21252.47,15712.910000000002,13776.29,11700.28,null,0,0,0,0,0]
[68,"68",null,33290.89,23527.760000000002,17405.73,15262.94,12954.79,null,0,0,0,0,0]
[69,"69",null,36625.65,25882.02,19144.66,16787.22,14254.880000000001,null,0,0,0,0,0]
[70,"70",null,45073.32,31519.100000000002,22534.54,19559.650000000001,16767.61,null,0,0,0,0,0]
[71,"71",null,46845.64,32755.06,23419.64,20328.68,17428.52,null,0,0,0,0,0]
[72,"72",null,48172.23,33683.620000000003,24082.670000000002,20904.79,17917.18,null,0,0,0,0,0]
[73,"73",null,49942.43,34921.17,24970.420000000002,21670.639999999999,18580.740000000002,null,0,0,0,0,0]
[74,"74",null,50824.880000000005,35535.97,25409.260000000002,22057.54,18908.810000000001,null,0,0,0,0,0]
[75,"75+",null,53041.87,37083.57,26515.9,23017.9,19728.72,null,0,0,0,0,0]
[1,"1 Child",null,1935.0300000000002,1416.16,1070.6000000000001,870.79000000000008,642.89,null,0,0,0,0,0]
[2,"2 Children",null,3079.3,2252.5,1702.89,1384.3600000000001,1023.96,null,0,0,0,0,0]
[3,"3+ Children",null,4506.0600000000004,3301.9,2493.1200000000003,2027.25,1502.5500000000002,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,6999,5266,3872,2890,2289,null,0,0,0,0,0]
[25,"25-29",null,7784,5871,4303,3219,2541,null,0,0,0,0,0]
[30,"30-34",null,9007,6902,5112,3817,2941,null,0,0,0,0,0]
[35,"35-39",null,9990,7680,5693,4353,3272,null,0,0,0,0,0]
[40,"40-44",null,11266,8704,6460,4864,3700,null,0,0,0,0,0]
[45,"45-49",null,13091,10023,7279,5535,4299,null,0,0,0,0,0]
[50,"50-54",null,14349,11266,8477,6213,4719,null,0,0,0,0,0]
[55,"55-59",null,16955,13005,9384,7194,5573,null,0,0,0,0,0]
[60,"60",null,18733,14402,10315,7941,6169,null,0,0,0,0,0]
[61,"61",null,21076,16208,11606,8941,6947,null,0,0,0,0,0]
[62,"62",null,23428,18019,12904,9937,7724,null,0,0,0,0,0]
[63,"63",null,25778,19823,14198,10940,8499,null,0,0,0,0,0]
[64,"64",null,28119,21630,15496,11937,9277,null,0,0,0,0,0]
[65,"65",null,30406,23537,16888,13002,10563,null,0,0,0,0,0]
[66,"66",null,32202,24927,17890,13770,11186,null,0,0,0,0,0]
[67,"67",null,35784,27705,19886,15304,12432,null,0,0,0,0,0]
[68,"68",null,39364,30478,21867,16834,13678,null,0,0,0,0,0]
[69,"69",null,41154,31865,22866,17605,14300,null,0,0,0,0,0]
[70,"70",null,41690,32373,23221,17935,14490,null,0,0,0,0,0]
[71,"71",null,46914,36426,26127,20183,16307,null,0,0,0,0,0]
[72,"72",null,52127,40480,29036,22427,18124,null,0,0,0,0,0]
[73,"73",null,57346,44527,31938,24681,19937,null,0,0,0,0,0]
[74,"74",null,62569,48588,34850,26928,21753,null,0,0,0,0,0]
[75,"75+",null,68435,54187,39968,29477,24963,null,0,0,0,0,0]
[1,"1 Child",null,3118,2224,1689,1453,1051,null,0,0,0,0,0]
[2,"2 Children",null,5070,3500,2669,2302,1541,null,0,0,0,0,0]
[3,"3+ Children",null,7422,5110,3890,3333,2344,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":3709.4700000000003},{"$f":"$L$2*E274","v":2790.98},2052.1600000000003,1531.7,1213.17,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D275","v":4125.5200000000004},3111.63,2280.59,1706.0700000000002,1346.73,null,0,0,0,0,0]
[30,"30-34",null,4773.71,3658.0600000000004,2709.36,2023.01,1558.73,null,0,0,0,0,0]
[35,"35-39",null,5294.7,4070.4,3017.29,2307.09,1734.16,null,0,0,0,0,0]
[40,"40-44",null,5970.9800000000005,4613.12,3423.8,2577.92,1961,null,0,0,0,0,0]
[45,"45-49",null,6938.2300000000005,5312.1900000000005,3857.8700000000003,2933.55,2278.4700000000003,null,0,0,0,0,0]
[50,"50-54",null,7604.97,5970.9800000000005,4492.8100000000004,3292.8900000000003,2501.0700000000002,null,0,0,0,0,0]
[55,"55-59",null,8986.15,6892.6500000000005,4973.5200000000004,3812.82,2953.69,null,0,0,0,0,0]
[60,"60",null,9928.49,7633.06,5466.9500000000007,4208.7300000000005,3269.57,null,0,0,0,0,0]
[61,"61",null,11170.28,8590.24,6151.18,4738.7300000000005,3681.9100000000003,null,0,0,0,0,0]
[62,"62",null,12416.84,9550.07,6839.12,5266.6100000000006,4093.7200000000003,null,0,0,0,0,0]
[63,"63",null,13662.34,10506.19,7524.9400000000005,5798.2000000000007,4504.47,null,0,0,0,0,0]
[64,"64",null,14903.070000000002,11463.900000000001,8212.880000000001,6326.6100000000006,4916.8100000000004,null,0,0,0,0,0]
[65,"65",null,16115.18,12474.61,8950.6400000000012,6891.06,5598.39,null,0,0,0,0,0]
[66,"66",null,17067.060000000001,13211.310000000001,9481.7000000000007,7298.1,5928.58,null,0,0,0,0,0]
[67,"67",null,18965.52,14683.650000000001,10539.58,8111.1200000000008,6588.96,null,0,0,0,0,0]
[68,"68",null,20862.920000000002,16153.34,11589.51,8922.02,7249.34,null,0,0,0,0,0]
[69,"69",null,21811.620000000003,16888.45,12118.980000000001,9330.65,7579,null,0,0,0,0,0]
[70,"70",null,22095.7,17157.690000000002,12307.130000000001,9505.5500000000011,7679.7000000000007,null,0,0,0,0,0]
[71,"71",null,24864.420000000002,19305.780000000002,13847.310000000001,10696.99,8642.7100000000009,null,0,0,0,0,0]
[72,"72",null,27627.31,21454.400000000001,15389.08,11886.310000000001,9605.7200000000012,null,0,0,0,0,0]
[73,"73",null,30393.38,23599.31,16927.14,13080.93,10566.61,null,0,0,0,0,0]
[74,"74",null,33161.57,25751.640000000003,18470.5,14271.84,11529.09,null,0,0,0,0,0]
[75,"75+",null,36270.550000000003,28719.11,21183.040000000001,15622.810000000001,13230.390000000001,null,0,0,0,0,0]
[1,"1 Child",null,1652.5400000000002,1178.72,895.17000000000007,770.09,557.03,null,0,0,0,0,0]
[2,"2 Children",null,2687.1,1855,1414.5700000000002,1220.0600000000002,816.73,null,0,0,0,0,0]
[3,"3+ Children",null,3933.6600000000003,2708.3,2061.7000000000003,1766.49,1242.3200000000002,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,5419,4070,2986,2227,1756,null,0,0,0,0,0]
[25,"25-29",null,6027,4534,3330,2483,1953,null,0,0,0,0,0]
[30,"30-34",null,6978,5342,3957,2950,2267,null,0,0,0,0,0]
[35,"35-39",null,7739,5952,4413,3367,2521,null,0,0,0,0,0]
[40,"40-44",null,8738,6742,5002,3759,2853,null,0,0,0,0,0]
[45,"45-49",null,10148,7771,5639,4283,3318,null,0,0,0,0,0]
[50,"50-54",null,11130,8738,6579,4816,3651,null,0,0,0,0,0]
[55,"55-59",null,13156,10094,7279,5577,4317,null,0,0,0,0,0]
[60,"60",null,14537,11173,8014,6157,4781,null,0,0,0,0,0]
[61,"61",null,16371,12583,9017,6937,5384,null,0,0,0,0,0]
[62,"62",null,18193,13986,10027,7708,5991,null,0,0,0,0,0]
[63,"63",null,20020,15397,11034,8495,6590,null,0,0,0,0,0]
[64,"64",null,21851,16792,12042,9271,7199,null,0,0,0,0,0]
[65,"65",null,23621,18286,13126,10103,8203,null,0,0,0,0,0]
[66,"66",null,25018,19363,13899,10695,8684,null,0,0,0,0,0]
[67,"67",null,27807,21525,15455,11895,9656,null,0,0,0,0,0]
[68,"68",null,30585,23684,17008,13084,10627,null,0,0,0,0,0]
[69,"69",null,31983,24762,17781,13680,11110,null,0,0,0,0,0]
[70,"70",null,32402,25151,18051,13941,11252,null,0,0,0,0,0]
[71,"71",null,36458,28310,20325,15691,12670,null,0,0,0,0,0]
[72,"72",null,40510,31462,22585,17443,14083,null,0,0,0,0,0]
[73,"73",null,44581,34612,24849,19188,15495,null,0,0,0,0,0]
[74,"74",null,48635,37770,27111,20949,16914,null,0,0,0,0,0]
[75,"75+",null,53202,42124,31101,22933,19414,null,0,0,0,0,0]
[1,"1 Child",null,2421,1729,1313,1134,823,null,0,0,0,0,0]
[2,"2 Children",null,3950,2733,2082,1795,1200,null,0,0,0,0,0]
[3,"3+ Children",null,5775,3972,3027,2588,1825,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":2872.07},{"$f":"$L$2*E341","v":2157.1},1582.5800000000002,1180.3100000000002,930.68000000000006,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D342","v":3194.31},2403.02,1764.9,1315.99,1035.0900000000001,null,0,0,0,0,0]
[30,"30-34",null,3698.34,2831.26,2097.21,1563.5,1201.51,null,0,0,0,0,0]
[35,"35-39",null,4101.67,3154.56,2338.8900000000003,1784.51,1336.13,null,0,0,0,0,0]
[40,"40-44",null,4631.1400000000003,3573.26,2651.06,1992.2700000000002,1512.0900000000001,null,0,0,0,0,0]
[45,"45-49",null,5378.4400000000005,4118.63,2988.67,2269.9900000000002,1758.5400000000002,null,0,0,0,0,0]
[50,"50-54",null,5898.9000000000005,4631.1400000000003,3486.8700000000003,2552.48,1935.0300000000002,null,0,0,0,0,0]
[55,"55-59",null,6972.68,5349.8200000000006,3857.8700000000003,2955.81,2288.0100000000002,null,0,0,0,0,0]
[60,"60",null,7704.6100000000006,5921.6900000000005,4247.42,3263.21,2533.9300000000003,null,0,0,0,0,0]
[61,"61",null,8676.630000000001,6668.9900000000007,4779.01,3676.61,2853.52,null,0,0,0,0,0]
[62,"62",null,9642.2900000000009,7412.58,5314.31,4085.2400000000002,3175.23,null,0,0,0,0,0]
[63,"63",null,10610.6,8160.4100000000008,5848.02,4502.3500000000004,3492.7000000000003,null,0,0,0,0,0]
[64,"64",null,11581.03,8899.76,6382.26,4913.63,3815.4700000000003,null,0,0,0,0,0]
[65,"65",null,12519.130000000001,9691.58,6956.7800000000007,5354.59,4347.59,null,0,0,0,0,0]
[66,"66",null,13259.54,10262.390000000001,7366.47,5668.35,4602.5200000000004,null,0,0,0,0,0]
[67,"67",null,14737.710000000001,11408.25,8191.1500000000005,6304.35,5117.68,null,0,0,0,0,0]
[68,"68",null,16210.050000000001,12552.52,9014.24,6934.52,5632.31,null,0,0,0,0,0]
[69,"69",null,16950.990000000002,13123.86,9423.93,7250.4000000000005,5888.3,null,0,0,0,0,0]
[70,"70",null,17173.060000000001,13330.03,9567.0300000000007,7388.7300000000005,5963.56,null,0,0,0,0,0]
[71,"71",null,19322.740000000002,15004.300000000001,10772.25,8316.23,6715.1,null,0,0,0,0,0]
[72,"72",null,21470.3,16674.86,11970.050000000001,9244.7900000000009,7463.9900000000007,null,0,0,0,0,0]
[73,"73",null,23627.93,18344.36,13169.970000000001,10169.640000000001,8212.35,null,0,0,0,0,0]
[74,"74",null,25776.550000000003,20018.100000000002,14368.83,11102.970000000001,8964.42,null,0,0,0,0,0]
[75,"75+",null,28197.06,22325.72,16483.530000000002,12154.49,10289.42,null,0,0,0,0,0]
[1,"1 Child",null,1283.1300000000001,916.37,695.89,601.02,436.19,null,0,0,0,0,0]
[2,"2 Children",null,2093.5,1448.49,1103.46,951.35,636,null,0,0,0,0,0]
[3,"3+ Children",null,3060.75,2105.1600000000003,1604.3100000000002,1371.64,967.25,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,5309,4166,3074,2591,1964,null,0,0,0,0,0]
[25,"25-29",null,5849,4685,3424,2887,2184,null,0,0,0,0,0]
[30,"30-34",null,6701,5513,3977,3351,2535,null,0,0,0,0,0]
[35,"35-39",null,7384,6166,4429,3728,2805,null,0,0,0,0,0]
[40,"40-44",null,8284,7039,5005,4212,3171,null,0,0,0,0,0]
[45,"45-49",null,9530,8243,5824,4899,3679,null,0,0,0,0,0]
[50,"50-54",null,10401,9081,6384,5372,4025,null,0,0,0,0,0]
[55,"55-59",null,12228,10841,7570,6363,4762,null,0,0,0,0,0]
[60,"60",null,12791,11583,8017,6732,5038,null,0,0,0,0,0]
[61,"61",null,14398,13035,9024,7587,5679,null,0,0,0,0,0]
[62,"62",null,16013,14502,10040,8430,6309,null,0,0,0,0,0]
[63,"63",null,17617,15949,11046,9278,6951,null,0,0,0,0,0]
[64,"64",null,19224,17414,12055,10134,7587,null,0,0,0,0,0]
[65,"65",null,19252,17579,12132,10193,7616,null,0,0,0,0,0]
[66,"66",null,19273,17737,12198,10237,7639,null,0,0,0,0,0]
[67,"67",null,21417,19708,13565,11381,8497,null,0,0,0,0,0]
[68,"68",null,23565,21695,14919,12530,9358,null,0,0,0,0,0]
[69,"69",null,24640,22679,15604,13096,9780,null,0,0,0,0,0]
[70,"70",null,24687,23064,15767,13227,9831,null,0,0,0,0,0]
[71,"71",null,27785,25951,17745,14891,11070,null,0,0,0,0,0]
[72,"72",null,30874,28847,19723,16559,12305,null,0,0,0,0,0]
[73,"73",null,33973,31730,21702,18208,13547,null,0,0,0,0,0]
[74,"74",null,37063,34623,23678,19870,14784,null,0,0,0,0,0]
[75,"75+",null,40393,37976,25900,21730,16150,null,0,0,0,0,0]
[1,"1 Child",null,2562,1506,1238,1039,766,null,0,0,0,0,0]
[2,"2 Children",null,4317,2244,1951,1643,1215,null,0,0,0,0,0]
[3,"3+ Children",null,6344,3225,2834,2382,1758,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":2813.77},{"$f":"$L$2*E408","v":2207.98},1629.22,1373.23,1040.92,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D409","v":3099.9700000000003},2483.0500000000002,1814.72,1530.1100000000001,1157.52,null,0,0,0,0,0]
[30,"30-34",null,3551.53,2921.8900000000003,2107.81,1776.0300000000002,1343.55,null,0,0,0,0,0]
[35,"35-39",null,3913.52,3267.98,2347.37,1975.8400000000001,1486.65,null,0,0,0,0,0]
[40,"40-44",null,4390.5200000000004,3730.67,2652.65,2232.36,1680.63,null,0,0,0,0,0]
[45,"45-49",null,5050.9000000000005,4368.79,3086.7200000000003,2596.4700000000003,1949.8700000000001,null,0,0,0,0,0]
[50,"50-54",null,5512.5300000000007,4812.93,3383.52,2847.1600000000003,2133.25,null,0,0,0,0,0]
[55,"55-59",null,6480.84,5745.7300000000005,4012.1000000000004,3372.3900000000003,2523.86,null,0,0,0,0,0]
[60,"60",null,6779.2300000000005,6138.9900000000007,4249.01,3567.96,2670.1400000000003,null,0,0,0,0,0]
[61,"61",null,7630.9400000000005,6908.55,4782.72,4021.11,3009.8700000000003,null,0,0,0,0,0]
[62,"62",null,8486.8900000000012,7686.06,5321.2,4467.9000000000005,3343.77,null,0,0,0,0,0]
[63,"63",null,9337.01,8452.9700000000012,5854.38,4917.34,3684.03,null,0,0,0,0,0]
[64,"64",null,10188.720000000001,9229.42,6389.1500000000005,5371.02,4021.11,null,0,0,0,0,0]
[65,"65",null,10203.560000000001,9316.8700000000008,6429.96,5402.29,4036.48,null,0,0,0,0,0]
[66,"66",null,10214.69,9400.61,6464.9400000000005,5425.6100000000006,4048.67,null,0,0,0,0,0]
[67,"67",null,11351.01,10445.24,7189.4500000000007,6031.93,4503.41,null,0,0,0,0,0]
[68,"68",null,12489.45,11498.35,7907.0700000000006,6640.9000000000005,4959.7400000000007,null,0,0,0,0,0]
[69,"69",null,13059.2,12019.87,8270.1200000000008,6940.88,5183.4000000000005,null,0,0,0,0,0]
[70,"70",null,13084.11,12223.92,8356.51,7010.31,5210.43,null,0,0,0,0,0]
[71,"71",null,14726.050000000001,13754.03,9404.85,7892.2300000000005,5867.1,null,0,0,0,0,0]
[72,"72",null,16363.220000000001,15288.910000000002,10453.19,8776.27,6521.6500000000005,null,0,0,0,0,0]
[73,"73",null,18005.690000000002,16816.900000000001,11502.060000000001,9650.24,7179.9100000000008,null,0,0,0,0,0]
[74,"74",null,19643.39,18350.190000000002,12549.34,10531.1,7835.52,null,0,0,0,0,0]
[75,"75+",null,21408.29,20127.280000000002,13727,11516.900000000001,8559.5,null,0,0,0,0,0]
[1,"1 Child",null,1357.8600000000001,798.18000000000006,656.14,550.67000000000007,405.98,null,0,0,0,0,0]
[2,"2 Children",null,2288.0100000000002,1189.3200000000002,1034.03,870.79000000000008,643.95000000000005,null,0,0,0,0,0]
[3,"3+ Children",null,3362.32,1709.25,1502.02,1262.46,931.74,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,4501,3528,2603,2191,1659,null,0,0,0,0,0]
[25,"25-29",null,4961,3972,2902,2436,1844,null,0,0,0,0,0]
[30,"30-34",null,5682,4672,3372,2834,2148,null,0,0,0,0,0]
[35,"35-39",null,6263,5231,3747,3159,2376,null,0,0,0,0,0]
[40,"40-44",null,7018,5967,4244,3570,2685,null,0,0,0,0,0]
[45,"45-49",null,8089,6992,4941,4153,3119,null,0,0,0,0,0]
[50,"50-54",null,8826,7708,5415,4556,3412,null,0,0,0,0,0]
[55,"55-59",null,10377,9207,6426,5393,4033,null,0,0,0,0,0]
[60,"60",null,10856,9835,6806,5717,4268,null,0,0,0,0,0]
[61,"61",null,12234,11071,7658,6438,4814,null,0,0,0,0,0]
[62,"62",null,13594,12319,8527,7159,5360,null,0,0,0,0,0]
[63,"63",null,14962,13554,9380,7879,5900,null,0,0,0,0,0]
[64,"64",null,16322,14785,10237,8603,6438,null,0,0,0,0,0]
[65,"65",null,16342,14930,10298,8651,6463,null,0,0,0,0,0]
[66,"66",null,16364,15066,10362,8699,6485,null,0,0,0,0,0]
[67,"67",null,18184,16749,11514,9668,7213,null,0,0,0,0,0]
[68,"68",null,20012,18425,12675,10643,7941,null,0,0,0,0,0]
[69,"69",null,20924,19263,13258,11131,8307,null,0,0,0,0,0]
[70,"70",null,20966,19593,13395,11230,8344,null,0,0,0,0,0]
[71,"71",null,23596,22048,15071,12648,9396,null,0,0,0,0,0]
[72,"72",null,26222,24510,16758,14064,10452,null,0,0,0,0,0]
[73,"73",null,28860,26963,18440,15466,11504,null,0,0,0,0,0]
[74,"74",null,31488,29419,20115,16884,12553,null,0,0,0,0,0]
[75,"75+",null,34316,32266,22002,18465,13715,null,0,0,0,0,0]
[1,"1 Child",null,2180,1283,1048,887,655,null,0,0,0,0,0]
[2,"2 Children",null,3667,1901,1658,1397,1032,null,0,0,0,0,0]
[3,"3+ Children",null,5387,2744,2414,2020,1495,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":2385.5300000000002},{"$f":"$L$2*E475","v":1869.8400000000001},1379.5900000000001,1161.23,879.2700000000001,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D476","v":2629.33},2105.1600000000003,1538.0600000000002,1291.0800000000002,977.32,null,0,0,0,0,0]
[30,"30-34",null,3011.46,2476.1600000000003,1787.16,1502.02,1138.44,null,0,0,0,0,0]
[35,"35-39",null,3319.3900000000003,2772.4300000000003,1985.91,1674.27,1259.28,null,0,0,0,0,0]
[40,"40-44",null,3719.54,3162.51,2249.3200000000002,1892.1000000000001,1423.0500000000002,null,0,0,0,0,0]
[45,"45-49",null,4287.17,3705.76,2618.73,2201.09,1653.0700000000002,null,0,0,0,0,0]
[50,"50-54",null,4677.7800000000007,4085.2400000000002,2869.9500000000003,2414.6800000000003,1808.3600000000001,null,0,0,0,0,0]
[55,"55-59",null,5499.81,4879.71,3405.78,2858.29,2137.4900000000002,null,0,0,0,0,0]
[60,"60",null,5753.68,5212.55,3607.1800000000003,3030.01,2262.04,null,0,0,0,0,0]
[61,"61",null,6484.02,5867.63,4058.7400000000002,3412.1400000000003,2551.42,null,0,0,0,0,0]
[62,"62",null,7204.8200000000006,6529.0700000000006,4519.3100000000004,3794.27,2840.8,null,0,0,0,0,0]
[63,"63",null,7929.8600000000006,7183.6200000000008,4971.4000000000005,4175.87,3127,null,0,0,0,0,0]
[64,"64",null,8650.66,7836.05,5425.6100000000006,4559.59,3412.1400000000003,null,0,0,0,0,0]
[65,"65",null,8661.26,7912.9000000000005,5457.9400000000005,4585.0300000000007,3425.3900000000003,null,0,0,0,0,0]
[66,"66",null,8672.92,7984.9800000000005,5491.8600000000006,4610.47,3437.05,null,0,0,0,0,0]
[67,"67",null,9637.52,8876.9700000000012,6102.42,5124.04,3822.8900000000003,null,0,0,0,0,0]
[68,"68",null,10606.36,9765.25,6717.75,5640.79,4208.7300000000005,null,0,0,0,0,0]
[69,"69",null,11089.720000000001,10209.390000000001,7026.7400000000007,5899.43,4402.71,null,0,0,0,0,0]
[70,"70",null,11111.980000000001,10384.290000000001,7099.35,5951.9000000000005,4422.3200000000006,null,0,0,0,0,0]
[71,"71",null,12505.880000000001,11685.44,7987.63,6703.4400000000005,4979.88,null,0,0,0,0,0]
[72,"72",null,13897.66,12990.300000000001,8881.74,7453.92,5539.56,null,0,0,0,0,0]
[73,"73",null,15295.800000000001,14290.390000000001,9773.2000000000007,8196.98,6097.12,null,0,0,0,0,0]
[74,"74",null,16688.64,15592.070000000002,10660.95,8948.52,6653.09,null,0,0,0,0,0]
[75,"75+",null,18187.48,17100.98,11661.060000000001,9786.4500000000007,7268.9500000000007,null,0,0,0,0,0]
[1,"1 Child",null,1155.4000000000001,679.99,555.44000000000005,470.11,347.15000000000003,null,0,0,0,0,0]
[2,"2 Children",null,1943.51,1007.5300000000001,878.74,740.41000000000008,546.96,null,0,0,0,0,0]
[3,"3+ Children",null,2855.11,1454.3200000000002,1279.42,1070.6000000000001,792.35,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",3170,5564,7955,2521,4289,6061,2160,3694,5227,1658,2791,3909,1249,2014,2775,808,1186,1570]
[50,"o más",4003,6395,8796,3167,4944,6712,2691,4231,5766,2056,3172,4299,1507,2273,3035,938,1317,1695]
[]
["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":1680.1000000000001},2948.92,4216.1500000000005,1336.13,2273.17,3212.3300000000004,1144.8,1957.8200000000002,2770.31,878.74,1479.23,2071.77,661.97,1067.42,1470.75,428.24,628.58000000000004,832.1]
[75,"o más",{"$f":"+C544*$L$2","v":2121.59},3389.3500000000004,4661.88,1678.51,2620.3200000000002,3557.36,1426.23,2242.4300000000003,3055.98,1089.68,1681.16,2278.4700000000003,798.71,1204.69,1608.5500000000002,497.14000000000004,698.01,898.35]
[]
[]
[]
[null,null,3170,5564,7955,2521,4289,6061,2160,3694,5227,1658,2791,3909,1249,2014,2775,808,1186,1570]
[null,null,4003,6395,8796,3167,4944,6712,2691,4231,5766,2056,3172,4299,1507,2273,3035,938,1317,1695]
[]
[null,null,1680.1000000000001,2948.92,4216.1500000000005,1336.13,2273.17,3212.3300000000004,1144.8,1957.8200000000002,2770.31,878.74,1479.23,2071.77,661.97,1067.42,1470.75,428.24,628.58000000000004,832.1]
[null,null,2121.59,3389.3500000000004,4661.88,1678.51,2620.3200000000002,3557.36,1426.23,2242.4300000000003,3055.98,1089.68,1681.16,2278.4700000000003,798.71,1204.69,1608.5500000000002,497.14000000000004,698.01,898.35]
[]
[null,null,{"$f":"+C555-C543","v":0},{"$f":"+D555-D543","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C556-C544","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,{"$f":"+C550-C558","v":0},{"$f":"+D550-D558","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C551-C559","v":0},{"$f":"+D551-D559","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Sheet1","index":11,"n_rows":20,"n_cols":26,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,"Deductible",2000,null,null,null,3500,null,null,null,5000,null,null,null,10000,null,null,null,20000,null,null,null,50000]
[null,null,"Annual","Semi-Annual","Quarterly","Monthly","Annual","Semi-Annual","Quarterly","Monthly","Annual","Semi-Annual","Quarterly","Monthly","Annual","Semi-Annual","Quarterly","Monthly","Annual","Semi-Annual","Quarterly","Monthly","Annual","Semi-Annual","Quarterly","Monthly"]
[null,"Under 50"]
[null,"0 1 Member",3170,1680.1000000000001,871.75000000000011,295.86666666666673,2521,1336.13,693.27500000000009,235.29333333333338,2160,1144.8,594,201.60000000000002,1658,878.74,455.95000000000005,154.74666666666667,1249,661.97,343.47500000000002,116.57333333333334,808,428.24,222.20000000000002,75.413333333333341]
[null,"0 2 Members",5564,2948.92,1530.1000000000001,519.30666666666673,4289,2273.17,1179.4750000000001,400.30666666666673,3694,1957.8200000000002,1015.8500000000001,344.77333333333337,2791,1479.23,767.52500000000009,260.4933333333334,2014,1067.42,553.85,187.97333333333336,1186,628.58000000000004,326.15000000000003,110.69333333333334]
[null,"0 3+ Members",7955,4216.1500000000005,2187.625,742.4666666666667,6061,3212.3300000000004,1666.7750000000001,565.69333333333338,5227,2770.31,1437.4250000000002,487.85333333333335,3909,2071.77,1074.9750000000001,364.84000000000003,2775,1470.75,763.12500000000011,259,1570,832.1,431.75000000000006,146.53333333333336]
[null,""]
[null,"Over 50"]
[null,"50 1 Member",4003,2121.59,1100.825,373.61333333333334,3167,1678.51,870.92500000000007,295.5866666666667,2691,1426.23,740.02500000000009,251.16000000000003,2056,1089.68,565.40000000000009,191.89333333333337,1507,798.71,414.42500000000001,140.65333333333334,938,497.14000000000004,257.95000000000005,87.546666666666681]
[null,"50 2 Members",6395,3389.3500000000004,1758.6250000000002,596.86666666666667,4944,2620.3200000000002,1359.6000000000001,461.44000000000005,4231,2242.4300000000003,1163.5250000000001,394.89333333333337,3172,1681.16,872.30000000000007,296.05333333333334,2273,1204.69,625.07500000000005,212.14666666666668,1317,698.01,362.17500000000001,122.92000000000002]
[null,"50 3+ Members",8796,4661.88,2418.9,820.96,6712,3557.36,1845.8000000000002,626.45333333333349,5766,3055.98,1585.65,538.16000000000008,4299,2278.4700000000003,1182.2250000000001,401.24000000000007,3035,1608.5500000000002,834.62500000000011,283.26666666666671,1695,898.35,466.12500000000006,158.20000000000002]
[]
[]
[]
[]
[null,null,3170,5564,7955,2521,4289,6061,2160,3694,5227,1658,2791,3909,1249,2014,2775,808,1186,1570]
[null,null,4003,6395,8796,3167,4944,6712,2691,4231,5766,2056,3172,4299,1507,2273,3035,938,1317,1695]
[]
[null,null,1680.1000000000001,2948.92,4216.1500000000005,1336.13,2273.17,3212.3300000000004,1144.8,1957.8200000000002,2770.31,878.74,1479.23,2071.77,661.97,1067.42,1470.75,428.24,628.58000000000004,832.1]
[null,null,2121.59,3389.3500000000004,4661.88,1678.51,2620.3200000000002,3557.36,1426.23,2242.4300000000003,3055.98,1089.68,1681.16,2278.4700000000003,798.71,1204.69,1608.5500000000002,497.14000000000004,698.01,898.35]