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

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

{"sheet":"Exclusive","index":1,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[51,0,51,1],[51,2,51,3],[50,0,50,1],[50,2,50,3],[47,0,47,1],[47,2,47,3],[35,0,35,1],[36,0,38,1],[36,2,38,3],[46,0,46,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],[44,0,44,1],[42,0,42,1],[19,0,19,1],[26,0,26,1],[21,2,21,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[25,0,25,1],[26,2,26,3],[9,2,9,12],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[23,2,23,3],[30,2,30,3],[46,2,46,3],[17,2,18,3],[29,2,29,3],[24,2,24,3],[19,2,19,3],[20,2,20,3],[22,2,22,3],[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],[27,0,27,1],[20,0,21,1],[28,0,28,1],[31,2,31,3],[27,2,27,3],[29,0,29,1],[30,0,31,1],[28,2,28,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],[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":"2021-11-04T16:59:44.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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":15890},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":10495},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":7182},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":5089},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":4007}]
[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":8786},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":6484},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":5118},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":4302},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":3350}]
[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":24676},{"$f":"SUM(J31:J34)","v":16979},{"$f":"SUM(K31:K34)","v":12525},{"$f":"SUM(L31:L34)","v":9616},{"$f":"SUM(M31:M34)","v":7582}]
[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":24751},{"$f":"SUM(J35:J36)","v":17054},{"$f":"SUM(K35:K36)","v":12600},{"$f":"SUM(L35:L36)","v":9691},{"$f":"SUM(M35:M36)","v":7657}]
[]
[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":8421.7000000000007},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":5562.35},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":3806.46},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":2697.17},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":2123.71}]
[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":4656.58},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":3436.52},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":2712.54},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":2280.06},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":1775.5}]
[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":13078.28},{"$f":"SUM(J40:J43)","v":8998.8700000000008},{"$f":"SUM(K40:K43)","v":6638.25},{"$f":"SUM(L40:L43)","v":5096.4799999999996},{"$f":"SUM(M40:M43)","v":4018.46}]
[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":13153.28},{"$f":"SUM(J44:J45)","v":9073.8700000000008},{"$f":"SUM(K44:K45)","v":6713.25},{"$f":"SUM(L44:L45)","v":5171.4799999999996},{"$f":"SUM(M44:M45)","v":4093.46}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":13078.28},{"$f":"J44","v":8998.8700000000008},6638.25,5096.4799999999996,4018.46]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2022"]
[]
[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],[32,0,32,1],[32,2,32,3],[41,2,41,3],[37,0,37,1],[38,0,38,1],[34,2,34,3],[39,0,39,1],[40,0,40,1],[41,0,41,1],[36,0,36,1],[36,2,36,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],[26,0,26,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[9,2,9,12],[11,7,11,12],[19,0,19,1],[17,0,18,1],[20,0,21,1],[29,2,29,3],[27,2,27,3],[28,2,28,3],[22,2,22,3],[31,2,31,3],[26,2,26,3],[20,2,20,3],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,18,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[21,2,21,3],[46,2,47,3],[43,2,43,3],[39,2,39,3],[49,5,50,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[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]]}
[]
[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":"2021-11-04T16:59:44.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null," ",false]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,4,TRUE)","v":13357},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":9181},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":6243},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":4424},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":3376}]
[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":7371},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":5389},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":4037},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":3410},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":2520}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$167)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":20728},{"$f":"SUM(J31:J34)","v":14570},{"$f":"SUM(K31:K34)","v":10280},{"$f":"SUM(L31:L34)","v":7834},{"$f":"SUM(M31:M34)","v":5896}]
[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":20803},{"$f":"SUM(J35:J36)","v":14645},{"$f":"SUM(K35:K36)","v":10355},{"$f":"SUM(L35:L36)","v":7909},{"$f":"SUM(M35:M36)","v":5971}]
[]
[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":7079.21},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":4865.93},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":3308.79},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":2344.7200000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":1789.2800000000002}]
[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":3906.63},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":2856.17},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":2139.61},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":1807.3000000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":1335.6000000000001}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$200)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":10985.84},{"$f":"SUM(J40:J43)","v":7722.1},{"$f":"SUM(K40:K43)","v":5448.4},{"$f":"SUM(L40:L43)","v":4152.0200000000004},{"$f":"SUM(M40:M43)","v":3124.88}]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,"n/a",{"$f":"SUM(I44:I45)","v":11060.84},{"$f":"SUM(J44:J45)","v":7797.1},{"$f":"SUM(K44:K45)","v":5523.4},{"$f":"SUM(L44:L45)","v":4227.0200000000004},{"$f":"SUM(M44:M45)","v":3199.88}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":10985.84},{"$f":"J44","v":7722.1},5448.4,4152.0200000000004,3124.88]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2022"]
[]
[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],[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],[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],[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],[21,2,21,3],[22,2,22,3],[20,2,20,3],[25,2,25,3],[23,2,23,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],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[51,5,52,12],[50,2,50,3],[46,2,46,3],[44,2,44,3],[51,2,52,3],[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]]}
[]
[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":"2021-11-04T16:59:44.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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,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":8896},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":6687},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":4881},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":3737},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":2960}]
[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":6453},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":4453},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":3352},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":2973},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":1999}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$301)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$301)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$301)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$301)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$301)","v":225}]
[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":15874},11665,8758,7235,5484]
[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":15949},{"$f":"SUM(J36:J37)","v":11740},{"$f":"SUM(K36:K37)","v":8833},{"$f":"SUM(L36:L37)","v":7310},{"$f":"SUM(M36:M37)","v":5559}]
[]
[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":4714.88},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":3544.11},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":2586.9300000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":1980.6100000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":1568.8000000000002}]
[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":3420.09},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":2360.09},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":1776.5600000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":1575.69},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":1059.47}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$334)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$334)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$334)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$334)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$334)","v":119.25}]
[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":8413.2200000000012},6182.4500000000007,4641.7400000000007,3834.55,2906.5200000000004]
[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":8488.2200000000012},{"$f":"SUM(J46:J47)","v":6257.4500000000007},{"$f":"SUM(K46:K47)","v":4716.7400000000007},{"$f":"SUM(L46:L47)","v":3909.55},{"$f":"SUM(M46:M47)","v":2981.5200000000004}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":8413.2200000000012},{"$f":"J46","v":6182.4500000000007},4641.7400000000007,3834.55,2906.5200000000004]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2022"]
[]
[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":false,"merged":[[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["                           Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
[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":"2021-11-04T16:59:44.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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,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$341:$H$364,4,TRUE)","v":6886},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":5165},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":3755},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":2876},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":2271}]
[null,null,null,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}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,4,TRUE)))","v":5014},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":3471},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":2615},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":2321},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":1555}]
[null,null,null,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}]
[null,null,null,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}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":11900},8636,6370,5197,3826]
[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":11975},{"$f":"SUM(J36:J37)","v":8711},{"$f":"SUM(K36:K37)","v":6445},{"$f":"SUM(L36:L37)","v":5272},{"$f":"SUM(M36:M37)","v":3901}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,4,TRUE)","v":3649.5800000000004},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":2737.4500000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":1990.15},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":1524.28},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":1203.6300000000001}]
[null,null,null,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}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,4,TRUE)))","v":2657.42},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":1839.63},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":1385.95},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":1230.1300000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":824.15000000000009}]
[null,null,null,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}]
[null,null,null,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}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":6307},4577.08,3376.1000000000004,2754.41,2027.7800000000002]
[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":6382},{"$f":"SUM(J46:J47)","v":4652.08},{"$f":"SUM(K46:K47)","v":3451.1000000000004},{"$f":"SUM(L46:L47)","v":2829.41},{"$f":"SUM(M46:M47)","v":2102.7800000000002}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":6307},{"$f":"J46","v":4577.08},3376.1000000000004,2754.41,2027.7800000000002]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2022"]

{"sheet":"Secure","index":5,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[33,2,33,3],[31,2,31,3],[47,0,48,1],[47,2,48,3],[45,2,45,3],[46,0,46,1],[45,0,45,1],[33,0,33,1],[34,0,34,1],[35,0,41,1],[44,0,44,1],[34,2,34,3],[40,2,41,3],[43,2,43,3],[44,2,44,3],[42,2,42,3],[42,0,42,1],[43,0,43,1],[35,2,39,3],[49,5,49,12],[46,2,46,3],[49,0,49,1],[49,2,49,3],[16,0,16,1],[19,0,19,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,0,29,1],[26,0,26,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[20,0,21,1],[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],[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]]}
[]
[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":"2021-11-04T16:59:44.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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,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":7091},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":5563},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":4070},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":3432},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":2615}]
[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":5774},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":3006},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":2587},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":2168},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":1619}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$435)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$435)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$435)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$435)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$435)","v":225}]
[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":13390},9094,7182,6125,4759]
[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":13465},{"$f":"SUM(J36:J37)","v":9169},{"$f":"SUM(K36:K37)","v":7257},{"$f":"SUM(L36:L37)","v":6200},{"$f":"SUM(M36:M37)","v":4834}]
[]
[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":3758.23},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":2948.3900000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":2157.1},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":1818.96},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":1385.95}]
[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":3060.2200000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":1593.18},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":1371.1100000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":1149.04},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":858.07}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$468)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$468)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$468)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$468)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$468)","v":119.25}]
[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":7096.7000000000007},4819.8200000000006,3806.46,3246.25,2522.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":7171.7000000000007},{"$f":"SUM(J46:J47)","v":4894.8200000000006},{"$f":"SUM(K46:K47)","v":3881.46},{"$f":"SUM(L46:L47)","v":3321.25},{"$f":"SUM(M46:M47)","v":2597.27}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":7096.7000000000007},{"$f":"J46","v":4819.8200000000006},3806.46,3246.25,2522.27]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2022"]
[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":[[49,2,49,3],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[21,2,21,3],[22,2,22,3],[20,0,21,1],[22,0,23,1],[24,0,24,1],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[29,2,29,3],[30,2,30,3],[27,2,27,3],[35,2,39,3],[33,0,33,1],[34,0,34,1],[35,0,41,1],[40,2,41,3],[33,2,33,3],[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]]}
[]
[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":"2021-11-04T16:59:44.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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,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":5856},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":4337},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":3367},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":2831},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":2145}]
[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":4783},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":2493},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":2142},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":1794},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":1346}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$502)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$502)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$502)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$502)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$502)","v":225}]
[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":11164},7355,6034,5150,4016]
[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":11239},{"$f":"SUM(J36:J37)","v":7430},{"$f":"SUM(K36:K37)","v":6109},{"$f":"SUM(L36:L37)","v":5225},{"$f":"SUM(M36:M37)","v":4091}]
[]
[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":3103.6800000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":2298.61},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":1784.51},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":1500.43},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":1136.8500000000001}]
[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":2534.9900000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":1321.29},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":1135.26},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":950.82},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":713.38}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$535)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$535)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$535)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$535)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$535)","v":119.25}]
[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":5916.92},3898.15,3198.02,2729.5,2128.48]
[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":5991.92},{"$f":"SUM(J46:J47)","v":3973.15},{"$f":"SUM(K46:K47)","v":3273.02},{"$f":"SUM(L46:L47)","v":2804.5},{"$f":"SUM(M46:M47)","v":2203.48}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":5916.92},{"$f":"J46","v":3898.15},3198.02,2729.5,2128.48]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2022"]
[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":[[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[29,8,29,9],[30,8,30,9],[45,0,45,1],[23,5,24,7],[25,5,26,7],[27,5,28,7],[29,5,30,7],[31,5,32,7],[33,5,34,7],[35,5,36,7],[44,2,44,3],[26,0,26,1],[43,2,43,3],[40,0,40,1],[41,0,41,1],[42,0,42,1],[42,2,42,3],[40,2,40,3],[19,0,19,1],[41,2,41,3],[44,0,44,1],[32,0,32,1],[35,0,39,1],[33,0,33,1],[34,0,34,1],[43,0,43,1],[22,0,23,1],[24,0,24,1],[30,2,31,3],[27,0,27,1],[28,0,28,1],[34,2,34,3],[29,0,29,1],[30,0,31,1],[25,0,25,1],[25,2,25,3],[23,2,23,3],[24,2,24,3],[27,2,27,3],[21,5,22,7],[21,8,22,9],[20,0,21,1],[21,2,21,3],[22,2,22,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],[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],[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]]}
[]
[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":"2021-11-04T16:59:44.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,6,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,9,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,12,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,15,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,18,TRUE)),0)","v":0}]
[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":10748},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,8,TRUE)),0)","v":9060},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,11,TRUE)),0)","v":7761},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,14,TRUE)),0)","v":5864},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,17,TRUE)),0)","v":4050},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,20,TRUE)),0)","v":2119}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":10748},{"$f":"SUM(I44:I46)","v":9060},7761,5864,4050,2119]
[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":10823},9135,7836,5939,4125,2194]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2022"]
[]
[]
[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":[[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],[11,0,11,7],[13,2,13,7],[15,2,15,7],[19,0,19,1],[18,0,18,1],[25,2,25,7],[32,0,32,1],[35,2,35,7],[39,0,41,7],[37,0,37,7],[28,0,28,1]]}
[]
[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":"2021-11-04T16:59:44.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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":24751},{"$f":"+Exclusive!J37","v":17054},{"$f":"+Exclusive!K37","v":12600},{"$f":"+Exclusive!L37","v":9691},{"$f":"+Exclusive!M37","v":7657}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":20803},{"$f":"+Privilege!J37","v":14645},{"$f":"+Privilege!K37","v":10355},{"$f":"+Privilege!L37","v":7909},{"$f":"+Privilege!M37","v":5971}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":15949},{"$f":"+'Advantage (Mundial)'!J38","v":11740},{"$f":"+'Advantage (Mundial)'!K38","v":8833},{"$f":"+'Advantage (Mundial)'!L38","v":7310},{"$f":"+'Advantage (Mundial)'!M38","v":5559}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":13465},{"$f":"+Secure!J38","v":9169},{"$f":"+Secure!K38","v":7257},{"$f":"+Secure!L38","v":6200},{"$f":"+Secure!M38","v":4834}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":11239},{"$f":"+Essential!J38","v":7430},{"$f":"+Essential!K38","v":6109},{"$f":"+Essential!L38","v":5225},{"$f":"+Essential!M38","v":4091}]
[]
["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":10823},{"$f":"+Critical!I49","v":9135},{"$f":"+Critical!J49","v":7836},{"$f":"+Critical!K49","v":5939},{"$f":"+Critical!L49","v":4125},{"$f":"+Critical!M49","v":2194}]
["Tarifas en US $ -  Válidas desde 01 enero 2022"]
[]
["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":[[6,5,7,5],[11,0,15,0],[20,0,21,0],[23,0,25,0],[1,1,3,6],[4,1,4,6],[5,6,7,6],[13,4,15,4],[13,5,15,5],[12,6,15,6],[5,0,7,0],[5,1,7,1],[5,2,7,2],[6,3,7,3],[6,4,7,4]]}
[]
[null,"2022 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":557,"n_cols":20,"rows_kept":557,"cut":false,"hidden":true,"merged":[[540,14,540,16],[540,17,540,19],[547,14,547,16],[547,17,547,19],[545,0,545,19],[540,2,540,4],[547,2,547,4],[547,5,547,7],[547,8,547,10],[546,0,546,1],[546,2,546,6],[540,5,540,7],[540,8,540,10],[547,11,547,13],[540,11,540,13],[539,0,539,1],[471,0,471,7],[472,0,472,1],[472,2,472,6],[504,0,504,7],[505,0,505,1],[505,2,505,6],[538,0,538,19],[537,0,537,19],[539,2,539,6],[304,2,304,6],[336,0,336,7],[437,0,437,7],[438,0,438,1],[438,2,438,6],[304,0,304,1],[370,0,370,7],[371,0,371,1],[371,2,371,6],[337,0,337,7],[338,0,338,1],[338,2,338,6],[470,0,470,7],[403,0,403,7],[404,0,404,7],[405,0,405,1],[405,2,405,6],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[303,0,303,7],[269,0,269,7],[270,0,270,7],[271,0,271,1],[271,2,271,6],[170,2,170,6],[202,0,202,7],[236,0,236,7],[237,0,237,1],[237,2,237,6],[204,0,204,1],[204,2,204,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6],[554,17,554,19],[554,2,554,4],[554,5,554,7],[554,8,554,10],[554,11,554,13],[554,14,554,16]]}
[]
["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,3,4,5,6]
[18,"-  24",null,15890,10495,7182,5089,4007,null,true,true,true,true,true]
[25,"-  29",null,16663,11598,7958,5652,4438,null,true,true,true,true,true]
[30,"-  34",null,17334,12440,8910,6766,5336,null,true,true,true,true,true]
[35,"-  39",null,19414,13930,9990,7588,5977,null,true,true,true,true,true]
[40,"-  44",null,22515,15237,11086,8350,6567,null,true,true,true,true,true]
[45,"-  49",null,25169,17039,12401,9328,7348,null,true,true,true,true,true]
[50,"-  54",null,32212,22373,16180,13185,10396,null,true,true,true,true,true]
[55,"-  59",null,34273,23802,17219,14034,11065,null,true,true,true,true,true]
[60,null,null,37343,25976,19812,16906,13754,null,true,true,true,true,true]
[61,null,null,40125,27904,21282,18178,14777,null,true,true,true,true,true]
[62,null,null,43926,30564,23311,19897,16180,null,true,true,true,true,true]
[63,null,null,46710,32494,24782,21161,17206,null,true,true,true,true,true]
[64,null,null,50525,35176,26818,22894,18617,null,true,true,true,true,true]
[65,null,null,66058,45874,33911,30544,26271,null,true,true,true,true,true]
[66,null,null,76746,53310,39402,35506,30529,null,true,true,true,true,true]
[67,null,null,83825,58223,43045,38761,33341,null,true,true,true,true,true,null," "]
[68,null,null,92822,64467,47665,42947,36925,null,true,true,true,true,true]
[69,null,null,102127,70931,52452,47248,40631,null,true,true,true,true,true]
[70,null,null,125697,86376,61743,55059,47800,null,true,true,true,true,true]
[71,null,null,130640,89768,64169,57226,49684,null,true,true,true,true,true]
[72,null,null,134339,92304,65977,58841,51088,null,true,true,true,true,true]
[73,null,null,139275,95707,68404,61011,52969,null,true,true,true,true,true]
[74,null,null,141737,97392,69620,62091,53899,null,true,true,true,true,true]
[75,"o más",null,147909,101635,72648,64800,56258,null,true,true,true,true,true]
[1,"Hijo",null,5523,4069,3215,2710,2115,null,true,true,true,true,true]
[2,"Hijos",null,8786,6484,5118,4302,3350,null,true,true,true,true,true]
[3,"Hijos o más",null,12872,9498,7490,6309,4917,null,true,true,true,true,true]
[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"]
[18,"-  24",null,{"$f":"$L$2*D6","v":8421.7000000000007},{"$f":"$L$2*E6","v":5562.35},3806.46,2697.17,2123.71]
[25,"-  29",null,{"$f":"$L$2*D7","v":8831.3900000000012},6146.9400000000005,4217.74,2995.56,2352.1400000000003]
[30,"-  34",null,9187.02,6593.2000000000007,4722.3,3585.98,2828.08]
[35,"-  39",null,10289.42,7382.9000000000005,5294.7,4021.6400000000003,3167.81]
[40,"-  44",null,11932.95,8075.6100000000006,5875.58,4425.5,3480.51]
[45,"-  49",null,13339.570000000002,9030.67,6572.5300000000007,4943.84,3894.44]
[50,"-  54",null,17072.36,11857.69,8575.4,6988.05,5509.88]
[55,"-  59",null,18164.690000000002,12615.060000000001,9126.07,7438.02,5864.4500000000007]
[60,null,null,19791.79,13767.28,10500.36,8960.18,7289.6200000000008]
[61,null,null,21266.25,14789.12,11279.460000000001,9634.34,7831.81]
[62,null,null,23280.780000000002,16198.92,12354.83,10545.41,8575.4]
[63,null,null,24756.300000000003,17221.82,13134.460000000001,11215.33,9119.18]
[64,null,null,26778.25,18643.280000000002,14213.54,12133.82,9867.01]
[65,null,null,35010.740000000005,24313.22,17972.830000000002,16188.320000000002,13923.630000000001]
[66,null,null,40675.380000000005,28254.300000000003,20883.060000000001,18818.18,16180.37]
[67,null,null,44427.25,30858.190000000002,22813.850000000002,20543.330000000002,17670.73]
[68,null,null,49195.66,34167.51,25262.45,22761.91,19570.25]
[69,null,null,54127.310000000005,37593.43,27799.56,25041.440000000002,21534.43]
[70,null,null,66619.41,45779.28,32723.79,29181.27,25334]
[71,null,null,69239.199999999997,47577.04,34009.57,30329.780000000002,26332.52]
[72,null,null,71199.67,48921.120000000003,34967.810000000005,31185.730000000003,27076.640000000003]
[73,null,null,73815.75,50724.71,36254.120000000003,32335.83,28073.57]
[74,null,null,75120.61,51617.760000000002,36898.6,32908.230000000003,28566.47]
[75,"o más",null,78391.77,53866.55,38503.440000000002,34344,29816.74]
[1,"Hijo",null,{"$f":"$L$2*D30","v":2927.19},2156.5700000000002,1703.95,1436.3000000000002,1120.95]
[2,"Hijos",null,{"$f":"$L$2*D31","v":4656.58},3436.52,2712.54,2280.06,1775.5]
[3,"Hijos o más",null,{"$f":"$L$2*D32","v":6822.1600000000008},5033.9400000000005,3969.7000000000003,3343.77,2606.0100000000002]
[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",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","DL1","DL2","DL3","DL4","DL5","DL6"]
[18,"-  24",{"$f":"+C73*$L$2","v":0},0,0,0,0,0]
[25,"-  29",0,0,0,0,0,0]
[30,"-  34",0,0,0,0,0,0]
[35,"-  39",0,0,0,0,0,0]
[40,"-  44",0,0,0,0,0,0]
[45,"-  49",0,0,0,0,0,0]
[50,"-  54",0,0,0,0,0,0]
[55,"-  59",0,0,0,0,0,0]
[60,null,0,0,0,0,0,0]
[61,null,0,0,0,0,0,0]
[62,null,{"$f":"+C83*$L$2","v":0},0,0,0,0,0]
[63,null,0,0,0,0,0,0]
[64,null,0,0,0,0,0,0]
[65,null,0,0,0,0,0,0]
[66,null,0,0,0,0,0,0]
[67,null,0,0,0,0,0,0]
[68,null,0,0,0,0,0,0]
[69,null,0,0,0,0,0,0]
[70,null,0,0,0,0,0,0]
[71,null,0,0,0,0,0,0]
[72,null,{"$f":"+C93*$L$2","v":0},0,0,0,0,0]
[73,null,0,0,0,0,0,0]
[74,null,0,0,0,0,0,0]
[75,"o más",0,0,0,0,0,0]
[1,"Hijo",0,0,0,0,0,0]
[2,"Hijos",0,0,0,0,0,0]
[3,"Hijos o más",0,0,0,0,0,0]
[1,"Rider Comp. Maternidad",0,0,0,0,0,0]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["PRIVILEGE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6",null,2,3,4,5,6]
[18,"-  24",null,13357,9181,6243,4424,3376,null,true,true,true,true,true]
[25,"-  29",null,14021,10170,6914,4908,3740,null,true,true,true,true,true]
[30,"-  34",null,14634,10876,7765,5928,4521,null,true,true,true,true,true]
[35,"-  39",null,16387,12173,8697,6647,5073,null,true,true,true,true,true]
[40,"-  44",null,18972,13347,9668,7333,5597,null,true,true,true,true,true]
[45,"-  49",null,21198,14911,10808,8199,6261,null,true,true,true,true,true]
[50,"-  54",null,27712,19676,14190,11697,8945,null,true,true,true,true,true]
[55,"-  59",null,29483,20936,15105,12447,9513,null,true,true,true,true,true]
[60,null,null,32103,22736,17188,14807,11883,null,true,true,true,true,true]
[61,null,null,34505,24408,18475,15912,12768,null,true,true,true,true,true]
[62,null,null,37761,26741,20225,17422,13989,null,true,true,true,true,true]
[63,null,null,40144,28433,21500,18521,14876,null,true,true,true,true,true]
[64,null,null,43429,30758,23263,20034,16094,null,true,true,true,true,true]
[65,null,null,56771,40116,29412,26719,22692,null,true,true,true,true,true]
[66,null,null,65955,46609,34165,31048,26370,null,true,true,true,true,true]
[67,null,null,72036,50903,37314,33911,28799,null,true,true,true,true,true]
[68,null,null,79767,56369,41331,37560,31884,null,true,true,true,true,true]
[69,null,null,87752,62018,45467,41315,35091,null,true,true,true,true,true]
[70,null,null,108003,75513,53515,48146,41268,null,true,true,true,true,true]
[71,null,null,112229,78482,55614,50034,42890,null,true,true,true,true,true]
[72,null,null,115414,80699,57194,51454,44104,null,true,true,true,true,true]
[73,null,null,119658,83662,59297,53345,45729,null,true,true,true,true,true]
[74,null,null,121769,85140,60347,54294,46538,null,true,true,true,true,true]
[75,"o más",null,127073,88849,62976,56647,48569,null,true,true,true,true,true]
[1,"Hijo",null,4637,3391,2544,2143,1589,null,true,true,true,true,true]
[2,"Hijos",null,7371,5389,4037,3410,2520]
[3,"Hijos o más",null,10798,7893,5920,4993,3692]
[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"]
[18,"-  24",null,{"$f":"$L$2*D140","v":7079.21},{"$f":"$L$2*E140","v":4865.93},3308.79,2344.7200000000003,1789.2800000000002]
[25,"-  29",null,{"$f":"$L$2*D141","v":7431.13},{"$f":"$L$2*E141","v":5390.1},3664.42,2601.2400000000002,1982.2]
[30,"-  34",null,7756.02,5764.2800000000007,4115.45,3141.84,2396.13]
[35,"-  39",null,8685.11,6451.6900000000005,4609.41,3522.9100000000003,2688.69]
[40,"-  44",null,10055.16,7073.9100000000008,5124.04,3886.4900000000002,2966.4100000000003]
[45,"-  49",null,11234.94,7902.8300000000008,5728.2400000000007,4345.47,3318.3300000000004]
[50,"-  54",null,14687.36,10428.280000000001,7520.7000000000007,6199.4100000000008,4740.8500000000004]
[55,"-  59",null,15625.990000000002,11096.08,8005.6500000000005,6596.9100000000008,5041.8900000000003]
[60,null,null,17014.59,12050.08,9109.6400000000012,7847.71,6297.9900000000007]
[61,null,null,18287.650000000001,12936.24,9791.75,8433.36,6767.04]
[62,null,null,20013.330000000002,14172.730000000001,10719.25,9233.66,7414.17]
[63,null,null,21276.32,15069.490000000002,11395,9816.130000000001,7884.2800000000007]
[64,null,null,23017.370000000003,16301.740000000002,12329.390000000001,10618.02,8529.82]
[65,null,null,30088.63,21261.48,15588.36,14161.070000000002,12026.76]
[66,null,null,34956.15,24702.77,18107.45,{"$f":"$L$2*G154","v":16455.440000000002},13976.1]
[67,null,null,38179.08,26978.59,19776.420000000002,17972.830000000002,15263.470000000001]
[68,null,null,42276.51,29875.57,21905.43,19906.8,16898.52]
[69,null,null,46508.560000000005,32869.54,24097.510000000002,21896.95,18598.23]
[70,null,null,57241.590000000004,40021.89,28362.95,25517.38,21872.04]
[71,null,null,59481.37,41595.46,29475.420000000002,26518.02,22731.7]
[72,null,null,61169.420000000006,42770.47,30312.82,27270.620000000003,23375.120000000003]
[73,null,null,63418.740000000005,44340.86,31427.41,28272.850000000002,24236.370000000003]
[74,null,null,64537.57,45124.200000000004,31983.91,28775.82,24665.140000000003]
[75,"o más",null,67348.69,47089.97,33377.279999999999,30022.91,25741.57]
[1,"Hijo",null,2457.61,1797.23,1348.3200000000002,1135.79,842.17000000000007]
[2,"Hijos",null,3906.63,2856.17,2139.61,1807.3000000000002,1335.6000000000001]
[3,"Hijos o más",null,5722.9400000000005,4183.29,3137.6000000000004,2646.29,1956.76]
[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"]
[" "," ","CL1","CL2","CL3","CL4","CL5","CL6"]
[18,"-  24",{"$f":"+C207*$L$2","v":0},0,0,0,0,0]
[25,"-  29",0,0,0,0,0,0]
[30,"-  34",0,0,0,0,0,0]
[35,"-  39",0,0,0,0,0,0]
[40,"-  44",0,0,0,0,0,0]
[45,"-  49",0,0,0,0,0,0]
[50,"-  54",0,0,0,0,0,0]
[55,"-  59",0,0,0,0,0,0]
[60,null,0,0,0,0,0,0]
[61,null,0,0,0,0,0,0]
[62,null,{"$f":"+C217*$L$2","v":0},0,0,0,0,0]
[63,null,0,0,0,0,0,0]
[64,null,0,0,0,0,0,0]
[65,null,0,0,0,0,0,0]
[66,null,0,0,0,0,0,0]
[67,null,0,0,0,0,0,0]
[68,null,0,0,0,0,0,0]
[69,null,0,0,0,0,0,0]
[70,null,0,0,0,0,0,0]
[71,null,0,0,0,0,0,0]
[72,null,{"$f":"+C227*$L$2","v":0},0,0,0,0,0]
[73,null,0,0,0,0,0,0]
[74,null,0,0,0,0,0,0]
[75,"o más",0,0,0,0,0,0]
[1,"Hijo",0,0,0,0,0,0]
[2,"Hijos",0,0,0,0,0,0]
[3,"Hijos o más",0,0,0,0,0,0]
[1,"Rider Comp. Maternidad",0,0,0,0,0,0]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["ADVANTAGE (WORLDWIDE)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6",null,2,3,4,5,6]
[18,"-  24",null,8896,6687,4881,3737,2960,null,true,true,true,true,true]
[25,"-  29",null,9892,7457,5417,4164,3276,null,true,true,true,true,true]
[30,"-  34",null,11445,8759,6445,4941,3806,null,true,true,true,true,true]
[35,"-  39",null,12701,9754,7165,5628,4227,null,true,true,true,true,true]
[40,"-  44",null,14325,11062,8120,6293,4780,null,true,true,true,true,true]
[45,"-  49",null,16643,12738,9164,7160,5558,null,true,true,true,true,true]
[50,"-  54",null,18234,14324,10680,8044,6106,null,true,true,true,true,true]
[55,"-  59",null,21549,16528,11819,9316,7216,null,true,true,true,true,true]
[60,null,null,23810,18304,12996,10279,7985,null,true,true,true,true,true]
[61,null,null,26786,20599,14623,11567,8993,null,true,true,true,true,true]
[62,null,null,29782,22899,16261,12864,9994,null,true,true,true,true,true]
[63,null,null,32767,25189,17885,14158,11004,null,true,true,true,true,true]
[64,null,null,35747,27491,19521,15446,12008,null,true,true,true,true,true]
[65,null,null,38640,29923,21277,16825,13666,null,true,true,true,true,true]
[66,null,null,40927,31680,22533,17819,14478,null,true,true,true,true,true]
[67,null,null,45481,35213,25048,19805,16087,null,true,true,true,true,true]
[68,null,null,50032,38736,27551,21791,17708,null,true,true,true,true,true]
[69,null,null,52316,40497,28807,22787,18512,null,true,true,true,true,true]
[70,null,null,52989,41143,29240,23220,18755,null,true,true,true,true,true]
[71,null,null,59613,46297,32916,26136,21107,null,true,true,true,true,true]
[72,null,null,66250,51443,36580,29039,23452,null,true,true,true,true,true]
[73,null,null,72892,56597,40233,31944,25816,null,true,true,true,true,true]
[74,null,null,79517,61753,43906,34855,28160,null,true,true,true,true,true]
[75,"o más",null,86986,68869,50360,38160,32318,null,true,true,true,true,true]
[1,"Hijo",null,3965,2821,2133,1883,1360,null,true,true,true,true,true]
[2,"Hijos",null,6453,4453,3352,2973,1999,null,true,true,true,true,true]
[3,"Hijos o más",null,9437,6489,4890,4311,3033,null,true,true,true,true,true]
[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"]
[18,"-  24",null,{"$f":"$L$2*D274","v":4714.88},{"$f":"$L$2*E274","v":3544.11},2586.9300000000003,1980.6100000000001,1568.8000000000002]
[25,"-  29",null,{"$f":"$L$2*D275","v":5242.76},{"$f":"$L$2*E275","v":3952.21},2871.01,2206.92,1736.2800000000002]
[30,"-  34",null,6065.85,4642.2700000000004,3415.8500000000004,2618.73,2017.18]
[35,"-  39",null,6731.5300000000007,5169.62,3797.4500000000003,2982.84,2240.31]
[40,"-  44",null,7592.25,5862.8600000000006,4303.6000000000004,3335.29,2533.4]
[45,"-  49",null,8820.7900000000009,6751.14,4856.92,3794.8,2945.7400000000002]
[50,"-  54",null,9664.02,7591.72,5660.4000000000005,4263.3200000000006,3236.1800000000003]
[55,"-  59",null,11420.970000000001,8759.84,6264.0700000000006,4937.4800000000005,3824.48]
[60,null,null,12619.300000000001,9701.1200000000008,6887.88,5447.87,4232.05]
[61,null,null,14196.58,10917.470000000001,7750.1900000000005,6130.51,4766.29]
[62,null,null,15784.460000000001,12136.470000000001,8618.33,6817.92,5296.8200000000006]
[63,null,null,17366.510000000002,13350.17,9479.0500000000011,7503.7400000000007,5832.12]
[64,null,null,18945.91,14570.230000000001,10346.130000000001,8186.38,6364.2400000000007]
[65,null,null,20479.2,15859.19,11276.810000000001,8917.25,7242.9800000000005]
[66,null,null,21691.31,16790.400000000001,11942.49,9444.07,7673.34]
[67,null,null,24104.93,18662.89,13275.44,10496.65,8526.11]
[68,null,null,26516.960000000003,20530.080000000002,14602.03,11549.230000000001,9385.24]
[69,null,null,27727.480000000003,21463.41,15267.710000000001,12077.11,9811.36]
[70,null,null,28084.170000000002,21805.79,15497.2,12306.6,9940.15]
[71,null,null,31594.890000000003,24537.41,17445.48,13852.08,11186.710000000001]
[72,null,null,35112.5,27264.79,{"$f":"$L$2*F294","v":19387.400000000001},15390.67,12429.560000000001]
[73,null,null,38632.76,29996.41,21323.49,16930.32,13682.480000000001]
[74,null,null,42144.01,32729.09,23270.18,18473.150000000001,14924.800000000001]
[75,"o más",null,46102.58,36500.57,26690.800000000003,20224.8,17128.54]
[1,"Hijo",null,2101.4500000000003,1495.13,1130.49,997.99,720.80000000000007]
[2,"Hijos",null,3420.09,2360.09,1776.5600000000002,1575.69,1059.47]
[3,"Hijos o más",null,5001.6100000000006,3439.17,2591.7000000000003,2284.83,1607.49]
[1,"Rider Comp. Maternidad",null,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"]
[" "," ","AL1","AL2","AL3","AL4","AL5","AL6",null,2,3,4,5,6]
[18,"-  24",null,6886,5165,3755,2876,2271,null,true,true,true,true,true]
[25,"-  29",null,7658,5768,4186,3214,2525,null,true,true,true,true,true]
[30,"-  34",null,8870,6779,4995,3816,2936,null,true,true,true,true,true]
[35,"-  39",null,9840,7559,5558,4354,3261,null,true,true,true,true,true]
[40,"-  44",null,11108,8574,6302,4872,3692,null,true,true,true,true,true]
[45,"-  49",null,12907,9879,7109,5543,4299,null,true,true,true,true,true]
[50,"-  54",null,14150,11108,8283,6232,4721,null,true,true,true,true,true]
[55,"-  59",null,16727,12831,9168,7219,5584,null,true,true,true,true,true]
[60,null,null,18481,14197,10085,7973,6186,null,true,true,true,true,true]
[61,null,null,20799,15989,11355,8981,6976,null,true,true,true,true,true]
[62,null,null,23129,17781,12628,9991,7750,null,true,true,true,true,true]
[63,null,null,25445,19562,13902,10993,8533,null,true,true,true,true,true]
[64,null,null,27781,21354,15171,11992,9320,null,true,true,true,true,true]
[65,null,null,30021,23235,16543,13070,10615,null,true,true,true,true,true]
[66,null,null,31799,24608,17517,13845,11239,null,true,true,true,true,true]
[67,null,null,35342,27356,19475,15393,12499,null,true,true,true,true,true]
[68,null,null,38882,30101,21424,16934,13756,null,true,true,true,true,true]
[69,null,null,40660,31467,22405,17711,14386,null,true,true,true,true,true]
[70,null,null,41182,31972,22742,18049,14578,null,true,true,true,true,true]
[71,null,null,46341,35983,25594,20315,16405,null,true,true,true,true,true]
[72,null,null,51501,39981,28455,22586,18234,null,true,true,true,true,true]
[73,null,null,56667,43994,31303,24847,20070,null,true,true,true,true,true]
[74,null,null,61819,48003,34154,27109,21901,null,true,true,true,true,true]
[75,"o más",null,67625,53536,39187,29682,25132,null,true,true,true,true,true]
[1,"Hijo",null,3085,2200,1655,1470,1063,null,true,true,true,true,true]
[2,"Hijos",null,5014,3471,2615,2321,1555,null,true,true,true,true,true]
[3,"Hijos o más",null,7344,5056,3806,3368,2366,null,true,true,true,true,true]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","AL1","AL2","AL3","AL4","AL5","AL6"]
[18,"-  24",{"$f":"+C341*$L$2","v":0},{"$f":"$L$2*D341","v":3649.5800000000004},{"$f":"$L$2*E341","v":2737.4500000000003},1990.15,1524.28,1203.6300000000001]
[25,"-  29",0,{"$f":"$L$2*D342","v":4058.7400000000002},3057.04,2218.58,1703.42,1338.25]
[30,"-  34",0,4701.1000000000004,3592.8700000000003,2647.35,2022.48,1556.0800000000002]
[35,"-  39",0,5215.2,4006.27,2945.7400000000002,2307.62,1728.3300000000002]
[40,"-  44",0,5887.2400000000007,4544.22,3340.06,2582.1600000000003,1956.76]
[45,"-  49",0,6840.71,5235.87,3767.77,2937.79,2278.4700000000003]
[50,"-  54",0,7499.5,5887.2400000000007,4389.99,3302.96,2502.13]
[55,"-  59",0,8865.3100000000013,6800.43,4859.04,3826.07,2959.52]
[60,null,0,9794.93,7524.4100000000008,5345.05,4225.6900000000005,3278.5800000000004]
[61,null,0,11023.470000000001,8474.17,6018.1500000000005,4759.93,3697.28]
[62,null,{"$f":"+C351*$L$2","v":0},12258.37,9423.93,6692.84,5295.2300000000005,4107.5]
[63,null,0,13485.85,10367.86,7368.06,5826.29,{"$f":"$L$2*H352","v":4522.49}]
[64,null,0,14723.93,11317.62,8040.63,6355.76,4939.6000000000004]
[65,null,0,15911.130000000001,12314.550000000001,8767.7900000000009,6927.1,5625.9500000000007]
[66,null,0,16853.47,13042.24,9284.01,7337.85,5956.67]
[67,null,0,18731.260000000002,14498.68,10321.75,8158.29,6624.47]
[68,null,0,20607.460000000003,15953.53,11354.720000000001,8975.02,7290.68]
[69,null,0,21549.8,16677.510000000002,11874.650000000001,9386.83,7624.5800000000008]
[70,null,0,21826.460000000003,16945.16,12053.26,9565.9700000000012,7726.34]
[71,null,0,24560.73,19070.990000000002,13564.820000000002,10766.95,8694.65]
[72,null,{"$f":"+C361*$L$2","v":0},27295.530000000002,21189.93,15081.150000000001,11970.58,9664.02]
[73,null,0,30033.510000000002,23316.82,16590.59,13168.91,10637.1]
[74,null,0,32764.070000000003,25441.59,18101.620000000003,14367.77,11607.53]
[75,"o más",0,35841.25,28374.080000000002,20769.11,15731.460000000001,13319.960000000001]
[1,"Hijo",0,1635.0500000000002,1166,877.15000000000009,779.1,563.39]
[2,"Hijos",0,2657.42,1839.63,1385.95,1230.1300000000001,824.15000000000009]
[3,"Hijos o más",0,3892.32,2679.6800000000003,2017.18,1785.0400000000002,1253.98]
[1,"Rider Comp. Maternidad",0,0,0,0,0,0]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["SECURE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6",null,2,3,4,5,6]
[18,"-  24",null,7091,5563,4070,3432,2615,null,true,true,true,true,true]
[25,"-  29",null,7813,6263,4538,3832,2897,null,true,true,true,true,true]
[30,"-  34",null,8958,7366,5280,4449,3354,null,true,true,true,true,true]
[35,"-  39",null,9879,8251,5870,4934,3721,null,true,true,true,true,true]
[40,"-  44",null,11070,9405,6637,5593,4204,null,true,true,true,true,true]
[45,"-  49",null,12755,11023,7725,6493,4879,null,true,true,true,true,true]
[50,"-  54",null,13910,12139,8474,7129,5337,null,true,true,true,true,true]
[55,"-  59",null,16346,14503,10040,8444,6317,null,true,true,true,true,true]
[60,null,null,17105,15484,10631,8939,6686,null,true,true,true,true,true]
[61,null,null,19253,17431,11964,10061,7532,null,true,true,true,true,true]
[62,null,null,21402,19383,13311,11193,8380,null,true,true,true,true,true]
[63,null,null,23554,21329,14649,12320,9215,null,true,true,true,true,true]
[64,null,null,25710,23278,15996,13452,10073,null,true,true,true,true,true]
[65,null,null,25734,23493,16082,13517,10108,null,true,true,true,true,true]
[66,null,null,25759,23710,16174,13591,10141,null,true,true,true,true,true]
[67,null,null,28638,26357,17986,15108,11279,null,true,true,true,true,true]
[68,null,null,31511,29011,19795,16625,12410,null,true,true,true,true,true]
[69,null,null,32943,30325,20691,17393,12980,null,true,true,true,true,true]
[70,null,null,33004,30832,20910,17551,13045,null,true,true,true,true,true]
[71,null,null,37141,34688,23535,19760,14687,null,true,true,true,true,true]
[72,null,null,41282,38561,26154,21959,16330,null,true,true,true,true,true]
[73,null,null,45418,42421,28778,24169,17971,null,true,true,true,true,true]
[74,null,null,49562,46288,31402,26375,19607,null,true,true,true,true,true]
[75,"o más",null,54009,50776,34342,28846,21427,null,true,true,true,true,true]
[1,"Hijo",null,3419,2017,1644,1376,1015,null,true,true,true,true,true]
[2,"Hijos",null,5774,3006,2587,2168,1619,null,true,true,true,true,true]
[3,"Hijos o más",null,8481,4323,3755,3149,2337,null,true,true,true,true,true]
[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"]
[18,"-  24",null,{"$f":"$L$2*D408","v":3758.23},{"$f":"$L$2*E408","v":2948.3900000000003},2157.1,1818.96,1385.95]
[25,"-  29",null,{"$f":"$L$2*D409","v":4140.8900000000003},3319.3900000000003,2405.1400000000003,2030.96,1535.41]
[30,"-  34",null,4747.7400000000007,3903.98,2798.4,2357.9700000000003,1777.6200000000001]
[35,"-  39",null,5235.87,4373.0300000000007,3111.1000000000004,2615.02,1972.13]
[40,"-  44",null,5867.1,4984.6500000000005,3517.61,2964.29,2228.12]
[45,"-  49",null,6760.1500000000005,5842.1900000000005,4094.25,3441.29,2585.8700000000003]
[50,"-  54",null,7372.3,6433.67,4491.22,3778.3700000000003,2828.61]
[55,"-  59",null,8663.380000000001,7686.59,5321.2,4475.3200000000006,3348.01]
[60,null,null,9065.65,8206.52,5634.43,4737.67,3543.5800000000004]
[61,null,null,10204.09,9238.43,6340.92,5332.33,3991.96]
[62,null,null,11343.060000000001,10272.99,7054.83,5932.29,4441.4000000000005]
[63,null,null,12483.62,11304.37,7763.97,6529.6,4883.95]
[64,null,null,13626.300000000001,12337.34,8477.880000000001,7129.56,5338.6900000000005]
[65,null,null,13639.02,12451.29,8523.4600000000009,7164.01,5357.2400000000007]
[66,null,null,13652.27,12566.300000000001,8572.2200000000012,7203.2300000000005,5374.7300000000005]
[67,null,null,15178.140000000001,13969.210000000001,9532.58,8007.2400000000007,5977.87]
[68,null,null,16700.830000000002,15375.83,10491.35,8811.25,6577.3]
[69,null,null,17459.79,16072.25,10966.230000000001,9218.2900000000009,6879.4000000000005]
[70,null,null,17492.120000000003,16340.960000000001,11082.300000000001,9302.0300000000007,6913.85]
[71,null,null,19684.73,18384.64,12473.550000000001,10472.800000000001,7784.1100000000006]
[72,null,null,21879.460000000003,20437.330000000002,13861.62,11638.27,8654.9]
[73,null,null,24071.54,{"$f":"$L$2*E429","v":22483.13},15252.34,12809.570000000002,9524.630000000001]
[74,null,null,26267.86,24532.639999999999,16643.060000000001,13978.75,10391.710000000001]
[75,"o más",null,28624.77,26911.280000000002,18201.260000000002,15288.380000000001,11356.310000000001]
[1,"Hijo",null,1812.0700000000002,1069.01,871.32,729.28000000000009,537.95000000000005]
[2,"Hijos",null,3060.2200000000003,1593.18,1371.1100000000001,1149.04,858.07]
[3,"Hijos o más",null,4494.93,2291.19,1990.15,1668.97,{"$f":"$L$2*H434","v":1238.6100000000001}]
[1,"Rider Comp. Maternidad",null,119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,159,159,159,159,159]
[]
["ESSENTIAL"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"ET2","ET3","ET4","ET5","ET6",null,2,3,4,5,6]
[18,"-  24",null,5856,4337,3367,2831,2145,null,true,true,true,true,true]
[25,"-  29",null,6462,4918,3755,3160,2389,null,true,true,true,true,true]
[30,"-  34",null,7397,5825,4360,3668,2769,null,true,true,true,true,true]
[35,"-  39",null,8158,6558,4844,4085,3067,null,true,true,true,true,true]
[40,"-  44",null,9157,7518,5480,4612,3468,null,true,true,true,true,true]
[45,"-  49",null,10538,8861,6388,5370,4027,null,true,true,true,true,true]
[50,"-  54",null,11504,9785,7003,5888,4414,null,true,true,true,true,true]
[55,"-  59",null,13529,11734,8307,6985,5226,null,true,true,true,true,true]
[60,null,null,14155,12556,8799,7392,5525,null,true,true,true,true,true]
[61,null,null,15936,14168,9903,8320,6228,null,true,true,true,true,true]
[62,null,null,17717,15787,11019,9261,6925,null,true,true,true,true,true]
[63,null,null,19498,17400,12123,10195,7620,null,true,true,true,true,true]
[64,null,null,21278,19006,13242,11131,8331,null,true,true,true,true,true]
[65,null,null,21303,19192,13317,11189,8365,null,true,true,true,true,true]
[66,null,null,21325,19374,13390,11251,8386,null,true,true,true,true,true]
[67,null,null,23708,21571,14892,12500,9332,null,true,true,true,true,true]
[68,null,null,26087,23759,16382,13764,10268,null,true,true,true,true,true]
[69,null,null,27270,24852,17138,14394,10738,null,true,true,true,true,true]
[70,null,null,27334,25268,17316,14535,10803,null,true,true,true,true,true]
[71,null,null,30751,28466,19491,16359,12152,null,true,true,true,true,true]
[72,null,null,34178,31679,21661,18186,13519,null,true,true,true,true,true]
[73,null,null,37619,34877,23831,20005,14875,null,true,true,true,true,true]
[74,null,null,41044,38084,26009,21839,16237,null,true,true,true,true,true]
[75,"o más",null,44726,41796,28442,23883,17738,null,true,true,true,true,true]
[1,"Hijo",null,2830,1674,1367,1144,843,null,true,true,true,true,true]
[2,"Hijos",null,4783,2493,2142,1794,1346,null,true,true,true,true,true]
[3,"Hijos o más",null,7021,3577,3119,2611,1932,null,true,true,true,true,true]
[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"]
[18,"-  24",null,{"$f":"$L$2*D475","v":3103.6800000000003},{"$f":"$L$2*E475","v":2298.61},1784.51,1500.43,1136.8500000000001]
[25,"-  29",null,{"$f":"$L$2*D476","v":3424.86},2606.54,1990.15,1674.8000000000002,1266.17]
[30,"-  34",null,3920.4100000000003,3087.25,2310.8000000000002,1944.0400000000002,1467.5700000000002]
[35,"-  39",null,4323.74,3475.7400000000002,2567.3200000000002,2165.0500000000002,1625.51]
[40,"-  44",null,4853.21,3984.5400000000004,2904.4,2444.36,1838.0400000000002]
[45,"-  49",null,5585.14,4696.33,3385.6400000000003,2846.1000000000004,2134.31]
[50,"-  54",null,6097.12,5186.05,3711.59,3120.6400000000003,2339.42]
[55,"-  59",null,7170.3700000000008,6219.02,4402.71,3702.05,2769.78]
[60,null,null,7502.1500000000005,6654.68,4663.47,3917.76,2928.25]
[61,null,null,8446.08,7509.04,5248.59,4409.6000000000004,3300.84]
[62,null,null,9390.01,8367.11,5840.0700000000006,4908.33,3670.25]
[63,null,null,10333.94,9222,6425.1900000000005,5403.35,4038.6000000000004]
[64,null,null,11277.34,10073.18,7018.26,5899.43,4415.43]
[65,null,null,11290.59,10171.76,7058.01,5930.17,4433.45]
[66,null,null,11302.25,10268.220000000001,7096.7000000000007,5963.0300000000007,4444.58]
[67,null,null,12565.24,11432.630000000001,7892.76,6625,4945.96]
[68,null,null,13826.11,12592.27,8682.4600000000009,7294.92,5442.04]
[69,null,null,14453.1,13171.560000000001,9083.1400000000012,7628.8200000000006,5691.14]
[70,null,null,14487.02,13392.04,9177.48,7703.55,5725.59]
[71,null,null,16298.03,15086.980000000001,10330.230000000001,8670.27,6440.56]
[72,null,null,18114.34,16789.870000000003,11480.33,9638.58,7165.0700000000006]
[73,null,null,19938.07,18484.810000000001,12630.43,10602.65,7883.75]
[74,null,null,21753.32,20184.52,13784.77,11574.67,8605.61]
[75,"o más",null,23704.780000000002,22151.88,15074.26,12657.99,9401.1400000000012]
[1,"Hijo",null,1499.9,887.22,724.51,606.32000000000005,446.79]
[2,"Hijos",null,2534.9900000000002,1321.29,1135.26,950.82,713.38]
[3,"Hijos o más",null,3721.13,1895.8100000000002,1653.0700000000002,1383.8300000000002,1023.96]
[1,"Rider Comp. Maternidad",null,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",4055,7396,10748,3526,6298,9060,2963,5364,7761,2267,4067,5864,1602,2824,4050,888,1506,2119]
[50,"o más",5224,8560,11904,4537,7301,10062,3801,6193,8601,2908,4704,6500,2034,3247,4476,1096,1721,2325]
[]
["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":2149.15},{"$f":"+D543*$L$2","v":3919.88},5696.4400000000005,1868.7800000000002,3337.94,4801.8,1570.39,2842.92,4113.33,1201.51,2155.5100000000002,3107.92,849.06000000000006,1496.72,2146.5,470.64000000000004,798.18000000000006,1123.0700000000002]
[75,"o más",{"$f":"+C544*$L$2","v":2768.7200000000003},4536.8,6309.12,2404.61,3869.53,5332.8600000000006,2014.5300000000002,3282.29,4558.5300000000007,1541.24,2493.1200000000003,3445,1078.02,1720.91,2372.2800000000002,580.88,912.13,1232.25]
[]
[]
[]
[null,null,1,null,null,2,null,null,3,null,null,4,null,null,5,null,null,6]
[null,null,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true]
[null,null,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true]