{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["INGRESO DE DATOS","Global Ultimate Health  Plan","Global Elite Health  Plan","Global Premier Health  Plan","Global Select Health  Plan","Global Major Medical Health  Pl","Resumen tarifas","Tablas"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":0,"defined_names":6,"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":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[50,3,50,4],[50,6,50,7],[17,0,17,12],[25,5,25,6],[21,1,21,2],[23,1,23,2],[21,3,21,7],[23,5,23,6],[25,1,25,2],[27,3,27,7]]}
[]
[null,null,null,null,null,null,null," "," "]
[]
[]
[]
[null,null,null,null,null,null,null," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1. LLENE LA INFORMACIÓN DEL ASEGURADO PROPUESTO:"]
[]
[null,"Nombre del Asegurado Titular",null,"JOHN DOE"]
[]
[null,"Número de adultos en la póliza",null,2,null,"Número de niños en la póliza",null,3]
[]
[null,"Edad del Asegurado Titular",null,49,null,"Edad del/la cónyuge ",null,39]
[]
[null,null,"Cotizador por","NOMBRE DE AGENTE"]
[]
[]
[]
["2. SELECCIONE EL PRODUCTO PARA VER LA COTIZACIÓN CORRESPONDIENTE: "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2,null,1]

{"sheet":"Global Ultimate Health  Plan","index":1,"n_rows":86,"n_cols":11,"rows_kept":86,"cut":false,"hidden":false,"merged":[[109,0,109,1],[78,0,79,1],[95,0,95,1],[26,3,26,4],[47,0,47,1],[63,0,63,1],[67,0,67,1],[83,0,83,1],[85,4,87,7],[84,4,84,7],[66,4,66,5],[41,4,41,5],[60,4,60,5],[74,4,74,5],[75,4,75,5],[81,4,81,5],[43,4,43,7],[55,4,55,7],[70,4,70,7],[48,0,49,0],[48,1,49,1],[53,4,53,5],[59,4,59,5],[19,3,19,4],[19,5,19,8],[22,3,22,4],[24,3,24,4],[42,0,42,1],[32,4,32,7],[19,0,20,1],[20,3,20,4],[20,5,20,8],[27,0,27,1]]}
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Global Ultimate Health Plan",null,null,"Nombre del Asegurado Titular",null,{"$f":"+'INGRESO DE DATOS'!$D$22","v":"JOHN DOE"}]
[null,null,null,"Cotizado por",null,{"$f":"+'INGRESO DE DATOS'!$D$28","v":"NOMBRE DE AGENTE"}]
[]
[null,null,null,"Número de adultos en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$D$24","v":2},null,"Edad del Asegurado Titular",{"$f":"+'INGRESO DE DATOS'!$D$26","v":49}]
[]
[null,null,null,"Número de niños en la póliza",null,3,null,"Edad del/la conyuge",{"$f":"+'INGRESO DE DATOS'!$H$26","v":39}]
[null,null,null,null,null,null,null," "," "]
[null,null,null,"Número de niños menores de 16 años",null,{"$f":"+'INGRESO DE DATOS'!$B$53","v":2},"Fecha de la cotización :",{"$f":"NOW()","v":"2020-12-16T16:14:06.940"}]
[null,null,null,null,null,null," ",false,null," ","s"]
[null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2"]
[null,null,null,null,"En el país de residencia",null,0,1000]
[null,null,null,null,"Fuera del país de residencia",null,0,1000]
[]
[null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$23,Tablas!$A$905:$G$971,3,TRUE))*1.1494","v":32553.306799999998},{"$f":"(VLOOKUP($I$23,Tablas!$A$905:$G$971,4,TRUE))*1.1494","v":21004.135599999998}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$23=1,0,(VLOOKUP($I$25,Tablas!$A$905:$G$971,3,TRUE))))*1.1494","v":25950.003799999999},{"$f":"(IF($F$23=1,0,(VLOOKUP($I$25,Tablas!$A$905:$G$971,4,TRUE))))*1.1494","v":16742.160400000001}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)=Tablas!A972,Tablas!C972,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)=Tablas!A973,Tablas!C973,Tablas!C974))))*1.1494","v":8156.1423999999997},{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)=Tablas!A972,Tablas!D972,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)=Tablas!A973,Tablas!D973,Tablas!D974))))*1.1494","v":5263.1026000000002}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G34:G36))","v":66659.452999999994},{"$f":"(SUM(H34:H36))","v":43009.3986}]
[null,null,null,null,"Costo administrativo anual",null,86,86]
[null,null,null,null,"Impuesto (14.49%)",null,{"$f":"(G38)*0%","v":0},{"$f":"(H38)*0%","v":0}]
[]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"SUM(G37:G39)","v":66745.452999999994},{"$f":"SUM(H37:H39)","v":43095.3986}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53) < 0, NA(), (IF('INGRESO DE DATOS'!H24<=0,0,IF('INGRESO DE DATOS'!H24=Tablas!A972,Tablas!C972,IF('INGRESO DE DATOS'!H24=Tablas!A973,Tablas!C973,Tablas!C974))) - IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)=Tablas!A972,Tablas!C972,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)=Tablas!A973,Tablas!C973,Tablas!C974))))))*1.1494","v":11415.8408},{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53) < 0, NA(), (IF('INGRESO DE DATOS'!H24<=0,0,IF('INGRESO DE DATOS'!H24=Tablas!A972,Tablas!D972,IF('INGRESO DE DATOS'!H24=Tablas!A973,Tablas!D973,Tablas!D974))) - IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)=Tablas!A972,Tablas!D972,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!B53)=Tablas!A973,Tablas!D973,Tablas!D974))))))*1.1494","v":7367.6539999999995}]
[]
[null,null,null,null,"Tarifas Semianuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$23,Tablas!$A$1428:$G$1494,3,TRUE))*1.1494","v":17253.252604000001},{"$f":"(VLOOKUP($I$23,Tablas!$A$1428:$G$1494,4,TRUE))*1.1494","v":11132.191868000002}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$23=1,0,(VLOOKUP($I$25,Tablas!$A$1428:$G$1494,3,TRUE))))*1.1494","v":13753.502014000002},{"$f":"(IF($F$23=1,0,(VLOOKUP($I$25,Tablas!$A$1428:$G$1494,4,TRUE))))*1.1494","v":8873.3450119999998}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G36*Tablas!K4","v":4322.7554719999998},{"$f":"H36*Tablas!K4","v":2789.4443780000001}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G45:G47))","v":35329.510090000003},{"$f":"(SUM(H45:H47))","v":22794.981258}]
[null,null,null,null,"Costo administrativo annual",null,86,86]
[null,null,null,null,"Impuesto (14.49%)",null,{"$f":"(G49)*0%","v":0},{"$f":"(H49)*0%","v":0}]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G48:G50)","v":35415.510090000003},{"$f":"SUM(H48:H50)","v":22880.981258}]
[null,null,null,null,"Costo de segunda cuota",null,{"$f":"G48+G50","v":35329.510090000003},{"$f":"H48+H50","v":22794.981258}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G51+G52","v":70745.020180000007},{"$f":"H51+H52","v":45675.962516}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G42*Tablas!K4*2","v":12100.791248000001},{"$f":"H42*Tablas!K4*2","v":7809.71324}]
[]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$23,Tablas!$A$1054:$G$1120,3,TRUE))*1.1494","v":8952.1593699999994},{"$f":"(VLOOKUP($I$23,Tablas!$A$1054:$G$1120,4,TRUE))*1.1494","v":5776.1372900000006}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$23=1,0,(VLOOKUP($I$25,Tablas!$A$1054:$G$1120,3,TRUE))))*1.1494","v":7136.251045},{"$f":"(IF($F$23=1,0,(VLOOKUP($I$25,Tablas!$A$1054:$G$1120,4,TRUE))))*1.1494","v":4604.0941100000009}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G36*Tablas!K3","v":2242.9391599999999},{"$f":"H36*Tablas!K3","v":1447.3532150000001}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G57:G59))","v":18331.349575},{"$f":"(SUM(H57:H59))","v":11827.584615}]
[null,null,null,null,"Costo administrativo annual",null,86,86]
[null,null,null,null,"Impuesto (14.49%)",null,{"$f":"(G61)*0%","v":0},{"$f":"(H61)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G60:G62)","v":18417.349575},{"$f":"SUM(H60:H62)","v":11913.584615}]
[null,null,null,null,"Tres (3) cuotas adicionales, cada una de:",null,{"$f":"G60+G62","v":18331.349575},{"$f":"H60+H62","v":11827.584615}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G64+(G65*3)","v":73411.398300000001},{"$f":"H64+(H65*3)","v":47396.338459999999}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G42*Tablas!K3*4","v":12557.42488},{"$f":"H42*Tablas!K3*4","v":8104.4193999999998}]
[]
[]
[]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$23,Tablas!$A$979:$G$1045,3,TRUE))*1.1494","v":3038.3086346666669},{"$f":"(VLOOKUP($I$23,Tablas!$A$979:$G$1045,4,TRUE))*1.1494","v":1960.3859893333336}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$23=1,0,(VLOOKUP($I$25,Tablas!$A$979:$G$1045,3,TRUE))))*1.1494","v":2422.0003546666671},{"$f":"(IF($F$23=1,0,(VLOOKUP($I$25,Tablas!$A$979:$G$1045,4,TRUE))))*1.1494","v":1562.6016373333332}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G36*Tablas!K2","v":761.23995733333334},{"$f":"H36*Tablas!K2","v":491.22290933333335}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G72:G74))","v":6221.5489466666677},{"$f":"(SUM(H72:H74))","v":4014.2105360000005}]
[null,null,null,null,"Costo administrativo anual",null,86,86]
[null,null,null,null,"Impuesto (14.49%)",null,{"$f":"(G76)*0%","v":0},{"$f":"(H76)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G75:G77)","v":6307.5489466666677},{"$f":"SUM(H75:H77)","v":4100.2105360000005}]
[null,null,null,null,"Once (11) cuotas mensuales cada una de:",null,{"$f":"G75+G77","v":6221.5489466666677},{"$f":"H75+H77","v":4014.2105360000005}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G79+(G80*11)","v":74744.587360000005},{"$f":"H79+(H80*11)","v":48256.526432000006}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G42*Tablas!K2*12","v":12785.741696000001},{"$f":"H42*Tablas!K2*12","v":8251.7724799999996}]
[]
[]
[null,null,null,null,"Tarifas en US$ -  Efectivas a partir del 1ro. de Enero de 2021"]
[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":"Global Elite Health  Plan","index":2,"n_rows":84,"n_cols":11,"rows_kept":84,"cut":false,"hidden":false,"merged":[[83,0,83,1],[93,0,93,1],[46,0,46,1],[63,0,63,1],[83,4,84,10],[82,4,82,10],[42,4,42,10],[54,4,54,10],[25,3,25,4],[23,3,23,4],[18,5,18,8],[18,3,18,4],[21,3,21,4],[18,0,19,1],[19,5,19,8],[73,4,73,5],[72,4,72,5],[79,4,79,5],[68,4,68,10],[26,0,26,1],[41,0,41,1],[67,0,67,1],[79,0,79,1],[31,4,31,10],[40,4,40,5],[52,4,52,5],[65,4,65,5],[58,4,58,5],[59,4,59,5]]}
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bupa Global Elite Health Plan",null,null,"Nombre del Asegurado Titular",null,{"$f":"+'INGRESO DE DATOS'!$D$22","v":"JOHN DOE"}]
[null,null,null,null,"Cotizado por",{"$f":"+'INGRESO DE DATOS'!$D$28","v":"NOMBRE DE AGENTE"}]
[]
[null,null,null,"Número de adultos en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$D$24","v":2},null,"Edad del Asegurado Titular",{"$f":"+'INGRESO DE DATOS'!$D$26","v":49}]
[]
[null,null,null,"Número de niños en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$H$24","v":3},null,"Edad del/la conyuge",{"$f":"+'INGRESO DE DATOS'!$H$26","v":39}]
[null,null,null,null,null,null,null," "," "]
[null,null,null,"Número de niños menores de 10 años",null,{"$f":"+'INGRESO DE DATOS'!$D$53","v":1},"Fecha de la cotización :",{"$f":"NOW()","v":"2020-12-16T16:14:06.940"}]
[null,null,null,null,null,null," ",false,null," "]
[null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5"]
[null,null,null,null,"En el país de residencia",null,250,2000,3500,5000,10000]
[null,null,null,null,"Fuera del país de residencia",null,5000,2000,3500,5000,10000]
[]
[null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$22,Tablas!$A$6:$G$72,3,TRUE))*1.1494","v":13900.8436},{"$f":"(VLOOKUP($I$22,Tablas!$A$6:$G$72,4,TRUE))*1.1494","v":12183.64},{"$f":"(VLOOKUP($I$22,Tablas!$A$6:$G$72,5,TRUE))*1.1494","v":10027.365599999999},{"$f":"(VLOOKUP($I$22,Tablas!$A$6:$G$72,6,TRUE))*1.1494","v":8694.0615999999991},{"$f":"(VLOOKUP($I$22,Tablas!$A$6:$G$72,7,TRUE))*1.1494","v":6742.3804}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$6:$G$72,3,TRUE))))*1.1494","v":11090.560599999999},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$6:$G$72,4,TRUE))))*1.1494","v":9718.1769999999997},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$6:$G$72,5,TRUE))))*1.1494","v":8059.5927999999994},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$6:$G$72,6,TRUE))))*1.1494","v":6989.5014000000001},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$6:$G$72,7,TRUE))))*1.1494","v":5420.5703999999996}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A73,Tablas!C73,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A74,Tablas!C74,Tablas!C75))))*1.1494","v":6005.6149999999998},{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A73,Tablas!D73,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A74,Tablas!D74,Tablas!D75))))*1.1494","v":5265.4013999999997},{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A73,Tablas!E73,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A74,Tablas!E74,Tablas!E75))))*1.1494","v":4482.66},{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A73,Tablas!F73,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A74,Tablas!F74,Tablas!F75))))*1.1494","v":3888.4202},{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A73,Tablas!G73,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A74,Tablas!G74,Tablas!G75))))*1.1494","v":3014.8762000000002}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G33:G35))","v":30997.019199999995},{"$f":"(SUM(H33:H35))","v":27167.218399999998},{"$f":"(SUM(I33:I35))","v":22569.618399999999},{"$f":"(SUM(J33:J35))","v":19571.983199999999},{"$f":"(SUM(K33:K35))","v":15177.826999999999}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G37)*0%","v":0},{"$f":"(H37)*0%","v":0},{"$f":"(I37)*0%","v":0},{"$f":"(J37)*0%","v":0},{"$f":"(K37)*0%","v":0}]
[]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"SUM(G36:G38)","v":31083.019199999995},{"$f":"SUM(H36:H38)","v":27253.218399999998},{"$f":"SUM(I36:I38)","v":22655.618399999999},{"$f":"SUM(J36:J38)","v":19657.983199999999},{"$f":"SUM(K36:K38)","v":15263.826999999999}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53) < 0, NA(), (IF('INGRESO DE DATOS'!H24<=0,0,IF('INGRESO DE DATOS'!H24=Tablas!A73,Tablas!C73,IF('INGRESO DE DATOS'!H24=Tablas!A74,Tablas!C74,Tablas!C75))) - IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A73,Tablas!C73,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A74,Tablas!C74,Tablas!C75))))))*1.1494","v":2474.6581999999999},{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53) < 0, NA(), (IF('INGRESO DE DATOS'!H24<=0,0,IF('INGRESO DE DATOS'!H24=Tablas!A73,Tablas!D73,IF('INGRESO DE DATOS'!H24=Tablas!A74,Tablas!D74,Tablas!D75))) - IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A73,Tablas!D73,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A74,Tablas!D74,Tablas!D75))))))*1.1494","v":2166.6190000000001},{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53) < 0, NA(), (IF('INGRESO DE DATOS'!H24<=0,0,IF('INGRESO DE DATOS'!H24=Tablas!A73,Tablas!E73,IF('INGRESO DE DATOS'!H24=Tablas!A74,Tablas!E74,Tablas!E75))) - IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A73,Tablas!E73,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A74,Tablas!E74,Tablas!E75))))))*1.1494","v":1844.787},{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53) < 0, NA(), (IF('INGRESO DE DATOS'!H24<=0,0,IF('INGRESO DE DATOS'!H24=Tablas!A73,Tablas!F73,IF('INGRESO DE DATOS'!H24=Tablas!A74,Tablas!F74,Tablas!F75))) - IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A73,Tablas!F73,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A74,Tablas!F74,Tablas!F75))))))*1.1494","v":1598.8154},{"$f":"(IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53) < 0, NA(), (IF('INGRESO DE DATOS'!H24<=0,0,IF('INGRESO DE DATOS'!H24=Tablas!A73,Tablas!G73,IF('INGRESO DE DATOS'!H24=Tablas!A74,Tablas!G74,Tablas!G75))) - IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)<=0,0,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A73,Tablas!G73,IF(('INGRESO DE DATOS'!H24 - 'INGRESO DE DATOS'!D53)=Tablas!A74,Tablas!G74,Tablas!G75))))))*1.1494","v":1241.3519999999999}]
[]
[null,null,null,null,"Tarifas Semianuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$22,Tablas!$A$455:$G$521,3,TRUE))*1.1494","v":7367.4471080000003},{"$f":"(VLOOKUP($I$22,Tablas!$A$455:$G$521,4,TRUE))*1.1494","v":6457.3292000000001},{"$f":"(VLOOKUP($I$22,Tablas!$A$455:$G$521,5,TRUE))*1.1494","v":5314.5037680000005},{"$f":"(VLOOKUP($I$22,Tablas!$A$455:$G$521,6,TRUE))*1.1494","v":4607.852648},{"$f":"(VLOOKUP($I$22,Tablas!$A$455:$G$521,7,TRUE))*1.1494","v":3573.4616120000001}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$455:$G$521,3,TRUE))))*1.1494","v":5877.9971180000002},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$455:$G$521,4,TRUE))))*1.1494","v":5150.6338100000003},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$455:$G$521,5,TRUE))))*1.1494","v":4271.5841840000003},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$455:$G$521,6,TRUE))))*1.1494","v":3704.4357420000001},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$455:$G$521,7,TRUE))))*1.1494","v":2872.9023120000002}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G35*Tablas!$K4","v":3182.97595},{"$f":"H35*Tablas!$K4","v":2790.662742},{"$f":"I35*Tablas!$K4","v":2375.8098},{"$f":"J35*Tablas!$K4","v":2060.8627059999999},{"$f":"K35*Tablas!$K4","v":1597.8843860000002}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G44:G46))","v":16428.420176},{"$f":"(SUM(H44:H46))","v":14398.625752},{"$f":"(SUM(I44:I46))","v":11961.897752000001},{"$f":"(SUM(J44:J46))","v":10373.151096},{"$f":"(SUM(K44:K46))","v":8044.2483100000009}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G48)*0%","v":0},{"$f":"(H48)*0%","v":0},{"$f":"(I48)*0%","v":0},{"$f":"(J48)*0%","v":0},{"$f":"(K48)*0%","v":0}]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G47:G49)","v":16514.420176},{"$f":"SUM(H47:H49)","v":14484.625752},{"$f":"SUM(I47:I49)","v":12047.897752000001},{"$f":"SUM(J47:J49)","v":10459.151096},{"$f":"SUM(K47:K49)","v":8130.2483100000009}]
[null,null,null,null,"Costo de segunda cuota",null,{"$f":"G47+G49","v":16428.420176},{"$f":"H47+H49","v":14398.625752},{"$f":"I47+I49","v":11961.897752000001},{"$f":"J47+J49","v":10373.151096},{"$f":"K47+K49","v":8044.2483100000009}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G50+G51","v":32942.840351999999},{"$f":"H50+H51","v":28883.251504},24009.795504000002,{"$f":"J50+J51","v":20832.302191999999},16174.496620000002]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G41*Tablas!$K4*2","v":2623.1376919999998},{"$f":"H41*Tablas!$K4*2","v":2296.6161400000001},{"$f":"I41*Tablas!$K4*2","v":1955.4742200000001},{"$f":"J41*Tablas!$K4*2","v":1694.744324},{"$f":"K41*Tablas!$K4*2","v":1315.83312}]
[]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$22,Tablas!$A$680:$G$746,3,TRUE))*1.1494","v":3822.7319900000002},{"$f":"(VLOOKUP($I$22,Tablas!$A$680:$G$746,4,TRUE))*1.1494","v":3350.5010000000007},{"$f":"(VLOOKUP($I$22,Tablas!$A$680:$G$746,5,TRUE))*1.1494","v":2757.5255400000005},{"$f":"(VLOOKUP($I$22,Tablas!$A$680:$G$746,6,TRUE))*1.1494","v":2390.8669400000003},{"$f":"(VLOOKUP($I$22,Tablas!$A$680:$G$746,7,TRUE))*1.1494","v":1854.15461}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$680:$G$746,3,TRUE))))*1.1494","v":3049.9041650000004},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$680:$G$746,4,TRUE))))*1.1494","v":2672.4986749999998},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$680:$G$746,5,TRUE))))*1.1494","v":2216.3880200000003},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$680:$G$746,6,TRUE))))*1.1494","v":1922.112885},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$680:$G$746,7,TRUE))))*1.1494","v":1490.6568600000001}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G35*Tablas!$K3","v":1651.5441250000001},{"$f":"H35*Tablas!$K3","v":1447.985385},{"$f":"I35*Tablas!$K3","v":1232.7315000000001},{"$f":"J35*Tablas!$K3","v":1069.3155550000001},{"$f":"K35*Tablas!$K3","v":829.09095500000012}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G56:G58))","v":8524.1802800000005},{"$f":"(SUM(H56:H58))","v":7470.9850600000009},{"$f":"(SUM(I56:I58))","v":6206.6450600000007},{"$f":"(SUM(J56:J58))","v":5382.2953800000005},{"$f":"(SUM(K56:K58))","v":4173.9024250000002}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G60)*0%","v":0},{"$f":"(H60)*0%","v":0},{"$f":"(I60)*0%","v":0},{"$f":"(J60)*0%","v":0},{"$f":"(K60)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G59:G61)","v":8610.1802800000005},{"$f":"SUM(H59:H61)","v":7556.9850600000009},{"$f":"SUM(I59:I61)","v":6292.6450600000007},{"$f":"SUM(J59:J61)","v":5468.2953800000005},{"$f":"SUM(K59:K61)","v":4259.9024250000002}]
[null,null,null,null,"Tres (3) cuotas adicionales, cada una de:",null,{"$f":"G59+G61","v":8524.1802800000005},{"$f":"H59+H61","v":7470.9850600000009},{"$f":"I59+I61","v":6206.6450600000007},{"$f":"J59+J61","v":5382.2953800000005},{"$f":"K59+K61","v":4173.9024250000002}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G63+(G64*3)","v":34182.721120000002},{"$f":"H63+(H64*3)","v":29969.940240000004},24912.580240000003,{"$f":"J63+(J64*3)","v":21615.181520000002},16781.609700000001]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G41*Tablas!$K3*4","v":2722.1240200000002},{"$f":"H41*Tablas!$K3*4","v":2383.2809000000002},{"$f":"I41*Tablas!$K3*4","v":2029.2657000000002},{"$f":"J41*Tablas!$K3*4","v":1758.69694},{"$f":"K41*Tablas!$K3*4","v":1365.4872}]
[]
[]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$22,Tablas!$A$80:$G$146,3,TRUE))*1.1494","v":1297.4120693333332},{"$f":"(VLOOKUP($I$22,Tablas!$A$80:$G$146,4,TRUE))*1.1494","v":1137.1397333333334},{"$f":"(VLOOKUP($I$22,Tablas!$A$80:$G$146,5,TRUE))*1.1494","v":935.88745600000004},{"$f":"(VLOOKUP($I$22,Tablas!$A$80:$G$146,6,TRUE))*1.1494","v":811.44574933333331},{"$f":"(VLOOKUP($I$22,Tablas!$A$80:$G$146,7,TRUE))*1.1494","v":629.28883733333328}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$80:$G$146,3,TRUE))))*1.1494","v":1035.1189893333333},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$80:$G$146,4,TRUE))))*1.1494","v":907.02985333333334},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$80:$G$146,5,TRUE))))*1.1494","v":752.22866133333332},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$80:$G$146,6,TRUE))))*1.1494","v":652.35346400000003},{"$f":"(IF($F$22=1,0,(VLOOKUP($I$24,Tablas!$A$80:$G$146,7,TRUE))))*1.1494","v":505.91990400000003}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G35*Tablas!$K2","v":560.52406666666673},{"$f":"H35*Tablas!$K2","v":491.43746399999998},{"$f":"I35*Tablas!$K2","v":418.38159999999999},{"$f":"J35*Tablas!$K2","v":362.91921866666667},{"$f":"K35*Tablas!$K2","v":281.38844533333338}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G70:G72))","v":2893.0551253333333},{"$f":"(SUM(H70:H72))","v":2535.607050666667},{"$f":"(SUM(I70:I72))","v":2106.4977173333336},{"$f":"(SUM(J70:J72))","v":1826.7184319999999},{"$f":"(SUM(K70:K72))","v":1416.5971866666669}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G74)*0%","v":0},{"$f":"(H74)*0%","v":0},{"$f":"(I74)*0%","v":0},{"$f":"(J74)*0%","v":0},{"$f":"(K74)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G73:G75)","v":2979.0551253333333},{"$f":"SUM(H73:H75)","v":2621.607050666667},{"$f":"SUM(I73:I75)","v":2192.4977173333336},{"$f":"SUM(J73:J75)","v":1912.7184319999999},{"$f":"SUM(K73:K75)","v":1502.5971866666669}]
[null,null,null,null,"Once (11) cuotas mensuales cada una de:",null,{"$f":"G73+G75","v":2893.0551253333333},{"$f":"H73+H75","v":2535.607050666667},{"$f":"I73+I75","v":2106.4977173333336},{"$f":"J73+J75","v":1826.7184319999999},{"$f":"K73+K75","v":1416.5971866666669}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G77+(G78*11)","v":34802.661504000003},{"$f":"H77+(H78*11)","v":30513.284608000002},{"$f":"I77+(I78*11)","v":25363.972608000004},{"$f":"J77+(J78*11)","v":22006.621184},{"$f":"K77+(K78*11)","v":17085.166240000002}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G41*Tablas!$K2*12","v":2771.6171839999997},{"$f":"H41*Tablas!$K2*12","v":2426.6132800000005},{"$f":"I41*Tablas!$K2*12","v":2066.1614400000003},{"$f":"J41*Tablas!$K2*12","v":1790.6732480000001},{"$f":"K41*Tablas!$K2*12","v":1390.3142399999999}]
[]
[]
[null,null,null,null,"Tarifas en US$ -  Efectivas a partir del 1ro. de Enero de 2021"]
[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":"Global Premier Health  Plan","index":3,"n_rows":84,"n_cols":10,"rows_kept":84,"cut":false,"hidden":false,"merged":[[82,4,82,9],[83,4,84,9],[71,0,71,1],[82,0,82,1],[86,0,86,1],[96,0,96,1],[22,3,22,4],[25,3,25,4],[27,3,27,4],[22,5,22,8],[22,0,23,1],[23,5,23,8],[60,4,60,5],[61,4,61,5],[73,4,73,5],[74,4,74,5],[35,4,35,9],[45,4,45,9],[56,4,56,9],[69,4,69,9],[67,0,67,1],[30,0,30,1],[45,0,45,1],[50,0,50,1],[51,1,52,1],[51,0,52,0]]}
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Global Premier Health Plan",null,null,"Nombre del Asegurado Titular",null,{"$f":"+'INGRESO DE DATOS'!$D$22","v":"JOHN DOE"}]
[null,null,null,null,"Cotizado por",{"$f":"+'INGRESO DE DATOS'!$D$28","v":"NOMBRE DE AGENTE"}]
[]
[null,null,null,"Número de adultos en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$D$24","v":2},null,"Edad del Asegurado Titular",{"$f":"+'INGRESO DE DATOS'!$D$26","v":49}]
[]
[null,null,null,"Número de niños en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$H$24","v":3},null,"Edad del/la conyuge",{"$f":"+'INGRESO DE DATOS'!$H$26","v":39}]
[null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,"Fecha de la cotización :",{"$f":"NOW()","v":"2020-12-16T16:14:06.940"}]
[null,null,null,null,null,null," ",false,null," "]
[null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4"]
[null,null,null,null,"En el país de residencia",null,250,2000,5000,10000]
[null,null,null,null,"Fuera del país de residencia",null,5000,2000,5000,10000]
[]
[null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$155:$G$221,3,TRUE))*1.1494","v":9135.4311999999991},{"$f":"(VLOOKUP($I$26,Tablas!$A$155:$G$221,4,TRUE))*1.1494","v":8291.7716},{"$f":"(VLOOKUP($I$26,Tablas!$A$155:$G$221,5,TRUE))*1.1494","v":6057.3379999999997},{"$f":"(VLOOKUP($I$26,Tablas!$A$155:$G$221,6,TRUE))*1.1494","v":4505.6480000000001}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$155:$G$221,3,TRUE))))*1.1494","v":7288.3454000000002},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$155:$G$221,4,TRUE))))*1.1494","v":6614.7969999999996},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$155:$G$221,5,TRUE))))*1.1494","v":4897.5933999999997},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$155:$G$221,6,TRUE))))*1.1494","v":3642.4485999999997}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$222:$G$224,3,TRUE))))*1.1494","v":5572.2911999999997},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$222:$G$224,4,TRUE))))*1.1494","v":5057.3599999999997},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$222:$G$224,5,TRUE))))*1.1494","v":3918.3045999999999},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$222:$G$224,6,TRUE))))*1.1494","v":2914.8784000000001}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G37:G39))","v":21996.067799999997},{"$f":"(SUM(H37:H39))","v":19963.928599999999},{"$f":"(SUM(I37:I39))","v":14873.235999999999},{"$f":"(SUM(J37:J39))","v":11062.975}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null," IVA (14.49%) ",null,{"$f":"(G41)*0%","v":0},{"$f":"(H41)*0%","v":0},{"$f":"(I41)*0%","v":0},{"$f":"(J41)*0%","v":0}]
[]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"SUM(G40:G42)","v":22082.067799999997},{"$f":"SUM(H40:H42)","v":20049.928599999999},{"$f":"SUM(I40:I42)","v":14959.235999999999},{"$f":"SUM(J40:J42)","v":11148.975}]
[]
[null,null,null,null,"Tarifas Semianuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$530:$G$596,3,TRUE))*1.1494","v":4841.7785360000007},{"$f":"(VLOOKUP($I$26,Tablas!$A$530:$G$596,4,TRUE))*1.1494","v":4394.6389479999998},{"$f":"(VLOOKUP($I$26,Tablas!$A$530:$G$596,5,TRUE))*1.1494","v":3210.3891400000002},{"$f":"(VLOOKUP($I$26,Tablas!$A$530:$G$596,6,TRUE))*1.1494","v":2387.9934399999997}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$530:$G$596,3,TRUE))))*1.1494","v":3862.8230619999999},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$530:$G$596,4,TRUE))))*1.1494","v":3505.8424100000002},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$530:$G$596,5,TRUE))))*1.1494","v":2595.724502},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$530:$G$596,6,TRUE))))*1.1494","v":1930.4977580000002}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$597:$G$599,3,TRUE))))*1.1494","v":2953.3143359999999},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$597:$G$599,4,TRUE))))*1.1494","v":2680.4007999999999},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$597:$G$599,5,TRUE))))*1.1494","v":2076.7014380000001},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$597:$G$599,6,TRUE))))*1.1494","v":1544.8855520000002}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G47:G49))","v":11657.915934000001},{"$f":"(SUM(H47:H49))","v":10580.882158},{"$f":"(SUM(I47:I49))","v":7882.8150800000003},{"$f":"(SUM(J47:J49))","v":5863.3767499999994}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null," IVA (14.49%) ",null,{"$f":"(G51)*0%","v":0},{"$f":"(H51)*0%","v":0},{"$f":"(I51)*0%","v":0},{"$f":"(J51)*0%","v":0}]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G50:G52)","v":11743.915934000001},{"$f":"SUM(H50:H52)","v":10666.882158},{"$f":"SUM(I50:I52)","v":7968.8150800000003},{"$f":"SUM(J50:J52)","v":5949.3767499999994}]
[null,null,null,null,"Costo de segunda cuota",null,{"$f":"G50+G52","v":11657.915934000001},{"$f":"H50+H52","v":10580.882158},{"$f":"I50+I52","v":7882.8150800000003},{"$f":"J50+J52","v":5863.3767499999994}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G53+G54","v":23401.831868000001},{"$f":"H53+H54","v":21247.764316000001},15851.630160000001,{"$f":"J53+J54","v":11812.753499999999}]
[]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$755:$G$821,3,TRUE))*1.1494","v":2512.2435800000003},{"$f":"(VLOOKUP($I$26,Tablas!$A$755:$G$821,4,TRUE))*1.1494","v":2280.2371900000003},{"$f":"(VLOOKUP($I$26,Tablas!$A$755:$G$821,5,TRUE))*1.1494","v":1665.7679500000002},{"$f":"(VLOOKUP($I$26,Tablas!$A$755:$G$821,6,TRUE))*1.1494","v":1239.0532000000001}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$755:$G$821,3,TRUE))))*1.1494","v":2004.294985},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$755:$G$821,4,TRUE))))*1.1494","v":1819.0691750000003},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$755:$G$821,5,TRUE))))*1.1494","v":1346.8381850000001},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$755:$G$821,6,TRUE))))*1.1494","v":1001.673365}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$822:$G$824,3,TRUE))))*1.1494","v":1532.3800800000001},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$822:$G$824,4,TRUE))))*1.1494","v":1390.7739999999999},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$822:$G$824,5,TRUE))))*1.1494","v":1077.5337649999999},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$822:$G$824,6,TRUE))))*1.1494","v":801.59156000000007}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G58:G60))","v":6048.9186450000007},{"$f":"(SUM(H58:H60))","v":5490.0803649999998},{"$f":"(SUM(I58:I60))","v":4090.1399000000001},{"$f":"(SUM(J58:J60))","v":3042.3181249999998}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null," IVA (14.49%) ",null,{"$f":"(G62)*0%","v":0},{"$f":"(H62)*0%","v":0},{"$f":"(I62)*0%","v":0},{"$f":"(J62)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G61:G63)","v":6134.9186450000007},{"$f":"SUM(H61:H63)","v":5576.0803649999998},{"$f":"SUM(I61:I63)","v":4176.1399000000001},{"$f":"SUM(J61:J63)","v":3128.3181249999998}]
[null,null,null,null,"Tres (3) cuotas adicionales, cada una de:",null,{"$f":"G61+G63","v":6048.9186450000007},{"$f":"H61+H63","v":5490.0803649999998},{"$f":"I61+I63","v":4090.1399000000001},{"$f":"J61+J63","v":3042.3181249999998}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G65+(G66*3)","v":24281.674580000003},{"$f":"H65+(H66*3)","v":22046.321459999999},16446.559600000001,{"$f":"J65+(J66*3)","v":12255.272499999999}]
[]
[]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$229:$G$295,3,TRUE))*1.1494","v":852.64024533333338},{"$f":"(VLOOKUP($I$26,Tablas!$A$229:$G$295,4,TRUE))*1.1494","v":773.89868266666667},{"$f":"(VLOOKUP($I$26,Tablas!$A$229:$G$295,5,TRUE))*1.1494","v":565.35154666666665},{"$f":"(VLOOKUP($I$26,Tablas!$A$229:$G$295,6,TRUE))*1.1494","v":420.52714666666668}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$229:$G$295,3,TRUE))))*1.1494","v":680.24557066666671},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A229:$G$295,4,TRUE))))*1.1494","v":617.38105333333328},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$229:$G$295,5,TRUE))))*1.1494","v":457.10871733333335},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$229:$G$295,6,TRUE))))*1.1494","v":339.96186933333337}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$296:$G$298,3,TRUE))))*1.1494","v":520.080512},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$296:$G$298,4,TRUE))))*1.1494","v":472.02026666666666},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$296:$G$298,5,TRUE))))*1.1494","v":365.70842933333336},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$296:$G$298,6,TRUE))))*1.1494","v":272.05531733333333}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"SUM(G71:G73)","v":2052.966328},{"$f":"SUM(H71:H73)","v":1863.3000026666666},{"$f":"SUM(I71:I73)","v":1388.1686933333335},{"$f":"SUM(J71:J73)","v":1032.5443333333333}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null," IVA (14.49%) ",null,{"$f":"(G75)*0%","v":0},{"$f":"(H75)*0%","v":0},{"$f":"(I75)*0%","v":0},{"$f":"(J75)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G74:G76)","v":2138.966328},{"$f":"SUM(H74:H76)","v":1949.3000026666666},{"$f":"SUM(I74:I76)","v":1474.1686933333335},{"$f":"SUM(J74:J76)","v":1118.5443333333333}]
[null,null,null,null,"Once (11) cuotas mensuales cada una de:",null,{"$f":"G74+G76","v":2052.966328},{"$f":"H74+H76","v":1863.3000026666666},{"$f":"I74+I76","v":1388.1686933333335},{"$f":"J74+J76","v":1032.5443333333333}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G78+(G79*11)","v":24721.595935999998},{"$f":"H78+(H79*11)","v":22445.600031999998},{"$f":"I78+(I79*11)","v":16744.024320000004},{"$f":"J78+(J79*11)","v":12476.531999999999}]
[]
[]
[null,null,null,null,"Tarifas en US$ -  Efectivas a partir del 1ro. de Enero de 2021"]
[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":"Global Select Health  Plan","index":4,"n_rows":84,"n_cols":10,"rows_kept":84,"cut":false,"hidden":false,"merged":[[83,4,84,9],[36,4,36,9],[46,4,46,9],[57,4,57,9],[70,4,70,9],[82,4,82,9],[74,4,74,5],[75,4,75,5],[67,0,67,1],[71,0,71,1],[82,0,82,1],[86,0,86,1],[96,0,96,1],[51,1,52,1],[51,0,52,0],[28,3,28,4],[61,4,61,5],[62,4,62,5],[30,0,30,1],[45,0,45,1],[50,0,50,1],[22,3,22,4],[25,3,25,4],[22,5,22,8],[25,0,26,1],[23,5,23,8]]}
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Nombre del Asegurado Titular",null,{"$f":"+'INGRESO DE DATOS'!$D$22","v":"JOHN DOE"}]
[null,null,null,null,"Cotizado por",{"$f":"+'INGRESO DE DATOS'!$D$28","v":"NOMBRE DE AGENTE"}]
[]
["Global Select Health Plan",null,null,"Número de adultos en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$D$24","v":2},null,"Edad del Asegurado Titular",{"$f":"+'INGRESO DE DATOS'!$D$26","v":49}]
[]
[null,null,null,null,null,null,null,"Edad del/la conyuge",{"$f":"+'INGRESO DE DATOS'!$H$26","v":39}]
[null,null,null,"Número de niños en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$H$24","v":3},null," "," "]
[]
[null,null,null,null,null,"Fecha de la cotización:",{"$f":"NOW()","v":"2020-12-16T16:14:06.940"}]
[null,null,null,null,null,null," ",false,null," "]
[null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4"]
[null,null,null,null,"En el país de residencia",null,250,2000,5000,10000]
[null,null,null,null,"Fuera del país de residencia",null,5000,2000,5000,10000]
[]
[null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$305:$G$371,3,TRUE))*1.1494","v":6323.9988000000003},{"$f":"(VLOOKUP($I$26,Tablas!$A$305:$G$371,4,TRUE))*1.1494","v":6066.5331999999999},{"$f":"(VLOOKUP($I$26,Tablas!$A$305:$G$371,5,TRUE))*1.1494","v":4440.1322},{"$f":"(VLOOKUP($I$26,Tablas!$A$305:$G$371,6,TRUE))*1.1494","v":3303.3755999999998}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$305:$G$371,3,TRUE))))*1.1494","v":4926.3284000000003},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$305:$G$371,4,TRUE))))*1.1494","v":4726.3328000000001},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$305:$G$371,5,TRUE))))*1.1494","v":3506.8193999999999},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$305:$G$371,6,TRUE))))*1.1494","v":2610.2874000000002}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$372:$G$374,3,TRUE))))*1.1494","v":4002.2107999999998},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$372:$G$374,4,TRUE))))*1.1494","v":3838.9960000000001},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$372:$G$374,5,TRUE))))*1.1494","v":2994.1869999999999},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$372:$G$374,6,TRUE))))*1.1494","v":2227.5371999999998}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G38:G40))","v":15252.538},{"$f":"(SUM(H38:H40))","v":14631.862000000001},{"$f":"(SUM(I38:I40))","v":10941.1386},{"$f":"(SUM(J38:J40))","v":8141.2002000000002}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null,"  IVA (14.49%)  ",null,{"$f":"(G42)*0%","v":0},{"$f":"(H42)*0%","v":0},{"$f":"(I42)*0%","v":0},{"$f":"(J42)*0%","v":0}]
[]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"SUM(G41:G43)","v":15338.538},{"$f":"SUM(H41:H43)","v":14717.862000000001},{"$f":"SUM(I41:I43)","v":11027.1386},{"$f":"SUM(J41:J43)","v":8227.2001999999993}]
[]
[null,null,null,null,"Tarifas Semianuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$605:$G$671,3,TRUE))*1.1494","v":3351.719364},{"$f":"(VLOOKUP($I$26,Tablas!$A$605:$G$671,4,TRUE))*1.1494","v":3215.262596},{"$f":"(VLOOKUP($I$26,Tablas!$A$605:$G$671,5,TRUE))*1.1494","v":2353.270066},{"$f":"(VLOOKUP($I$26,Tablas!$A$605:$G$671,6,TRUE))*1.1494","v":1750.789068}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$605:$G$671,3,TRUE))))*1.1494","v":2610.954052},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$605:$G$671,4,TRUE))))*1.1494","v":2504.9563840000001},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$605:$G$671,5,TRUE))))*1.1494","v":1858.614282},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$605:$G$671,6,TRUE))))*1.1494","v":1383.4523220000001}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$672:$G$674,3,TRUE))))*1.1494","v":2121.1717239999998},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$672:$G$674,4,TRUE))))*1.1494","v":2034.66788},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$672:$G$674,5,TRUE))))*1.1494","v":1586.91911},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$672:$G$674,6,TRUE))))*1.1494","v":1180.5947160000001}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G48:G50))","v":8083.8451399999994},{"$f":"(SUM(H48:H50))","v":7754.8868599999996},{"$f":"(SUM(I48:I50))","v":5798.8034579999994},{"$f":"(SUM(J48:J50))","v":4314.8361060000007}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null,"  IVA (14.49%)  ",null,{"$f":"(G52)*0%","v":0},{"$f":"(H52)*0%","v":0},{"$f":"(I52)*0%","v":0}]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G51:G53)","v":8169.8451399999994},{"$f":"SUM(H51:H53)","v":7840.8868599999996},{"$f":"SUM(I51:I53)","v":5884.8034579999994},{"$f":"SUM(J51:J53)","v":4400.8361060000007}]
[null,null,null,null,"Costo de segunda cuota",null,{"$f":"G51+G53","v":8083.8451399999994},{"$f":"H51+H53","v":7754.8868599999996},{"$f":"I51+I53","v":5798.8034579999994},{"$f":"J51+J53","v":4314.8361060000007}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G54+G55","v":16253.690279999999},{"$f":"H54+H55","v":15595.773719999999},11683.606915999999,8715.6722120000013]
[]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$830:$G$896,3,TRUE))*1.1494","v":1739.0996700000003},{"$f":"(VLOOKUP($I$26,Tablas!$A$830:$G$896,4,TRUE))*1.1494","v":1668.2966300000001},{"$f":"(VLOOKUP($I$26,Tablas!$A$830:$G$896,5,TRUE))*1.1494","v":1221.036355},{"$f":"(VLOOKUP($I$26,Tablas!$A$830:$G$896,6,TRUE))*1.1494","v":908.42829000000006}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$830:$G$896,3,TRUE))))*1.1494","v":1354.7403100000001},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$830:$G$896,4,TRUE))))*1.1494","v":1299.7415200000003},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$830:$G$896,5,TRUE))))*1.1494","v":964.37533500000006},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$830:$G$896,6,TRUE))))*1.1494","v":717.82903500000009}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$897:$G$899,3,TRUE))))*1.1494","v":1100.60797},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$897:$G$899,4,TRUE))))*1.1494","v":1055.7239000000002},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$897:$G$899,5,TRUE))))*1.1494","v":823.40142500000013},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$897:$G$899,6,TRUE))))*1.1494","v":612.57273000000009}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G59:G61))","v":4194.4479500000007},{"$f":"(SUM(H59:H61))","v":4023.7620500000003},{"$f":"(SUM(I59:I61))","v":3008.8131149999999},{"$f":"(SUM(J59:J61))","v":2238.8300550000004}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null,"  IVA (14.49%)  ",null,{"$f":"(G63)*0%","v":0},{"$f":"(H63)*0%","v":0},{"$f":"(I63)*0%","v":0},{"$f":"(J63)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G62:G64)","v":4280.4479500000007},{"$f":"SUM(H62:H64)","v":4109.7620500000003},{"$f":"SUM(I62:I64)","v":3094.8131149999999},{"$f":"SUM(J62:J64)","v":2324.8300550000004}]
[null,null,null,null,"Tres (3) cuotas adicionales, cada una de:",null,{"$f":"G62+G64","v":4194.4479500000007},{"$f":"H62+H64","v":4023.7620500000003},{"$f":"I62+I64","v":3008.8131149999999},{"$f":"J62+J64","v":2238.8300550000004}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G66+(G67*3)","v":16863.791800000003},{"$f":"H66+(H67*3)","v":16181.048200000001},12121.25246,{"$f":"J66+(J67*3)","v":9041.3202200000014}]
[]
[]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$379:$G$445,3,TRUE))*1.1494","v":590.23988799999995},{"$f":"(VLOOKUP($I$26,Tablas!$A$379:$G$445,4,TRUE))*1.1494","v":566.20976533333328},{"$f":"(VLOOKUP($I$26,Tablas!$A$379:$G$445,5,TRUE))*1.1494","v":414.4123386666667},{"$f":"(VLOOKUP($I$26,Tablas!$A$379:$G$445,6,TRUE))*1.1494","v":308.31505600000003}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$379:$G$445,3,TRUE))))*1.1494","v":459.79065066666669},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$379:$G$445,4,TRUE))))*1.1494","v":441.12439466666666},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$379:$G$445,5,TRUE))))*1.1494","v":327.30314399999997},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$379:$G$445,6,TRUE))))*1.1494","v":243.626824}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$446:$G$448,3,TRUE))))*1.1494","v":373.53967466666666},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$446:$G$448,4,TRUE))))*1.1494","v":358.30629333333337},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$446:$G$448,5,TRUE))))*1.1494","v":279.45745333333338},{"$f":"(IF($F$29=0,0,(VLOOKUP($F$29,Tablas!$A$446:$G$448,6,TRUE))))*1.1494","v":207.90347199999999}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G72:G74))","v":1423.5702133333334},{"$f":"(SUM(H72:H74))","v":1365.6404533333332},{"$f":"(SUM(I72:I74))","v":1021.1729360000002},{"$f":"(SUM(J72:J74))","v":759.84535200000005}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null,"  IVA (14.49%)  ",null,{"$f":"(G76)*0%","v":0},{"$f":"(H76)*0%","v":0},{"$f":"(I76)*0%","v":0},{"$f":"(J76)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G75:G77)","v":1509.5702133333334},{"$f":"SUM(H75:H77)","v":1451.6404533333332},{"$f":"SUM(I75:I77)","v":1107.1729360000002},{"$f":"SUM(J75:J77)","v":845.84535200000005}]
[null,null,null,null,"Once (11) cuotas mensuales cada una de:",null,{"$f":"G75+G77","v":1423.5702133333334},{"$f":"H75+H77","v":1365.6404533333332},{"$f":"I75+I77","v":1021.1729360000002},{"$f":"J75+J77","v":759.84535200000005}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G79+(G80*11)","v":17168.842560000001},{"$f":"H79+(H80*11)","v":16473.685439999997},{"$f":"I79+(I80*11)","v":12340.075232000003},{"$f":"J79+(J80*11)","v":9204.1442240000015}]
[]
[null,null,null,null,"Tarifas en US$ -  Efectivas a partir del 1ro. de Enero de 2021"]
[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":"Global Major Medical Health  Pl","index":5,"n_rows":138,"n_cols":22,"rows_kept":138,"cut":false,"hidden":false,"merged":[[96,0,96,1],[50,0,50,1],[67,0,67,1],[71,0,71,1],[82,0,82,1],[86,0,86,1],[51,0,52,0],[51,1,52,1],[81,4,83,7],[80,4,80,7],[60,4,60,5],[61,4,61,5],[72,4,72,5],[73,4,73,5],[68,4,68,7],[22,0,23,1],[23,5,23,8],[30,0,30,1],[45,0,45,1],[56,4,56,7],[27,3,27,4],[22,3,22,4],[22,5,22,8],[25,3,25,4],[45,4,45,7],[35,4,35,7]]}
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Global Major Medical Health Plan",null,null,"Nombre del Asegurado Titular",null,{"$f":"+'INGRESO DE DATOS'!$D$22","v":"JOHN DOE"}]
[null,null,null,null,"Cotizado Por",{"$f":"+'INGRESO DE DATOS'!$D$28","v":"NOMBRE DE AGENTE"}]
[]
[null,null,null,"Número de adultos en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$D$24","v":2},null,"Edad del Asegurado Titular",{"$f":"+'INGRESO DE DATOS'!$D$26","v":49}]
[]
[null,null,null,"Número de niños en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$H$24","v":3},null,"Edad del/la conyuge",{"$f":"+'INGRESO DE DATOS'!$H$26","v":39}]
[null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,"Fecha de la cotización:",{"$f":"NOW()","v":"2020-12-16T16:14:06.940"}]
[null,null,null,null,null,null," ",false,null," "]
[null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2"]
[null,null,null,null,"En el país de residencia",null,10000,20000]
[null,null,null,null,"Fuera del país de residencia",null,10000,20000]
[]
[null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$1129:$G$1195,3,TRUE))*1.1494","v":3914.8564000000001},{"$f":"(VLOOKUP($I$26,Tablas!$A$1129:$G$1195,4,TRUE))*1.1494","v":2975.7966000000001}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$1129:$G$1195,3,TRUE))))*1.1494","v":3120.6210000000001},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$1129:$G$1195,4,TRUE))))*1.1494","v":2370.0628000000002}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$1196:$G$1198,3,TRUE))))*1.1494","v":2370.0628000000002},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$1196:$G$1198,4,TRUE))))*1.1494","v":1859.7292}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G37:G39))","v":9405.5401999999995},{"$f":"(SUM(H37:H39))","v":7205.5886}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G41)*0%","v":0},{"$f":"(H41)*0%","v":0}]
[]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"SUM(G40:G42)","v":9491.5401999999995},{"$f":"SUM(H40:H42)","v":7291.5886}]
[]
[null,null,null,null,"Tarifas Semianuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$1353:$G$1419,3,TRUE))*1.1494","v":2074.8738920000001},{"$f":"(VLOOKUP($I$26,Tablas!$A$1353:$G$1419,4,TRUE))*1.1494","v":1577.172198}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$1353:$G$1419,3,TRUE))))*1.1494","v":1653.92913},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$1353:$G$1419,4,TRUE))))*1.1494","v":1256.1332840000002}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$1420:$G$1422,3,TRUE))))*1.1494","v":1256.1332840000002},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$1420:$G$1422,4,TRUE))))*1.1494","v":985.65647600000011}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G47:G49))","v":4984.9363060000005},{"$f":"(SUM(H47:H49))","v":3818.9619580000003}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G51)*0%","v":0},{"$f":"(H51)*0%","v":0}]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G50:G52)","v":5070.9363060000005},{"$f":"SUM(H50:H52)","v":3904.9619580000003}]
[null,null,null,null,"Costo de segunda cuota",null,{"$f":"G50+G52","v":4984.9363060000005},{"$f":"H50+H52","v":3818.9619580000003}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G53+G54","v":10055.872612000001},{"$f":"H53+H54","v":7723.9239160000006}]
[]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$1278:$G$1344,3,TRUE))*1.1494","v":1076.5855100000001},{"$f":"(VLOOKUP($I$26,Tablas!$A$1278:$G$1344,4,TRUE))*1.1494","v":818.344065}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$1278:$G$1344,3,TRUE))))*1.1494","v":858.17077500000016},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$1278:$G$1344,4,TRUE))))*1.1494","v":651.76727000000005}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$1345:$G$1347,3,TRUE))))*1.1494","v":651.76727000000005},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$1345:$G$1347,4,TRUE))))*1.1494","v":511.42553000000004}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G58:G60))","v":2586.5235550000007},{"$f":"(SUM(H58:H60))","v":1981.536865}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G62)*0%","v":0},{"$f":"(H62)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G61:G63)","v":2672.5235550000007},{"$f":"SUM(H61:H63)","v":2067.536865}]
[null,null,null,null,"Tres (3) cuotas adicionales, cada una de:",null,{"$f":"G61+G63","v":2586.5235550000007},{"$f":"H61+H63","v":1981.536865}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G65+(G66*3)","v":10432.094220000003},{"$f":"H65+(H66*3)","v":8012.1474600000001}]
[]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$26,Tablas!$A$1203:$G$1269,3,TRUE))*1.1494","v":365.38659733333338},{"$f":"(VLOOKUP($I$26,Tablas!$A$1203:$G$1269,4,TRUE))*1.1494","v":277.741016}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$1203:$G$1269,3,TRUE))))*1.1494","v":291.25796000000003},{"$f":"(IF($F$26=1,0,(VLOOKUP($I$28,Tablas!$A$1203:$G$1269,4,TRUE))))*1.1494","v":221.20586133333333}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$1270:$G$1272,3,TRUE))))*1.1494","v":221.20586133333333},{"$f":"(IF($F$28=0,0,(VLOOKUP($F$28,Tablas!$A$1270:$G$1272,4,TRUE))))*1.1494","v":173.57472533333336}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G70:G72))","v":877.85041866666677},{"$f":"(SUM(H70:H72))","v":672.52160266666669}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G74)*0%","v":0},{"$f":"(H74)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G73:G75)","v":963.85041866666677},{"$f":"SUM(H73:H75)","v":758.52160266666669}]
[null,null,null,null,"Once (11) cuotas mensuales cada una de:",null,{"$f":"G73+G75","v":877.85041866666677},{"$f":"H73+H75","v":672.52160266666669}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G77+(G78*11)","v":10620.205024000001},{"$f":"H77+(H78*11)","v":8156.2592320000003}]
[]
[null,null,null,null,"Tarifas en US$ -  Efectivas a partir del 1ro. de Enero de 2021"]
[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,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"       "]

{"sheet":"Resumen tarifas","index":6,"n_rows":106,"n_cols":8,"rows_kept":106,"cut":false,"hidden":false,"merged":[[104,0,104,7],[70,4,70,7],[77,4,77,7],[79,4,79,7],[81,4,81,7],[83,4,83,7],[78,0,78,1],[91,0,91,1],[92,0,92,1],[74,1,74,3],[77,0,77,1],[101,0,101,3],[100,0,100,3],[64,4,64,7],[66,4,66,7],[68,4,68,7],[50,3,50,7],[52,3,52,7],[54,3,54,7],[22,2,22,6],[58,0,58,2],[53,0,53,1],[54,0,54,1],[55,0,55,1],[38,2,38,3],[40,2,40,3],[41,0,41,1],[27,0,27,1],[50,0,50,1],[51,0,51,1],[42,2,42,3],[52,0,52,1],[56,3,56,7],[105,0,107,6],[87,0,87,1],[90,0,90,1],[79,0,79,1],[86,0,86,2],[90,2,90,3],[82,0,82,1],[80,0,80,1],[81,0,81,1],[93,0,93,1],[102,0,102,1],[92,2,92,3],[94,2,94,3],[94,0,94,1],[95,0,95,1],[96,2,96,3],[19,0,19,6],[46,0,46,1],[21,2,21,6],[24,4,24,5],[27,4,27,5],[32,0,32,1],[33,0,33,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[44,0,44,1],[36,2,36,3],[21,0,21,1],[24,0,24,1],[61,0,61,1],[69,0,69,1],[64,0,64,1],[65,0,65,1],[66,0,66,1],[67,0,67,1],[68,0,68,1]]}
[]
[null,null,null,null," "," "]
[]
[]
[]
[null,null,null,null," "," "," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Cotización de Seguro Médico - Global Health Plans"]
[]
["Nombre del Asegurado Titular",null,{"$f":"+'INGRESO DE DATOS'!$D$22","v":"JOHN DOE"}]
[null,"Cotizado por",{"$f":"+'INGRESO DE DATOS'!$D$28","v":"NOMBRE DE AGENTE"}]
[]
["Número de adultos en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$D$24","v":2},null,"Edad del Asegurado Titular",null,{"$f":"+'INGRESO DE DATOS'!$D$26","v":49}]
[]
[]
["Número de niños en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$H$24","v":3},null,"Edad del/la cónyuge ",null,{"$f":"+'INGRESO DE DATOS'!$H$26","v":39}]
[]
[]
[null,null,"Fecha de la Cotización:",{"$f":"NOW()","v":"2020-12-16T16:14:06.940"}]
[]
["Bupa Global Ultimtate Health Plan"]
["Deducibles",null,"PLAN 1","PLAN 2"]
["En el país de residencia",null,0,1000]
["Fuera del país de residencia",null,0,1000]
[null,null,"Tarifas Anuales"]
[null,null,{"$f":"'Global Ultimate Health  Plan'!G41","v":66745.452999999994},{"$f":"'Global Ultimate Health  Plan'!H41","v":43095.3986}]
[null,null,"Tarifas Semi-anuales"]
[null,null,{"$f":"'Global Ultimate Health  Plan'!G52","v":35329.510090000003},{"$f":"'Global Ultimate Health  Plan'!H52","v":22794.981258}]
[null,null,"Tarifas Trimestrales"]
[null,null,{"$f":"'Global Ultimate Health  Plan'!G65","v":18331.349575},{"$f":"'Global Ultimate Health  Plan'!H65","v":11827.584615}]
[null,null,"Tarifas Mensuales"]
[null,null,{"$f":"'Global Ultimate Health  Plan'!G80","v":6221.5489466666677},{"$f":"'Global Ultimate Health  Plan'!H80","v":4014.2105360000005}]
["Ahorros en tarifas de prima para niños*",null,{"$f":"'Global Ultimate Health  Plan'!G42","v":11415.8408},{"$f":"'Global Ultimate Health  Plan'!H42","v":7367.6539999999995}]
[]
["Bupa Global Elite Health Plan"]
["Deducibles",null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5"]
["En el país de residencia",null,null,250,2000,3500,5000,10000]
["Fuera del país de residencia",null,null,5000,2000,3500,5000,10000]
[null,null,null,"Tarifas Anuales"]
[null,null,null,{"$f":"+'Global Elite Health  Plan'!G40","v":31083.019199999995},{"$f":"+'Global Elite Health  Plan'!H40","v":27253.218399999998},{"$f":"+'Global Elite Health  Plan'!I40","v":22655.618399999999},{"$f":"+'Global Elite Health  Plan'!J40","v":19657.983199999999},{"$f":"+'Global Elite Health  Plan'!K40","v":15263.826999999999}]
[null,null,null,"Tarifas Semi-anuales"]
[null,null,null,{"$f":"+'Global Elite Health  Plan'!G51","v":16428.420176},{"$f":"+'Global Elite Health  Plan'!H51","v":14398.625752},{"$f":"+'Global Elite Health  Plan'!I51","v":11961.897752000001},{"$f":"+'Global Elite Health  Plan'!J51","v":10373.151096},{"$f":"+'Global Elite Health  Plan'!K51","v":8044.2483100000009}]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,{"$f":"+'Global Elite Health  Plan'!G64","v":8524.1802800000005},{"$f":"+'Global Elite Health  Plan'!H64","v":7470.9850600000009},{"$f":"+'Global Elite Health  Plan'!I64","v":6206.6450600000007},{"$f":"+'Global Elite Health  Plan'!J64","v":5382.2953800000005},{"$f":"+'Global Elite Health  Plan'!K64","v":4173.9024250000002}]
[null,null,null,"Tarifas Mensuales"]
[null,null,null,{"$f":"+'Global Elite Health  Plan'!G78","v":2893.0551253333333},{"$f":"+'Global Elite Health  Plan'!H78","v":2535.607050666667},{"$f":"+'Global Elite Health  Plan'!I78","v":2106.4977173333336},{"$f":"+'Global Elite Health  Plan'!J78","v":1826.7184319999999},{"$f":"+'Global Elite Health  Plan'!K78","v":1416.5971866666669}]
["Ahorros en tarifas de prima para niños*",null,null,{"$f":"+'Global Elite Health  Plan'!G41","v":2474.6581999999999},{"$f":"+'Global Elite Health  Plan'!H41","v":2166.6190000000001},{"$f":"+'Global Elite Health  Plan'!I41","v":1844.787},{"$f":"+'Global Elite Health  Plan'!J41","v":1598.8154},{"$f":"+'Global Elite Health  Plan'!K41","v":1241.3519999999999}]
[]
["Bupa Global Premier Health Plan"]
["Deducibles",null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4"]
["En el país de residencia",null,null,null,250,2000,5000,10000]
["Fuera del país de residencia",null,null,null,5000,2000,5000,10000]
[null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,{"$f":"+'Global Premier Health  Plan'!G44","v":22082.067799999997},{"$f":"+'Global Premier Health  Plan'!H44","v":20049.928599999999},{"$f":"+'Global Premier Health  Plan'!I44","v":14959.235999999999},{"$f":"+'Global Premier Health  Plan'!J44","v":11148.975}]
[null,null,null,null,"Tarifas Semi-anuales"]
[null,null,null,null,{"$f":"+'Global Premier Health  Plan'!G54","v":11657.915934000001},{"$f":"+'Global Premier Health  Plan'!H54","v":10580.882158},{"$f":"+'Global Premier Health  Plan'!I54","v":7882.8150800000003},{"$f":"+'Global Premier Health  Plan'!J54","v":5863.3767499999994}]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,{"$f":"+'Global Premier Health  Plan'!G66","v":6048.9186450000007},{"$f":"+'Global Premier Health  Plan'!H66","v":5490.0803649999998},{"$f":"+'Global Premier Health  Plan'!I66","v":4090.1399000000001},{"$f":"+'Global Premier Health  Plan'!J66","v":3042.3181249999998}]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,{"$f":"+'Global Premier Health  Plan'!G79","v":2052.966328},{"$f":"+'Global Premier Health  Plan'!H79","v":1863.3000026666666},{"$f":"+'Global Premier Health  Plan'!I79","v":1388.1686933333335},{"$f":"+'Global Premier Health  Plan'!J79","v":1032.5443333333333}]
[]
["Bupa Global Select Health Plan"]
["Deducibles",null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4"]
[" En el país de residencia ",null,null,null,250,2000,5000,10000]
[" Fuera del país de residencia ",null,null,null,5000,2000,5000,10000]
[null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,{"$f":"+'Global Select Health  Plan'!G45","v":15338.538},{"$f":"+'Global Select Health  Plan'!H45","v":14717.862000000001},{"$f":"+'Global Select Health  Plan'!I45","v":11027.1386},{"$f":"+'Global Select Health  Plan'!J45","v":8227.2001999999993}]
[null,null,null,null,"Tarifas Semi-anuales"]
[null,null,null,null,{"$f":"+'Global Select Health  Plan'!G55","v":8083.8451399999994},{"$f":"+'Global Select Health  Plan'!H55","v":7754.8868599999996},{"$f":"+'Global Select Health  Plan'!I55","v":5798.8034579999994},{"$f":"+'Global Select Health  Plan'!J55","v":4314.8361060000007}]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,{"$f":"+'Global Select Health  Plan'!G67","v":4194.4479500000007},{"$f":"+'Global Select Health  Plan'!H67","v":4023.7620500000003},{"$f":"+'Global Select Health  Plan'!I67","v":3008.8131149999999},{"$f":"+'Global Select Health  Plan'!J67","v":2238.8300550000004}]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,{"$f":"+'Global Select Health  Plan'!G80","v":1423.5702133333334},{"$f":"+'Global Select Health  Plan'!H80","v":1365.6404533333332},{"$f":"+'Global Select Health  Plan'!I80","v":1021.1729360000002},{"$f":"+'Global Select Health  Plan'!J80","v":759.84535200000005}]
[]
["Bupa Global Major Medical Health Plan"]
["Deducibles",null,"PLAN 1","PLAN 2"]
[" En el país de residencia ",null,10000,20000]
[" Fuera del país de residencia ",null,10000,20000]
[null,null,"Tarifas Anuales"]
[null,null,{"$f":"'Global Major Medical Health  Pl'!G44","v":9491.5401999999995},{"$f":"'Global Major Medical Health  Pl'!H44","v":7291.5886}]
[null,null,"Tarifas Semi-anuales"]
[null,null,{"$f":"'Global Major Medical Health  Pl'!G54","v":4984.9363060000005},{"$f":"'Global Major Medical Health  Pl'!H54","v":3818.9619580000003}]
[null,null,"Tarifas Trimestrales"]
[null,null,{"$f":"'Global Major Medical Health  Pl'!G66","v":2586.5235550000007},{"$f":"'Global Major Medical Health  Pl'!H66","v":1981.536865}]
[null,null,"Tarifas Mensuales"]
[null,null,{"$f":"'Global Major Medical Health  Pl'!G78","v":877.85041866666677},{"$f":"'Global Major Medical Health  Pl'!H78","v":672.52160266666669}]
[]
["Notas:"]
["Primas anuales incluyen US$86.00 por Costo Administrativo Anual"]
["Costo administrativo anual incluido en el primer pago de los pagos semestrales, trimestrales y mensuales"]
["*Basado en un modo de pago anual"]
[]
["Tarifas en US$ -  Efectivas a partir del 1ro. de Enero de 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":"Tablas","index":7,"n_rows":1497,"n_cols":13,"rows_kept":1497,"cut":false,"hidden":true,"merged":[[1424,0,1424,6],[1425,0,1425,1],[1425,2,1425,6],[1348,0,1348,6],[1349,0,1349,6],[1350,0,1350,1],[1350,2,1350,6],[1423,0,1423,6],[1200,0,1200,1],[1200,2,1200,6],[1273,0,1273,6],[1274,0,1274,6],[1275,0,1275,1],[1275,2,1275,6],[1124,0,1124,6],[1125,0,1125,6],[1126,0,1126,1],[1126,2,1126,6],[1199,0,1199,6],[976,0,976,1],[976,2,976,6],[1049,0,1049,6],[1050,0,1050,6],[1051,0,1051,1],[1051,2,1051,6],[900,0,900,6],[901,0,901,6],[902,0,902,1],[902,2,902,6],[975,0,975,6],[1,0,1,6],[2,0,2,6],[77,0,77,1],[77,2,77,6],[76,0,76,6],[3,0,3,1],[3,2,3,6],[376,0,376,1],[376,2,376,6],[150,0,150,6],[151,0,151,6],[152,0,152,1],[152,2,152,6],[225,0,225,6],[226,0,226,1],[375,0,375,6],[226,2,226,6],[300,0,300,6],[301,0,301,6],[302,0,302,1],[302,2,302,6],[526,0,526,6],[450,0,450,6],[451,0,451,6],[452,0,452,1],[452,2,452,6],[525,0,525,6],[527,0,527,1],[527,2,527,6],[600,0,600,6],[601,0,601,6],[602,0,602,1],[602,2,602,6],[751,0,751,6],[675,0,675,6],[676,0,676,6],[677,0,677,1],[677,2,677,6],[750,0,750,6],[752,0,752,1],[752,2,752,6],[825,0,825,6],[826,0,826,6],[827,0,827,1],[827,2,827,6]]}
[]
["BUPA GLOBAL ELITE",null,null,null,null,null,null,null,"FACTOR MENSUAL:",null,9.3333333333333338E-2]
["TARIFAS ANUALES",null,null,null,null,null,null,null,"FACTOR TRIMESTRAL:",null,0.27500000000000002]
["EDAD",null,null,null,null,null,null,null,"FACTOR SEMIANUAL:",null,0.53]
[" "," ",250,2000,3500,5000,10000]
[18,null,7275,6375,5390,4676,3626,null,true,true,true,true,true]
[19,null,7275,6375,5390,4676,3626]
[20,null,7275,6375,5390,4676,3626]
[21,null,7275,6375,5390,4676,3626]
[22,null,7275,6375,5390,4676,3626]
[23,null,7275,6375,5390,4676,3626]
[24,null,7275,6375,5390,4676,3626]
[25,null,7772,6812,5725,4964,3851,null,true,true,true,true,true]
[26,null,7772,6812,5725,4964,3851]
[27,null,7772,6812,5725,4964,3851]
[28,null,7772,6812,5725,4964,3851]
[29,null,7772,6812,5725,4964,3851]
[30,null,8643,7576,6319,5478,4249,null,true,true,true,true,true]
[31,null,8643,7576,6319,5478,4249]
[32,null,8643,7576,6319,5478,4249]
[33,null,8643,7576,6319,5478,4249]
[34,null,8643,7576,6319,5478,4249]
[35,null,9649,8455,7012,6081,4716,null,true,true,true,true,true]
[36,null,9649,8455,7012,6081,4716]
[37,null,9649,8455,7012,6081,4716]
[38,null,9649,8455,7012,6081,4716]
[39,null,9649,8455,7012,6081,4716]
[40,null,10807,9471,7819,6780,5260,null,true,true,true,true,true]
[41,null,10807,9471,7819,6780,5260]
[42,null,10807,9471,7819,6780,5260]
[43,null,10807,9471,7819,6780,5260]
[44,null,10807,9471,7819,6780,5260]
[45,null,12094,10600,8724,7564,5866,null,true,true,true,true,true]
[46,null,12094,10600,8724,7564,5866]
[47,null,12094,10600,8724,7564,5866]
[48,null,12094,10600,8724,7564,5866]
[49,null,12094,10600,8724,7564,5866]
[50,null,13541,11870,9745,8451,6554,null,true,true,true,true,true]
[51,null,13541,11870,9745,8451,6554]
[52,null,13541,11870,9745,8451,6554]
[53,null,13541,11870,9745,8451,6554]
[54,null,13541,11870,9745,8451,6554]
[55,null,15138,13270,10880,9435,7318,null,true,true,true,true,true]
[56,null,15138,13270,10880,9435,7318]
[57,null,15138,13270,10880,9435,7318]
[58,null,15138,13270,10880,9435,7318]
[59,null,15138,13270,10880,9435,7318]
[60,null,16202,14202,11635,10089,7824,null,true,true,true,true,true]
[61,null,18054,15826,12959,11239,8715,null,true,true,true,true,true]
[62,null,20058,17581,14394,12480,9678,null,true,true,true,true,true]
[63,null,22210,19470,15940,13821,10719,null,true,true,true,true,true]
[64,null,24517,21488,17596,15258,11832,null,true,true,true,true,true]
[65,null,26972,23643,19366,16793,13024,null,true,true,true,true,true]
[66,null,29581,25929,21247,18424,14290,null,true,true,true,true,true]
[67,null,32340,28346,23242,20153,15630,null,true,true,true,true,true]
[68,null,35249,30897,25348,21980,17047,null,true,true,true,true,true]
[69,null,38312,33580,27567,23905,18539,null,true,true,true,true,true]
[70,null,41523,36396,29896,25925,20105,null,true,true,true,true,true]
[71,null,44886,39344,32340,28043,21748,null,true,true,true,true,true]
[72,null,48401,42427,34894,30256,23465,null,true,true,true,true,true]
[73,null,52068,45639,37563,32570,25259,null,true,true,true,true,true]
[74,null,55886,48984,40341,34980,27128,null,true,true,true,true,true]
[75,null,59854,52463,43231,37486,29071,null,true,true,true,true,true]
[76,null,59854,52463,43231,37486,29071]
[77,null,59854,52463,43231,37486,29071]
[78,null,59854,52463,43231,37486,29071]
[79,null,59854,52463,43231,37486,29071]
[80,null,59854,52463,43231,37486,29071]
[81,null,59854,52463,43231,37486,29071]
[82,null,59854,52463,43231,37486,29071]
[83,null,59854,52463,43231,37486,29071]
[84,"o más",59854,52463,43231,37486,29071]
[1,"Hijo",3075,2695,2294,1990,1543,null,true,true,true,true,true]
[2,"Hijos",5225,4581,3900,3383,2623,null,true,true,true,true,true]
[3,"Hijos o más",7378,6466,5505,4774,3703,null,true,true,true,true,true]
[]
["BUPA GLOBAL ELITE - MENSUALES"]
["EDAD"]
[" "," ",1000,2000,3500]
[18,null,{"$f":"C6*$K$2","v":679},{"$f":"D6*$K$2","v":595},503.06666666666666,436.42666666666668,338.42666666666668]
[19,null,{"$f":"C7*$K$2","v":679},595,503.06666666666666,436.42666666666668,338.42666666666668]
[20,null,679,595,503.06666666666666,436.42666666666668,338.42666666666668]
[21,null,679,595,503.06666666666666,436.42666666666668,338.42666666666668]
[22,null,679,595,503.06666666666666,436.42666666666668,338.42666666666668]
[23,null,679,595,503.06666666666666,436.42666666666668,338.42666666666668]
[24,null,679,595,503.06666666666666,436.42666666666668,338.42666666666668]
[25,null,725.38666666666666,635.78666666666675,534.33333333333337,463.30666666666667,359.42666666666668]
[26,null,725.38666666666666,635.78666666666675,534.33333333333337,463.30666666666667,359.42666666666668]
[27,null,725.38666666666666,635.78666666666675,534.33333333333337,463.30666666666667,359.42666666666668]
[28,null,725.38666666666666,635.78666666666675,534.33333333333337,463.30666666666667,359.42666666666668]
[29,null,725.38666666666666,635.78666666666675,534.33333333333337,463.30666666666667,359.42666666666668]
[30,null,806.68000000000006,707.09333333333336,589.77333333333331,511.28000000000003,396.57333333333332]
[31,null,806.68000000000006,707.09333333333336,589.77333333333331,511.28000000000003,396.57333333333332]
[32,null,806.68000000000006,707.09333333333336,589.77333333333331,511.28000000000003,396.57333333333332]
[33,null,806.68000000000006,707.09333333333336,589.77333333333331,511.28000000000003,396.57333333333332]
[34,null,806.68000000000006,707.09333333333336,589.77333333333331,511.28000000000003,396.57333333333332]
[35,null,900.57333333333338,789.13333333333333,654.45333333333338,567.56000000000006,440.16]
[36,null,900.57333333333338,789.13333333333333,654.45333333333338,567.56000000000006,440.16]
[37,null,900.57333333333338,789.13333333333333,654.45333333333338,567.56000000000006,440.16]
[38,null,900.57333333333338,789.13333333333333,654.45333333333338,567.56000000000006,440.16]
[39,null,900.57333333333338,789.13333333333333,654.45333333333338,567.56000000000006,440.16]
[40,null,1008.6533333333334,883.96,729.77333333333331,632.80000000000007,490.93333333333334]
[41,null,1008.6533333333334,883.96,729.77333333333331,632.80000000000007,490.93333333333334]
[42,null,1008.6533333333334,883.96,729.77333333333331,632.80000000000007,490.93333333333334]
[43,null,1008.6533333333334,883.96,729.77333333333331,632.80000000000007,490.93333333333334]
[44,null,1008.6533333333334,883.96,729.77333333333331,632.80000000000007,490.93333333333334]
[45,null,1128.7733333333333,989.33333333333337,814.24,705.97333333333336,547.49333333333334]
[46,null,1128.7733333333333,989.33333333333337,814.24,705.97333333333336,547.49333333333334]
[47,null,1128.7733333333333,989.33333333333337,814.24,705.97333333333336,547.49333333333334]
[48,null,1128.7733333333333,989.33333333333337,814.24,705.97333333333336,547.49333333333334]
[49,null,1128.7733333333333,989.33333333333337,814.24,705.97333333333336,547.49333333333334]
[50,null,1263.8266666666668,1107.8666666666668,909.53333333333342,788.76,611.70666666666671]
[51,null,1263.8266666666668,1107.8666666666668,909.53333333333342,788.76,611.70666666666671]
[52,null,1263.8266666666668,1107.8666666666668,909.53333333333342,788.76,611.70666666666671]
[53,null,1263.8266666666668,1107.8666666666668,909.53333333333342,788.76,611.70666666666671]
[54,null,1263.8266666666668,1107.8666666666668,909.53333333333342,788.76,611.70666666666671]
[55,null,1412.88,1238.5333333333333,1015.4666666666667,880.6,683.01333333333332]
[56,null,1412.88,1238.5333333333333,1015.4666666666667,880.6,683.01333333333332]
[57,null,1412.88,1238.5333333333333,1015.4666666666667,880.6,683.01333333333332]
[58,null,1412.88,1238.5333333333333,1015.4666666666667,880.6,683.01333333333332]
[59,null,1412.88,1238.5333333333333,1015.4666666666667,880.6,683.01333333333332]
[60,null,1512.1866666666667,1325.52,1085.9333333333334,941.64,730.24]
[61,null,1685.04,1477.0933333333335,1209.5066666666667,1048.9733333333334,813.40000000000009]
[62,null,1872.0800000000002,1640.8933333333334,1343.44,1164.8,903.28000000000009]
[63,null,2072.9333333333334,1817.2,1487.7333333333333,1289.96,1000.44]
[64,null,2288.2533333333336,2005.5466666666669,1642.2933333333335,1424.0800000000002,1104.3200000000002]
[65,null,2517.3866666666668,2206.6800000000003,1807.4933333333333,1567.3466666666668,1215.5733333333335]
[66,null,2760.8933333333334,2420.04,1983.0533333333335,1719.5733333333335,{"$f":"G54*$K$2","v":1333.7333333333333}]
[67,null,3018.4,2645.626666666667,2169.2533333333336,1880.9466666666667,1458.8]
[68,null,3289.9066666666668,2883.7200000000003,2365.8133333333335,2051.4666666666667,1591.0533333333335]
[69,null,3575.7866666666669,3134.1333333333337,2572.92,2231.1333333333332,1730.3066666666668]
[70,null,3875.48,3396.96,2790.2933333333335,2419.666666666667,1876.4666666666667]
[71,null,4189.3600000000006,3672.106666666667,3018.4,2617.3466666666668,2029.8133333333335]
[72,null,4517.4266666666672,3959.8533333333335,3256.7733333333335,2823.8933333333334,2190.0666666666666]
[73,null,4859.68,4259.6400000000003,3505.88,3039.8666666666668,2357.5066666666667]
[74,null,5216.0266666666666,4571.84,3765.1600000000003,3264.8,2531.9466666666667]
[75,null,5586.3733333333339,4896.5466666666671,4034.8933333333334,3498.6933333333336,2713.2933333333335]
[76,null,5586.3733333333339,4896.5466666666671,4034.8933333333334,3498.6933333333336,2713.2933333333335]
[77,null,5586.3733333333339,4896.5466666666671,4034.8933333333334,3498.6933333333336,2713.2933333333335]
[78,null,5586.3733333333339,4896.5466666666671,4034.8933333333334,3498.6933333333336,2713.2933333333335]
[79,null,5586.3733333333339,4896.5466666666671,4034.8933333333334,3498.6933333333336,2713.2933333333335]
[80,null,5586.3733333333339,4896.5466666666671,4034.8933333333334,3498.6933333333336,2713.2933333333335]
[81,null,5586.3733333333339,4896.5466666666671,4034.8933333333334,3498.6933333333336,2713.2933333333335]
[82,null,5586.3733333333339,{"$f":"D70*$K$2","v":4896.5466666666671},4034.8933333333334,3498.6933333333336,2713.2933333333335]
[83,null,{"$f":"C71*$K$2","v":5586.3733333333339},4896.5466666666671,4034.8933333333334,3498.6933333333336,2713.2933333333335]
[84,"o más",5586.3733333333339,4896.5466666666671,4034.8933333333334,3498.6933333333336,2713.2933333333335]
[1,"Hijo",287,251.53333333333333,214.10666666666668,185.73333333333335,144.01333333333335]
[2,"Hijos",487.66666666666669,427.56,364,315.74666666666667,244.81333333333333]
[3,"Hijos o más",688.61333333333334,603.49333333333334,513.80000000000007,445.57333333333338,345.61333333333334]
[]
["BUPA GLOBAL PREMIER"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",250,2000,5000,10000]
[18,null,4781,4337,3321,2470,null,null,true,true,true,true]
[19,null,4781,4337,3321,2470]
[20,null,4781,4337,3321,2470]
[21,null,4781,4337,3321,2470]
[22,null,4781,4337,3321,2470]
[23,null,4781,4337,3321,2470]
[24,null,4781,4337,3321,2470]
[25,null,5110,4635,3511,2612,null,null,true,true,true,true]
[26,null,5110,4635,3511,2612]
[27,null,5110,4635,3511,2612]
[28,null,5110,4635,3511,2612]
[29,null,5110,4635,3511,2612]
[30,null,5682,5157,3855,2867,null,null,true,true,true,true]
[31,null,5682,5157,3855,2867]
[32,null,5682,5157,3855,2867]
[33,null,5682,5157,3855,2867]
[34,null,5682,5157,3855,2867]
[35,null,6341,5755,4261,3169,null,null,true,true,true,true]
[36,null,6341,5755,4261,3169]
[37,null,6341,5755,4261,3169]
[38,null,6341,5755,4261,3169]
[39,null,6341,5755,4261,3169]
[40,null,7102,6446,4735,3523,null,null,true,true,true,true]
[41,null,7102,6446,4735,3523]
[42,null,7102,6446,4735,3523]
[43,null,7102,6446,4735,3523]
[44,null,7102,6446,4735,3523]
[45,null,7948,7214,5270,3920,null,null,true,true,true,true]
[46,null,7948,7214,5270,3920]
[47,null,7948,7214,5270,3920]
[48,null,7948,7214,5270,3920]
[49,null,7948,7214,5270,3920]
[50,null,8902,8078,5879,4374,null,null,true,true,true,true]
[51,null,8902,8078,5879,4374]
[52,null,8902,8078,5879,4374]
[53,null,8902,8078,5879,4374]
[54,null,8902,8078,5879,4374]
[55,null,9950,9031,6555,4877,null,null,true,true,true,true]
[56,null,9950,9031,6555,4877]
[57,null,9950,9031,6555,4877]
[58,null,9950,9031,6555,4877]
[59,null,9950,9031,6555,4877]
[60,null,10650,9663,7007,5211,null,null,true,true,true,true]
[61,null,11865,10767,7798,5801,null,null,true,true,true,true]
[62,null,13181,11964,8661,6443,null,null,true,true,true,true]
[63,null,14598,13248,9591,7133,null,null,true,true,true,true]
[64,null,16113,14623,10590,7877,null,null,true,true,true,true]
[65,null,17728,16088,11658,8672,null,null,true,true,true,true]
[66,null,19442,17642,12795,9518,null,null,true,true,true,true]
[67,null,21255,19289,14002,10417,null,null,true,true,true,true]
[68,null,23166,21023,15277,11364,null,null,true,true,true,true]
[69,null,25179,22851,16622,12365,null,null,true,true,true,true]
[70,null,27291,24768,18034,13415,null,null,true,true,true,true]
[71,null,29502,26772,19518,14519,null,null,true,true,true,true]
[72,null,31811,28869,21069,15673,null,null,true,true,true,true]
[73,null,34220,31056,22690,16878,null,null,true,true,true,true]
[74,null,36729,33332,24381,18136,null,null,true,true,true,true]
[75,null,39336,35700,26140,19445,null,null,true,true,true,true]
[76,null,39336,35700,26140,19445]
[77,null,39336,35700,26140,19445]
[78,null,39336,35700,26140,19445]
[79,null,39336,35700,26140,19445]
[80,null,39336,35700,26140,19445]
[81,null,39336,35700,26140,19445]
[82,null,39336,35700,26140,19445]
[83,null,39336,35700,26140,19445]
[84,"o más",39336,35700,26140,19445]
[1,"Hijo",2021,1833,1422,1057,null,null,true,true,true,true]
[2,"Hijos",3435,3118,2415,1797,null,null,true,true,true,true]
[3,"Hijos o más",4848,4400,3409,2536,null,null,true,true,true,true]
[]
["BUPA GLOBAL PREMIER - MENSUALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C155*$K$2","v":446.22666666666669},{"$f":"D155*$K$2","v":404.78666666666669},309.96000000000004,230.53333333333333,0]
[19,null,{"$f":"C156*$K$2","v":446.22666666666669},404.78666666666669,309.96000000000004,230.53333333333333,0]
[20,null,446.22666666666669,404.78666666666669,309.96000000000004,230.53333333333333,0]
[21,null,446.22666666666669,404.78666666666669,309.96000000000004,230.53333333333333,0]
[22,null,446.22666666666669,404.78666666666669,309.96000000000004,230.53333333333333,0]
[23,null,446.22666666666669,404.78666666666669,309.96000000000004,230.53333333333333,0]
[24,null,446.22666666666669,404.78666666666669,309.96000000000004,230.53333333333333,0]
[25,null,476.93333333333334,432.6,327.69333333333333,243.78666666666669,0]
[26,null,476.93333333333334,432.6,327.69333333333333,243.78666666666669,0]
[27,null,476.93333333333334,432.6,327.69333333333333,243.78666666666669,0]
[28,null,476.93333333333334,432.6,327.69333333333333,243.78666666666669,0]
[29,null,476.93333333333334,432.6,327.69333333333333,243.78666666666669,0]
[30,null,530.32000000000005,481.32000000000005,359.8,267.5866666666667,0]
[31,null,530.32000000000005,481.32000000000005,359.8,267.5866666666667,0]
[32,null,530.32000000000005,481.32000000000005,359.8,267.5866666666667,0]
[33,null,530.32000000000005,481.32000000000005,359.8,267.5866666666667,0]
[34,null,530.32000000000005,481.32000000000005,359.8,267.5866666666667,0]
[35,null,591.82666666666671,537.13333333333333,397.69333333333333,295.77333333333337,0]
[36,null,591.82666666666671,537.13333333333333,397.69333333333333,295.77333333333337,0]
[37,null,591.82666666666671,537.13333333333333,397.69333333333333,295.77333333333337,0]
[38,null,591.82666666666671,537.13333333333333,397.69333333333333,295.77333333333337,0]
[39,null,591.82666666666671,537.13333333333333,397.69333333333333,295.77333333333337,0]
[40,null,662.85333333333335,601.62666666666667,441.93333333333334,328.81333333333333,0]
[41,null,662.85333333333335,601.62666666666667,441.93333333333334,328.81333333333333,0]
[42,null,662.85333333333335,601.62666666666667,441.93333333333334,328.81333333333333,0]
[43,null,662.85333333333335,601.62666666666667,441.93333333333334,328.81333333333333,0]
[44,null,662.85333333333335,601.62666666666667,441.93333333333334,328.81333333333333,0]
[45,null,741.81333333333339,673.30666666666673,491.86666666666667,365.86666666666667,0]
[46,null,741.81333333333339,673.30666666666673,491.86666666666667,365.86666666666667,0]
[47,null,741.81333333333339,673.30666666666673,491.86666666666667,365.86666666666667,0]
[48,null,741.81333333333339,673.30666666666673,491.86666666666667,365.86666666666667,0]
[49,null,741.81333333333339,673.30666666666673,491.86666666666667,365.86666666666667,0]
[50,null,830.85333333333335,753.94666666666672,548.70666666666671,408.24,0]
[51,null,830.85333333333335,753.94666666666672,548.70666666666671,408.24,0]
[52,null,830.85333333333335,753.94666666666672,548.70666666666671,408.24,0]
[53,null,830.85333333333335,753.94666666666672,548.70666666666671,408.24,0]
[54,null,830.85333333333335,753.94666666666672,548.70666666666671,408.24,0]
[55,null,928.66666666666674,842.89333333333332,611.80000000000007,455.18666666666667,0]
[56,null,928.66666666666674,842.89333333333332,611.80000000000007,455.18666666666667,0]
[57,null,928.66666666666674,842.89333333333332,611.80000000000007,455.18666666666667,0]
[58,null,928.66666666666674,842.89333333333332,611.80000000000007,455.18666666666667,0]
[59,null,928.66666666666674,842.89333333333332,611.80000000000007,455.18666666666667,0]
[60,null,994,901.88,653.98666666666668,486.36,0]
[61,null,1107.4000000000001,1004.9200000000001,727.81333333333339,541.42666666666673,0]
[62,null,1230.2266666666667,1116.6400000000001,808.36,601.34666666666669,0]
[63,null,1362.48,1236.48,895.16000000000008,665.74666666666667,0]
[64,null,1503.88,1364.8133333333335,988.40000000000009,735.18666666666672,0]
[65,null,1654.6133333333335,1501.5466666666666,1088.0800000000002,809.38666666666666,0]
[66,null,1814.5866666666668,1646.5866666666668,1194.2,888.34666666666669,0]
[67,null,1983.8000000000002,1800.3066666666668,1306.8533333333335,972.25333333333333,0]
[68,null,2162.1600000000003,1962.1466666666668,1425.8533333333335,1060.6400000000001,0]
[69,null,2350.04,2132.7600000000002,1551.3866666666668,1154.0666666666666,0]
[70,null,2547.1600000000003,2311.6800000000003,1683.1733333333334,1252.0666666666668,0]
[71,null,2753.52,2498.7200000000003,1821.68,1355.1066666666668,0]
[72,null,2969.0266666666666,2694.44,1966.44,1462.8133333333335,0]
[73,null,3193.8666666666668,2898.56,2117.7333333333336,1575.28,0]
[74,null,3428.04,3110.9866666666667,2275.56,1692.6933333333334,0]
[75,null,3671.36,3332,2439.7333333333336,1814.8666666666668,0]
[76,null,3671.36,3332,2439.7333333333336,1814.8666666666668,0]
[77,null,3671.36,3332,2439.7333333333336,1814.8666666666668,0]
[78,null,3671.36,3332,2439.7333333333336,1814.8666666666668,0]
[79,null,3671.36,3332,2439.7333333333336,1814.8666666666668,0]
[80,null,3671.36,3332,2439.7333333333336,1814.8666666666668]
[81,null,3671.36,3332,2439.7333333333336,1814.8666666666668]
[82,null,3671.36,3332,2439.7333333333336,{"$f":"F219*$K$2","v":1814.8666666666668}]
[83,null,{"$f":"C220*$K$2","v":3671.36},3332,2439.7333333333336,1814.8666666666668]
[84,"o más",3671.36,3332,2439.7333333333336,1814.8666666666668,0]
[1,"Hijo",188.62666666666667,171.08,132.72,98.653333333333336,0]
[2,"Hijos",320.60000000000002,291.01333333333332,225.4,167.72,0]
[3,"Hijos o más",452.48,410.66666666666669,318.17333333333335,236.69333333333336,0]
[]
[]
["BUPA GLOBAL SELECT"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",250,2000,5000]
[18,null,3112,2985,2296,1708,null,true,true,true,true]
[19,null,3112,2985,2296,1708,null,true]
[20,null,3112,2985,2296,1708,null,true]
[21,null,3112,2985,2296,1708,null,true]
[22,null,3112,2985,2296,1708,null,true]
[23,null,3112,2985,2296,1708,null,true]
[24,null,3112,2985,2296,1708,null,true]
[25,null,3357,3221,2451,1824,null,true,true,true,true]
[26,null,3357,3221,2451,1824,null,true]
[27,null,3357,3221,2451,1824,null,true]
[28,null,3357,3221,2451,1824,null,true]
[29,null,3357,3221,2451,1824,null,true]
[30,null,3788,3633,2725,2027,null,true,true,true,true]
[31,null,3788,3633,2725,2027,null,true]
[32,null,3788,3633,2725,2027,null,true]
[33,null,3788,3633,2725,2027,null,true]
[34,null,3788,3633,2725,2027,null,true]
[35,null,4286,4112,3051,2271,null,true,true,true,true]
[36,null,4286,4112,3051,2271,null,true]
[37,null,4286,4112,3051,2271,null,true]
[38,null,4286,4112,3051,2271,null,true]
[39,null,4286,4112,3051,2271,null,true]
[40,null,4861,4664,3432,2553,null,true,true,true,true]
[41,null,4861,4664,3432,2553,null,true]
[42,null,4861,4664,3432,2553,null,true]
[43,null,4861,4664,3432,2553,null,true]
[44,null,4861,4664,3432,2553,null,true]
[45,null,5502,5278,3863,2874,null,true,true,true,true]
[46,null,5502,5278,3863,2874,null,true]
[47,null,5502,5278,3863,2874,null,true]
[48,null,5502,5278,3863,2874,null,true]
[49,null,5502,5278,3863,2874,null,true]
[50,null,6224,5971,4352,3238,null,true,true,true,true]
[51,null,6224,5971,4352,3238,null,true]
[52,null,6224,5971,4352,3238,null,true]
[53,null,6224,5971,4352,3238,null,true]
[54,null,6224,5971,4352,3238,null,true]
[55,null,7020,6736,4897,3643,null,true,true,true,true]
[56,null,7020,6736,4897,3643,null,true]
[57,null,7020,6736,4897,3643,null,true]
[58,null,7020,6736,4897,3643,null,true]
[59,null,7020,6736,4897,3643,null,true]
[60,null,7550,7244,5263,3914,null,true,true,true,true]
[61,null,8475,8131,5901,4390,null,true,true,true,true]
[62,null,9475,9091,6597,4906,null,true,true,true,true]
[63,null,10553,10126,7347,5465,null,true,true,true,true]
[64,null,11705,11232,8153,6065,null,true,true,true,true]
[65,null,12936,12412,9017,6708,null,true,true,true,true]
[66,null,14241,13664,9935,7390,null,true,true,true,true]
[67,null,15624,14990,10909,8115,null,true,true,true,true]
[68,null,17082,16389,11938,8881,null,true,true,true,true]
[69,null,18615,17861,13025,9689,null,true,true,true,true]
[70,null,20226,19406,14167,10538,null,true,true,true,true]
[71,null,21911,21023,15367,11430,null,true,true,true,true]
[72,null,23675,22715,16620,12364,null,true,true,true,true]
[73,null,25513,24478,17930,13337,null,true,true,true,true]
[74,null,27427,26317,19294,14353,null,true,true,true,true]
[75,null,29418,28227,20718,15412,null,true,true,true,true]
[76,null,29418,28227,20718,15412,null,true]
[77,null,29418,28227,20718,15412,null,true]
[78,null,29418,28227,20718,15412,null,true]
[79,null,29418,28227,20718,15412,null,true]
[80,null,29418,28227,20718,15412,null,true]
[81,null,29418,28227,20718,15412,null,true]
[82,null,29418,28227,20718,15412,null,true]
[83,null,29418,28227,20718,15412,null,true]
[84,"o más",29418,28227,20718,15412,null,true]
[1,"Hijo",1452,1393,1087,809,null,true,true,true,true]
[2,"Hijos",2466,2366,1845,1373,null,true,true,true,true]
[3,"Hijos o más",3482,3340,2605,1938,null,true,true,true,true]
[]
["BUPA GLOBAL SELECT - MENSUALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C305*$K$2","v":290.45333333333332},{"$f":"D305*$K$2","v":278.60000000000002},214.29333333333335,159.41333333333333,0]
[19,null,{"$f":"C306*$K$2","v":290.45333333333332},278.60000000000002,214.29333333333335,159.41333333333333,0]
[20,null,290.45333333333332,278.60000000000002,214.29333333333335,159.41333333333333,0]
[21,null,290.45333333333332,278.60000000000002,214.29333333333335,159.41333333333333,0]
[22,null,290.45333333333332,278.60000000000002,214.29333333333335,159.41333333333333,0]
[23,null,290.45333333333332,278.60000000000002,214.29333333333335,159.41333333333333,0]
[24,null,290.45333333333332,278.60000000000002,214.29333333333335,159.41333333333333,0]
[25,null,313.32,300.62666666666667,228.76000000000002,170.24,0]
[26,null,313.32,300.62666666666667,228.76000000000002,170.24,0]
[27,null,313.32,300.62666666666667,228.76000000000002,170.24,0]
[28,null,313.32,300.62666666666667,228.76000000000002,170.24,0]
[29,null,313.32,300.62666666666667,228.76000000000002,170.24,0]
[30,null,353.54666666666668,339.08000000000004,254.33333333333334,189.18666666666667,0]
[31,null,353.54666666666668,339.08000000000004,254.33333333333334,189.18666666666667,0]
[32,null,353.54666666666668,339.08000000000004,254.33333333333334,189.18666666666667,0]
[33,null,353.54666666666668,339.08000000000004,254.33333333333334,189.18666666666667,0]
[34,null,353.54666666666668,339.08000000000004,254.33333333333334,189.18666666666667,0]
[35,null,400.0266666666667,383.78666666666669,284.76,211.96,0]
[36,null,400.0266666666667,383.78666666666669,284.76,211.96,0]
[37,null,400.0266666666667,383.78666666666669,284.76,211.96,0]
[38,null,400.0266666666667,383.78666666666669,284.76,211.96,0]
[39,null,400.0266666666667,383.78666666666669,284.76,211.96,0]
[40,null,453.69333333333333,435.30666666666667,320.32,238.28,0]
[41,null,453.69333333333333,435.30666666666667,320.32,238.28,0]
[42,null,453.69333333333333,435.30666666666667,320.32,238.28,0]
[43,null,453.69333333333333,435.30666666666667,320.32,238.28,0]
[44,null,453.69333333333333,435.30666666666667,320.32,238.28,0]
[45,null,513.52,492.61333333333334,360.54666666666668,268.24,0]
[46,null,513.52,492.61333333333334,360.54666666666668,268.24,0]
[47,null,513.52,492.61333333333334,360.54666666666668,268.24,0]
[48,null,513.52,492.61333333333334,360.54666666666668,268.24,0]
[49,null,513.52,492.61333333333334,360.54666666666668,268.24,0]
[50,null,580.90666666666664,557.29333333333341,406.18666666666667,302.21333333333337,0]
[51,null,580.90666666666664,557.29333333333341,406.18666666666667,302.21333333333337,0]
[52,null,580.90666666666664,557.29333333333341,406.18666666666667,302.21333333333337,0]
[53,null,580.90666666666664,557.29333333333341,406.18666666666667,302.21333333333337,0]
[54,null,580.90666666666664,557.29333333333341,406.18666666666667,302.21333333333337,0]
[55,null,655.20000000000005,628.69333333333338,457.05333333333334,340.01333333333332,0]
[56,null,655.20000000000005,628.69333333333338,457.05333333333334,340.01333333333332,0]
[57,null,655.20000000000005,628.69333333333338,457.05333333333334,340.01333333333332,0]
[58,null,655.20000000000005,628.69333333333338,457.05333333333334,340.01333333333332,0]
[59,null,655.20000000000005,628.69333333333338,457.05333333333334,340.01333333333332,0]
[60,null,704.66666666666674,676.10666666666668,491.21333333333337,365.30666666666667,0]
[61,null,791,758.89333333333332,550.76,409.73333333333335,0]
[62,null,884.33333333333337,848.49333333333334,615.72,457.89333333333337,0]
[63,null,984.94666666666672,945.09333333333336,685.72,510.06666666666666,0]
[64,null,1092.4666666666667,1048.32,760.94666666666672,566.06666666666672,0]
[65,null,1207.3600000000001,1158.4533333333334,841.5866666666667,626.08000000000004,0]
[66,null,1329.16,1275.3066666666666,927.26666666666677,689.73333333333335,0]
[67,null,1458.24,1399.0666666666668,1018.1733333333334,757.40000000000009,0]
[68,null,1594.3200000000002,1529.64,1114.2133333333334,828.89333333333332,0]
[69,null,1737.4,1667.0266666666666,1215.6666666666667,904.30666666666673,0]
[70,null,1887.76,1811.2266666666667,1322.2533333333333,983.54666666666674,0]
[71,null,2045.0266666666669,1962.1466666666668,1434.2533333333333,1066.8,0]
[72,null,2209.666666666667,2120.0666666666666,1551.2,1153.9733333333334,0]
[73,null,2381.2133333333336,2284.6133333333332,1673.4666666666667,1244.7866666666666,0]
[74,null,2559.8533333333335,2456.2533333333336,1800.7733333333333,1339.6133333333335,0]
[75,null,2745.6800000000003,2634.52,1933.68,1438.4533333333334,0]
[76,null,2745.6800000000003,2634.52,1933.68,1438.4533333333334,0]
[77,null,2745.6800000000003,2634.52,1933.68,1438.4533333333334,0]
[78,null,2745.6800000000003,2634.52,1933.68,1438.4533333333334,0]
[79,null,2745.6800000000003,2634.52,1933.68,1438.4533333333334,0]
[80,null,2745.6800000000003,2634.52,1933.68,1438.4533333333334]
[81,null,2745.6800000000003,2634.52,1933.68,1438.4533333333334]
[82,null,2745.6800000000003,2634.52,1933.68,{"$f":"F369*$K$2","v":1438.4533333333334}]
[83,null,{"$f":"C370*$K$2","v":2745.6800000000003},2634.52,1933.68,1438.4533333333334]
[84,"o más",2745.6800000000003,2634.52,1933.68,1438.4533333333334,0]
[1,"Hijo",135.52000000000001,130.01333333333335,101.45333333333333,75.506666666666675]
[2,"Hijos",230.16,220.82666666666668,172.20000000000002,128.14666666666668]
[3,"Hijos o más",324.98666666666668,311.73333333333335,243.13333333333335,180.88]
[]
[]
["BUPA GLOBAL ELITE"]
["TARIFAS SEMESTRALES"]
["EDAD"]
[" "," ",1000,2000,3500]
[18,null,{"$f":"C6*$K$4","v":3855.75},{"$f":"D6*$K$4","v":3378.75},2856.7000000000003,2478.2800000000002,1921.7800000000002]
[19,null,{"$f":"C7*$K$4","v":3855.75},3378.75,2856.7000000000003,2478.2800000000002,1921.7800000000002]
[20,null,3855.75,3378.75,2856.7000000000003,2478.2800000000002,1921.7800000000002]
[21,null,3855.75,3378.75,2856.7000000000003,2478.2800000000002,1921.7800000000002]
[22,null,3855.75,3378.75,2856.7000000000003,2478.2800000000002,1921.7800000000002]
[23,null,3855.75,3378.75,2856.7000000000003,2478.2800000000002,1921.7800000000002]
[24,null,3855.75,3378.75,2856.7000000000003,2478.2800000000002,1921.7800000000002]
[25,null,4119.16,3610.36,3034.25,2630.92,2041.0300000000002]
[26,null,4119.16,3610.36,3034.25,2630.92,2041.0300000000002]
[27,null,4119.16,3610.36,3034.25,2630.92,2041.0300000000002]
[28,null,4119.16,3610.36,3034.25,2630.92,2041.0300000000002]
[29,null,4119.16,3610.36,3034.25,2630.92,2041.0300000000002]
[30,null,4580.79,4015.28,3349.07,2903.34,2251.9700000000003]
[31,null,4580.79,4015.28,3349.07,2903.34,2251.9700000000003]
[32,null,4580.79,4015.28,3349.07,2903.34,2251.9700000000003]
[33,null,4580.79,4015.28,3349.07,2903.34,2251.9700000000003]
[34,null,4580.79,4015.28,3349.07,2903.34,2251.9700000000003]
[35,null,5113.97,4481.1500000000005,3716.36,3222.9300000000003,2499.48]
[36,null,5113.97,4481.1500000000005,3716.36,3222.9300000000003,2499.48]
[37,null,5113.97,4481.1500000000005,3716.36,3222.9300000000003,2499.48]
[38,null,5113.97,4481.1500000000005,3716.36,3222.9300000000003,2499.48]
[39,null,5113.97,4481.1500000000005,3716.36,3222.9300000000003,2499.48]
[40,null,5727.71,5019.63,4144.0700000000006,3593.4,2787.8]
[41,null,5727.71,5019.63,4144.0700000000006,3593.4,2787.8]
[42,null,5727.71,5019.63,4144.0700000000006,3593.4,2787.8]
[43,null,5727.71,5019.63,4144.0700000000006,3593.4,2787.8]
[44,null,5727.71,5019.63,4144.0700000000006,3593.4,2787.8]
[45,null,6409.8200000000006,5618,4623.72,4008.92,3108.98]
[46,null,6409.8200000000006,5618,4623.72,4008.92,3108.98]
[47,null,6409.8200000000006,5618,4623.72,4008.92,3108.98]
[48,null,6409.8200000000006,5618,4623.72,4008.92,3108.98]
[49,null,6409.8200000000006,5618,4623.72,4008.92,3108.98]
[50,null,7176.7300000000005,6291.1,5164.8500000000004,4479.0300000000007,3473.6200000000003]
[51,null,7176.7300000000005,6291.1,5164.8500000000004,4479.0300000000007,3473.6200000000003]
[52,null,7176.7300000000005,6291.1,5164.8500000000004,4479.0300000000007,3473.6200000000003]
[53,null,7176.7300000000005,6291.1,5164.8500000000004,4479.0300000000007,3473.6200000000003]
[54,null,7176.7300000000005,6291.1,5164.8500000000004,4479.0300000000007,3473.6200000000003]
[55,null,8023.14,7033.1,5766.4000000000005,5000.55,3878.5400000000004]
[56,null,8023.14,7033.1,5766.4000000000005,5000.55,3878.5400000000004]
[57,null,8023.14,7033.1,5766.4000000000005,5000.55,3878.5400000000004]
[58,null,8023.14,7033.1,5766.4000000000005,5000.55,3878.5400000000004]
[59,null,8023.14,7033.1,5766.4000000000005,5000.55,3878.5400000000004]
[60,null,8587.0600000000013,7527.06,6166.55,5347.17,4146.72]
[61,null,9568.6200000000008,8387.7800000000007,6868.27,5956.67,4618.95]
[62,null,10630.74,9317.93,7628.8200000000006,6614.4000000000005,5129.34]
[63,null,11771.300000000001,10319.1,8448.2000000000007,7325.13,5681.0700000000006]
[64,null,12994.01,11388.640000000001,9325.880000000001,8086.7400000000007,6270.96]
[65,null,14295.16,12530.79,10263.980000000001,8900.2900000000009,6902.72]
[66,null,15677.93,13742.37,11260.91,9764.7200000000012,{"$f":"G54*$K$4","v":7573.7000000000007}]
[67,null,17140.2,15023.380000000001,12318.26,10681.09,8283.9]
[68,null,18681.97,16375.410000000002,13434.44,11649.400000000001,9034.91]
[69,null,20305.36,17797.400000000001,14610.51,12669.650000000001,9825.67]
[70,null,22007.190000000002,19289.88,15844.880000000001,13740.25,10655.65]
[71,null,23789.58,20852.32,17140.2,14862.79,11526.44]
[72,null,25652.530000000002,22486.31,18493.82,16035.68,12436.45]
[73,null,27596.04,24188.670000000002,19908.39,17262.100000000002,13387.27]
[74,null,29619.58,25961.52,21380.73,18539.400000000001,14377.84]
[75,null,31722.620000000003,27805.390000000003,22912.43,19867.580000000002,15407.630000000001]
[76,null,31722.620000000003,27805.390000000003,22912.43,19867.580000000002,15407.630000000001]
[77,null,31722.620000000003,27805.390000000003,22912.43,19867.580000000002,15407.630000000001]
[78,null,31722.620000000003,27805.390000000003,22912.43,19867.580000000002,15407.630000000001]
[79,null,31722.620000000003,27805.390000000003,22912.43,19867.580000000002,15407.630000000001]
[80,null,31722.620000000003,27805.390000000003,22912.43,19867.580000000002,15407.630000000001]
[81,null,31722.620000000003,27805.390000000003,22912.43,19867.580000000002,15407.630000000001]
[82,null,31722.620000000003,{"$f":"D70*$K$4","v":27805.390000000003},22912.43,19867.580000000002,15407.630000000001]
[83,null,{"$f":"C71*$K$4","v":31722.620000000003},27805.390000000003,22912.43,19867.580000000002,15407.630000000001]
[84,"o más",31722.620000000003,27805.390000000003,22912.43,19867.580000000002,15407.630000000001]
[1,"Hijo",1629.75,1428.3500000000001,1215.8200000000002,1054.7,817.79000000000008]
[2,"Hijos",2769.25,2427.9300000000003,2067,1792.99,1390.19]
[3,"Hijos o más",3910.34,3426.98,2917.65,2530.2200000000003,1962.5900000000001]
[]
["BUPA GLOBAL PREMIER"]
["TARIFAS SEMESTRALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C155*$K$4","v":2533.9300000000003},{"$f":"D155*$K$4","v":2298.61},1760.13,1309.1000000000001,0]
[19,null,{"$f":"C156*$K$4","v":2533.9300000000003},2298.61,1760.13,1309.1000000000001,0]
[20,null,2533.9300000000003,2298.61,1760.13,1309.1000000000001,0]
[21,null,2533.9300000000003,2298.61,1760.13,1309.1000000000001,0]
[22,null,2533.9300000000003,2298.61,1760.13,1309.1000000000001,0]
[23,null,2533.9300000000003,2298.61,1760.13,1309.1000000000001,0]
[24,null,2533.9300000000003,2298.61,1760.13,1309.1000000000001,0]
[25,null,2708.3,2456.5500000000002,1860.8300000000002,1384.3600000000001,0]
[26,null,2708.3,2456.5500000000002,1860.8300000000002,1384.3600000000001,0]
[27,null,2708.3,2456.5500000000002,1860.8300000000002,1384.3600000000001,0]
[28,null,2708.3,2456.5500000000002,1860.8300000000002,1384.3600000000001,0]
[29,null,2708.3,2456.5500000000002,1860.8300000000002,1384.3600000000001,0]
[30,null,3011.46,2733.21,2043.15,1519.51,0]
[31,null,3011.46,2733.21,2043.15,1519.51,0]
[32,null,3011.46,2733.21,2043.15,1519.51,0]
[33,null,3011.46,2733.21,2043.15,1519.51,0]
[34,null,3011.46,2733.21,2043.15,1519.51,0]
[35,null,3360.73,3050.15,2258.33,1679.5700000000002,0]
[36,null,3360.73,3050.15,2258.33,1679.5700000000002,0]
[37,null,3360.73,3050.15,2258.33,1679.5700000000002,0]
[38,null,3360.73,3050.15,2258.33,1679.5700000000002,0]
[39,null,3360.73,3050.15,2258.33,1679.5700000000002,0]
[40,null,3764.0600000000004,3416.38,2509.5500000000002,1867.19,0]
[41,null,3764.0600000000004,3416.38,2509.5500000000002,1867.19,0]
[42,null,3764.0600000000004,3416.38,2509.5500000000002,1867.19,0]
[43,null,3764.0600000000004,3416.38,2509.5500000000002,1867.19,0]
[44,null,3764.0600000000004,3416.38,2509.5500000000002,1867.19,0]
[45,null,4212.4400000000005,3823.42,2793.1000000000004,2077.6,0]
[46,null,4212.4400000000005,3823.42,2793.1000000000004,2077.6,0]
[47,null,4212.4400000000005,3823.42,2793.1000000000004,2077.6,0]
[48,null,4212.4400000000005,3823.42,2793.1000000000004,2077.6,0]
[49,null,4212.4400000000005,3823.42,2793.1000000000004,2077.6,0]
[50,null,4718.0600000000004,4281.34,3115.8700000000003,2318.2200000000003,0]
[51,null,4718.0600000000004,4281.34,3115.8700000000003,2318.2200000000003,0]
[52,null,4718.0600000000004,4281.34,3115.8700000000003,2318.2200000000003,0]
[53,null,4718.0600000000004,4281.34,3115.8700000000003,2318.2200000000003,0]
[54,null,4718.0600000000004,4281.34,3115.8700000000003,2318.2200000000003,0]
[55,null,5273.5,4786.43,3474.15,2584.81,0]
[56,null,5273.5,4786.43,3474.15,2584.81,0]
[57,null,5273.5,4786.43,3474.15,2584.81,0]
[58,null,5273.5,4786.43,3474.15,2584.81,0]
[59,null,5273.5,4786.43,3474.15,2584.81,0]
[60,null,5644.5,5121.3900000000003,3713.71,2761.83,0]
[61,null,6288.4500000000007,5706.51,4132.9400000000005,3074.53,0]
[62,null,6985.93,6340.92,4590.33,3414.79,0]
[63,null,7736.9400000000005,7021.4400000000005,5083.2300000000005,3780.4900000000002,0]
[64,null,8539.8900000000012,7750.1900000000005,5612.7000000000007,4174.8100000000004,0]
[65,null,9395.84,8526.6400000000012,6178.7400000000007,4596.16,0]
[66,null,10304.26,9350.26,6781.35,5044.54,0]
[67,null,11265.150000000001,10223.17,7421.06,5521.01,0]
[68,null,12277.980000000001,11142.19,8096.81,6022.92,0]
[69,null,13344.87,12111.03,8809.66,6553.4500000000007,0]
[70,null,14464.230000000001,13127.04,9558.02,7109.9500000000007,0]
[71,null,15636.060000000001,14189.16,10344.540000000001,7695.0700000000006,0]
[72,null,16859.830000000002,15300.570000000002,11166.57,8306.69,0]
[73,null,18136.600000000002,16459.68,12025.7,8945.34,0]
[74,null,19466.370000000003,17665.96,12921.93,9612.08,0]
[75,null,20848.080000000002,18921,13854.2,10305.85,0]
[76,null,20848.080000000002,18921,13854.2,10305.85,0]
[77,null,20848.080000000002,18921,13854.2,10305.85,0]
[78,null,20848.080000000002,18921,13854.2,10305.85,0]
[79,null,20848.080000000002,18921,13854.2,10305.85,0]
[80,null,20848.080000000002,18921,13854.2,10305.85,0]
[81,null,20848.080000000002,18921,13854.2,10305.85,0]
[82,null,20848.080000000002,18921,13854.2,{"$f":"F219*$K$4","v":10305.85},0]
[83,null,{"$f":"C220*$K$4","v":20848.080000000002},18921,13854.2,10305.85,0]
[84,"o más",20848.080000000002,18921,13854.2,10305.85,0]
[1,"Hijo",1071.1300000000001,971.49,753.66000000000008,560.21,0]
[2,"Hijos",1820.5500000000002,1652.5400000000002,1279.95,952.41000000000008,0]
[3,"Hijos o más",2569.44,2332,1806.77,1344.0800000000002,0]
[]
["BUPA GLOBAL SELECT"]
["TARIFAS SEMESTRALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C305*$K$4","v":1649.3600000000001},{"$f":"D305*$K$4","v":1582.0500000000002},1216.8800000000001,905.24,0]
[19,null,{"$f":"C306*$K$4","v":1649.3600000000001},1582.0500000000002,1216.8800000000001,905.24,0]
[20,null,1649.3600000000001,1582.0500000000002,1216.8800000000001,905.24,0]
[21,null,1649.3600000000001,1582.0500000000002,1216.8800000000001,905.24,0]
[22,null,1649.3600000000001,1582.0500000000002,1216.8800000000001,905.24,0]
[23,null,1649.3600000000001,1582.0500000000002,1216.8800000000001,905.24,0]
[24,null,1649.3600000000001,1582.0500000000002,1216.8800000000001,905.24,0]
[25,null,1779.21,1707.13,1299.03,966.72,0]
[26,null,1779.21,1707.13,1299.03,966.72,0]
[27,null,1779.21,1707.13,1299.03,966.72,0]
[28,null,1779.21,1707.13,1299.03,966.72,0]
[29,null,1779.21,1707.13,1299.03,966.72,0]
[30,null,2007.64,1925.49,1444.25,1074.31,0]
[31,null,2007.64,1925.49,1444.25,1074.31,0]
[32,null,2007.64,1925.49,1444.25,1074.31,0]
[33,null,2007.64,1925.49,1444.25,1074.31,0]
[34,null,2007.64,1925.49,1444.25,1074.31,0]
[35,null,2271.58,2179.36,1617.03,1203.6300000000001,0]
[36,null,2271.58,2179.36,1617.03,1203.6300000000001,0]
[37,null,2271.58,2179.36,1617.03,1203.6300000000001,0]
[38,null,2271.58,2179.36,1617.03,1203.6300000000001,0]
[39,null,2271.58,2179.36,1617.03,1203.6300000000001,0]
[40,null,2576.33,2471.92,1818.96,1353.0900000000001,0]
[41,null,2576.33,2471.92,1818.96,1353.0900000000001,0]
[42,null,2576.33,2471.92,1818.96,1353.0900000000001,0]
[43,null,2576.33,2471.92,1818.96,1353.0900000000001,0]
[44,null,2576.33,2471.92,1818.96,1353.0900000000001,0]
[45,null,2916.06,2797.34,2047.39,1523.22,0]
[46,null,2916.06,2797.34,2047.39,1523.22,0]
[47,null,2916.06,2797.34,2047.39,1523.22,0]
[48,null,2916.06,2797.34,2047.39,1523.22,0]
[49,null,2916.06,2797.34,2047.39,1523.22,0]
[50,null,3298.7200000000003,3164.63,2306.56,1716.14,0]
[51,null,3298.7200000000003,3164.63,2306.56,1716.14,0]
[52,null,3298.7200000000003,3164.63,2306.56,1716.14,0]
[53,null,3298.7200000000003,3164.63,2306.56,1716.14,0]
[54,null,3298.7200000000003,3164.63,2306.56,1716.14,0]
[55,null,3720.6000000000004,3570.0800000000004,2595.4100000000003,1930.7900000000002,0]
[56,null,3720.6000000000004,3570.0800000000004,2595.4100000000003,1930.7900000000002,0]
[57,null,3720.6000000000004,3570.0800000000004,2595.4100000000003,1930.7900000000002,0]
[58,null,3720.6000000000004,3570.0800000000004,2595.4100000000003,1930.7900000000002,0]
[59,null,3720.6000000000004,3570.0800000000004,2595.4100000000003,1930.7900000000002,0]
[60,null,4001.5,3839.32,2789.3900000000003,2074.42,0]
[61,null,4491.75,4309.43,3127.53,2326.7000000000003,0]
[62,null,5021.75,4818.2300000000005,3496.4100000000003,2600.1800000000003,0]
[63,null,5593.09,5366.7800000000007,3893.9100000000003,2896.4500000000003,0]
[64,null,6203.6500000000005,5952.96,4321.09,3214.4500000000003,0]
[65,null,6856.08,6578.3600000000006,4779.01,3555.2400000000002,0]
[66,null,7547.7300000000005,7241.92,5265.55,3916.7000000000003,0]
[67,null,8280.7200000000012,7944.7000000000007,5781.77,4300.95,0]
[68,null,9053.4600000000009,8686.17,6327.14,4706.93,0]
[69,null,9865.9500000000007,9466.33,6903.25,5135.17,0]
[70,null,10719.78,10285.18,7508.51,5585.14,0]
[71,null,11612.83,11142.19,8144.51,6057.9000000000005,0]
[72,null,12547.75,12038.95,8808.6,6552.92,0]
[73,null,13521.890000000001,12973.34,9502.9,7068.6100000000006,0]
[74,null,14536.310000000001,13948.01,10225.82,7607.09,0]
[75,null,15591.54,14960.310000000001,10980.54,8168.3600000000006,0]
[76,null,15591.54,14960.310000000001,10980.54,8168.3600000000006,0]
[77,null,15591.54,14960.310000000001,10980.54,8168.3600000000006,0]
[78,null,15591.54,14960.310000000001,10980.54,8168.3600000000006,0]
[79,null,15591.54,14960.310000000001,10980.54,8168.3600000000006,0]
[80,null,15591.54,14960.310000000001,10980.54,8168.3600000000006,0]
[81,null,15591.54,14960.310000000001,10980.54,8168.3600000000006,0]
[82,null,15591.54,14960.310000000001,10980.54,{"$f":"F369*$K$4","v":8168.3600000000006},0]
[83,null,{"$f":"C370*$K$4","v":15591.54},14960.310000000001,10980.54,8168.3600000000006,0]
[84,"o más",15591.54,14960.310000000001,10980.54,8168.3600000000006,0]
[1,"Hijo",769.56000000000006,738.29000000000008,576.11,428.77000000000004,0]
[2,"Hijos",1306.98,1253.98,977.85,727.69,0]
[3,"Hijos o más",1845.46,1770.2,1380.65,1027.1400000000001,0]
[]
["BUPA GLOBAL ELITE"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ",1000,2000,3500]
[18,null,{"$f":"C6*$K$3","v":2000.6250000000002},{"$f":"D6*$K$3","v":1753.1250000000002},1482.2500000000002,1285.9000000000001,997.15000000000009]
[19,null,{"$f":"C7*$K$3","v":2000.6250000000002},1753.1250000000002,1482.2500000000002,1285.9000000000001,997.15000000000009]
[20,null,2000.6250000000002,1753.1250000000002,1482.2500000000002,1285.9000000000001,997.15000000000009]
[21,null,2000.6250000000002,1753.1250000000002,1482.2500000000002,1285.9000000000001,997.15000000000009]
[22,null,2000.6250000000002,1753.1250000000002,1482.2500000000002,1285.9000000000001,997.15000000000009]
[23,null,2000.6250000000002,1753.1250000000002,1482.2500000000002,1285.9000000000001,997.15000000000009]
[24,null,2000.6250000000002,1753.1250000000002,1482.2500000000002,1285.9000000000001,997.15000000000009]
[25,null,2137.3000000000002,1873.3000000000002,1574.3750000000002,1365.1000000000001,1059.0250000000001]
[26,null,2137.3000000000002,1873.3000000000002,1574.3750000000002,1365.1000000000001,1059.0250000000001]
[27,null,2137.3000000000002,1873.3000000000002,1574.3750000000002,1365.1000000000001,1059.0250000000001]
[28,null,2137.3000000000002,1873.3000000000002,1574.3750000000002,1365.1000000000001,1059.0250000000001]
[29,null,2137.3000000000002,1873.3000000000002,1574.3750000000002,1365.1000000000001,1059.0250000000001]
[30,null,2376.8250000000003,2083.4,1737.7250000000001,1506.45,1168.4750000000001]
[31,null,2376.8250000000003,2083.4,1737.7250000000001,1506.45,1168.4750000000001]
[32,null,2376.8250000000003,2083.4,1737.7250000000001,1506.45,1168.4750000000001]
[33,null,2376.8250000000003,2083.4,1737.7250000000001,1506.45,1168.4750000000001]
[34,null,2376.8250000000003,2083.4,1737.7250000000001,1506.45,1168.4750000000001]
[35,null,2653.4750000000004,2325.125,1928.3000000000002,1672.2750000000001,1296.9000000000001]
[36,null,2653.4750000000004,2325.125,1928.3000000000002,1672.2750000000001,1296.9000000000001]
[37,null,2653.4750000000004,2325.125,1928.3000000000002,1672.2750000000001,1296.9000000000001]
[38,null,2653.4750000000004,2325.125,1928.3000000000002,1672.2750000000001,1296.9000000000001]
[39,null,2653.4750000000004,2325.125,1928.3000000000002,1672.2750000000001,1296.9000000000001]
[40,null,2971.9250000000002,2604.5250000000001,2150.2250000000004,1864.5000000000002,1446.5000000000002]
[41,null,2971.9250000000002,2604.5250000000001,2150.2250000000004,1864.5000000000002,1446.5000000000002]
[42,null,2971.9250000000002,2604.5250000000001,2150.2250000000004,1864.5000000000002,1446.5000000000002]
[43,null,2971.9250000000002,2604.5250000000001,2150.2250000000004,1864.5000000000002,1446.5000000000002]
[44,null,2971.9250000000002,2604.5250000000001,2150.2250000000004,1864.5000000000002,1446.5000000000002]
[45,null,3325.8500000000004,2915.0000000000005,2399.1000000000004,2080.1000000000004,1613.15]
[46,null,3325.8500000000004,2915.0000000000005,2399.1000000000004,2080.1000000000004,1613.15]
[47,null,3325.8500000000004,2915.0000000000005,2399.1000000000004,2080.1000000000004,1613.15]
[48,null,3325.8500000000004,2915.0000000000005,2399.1000000000004,2080.1000000000004,1613.15]
[49,null,3325.8500000000004,2915.0000000000005,2399.1000000000004,2080.1000000000004,1613.15]
[50,null,3723.7750000000001,3264.2500000000005,2679.875,2324.0250000000001,1802.3500000000001]
[51,null,3723.7750000000001,3264.2500000000005,2679.875,2324.0250000000001,1802.3500000000001]
[52,null,3723.7750000000001,3264.2500000000005,2679.875,2324.0250000000001,1802.3500000000001]
[53,null,3723.7750000000001,3264.2500000000005,2679.875,2324.0250000000001,1802.3500000000001]
[54,null,3723.7750000000001,3264.2500000000005,2679.875,2324.0250000000001,1802.3500000000001]
[55,null,4162.9500000000007,3649.2500000000005,2992.0000000000005,2594.625,2012.4500000000003]
[56,null,4162.9500000000007,3649.2500000000005,2992.0000000000005,2594.625,2012.4500000000003]
[57,null,4162.9500000000007,3649.2500000000005,2992.0000000000005,2594.625,2012.4500000000003]
[58,null,4162.9500000000007,3649.2500000000005,2992.0000000000005,2594.625,2012.4500000000003]
[59,null,4162.9500000000007,3649.2500000000005,2992.0000000000005,2594.625,2012.4500000000003]
[60,null,4455.55,3905.55,3199.6250000000005,2774.4750000000004,2151.6000000000004]
[61,null,4964.8500000000004,4352.1500000000005,3563.7250000000004,3090.7250000000004,2396.625]
[62,null,5515.9500000000007,4834.7750000000005,3958.3500000000004,3432.0000000000005,2661.4500000000003]
[63,null,6107.7500000000009,5354.25,4383.5,3800.7750000000001,2947.7250000000004]
[64,null,6742.1750000000002,5909.2000000000007,4838.9000000000005,4195.9500000000007,3253.8]
[65,null,7417.3,6501.8250000000007,5325.6500000000005,4618.0750000000007,3581.6000000000004]
[66,null,8134.7750000000005,7130.4750000000004,5842.9250000000002,5066.6000000000004,{"$f":"G54*$K$3","v":3929.7500000000005}]
[67,null,8893.5,7795.1500000000005,6391.55,5542.0750000000007,4298.25]
[68,null,9693.4750000000004,8496.6750000000011,6970.7000000000007,6044.5000000000009,4687.9250000000002]
[69,null,10535.800000000001,9234.5,7580.9250000000002,6573.8750000000009,5098.2250000000004]
[70,null,11418.825000000001,10008.900000000001,8221.4000000000015,7129.3750000000009,5528.875]
[71,null,12343.650000000001,10819.6,8893.5,7711.8250000000007,5980.7000000000007]
[72,null,13310.275000000001,11667.425000000001,9595.85,8320.4000000000015,6452.8750000000009]
[73,null,14318.7,12550.725,10329.825000000001,8956.75,6946.2250000000004]
[74,null,15368.650000000001,13470.6,11093.775000000001,9619.5,7460.2000000000007]
[75,null,16459.850000000002,14427.325000000001,11888.525000000001,10308.650000000001,7994.5250000000005]
[76,null,16459.850000000002,14427.325000000001,11888.525000000001,10308.650000000001,7994.5250000000005]
[77,null,16459.850000000002,14427.325000000001,11888.525000000001,10308.650000000001,7994.5250000000005]
[78,null,16459.850000000002,14427.325000000001,11888.525000000001,10308.650000000001,7994.5250000000005]
[79,null,16459.850000000002,14427.325000000001,11888.525000000001,10308.650000000001,7994.5250000000005]
[80,null,16459.850000000002,14427.325000000001,11888.525000000001,10308.650000000001,7994.5250000000005]
[81,null,16459.850000000002,14427.325000000001,11888.525000000001,10308.650000000001,7994.5250000000005]
[82,null,16459.850000000002,{"$f":"D70*$K$3","v":14427.325000000001},11888.525000000001,10308.650000000001,7994.5250000000005]
[83,null,{"$f":"C71*$K$3","v":16459.850000000002},14427.325000000001,11888.525000000001,10308.650000000001,7994.5250000000005]
[84,"o más",16459.850000000002,14427.325000000001,11888.525000000001,10308.650000000001,7994.5250000000005]
[1,"Hijo",845.62500000000011,741.12500000000011,630.85,547.25,424.32500000000005]
[2,"Hijos",1436.8750000000002,1259.7750000000001,1072.5,930.32500000000005,721.32500000000005]
[3,"Hijos o más",2028.9500000000003,1778.15,1513.8750000000002,1312.8500000000001,1018.325]
[]
["BUPA GLOBAL PREMIER"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C155*$K$3","v":1314.7750000000001},{"$f":"D155*$K$3","v":1192.6750000000002},913.27500000000009,679.25,0]
[19,null,{"$f":"C156*$K$3","v":1314.7750000000001},1192.6750000000002,913.27500000000009,679.25,0]
[20,null,1314.7750000000001,1192.6750000000002,913.27500000000009,679.25,0]
[21,null,1314.7750000000001,1192.6750000000002,913.27500000000009,679.25,0]
[22,null,1314.7750000000001,1192.6750000000002,913.27500000000009,679.25,0]
[23,null,1314.7750000000001,1192.6750000000002,913.27500000000009,679.25,0]
[24,null,1314.7750000000001,1192.6750000000002,913.27500000000009,679.25,0]
[25,null,1405.25,1274.625,965.52500000000009,718.30000000000007,0]
[26,null,1405.25,1274.625,965.52500000000009,718.30000000000007,0]
[27,null,1405.25,1274.625,965.52500000000009,718.30000000000007,0]
[28,null,1405.25,1274.625,965.52500000000009,718.30000000000007,0]
[29,null,1405.25,1274.625,965.52500000000009,718.30000000000007,0]
[30,null,1562.5500000000002,1418.1750000000002,1060.125,788.42500000000007,0]
[31,null,1562.5500000000002,1418.1750000000002,1060.125,788.42500000000007,0]
[32,null,1562.5500000000002,1418.1750000000002,1060.125,788.42500000000007,0]
[33,null,1562.5500000000002,1418.1750000000002,1060.125,788.42500000000007,0]
[34,null,1562.5500000000002,1418.1750000000002,1060.125,788.42500000000007,0]
[35,null,1743.7750000000001,1582.6250000000002,1171.7750000000001,871.47500000000002,0]
[36,null,1743.7750000000001,1582.6250000000002,1171.7750000000001,871.47500000000002,0]
[37,null,1743.7750000000001,1582.6250000000002,1171.7750000000001,871.47500000000002,0]
[38,null,1743.7750000000001,1582.6250000000002,1171.7750000000001,871.47500000000002,0]
[39,null,1743.7750000000001,1582.6250000000002,1171.7750000000001,871.47500000000002,0]
[40,null,1953.0500000000002,1772.65,1302.125,968.82500000000005,0]
[41,null,1953.0500000000002,1772.65,1302.125,968.82500000000005,0]
[42,null,1953.0500000000002,1772.65,1302.125,968.82500000000005,0]
[43,null,1953.0500000000002,1772.65,1302.125,968.82500000000005,0]
[44,null,1953.0500000000002,1772.65,1302.125,968.82500000000005,0]
[45,null,2185.7000000000003,1983.8500000000001,1449.2500000000002,1078,0]
[46,null,2185.7000000000003,1983.8500000000001,1449.2500000000002,1078,0]
[47,null,2185.7000000000003,1983.8500000000001,1449.2500000000002,1078,0]
[48,null,2185.7000000000003,1983.8500000000001,1449.2500000000002,1078,0]
[49,null,2185.7000000000003,1983.8500000000001,1449.2500000000002,1078,0]
[50,null,2448.0500000000002,2221.4500000000003,1616.7250000000001,1202.8500000000001,0]
[51,null,2448.0500000000002,2221.4500000000003,1616.7250000000001,1202.8500000000001,0]
[52,null,2448.0500000000002,2221.4500000000003,1616.7250000000001,1202.8500000000001,0]
[53,null,2448.0500000000002,2221.4500000000003,1616.7250000000001,1202.8500000000001,0]
[54,null,2448.0500000000002,2221.4500000000003,1616.7250000000001,1202.8500000000001,0]
[55,null,2736.25,2483.5250000000001,1802.6250000000002,1341.1750000000002,0]
[56,null,2736.25,2483.5250000000001,1802.6250000000002,1341.1750000000002,0]
[57,null,2736.25,2483.5250000000001,1802.6250000000002,1341.1750000000002,0]
[58,null,2736.25,2483.5250000000001,1802.6250000000002,1341.1750000000002,0]
[59,null,2736.25,2483.5250000000001,1802.6250000000002,1341.1750000000002,0]
[60,null,2928.7500000000005,2657.3250000000003,1926.9250000000002,1433.0250000000001,0]
[61,null,3262.8750000000005,2960.9250000000002,2144.4500000000003,1595.2750000000001,0]
[62,null,3624.7750000000001,3290.1000000000004,2381.7750000000001,1771.825,0]
[63,null,4014.4500000000003,3643.2000000000003,2637.5250000000001,1961.575,0]
[64,null,4431.0750000000007,4021.3250000000003,2912.2500000000005,2166.1750000000002,0]
[65,null,4875.2000000000007,4424.2000000000007,3205.9500000000003,2384.8000000000002,0]
[66,null,5346.55,4851.55,3518.6250000000005,2617.4500000000003,0]
[67,null,5845.1250000000009,5304.4750000000004,3850.55,2864.6750000000002,0]
[68,null,6370.6500000000005,5781.3250000000007,4201.1750000000002,3125.1000000000004,0]
[69,null,6924.2250000000004,6284.0250000000005,4571.05,3400.3750000000005,0]
[70,null,7505.0250000000005,6811.2000000000007,4959.3500000000004,3689.1250000000005,0]
[71,null,8113.0500000000011,7362.3,5367.4500000000007,3992.7250000000004,0]
[72,null,8748.0250000000015,7938.9750000000004,5793.9750000000004,4310.0750000000007,0]
[73,null,9410.5,8540.4000000000015,6239.7500000000009,4641.4500000000007,0]
[74,null,10100.475,9166.3000000000011,6704.7750000000005,4987.4000000000005,0]
[75,null,10817.400000000001,9817.5,7188.5000000000009,5347.375,0]
[76,null,10817.400000000001,9817.5,7188.5000000000009,5347.375,0]
[77,null,10817.400000000001,9817.5,7188.5000000000009,5347.375,0]
[78,null,10817.400000000001,9817.5,7188.5000000000009,5347.375,0]
[79,null,10817.400000000001,9817.5,7188.5000000000009,5347.375,0]
[80,null,10817.400000000001,9817.5,7188.5000000000009,5347.375,0]
[81,null,10817.400000000001,9817.5,7188.5000000000009,5347.375,0]
[82,null,10817.400000000001,9817.5,7188.5000000000009,{"$f":"F219*$K$3","v":5347.375},0]
[83,null,{"$f":"C220*$K$3","v":10817.400000000001},9817.5,7188.5000000000009,5347.375,0]
[84,"o más",10817.400000000001,9817.5,7188.5000000000009,5347.375,0]
[1,"Hijo",555.77500000000009,504.07500000000005,391.05,290.67500000000001,0]
[2,"Hijos",944.62500000000011,857.45,664.125,494.17500000000007,0]
[3,"Hijos o más",1333.2,1210,937.47500000000002,697.40000000000009,0]
[]
["BUPA GLOBAL SELECT"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C305*$K$3","v":855.80000000000007},{"$f":"D305*$K$3","v":820.87500000000011},631.40000000000009,469.70000000000005,0]
[19,null,{"$f":"C306*$K$3","v":855.80000000000007},820.87500000000011,631.40000000000009,469.70000000000005,0]
[20,null,855.80000000000007,820.87500000000011,631.40000000000009,469.70000000000005,0]
[21,null,855.80000000000007,820.87500000000011,631.40000000000009,469.70000000000005,0]
[22,null,855.80000000000007,820.87500000000011,631.40000000000009,469.70000000000005,0]
[23,null,855.80000000000007,820.87500000000011,631.40000000000009,469.70000000000005,0]
[24,null,855.80000000000007,820.87500000000011,631.40000000000009,469.70000000000005,0]
[25,null,923.17500000000007,885.77500000000009,674.02500000000009,501.6,0]
[26,null,923.17500000000007,885.77500000000009,674.02500000000009,501.6,0]
[27,null,923.17500000000007,885.77500000000009,674.02500000000009,501.6,0]
[28,null,923.17500000000007,885.77500000000009,674.02500000000009,501.6,0]
[29,null,923.17500000000007,885.77500000000009,674.02500000000009,501.6,0]
[30,null,1041.7,999.07500000000005,749.37500000000011,557.42500000000007,0]
[31,null,1041.7,999.07500000000005,749.37500000000011,557.42500000000007,0]
[32,null,1041.7,999.07500000000005,749.37500000000011,557.42500000000007,0]
[33,null,1041.7,999.07500000000005,749.37500000000011,557.42500000000007,0]
[34,null,1041.7,999.07500000000005,749.37500000000011,557.42500000000007,0]
[35,null,1178.6500000000001,1130.8000000000002,839.02500000000009,624.52500000000009,0]
[36,null,1178.6500000000001,1130.8000000000002,839.02500000000009,624.52500000000009,0]
[37,null,1178.6500000000001,1130.8000000000002,839.02500000000009,624.52500000000009,0]
[38,null,1178.6500000000001,1130.8000000000002,839.02500000000009,624.52500000000009,0]
[39,null,1178.6500000000001,1130.8000000000002,839.02500000000009,624.52500000000009,0]
[40,null,1336.7750000000001,1282.6000000000001,943.80000000000007,702.07500000000005,0]
[41,null,1336.7750000000001,1282.6000000000001,943.80000000000007,702.07500000000005,0]
[42,null,1336.7750000000001,1282.6000000000001,943.80000000000007,702.07500000000005,0]
[43,null,1336.7750000000001,1282.6000000000001,943.80000000000007,702.07500000000005,0]
[44,null,1336.7750000000001,1282.6000000000001,943.80000000000007,702.07500000000005,0]
[45,null,1513.0500000000002,1451.45,1062.325,790.35,0]
[46,null,1513.0500000000002,1451.45,1062.325,790.35,0]
[47,null,1513.0500000000002,1451.45,1062.325,790.35,0]
[48,null,1513.0500000000002,1451.45,1062.325,790.35,0]
[49,null,1513.0500000000002,1451.45,1062.325,790.35,0]
[50,null,1711.6000000000001,1642.0250000000001,1196.8000000000002,890.45,0]
[51,null,1711.6000000000001,1642.0250000000001,1196.8000000000002,890.45,0]
[52,null,1711.6000000000001,1642.0250000000001,1196.8000000000002,890.45,0]
[53,null,1711.6000000000001,1642.0250000000001,1196.8000000000002,890.45,0]
[54,null,1711.6000000000001,1642.0250000000001,1196.8000000000002,890.45,0]
[55,null,1930.5000000000002,1852.4,1346.6750000000002,1001.825,0]
[56,null,1930.5000000000002,1852.4,1346.6750000000002,1001.825,0]
[57,null,1930.5000000000002,1852.4,1346.6750000000002,1001.825,0]
[58,null,1930.5000000000002,1852.4,1346.6750000000002,1001.825,0]
[59,null,1930.5000000000002,1852.4,1346.6750000000002,1001.825,0]
[60,null,2076.25,1992.1000000000001,1447.325,1076.3500000000001,0]
[61,null,2330.625,2236.0250000000001,1622.7750000000001,1207.25,0]
[62,null,2605.625,2500.0250000000001,1814.1750000000002,1349.15,0]
[63,null,2902.0750000000003,2784.65,2020.4250000000002,1502.8750000000002,0]
[64,null,3218.8750000000005,3088.8,2242.0750000000003,1667.8750000000002,0]
[65,null,3557.4,3413.3,2479.6750000000002,1844.7,0]
[66,null,3916.2750000000001,3757.6000000000004,2732.125,2032.2500000000002,0]
[67,null,4296.6000000000004,4122.25,2999.9750000000004,2231.625,0]
[68,null,4697.55,4506.9750000000004,3282.9500000000003,2442.2750000000001,0]
[69,null,5119.125,4911.7750000000005,3581.8750000000005,2664.4750000000004,0]
[70,null,5562.1500000000005,5336.6500000000005,3895.9250000000002,2897.9500000000003,0]
[71,null,6025.5250000000005,5781.3250000000007,4225.9250000000002,3143.2500000000005,0]
[72,null,6510.6250000000009,6246.6250000000009,4570.5,3400.1000000000004,0]
[73,null,7016.0750000000007,6731.4500000000007,4930.75,3667.6750000000002,0]
[74,null,7542.4250000000002,7237.1750000000002,5305.85,3947.0750000000003,0]
[75,null,8089.9500000000007,7762.4250000000002,5697.4500000000007,4238.3,0]
[76,null,8089.9500000000007,7762.4250000000002,5697.4500000000007,4238.3,0]
[77,null,8089.9500000000007,7762.4250000000002,5697.4500000000007,4238.3,0]
[78,null,8089.9500000000007,7762.4250000000002,5697.4500000000007,4238.3,0]
[79,null,8089.9500000000007,7762.4250000000002,5697.4500000000007,4238.3,0]
[80,null,8089.9500000000007,7762.4250000000002,5697.4500000000007,4238.3,0]
[81,null,8089.9500000000007,7762.4250000000002,5697.4500000000007,4238.3,0]
[82,null,8089.9500000000007,7762.4250000000002,5697.4500000000007,{"$f":"F369*$K$3","v":4238.3},0]
[83,null,{"$f":"C370*$K$3","v":8089.9500000000007},7762.4250000000002,5697.4500000000007,4238.3,0]
[84,"o más",8089.9500000000007,7762.4250000000002,5697.4500000000007,4238.3,0]
[1,"Hijo",399.3,383.07500000000005,298.92500000000001,222.47500000000002,0]
[2,"Hijos",678.15000000000009,650.65000000000009,507.37500000000006,377.57500000000005,0]
[3,"Hijos o más",957.55000000000007,918.50000000000011,716.37500000000011,532.95000000000005,0]
[]
["BUPA GLOBAL ULTIMATE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",0,1000,2000]
[18,null,16871,10885,null,null,null,null,true,true]
[19,null,16871,10885]
[20,null,16871,10885]
[21,null,16871,10885]
[22,null,16871,10885]
[23,null,16871,10885]
[24,null,16871,10885]
[25,null,18086,11669,null,null,null,null,true,true]
[26,null,18086,11669]
[27,null,18086,11669]
[28,null,18086,11669]
[29,null,18086,11669]
[30,null,20184,13024,null,null,null,null,true,true]
[31,null,20184,13024]
[32,null,20184,13024]
[33,null,20184,13024]
[34,null,20184,13024]
[35,null,22577,14566,null,null,null,null,true,true]
[36,null,22577,14566]
[37,null,22577,14566]
[38,null,22577,14566]
[39,null,22577,14566]
[40,null,25307,16329,null,null,null,null,true,true]
[41,null,25307,16329]
[42,null,25307,16329]
[43,null,25307,16329]
[44,null,25307,16329]
[45,null,28322,18274,null,null,null,null,true,true]
[46,null,28322,18274]
[47,null,28322,18274]
[48,null,28322,18274]
[49,null,28322,18274]
[50,null,31695,20449,null,null,null,null,true,true]
[51,null,31695,20449]
[52,null,31695,20449]
[53,null,31695,20449]
[54,null,31695,20449]
[55,null,35396,22839,null,null,null,null,true,true]
[56,null,35396,22839]
[57,null,35396,22839]
[58,null,35396,22839]
[59,null,35396,22839]
[60,null,37853,24423,null,null,null,null,true,true]
[61,null,42118,27175,null,null,null,null,true,true]
[62,null,46719,30143,null,null,null,null,true,true]
[63,null,51656,33328,null,null,null,null,true,true]
[64,null,56927,36727,null,null,null,null,true,true]
[65,null,62533,40345,null,null,null,null,true,true]
[66,null,68473,44175,null,null,null,null,true,true]
[67,null,74748,48226,null,null,null,null,true,true]
[68,null,81356,52489,null,null,null,null,true,true]
[69,null,88299,56968,null,null,null,null,true,true]
[70,null,95578,61665,null,null,null,null,true,true]
[71,null,103192,66577,null,null,null,null,true,true]
[72,null,111139,71703,null,null,null,null,true,true]
[73,null,119424,77047,null,null,null,null,true,true]
[74,null,128037,82605,null,null,null,null,true,true]
[75,null,136989,88383,null,null,null,null,true,true]
[76,null,136989,88383]
[77,null,136989,88383]
[78,null,136989,88383]
[79,null,136989,88383]
[80,null,136989,88383]
[81,null,136989,88383]
[82,null,136989,88383]
[83,null,136989,88383]
[84,"o más",136989,88383]
[1,"Hijo",7096,4579,null,null,null,null,true,true]
[2,"Hijos",12063,7784,null,null,null,null,true,true]
[3,"Hijos o más",17028,10989,null,null,null,null,true,true]
[]
["BUPA GLOBAL ULTIMATE - MENSUALES"]
["EDAD"]
[" "," ",0,1000,2000]
[18,null,{"$f":"C905*$K$2","v":1574.6266666666668},{"$f":"D905*$K$2","v":1015.9333333333334},0,0,0]
[19,null,{"$f":"C906*$K$2","v":1574.6266666666668},1015.9333333333334,0,0,0]
[20,null,1574.6266666666668,1015.9333333333334,0,0,0]
[21,null,1574.6266666666668,1015.9333333333334,0,0,0]
[22,null,1574.6266666666668,1015.9333333333334,0,0,0]
[23,null,1574.6266666666668,1015.9333333333334,0,0,0]
[24,null,1574.6266666666668,1015.9333333333334,0,0,0]
[25,null,1688.0266666666666,1089.1066666666668,0,0,0]
[26,null,1688.0266666666666,1089.1066666666668,0,0,0]
[27,null,1688.0266666666666,1089.1066666666668,0,0,0]
[28,null,1688.0266666666666,1089.1066666666668,0,0,0]
[29,null,1688.0266666666666,1089.1066666666668,0,0,0]
[30,null,1883.8400000000001,1215.5733333333335,0,0,0]
[31,null,1883.8400000000001,1215.5733333333335,0,0,0]
[32,null,1883.8400000000001,1215.5733333333335,0,0,0]
[33,null,1883.8400000000001,1215.5733333333335,0,0,0]
[34,null,1883.8400000000001,1215.5733333333335,0,0,0]
[35,null,2107.186666666667,1359.4933333333333,0,0,0]
[36,null,2107.186666666667,1359.4933333333333,0,0,0]
[37,null,2107.186666666667,1359.4933333333333,0,0,0]
[38,null,2107.186666666667,1359.4933333333333,0,0,0]
[39,null,2107.186666666667,1359.4933333333333,0,0,0]
[40,null,2361.9866666666667,1524.04,0,0,0]
[41,null,2361.9866666666667,1524.04,0,0,0]
[42,null,2361.9866666666667,1524.04,0,0,0]
[43,null,2361.9866666666667,1524.04,0,0,0]
[44,null,2361.9866666666667,1524.04,0,0,0]
[45,null,2643.3866666666668,1705.5733333333335,0,0,0]
[46,null,2643.3866666666668,1705.5733333333335,0,0,0]
[47,null,2643.3866666666668,1705.5733333333335,0,0,0]
[48,null,2643.3866666666668,1705.5733333333335,0,0,0]
[49,null,2643.3866666666668,1705.5733333333335,0,0,0]
[50,null,2958.2000000000003,1908.5733333333335,0,0,0]
[51,null,2958.2000000000003,1908.5733333333335,0,0,0]
[52,null,2958.2000000000003,1908.5733333333335,0,0,0]
[53,null,2958.2000000000003,1908.5733333333335,0,0,0]
[54,null,2958.2000000000003,1908.5733333333335,0,0,0]
[55,null,3303.626666666667,2131.64,0,0,0]
[56,null,3303.626666666667,2131.64,0,0,0]
[57,null,3303.626666666667,2131.64,0,0,0]
[58,null,3303.626666666667,2131.64,0,0,0]
[59,null,3303.626666666667,2131.64,0,0,0]
[60,null,3532.9466666666667,2279.48,0,0,0]
[61,null,3931.0133333333333,2536.3333333333335,0,0,0]
[62,null,4360.4400000000005,2813.3466666666668,0,0,0]
[63,null,4821.2266666666665,3110.6133333333337,0,0,0]
[64,null,5313.1866666666665,3427.8533333333335,0,0,0]
[65,null,5836.4133333333339,3765.5333333333333,0,0,0]
[66,null,6390.8133333333335,4123,0,0,0]
[67,null,6976.4800000000005,4501.0933333333332,0,0,0]
[68,null,7593.2266666666674,4898.9733333333334,0,0,0]
[69,null,8241.24,5317.0133333333333,0,0,0]
[70,null,8920.6133333333346,5755.4000000000005,0,0,0]
[71,null,9631.253333333334,6213.8533333333335,0,0,0]
[72,null,10372.973333333333,6692.2800000000007,0,0,0]
[73,null,11146.24,7191.0533333333333,0,0,0]
[74,null,11950.12,7709.8,0,0,0]
[75,null,12785.640000000001,8249.08,0,0,0]
[76,null,12785.640000000001,8249.08,0,0,0]
[77,null,12785.640000000001,8249.08,0,0,0]
[78,null,12785.640000000001,8249.08,0,0,0]
[79,null,12785.640000000001,8249.08,0,0,0]
[80,null,12785.640000000001,8249.08,0]
[81,null,12785.640000000001,8249.08,0]
[82,null,12785.640000000001,8249.08,0]
[83,null,{"$f":"C970*$K$2","v":12785.640000000001},8249.08,0]
[84,"o más",12785.640000000001,8249.08,0,0,0]
[1,"Hijo",662.29333333333341,427.37333333333333,0,0,0]
[2,"Hijos",1125.8800000000001,726.50666666666666,0,0,0]
[3,"Hijos o más",1589.28,1025.6400000000001,0,0,0]
[]
["BUPA GLOBAL ULTIMATE"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ",0,1000,2000]
[18,null,{"$f":"C905*$K$3","v":4639.5250000000005},{"$f":"D905*$K$3","v":2993.3750000000005},0,42.555333333333337,0]
[19,null,{"$f":"C906*$K$3","v":4639.5250000000005},2993.3750000000005,0,42.555333333333337,0]
[20,null,4639.5250000000005,2993.3750000000005,0,42.555333333333337,0]
[21,null,4639.5250000000005,2993.3750000000005,0,42.555333333333337,0]
[22,null,4639.5250000000005,2993.3750000000005,0,42.555333333333337,0]
[23,null,4639.5250000000005,2993.3750000000005,0,42.555333333333337,0]
[24,null,4639.5250000000005,2993.3750000000005,0,45.430000000000007,0]
[25,null,4973.6500000000005,3208.9750000000004,0,45.430000000000007,0]
[26,null,4973.6500000000005,3208.9750000000004,0,45.430000000000007,0]
[27,null,4973.6500000000005,3208.9750000000004,0,45.430000000000007,0]
[28,null,4973.6500000000005,3208.9750000000004,0,45.430000000000007,0]
[29,null,4973.6500000000005,3208.9750000000004,0,50.486333333333341,0]
[30,null,5550.6,3581.6000000000004,0,50.486333333333341,0]
[31,null,5550.6,3581.6000000000004,0,50.486333333333341,0]
[32,null,5550.6,3581.6000000000004,0,50.486333333333341,0]
[33,null,5550.6,3581.6000000000004,0,50.486333333333341,0]
[34,null,5550.6,3581.6000000000004,0,56.56933333333334,0]
[35,null,6208.6750000000002,4005.6500000000005,0,56.56933333333334,0]
[36,null,6208.6750000000002,4005.6500000000005,0,56.56933333333334,0]
[37,null,6208.6750000000002,4005.6500000000005,0,56.56933333333334,0]
[38,null,6208.6750000000002,4005.6500000000005,0,56.56933333333334,0]
[39,null,6208.6750000000002,4005.6500000000005,0,63.602000000000004,0]
[40,null,6959.4250000000002,4490.4750000000004,0,63.602000000000004,0]
[41,null,6959.4250000000002,4490.4750000000004,0,63.602000000000004,0]
[42,null,6959.4250000000002,4490.4750000000004,0,63.602000000000004,0]
[43,null,6959.4250000000002,4490.4750000000004,0,63.602000000000004,0]
[44,null,6959.4250000000002,4490.4750000000004,0,71.610000000000014,0]
[45,null,7788.55,5025.3500000000004,0,71.610000000000014,0]
[46,null,7788.55,5025.3500000000004,0,71.610000000000014,0]
[47,null,7788.55,5025.3500000000004,0,71.610000000000014,0]
[48,null,7788.55,5025.3500000000004,0,71.610000000000014,0]
[49,null,7788.55,5025.3500000000004,0,80.670333333333346,0]
[50,null,8716.125,5623.4750000000004,0,80.670333333333346,0]
[51,null,8716.125,5623.4750000000004,0,80.670333333333346,0]
[52,null,8716.125,5623.4750000000004,0,80.670333333333346,0]
[53,null,8716.125,5623.4750000000004,0,80.670333333333346,0]
[54,null,8716.125,5623.4750000000004,0,90.757333333333349,0]
[55,null,9733.9000000000015,6280.7250000000004,0,90.757333333333349,0]
[56,null,9733.9000000000015,6280.7250000000004,0,90.757333333333349,0]
[57,null,9733.9000000000015,6280.7250000000004,0,90.757333333333349,0]
[58,null,9733.9000000000015,6280.7250000000004,0,90.757333333333349,0]
[59,null,9733.9000000000015,6280.7250000000004,0,97.533333333333346,0]
[60,null,10409.575000000001,6716.3250000000007,0,109.39133333333335,0]
[61,null,11582.45,7473.1250000000009,0,122.25033333333334,0]
[62,null,12847.725,8289.3250000000007,0,136.16166666666669,0]
[63,null,14205.400000000001,9165.2000000000007,0,151.12533333333337,0]
[64,null,15654.925000000001,10099.925000000001,0,167.14133333333336,0]
[65,null,17196.575000000001,11094.875,0,184.13266666666669,0]
[66,null,18830.075000000001,12148.125000000002,0,202.20200000000003,0]
[67,null,20555.7,13262.150000000001,0,221.29800000000003,0]
[68,null,22372.9,14434.475,0,241.42066666666668,0]
[69,null,24282.225000000002,15666.2,0,262.59566666666672,0]
[70,null,26283.95,16957.875,0,284.82300000000004,0]
[71,null,28377.800000000003,18308.675000000003,0,308.077,0]
[72,null,30563.225000000002,19718.325000000001,0,332.33200000000005,0]
[73,null,32841.600000000006,21187.925000000003,0,357.63933333333335,0]
[74,null,35210.175000000003,22716.375000000004,0,384.05033333333336,0]
[75,null,37671.975000000006,24305.325000000001,0,384.05033333333336,0]
[76,null,37671.975000000006,24305.325000000001,0,384.05033333333336,0]
[77,null,37671.975000000006,24305.325000000001,0,384.05033333333336,0]
[78,null,37671.975000000006,24305.325000000001,0,384.05033333333336,0]
[79,null,37671.975000000006,24305.325000000001,0,384.05033333333336,0]
[80,null,37671.975000000006,24305.325000000001,0,384.05033333333336,0]
[81,null,37671.975000000006,24305.325000000001,0,384.05033333333336,0]
[82,null,37671.975000000006,24305.325000000001,0,384.05033333333336,0]
[83,null,{"$f":"C970*$K$3","v":37671.975000000006},24305.325000000001,0,384.05033333333336,0]
[84,"o más",37671.975000000006,24305.325000000001,0,20.148333333333333,0]
[1,"Hijo",1951.4,1259.2250000000001,0,34.213666666666668,0]
[2,"Hijos",3317.3250000000003,2140.6000000000004,0,48.279000000000003,0]
[3,"Hijos o más",4682.7000000000007,3021.9750000000004,0,0,0]
[]
["BUPA GLOBAL MM"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",10000,20000]
[18,null,2037,1579,null,null,null,null,true,true]
[19,null,2037,1579]
[20,null,2037,1579]
[21,null,2037,1579]
[22,null,2037,1579]
[23,null,2037,1579]
[24,null,2037,1579]
[25,null,2180,1676,null,null,null,null,true,true]
[26,null,2180,1676]
[27,null,2180,1676]
[28,null,2180,1676]
[29,null,2180,1676]
[30,null,2428,1851,null,null,null,null,true,true]
[31,null,2428,1851]
[32,null,2428,1851]
[33,null,2428,1851]
[34,null,2428,1851]
[35,null,2715,2062,null,null,null,null,true,true]
[36,null,2715,2062]
[37,null,2715,2062]
[38,null,2715,2062]
[39,null,2715,2062]
[40,null,3041,2308,null,null,null,null,true,true]
[41,null,3041,2308]
[42,null,3041,2308]
[43,null,3041,2308]
[44,null,3041,2308]
[45,null,3406,2589,null,null,null,null,true,true]
[46,null,3406,2589]
[47,null,3406,2589]
[48,null,3406,2589]
[49,null,3406,2589]
[50,null,3815,2905,null,null,null,null,true,true]
[51,null,3815,2905]
[52,null,3815,2905]
[53,null,3815,2905]
[54,null,3815,2905]
[55,null,4264,3261,null,null,null,null,true,true]
[56,null,4264,3261]
[57,null,4264,3261]
[58,null,4264,3261]
[59,null,4264,3261]
[60,null,4561,3498,null,null,null,null,true,true]
[61,null,5081,3918,null,null,null,null,true,true]
[62,null,5643,4373,null,null,null,null,true,true]
[63,null,6246,4864,null,null,null,null,true,true]
[64,null,6891,5395,null,null,null,null,true,true]
[65,null,7578,5961,null,null,null,null,true,true]
[66,null,8307,6567,null,null,null,null,true,true]
[67,null,9078,7208,null,null,null,null,true,true]
[68,null,9890,7888,null,null,null,null,true,true]
[69,null,10742,8603,null,null,null,null,true,true]
[70,null,11636,9356,null,null,null,null,true,true]
[71,null,12576,10147,null,null,null,null,true,true]
[72,null,13555,10976,null,null,null,null,true,true]
[73,null,14576,11841,null,null,null,null,true,true]
[74,null,15638,12744,null,null,null,null,true,true]
[75,null,16742,13685,null,null,null,null,true,true]
[76,null,16742,13685]
[77,null,16742,13685]
[78,null,16742,13685]
[79,null,16742,13685]
[80,null,16742,13685]
[81,null,16742,13685]
[82,null,16742,13685]
[83,null,16742,13685]
[84,"o más",16742,13685]
[1,"Hijo",860,675,null,null,null,null,true,true]
[2,"Hijos",1460,1147,null,null,null,null,true,true]
[3,"Hijos o más",2062,1618,null,null,null,null,true,true]
[]
["BUPA GLOBAL MM - MENSUALES"]
["EDAD"]
[" "," ",10000,20000]
[18,null,{"$f":"C1129*$K$2","v":190.12},{"$f":"D1129*$K$2","v":147.37333333333333},0,0,0]
[19,null,{"$f":"C1130*$K$2","v":190.12},147.37333333333333,0,0,0]
[20,null,190.12,147.37333333333333,0,0,0]
[21,null,190.12,147.37333333333333,0,0,0]
[22,null,190.12,147.37333333333333,0,0,0]
[23,null,190.12,147.37333333333333,0,0,0]
[24,null,190.12,147.37333333333333,0,0,0]
[25,null,203.46666666666667,156.42666666666668,0,0,0]
[26,null,203.46666666666667,156.42666666666668,0,0,0]
[27,null,203.46666666666667,156.42666666666668,0,0,0]
[28,null,203.46666666666667,156.42666666666668,0,0,0]
[29,null,203.46666666666667,156.42666666666668,0,0,0]
[30,null,226.61333333333334,172.76000000000002,0,0,0]
[31,null,226.61333333333334,172.76000000000002,0,0,0]
[32,null,226.61333333333334,172.76000000000002,0,0,0]
[33,null,226.61333333333334,172.76000000000002,0,0,0]
[34,null,226.61333333333334,172.76000000000002,0,0,0]
[35,null,253.4,192.45333333333335,0,0,0]
[36,null,253.4,192.45333333333335,0,0,0]
[37,null,253.4,192.45333333333335,0,0,0]
[38,null,253.4,192.45333333333335,0,0,0]
[39,null,253.4,192.45333333333335,0,0,0]
[40,null,283.82666666666665,215.41333333333336,0,0,0]
[41,null,283.82666666666665,215.41333333333336,0,0,0]
[42,null,283.82666666666665,215.41333333333336,0,0,0]
[43,null,283.82666666666665,215.41333333333336,0,0,0]
[44,null,283.82666666666665,215.41333333333336,0,0,0]
[45,null,317.89333333333337,241.64000000000001,0,0,0]
[46,null,317.89333333333337,241.64000000000001,0,0,0]
[47,null,317.89333333333337,241.64000000000001,0,0,0]
[48,null,317.89333333333337,241.64000000000001,0,0,0]
[49,null,317.89333333333337,241.64000000000001,0,0,0]
[50,null,356.06666666666666,271.13333333333333,0,0,0]
[51,null,356.06666666666666,271.13333333333333,0,0,0]
[52,null,356.06666666666666,271.13333333333333,0,0,0]
[53,null,356.06666666666666,271.13333333333333,0,0,0]
[54,null,356.06666666666666,271.13333333333333,0,0,0]
[55,null,397.97333333333336,304.36,0,0,0]
[56,null,397.97333333333336,304.36,0,0,0]
[57,null,397.97333333333336,304.36,0,0,0]
[58,null,397.97333333333336,304.36,0,0,0]
[59,null,397.97333333333336,304.36,0,0,0]
[60,null,425.69333333333333,326.48,0,0,0]
[61,null,474.22666666666669,365.68,0,0,0]
[62,null,526.68000000000006,408.1466666666667,0,0,0]
[63,null,582.96,453.97333333333336,0,0,0]
[64,null,643.16000000000008,503.53333333333336,0,0,0]
[65,null,707.28000000000009,556.36,0,0,0]
[66,null,775.32,612.92000000000007,0,0,0]
[67,null,847.28000000000009,672.74666666666667,0,0,0]
[68,null,923.06666666666672,736.21333333333337,0,0,0]
[69,null,1002.5866666666667,802.94666666666672,0,0,0]
[70,null,1086.0266666666666,873.22666666666669,0,0,0]
[71,null,1173.76,947.0533333333334,0,0,0]
[72,null,1265.1333333333334,1024.4266666666667,0,0,0]
[73,null,1360.4266666666667,1105.1600000000001,0,0,0]
[74,null,1459.5466666666666,1189.44,0,0,0]
[75,null,1562.5866666666668,1277.2666666666667,0,0,0]
[76,null,1562.5866666666668,1277.2666666666667,0,0,0]
[77,null,1562.5866666666668,1277.2666666666667,0,0,0]
[78,null,1562.5866666666668,1277.2666666666667,0,0,0]
[79,null,1562.5866666666668,1277.2666666666667,0,0,0]
[80,null,1562.5866666666668,1277.2666666666667,0]
[81,null,1562.5866666666668,1277.2666666666667,0]
[82,null,1562.5866666666668,1277.2666666666667,0]
[83,null,{"$f":"C1194*$K$2","v":1562.5866666666668},1277.2666666666667,0]
[84,"o más",1562.5866666666668,1277.2666666666667,0,0,0]
[1,"Hijo",80.266666666666666,63,0,0,0]
[2,"Hijos",136.26666666666668,107.05333333333334,0,0,0]
[3,"Hijos o más",192.45333333333335,151.01333333333335,0,0,0]
[]
["BUPA GLOBAL MM"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ",10000,20000]
[18,null,{"$f":"C1129*$K$3","v":560.17500000000007},{"$f":"D1129*$K$3","v":434.22500000000002},0,0,0]
[19,null,{"$f":"C1130*$K$3","v":560.17500000000007},434.22500000000002,0,241.65350000000001,0]
[20,null,560.17500000000007,434.22500000000002,0,241.65350000000001,0]
[21,null,560.17500000000007,434.22500000000002,0,241.65350000000001,0]
[22,null,560.17500000000007,434.22500000000002,0,241.65350000000001,0]
[23,null,560.17500000000007,434.22500000000002,0,241.65350000000001,0]
[24,null,560.17500000000007,434.22500000000002,0,241.65350000000001,0]
[25,null,599.5,460.90000000000003,0,241.65350000000001,0]
[26,null,599.5,460.90000000000003,0,257.97750000000002,0]
[27,null,599.5,460.90000000000003,0,257.97750000000002,0]
[28,null,599.5,460.90000000000003,0,257.97750000000002,0]
[29,null,599.5,460.90000000000003,0,257.97750000000002,0]
[30,null,667.7,509.02500000000003,0,257.97750000000002,0]
[31,null,667.7,509.02500000000003,0,286.69025000000005,0]
[32,null,667.7,509.02500000000003,0,286.69025000000005,0]
[33,null,667.7,509.02500000000003,0,286.69025000000005,0]
[34,null,667.7,509.02500000000003,0,286.69025000000005,0]
[35,null,746.62500000000011,567.05000000000007,0,286.69025000000005,0]
[36,null,746.62500000000011,567.05000000000007,0,321.23300000000006,0]
[37,null,746.62500000000011,567.05000000000007,0,321.23300000000006,0]
[38,null,746.62500000000011,567.05000000000007,0,321.23300000000006,0]
[39,null,746.62500000000011,567.05000000000007,0,321.23300000000006,0]
[40,null,836.27500000000009,634.70000000000005,0,321.23300000000006,0]
[41,null,836.27500000000009,634.70000000000005,0,361.16850000000005,0]
[42,null,836.27500000000009,634.70000000000005,0,361.16850000000005,0]
[43,null,836.27500000000009,634.70000000000005,0,361.16850000000005,0]
[44,null,836.27500000000009,634.70000000000005,0,361.16850000000005,0]
[45,null,936.65000000000009,711.97500000000002,0,361.16850000000005,0]
[46,null,936.65000000000009,711.97500000000002,0,406.64250000000004,0]
[47,null,936.65000000000009,711.97500000000002,0,406.64250000000004,0]
[48,null,936.65000000000009,711.97500000000002,0,406.64250000000004,0]
[49,null,936.65000000000009,711.97500000000002,0,406.64250000000004,0]
[50,null,1049.125,798.87500000000011,0,406.64250000000004,0]
[51,null,1049.125,798.87500000000011,0,458.09225000000009,0]
[52,null,1049.125,798.87500000000011,0,458.09225000000009,0]
[53,null,1049.125,798.87500000000011,0,458.09225000000009,0]
[54,null,1049.125,798.87500000000011,0,458.09225000000009,0]
[55,null,1172.6000000000001,896.77500000000009,0,458.09225000000009,0]
[56,null,1172.6000000000001,896.77500000000009,0,515.37200000000007,0]
[57,null,1172.6000000000001,896.77500000000009,0,515.37200000000007,0]
[58,null,1172.6000000000001,896.77500000000009,0,515.37200000000007,0]
[59,null,1172.6000000000001,896.77500000000009,0,515.37200000000007,0]
[60,null,1254.2750000000001,961.95,0,515.37200000000007,0]
[61,null,1397.2750000000001,1077.45,0,553.85,0]
[62,null,1551.825,1202.575,0,621.18650000000014,0]
[63,null,1717.65,1337.6000000000001,0,694.20725000000016,0]
[64,null,1895.0250000000001,1483.6250000000002,0,773.20375000000013,0]
[65,null,2083.9500000000003,1639.2750000000001,0,858.17600000000016,0]
[66,null,2284.4250000000002,1805.9250000000002,0,949.12400000000014,0]
[67,null,2496.4500000000003,1982.2000000000003,0,1045.6105000000002,0]
[68,null,2719.75,2169.2000000000003,0,1148.2185000000002,0]
[69,null,2954.05,2365.8250000000003,0,1256.6565000000001,0]
[70,null,3199.9,2572.9,0,1370.9245000000001,0]
[71,null,3458.4,2790.4250000000002,0,1491.1682500000002,0]
[72,null,3727.6250000000005,3018.4,0,1617.3877500000001,0]
[73,null,4008.4000000000005,3256.2750000000001,0,1749.4372500000002,0]
[74,null,4300.4500000000007,3504.6000000000004,0,1887.1710000000003,0]
[75,null,4604.05,3763.3750000000005,0,2030.8805000000002,0]
[76,null,4604.05,3763.3750000000005,0,2180.8572500000005,0]
[77,null,4604.05,3763.3750000000005,0,2180.8572500000005,0]
[78,null,4604.05,3763.3750000000005,0,2180.8572500000005,0]
[79,null,4604.05,3763.3750000000005,0,2180.8572500000005,0]
[80,null,4604.05,3763.3750000000005,0,2180.8572500000005,0]
[81,null,4604.05,3763.3750000000005,0,2180.8572500000005,0]
[82,null,4604.05,3763.3750000000005,0,2180.8572500000005,0]
[83,null,{"$f":"C1194*$K$3","v":4604.05},3763.3750000000005,0,2180.8572500000005,0]
[84,"o más",4604.05,3763.3750000000005,0,2180.8572500000005,0]
[1,"Hijo",236.50000000000003,185.62500000000003,0,2180.8572500000005,0]
[2,"Hijos",401.50000000000006,315.42500000000001,0,114.41375000000001,0]
[3,"Hijos o más",567.05000000000007,444.95000000000005,0,194.28475000000003,0]
[]
["BUPA GLOBAL MM"]
["TARIFAS SEMESTRAL"]
["EDAD"]
[" "," ",10000,20000]
[18,null,{"$f":"C1129*$K$4","v":1079.6100000000001},{"$f":"D1129*$K$4","v":836.87},0,0,0]
[19,null,{"$f":"C1130*$K$4","v":1079.6100000000001},836.87,0,343.26187500000009,266.20000000000005]
[20,null,1079.6100000000001,836.87,0,343.26187500000009,266.20000000000005]
[21,null,1079.6100000000001,836.87,0,343.26187500000009,266.20000000000005]
[22,null,1079.6100000000001,836.87,0,343.26187500000009,266.20000000000005]
[23,null,1079.6100000000001,836.87,0,343.26187500000009,266.20000000000005]
[24,null,1079.6100000000001,836.87,0,343.26187500000009,266.20000000000005]
[25,null,1155.4000000000001,888.28000000000009,0,343.26187500000009,266.20000000000005]
[26,null,1155.4000000000001,888.28000000000009,0,364.43687500000004,282.68625000000003]
[27,null,1155.4000000000001,888.28000000000009,0,364.43687500000004,282.68625000000003]
[28,null,1155.4000000000001,888.28000000000009,0,364.43687500000004,282.68625000000003]
[29,null,1155.4000000000001,888.28000000000009,0,364.43687500000004,282.68625000000003]
[30,null,1286.8400000000001,981.03000000000009,0,364.43687500000004,282.68625000000003]
[31,null,1286.8400000000001,981.03000000000009,0,402.17375000000004,311.953125]
[32,null,1286.8400000000001,981.03000000000009,0,402.17375000000004,311.953125]
[33,null,1286.8400000000001,981.03000000000009,0,402.17375000000004,311.953125]
[34,null,1286.8400000000001,981.03000000000009,0,402.17375000000004,311.953125]
[35,null,1438.95,1092.8600000000001,0,402.17375000000004,311.953125]
[36,null,1438.95,1092.8600000000001,0,446.41437500000006,346.21125000000006]
[37,null,1438.95,1092.8600000000001,0,446.41437500000006,346.21125000000006]
[38,null,1438.95,1092.8600000000001,0,446.41437500000006,346.21125000000006]
[39,null,1438.95,1092.8600000000001,0,446.41437500000006,346.21125000000006]
[40,null,1611.73,1223.24,0,446.41437500000006,346.21125000000006]
[41,null,1611.73,1223.24,0,497.76375000000007,386.14125000000007]
[42,null,1611.73,1223.24,0,497.76375000000007,386.14125000000007]
[43,null,1611.73,1223.24,0,497.76375000000007,386.14125000000007]
[44,null,1611.73,1223.24,0,497.76375000000007,386.14125000000007]
[45,null,1805.18,1372.17,0,497.76375000000007,386.14125000000007]
[46,null,1805.18,1372.17,0,555.31437500000015,430.6843750000001]
[47,null,1805.18,1372.17,0,555.31437500000015,430.6843750000001]
[48,null,1805.18,1372.17,0,555.31437500000015,430.6843750000001]
[49,null,1805.18,1372.17,0,555.31437500000015,430.6843750000001]
[50,null,2021.95,1539.65,0,555.31437500000015,430.6843750000001]
[51,null,2021.95,1539.65,0,620.42750000000012,481.20187500000003]
[52,null,2021.95,1539.65,0,620.42750000000012,481.20187500000003]
[53,null,2021.95,1539.65,0,620.42750000000012,481.20187500000003]
[54,null,2021.95,1539.65,0,620.42750000000012,481.20187500000003]
[55,null,2259.92,1728.3300000000002,0,620.42750000000012,481.20187500000003]
[56,null,2259.92,1728.3300000000002,0,692.72500000000002,537.24000000000012]
[57,null,2259.92,1728.3300000000002,0,692.72500000000002,537.24000000000012]
[58,null,2259.92,1728.3300000000002,0,692.72500000000002,537.24000000000012]
[59,null,2259.92,1728.3300000000002,0,692.72500000000002,537.24000000000012]
[60,null,2417.33,1853.94,0,692.72500000000002,537.24000000000012]
[61,null,2692.9300000000003,2076.54,0,740.74687500000005,574.4475000000001]
[62,null,2990.79,2317.69,0,825.14437500000008,639.86312500000008]
[63,null,3310.38,2577.92,0,916.27250000000015,710.5725000000001]
[64,null,3652.23,2859.3500000000004,0,1014.7362500000002,786.95375000000013]
[65,null,4016.34,3159.3300000000004,0,1120.2331250000002,868.70437500000014]
[66,null,4402.71,3480.51,0,1232.9143750000003,956.20250000000021]
[67,null,4811.34,3820.2400000000002,0,1352.7043750000003,1049.1456250000001]
[68,null,5241.7,4180.6400000000003,0,1479.6787500000003,1147.5337500000003]
[69,null,5693.26,4559.59,0,1613.7618750000001,1251.59375]
[70,null,6167.08,4958.68,0,1755.1050000000002,1361.1743750000003]
[71,null,6665.2800000000007,5377.91,0,1903.4056250000003,1476.1243750000003]
[72,null,7184.1500000000005,5817.2800000000007,0,2058.9662500000004,1596.7462500000001]
[73,null,7725.2800000000007,6275.7300000000005,0,2221.4087500000001,1722.8131250000004]
[74,null,8288.1400000000012,6754.3200000000006,0,2391.3381250000007,1854.5518750000003]
[75,null,8873.26,7253.05,0,2568.3006250000008,1991.7356250000003]
[76,null,8873.26,7253.05,0,2752.2962500000003,2134.44]
[77,null,8873.26,7253.05,0,2752.2962500000003,2134.44]
[78,null,8873.26,7253.05,0,2752.2962500000003,2134.44]
[79,null,8873.26,7253.05,0,2752.2962500000003,2134.44]
[80,null,8873.26,7253.05,0,2752.2962500000003,2134.44]
[81,null,8873.26,7253.05,0,2752.2962500000003,2134.44]
[82,null,8873.26,7253.05,0,2752.2962500000003,2134.44]
[83,null,{"$f":"C1194*$K$4","v":8873.26},7253.05,0,2752.2962500000003,2134.44]
[84,"o más",8873.26,7253.05,0,2752.2962500000003,2134.44]
[1,"Hijo",455.8,357.75,0,2752.2962500000003,2134.44]
[2,"Hijos",773.80000000000007,607.91000000000008,0,146.10750000000004,113.28625000000002]
[3,"Hijos o más",1092.8600000000001,857.54000000000008,0,248.35250000000002,192.54125000000005]
[]
["BUPA GLOBAL ULTIMATE"]
["TARIFAS SEMESTRALES"]
["EDAD"]
[" "," ",0,1000,2000]
[18,null,{"$f":"C905*$K$4","v":8941.630000000001},{"$f":"D905*$K$4","v":5769.05},0,0,0]
[19,null,{"$f":"C906*$K$4","v":8941.630000000001},5769.05,0,181.34875000000002,0]
[20,null,8941.630000000001,5769.05,0,181.34875000000002,0]
[21,null,8941.630000000001,5769.05,0,181.34875000000002,0]
[22,null,8941.630000000001,5769.05,0,181.34875000000002,0]
[23,null,8941.630000000001,5769.05,0,181.34875000000002,0]
[24,null,8941.630000000001,5769.05,0,181.34875000000002,0]
[25,null,9585.58,6184.5700000000006,0,181.34875000000002,0]
[26,null,9585.58,6184.5700000000006,0,191.70937500000002,0]
[27,null,9585.58,6184.5700000000006,0,191.70937500000002,0]
[28,null,9585.58,6184.5700000000006,0,191.70937500000002,0]
[29,null,9585.58,6184.5700000000006,0,191.70937500000002,0]
[30,null,10697.52,6902.72,0,191.70937500000002,0]
[31,null,10697.52,6902.72,0,210.46437500000002,0]
[32,null,10697.52,6902.72,0,210.46437500000002,0]
[33,null,10697.52,6902.72,0,210.46437500000002,0]
[34,null,10697.52,6902.72,0,210.46437500000002,0]
[35,null,11965.810000000001,7719.9800000000005,0,210.46437500000002,0]
[36,null,11965.810000000001,7719.9800000000005,0,232.62250000000003,0]
[37,null,11965.810000000001,7719.9800000000005,0,232.62250000000003,0]
[38,null,11965.810000000001,7719.9800000000005,0,232.62250000000003,0]
[39,null,11965.810000000001,7719.9800000000005,0,232.62250000000003,0]
[40,null,13412.710000000001,8654.3700000000008,0,232.62250000000003,0]
[41,null,13412.710000000001,8654.3700000000008,0,258.63750000000005,0]
[42,null,13412.710000000001,8654.3700000000008,0,258.63750000000005,0]
[43,null,13412.710000000001,8654.3700000000008,0,258.63750000000005,0]
[44,null,13412.710000000001,8654.3700000000008,0,258.63750000000005,0]
[45,null,15010.66,9685.2200000000012,0,258.63750000000005,0]
[46,null,15010.66,9685.2200000000012,0,287.75312500000001,0]
[47,null,15010.66,9685.2200000000012,0,287.75312500000001,0]
[48,null,15010.66,9685.2200000000012,0,287.75312500000001,0]
[49,null,15010.66,9685.2200000000012,0,287.75312500000001,0]
[50,null,16798.350000000002,10837.970000000001,0,287.75312500000001,0]
[51,null,16798.350000000002,10837.970000000001,0,321.10375000000005,0]
[52,null,16798.350000000002,10837.970000000001,0,321.10375000000005,0]
[53,null,16798.350000000002,10837.970000000001,0,321.10375000000005,0]
[54,null,16798.350000000002,10837.970000000001,0,321.10375000000005,0]
[55,null,18759.88,12104.67,0,321.10375000000005,0]
[56,null,18759.88,12104.67,0,358.00875000000008,0]
[57,null,18759.88,12104.67,0,358.00875000000008,0]
[58,null,18759.88,12104.67,0,358.00875000000008,0]
[59,null,18759.88,12104.67,0,358.00875000000008,0]
[60,null,20062.09,12944.19,0,358.00875000000008,0]
[61,null,22322.54,14402.75,0,382.58687500000008,0]
[62,null,24761.07,15975.79,0,425.92000000000007,0]
[63,null,27377.68,17663.84,0,473.03437500000013,0]
[64,null,30171.31,19465.310000000001,0,523.70312500000011,0]
[65,null,33142.490000000005,21382.850000000002,0,578.30437500000005,0]
[66,null,36290.69,23412.75,0,636.6868750000001,0]
[67,null,39616.44,25559.780000000002,0,698.77500000000009,0]
[68,null,43118.68,27819.170000000002,0,764.79562500000009,0]
[69,null,46798.47,30193.040000000001,0,834.37062500000013,0]
[70,null,50656.340000000004,32682.45,0,907.80250000000012,0]
[71,null,54691.76,35285.810000000005,0,984.94000000000017,0]
[72,null,58903.670000000006,38002.590000000004,0,1066.0100000000002,0]
[73,null,63294.720000000001,40834.910000000003,0,1150.7100000000003,0]
[74,null,67859.61,43780.65,0,1239.1912500000003,0]
[75,null,72604.17,46842.990000000005,0,1331.5293750000001,0]
[76,null,72604.17,46842.990000000005,0,1427.6487500000003,0]
[77,null,72604.17,46842.990000000005,0,1427.6487500000003,0]
[78,null,72604.17,46842.990000000005,0,1427.6487500000003,0]
[79,null,72604.17,46842.990000000005,0,1427.6487500000003,0]
[80,null,72604.17,46842.990000000005,0,1427.6487500000003,0]
[81,null,72604.17,46842.990000000005,0,1427.6487500000003,0]
[82,null,72604.17,46842.990000000005,0,1427.6487500000003,0]
[83,null,{"$f":"C970*$K$4","v":72604.17},46842.990000000005,0,1427.6487500000003,0]
[84,"o más",72604.17,46842.990000000005,0,1427.6487500000003,0]
[1,"Hijo",3760.88,2426.8700000000003,0,1427.6487500000003,0]
[2,"Hijos",6393.39,4125.5200000000004,0,77.591250000000016,0]
[3,"Hijos o más",9024.84,5824.17,0,131.89000000000001,0]