{"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":9,"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 : ",2,null,"Número de hijos en la póliza :",1]
[]
[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":[[48,0,49,1],[48,2,49,3],[34,0,34,1],[45,0,45,1],[40,0,40,1],[41,0,41,1],[45,2,45,3],[43,0,43,1],[44,0,44,1],[42,0,42,1],[47,0,47,1],[47,2,47,3],[35,0,35,1],[36,0,38,1],[36,2,38,3],[46,0,46,1],[19,0,19,1],[26,0,26,1],[21,2,21,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[25,0,25,1],[26,2,26,3],[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],[28,2,28,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],[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],[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]]}
[]
[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":2},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-05T09:31:55.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":13749},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":9094},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":6396},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":4547},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":3582}]
[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":13749},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,5,TRUE)))","v":9094},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,6,TRUE)))","v":6396},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,7,TRUE)))","v":4547},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,8,TRUE)))","v":3582}]
[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":4773},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":3513},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":2847},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":2396},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":1875}]
[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":32271},{"$f":"SUM(J31:J34)","v":21701},{"$f":"SUM(K31:K34)","v":15864},{"$f":"SUM(L31:L34)","v":11715},{"$f":"SUM(M31:M34)","v":9264}]
[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":32346},{"$f":"SUM(J35:J36)","v":21776},{"$f":"SUM(K35:K36)","v":15939},{"$f":"SUM(L35:L36)","v":11790},{"$f":"SUM(M35:M36)","v":9339}]
[]
[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":7286.97},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":4819.8200000000006},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":3389.88},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":2409.9100000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":1898.46}]
[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":7286.97},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,5,TRUE)))","v":4819.8200000000006},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,6,TRUE)))","v":3389.88},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,7,TRUE)))","v":2409.9100000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,8,TRUE)))","v":1898.46}]
[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":2529.69},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":1861.89},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":1508.91},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":1269.8800000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":993.75}]
[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":17103.63},{"$f":"SUM(J40:J43)","v":11501.53},{"$f":"SUM(K40:K43)","v":8407.92},{"$f":"SUM(L40:L43)","v":6208.9500000000007},{"$f":"SUM(M40:M43)","v":4909.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(I44:I45)","v":17178.63},{"$f":"SUM(J44:J45)","v":11576.53},{"$f":"SUM(K44:K45)","v":8482.92},{"$f":"SUM(L44:L45)","v":6283.9500000000007},{"$f":"SUM(M44:M45)","v":4984.92}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":17103.63},{"$f":"J44","v":11501.53},8407.92,6208.9500000000007,4909.92]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2022"]
[]
[]
[]
[null," "]
[null," "]

{"sheet":"Privilege","index":2,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[33,0,33,1],[34,0,34,1],[29,0,29,1],[41,2,41,3],[37,0,37,1],[38,0,38,1],[34,2,34,3],[39,0,39,1],[40,0,40,1],[41,0,41,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,2,29,3],[32,0,32,1],[19,0,19,1],[17,0,18,1],[20,0,21,1],[46,0,47,1],[20,2,20,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[25,0,25,1],[27,2,27,3],[28,2,28,3],[22,2,22,3],[31,2,31,3],[26,2,26,3],[32,2,32,3],[26,0,26,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],[36,0,36,1],[42,2,42,3],[36,2,36,3],[43,0,43,1],[43,2,43,3],[39,2,39,3],[40,2,40,3],[37,2,37,3],[38,2,38,3],[42,0,42,1],[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],[9,0,9,12],[11,7,11,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]]}
[]
[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":2},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-05T09:31:55.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":11561},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":7943},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":5554},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":3934},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":2997}]
[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":11561},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,5,TRUE)))","v":7943},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,6,TRUE)))","v":5554},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,7,TRUE)))","v":3934},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,8,TRUE)))","v":2997}]
[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":4014},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":2933},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":2254},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":1900},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":1404}]
[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":27136},{"$f":"SUM(J31:J34)","v":18819},{"$f":"SUM(K31:K34)","v":13587},{"$f":"SUM(L31:L34)","v":9993},{"$f":"SUM(M31:M34)","v":7623}]
[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":27211},{"$f":"SUM(J35:J36)","v":18894},{"$f":"SUM(K35:K36)","v":13662},{"$f":"SUM(L35:L36)","v":10068},{"$f":"SUM(M35:M36)","v":7698}]
[]
[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":6127.33},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":4209.79},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":2943.6200000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":2085.02},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":1588.41}]
[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":6127.33},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,5,TRUE)))","v":4209.79},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,6,TRUE)))","v":2943.6200000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,7,TRUE)))","v":2085.02},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,8,TRUE)))","v":1588.41}]
[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":2127.42},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":1554.49},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":1194.6200000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":1007},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":744.12}]
[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":14382.08},{"$f":"SUM(J40:J43)","v":9974.07},{"$f":"SUM(K40:K43)","v":7201.1100000000006},{"$f":"SUM(L40:L43)","v":5296.29},{"$f":"SUM(M40:M43)","v":4040.19}]
[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":14457.08},{"$f":"SUM(J44:J45)","v":10049.07},{"$f":"SUM(K44:K45)","v":7276.1100000000006},{"$f":"SUM(L44:L45)","v":5371.29},{"$f":"SUM(M44:M45)","v":4115.1900000000005}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":14382.08},{"$f":"J44","v":9974.07},7201.1100000000006,5296.29,4040.19]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2022"]
[]
[null," "]
[null," "]

{"sheet":"Advantage (Mundial)","index":3,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[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],[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],[22,2,22,3],[20,2,20,3],[50,5,52,12],[50,2,50,3],[46,2,46,3],[44,2,44,3],[51,2,52,3],[25,2,25,3],[23,2,23,3],[54,0,54,1],[54,2,54,3],[53,0,53,1],[53,2,53,3],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[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]]}
[]
[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":2},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-05T09:31:55.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":7695},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":5787},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":4326},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":3324},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":2636}]
[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":7695},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,5,TRUE)))","v":5787},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,6,TRUE)))","v":4326},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,7,TRUE)))","v":3324},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,8,TRUE)))","v":2636}]
[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":3428},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":2438},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":1887},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":1668},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":1205}]
[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":19118},14312,10839,8616,6777]
[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":19193},{"$f":"SUM(J36:J37)","v":14387},{"$f":"SUM(K36:K37)","v":10914},{"$f":"SUM(L36:L37)","v":8691},{"$f":"SUM(M36:M37)","v":6852}]
[]
[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":4078.3500000000004},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":3067.11},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":2292.7800000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":1761.72},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":1397.0800000000002}]
[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":4078.3500000000004},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,5,TRUE)))","v":3067.11},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,6,TRUE)))","v":2292.7800000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,7,TRUE)))","v":1761.72},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,8,TRUE)))","v":1397.0800000000002}]
[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":1816.8400000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":1292.1400000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":1000.11},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":884.04000000000008},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":638.65}]
[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":10132.540000000001},7585.3600000000006,5744.67,4566.4800000000005,3591.8100000000004]
[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":10207.540000000001},{"$f":"SUM(J46:J47)","v":7660.3600000000006},{"$f":"SUM(K46:K47)","v":5819.67},{"$f":"SUM(L46:L47)","v":4641.4800000000005},{"$f":"SUM(M46:M47)","v":3666.8100000000004}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":10132.540000000001},{"$f":"J46","v":7585.3600000000006},5744.67,4566.4800000000005,3591.8100000000004]
[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":true,"merged":[[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
["Bupa Advantage Care (cobertura solo en Latinoamérica)",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
["Cobertura Máxima anual",null,"US $ 3,500,000"]
["Cobertura Geografica",null,"Limitada a Latinoamérica excluyendo México",null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"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":2},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":"2021-11-05T09:31:55.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":5956},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":4467},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":3344},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":2559},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":2021}]
[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":5956},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,5,TRUE)))","v":4467},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,6,TRUE)))","v":3344},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,7,TRUE)))","v":2559},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,8,TRUE)))","v":2021}]
["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":2662},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":1896},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":1468},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":1304},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":940}]
["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":14574},10830,8156,6422,4982]
["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":14649},{"$f":"SUM(J36:J37)","v":10905},{"$f":"SUM(K36:K37)","v":8231},{"$f":"SUM(L36:L37)","v":6497},{"$f":"SUM(M36:M37)","v":5057}]
["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":3156.6800000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":2367.5100000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":1772.3200000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":1356.27},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":1071.1300000000001}]
["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":3156.6800000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,5,TRUE)))","v":2367.5100000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,6,TRUE)))","v":1772.3200000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,7,TRUE)))","v":1356.27},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,8,TRUE)))","v":1071.1300000000001}]
["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":1410.8600000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":1004.88},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":778.04000000000008},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":691.12},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":498.20000000000005}]
["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":7724.2200000000012},5739.9000000000005,4322.68,3403.66,2640.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(I46:I47)","v":7799.2200000000012},{"$f":"SUM(J46:J47)","v":5814.9000000000005},{"$f":"SUM(K46:K47)","v":4397.68},{"$f":"SUM(L46:L47)","v":3478.66},{"$f":"SUM(M46:M47)","v":2715.46}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":7724.2200000000012},{"$f":"J46","v":5739.9000000000005},4322.68,3403.66,2640.46]
[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":[[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":2},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-05T09:31:55.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":5940},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":4658},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":3503},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":3029},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":2306}]
[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":5940},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,5,TRUE)))","v":4658},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,6,TRUE)))","v":3503},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,7,TRUE)))","v":3029},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,8,TRUE)))","v":2306}]
[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":2867},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":1688},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":1410},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":1215},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":897}]
[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":15272},11529,8941,7798,6034]
[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":15347},{"$f":"SUM(J36:J37)","v":11604},{"$f":"SUM(K36:K37)","v":9016},{"$f":"SUM(L36:L37)","v":7873},{"$f":"SUM(M36:M37)","v":6109}]
[]
[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":3148.2000000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":2468.7400000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":1856.5900000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":1605.3700000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":1222.18}]
[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":3148.2000000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,5,TRUE)))","v":2468.7400000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,6,TRUE)))","v":1856.5900000000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,7,TRUE)))","v":1605.3700000000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,8,TRUE)))","v":1222.18}]
[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":1519.51},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":894.6400000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":747.30000000000007},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":643.95000000000005},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":475.41}]
[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":8094.1600000000008},6110.3700000000008,4738.7300000000005,4132.9400000000005,3198.02]
[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":8169.1600000000008},{"$f":"SUM(J46:J47)","v":6185.3700000000008},{"$f":"SUM(K46:K47)","v":4813.7300000000005},{"$f":"SUM(L46:L47)","v":4207.9400000000005},{"$f":"SUM(M46:M47)","v":3273.02}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":8094.1600000000008},{"$f":"J46","v":6110.3700000000008},4738.7300000000005,4132.9400000000005,3198.02]
[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":[[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],[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],[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],[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],[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":2},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-05T09:31:55.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,false,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,4,TRUE)","v":4013},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":3142},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":2366},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":2051},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":1552}]
[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":4013},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,5,TRUE)))","v":3142},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,6,TRUE)))","v":2366},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,7,TRUE)))","v":2051},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,8,TRUE)))","v":1552}]
[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":1949},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":1152},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":962},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":834},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":617}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$502)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$503)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":9975},7436,5694,4936,3721]
[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":10050},{"$f":"SUM(J36:J37)","v":7511},{"$f":"SUM(K36:K37)","v":5769},{"$f":"SUM(L36:L37)","v":5011},{"$f":"SUM(M36:M37)","v":3796}]
[]
[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":2126.8900000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":1665.26},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":1253.98},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":1087.03},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":822.56000000000006}]
[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":2126.8900000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,5,TRUE)))","v":1665.26},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,6,TRUE)))","v":1253.98},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,7,TRUE)))","v":1087.03},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,8,TRUE)))","v":822.56000000000006}]
[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":1032.97},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":610.56000000000006},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":509.86},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":442.02000000000004},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":327.01}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$535)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$536)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":5286.7500000000009},3941.08,3017.82,2616.08,1972.13]
[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":5361.7500000000009},{"$f":"SUM(J46:J47)","v":4016.08},{"$f":"SUM(K46:K47)","v":3092.82},{"$f":"SUM(L46:L47)","v":2691.08},{"$f":"SUM(M46:M47)","v":2047.13}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":5286.7500000000009},{"$f":"J46","v":3941.08},3017.82,2616.08,1972.13]
[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":52,"n_cols":13,"rows_kept":52,"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],[51,5,52,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":2},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-05T09:31:55.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":10823},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,8,TRUE)),0)","v":9134},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,11,TRUE)),0)","v":7828},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,14,TRUE)),0)","v":5919},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,17,TRUE)),0)","v":4094},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,20,TRUE)),0)","v":2142}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":10823},{"$f":"SUM(I44:I46)","v":9134},7828,5919,4094,2142]
[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":10898},9209,7903,5994,4169,2217]
[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":[[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],[39,0,40,7],[13,2,13,7],[15,2,15,7],[19,0,19,1],[18,0,18,1]]}
[]
[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":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2021-11-05T09:31:55.750"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":32346},{"$f":"+Exclusive!J37","v":21776},{"$f":"+Exclusive!K37","v":15939},{"$f":"+Exclusive!L37","v":11790},{"$f":"+Exclusive!M37","v":9339}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":27211},{"$f":"+Privilege!J37","v":18894},{"$f":"+Privilege!K37","v":13662},{"$f":"+Privilege!L37","v":10068},{"$f":"+Privilege!M37","v":7698}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":19193},{"$f":"+'Advantage (Mundial)'!J38","v":14387},{"$f":"+'Advantage (Mundial)'!K38","v":10914},{"$f":"+'Advantage (Mundial)'!L38","v":8691},{"$f":"+'Advantage (Mundial)'!M38","v":6852}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":15347},{"$f":"+Secure!J38","v":11604},{"$f":"+Secure!K38","v":9016},{"$f":"+Secure!L38","v":7873},{"$f":"+Secure!M38","v":6109}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":10050},{"$f":"+Essential!J38","v":7511},{"$f":"+Essential!K38","v":5769},{"$f":"+Essential!L38","v":5011},{"$f":"+Essential!M38","v":3796}]
[]
["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":10898},{"$f":"+Critical!I49","v":9209},{"$f":"+Critical!J49","v":7903},{"$f":"+Critical!K49","v":5994},{"$f":"+Critical!L49","v":4169},{"$f":"+Critical!M49","v":2217}]
["Tarifas en US $ -  Válidas desde 01 enero 2021"]
[]
["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":[[26,4,27,4],[26,5,27,5],[28,0,29,0],[30,0,31,0],[32,0,34,0],[32,1,34,1],[32,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[38,0,42,0],[25,0,27,0],[26,1,27,1],[26,2,27,2],[26,3,27,3],[47,0,48,0],[50,0,52,0],[1,1,3,6],[4,1,4,6],[10,0,12,0],[14,0,15,0],[16,0,17,0],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[32,6,34,6],[40,4,42,4],[40,5,42,5],[39,6,42,6],[18,0,20,0]]}
[]
[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":[[554,17,554,19],[554,2,554,4],[554,5,554,7],[554,8,554,10],[554,11,554,13],[554,14,554,16],[540,14,540,16],[540,17,540,19],[547,14,547,16],[547,17,547,19],[545,0,545,19],[540,2,540,4],[547,2,547,4],[547,5,547,7],[547,8,547,10],[546,0,546,1],[546,2,546,6],[540,5,540,7],[540,8,540,10],[547,11,547,13],[540,11,540,13],[539,0,539,1],[471,0,471,7],[472,0,472,1],[472,2,472,6],[504,0,504,7],[505,0,505,1],[505,2,505,6],[538,0,538,19],[537,0,537,19],[539,2,539,6],[304,2,304,6],[336,0,336,7],[437,0,437,7],[438,0,438,1],[438,2,438,6],[304,0,304,1],[370,0,370,7],[371,0,371,1],[371,2,371,6],[337,0,337,7],[338,0,338,1],[338,2,338,6],[470,0,470,7],[403,0,403,7],[404,0,404,7],[405,0,405,1],[405,2,405,6],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[303,0,303,7],[269,0,269,7],[270,0,270,7],[271,0,271,1],[271,2,271,6],[170,2,170,6],[202,0,202,7],[236,0,236,7],[237,0,237,1],[237,2,237,6],[204,0,204,1],[204,2,204,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6]]}
[]
["EXCLUSIVE",null,null,null,null,null,null,null,null,"FACTOR SEMESTRAL :",null,0.53]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6",null,1,2,3,4,5]
[18,"-  24",null,13749,9094,6396,4547,3582,null,true,true,true,true,true]
[25,"-  29",null,14421,10044,7083,5042,3966,null,true,true,true,true,true]
[30,"-  34",null,14996,10768,7930,6035,4761,null,true,true,true,true,true]
[35,"-  39",null,16794,12057,8884,6758,5331,null,true,true,true,true,true]
[40,"-  44",null,19463,13178,9856,7425,5855,null,true,true,true,true,true]
[45,"-  49",null,21760,14742,11008,8297,6540,null,true,true,true,true,true]
[50,"-  54",null,27844,19329,14370,11716,9244,null,true,true,true,true,true]
[55,"-  59",null,29621,20568,15285,12472,9842,null,true,true,true,true,true]
[60,null,null,32266,22439,17585,15015,12221,null,true,true,true,true,true]
[61,null,null,34666,24114,18879,16142,13126,null,true,true,true,true,true]
[62,null,null,37953,26399,20682,17661,14370,null,true,true,true,true,true]
[63,null,null,40350,28070,21980,18789,15279,null,true,true,true,true,true]
[64,null,null,43648,30374,23781,20316,16528,null,true,true,true,true,true]
[65,null,null,57047,39609,30063,27088,23306,null,true,true,true,true,true]
[66,null,null,66270,46018,34935,31482,27077,null,true,true,true,true,true]
[67,null,null,72393,50264,38153,34378,29566,null,true,true,true,true,true]
[68,null,null,80147,55650,42243,38078,32745,null,true,true,true,true,true]
[69,null,null,88193,61232,46475,41888,36027,null,true,true,true,true,true]
[70,null,null,108530,74553,54714,48808,42375,null,true,true,true,true,true]
[71,null,null,112791,77483,56858,50727,44033,null,true,true,true,true,true]
[72,null,null,115988,79668,58462,52160,45285,null,true,true,true,true,true]
[73,null,null,120246,82598,60614,54082,46950,null,true,true,true,true,true]
[74,null,null,122368,84054,61684,55032,47782,null,true,true,true,true,true]
[75,"o más",null,127702,87713,64368,57434,49859,null,true,true,true,true,true]
[1,"Hijo",null,4773,3513,2847,2396,1875,null,true,true,true,true,true]
[2,"Hijos",null,7581,5592,4528,3814,2963,null,true,true,true,true,true]
[3,"Hijos o más",null,11117,8184,6638,5586,4350,null,true,true,true,true,true]
[1,"Rider Comp. Maternidad",0,0,0,225,225,225]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",null,{"$f":"$L$2*D6","v":7286.97},{"$f":"$L$2*E6","v":4819.8200000000006},3389.88,2409.9100000000003,1898.46]
[25,"-  29",null,{"$f":"$L$2*D7","v":7643.13},{"$f":"$L$2*E7","v":5323.3200000000006},3753.9900000000002,2672.26,2101.98]
[30,"-  34",null,7947.88,{"$f":"$L$2*E8","v":5707.04},4202.9000000000005,3198.55,2523.33]
[35,"-  39",null,8900.82,{"$f":"$L$2*E9","v":6390.21},4708.5200000000004,3581.7400000000002,2825.4300000000003]
[40,"-  44",null,10315.390000000001,{"$f":"$L$2*E10","v":6984.34},5223.68,3935.25,3103.15]
[45,"-  49",null,11532.800000000001,{"$f":"$L$2*E11","v":7813.26},5834.2400000000007,4397.41,3466.2000000000003]
[50,"-  54",null,14757.320000000002,{"$f":"$L$2*E12","v":10244.370000000001},7616.1,6209.4800000000005,4899.3200000000006]
[55,"-  59",null,15699.130000000001,{"$f":"$L$2*E13","v":10901.04},8101.05,6610.1600000000008,5216.26]
[60,null,null,17100.98,{"$f":"$L$2*E14","v":11892.67},9320.0500000000011,7957.9500000000007,6477.13]
[61,null,null,18372.98,{"$f":"$L$2*E15","v":12780.42},10005.870000000001,8555.26,6956.7800000000007]
[62,null,null,20115.09,{"$f":"$L$2*E16","v":13991.470000000001},10961.460000000001,9360.33,7616.1]
[63,null,null,21385.5,{"$f":"$L$2*E17","v":14877.1},11649.400000000001,9958.17,8097.8700000000008]
[64,null,null,23133.440000000002,{"$f":"$L$2*E18","v":16098.220000000001},12603.93,10767.480000000001,8759.84]
[65,null,null,30234.91,{"$f":"$L$2*E19","v":20992.77},15933.390000000001,14356.640000000001,12352.18]
[66,null,null,35123.1,{"$f":"$L$2*E20","v":24389.54},18515.55,16685.46,14350.810000000001]
[67,null,null,38368.29,{"$f":"$L$2*E21","v":26639.920000000002},20221.09,18220.34,15669.980000000001]
[68,null,null,42477.91,{"$f":"$L$2*E22","v":29494.5},22388.79,20181.34,17354.850000000002]
[69,null,null,46742.29,{"$f":"$L$2*E23","v":32452.960000000003},24631.75,22200.639999999999,19094.310000000001]
[70,null,null,57520.9,{"$f":"$L$2*E24","v":39513.090000000004},28998.420000000002,25868.240000000002,22458.75]
[71,null,null,59779.23,{"$f":"$L$2*E25","v":41065.990000000005},30134.74,26885.31,23337.49]
[72,null,null,61473.640000000007,{"$f":"$L$2*E26","v":42224.04},30984.86,27644.800000000003,24001.050000000003]
[73,null,null,63730.380000000005,{"$f":"$L$2*E27","v":43776.94},32125.420000000002,28663.460000000003,24883.5]
[74,null,null,64855.040000000001,{"$f":"$L$2*E28","v":44548.62},32692.52,29166.960000000003,25324.460000000003]
[75,"o más",null,67682.06,{"$f":"$L$2*E29","v":46487.89},34115.040000000001,30440.02,26425.27]
[1,"Hijo",null,2529.69,{"$f":"$L$2*E30","v":1861.89},1508.91,1269.8800000000001,993.75]
[2,"Hijos",null,4017.9300000000003,{"$f":"$L$2*E31","v":2963.76},2399.84,2021.42,1570.39]
[3,"Hijos o más",null,5892.01,{"$f":"$L$2*E32","v":4337.5200000000004},3518.1400000000003,2960.58,2305.5]
[1,"Rider Comp. Maternidad",{"$f":"+C33*$L$2","v":0},0,0,119.25,119.25,119.25]
[1,"Transplante de organos",0,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,1,2,3,4,5]
[18,"-  24",null,11561,7943,5554,3934,2997,null,true,true,true,true,true]
[25,"-  29",null,12132,8789,6153,4359,3326,null,true,true,true,true,true]
[30,"-  34",null,12672,9420,6894,5279,4026,null,true,true,true,true,true]
[35,"-  39",null,14190,10542,7726,5914,4514,null,true,true,true,true,true]
[40,"-  44",null,16422,11549,8591,6520,4973,null,true,true,true,true,true]
[45,"-  49",null,18345,12905,9610,7280,5566,null,true,true,true,true,true]
[50,"-  54",null,23985,17018,12610,10395,7949,null,true,true,true,true,true]
[55,"-  59",null,25517,18108,13419,11061,8459,null,true,true,true,true,true]
[60,null,null,27788,19671,15269,13160,10563,null,true,true,true,true,true]
[61,null,null,29852,21125,16401,14134,11348,null,true,true,true,true,true]
[62,null,null,32679,23133,17964,15476,12430,null,true,true,true,true,true]
[63,null,null,34751,24593,19094,16456,13211,null,true,true,true,true,true]
[64,null,null,37581,26603,20652,17798,14303,null,true,true,true,true,true]
[65,null,null,49126,34701,26115,23729,20156,null,true,true,true,true,true]
[66,null,null,57069,40320,30340,27579,23423,null,true,true,true,true,true]
[67,null,null,62338,44039,33136,30119,25576,null,true,true,true,true,true]
[68,null,null,69030,48759,36702,33360,28323,null,true,true,true,true,true]
[69,null,null,75939,53643,40373,36696,31166,null,true,true,true,true,true]
[70,null,null,93461,65310,47517,42766,36654,null,true,true,true,true,true]
[71,null,null,97124,67874,49390,44440,38094,null,true,true,true,true,true]
[72,null,null,99868,69801,50783,45698,39173,null,true,true,true,true,true]
[73,null,null,103553,72362,52652,47373,40613,null,true,true,true,true,true]
[74,null,null,105381,73646,53580,48214,41328,null,true,true,true,true,true]
[75,"o más",null,109966,76844,55914,50316,43127,null,true,true,true,true,true]
[1,"Hijo",null,4014,2933,2254,1900,1404,null,true,true,true,true,true]
[2,"Hijos",null,6383,4667,3591,3026,2238,null,true,true,true,true,true]
[3,"Hijos o más",null,9345,6834,5259,4430,3282,null,true,true,true,true,true]
[1,"Rider Comp. Maternidad",0,0,0,225,225,225]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",{"$f":"+C140*$L$2","v":0},{"$f":"$L$2*D140","v":6127.33},{"$f":"$L$2*E140","v":4209.79},2943.6200000000003,2085.02,1588.41]
[25,"-  29",0,{"$f":"$L$2*D141","v":6429.96},4658.17,3261.09,2310.27,1762.7800000000002]
[30,"-  34",0,6716.1600000000008,4992.6000000000004,3653.82,2797.8700000000003,2133.7800000000002]
[35,"-  39",0,7520.7000000000007,5587.26,4094.78,3134.42,2392.42]
[40,"-  44",0,8703.66,6120.97,4553.2300000000005,3455.6000000000004,2635.69]
[45,"-  49",0,9722.85,6839.6500000000005,5093.3,3858.4,2949.98]
[50,"-  54",0,12712.050000000001,9019.5400000000009,6683.3,5509.35,4212.97]
[55,"-  59",0,13524.01,9597.24,7112.0700000000006,5862.33,4483.2700000000004]
[60,null,0,14727.640000000001,10425.630000000001,8092.5700000000006,{"$f":"$L$2*G148","v":6974.8},5598.39]
[61,null,0,15821.560000000001,11196.25,8692.5300000000007,7491.02,6014.4400000000005]
[62,null,{"$f":"+C150*$L$2","v":0},{"$f":"$L$2*D150","v":17319.870000000003},12260.49,9520.92,8202.2800000000007,6587.9000000000005]
[63,null,0,18418.030000000002,13034.29,10119.82,8721.68,7001.83]
[64,null,0,19917.93,14099.59,10945.560000000001,9432.94,7580.59]
[65,null,0,26036.780000000002,18391.530000000002,13840.95,12576.37,10682.68]
[66,null,0,30246.57,21369.600000000002,16080.2,14616.87,12414.19]
[67,null,0,33039.14,23340.670000000002,17562.080000000002,15963.070000000002,13555.28]
[68,null,0,36585.9,25842.27,19452.060000000001,17680.8,15011.19]
[69,null,0,40247.670000000006,28430.79,21397.690000000002,19448.88,16517.98]
[70,null,0,49534.33,34614.300000000003,25184.010000000002,22665.98,{"$f":"$L$2*H158","v":19426.620000000003}]
[71,null,0,51475.72,35973.22,26176.7,23553.200000000001,20189.82]
[72,null,{"$f":"+C160*$L$2","v":0},52930.04,36994.53,26914.99,24219.940000000002,20761.690000000002]
[73,null,0,54883.090000000004,38351.86,27905.56,25107.690000000002,21524.89]
[74,null,0,55851.93,39032.380000000005,28397.4,25553.420000000002,21903.84]
[75,"o más",0,58281.98,40727.32,29634.420000000002,26667.48,22857.31]
[1,"Hijo",0,2127.42,1554.49,1194.6200000000001,1007,744.12]
[2,"Hijos",0,3382.9900000000002,2473.5100000000002,1903.23,1603.78,1186.1400000000001]
[3,"Hijos o más",0,4952.8500000000004,3622.02,2787.27,2347.9,1739.46]
[1,"Rider Comp. Maternidad",0,0,0,119.25,119.25,119.25]
[1,"Transplante de organos",0,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,1,2,3,4,5]
[18,"-  24",null,7695,5787,4326,3324,2636,null,true,true,true,true,true]
[25,"-  29",null,8560,6458,4818,3706,2918,null,true,true,true,true,true]
[30,"-  34",null,9908,7584,5724,4389,3390,null,true,true,true,true,true]
[35,"-  39",null,10983,8444,6371,5006,3761,null,true,true,true,true,true]
[40,"-  44",null,12394,9570,7223,5595,4251,null,true,true,true,true,true]
[45,"-  49",null,14398,11020,8135,6362,4942,null,true,true,true,true,true]
[50,"-  54",null,15779,12390,9485,7148,5424,null,true,true,true,true,true]
[55,"-  59",null,18645,14298,10494,8274,6411,null,true,true,true,true,true]
[60,null,null,20594,15832,11541,9128,7089,null,true,true,true,true,true]
[61,null,null,23172,17816,12983,10276,7991,null,true,true,true,true,true]
[62,null,null,25758,19798,14429,11422,8873,null,true,true,true,true,true]
[63,null,null,28342,21788,15879,12569,9777,null,true,true,true,true,true]
[64,null,null,30920,23770,17333,13718,10664,null,true,true,true,true,true]
[65,null,null,33420,25864,18884,14940,12137,null,true,true,true,true,true]
[66,null,null,35399,27401,20004,15826,12858,null,true,true,true,true,true]
[67,null,null,39340,30442,22233,17588,14290,null,true,true,true,true,true]
[68,null,null,43274,33495,24453,19348,15716,null,true,true,true,true,true]
[69,null,null,45252,35016,25572,20229,16439,null,true,true,true,true,true]
[70,null,null,45831,35574,25959,20619,16659,null,true,true,true,true,true]
[71,null,null,51575,40026,29214,23199,18738,null,true,true,true,true,true]
[72,null,null,57306,44487,32463,25780,20826,null,true,true,true,true,true]
[73,null,null,63039,48932,35712,28366,22914,null,true,true,true,true,true]
[74,null,null,68780,53388,38970,30948,25004,null,true,true,true,true,true]
[75,"o más",null,75234,59546,44693,33872,28691,null,true,true,true,true,true]
[1,"Hijo",null,3428,2438,1887,1668,1205,null,true,true,true,true,true]
[2,"Hijos",null,5578,3849,2987,2639,1773,null,true,true,true,true,true]
[3,"Hijos o más",null,8162,5612,4341,3836,2697,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":4078.3500000000004},{"$f":"$L$2*E274","v":3067.11},2292.7800000000002,1761.72,1397.0800000000002]
[25,"-  29",null,{"$f":"$L$2*D275","v":4536.8},3422.7400000000002,2553.54,1964.18,1546.5400000000002]
[30,"-  34",null,5251.2400000000007,4019.52,3033.7200000000003,2326.17,1796.7]
[35,"-  39",null,5820.9900000000007,4475.3200000000006,3376.63,2653.1800000000003,{"$f":"$L$2*H277","v":1993.3300000000002}]
[40,"-  44",null,6568.8200000000006,5072.1000000000004,3828.19,2965.3500000000004,2253.0300000000002]
[45,"-  49",null,7630.9400000000005,5840.6,4311.55,3371.86,2619.2600000000002]
[50,"-  54",null,8362.8700000000008,6566.7000000000007,5027.05,3788.44,2874.7200000000003]
[55,"-  59",null,9881.85,7577.9400000000005,5561.8200000000006,4385.22,3397.8300000000004]
[60,null,null,10914.82,8390.9600000000009,6116.7300000000005,4837.84,3757.17]
[61,null,null,{"$f":"$L$2*D283","v":12281.16},9442.4800000000014,6880.9900000000007,5446.2800000000007,4235.2300000000005]
[62,null,null,13651.74,10492.94,7647.3700000000008,6053.66,4702.6900000000005]
[63,null,null,15021.26,11547.640000000001,8415.8700000000008,6661.5700000000006,5181.8100000000004]
[64,null,null,16387.600000000002,12598.1,9186.49,7270.54,5651.92]
[65,null,null,17712.600000000002,13707.92,10008.52,7918.2000000000007,6432.6100000000006]
[66,null,null,18761.47,14522.53,10602.12,8387.7800000000007,6814.7400000000007]
[67,null,null,20850.2,16134.26,11783.49,9321.6400000000012,7573.7000000000007]
[68,null,null,22935.22,17752.350000000002,12960.09,10254.44,8329.48]
[69,null,null,23983.56,18558.48,{"$f":"$L$2*F291","v":13553.16},10721.37,8712.67]
[70,null,null,24290.43,18854.22,13758.27,10928.07,8829.27]
[71,null,null,27334.75,21213.780000000002,15483.42,12295.470000000001,9931.1400000000012]
[72,null,null,30372.18,23578.11,17205.39,13663.400000000001,11037.78]
[73,null,null,33410.67,25933.960000000003,18927.36,15033.980000000001,12144.42]
[74,null,null,36453.4,28295.640000000003,20654.100000000002,16402.440000000002,13252.12]
[75,"o más",null,39874.020000000004,31559.38,23687.29,17952.16,15206.230000000001]
[1,"Hijo",null,1816.8400000000001,1292.1400000000001,1000.11,884.04000000000008,638.65]
[2,"Hijos",null,2956.34,2039.97,1583.1100000000001,1398.67,939.69]
[3,"Hijos o más",null,4325.8600000000006,2974.36,2300.73,2033.0800000000002,1429.41]
[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,1,2,3,4,5]
[18,"-  24",null,5956,4467,3344,2559,2021,null,true,true,true,true,true]
[25,"-  29",null,6628,4990,3730,2860,2252,null,true,true,true,true,true]
[30,"-  34",null,7679,5873,4431,3392,2614,null,true,true,true,true,true]
[35,"-  39",null,8514,6539,4931,3875,2907,null,true,true,true,true,true]
[40,"-  44",null,9615,7414,5600,4325,3282,null,true,true,true,true,true]
[45,"-  49",null,11166,8540,6305,4928,3812,null,true,true,true,true,true]
[50,"-  54",null,12237,9609,7362,5546,4198,null,true,true,true,true,true]
[55,"-  59",null,14465,11092,8144,6417,4955,null,true,true,true,true,true]
[60,null,null,15982,12285,8966,7082,5499,null,true,true,true,true,true]
[61,null,null,17996,13828,10079,7972,6189,null,true,true,true,true,true]
[62,null,null,20008,15376,11210,8864,6887,null,true,true,true,true,true]
[63,null,null,22008,16918,12336,9767,7582,null,true,true,true,true,true]
[64,null,null,24023,18454,13469,10655,8274,null,true,true,true,true,true]
[65,null,null,25971,20098,14679,11604,9429,null,true,true,true,true,true]
[66,null,null,27504,21280,15549,12287,9982,null,true,true,true,true,true]
[67,null,null,30567,23657,17285,13668,11104,null,true,true,true,true,true]
[68,null,null,33627,26026,19017,15044,12218,null,true,true,true,true,true]
[69,null,null,35164,27213,19881,15730,12772,null,true,true,true,true,true]
[70,null,null,35625,27641,20192,16026,12936,null,true,true,true,true,true]
[71,null,null,40092,31107,22722,18035,14567,null,true,true,true,true,true]
[72,null,null,44537,34577,25248,20050,16190,null,true,true,true,true,true]
[73,null,null,49011,38034,27782,22056,17813,null,true,true,true,true,true]
[74,null,null,53474,41505,30318,24074,19445,null,true,true,true,true,true]
[75,"o más",null,58491,46289,34780,26355,22313,null,true,true,true,true,true]
[1,"Hijo",null,2662,1896,1468,1304,940,null,true,true,true,true,true]
[2,"Hijos",null,4334,2996,2322,2060,1379,null,true,true,true,true,true]
[3,"Hijos o más",null,6350,4359,3388,2979,2098,null,true,true,true,true,true]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," "]
[18,"-  24",null,{"$f":"$L$2*D341","v":3156.6800000000003},{"$f":"$L$2*E341","v":2367.5100000000002},1772.3200000000002,1356.27,1071.1300000000001]
[25,"-  29",null,{"$f":"$L$2*D342","v":3512.84},2644.7000000000003,1976.9,1515.8000000000002,1193.5600000000002]
[30,"-  34",null,4069.8700000000003,3112.69,2348.4300000000003,1797.76,1385.42]
[35,"-  39",null,4512.42,3465.67,2613.4300000000003,2053.75,1540.71]
[40,"-  44",null,5095.95,3929.42,2968,2292.25,{"$f":"$L$2*H345","v":1739.46}]
[45,"-  49",null,5917.9800000000005,4526.2,3341.65,2611.84,2020.3600000000001]
[50,"-  54",null,6485.6100000000006,5092.7700000000004,3901.86,2939.38,2224.94]
[55,"-  59",null,7666.4500000000007,5878.76,4316.3200000000006,3401.01,2626.15]
[60,null,null,8470.4600000000009,6511.05,4751.9800000000005,3753.46,2914.4700000000003]
[61,null,null,{"$f":"$L$2*D350","v":9537.880000000001},7328.84,5341.87,4225.16,3280.17]
[62,null,null,10604.24,8149.2800000000007,5941.3,4697.92,3650.11]
[63,null,null,11664.24,8966.5400000000009,6538.08,5176.51,4018.46]
[64,null,null,12732.19,9780.6200000000008,7138.5700000000006,5647.1500000000005,4385.22]
[65,null,null,13764.630000000001,10651.94,7779.8700000000008,6150.12,4997.37]
[66,null,null,14577.12,11278.400000000001,8240.9700000000012,6512.1100000000006,5290.46]
[67,null,null,16200.51,12538.210000000001,9161.0500000000011,7244.04,5885.12]
[68,null,null,17822.310000000001,13793.78,10079.01,7973.3200000000006,6475.54]
[69,null,null,18636.920000000002,14422.890000000001,10536.93,8336.9,6769.1600000000008]
[70,null,null,18881.25,14649.730000000001,{"$f":"$L$2*F359","v":10701.76},8493.7800000000007,6856.08]
[71,null,null,21248.760000000002,16486.71,{"$f":"$L$2*F360","v":12042.66},9558.5500000000011,7720.51]
[72,null,null,23604.61,18325.810000000001,{"$f":"$L$2*F361","v":13381.44},10626.5,8580.7000000000007]
[73,null,null,25975.83,20158.02,14724.460000000001,11689.68,9440.8900000000012]
[74,null,null,28341.22,21997.65,16068.54,12759.220000000001,10305.85]
[75,"o más",null,31000.230000000003,24533.170000000002,18433.400000000001,13968.150000000001,11825.890000000001]
[1,"Hijo",null,1410.8600000000001,1004.88,778.04000000000008,691.12,498.20000000000005]
[2,"Hijos",null,2297.02,1587.88,1230.6600000000001,1091.8,730.87]
[3,"Hijos o más",null,3365.5,2310.27,1795.64,1578.8700000000001,1111.94]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["SECURE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6",null,1,2,3,4,5]
[18,"-  24",null,5940,4658,3503,3029,2306,null,true,true,true,true,true]
[25,"-  29",null,6544,5243,3903,3376,2554,null,true,true,true,true,true]
[30,"-  34",null,7496,6164,4527,3920,2967,null,true,true,true,true,true]
[35,"-  39",null,8266,6897,5037,4355,3285,null,true,true,true,true,true]
[40,"-  44",null,9273,7880,5702,4932,3706,null,true,true,true,true,true]
[45,"-  49",null,10674,9224,6630,5723,4311,null,true,true,true,true,true]
[50,"-  54",null,11637,10155,7268,6285,4708,null,true,true,true,true,true]
[55,"-  59",null,13685,12130,8621,7442,5577,null,true,true,true,true,true]
[60,null,null,14321,12957,9123,7878,5890,null,true,true,true,true,true]
[61,null,null,16116,14579,10274,8874,6633,null,true,true,true,true,true]
[62,null,null,17915,16215,11422,9870,7382,null,true,true,true,true,true]
[63,null,null,19715,17835,12573,10857,8128,null,true,true,true,true,true]
[64,null,null,21508,19472,13710,11853,8874,null,true,true,true,true,true]
[65,null,null,21536,19654,13803,11920,8910,null,true,true,true,true,true]
[66,null,null,21566,19833,13878,11978,8939,null,true,true,true,true,true]
[67,null,null,23961,22048,15440,13313,9935,null,true,true,true,true,true]
[68,null,null,26364,24256,16980,14655,10944,null,true,true,true,true,true]
[69,null,null,27568,25353,17760,15315,11447,null,true,true,true,true,true]
[70,null,null,27612,25787,17938,15471,11496,null,true,true,true,true,true]
[71,null,null,31080,29019,20194,17414,12947,null,true,true,true,true,true]
[72,null,null,34534,32258,22445,19365,14392,null,true,true,true,true,true]
[73,null,null,38006,35484,24694,21297,15842,null,true,true,true,true,true]
[74,null,null,41462,38709,26943,23240,17288,null,true,true,true,true,true]
[75,"o más",null,45189,42468,29470,25416,18885,null,true,true,true,true,true]
[1,"Hijo",null,2867,1688,1410,1215,897,null,true,true,true,true,true]
[2,"Hijos",null,4832,2511,2219,1923,1419,null,true,true,true,true,true]
[3,"Hijos o más",null,7091,3610,3228,2782,2055,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":3148.2000000000003},{"$f":"$L$2*E408","v":2468.7400000000002},1856.5900000000001,1605.3700000000001,1222.18]
[25,"-  29",null,{"$f":"$L$2*D409","v":3468.32},2778.79,2068.59,1789.2800000000002,1353.6200000000001]
[30,"-  34",null,3972.88,3266.92,2399.31,2077.6,1572.51]
[35,"-  39",null,4380.9800000000005,3655.4100000000003,2669.61,2308.15,1741.0500000000002]
[40,"-  44",null,4914.6900000000005,4176.4000000000005,3022.06,2613.96,1964.18]
[45,"-  49",null,5657.22,4888.72,3513.9,3033.19,2284.83]
[50,"-  54",null,6167.6100000000006,5382.1500000000005,3852.0400000000004,3331.05,2495.2400000000002]
[55,"-  59",null,7253.05,6428.9000000000005,4569.13,3944.26,{"$f":"$L$2*H415","v":2955.81}]
[60,null,null,7590.13,6867.21,4835.1900000000005,4175.34,3121.7000000000003]
[61,null,null,8541.48,7726.8700000000008,5445.22,4703.22,3515.4900000000002]
[62,null,null,9494.9500000000007,8593.9500000000007,6053.66,5231.1000000000004,3912.46]
[63,null,null,10448.950000000001,9452.5500000000011,6663.6900000000005,5754.21,4307.84]
[64,null,null,11399.24,10320.16,7266.3,6282.09,4703.22]
[65,null,null,11414.08,10416.620000000001,7315.59,6317.6,4722.3]
[66,null,null,11429.980000000001,10511.49,7355.34,6348.34,4737.67]
[67,null,null,12699.33,11685.44,8183.2000000000007,7055.89,5265.55]
[68,null,null,13972.92,12855.68,8999.4,{"$f":"$L$2*G424","v":7767.1500000000005},5800.3200000000006]
[69,null,null,14611.04,13437.09,9412.8000000000011,8116.9500000000007,6066.91]
[70,null,null,14634.36,13667.11,9507.1400000000012,8199.630000000001,6092.88]
[71,null,null,16472.400000000001,15380.070000000002,10702.82,9229.42,6861.9100000000008]
[72,null,null,18303.02,17096.740000000002,11895.85,10263.450000000001,7627.76]
[73,null,null,20143.18,18806.52,13087.820000000002,11287.41,8396.26]
[74,null,null,21974.86,20515.77,14279.79,12317.2,9162.6400000000012]
[75,"o más",null,23950.170000000002,22508.04,15619.1,13470.480000000001,10009.050000000001]
[1,"Hijo",null,1519.51,894.6400000000001,747.30000000000007,643.95000000000005,475.41]
[2,"Hijos",null,2560.96,1330.8300000000002,1176.0700000000002,1019.19,752.07]
[3,"Hijos o más",null,3758.23,1913.3000000000002,1710.8400000000001,1474.46,1089.1500000000001]
[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,1,2,3,4,5]
[18,"-  24",null,4013,3142,2366,2051,1552,null,true,true,true,true,true]
[25,"-  29",null,4418,3545,2631,2292,1728,null,true,true,true,true,true]
[30,"-  34",null,5073,4178,3060,2656,1996,null,true,true,true,true,true]
[35,"-  39",null,5589,4667,3405,2954,2222,null,true,true,true,true,true]
[40,"-  44",null,6275,5328,3849,3344,2510,null,true,true,true,true,true]
[45,"-  49",null,7227,6252,4488,3891,2916,null,true,true,true,true,true]
[50,"-  54",null,7877,6884,4922,4270,3195,null,true,true,true,true,true]
[55,"-  59",null,9272,8224,5831,5068,3782,null,true,true,true,true,true]
[60,null,null,9705,8786,6185,5361,4002,null,true,true,true,true,true]
[61,null,null,10930,9892,6964,6045,4512,null,true,true,true,true,true]
[62,null,null,12150,10996,7742,6724,5027,null,true,true,true,true,true]
[63,null,null,13373,12102,8530,7397,5536,null,true,true,true,true,true]
[64,null,null,14598,13214,9308,8075,6045,null,true,true,true,true,true]
[65,null,null,14610,13341,9357,8122,6064,null,true,true,true,true,true]
[66,null,null,14627,13454,9418,8159,6080,null,true,true,true,true,true]
[67,null,null,16256,14962,10472,9075,6766,null,true,true,true,true,true]
[68,null,null,17897,16462,11518,9993,7450,null,true,true,true,true,true]
[69,null,null,18702,17216,12050,10442,7794,null,true,true,true,true,true]
[70,null,null,18742,17507,12179,10550,7838,null,true,true,true,true,true]
[71,null,null,21098,19706,13706,11878,8822,null,true,true,true,true,true]
[72,null,null,23444,21910,15237,13199,9812,null,true,true,true,true,true]
[73,null,null,25809,24098,16767,14528,10794,null,true,true,true,true,true]
[74,null,null,28155,26304,18292,15854,11786,null,true,true,true,true,true]
[75,"o más",null,30694,28844,20015,17349,12885,null,true,true,true,true,true]
[1,"Hijo",null,1949,1152,962,834,617,null,true,true,true,true,true]
[2,"Hijos",null,3285,1708,1512,1310,970,null,true,true,true,true,true]
[3,"Hijos o más",null,4820,2456,2198,1902,1401,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":2126.8900000000003},{"$f":"$L$2*E475","v":1665.26},1253.98,1087.03,822.56000000000006]
[25,"-  29",null,{"$f":"$L$2*D476","v":2341.54},1878.8500000000001,1394.43,1214.76,915.84]
[30,"-  34",null,2688.69,2214.34,1621.8000000000002,1407.68,1057.8800000000001]
[35,"-  39",null,2962.17,2473.5100000000002,1804.65,{"$f":"$L$2*G478","v":1565.6200000000001},1177.6600000000001]
[40,"-  44",null,3325.75,2823.84,2039.97,1772.3200000000002,1330.3]
[45,"-  49",null,3830.3100000000004,3313.56,2378.6400000000003,2062.23,1545.48]
[50,"-  54",null,4174.8100000000004,3648.52,2608.6600000000003,2263.1,1693.3500000000001]
[55,"-  59",null,4914.16,4358.72,3090.4300000000003,{"$f":"$L$2*G482","v":2686.04},2004.46]
[60,null,null,5143.6500000000005,4656.58,3278.05,2841.33,2121.06]
[61,null,null,5792.9000000000005,5242.76,3690.92,3203.8500000000004,2391.36]
[62,null,null,6439.5,5827.88,4103.26,3563.7200000000003,2664.31]
[63,null,null,7087.6900000000005,6414.06,4520.9000000000005,3920.4100000000003,2934.08]
[64,null,null,7736.9400000000005,7003.42,4933.2400000000007,4279.75,3203.8500000000004]
[65,null,null,7743.3,7070.7300000000005,4959.21,4304.66,3213.92]
[66,null,null,7752.31,{"$f":"$L$2*E489","v":7130.6200000000008},4991.54,4324.2700000000004,3222.4]
[67,null,null,8615.68,7929.8600000000006,5550.16,4809.75,3585.98]
[68,null,null,9485.41,{"$f":"$L$2*E491","v":8724.86},6104.54,5296.29,3948.5]
[69,null,null,9912.0600000000013,9124.48,6386.5,5534.26,4130.8200000000006]
[70,null,null,9933.26,9278.7100000000009,6454.87,5591.5,4154.1400000000003]
[71,null,null,11181.94,10444.18,7264.18,6295.34,4675.66]
[72,null,null,12425.320000000002,11612.300000000001,8075.6100000000006,6995.47,{"$f":"$L$2*H495","v":5200.3600000000006}]
[73,null,null,13678.77,12771.94,8886.51,7699.84,5720.8200000000006]
[74,null,null,14922.150000000001,13941.12,9694.76,8402.6200000000008,6246.58]
[75,"o más",null,{"$f":"$L$2*D498","v":16267.820000000002},15287.320000000002,10607.95,9194.9700000000012,6829.05]
[1,"Hijo",null,1032.97,610.56000000000006,509.86,442.02000000000004,327.01]
[2,"Hijos",null,1741.0500000000002,905.24,801.36,694.30000000000007,514.1]
[3,"Hijos o más",null,2554.6,1301.68,1164.94,1008.0600000000001,742.53000000000009]
[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",4103,7455,10823,3569,6348,9134,2993,5417,7828,2298,4110,5919,1630,2859,4094,917,1528,2142]
[50,"o más",5273,8634,11994,4582,7361,10145,3843,6257,8663,2932,4738,6554,2048,3297,4514,1131,1749,2363]
[]
["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":"$L$2*C543","v":2174.59},{"$f":"$L$2*D543","v":3951.15},5736.1900000000005,1891.5700000000002,3364.44,4841.0200000000004,1586.2900000000002,2871.01,4148.84,1217.94,2178.3000000000002,3137.07,863.90000000000009,1515.27,2169.8200000000002,486.01000000000005,809.84,1135.26]
[75,"o más",{"$f":"$L$2*C544","v":2794.69},{"$f":"$L$2*D544","v":4576.0200000000004},6356.8200000000006,2428.46,3901.3300000000004,5376.85,2036.7900000000002,3316.21,4591.3900000000003,1553.96,2511.1400000000003,3473.6200000000003,1085.44,1747.41,2392.42,599.43000000000006,926.97,1252.3900000000001]
[]
[]
[]
[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]