{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["INGRESO DE DATOS","Complete","Secure","Premium","Bupa Essential Care","Classic Care","Resumen tarifas anuales","Tablas"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":5,"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":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[22,3,22,9],[6,1,6,8],[15,7,15,8],[11,3,11,9],[13,3,13,5],[13,7,13,8]]}
[]
[]
[]
[]
[" "]
[]
[null,"COTIZACIÓN DE SEGURO MÉDICO INTERNACIONAL"]
[null,null,null,null,null,null,null,null,null,null," "]
[]
["INGRESE LOS DATOS DEL PROPUESTO ASEGURADO:"]
[]
[null,null,"Nombre del Asegurado Principal:","Nombre"]
[null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,"Número de Adultos:",null,null,2,"Número de Hijos:",null,2]
[]
[null,null,null,null,null," Edad de Titular:",32,"Edad de Cónyuge:",null,46]
[]
[null,null,null,null,null,"Descuento:",0]
[]
[]
["INGRESE EL NOMBRE DE LA AGENCIA ASESORA:"]
[]
[null,null,"Intermediario:","Agente / Agencia"]
[]
[]
[]
["ESCOJA EL PRODUCTO PARA VISUALIZAR LA COTIZACION RESPECTIVA:"]

{"sheet":"Complete","index":1,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[[7,3,7,9],[8,3,8,9],[9,0,9,1],[40,0,40,1],[35,0,35,1],[30,0,30,1],[28,3,28,9],[39,3,39,9],[11,4,11,9],[13,4,13,9],[15,0,15,1],[21,0,21,1],[23,3,23,9],[64,3,66,9],[51,3,51,9],[72,0,72,1],[73,0,73,1],[71,0,71,1],[63,3,63,9],[55,0,55,1]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Cotización de Seguro Médico Internacional"]
[null,null,null,"Producto: Bupa Complete Care"]
["BUPA COMPLETE CARE"]
[]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$23","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2022-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G18>0,'INGRESO DE DATOS'!G18,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!G14","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":32}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":46}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,"Complicaciones de Maternidad (+ $500,000)"]
[null,null,null,null,null,null,null,false]
[null,null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$6:$H$29,4,TRUE)","v":13182},{"$f":"VLOOKUP($J$18,Tablas!$A$6:$H$29,5,TRUE)","v":9802},{"$f":"VLOOKUP($J$18,Tablas!$A$6:$H$29,6,TRUE)","v":7149},{"$f":"VLOOKUP($J$18,Tablas!$A$6:$H$29,7,TRUE)","v":5322},{"$f":"VLOOKUP($J$18,Tablas!$A$6:$H$29,8,TRUE)","v":4071}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$6:$H$29,4,TRUE)))","v":19113},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$6:$H$29,5,TRUE)))","v":13428},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$6:$H$29,6,TRUE)))","v":9954},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$6:$H$29,7,TRUE)))","v":7353},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$6:$H$29,8,TRUE)))","v":5632}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$30:$H$32,4,TRUE)))","v":6674},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$30:$H$32,5,TRUE)))","v":4862},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$30:$H$32,6,TRUE)))","v":3698},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$30:$H$32,7,TRUE)))","v":3051},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$30:$H$32,8,TRUE)))","v":2272}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($H$23=FALSE,0,Tablas!D$33)","v":0},{"$f":"+IF($H$23=FALSE,0,Tablas!E$33)","v":0},{"$f":"+IF($H$23=FALSE,0,Tablas!F$33)","v":0},{"$f":"+IF($H$23=FALSE,0,Tablas!G$33)","v":0},{"$f":"+IF($H$23=FALSE,0,Tablas!H$33)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F30:F33)","v":38969},{"$f":"SUM(G30:G33)","v":28092},{"$f":"SUM(H30:H33)","v":20801},{"$f":"SUM(I30:I33)","v":15726},{"$f":"SUM(J30:J33)","v":11975}]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F30+F31+F32)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G30+G31+G32)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H30+H31+H32)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I30+I31+I32)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J30+J31+J32)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F34+F35+F36)*12%","v":4685.28},{"$f":"+(G34+G35+G36)*12%","v":3380.04},2505.12,1896.12,{"$f":"+(J34+J35+J36)*12%","v":1446}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F34:F37)","v":43729.279999999999},{"$f":"SUM(G34:G37)","v":31547.040000000001},23381.119999999999,17697.12,{"$f":"SUM(J34:J37)","v":13496}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$39:$H$62,4,TRUE)","v":6986.46},{"$f":"VLOOKUP($J$18,Tablas!$A$39:$H$62,5,TRUE)","v":5195.0600000000004},{"$f":"VLOOKUP($J$18,Tablas!$A$39:$H$62,6,TRUE)","v":3788.9700000000003},{"$f":"VLOOKUP($J$18,Tablas!$A$39:$H$62,7,TRUE)","v":2820.6600000000003},{"$f":"VLOOKUP($J$18,Tablas!$A$39:$H$62,8,TRUE)","v":2157.63}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$39:$H$62,4,TRUE)))","v":10129.890000000001},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$39:$H$62,5,TRUE)))","v":7116.84},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$39:$H$62,6,TRUE)))","v":5275.62},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$39:$H$62,7,TRUE)))","v":3897.09},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$39:$H$62,8,TRUE)))","v":2984.96}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,4,TRUE)))","v":3537.2200000000003},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,5,TRUE)))","v":2576.86},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,6,TRUE)))","v":1959.94},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,7,TRUE)))","v":1617.03},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,8,TRUE)))","v":1204.1600000000001}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$66)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$66)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$66)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$66)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$66)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F41:F44)","v":20653.570000000003},{"$f":"SUM(G41:G44)","v":14888.760000000002},{"$f":"SUM(H41:H44)","v":11024.53},{"$f":"SUM(I41:I44)","v":8334.7800000000007},{"$f":"SUM(J41:J44)","v":6346.75}]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F41+F42+F43)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G41+G42+G43)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H41+H42+H43)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I41+I42+I43)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J41+J42+J43)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F45+F46+F47)*12%","v":2487.4284000000002},{"$f":"+(G45+G46+G47)*12%","v":1795.6512000000002},1331.9436000000001,1009.1736000000001,{"$f":"+(J45+J46+J47)*12%","v":770.61}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F45:F48)","v":23215.998400000004},{"$f":"SUM(G45:G48)","v":16759.411200000002},{"$f":"SUM(H45:H48)","v":12431.473600000001},{"$f":"SUM(I45:I48)","v":9418.9536000000007},{"$f":"SUM(J45:J48)","v":7192.36}]
[null,null,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F45+F46+F48-(F47*0.12)","v":23131.998400000004},{"$f":"G45+G46+G48-(G47*0.12)","v":16675.411200000002},12347.473600000001,9334.9536000000007,{"$f":"J45+J46+J48-(J47*0.12)","v":7108.36}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$923:$H$946,4,TRUE)","v":3625.05},{"$f":"VLOOKUP($J$18,Tablas!$A$923:$H$946,5,TRUE)","v":2695.55},{"$f":"VLOOKUP($J$18,Tablas!$A$923:$H$946,6,TRUE)","v":1965.9750000000001},{"$f":"VLOOKUP($J$18,Tablas!$A$923:$H$946,7,TRUE)","v":1463.5500000000002},{"$f":"VLOOKUP($J$18,Tablas!$A$923:$H$946,8,TRUE)","v":1119.5250000000001}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$923:$H$946,4,TRUE)))","v":5256.0750000000007},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$923:$H$946,5,TRUE)))","v":3692.7000000000003},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$923:$H$946,6,TRUE)))","v":2737.3500000000004},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$923:$H$946,7,TRUE)))","v":2022.0750000000003},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$923:$H$946,8,TRUE)))","v":1548.8000000000002}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$947:$H$949,4,TRUE)))","v":1835.3500000000001},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,5,TRUE)))","v":2576.86},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,6,TRUE)))","v":1959.94},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,7,TRUE)))","v":1617.03},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,8,TRUE)))","v":1204.1600000000001}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$950)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$950)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$950)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$950)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$950)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F53:F56)","v":10716.475},{"$f":"SUM(G53:G56)","v":8965.11},{"$f":"SUM(H53:H56)","v":6663.2650000000012},{"$f":"SUM(I53:I56)","v":5102.6550000000007},{"$f":"SUM(J53:J56)","v":3872.4850000000006}]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G32>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F53+F54+F55)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G53+G54+G55)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H53+H54+H55)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I53+I54+I55)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J53+J54+J55)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F57+F58+F59)*12%","v":1294.9770000000001},{"$f":"+(G57+G58+G59)*12%","v":1084.8132000000001},808.59180000000015,621.31860000000006,{"$f":"+(J57+J58+J59)*12%","v":473.69820000000004}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F57:F60)","v":12086.452000000001},{"$f":"SUM(G57:G60)","v":10124.923200000001},{"$f":"SUM(H57:H60)","v":7546.8568000000014},{"$f":"SUM(I57:I60)","v":5798.9736000000012},{"$f":"SUM(J57:J60)","v":4421.1832000000004}]
[null,null,null,"TOTAL  (2da a 4ta Cuota)","n/a",{"$f":"F57+F58+F60-(F59*0.12)","v":12002.452000000001},{"$f":"G57+G58+G60-(G59*0.12)","v":10040.923200000001},7462.8568000000014,5714.9736000000012,{"$f":"J57+J58+J60-(J59*0.12)","v":4337.1832000000004}]
[]
[null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2023"]
[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":"Secure","index":2,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[7,3,7,9],[8,3,8,9],[19,0,19,1],[9,3,9,8],[9,0,9,1],[11,4,11,9],[13,4,13,9],[13,0,13,1],[69,3,71,9],[72,0,72,1],[68,3,68,9],[25,3,25,9],[30,3,30,9],[42,3,42,9],[33,0,33,1],[25,0,25,1],[38,0,38,1],[43,0,43,1],[54,0,54,1],[55,3,55,9],[70,0,70,1],[71,0,71,1]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Cotización de Seguro Médico Internacional"]
[null,null,null,"Producto: Bupa Secure Care "]
["BUPA SECURE CARE",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$23","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2022-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G18>0,'INGRESO DE DATOS'!G18,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":32}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":46}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,true,null,"Complicaciones de Maternidad (+ $500,000)"]
[]
[null,null,null,null,null,true,false,"Trasplante de Órganos (+ $500,000)"]
[]
[null,null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$140:$H$163,4,TRUE)","v":7419},{"$f":"VLOOKUP($J$18,Tablas!$A$140:$H$163,5,TRUE)","v":6076},{"$f":"VLOOKUP($J$18,Tablas!$A$140:$H$163,6,TRUE)","v":4490},{"$f":"VLOOKUP($J$18,Tablas!$A$140:$H$163,7,TRUE)","v":3766},{"$f":"VLOOKUP($J$18,Tablas!$A$140:$H$163,8,TRUE)","v":2859}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$140:$H$163,4,TRUE)))","v":10552},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$140:$H$163,5,TRUE)))","v":9142},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$140:$H$163,6,TRUE)))","v":6548},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$140:$H$163,7,TRUE)))","v":5530},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$140:$H$163,8,TRUE)))","v":4132}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$164:$H$166,4,TRUE)))","v":4798},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$164:$H$166,5,TRUE)))","v":2499},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$164:$H$166,6,TRUE)))","v":2184},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$164:$H$166,7,TRUE)))","v":1824},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$164:$H$166,8,TRUE)))","v":1338}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$22=FALSE,0,Tablas!D$167)","v":225},{"$f":"+IF($F$22=FALSE,0,Tablas!E$167)","v":225},{"$f":"+IF($F$22=FALSE,0,Tablas!F$167)","v":225},{"$f":"+IF($F$22=FALSE,0,Tablas!G$167)","v":225},{"$f":"+IF($F$22=FALSE,0,Tablas!H$167)","v":225}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$341)","v":300},{"$f":"IF($F$24=FALSE,0,Tablas!E$341)","v":300},{"$f":"IF($F$24=FALSE,0,Tablas!F$341)","v":300},{"$f":"IF($F$24=FALSE,0,Tablas!G$341)","v":300},{"$f":"IF($F$24=FALSE,0,Tablas!H$341)","v":300}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F32:F36)","v":23294},{"$f":"SUM(G32:G36)","v":18242},13747,11645,8854]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F32+F33+F34)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G32+G33+G34)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H32+H33+H34)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I32+I33+I34)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J32+J33+J34)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F37+F38+F39)*12%","v":2804.2799999999997},{"$f":"+(G37+G38+G39)*12%","v":2198.04},1658.6399999999999,1406.3999999999999,{"$f":"+(J37+J38+J39)*12%","v":1071.48}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F37:F40)","v":26173.279999999999},{"$f":"SUM(G37:G40)","v":20515.04},{"$f":"SUM(H37:H40)","v":15480.64},{"$f":"SUM(I37:I40)","v":13126.4},{"$f":"SUM(J37:J40)","v":10000.48}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$173:$H$196,4,TRUE)","v":3932.07},{"$f":"VLOOKUP($J$18,Tablas!$A$173:$H$196,5,TRUE)","v":3220.28},{"$f":"VLOOKUP($J$18,Tablas!$A$173:$H$196,6,TRUE)","v":2379.7000000000003},{"$f":"VLOOKUP($J$18,Tablas!$A$173:$H$196,7,TRUE)","v":1995.98},{"$f":"VLOOKUP($J$18,Tablas!$A$173:$H$196,8,TRUE)","v":1515.27}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$173:$H$196,4,TRUE)))","v":5592.56},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$173:$H$196,5,TRUE)))","v":4845.26},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$173:$H$196,6,TRUE)))","v":3470.44},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$173:$H$196,7,TRUE)))","v":2930.9},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$173:$H$196,8,TRUE)))","v":2189.96}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$197:$H$199,4,TRUE)))","v":2542.94},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$197:$H$199,5,TRUE)))","v":1324.47},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$197:$H$199,6,TRUE)))","v":1157.52},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$197:$H$199,7,TRUE)))","v":966.72},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$197:$H$199,8,TRUE)))","v":709.14}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$22=FALSE,0,Tablas!D$200)","v":119.25},{"$f":"+IF($F$22=FALSE,0,Tablas!E$200)","v":119.25},{"$f":"+IF($F$22=FALSE,0,Tablas!F$200)","v":119.25},{"$f":"+IF($F$22=FALSE,0,Tablas!G$200)","v":119.25},{"$f":"+IF($F$22=FALSE,0,Tablas!H$200)","v":119.25}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!E$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!F$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!G$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!H$413)","v":159}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F44:F48)","v":12345.820000000002},{"$f":"SUM(G44:G48)","v":9668.26},7285.91,6171.85,4692.62]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F44+F45+F46)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G44+G45+G46)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H44+H45+H46)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I44+I45+I46)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J44+J45+J46)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F49+F50+F51)*12%","v":1490.4984000000002},{"$f":"+(G49+G50+G51)*12%","v":1169.1912},883.30919999999992,749.62200000000007,{"$f":"+(J49+J50+J51)*12%","v":572.11439999999993}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F49:F52)","v":13911.318400000002},{"$f":"SUM(G49:G52)","v":10912.4512},{"$f":"SUM(H49:H52)","v":8244.2191999999995},{"$f":"SUM(I49:I52)","v":6996.4720000000007},{"$f":"SUM(J49:J52)","v":5339.7343999999994}]
[null,null,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F49+F50+F52-(F51*0.12)","v":13827.318400000002},{"$f":"G49+G50+G52-(G51*0.12)","v":10828.4512},8160.2191999999995,6912.4720000000007,5255.7343999999994]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$957:$H$980,4,TRUE)","v":2040.2250000000001},{"$f":"VLOOKUP($J$18,Tablas!$A$957:$H$980,5,TRUE)","v":1670.9},{"$f":"VLOOKUP($J$18,Tablas!$A$957:$H$980,6,TRUE)","v":1234.75},{"$f":"VLOOKUP($J$18,Tablas!$A$957:$H$980,7,TRUE)","v":1035.6500000000001},{"$f":"VLOOKUP($J$18,Tablas!$A$957:$H$980,8,TRUE)","v":786.22500000000002}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$957:$H$980,4,TRUE)))","v":2901.8},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$957:$H$980,5,TRUE)))","v":2514.0500000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$957:$H$980,6,TRUE)))","v":1800.7},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$957:$H$980,7,TRUE)))","v":1520.7500000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$957:$H$980,8,TRUE)))","v":1136.3000000000002}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$981:$H$983,4,TRUE)))","v":1319.45},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$981:$H$983,5,TRUE)))","v":687.22500000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$981:$H$983,6,TRUE)))","v":600.6},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$981:$H$983,7,TRUE)))","v":501.6},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$981:$H$983,8,TRUE)))","v":367.95000000000005}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$22=FALSE,0,Tablas!D$984)","v":61.875000000000007},{"$f":"+IF($F$22=FALSE,0,Tablas!E$984)","v":61.875000000000007},{"$f":"+IF($F$22=FALSE,0,Tablas!F$984)","v":61.875000000000007},{"$f":"+IF($F$22=FALSE,0,Tablas!G$984)","v":61.875000000000007},{"$f":"+IF($F$22=FALSE,0,Tablas!H$984)","v":61.875000000000007}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!E$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!F$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!G$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!H$413)","v":159}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F57:F61)","v":6482.35},{"$f":"SUM(G57:G61)","v":5093.0500000000011},3856.9249999999997,3278.8750000000005,2511.3500000000004]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G33>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F57+F58+F59)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G57+G58+G59)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H57+H58+H59)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I57+I58+I59)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J57+J58+J59)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F62+F63+F64)*12%","v":786.88200000000006},{"$f":"+(G62+G63+G64)*12%","v":620.16600000000005},471.83099999999996,402.46500000000003,{"$f":"+(J62+J63+J64)*12%","v":310.36200000000002}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F62:F65)","v":7344.232},{"$f":"SUM(G62:G65)","v":5788.2160000000013},{"$f":"SUM(H62:H65)","v":4403.7559999999994},{"$f":"SUM(I62:I65)","v":3756.3400000000006},{"$f":"SUM(J62:J65)","v":2896.7120000000004}]
[null,null,null,"TOTAL  (2da a 4ta Cuota)","n/a",{"$f":"F62+F63+F65-(F64*0.12)","v":7260.232},{"$f":"G62+G63+G65-(G64*0.12)","v":5704.2160000000013},4319.7559999999994,3672.3400000000006,2812.7120000000004]
[]
[null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2023"]
[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":"Premium","index":3,"n_rows":75,"n_cols":11,"rows_kept":75,"cut":false,"hidden":false,"merged":[[27,3,27,9],[11,0,11,1],[17,0,17,1],[23,0,23,1],[74,3,76,9],[59,3,59,9],[73,0,73,1],[74,0,74,1],[75,0,75,1],[32,0,32,1],[32,3,32,9],[45,3,45,9],[73,3,73,9],[57,0,57,1],[38,0,38,1],[43,0,43,1],[9,0,9,1],[11,4,11,9],[13,4,13,9],[7,3,7,9],[8,3,8,9]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Cotización de Seguro Médico Internacional"]
[null,null,null,"Producto: Bupa Premium Care"]
["BUPA PREMIUM CARE"]
[null,null,null,null,null,null,null," "," "," "," "]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$23","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2022-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G18>0,'INGRESO DE DATOS'!G18,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":32}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":46}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,"Complicaciones de Maternidad (+ $500,000)"]
[null,null,null,null,null,true]
[null,null,null,null,null,true,null,"Trasplante de Órganos (+ $500,000)"]
[null,null,null,null,null,true]
[null,null,null," ",null,null,null,"Eliminación de Deducible"]
[]
[null,null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$274:$H$336,4,TRUE)","v":7901},{"$f":"VLOOKUP($J$18,Tablas!$A$274:$H$336,5,TRUE)","v":6050},{"$f":"VLOOKUP($J$18,Tablas!$A$274:$H$336,6,TRUE)","v":4427},{"$f":"VLOOKUP($J$18,Tablas!$A$274:$H$336,7,TRUE)","v":3299},{"$f":"VLOOKUP($J$18,Tablas!$A$274:$H$336,8,TRUE)","v":2553}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$274:$H$336,4,TRUE)))","v":11147},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$274:$H$336,5,TRUE)))","v":8909},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$274:$H$336,6,TRUE)))","v":6881},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$274:$H$336,7,TRUE)))","v":5104},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$274:$H$336,8,TRUE)))","v":3512}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$337:$H$339,4,TRUE)))","v":4709},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$337:$H$339,5,TRUE)))","v":3252},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$337:$H$339,6,TRUE)))","v":2405},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$337:$H$339,7,TRUE)))","v":2076},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$337:$H$339,8,TRUE)))","v":1383}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$340)","v":225},{"$f":"+IF($F$23=FALSE,0,Tablas!E$340)","v":225},{"$f":"+IF($F$23=FALSE,0,Tablas!F$340)","v":225},{"$f":"+IF($F$23=FALSE,0,Tablas!G$340)","v":225},{"$f":"+IF($F$23=FALSE,0,Tablas!H$340)","v":225}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$341)","v":300},{"$f":"IF($F$24=FALSE,0,Tablas!E$341)","v":300},{"$f":"IF($F$24=FALSE,0,Tablas!F$341)","v":300},{"$f":"IF($F$24=FALSE,0,Tablas!G$341)","v":300},{"$f":"IF($F$24=FALSE,0,Tablas!H$341)","v":300}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$342)","v":180},{"$f":"IF($F$25=FALSE,0,Tablas!E$342)","v":345},{"$f":"IF($F$25=FALSE,0,Tablas!F$342)","v":775},{"$f":"IF($F$25=FALSE,0,Tablas!G$342)","v":1330},{"$f":"IF($F$25=FALSE,0,Tablas!H$342)","v":2080}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F34:F39)","v":24462},{"$f":"SUM(G34:G39)","v":19081},15013,12334,10053]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F34+F35+F36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G34+G35+G36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H34+H35+H36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I34+I35+I36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J34+J35+J36)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F40+F41+F42)*12%","v":2944.44},{"$f":"+(G40+G41+G42)*12%","v":2298.7199999999998},1810.56,1489.08,{"$f":"+(J40+J41+J42)*12%","v":1215.3599999999999}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F40:F43)","v":27481.439999999999},{"$f":"SUM(G40:G43)","v":21454.720000000001},{"$f":"SUM(H40:H43)","v":16898.560000000001},{"$f":"SUM(I40:I43)","v":13898.08},{"$f":"SUM(J40:J43)","v":11343.36}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$346:$H$408,4,TRUE)","v":4187.5300000000007},{"$f":"VLOOKUP($J$18,Tablas!$A$346:$H$408,5,TRUE)","v":3206.5},{"$f":"VLOOKUP($J$18,Tablas!$A$346:$H$408,6,TRUE)","v":2346.31},{"$f":"VLOOKUP($J$18,Tablas!$A$346:$H$408,7,TRUE)","v":1748.47},{"$f":"VLOOKUP($J$18,Tablas!$A$346:$H$408,8,TRUE)","v":1353.0900000000001}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$346:$H$408,4,TRUE)))","v":5907.91},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$346:$H$408,5,TRUE)))","v":4721.7700000000004},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$346:$H$408,6,TRUE)))","v":3646.9300000000003},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$346:$H$408,7,TRUE)))","v":2705.1200000000003},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$346:$H$408,8,TRUE)))","v":1861.3600000000001}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$409:$H$411,4,TRUE)))","v":2495.77},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$409:$H$411,5,TRUE)))","v":1723.5600000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$409:$H$411,6,TRUE)))","v":1274.6500000000001},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$409:$H$411,7,TRUE)))","v":1100.28},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$409:$H$411,8,TRUE)))","v":732.99}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$412)","v":119.25},{"$f":"+IF($F$23=FALSE,0,Tablas!E$412)","v":119.25},{"$f":"+IF($F$23=FALSE,0,Tablas!F$412)","v":119.25},{"$f":"+IF($F$23=FALSE,0,Tablas!G$412)","v":119.25},{"$f":"+IF($F$23=FALSE,0,Tablas!H$412)","v":119.25}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!E$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!F$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!G$413)","v":159},{"$f":"IF($F$24=FALSE,0,Tablas!H$413)","v":159}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$414)","v":95.4},{"$f":"IF($F$25=FALSE,0,Tablas!E$414)","v":182.85000000000002},{"$f":"IF($F$25=FALSE,0,Tablas!F$414)","v":410.75},{"$f":"IF($F$25=FALSE,0,Tablas!G$414)","v":704.90000000000009},{"$f":"IF($F$25=FALSE,0,Tablas!H$414)","v":1102.4000000000001}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F47:F52)","v":12964.86},{"$f":"SUM(G47:G52)","v":10112.93},7956.8899999999994,6537.02,5328.09]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F47+F48+F49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G47+G48+G49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H47+H48+H49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I47+I48+I49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J47+J48+J49)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F53+F54+F55)*12%","v":1564.7832000000001},{"$f":"+(G53+G54+G55)*12%","v":1222.5516},{"$f":"+(H53+H54+H55)*12%","v":963.82679999999993},{"$f":"+(I53+I54+I55)*12%","v":793.44240000000002},{"$f":"+(J53+J54+J55)*12%","v":648.37080000000003}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F53:F56)","v":14604.6432},{"$f":"SUM(G53:G56)","v":11410.481600000001},{"$f":"SUM(H53:H56)","v":8995.7168000000001},{"$f":"SUM(I53:I56)","v":7405.4624000000003},{"$f":"SUM(J53:J56)","v":6051.4607999999998}]
[null,null,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F53+F54+F56-(F55*0.12)","v":14520.6432},{"$f":"G53+G54+G56-(G55*0.12)","v":11326.481600000001},8911.7168000000001,7321.4624000000003,5967.4607999999998]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$991:$H$1053,4,TRUE)","v":2172.7750000000001},{"$f":"VLOOKUP($J$18,Tablas!$A$991:$H$1053,5,TRUE)","v":1663.7500000000002},{"$f":"VLOOKUP($J$18,Tablas!$A$991:$H$1053,6,TRUE)","v":1217.4250000000002},{"$f":"VLOOKUP($J$18,Tablas!$A$991:$H$1053,7,TRUE)","v":907.22500000000002},{"$f":"VLOOKUP($J$18,Tablas!$A$991:$H$1053,8,TRUE)","v":702.07500000000005}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$991:$H$1053,4,TRUE)))","v":3065.4250000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$991:$H$1053,5,TRUE)))","v":2449.9750000000004},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$991:$H$1053,6,TRUE)))","v":1892.2750000000001},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$991:$H$1053,7,TRUE)))","v":1403.6000000000001},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$991:$H$1053,8,TRUE)))","v":965.80000000000007}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1054:$H$1056,4,TRUE)))","v":1294.9750000000001},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1054:$H$1056,5,TRUE)))","v":894.30000000000007},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1054:$H$1056,6,TRUE)))","v":661.375},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1054:$H$1056,7,TRUE)))","v":570.90000000000009},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1054:$H$1056,8,TRUE)))","v":380.32500000000005}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$1057)","v":61.875000000000007},{"$f":"+IF($F$23=FALSE,0,Tablas!E$1057)","v":61.875000000000007},{"$f":"+IF($F$23=FALSE,0,Tablas!F$1057)","v":61.875000000000007},{"$f":"+IF($F$23=FALSE,0,Tablas!G$1057)","v":61.875000000000007},{"$f":"+IF($F$23=FALSE,0,Tablas!H$1057)","v":61.875000000000007}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$1058)","v":82.5},{"$f":"IF($F$24=FALSE,0,Tablas!E$1058)","v":82.5},{"$f":"IF($F$24=FALSE,0,Tablas!F$1058)","v":82.5},{"$f":"IF($F$24=FALSE,0,Tablas!G$1058)","v":82.5},{"$f":"IF($F$24=FALSE,0,Tablas!H$1058)","v":82.5}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$1059)","v":49.500000000000007},{"$f":"IF($F$25=FALSE,0,Tablas!E$1059)","v":94.875000000000014},{"$f":"IF($F$25=FALSE,0,Tablas!F$1059)","v":213.12500000000003},{"$f":"IF($F$25=FALSE,0,Tablas!G$1059)","v":365.75000000000006},{"$f":"IF($F$25=FALSE,0,Tablas!H$1059)","v":572}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F61:F66)","v":6727.0500000000011},{"$f":"SUM(G61:G66)","v":5247.2750000000005},4128.5750000000007,3391.8500000000004,2764.5749999999998]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G34>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F61+F62+F63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G61+G62+G63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H61+H62+H63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I61+I62+I63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J61+J62+J63)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F67+F68+F69)*12%","v":816.24600000000009},{"$f":"+(G67+G68+G69)*12%","v":638.673},504.42900000000009,416.02200000000005,{"$f":"+(J67+J68+J69)*12%","v":340.74899999999997}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F67:F70)","v":7618.2960000000012},{"$f":"SUM(G67:G70)","v":5960.9480000000003},{"$f":"SUM(H67:H70)","v":4708.0040000000008},{"$f":"SUM(I67:I70)","v":3882.8720000000003},{"$f":"SUM(J67:J70)","v":3180.3239999999996}]
[null,null,null,"TOTAL  (2da a 4ta Cuota)","n/a",{"$f":"F67+F68+F70-(F69*0.12)","v":7534.2960000000012},{"$f":"G67+G68+G70-(G69*0.12)","v":5876.9480000000003},4624.0040000000008,3798.8720000000003,3096.3239999999996]
[]
[null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2023"]
[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":"Bupa Essential Care","index":4,"n_rows":83,"n_cols":11,"rows_kept":83,"cut":false,"hidden":false,"merged":[[82,3,82,9],[41,0,41,1],[43,3,43,9],[55,0,55,1],[59,3,59,9],[69,0,69,1],[70,0,70,1],[71,0,71,1],[75,3,75,9],[76,3,78,9],[80,3,80,9],[81,3,81,9],[36,0,36,1],[7,3,7,9],[8,3,8,9],[9,0,9,1],[10,0,10,1],[10,4,10,9],[12,4,12,9],[16,0,16,1],[22,0,22,1],[25,3,25,9],[30,0,30,1],[30,3,30,9]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Cotización de Seguro Médico Internacional"]
[null,null,null,"BUPA Essential Care"]
["Bupa Essential Care",null,null,null,null,null,null," "," "," "," "]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$14","v":"Número de Adultos:"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$23","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2022-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G20>0,'INGRESO DE DATOS'!G20,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":32}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":46}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,"Complicaciones de Maternidad (planes 1, 2, y 3)"]
[null,null,null,null,null,true]
[null,null,null,null,null,true,null,"Trasplante de Órganos"]
[null,null,null,null,null,false]
[null,null,null," ",null,null,null,"Eliminación de Deducible"]
[null,null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,"Dentro del pais de residencia",250,250,1000,5000,10000,20000]
[null,null,null,"Fuera del pais de residencia",1000,5000,10000,5000,10000,20000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular",{"$f":"VLOOKUP($J$17,Tablas!$A$778:$H$843,3,TRUE)","v":1961},{"$f":"VLOOKUP($J$17,Tablas!$A$778:$H$843,4,TRUE)","v":1886},{"$f":"VLOOKUP($J$17,Tablas!$A$778:$H$843,5,TRUE)","v":1748},{"$f":"VLOOKUP($J$17,Tablas!$A$778:$H$843,6,TRUE)","v":1239},{"$f":"VLOOKUP($J$17,Tablas!$A$778:$H$843,7,TRUE)","v":907},{"$f":"VLOOKUP($J$17,Tablas!$A$778:$H$843,8,TRUE)","v":644}]
[null,null,null,"Prima Cónyuge",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$778:$H$840,3,TRUE)))","v":2980},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$778:$H$840,4,TRUE)))","v":2866},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$778:$H$840,5,TRUE)))","v":2657},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$778:$H$840,6,TRUE)))","v":1881},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$778:$H$840,7,TRUE)))","v":1324},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$778:$H$840,8,TRUE)))","v":925}]
[null,null,null,"Primas Hijos",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$841:$H$843,3,TRUE)))","v":996},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$841:$H$843,4,TRUE)))","v":958},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$841:$H$843,5,TRUE)))","v":888},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$841:$H$843,6,TRUE)))","v":629},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$841:$H$843,7,TRUE)))","v":524},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$841:$H$843,8,TRUE)))","v":414}]
[null,null,null,"Anexo: Complicaciones de Maternidad",{"$f":"+IF($F$22=FALSE,0,Tablas!C$844)","v":225},{"$f":"+IF($F$22=FALSE,0,Tablas!D$844)","v":225},{"$f":"+IF($F$22=FALSE,0,Tablas!E$844)","v":225},{"$f":"+IF($F$22=FALSE,0,Tablas!F$844)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!G$844)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!H$844)","v":0}]
[null,null,null,"Anexo: Trasplante Organos",{"$f":"IF($F$23=FALSE,0,Tablas!C$845)","v":300},{"$f":"IF($F$23=FALSE,0,Tablas!D$845)","v":300},{"$f":"IF($F$23=FALSE,0,Tablas!E$845)","v":300},{"$f":"IF($F$23=FALSE,0,Tablas!F$845)","v":300},{"$f":"IF($F$23=FALSE,0,Tablas!G$845)","v":300},{"$f":"IF($F$23=FALSE,0,Tablas!H$845)","v":300}]
[null,null,null,"Anexo: Eliminacion de Deducible",0,0,0,0,0,0]
[null,null,null,"PRIMA NETA",{"$f":"SUM(E32:E37)","v":6462},6235,5818,4049,3055,2283]
[null,null,null,"",0,0,0,0,0,0]
[null,null,null,"Costo Administrativo Anual",75,75,75,75,75,75]
[null,null,null,"IVA (12%)",{"$f":"+(E38+E39+E40)*12%","v":784.43999999999994},{"$f":"+(F38+F39+F40)*12%","v":757.19999999999993},{"$f":"+(G38+G39+G40)*12%","v":707.16},494.88,375.59999999999997,{"$f":"+(J38+J39+J40)*12%","v":282.95999999999998}]
[null,null,null,"TOTAL",{"$f":"SUM(E38:E41)","v":7321.44},7067.2,6600.16,4618.88,3505.6,2640.96]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular",{"$f":"VLOOKUP($J$17,Tablas!$A$850:$H$912,3,TRUE)","v":1039.3300000000002},{"$f":"VLOOKUP($J$17,Tablas!$A$850:$H$912,4,TRUE)","v":999.58},{"$f":"VLOOKUP($J$17,Tablas!$A$850:$H$912,5,TRUE)","v":926.44},{"$f":"VLOOKUP($J$17,Tablas!$A$850:$H$912,6,TRUE)","v":656.67000000000007},{"$f":"VLOOKUP($J$17,Tablas!$A$850:$H$912,7,TRUE)","v":480.71000000000004},{"$f":"VLOOKUP($J$17,Tablas!$A$850:$H$912,8,TRUE)","v":341.32}]
[null,null,null,"Prima Cónyuge",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$850:$H$912,3,TRUE)))","v":1579.4},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$850:$H$912,4,TRUE)))","v":1518.98},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$850:$H$912,5,TRUE)))","v":1408.21},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$850:$H$912,6,TRUE)))","v":996.93000000000006},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$850:$H$912,7,TRUE)))","v":701.72},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$850:$H$912,8,TRUE)))","v":490.25}]
[null,null,null,"Primas Hijos",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$913:$H$915,3,TRUE)))","v":527.88},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$913:$H$915,4,TRUE)))","v":507.74},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$913:$H$915,5,TRUE)))","v":470.64000000000004},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$913:$H$915,6,TRUE)))","v":333.37},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$913:$H$915,7,TRUE)))","v":277.72000000000003},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$913:$H$915,8,TRUE)))","v":219.42000000000002}]
[null,null,null,"Anexo: Complicaciones de Maternidad",{"$f":"+IF($F$22=FALSE,0,Tablas!C$916)","v":119.25},{"$f":"+IF($F$22=FALSE,0,Tablas!D$916)","v":119.25},{"$f":"+IF($F$22=FALSE,0,Tablas!E$916)","v":119.25},{"$f":"+IF($F$22=FALSE,0,Tablas!F$916)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!G$916)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!H$916)","v":0}]
[null,null,null,"Anexo: Trasplante Organos",{"$f":"IF($F$23=FALSE,0,Tablas!C$917)","v":159},{"$f":"IF($F$23=FALSE,0,Tablas!D$917)","v":159},{"$f":"IF($F$23=FALSE,0,Tablas!E$917)","v":159},{"$f":"IF($F$23=FALSE,0,Tablas!F$917)","v":159},{"$f":"IF($F$23=FALSE,0,Tablas!G$917)","v":159},{"$f":"IF($F$23=FALSE,0,Tablas!H$917)","v":159}]
[null,null,null,"Anexo: Eliminacion de Deducible",0,0,0,0,0,0]
[null,null,null,"PRIMA NETA",{"$f":"SUM(E45:E50)","v":3424.8600000000006},{"$f":"SUM(F45:F50)","v":3304.55},{"$f":"SUM(G45:G50)","v":3083.54},2145.9700000000003,1619.15,1209.99]
[null,null,null,"",0,0,0,0,0,0]
[null,null,null,"Costo Administrativo Anual",75,75,75,75,75,75]
[null,null,null,"IVA (12%)",{"$f":"+(E51+E52+E53)*12%","v":419.98320000000007},{"$f":"+(F51+F52+F53)*12%","v":405.54599999999999},{"$f":"+(G51+G52+G53)*12%","v":379.02479999999997},266.51640000000003,203.298,{"$f":"+(J51+J52+J53)*12%","v":154.19880000000001}]
[null,null,null,"(1ra Cuota)",{"$f":"SUM(E51:E54)","v":3919.8432000000007},3785.096,3537.5648000000001,2487.4864000000002,1897.4480000000001,1439.1887999999999]
[null,null,null,"(2da Cuota)",{"$f":"E51+E52+E54-(E53*0.12)","v":3835.8432000000007},{"$f":"F51+F52+F54-(F53*0.12)","v":3701.096},{"$f":"G51+G52+G54-(G53*0.12)","v":3453.5648000000001},2403.4864000000002,1813.4480000000001,1355.1887999999999]
[null,null,null,"TOTAL",{"$f":"SUM(E55:E56)","v":7755.6864000000014},{"$f":"SUM(F55:F56)","v":7486.192},6991.1296000000002,4890.9728000000005,3710.8960000000002,2794.3775999999998]
[]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular",{"$f":"VLOOKUP($J$17,Tablas!$A$1141:$H$1203,3,TRUE)","v":539.27500000000009},{"$f":"VLOOKUP($J$17,Tablas!$A$1141:$H$1203,4,TRUE)","v":518.65000000000009},{"$f":"VLOOKUP($J$17,Tablas!$A$1141:$H$1203,5,TRUE)","v":480.70000000000005},{"$f":"VLOOKUP($J$17,Tablas!$A$1141:$H$1203,6,TRUE)","v":340.72500000000002},{"$f":"VLOOKUP($J$17,Tablas!$A$1141:$H$1203,7,TRUE)","v":249.42500000000001},{"$f":"VLOOKUP($J$17,Tablas!$A$1141:$H$1203,8,TRUE)","v":177.10000000000002}]
[null,null,null,"Prima Cónyuge",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1141:$H$1203,3,TRUE)))","v":819.50000000000011},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1141:$H$1203,4,TRUE)))","v":788.15000000000009},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1141:$H$1203,5,TRUE)))","v":730.67500000000007},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1141:$H$1203,6,TRUE)))","v":517.27500000000009},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1141:$H$1203,7,TRUE)))","v":364.1},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1141:$H$1203,8,TRUE)))","v":254.37500000000003}]
[null,null,null,"Primas Hijos",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1204:$H$1206,3,TRUE)))","v":273.90000000000003},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1204:$H$1206,4,TRUE)))","v":263.45000000000005},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1204:$H$1206,5,TRUE)))","v":244.20000000000002},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1204:$H$1206,6,TRUE)))","v":172.97500000000002},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1204:$H$1206,7,TRUE)))","v":144.10000000000002},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1204:$H$1206,8,TRUE)))","v":113.85000000000001}]
[null,null,null,"Anexo: Complicaciones de Maternidad",{"$f":"+IF($F$22=FALSE,0,Tablas!C$1207)","v":61.875000000000007},{"$f":"+IF($F$22=FALSE,0,Tablas!D$1207)","v":61.875000000000007},{"$f":"+IF($F$22=FALSE,0,Tablas!E$1207)","v":61.875000000000007},{"$f":"+IF($F$22=FALSE,0,Tablas!F$1207)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!G$1207)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!H$1207)","v":0}]
[null,null,null,"Anexo: Trasplante Organos",{"$f":"IF($F$23=FALSE,0,Tablas!C$1208)","v":82.5},{"$f":"IF($F$23=FALSE,0,Tablas!D$1208)","v":82.5},{"$f":"IF($F$23=FALSE,0,Tablas!E$1208)","v":82.5},{"$f":"IF($F$23=FALSE,0,Tablas!F$1208)","v":82.5},{"$f":"IF($F$23=FALSE,0,Tablas!G$1208)","v":82.5},{"$f":"IF($F$23=FALSE,0,Tablas!H$1208)","v":82.5}]
[null,null,null,"Anexo: Eliminacion de Deducible",0,0,0,0,0,0]
[null,null,null,"PRIMA NETA",{"$f":"SUM(E61:E66)","v":1777.0500000000002},{"$f":"SUM(F61:F66)","v":1714.6250000000002},{"$f":"SUM(G61:G66)","v":1599.95},1113.4750000000001,840.12500000000011,627.82500000000005]
[null,null,null,"",0,0,0,0,0,0]
[null,null,null,"Costo Administrativo Anual",75,75,75,75,75,75]
[null,null,null,"IVA (12%)",{"$f":"+(E67+E68+E69)*12%","v":222.24600000000001},{"$f":"+(F67+F68+F69)*12%","v":214.75500000000002},{"$f":"+(G67+G68+G69)*12%","v":200.994},142.61700000000002,109.81500000000001,{"$f":"+(J67+J68+J69)*12%","v":84.338999999999999}]
[null,null,null,"(1ra Cuota)",{"$f":"SUM(E67:E70)","v":2074.2960000000003},2004.3800000000003,1875.944,1331.0920000000001,1024.94,787.16399999999999]
[null,null,null,"(2da a 4ta Cuota)",{"$f":"E67+E68+E70-(E69*0.12)","v":1990.2960000000003},{"$f":"F67+F68+F70-(F69*0.12)","v":1920.3800000000003},{"$f":"G67+G68+G70-(G69*0.12)","v":1791.944},1247.0920000000001,940.94000000000017,703.16399999999999]
[null,null,null,"TOTAL",{"$f":"E71+E72*3","v":8045.1840000000011},{"$f":"F71+F72*3","v":7765.5200000000013},7251.7759999999998,5072.3680000000004,3847.7600000000007,2896.6559999999999]
[]
[]
[null,null,null,"Tarifas en US $ -   Efectivas partir del 1ro de enero de  2023"]
[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,"Bupa Guatemala, Compañía de Seguros, S.A."]
[null,null,null,"5 Avenida 5-55 Zona 14, Europlaza World Business Center, Torre 3, Nivel 11, Guatemala"]
[null,null,null,"PBX: 2300-8000 / www.bupasalud.com / servicioguatemala@bupalatinamerica.com"]

{"sheet":"Classic Care","index":5,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[[7,0,7,1],[73,3,73,9],[11,4,11,9],[13,4,13,9],[56,0,56,1],[27,3,27,9],[32,3,32,9],[45,3,45,9],[12,0,12,1],[43,0,43,1],[38,0,38,1],[24,0,24,1],[7,3,7,9],[8,3,8,9],[9,0,9,1],[32,0,32,1],[18,0,18,1],[74,3,76,9],[59,3,59,9],[69,0,69,1],[70,0,70,1],[71,0,71,1]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Cotización de Seguro Médico Internacional"]
[null,null,null,"Bupa Classic Care"]
["BUPA CLASSIC CARE"]
[]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$23","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2022-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G18>0,'INGRESO DE DATOS'!G18,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":32}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":46}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,"Complicaciones de Maternidad (+ $500,000)"]
[null,null,null,null,null,false]
[null,null,null,null,null,false,null,"Trasplante de Órganos (+ $500,000)"]
[null,null,null,null,null,false]
[null,null,null,null,null,null,null,"Eliminación de Deducible"]
[]
[null,null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$487:$H$549,4,TRUE)","v":4087},{"$f":"VLOOKUP($J$18,Tablas!$A$487:$H$549,5,TRUE)","v":3364},{"$f":"VLOOKUP($J$18,Tablas!$A$487:$H$549,6,TRUE)","v":2176},{"$f":"VLOOKUP($J$18,Tablas!$A$487:$H$549,7,TRUE)","v":1550},{"$f":"VLOOKUP($J$18,Tablas!$A$487:$H$549,8,TRUE)","v":1101}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$487:$H$549,4,TRUE)))","v":5880},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$487:$H$549,5,TRUE)))","v":5031},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$487:$H$549,6,TRUE)))","v":3306},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$487:$H$549,7,TRUE)))","v":2266},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$487:$H$549,8,TRUE)))","v":1581}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$550:$H$552,4,TRUE)))","v":2735},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$550:$H$552,5,TRUE)))","v":1419},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$550:$H$552,6,TRUE)))","v":1105},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$550:$H$552,7,TRUE)))","v":779},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$550:$H$552,8,TRUE)))","v":539}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$553)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$553)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$553)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$553)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$553)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$554)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$554)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$554)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$554)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$554)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$555)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!E$555)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!F$555)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!G$555)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!H$555)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F34:F39)","v":12702},{"$f":"SUM(G34:G39)","v":9814},6587,4595,3221]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F34+F35+F36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G34+G35+G36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H34+H35+H36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I34+I35+I36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J34+J35+J36)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F40+F41+F42)*12%","v":1533.24},{"$f":"+(G40+G41+G42)*12%","v":1186.68},799.43999999999994,560.4,{"$f":"+(J40+J41+J42)*12%","v":395.52}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F40:F43)","v":14310.24},{"$f":"SUM(G40:G43)","v":11075.68},{"$f":"SUM(H40:H43)","v":7461.44},{"$f":"SUM(I40:I43)","v":5230.3999999999996},{"$f":"SUM(J40:J43)","v":3691.52}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$559:$H$621,4,TRUE)","v":2166.11},{"$f":"VLOOKUP($J$18,Tablas!$A$559:$H$621,5,TRUE)","v":1782.92},{"$f":"VLOOKUP($J$18,Tablas!$A$559:$H$621,6,TRUE)","v":1153.28},{"$f":"VLOOKUP($J$18,Tablas!$A$559:$H$621,7,TRUE)","v":821.5},{"$f":"VLOOKUP($J$18,Tablas!$A$559:$H$621,8,TRUE)","v":583.53}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$559:$H$621,4,TRUE)))","v":3116.4},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$559:$H$621,5,TRUE)))","v":2666.4300000000003},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$559:$H$621,6,TRUE)))","v":1752.18},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$559:$H$621,7,TRUE)))","v":1200.98},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$559:$H$621,8,TRUE)))","v":837.93000000000006}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$622:$H$624,4,TRUE)))","v":1449.5500000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$622:$H$624,5,TRUE)))","v":752.07},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$622:$H$624,6,TRUE)))","v":585.65},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$622:$H$624,7,TRUE)))","v":412.87},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$622:$H$624,8,TRUE)))","v":285.67}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$625)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$625)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$625)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$625)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$625)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$626)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$626)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$626)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$626)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$626)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$627)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!E$627)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!F$627)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!G$627)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!H$627)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F47:F52)","v":6732.06},{"$f":"SUM(G47:G52)","v":5201.42},3491.11,2435.35,1707.13]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F47+F48+F49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G47+G48+G49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H47+H48+H49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I47+I48+I49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J47+J48+J49)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F53+F54+F55)*12%","v":816.84720000000004},{"$f":"+(G53+G54+G55)*12%","v":633.17039999999997},427.9332,301.24199999999996,{"$f":"+(J53+J54+J55)*12%","v":213.85560000000001}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F53:F56)","v":7623.9072000000006},{"$f":"SUM(G53:G56)","v":5909.5904},{"$f":"SUM(H53:H56)","v":3994.0432000000001},{"$f":"SUM(I53:I56)","v":2811.5919999999996},{"$f":"SUM(J53:J56)","v":1995.9856000000002}]
[null,null,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F53+F54+F56-(F55*0.12)","v":7539.9072000000006},{"$f":"G53+G54+G56-(G55*0.12)","v":5825.5904},3910.0432000000001,2727.5919999999996,{"$f":"J53+J54+J56-(J55*0.12)","v":1911.9856000000002}]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$1065:$H$1127,4,TRUE)","v":1123.9250000000002},{"$f":"VLOOKUP($J$18,Tablas!$A$1065:$H$1127,5,TRUE)","v":925.1},{"$f":"VLOOKUP($J$18,Tablas!$A$1065:$H$1127,6,TRUE)","v":598.40000000000009},{"$f":"VLOOKUP($J$18,Tablas!$A$1065:$H$1127,7,TRUE)","v":426.25000000000006},{"$f":"VLOOKUP($J$18,Tablas!$A$1065:$H$1127,8,TRUE)","v":302.77500000000003}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$1065:$H$1127,4,TRUE)))","v":1617.0000000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$1065:$H$1127,5,TRUE)))","v":1383.5250000000001},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$1065:$H$1127,6,TRUE)))","v":909.15000000000009},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$1065:$H$1127,7,TRUE)))","v":623.15000000000009},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$1065:$H$1127,8,TRUE)))","v":434.77500000000003}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1128:$H$1130,4,TRUE)))","v":752.12500000000011},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1128:$H$1130,5,TRUE)))","v":390.22500000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1128:$H$1130,6,TRUE)))","v":303.875},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1128:$H$1130,7,TRUE)))","v":214.22500000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1128:$H$1130,8,TRUE)))","v":148.22500000000002}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$1131)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$1131)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$1131)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$1131)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$1131)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$1132)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$1132)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$1132)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$1132)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$1132)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$1133)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!E$1133)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!F$1133)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!G$1133)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!H$1133)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F61:F66)","v":3493.05},{"$f":"SUM(G61:G66)","v":2698.85},1811.4250000000002,1263.625,885.77500000000009]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G34>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F61+F62+F63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G61+G62+G63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H61+H62+H63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I61+I62+I63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J61+J62+J63)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F67+F68+F69)*12%","v":428.166},{"$f":"+(G67+G68+G69)*12%","v":332.86199999999997},226.37100000000001,160.63499999999999,{"$f":"+(J67+J68+J69)*12%","v":115.29300000000001}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F67:F70)","v":3996.2160000000003},{"$f":"SUM(G67:G70)","v":3106.712},{"$f":"SUM(H67:H70)","v":2112.7960000000003},{"$f":"SUM(I67:I70)","v":1499.26},{"$f":"SUM(J67:J70)","v":1076.0680000000002}]
[null,null,null,"TOTAL  (2da a 4ta Cuota)","n/a",{"$f":"F67+F68+F70-(F69*0.12)","v":3912.2160000000003},{"$f":"G67+G68+G70-(G69*0.12)","v":3022.712},2028.7960000000003,1415.26,{"$f":"J67+J68+J70-(J69*0.12)","v":992.0680000000001}]
[]
[null,null,null,"Tarifas en US $ -   Efectivas partir del 1ro de enero de  2023"]
[null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Resumen tarifas anuales","index":6,"n_rows":126,"n_cols":9,"rows_kept":126,"cut":false,"hidden":false,"merged":[[115,2,116,2],[123,2,123,8],[124,2,124,8],[125,2,125,8],[86,2,86,8],[119,2,119,8],[90,2,90,8],[91,2,92,2],[94,2,94,8],[99,2,99,8],[100,2,100,8],[106,2,106,8],[107,2,107,3],[110,2,110,8],[111,2,112,2],[114,2,114,8],[0,0,0,8],[120,2,121,8],[95,2,96,2],[6,3,6,8],[8,3,8,8],[14,1,14,2],[13,1,13,2],[80,2,80,8],[79,2,79,8],[19,2,19,8],[20,2,20,8],[26,2,26,8],[27,2,27,3],[30,2,30,8],[31,2,32,2],[34,2,34,8],[35,2,36,2],[39,2,39,8],[40,2,40,8],[46,2,46,8],[47,2,47,3],[50,2,50,8],[51,2,52,2],[54,2,54,8],[55,2,56,2],[59,2,59,8],[74,2,74,8],[75,2,76,2],[60,2,60,8],[66,2,66,8],[67,2,67,3],[70,2,70,8],[71,2,72,2]]}
["Cotización de Seguro Médico Internacional - BUPA Guatemala"]
[null,null,null,null,null," "," "," "]
[]
[]
[null,null,null,null,null," "," "," "," "]
[]
[null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"Nombre"}]
[]
[null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$23","v":"Agente / Agencia"}]
[]
[null,null,"Fecha:",{"$f":"+TODAY()","v":"2022-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G18>0,'INGRESO DE DATOS'!G18,\"\")","v":""}]
[]
[null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":32}]
[]
[null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":46}]
[null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,"COMPLETE CARE"]
[null,null,"Deducibles"]
[null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"Complete Care",null,{"$f":"+Complete!F38","v":43729.279999999999},{"$f":"+Complete!G38","v":31547.040000000001},{"$f":"+Complete!H38","v":23381.119999999999},{"$f":"+Complete!I38","v":17697.12},{"$f":"+Complete!J38","v":13496}]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"Complete Care","1ra Cuota",{"$f":"+Complete!F49","v":23215.998400000004},{"$f":"+Complete!G49","v":16759.411200000002},{"$f":"+Complete!H49","v":12431.473600000001},{"$f":"+Complete!I49","v":9418.9536000000007},{"$f":"+Complete!J49","v":7192.36}]
[null,null,null,"2da Cuota",{"$f":"+Complete!F50","v":23131.998400000004},{"$f":"+Complete!G50","v":16675.411200000002},{"$f":"+Complete!H50","v":12347.473600000001},{"$f":"+Complete!I50","v":9334.9536000000007},{"$f":"+Complete!J50","v":7108.36}]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"Complete Care","1ra Cuota",{"$f":"+Complete!F61","v":12086.452000000001},{"$f":"+Complete!G61","v":10124.923200000001},{"$f":"+Complete!H61","v":7546.8568000000014},{"$f":"+Complete!I61","v":5798.9736000000012},{"$f":"+Complete!J61","v":4421.1832000000004}]
[null,null,null,"2da a 4ta Cuota",{"$f":"+Complete!F62","v":12002.452000000001},{"$f":"+Complete!G62","v":10040.923200000001},{"$f":"+Complete!H62","v":7462.8568000000014},{"$f":"+Complete!I62","v":5714.9736000000012},{"$f":"+Complete!J62","v":4337.1832000000004}]
[]
[]
[null,null,"SECURE CARE"]
[null,null,"Deducibles"]
[null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"Secure Care",null,{"$f":"+Secure!F41","v":26173.279999999999},{"$f":"+Secure!G41","v":20515.04},{"$f":"+Secure!H41","v":15480.64},{"$f":"+Secure!I41","v":13126.4},{"$f":"+Secure!J41","v":10000.48}]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"Secure Care","1ra Cuota",{"$f":"+Secure!F53","v":13911.318400000002},{"$f":"+Secure!G53","v":10912.4512},{"$f":"+Secure!H53","v":8244.2191999999995},{"$f":"+Secure!I53","v":6996.4720000000007},{"$f":"+Secure!J53","v":5339.7343999999994}]
[null,null,null,"2da Cuota",{"$f":"+Secure!F54","v":13827.318400000002},{"$f":"+Secure!G54","v":10828.4512},{"$f":"+Secure!H54","v":8160.2191999999995},{"$f":"+Secure!I54","v":6912.4720000000007},{"$f":"+Secure!J54","v":5255.7343999999994}]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"Complete Care","1ra Cuota",{"$f":"+Secure!F66","v":7344.232},{"$f":"+Secure!G66","v":5788.2160000000013},{"$f":"+Secure!H66","v":4403.7559999999994},{"$f":"+Secure!I66","v":3756.3400000000006},{"$f":"+Secure!J66","v":2896.7120000000004}]
[null,null,null,"2da a 4ta Cuota",{"$f":"+Secure!F67","v":7260.232},{"$f":"+Secure!G67","v":5704.2160000000013},{"$f":"+Secure!H67","v":4319.7559999999994},{"$f":"+Secure!I67","v":3672.3400000000006},{"$f":"+Secure!J67","v":2812.7120000000004}]
[]
[]
[null,null,"PREMIUM CARE"]
[null,null,"Deducibles"]
[null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"Premium Care",null,{"$f":"+Premium!F44","v":27481.439999999999},{"$f":"+Premium!G44","v":21454.720000000001},{"$f":"+Premium!H44","v":16898.560000000001},{"$f":"+Premium!I44","v":13898.08},{"$f":"+Premium!J44","v":11343.36}]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"Premium Care","1ra Cuota",{"$f":"+Premium!F57","v":14604.6432},{"$f":"+Premium!G57","v":11410.481600000001},{"$f":"+Premium!H57","v":8995.7168000000001},{"$f":"+Premium!I57","v":7405.4624000000003},{"$f":"+Premium!J57","v":6051.4607999999998}]
[null,null,null,"2da Cuota",{"$f":"+Premium!F58","v":14520.6432},{"$f":"+Premium!G58","v":11326.481600000001},{"$f":"+Premium!H58","v":8911.7168000000001},{"$f":"+Premium!I58","v":7321.4624000000003},{"$f":"+Premium!J58","v":5967.4607999999998}]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"Premium Care","1ra Cuota",{"$f":"+Premium!F71","v":7618.2960000000012},{"$f":"+Premium!G71","v":5960.9480000000003},{"$f":"+Premium!H71","v":4708.0040000000008},{"$f":"+Premium!I71","v":3882.8720000000003},{"$f":"+Premium!J71","v":3180.3239999999996}]
[null,null,null,"2da a 4ta Cuota",{"$f":"+Premium!F72","v":7534.2960000000012},{"$f":"+Premium!G72","v":5876.9480000000003},{"$f":"+Premium!H72","v":4624.0040000000008},{"$f":"+Premium!I72","v":3798.8720000000003},{"$f":"+Premium!J72","v":3096.3239999999996}]
[]
[]
[null,null,"ESSENTIAL CARE"]
[null,null,"Deducibles"]
[null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,"Dentro del pais de residencia",250,250,1000,5000,10000,20000]
[null,null,"Fuera del pais de residencia",1000,5000,10000,5000,10000,20000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"Essentiial Care",{"$f":"'Bupa Essential Care'!E42","v":7321.44},{"$f":"'Bupa Essential Care'!F42","v":7067.2},{"$f":"'Bupa Essential Care'!G42","v":6600.16},{"$f":"'Bupa Essential Care'!H42","v":4618.88},{"$f":"'Bupa Essential Care'!I42","v":3505.6},{"$f":"'Bupa Essential Care'!J42","v":2640.96}]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"Essential Care",{"$f":"'Bupa Essential Care'!E55","v":3919.8432000000007},{"$f":"'Bupa Essential Care'!F55","v":3785.096},{"$f":"'Bupa Essential Care'!G55","v":3537.5648000000001},{"$f":"'Bupa Essential Care'!H55","v":2487.4864000000002},{"$f":"'Bupa Essential Care'!I55","v":1897.4480000000001},{"$f":"'Bupa Essential Care'!J55","v":1439.1887999999999}]
[null,null,null,{"$f":"'Bupa Essential Care'!E56","v":3835.8432000000007},{"$f":"'Bupa Essential Care'!F56","v":3701.096},{"$f":"'Bupa Essential Care'!G56","v":3453.5648000000001},{"$f":"'Bupa Essential Care'!H56","v":2403.4864000000002},{"$f":"'Bupa Essential Care'!I56","v":1813.4480000000001},{"$f":"'Bupa Essential Care'!J56","v":1355.1887999999999}]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"Essential Care",{"$f":"'Bupa Essential Care'!E71","v":2074.2960000000003},{"$f":"'Bupa Essential Care'!F71","v":2004.3800000000003},{"$f":"'Bupa Essential Care'!G71","v":1875.944},{"$f":"'Bupa Essential Care'!H71","v":1331.0920000000001},{"$f":"'Bupa Essential Care'!I71","v":1024.94},{"$f":"'Bupa Essential Care'!J71","v":787.16399999999999}]
[null,null,null,{"$f":"'Bupa Essential Care'!E72","v":1990.2960000000003},{"$f":"'Bupa Essential Care'!F72","v":1920.3800000000003},{"$f":"'Bupa Essential Care'!G72","v":1791.944},{"$f":"'Bupa Essential Care'!H72","v":1247.0920000000001},{"$f":"'Bupa Essential Care'!I72","v":940.94000000000017},{"$f":"'Bupa Essential Care'!J72","v":703.16399999999999}]
[]
[]
[null,null,"CLASSIC CARE"]
[null,null,"Deducibles"]
[null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"Classic Care",null,{"$f":"'Classic Care'!F44","v":14310.24},{"$f":"'Classic Care'!G44","v":11075.68},{"$f":"'Classic Care'!H44","v":7461.44},{"$f":"'Classic Care'!I44","v":5230.3999999999996},{"$f":"'Classic Care'!J44","v":3691.52}]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"Classic Care","1ra Cuota",{"$f":"+'Classic Care'!$F$57","v":7623.9072000000006},{"$f":"+'Classic Care'!$G$57","v":5909.5904},{"$f":"+'Classic Care'!$H$57","v":3994.0432000000001},{"$f":"+'Classic Care'!$I$57","v":2811.5919999999996},{"$f":"+'Classic Care'!$J$57","v":1995.9856000000002}]
[null,null,null,"2da Cuota",{"$f":"+'Classic Care'!$F$58","v":7539.9072000000006},{"$f":"+'Classic Care'!$G$58","v":5825.5904},{"$f":"+'Classic Care'!$H$58","v":3910.0432000000001},{"$f":"+'Classic Care'!$I$58","v":2727.5919999999996},{"$f":"+'Classic Care'!$J$58","v":1911.9856000000002}]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"Classic Care","1ra Cuota",{"$f":"+'Classic Care'!$F$71","v":3996.2160000000003},{"$f":"+'Classic Care'!$G$71","v":3106.712},{"$f":"+'Classic Care'!$H$71","v":2112.7960000000003},{"$f":"+'Classic Care'!$I$71","v":1499.26},{"$f":"+'Classic Care'!$J$71","v":1076.0680000000002}]
[null,null,null,"2da a 4ta Cuota",{"$f":"+'Classic Care'!$F$72","v":3912.2160000000003},{"$f":"+'Classic Care'!$G$72","v":3022.712},{"$f":"+'Classic Care'!$H$72","v":2028.7960000000003},{"$f":"+'Classic Care'!$I$72","v":1415.26},{"$f":"+'Classic Care'!$J$72","v":992.0680000000001}]
[]
[]
[null,null,"Tarifas en US $ -  Efectivas a partir del 1ro de enero de  2023"]
[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,"Bupa Guatemala, Compañía de Seguros, S.A."]
[null,null,"5 Avenida 5-55 Zona 14, Europlaza World Business Center, Torre 3, Nivel 11, Guatemala"]
[null,null,"PBX: 2300-8000 / www.bupasalud.com / servicioguatemala@bupalatinamerica.com"]

{"sheet":"Tablas","index":7,"n_rows":1208,"n_cols":12,"rows_kept":1208,"cut":false,"hidden":true,"merged":[[1137,0,1137,7],[1138,0,1138,1],[1138,2,1138,6],[1062,0,1062,1],[1062,2,1062,6],[987,0,987,7],[988,0,988,1],[988,2,988,6],[1060,0,1060,7],[1061,0,1061,7],[952,0,952,7],[953,0,953,7],[954,0,954,1],[954,2,954,6],[986,0,986,7],[918,0,918,7],[919,0,919,7],[920,0,920,1],[920,2,920,6],[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[342,0,342,7],[269,0,269,7],[270,0,270,7],[271,0,271,1],[271,2,271,6],[170,2,170,6],[202,0,202,7],[236,0,236,7],[237,0,237,1],[237,2,237,6],[204,0,204,1],[204,2,204,6],[628,0,628,7],[482,0,482,7],[483,0,483,7],[484,0,484,1],[484,2,484,6],[343,2,343,6],[415,0,415,7],[555,0,555,7],[556,0,556,1],[556,2,556,6],[343,0,343,1],[449,0,449,7],[450,0,450,1],[450,2,450,6],[416,0,416,7],[417,0,417,1],[417,2,417,6],[629,0,629,7],[630,0,630,1],[630,2,630,6],[701,0,701,7],[702,0,702,1],[702,2,702,6],[847,0,847,1],[847,2,847,6],[773,0,773,7],[774,0,774,7],[775,0,775,1],[775,2,775,6],[846,0,846,7]]}
[]
["BUPA COMPLETE GUATEMALA",null,null,null,null,null,null,null,null,"FACTOR SEMESTRAL :",null,0.53]
["TARIFAS ANUALES",null,null,null,null,null,null,null,null,"FACTOR TRIMESTRAL :",null,0.27500000000000002]
["EDAD"]
[" "," ","DW1","DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",19769,12028,8238,5783,3992,3051,null,"Descuento (15%)",null,1]
[25,"-  29",20759,12602,9147,6426,4379,3365]
[30,"-  34",21668,13182,9802,7149,5322,4071]
[35,"-  39",24218,14748,10958,8028,5945,4540]
[40,"-  44",27430,17132,12028,8914,6570,5006]
[45,"-  49",30644,19113,13428,9954,7353,5632]
[50,"-  54",40445,24958,17712,13088,10480,8058]
[55,"-  59",42996,26604,18863,13970,11181,8525]
[60,null,45633,28913,20513,15896,13293,10712]
[61,null,49010,31053,21998,17020,14310,11496]
[62,null,53622,34018,24054,18627,15635,12587]
[63,null,57000,36160,25617,19832,16656,13370]
[64,null,61695,39125,27678,21438,17985,14466]
[65,null,64655,51153,36160,27135,24004,20405]
[66,null,67540,59469,42010,31547,27914,23688]
[67,null,73800,64906,45881,34436,30492,25880]
[68,null,81624,71906,50820,38130,33774,28694]
[69,null,89775,79073,55847,41985,37136,31505]
[70,null,106253,97355,68033,49366,43234,37058]
[71,null,110454,101145,70673,51297,44955,38544]
[72,null,113583,104027,72730,52740,46204,39639]
[73,null,117700,107817,75368,54670,47922,41123]
[74,null,119840,109794,76684,55712,48784,41828]
[75,"o más",125032,114570,80058,58115,50896,43624]
[1,"Hijo",6674,4205,3050,2333,1958,1409]
[2,"Hijos",10462,6674,4862,3698,3051,2272]
[3,"Hijos o más",15242,9719,7086,5464,4457,3290]
[1,"Rider Comp. Maternidad",0,0,0,225,225,225]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","DW1","DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",{"$f":"C6*$L$2","v":10477.57},{"$f":"D6*$L$2","v":6374.84},4366.1400000000003,3064.9900000000002,2115.7600000000002,1617.03]
[25,"-  29",{"$f":"C7*$L$2","v":11002.27},6679.06,4847.91,3405.78,2320.87,1783.45]
[30,"-  34",{"$f":"C8*$L$2","v":11484.04},6986.46,5195.0600000000004,3788.9700000000003,2820.6600000000003,2157.63]
[35,"-  39",{"$f":"C9*$L$2","v":12835.54},7816.4400000000005,5807.7400000000007,4254.84,3150.8500000000004,2406.2000000000003]
[40,"-  44",{"$f":"C10*$L$2","v":14537.900000000001},9079.9600000000009,6374.84,4724.42,3482.1000000000004,2653.1800000000003]
[45,"-  49",{"$f":"C11*$L$2","v":16241.320000000002},10129.890000000001,7116.84,5275.62,3897.09,2984.96]
[50,"-  54",{"$f":"C12*$L$2","v":21435.850000000002},13227.74,9387.36,6936.64,5554.4000000000005,4270.74]
[55,"-  59",{"$f":"C13*$L$2","v":22787.88},14100.12,9997.3900000000012,7404.1,5925.93,4518.25]
[60,null,{"$f":"C14*$L$2","v":24185.49},15323.890000000001,10871.890000000001,8424.880000000001,7045.29,5677.3600000000006]
[61,null,{"$f":"C15*$L$2","v":25975.300000000003},16458.09,11658.94,9020.6,7584.3,6092.88]
[62,null,{"$f":"C16*$L$2","v":28419.66},18029.54,12748.62,9872.3100000000013,8286.5500000000011,6671.1100000000006]
[63,null,{"$f":"C17*$L$2","v":30210},19164.8,13577.01,10510.960000000001,8827.68,7086.1]
[64,null,{"$f":"C18*$L$2","v":32698.350000000002},20736.25,14669.34,11362.140000000001,9532.0500000000011,7666.9800000000005]
[65,null,{"$f":"C19*$L$2","v":34267.15},27111.09,19164.8,14381.550000000001,12722.12,10814.65]
[66,null,{"$f":"C20*$L$2","v":35796.200000000004},31518.570000000003,22265.300000000003,16719.91,14794.42,12554.640000000001]
[67,null,{"$f":"C21*$L$2","v":39114},34400.18,24316.93,18251.080000000002,16160.76,13716.400000000001]
[68,null,{"$f":"C22*$L$2","v":43260.72},38110.18,26934.600000000002,20208.900000000001,17900.22,15207.820000000002]
[69,null,{"$f":"C23*$L$2","v":47580.75},41908.69,29598.91,22252.050000000003,19682.080000000002,16697.650000000001]
[70,null,{"$f":"C24*$L$2","v":56314.090000000004},51598.15,36057.490000000005,26163.98,22914.02,19640.740000000002]
[71,null,{"$f":"C25*$L$2","v":58540.62},53606.850000000006,37456.69,27187.41,23826.15,20428.32]
[72,null,{"$f":"C26*$L$2","v":60198.990000000005},55134.310000000005,38546.9,27952.2,24488.120000000003,21008.670000000002]
[73,null,{"$f":"C27*$L$2","v":62381},57143.01,39945.040000000001,28975.100000000002,25398.66,21795.190000000002]
[74,null,{"$f":"C28*$L$2","v":63515.200000000004},58190.82,40642.520000000004,29527.360000000001,25855.52,22168.84]
[75,"o más",{"$f":"C29*$L$2","v":66266.960000000006},60722.100000000006,42430.740000000005,30800.95,26974.880000000001,23120.720000000001]
[1,"Hijo",{"$f":"C30*$L$2","v":3537.2200000000003},2228.65,1616.5,1236.49,1037.74,746.77]
[2,"Hijos",{"$f":"C31*$L$2","v":5544.8600000000006},3537.2200000000003,2576.86,1959.94,1617.03,1204.1600000000001]
[3,"Hijos o más",{"$f":"C32*$L$2","v":8078.26},5151.0700000000006,3755.5800000000004,2895.92,2362.21,1743.7]
[1,"Rider Comp. Maternidad",{"$f":"+C33*$L$2","v":0},0,0,119.25,119.25,119.25]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["Other Product"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","DL1","DL2","DL3","DL4","DL5","DL6"]
[18,"-  24",4794,2952,1949,1401,993,779]
[25,"-  29",5028,3097,2156,1553,1103,867]
[30,"-  34",5200,3223,2312,1743,1322,1041]
[35,"-  39",5816,3609,2590,1951,1483,1168]
[40,"-  44",6733,4186,2831,2168,1630,1284]
[45,"-  49",7517,4680,3168,2425,1824,1436]
[50,"-  54",9772,5991,4158,3164,2578,2033]
[55,"-  59",10394,6374,4426,3365,2744,2164]
[60,null,11056,6945,4828,3871,3307,2688]
[61,null,11876,7463,5187,4159,3555,2886]
[62,null,12994,8172,5684,4557,3892,3162]
[63,null,13812,8687,6042,4844,4139,3362]
[64,null,14936,9396,6539,5242,4475,3639]
[65,null,15651,12288,8530,6629,5974,5139]
[66,null,16363,14275,9911,7703,6942,5968]
[67,null,17867,15595,10826,8416,7581,6521]
[68,null,19780,17268,11986,9320,8398,7220]
[69,null,21758,18999,13190,10254,9240,7945]
[70,null,25748,23384,16061,12071,10768,9345]
[71,null,26759,24303,16691,12545,11190,9716]
[72,null,27512,24990,17164,12900,11507,9987]
[73,null,28525,25911,17793,13375,11931,10356]
[74,null,29026,26368,18111,13609,12143,10540]
[75,"o más",30287,27515,18898,14204,12670,11001]
[1,"Hijo",1660,1027,758,629,527,413]
[2,"Hijos",2608,1634,1204,999,841,656]
[3,"Hijos o más",3798,2395,1766,1465,1234,961]
[1,"Rider Comp. Maternidad",0,0,0,225,225,225]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","DL1","DL2","DL3","DL4","DL5","DL6"]
[18,"-  24",{"$f":"+C73*$L$2","v":2540.8200000000002},1564.5600000000002,1032.97,742.53000000000009,526.29000000000008,412.87]
[25,"-  29",2664.84,1641.41,1142.68,823.09,584.59,459.51000000000005]
[30,"-  34",2756,1708.19,1225.3600000000001,923.79000000000008,700.66000000000008,551.73]
[35,"-  39",3082.48,1912.7700000000002,1372.7,1034.03,785.99,619.04000000000008]
[40,"-  44",3568.4900000000002,2218.58,1500.43,1149.04,863.90000000000009,680.52]
[45,"-  49",3984.01,2480.4,1679.0400000000002,1285.25,966.72,761.08]
[50,"-  54",5179.16,3175.23,2203.7400000000002,1676.92,1366.3400000000001,1077.49]
[55,"-  59",5508.8200000000006,3378.2200000000003,2345.7800000000002,1783.45,1454.3200000000002,1146.92]
[60,null,5859.68,3680.8500000000004,2558.84,2051.63,1752.71,1424.64]
[61,null,6294.2800000000007,3955.3900000000003,2749.11,2204.27,1884.15,1529.5800000000002]
[62,null,{"$f":"+C83*$L$2","v":6886.8200000000006},4331.16,3012.52,2415.21,2062.7600000000002,1675.8600000000001]
[63,null,7320.3600000000006,4604.1100000000006,3202.26,2567.3200000000002,2193.67,1781.8600000000001]
[64,null,7916.0800000000008,4979.88,3465.67,2778.26,2371.75,1928.67]
[65,null,8295.0300000000007,6512.64,4520.9000000000005,3513.3700000000003,3166.2200000000003,2723.67]
[66,null,8672.3900000000012,7565.75,5252.83,4082.59,3679.26,3163.04]
[67,null,9469.51,8265.35,5737.7800000000007,4460.4800000000005,4017.9300000000003,3456.13]
[68,null,10483.4,9152.0400000000009,6352.58,4939.6000000000004,4450.9400000000005,3826.6000000000004]
[69,null,11531.74,10069.470000000001,6990.7000000000007,5434.62,4897.2,4210.8500000000004]
[70,null,13646.44,12393.52,8512.33,6397.63,5707.04,4952.8500000000004]
[71,null,14182.27,12880.59,8846.23,6648.85,5930.7000000000007,5149.4800000000005]
[72,null,{"$f":"+C93*$L$2","v":14581.36},13244.7,9096.92,6837,6098.71,5293.1100000000006]
[73,null,15118.25,13732.83,9430.2900000000009,7088.75,6323.43,5488.68]
[74,null,15383.78,13975.04,9598.83,7212.77,6435.79,5586.2000000000007]
[75,"o más",16052.11,14582.95,10015.94,7528.1200000000008,6715.1,5830.5300000000007]
[1,"Hijo",879.80000000000007,544.31000000000006,401.74,333.37,279.31,218.89000000000001]
[2,"Hijos",1382.24,866.0200000000001,638.12,529.47,445.73,347.68]
[3,"Hijos o más",2012.94,1269.3500000000001,935.98,776.45,654.02,509.33000000000004]
[1,"Rider Comp. Maternidad",0,0,0,119.25,119.25,119.25]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["BUPA SECURE GUATEMALA"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","CW1","CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",6972,5882,4605,3434,2919,2187]
[25,"-  29",7736,6459,5181,3864,3222,2432]
[30,"-  34",8891,7419,6076,4490,3766,2859]
[35,"-  39",9846,8187,6843,4991,4192,3156]
[40,"-  44",11127,9142,7803,5615,4739,3586]
[45,"-  49",12915,10552,9142,6548,5530,4132]
[50,"-  54",14129,11512,10041,7173,6016,4558]
[55,"-  59",16624,13554,12017,8480,7169,5349]
[60,null,17583,14195,12851,8978,7596,5651]
[61,null,19756,15984,14450,10164,8506,6380]
[62,null,21993,17772,16048,11286,9478,7108]
[63,null,24166,19503,17646,12407,10450,7835]
[64,null,26403,21290,19307,13527,11417,8566]
[65,null,26471,21354,19436,13654,11483,8566]
[66,null,26595,21354,19628,13714,11542,8566]
[67,null,29532,23717,21864,15210,12815,9539]
[68,null,32477,26082,24038,16768,14093,10512]
[69,null,34012,27298,25126,17519,14760,10997]
[70,null,34203,27363,25510,17705,14879,11055]
[71,null,38548,30754,28770,19947,16764,12455]
[72,null,42833,34203,31967,22127,18585,13848]
[73,null,47116,37656,35160,24375,20468,15246]
[74,null,51398,41044,38358,26615,22349,16644]
[75,"o más",56128,44752,42068,29109,24416,18162]
[1,"Hijo",3135,2813,1666,1374,1157,855]
[2,"Hijos",5181,4798,2499,2184,1824,1338]
[3,"Hijos o más",7546,7032,3584,3182,2673,2008]
[1,"Rider Comp. Maternidad",0,225,225,225,225,225]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","CW1","CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",{"$f":"C140*$L$2","v":3695.1600000000003},{"$f":"D140*$L$2","v":3117.46},2440.65,1820.02,1547.0700000000002,1159.1100000000001]
[25,"-  29",{"$f":"C141*$L$2","v":4100.08},3423.27,2745.9300000000003,2047.92,1707.66,1288.96]
[30,"-  34",{"$f":"C142*$L$2","v":4712.2300000000005},3932.07,3220.28,2379.7000000000003,1995.98,1515.27]
[35,"-  39",{"$f":"C143*$L$2","v":5218.38},4339.1100000000006,3626.79,2645.23,2221.7600000000002,1672.68]
[40,"-  44",{"$f":"C144*$L$2","v":5897.31},4845.26,4135.59,2975.9500000000003,2511.67,1900.5800000000002]
[45,"-  49",{"$f":"C145*$L$2","v":6844.9500000000007},5592.56,4845.26,3470.44,2930.9,2189.96]
[50,"-  54",{"$f":"C146*$L$2","v":7488.3700000000008},6101.3600000000006,5321.7300000000005,3801.69,3188.48,2415.7400000000002]
[55,"-  59",{"$f":"C147*$L$2","v":8810.7200000000012},7183.6200000000008,6369.01,4494.4000000000005,3799.57,2834.9700000000003]
[60,null,{"$f":"C148*$L$2","v":9318.99},7523.35,6811.0300000000007,4758.34,4025.88,2995.03]
[61,null,{"$f":"C149*$L$2","v":10470.68},8471.52,7658.5,5386.92,4508.18,3381.4]
[62,null,{"$f":"C150*$L$2","v":11656.29},9419.16,8505.44,5981.58,5023.34,3767.2400000000002]
[63,null,{"$f":"C151*$L$2","v":12807.980000000001},10336.59,9352.380000000001,6575.71,5538.5,4152.55]
[64,null,{"$f":"C152*$L$2","v":13993.59},11283.7,10232.710000000001,7169.31,6051.01,4539.9800000000005]
[65,null,{"$f":"C153*$L$2","v":14029.630000000001},11317.62,10301.08,7236.6200000000008,6085.9900000000007,4539.9800000000005]
[66,null,{"$f":"C154*$L$2","v":14095.35},11317.62,10402.84,7268.42,6117.26,4539.9800000000005]
[67,null,{"$f":"C155*$L$2","v":15651.960000000001},12570.01,11587.92,8061.3,6791.9500000000007,5055.67]
[68,null,{"$f":"C156*$L$2","v":17212.810000000001},13823.460000000001,12740.140000000001,8887.0400000000009,7469.29,5571.3600000000006]
[69,null,{"$f":"C157*$L$2","v":18026.36},14467.94,13316.78,9285.07,7822.8,5828.41]
[70,null,{"$f":"C158*$L$2","v":18127.59},14502.390000000001,13520.300000000001,9383.65,7885.8700000000008,5859.1500000000005]
[71,null,{"$f":"C159*$L$2","v":20430.440000000002},16299.62,15248.1,10571.91,8884.92,6601.1500000000005]
[72,null,{"$f":"C160*$L$2","v":22701.49},18127.59,16942.510000000002,11727.310000000001,9850.0500000000011,7339.4400000000005]
[73,null,{"$f":"C161*$L$2","v":24971.48},19957.68,18634.8,12918.75,10848.04,8080.38]
[74,null,{"$f":"C162*$L$2","v":27240.940000000002},21753.32,20329.740000000002,14105.95,11844.970000000001,8821.32]
[75,"o más",{"$f":"C163*$L$2","v":29747.84},23718.560000000001,22296.04,15427.77,12940.480000000001,9625.86]
[1,"Hijo",{"$f":"C164*$L$2","v":1661.5500000000002},1490.89,882.98,728.22,613.21,453.15000000000003]
[2,"Hijos",{"$f":"C165*$L$2","v":2745.9300000000003},2542.94,1324.47,1157.52,966.72,709.14]
[3,"Hijos o más",{"$f":"C166*$L$2","v":3999.38},3726.96,1899.52,1686.46,1416.69,1064.24]
[1,"Rider Comp. Maternidad",{"$f":"+C167*$L$2","v":0},119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["COMPLETE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","CL1","CL2","CL3","CL4","CL5","CL6"]
[18,"-  24",4108,2493,1711,1222,864,656]
[25,"-  29",4312,2617,1893,1355,958,727]
[30,"-  34",4497,2733,2028,1520,1162,884]
[35,"-  39",5030,3059,2271,1704,1304,991]
[40,"-  44",5699,3544,2490,1897,1437,1095]
[45,"-  49",6362,3962,2784,2121,1606,1226]
[50,"-  54",8400,5181,3675,2788,2297,1752]
[55,"-  59",8934,5515,3910,2965,2444,1865]
[60,null,9484,6004,4246,3377,2908,2333]
[61,null,10185,6452,4562,3627,3125,2507]
[62,null,11146,7062,4997,3973,3422,2746]
[63,null,11845,7510,5314,4224,3639,2920]
[64,null,12809,8124,5749,4572,3937,3161]
[65,null,13423,10620,7502,5783,5253,4458]
[66,null,14033,12341,8716,6718,6105,5183]
[67,null,15322,13481,9521,7338,6668,5662]
[68,null,16961,14927,10543,8127,7387,6271]
[69,null,18656,16424,11600,8941,8127,6900]
[70,null,22081,20216,14125,10526,9470,8117]
[71,null,22943,21009,14681,10940,9844,8436]
[72,null,23592,21603,15097,11250,10123,8676]
[73,null,24457,22398,15651,11665,10493,8996]
[74,null,24890,22795,15928,11869,10680,9155]
[75,"o más",25970,23787,16621,12385,11147,9552]
[1,"Hijo",1395,867,632,499,421,313]
[2,"Hijos",2187,1379,1009,795,669,498]
[3,"Hijos o más",3179,2023,1479,1166,983,727]
[1,"Rider Comp. Maternidad",0,0,0,225,225,225]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","CL1","CL2","CL3","CL4","CL5","CL6"]
[18,"-  24",{"$f":"+C207*$L$2","v":2177.2400000000002},1321.29,906.83,647.66000000000008,457.92,347.68]
[25,"-  29",2285.36,1387.01,1003.2900000000001,718.15000000000009,507.74,385.31]
[30,"-  34",2383.4100000000003,1448.49,1074.8400000000001,805.6,615.86,468.52000000000004]
[35,"-  39",2665.9,1621.27,1203.6300000000001,903.12,691.12,525.23]
[40,"-  44",3020.4700000000003,1878.3200000000002,1319.7,1005.4100000000001,761.61,580.35]
[45,"-  49",3371.86,2099.86,1475.52,1124.1300000000001,851.18000000000006,649.78000000000009]
[50,"-  54",4452,2745.9300000000003,1947.75,1477.64,1217.4100000000001,928.56000000000006]
[55,"-  59",4735.0200000000004,2922.9500000000003,2072.3000000000002,1571.45,1295.3200000000002,988.45]
[60,null,5026.5200000000004,3182.1200000000003,2250.38,1789.8100000000002,1541.24,1236.49]
[61,null,5398.05,3419.56,2417.86,1922.3100000000002,1656.25,1328.71]
[62,null,{"$f":"+C217*$L$2","v":5907.38},3742.86,2648.4100000000003,2105.69,1813.66,1455.38]
[63,null,6277.85,3980.3,2816.42,2238.7200000000003,1928.67,1547.6000000000001]
[64,null,6788.77,4305.72,3046.9700000000003,2423.1600000000003,2086.61,1675.3300000000002]
[65,null,7114.1900000000005,5628.6,3976.0600000000004,3064.9900000000002,2784.09,2362.7400000000002]
[66,null,7437.4900000000007,6540.7300000000005,4619.4800000000005,3560.54,3235.65,2746.9900000000002]
[67,null,8120.6600000000008,7144.93,5046.13,3889.1400000000003,3534.04,3000.86]
[68,null,8989.33,7911.31,5587.79,4307.3100000000004,3915.11,3323.63]
[69,null,9887.68,8704.7200000000012,6148,4738.7300000000005,4307.3100000000004,3657]
[70,null,11702.93,10714.480000000001,7486.25,5578.7800000000007,5019.1000000000004,4302.01]
[71,null,12159.79,11134.77,7780.93,5798.2000000000007,5217.3200000000006,4471.08]
[72,null,{"$f":"+C227*$L$2","v":12503.76},11449.59,8001.4100000000008,5962.5,5365.1900000000005,4598.2800000000007]
[73,null,12962.210000000001,11870.94,8295.0300000000007,6182.4500000000007,5561.29,4767.88]
[74,null,13191.7,12081.35,8441.84,6290.5700000000006,5660.4000000000005,4852.1500000000005]
[75,"o más",13764.1,12607.11,8809.130000000001,6564.05,5907.91,5062.5600000000004]
[1,"Hijo",739.35,459.51000000000005,334.96000000000004,264.47000000000003,223.13000000000002,165.89000000000001]
[2,"Hijos",1159.1100000000001,730.87,534.77,421.35,354.57,263.94]
[3,"Hijos o más",1684.8700000000001,1072.19,783.87,617.98,520.99,385.31]
[1,"Rider Comp. Maternidad",0,0,0,119.25,119.25,119.25]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["PREMIUM GUATEMALA"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,{"$f":"J274*$L$6","v":0},6166,4596,3333,2501,1970]
[19,null,{"$f":"J275*$L$6","v":0},6220,4653,3388,2553,2024]
[20,null,0,6330,4764,3443,2609,2076]
[21,null,0,6443,4876,3554,2609,2076]
[22,null,0,6555,4930,3605,2662,2130]
[23,null,0,6724,5045,3659,2714,2183]
[24,null,0,6834,5157,3714,2766,2183]
[25,null,0,6945,5212,3768,2819,2235]
[26,null,0,7061,5322,3879,2874,2291]
[27,null,0,7173,5434,3933,2926,2343]
[28,null,0,7283,5549,4043,3032,2343]
[29,null,0,7452,5660,4096,3087,2394]
[30,null,0,7620,5828,4203,3140,2447]
[31,null,0,7731,5939,4317,3245,2501]
[32,null,0,7901,6050,4427,3299,2553]
[33,null,0,8068,6220,4534,3404,2609]
[34,null,0,8290,6387,4696,3512,2662]
[35,null,0,8459,6555,4860,3617,2714]
[36,null,0,8682,6724,4971,3725,2766]
[37,null,0,8853,6891,5134,3830,2819]
[38,null,0,9077,7061,5296,3938,2926]
[39,null,0,9298,7283,5462,4043,2979]
[40,null,0,9526,7509,5627,4204,3032]
[41,null,0,9804,7677,5844,4311,3087]
[42,null,0,10030,7901,6010,4469,3195]
[43,null,0,10305,8123,6225,4629,3245]
[44,null,0,10586,8405,6444,4788,3353]
[45,null,0,10871,8630,6660,4947,3404]
[46,null,0,11147,8909,6881,5104,3512]
[47,null,0,11427,9134,7154,5267,3564]
[48,null,0,11766,9468,7427,5481,3670]
[49,null,0,12156,9804,7754,5692,3778]
[50,null,0,12546,10140,8080,5904,3882]
[51,null,0,12884,10475,8411,6116,3989]
[52,null,0,13276,10871,8682,6330,4094]
[53,null,0,13725,11261,9116,6650,4204]
[54,null,0,14229,11705,9501,6914,4362]
[55,null,0,14676,12156,9935,7178,4469]
[56,null,0,15126,12546,10317,7499,4629]
[57,null,0,15629,12999,10757,7760,4733]
[58,null,0,16245,13557,11302,8138,4894]
[59,null,0,16860,14117,11847,8508,5051]
[60,null,0,17421,14676,12393,8878,5212]
[61,null,0,18263,15461,13103,9411,5481]
[62,null,0,19380,16524,14194,10102,5742]
[63,null,0,21003,18035,15615,11169,6170]
[64,null,0,23248,20110,17577,12600,6808]
[65,null,0,26102,22907,20091,14462,7658]
[66,null,0,29628,26328,23092,16748,8720]
[67,null,0,33549,30134,26474,19300,9996]
[68,null,0,37750,34335,30134,22008,11326]
[69,null,0,42176,38758,33898,24934,12818]
[70,null,0,46769,43296,37829,27909,14302]
[71,null,0,51470,47999,41867,30995,15844]
[72,null,0,56344,52816,46014,34132,17490]
[73,null,0,61271,57746,50273,37373,19139]
[74,null,0,66312,62783,54586,40667,20786]
[75,null,0,71468,67938,58952,44015,22541]
[76,null,0,71468,67938,58952,44015,22541]
[77,null,0,71468,67938,58952,44015,22541]
[78,null,0,71468,67938,58952,44015,22541]
[79,null,0,71468,67938,58952,44015,22541]
[80,"o mas",0,71468,67938,58952,44015,22541]
[1,"Hijo",0,2859,2075,1532,1332,960]
[2,"Hijos",0,4709,3252,2405,2076,1383]
[3,"Hijos o más",{"$f":"J339*$L$6","v":0},6891,4709,3554,3032,2130]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[null,"Deductible Waiver",null,180,345,775,1330,2080]
["TARIFAS SEMESTRALES "]
["EDAD",null,null,null,null,null,null,null,"NO HAY"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,{"$f":"C274*$L$2","v":0},{"$f":"D274*$L$2","v":3267.98},2435.88,1766.49,1325.53,1044.1000000000001]
[19,null,{"$f":"C275*$L$2","v":0},3296.6000000000004,2466.09,1795.64,1353.0900000000001,1072.72]
[20,null,{"$f":"C276*$L$2","v":0},3354.9,2524.92,1824.7900000000002,1382.77,1100.28]
[21,null,{"$f":"C277*$L$2","v":0},3414.79,2584.2800000000002,1883.6200000000001,1382.77,1100.28]
[22,null,{"$f":"C278*$L$2","v":0},3474.15,2612.9,1910.65,1410.8600000000001,1128.9000000000001]
[23,null,{"$f":"C279*$L$2","v":0},3563.7200000000003,2673.85,1939.2700000000002,1438.42,1156.99]
[24,null,{"$f":"C280*$L$2","v":0},3622.02,2733.21,1968.42,1465.98,1156.99]
[25,null,{"$f":"C281*$L$2","v":0},3680.8500000000004,2762.36,1997.0400000000002,1494.0700000000002,1184.55]
[26,null,{"$f":"C282*$L$2","v":0},3742.3300000000004,2820.6600000000003,2055.87,1523.22,1214.23]
[27,null,{"$f":"C283*$L$2","v":0},3801.69,2880.02,2084.4900000000002,1550.78,1241.79]
[28,null,{"$f":"C284*$L$2","v":0},3859.9900000000002,2940.9700000000003,2142.79,1606.96,1241.79]
[29,null,{"$f":"C285*$L$2","v":0},3949.5600000000004,2999.8,2170.88,1636.1100000000001,1268.8200000000002]
[30,null,{"$f":"C286*$L$2","v":0},4038.6000000000004,3088.84,2227.59,1664.2,1296.9100000000001]
[31,null,{"$f":"C287*$L$2","v":0},4097.43,3147.67,2288.0100000000002,1719.8500000000001,1325.53]
[32,null,{"$f":"C288*$L$2","v":0},4187.5300000000007,3206.5,2346.31,1748.47,1353.0900000000001]
[33,null,{"$f":"C289*$L$2","v":0},4276.04,3296.6000000000004,2403.02,1804.1200000000001,1382.77]
[34,null,{"$f":"C290*$L$2","v":0},4393.7,3385.11,2488.88,1861.3600000000001,1410.8600000000001]
[35,null,{"$f":"C291*$L$2","v":0},4483.2700000000004,3474.15,2575.8000000000002,1917.01,1438.42]
[36,null,{"$f":"C292*$L$2","v":0},4601.46,3563.7200000000003,2634.63,1974.25,1465.98]
[37,null,{"$f":"C293*$L$2","v":0},4692.09,3652.23,2721.02,2029.9,1494.0700000000002]
[38,null,{"$f":"C294*$L$2","v":0},4810.8100000000004,3742.3300000000004,2806.88,2087.1400000000003,1550.78]
[39,null,{"$f":"C295*$L$2","v":0},4927.9400000000005,3859.9900000000002,2894.86,2142.79,1578.8700000000001]
[40,null,{"$f":"C296*$L$2","v":0},5048.7800000000007,3979.77,2982.31,2228.12,1606.96]
[41,null,{"$f":"C297*$L$2","v":0},5196.12,4068.8100000000004,3097.32,2284.83,1636.1100000000001]
[42,null,{"$f":"C298*$L$2","v":0},5315.9000000000005,4187.5300000000007,3185.3,2368.5700000000002,1693.3500000000001]
[43,null,{"$f":"C299*$L$2","v":0},5461.6500000000005,4305.1900000000005,3299.25,2453.3700000000003,1719.8500000000001]
[44,null,{"$f":"C300*$L$2","v":0},5610.58,4454.6500000000005,3415.32,2537.6400000000003,1777.0900000000001]
[45,null,{"$f":"C301*$L$2","v":0},5761.63,4573.9000000000005,3529.8,2621.9100000000003,1804.1200000000001]
[46,null,{"$f":"C302*$L$2","v":0},5907.91,4721.7700000000004,3646.9300000000003,2705.1200000000003,1861.3600000000001]
[47,null,{"$f":"C303*$L$2","v":0},6056.31,4841.0200000000004,3791.6200000000003,2791.51,1888.92]
[48,null,{"$f":"C304*$L$2","v":0},6235.9800000000005,5018.04,3936.3100000000004,2904.9300000000003,1945.1000000000001]
[49,null,{"$f":"C305*$L$2","v":0},6442.68,5196.12,4109.62,3016.76,2002.3400000000001]
[50,null,{"$f":"C306*$L$2","v":0},6649.38,5374.2,4282.4000000000005,3129.1200000000003,2057.46]
[51,null,{"$f":"C307*$L$2","v":0},6828.52,5551.75,4457.83,3241.48,2114.17]
[52,null,{"$f":"C308*$L$2","v":0},7036.2800000000007,5761.63,4601.46,3354.9,2169.8200000000002]
[53,null,{"$f":"C309*$L$2","v":0},7274.25,5968.33,4831.4800000000005,3524.5,2228.12]
[54,null,{"$f":"C310*$L$2","v":0},7541.3700000000008,6203.6500000000005,5035.5300000000007,3664.42,2311.86]
[55,null,{"$f":"C311*$L$2","v":0},7778.2800000000007,6442.68,5265.55,3804.34,2368.5700000000002]
[56,null,{"$f":"C312*$L$2","v":0},8016.7800000000007,6649.38,5468.01,3974.4700000000003,2453.3700000000003]
[57,null,{"$f":"C313*$L$2","v":0},8283.3700000000008,6889.47,5701.21,4112.8,2508.4900000000002]
[58,null,{"$f":"C314*$L$2","v":0},8609.85,7185.21,5990.06,4313.1400000000003,2593.8200000000002]
[59,null,{"$f":"C315*$L$2","v":0},8935.8000000000011,7482.01,6278.9100000000008,4509.24,2677.03]
[60,null,{"$f":"C316*$L$2","v":0},9233.130000000001,7778.2800000000007,6568.29,4705.34,2762.36]
[61,null,{"$f":"C317*$L$2","v":0},9679.3900000000012,8194.33,6944.59,4987.83,2904.9300000000003]
[62,null,{"$f":"C318*$L$2","v":0},10271.4,8757.7200000000012,7522.8200000000006,5354.06,3043.26]
[63,null,{"$f":"C319*$L$2","v":0},11131.59,9558.5500000000011,8275.9500000000007,5919.5700000000006,3270.1000000000004]
[64,null,{"$f":"C320*$L$2","v":0},12321.44,10658.300000000001,9315.8100000000013,6678,3608.2400000000002]
[65,null,{"$f":"C321*$L$2","v":0},13834.060000000001,12140.710000000001,10648.230000000001,7664.8600000000006,4058.7400000000002]
[66,null,{"$f":"C322*$L$2","v":0},15702.84,13953.84,12238.76,8876.44,4621.6000000000004]
[67,null,{"$f":"C323*$L$2","v":0},17780.97,15971.02,14031.220000000001,10229,5297.88]
[68,null,{"$f":"C324*$L$2","v":0},20007.5,18197.55,15971.02,11664.24,6002.7800000000007]
[69,null,{"$f":"C325*$L$2","v":0},22353.280000000002,20541.740000000002,17965.940000000002,13215.02,6793.54]
[70,null,{"$f":"C326*$L$2","v":0},24787.57,22946.880000000001,20049.370000000003,14791.77,7580.06]
[71,null,{"$f":"C327*$L$2","v":0},27279.100000000002,25439.47,22189.510000000002,16427.350000000002,8397.32]
[72,null,{"$f":"C328*$L$2","v":0},29862.32,27992.480000000003,24387.420000000002,18089.96,9269.7000000000007]
[73,null,{"$f":"C329*$L$2","v":0},32473.63,30605.38,26644.690000000002,19807.690000000002,10143.67]
[74,null,{"$f":"C330*$L$2","v":0},35145.360000000001,33274.990000000005,28930.58,21553.510000000002,11016.58]
[75,null,{"$f":"C331*$L$2","v":0},37878.04,36007.14,31244.560000000001,23327.95,11946.730000000001]
[76,null,{"$f":"C332*$L$2","v":0},37878.04,36007.14,31244.560000000001,23327.95,11946.730000000001]
[77,null,{"$f":"C333*$L$2","v":0},37878.04,36007.14,31244.560000000001,23327.95,11946.730000000001]
[78,null,{"$f":"C334*$L$2","v":0},37878.04,36007.14,31244.560000000001,23327.95,11946.730000000001]
[79,null,{"$f":"C335*$L$2","v":0},37878.04,36007.14,31244.560000000001,23327.95,11946.730000000001]
[80,"o mas",{"$f":"C336*$L$2","v":0},37878.04,36007.14,31244.560000000001,23327.95,11946.730000000001]
[1,"Hijo",{"$f":"C337*$L$2","v":0},1515.27,1099.75,811.96,705.96,508.8]
[2,"Hijos",{"$f":"C338*$L$2","v":0},2495.77,1723.5600000000002,1274.6500000000001,1100.28,732.99]
[3,"Hijos o más",{"$f":"C339*$L$2","v":0},3652.23,2495.77,1883.6200000000001,1606.96,1128.9000000000001]
[1,"Rider Comp. Maternidad",{"$f":"+C340*$L$2","v":0},119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",0,159,159,159,159,159]
[null,"Deductible Waiver",null,{"$f":"+D342*$L$2","v":95.4},{"$f":"+E342*$L$2","v":182.85000000000002},{"$f":"+F342*$L$2","v":410.75},{"$f":"+G342*$L$2","v":704.90000000000009},{"$f":"+H342*$L$2","v":1102.4000000000001}]
[]
["ADVANTAGE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","AL1","AL2","AL3","AL4","AL5","AL6"]
[18,"-  24",2323,3529,2653,2029,1555,1231]
[25,"-  29",2595,3931,2960,2256,1736,1363]
[30,"-  34",3035,4550,3480,2690,2059,1587]
[35,"-  39",3425,5045,3876,2993,2348,1760]
[40,"-  44",3878,5694,4395,3396,2625,1992]
[45,"-  49",4483,6617,5063,3827,2988,2317]
[50,"-  54",5074,7252,5692,4463,3354,2545]
[55,"-  59",5880,8569,6573,4936,3891,3010]
[60,null,6256,9468,7278,5429,4290,3333]
[61,null,7042,10658,8188,6113,4832,3756]
[62,null,7827,11845,9109,6796,5373,4175]
[63,null,8613,13033,10021,7480,5914,4598]
[64,null,9397,14223,10937,8165,6457,5014]
[65,null,10323,15378,11902,8897,7032,5708]
[66,null,10933,16284,12602,9424,7448,6051]
[67,null,12149,18099,14009,10474,8283,6725]
[68,null,13367,19911,15411,11526,9115,7400]
[69,null,13974,20818,16114,12048,9529,7741]
[70,null,14272,21084,16371,12234,9708,7843]
[71,null,16060,23726,18422,13767,10928,8825]
[72,null,17843,26369,20478,15303,12144,9810]
[73,null,19631,29008,22530,16836,13363,10795]
[74,null,21416,31650,24579,18368,14581,11779]
[75,"o más",23387,34622,27408,21070,15964,13516]
[1,"Hijo",960,1572,1121,886,784,569]
[2,"Hijos",1478,2567,1768,1402,1246,837]
[3,"Hijos o más",2155,3757,2580,2048,1803,1269]
[1,"Rider Comp. Maternidad",225,225,225,225,225,225]
[1,"Transplante de organos",250,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","AL1","AL2","AL3","AL4","AL5","AL6"]
[18,"-  24",{"$f":"+C420*$L$2","v":1231.19},1870.3700000000001,1406.0900000000001,1075.3700000000001,824.15000000000009,652.43000000000006]
[25,"-  29",1375.3500000000001,2083.4300000000003,1568.8000000000002,1195.68,920.08,722.39]
[30,"-  34",1608.5500000000002,2411.5,1844.4,1425.7,1091.27,841.11]
[35,"-  39",1815.25,2673.85,2054.2800000000002,1586.2900000000002,1244.44,932.80000000000007]
[40,"-  44",2055.34,3017.82,2329.35,1799.88,1391.25,1055.76]
[45,"-  49",2375.9900000000002,3507.01,2683.3900000000003,2028.3100000000002,1583.64,1228.01]
[50,"-  54",2689.2200000000003,3843.5600000000004,3016.76,2365.3900000000003,1777.6200000000001,1348.8500000000001]
[55,"-  59",3116.4,4541.5700000000006,3483.69,2616.08,2062.23,1595.3000000000002]
[60,null,3315.6800000000003,5018.04,3857.34,2877.3700000000003,2273.7000000000003,1766.49]
[61,null,3732.26,5648.7400000000007,4339.6400000000003,3239.8900000000003,2560.96,1990.68]
[62,null,{"$f":"+C430*$L$2","v":4148.3100000000004},6277.85,4827.7700000000004,3601.88,2847.69,2212.75]
[63,null,4564.8900000000003,6907.4900000000007,5311.13,3964.4,3134.42,2436.94]
[64,null,4980.41,7538.1900000000005,5796.6100000000006,4327.45,3422.21,2657.42]
[65,null,5471.1900000000005,8150.34,6308.06,4715.41,3726.96,3025.2400000000002]
[66,null,5794.4900000000007,8630.52,6679.06,4994.72,3947.44,3207.03]
[67,null,6438.97,9592.4700000000012,7424.77,5551.22,4389.99,3564.25]
[68,null,7084.51,10552.83,8167.8300000000008,6108.7800000000007,4830.95,3922]
[69,null,7406.22,11033.54,8540.42,6385.4400000000005,5050.37,4102.7300000000005]
[70,null,7564.1600000000008,11174.52,8676.630000000001,6484.02,5145.2400000000007,4156.79]
[71,null,8511.8000000000011,12574.78,9763.66,7296.51,5791.84,4677.25]
[72,null,{"$f":"+C440*$L$2","v":9456.7900000000009},13975.570000000002,10853.34,8110.59,6436.3200000000006,5199.3]
[73,null,10404.43,15374.240000000002,11940.900000000001,8923.08,7082.39,5721.35]
[74,null,11350.480000000001,16774.5,13026.87,9735.0400000000009,7727.93,6242.87]
[75,"o más",12395.11,18349.66,14526.240000000002,11167.1,8460.92,7163.4800000000005]
[1,"Hijo",508.8,833.16000000000008,594.13,469.58000000000004,415.52000000000004,301.57]
[2,"Hijos",783.34,1360.51,937.04000000000008,743.06000000000006,660.38,443.61]
[3,"Hijos o más",1142.1500000000001,1991.21,1367.4,1085.44,955.59,672.57]
[1,"Rider Comp. Maternidad",119.25,119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",132.5,159,159,159,159,159]
[]
["CLASSIC GUATEMALA"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,{"$f":"L487*$L$6","v":0},3207,2485,1624,1192,838]
[19,null,{"$f":"L488*$L$6","v":0},3271,2517,1655,1192,864]
[20,null,0,3300,2578,1686,1224,864]
[21,null,0,3364,2645,1716,1253,896]
[22,null,0,3430,2707,1747,1283,896]
[23,null,0,3459,2735,1775,1283,928]
[24,null,0,3521,2801,1839,1312,954]
[25,null,0,3585,2862,1868,1344,954]
[26,null,0,3649,2925,1899,1371,986]
[27,null,0,3679,2987,1932,1402,986]
[28,null,0,3772,3051,1959,1431,1014]
[29,null,0,3836,3114,2021,1460,1042]
[30,null,0,3931,3207,2083,1492,1075]
[31,null,0,3992,3271,2115,1523,1075]
[32,null,0,4087,3364,2176,1550,1101]
[33,null,0,4182,3459,2236,1581,1135]
[34,null,0,4277,3556,2298,1640,1164]
[35,null,0,4404,3649,2358,1669,1192]
[36,null,0,4496,3743,2420,1727,1224]
[37,null,0,4590,3836,2481,1758,1253]
[38,null,0,4716,3962,2575,1817,1283]
[39,null,0,4843,4087,2663,1880,1312]
[40,null,0,4999,4182,2727,1906,1344]
[41,null,0,5123,4310,2818,1967,1371]
[42,null,null,5251,4432,2908,2027,1402]
[43,null,null,5409,4590,3000,2086,1460]
[44,null,null,5565,4716,3122,2147,1492]
[45,null,null,5721,4873,3213,2208,1550]
[46,null,null,5880,5031,3306,2266,1581]
[47,null,null,6036,5157,3429,2325,1611]
[48,null,null,6287,5376,3581,2414,1669]
[49,null,null,6507,5565,3705,2506,1727]
[50,null,null,6728,5754,3858,2592,1758]
[51,null,null,6947,5971,4012,2682,1817]
[52,null,null,7167,6161,4133,2771,1880]
[53,null,null,7451,6412,4316,2861,1938]
[54,null,null,7733,6666,4501,2977,1967]
[55,null,null,8016,6918,4683,3068,2027]
[56,null,null,8298,7167,4867,3187,2086]
[57,null,null,8582,7418,5050,3308,2147]
[58,null,null,8959,7733,5326,3426,2208]
[59,null,null,9303,8045,5571,3574,2266]
[60,null,null,9683,8394,5815,3724,2355]
[61,null,null,10216,8832,6153,3903,2414]
[62,null,null,10907,9459,6611,4172,2532]
[63,null,null,11942,10343,7255,4556,2654]
[64,null,null,13356,11568,8140,5093,2830]
[65,null,null,15181,13140,9273,5777,3099]
[66,null,null,17412,15118,10649,6581,3426]
[67,null,null,19927,17346,12242,7505,3872]
[68,null,null,22627,19768,13924,8518,4349]
[69,null,null,25456,22315,15698,9587,4886]
[70,null,null,28379,24919,17593,10781,5451]
[71,null,null,31396,27653,19583,12028,6046]
[72,null,null,34503,30420,21664,13366,6671]
[73,null,null,37678,33279,23867,14797,7326]
[74,null,null,40883,36203,26161,16316,7980]
[75,null,null,44181,39155,28547,17924,8666]
[76,null,null,47514,42170,31027,19621,9379]
[77,null,null,50906,45218,33595,21406,10122]
[78,null,null,54331,48330,36289,23281,10870]
[79,null,null,57790,51441,39072,25217,11672]
[80,"o mas",null,61275,54616,41949,27271,12448]
[1,"Hijo",null,1636,946,705,508,360]
[2,"Hijos",null,2735,1419,1105,779,539]
[3,"Hijos o más",null,4025,2045,1593,1135,806]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[null,"Deductible Waiver",null,180,345,775,1330,2080]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,{"$f":"+C487*$L$2","v":0},{"$f":"+D487*$L$2","v":1699.71},1317.05,860.72,631.76,444.14000000000004]
[19,null,{"$f":"+C488*$L$2","v":0},1733.63,1334.01,877.15000000000009,631.76,457.92]
[20,null,{"$f":"+C489*$L$2","v":0},{"$f":"C6*$L$2","v":10477.57},1366.3400000000001,893.58,648.72,457.92]
[21,null,{"$f":"+C490*$L$2","v":0},1782.92,1401.8500000000001,909.48,664.09,474.88]
[22,null,{"$f":"+C491*$L$2","v":0},1817.9,1434.71,925.91000000000008,679.99,474.88]
[23,null,{"$f":"+C492*$L$2","v":0},1833.27,1449.5500000000002,940.75,679.99,491.84000000000003]
[24,null,{"$f":"+C493*$L$2","v":0},1866.13,1484.53,974.67000000000007,695.36,505.62]
[25,null,{"$f":"+C494*$L$2","v":0},1900.0500000000002,1516.8600000000001,990.04000000000008,712.32,505.62]
[26,null,{"$f":"+C495*$L$2","v":0},1933.97,1550.25,1006.47,726.63,522.58000000000004]
[27,null,{"$f":"+C496*$L$2","v":0},1949.8700000000001,1583.1100000000001,1023.96,743.06000000000006,522.58000000000004]
[28,null,{"$f":"+C497*$L$2","v":0},1999.16,1617.03,1038.27,758.43000000000006,537.42000000000007]
[29,null,{"$f":"+C498*$L$2","v":0},2033.0800000000002,1650.42,1071.1300000000001,773.80000000000007,552.26]
[30,null,{"$f":"+C499*$L$2","v":0},2083.4300000000003,1699.71,1103.99,790.76,569.75]
[31,null,{"$f":"+C500*$L$2","v":0},2115.7600000000002,1733.63,1120.95,807.19,569.75]
[32,null,{"$f":"+C501*$L$2","v":0},2166.11,1782.92,1153.28,821.5,583.53]
[33,null,{"$f":"+C502*$L$2","v":0},2216.46,1833.27,1185.0800000000002,837.93000000000006,601.55000000000007]
[34,null,{"$f":"+C503*$L$2","v":0},2266.81,1884.68,1217.94,869.2,616.92000000000007]
[35,null,{"$f":"+C504*$L$2","v":0},2334.12,1933.97,1249.74,884.57,631.76]
[36,null,{"$f":"+C505*$L$2","v":0},2382.88,1983.7900000000002,1282.6000000000001,915.31000000000006,648.72]
[37,null,{"$f":"+C506*$L$2","v":0},2432.7000000000003,2033.0800000000002,1314.93,931.74,664.09]
[38,null,{"$f":"+C507*$L$2","v":0},2499.48,2099.86,1364.75,963.0100000000001,679.99]
[39,null,{"$f":"+C508*$L$2","v":0},2566.79,2166.11,1411.39,996.40000000000009,695.36]
[40,null,{"$f":"+C509*$L$2","v":0},2649.4700000000003,2216.46,1445.3100000000002,1010.1800000000001,712.32]
[41,null,{"$f":"+C510*$L$2","v":0},2715.19,2284.3000000000002,1493.54,1042.51,726.63]
[42,null,null,{"$f":"+D511*$L$2","v":2783.03},2348.96,1541.24,1074.31,743.06000000000006]
[43,null,null,{"$f":"+D512*$L$2","v":2866.77},2432.7000000000003,1590,1105.5800000000002,773.80000000000007]
[44,null,null,{"$f":"+D513*$L$2","v":2949.4500000000003},2499.48,1654.66,1137.9100000000001,790.76]
[45,null,null,{"$f":"+D514*$L$2","v":3032.13},2582.69,1702.89,1170.24,821.5]
[46,null,null,{"$f":"+D515*$L$2","v":3116.4},2666.4300000000003,1752.18,1200.98,837.93000000000006]
[47,null,null,{"$f":"+D516*$L$2","v":3199.0800000000004},2733.21,1817.3700000000001,1232.25,853.83]
[48,null,null,{"$f":"+D517*$L$2","v":3332.11},2849.28,1897.93,1279.42,884.57]
[49,null,null,{"$f":"+D518*$L$2","v":3448.71},2949.4500000000003,1963.65,1328.18,915.31000000000006]
[50,null,null,{"$f":"+D519*$L$2","v":3565.84},3049.6200000000003,2044.74,1373.76,931.74]
[51,null,null,{"$f":"+D520*$L$2","v":3681.9100000000003},3164.63,2126.36,1421.46,963.0100000000001]
[52,null,null,{"$f":"+D521*$L$2","v":3798.51},3265.3300000000004,2190.4900000000002,1468.63,996.40000000000009]
[53,null,null,{"$f":"+D522*$L$2","v":3949.03},3398.36,2287.48,1516.3300000000002,1027.1400000000001]
[54,null,null,{"$f":"+D523*$L$2","v":4098.49},3532.98,2385.5300000000002,1577.8100000000002,1042.51]
[55,null,null,{"$f":"+D524*$L$2","v":4248.4800000000005},3666.54,2481.9900000000002,1626.0400000000002,1074.31]
[56,null,null,{"$f":"+D525*$L$2","v":4397.9400000000005},3798.51,2579.5100000000002,1689.1100000000001,1105.5800000000002]
[57,null,null,{"$f":"+D526*$L$2","v":4548.46},3931.5400000000004,2676.5,1753.24,1137.9100000000001]
[58,null,null,{"$f":"+D527*$L$2","v":4748.2700000000004},4098.49,2822.78,1815.7800000000002,1170.24]
[59,null,null,{"$f":"+D528*$L$2","v":4930.59},4263.8500000000004,2952.63,1894.22,1200.98]
[60,null,null,{"$f":"+D529*$L$2","v":5131.9900000000007},4448.8200000000006,3081.9500000000003,1973.72,1248.1500000000001]
[61,null,null,{"$f":"+D530*$L$2","v":5414.4800000000005},4680.96,3261.09,2068.59,1279.42]
[62,null,null,{"$f":"+D531*$L$2","v":5780.71},5013.2700000000004,3503.8300000000004,2211.1600000000003,1341.96]
[63,null,null,{"$f":"+D532*$L$2","v":6329.26},5481.79,3845.15,2414.6800000000003,1406.6200000000001]
[64,null,null,{"$f":"+D533*$L$2","v":7078.68},6131.04,4314.2,2699.29,1499.9]
[65,null,null,{"$f":"+D534*$L$2","v":8045.93},6964.2000000000007,4914.6900000000005,3061.81,1642.47]
[66,null,null,{"$f":"+D535*$L$2","v":9228.36},8012.54,5643.97,3487.9300000000003,1815.7800000000002]
[67,null,null,{"$f":"+D536*$L$2","v":10561.310000000001},9193.380000000001,6488.26,3977.65,2052.1600000000003]
[68,null,null,{"$f":"+D537*$L$2","v":11992.310000000001},10477.040000000001,7379.72,4514.54,2304.9700000000003]
[69,null,null,{"$f":"+D538*$L$2","v":13491.68},11826.95,8319.94,5081.1100000000006,2589.58]
[70,null,null,{"$f":"+D539*$L$2","v":15040.87},13207.070000000002,9324.2900000000009,5713.93,2889.03]
[71,null,null,{"$f":"+D540*$L$2","v":16639.88},14656.09,10378.99,6374.84,3204.38]
[72,null,null,{"$f":"+D541*$L$2","v":18286.59},16122.6,11481.92,7083.9800000000005,3535.63]
[73,null,null,{"$f":"+D542*$L$2","v":19969.34},17637.870000000003,12649.51,7842.4100000000008,3882.78]
[74,null,null,{"$f":"+D543*$L$2","v":21667.99},19187.59,13865.33,8647.48,4229.4000000000005]
[75,null,null,{"$f":"+D544*$L$2","v":23415.93},20752.150000000001,15129.91,9499.7200000000012,4592.9800000000005]
[76,null,null,{"$f":"+D545*$L$2","v":25182.420000000002},22350.100000000002,16444.310000000001,10399.130000000001,4970.87]
[77,null,null,{"$f":"+D546*$L$2","v":26980.18},23965.54,17805.350000000002,11345.18,5364.66]
[78,null,null,{"$f":"+D547*$L$2","v":28795.43},25614.9,19233.170000000002,12338.93,5761.1]
[79,null,null,{"$f":"+D548*$L$2","v":30628.7},27263.73,20708.16,13365.01,6186.1600000000008]
[80,"o mas",null,{"$f":"+D549*$L$2","v":32475.75},28946.480000000003,22232.97,14453.630000000001,6597.4400000000005]
[1,"Hijo",{"$f":"+C550*$L$2","v":0},867.08,501.38000000000005,373.65000000000003,269.24,190.8]
[2,"Hijos",{"$f":"+C551*$L$2","v":0},1449.5500000000002,752.07,585.65,412.87,285.67]
[3,"Hijos o más",{"$f":"+C552*$L$2","v":0},2133.25,1083.8500000000001,844.29000000000008,601.55000000000007,427.18]
[1,"Rider Comp. Maternidad",{"$f":"+C553*$L$2","v":0},119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",{"$f":"+C554*$L$2","v":0},159,159,159,159,159]
[null,"Deductible Waiver",null,{"$f":"+D555*$L$2","v":95.4},182.85000000000002,410.75,704.90000000000009,1102.4000000000001]
[]
["BUPA BLUE 500 GUATEMALA",null,null,null,null,null,null,null,"?"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","ET1","ET2","ET3","ET4","ET5","ET6"]
[18,null,1326,1371,1193,1086,837,650]
[19,null,1471,1398,1211,1104,855,659]
[20,null,1702,1416,1229,1122,873,677]
[21,null,1883,1443,1256,1140,899,686]
[22,null,2123,1469,1273,1166,917,703]
[23,null,2461,1487,1300,1184,935,712]
[24,null,2695,1514,1318,1202,953,730]
[25,null,3185,1540,1336,1220,971,739]
[26,null,3358,1567,1362,1238,988,757]
[27,null,3780,1585,1380,1256,1015,766]
[28,null,4205,1621,1407,1282,1033,784]
[29,null,4626,1647,1434,1309,1060,801]
[30,null,5047,1674,1460,1327,1086,819]
[31,null,5068,1701,1478,1353,1104,828]
[32,null,5088,1727,1505,1371,1131,846]
[33,null,5656,1781,1549,1407,1166,873]
[34,null,6225,1825,1585,1451,1202,899]
[35,null,6508,1879,1630,1487,1238,926]
[36,null,6554,1923,1674,1523,1273,944]
[37,null,7376,1968,1710,1558,1300,971]
[38,null,8198,2021,1754,1603,1345,997]
[39,null,9021,2066,1799,1638,1380,1024]
[40,null,9842,2119,1843,1674,1416,1051]
[41,null,10752,2164,1879,1719,1451,1077]
[42,null,null,2208,1923,1754,1487,1095]
[43,null,null,2297,1995,1825,1558,1149]
[44,null,null,2386,2075,1897,1621,1193]
[45,null,null,2475,2155,1959,1683,1238]
[46,null,null,2564,2226,2030,1754,1282]
[47,null,null,2654,2306,2101,1816,1336]
[48,null,null,2743,2386,2173,1888,1380]
[49,null,null,2841,2467,2253,1950,1434]
[50,null,null,2930,2547,2324,2021,1478]
[51,null,null,3019,2627,2395,2093,1532]
[52,null,null,3117,2707,2475,2155,1576]
[53,null,null,3223,2805,2556,2244,1638]
[54,null,null,3339,2903,2645,2324,1692]
[55,null,null,3446,3001,2734,2413,1754]
[56,null,null,3553,3090,2823,2493,1808]
[57,null,null,3669,3188,2903,2582,1870]
[58,null,null,3793,3295,3001,2689,1941]
[59,null,null,3918,3410,3090,2796,2021]
[60,null,null,4052,3517,3179,2903,2093]
[61,null,null,4203,3651,3321,3010,2173]
[62,null,null,4390,3820,3482,3152,2271]
[63,null,null,4621,4016,3660,3312,2386]
[64,null,null,4880,4247,3873,3499,2520]
[65,null,null,5200,4523,4123,3767,2698]
[66,null,null,5574,4853,4425,4069,2912]
[67,null,null,6019,5236,4773,4390,3143]
[68,null,null,6536,5681,5182,4764,3410]
[69,null,null,7132,6197,5654,5200,3722]
[70,null,null,7818,6803,6144,5788,4114]
[71,null,null,8611,7489,6830,6376,4532]
[72,null,null,9528,8290,7551,7061,5022]
[73,null,null,10587,9198,8388,7836,5574]
[74,null,null,11798,10258,9350,8735,6215]
[75,null,null,13196,11469,10418,9830,6972]
[76,null,null,14790,12867,11718,11024,7818]
[77,null,null,16616,14443,13170,12377,8780]
[78,null,null,18673,16233,14799,13909,9866]
[79,null,null,20979,18236,16633,15627,11086]
[80,"o mas",null,23739,20640,18815,17684,12546]
[1,"Hijo",604,703,605,552,329,276]
[2,"Hijos",991,1184,1024,935,490,436]
[3,"Hijos o más",1452,1736,1505,1371,703,641]
[1,"Rider Comp. Maternidad",225,225,225,225,225,225]
[1,"Transplante de organos",250,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES ",null,null,null,null,null,null,null,"?"]
["EDAD"]
[" "," ","ET1","ET2","ET3","ET4","ET5","ET6"]
[18,null,{"$f":"+C633*$L$2","v":702.78000000000009},726.63,632.29000000000008,575.58000000000004,443.61,344.5]
[19,null,779.63,740.94,641.83000000000004,585.12,453.15000000000003,349.27000000000004]
[20,null,902.06000000000006,750.48,651.37,594.66000000000008,462.69,358.81]
[21,null,997.99,764.79000000000008,665.68000000000006,604.20000000000005,476.47,363.58000000000004]
[22,null,1125.19,778.57,674.69,617.98,486.01000000000005,372.59000000000003]
[23,null,1304.3300000000002,788.11,689,627.52,495.55,377.36]
[24,null,1428.3500000000001,802.42000000000007,698.54000000000008,637.06000000000006,505.09000000000003,386.90000000000003]
[25,null,1688.0500000000002,816.2,708.08,646.6,514.63,391.67]
[26,null,1779.74,830.51,721.86,656.14,523.64,401.21000000000004]
[27,null,2003.4,840.05000000000007,731.40000000000009,665.68000000000006,537.95000000000005,405.98]
[28,null,{"$f":"+C643*$L$2","v":2228.65},859.13,745.71,679.46,547.49,415.52000000000004]
[29,null,2451.7800000000002,872.91000000000008,760.02,693.77,561.80000000000007,424.53000000000003]
[30,null,2674.9100000000003,887.22,773.80000000000007,703.31000000000006,575.58000000000004,434.07000000000005]
[31,null,2686.04,901.53000000000009,783.34,717.09,585.12,438.84000000000003]
[32,null,2696.6400000000003,915.31000000000006,797.65000000000009,726.63,599.43000000000006,448.38]
[33,null,2997.6800000000003,943.93000000000006,820.97,745.71,617.98,462.69]
[34,null,3299.25,967.25,840.05000000000007,769.03000000000009,637.06000000000006,476.47]
[35,null,3449.2400000000002,995.87,863.90000000000009,788.11,656.14,490.78000000000003]
[36,null,3473.6200000000003,1019.19,887.22,807.19,674.69,500.32000000000005]
[37,null,3909.28,1043.04,906.30000000000007,825.74,689,514.63]
[38,null,{"$f":"+C653*$L$2","v":4344.9400000000005},1071.1300000000001,929.62,849.59,712.85,528.41000000000008]
[39,null,4781.13,1094.98,953.47,868.1400000000001,731.40000000000009,542.72]
[40,null,5216.26,1123.0700000000002,976.79000000000008,887.22,750.48,557.03]
[41,null,5698.56,1146.92,995.87,911.07,769.03000000000009,570.81000000000006]
[42,null,null,{"$f":"+D657*$L$2","v":1170.24},1019.19,929.62,788.11,580.35]
[43,null,null,{"$f":"+D658*$L$2","v":1217.4100000000001},1057.3500000000001,967.25,825.74,608.97]
[44,null,null,{"$f":"+D659*$L$2","v":1264.5800000000002},1099.75,1005.4100000000001,859.13,632.29000000000008]
[45,null,null,{"$f":"+D660*$L$2","v":1311.75},1142.1500000000001,1038.27,891.99,656.14]
[46,null,null,{"$f":"+D661*$L$2","v":1358.92},1179.78,1075.9000000000001,929.62,679.46]
[47,null,null,{"$f":"+D662*$L$2","v":1406.6200000000001},1222.18,1113.53,962.48,708.08]
[48,null,null,{"$f":"+D663*$L$2","v":1453.79},1264.5800000000002,1151.69,1000.6400000000001,731.40000000000009]
[49,null,null,{"$f":"+D664*$L$2","v":1505.73},1307.51,1194.0900000000001,1033.5,760.02]
[50,null,null,{"$f":"+D665*$L$2","v":1552.9},1349.91,1231.72,1071.1300000000001,783.34]
[51,null,null,{"$f":"+D666*$L$2","v":1600.0700000000002},1392.3100000000002,1269.3500000000001,1109.29,811.96]
[52,null,null,{"$f":"+D667*$L$2","v":1652.01},1434.71,1311.75,1142.1500000000001,835.28000000000009]
[53,null,null,{"$f":"+D668*$L$2","v":1708.19},1486.65,1354.68,1189.3200000000002,868.1400000000001]
[54,null,null,{"$f":"+D669*$L$2","v":1769.67},1538.5900000000001,1401.8500000000001,1231.72,896.76]
[55,null,null,{"$f":"+D670*$L$2","v":1826.38},1590.53,1449.02,1278.8900000000001,929.62]
[56,null,null,{"$f":"+D671*$L$2","v":1883.0900000000001},1637.7,1496.19,1321.29,958.24]
[57,null,null,{"$f":"+D672*$L$2","v":1944.5700000000002},1689.64,1538.5900000000001,1368.46,991.1]
[58,null,null,{"$f":"+D673*$L$2","v":2010.2900000000002},1746.3500000000001,1590.53,1425.17,1028.73]
[59,null,null,{"$f":"+D674*$L$2","v":2076.54},1807.3000000000002,1637.7,1481.88,1071.1300000000001]
[60,null,null,{"$f":"+D675*$L$2","v":2147.56},1864.01,1684.8700000000001,1538.5900000000001,1109.29]
[61,null,null,{"$f":"+D676*$L$2","v":2227.59},1935.0300000000002,1760.13,1595.3000000000002,1151.69]
[62,null,null,{"$f":"+D677*$L$2","v":2326.7000000000003},2024.6000000000001,1845.46,1670.5600000000002,1203.6300000000001]
[63,null,null,{"$f":"+D678*$L$2","v":2449.13},2128.48,1939.8000000000002,1755.3600000000001,1264.5800000000002]
[64,null,null,{"$f":"+D679*$L$2","v":2586.4},2250.9100000000003,2052.69,1854.47,1335.6000000000001]
[65,null,null,{"$f":"+D680*$L$2","v":2756},2397.19,2185.19,1996.51,1429.94]
[66,null,null,{"$f":"+D681*$L$2","v":2954.2200000000003},2572.09,2345.25,2156.5700000000002,1543.3600000000001]
[67,null,null,{"$f":"+D682*$L$2","v":3190.07},2775.08,2529.69,2326.7000000000003,1665.7900000000002]
[68,null,null,{"$f":"+D683*$L$2","v":3464.0800000000004},3010.9300000000003,2746.46,2524.92,1807.3000000000002]
[69,null,null,{"$f":"+D684*$L$2","v":3779.96},3284.4100000000003,2996.6200000000003,2756,1972.66]
[70,null,null,{"$f":"+D685*$L$2","v":4143.54},3605.59,3256.32,3067.6400000000003,2180.42]
[71,null,null,{"$f":"+D686*$L$2","v":4563.83},3969.17,3619.9,3379.28,2401.96]
[72,null,null,{"$f":"+D687*$L$2","v":5049.84},4393.7,4002.03,3742.3300000000004,2661.6600000000003]
[73,null,null,{"$f":"+D688*$L$2","v":5611.1100000000006},4874.9400000000005,4445.6400000000003,4153.08,2954.2200000000003]
[74,null,null,{"$f":"+D689*$L$2","v":6252.9400000000005},5436.7400000000007,4955.5,4629.55,3293.9500000000003]
[75,null,null,{"$f":"+D690*$L$2","v":6993.88},6078.5700000000006,5521.54,5209.9000000000005,3695.1600000000003]
[76,null,null,{"$f":"+D691*$L$2","v":7838.7000000000007},6819.51,6210.54,5842.72,4143.54]
[77,null,null,{"$f":"+D692*$L$2","v":8806.48},7654.79,6980.1,6559.81,4653.4000000000005]
[78,null,null,{"$f":"+D693*$L$2","v":9896.69},8603.49,7843.47,7371.77,5228.9800000000005]
[79,null,null,{"$f":"+D694*$L$2","v":11118.87},9665.08,8815.49,8282.3100000000013,5875.58]
[80,"o mas",null,{"$f":"+D695*$L$2","v":12581.67},10939.2,9971.9500000000007,9372.52,6649.38]
[1,"Hijo",{"$f":"+C696*$L$2","v":320.12},372.59000000000003,320.65000000000003,292.56,174.37,146.28]
[2,"Hijos",525.23,627.52,542.72,495.55,259.7,231.08]
[3,"Hijos o más",769.56000000000006,920.08,797.65000000000009,726.63,372.59000000000003,339.73]
[1,"Rider Comp. Maternidad",119.25,119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",132.5,159,159,159,159,159]
[]
["Bupa Essential Care",null,null,null,null,null,null,null,"?"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","ET1","ET2","ET3","ET4","ET5","ET6"]
[18,null,1464,1408,1305,925,697,490]
[19,null,1492,1435,1331,942,697,506]
[20,null,1518,1461,1354,959,716,506]
[21,null,1546,1487,1378,976,733,524]
[22,null,1575,1514,1404,995,750,524]
[23,null,1600,1539,1426,1011,750,543]
[24,null,1657,1594,1477,1047,767,558]
[25,null,1684,1619,1501,1064,786,558]
[26,null,1711,1646,1526,1081,802,577]
[27,null,1741,1674,1551,1099,820,577]
[28,null,1765,1698,1574,1115,838,593]
[29,null,1822,1752,1624,1151,855,610]
[30,null,1878,1806,1674,1186,873,629]
[31,null,1906,1833,1700,1204,890,629]
[32,null,1961,1886,1748,1239,907,644]
[33,null,2016,1938,1797,1272,925,663]
[34,null,2072,1992,1847,1307,959,681]
[35,null,2125,2043,1895,1341,976,697]
[36,null,2182,2098,1945,1377,1011,716]
[37,null,2236,2150,1993,1411,1028,733]
[38,null,2321,2232,2069,1465,1064,750]
[39,null,2401,2309,2141,1516,1099,767]
[40,null,2458,2363,2192,1551,1115,786]
[41,null,2540,2443,2265,1603,1151,802]
[42,null,2622,2521,2337,1655,1186,820]
[43,null,2703,2601,2411,1707,1219,855]
[44,null,2814,2707,2508,1777,1256,873]
[45,null,2896,2785,2583,1829,1292,907]
[46,null,2980,2866,2657,1881,1324,925]
[47,null,3090,2972,2755,1951,1359,942]
[48,null,3228,3105,2878,2038,1411,976]
[49,null,3339,3212,2977,2109,1465,1011]
[50,null,3476,3344,3100,2195,1516,1028]
[51,null,3616,3477,3224,2283,1568,1064]
[52,null,3725,3582,3321,2352,1620,1099]
[53,null,3890,3741,3468,2455,1674,1134]
[54,null,4057,3901,3617,2561,1741,1151]
[55,null,4220,4059,3762,2664,1794,1186]
[56,null,4388,4219,3912,2770,1864,1219]
[57,null,4551,4377,4057,2873,1934,1256]
[58,null,4801,4617,4280,3031,2004,1292]
[59,null,5022,4829,4477,3170,2090,1324]
[60,null,5241,5040,4672,3309,2178,1377]
[61,null,5545,5333,4944,3501,2283,1411]
[62,null,5959,5731,5312,3761,2440,1480]
[63,null,6540,6288,5829,4128,2664,1551]
[64,null,7338,7057,6542,4632,2979,1655]
[65,null,8359,8038,7452,5276,3379,1812]
[66,null,9600,9232,8558,6059,3849,2004]
[67,null,11035,10612,9837,6966,4389,2265]
[68,null,12551,12070,11189,7922,4980,2543]
[69,null,14149,13608,12614,8932,5607,2857]
[70,null,15859,15252,14139,10011,6304,3188]
[71,null,17653,16976,15737,11142,7034,3536]
[72,null,19528,18779,17409,12326,7817,3901]
[73,null,21514,20691,19180,13580,8653,4285]
[74,null,23582,22679,21023,14886,9542,4667]
[75,null,25733,24747,22941,16243,10482,5067]
[76,null,27968,26897,24934,17654,11474,5485]
[77,null,30283,29124,26998,19115,12518,5920]
[78,null,32711,31458,29162,20647,13615,6356]
[79,null,35220,33872,31399,22231,14746,6826]
[80,"o mas",37814,36366,33711,23869,15948,7280]
[1,"Hijo",635,611,567,401,335,264]
[2,"Hijos",996,958,888,629,524,414]
[3,"Hijos o más",1436,1381,1280,907,756,596]
[1,"Rider Comp. Maternidad",225,225,225,0,0,0]
[1,"Transplante de organos",300,300,300,300,300,300]
[]
["Bupa Essential Care: TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","ET1","ET2","ET3","ET4","ET5","ET6"]
[18,null,{"$f":"C778*$L$2","v":775.92000000000007},{"$f":"D778*$L$2","v":746.24},691.65000000000009,490.25,369.41,259.7]
[19,null,{"$f":"C779*$L$2","v":790.76},760.55000000000007,705.43000000000006,499.26000000000005,369.41,268.18]
[20,null,{"$f":"C780*$L$2","v":804.54000000000008},774.33,717.62,508.27000000000004,379.48,268.18]
[21,null,{"$f":"C781*$L$2","v":819.38},788.11,730.34,517.28,388.49,277.72000000000003]
[22,null,{"$f":"C782*$L$2","v":834.75},802.42000000000007,744.12,527.35,397.5,277.72000000000003]
[23,null,{"$f":"C783*$L$2","v":848},815.67000000000007,755.78000000000009,535.83000000000004,397.5,287.79000000000002]
[24,null,{"$f":"C784*$L$2","v":878.21},844.82,782.81000000000006,554.91000000000008,406.51000000000005,295.74]
[25,null,{"$f":"C785*$L$2","v":892.5200000000001},858.07,795.53000000000009,563.92000000000007,416.58000000000004,295.74]
[26,null,{"$f":"C786*$L$2","v":906.83},872.38,808.78000000000009,572.93000000000006,425.06,305.81]
[27,null,{"$f":"C787*$L$2","v":922.73},887.22,822.03000000000009,582.47,434.6,305.81]
[28,null,{"$f":"C788*$L$2","v":935.45},899.94,834.22,590.95000000000005,444.14000000000004,314.29000000000002]
[29,null,{"$f":"C789*$L$2","v":965.66000000000008},928.56000000000006,860.72,610.03000000000009,453.15000000000003,323.3]
[30,null,{"$f":"C790*$L$2","v":995.34},957.18000000000006,887.22,628.58000000000004,462.69,333.37]
[31,null,{"$f":"C791*$L$2","v":1010.1800000000001},971.49,901,638.12,471.70000000000005,333.37]
[32,null,{"$f":"C792*$L$2","v":1039.3300000000002},999.58,926.44,656.67000000000007,480.71000000000004,341.32]
[33,null,{"$f":"C793*$L$2","v":1068.48},1027.1400000000001,952.41000000000008,674.16000000000008,490.25,351.39000000000004]
[34,null,{"$f":"C794*$L$2","v":1098.1600000000001},1055.76,978.91000000000008,692.71,508.27000000000004,360.93]
[35,null,{"$f":"C795*$L$2","v":1126.25},1082.79,1004.35,710.73,517.28,369.41]
[36,null,{"$f":"C796*$L$2","v":1156.46},1111.94,1030.8500000000001,729.81000000000006,535.83000000000004,379.48]
[37,null,{"$f":"C797*$L$2","v":1185.0800000000002},1139.5,1056.29,747.83,544.84,388.49]
[38,null,{"$f":"C798*$L$2","v":1230.1300000000001},1182.96,1096.5700000000002,776.45,563.92000000000007,397.5]
[39,null,{"$f":"C799*$L$2","v":1272.53},1223.77,1134.73,803.48,582.47,406.51000000000005]
[40,null,{"$f":"C800*$L$2","v":1302.74},1252.3900000000001,1161.76,822.03000000000009,590.95000000000005,416.58000000000004]
[41,null,{"$f":"C801*$L$2","v":1346.2},1294.79,1200.45,849.59,610.03000000000009,425.06]
[42,null,{"$f":"C802*$L$2","v":1389.66},1336.13,1238.6100000000001,877.15000000000009,628.58000000000004,434.6]
[43,null,{"$f":"C803*$L$2","v":1432.5900000000001},1378.53,1277.8300000000002,904.71,646.07000000000005,453.15000000000003]
[44,null,{"$f":"C804*$L$2","v":1491.42},1434.71,1329.24,941.81000000000006,665.68000000000006,462.69]
[45,null,{"$f":"C805*$L$2","v":1534.88},1476.0500000000002,1368.99,969.37,684.76,480.71000000000004]
[46,null,{"$f":"C806*$L$2","v":1579.4},1518.98,1408.21,996.93000000000006,701.72,490.25]
[47,null,{"$f":"C807*$L$2","v":1637.7},1575.16,1460.15,1034.03,720.27,499.26000000000005]
[48,null,{"$f":"C808*$L$2","v":1710.8400000000001},1645.65,1525.3400000000001,1080.1400000000001,747.83,517.28]
[49,null,{"$f":"C809*$L$2","v":1769.67},1702.3600000000001,1577.8100000000002,1117.77,776.45,535.83000000000004]
[50,null,{"$f":"C810*$L$2","v":1842.2800000000002},1772.3200000000002,1643,1163.3500000000001,803.48,544.84]
[51,null,{"$f":"C811*$L$2","v":1916.48},1842.8100000000002,1708.72,1209.99,831.04000000000008,563.92000000000007]
[52,null,{"$f":"C812*$L$2","v":1974.25},1898.46,1760.13,1246.5600000000002,858.6,582.47]
[53,null,{"$f":"C813*$L$2","v":2061.7000000000003},1982.73,1838.0400000000002,1301.1500000000001,887.22,601.02]
[54,null,{"$f":"C814*$L$2","v":2150.21},2067.5300000000002,1917.01,1357.3300000000002,922.73,610.03000000000009]
[55,null,{"$f":"C815*$L$2","v":2236.6},2151.27,1993.8600000000001,1411.92,950.82,628.58000000000004]
[56,null,{"$f":"C816*$L$2","v":2325.6400000000003},2236.0700000000002,2073.36,1468.1000000000001,987.92000000000007,646.07000000000005]
[57,null,{"$f":"C817*$L$2","v":2412.0300000000002},2319.81,2150.21,1522.69,1025.02,665.68000000000006]
[58,null,{"$f":"C818*$L$2","v":2544.5300000000002},2447.0100000000002,2268.4,1606.43,1062.1200000000001,684.76]
[59,null,{"$f":"C819*$L$2","v":2661.6600000000003},2559.3700000000003,2372.81,1680.1000000000001,1107.7,701.72]
[60,null,{"$f":"C820*$L$2","v":2777.73},2671.2000000000003,2476.1600000000003,1753.77,1154.3400000000001,729.81000000000006]
[61,null,{"$f":"C821*$L$2","v":2938.8500000000004},2826.4900000000002,2620.3200000000002,1855.5300000000002,1209.99,747.83]
[62,null,{"$f":"C822*$L$2","v":3158.27},3037.4300000000003,2815.36,1993.3300000000002,1293.2,784.40000000000009]
[63,null,{"$f":"C823*$L$2","v":3466.2000000000003},3332.6400000000003,3089.3700000000003,2187.84,1411.92,822.03000000000009]
[64,null,{"$f":"C824*$L$2","v":3889.1400000000003},3740.21,3467.26,2454.96,1578.8700000000001,877.15000000000009]
[65,null,{"$f":"C825*$L$2","v":4430.2700000000004},4260.1400000000003,3949.5600000000004,2796.28,1790.8700000000001,960.36]
[66,null,{"$f":"C826*$L$2","v":5088},4892.96,4535.74,3211.27,2039.97,1062.1200000000001]
[67,null,{"$f":"C827*$L$2","v":5848.55},5624.3600000000006,5213.6100000000006,3691.98,2326.17,1200.45]
[68,null,{"$f":"C828*$L$2","v":6652.0300000000007},6397.1,5930.17,4198.66,2639.4,1347.79]
[69,null,{"$f":"C829*$L$2","v":7498.97},7212.2400000000007,6685.42,4733.96,2971.71,1514.21]
[70,null,{"$f":"C830*$L$2","v":8405.27},8083.56,7493.67,5305.83,3341.1200000000003,1689.64]
[71,null,{"$f":"C831*$L$2","v":9356.09},8997.2800000000007,8340.61,5905.26,3728.02,1874.0800000000002]
[72,null,{"$f":"C832*$L$2","v":10349.84},9952.8700000000008,9226.77,6532.7800000000007,4143.01,2067.5300000000002]
[73,null,{"$f":"C833*$L$2","v":11402.42},10966.230000000001,10165.4,7197.4000000000005,4586.09,2271.0500000000002]
[74,null,{"$f":"C834*$L$2","v":12498.460000000001},12019.87,11142.19,7889.5800000000008,5057.26,2473.5100000000002]
[75,null,{"$f":"C835*$L$2","v":13638.49},13115.91,12158.730000000001,8608.7900000000009,5555.46,2685.51]
[76,null,{"$f":"C836*$L$2","v":14823.04},14255.41,13215.02,9356.6200000000008,6081.22,2907.05]
[77,null,{"$f":"C837*$L$2","v":16049.990000000002},15435.720000000001,14308.94,10130.950000000001,6634.54,3137.6000000000004]
[78,null,{"$f":"C838*$L$2","v":17336.830000000002},16672.740000000002,15455.86,10942.91,7215.9500000000007,3368.6800000000003]
[79,null,{"$f":"C839*$L$2","v":18666.600000000002},17952.16,16641.47,11782.43,7815.38,3617.78]
[80,"o mas",{"$f":"C840*$L$2","v":20041.420000000002},19273.98,17866.830000000002,12650.570000000002,8452.44,3858.4]
[1,"Hijo",{"$f":"C841*$L$2","v":336.55},323.83000000000004,300.51,212.53,177.55,139.92000000000002]
[2,"Hijos",{"$f":"C842*$L$2","v":527.88},507.74,470.64000000000004,333.37,277.72000000000003,219.42000000000002]
[3,"Hijos o más",{"$f":"C843*$L$2","v":761.08},731.93000000000006,678.40000000000009,480.71000000000004,400.68,315.88]
[1,"Rider Comp. Maternidad",{"$f":"C844*$L$2","v":119.25},119.25,119.25,0,0,0]
[1,"Transplante de organos",{"$f":"C845*$L$2","v":159},159,159,159,159,159]
[]
["BUPA COMPLETE GUATEMALA"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","DW1","DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",null,{"$f":"D6*$L$3","v":3307.7000000000003},{"$f":"E6*$L$3","v":2265.4500000000003},1590.325,1097.8000000000002,839.02500000000009]
[25,"-  29",null,{"$f":"D7*$L$3","v":3465.55},2515.4250000000002,1767.15,1204.2250000000001,925.37500000000011]
[30,"-  34",null,3625.05,2695.55,1965.9750000000001,1463.5500000000002,1119.5250000000001]
[35,"-  39",null,4055.7000000000003,3013.4500000000003,2207.7000000000003,1634.8750000000002,1248.5]
[40,"-  44",null,4711.3,3307.7000000000003,2451.3500000000004,1806.7500000000002,1376.65]
[45,"-  49",null,5256.0750000000007,3692.7000000000003,2737.3500000000004,2022.0750000000003,1548.8000000000002]
[50,"-  54",null,6863.4500000000007,4870.8,3599.2000000000003,2882.0000000000005,2215.9500000000003]
[55,"-  59",null,7316.1,5187.3250000000007,3841.7500000000005,3074.7750000000001,2344.375]
[60,null,null,7951.0750000000007,5641.0750000000007,4371.4000000000005,3655.5750000000003,2945.8]
[61,null,null,8539.5750000000007,6049.4500000000007,4680.5,3935.2500000000005,3161.4]
[62,null,null,9354.9500000000007,6614.85,5122.4250000000002,4299.625,3461.4250000000002]
[63,null,null,9944,7044.6750000000002,5453.8,4580.4000000000005,3676.7500000000005]
[64,null,null,10759.375,7611.4500000000007,5895.4500000000007,4945.875,3978.1500000000005]
[65,null,null,14067.075000000001,9944,7462.1250000000009,6601.1,5611.375]
[66,null,null,16353.975000000002,11552.750000000002,8675.4250000000011,7676.35,6514.2000000000007]
[67,null,null,17849.150000000001,12617.275000000001,9469.9000000000015,8385.3000000000011,7117.0000000000009]
[68,null,null,19774.150000000001,13975.500000000002,10485.75,9287.85,7890.85]
[69,null,null,21745.075000000001,15357.925000000001,11545.875000000002,10212.400000000001,8663.875]
[70,null,null,26772.625000000004,18709.075000000001,13575.650000000001,11889.35,10190.950000000001]
[71,null,null,27814.875000000004,19435.075000000001,14106.675000000001,12362.625000000002,10599.6]
[72,null,null,28607.425000000003,20000.75,14503.500000000002,12706.1,10900.725]
[73,null,null,29649.675000000003,20726.2,15034.250000000002,13178.550000000001,11308.825000000001]
[74,null,null,30193.350000000002,21088.100000000002,15320.800000000001,13415.6,11502.7]
[75,"o más",null,31506.750000000004,22015.95,15981.625000000002,13996.400000000001,11996.6]
[1,"Hijo",null,1156.375,838.75000000000011,641.57500000000005,538.45000000000005,387.47500000000002]
[2,"Hijos",null,1835.3500000000001,1337.0500000000002,1016.95,839.02500000000009,624.80000000000007]
[3,"Hijos o más",null,2672.7250000000004,1948.65,1502.6000000000001,1225.6750000000002,904.75000000000011]
[1,"Rider Comp. Maternidad",null,0,0,61.875000000000007,61.875000000000007,61.875000000000007]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["BUPA SECURE GUATEMALA"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","CW1","CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",null,{"$f":"D140*$L$3","v":1617.5500000000002},{"$f":"E140*$L$3","v":1266.375},944.35,802.72500000000002,601.42500000000007]
[25,"-  29",null,{"$f":"D141*$L$3","v":1776.2250000000001},1424.7750000000001,1062.6000000000001,886.05000000000007,668.80000000000007]
[30,"-  34",null,2040.2250000000001,1670.9,1234.75,1035.6500000000001,786.22500000000002]
[35,"-  39",null,2251.4250000000002,1881.825,1372.5250000000001,1152.8000000000002,867.90000000000009]
[40,"-  44",null,2514.0500000000002,2145.8250000000003,1544.1250000000002,1303.2250000000001,986.15000000000009]
[45,"-  49",null,2901.8,2514.0500000000002,1800.7,1520.7500000000002,1136.3000000000002]
[50,"-  54",null,3165.8,2761.2750000000001,1972.5750000000003,1654.4,1253.45]
[55,"-  59",null,3727.3500000000004,3304.6750000000002,2332,1971.4750000000001,1470.9750000000001]
[60,null,null,3903.6250000000005,3534.0250000000001,2468.9500000000003,2088.9,1554.0250000000001]
[61,null,null,4395.6000000000004,3973.7500000000005,2795.1000000000004,2339.15,1754.5000000000002]
[62,null,null,4887.3,4413.2000000000007,3103.65,2606.4500000000003,1954.7]
[63,null,null,5363.3250000000007,4852.6500000000005,3411.9250000000002,2873.7500000000005,2154.625]
[64,null,null,5854.7500000000009,5309.4250000000002,3719.9250000000002,3139.6750000000002,2355.65]
[65,null,null,5872.35,5344.9000000000005,3754.8500000000004,3157.8250000000003,2355.65]
[66,null,null,5872.35,5397.7000000000007,3771.3500000000004,3174.05,2355.65]
[67,null,null,6522.1750000000002,6012.6,4182.75,3524.1250000000005,2623.2250000000004]
[68,null,null,7172.55,6610.4500000000007,4611.2000000000007,3875.5750000000003,2890.8]
[69,null,null,7506.9500000000007,6909.6500000000005,4817.7250000000004,4059.0000000000005,3024.1750000000002]
[70,null,null,7524.8250000000007,7015.2500000000009,4868.875,4091.7250000000004,3040.1250000000005]
[71,null,null,8457.35,7911.7500000000009,5485.4250000000002,4610.1000000000004,3425.1250000000005]
[72,null,null,9405.8250000000007,8790.9250000000011,6084.9250000000002,5110.875,3808.2000000000003]
[73,null,null,10355.400000000001,9669,6703.1250000000009,5628.7000000000007,4192.6500000000005]
[74,null,null,11287.1,10548.45,7319.1250000000009,6145.9750000000004,4577.1000000000004]
[75,"o más",null,12306.800000000001,11568.7,8004.9750000000004,6714.4000000000005,4994.55]
[1,"Hijo",null,773.57500000000005,458.15000000000003,377.85,318.17500000000001,235.12500000000003]
[2,"Hijos",null,1319.45,687.22500000000002,600.6,501.6,367.95000000000005]
[3,"Hijos o más",null,1933.8000000000002,985.60000000000014,875.05000000000007,735.07500000000005,552.20000000000005]
[1,"Rider Comp. Maternidad",null,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["BUPA PREMIUM GUATEMALA"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,null,{"$f":"D274*$L$3","v":1695.65},{"$f":"E274*$L$3","v":1263.9000000000001},916.57500000000005,687.77500000000009,541.75]
[19,null,null,{"$f":"D275*$L$3","v":1710.5000000000002},1279.575,931.7,702.07500000000005,556.6]
[20,null,null,1740.7500000000002,1310.1000000000001,946.82500000000005,717.47500000000002,570.90000000000009]
[21,null,null,1771.825,1340.9,977.35,717.47500000000002,570.90000000000009]
[22,null,null,1802.6250000000002,1355.75,991.37500000000011,732.05000000000007,585.75]
[23,null,null,1849.1000000000001,1387.375,1006.2250000000001,746.35,600.32500000000005]
[24,null,null,1879.3500000000001,1418.1750000000002,1021.3500000000001,760.65000000000009,600.32500000000005]
[25,null,null,1909.8750000000002,1433.3000000000002,1036.2,775.22500000000002,614.625]
[26,null,null,1941.7750000000001,1463.5500000000002,1066.7250000000001,790.35,630.02500000000009]
[27,null,null,1972.5750000000003,1494.3500000000001,1081.575,804.65000000000009,644.32500000000005]
[28,null,null,2002.8250000000003,1525.9750000000001,1111.825,833.80000000000007,644.32500000000005]
[29,null,null,2049.3000000000002,1556.5000000000002,1126.4000000000001,848.92500000000007,658.35]
[30,null,null,2095.5,1602.7,1155.825,863.50000000000011,672.92500000000007]
[31,null,null,2126.0250000000001,1633.2250000000001,1187.1750000000002,892.37500000000011,687.77500000000009]
[32,null,null,2172.7750000000001,1663.7500000000002,1217.4250000000002,907.22500000000002,702.07500000000005]
[33,null,null,2218.7000000000003,1710.5000000000002,1246.8500000000001,936.1,717.47500000000002]
[34,null,null,2279.75,1756.4250000000002,1291.4000000000001,965.80000000000007,732.05000000000007]
[35,null,null,2326.2250000000004,1802.6250000000002,1336.5,994.67500000000007,746.35]
[36,null,null,2387.5500000000002,1849.1000000000001,1367.0250000000001,1024.375,760.65000000000009]
[37,null,null,2434.5750000000003,1895.0250000000001,1411.8500000000001,1053.25,775.22500000000002]
[38,null,null,2496.1750000000002,1941.7750000000001,1456.4,1082.95,804.65000000000009]
[39,null,null,2556.9500000000003,2002.8250000000003,1502.0500000000002,1111.825,819.22500000000002]
[40,null,null,2619.65,2064.9750000000004,1547.4250000000002,1156.1000000000001,833.80000000000007]
[41,null,null,2696.1000000000004,2111.1750000000002,1607.1000000000001,1185.5250000000001,848.92500000000007]
[42,null,null,2758.25,2172.7750000000001,1652.7500000000002,1228.9750000000001,878.62500000000011]
[43,null,null,2833.8750000000005,2233.8250000000003,1711.8750000000002,1272.9750000000001,892.37500000000011]
[44,null,null,2911.15,2311.375,1772.1000000000001,1316.7,922.07500000000005]
[45,null,null,2989.5250000000001,2373.25,1831.5000000000002,1360.4250000000002,936.1]
[46,null,null,3065.4250000000002,2449.9750000000004,1892.2750000000001,1403.6000000000001,965.80000000000007]
[47,null,null,3142.4250000000002,2511.8500000000004,1967.3500000000001,1448.4250000000002,980.1]
[48,null,null,3235.65,2603.7000000000003,2042.4250000000002,1507.2750000000001,1009.2500000000001]
[49,null,null,3342.9,2696.1000000000004,2132.3500000000004,1565.3000000000002,1038.95]
[50,null,null,3450.15,2788.5,2222,1623.6000000000001,1067.5500000000002]
[51,null,null,3543.1000000000004,2880.6250000000005,2313.0250000000001,1681.9,1096.9750000000001]
[52,null,null,3650.9,2989.5250000000001,2387.5500000000002,1740.7500000000002,1125.8500000000001]
[53,null,null,3774.3750000000005,3096.7750000000001,2506.9,1828.7500000000002,1156.1000000000001]
[54,null,null,3912.9750000000004,3218.8750000000005,2612.7750000000001,1901.3500000000001,1199.5500000000002]
[55,null,null,4035.9000000000005,3342.9,2732.125,1973.9500000000003,1228.9750000000001]
[56,null,null,4159.6500000000005,3450.15,2837.1750000000002,2062.2250000000004,1272.9750000000001]
[57,null,null,4297.9750000000004,3574.7250000000004,2958.1750000000002,2134,1301.575]
[58,null,null,4467.375,3728.1750000000002,3108.05,2237.9500000000003,1345.8500000000001]
[59,null,null,4636.5,3882.1750000000002,3257.9250000000002,2339.7000000000003,1389.0250000000001]
[60,null,null,4790.7750000000005,4035.9000000000005,3408.0750000000003,2441.4500000000003,1433.3000000000002]
[61,null,null,5022.3250000000007,4251.7750000000005,3603.3250000000003,2588.0250000000001,1507.2750000000001]
[62,null,null,5329.5,4544.1000000000004,3903.3500000000004,2778.05,1579.0500000000002]
[63,null,null,5775.8250000000007,4959.625,4294.125,3071.4750000000004,1696.7500000000002]
[64,null,null,6393.2000000000007,5530.25,4833.6750000000002,3465.0000000000005,1872.2]
[65,null,null,7178.05,6299.4250000000002,5525.0250000000005,3977.05,2105.9500000000003]
[66,null,null,8147.7000000000007,7240.2000000000007,6350.3,4605.7000000000007,{"$f":"H322*$L$3","v":2398}]
[67,null,null,9225.9750000000004,8286.85,7280.35,5307.5,2748.9]
[68,null,null,10381.25,9442.125,8286.85,6052.2000000000007,3114.65]
[69,null,null,11598.400000000001,10658.45,9321.9500000000007,6856.85,3524.9500000000003]
[70,null,null,12861.475,11906.400000000001,10402.975,7674.9750000000004,3933.05]
[71,null,null,14154.250000000002,13199.725,11513.425000000001,8523.625,4357.1000000000004]
[72,null,null,15494.6,14524.400000000001,12653.85,9386.3000000000011,4809.75]
[73,null,null,16849.525000000001,15880.150000000001,13825.075000000001,10277.575000000001,5263.2250000000004]
[74,null,null,18235.800000000003,17265.325000000001,15011.150000000001,11183.425000000001,5716.1500000000005]
[75,null,null,19653.7,18682.95,16211.800000000001,12104.125000000002,6198.7750000000005]
[76,null,null,19653.7,18682.95,16211.800000000001,12104.125000000002,6198.7750000000005]
[77,null,null,19653.7,18682.95,16211.800000000001,12104.125000000002,6198.7750000000005]
[78,null,null,19653.7,18682.95,16211.800000000001,12104.125000000002,6198.7750000000005]
[79,null,null,19653.7,18682.95,16211.800000000001,12104.125000000002,6198.7750000000005]
[80,"o mas",null,19653.7,18682.95,16211.800000000001,12104.125000000002,6198.7750000000005]
[1,"Hijo",null,786.22500000000002,570.625,421.3,366.3,264]
[2,"Hijos",null,1294.9750000000001,{"$f":"E338*$L$3","v":894.30000000000007},661.375,570.90000000000009,380.32500000000005]
[3,"Hijos o más",null,{"$f":"D339*$L$3","v":1895.0250000000001},1294.9750000000001,977.35,833.80000000000007,585.75]
[1,"Rider Comp. Maternidad",null,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007]
[1,"Transplante de organos",null,82.5,82.5,82.5,82.5,82.5]
[null,"Deductible Waiver",null,49.500000000000007,94.875000000000014,213.12500000000003,365.75000000000006,572]
[]
["BUPA CLASSIC GUATEMALA"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,null,{"$f":"D487*$L$3","v":881.92500000000007},{"$f":"E487*$L$3","v":683.375},446.6,327.8,230.45000000000002]
[19,null,null,{"$f":"D488*$L$3","v":899.52500000000009},692.17500000000007,455.12500000000006,327.8,237.60000000000002]
[20,null,null,907.50000000000011,708.95,463.65000000000003,336.6,237.60000000000002]
[21,null,null,925.1,727.37500000000011,471.90000000000003,344.57500000000005,246.40000000000003]
[22,null,null,943.25000000000011,744.42500000000007,480.42500000000001,352.82500000000005,246.40000000000003]
[23,null,null,951.22500000000002,752.12500000000011,488.12500000000006,352.82500000000005,255.20000000000002]
[24,null,null,968.27500000000009,770.27500000000009,505.72500000000002,360.8,262.35000000000002]
[25,null,null,985.87500000000011,787.05000000000007,513.70000000000005,369.6,262.35000000000002]
[26,null,null,1003.4750000000001,804.37500000000011,522.22500000000002,377.02500000000003,271.15000000000003]
[27,null,null,1011.7250000000001,821.42500000000007,531.30000000000007,385.55,271.15000000000003]
[28,null,null,1037.3000000000002,839.02500000000009,538.72500000000002,393.52500000000003,278.85000000000002]
[29,null,null,1054.9000000000001,856.35,555.77500000000009,401.50000000000006,286.55]
[30,null,null,1081.0250000000001,881.92500000000007,572.82500000000005,410.3,295.625]
[31,null,null,1097.8000000000002,899.52500000000009,581.625,418.82500000000005,295.625]
[32,null,null,1123.9250000000002,925.1,598.40000000000009,426.25000000000006,302.77500000000003]
[33,null,null,1150.0500000000002,951.22500000000002,614.90000000000009,434.77500000000003,312.125]
[34,null,null,1176.1750000000002,977.90000000000009,631.95000000000005,451.00000000000006,320.10000000000002]
[35,null,null,1211.1000000000001,1003.4750000000001,648.45000000000005,458.97500000000002,327.8]
[36,null,null,1236.4000000000001,1029.325,665.5,474.92500000000001,336.6]
[37,null,null,1262.25,1054.9000000000001,682.27500000000009,483.45000000000005,344.57500000000005]
[38,null,null,1296.9000000000001,1089.5500000000002,708.12500000000011,499.67500000000007,352.82500000000005]
[39,null,null,1331.825,1123.9250000000002,732.32500000000005,517,360.8]
[40,null,null,1374.7250000000001,1150.0500000000002,749.92500000000007,524.15000000000009,369.6]
[41,null,null,1408.825,1185.25,774.95,540.92500000000007,377.02500000000003]
[42,null,null,1444.0250000000001,1218.8000000000002,799.7,557.42500000000007,385.55]
[43,null,null,1487.4750000000001,1262.25,825.00000000000011,573.65000000000009,401.50000000000006]
[44,null,null,1530.3750000000002,1296.9000000000001,858.55000000000007,590.42500000000007,410.3]
[45,null,null,1573.2750000000001,1340.075,883.57500000000005,607.20000000000005,426.25000000000006]
[46,null,null,1617.0000000000002,1383.5250000000001,909.15000000000009,623.15000000000009,434.77500000000003]
[47,null,null,1659.9,1418.1750000000002,942.97500000000002,639.375,443.02500000000003]
[48,null,null,1728.9250000000002,1478.4,984.77500000000009,663.85,458.97500000000002]
[49,null,null,1789.4250000000002,1530.3750000000002,1018.8750000000001,689.15000000000009,474.92500000000001]
[50,null,null,1850.2,1582.3500000000001,1060.95,712.80000000000007,483.45000000000005]
[51,null,null,1910.4250000000002,1642.0250000000001,1103.3000000000002,737.55000000000007,499.67500000000007]
[52,null,null,1970.9250000000002,1694.2750000000001,1136.575,762.02500000000009,517]
[53,null,null,2049.0250000000001,1763.3000000000002,1186.9000000000001,786.77500000000009,532.95000000000005]
[54,null,null,2126.5750000000003,1833.15,1237.7750000000001,818.67500000000007,540.92500000000007]
[55,null,null,2204.4,1902.45,1287.825,843.7,557.42500000000007]
[56,null,null,2281.9500000000003,1970.9250000000002,1338.4250000000002,876.42500000000007,573.65000000000009]
[57,null,null,2360.0500000000002,2039.9500000000003,1388.75,909.7,590.42500000000007]
[58,null,null,2463.7250000000004,2126.5750000000003,1464.65,942.15000000000009,607.20000000000005]
[59,null,null,2558.3250000000003,2212.375,1532.0250000000001,982.85,623.15000000000009]
[60,null,null,2662.8250000000003,2308.3500000000004,1599.1250000000002,1024.1000000000001,647.625]
[61,null,null,2809.4,2428.8000000000002,1692.075,1073.325,663.85]
[62,null,null,2999.4250000000002,2601.2250000000004,1818.0250000000001,1147.3000000000002,696.30000000000007]
[63,null,null,3284.05,2844.3250000000003,1995.1250000000002,1252.9000000000001,729.85]
[64,null,null,3672.9,3181.2000000000003,2238.5,1400.575,778.25000000000011]
[65,null,null,4174.7750000000005,3613.5000000000005,2550.0750000000003,1588.6750000000002,852.22500000000002]
[66,null,null,4788.3,4157.4500000000007,2928.4750000000004,1809.7750000000001,{"$f":"H535*$L$3","v":942.15000000000009}]
[67,null,null,5479.9250000000002,4770.1500000000005,3366.55,2063.875,1064.8000000000002]
[68,null,null,6222.4250000000002,5436.2000000000007,3829.1000000000004,2342.4500000000003,1195.9750000000001]
[69,null,null,7000.4000000000005,6136.6250000000009,4316.9500000000007,2636.4250000000002,1343.65]
[70,null,null,7804.2250000000004,6852.7250000000004,4838.0750000000007,2964.7750000000001,1499.0250000000001]
[71,null,null,8633.9000000000015,7604.5750000000007,5385.3250000000007,3307.7000000000003,1662.65]
[72,null,null,9488.3250000000007,8365.5,5957.6,3675.65,1834.5250000000001]
[73,null,null,10361.450000000001,9151.7250000000004,6563.4250000000002,4069.1750000000002,2014.65]
[74,null,null,11242.825000000001,9955.8250000000007,7194.2750000000005,4486.9000000000005,2194.5]
[75,null,null,12149.775000000001,10767.625,7850.4250000000002,4929.1000000000004,2383.15]
[76,null,null,13066.35,11596.750000000002,8532.4250000000011,5395.7750000000005,2579.2250000000004]
[77,null,null,13999.150000000001,12434.95,9238.625,5886.6500000000005,2783.55]
[78,null,null,14941.025000000001,13290.750000000002,9979.4750000000004,6402.2750000000005,2989.2500000000005]
[79,null,null,15892.250000000002,14146.275000000001,10744.800000000001,6934.6750000000002,3209.8]
[80,"o mas",null,16850.625,15019.400000000001,11535.975,7499.5250000000005,3423.2000000000003]
[1,"Hijo",null,449.90000000000003,260.15000000000003,193.87500000000003,139.70000000000002,99.000000000000014]
[2,"Hijos",null,752.12500000000011,{"$f":"E551*$L$3","v":390.22500000000002},303.875,214.22500000000002,148.22500000000002]
[3,"Hijos o más",null,{"$f":"D552*$L$3","v":1106.875},562.375,438.07500000000005,312.125,221.65]
[1,"Rider Comp. Maternidad",null,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007]
[1,"Transplante de organos",null,82.5,82.5,82.5,82.5,82.5]
[null,"Deductible Waiver",null,49.500000000000007,94.875000000000014,213.12500000000003,365.75000000000006,572]
[]
[]
[]
[]
["Bupa Essential Care: TARIFAS Trimestrales"]
["EDAD"]
[" "," ","ET1","ET2","ET3","ET4","ET5","ET6"]
[18,null,{"$f":"+C778*$L$3","v":402.6},{"$f":"+D778*$L$3","v":387.20000000000005},358.87500000000006,254.37500000000003,191.67500000000001,134.75]
[19,null,{"$f":"+C779*$L$3","v":410.3},394.62500000000006,366.02500000000003,259.05,191.67500000000001,139.15]
[20,null,{"$f":"+C780*$L$3","v":417.45000000000005},401.77500000000003,372.35,263.72500000000002,196.9,139.15]
[21,null,{"$f":"+C781*$L$3","v":425.15000000000003},408.92500000000001,378.95000000000005,268.40000000000003,201.57500000000002,144.10000000000002]
[22,null,{"$f":"+C782*$L$3","v":433.12500000000006},416.35,386.1,273.625,206.25000000000003,144.10000000000002]
[23,null,{"$f":"+C783*$L$3","v":440.00000000000006},423.22500000000002,392.15000000000003,278.02500000000003,206.25000000000003,149.32500000000002]
[24,null,{"$f":"+C784*$L$3","v":455.67500000000001},438.35,406.17500000000001,287.92500000000001,210.92500000000001,153.45000000000002]
[25,null,{"$f":"+C785*$L$3","v":463.1},445.22500000000002,412.77500000000003,292.60000000000002,216.15,153.45000000000002]
[26,null,{"$f":"+C786*$L$3","v":470.52500000000003},452.65000000000003,419.65000000000003,297.27500000000003,220.55,158.67500000000001]
[27,null,{"$f":"+C787*$L$3","v":478.77500000000003},460.35,426.52500000000003,302.22500000000002,225.50000000000003,158.67500000000001]
[28,null,{"$f":"+C788*$L$3","v":485.37500000000006},466.95000000000005,432.85,306.625,230.45000000000002,163.07500000000002]
[29,null,{"$f":"+C789*$L$3","v":501.05000000000007},481.8,446.6,316.52500000000003,235.12500000000003,167.75]
[30,null,{"$f":"+C790*$L$3","v":516.45000000000005},496.65000000000003,460.35,326.15000000000003,240.07500000000002,172.97500000000002]
[31,null,{"$f":"+C791*$L$3","v":524.15000000000009},504.07500000000005,467.50000000000006,331.1,244.75000000000003,172.97500000000002]
[32,null,{"$f":"+C792*$L$3","v":539.27500000000009},518.65000000000009,480.70000000000005,340.72500000000002,249.42500000000001,177.10000000000002]
[33,null,{"$f":"+C793*$L$3","v":554.40000000000009},532.95000000000005,494.17500000000007,349.8,254.37500000000003,182.32500000000002]
[34,null,{"$f":"+C794*$L$3","v":569.80000000000007},547.80000000000007,507.92500000000007,359.42500000000001,263.72500000000002,187.27500000000001]
[35,null,{"$f":"+C795*$L$3","v":584.375},561.82500000000005,521.125,368.77500000000003,268.40000000000003,191.67500000000001]
[36,null,{"$f":"+C796*$L$3","v":600.05000000000007},576.95000000000005,534.875,378.67500000000001,278.02500000000003,196.9]
[37,null,{"$f":"+C797*$L$3","v":614.90000000000009},591.25,548.07500000000005,388.02500000000003,282.70000000000005,201.57500000000002]
[38,null,{"$f":"+C798*$L$3","v":638.27500000000009},613.80000000000007,568.97500000000002,402.87500000000006,292.60000000000002,206.25000000000003]
[39,null,{"$f":"+C799*$L$3","v":660.27500000000009},634.97500000000002,588.77500000000009,416.90000000000003,302.22500000000002,210.92500000000001]
[40,null,{"$f":"+C800*$L$3","v":675.95},649.82500000000005,602.80000000000007,426.52500000000003,306.625,216.15]
[41,null,{"$f":"+C801*$L$3","v":698.5},671.82500000000005,622.875,440.82500000000005,316.52500000000003,220.55]
[42,null,{"$f":"+C802*$L$3","v":721.05000000000007},693.27500000000009,642.67500000000007,455.12500000000006,326.15000000000003,225.50000000000003]
[43,null,{"$f":"+C803*$L$3","v":743.32500000000005},715.27500000000009,663.02500000000009,469.42500000000001,335.22500000000002,235.12500000000003]
[44,null,{"$f":"+C804*$L$3","v":773.85},744.42500000000007,689.7,488.67500000000001,345.40000000000003,240.07500000000002]
[45,null,{"$f":"+C805*$L$3","v":796.40000000000009},765.87500000000011,710.32500000000005,502.97500000000002,355.3,249.42500000000001]
[46,null,{"$f":"+C806*$L$3","v":819.50000000000011},788.15000000000009,730.67500000000007,517.27500000000009,364.1,254.37500000000003]
[47,null,{"$f":"+C807*$L$3","v":849.75000000000011},817.30000000000007,757.62500000000011,536.52500000000009,373.72500000000002,259.05]
[48,null,{"$f":"+C808*$L$3","v":887.7},853.87500000000011,791.45,560.45000000000005,388.02500000000003,268.40000000000003]
[49,null,{"$f":"+C809*$L$3","v":918.22500000000002},883.30000000000007,818.67500000000007,579.97500000000002,402.87500000000006,278.02500000000003]
[50,null,{"$f":"+C810*$L$3","v":955.90000000000009},919.6,852.50000000000011,603.625,416.90000000000003,282.70000000000005]
[51,null,{"$f":"+C811*$L$3","v":994.40000000000009},956.17500000000007,886.6,627.82500000000005,431.20000000000005,292.60000000000002]
[52,null,{"$f":"+C812*$L$3","v":1024.375},985.05000000000007,913.27500000000009,646.80000000000007,445.50000000000006,302.22500000000002]
[53,null,{"$f":"+C813*$L$3","v":1069.75},1028.7750000000001,953.7,675.125,460.35,311.85000000000002]
[54,null,{"$f":"+C814*$L$3","v":1115.6750000000002},1072.7750000000001,994.67500000000007,704.27500000000009,478.77500000000003,316.52500000000003]
[55,null,{"$f":"+C815*$L$3","v":1160.5},1116.2250000000001,1034.5500000000002,732.6,493.35,326.15000000000003]
[56,null,{"$f":"+C816*$L$3","v":1206.7},1160.2250000000001,1075.8000000000002,761.75000000000011,512.6,335.22500000000002]
[57,null,{"$f":"+C817*$L$3","v":1251.5250000000001},1203.6750000000002,1115.6750000000002,790.07500000000005,531.85,345.40000000000003]
[58,null,{"$f":"+C818*$L$3","v":1320.2750000000001},1269.6750000000002,1177,833.52500000000009,551.1,355.3]
[59,null,{"$f":"+C819*$L$3","v":1381.0500000000002},1327.9750000000001,1231.1750000000002,871.75000000000011,574.75,364.1]
[60,null,{"$f":"+C820*$L$3","v":1441.2750000000001},1386,1284.8000000000002,909.97500000000002,598.95000000000005,378.67500000000001]
[61,null,{"$f":"+C821*$L$3","v":1524.8750000000002},1466.575,1359.6000000000001,962.77500000000009,627.82500000000005,388.02500000000003]
[62,null,{"$f":"+C822*$L$3","v":1638.7250000000001},1576.0250000000001,1460.8000000000002,1034.2750000000001,671,407.00000000000006]
[63,null,{"$f":"+C823*$L$3","v":1798.5000000000002},1729.2,1602.9750000000001,1135.2,732.6,426.52500000000003]
[64,null,{"$f":"+C824*$L$3","v":2017.9500000000003},1940.6750000000002,1799.0500000000002,1273.8000000000002,819.22500000000002,455.12500000000006]
[65,null,{"$f":"+C825*$L$3","v":2298.7250000000004},2210.4500000000003,2049.3000000000002,1450.9,929.22500000000002,498.30000000000007]
[66,null,{"$f":"+C826*$L$3","v":2640},2538.8000000000002,2353.4500000000003,1666.2250000000001,1058.4750000000001,551.1]
[67,null,{"$f":"+C827*$L$3","v":3034.6250000000005},2918.3,2705.1750000000002,1915.65,1206.9750000000001,622.875]
[68,null,{"$f":"+C828*$L$3","v":3451.5250000000001},3319.2500000000005,3076.9750000000004,2178.5500000000002,1369.5,699.32500000000005]
[69,null,{"$f":"+C829*$L$3","v":3890.9750000000004},3742.2000000000003,3468.8500000000004,2456.3000000000002,1541.9250000000002,785.67500000000007]
[70,null,{"$f":"+C830*$L$3","v":4361.2250000000004},4194.3,3888.2250000000004,2753.0250000000001,1733.6000000000001,876.7]
[71,null,{"$f":"+C831*$L$3","v":4854.5750000000007},4668.4000000000005,4327.6750000000002,3064.05,1934.3500000000001,972.40000000000009]
[72,null,{"$f":"+C832*$L$3","v":5370.2000000000007},5164.2250000000004,4787.4750000000004,3389.65,2149.6750000000002,1072.7750000000001]
[73,null,{"$f":"+C833*$L$3","v":5916.35},5690.0250000000005,5274.5,3734.5000000000005,2379.5750000000003,1178.375]
[74,null,{"$f":"+C834*$L$3","v":6485.05},6236.7250000000004,5781.3250000000007,4093.6500000000005,2624.05,1283.4250000000002]
[75,null,{"$f":"+C835*$L$3","v":7076.5750000000007},6805.4250000000002,6308.7750000000005,4466.8250000000007,2882.55,1393.4250000000002]
[76,null,{"$f":"+C836*$L$3","v":7691.2000000000007},7396.6750000000002,6856.85,4854.8500000000004,3155.3500000000004,1508.3750000000002]
[77,null,{"$f":"+C837*$L$3","v":8327.8250000000007},8009.1,7424.4500000000007,5256.625,3442.4500000000003,1628.0000000000002]
[78,null,{"$f":"+C838*$L$3","v":8995.5250000000015},8650.9500000000007,8019.5500000000011,5677.9250000000002,3744.1250000000005,1747.9]
[79,null,{"$f":"+C839*$L$3","v":9685.5},9314.8000000000011,8634.7250000000004,6113.5250000000005,4055.1500000000005,1877.15]
[80,"o mas",{"$f":"+C840*$L$3","v":10398.85},10000.650000000001,9270.5250000000015,6563.9750000000004,4385.7000000000007,2002.0000000000002]
[1,"Hijo",{"$f":"+C841*$L$3","v":174.625},168.02500000000001,155.92500000000001,110.27500000000001,92.125000000000014,72.600000000000009]
[2,"Hijos",{"$f":"+C842*$L$3","v":273.90000000000003},263.45000000000005,244.20000000000002,172.97500000000002,144.10000000000002,113.85000000000001]
[3,"Hijos o más",{"$f":"+C843*$L$3","v":394.90000000000003},379.77500000000003,352,249.42500000000001,207.9,163.9]
[1,"Rider Comp. Maternidad",{"$f":"+C844*$L$3","v":61.875000000000007},61.875000000000007,61.875000000000007,0,0,0]
[1,"Transplante de organos",{"$f":"+C845*$L$3","v":82.5},82.5,82.5,82.5,82.5,82.5]