{"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":9,"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":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[28,3,28,4],[28,6,28,7],[9,0,9,12],[18,5,18,6],[14,1,14,2],[16,1,16,2],[14,3,14,7],[16,5,16,6],[18,1,18,2],[20,3,20,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,65,null,"Edad del/la cónyuge:",null,71]
[]
[null,null,"Cotizador por:","NOMBRE DE AGENTE"]
[]
[]
[]
["2. SELECCIONE EL PRODUCTO PARA VER LA COTIZACIÓN CORRESPONDIENTE: "]
[]
[]
[]
[]
[]
[]
[]
[null,2,null,2]

{"sheet":"Global Ultimate Health  Plan","index":1,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[13,3,13,4],[13,5,13,8],[17,3,17,4],[19,3,19,4],[37,0,37,1],[27,4,27,7],[15,3,15,4],[15,5,15,8],[22,0,22,1],[13,0,13,1],[38,4,38,7],[50,4,50,7],[65,4,65,7],[43,0,44,0],[43,1,44,1],[48,4,48,5],[54,4,54,5],[104,0,104,1],[73,0,74,1],[90,0,90,1],[21,3,21,4],[42,0,42,1],[58,0,58,1],[62,0,62,1],[78,0,78,1],[80,4,82,7],[79,4,79,7],[61,4,61,5],[36,4,36,5],[55,4,55,5],[69,4,69,5],[70,4,70,5],[76,4,76,5]]}
[]
[]
[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$15","v":"JOHN DOE"}]
[]
[null,null,null,"Cotizado por:",null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE AGENTE"}]
[]
[null,null,null,"Número de adultos en la póliza:",null,{"$f":"+'INGRESO DE DATOS'!$D$17","v":2},null,"Edad del Asegurado Titular:",{"$f":"+'INGRESO DE DATOS'!$D$19","v":65}]
[]
[null,null,null,"Número de niños en la póliza:",null,3,null,"Edad del/la conyuge:",{"$f":"+'INGRESO DE DATOS'!$H$19","v":71}]
[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$33","v":2},null,"Fecha de la cotización:",{"$f":"NOW()","v":"2022-01-26T13:22:05.120"}]
[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$18,Tablas!$A$905:$G$971,3,TRUE))*1.1494","v":81938.427200000006},{"$f":"(VLOOKUP($I$18,Tablas!$A$905:$G$971,4,TRUE))*1.1494","v":52865.503599999996}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$905:$G$971,3,TRUE))))*1.1494","v":135214.2666},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$905:$G$971,4,TRUE))))*1.1494","v":87237.161200000002}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)=Tablas!A972,Tablas!C972,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)=Tablas!A973,Tablas!C973,Tablas!C974))))*1.1494","v":9298.6460000000006},{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)=Tablas!A972,Tablas!D972,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)=Tablas!A973,Tablas!D973,Tablas!D974))))*1.1494","v":6001.0173999999997}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G29:G31))","v":226451.33980000002},{"$f":"(SUM(H29:H31))","v":146103.68220000001}]
[null,null,null,null,"Costo administrativo anual",null,86,86]
[null,null,null,null,"Impuesto (14.49%)",null,{"$f":"(G33)*0%","v":0},{"$f":"(H33)*0%","v":0}]
[]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"SUM(G32:G34)","v":226537.33980000002},{"$f":"SUM(H32:H34)","v":146189.68220000001}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33) < 0, NA(), (IF('INGRESO DE DATOS'!H17<=0,0,IF('INGRESO DE DATOS'!H17=Tablas!A972,Tablas!C972,IF('INGRESO DE DATOS'!H17=Tablas!A973,Tablas!C973,Tablas!C974))) - IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)=Tablas!A972,Tablas!C972,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)=Tablas!A973,Tablas!C973,Tablas!C974))))))*1.1494","v":13013.506799999999},{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33) < 0, NA(), (IF('INGRESO DE DATOS'!H17<=0,0,IF('INGRESO DE DATOS'!H17=Tablas!A972,Tablas!D972,IF('INGRESO DE DATOS'!H17=Tablas!A973,Tablas!D973,Tablas!D974))) - IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)=Tablas!A972,Tablas!D972,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!B33)=Tablas!A973,Tablas!D973,Tablas!D974))))))*1.1494","v":8398.6658000000007}]
[]
[null,null,null,null,"Tarifas Semianuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$18,Tablas!$A$1428:$G$1494,3,TRUE))*1.1494","v":43427.366415999997},{"$f":"(VLOOKUP($I$18,Tablas!$A$1428:$G$1494,4,TRUE))*1.1494","v":28018.716907999999}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$1428:$G$1494,3,TRUE))))*1.1494","v":71663.561298000001},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$1428:$G$1494,4,TRUE))))*1.1494","v":46235.695436000002}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G31*Tablas!K4","v":4928.2823800000006},{"$f":"H31*Tablas!K4","v":3180.5392219999999}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G40:G42))","v":120019.21009399999},{"$f":"(SUM(H40:H42))","v":77434.951566000003}]
[null,null,null,null,"Costo administrativo annual",null,86,86]
[null,null,null,null,"Impuesto (14.49%)",null,{"$f":"(G44)*0%","v":0},{"$f":"(H44)*0%","v":0}]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G43:G45)","v":120105.21009399999},{"$f":"SUM(H43:H45)","v":77520.951566000003}]
[null,null,null,null,"Costo de segunda cuota",null,{"$f":"G43+G45","v":120019.21009399999},{"$f":"H43+H45","v":77434.951566000003}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G46+G47","v":240124.42018799999},{"$f":"H46+H47","v":154955.90313200001}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G37*Tablas!K4*2","v":13794.317208},{"$f":"H37*Tablas!K4*2","v":8902.5857480000013}]
[]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$18,Tablas!$A$1054:$G$1120,3,TRUE))*1.1494","v":22533.067480000002},{"$f":"(VLOOKUP($I$18,Tablas!$A$1054:$G$1120,4,TRUE))*1.1494","v":14538.013489999999}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$1054:$G$1120,3,TRUE))))*1.1494","v":37183.923315},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$1054:$G$1120,4,TRUE))))*1.1494","v":23990.21933}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G31*Tablas!K3","v":2557.1276500000004},{"$f":"H31*Tablas!K3","v":1650.2797849999999}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G52:G54))","v":62274.118445000007},{"$f":"(SUM(H52:H54))","v":40178.512604999996}]
[null,null,null,null,"Costo administrativo annual",null,86,86]
[null,null,null,null,"Impuesto (14.49%)",null,{"$f":"(G56)*0%","v":0},{"$f":"(H56)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G55:G57)","v":62360.118445000007},{"$f":"SUM(H55:H57)","v":40264.512604999996}]
[null,null,null,null,"Tres (3) cuotas adicionales, cada una de:",null,{"$f":"G55+G57","v":62274.118445000007},{"$f":"H55+H57","v":40178.512604999996}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G59+(G60*3)","v":249182.47378000003},{"$f":"H59+(H60*3)","v":160800.05041999999}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G37*Tablas!K3*4","v":14314.857480000001},{"$f":"H37*Tablas!K3*4","v":9238.5323800000024}]
[]
[]
[]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$18,Tablas!$A$979:$G$1045,3,TRUE))*1.1494","v":7647.5865386666674},{"$f":"(VLOOKUP($I$18,Tablas!$A$979:$G$1045,4,TRUE))*1.1494","v":4934.1136693333337}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$979:$G$1045,3,TRUE))))*1.1494","v":12619.998216000002},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$979:$G$1045,4,TRUE))))*1.1494","v":8142.1350453333334}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G31*Tablas!K2","v":867.87362666666672},{"$f":"H31*Tablas!K2","v":560.09495733333335}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G67:G69))","v":21135.458381333337},{"$f":"(SUM(H67:H69))","v":13636.343672000001}]
[null,null,null,null,"Costo administrativo anual",null,86,86]
[null,null,null,null,"Impuesto (14.49%)",null,{"$f":"(G71)*0%","v":0},{"$f":"(H71)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G70:G72)","v":21221.458381333337},{"$f":"SUM(H70:H72)","v":13722.343672000001}]
[null,null,null,null,"Once (11) cuotas mensuales cada una de:",null,{"$f":"G70+G72","v":21135.458381333337},{"$f":"H70+H72","v":13636.343672000001}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G74+(G75*11)","v":253711.50057600005},{"$f":"H74+(H75*11)","v":163722.124064}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G37*Tablas!K2*12","v":14575.127615999998},{"$f":"H37*Tablas!K2*12","v":9406.5056960000002}]
[]
[]
[null,null,null,null,"Tarifas en US$ -  Efectivas a partir del 1ro. de Enero de 2022"]
[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":80,"n_cols":11,"rows_kept":80,"cut":false,"hidden":false,"merged":[[13,0,13,1],[15,5,15,8],[69,4,69,5],[68,4,68,5],[75,4,75,5],[64,4,64,10],[22,0,22,1],[37,0,37,1],[63,0,63,1],[75,0,75,1],[27,4,27,10],[36,4,36,5],[48,4,48,5],[61,4,61,5],[54,4,54,5],[55,4,55,5],[38,4,38,10],[50,4,50,10],[21,3,21,4],[19,3,19,4],[13,5,13,8],[13,3,13,4],[17,3,17,4],[79,0,79,1],[89,0,89,1],[42,0,42,1],[59,0,59,1],[79,4,80,10],[78,4,78,10]]}
[]
[]
[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$15","v":"JOHN DOE"}]
[]
[null,null,null,null,"Cotizado por:",{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE AGENTE"}]
[]
[null,null,null,"Número de adultos en la póliza:",null,{"$f":"+'INGRESO DE DATOS'!$D$17","v":2},null,"Edad del Asegurado Titular:",{"$f":"+'INGRESO DE DATOS'!$D$19","v":65}]
[]
[null,null,null,"Número de niños en la póliza:",null,{"$f":"+'INGRESO DE DATOS'!$H$17","v":3},null,"Edad del/la conyuge:",{"$f":"+'INGRESO DE DATOS'!$H$19","v":71}]
[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$33","v":2},null,"Fecha de la cotización:",{"$f":"NOW()","v":"2022-01-26T13:22:05.120"}]
[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$18,Tablas!$A$6:$G$72,3,TRUE))*1.1494","v":35342.900600000001},{"$f":"(VLOOKUP($I$18,Tablas!$A$6:$G$72,4,TRUE))*1.1494","v":30980.927599999999},{"$f":"(VLOOKUP($I$18,Tablas!$A$6:$G$72,5,TRUE))*1.1494","v":24930.486000000001},{"$f":"(VLOOKUP($I$18,Tablas!$A$6:$G$72,6,TRUE))*1.1494","v":21619.064599999998},{"$f":"(VLOOKUP($I$18,Tablas!$A$6:$G$72,7,TRUE))*1.1494","v":16467.453799999999}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$6:$G$72,3,TRUE))))*1.1494","v":58815.947399999997},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$6:$G$72,4,TRUE))))*1.1494","v":51554.038199999995},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$6:$G$72,5,TRUE))))*1.1494","v":41632.417399999998},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$6:$G$72,6,TRUE))))*1.1494","v":36101.5046},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$6:$G$72,7,TRUE))))*1.1494","v":27497.0962}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A73,Tablas!C73,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A74,Tablas!C74,Tablas!C75))))*1.1494","v":4029.7963999999997},{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A73,Tablas!D73,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A74,Tablas!D74,Tablas!D75))))*1.1494","v":3532.1061999999997},{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A73,Tablas!E73,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A74,Tablas!E74,Tablas!E75))))*1.1494","v":2953.9580000000001},{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A73,Tablas!F73,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A74,Tablas!F74,Tablas!F75))))*1.1494","v":2562.0126},{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A73,Tablas!G73,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A74,Tablas!G74,Tablas!G75))))*1.1494","v":1951.6812}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G29:G31))","v":98188.644400000005},{"$f":"(SUM(H29:H31))","v":86067.071999999986},{"$f":"(SUM(I29:I31))","v":69516.861399999994},{"$f":"(SUM(J29:J31))","v":60282.5818},{"$f":"(SUM(K29:K31))","v":45916.231200000002}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G33)*0%","v":0},{"$f":"(H33)*0%","v":0},{"$f":"(I33)*0%","v":0},{"$f":"(J33)*0%","v":0},{"$f":"(K33)*0%","v":0}]
[]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"SUM(G32:G34)","v":98274.644400000005},{"$f":"SUM(H32:H34)","v":86153.071999999986},{"$f":"SUM(I32:I34)","v":69602.861399999994},{"$f":"SUM(J32:J34)","v":60368.5818},{"$f":"SUM(K32:K34)","v":46002.231200000002}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33) < 0, NA(), (IF('INGRESO DE DATOS'!H17<=0,0,IF('INGRESO DE DATOS'!H17=Tablas!A73,Tablas!C73,IF('INGRESO DE DATOS'!H17=Tablas!A74,Tablas!C74,Tablas!C75))) - IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A73,Tablas!C73,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A74,Tablas!C74,Tablas!C75))))))*1.1494","v":5637.8069999999998},{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33) < 0, NA(), (IF('INGRESO DE DATOS'!H17<=0,0,IF('INGRESO DE DATOS'!H17=Tablas!A73,Tablas!D73,IF('INGRESO DE DATOS'!H17=Tablas!A74,Tablas!D74,Tablas!D75))) - IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A73,Tablas!D73,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A74,Tablas!D74,Tablas!D75))))))*1.1494","v":4941.2705999999998},{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33) < 0, NA(), (IF('INGRESO DE DATOS'!H17<=0,0,IF('INGRESO DE DATOS'!H17=Tablas!A73,Tablas!E73,IF('INGRESO DE DATOS'!H17=Tablas!A74,Tablas!E74,Tablas!E75))) - IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A73,Tablas!E73,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A74,Tablas!E74,Tablas!E75))))))*1.1494","v":4133.2424000000001},{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33) < 0, NA(), (IF('INGRESO DE DATOS'!H17<=0,0,IF('INGRESO DE DATOS'!H17=Tablas!A73,Tablas!F73,IF('INGRESO DE DATOS'!H17=Tablas!A74,Tablas!F74,Tablas!F75))) - IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A73,Tablas!F73,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A74,Tablas!F74,Tablas!F75))))))*1.1494","v":3583.8292000000001},{"$f":"(IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33) < 0, NA(), (IF('INGRESO DE DATOS'!H17<=0,0,IF('INGRESO DE DATOS'!H17=Tablas!A73,Tablas!G73,IF('INGRESO DE DATOS'!H17=Tablas!A74,Tablas!G74,Tablas!G75))) - IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)<=0,0,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A73,Tablas!G73,IF(('INGRESO DE DATOS'!H17 - 'INGRESO DE DATOS'!D33)=Tablas!A74,Tablas!G74,Tablas!G75))))))*1.1494","v":2730.9744000000001}]
[]
[null,null,null,null,"Tarifas Semianuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$18,Tablas!$A$455:$G$521,3,TRUE))*1.1494","v":18731.737318},{"$f":"(VLOOKUP($I$18,Tablas!$A$455:$G$521,4,TRUE))*1.1494","v":16419.891628000001},{"$f":"(VLOOKUP($I$18,Tablas!$A$455:$G$521,5,TRUE))*1.1494","v":13213.157580000001},{"$f":"(VLOOKUP($I$18,Tablas!$A$455:$G$521,6,TRUE))*1.1494","v":11458.104238},{"$f":"(VLOOKUP($I$18,Tablas!$A$455:$G$521,7,TRUE))*1.1494","v":8727.7505139999994}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$455:$G$521,3,TRUE))))*1.1494","v":31172.452121999999},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$455:$G$521,4,TRUE))))*1.1494","v":27323.640245999999},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$455:$G$521,5,TRUE))))*1.1494","v":22065.181221999999},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$455:$G$521,6,TRUE))))*1.1494","v":19133.797438000001},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$455:$G$521,7,TRUE))))*1.1494","v":14573.460986}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G31*Tablas!$K4","v":2135.7920920000001},{"$f":"H31*Tablas!$K4","v":1872.016286},{"$f":"I31*Tablas!$K4","v":1565.5977400000002},{"$f":"J31*Tablas!$K4","v":1357.8666780000001},{"$f":"K31*Tablas!$K4","v":1034.391036}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G40:G42))","v":52039.981532000005},{"$f":"(SUM(H40:H42))","v":45615.548159999998},{"$f":"(SUM(I40:I42))","v":36843.936541999996},{"$f":"(SUM(J40:J42))","v":31949.768354},{"$f":"(SUM(K40:K42))","v":24335.602535999999}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G44)*0%","v":0},{"$f":"(H44)*0%","v":0},{"$f":"(I44)*0%","v":0},{"$f":"(J44)*0%","v":0},{"$f":"(K44)*0%","v":0}]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G43:G45)","v":52125.981532000005},{"$f":"SUM(H43:H45)","v":45701.548159999998},{"$f":"SUM(I43:I45)","v":36929.936541999996},{"$f":"SUM(J43:J45)","v":32035.768354},{"$f":"SUM(K43:K45)","v":24421.602535999999}]
[null,null,null,null,"Costo de segunda cuota",null,{"$f":"G43+G45","v":52039.981532000005},{"$f":"H43+H45","v":45615.548159999998},{"$f":"I43+I45","v":36843.936541999996},{"$f":"J43+J45","v":31949.768354},{"$f":"K43+K45","v":24335.602535999999}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G46+G47","v":104165.96306400001},{"$f":"H46+H47","v":91317.096319999997},73773.873083999992,{"$f":"J46+J47","v":63985.536708},48757.205071999997]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G37*Tablas!$K4*2","v":5976.0754200000001},{"$f":"H37*Tablas!$K4*2","v":5237.7468360000003},{"$f":"I37*Tablas!$K4*2","v":4381.2369440000002},{"$f":"J37*Tablas!$K4*2","v":3798.8589520000005},{"$f":"K37*Tablas!$K4*2","v":2894.8328640000004}]
[]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$18,Tablas!$A$680:$G$746,3,TRUE))*1.1494","v":9719.2976650000001},{"$f":"(VLOOKUP($I$18,Tablas!$A$680:$G$746,4,TRUE))*1.1494","v":8519.7550900000006},{"$f":"(VLOOKUP($I$18,Tablas!$A$680:$G$746,5,TRUE))*1.1494","v":6855.8836500000007},{"$f":"(VLOOKUP($I$18,Tablas!$A$680:$G$746,6,TRUE))*1.1494","v":5945.242765},{"$f":"(VLOOKUP($I$18,Tablas!$A$680:$G$746,7,TRUE))*1.1494","v":4528.5497949999999}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$680:$G$746,3,TRUE))))*1.1494","v":16174.385535000001},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$680:$G$746,4,TRUE))))*1.1494","v":14177.360505000001},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$680:$G$746,5,TRUE))))*1.1494","v":11448.914785000001},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$680:$G$746,6,TRUE))))*1.1494","v":9927.9137649999993},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$680:$G$746,7,TRUE))))*1.1494","v":7561.7014550000004}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G31*Tablas!$K3","v":1108.1940099999999},{"$f":"H31*Tablas!$K3","v":971.329205},{"$f":"I31*Tablas!$K3","v":812.33845000000008},{"$f":"J31*Tablas!$K3","v":704.55346500000007},{"$f":"K31*Tablas!$K3","v":536.71233000000007}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G52:G54))","v":27001.877209999999},{"$f":"(SUM(H52:H54))","v":23668.444800000005},{"$f":"(SUM(I52:I54))","v":19117.136885},{"$f":"(SUM(J52:J54))","v":16577.709995000001},{"$f":"(SUM(K52:K54))","v":12626.963580000001}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G56)*0%","v":0},{"$f":"(H56)*0%","v":0},{"$f":"(I56)*0%","v":0},{"$f":"(J56)*0%","v":0},{"$f":"(K56)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G55:G57)","v":27087.877209999999},{"$f":"SUM(H55:H57)","v":23754.444800000005},{"$f":"SUM(I55:I57)","v":19203.136885},{"$f":"SUM(J55:J57)","v":16663.709995000001},{"$f":"SUM(K55:K57)","v":12712.963580000001}]
[null,null,null,null,"Tres (3) cuotas adicionales, cada una de:",null,{"$f":"G55+G57","v":27001.877209999999},{"$f":"H55+H57","v":23668.444800000005},{"$f":"I55+I57","v":19117.136885},{"$f":"J55+J57","v":16577.709995000001},{"$f":"K55+K57","v":12626.963580000001}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G59+(G60*3)","v":108093.50883999999},{"$f":"H59+(H60*3)","v":94759.779200000019},76554.54754,{"$f":"J59+(J60*3)","v":66396.839980000004},50593.854320000006]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G37*Tablas!$K3*4","v":6201.5877},{"$f":"H37*Tablas!$K3*4","v":5435.3976600000005},{"$f":"I37*Tablas!$K3*4","v":4546.5666400000009},{"$f":"J37*Tablas!$K3*4","v":3942.2121200000006},{"$f":"K37*Tablas!$K3*4","v":3004.0718400000005}]
[]
[]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$18,Tablas!$A$80:$G$146,3,TRUE))*1.1494","v":3298.6707226666667},{"$f":"(VLOOKUP($I$18,Tablas!$A$80:$G$146,4,TRUE))*1.1494","v":2891.5532426666668},{"$f":"(VLOOKUP($I$18,Tablas!$A$80:$G$146,5,TRUE))*1.1494","v":2326.8453600000003},{"$f":"(VLOOKUP($I$18,Tablas!$A$80:$G$146,6,TRUE))*1.1494","v":2017.7793626666667},{"$f":"(VLOOKUP($I$18,Tablas!$A$80:$G$146,7,TRUE))*1.1494","v":1536.9623546666667}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$80:$G$146,3,TRUE))))*1.1494","v":5489.4884240000001},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$80:$G$146,4,TRUE))))*1.1494","v":4811.7102319999995},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$80:$G$146,5,TRUE))))*1.1494","v":3885.6922906666668},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$80:$G$146,6,TRUE))))*1.1494","v":3369.4737626666665},{"$f":"(IF($F$18=1,0,(VLOOKUP($I$20,Tablas!$A$80:$G$146,7,TRUE))))*1.1494","v":2566.3956453333335}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"G31*Tablas!$K2","v":376.11433066666666},{"$f":"H31*Tablas!$K2","v":329.66324533333335},{"$f":"I31*Tablas!$K2","v":275.70274666666671},{"$f":"J31*Tablas!$K2","v":239.12117600000002},{"$f":"K31*Tablas!$K2","v":182.15691200000001}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G66:G68))","v":9164.2734773333341},{"$f":"(SUM(H66:H68))","v":8032.9267199999995},{"$f":"(SUM(I66:I68))","v":6488.2403973333339},{"$f":"(SUM(J66:J68))","v":5626.3743013333324},{"$f":"(SUM(K66:K68))","v":4285.5149120000005}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G70)*0%","v":0},{"$f":"(H70)*0%","v":0},{"$f":"(I70)*0%","v":0},{"$f":"(J70)*0%","v":0},{"$f":"(K70)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G69:G71)","v":9250.2734773333341},{"$f":"SUM(H69:H71)","v":8118.9267199999995},{"$f":"SUM(I69:I71)","v":6574.2403973333339},{"$f":"SUM(J69:J71)","v":5712.3743013333324},{"$f":"SUM(K69:K71)","v":4371.5149120000005}]
[null,null,null,null,"Once (11) cuotas mensuales cada una de:",null,{"$f":"G69+G71","v":9164.2734773333341},{"$f":"H69+H71","v":8032.9267199999995},{"$f":"I69+I71","v":6488.2403973333339},{"$f":"J69+J71","v":5626.3743013333324},{"$f":"K69+K71","v":4285.5149120000005}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G73+(G74*11)","v":110057.28172800002},{"$f":"H73+(H74*11)","v":96481.120639999994},{"$f":"I73+(I74*11)","v":77944.884768000004},{"$f":"J73+(J74*11)","v":67602.491615999985},{"$f":"K73+(K74*11)","v":51512.178944000007}]
[null,null,null,null,"Ahorros en tarifas de prima para niños",null,{"$f":"G37*Tablas!$K2*12","v":6314.3438400000005},{"$f":"H37*Tablas!$K2*12","v":5534.2230719999998},{"$f":"I37*Tablas!$K2*12","v":4629.2314880000004},{"$f":"J37*Tablas!$K2*12","v":4013.8887040000009},{"$f":"K37*Tablas!$K2*12","v":3058.6913280000003}]
[]
[]
[null,null,null,null,"Tarifas en US$ -  Efectivas a partir del 1ro. de Enero de 2022"]
[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":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[[57,0,57,1],[72,4,72,9],[11,0,11,1],[20,0,20,1],[35,0,35,1],[40,0,40,1],[41,1,42,1],[41,0,42,0],[50,4,50,5],[51,4,51,5],[63,4,63,5],[64,4,64,5],[25,4,25,9],[35,4,35,9],[46,4,46,9],[59,4,59,9],[11,3,11,4],[15,3,15,4],[17,3,17,4],[11,5,11,8],[13,5,13,8],[73,4,74,9],[61,0,61,1],[72,0,72,1],[76,0,76,1],[86,0,86,1]]}
[]
[]
[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$15","v":"JOHN DOE"}]
[]
[null,null,null,null,"Cotizado por:",{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE AGENTE"}]
[]
[null,null,null,"Número de adultos en la póliza:",null,{"$f":"+'INGRESO DE DATOS'!$D$17","v":2},null,"Edad del Asegurado Titular:",{"$f":"+'INGRESO DE DATOS'!$D$19","v":65}]
[]
[null,null,null,"Número de niños en la póliza:",null,{"$f":"+'INGRESO DE DATOS'!$H$17","v":3},null,"Edad del/la conyuge:",{"$f":"+'INGRESO DE DATOS'!$H$19","v":71}]
[null,null,null,null,null,null,null," "," "]
[null,null,null,null,"Fecha de la cotización:",{"$f":"NOW()","v":"2022-01-26T13:22:05.120"}]
[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$16,Tablas!$A$155:$G$221,3,TRUE))*1.1494","v":23229.374},{"$f":"(VLOOKUP($I$16,Tablas!$A$155:$G$221,4,TRUE))*1.1494","v":21081.145400000001},{"$f":"(VLOOKUP($I$16,Tablas!$A$155:$G$221,5,TRUE))*1.1494","v":15007.7158},{"$f":"(VLOOKUP($I$16,Tablas!$A$155:$G$221,6,TRUE))*1.1494","v":10965.276}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$155:$G$221,3,TRUE))))*1.1494","v":38657.770199999999},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$155:$G$221,4,TRUE))))*1.1494","v":35080.837399999997},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$155:$G$221,5,TRUE))))*1.1494","v":25127.0334},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$155:$G$221,6,TRUE))))*1.1494","v":18357.0674}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$222:$G$224,3,TRUE))))*1.1494","v":6352.7338},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$222:$G$224,4,TRUE))))*1.1494","v":5765.3904000000002},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$222:$G$224,5,TRUE))))*1.1494","v":4389.5586000000003},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$222:$G$224,6,TRUE))))*1.1494","v":3206.826}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G27:G29))","v":68239.877999999997},{"$f":"(SUM(H27:H29))","v":61927.373200000002},{"$f":"(SUM(I27:I29))","v":44524.307799999995},{"$f":"(SUM(J27:J29))","v":32529.169399999999}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null," IVA (14.49%) ",null,{"$f":"(G31)*0%","v":0},{"$f":"(H31)*0%","v":0},{"$f":"(I31)*0%","v":0},{"$f":"(J31)*0%","v":0}]
[]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"SUM(G30:G32)","v":68325.877999999997},{"$f":"SUM(H30:H32)","v":62013.373200000002},{"$f":"SUM(I30:I32)","v":44610.307799999995},{"$f":"SUM(J30:J32)","v":32615.169399999999}]
[]
[null,null,null,null,"Tarifas Semianuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$16,Tablas!$A$530:$G$596,3,TRUE))*1.1494","v":12311.568220000001},{"$f":"(VLOOKUP($I$16,Tablas!$A$530:$G$596,4,TRUE))*1.1494","v":11173.007062000001},{"$f":"(VLOOKUP($I$16,Tablas!$A$530:$G$596,5,TRUE))*1.1494","v":7954.0893740000001},{"$f":"(VLOOKUP($I$16,Tablas!$A$530:$G$596,6,TRUE))*1.1494","v":5811.5962799999998}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$530:$G$596,3,TRUE))))*1.1494","v":20488.618206000003},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$530:$G$596,4,TRUE))))*1.1494","v":18592.843822000003},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$530:$G$596,5,TRUE))))*1.1494","v":13317.327702},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$530:$G$596,6,TRUE))))*1.1494","v":9729.2457220000015}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$597:$G$599,3,TRUE))))*1.1494","v":3366.9489140000001},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$597:$G$599,4,TRUE))))*1.1494","v":3055.6569119999999},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$597:$G$599,5,TRUE))))*1.1494","v":2326.466058},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$597:$G$599,6,TRUE))))*1.1494","v":1699.61778}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G37:G39))","v":36167.135340000001},{"$f":"(SUM(H37:H39))","v":32821.507796000005},{"$f":"(SUM(I37:I39))","v":23597.883134000003},{"$f":"(SUM(J37:J39))","v":17240.459782000002}]
[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 de primera cuota",null,{"$f":"SUM(G40:G42)","v":36253.135340000001},{"$f":"SUM(H40:H42)","v":32907.507796000005},{"$f":"SUM(I40:I42)","v":23683.883134000003},{"$f":"SUM(J40:J42)","v":17326.459782000002}]
[null,null,null,null,"Costo de segunda cuota",null,{"$f":"G40+G42","v":36167.135340000001},{"$f":"H40+H42","v":32821.507796000005},{"$f":"I40+I42","v":23597.883134000003},{"$f":"J40+J42","v":17240.459782000002}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G43+G44","v":72420.270680000001},{"$f":"H43+H44","v":65729.015592000011},47281.766268000007,{"$f":"J43+J44","v":34566.919564000003}]
[]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$16,Tablas!$A$755:$G$821,3,TRUE))*1.1494","v":6388.0778499999997},{"$f":"(VLOOKUP($I$16,Tablas!$A$755:$G$821,4,TRUE))*1.1494","v":5797.3149850000009},{"$f":"(VLOOKUP($I$16,Tablas!$A$755:$G$821,5,TRUE))*1.1494","v":4127.1218450000006},{"$f":"(VLOOKUP($I$16,Tablas!$A$755:$G$821,6,TRUE))*1.1494","v":3015.4508999999998}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$755:$G$821,3,TRUE))))*1.1494","v":10630.886805},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$755:$G$821,4,TRUE))))*1.1494","v":9647.2302850000015},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$755:$G$821,5,TRUE))))*1.1494","v":6909.9341850000001},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$755:$G$821,6,TRUE))))*1.1494","v":5048.1935350000003}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$822:$G$824,3,TRUE))))*1.1494","v":1747.0017950000001},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$822:$G$824,4,TRUE))))*1.1494","v":1585.48236},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$822:$G$824,5,TRUE))))*1.1494","v":1207.1286150000001},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$822:$G$824,6,TRUE))))*1.1494","v":881.87715000000014}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G48:G50))","v":18765.96645},{"$f":"(SUM(H48:H50))","v":17030.027630000004},{"$f":"(SUM(I48:I50))","v":12244.184644999999},{"$f":"(SUM(J48:J50))","v":8945.5215850000004}]
[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},{"$f":"(J52)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G51:G53)","v":18851.96645},{"$f":"SUM(H51:H53)","v":17116.027630000004},{"$f":"SUM(I51:I53)","v":12330.184644999999},{"$f":"SUM(J51:J53)","v":9031.5215850000004}]
[null,null,null,null,"Tres (3) cuotas adicionales, cada una de:",null,{"$f":"G51+G53","v":18765.96645},{"$f":"H51+H53","v":17030.027630000004},{"$f":"I51+I53","v":12244.184644999999},{"$f":"J51+J53","v":8945.5215850000004}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G55+(G56*3)","v":75149.8658},{"$f":"H55+(H56*3)","v":68206.110520000017},49062.738579999997,{"$f":"J55+(J56*3)","v":35868.086340000002}]
[]
[]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$16,Tablas!$A$229:$G$295,3,TRUE))*1.1494","v":2168.0749066666667},{"$f":"(VLOOKUP($I$16,Tablas!$A$229:$G$295,4,TRUE))*1.1494","v":1967.5735706666669},{"$f":"(VLOOKUP($I$16,Tablas!$A$229:$G$295,5,TRUE))*1.1494","v":1400.7201413333335},{"$f":"(VLOOKUP($I$16,Tablas!$A$229:$G$295,6,TRUE))*1.1494","v":1023.4257600000001}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$229:$G$295,3,TRUE))))*1.1494","v":3608.058552},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A229:$G$295,4,TRUE))))*1.1494","v":3274.211490666667},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$229:$G$295,5,TRUE))))*1.1494","v":2345.1897840000001},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$229:$G$295,6,TRUE))))*1.1494","v":1713.3262906666669}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$296:$G$298,3,TRUE))))*1.1494","v":592.92182133333336},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$296:$G$298,4,TRUE))))*1.1494","v":538.10310400000003},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$296:$G$298,5,TRUE))))*1.1494","v":409.692136},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$296:$G$298,6,TRUE))))*1.1494","v":299.30376000000001}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"SUM(G61:G63)","v":6369.0552800000005},{"$f":"SUM(H61:H63)","v":5779.8881653333337},{"$f":"SUM(I61:I63)","v":4155.602061333333},{"$f":"SUM(J61:J63)","v":3036.0558106666667}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null," IVA (14.49%) ",null,{"$f":"(G65)*0%","v":0},{"$f":"(H65)*0%","v":0},{"$f":"(I65)*0%","v":0},{"$f":"(J65)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G64:G66)","v":6455.0552800000005},{"$f":"SUM(H64:H66)","v":5865.8881653333337},{"$f":"SUM(I64:I66)","v":4241.602061333333},{"$f":"SUM(J64:J66)","v":3122.0558106666667}]
[null,null,null,null,"Once (11) cuotas mensuales cada una de:",null,{"$f":"G64+G66","v":6369.0552800000005},{"$f":"H64+H66","v":5779.8881653333337},{"$f":"I64+I66","v":4155.602061333333},{"$f":"J64+J66","v":3036.0558106666667}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G68+(G69*11)","v":76514.663360000006},{"$f":"H68+(H69*11)","v":69444.657984000005},{"$f":"I68+(I69*11)","v":49953.224735999996},{"$f":"J68+(J69*11)","v":36518.669728000001}]
[]
[]
[null,null,null,null,"Tarifas en US$ -  Efectivas a partir del 1ro. de Enero de 2022"]
[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":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[[11,3,11,4],[15,3,15,4],[11,5,11,8],[13,5,13,8],[11,0,11,1],[40,1,41,1],[40,0,41,0],[50,4,50,5],[51,4,51,5],[20,0,20,1],[34,0,34,1],[39,0,39,1],[56,0,56,1],[60,0,60,1],[71,0,71,1],[75,0,75,1],[85,0,85,1],[72,4,73,9],[25,4,25,9],[35,4,35,9],[46,4,46,9],[59,4,59,9],[71,4,71,9],[63,4,63,5],[64,4,64,5]]}
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[]
["Global Select Health Plan",null,null,"Nombre del Asegurado Titular:",null,{"$f":"+'INGRESO DE DATOS'!$D$15","v":"JOHN DOE"}]
[]
[null,null,null,null,"Cotizado por:",{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE AGENTE"}]
[]
[null,null,null,"Número de adultos en la póliza:",null,{"$f":"+'INGRESO DE DATOS'!$D$17","v":2},null,"Edad del Asegurado Titular:",{"$f":"+'INGRESO DE DATOS'!$D$19","v":65}]
[]
[null,null,null,null,"Número de niños en la póliza:",{"$f":"+'INGRESO DE DATOS'!$H$17","v":3},null,"Edad del/la conyuge:",{"$f":"+'INGRESO DE DATOS'!$H$19","v":71}]
[null,null,null,null,null,null,null," "," "]
[null,null,null,null,"Fecha de la cotización:",{"$f":"NOW()","v":"2022-01-26T13:22:05.120"}]
[]
[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$16,Tablas!$A$305:$G$371,3,TRUE))*1.1494","v":16504.2346},{"$f":"(VLOOKUP($I$16,Tablas!$A$305:$G$371,4,TRUE))*1.1494","v":15836.433199999999},{"$f":"(VLOOKUP($I$16,Tablas!$A$305:$G$371,5,TRUE))*1.1494","v":11297.452600000001},{"$f":"(VLOOKUP($I$16,Tablas!$A$305:$G$371,6,TRUE))*1.1494","v":8250.3932000000004}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$305:$G$371,3,TRUE))))*1.1494","v":27955.7068},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$305:$G$371,4,TRUE))))*1.1494","v":26822.398399999998},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$305:$G$371,5,TRUE))))*1.1494","v":19253.599399999999},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$305:$G$371,6,TRUE))))*1.1494","v":14058.311400000001}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$372:$G$374,3,TRUE))))*1.1494","v":4443.5803999999998},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$372:$G$374,4,TRUE))))*1.1494","v":4261.9751999999999},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$372:$G$374,5,TRUE))))*1.1494","v":3264.2959999999998},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$372:$G$374,6,TRUE))))*1.1494","v":2383.8555999999999}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G27:G29))","v":48903.521799999995},{"$f":"(SUM(H27:H29))","v":46920.806799999998},{"$f":"(SUM(I27:I29))","v":33815.347999999998},{"$f":"(SUM(J27:J29))","v":24692.5602}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null,"  IVA (14.49%)  ",null,{"$f":"(G31)*0%","v":0},{"$f":"(H31)*0%","v":0},{"$f":"(I31)*0%","v":0},{"$f":"(J31)*0%","v":0}]
[]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"SUM(G30:G32)","v":48989.521799999995},{"$f":"SUM(H30:H32)","v":47006.806799999998},{"$f":"SUM(I30:I32)","v":33901.347999999998},{"$f":"SUM(J30:J32)","v":24778.5602}]
[]
[null,null,null,null,"Tarifas Semianuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$16,Tablas!$A$605:$G$671,3,TRUE))*1.1494","v":8747.2443380000004},{"$f":"(VLOOKUP($I$16,Tablas!$A$605:$G$671,4,TRUE))*1.1494","v":8393.3095959999991},{"$f":"(VLOOKUP($I$16,Tablas!$A$605:$G$671,5,TRUE))*1.1494","v":5987.6498780000002},{"$f":"(VLOOKUP($I$16,Tablas!$A$605:$G$671,6,TRUE))*1.1494","v":4372.708396}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$605:$G$671,3,TRUE))))*1.1494","v":14816.524604},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$605:$G$671,4,TRUE))))*1.1494","v":14215.871152},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$605:$G$671,5,TRUE))))*1.1494","v":10204.407682000001},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$605:$G$671,6,TRUE))))*1.1494","v":7450.9050420000003}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$672:$G$674,3,TRUE))))*1.1494","v":2355.097612},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$672:$G$674,4,TRUE))))*1.1494","v":2258.8468560000001},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$672:$G$674,5,TRUE))))*1.1494","v":1730.0768800000001},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$672:$G$674,6,TRUE))))*1.1494","v":1263.4434679999999}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G37:G39))","v":25918.866554000004},{"$f":"(SUM(H37:H39))","v":24868.027603999999},{"$f":"(SUM(I37:I39))","v":17922.134440000002},{"$f":"(SUM(J37:J39))","v":13087.056906}]
[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}]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G40:G42)","v":26004.866554000004},{"$f":"SUM(H40:H42)","v":24954.027603999999},{"$f":"SUM(I40:I42)","v":18008.134440000002},{"$f":"SUM(J40:J42)","v":13173.056906}]
[null,null,null,null,"Costo de segunda cuota",null,{"$f":"G40+G42","v":25918.866554000004},{"$f":"H40+H42","v":24868.027603999999},{"$f":"I40+I42","v":17922.134440000002},{"$f":"J40+J42","v":13087.056906}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G43+G44","v":51923.733108000008},{"$f":"H43+H44","v":49822.055207999998},35930.268880000003,26260.113812]
[]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$16,Tablas!$A$830:$G$896,3,TRUE))*1.1494","v":4538.6645150000004},{"$f":"(VLOOKUP($I$16,Tablas!$A$830:$G$896,4,TRUE))*1.1494","v":4355.0191300000006},{"$f":"(VLOOKUP($I$16,Tablas!$A$830:$G$896,5,TRUE))*1.1494","v":3106.7994650000005},{"$f":"(VLOOKUP($I$16,Tablas!$A$830:$G$896,6,TRUE))*1.1494","v":2268.8581300000001}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$830:$G$896,3,TRUE))))*1.1494","v":7687.8193700000002},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$830:$G$896,4,TRUE))))*1.1494","v":7376.1595600000001},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$830:$G$896,5,TRUE))))*1.1494","v":5294.7398350000003},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$830:$G$896,6,TRUE))))*1.1494","v":3866.0356350000002}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$897:$G$899,3,TRUE))))*1.1494","v":1221.98461},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$897:$G$899,4,TRUE))))*1.1494","v":1172.0431800000001},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$897:$G$899,5,TRUE))))*1.1494","v":897.68140000000017},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$897:$G$899,6,TRUE))))*1.1494","v":655.56029000000001}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G48:G50))","v":13448.468495000001},{"$f":"(SUM(H48:H50))","v":12903.221870000001},{"$f":"(SUM(I48:I50))","v":9299.2206999999999},{"$f":"(SUM(J48:J50))","v":6790.4540550000011}]
[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},{"$f":"(J52)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G51:G53)","v":13534.468495000001},{"$f":"SUM(H51:H53)","v":12989.221870000001},{"$f":"SUM(I51:I53)","v":9385.2206999999999},{"$f":"SUM(J51:J53)","v":6876.4540550000011}]
[null,null,null,null,"Tres (3) cuotas adicionales, cada una de:",null,{"$f":"G51+G53","v":13448.468495000001},{"$f":"H51+H53","v":12903.221870000001},{"$f":"I51+I53","v":9299.2206999999999},{"$f":"J51+J53","v":6790.4540550000011}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G55+(G56*3)","v":53879.873980000004},{"$f":"H55+(H56*3)","v":51698.887480000005},37282.882799999999,{"$f":"J55+(J56*3)","v":27247.816220000004}]
[]
[]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$16,Tablas!$A$379:$G$445,3,TRUE))*1.1494","v":1540.3952293333334},{"$f":"(VLOOKUP($I$16,Tablas!$A$379:$G$445,4,TRUE))*1.1494","v":1478.0670986666667},{"$f":"(VLOOKUP($I$16,Tablas!$A$379:$G$445,5,TRUE))*1.1494","v":1054.4289093333334},{"$f":"(VLOOKUP($I$16,Tablas!$A$379:$G$445,6,TRUE))*1.1494","v":770.03669866666667}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$379:$G$445,3,TRUE))))*1.1494","v":2609.1993013333331},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$379:$G$445,4,TRUE))))*1.1494","v":2503.4238506666666},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$379:$G$445,5,TRUE))))*1.1494","v":1797.0026106666667},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$379:$G$445,6,TRUE))))*1.1494","v":1312.109064}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$446:$G$448,3,TRUE))))*1.1494","v":414.73417066666673},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$446:$G$448,4,TRUE))))*1.1494","v":397.78435200000001},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$446:$G$448,5,TRUE))))*1.1494","v":304.66762666666665},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$446:$G$448,6,TRUE))))*1.1494","v":222.49318933333336}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G61:G63))","v":4564.3287013333329},{"$f":"(SUM(H61:H63))","v":4379.2753013333331},{"$f":"(SUM(I61:I63))","v":3156.0991466666669},{"$f":"(SUM(J61:J63))","v":2304.6389519999998}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86,86,86]
[null,null,null,null,"  IVA (14.49%)  ",null,{"$f":"(G65)*0%","v":0},{"$f":"(H65)*0%","v":0},{"$f":"(I65)*0%","v":0},{"$f":"(J65)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G64:G66)","v":4650.3287013333329},{"$f":"SUM(H64:H66)","v":4465.2753013333331},{"$f":"SUM(I64:I66)","v":3242.0991466666669},{"$f":"SUM(J64:J66)","v":2390.6389519999998}]
[null,null,null,null,"Once (11) cuotas mensuales cada una de:",null,{"$f":"G64+G66","v":4564.3287013333329},{"$f":"H64+H66","v":4379.2753013333331},{"$f":"I64+I66","v":3156.0991466666669},{"$f":"J64+J66","v":2304.6389519999998}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G68+(G69*11)","v":54857.944415999991},{"$f":"H68+(H69*11)","v":52637.303615999997},{"$f":"I68+(I69*11)","v":37959.189760000001},{"$f":"J68+(J69*11)","v":27741.667423999999}]
[]
[null,null,null,null,"Tarifas en US$ -  Efectivas a partir del 1ro. de Enero de 2022"]
[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":128,"n_cols":22,"rows_kept":128,"cut":false,"hidden":false,"merged":[[46,4,46,7],[17,3,17,4],[11,0,11,1],[71,4,73,7],[70,4,70,7],[50,4,50,5],[51,4,51,5],[62,4,62,5],[63,4,63,5],[58,4,58,7],[11,3,11,4],[11,5,11,8],[15,3,15,4],[35,4,35,7],[25,4,25,7],[13,5,13,8],[20,0,20,1],[35,0,35,1],[86,0,86,1],[40,0,40,1],[57,0,57,1],[61,0,61,1],[72,0,72,1],[76,0,76,1],[41,0,42,0],[41,1,42,1]]}
[]
[]
[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$15","v":"JOHN DOE"}]
[]
[null,null,null,null,"Cotizado Por:",{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE AGENTE"}]
[]
[null,null,null,"Número de adultos en la póliza:",null,{"$f":"+'INGRESO DE DATOS'!$D$17","v":2},null,"Edad del Asegurado Titular:",{"$f":"+'INGRESO DE DATOS'!$D$19","v":65}]
[]
[null,null,null,"Número de niños en la póliza:",null,{"$f":"+'INGRESO DE DATOS'!$H$17","v":3},null,"Edad del/la conyuge:",{"$f":"+'INGRESO DE DATOS'!$H$19","v":71}]
[null,null,null,null,null,null,null," "," "]
[null,null,null,null,"Fecha de la cotización:",{"$f":"NOW()","v":"2022-01-26T13:22:05.120"}]
[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$16,Tablas!$A$1129:$G$1195,3,TRUE))*1.1494","v":9581.3984},{"$f":"(VLOOKUP($I$16,Tablas!$A$1129:$G$1195,4,TRUE))*1.1494","v":7537.7651999999998}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$1129:$G$1195,3,TRUE))))*1.1494","v":15900.7996},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$1129:$G$1195,4,TRUE))))*1.1494","v":12829.602800000001}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$1196:$G$1198,3,TRUE))))*1.1494","v":2607.9886000000001},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$1196:$G$1198,4,TRUE))))*1.1494","v":2045.932}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G27:G29))","v":28090.186600000001},{"$f":"(SUM(H27:H29))","v":22413.300000000003}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G31)*0%","v":0},{"$f":"(H31)*0%","v":0}]
[]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"SUM(G30:G32)","v":28176.186600000001},{"$f":"SUM(H30:H32)","v":22499.300000000003}]
[]
[null,null,null,null,"Tarifas Semianuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$16,Tablas!$A$1353:$G$1419,3,TRUE))*1.1494","v":5078.1411520000001},{"$f":"(VLOOKUP($I$16,Tablas!$A$1353:$G$1419,4,TRUE))*1.1494","v":3995.0155560000003}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$1353:$G$1419,3,TRUE))))*1.1494","v":8427.4237880000001},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$1353:$G$1419,4,TRUE))))*1.1494","v":6799.6894840000004}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$1420:$G$1422,3,TRUE))))*1.1494","v":1382.2339580000003},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$1420:$G$1422,4,TRUE))))*1.1494","v":1084.3439600000002}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G37:G39))","v":14887.798898000001},{"$f":"(SUM(H37:H39))","v":11879.049000000001}]
[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 de primera cuota",null,{"$f":"SUM(G40:G42)","v":14973.798898000001},{"$f":"SUM(H40:H42)","v":11965.049000000001}]
[null,null,null,null,"Costo de segunda cuota",null,{"$f":"G40+G42","v":14887.798898000001},{"$f":"H40+H42","v":11879.049000000001}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G43+G44","v":29861.597796000002},{"$f":"H43+H44","v":23844.098000000002}]
[]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$16,Tablas!$A$1278:$G$1344,3,TRUE))*1.1494","v":2634.88456},{"$f":"(VLOOKUP($I$16,Tablas!$A$1278:$G$1344,4,TRUE))*1.1494","v":2072.8854299999998}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$1278:$G$1344,3,TRUE))))*1.1494","v":4372.7198900000003},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$1278:$G$1344,4,TRUE))))*1.1494","v":3528.14077}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$1345:$G$1347,3,TRUE))))*1.1494","v":717.196865},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$1345:$G$1347,4,TRUE))))*1.1494","v":562.63130000000001}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G48:G50))","v":7724.8013150000006},{"$f":"(SUM(H48:H50))","v":6163.6575000000003}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G52)*0%","v":0},{"$f":"(H52)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G51:G53)","v":7810.8013150000006},{"$f":"SUM(H51:H53)","v":6249.6575000000003}]
[null,null,null,null,"Tres (3) cuotas adicionales, cada una de:",null,{"$f":"G51+G53","v":7724.8013150000006},{"$f":"H51+H53","v":6163.6575000000003}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G55+(G56*3)","v":30985.205260000002},{"$f":"H55+(H56*3)","v":24740.63}]
[]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,"Prima para Asegurado Titular",null,{"$f":"(VLOOKUP($I$16,Tablas!$A$1203:$G$1269,3,TRUE))*1.1494","v":894.26385066666671},{"$f":"(VLOOKUP($I$16,Tablas!$A$1203:$G$1269,4,TRUE))*1.1494","v":703.52475200000003}]
[null,null,null,null,"Prima para conyuge",null,{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$1203:$G$1269,3,TRUE))))*1.1494","v":1484.0746293333334},{"$f":"(IF($F$16=1,0,(VLOOKUP($I$18,Tablas!$A$1203:$G$1269,4,TRUE))))*1.1494","v":1197.4295946666666}]
[null,null,null,null,"Prima para hijo (s)",null,{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$1270:$G$1272,3,TRUE))))*1.1494","v":243.41226933333334},{"$f":"(IF($F$18=0,0,(VLOOKUP($F$18,Tablas!$A$1270:$G$1272,4,TRUE))))*1.1494","v":190.95365333333336}]
[null,null,null,null,"Total de Prima neta",null,{"$f":"(SUM(G60:G62))","v":2621.7507493333337},{"$f":"(SUM(H60:H62))","v":2091.9079999999999}]
[null,null,null,null,"Costo Administrativo Anual",null,86,86]
[null,null,null,null,"IVA (14.49%)",null,{"$f":"(G64)*0%","v":0},{"$f":"(H64)*0%","v":0}]
[]
[null,null,null,null,"TOTAL de primera cuota",null,{"$f":"SUM(G63:G65)","v":2707.7507493333337},{"$f":"SUM(H63:H65)","v":2177.9079999999999}]
[null,null,null,null,"Once (11) cuotas mensuales cada una de:",null,{"$f":"G63+G65","v":2621.7507493333337},{"$f":"H63+H65","v":2091.9079999999999}]
[null,null,null,null,"TOTAL ANUAL",null,{"$f":"G67+(G68*11)","v":31547.008992000003},{"$f":"H67+(H68*11)","v":25188.895999999997}]
[]
[null,null,null,null,"Tarifas en US$ -  Efectivas a partir del 1ro. de Enero de 2022"]
[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":[[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],[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],[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],[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],[64,4,64,7],[66,4,66,7],[68,4,68,7],[50,3,50,7],[52,3,52,7],[54,3,54,7],[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]]}
[]
[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$15","v":"JOHN DOE"}]
[null,"Cotizado por",{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE AGENTE"}]
[]
["Número de adultos en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$D$17","v":2},null,"Edad del Asegurado Titular",null,{"$f":"+'INGRESO DE DATOS'!$D$19","v":65}]
[]
[]
["Número de niños en la póliza",null,{"$f":"+'INGRESO DE DATOS'!$H$17","v":3},null,"Edad del/la cónyuge ",null,{"$f":"+'INGRESO DE DATOS'!$H$19","v":71}]
[]
[]
[null,null,"Fecha de la Cotización:",{"$f":"NOW()","v":"2022-01-26T13:22:05.120"}]
[]
["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'!G36","v":226537.33980000002},{"$f":"'Global Ultimate Health  Plan'!H36","v":146189.68220000001}]
[null,null,"Tarifas Semi-anuales"]
[null,null,{"$f":"'Global Ultimate Health  Plan'!G47","v":120019.21009399999},{"$f":"'Global Ultimate Health  Plan'!H47","v":77434.951566000003}]
[null,null,"Tarifas Trimestrales"]
[null,null,{"$f":"'Global Ultimate Health  Plan'!G60","v":62274.118445000007},{"$f":"'Global Ultimate Health  Plan'!H60","v":40178.512604999996}]
[null,null,"Tarifas Mensuales"]
[null,null,{"$f":"'Global Ultimate Health  Plan'!G75","v":21135.458381333337},{"$f":"'Global Ultimate Health  Plan'!H75","v":13636.343672000001}]
["Ahorros en tarifas de prima para niños*",null,{"$f":"'Global Ultimate Health  Plan'!G37","v":13013.506799999999},{"$f":"'Global Ultimate Health  Plan'!H37","v":8398.6658000000007}]
[]
["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'!G36","v":98274.644400000005},{"$f":"+'Global Elite Health  Plan'!H36","v":86153.071999999986},{"$f":"+'Global Elite Health  Plan'!I36","v":69602.861399999994},{"$f":"+'Global Elite Health  Plan'!J36","v":60368.5818},{"$f":"+'Global Elite Health  Plan'!K36","v":46002.231200000002}]
[null,null,null,"Tarifas Semi-anuales"]
[null,null,null,{"$f":"+'Global Elite Health  Plan'!G47","v":52039.981532000005},{"$f":"+'Global Elite Health  Plan'!H47","v":45615.548159999998},{"$f":"+'Global Elite Health  Plan'!I47","v":36843.936541999996},{"$f":"+'Global Elite Health  Plan'!J47","v":31949.768354},{"$f":"+'Global Elite Health  Plan'!K47","v":24335.602535999999}]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,{"$f":"+'Global Elite Health  Plan'!G60","v":27001.877209999999},{"$f":"+'Global Elite Health  Plan'!H60","v":23668.444800000005},{"$f":"+'Global Elite Health  Plan'!I60","v":19117.136885},{"$f":"+'Global Elite Health  Plan'!J60","v":16577.709995000001},{"$f":"+'Global Elite Health  Plan'!K60","v":12626.963580000001}]
[null,null,null,"Tarifas Mensuales"]
[null,null,null,{"$f":"+'Global Elite Health  Plan'!G74","v":9164.2734773333341},{"$f":"+'Global Elite Health  Plan'!H74","v":8032.9267199999995},{"$f":"+'Global Elite Health  Plan'!I74","v":6488.2403973333339},{"$f":"+'Global Elite Health  Plan'!J74","v":5626.3743013333324},{"$f":"+'Global Elite Health  Plan'!K74","v":4285.5149120000005}]
["Ahorros en tarifas de prima para niños*",null,null,{"$f":"+'Global Elite Health  Plan'!G37","v":5637.8069999999998},{"$f":"+'Global Elite Health  Plan'!H37","v":4941.2705999999998},{"$f":"+'Global Elite Health  Plan'!I37","v":4133.2424000000001},{"$f":"+'Global Elite Health  Plan'!J37","v":3583.8292000000001},{"$f":"+'Global Elite Health  Plan'!K37","v":2730.9744000000001}]
[]
["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'!G34","v":68325.877999999997},{"$f":"+'Global Premier Health  Plan'!H34","v":62013.373200000002},{"$f":"+'Global Premier Health  Plan'!I34","v":44610.307799999995},{"$f":"+'Global Premier Health  Plan'!J34","v":32615.169399999999}]
[null,null,null,null,"Tarifas Semi-anuales"]
[null,null,null,null,{"$f":"+'Global Premier Health  Plan'!G44","v":36167.135340000001},{"$f":"+'Global Premier Health  Plan'!H44","v":32821.507796000005},{"$f":"+'Global Premier Health  Plan'!I44","v":23597.883134000003},{"$f":"+'Global Premier Health  Plan'!J44","v":17240.459782000002}]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,{"$f":"+'Global Premier Health  Plan'!G56","v":18765.96645},{"$f":"+'Global Premier Health  Plan'!H56","v":17030.027630000004},{"$f":"+'Global Premier Health  Plan'!I56","v":12244.184644999999},{"$f":"+'Global Premier Health  Plan'!J56","v":8945.5215850000004}]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,{"$f":"+'Global Premier Health  Plan'!G69","v":6369.0552800000005},{"$f":"+'Global Premier Health  Plan'!H69","v":5779.8881653333337},{"$f":"+'Global Premier Health  Plan'!I69","v":4155.602061333333},{"$f":"+'Global Premier Health  Plan'!J69","v":3036.0558106666667}]
[]
["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'!G34","v":48989.521799999995},{"$f":"+'Global Select Health Plan'!H34","v":47006.806799999998},{"$f":"+'Global Select Health Plan'!I34","v":33901.347999999998},{"$f":"+'Global Select Health Plan'!J34","v":24778.5602}]
[null,null,null,null,"Tarifas Semi-anuales"]
[null,null,null,null,{"$f":"+'Global Select Health Plan'!G44","v":25918.866554000004},{"$f":"+'Global Select Health Plan'!H44","v":24868.027603999999},{"$f":"+'Global Select Health Plan'!I44","v":17922.134440000002},{"$f":"+'Global Select Health Plan'!J44","v":13087.056906}]
[null,null,null,null,"Tarifas Trimestrales"]
[null,null,null,null,{"$f":"+'Global Select Health Plan'!G56","v":13448.468495000001},{"$f":"+'Global Select Health Plan'!H56","v":12903.221870000001},{"$f":"+'Global Select Health Plan'!I56","v":9299.2206999999999},{"$f":"+'Global Select Health Plan'!J56","v":6790.4540550000011}]
[null,null,null,null,"Tarifas Mensuales"]
[null,null,null,null,{"$f":"+'Global Select Health Plan'!G69","v":4564.3287013333329},{"$f":"+'Global Select Health Plan'!H69","v":4379.2753013333331},{"$f":"+'Global Select Health Plan'!I69","v":3156.0991466666669},{"$f":"+'Global Select Health Plan'!J69","v":2304.6389519999998}]
[]
["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'!G34","v":28176.186600000001},{"$f":"'Global Major Medical Health  Pl'!H34","v":22499.300000000003}]
[null,null,"Tarifas Semi-anuales"]
[null,null,{"$f":"'Global Major Medical Health  Pl'!G44","v":14887.798898000001},{"$f":"'Global Major Medical Health  Pl'!H44","v":11879.049000000001}]
[null,null,"Tarifas Trimestrales"]
[null,null,{"$f":"'Global Major Medical Health  Pl'!G56","v":7724.8013150000006},{"$f":"'Global Major Medical Health  Pl'!H56","v":6163.6575000000003}]
[null,null,"Tarifas Mensuales"]
[null,null,{"$f":"'Global Major Medical Health  Pl'!G68","v":2621.7507493333337},{"$f":"'Global Major Medical Health  Pl'!H68","v":2091.9079999999999}]
[]
["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 2022"]
["Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Tablas","index":7,"n_rows":1497,"n_cols":13,"rows_kept":1497,"cut":false,"hidden":true,"merged":[[752,0,752,1],[752,2,752,6],[825,0,825,6],[826,0,826,6],[827,0,827,1],[827,2,827,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],[527,0,527,1],[527,2,527,6],[600,0,600,6],[601,0,601,6],[602,0,602,1],[602,2,602,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],[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],[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],[900,0,900,6],[901,0,901,6],[902,0,902,1],[902,2,902,6],[975,0,975,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],[1124,0,1124,6],[1125,0,1125,6],[1126,0,1126,1],[1126,2,1126,6],[1199,0,1199,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],[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]]}
[]
["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,8294,7268,6037,5238,3989,null,true,true,true,true,true]
[19,null,8294,7268,6037,5238,3989]
[20,null,8294,7268,6037,5238,3989]
[21,null,8294,7268,6037,5238,3989]
[22,null,8294,7268,6037,5238,3989]
[23,null,8294,7268,6037,5238,3989]
[24,null,8294,7268,6037,5238,3989]
[25,null,8861,7766,6412,5560,4237,null,true,true,true,true,true]
[26,null,8861,7766,6412,5560,4237]
[27,null,8861,7766,6412,5560,4237]
[28,null,8861,7766,6412,5560,4237]
[29,null,8861,7766,6412,5560,4237]
[30,null,9854,8637,7078,6136,4674,null,true,true,true,true,true]
[31,null,9854,8637,7078,6136,4674]
[32,null,9854,8637,7078,6136,4674]
[33,null,9854,8637,7078,6136,4674]
[34,null,9854,8637,7078,6136,4674]
[35,null,11000,9639,7854,6811,5188,null,true,true,true,true,true]
[36,null,11000,9639,7854,6811,5188]
[37,null,11000,9639,7854,6811,5188]
[38,null,11000,9639,7854,6811,5188]
[39,null,11000,9639,7854,6811,5188]
[40,null,12320,10797,8758,7594,5786,null,true,true,true,true,true]
[41,null,12320,10797,8758,7594,5786]
[42,null,12320,10797,8758,7594,5786]
[43,null,12320,10797,8758,7594,5786]
[44,null,12320,10797,8758,7594,5786]
[45,null,13788,12084,9771,8472,6453,null,true,true,true,true,true]
[46,null,13788,12084,9771,8472,6453]
[47,null,13788,12084,9771,8472,6453]
[48,null,13788,12084,9771,8472,6453]
[49,null,13788,12084,9771,8472,6453]
[50,null,15437,13532,10915,9466,7210,null,true,true,true,true,true]
[51,null,15437,13532,10915,9466,7210]
[52,null,15437,13532,10915,9466,7210]
[53,null,15437,13532,10915,9466,7210]
[54,null,15437,13532,10915,9466,7210]
[55,null,17258,15128,12186,10568,8050,null,true,true,true,true,true]
[56,null,17258,15128,12186,10568,8050]
[57,null,17258,15128,12186,10568,8050]
[58,null,17258,15128,12186,10568,8050]
[59,null,17258,15128,12186,10568,8050]
[60,null,18471,16191,13032,11300,8607,null,true,true,true,true,true]
[61,null,20582,18042,14515,12588,9587,null,true,true,true,true,true]
[62,null,22867,20043,16122,13978,10646,null,true,true,true,true,true]
[63,null,25320,22196,17853,15480,11791,null,true,true,true,true,true]
[64,null,27950,24497,19708,17089,13016,null,true,true,true,true,true]
[65,null,30749,26954,21690,18809,14327,null,true,true,true,true,true]
[66,null,33723,29560,23797,20635,15719,null,true,true,true,true,true]
[67,null,36868,32315,26032,22572,17193,null,true,true,true,true,true]
[68,null,40184,35223,28390,24618,18752,null,true,true,true,true,true]
[69,null,43676,38282,30876,26774,20393,null,true,true,true,true,true]
[70,null,47337,41492,33484,29036,22116,null,true,true,true,true,true]
[71,null,51171,44853,36221,31409,23923,null,true,true,true,true,true]
[72,null,55178,48367,39082,33887,25812,null,true,true,true,true,true]
[73,null,59358,52029,42071,36479,27785,null,true,true,true,true,true]
[74,null,63711,55842,45182,39178,29841,null,true,true,true,true,true]
[75,null,68234,59808,48419,41985,31979,null,true,true,true,true,true]
[76,null,68234,59808,48419,41985,31979]
[77,null,68234,59808,48419,41985,31979]
[78,null,68234,59808,48419,41985,31979]
[79,null,68234,59808,48419,41985,31979]
[80,null,68234,59808,48419,41985,31979]
[81,null,68234,59808,48419,41985,31979]
[82,null,68234,59808,48419,41985,31979]
[83,null,68234,59808,48419,41985,31979]
[84,"o más",68234,59808,48419,41985,31979]
[1,"Hijo",3506,3073,2570,2229,1698,null,true,true,true,true,true]
[2,"Hijos",5957,5223,4368,3789,2886,null,true,true,true,true,true]
[3,"Hijos o más",8411,7372,6166,5347,4074,null,true,true,true,true,true]
[]
["BUPA GLOBAL ELITE - MENSUALES"]
["EDAD"]
[" "," ",1000,2000,3500]
[18,null,{"$f":"C6*$K$2","v":774.10666666666668},{"$f":"D6*$K$2","v":678.34666666666669},563.45333333333338,488.88,372.30666666666667]
[19,null,{"$f":"C7*$K$2","v":774.10666666666668},678.34666666666669,563.45333333333338,488.88,372.30666666666667]
[20,null,774.10666666666668,678.34666666666669,563.45333333333338,488.88,372.30666666666667]
[21,null,774.10666666666668,678.34666666666669,563.45333333333338,488.88,372.30666666666667]
[22,null,774.10666666666668,678.34666666666669,563.45333333333338,488.88,372.30666666666667]
[23,null,774.10666666666668,678.34666666666669,563.45333333333338,488.88,372.30666666666667]
[24,null,774.10666666666668,678.34666666666669,563.45333333333338,488.88,372.30666666666667]
[25,null,827.02666666666676,724.82666666666671,598.45333333333338,518.93333333333339,395.45333333333338]
[26,null,827.02666666666676,724.82666666666671,598.45333333333338,518.93333333333339,395.45333333333338]
[27,null,827.02666666666676,724.82666666666671,598.45333333333338,518.93333333333339,395.45333333333338]
[28,null,827.02666666666676,724.82666666666671,598.45333333333338,518.93333333333339,395.45333333333338]
[29,null,827.02666666666676,724.82666666666671,598.45333333333338,518.93333333333339,395.45333333333338]
[30,null,919.70666666666671,806.12,660.61333333333334,572.69333333333338,436.24]
[31,null,919.70666666666671,806.12,660.61333333333334,572.69333333333338,436.24]
[32,null,919.70666666666671,806.12,660.61333333333334,572.69333333333338,436.24]
[33,null,919.70666666666671,806.12,660.61333333333334,572.69333333333338,436.24]
[34,null,919.70666666666671,806.12,660.61333333333334,572.69333333333338,436.24]
[35,null,1026.6666666666667,899.64,733.04000000000008,635.69333333333338,484.21333333333337]
[36,null,1026.6666666666667,899.64,733.04000000000008,635.69333333333338,484.21333333333337]
[37,null,1026.6666666666667,899.64,733.04000000000008,635.69333333333338,484.21333333333337]
[38,null,1026.6666666666667,899.64,733.04000000000008,635.69333333333338,484.21333333333337]
[39,null,1026.6666666666667,899.64,733.04000000000008,635.69333333333338,484.21333333333337]
[40,null,1149.8666666666668,1007.72,817.41333333333341,708.77333333333331,540.02666666666664]
[41,null,1149.8666666666668,1007.72,817.41333333333341,708.77333333333331,540.02666666666664]
[42,null,1149.8666666666668,1007.72,817.41333333333341,708.77333333333331,540.02666666666664]
[43,null,1149.8666666666668,1007.72,817.41333333333341,708.77333333333331,540.02666666666664]
[44,null,1149.8666666666668,1007.72,817.41333333333341,708.77333333333331,540.02666666666664]
[45,null,1286.8800000000001,1127.8400000000001,911.96,790.72,602.28]
[46,null,1286.8800000000001,1127.8400000000001,911.96,790.72,602.28]
[47,null,1286.8800000000001,1127.8400000000001,911.96,790.72,602.28]
[48,null,1286.8800000000001,1127.8400000000001,911.96,790.72,602.28]
[49,null,1286.8800000000001,1127.8400000000001,911.96,790.72,602.28]
[50,null,1440.7866666666666,1262.9866666666667,1018.7333333333333,883.49333333333334,672.93333333333339]
[51,null,1440.7866666666666,1262.9866666666667,1018.7333333333333,883.49333333333334,672.93333333333339]
[52,null,1440.7866666666666,1262.9866666666667,1018.7333333333333,883.49333333333334,672.93333333333339]
[53,null,1440.7866666666666,1262.9866666666667,1018.7333333333333,883.49333333333334,672.93333333333339]
[54,null,1440.7866666666666,1262.9866666666667,1018.7333333333333,883.49333333333334,672.93333333333339]
[55,null,1610.7466666666667,1411.9466666666667,1137.3600000000001,986.34666666666669,751.33333333333337]
[56,null,1610.7466666666667,1411.9466666666667,1137.3600000000001,986.34666666666669,751.33333333333337]
[57,null,1610.7466666666667,1411.9466666666667,1137.3600000000001,986.34666666666669,751.33333333333337]
[58,null,1610.7466666666667,1411.9466666666667,1137.3600000000001,986.34666666666669,751.33333333333337]
[59,null,1610.7466666666667,1411.9466666666667,1137.3600000000001,986.34666666666669,751.33333333333337]
[60,null,1723.96,1511.16,1216.3200000000002,1054.6666666666667,803.32]
[61,null,1920.9866666666667,1683.92,1354.7333333333333,1174.8800000000001,894.78666666666675]
[62,null,2134.2533333333336,1870.68,1504.72,1304.6133333333335,993.62666666666667]
[63,null,2363.2000000000003,2071.6266666666666,1666.28,1444.8,1100.4933333333333]
[64,null,2608.666666666667,2286.3866666666668,1839.4133333333334,1594.9733333333334,1214.8266666666668]
[65,null,2869.9066666666668,2515.7066666666669,2024.4,1755.5066666666667,1337.1866666666667]
[66,null,3147.48,2758.9333333333334,2221.0533333333333,1925.9333333333334,{"$f":"G54*$K$2","v":1467.1066666666668}]
[67,null,3441.0133333333333,3016.0666666666666,2429.6533333333336,2106.7200000000003,1604.68]
[68,null,3750.5066666666667,3287.48,2649.7333333333336,2297.6800000000003,1750.1866666666667]
[69,null,4076.4266666666667,3572.9866666666667,2881.76,2498.9066666666668,1903.3466666666668]
[70,null,4418.12,3872.586666666667,3125.1733333333336,2710.0266666666666,2064.1600000000003]
[71,null,4775.96,4186.28,3380.626666666667,2931.5066666666667,2232.8133333333335]
[72,null,5149.9466666666667,4514.2533333333331,3647.6533333333336,3162.7866666666669,2409.12]
[73,null,5540.08,4856.04,3926.626666666667,3404.7066666666669,2593.2666666666669]
[74,null,5946.3600000000006,5211.92,4216.9866666666667,3656.6133333333337,2785.1600000000003]
[75,null,6368.5066666666671,5582.08,4519.1066666666666,3918.6000000000004,2984.7066666666669]
[76,null,6368.5066666666671,5582.08,4519.1066666666666,3918.6000000000004,2984.7066666666669]
[77,null,6368.5066666666671,5582.08,4519.1066666666666,3918.6000000000004,2984.7066666666669]
[78,null,6368.5066666666671,5582.08,4519.1066666666666,3918.6000000000004,2984.7066666666669]
[79,null,6368.5066666666671,5582.08,4519.1066666666666,3918.6000000000004,2984.7066666666669]
[80,null,6368.5066666666671,5582.08,4519.1066666666666,3918.6000000000004,2984.7066666666669]
[81,null,6368.5066666666671,5582.08,4519.1066666666666,3918.6000000000004,2984.7066666666669]
[82,null,6368.5066666666671,{"$f":"D70*$K$2","v":5582.08},4519.1066666666666,3918.6000000000004,2984.7066666666669]
[83,null,{"$f":"C71*$K$2","v":6368.5066666666671},5582.08,4519.1066666666666,3918.6000000000004,2984.7066666666669]
[84,"o más",6368.5066666666671,5582.08,4519.1066666666666,3918.6000000000004,2984.7066666666669]
[1,"Hijo",327.22666666666669,286.81333333333333,239.86666666666667,208.04000000000002,158.48000000000002]
[2,"Hijos",555.98666666666668,487.48,407.68,353.64000000000004,269.36]
[3,"Hijos o más",785.02666666666676,688.0533333333334,575.49333333333334,499.05333333333334,380.24]
[]
["BUPA GLOBAL PREMIER"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",250,2000,5000,10000]
[18,null,5451,4945,3720,2717,null,null,true,true,true,true]
[19,null,5451,4945,3720,2717]
[20,null,5451,4945,3720,2717]
[21,null,5451,4945,3720,2717]
[22,null,5451,4945,3720,2717]
[23,null,5451,4945,3720,2717]
[24,null,5451,4945,3720,2717]
[25,null,5826,5284,3933,2874,null,null,true,true,true,true]
[26,null,5826,5284,3933,2874]
[27,null,5826,5284,3933,2874]
[28,null,5826,5284,3933,2874]
[29,null,5826,5284,3933,2874]
[30,null,6478,5879,4318,3154,null,null,true,true,true,true]
[31,null,6478,5879,4318,3154]
[32,null,6478,5879,4318,3154]
[33,null,6478,5879,4318,3154]
[34,null,6478,5879,4318,3154]
[35,null,7229,6561,4773,3486,null,null,true,true,true,true]
[36,null,7229,6561,4773,3486]
[37,null,7229,6561,4773,3486]
[38,null,7229,6561,4773,3486]
[39,null,7229,6561,4773,3486]
[40,null,8097,7349,5304,3876,null,null,true,true,true,true]
[41,null,8097,7349,5304,3876]
[42,null,8097,7349,5304,3876]
[43,null,8097,7349,5304,3876]
[44,null,8097,7349,5304,3876]
[45,null,9061,8224,5903,4312,null,null,true,true,true,true]
[46,null,9061,8224,5903,4312]
[47,null,9061,8224,5903,4312]
[48,null,9061,8224,5903,4312]
[49,null,9061,8224,5903,4312]
[50,null,10149,9209,6585,4812,null,null,true,true,true,true]
[51,null,10149,9209,6585,4812]
[52,null,10149,9209,6585,4812]
[53,null,10149,9209,6585,4812]
[54,null,10149,9209,6585,4812]
[55,null,11343,10296,7342,5365,null,null,true,true,true,true]
[56,null,11343,10296,7342,5365]
[57,null,11343,10296,7342,5365]
[58,null,11343,10296,7342,5365]
[59,null,11343,10296,7342,5365]
[60,null,12141,11016,7848,5733,null,null,true,true,true,true]
[61,null,13527,12275,8734,6382,null,null,true,true,true,true]
[62,null,15027,13639,9701,7088,null,null,true,true,true,true]
[63,null,16642,15103,10742,7847,null,null,true,true,true,true]
[64,null,18369,16671,11861,8665,null,null,true,true,true,true]
[65,null,20210,18341,13057,9540,null,null,true,true,true,true]
[66,null,22164,20112,14331,10470,null,null,true,true,true,true]
[67,null,24231,21990,15683,11459,null,null,true,true,true,true]
[68,null,26410,23967,17111,12501,null,null,true,true,true,true]
[69,null,28705,26051,18617,13602,null,null,true,true,true,true]
[70,null,31112,28236,20199,14757,null,null,true,true,true,true]
[71,null,33633,30521,21861,15971,null,null,true,true,true,true]
[72,null,36265,32911,23598,17241,null,null,true,true,true,true]
[73,null,39011,35404,25413,18566,null,null,true,true,true,true]
[74,null,41872,37999,27307,19950,null,null,true,true,true,true]
[75,null,44844,40698,29277,21390,null,null,true,true,true,true]
[76,null,44844,40698,29277,21390]
[77,null,44844,40698,29277,21390]
[78,null,44844,40698,29277,21390]
[79,null,44844,40698,29277,21390]
[80,null,44844,40698,29277,21390]
[81,null,44844,40698,29277,21390]
[82,null,44844,40698,29277,21390]
[83,null,44844,40698,29277,21390]
[84,"o más",44844,40698,29277,21390]
[1,"Hijo",2304,2090,1593,1163,null,null,true,true,true,true]
[2,"Hijos",3916,3555,2705,1977,null,null,true,true,true,true]
[3,"Hijos o más",5527,5016,3819,2790,null,null,true,true,true,true]
[]
["BUPA GLOBAL PREMIER - MENSUALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C155*$K$2","v":508.76000000000005},{"$f":"D155*$K$2","v":461.53333333333336},347.2,253.58666666666667,0]
[19,null,{"$f":"C156*$K$2","v":508.76000000000005},461.53333333333336,347.2,253.58666666666667,0]
[20,null,508.76000000000005,461.53333333333336,347.2,253.58666666666667,0]
[21,null,508.76000000000005,461.53333333333336,347.2,253.58666666666667,0]
[22,null,508.76000000000005,461.53333333333336,347.2,253.58666666666667,0]
[23,null,508.76000000000005,461.53333333333336,347.2,253.58666666666667,0]
[24,null,508.76000000000005,461.53333333333336,347.2,253.58666666666667,0]
[25,null,543.76,493.17333333333335,367.08000000000004,268.24,0]
[26,null,543.76,493.17333333333335,367.08000000000004,268.24,0]
[27,null,543.76,493.17333333333335,367.08000000000004,268.24,0]
[28,null,543.76,493.17333333333335,367.08000000000004,268.24,0]
[29,null,543.76,493.17333333333335,367.08000000000004,268.24,0]
[30,null,604.61333333333334,548.70666666666671,403.01333333333338,294.37333333333333,0]
[31,null,604.61333333333334,548.70666666666671,403.01333333333338,294.37333333333333,0]
[32,null,604.61333333333334,548.70666666666671,403.01333333333338,294.37333333333333,0]
[33,null,604.61333333333334,548.70666666666671,403.01333333333338,294.37333333333333,0]
[34,null,604.61333333333334,548.70666666666671,403.01333333333338,294.37333333333333,0]
[35,null,674.70666666666671,612.36,445.48,325.36,0]
[36,null,674.70666666666671,612.36,445.48,325.36,0]
[37,null,674.70666666666671,612.36,445.48,325.36,0]
[38,null,674.70666666666671,612.36,445.48,325.36,0]
[39,null,674.70666666666671,612.36,445.48,325.36,0]
[40,null,755.72,685.90666666666675,495.04,361.76,0]
[41,null,755.72,685.90666666666675,495.04,361.76,0]
[42,null,755.72,685.90666666666675,495.04,361.76,0]
[43,null,755.72,685.90666666666675,495.04,361.76,0]
[44,null,755.72,685.90666666666675,495.04,361.76,0]
[45,null,845.69333333333338,767.57333333333338,550.94666666666672,402.45333333333338,0]
[46,null,845.69333333333338,767.57333333333338,550.94666666666672,402.45333333333338,0]
[47,null,845.69333333333338,767.57333333333338,550.94666666666672,402.45333333333338,0]
[48,null,845.69333333333338,767.57333333333338,550.94666666666672,402.45333333333338,0]
[49,null,845.69333333333338,767.57333333333338,550.94666666666672,402.45333333333338,0]
[50,null,947.24,859.50666666666666,614.6,449.12,0]
[51,null,947.24,859.50666666666666,614.6,449.12,0]
[52,null,947.24,859.50666666666666,614.6,449.12,0]
[53,null,947.24,859.50666666666666,614.6,449.12,0]
[54,null,947.24,859.50666666666666,614.6,449.12,0]
[55,null,1058.68,960.96,685.25333333333333,500.73333333333335,0]
[56,null,1058.68,960.96,685.25333333333333,500.73333333333335,0]
[57,null,1058.68,960.96,685.25333333333333,500.73333333333335,0]
[58,null,1058.68,960.96,685.25333333333333,500.73333333333335,0]
[59,null,1058.68,960.96,685.25333333333333,500.73333333333335,0]
[60,null,1133.1600000000001,1028.1600000000001,732.48,535.08000000000004,0]
[61,null,1262.52,1145.6666666666667,815.1733333333334,595.65333333333331,0]
[62,null,1402.52,1272.9733333333334,905.42666666666673,661.54666666666674,0]
[63,null,1553.2533333333333,1409.6133333333335,1002.5866666666667,732.38666666666666,0]
[64,null,1714.44,1555.96,1107.0266666666666,808.73333333333335,0]
[65,null,1886.2666666666667,1711.8266666666668,1218.6533333333334,890.40000000000009,0]
[66,null,2068.64,1877.1200000000001,1337.5600000000002,977.2,0]
[67,null,2261.56,2052.4,1463.7466666666667,1069.5066666666667,0]
[68,null,2464.9333333333334,2236.92,1597.0266666666666,1166.76,0]
[69,null,2679.1333333333337,2431.4266666666667,1737.5866666666668,1269.52,0]
[70,null,2903.7866666666669,2635.36,1885.24,1377.3200000000002,0]
[71,null,3139.08,2848.626666666667,2040.3600000000001,1490.6266666666668,0]
[72,null,3384.7333333333336,3071.6933333333336,2202.48,1609.16,0]
[73,null,3641.0266666666666,3304.3733333333334,2371.88,1732.8266666666668,0]
[74,null,3908.0533333333333,3546.5733333333337,2548.6533333333336,1862,0]
[75,null,4185.4400000000005,3798.48,2732.52,1996.4,0]
[76,null,4185.4400000000005,3798.48,2732.52,1996.4,0]
[77,null,4185.4400000000005,3798.48,2732.52,1996.4,0]
[78,null,4185.4400000000005,3798.48,2732.52,1996.4,0]
[79,null,4185.4400000000005,3798.48,2732.52,1996.4,0]
[80,null,4185.4400000000005,3798.48,2732.52,1996.4]
[81,null,4185.4400000000005,3798.48,2732.52,1996.4]
[82,null,4185.4400000000005,3798.48,2732.52,{"$f":"F219*$K$2","v":1996.4}]
[83,null,{"$f":"C220*$K$2","v":4185.4400000000005},3798.48,2732.52,1996.4]
[84,"o más",4185.4400000000005,3798.48,2732.52,1996.4,0]
[1,"Hijo",215.04000000000002,195.06666666666666,148.68,108.54666666666667,0]
[2,"Hijos",365.49333333333334,331.8,252.46666666666667,184.52,0]
[3,"Hijos o más",515.85333333333335,468.16,356.44,260.40000000000003,0]
[]
[]
["BUPA GLOBAL SELECT"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",250,2000,5000]
[18,null,3455,3314,2503,1828,null,true,true,true,true]
[19,null,3455,3314,2503,1828,null,true]
[20,null,3455,3314,2503,1828,null,true]
[21,null,3455,3314,2503,1828,null,true]
[22,null,3455,3314,2503,1828,null,true]
[23,null,3455,3314,2503,1828,null,true]
[24,null,3455,3314,2503,1828,null,true]
[25,null,3727,3576,2672,1952,null,true,true,true,true]
[26,null,3727,3576,2672,1952,null,true]
[27,null,3727,3576,2672,1952,null,true]
[28,null,3727,3576,2672,1952,null,true]
[29,null,3727,3576,2672,1952,null,true]
[30,null,4205,4033,2971,2169,null,true,true,true,true]
[31,null,4205,4033,2971,2169,null,true]
[32,null,4205,4033,2971,2169,null,true]
[33,null,4205,4033,2971,2169,null,true]
[34,null,4205,4033,2971,2169,null,true]
[35,null,4758,4565,3326,2430,null,true,true,true,true]
[36,null,4758,4565,3326,2430,null,true]
[37,null,4758,4565,3326,2430,null,true]
[38,null,4758,4565,3326,2430,null,true]
[39,null,4758,4565,3326,2430,null,true]
[40,null,5396,5178,3741,2732,null,true,true,true,true]
[41,null,5396,5178,3741,2732,null,true]
[42,null,5396,5178,3741,2732,null,true]
[43,null,5396,5178,3741,2732,null,true]
[44,null,5396,5178,3741,2732,null,true]
[45,null,6108,5859,4211,3076,null,true,true,true,true]
[46,null,6108,5859,4211,3076,null,true]
[47,null,6108,5859,4211,3076,null,true]
[48,null,6108,5859,4211,3076,null,true]
[49,null,6108,5859,4211,3076,null,true]
[50,null,6909,6628,4744,3465,null,true,true,true,true]
[51,null,6909,6628,4744,3465,null,true]
[52,null,6909,6628,4744,3465,null,true]
[53,null,6909,6628,4744,3465,null,true]
[54,null,6909,6628,4744,3465,null,true]
[55,null,7793,7477,5338,3899,null,true,true,true,true]
[56,null,7793,7477,5338,3899,null,true]
[57,null,7793,7477,5338,3899,null,true]
[58,null,7793,7477,5338,3899,null,true]
[59,null,7793,7477,5338,3899,null,true]
[60,null,8381,8041,5737,4188,null,true,true,true,true]
[61,null,9408,9026,6433,4698,null,true,true,true,true]
[62,null,10518,10092,7191,5250,null,true,true,true,true]
[63,null,11714,11240,8009,5848,null,true,true,true,true]
[64,null,12993,12468,8887,6490,null,true,true,true,true]
[65,null,14359,13778,9829,7178,null,true,true,true,true]
[66,null,15808,15168,10830,7908,null,true,true,true,true]
[67,null,17343,16639,11891,8684,null,true,true,true,true]
[68,null,18962,18192,13013,9503,null,true,true,true,true]
[69,null,20663,19826,14198,10368,null,true,true,true,true]
[70,null,22451,21541,15443,11276,null,true,true,true,true]
[71,null,24322,23336,16751,12231,null,true,true,true,true]
[72,null,26280,25214,18116,13230,null,true,true,true,true]
[73,null,28320,27171,19544,14271,null,true,true,true,true]
[74,null,30444,29212,21031,15358,null,true,true,true,true]
[75,null,32654,31332,22583,16491,null,true,true,true,true]
[76,null,32654,31332,22583,16491,null,true]
[77,null,32654,31332,22583,16491,null,true]
[78,null,32654,31332,22583,16491,null,true]
[79,null,32654,31332,22583,16491,null,true]
[80,null,32654,31332,22583,16491,null,true]
[81,null,32654,31332,22583,16491,null,true]
[82,null,32654,31332,22583,16491,null,true]
[83,null,32654,31332,22583,16491,null,true]
[84,"o más",32654,31332,22583,16491,null,true]
[1,"Hijo",1612,1547,1185,866,null,true,true,true,true]
[2,"Hijos",2738,2627,2012,1470,null,true,true,true,true]
[3,"Hijos o más",3866,3708,2840,2074,null,true,true,true,true]
[]
["BUPA GLOBAL SELECT - MENSUALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C305*$K$2","v":322.4666666666667},{"$f":"D305*$K$2","v":309.30666666666667},233.61333333333334,170.61333333333334,0]
[19,null,{"$f":"C306*$K$2","v":322.4666666666667},309.30666666666667,233.61333333333334,170.61333333333334,0]
[20,null,322.4666666666667,309.30666666666667,233.61333333333334,170.61333333333334,0]
[21,null,322.4666666666667,309.30666666666667,233.61333333333334,170.61333333333334,0]
[22,null,322.4666666666667,309.30666666666667,233.61333333333334,170.61333333333334,0]
[23,null,322.4666666666667,309.30666666666667,233.61333333333334,170.61333333333334,0]
[24,null,322.4666666666667,309.30666666666667,233.61333333333334,170.61333333333334,0]
[25,null,347.85333333333335,333.76,249.38666666666668,182.18666666666667,0]
[26,null,347.85333333333335,333.76,249.38666666666668,182.18666666666667,0]
[27,null,347.85333333333335,333.76,249.38666666666668,182.18666666666667,0]
[28,null,347.85333333333335,333.76,249.38666666666668,182.18666666666667,0]
[29,null,347.85333333333335,333.76,249.38666666666668,182.18666666666667,0]
[30,null,392.4666666666667,376.41333333333336,277.29333333333335,202.44,0]
[31,null,392.4666666666667,376.41333333333336,277.29333333333335,202.44,0]
[32,null,392.4666666666667,376.41333333333336,277.29333333333335,202.44,0]
[33,null,392.4666666666667,376.41333333333336,277.29333333333335,202.44,0]
[34,null,392.4666666666667,376.41333333333336,277.29333333333335,202.44,0]
[35,null,444.08000000000004,426.06666666666666,310.42666666666668,226.8,0]
[36,null,444.08000000000004,426.06666666666666,310.42666666666668,226.8,0]
[37,null,444.08000000000004,426.06666666666666,310.42666666666668,226.8,0]
[38,null,444.08000000000004,426.06666666666666,310.42666666666668,226.8,0]
[39,null,444.08000000000004,426.06666666666666,310.42666666666668,226.8,0]
[40,null,503.62666666666667,483.28000000000003,349.16,254.98666666666668,0]
[41,null,503.62666666666667,483.28000000000003,349.16,254.98666666666668,0]
[42,null,503.62666666666667,483.28000000000003,349.16,254.98666666666668,0]
[43,null,503.62666666666667,483.28000000000003,349.16,254.98666666666668,0]
[44,null,503.62666666666667,483.28000000000003,349.16,254.98666666666668,0]
[45,null,570.08000000000004,546.84,393.0266666666667,287.09333333333336,0]
[46,null,570.08000000000004,546.84,393.0266666666667,287.09333333333336,0]
[47,null,570.08000000000004,546.84,393.0266666666667,287.09333333333336,0]
[48,null,570.08000000000004,546.84,393.0266666666667,287.09333333333336,0]
[49,null,570.08000000000004,546.84,393.0266666666667,287.09333333333336,0]
[50,null,644.84,618.61333333333334,442.77333333333337,323.40000000000003,0]
[51,null,644.84,618.61333333333334,442.77333333333337,323.40000000000003,0]
[52,null,644.84,618.61333333333334,442.77333333333337,323.40000000000003,0]
[53,null,644.84,618.61333333333334,442.77333333333337,323.40000000000003,0]
[54,null,644.84,618.61333333333334,442.77333333333337,323.40000000000003,0]
[55,null,727.34666666666669,697.85333333333335,498.21333333333337,363.90666666666669,0]
[56,null,727.34666666666669,697.85333333333335,498.21333333333337,363.90666666666669,0]
[57,null,727.34666666666669,697.85333333333335,498.21333333333337,363.90666666666669,0]
[58,null,727.34666666666669,697.85333333333335,498.21333333333337,363.90666666666669,0]
[59,null,727.34666666666669,697.85333333333335,498.21333333333337,363.90666666666669,0]
[60,null,782.22666666666669,750.49333333333334,535.45333333333338,390.88,0]
[61,null,878.08,842.42666666666673,600.41333333333341,438.48,0]
[62,null,981.68000000000006,941.92000000000007,671.16000000000008,490,0]
[63,null,1093.3066666666666,1049.0666666666666,747.50666666666666,545.81333333333339,0]
[64,null,1212.68,1163.68,829.45333333333338,605.73333333333335,0]
[65,null,1340.1733333333334,1285.9466666666667,917.37333333333333,669.94666666666672,0]
[66,null,1475.4133333333334,1415.68,1010.8000000000001,738.08,0]
[67,null,1618.68,1552.9733333333334,1109.8266666666668,810.50666666666666,0]
[68,null,1769.7866666666669,1697.92,1214.5466666666666,886.94666666666672,0]
[69,null,1928.5466666666669,1850.4266666666667,1325.1466666666668,967.68000000000006,0]
[70,null,2095.4266666666667,2010.4933333333333,1441.3466666666668,1052.4266666666667,0]
[71,null,2270.0533333333333,2178.0266666666666,1563.4266666666667,1141.56,0]
[72,null,2452.8000000000002,2353.3066666666668,1690.8266666666668,1234.8,0]
[73,null,2643.2000000000003,2535.96,1824.1066666666668,1331.96,0]
[74,null,2841.44,2726.4533333333334,1962.8933333333334,1433.4133333333334,0]
[75,null,3047.7066666666669,2924.32,2107.7466666666669,1539.16,0]
[76,null,3047.7066666666669,2924.32,2107.7466666666669,1539.16,0]
[77,null,3047.7066666666669,2924.32,2107.7466666666669,1539.16,0]
[78,null,3047.7066666666669,2924.32,2107.7466666666669,1539.16,0]
[79,null,3047.7066666666669,2924.32,2107.7466666666669,1539.16,0]
[80,null,3047.7066666666669,2924.32,2107.7466666666669,1539.16]
[81,null,3047.7066666666669,2924.32,2107.7466666666669,1539.16]
[82,null,3047.7066666666669,2924.32,2107.7466666666669,{"$f":"F369*$K$2","v":1539.16}]
[83,null,{"$f":"C370*$K$2","v":3047.7066666666669},2924.32,2107.7466666666669,1539.16]
[84,"o más",3047.7066666666669,2924.32,2107.7466666666669,1539.16,0]
[1,"Hijo",150.45333333333335,144.38666666666668,110.60000000000001,80.826666666666668]
[2,"Hijos",255.54666666666668,245.18666666666667,187.78666666666666,137.20000000000002]
[3,"Hijos o más",360.82666666666671,346.08000000000004,265.06666666666666,193.57333333333335]
[]
[]
["BUPA GLOBAL ELITE"]
["TARIFAS SEMESTRALES"]
["EDAD"]
[" "," ",1000,2000,3500]
[18,null,{"$f":"C6*$K$4","v":4395.8200000000006},{"$f":"D6*$K$4","v":3852.0400000000004},3199.61,2776.1400000000003,2114.17]
[19,null,{"$f":"C7*$K$4","v":4395.8200000000006},3852.0400000000004,3199.61,2776.1400000000003,2114.17]
[20,null,4395.8200000000006,3852.0400000000004,3199.61,2776.1400000000003,2114.17]
[21,null,4395.8200000000006,3852.0400000000004,3199.61,2776.1400000000003,2114.17]
[22,null,4395.8200000000006,3852.0400000000004,3199.61,2776.1400000000003,2114.17]
[23,null,4395.8200000000006,3852.0400000000004,3199.61,2776.1400000000003,2114.17]
[24,null,4395.8200000000006,3852.0400000000004,3199.61,2776.1400000000003,2114.17]
[25,null,4696.33,4115.9800000000005,3398.36,2946.8,2245.61]
[26,null,4696.33,4115.9800000000005,3398.36,2946.8,2245.61]
[27,null,4696.33,4115.9800000000005,3398.36,2946.8,2245.61]
[28,null,4696.33,4115.9800000000005,3398.36,2946.8,2245.61]
[29,null,4696.33,4115.9800000000005,3398.36,2946.8,2245.61]
[30,null,5222.62,4577.6100000000006,3751.34,3252.0800000000004,2477.2200000000003]
[31,null,5222.62,4577.6100000000006,3751.34,3252.0800000000004,2477.2200000000003]
[32,null,5222.62,4577.6100000000006,3751.34,3252.0800000000004,2477.2200000000003]
[33,null,5222.62,4577.6100000000006,3751.34,3252.0800000000004,2477.2200000000003]
[34,null,5222.62,4577.6100000000006,3751.34,3252.0800000000004,2477.2200000000003]
[35,null,5830,5108.67,4162.62,3609.8300000000004,2749.6400000000003]
[36,null,5830,5108.67,4162.62,3609.8300000000004,2749.6400000000003]
[37,null,5830,5108.67,4162.62,3609.8300000000004,2749.6400000000003]
[38,null,5830,5108.67,4162.62,3609.8300000000004,2749.6400000000003]
[39,null,5830,5108.67,4162.62,3609.8300000000004,2749.6400000000003]
[40,null,6529.6,5722.41,4641.74,4024.82,3066.58]
[41,null,6529.6,5722.41,4641.74,4024.82,3066.58]
[42,null,6529.6,5722.41,4641.74,4024.82,3066.58]
[43,null,6529.6,5722.41,4641.74,4024.82,3066.58]
[44,null,6529.6,5722.41,4641.74,4024.82,3066.58]
[45,null,7307.64,6404.52,5178.63,4490.16,3420.09]
[46,null,7307.64,6404.52,5178.63,4490.16,3420.09]
[47,null,7307.64,6404.52,5178.63,4490.16,3420.09]
[48,null,7307.64,6404.52,5178.63,4490.16,3420.09]
[49,null,7307.64,6404.52,5178.63,4490.16,3420.09]
[50,null,8181.6100000000006,7171.96,5784.9500000000007,5016.9800000000005,3821.3]
[51,null,8181.6100000000006,7171.96,5784.9500000000007,5016.9800000000005,3821.3]
[52,null,8181.6100000000006,7171.96,5784.9500000000007,5016.9800000000005,3821.3]
[53,null,8181.6100000000006,7171.96,5784.9500000000007,5016.9800000000005,3821.3]
[54,null,8181.6100000000006,7171.96,5784.9500000000007,5016.9800000000005,3821.3]
[55,null,9146.74,8017.84,6458.58,5601.04,4266.5]
[56,null,9146.74,8017.84,6458.58,5601.04,4266.5]
[57,null,9146.74,8017.84,6458.58,5601.04,4266.5]
[58,null,9146.74,8017.84,6458.58,5601.04,4266.5]
[59,null,9146.74,8017.84,6458.58,5601.04,4266.5]
[60,null,9789.630000000001,8581.23,6906.96,5989,4561.71]
[61,null,10908.460000000001,9562.26,7692.9500000000007,6671.64,5081.1100000000006]
[62,null,12119.51,10622.79,8544.66,7408.34,5642.38]
[63,null,13419.6,11763.880000000001,9462.09,8204.4,6249.2300000000005]
[64,null,14813.5,12983.41,10445.24,9057.17,6898.4800000000005]
[65,null,16296.970000000001,14285.62,11495.7,9968.77,7593.31]
[66,null,17873.190000000002,15666.800000000001,12612.41,10936.550000000001,{"$f":"G54*$K$4","v":8331.07}]
[67,null,19540.04,17126.95,13796.960000000001,11963.16,9112.2900000000009]
[68,null,21297.52,18668.190000000002,15046.7,13047.54,9938.5600000000013]
[69,null,23148.280000000002,20289.460000000003,16364.28,14190.220000000001,10808.29]
[70,null,25088.61,21990.760000000002,17746.52,15389.08,11721.480000000001]
[71,null,27120.63,23772.09,19197.13,16646.77,12679.19]
[72,null,29244.34,25634.510000000002,20713.460000000003,17960.11,13680.36]
[73,null,31459.74,27575.370000000003,22297.63,19333.870000000003,14726.050000000001]
[74,null,33766.83,29596.260000000002,23946.460000000003,20764.34,15815.730000000001]
[75,null,36164.020000000004,31698.240000000002,25662.07,22252.050000000003,16948.870000000003]
[76,null,36164.020000000004,31698.240000000002,25662.07,22252.050000000003,16948.870000000003]
[77,null,36164.020000000004,31698.240000000002,25662.07,22252.050000000003,16948.870000000003]
[78,null,36164.020000000004,31698.240000000002,25662.07,22252.050000000003,16948.870000000003]
[79,null,36164.020000000004,31698.240000000002,25662.07,22252.050000000003,16948.870000000003]
[80,null,36164.020000000004,31698.240000000002,25662.07,22252.050000000003,16948.870000000003]
[81,null,36164.020000000004,31698.240000000002,25662.07,22252.050000000003,16948.870000000003]
[82,null,36164.020000000004,{"$f":"D70*$K$4","v":31698.240000000002},25662.07,22252.050000000003,16948.870000000003]
[83,null,{"$f":"C71*$K$4","v":36164.020000000004},31698.240000000002,25662.07,22252.050000000003,16948.870000000003]
[84,"o más",36164.020000000004,31698.240000000002,25662.07,22252.050000000003,16948.870000000003]
[1,"Hijo",1858.18,1628.69,1362.1000000000001,1181.3700000000001,899.94]
[2,"Hijos",3157.21,2768.19,2315.04,2008.17,1529.5800000000002]
[3,"Hijos o más",4457.83,3907.1600000000003,3267.98,2833.9100000000003,2159.2200000000003]
[]
["BUPA GLOBAL PREMIER"]
["TARIFAS SEMESTRALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C155*$K$4","v":2889.03},{"$f":"D155*$K$4","v":2620.85},1971.6000000000001,1440.01,0]
[19,null,{"$f":"C156*$K$4","v":2889.03},2620.85,1971.6000000000001,1440.01,0]
[20,null,2889.03,2620.85,1971.6000000000001,1440.01,0]
[21,null,2889.03,2620.85,1971.6000000000001,1440.01,0]
[22,null,2889.03,2620.85,1971.6000000000001,1440.01,0]
[23,null,2889.03,2620.85,1971.6000000000001,1440.01,0]
[24,null,2889.03,2620.85,1971.6000000000001,1440.01,0]
[25,null,3087.78,2800.52,2084.4900000000002,1523.22,0]
[26,null,3087.78,2800.52,2084.4900000000002,1523.22,0]
[27,null,3087.78,2800.52,2084.4900000000002,1523.22,0]
[28,null,3087.78,2800.52,2084.4900000000002,1523.22,0]
[29,null,3087.78,2800.52,2084.4900000000002,1523.22,0]
[30,null,3433.34,3115.8700000000003,2288.54,1671.6200000000001,0]
[31,null,3433.34,3115.8700000000003,2288.54,1671.6200000000001,0]
[32,null,3433.34,3115.8700000000003,2288.54,1671.6200000000001,0]
[33,null,3433.34,3115.8700000000003,2288.54,1671.6200000000001,0]
[34,null,3433.34,3115.8700000000003,2288.54,1671.6200000000001,0]
[35,null,3831.3700000000003,3477.3300000000004,2529.69,1847.5800000000002,0]
[36,null,3831.3700000000003,3477.3300000000004,2529.69,1847.5800000000002,0]
[37,null,3831.3700000000003,3477.3300000000004,2529.69,1847.5800000000002,0]
[38,null,3831.3700000000003,3477.3300000000004,2529.69,1847.5800000000002,0]
[39,null,3831.3700000000003,3477.3300000000004,2529.69,1847.5800000000002,0]
[40,null,4291.41,3894.9700000000003,2811.1200000000003,2054.2800000000002,0]
[41,null,4291.41,3894.9700000000003,2811.1200000000003,2054.2800000000002,0]
[42,null,4291.41,3894.9700000000003,2811.1200000000003,2054.2800000000002,0]
[43,null,4291.41,3894.9700000000003,2811.1200000000003,2054.2800000000002,0]
[44,null,4291.41,3894.9700000000003,2811.1200000000003,2054.2800000000002,0]
[45,null,4802.33,4358.72,3128.59,2285.36,0]
[46,null,4802.33,4358.72,3128.59,2285.36,0]
[47,null,4802.33,4358.72,3128.59,2285.36,0]
[48,null,4802.33,4358.72,3128.59,2285.36,0]
[49,null,4802.33,4358.72,3128.59,2285.36,0]
[50,null,5378.97,4880.7700000000004,3490.05,2550.36,0]
[51,null,5378.97,4880.7700000000004,3490.05,2550.36,0]
[52,null,5378.97,4880.7700000000004,3490.05,2550.36,0]
[53,null,5378.97,4880.7700000000004,3490.05,2550.36,0]
[54,null,5378.97,4880.7700000000004,3490.05,2550.36,0]
[55,null,6011.79,5456.88,3891.26,2843.4500000000003,0]
[56,null,6011.79,5456.88,3891.26,2843.4500000000003,0]
[57,null,6011.79,5456.88,3891.26,2843.4500000000003,0]
[58,null,6011.79,5456.88,3891.26,2843.4500000000003,0]
[59,null,6011.79,5456.88,3891.26,2843.4500000000003,0]
[60,null,6434.7300000000005,5838.4800000000005,4159.4400000000005,3038.4900000000002,0]
[61,null,7169.31,6505.75,4629.0200000000004,3382.46,0]
[62,null,7964.31,7228.67,5141.5300000000007,3756.6400000000003,0]
[63,null,8820.26,8004.59,5693.26,4158.91,0]
[64,null,9735.57,8835.630000000001,6286.33,4592.45,0]
[65,null,10711.300000000001,9720.7300000000014,6920.21,5056.2,0]
[66,null,11746.92,10659.36,7595.43,5549.1,0]
[67,null,12842.43,11654.7,8311.99,6073.27,0]
[68,null,13997.300000000001,12702.51,9068.83,6625.5300000000007,0]
[69,null,15213.650000000001,13807.03,9867.01,7209.06,0]
[70,null,16489.36,14965.08,10705.470000000001,7821.21,0]
[71,null,17825.490000000002,16176.130000000001,11586.33,8464.630000000001,0]
[72,null,19220.45,17442.830000000002,12506.94,9137.73,0]
[73,null,20675.830000000002,18764.120000000003,13468.890000000001,9839.9800000000014,0]
[74,null,22192.16,20139.47,14472.710000000001,10573.5,0]
[75,null,23767.32,21569.940000000002,15516.810000000001,11336.7,0]
[76,null,23767.32,21569.940000000002,15516.810000000001,11336.7,0]
[77,null,23767.32,21569.940000000002,15516.810000000001,11336.7,0]
[78,null,23767.32,21569.940000000002,15516.810000000001,11336.7,0]
[79,null,23767.32,21569.940000000002,15516.810000000001,11336.7,0]
[80,null,23767.32,21569.940000000002,15516.810000000001,11336.7,0]
[81,null,23767.32,21569.940000000002,15516.810000000001,11336.7,0]
[82,null,23767.32,21569.940000000002,15516.810000000001,{"$f":"F219*$K$4","v":11336.7},0]
[83,null,{"$f":"C220*$K$4","v":23767.32},21569.940000000002,15516.810000000001,11336.7,0]
[84,"o más",23767.32,21569.940000000002,15516.810000000001,11336.7,0]
[1,"Hijo",1221.1200000000001,1107.7,844.29000000000008,616.39,0]
[2,"Hijos",2075.48,1884.15,1433.65,1047.81,0]
[3,"Hijos o más",2929.31,2658.48,2024.0700000000002,1478.7,0]
[]
["BUPA GLOBAL SELECT"]
["TARIFAS SEMESTRALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C305*$K$4","v":1831.15},{"$f":"D305*$K$4","v":1756.42},1326.5900000000001,968.84,0]
[19,null,{"$f":"C306*$K$4","v":1831.15},1756.42,1326.5900000000001,968.84,0]
[20,null,1831.15,1756.42,1326.5900000000001,968.84,0]
[21,null,1831.15,1756.42,1326.5900000000001,968.84,0]
[22,null,1831.15,1756.42,1326.5900000000001,968.84,0]
[23,null,1831.15,1756.42,1326.5900000000001,968.84,0]
[24,null,1831.15,1756.42,1326.5900000000001,968.84,0]
[25,null,1975.3100000000002,1895.2800000000002,1416.16,1034.56,0]
[26,null,1975.3100000000002,1895.2800000000002,1416.16,1034.56,0]
[27,null,1975.3100000000002,1895.2800000000002,1416.16,1034.56,0]
[28,null,1975.3100000000002,1895.2800000000002,1416.16,1034.56,0]
[29,null,1975.3100000000002,1895.2800000000002,1416.16,1034.56,0]
[30,null,2228.65,2137.4900000000002,1574.63,1149.5700000000002,0]
[31,null,2228.65,2137.4900000000002,1574.63,1149.5700000000002,0]
[32,null,2228.65,2137.4900000000002,1574.63,1149.5700000000002,0]
[33,null,2228.65,2137.4900000000002,1574.63,1149.5700000000002,0]
[34,null,2228.65,2137.4900000000002,1574.63,1149.5700000000002,0]
[35,null,2521.7400000000002,2419.4500000000003,1762.7800000000002,1287.9000000000001,0]
[36,null,2521.7400000000002,2419.4500000000003,1762.7800000000002,1287.9000000000001,0]
[37,null,2521.7400000000002,2419.4500000000003,1762.7800000000002,1287.9000000000001,0]
[38,null,2521.7400000000002,2419.4500000000003,1762.7800000000002,1287.9000000000001,0]
[39,null,2521.7400000000002,2419.4500000000003,1762.7800000000002,1287.9000000000001,0]
[40,null,2859.88,2744.34,1982.73,1447.96,0]
[41,null,2859.88,2744.34,1982.73,1447.96,0]
[42,null,2859.88,2744.34,1982.73,1447.96,0]
[43,null,2859.88,2744.34,1982.73,1447.96,0]
[44,null,2859.88,2744.34,1982.73,1447.96,0]
[45,null,3237.2400000000002,3105.27,2231.83,1630.28,0]
[46,null,3237.2400000000002,3105.27,2231.83,1630.28,0]
[47,null,3237.2400000000002,3105.27,2231.83,1630.28,0]
[48,null,3237.2400000000002,3105.27,2231.83,1630.28,0]
[49,null,3237.2400000000002,3105.27,2231.83,1630.28,0]
[50,null,3661.77,3512.84,2514.3200000000002,1836.45,0]
[51,null,3661.77,3512.84,2514.3200000000002,1836.45,0]
[52,null,3661.77,3512.84,2514.3200000000002,1836.45,0]
[53,null,3661.77,3512.84,2514.3200000000002,1836.45,0]
[54,null,3661.77,3512.84,2514.3200000000002,1836.45,0]
[55,null,4130.29,3962.8100000000004,2829.1400000000003,2066.4700000000003,0]
[56,null,4130.29,3962.8100000000004,2829.1400000000003,2066.4700000000003,0]
[57,null,4130.29,3962.8100000000004,2829.1400000000003,2066.4700000000003,0]
[58,null,4130.29,3962.8100000000004,2829.1400000000003,2066.4700000000003,0]
[59,null,4130.29,3962.8100000000004,2829.1400000000003,2066.4700000000003,0]
[60,null,4441.93,4261.7300000000005,3040.61,2219.6400000000003,0]
[61,null,4986.2400000000007,4783.7800000000007,3409.4900000000002,2489.94,0]
[62,null,5574.54,5348.76,3811.23,2782.5,0]
[63,null,6208.42,5957.2000000000007,4244.7700000000004,3099.44,0]
[64,null,6886.29,6608.04,4710.1100000000006,3439.7000000000003,0]
[65,null,7610.27,7302.34,5209.37,3804.34,0]
[66,null,8378.24,8039.04,5739.9000000000005,4191.24,0]
[67,null,9191.7900000000009,8818.67,6302.2300000000005,4602.5200000000004,0]
[68,null,10049.86,9641.76,6896.89,5036.59,0]
[69,null,10951.390000000001,10507.78,7524.9400000000005,5495.04,0]
[70,null,11899.03,11416.730000000001,8184.79,5976.2800000000007,0]
[71,null,12890.66,12368.08,8878.0300000000007,6482.43,0]
[72,null,13928.400000000001,13363.42,9601.4800000000014,7011.9000000000005,0]
[73,null,15009.6,14400.630000000001,10358.32,7563.63,0]
[74,null,16135.320000000002,15482.36,11146.43,8139.7400000000007,0]
[75,null,17306.620000000003,16605.96,11968.99,8740.23,0]
[76,null,17306.620000000003,16605.96,11968.99,8740.23,0]
[77,null,17306.620000000003,16605.96,11968.99,8740.23,0]
[78,null,17306.620000000003,16605.96,11968.99,8740.23,0]
[79,null,17306.620000000003,16605.96,11968.99,8740.23,0]
[80,null,17306.620000000003,16605.96,11968.99,8740.23,0]
[81,null,17306.620000000003,16605.96,11968.99,8740.23,0]
[82,null,17306.620000000003,16605.96,11968.99,{"$f":"F369*$K$4","v":8740.23},0]
[83,null,{"$f":"C370*$K$4","v":17306.620000000003},16605.96,11968.99,8740.23,0]
[84,"o más",17306.620000000003,16605.96,11968.99,8740.23,0]
[1,"Hijo",854.36,819.91000000000008,628.05000000000007,458.98,0]
[2,"Hijos",1451.14,1392.3100000000002,1066.3600000000001,779.1,0]
[3,"Hijos o más",2048.98,1965.24,1505.2,1099.22,0]
[]
["BUPA GLOBAL ELITE"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ",1000,2000,3500]
[18,null,{"$f":"C6*$K$3","v":2280.8500000000004},{"$f":"D6*$K$3","v":1998.7000000000003},1660.1750000000002,1440.45,1096.9750000000001]
[19,null,{"$f":"C7*$K$3","v":2280.8500000000004},1998.7000000000003,1660.1750000000002,1440.45,1096.9750000000001]
[20,null,2280.8500000000004,1998.7000000000003,1660.1750000000002,1440.45,1096.9750000000001]
[21,null,2280.8500000000004,1998.7000000000003,1660.1750000000002,1440.45,1096.9750000000001]
[22,null,2280.8500000000004,1998.7000000000003,1660.1750000000002,1440.45,1096.9750000000001]
[23,null,2280.8500000000004,1998.7000000000003,1660.1750000000002,1440.45,1096.9750000000001]
[24,null,2280.8500000000004,1998.7000000000003,1660.1750000000002,1440.45,1096.9750000000001]
[25,null,2436.7750000000001,2135.65,1763.3000000000002,1529.0000000000002,1165.1750000000002]
[26,null,2436.7750000000001,2135.65,1763.3000000000002,1529.0000000000002,1165.1750000000002]
[27,null,2436.7750000000001,2135.65,1763.3000000000002,1529.0000000000002,1165.1750000000002]
[28,null,2436.7750000000001,2135.65,1763.3000000000002,1529.0000000000002,1165.1750000000002]
[29,null,2436.7750000000001,2135.65,1763.3000000000002,1529.0000000000002,1165.1750000000002]
[30,null,2709.8500000000004,2375.1750000000002,1946.45,1687.4,1285.3500000000001]
[31,null,2709.8500000000004,2375.1750000000002,1946.45,1687.4,1285.3500000000001]
[32,null,2709.8500000000004,2375.1750000000002,1946.45,1687.4,1285.3500000000001]
[33,null,2709.8500000000004,2375.1750000000002,1946.45,1687.4,1285.3500000000001]
[34,null,2709.8500000000004,2375.1750000000002,1946.45,1687.4,1285.3500000000001]
[35,null,3025.0000000000005,2650.7250000000004,2159.8500000000004,1873.0250000000001,1426.7]
[36,null,3025.0000000000005,2650.7250000000004,2159.8500000000004,1873.0250000000001,1426.7]
[37,null,3025.0000000000005,2650.7250000000004,2159.8500000000004,1873.0250000000001,1426.7]
[38,null,3025.0000000000005,2650.7250000000004,2159.8500000000004,1873.0250000000001,1426.7]
[39,null,3025.0000000000005,2650.7250000000004,2159.8500000000004,1873.0250000000001,1426.7]
[40,null,3388.0000000000005,2969.1750000000002,2408.4500000000003,2088.3500000000004,1591.15]
[41,null,3388.0000000000005,2969.1750000000002,2408.4500000000003,2088.3500000000004,1591.15]
[42,null,3388.0000000000005,2969.1750000000002,2408.4500000000003,2088.3500000000004,1591.15]
[43,null,3388.0000000000005,2969.1750000000002,2408.4500000000003,2088.3500000000004,1591.15]
[44,null,3388.0000000000005,2969.1750000000002,2408.4500000000003,2088.3500000000004,1591.15]
[45,null,3791.7000000000003,3323.1000000000004,2687.0250000000001,2329.8000000000002,1774.575]
[46,null,3791.7000000000003,3323.1000000000004,2687.0250000000001,2329.8000000000002,1774.575]
[47,null,3791.7000000000003,3323.1000000000004,2687.0250000000001,2329.8000000000002,1774.575]
[48,null,3791.7000000000003,3323.1000000000004,2687.0250000000001,2329.8000000000002,1774.575]
[49,null,3791.7000000000003,3323.1000000000004,2687.0250000000001,2329.8000000000002,1774.575]
[50,null,4245.1750000000002,3721.3,3001.6250000000005,2603.15,1982.7500000000002]
[51,null,4245.1750000000002,3721.3,3001.6250000000005,2603.15,1982.7500000000002]
[52,null,4245.1750000000002,3721.3,3001.6250000000005,2603.15,1982.7500000000002]
[53,null,4245.1750000000002,3721.3,3001.6250000000005,2603.15,1982.7500000000002]
[54,null,4245.1750000000002,3721.3,3001.6250000000005,2603.15,1982.7500000000002]
[55,null,4745.9500000000007,4160.2000000000007,3351.15,2906.2000000000003,2213.75]
[56,null,4745.9500000000007,4160.2000000000007,3351.15,2906.2000000000003,2213.75]
[57,null,4745.9500000000007,4160.2000000000007,3351.15,2906.2000000000003,2213.75]
[58,null,4745.9500000000007,4160.2000000000007,3351.15,2906.2000000000003,2213.75]
[59,null,4745.9500000000007,4160.2000000000007,3351.15,2906.2000000000003,2213.75]
[60,null,5079.5250000000005,4452.5250000000005,3583.8,3107.5000000000005,2366.9250000000002]
[61,null,5660.05,4961.55,3991.6250000000005,3461.7000000000003,2636.4250000000002]
[62,null,6288.4250000000002,5511.8250000000007,4433.55,3843.9500000000003,2927.65]
[63,null,6963.0000000000009,6103.9000000000005,4909.5750000000007,4257,3242.5250000000001]
[64,null,7686.2500000000009,6736.6750000000002,5419.7000000000007,4699.4750000000004,3579.4]
[65,null,8455.9750000000004,7412.35,5964.7500000000009,5172.4750000000004,3939.9250000000002]
[66,null,9273.8250000000007,8129.0000000000009,6544.1750000000002,5674.6250000000009,{"$f":"G54*$K$3","v":4322.7250000000004}]
[67,null,10138.700000000001,8886.625,7158.8,6207.3,4728.0750000000007]
[68,null,11050.6,9686.3250000000007,7807.2500000000009,6769.9500000000007,5156.8]
[69,null,12010.900000000001,10527.550000000001,8490.9000000000015,7362.85,5608.0750000000007]
[70,null,13017.675000000001,11410.300000000001,9208.1,7984.9000000000005,6081.9000000000005]
[71,null,14072.025000000001,12334.575000000001,9960.7750000000015,8637.4750000000004,6578.8250000000007]
[72,null,15173.95,13300.925000000001,10747.550000000001,9318.9250000000011,7098.3]
[73,null,16323.45,14307.975,11569.525000000001,10031.725,7640.8750000000009]
[74,null,17520.525000000001,15356.550000000001,12425.050000000001,10773.95,8206.2750000000015]
[75,null,18764.350000000002,16447.2,13315.225,11545.875000000002,8794.2250000000004]
[76,null,18764.350000000002,16447.2,13315.225,11545.875000000002,8794.2250000000004]
[77,null,18764.350000000002,16447.2,13315.225,11545.875000000002,8794.2250000000004]
[78,null,18764.350000000002,16447.2,13315.225,11545.875000000002,8794.2250000000004]
[79,null,18764.350000000002,16447.2,13315.225,11545.875000000002,8794.2250000000004]
[80,null,18764.350000000002,16447.2,13315.225,11545.875000000002,8794.2250000000004]
[81,null,18764.350000000002,16447.2,13315.225,11545.875000000002,8794.2250000000004]
[82,null,18764.350000000002,{"$f":"D70*$K$3","v":16447.2},13315.225,11545.875000000002,8794.2250000000004]
[83,null,{"$f":"C71*$K$3","v":18764.350000000002},16447.2,13315.225,11545.875000000002,8794.2250000000004]
[84,"o más",18764.350000000002,16447.2,13315.225,11545.875000000002,8794.2250000000004]
[1,"Hijo",964.15000000000009,845.07500000000005,706.75000000000011,612.97500000000002,466.95000000000005]
[2,"Hijos",1638.1750000000002,1436.325,1201.2,1041.9750000000001,793.65000000000009]
[3,"Hijos o más",2313.0250000000001,2027.3000000000002,1695.65,1470.4250000000002,1120.3500000000001]
[]
["BUPA GLOBAL PREMIER"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C155*$K$3","v":1499.0250000000001},{"$f":"D155*$K$3","v":1359.875},1023.0000000000001,747.17500000000007,0]
[19,null,{"$f":"C156*$K$3","v":1499.0250000000001},1359.875,1023.0000000000001,747.17500000000007,0]
[20,null,1499.0250000000001,1359.875,1023.0000000000001,747.17500000000007,0]
[21,null,1499.0250000000001,1359.875,1023.0000000000001,747.17500000000007,0]
[22,null,1499.0250000000001,1359.875,1023.0000000000001,747.17500000000007,0]
[23,null,1499.0250000000001,1359.875,1023.0000000000001,747.17500000000007,0]
[24,null,1499.0250000000001,1359.875,1023.0000000000001,747.17500000000007,0]
[25,null,1602.15,1453.1000000000001,1081.575,790.35,0]
[26,null,1602.15,1453.1000000000001,1081.575,790.35,0]
[27,null,1602.15,1453.1000000000001,1081.575,790.35,0]
[28,null,1602.15,1453.1000000000001,1081.575,790.35,0]
[29,null,1602.15,1453.1000000000001,1081.575,790.35,0]
[30,null,1781.45,1616.7250000000001,1187.45,867.35,0]
[31,null,1781.45,1616.7250000000001,1187.45,867.35,0]
[32,null,1781.45,1616.7250000000001,1187.45,867.35,0]
[33,null,1781.45,1616.7250000000001,1187.45,867.35,0]
[34,null,1781.45,1616.7250000000001,1187.45,867.35,0]
[35,null,1987.9750000000001,1804.2750000000001,1312.575,958.65000000000009,0]
[36,null,1987.9750000000001,1804.2750000000001,1312.575,958.65000000000009,0]
[37,null,1987.9750000000001,1804.2750000000001,1312.575,958.65000000000009,0]
[38,null,1987.9750000000001,1804.2750000000001,1312.575,958.65000000000009,0]
[39,null,1987.9750000000001,1804.2750000000001,1312.575,958.65000000000009,0]
[40,null,2226.6750000000002,2020.9750000000001,1458.6000000000001,1065.9000000000001,0]
[41,null,2226.6750000000002,2020.9750000000001,1458.6000000000001,1065.9000000000001,0]
[42,null,2226.6750000000002,2020.9750000000001,1458.6000000000001,1065.9000000000001,0]
[43,null,2226.6750000000002,2020.9750000000001,1458.6000000000001,1065.9000000000001,0]
[44,null,2226.6750000000002,2020.9750000000001,1458.6000000000001,1065.9000000000001,0]
[45,null,2491.7750000000001,2261.6000000000004,1623.325,1185.8000000000002,0]
[46,null,2491.7750000000001,2261.6000000000004,1623.325,1185.8000000000002,0]
[47,null,2491.7750000000001,2261.6000000000004,1623.325,1185.8000000000002,0]
[48,null,2491.7750000000001,2261.6000000000004,1623.325,1185.8000000000002,0]
[49,null,2491.7750000000001,2261.6000000000004,1623.325,1185.8000000000002,0]
[50,null,2790.9750000000004,2532.4750000000004,1810.8750000000002,1323.3000000000002,0]
[51,null,2790.9750000000004,2532.4750000000004,1810.8750000000002,1323.3000000000002,0]
[52,null,2790.9750000000004,2532.4750000000004,1810.8750000000002,1323.3000000000002,0]
[53,null,2790.9750000000004,2532.4750000000004,1810.8750000000002,1323.3000000000002,0]
[54,null,2790.9750000000004,2532.4750000000004,1810.8750000000002,1323.3000000000002,0]
[55,null,3119.3250000000003,2831.4,2019.0500000000002,1475.3750000000002,0]
[56,null,3119.3250000000003,2831.4,2019.0500000000002,1475.3750000000002,0]
[57,null,3119.3250000000003,2831.4,2019.0500000000002,1475.3750000000002,0]
[58,null,3119.3250000000003,2831.4,2019.0500000000002,1475.3750000000002,0]
[59,null,3119.3250000000003,2831.4,2019.0500000000002,1475.3750000000002,0]
[60,null,3338.7750000000001,3029.4,2158.2000000000003,1576.575,0]
[61,null,3719.9250000000002,3375.6250000000005,2401.8500000000004,1755.0500000000002,0]
[62,null,4132.4250000000002,3750.7250000000004,2667.7750000000001,1949.2,0]
[63,null,4576.55,4153.3250000000007,2954.05,2157.9250000000002,0]
[64,null,5051.4750000000004,4584.5250000000005,3261.7750000000001,2382.875,0]
[65,null,5557.75,5043.7750000000005,3590.6750000000002,2623.5,0]
[66,null,6095.1,5530.8,3941.0250000000001,2879.2500000000005,0]
[67,null,6663.5250000000005,6047.2500000000009,4312.8250000000007,3151.2250000000004,0]
[68,null,7262.7500000000009,6590.9250000000002,4705.5250000000005,3437.7750000000001,0]
[69,null,7893.8750000000009,7164.0250000000005,5119.6750000000002,3740.55,0]
[70,null,8555.8000000000011,7764.9000000000005,5554.7250000000004,4058.1750000000002,0]
[71,null,9249.0750000000007,8393.2750000000015,6011.7750000000005,4392.0250000000005,0]
[72,null,9972.875,9050.5250000000015,6489.4500000000007,4741.2750000000005,0]
[73,null,10728.025000000001,9736.1,6988.5750000000007,5105.6500000000005,0]
[74,null,11514.800000000001,10449.725,7509.4250000000002,5486.25,0]
[75,null,12332.1,11191.95,8051.1750000000011,5882.2500000000009,0]
[76,null,12332.1,11191.95,8051.1750000000011,5882.2500000000009,0]
[77,null,12332.1,11191.95,8051.1750000000011,5882.2500000000009,0]
[78,null,12332.1,11191.95,8051.1750000000011,5882.2500000000009,0]
[79,null,12332.1,11191.95,8051.1750000000011,5882.2500000000009,0]
[80,null,12332.1,11191.95,8051.1750000000011,5882.2500000000009,0]
[81,null,12332.1,11191.95,8051.1750000000011,5882.2500000000009,0]
[82,null,12332.1,11191.95,8051.1750000000011,{"$f":"F219*$K$3","v":5882.2500000000009},0]
[83,null,{"$f":"C220*$K$3","v":12332.1},11191.95,8051.1750000000011,5882.2500000000009,0]
[84,"o más",12332.1,11191.95,8051.1750000000011,5882.2500000000009,0]
[1,"Hijo",633.6,574.75,438.07500000000005,319.82500000000005,0]
[2,"Hijos",1076.9000000000001,977.62500000000011,743.87500000000011,543.67500000000007,0]
[3,"Hijos o más",1519.9250000000002,1379.4,1050.2250000000001,767.25000000000011,0]
[]
["BUPA GLOBAL SELECT"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ",2000,3500,5000]
[18,null,{"$f":"C305*$K$3","v":950.12500000000011},{"$f":"D305*$K$3","v":911.35},688.32500000000005,502.70000000000005,0]
[19,null,{"$f":"C306*$K$3","v":950.12500000000011},911.35,688.32500000000005,502.70000000000005,0]
[20,null,950.12500000000011,911.35,688.32500000000005,502.70000000000005,0]
[21,null,950.12500000000011,911.35,688.32500000000005,502.70000000000005,0]
[22,null,950.12500000000011,911.35,688.32500000000005,502.70000000000005,0]
[23,null,950.12500000000011,911.35,688.32500000000005,502.70000000000005,0]
[24,null,950.12500000000011,911.35,688.32500000000005,502.70000000000005,0]
[25,null,1024.9250000000002,983.40000000000009,734.80000000000007,536.80000000000007,0]
[26,null,1024.9250000000002,983.40000000000009,734.80000000000007,536.80000000000007,0]
[27,null,1024.9250000000002,983.40000000000009,734.80000000000007,536.80000000000007,0]
[28,null,1024.9250000000002,983.40000000000009,734.80000000000007,536.80000000000007,0]
[29,null,1024.9250000000002,983.40000000000009,734.80000000000007,536.80000000000007,0]
[30,null,1156.375,1109.075,817.02500000000009,596.47500000000002,0]
[31,null,1156.375,1109.075,817.02500000000009,596.47500000000002,0]
[32,null,1156.375,1109.075,817.02500000000009,596.47500000000002,0]
[33,null,1156.375,1109.075,817.02500000000009,596.47500000000002,0]
[34,null,1156.375,1109.075,817.02500000000009,596.47500000000002,0]
[35,null,1308.45,1255.375,914.65000000000009,668.25,0]
[36,null,1308.45,1255.375,914.65000000000009,668.25,0]
[37,null,1308.45,1255.375,914.65000000000009,668.25,0]
[38,null,1308.45,1255.375,914.65000000000009,668.25,0]
[39,null,1308.45,1255.375,914.65000000000009,668.25,0]
[40,null,1483.9,1423.95,1028.7750000000001,751.30000000000007,0]
[41,null,1483.9,1423.95,1028.7750000000001,751.30000000000007,0]
[42,null,1483.9,1423.95,1028.7750000000001,751.30000000000007,0]
[43,null,1483.9,1423.95,1028.7750000000001,751.30000000000007,0]
[44,null,1483.9,1423.95,1028.7750000000001,751.30000000000007,0]
[45,null,1679.7,1611.2250000000001,1158.0250000000001,845.90000000000009,0]
[46,null,1679.7,1611.2250000000001,1158.0250000000001,845.90000000000009,0]
[47,null,1679.7,1611.2250000000001,1158.0250000000001,845.90000000000009,0]
[48,null,1679.7,1611.2250000000001,1158.0250000000001,845.90000000000009,0]
[49,null,1679.7,1611.2250000000001,1158.0250000000001,845.90000000000009,0]
[50,null,1899.9750000000001,1822.7,1304.6000000000001,952.87500000000011,0]
[51,null,1899.9750000000001,1822.7,1304.6000000000001,952.87500000000011,0]
[52,null,1899.9750000000001,1822.7,1304.6000000000001,952.87500000000011,0]
[53,null,1899.9750000000001,1822.7,1304.6000000000001,952.87500000000011,0]
[54,null,1899.9750000000001,1822.7,1304.6000000000001,952.87500000000011,0]
[55,null,2143.0750000000003,2056.1750000000002,1467.95,1072.2250000000001,0]
[56,null,2143.0750000000003,2056.1750000000002,1467.95,1072.2250000000001,0]
[57,null,2143.0750000000003,2056.1750000000002,1467.95,1072.2250000000001,0]
[58,null,2143.0750000000003,2056.1750000000002,1467.95,1072.2250000000001,0]
[59,null,2143.0750000000003,2056.1750000000002,1467.95,1072.2250000000001,0]
[60,null,2304.7750000000001,2211.2750000000001,1577.6750000000002,1151.7,0]
[61,null,2587.2000000000003,2482.15,1769.075,1291.95,0]
[62,null,2892.4500000000003,2775.3,1977.5250000000001,1443.7500000000002,0]
[63,null,3221.3500000000004,3091.0000000000005,2202.4750000000004,1608.2,0]
[64,null,3573.0750000000003,3428.7000000000003,2443.9250000000002,1784.7500000000002,0]
[65,null,3948.7250000000004,3788.9500000000003,2702.9750000000004,1973.9500000000003,0]
[66,null,4347.2000000000007,4171.2000000000007,2978.2500000000005,2174.7000000000003,0]
[67,null,4769.3250000000007,4575.7250000000004,3270.0250000000001,2388.1000000000004,0]
[68,null,5214.55,5002.8,3578.5750000000003,2613.3250000000003,0]
[69,null,5682.3250000000007,5452.1500000000005,3904.4500000000003,2851.2000000000003,0]
[70,null,6174.0250000000005,5923.7750000000005,4246.8250000000007,3100.9,0]
[71,null,6688.55,6417.4000000000005,4606.5250000000005,3363.5250000000001,0]
[72,null,7227.0000000000009,6933.85,4981.9000000000005,3638.2500000000005,0]
[73,null,7788.0000000000009,7472.0250000000005,5374.6,3924.5250000000001,0]
[74,null,8372.1,8033.3000000000011,5783.5250000000005,4223.4500000000007,0]
[75,null,8979.85,8616.3000000000011,6210.3250000000007,4535.0250000000005,0]
[76,null,8979.85,8616.3000000000011,6210.3250000000007,4535.0250000000005,0]
[77,null,8979.85,8616.3000000000011,6210.3250000000007,4535.0250000000005,0]
[78,null,8979.85,8616.3000000000011,6210.3250000000007,4535.0250000000005,0]
[79,null,8979.85,8616.3000000000011,6210.3250000000007,4535.0250000000005,0]
[80,null,8979.85,8616.3000000000011,6210.3250000000007,4535.0250000000005,0]
[81,null,8979.85,8616.3000000000011,6210.3250000000007,4535.0250000000005,0]
[82,null,8979.85,8616.3000000000011,6210.3250000000007,{"$f":"F369*$K$3","v":4535.0250000000005},0]
[83,null,{"$f":"C370*$K$3","v":8979.85},8616.3000000000011,6210.3250000000007,4535.0250000000005,0]
[84,"o más",8979.85,8616.3000000000011,6210.3250000000007,4535.0250000000005,0]
[1,"Hijo",443.3,425.42500000000001,325.875,238.15,0]
[2,"Hijos",752.95,722.42500000000007,553.30000000000007,404.25000000000006,0]
[3,"Hijos o más",1063.1500000000001,1019.7,781.00000000000011,570.35,0]
[]
["BUPA GLOBAL ULTIMATE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",0,1000,2000]
[18,null,19233,12409,null,null,null,null,true,true]
[19,null,19233,12409]
[20,null,19233,12409]
[21,null,19233,12409]
[22,null,19233,12409]
[23,null,19233,12409]
[24,null,19233,12409]
[25,null,20619,13303,null,null,null,null,true,true]
[26,null,20619,13303]
[27,null,20619,13303]
[28,null,20619,13303]
[29,null,20619,13303]
[30,null,23010,14848,null,null,null,null,true,true]
[31,null,23010,14848]
[32,null,23010,14848]
[33,null,23010,14848]
[34,null,23010,14848]
[35,null,25738,16606,null,null,null,null,true,true]
[36,null,25738,16606]
[37,null,25738,16606]
[38,null,25738,16606]
[39,null,25738,16606]
[40,null,28850,18616,null,null,null,null,true,true]
[41,null,28850,18616]
[42,null,28850,18616]
[43,null,28850,18616]
[44,null,28850,18616]
[45,null,32288,20833,null,null,null,null,true,true]
[46,null,32288,20833]
[47,null,32288,20833]
[48,null,32288,20833]
[49,null,32288,20833]
[50,null,36133,23312,null,null,null,null,true,true]
[51,null,36133,23312]
[52,null,36133,23312]
[53,null,36133,23312]
[54,null,36133,23312]
[55,null,40352,26037,null,null,null,null,true,true]
[56,null,40352,26037]
[57,null,40352,26037]
[58,null,40352,26037]
[59,null,40352,26037]
[60,null,43153,27843,null,null,null,null,true,true]
[61,null,48015,30980,null,null,null,null,true,true]
[62,null,53260,34364,null,null,null,null,true,true]
[63,null,58888,37994,null,null,null,null,true,true]
[64,null,64897,41869,null,null,null,null,true,true]
[65,null,71288,45994,null,null,null,null,true,true]
[66,null,78060,50360,null,null,null,null,true,true]
[67,null,85213,54978,null,null,null,null,true,true]
[68,null,92746,59838,null,null,null,null,true,true]
[69,null,100661,64944,null,null,null,null,true,true]
[70,null,108959,70299,null,null,null,null,true,true]
[71,null,117639,75898,null,null,null,null,true,true]
[72,null,126699,81742,null,null,null,null,true,true]
[73,null,136144,87834,null,null,null,null,true,true]
[74,null,145963,94170,null,null,null,null,true,true]
[75,null,156168,100757,null,null,null,null,true,true]
[76,null,156168,100757]
[77,null,156168,100757]
[78,null,156168,100757]
[79,null,156168,100757]
[80,null,156168,100757]
[81,null,156168,100757]
[82,null,156168,100757]
[83,null,156168,100757]
[84,"o más",156168,100757]
[1,"Hijo",8090,5221,null,null,null,null,true,true]
[2,"Hijos",13752,8874,null,null,null,null,true,true]
[3,"Hijos o más",19412,12528,null,null,null,null,true,true]
[]
["BUPA GLOBAL ULTIMATE - MENSUALES"]
["EDAD"]
[" "," ",0,1000,2000]
[18,null,{"$f":"C905*$K$2","v":1795.0800000000002},{"$f":"D905*$K$2","v":1158.1733333333334},0,0,0]
[19,null,{"$f":"C906*$K$2","v":1795.0800000000002},1158.1733333333334,0,0,0]
[20,null,1795.0800000000002,1158.1733333333334,0,0,0]
[21,null,1795.0800000000002,1158.1733333333334,0,0,0]
[22,null,1795.0800000000002,1158.1733333333334,0,0,0]
[23,null,1795.0800000000002,1158.1733333333334,0,0,0]
[24,null,1795.0800000000002,1158.1733333333334,0,0,0]
[25,null,1924.44,1241.6133333333335,0,0,0]
[26,null,1924.44,1241.6133333333335,0,0,0]
[27,null,1924.44,1241.6133333333335,0,0,0]
[28,null,1924.44,1241.6133333333335,0,0,0]
[29,null,1924.44,1241.6133333333335,0,0,0]
[30,null,2147.6,1385.8133333333335,0,0,0]
[31,null,2147.6,1385.8133333333335,0,0,0]
[32,null,2147.6,1385.8133333333335,0,0,0]
[33,null,2147.6,1385.8133333333335,0,0,0]
[34,null,2147.6,1385.8133333333335,0,0,0]
[35,null,2402.2133333333336,1549.8933333333334,0,0,0]
[36,null,2402.2133333333336,1549.8933333333334,0,0,0]
[37,null,2402.2133333333336,1549.8933333333334,0,0,0]
[38,null,2402.2133333333336,1549.8933333333334,0,0,0]
[39,null,2402.2133333333336,1549.8933333333334,0,0,0]
[40,null,2692.666666666667,1737.4933333333333,0,0,0]
[41,null,2692.666666666667,1737.4933333333333,0,0,0]
[42,null,2692.666666666667,1737.4933333333333,0,0,0]
[43,null,2692.666666666667,1737.4933333333333,0,0,0]
[44,null,2692.666666666667,1737.4933333333333,0,0,0]
[45,null,3013.5466666666666,1944.4133333333334,0,0,0]
[46,null,3013.5466666666666,1944.4133333333334,0,0,0]
[47,null,3013.5466666666666,1944.4133333333334,0,0,0]
[48,null,3013.5466666666666,1944.4133333333334,0,0,0]
[49,null,3013.5466666666666,1944.4133333333334,0,0,0]
[50,null,3372.4133333333334,2175.7866666666669,0,0,0]
[51,null,3372.4133333333334,2175.7866666666669,0,0,0]
[52,null,3372.4133333333334,2175.7866666666669,0,0,0]
[53,null,3372.4133333333334,2175.7866666666669,0,0,0]
[54,null,3372.4133333333334,2175.7866666666669,0,0,0]
[55,null,3766.186666666667,2430.12,0,0,0]
[56,null,3766.186666666667,2430.12,0,0,0]
[57,null,3766.186666666667,2430.12,0,0,0]
[58,null,3766.186666666667,2430.12,0,0,0]
[59,null,3766.186666666667,2430.12,0,0,0]
[60,null,4027.6133333333337,2598.6800000000003,0,0,0]
[61,null,4481.4000000000005,2891.4666666666667,0,0,0]
[62,null,4970.9333333333334,3207.3066666666668,0,0,0]
[63,null,5496.2133333333331,3546.106666666667,0,0,0]
[64,null,6057.0533333333333,3907.7733333333335,0,0,0]
[65,null,6653.5466666666671,4292.7733333333335,0,0,0]
[66,null,7285.6,4700.2666666666673,0,0,0]
[67,null,7953.213333333334,5131.2800000000007,0,0,0]
[68,null,8656.2933333333331,5584.88,0,0,0]
[69,null,9395.0266666666666,6061.4400000000005,0,0,0]
[70,null,10169.506666666668,6561.2400000000007,0,0,0]
[71,null,10979.640000000001,7083.8133333333335,0,0,0]
[72,null,11825.24,7629.253333333334,0,0,0]
[73,null,12706.773333333334,8197.84,0,0,0]
[74,null,13623.213333333333,8789.2000000000007,0,0,0]
[75,null,14575.68,9403.9866666666676,0,0,0]
[76,null,14575.68,9403.9866666666676,0,0,0]
[77,null,14575.68,9403.9866666666676,0,0,0]
[78,null,14575.68,9403.9866666666676,0,0,0]
[79,null,14575.68,9403.9866666666676,0,0,0]
[80,null,14575.68,9403.9866666666676,0]
[81,null,14575.68,9403.9866666666676,0]
[82,null,14575.68,9403.9866666666676,0]
[83,null,{"$f":"C970*$K$2","v":14575.68},9403.9866666666676,0]
[84,"o más",14575.68,9403.9866666666676,0,0,0]
[1,"Hijo",755.06666666666672,487.29333333333335,0,0,0]
[2,"Hijos",1283.52,828.24,0,0,0]
[3,"Hijos o más",1811.7866666666669,1169.28,0,0,0]
[]
["BUPA GLOBAL ULTIMATE"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ",0,1000,2000]
[18,null,{"$f":"C905*$K$3","v":5289.0750000000007},{"$f":"D905*$K$3","v":3412.4750000000004},0,42.555333333333337,0]
[19,null,{"$f":"C906*$K$3","v":5289.0750000000007},3412.4750000000004,0,42.555333333333337,0]
[20,null,5289.0750000000007,3412.4750000000004,0,42.555333333333337,0]
[21,null,5289.0750000000007,3412.4750000000004,0,42.555333333333337,0]
[22,null,5289.0750000000007,3412.4750000000004,0,42.555333333333337,0]
[23,null,5289.0750000000007,3412.4750000000004,0,42.555333333333337,0]
[24,null,5289.0750000000007,3412.4750000000004,0,45.430000000000007,0]
[25,null,5670.2250000000004,3658.3250000000003,0,45.430000000000007,0]
[26,null,5670.2250000000004,3658.3250000000003,0,45.430000000000007,0]
[27,null,5670.2250000000004,3658.3250000000003,0,45.430000000000007,0]
[28,null,5670.2250000000004,3658.3250000000003,0,45.430000000000007,0]
[29,null,5670.2250000000004,3658.3250000000003,0,50.486333333333341,0]
[30,null,6327.7500000000009,4083.2000000000003,0,50.486333333333341,0]
[31,null,6327.7500000000009,4083.2000000000003,0,50.486333333333341,0]
[32,null,6327.7500000000009,4083.2000000000003,0,50.486333333333341,0]
[33,null,6327.7500000000009,4083.2000000000003,0,50.486333333333341,0]
[34,null,6327.7500000000009,4083.2000000000003,0,56.56933333333334,0]
[35,null,7077.9500000000007,4566.6500000000005,0,56.56933333333334,0]
[36,null,7077.9500000000007,4566.6500000000005,0,56.56933333333334,0]
[37,null,7077.9500000000007,4566.6500000000005,0,56.56933333333334,0]
[38,null,7077.9500000000007,4566.6500000000005,0,56.56933333333334,0]
[39,null,7077.9500000000007,4566.6500000000005,0,63.602000000000004,0]
[40,null,7933.7500000000009,5119.4000000000005,0,63.602000000000004,0]
[41,null,7933.7500000000009,5119.4000000000005,0,63.602000000000004,0]
[42,null,7933.7500000000009,5119.4000000000005,0,63.602000000000004,0]
[43,null,7933.7500000000009,5119.4000000000005,0,63.602000000000004,0]
[44,null,7933.7500000000009,5119.4000000000005,0,71.610000000000014,0]
[45,null,8879.2000000000007,5729.0750000000007,0,71.610000000000014,0]
[46,null,8879.2000000000007,5729.0750000000007,0,71.610000000000014,0]
[47,null,8879.2000000000007,5729.0750000000007,0,71.610000000000014,0]
[48,null,8879.2000000000007,5729.0750000000007,0,71.610000000000014,0]
[49,null,8879.2000000000007,5729.0750000000007,0,80.670333333333346,0]
[50,null,9936.5750000000007,6410.8,0,80.670333333333346,0]
[51,null,9936.5750000000007,6410.8,0,80.670333333333346,0]
[52,null,9936.5750000000007,6410.8,0,80.670333333333346,0]
[53,null,9936.5750000000007,6410.8,0,80.670333333333346,0]
[54,null,9936.5750000000007,6410.8,0,90.757333333333349,0]
[55,null,11096.800000000001,7160.1750000000002,0,90.757333333333349,0]
[56,null,11096.800000000001,7160.1750000000002,0,90.757333333333349,0]
[57,null,11096.800000000001,7160.1750000000002,0,90.757333333333349,0]
[58,null,11096.800000000001,7160.1750000000002,0,90.757333333333349,0]
[59,null,11096.800000000001,7160.1750000000002,0,97.533333333333346,0]
[60,null,11867.075000000001,7656.8250000000007,0,109.39133333333335,0]
[61,null,13204.125000000002,8519.5,0,122.25033333333334,0]
[62,null,14646.500000000002,9450.1,0,136.16166666666669,0]
[63,null,16194.2,10448.35,0,151.12533333333337,0]
[64,null,17846.675000000003,11513.975,0,167.14133333333336,0]
[65,null,19604.2,12648.35,0,184.13266666666669,0]
[66,null,21466.5,13849.000000000002,0,202.20200000000003,0]
[67,null,23433.575000000001,15118.95,0,221.29800000000003,0]
[68,null,25505.15,16455.45,0,241.42066666666668,0]
[69,null,27681.775000000001,17859.600000000002,0,262.59566666666672,0]
[70,null,29963.725000000002,19332.225000000002,0,284.82300000000004,0]
[71,null,32350.725000000002,20871.95,0,308.077,0]
[72,null,34842.225000000006,22479.050000000003,0,332.33200000000005,0]
[73,null,37439.600000000006,24154.350000000002,0,357.63933333333335,0]
[74,null,40139.825000000004,25896.750000000004,0,384.05033333333336,0]
[75,null,42946.200000000004,27708.175000000003,0,384.05033333333336,0]
[76,null,42946.200000000004,27708.175000000003,0,384.05033333333336,0]
[77,null,42946.200000000004,27708.175000000003,0,384.05033333333336,0]
[78,null,42946.200000000004,27708.175000000003,0,384.05033333333336,0]
[79,null,42946.200000000004,27708.175000000003,0,384.05033333333336,0]
[80,null,42946.200000000004,27708.175000000003,0,384.05033333333336,0]
[81,null,42946.200000000004,27708.175000000003,0,384.05033333333336,0]
[82,null,42946.200000000004,27708.175000000003,0,384.05033333333336,0]
[83,null,{"$f":"C970*$K$3","v":42946.200000000004},27708.175000000003,0,384.05033333333336,0]
[84,"o más",42946.200000000004,27708.175000000003,0,20.148333333333333,0]
[1,"Hijo",2224.75,1435.7750000000001,0,34.213666666666668,0]
[2,"Hijos",3781.8,2440.3500000000004,0,48.279000000000003,0]
[3,"Hijos o más",5338.3,3445.2000000000003,0,0,0]
[]
["BUPA GLOBAL MM"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",10000,20000]
[18,null,2241,1737,null,null,null,null,true,true]
[19,null,2241,1737]
[20,null,2241,1737]
[21,null,2241,1737]
[22,null,2241,1737]
[23,null,2241,1737]
[24,null,2241,1737]
[25,null,2398,1844,null,null,null,null,true,true]
[26,null,2398,1844]
[27,null,2398,1844]
[28,null,2398,1844]
[29,null,2398,1844]
[30,null,2671,2037,null,null,null,null,true,true]
[31,null,2671,2037]
[32,null,2671,2037]
[33,null,2671,2037]
[34,null,2671,2037]
[35,null,2987,2269,null,null,null,null,true,true]
[36,null,2987,2269]
[37,null,2987,2269]
[38,null,2987,2269]
[39,null,2987,2269]
[40,null,3346,2539,null,null,null,null,true,true]
[41,null,3346,2539]
[42,null,3346,2539]
[43,null,3346,2539]
[44,null,3346,2539]
[45,null,3747,2848,null,null,null,null,true,true]
[46,null,3747,2848]
[47,null,3747,2848]
[48,null,3747,2848]
[49,null,3747,2848]
[50,null,4197,3196,null,null,null,null,true,true]
[51,null,4197,3196]
[52,null,4197,3196]
[53,null,4197,3196]
[54,null,4197,3196]
[55,null,4691,3588,null,null,null,null,true,true]
[56,null,4691,3588]
[57,null,4691,3588]
[58,null,4691,3588]
[59,null,4691,3588]
[60,null,5018,3848,null,null,null,null,true,true]
[61,null,5590,4310,null,null,null,null,true,true]
[62,null,6208,4811,null,null,null,null,true,true]
[63,null,6871,5351,null,null,null,null,true,true]
[64,null,7581,5935,null,null,null,null,true,true]
[65,null,8336,6558,null,null,null,null,true,true]
[66,null,9138,7224,null,null,null,null,true,true]
[67,null,9986,7929,null,null,null,null,true,true]
[68,null,10879,8677,null,null,null,null,true,true]
[69,null,11817,9464,null,null,null,null,true,true]
[70,null,12800,10292,null,null,null,null,true,true]
[71,null,13834,11162,null,null,null,null,true,true]
[72,null,14911,12074,null,null,null,null,true,true]
[73,null,16034,13026,null,null,null,null,true,true]
[74,null,17202,14019,null,null,null,null,true,true]
[75,null,18417,15054,null,null,null,null,true,true]
[76,null,18417,15054]
[77,null,18417,15054]
[78,null,18417,15054]
[79,null,18417,15054]
[80,null,18417,15054]
[81,null,18417,15054]
[82,null,18417,15054]
[83,null,18417,15054]
[84,"o más",18417,15054]
[1,"Hijo",946,743,null,null,null,null,true,true]
[2,"Hijos",1606,1262,null,null,null,null,true,true]
[3,"Hijos o más",2269,1780,null,null,null,null,true,true]
[]
["BUPA GLOBAL MM - MENSUALES"]
["EDAD"]
[" "," ",10000,20000]
[18,null,{"$f":"C1129*$K$2","v":209.16},{"$f":"D1129*$K$2","v":162.12},0,0,0]
[19,null,{"$f":"C1130*$K$2","v":209.16},162.12,0,0,0]
[20,null,209.16,162.12,0,0,0]
[21,null,209.16,162.12,0,0,0]
[22,null,209.16,162.12,0,0,0]
[23,null,209.16,162.12,0,0,0]
[24,null,209.16,162.12,0,0,0]
[25,null,223.81333333333333,172.10666666666668,0,0,0]
[26,null,223.81333333333333,172.10666666666668,0,0,0]
[27,null,223.81333333333333,172.10666666666668,0,0,0]
[28,null,223.81333333333333,172.10666666666668,0,0,0]
[29,null,223.81333333333333,172.10666666666668,0,0,0]
[30,null,249.29333333333335,190.12,0,0,0]
[31,null,249.29333333333335,190.12,0,0,0]
[32,null,249.29333333333335,190.12,0,0,0]
[33,null,249.29333333333335,190.12,0,0,0]
[34,null,249.29333333333335,190.12,0,0,0]
[35,null,278.78666666666669,211.77333333333334,0,0,0]
[36,null,278.78666666666669,211.77333333333334,0,0,0]
[37,null,278.78666666666669,211.77333333333334,0,0,0]
[38,null,278.78666666666669,211.77333333333334,0,0,0]
[39,null,278.78666666666669,211.77333333333334,0,0,0]
[40,null,312.29333333333335,236.97333333333336,0,0,0]
[41,null,312.29333333333335,236.97333333333336,0,0,0]
[42,null,312.29333333333335,236.97333333333336,0,0,0]
[43,null,312.29333333333335,236.97333333333336,0,0,0]
[44,null,312.29333333333335,236.97333333333336,0,0,0]
[45,null,349.72,265.81333333333333,0,0,0]
[46,null,349.72,265.81333333333333,0,0,0]
[47,null,349.72,265.81333333333333,0,0,0]
[48,null,349.72,265.81333333333333,0,0,0]
[49,null,349.72,265.81333333333333,0,0,0]
[50,null,391.72,298.29333333333335,0,0,0]
[51,null,391.72,298.29333333333335,0,0,0]
[52,null,391.72,298.29333333333335,0,0,0]
[53,null,391.72,298.29333333333335,0,0,0]
[54,null,391.72,298.29333333333335,0,0,0]
[55,null,437.82666666666671,334.88,0,0,0]
[56,null,437.82666666666671,334.88,0,0,0]
[57,null,437.82666666666671,334.88,0,0,0]
[58,null,437.82666666666671,334.88,0,0,0]
[59,null,437.82666666666671,334.88,0,0,0]
[60,null,468.34666666666669,359.1466666666667,0,0,0]
[61,null,521.73333333333335,402.26666666666671,0,0,0]
[62,null,579.41333333333341,449.0266666666667,0,0,0]
[63,null,641.29333333333341,499.42666666666668,0,0,0]
[64,null,707.56000000000006,553.93333333333339,0,0,0]
[65,null,778.02666666666676,612.08000000000004,0,0,0]
[66,null,852.88,674.24,0,0,0]
[67,null,932.02666666666676,740.04000000000008,0,0,0]
[68,null,1015.3733333333333,809.85333333333335,0,0,0]
[69,null,1102.92,883.30666666666673,0,0,0]
[70,null,1194.6666666666667,960.5866666666667,0,0,0]
[71,null,1291.1733333333334,1041.7866666666666,0,0,0]
[72,null,1391.6933333333334,1126.9066666666668,0,0,0]
[73,null,1496.5066666666667,1215.76,0,0,0]
[74,null,1605.52,1308.44,0,0,0]
[75,null,1718.92,1405.04,0,0,0]
[76,null,1718.92,1405.04,0,0,0]
[77,null,1718.92,1405.04,0,0,0]
[78,null,1718.92,1405.04,0,0,0]
[79,null,1718.92,1405.04,0,0,0]
[80,null,1718.92,1405.04,0]
[81,null,1718.92,1405.04,0]
[82,null,1718.92,1405.04,0]
[83,null,{"$f":"C1194*$K$2","v":1718.92},1405.04,0]
[84,"o más",1718.92,1405.04,0,0,0]
[1,"Hijo",88.293333333333337,69.346666666666664,0,0,0]
[2,"Hijos",149.89333333333335,117.78666666666668,0,0,0]
[3,"Hijos o más",211.77333333333334,166.13333333333335,0,0,0]
[]
["BUPA GLOBAL MM"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ",10000,20000]
[18,null,{"$f":"C1129*$K$3","v":616.27500000000009},{"$f":"D1129*$K$3","v":477.67500000000001},0,0,0]
[19,null,{"$f":"C1130*$K$3","v":616.27500000000009},477.67500000000001,0,241.65350000000001,0]
[20,null,616.27500000000009,477.67500000000001,0,241.65350000000001,0]
[21,null,616.27500000000009,477.67500000000001,0,241.65350000000001,0]
[22,null,616.27500000000009,477.67500000000001,0,241.65350000000001,0]
[23,null,616.27500000000009,477.67500000000001,0,241.65350000000001,0]
[24,null,616.27500000000009,477.67500000000001,0,241.65350000000001,0]
[25,null,659.45,507.1,0,241.65350000000001,0]
[26,null,659.45,507.1,0,257.97750000000002,0]
[27,null,659.45,507.1,0,257.97750000000002,0]
[28,null,659.45,507.1,0,257.97750000000002,0]
[29,null,659.45,507.1,0,257.97750000000002,0]
[30,null,734.52500000000009,560.17500000000007,0,257.97750000000002,0]
[31,null,734.52500000000009,560.17500000000007,0,286.69025000000005,0]
[32,null,734.52500000000009,560.17500000000007,0,286.69025000000005,0]
[33,null,734.52500000000009,560.17500000000007,0,286.69025000000005,0]
[34,null,734.52500000000009,560.17500000000007,0,286.69025000000005,0]
[35,null,821.42500000000007,623.97500000000002,0,286.69025000000005,0]
[36,null,821.42500000000007,623.97500000000002,0,321.23300000000006,0]
[37,null,821.42500000000007,623.97500000000002,0,321.23300000000006,0]
[38,null,821.42500000000007,623.97500000000002,0,321.23300000000006,0]
[39,null,821.42500000000007,623.97500000000002,0,321.23300000000006,0]
[40,null,920.15000000000009,698.22500000000002,0,321.23300000000006,0]
[41,null,920.15000000000009,698.22500000000002,0,361.16850000000005,0]
[42,null,920.15000000000009,698.22500000000002,0,361.16850000000005,0]
[43,null,920.15000000000009,698.22500000000002,0,361.16850000000005,0]
[44,null,920.15000000000009,698.22500000000002,0,361.16850000000005,0]
[45,null,1030.4250000000002,783.2,0,361.16850000000005,0]
[46,null,1030.4250000000002,783.2,0,406.64250000000004,0]
[47,null,1030.4250000000002,783.2,0,406.64250000000004,0]
[48,null,1030.4250000000002,783.2,0,406.64250000000004,0]
[49,null,1030.4250000000002,783.2,0,406.64250000000004,0]
[50,null,1154.1750000000002,878.90000000000009,0,406.64250000000004,0]
[51,null,1154.1750000000002,878.90000000000009,0,458.09225000000009,0]
[52,null,1154.1750000000002,878.90000000000009,0,458.09225000000009,0]
[53,null,1154.1750000000002,878.90000000000009,0,458.09225000000009,0]
[54,null,1154.1750000000002,878.90000000000009,0,458.09225000000009,0]
[55,null,1290.0250000000001,986.7,0,458.09225000000009,0]
[56,null,1290.0250000000001,986.7,0,515.37200000000007,0]
[57,null,1290.0250000000001,986.7,0,515.37200000000007,0]
[58,null,1290.0250000000001,986.7,0,515.37200000000007,0]
[59,null,1290.0250000000001,986.7,0,515.37200000000007,0]
[60,null,1379.95,1058.2,0,515.37200000000007,0]
[61,null,1537.2500000000002,1185.25,0,553.85,0]
[62,null,1707.2,1323.0250000000001,0,621.18650000000014,0]
[63,null,1889.5250000000001,1471.5250000000001,0,694.20725000000016,0]
[64,null,2084.7750000000001,1632.1250000000002,0,773.20375000000013,0]
[65,null,2292.4,1803.45,0,858.17600000000016,0]
[66,null,2512.9500000000003,1986.6000000000001,0,949.12400000000014,0]
[67,null,2746.15,2180.4750000000004,0,1045.6105000000002,0]
[68,null,2991.7250000000004,2386.1750000000002,0,1148.2185000000002,0]
[69,null,3249.6750000000002,2602.6000000000004,0,1256.6565000000001,0]
[70,null,3520.0000000000005,2830.3,0,1370.9245000000001,0]
[71,null,3804.3500000000004,3069.55,0,1491.1682500000002,0]
[72,null,4100.5250000000005,3320.3500000000004,0,1617.3877500000001,0]
[73,null,4409.3500000000004,3582.15,0,1749.4372500000002,0]
[74,null,4730.55,3855.2250000000004,0,1887.1710000000003,0]
[75,null,5064.6750000000002,4139.8500000000004,0,2030.8805000000002,0]
[76,null,5064.6750000000002,4139.8500000000004,0,2180.8572500000005,0]
[77,null,5064.6750000000002,4139.8500000000004,0,2180.8572500000005,0]
[78,null,5064.6750000000002,4139.8500000000004,0,2180.8572500000005,0]
[79,null,5064.6750000000002,4139.8500000000004,0,2180.8572500000005,0]
[80,null,5064.6750000000002,4139.8500000000004,0,2180.8572500000005,0]
[81,null,5064.6750000000002,4139.8500000000004,0,2180.8572500000005,0]
[82,null,5064.6750000000002,4139.8500000000004,0,2180.8572500000005,0]
[83,null,{"$f":"C1194*$K$3","v":5064.6750000000002},4139.8500000000004,0,2180.8572500000005,0]
[84,"o más",5064.6750000000002,4139.8500000000004,0,2180.8572500000005,0]
[1,"Hijo",260.15000000000003,204.32500000000002,0,2180.8572500000005,0]
[2,"Hijos",441.65000000000003,347.05,0,114.41375000000001,0]
[3,"Hijos o más",623.97500000000002,489.50000000000006,0,194.28475000000003,0]
[]
["BUPA GLOBAL MM"]
["TARIFAS SEMESTRAL"]
["EDAD"]
[" "," ",10000,20000]
[18,null,{"$f":"C1129*$K$4","v":1187.73},{"$f":"D1129*$K$4","v":920.61},0,0,0]
[19,null,{"$f":"C1130*$K$4","v":1187.73},920.61,0,343.26187500000009,266.20000000000005]
[20,null,1187.73,920.61,0,343.26187500000009,266.20000000000005]
[21,null,1187.73,920.61,0,343.26187500000009,266.20000000000005]
[22,null,1187.73,920.61,0,343.26187500000009,266.20000000000005]
[23,null,1187.73,920.61,0,343.26187500000009,266.20000000000005]
[24,null,1187.73,920.61,0,343.26187500000009,266.20000000000005]
[25,null,1270.94,977.32,0,343.26187500000009,266.20000000000005]
[26,null,1270.94,977.32,0,364.43687500000004,282.68625000000003]
[27,null,1270.94,977.32,0,364.43687500000004,282.68625000000003]
[28,null,1270.94,977.32,0,364.43687500000004,282.68625000000003]
[29,null,1270.94,977.32,0,364.43687500000004,282.68625000000003]
[30,null,1415.63,1079.6100000000001,0,364.43687500000004,282.68625000000003]
[31,null,1415.63,1079.6100000000001,0,402.17375000000004,311.953125]
[32,null,1415.63,1079.6100000000001,0,402.17375000000004,311.953125]
[33,null,1415.63,1079.6100000000001,0,402.17375000000004,311.953125]
[34,null,1415.63,1079.6100000000001,0,402.17375000000004,311.953125]
[35,null,1583.1100000000001,1202.5700000000002,0,402.17375000000004,311.953125]
[36,null,1583.1100000000001,1202.5700000000002,0,446.41437500000006,346.21125000000006]
[37,null,1583.1100000000001,1202.5700000000002,0,446.41437500000006,346.21125000000006]
[38,null,1583.1100000000001,1202.5700000000002,0,446.41437500000006,346.21125000000006]
[39,null,1583.1100000000001,1202.5700000000002,0,446.41437500000006,346.21125000000006]
[40,null,1773.38,1345.67,0,446.41437500000006,346.21125000000006]
[41,null,1773.38,1345.67,0,497.76375000000007,386.14125000000007]
[42,null,1773.38,1345.67,0,497.76375000000007,386.14125000000007]
[43,null,1773.38,1345.67,0,497.76375000000007,386.14125000000007]
[44,null,1773.38,1345.67,0,497.76375000000007,386.14125000000007]
[45,null,1985.91,1509.44,0,497.76375000000007,386.14125000000007]
[46,null,1985.91,1509.44,0,555.31437500000015,430.6843750000001]
[47,null,1985.91,1509.44,0,555.31437500000015,430.6843750000001]
[48,null,1985.91,1509.44,0,555.31437500000015,430.6843750000001]
[49,null,1985.91,1509.44,0,555.31437500000015,430.6843750000001]
[50,null,2224.4100000000003,1693.88,0,555.31437500000015,430.6843750000001]
[51,null,2224.4100000000003,1693.88,0,620.42750000000012,481.20187500000003]
[52,null,2224.4100000000003,1693.88,0,620.42750000000012,481.20187500000003]
[53,null,2224.4100000000003,1693.88,0,620.42750000000012,481.20187500000003]
[54,null,2224.4100000000003,1693.88,0,620.42750000000012,481.20187500000003]
[55,null,2486.23,1901.64,0,620.42750000000012,481.20187500000003]
[56,null,2486.23,1901.64,0,692.72500000000002,537.24000000000012]
[57,null,2486.23,1901.64,0,692.72500000000002,537.24000000000012]
[58,null,2486.23,1901.64,0,692.72500000000002,537.24000000000012]
[59,null,2486.23,1901.64,0,692.72500000000002,537.24000000000012]
[60,null,2659.54,2039.44,0,692.72500000000002,537.24000000000012]
[61,null,2962.7000000000003,2284.3000000000002,0,740.74687500000005,574.4475000000001]
[62,null,3290.2400000000002,2549.83,0,825.14437500000008,639.86312500000008]
[63,null,3641.63,2836.03,0,916.27250000000015,710.5725000000001]
[64,null,4017.9300000000003,3145.55,0,1014.7362500000002,786.95375000000013]
[65,null,4418.08,3475.7400000000002,0,1120.2331250000002,868.70437500000014]
[66,null,4843.1400000000003,3828.7200000000003,0,1232.9143750000003,956.20250000000021]
[67,null,5292.58,4202.37,0,1352.7043750000003,1049.1456250000001]
[68,null,5765.87,4598.8100000000004,0,1479.6787500000003,1147.5337500000003]
[69,null,6263.01,5015.92,0,1613.7618750000001,1251.59375]
[70,null,6784,5454.76,0,1755.1050000000002,1361.1743750000003]
[71,null,7332.02,5915.8600000000006,0,1903.4056250000003,1476.1243750000003]
[72,null,7902.8300000000008,6399.22,0,2058.9662500000004,1596.7462500000001]
[73,null,8498.02,6903.7800000000007,0,2221.4087500000001,1722.8131250000004]
[74,null,9117.0600000000013,7430.0700000000006,0,2391.3381250000007,1854.5518750000003]
[75,null,9761.01,7978.6200000000008,0,2568.3006250000008,1991.7356250000003]
[76,null,9761.01,7978.6200000000008,0,2752.2962500000003,2134.44]
[77,null,9761.01,7978.6200000000008,0,2752.2962500000003,2134.44]
[78,null,9761.01,7978.6200000000008,0,2752.2962500000003,2134.44]
[79,null,9761.01,7978.6200000000008,0,2752.2962500000003,2134.44]
[80,null,9761.01,7978.6200000000008,0,2752.2962500000003,2134.44]
[81,null,9761.01,7978.6200000000008,0,2752.2962500000003,2134.44]
[82,null,9761.01,7978.6200000000008,0,2752.2962500000003,2134.44]
[83,null,{"$f":"C1194*$K$4","v":9761.01},7978.6200000000008,0,2752.2962500000003,2134.44]
[84,"o más",9761.01,7978.6200000000008,0,2752.2962500000003,2134.44]
[1,"Hijo",501.38000000000005,393.79,0,2752.2962500000003,2134.44]
[2,"Hijos",851.18000000000006,668.86,0,146.10750000000004,113.28625000000002]
[3,"Hijos o más",1202.5700000000002,943.40000000000009,0,248.35250000000002,192.54125000000005]
[]
["BUPA GLOBAL ULTIMATE"]
["TARIFAS SEMESTRALES"]
["EDAD"]
[" "," ",0,1000,2000]
[18,null,{"$f":"C905*$K$4","v":10193.49},{"$f":"D905*$K$4","v":6576.77},0,0,0]
[19,null,{"$f":"C906*$K$4","v":10193.49},6576.77,0,181.34875000000002,0]
[20,null,10193.49,6576.77,0,181.34875000000002,0]
[21,null,10193.49,6576.77,0,181.34875000000002,0]
[22,null,10193.49,6576.77,0,181.34875000000002,0]
[23,null,10193.49,6576.77,0,181.34875000000002,0]
[24,null,10193.49,6576.77,0,181.34875000000002,0]
[25,null,10928.07,7050.59,0,181.34875000000002,0]
[26,null,10928.07,7050.59,0,191.70937500000002,0]
[27,null,10928.07,7050.59,0,191.70937500000002,0]
[28,null,10928.07,7050.59,0,191.70937500000002,0]
[29,null,10928.07,7050.59,0,191.70937500000002,0]
[30,null,12195.300000000001,7869.4400000000005,0,191.70937500000002,0]
[31,null,12195.300000000001,7869.4400000000005,0,210.46437500000002,0]
[32,null,12195.300000000001,7869.4400000000005,0,210.46437500000002,0]
[33,null,12195.300000000001,7869.4400000000005,0,210.46437500000002,0]
[34,null,12195.300000000001,7869.4400000000005,0,210.46437500000002,0]
[35,null,13641.140000000001,8801.18,0,210.46437500000002,0]
[36,null,13641.140000000001,8801.18,0,232.62250000000003,0]
[37,null,13641.140000000001,8801.18,0,232.62250000000003,0]
[38,null,13641.140000000001,8801.18,0,232.62250000000003,0]
[39,null,13641.140000000001,8801.18,0,232.62250000000003,0]
[40,null,15290.5,9866.4800000000014,0,232.62250000000003,0]
[41,null,15290.5,9866.4800000000014,0,258.63750000000005,0]
[42,null,15290.5,9866.4800000000014,0,258.63750000000005,0]
[43,null,15290.5,9866.4800000000014,0,258.63750000000005,0]
[44,null,15290.5,9866.4800000000014,0,258.63750000000005,0]
[45,null,17112.64,11041.49,0,258.63750000000005,0]
[46,null,17112.64,11041.49,0,287.75312500000001,0]
[47,null,17112.64,11041.49,0,287.75312500000001,0]
[48,null,17112.64,11041.49,0,287.75312500000001,0]
[49,null,17112.64,11041.49,0,287.75312500000001,0]
[50,null,19150.490000000002,12355.36,0,287.75312500000001,0]
[51,null,19150.490000000002,12355.36,0,321.10375000000005,0]
[52,null,19150.490000000002,12355.36,0,321.10375000000005,0]
[53,null,19150.490000000002,12355.36,0,321.10375000000005,0]
[54,null,19150.490000000002,12355.36,0,321.10375000000005,0]
[55,null,21386.560000000001,13799.61,0,321.10375000000005,0]
[56,null,21386.560000000001,13799.61,0,358.00875000000008,0]
[57,null,21386.560000000001,13799.61,0,358.00875000000008,0]
[58,null,21386.560000000001,13799.61,0,358.00875000000008,0]
[59,null,21386.560000000001,13799.61,0,358.00875000000008,0]
[60,null,22871.09,14756.79,0,358.00875000000008,0]
[61,null,25447.95,16419.400000000001,0,382.58687500000008,0]
[62,null,28227.800000000003,18212.920000000002,0,425.92000000000007,0]
[63,null,31210.640000000003,20136.82,0,473.03437500000013,0]
[64,null,34395.410000000003,22190.57,0,523.70312500000011,0]
[65,null,37782.639999999999,24376.82,0,578.30437500000005,0]
[66,null,41371.800000000003,26690.800000000003,0,636.6868750000001,0]
[67,null,45162.89,29138.34,0,698.77500000000009,0]
[68,null,49155.380000000005,31714.140000000003,0,764.79562500000009,0]
[69,null,53350.33,34420.32,0,834.37062500000013,0]
[70,null,57748.270000000004,37258.47,0,907.80250000000012,0]
[71,null,62348.670000000006,40225.94,0,984.94000000000017,0]
[72,null,67150.47,43323.26,0,1066.0100000000002,0]
[73,null,72156.320000000007,46552.020000000004,0,1150.7100000000003,0]
[74,null,77360.39,49910.100000000006,0,1239.1912500000003,0]
[75,null,82769.040000000008,53401.21,0,1331.5293750000001,0]
[76,null,82769.040000000008,53401.21,0,1427.6487500000003,0]
[77,null,82769.040000000008,53401.21,0,1427.6487500000003,0]
[78,null,82769.040000000008,53401.21,0,1427.6487500000003,0]
[79,null,82769.040000000008,53401.21,0,1427.6487500000003,0]
[80,null,82769.040000000008,53401.21,0,1427.6487500000003,0]
[81,null,82769.040000000008,53401.21,0,1427.6487500000003,0]
[82,null,82769.040000000008,53401.21,0,1427.6487500000003,0]
[83,null,{"$f":"C970*$K$4","v":82769.040000000008},53401.21,0,1427.6487500000003,0]
[84,"o más",82769.040000000008,53401.21,0,1427.6487500000003,0]
[1,"Hijo",4287.7,2767.13,0,1427.6487500000003,0]
[2,"Hijos",7288.56,4703.22,0,77.591250000000016,0]
[3,"Hijos o más",10288.36,6639.84,0,131.89000000000001,0]