{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["INGRESO DE DATOS","Complete","Secure Care","Advantage (LA)","Classic","Blue 500","Blue 100","Essential Care","Resumen tarifas anuales","Tablas"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":3,"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":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[7,0,7,9],[24,3,24,9],[17,7,17,8],[13,3,13,9],[15,3,15,5],[15,7,15,8],[8,0,8,9]]}
[]
[]
[]
[]
[]
[]
[]
[" Tarifas efectivas a partir del 1ro de enero de 2022 "]
["(Para nuevos negocios emitidos a partir del 1 de enero 2022 y renovaciones de pólizas emitidas a partir del 1 de abril 2018)"]
[null,null,null,null,null,null,null,null,null,null," "]
[]
["1. 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,3]
[]
[null,null,null,null,null," Edad de Titular:",65,"Edad de Cónyuge:",null,71]
[]
[null,null,null,null,null,"Descuento:",0]
[]
[]
["2. INGRESE EL NOMBRE DE LA AGENCIA ASESORA:"]
[]
[null,null,"Intermediario:","Agente / Agencia"]
[]
[]
[]
["3. ESCOJA EL PRODUCTO PARA VISUALIZAR LA COTIZACION RESPECTIVA:"]

{"sheet":"Complete","index":1,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":true,"merged":[[34,0,34,1],[29,0,29,1],[24,0,24,1],[0,0,0,9],[22,3,22,9],[33,3,33,9],[3,0,3,1],[5,4,5,9],[7,4,7,9],[1,0,1,9],[9,0,9,1],[15,0,15,1],[17,3,17,9],[58,3,60,9],[45,3,45,9],[54,0,54,1],[55,0,55,1],[53,0,53,1],[57,3,57,9],[49,0,49,1]]}
["Cotización de Seguro Médico Internacional"]
["Producto: COMPLETE"]
[]
["COBERTURA"]
["Cobertura máxima por año","$7,000,000"]
["Área de cobertura","Mundial",null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$14","v":"Nombre"}]
["Red de proveedores en EE.UU.","Abierta"]
["Red de proveedores fuera de EE.UU.","Abierta ",null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$25","v":"Agente / Agencia"}]
["Cobertura extendida para dependientes en caso de muerte de asegurado principal","2 años"]
["BENEFICIOS POR HOSPITALIZACION",null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G20>0,'INGRESO DE DATOS'!G20,\"\")","v":""}]
["Habitación y alimentación dentro de la red",1]
["Unidad de cuidados intensivos dentro de la red",1,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!G16","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$18","v":65}]
["Honorarios médicos y de enfermería",1]
["Medicamentos por receta durante la hospitalización",1,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$18","v":71}]
["Cama para acompañante de menor (por día)","$300",null,null,null,null," "," "," "]
["BENEFICIOS POR PROCEDIMIENTOS AMBULATORIOS",null,null,null,null,"Coberturas Adicionales:",null,"Complicaciones de Maternidad (+ $500,000)"]
["Cirugía ambulatoria",1,null,null,null,null,null,false]
["Visitas a médicos y especialistas (por visita)",1,null,"Deducibles"]
["Medicamentos después de hospitalización o tratamiento ambulatorio",1,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Medicamentos por receta por tratamiento ambulatorio (en consulta externa)",1,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
["Procedimiento de Diagnóstico",1,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
["Fisioterapia y rehabilitación",1]
["Atención médica en el hogar (por día)",1,null,"Tarifas Anuales"]
["Reconocimiento medico de rutina (no aplica deducible) ","$300",null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$12,Tablas!$A$6:$H$29,4,TRUE)","v":31412},{"$f":"VLOOKUP($J$12,Tablas!$A$6:$H$29,5,TRUE)","v":22205},{"$f":"VLOOKUP($J$12,Tablas!$A$6:$H$29,6,TRUE)","v":17097},{"$f":"VLOOKUP($J$12,Tablas!$A$6:$H$29,7,TRUE)","v":15529},{"$f":"VLOOKUP($J$12,Tablas!$A$6:$H$29,8,TRUE)","v":13201}]
["BENEFICIOS POR MATERNIDAD",null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$6:$H$29,4,TRUE)))","v":62112},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$6:$H$29,5,TRUE)))","v":43400},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$6:$H$29,6,TRUE)))","v":32322},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$6:$H$29,7,TRUE)))","v":29085},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$6:$H$29,8,TRUE)))","v":24937}]
["Embarazo, maternidad y parto","$7,500",null,"Primas Hijos","n/a",{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$30:$H$32,4,TRUE)))","v":9359},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$30:$H$32,5,TRUE)))","v":4351},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$30:$H$32,6,TRUE)))","v":3442},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$30:$H$32,7,TRUE)))","v":2883},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$30:$H$32,8,TRUE)))","v":2127}]
["Cobertura provisional del recién nacido (no aplica deducible)","$30,000",null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($H$17=FALSE,0,Tablas!D$33)","v":0},{"$f":"+IF($H$17=FALSE,0,Tablas!E$33)","v":0},{"$f":"+IF($H$17=FALSE,0,Tablas!F$33)","v":0},{"$f":"+IF($H$17=FALSE,0,Tablas!G$33)","v":0},{"$f":"+IF($H$17=FALSE,0,Tablas!H$33)","v":0}]
["Almacenamiento de sangre del cordón umbilical (no aplica deducible)","$1,000",null,"PRIMA NETA","n/a",{"$f":"SUM(F24:F27)","v":102883},{"$f":"SUM(G24:G27)","v":69956},{"$f":"SUM(H24:H27)","v":52861},{"$f":"SUM(I24:I27)","v":47497},{"$f":"SUM(J24:J27)","v":40265}]
["Complicaciones del embarazo, maternidad y el parto","$1,000,000",null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F24+F25+F26)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G24+G25+G26)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H24+H25+H26)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I24+I25+I26)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J24+J25+J26)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
["BENEFICIOS POR TRANSPORTACION MEDICA",null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
["Ambulancia aérea (no aplica deducible por emergencia)","$125,000",null,"IVA (12%)","n/a",{"$f":"+(F28+F29+F30)*12%","v":12354.96},{"$f":"+(G28+G29+G30)*12%","v":8403.7199999999993},6352.32,5708.6399999999994,{"$f":"+(J28+J29+J30)*12%","v":4840.8}]
["Viaje de regreso (Asegurado y 1 acompañante)",1,null,"TOTAL","n/a",{"$f":"SUM(F28:F31)","v":115312.95999999999},{"$f":"SUM(G28:G31)","v":78434.720000000001},59288.32,53280.639999999999,{"$f":"SUM(J28:J31)","v":45180.800000000003}]
["Ambulancia terrestre (no aplica deducible por emergencia)",1]
["Repatriación de restos mortales",1,null,"Tarifas Semestrales"]
["OTROS BENEFICIOS",null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$12,Tablas!$A$39:$H$62,4,TRUE)","v":13829.820000000002},{"$f":"VLOOKUP($J$12,Tablas!$A$39:$H$62,5,TRUE)","v":9775.85},{"$f":"VLOOKUP($J$12,Tablas!$A$39:$H$62,6,TRUE)","v":7527.06},{"$f":"VLOOKUP($J$12,Tablas!$A$39:$H$62,7,TRUE)","v":6837},{"$f":"VLOOKUP($J$12,Tablas!$A$39:$H$62,8,TRUE)","v":5811.9800000000005}]
["Tratamiento del cáncer",1,null,"Prima Cónyuge","n/a",{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$39:$H$62,4,TRUE)))","v":27346.940000000002},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$39:$H$62,5,TRUE)))","v":19108.09},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$39:$H$62,6,TRUE)))","v":14230.5},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$39:$H$62,7,TRUE)))","v":12805.33},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$39:$H$62,8,TRUE)))","v":10978.95}]
["Insuficiencia renal (diálisis)",1,null,"Primas Hijos","n/a",{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,4,TRUE)))","v":2627.21},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,5,TRUE)))","v":1915.42},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,6,TRUE)))","v":1514.74},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,7,TRUE)))","v":1268.8200000000002},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,8,TRUE)))","v":935.98}]
["Procedimientos de trasplante","$1,500,000",null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$17=FALSE,0,Tablas!D$66)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!E$66)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!F$66)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!G$66)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!H$66)","v":0}]
["Preparación del donante","$50,000",null,"PRIMA NETA","n/a",{"$f":"SUM(F35:F38)","v":43803.97},{"$f":"SUM(G35:G38)","v":30799.360000000001},{"$f":"SUM(H35:H38)","v":23272.300000000003},{"$f":"SUM(I35:I38)","v":20911.150000000001},{"$f":"SUM(J35:J38)","v":17726.91}]
["Condiciones congénitas y/o hereditarias antes de los 18 años","$1,000,000",null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F35+F36+F37)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G35+G36+G37)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H35+H36+H37)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I35+I36+I37)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J35+J36+J37)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
["Condiciones congénitas y/o hereditarias después de los 18 años",1,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
["Protesis - Brazos y piernas artificiales (Máximo $120,000 vitalicio)","$30,000",null,"IVA (12%)","n/a",{"$f":"+(F39+F40+F41)*12%","v":5265.4763999999996},{"$f":"+(G39+G40+G41)*12%","v":3704.9231999999997},2801.6760000000004,2518.3380000000002,{"$f":"+(J39+J40+J41)*12%","v":2136.2291999999998}]
["Tratamientos especiales",1,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F39:F42)","v":49144.446400000001},{"$f":"SUM(G39:G42)","v":34579.283199999998},{"$f":"SUM(H39:H42)","v":26148.976000000002},{"$f":"SUM(I39:I42)","v":23504.488000000001},{"$f":"SUM(J39:J42)","v":19938.139199999998}]
["Sala de emergencias",1,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F39+F40+F42-(F41*0.12)","v":49060.446400000001},{"$f":"G39+G40+G42-(G41*0.12)","v":34495.283199999998},26064.976000000002,23420.488000000001,{"$f":"J39+J40+J42-(J41*0.12)","v":19854.139199999998}]
["Tratamiento dental de emergencia",1]
["Residencia para pacientes terminales y cuidados paliativos",1,null,"Tarifas Semestrales"]
["Terapeuta complementario","100% (máx. 20 sesiones)",null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$12,Tablas!$A$923:$H$946,4,TRUE)","v":8638.3000000000011},{"$f":"VLOOKUP($J$12,Tablas!$A$923:$H$946,5,TRUE)","v":6106.3750000000009},{"$f":"VLOOKUP($J$12,Tablas!$A$923:$H$946,6,TRUE)","v":4701.6750000000002},{"$f":"VLOOKUP($J$12,Tablas!$A$923:$H$946,7,TRUE)","v":4270.4750000000004},{"$f":"VLOOKUP($J$12,Tablas!$A$923:$H$946,8,TRUE)","v":3630.2750000000001}]
["Actividades peligrosas","100% (cubre profesionales)",null,"Prima Cónyuge","n/a",{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$923:$H$946,4,TRUE)))","v":17080.800000000003},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$923:$H$946,5,TRUE)))","v":11935.000000000002},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$923:$H$946,6,TRUE)))","v":8888.5500000000011},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$923:$H$946,7,TRUE)))","v":7998.3750000000009},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$923:$H$946,8,TRUE)))","v":6857.6750000000002}]
["VIH/SIDA","Por accidente",null,"Primas Hijos","n/a",{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$947:$H$949,4,TRUE)))","v":2573.7250000000004},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,5,TRUE)))","v":1915.42},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,6,TRUE)))","v":1514.74},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,7,TRUE)))","v":1268.8200000000002},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,8,TRUE)))","v":935.98}]
["ANEXOS ADICIONALES",null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$17=FALSE,0,Tablas!D$950)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!E$950)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!F$950)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!G$950)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!H$950)","v":0}]
["Anexo cobertura complicaciones perinatales y del embarazo","$500,000",null,"PRIMA NETA","n/a",{"$f":"SUM(F47:F50)","v":28292.825000000004},{"$f":"SUM(G47:G50)","v":19956.795000000006},{"$f":"SUM(H47:H50)","v":15104.965000000002},{"$f":"SUM(I47:I50)","v":13537.670000000002},{"$f":"SUM(J47:J50)","v":11423.93}]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G34>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F47+F48+F49)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G47+G48+G49)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H47+H48+H49)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I47+I48+I49)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J47+J48+J49)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
["Bupa Guatemala, Compañía de Seguros, S.A.",null,null,"IVA (12%)","n/a",{"$f":"+(F51+F52+F53)*12%","v":3404.1390000000006},{"$f":"+(G51+G52+G53)*12%","v":2403.8154000000004},1821.5958000000003,1633.5204000000001,{"$f":"+(J51+J52+J53)*12%","v":1379.8715999999999}]
["5 Avenida 5-55 Zona 14, Europlaza World Business Center, Torre 3, Nivel 11, Guatemala",null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F51:F54)","v":31771.964000000004},{"$f":"SUM(G51:G54)","v":22435.610400000005},{"$f":"SUM(H51:H54)","v":17001.560800000003},{"$f":"SUM(I51:I54)","v":15246.190400000001},{"$f":"SUM(J51:J54)","v":12878.801600000001}]
["PBX: 2300-8000 / www.bupasalud.com / servicioguatemala@bupalatinamerica.com",null,null,"TOTAL  (2da a 4ta Cuota)","n/a",{"$f":"F51+F52+F54-(F53*0.12)","v":31687.964000000004},{"$f":"G51+G52+G54-(G53*0.12)","v":22351.610400000005},16917.560800000003,15162.190400000001,{"$f":"J51+J52+J54-(J53*0.12)","v":12794.801600000001}]
[]
[null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2018"]
[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 Care","index":2,"n_rows":72,"n_cols":12,"rows_kept":72,"cut":false,"hidden":true,"merged":[[70,3,70,9],[71,3,71,9],[0,0,0,9],[1,0,1,9],[62,3,62,9],[19,3,19,9],[24,3,24,9],[36,3,36,9],[7,0,7,1],[27,0,27,1],[19,0,19,1],[32,0,32,1],[37,0,37,1],[13,0,13,1],[48,0,48,1],[49,3,49,9],[5,4,5,9],[7,4,7,9],[63,3,65,9],[5,0,5,1],[69,3,69,9]]}
["Cotización de Seguro Médico Internacional"]
["Producto: Essential Care",null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "," "]
["BUPA ESSENTIAL CARE",null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$14","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$25","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-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$16","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$18","v":65}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$18","v":71}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,false,null,"Complicaciones de Maternidad (+ $500,000)"]
[]
[null,null,null,null,null,false,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$12,Tablas!$A$140:$H$163,4,TRUE)","v":12894},{"$f":"VLOOKUP($J$12,Tablas!$A$140:$H$163,5,TRUE)","v":11735},{"$f":"VLOOKUP($J$12,Tablas!$A$140:$H$163,6,TRUE)","v":8455},{"$f":"VLOOKUP($J$12,Tablas!$A$140:$H$163,7,TRUE)","v":7298},{"$f":"VLOOKUP($J$12,Tablas!$A$140:$H$163,8,TRUE)","v":5444}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$140:$H$163,4,TRUE)))","v":18570},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$140:$H$163,5,TRUE)))","v":17373},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$140:$H$163,6,TRUE)))","v":12353},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$140:$H$163,7,TRUE)))","v":10655},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$140:$H$163,8,TRUE)))","v":7916}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$164:$H$166,4,TRUE)))","v":4246},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$164:$H$166,5,TRUE)))","v":2163},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$164:$H$166,6,TRUE)))","v":1969},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$164:$H$166,7,TRUE)))","v":1698},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$164:$H$166,8,TRUE)))","v":1275}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$16=FALSE,0,Tablas!D$167)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!E$167)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!F$167)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!G$167)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!H$167)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$18=FALSE,0,Tablas!D$341)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!E$341)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!F$341)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!G$341)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!H$341)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F26:F30)","v":35710},{"$f":"SUM(G26:G30)","v":31271},22777,19651,14635]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F26+F27+F28)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G26+G27+G28)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H26+H27+H28)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I26+I27+I28)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J26+J27+J28)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F31+F32+F33)*12%","v":4294.2},{"$f":"+(G31+G32+G33)*12%","v":3761.52},2742.24,2367.12,{"$f":"+(J31+J32+J33)*12%","v":1765.2}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F31:F34)","v":40079.199999999997},{"$f":"SUM(G31:G34)","v":35107.519999999997},{"$f":"SUM(H31:H34)","v":25594.239999999998},{"$f":"SUM(I31:I34)","v":22093.119999999999},{"$f":"SUM(J31:J34)","v":16475.2}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$12,Tablas!$A$173:$H$196,4,TRUE)","v":5676.83},{"$f":"VLOOKUP($J$12,Tablas!$A$173:$H$196,5,TRUE)","v":5166.4400000000005},{"$f":"VLOOKUP($J$12,Tablas!$A$173:$H$196,6,TRUE)","v":3722.19},{"$f":"VLOOKUP($J$12,Tablas!$A$173:$H$196,7,TRUE)","v":3212.86},{"$f":"VLOOKUP($J$12,Tablas!$A$173:$H$196,8,TRUE)","v":2396.6600000000003}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$173:$H$196,4,TRUE)))","v":8175.7800000000007},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$173:$H$196,5,TRUE)))","v":7648.43},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$173:$H$196,6,TRUE)))","v":5438.33},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$173:$H$196,7,TRUE)))","v":4691.0300000000007},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$173:$H$196,8,TRUE)))","v":3484.75}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$197:$H$199,4,TRUE)))","v":1869.3100000000002},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$197:$H$199,5,TRUE)))","v":951.88},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$197:$H$199,6,TRUE)))","v":866.55000000000007},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$197:$H$199,7,TRUE)))","v":747.3},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$197:$H$199,8,TRUE)))","v":560.74}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$16=FALSE,0,Tablas!D$200)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!E$200)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!F$200)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!G$200)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!H$200)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$18=FALSE,0,Tablas!D$413)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!E$413)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!F$413)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!G$413)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!H$413)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F38:F42)","v":15721.92},{"$f":"SUM(G38:G42)","v":13766.75},10027.07,8651.19,6442.15]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F38+F39+F40)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G38+G39+G40)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H38+H39+H40)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I38+I39+I40)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J38+J39+J40)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F43+F44+F45)*12%","v":1895.6304},{"$f":"+(G43+G44+G45)*12%","v":1661.01},1212.2483999999999,1047.1428000000001,{"$f":"+(J43+J44+J45)*12%","v":782.05799999999988}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F43:F46)","v":17692.5504},{"$f":"SUM(G43:G46)","v":15502.76},{"$f":"SUM(H43:H46)","v":11314.3184},{"$f":"SUM(I43:I46)","v":9773.3328000000001},{"$f":"SUM(J43:J46)","v":7299.2079999999996}]
[null,null,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F43+F44+F46-(F45*0.12)","v":17608.5504},{"$f":"G43+G44+G46-(G45*0.12)","v":15418.76},11230.3184,9689.3328000000001,7215.2079999999996]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$12,Tablas!$A$957:$H$980,4,TRUE)","v":3545.8500000000004},{"$f":"VLOOKUP($J$12,Tablas!$A$957:$H$980,5,TRUE)","v":3227.1250000000005},{"$f":"VLOOKUP($J$12,Tablas!$A$957:$H$980,6,TRUE)","v":2325.125},{"$f":"VLOOKUP($J$12,Tablas!$A$957:$H$980,7,TRUE)","v":2006.9500000000003},{"$f":"VLOOKUP($J$12,Tablas!$A$957:$H$980,8,TRUE)","v":1497.1000000000001}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$957:$H$980,4,TRUE)))","v":5106.75},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$957:$H$980,5,TRUE)))","v":4777.5750000000007},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$957:$H$980,6,TRUE)))","v":3397.0750000000003},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$957:$H$980,7,TRUE)))","v":2930.1250000000005},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$957:$H$980,8,TRUE)))","v":2176.9}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$981:$H$983,4,TRUE)))","v":1167.6500000000001},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$981:$H$983,5,TRUE)))","v":594.82500000000005},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$981:$H$983,6,TRUE)))","v":541.47500000000002},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$981:$H$983,7,TRUE)))","v":466.95000000000005},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$981:$H$983,8,TRUE)))","v":350.625}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$16=FALSE,0,Tablas!D$984)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!E$984)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!F$984)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!G$984)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!H$984)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$18=FALSE,0,Tablas!D$413)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!E$413)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!F$413)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!G$413)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!H$413)","v":0}]
[" ",null,null,"PRIMA NETA","n/a",{"$f":"SUM(F51:F55)","v":9820.25},{"$f":"SUM(G51:G55)","v":8599.5250000000015},6263.6750000000011,5404.0250000000005,4024.625]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G35>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F51+F52+F53)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G51+G52+G53)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H51+H52+H53)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I51+I52+I53)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J51+J52+J53)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F56+F57+F58)*12%","v":1187.43},{"$f":"+(G56+G57+G58)*12%","v":1040.9430000000002},760.64100000000008,657.48300000000006,{"$f":"+(J56+J57+J58)*12%","v":491.95499999999998}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F56:F59)","v":11082.68},{"$f":"SUM(G56:G59)","v":9715.4680000000008},{"$f":"SUM(H56:H59)","v":7099.3160000000007},{"$f":"SUM(I56:I59)","v":6136.5080000000007},{"$f":"SUM(J56:J59)","v":4591.58}]
[null,null,null,"TOTAL  (2da a 4ta Cuota)","n/a",{"$f":"F56+F57+F59-(F58*0.12)","v":10998.68},{"$f":"G56+G57+G59-(G58*0.12)","v":9631.4680000000008},7015.3160000000007,6052.5080000000007,4507.58]
[]
[null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2018"]
[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":"Advantage (LA)","index":3,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":true,"merged":[[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
["Bupa Advantage Care (cobertura solo en Latinoamérica)",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$14","v":"Nombre"}]
["Cobertura Máxima anual",null,"US $ 3,500,000"]
["Cobertura Geografica",null,"Limitada a Latinoamérica excluyendo México",null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$25","v":"Agente / Agencia"}]
["Condiciones médicas cubiertas",null,"Todas las condiciones médicas"]
["Redes de proveedores",null,"Red de Proveedores \"Bupa Advantage\"",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$18","v":65}]
["Opciones fuera de la Red",null,"NO, solo en casos de emergencia",null,null,"FECHA DE COTIZACION :"]
["Requiere preautorización",null,"SI, 30% de penalización por omitir prenotificación",null,null,{"$f":"NOW()","v":"2021-12-20T18:26:45"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":3},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":71}]
[null,null,null,null,null,null,null,null,null," "," "," "]
["Número máximo de días de hospitalización",null,"Ilimitado",null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
["Habitación y alimentación",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
["Cuidados Intensivos",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null," "]
["Cobertura de Maternidad",null,"$5,000 (Excepto planes 4,5, y 6)",null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Cobertura Provisional de Recién Nacido",null,"$30,000 por los primeros 90 días",null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Cuidado del Recién Nacido saludable",null,"Ya incluída dentro del beneficio de Maternidad",null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
["Cobertura de Complicaciones de Maternidad",null,"Disponible a través de cobertura opcional adicional"]
["Trasplante de Organos",null,"$1,000,000 de por vida, por diagnóstico"]
["Condiciones congénitas y hereditarias",null,"<18 años $300,000 de por vida; >=18 al 100%",null,null,"Tarifas Anuales"]
["Coberturas opcionales (Riders)",null,"Complicaciones de Maternidad por $500,000",null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,4,TRUE)","v":15378},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,5,TRUE)","v":11902},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,6,TRUE)","v":8897},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,7,TRUE)","v":7032},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,8,TRUE)","v":5708}]
[null,null,"Trasplante de órganos por $ 300,000 adicionales",null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,4,TRUE)))","v":23726},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,5,TRUE)))","v":18422},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,6,TRUE)))","v":13767},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,7,TRUE)))","v":10928},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,8,TRUE)))","v":8825}]
["Acompañamiento de menores hospitalizados",null,"$300 por día",null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,4,TRUE)))","v":3757},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,5,TRUE)))","v":2580},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,6,TRUE)))","v":2048},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,7,TRUE)))","v":1803},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,8,TRUE)))","v":1269}]
["Ambulancia aérea",null,"$100,000 por año y ticket aéreo de retorno",null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$447)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$447)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$447)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$447)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$447)","v":225}]
["Repatriación restos mortales",null,1,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$448)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$448)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$448)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$448)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$448)","v":300}]
["Medicamentos por receta",null,"$6,000 por Asegurado, por año póliza",null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":43386},33429,25237,20288,16327]
["Almacenamiento de sangre de cordon umbilical",null,"$500  (Excepto planes 4,5, y 6)",null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL :",null,"n/a",{"$f":"SUM(I36:I37)","v":43461},{"$f":"SUM(J36:J37)","v":33504},{"$f":"SUM(K36:K37)","v":25312},{"$f":"SUM(L36:L37)","v":20363},{"$f":"SUM(M36:M37)","v":16402}]
["Atención médica en el hogar",null,"100% de usual/acostumbrado y razonable"]
["Rehabilitación",null,"100% de usual/acostumbrado y razonable",null,null,"Tarifas Semestrales"]
["Residencia y cuidados paliativos",null,"100% de usual/acostumbrado y razonable",null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,4,TRUE)","v":8150.34},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,5,TRUE)","v":6308.06},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,6,TRUE)","v":4715.41},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,7,TRUE)","v":3726.96},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,8,TRUE)","v":3025.2400000000002}]
["Cobertura de actividades peligrosas",null,1,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,4,TRUE)))","v":12574.78},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,5,TRUE)))","v":9763.66},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,6,TRUE)))","v":7296.51},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,7,TRUE)))","v":5791.84},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,8,TRUE)))","v":4677.25}]
["Chequeos generales de rutina",null,"Hasta US$150 por año póliza.Sin deducible",null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,4,TRUE)))","v":1991.21},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,5,TRUE)))","v":1367.4},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,6,TRUE)))","v":1085.44},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,7,TRUE)))","v":955.59},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,8,TRUE)))","v":672.57}]
["Cobertura de VIH, SIDA, CAS",null,"Solo como efecto de transfusión de sangre",null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$480)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$480)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$480)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$480)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$480)","v":119.25}]
["Cobertura de brazos y piernas artificiales",null,"$30,000 por año y hasta $120,000 de por vida",null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$481)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$481)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$481)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$481)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$481)","v":159}]
["Cobertura extendida para dependientes en caso de muerte de asegurado principal",null,"2 años sin costo",null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":22994.58},17717.370000000003,13375.61,10752.64,8653.31]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,"n/a",{"$f":"SUM(I46:I47)","v":23069.58},{"$f":"SUM(J46:J47)","v":17792.370000000003},{"$f":"SUM(K46:K47)","v":13450.61},{"$f":"SUM(L46:L47)","v":10827.64},{"$f":"SUM(M46:M47)","v":8728.31}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":22994.58},{"$f":"J46","v":17717.370000000003},13375.61,10752.64,8653.31]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2013"]

{"sheet":"Classic","index":4,"n_rows":86,"n_cols":10,"rows_kept":86,"cut":false,"hidden":false,"merged":[[83,3,83,9],[84,3,84,9],[85,3,85,9],[77,3,79,9],[76,3,76,9],[60,3,60,9],[70,0,70,1],[71,0,71,1],[72,0,72,1],[31,0,31,1],[55,0,55,1],[31,3,31,9],[44,3,44,9],[42,0,42,1],[37,0,37,1],[7,3,7,9],[8,3,8,9],[26,3,26,9],[17,0,17,1],[9,0,9,1],[10,4,10,9],[12,4,12,9],[11,0,11,1],[23,0,23,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$14","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$25","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-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$16","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$18","v":65}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$18","v":71}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,"Complicaciones de Maternidad"]
[null,null,null,false]
[null,null,null,false,null,null,null,"Trasplante de Órganos"]
[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$17,Tablas!$A$487:$H$549,4,TRUE)","v":12172.85},{"$f":"VLOOKUP($J$17,Tablas!$A$487:$H$549,5,TRUE)","v":10536.6},{"$f":"VLOOKUP($J$17,Tablas!$A$487:$H$549,6,TRUE)","v":7435.8},{"$f":"VLOOKUP($J$17,Tablas!$A$487:$H$549,7,TRUE)","v":4632.5},{"$f":"VLOOKUP($J$17,Tablas!$A$487:$H$549,8,TRUE)","v":2484.5499999999997}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$487:$H$549,4,TRUE)))","v":25175.3},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$487:$H$549,5,TRUE)))","v":22173.95},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$487:$H$549,6,TRUE)))","v":15702.9},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$487:$H$549,7,TRUE)))","v":9644.9499999999989},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$487:$H$549,8,TRUE)))","v":4847.55}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$550:$H$552,4,TRUE)))","v":3227.45},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$550:$H$552,5,TRUE)))","v":1639.6499999999999},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$550:$H$552,6,TRUE)))","v":1276.7},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$550:$H$552,7,TRUE)))","v":909.5},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$550:$H$552,8,TRUE)))","v":646}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($D$22=FALSE,0,Tablas!D$553)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!E$553)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!F$553)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!G$553)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!H$553)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($D$23=FALSE,0,Tablas!D$554)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!E$554)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!F$554)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!G$554)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!H$554)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($D$24=FALSE,0,Tablas!D$555)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!E$555)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!F$555)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!G$555)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!H$555)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F33:F38)","v":40575.599999999999},{"$f":"SUM(G33:G38)","v":34350.200000000004},24415.4,15186.949999999999,7978.1]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F33+F34+F35)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G33+G34+G35)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H33+H34+H35)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I33+I34+I35)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J33+J34+J35)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F39+F40+F41)*12%","v":4878.0719999999992},{"$f":"+(G39+G40+G41)*12%","v":4131.0240000000003},2938.848,1831.4339999999997,{"$f":"+(J39+J40+J41)*12%","v":966.37199999999996}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F39:F42)","v":45528.671999999999},{"$f":"SUM(G39:G42)","v":38556.224000000002},{"$f":"SUM(H39:H42)","v":27429.248},{"$f":"SUM(I39:I42)","v":17093.383999999998},{"$f":"SUM(J39:J42)","v":9019.4719999999998}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$17,Tablas!$A$559:$H$621,4,TRUE)","v":6451.6105000000007},{"$f":"VLOOKUP($J$17,Tablas!$A$559:$H$621,5,TRUE)","v":5584.3980000000001},{"$f":"VLOOKUP($J$17,Tablas!$A$559:$H$621,6,TRUE)","v":3940.9740000000002},{"$f":"VLOOKUP($J$17,Tablas!$A$559:$H$621,7,TRUE)","v":2455.2249999999999},{"$f":"VLOOKUP($J$17,Tablas!$A$559:$H$621,8,TRUE)","v":1316.8115}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$559:$H$621,4,TRUE)))","v":13342.909},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$559:$H$621,5,TRUE)))","v":11752.193500000001},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$559:$H$621,6,TRUE)))","v":8322.5370000000003},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$559:$H$621,7,TRUE)))","v":5111.8234999999995},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$559:$H$621,8,TRUE)))","v":2569.2015000000001}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$622:$H$624,4,TRUE)))","v":1710.5484999999999},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$622:$H$624,5,TRUE)))","v":869.0145},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$622:$H$624,6,TRUE)))","v":676.65100000000007},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$622:$H$624,7,TRUE)))","v":482.03500000000003},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$622:$H$624,8,TRUE)))","v":342.38}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($D$22=FALSE,0,Tablas!D$625)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!E$625)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!F$625)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!G$625)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!H$625)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($D$23=FALSE,0,Tablas!D$626)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!E$626)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!F$626)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!G$626)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!H$626)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($D$24=FALSE,0,Tablas!D$627)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!E$627)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!F$627)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!G$627)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!H$627)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F46:F51)","v":21505.068000000003},{"$f":"SUM(G46:G51)","v":18205.606000000003},12940.162,8049.0834999999988,4228.393]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F46+F47+F48)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G46+G47+G48)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H46+H47+H48)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I46+I47+I48)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J46+J47+J48)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F52+F53+F54)*0.12","v":2589.6081600000002},{"$f":"+(G52+G53+G54)*12%","v":2193.6727200000005},1561.81944,974.89001999999982,{"$f":"+(J52+J53+J54)*12%","v":516.40715999999998}]
[null,null,null,"(1ra Cuota)","n/a",{"$f":"SUM(F52:F55)","v":24169.676160000003},{"$f":"SUM(G52:G55)","v":20474.278720000002},{"$f":"SUM(H52:H55)","v":14576.98144},{"$f":"SUM(I52:I55)","v":9098.9735199999996},{"$f":"SUM(J52:J55)","v":4819.8001599999998}]
[null,null,null,"(2da Cuota)","n/a",{"$f":"F52+F53+F55-(F54*0.12)","v":24085.676160000003},{"$f":"G52+G53+G55-(G54*0.12)","v":20390.278720000002},14492.98144,9014.9735199999996,{"$f":"J52+J53+J55-(J54*0.12)","v":4735.8001599999998}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F56:F57)","v":48255.352320000005},{"$f":"SUM(G56:G57)","v":40864.557440000004},29069.962879999999,18113.947039999999,9555.6003199999996]
[]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$17,Tablas!$A$1065:$H$1127,4,TRUE)","v":3347.5337500000005},{"$f":"VLOOKUP($J$17,Tablas!$A$1065:$H$1127,5,TRUE)","v":2897.5650000000005},{"$f":"VLOOKUP($J$17,Tablas!$A$1065:$H$1127,6,TRUE)","v":2044.8450000000003},{"$f":"VLOOKUP($J$17,Tablas!$A$1065:$H$1127,7,TRUE)","v":1273.9375},{"$f":"VLOOKUP($J$17,Tablas!$A$1065:$H$1127,8,TRUE)","v":683.25125000000003}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1065:$H$1127,4,TRUE)))","v":6923.2075000000004},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1065:$H$1127,5,TRUE)))","v":6097.8362500000003},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1065:$H$1127,6,TRUE)))","v":4318.2975000000006},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1065:$H$1127,7,TRUE)))","v":2652.3612499999999},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1065:$H$1127,8,TRUE)))","v":1333.0762500000001}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1128:$H$1130,4,TRUE)))","v":887.54875000000004},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1128:$H$1130,5,TRUE)))","v":450.90375},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1128:$H$1130,6,TRUE)))","v":351.09250000000003},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1128:$H$1130,7,TRUE)))","v":250.11250000000001},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1128:$H$1130,8,TRUE)))","v":177.65}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($D$22=FALSE,0,Tablas!D$1131)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!E$1131)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!F$1131)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!G$1131)","v":0},{"$f":"+IF($D$22=FALSE,0,Tablas!H$1131)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($D$23=FALSE,0,Tablas!D$1132)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!E$1132)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!F$1132)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!G$1132)","v":0},{"$f":"IF($D$23=FALSE,0,Tablas!H$1132)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($D$24=FALSE,0,Tablas!D$1133)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!E$1133)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!F$1133)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!G$1133)","v":0},{"$f":"IF($D$24=FALSE,0,Tablas!H$1133)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F62:F67)","v":11158.29},{"$f":"SUM(G62:G67)","v":9446.3050000000003},6714.2350000000006,4176.4112500000001,2193.9775]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G36>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F62+F63+F64)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G62+G63+G64)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H62+H63+H64)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I62+I63+I64)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J62+J63+J64)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F68+F69+F70)*12%","v":1347.9948000000002},{"$f":"+(G68+G69+G70)*12%","v":1142.5565999999999},814.70820000000003,510.16935000000001,{"$f":"+(J68+J69+J70)*12%","v":272.27729999999997}]
[null,null,null,"(1ra Cuota)","n/a",{"$f":"SUM(F68:F71)","v":12581.284800000001},{"$f":"SUM(G68:G71)","v":10663.8616},{"$f":"SUM(H68:H71)","v":7603.9432000000006},{"$f":"SUM(I68:I71)","v":4761.5806000000002},{"$f":"SUM(J68:J71)","v":2541.2547999999997}]
[null,null,null,"(2da a 4ta Cuota)","n/a",{"$f":"F68+F69+F71-(F70*0.12)","v":12497.284800000001},{"$f":"G68+G69+G71-(G70*0.12)","v":10579.8616},7519.9432000000006,4677.5806000000002,{"$f":"J68+J69+J71-(J70*0.12)","v":2457.2547999999997}]
[null,null,null,"TOTAL","n/a",{"$f":"F72+F73*3","v":50073.139200000005},{"$f":"G72+G73*3","v":42403.446400000001},30163.772800000002,18794.322400000001,9913.0191999999988]
[]
[]
[null,null,null,"Tarifas en US $ -   Efectivas partir del 1ro de enero de  2022"]
[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":"Blue 500","index":5,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":true,"merged":[[43,0,43,1],[34,2,34,3],[48,2,49,3],[48,0,49,1],[46,2,46,3],[47,2,47,3],[44,2,44,3],[46,0,46,1],[47,0,47,1],[44,0,44,1],[45,0,45,1],[45,2,45,3],[22,0,23,1],[24,0,24,1],[35,2,40,3],[33,0,33,1],[34,0,34,1],[35,0,42,1],[41,2,42,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[51,5,51,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[43,2,43,3],[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa Blue 500 Guatemala"]
[]
["Bupa Blue 500 Guatemala",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$14","v":"Nombre"}]
["Cobertura Máxima anual",null,"US$500,000"]
["Cobertura Geografica",null,"Cobertura mundial",null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$25","v":"Agente / Agencia"}]
["Condiciones médicas cubiertas",null,"Todas las condiciones médicas"]
["Redes de proveedores",null,"Red de Proveedores Alpha",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$18","v":65}]
["Opciones fuera de la Red",null,"30%/70%",null,null,"FECHA DE COTIZACION :"]
["Requiere preautorización",null,"SI, 30% de penalización por omitir prenotificación",null,null,{"$f":"NOW()","v":"2021-12-20T18:26:45"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":3},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":71}]
[null,null,null,null,null,null,null,null,null," "," "," "]
["Número máximo de días de hospitalización",null,"Ilimitado",null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
["Habitación y alimentación",null,"100% dentro de Red Bupa"]
[null,null,"70% fuera de la Red Bupa",null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
["Cuidados Intensivos",null,"100% dentro de Red Bupa"]
[null,null,"70% fuera de la Red Bupa",null,null,null," "]
["Cobertura de Maternidad",null,"$3,500 (Excepto planes 4,5, y 6)",null,null,"Deducibles",null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5"]
["Cobertura Provisional de Recién Nacido",null,"$10,000 por los primeros 90 días",null,null,"Dentro del pais de residencia",null,null,250,500,1000,2000,5000]
["Cuidado del Recién Nacido saludable",null,"2 visitas por año/ $50 vacunas",null,null,"Fuera del pais de residencia",null,null,500,1000,2000,4000,5000]
["Cobertura de Complicaciones de Maternidad",null,50000]
["Trasplante de Organos",null,250000]
["Condiciones congénitas y hereditarias",null,"<18 años $75,000 de por vida; >=18 al 100%",null,null,"Tarifas Anuales"]
["Coberturas opcionales (Riders)",null,"Complicaciones de Maternidad por $500,000",null,null,"Prima de Titular :",null,null,{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,4,TRUE)","v":5200},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,5,TRUE)","v":4523},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,6,TRUE)","v":4123},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,7,TRUE)","v":3767},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,8,TRUE)","v":2698}]
[null,null,"Trasplante de órganos por $ 500,000 de por vida",null,null,"Prima de Cónyuge",null,null,{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,4,TRUE)))","v":8611},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,5,TRUE)))","v":7489},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,6,TRUE)))","v":6830},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,7,TRUE)))","v":6376},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,8,TRUE)))","v":4532}]
["Acompañamiento de menores hospitalizados",null,"No incluye",null,null,"Primas Hijos :",null,null,{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,4,TRUE)))","v":1736},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,5,TRUE)))","v":1505},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,6,TRUE)))","v":1371},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,7,TRUE)))","v":703},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,8,TRUE)))","v":641}]
["Ambulancia aérea",null,25000,null,null,"Prima Rider Complic. Maternidad",null,null,{"$f":"+IF($I$20=FALSE,0,Tablas!D$699)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$699)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$699)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$699)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$699)","v":225}]
["Repatriación restos mortales",null,5000,null,null,"Prima Rider Trasplante Organos",null,null,{"$f":"IF($I$22=FALSE,0,Tablas!D$700)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$700)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$700)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$700)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$700)","v":300}]
["Medicamentos por receta",null,"Si son médicamente prescritos tras una hospitalización o en relación con una cirugía ambulatoria entonces $7,000 por los próximos 6 meses.",null,null,"TOTAL PRIMA NETA :",null,null,{"$f":"SUM(I31:I35)","v":16072},14042,12849,11371,8396]
[null,null,null,null,null,"Costo Administrativo Anual :",null,null,75,75,75,75,75]
[null,null,null,null,null,"IVA (12%)",null,null,{"$f":"I36*0.12","v":1928.6399999999999},{"$f":"J36*0.12","v":1685.04},1541.8799999999999,1364.52,1007.52]
[null,null,null,null,null,"GRAN TOTAL :",null,null,{"$f":"SUM(I36:I38)","v":18075.64},{"$f":"SUM(J36:J38)","v":15802.04},14465.88,12810.52,9478.52]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,"Medicamentos por receta ambulatoria $1,500",null,null,"Prima de Titular :",null,null,{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,4,TRUE)","v":2756},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,5,TRUE)","v":2397.19},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,6,TRUE)","v":2185.19},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,7,TRUE)","v":1996.51},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,8,TRUE)","v":1429.94}]
[null,null,null,null,null,"Prima de Cónyuge",null,null,{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,4,TRUE)))","v":4563.83},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,5,TRUE)))","v":3969.17},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,6,TRUE)))","v":3619.9},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,7,TRUE)))","v":3379.28},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,8,TRUE)))","v":2401.96}]
["Atención médica en el hogar",null,"$200 por día, hasta 60 días por año por incidente",null,null,"Primas Hijos :",null,null,{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,4,TRUE)))","v":920.08},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,5,TRUE)))","v":797.65000000000009},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,6,TRUE)))","v":726.63},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,7,TRUE)))","v":372.59000000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,8,TRUE)))","v":339.73}]
["Rehabilitación",null,"100% de UCR hasta 40 sesiones por año",null,null,"Prima Rider Complic. Maternidad",null,null,{"$f":"+IF($I$20=FALSE,0,Tablas!D$771)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$771)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$771)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$771)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$771)","v":119.25}]
["Residencia y cuidados paliativos",null,"100% de usual/acostumbrado y razonable",null,null,"Prima Rider Trasplante Organos",null,null,{"$f":"IF($I$22=FALSE,0,Tablas!D$772)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$772)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$772)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$772)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$772)","v":159}]
["Cobertura de actividades peligrosas",null,"100% siempre que no sea práctica profesional",null,null,"TOTAL PRIMA NETA :",null,null,{"$f":"SUM(I42:I46)","v":8518.16},7442.26,6809.97,6026.63,4449.88]
["Cobertura de brazos y piernas artificiales",null,"$30,000 por año y hasta $120,000 de por vida",null,null,"Costo Administrativo Anual :",null,null,75,75,75,75,75]
["Cobertura extendida para dependientes en caso de muerte de asegurado principal",null,"n/a",null,null,"IVA (12%)",null,null,{"$f":"I47*0.12","v":1022.1791999999999},{"$f":"J47*0.12","v":893.07119999999998},817.19640000000004,723.19560000000001,533.98559999999998]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,null,{"$f":"SUM(I47:I49)","v":9615.3392000000003},{"$f":"SUM(J47:J49)","v":8410.3312000000005},7702.1664000000001,6824.8256000000001,5058.8656000000001]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,null,{"$f":"I47+I49","v":9540.3392000000003},{"$f":"J47+J49","v":8335.3312000000005},7627.1664000000001,6749.8256000000001,4983.8656000000001]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2014"]
[null," "]

{"sheet":"Blue 100","index":6,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":true,"merged":[[47,0,47,1],[47,2,47,3],[48,0,49,1],[48,2,49,3],[51,5,51,12],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[46,0,46,1],[46,2,46,3],[43,0,43,1],[43,2,43,3],[30,0,31,1],[30,2,30,3],[31,2,31,3],[32,0,32,1],[32,2,32,3],[33,0,33,1],[33,2,33,3],[34,0,34,1],[34,2,34,3],[35,0,42,1],[35,2,40,3],[41,2,42,3],[27,0,27,1],[27,2,27,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[24,0,24,1],[24,2,24,3],[25,0,25,1],[25,2,25,3],[26,0,26,1],[26,2,26,3],[20,0,21,1],[20,2,20,3],[21,2,21,3],[22,0,23,1],[22,2,22,3],[23,2,23,3],[16,5,16,6],[17,0,18,1],[17,2,18,3],[17,5,17,6],[19,0,19,1],[19,2,19,3],[14,0,14,1],[14,2,14,3],[15,0,15,1],[15,2,15,3],[16,0,16,1],[16,2,16,3],[13,0,13,1],[13,2,13,3],[13,7,13,12],[9,0,9,12],[11,0,11,3],[11,7,11,12],[12,0,12,1],[12,2,12,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa Blue 100 Guatemala"]
[]
["Bupa Blue 100 Guatemala",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$14","v":"Nombre"}]
["Cobertura Máxima anual",null,"US$100,000"]
["Cobertura Geografica",null,"Cobertura mundial",null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$25","v":"Agente / Agencia"}]
["Condiciones médicas cubiertas",null,"Todas las condiciones médicas"]
["Redes de proveedores",null,"Red de Proveedores Alpha",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$18","v":65}]
["Opciones fuera de la Red",null,"30%/70%",null,null,"FECHA DE COTIZACION :"]
["Requiere preautorización",null,"Sí, 30% de penalización por omitir prenotificación",null,null,{"$f":"NOW()","v":"2021-12-20T18:26:45"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":3},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":71}]
[null,null,null,null,null,null,null,null,null," "," "," "]
["Número máximo de días de hospitalización",null,"Ilimitado",null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
["Habitación y alimentación",null,"100% dentro de Red Bupa"]
[null,null,"70% fuera de la Red Bupa",null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
["Cuidados Intensivos",null,"100% dentro de Red Bupa"]
[null,null,"70% fuera de la Red Bupa",null,null,null," "]
["Cobertura de Maternidad",null,"$3,500 (Excepto planes 4,5, y 6)",null,null,"Deducibles",null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5"]
["Cobertura Provisional de Recién Nacido",null,"$7,500 por los primeros 90 días",null,null,"Dentro del pais de residencia",null,null,250,500,1000,2000,5000]
["Cuidado del Recién Nacido saludable",null,"2 visitas por año. $50 vacunas",null,null,"Fuera del pais de residencia",null,null,500,1000,2000,4000,5000]
["Cobertura de Complicaciones de Maternidad",null,25000]
["Trasplante de Organos",null,100000]
["Condiciones congénitas y hereditarias",null,"<18 años $50,000 de por vida; >=18 al 100%",null,null,"Tarifas Anuales"]
["Coberturas opcionales (Riders)",null,"Complicaciones de Maternidad por $500,000",null,null,"Prima de Titular :",null,null,{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,4,TRUE)","v":4179},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,5,TRUE)","v":4095},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,6,TRUE)","v":3860},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,7,TRUE)","v":3519},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,8,TRUE)","v":3213}]
[null,null,"Trasplante de órganos por $ 500,000 de por vida",null,null,"Prima de Cónyuge",null,null,{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$778:$H$840,4,TRUE)))","v":6920},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$778:$H$840,5,TRUE)))","v":6781},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$656,6,TRUE)))","v":1719},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$778:$H$840,7,TRUE)))","v":5826},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$778:$H$840,8,TRUE)))","v":5441}]
["Acompañamiento de menores hospitalizados",null,"n/a",null,null,"Primas Hijos :",null,null,{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,4,TRUE)))","v":1393},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,5,TRUE)))","v":1364},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,6,TRUE)))","v":1285},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,7,TRUE)))","v":1173},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,8,TRUE)))","v":597}]
["Ambulancia aérea",null,"$10,000 por año y ticket aéreo de retorno ",null,null,"Prima Rider Complic. Maternidad",null,null,{"$f":"+IF($I$20=FALSE,0,Tablas!D$844)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$844)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$844)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$844)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$844)","v":225}]
["Repatriación restos mortales",null,5000,null,null,"Prima Rider Trasplante Organos",null,null,{"$f":"IF($I$22=FALSE,0,Tablas!D$845)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$845)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$845)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$845)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$845)","v":300}]
["Medicamentos por receta",null,"Si son médicamente prescritos tras una hospitalización o en relación con una cirugía ambulatoria entonces $6,000 por los próximos 6 meses.",null,null,"TOTAL PRIMA NETA :",null,null,{"$f":"SUM(I31:I35)","v":13017},12765,7389,11043,9776]
[null,null,null,null,null,"Costo Administrativo Anual :",null,null,75,75,75,75,75]
[null,null,null,null,null,"IVA (12%)",null,null,{"$f":"I36*0.12","v":1562.04},{"$f":"J36*0.12","v":1531.8},886.68,1325.1599999999999,1173.1199999999999]
[null,null,null,null,null,"GRAN TOTAL :",null,null,{"$f":"SUM(I36:I38)","v":14654.04},{"$f":"SUM(J36:J38)","v":14371.8},8350.68,12443.16,11024.119999999999]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,"Tratamiento Ambulatorio a US$1,500",null,null,"Prima de Titular :",null,null,{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,4,TRUE)","v":2214.87},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,5,TRUE)","v":2170.35},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,6,TRUE)","v":2045.8000000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,7,TRUE)","v":1865.0700000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,8,TRUE)","v":1702.89}]
[null,null,null,null,null,"Prima de Cónyuge",null,null,{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,4,TRUE)))","v":3667.6000000000004},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,5,TRUE)))","v":3593.9300000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,6,TRUE)))","v":3387.23},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,7,TRUE)))","v":3087.78},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,8,TRUE)))","v":2883.73}]
["Atención médica en el hogar",null,"$200 por día, hasta 60 días por año por incidente",null,null,"Primas Hijos :",null,null,{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,4,TRUE)))","v":738.29000000000008},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,5,TRUE)))","v":722.92000000000007},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,6,TRUE)))","v":681.05000000000007},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,7,TRUE)))","v":621.69000000000005},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,8,TRUE)))","v":316.41000000000003}]
["Rehabilitación",null,"100% de UCR hasta 30 sesiones por año",null,null,"Prima Rider Complic. Maternidad",null,null,{"$f":"+IF($I$20=FALSE,0,Tablas!D$916)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$916)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$916)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$916)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$916)","v":119.25}]
["Residencia y cuidados paliativos",null,"100% de usual/acostumbrado y razonable",null,null,"Prima Rider Trasplante Organos",null,null,{"$f":"IF($I$22=FALSE,0,Tablas!D$917)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$917)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$917)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$917)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$917)","v":159}]
["Cobertura de actividades peligrosas",null,"100% siempre que no sea práctica profesional",null,null,"TOTAL PRIMA NETA :",null,null,{"$f":"SUM(I42:I46)","v":6899.01},6765.4500000000007,6392.3300000000008,5852.7900000000009,5181.28]
["Cobertura de brazos y piernas artificiales",null,"$30,000 por año y hasta $120,000 de por vida",null,null,"Costo Administrativo Anual :",null,null,75,75,75,75,75]
["Cobertura extendida para dependientes en caso de muerte de asegurado principal",null,"n/a",null,null,"IVA (12%)",null,null,{"$f":"I47*0.12","v":827.88120000000004},{"$f":"J47*0.12","v":811.85400000000004},767.07960000000003,702.33480000000009,621.75359999999989]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,null,{"$f":"SUM(I47:I49)","v":7801.8912},{"$f":"SUM(J47:J49)","v":7652.304000000001},7234.4096000000009,6630.1248000000014,5878.0335999999998]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,null,{"$f":"I47+I49","v":7726.8912},{"$f":"J47+J49","v":7577.304000000001},7159.4096000000009,6555.1248000000014,5803.0335999999998]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2014"]
[null," "]

{"sheet":"Essential Care","index":7,"n_rows":83,"n_cols":11,"rows_kept":83,"cut":false,"hidden":false,"merged":[[70,0,70,1],[71,0,71,1],[30,0,30,1],[30,3,30,9],[43,3,43,9],[55,0,55,1],[36,0,36,1],[41,0,41,1],[10,0,10,1],[16,0,16,1],[22,0,22,1],[9,0,9,1],[69,0,69,1],[8,3,8,9],[7,3,7,9],[80,3,80,9],[81,3,81,9],[82,3,82,9],[10,4,10,9],[12,4,12,9],[76,3,78,9],[59,3,59,9],[75,3,75,9],[25,3,25,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":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$25","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-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$16","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$18","v":65}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$18","v":71}]
[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,false]
[null,null,null,null,null,false,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$274:$H$336,3,TRUE)","v":7885},{"$f":"VLOOKUP($J$17,Tablas!$A$274:$H$336,4,TRUE)","v":7583},{"$f":"VLOOKUP($J$17,Tablas!$A$274:$H$336,5,TRUE)","v":7030},{"$f":"VLOOKUP($J$17,Tablas!$A$274:$H$336,6,TRUE)","v":4977},{"$f":"VLOOKUP($J$17,Tablas!$A$274:$H$336,7,TRUE)","v":3187},{"$f":"VLOOKUP($J$17,Tablas!$A$274:$H$336,8,TRUE)","v":1709}]
[null,null,null,"Prima Cónyuge",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,3,TRUE)))","v":16653},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,4,TRUE)))","v":16015},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,5,TRUE)))","v":14846},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,6,TRUE)))","v":10511},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,7,TRUE)))","v":6635},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,8,TRUE)))","v":3335}]
[null,null,null,"Primas Hijos",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,3,TRUE)))","v":1354},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,4,TRUE)))","v":1302},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,5,TRUE)))","v":1207},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,6,TRUE)))","v":855},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,7,TRUE)))","v":713},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,8,TRUE)))","v":562}]
[null,null,null,"Anexo: Complicaciones de Maternidad",{"$f":"+IF($F$22=FALSE,0,Tablas!C$340)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!D$340)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!E$340)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!F$340)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!G$340)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!H$340)","v":0}]
[null,null,null,"Anexo: Trasplante Organos",{"$f":"IF($F$23=FALSE,0,Tablas!C$341)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!D$341)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!E$341)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!F$341)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!G$341)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!H$341)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible",{"$f":"IF($F$24=FALSE,0,Tablas!C$342)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!D$342)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$342)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$342)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$342)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$342)","v":0}]
[null,null,null,"PRIMA NETA",{"$f":"SUM(E32:E37)","v":25892},24900,23083,16343,10535,5606]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(E32+E33+E34)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F32+F33+F34)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G32+G33+G34)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H32+H33+H34)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I32+I33+I34)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J32+J33+J34)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",75,75,75,75,75,75]
[null,null,null,"IVA (12%)",{"$f":"+(E38+E39+E40)*12%","v":3116.04},{"$f":"+(F38+F39+F40)*12%","v":2997},{"$f":"+(G38+G39+G40)*12%","v":2778.96},1970.1599999999999,1273.2,{"$f":"+(J38+J39+J40)*12%","v":681.72}]
[null,null,null,"TOTAL",{"$f":"SUM(E38:E41)","v":29083.040000000001},27972,25936.959999999999,18388.16,11883.2,6362.72]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular",{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,3,TRUE)","v":4179.05},{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,4,TRUE)","v":4018.9900000000002},{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,5,TRUE)","v":3725.9},{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,6,TRUE)","v":2637.81},{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,7,TRUE)","v":1689.1100000000001},{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,8,TRUE)","v":905.7700000000001}]
[null,null,null,"Prima Cónyuge",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,3,TRUE)))","v":8826.09},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,4,TRUE)))","v":8487.9500000000007},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,5,TRUE)))","v":7868.38},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,6,TRUE)))","v":5570.83},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,7,TRUE)))","v":3516.55},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,8,TRUE)))","v":1767.5500000000002}]
[null,null,null,"Primas Hijos",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,3,TRUE)))","v":717.62},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,4,TRUE)))","v":690.06000000000006},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,5,TRUE)))","v":639.71},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,6,TRUE)))","v":453.15000000000003},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,7,TRUE)))","v":377.89000000000004},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,8,TRUE)))","v":297.86}]
[null,null,null,"Anexo: Complicaciones de Maternidad",{"$f":"+IF($F$22=FALSE,0,Tablas!C$412)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!D$412)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!E$412)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!F$412)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!G$412)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!H$412)","v":0}]
[null,null,null,"Anexo: Trasplante Organos",{"$f":"IF($F$23=FALSE,0,Tablas!C$413)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!D$413)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!E$413)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!F$413)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!G$413)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!H$413)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible",{"$f":"IF($F$24=FALSE,0,Tablas!C$414)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!D$414)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$414)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$414)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$414)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$414)","v":0}]
[null,null,null,"PRIMA NETA",{"$f":"SUM(E45:E50)","v":13722.76},{"$f":"SUM(F45:F50)","v":13197},{"$f":"SUM(G45:G50)","v":12233.990000000002},8661.7899999999991,5583.55,2971.1800000000003]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(E45+E46+E47)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F45+F46+F47)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G45+G46+G47)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H45+H46+H47)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I45+I46+I47)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J45+J46+J47)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",75,75,75,75,75,75]
[null,null,null,"IVA (12%)",{"$f":"+(E51+E52+E53)*12%","v":1655.7311999999999},{"$f":"+(F51+F52+F53)*12%","v":1592.6399999999999},{"$f":"+(G51+G52+G53)*12%","v":1477.0788000000002},{"$f":"+(H51+H52+H53)*12%","v":1048.4147999999998},{"$f":"+(I51+I52+I53)*12%","v":679.02599999999995},{"$f":"+(J51+J52+J53)*12%","v":365.54160000000002}]
[null,null,null,"(1ra Cuota)",{"$f":"SUM(E51:E54)","v":15453.4912},14864.64,13786.068800000001,9785.2047999999995,6337.576,3411.7216000000003]
[null,null,null,"(2da Cuota)",{"$f":"E51+E52+E54-(E53*0.12)","v":15369.4912},{"$f":"F51+F52+F54-(F53*0.12)","v":14780.64},{"$f":"G51+G52+G54-(G53*0.12)","v":13702.068800000001},9701.2047999999995,6253.576,3327.7216000000003]
[null,null,null,"TOTAL",{"$f":"SUM(E55:E56)","v":30822.982400000001},{"$f":"SUM(F55:F56)","v":29645.279999999999},27488.137600000002,19486.409599999999,12591.152,6739.4432000000006]
[]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular",{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,3,TRUE)","v":2168.375},{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,4,TRUE)","v":2085.3250000000003},{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,5,TRUE)","v":1933.2500000000002},{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,6,TRUE)","v":1368.6750000000002},{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,7,TRUE)","v":876.42500000000007},{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,8,TRUE)","v":469.97500000000002}]
[null,null,null,"Prima Cónyuge",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,3,TRUE)))","v":4579.5750000000007},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,4,TRUE)))","v":4404.125},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,5,TRUE)))","v":4082.6500000000005},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,6,TRUE)))","v":2890.5250000000001},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,7,TRUE)))","v":1824.6250000000002},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,8,TRUE)))","v":917.12500000000011}]
[null,null,null,"Primas Hijos",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,3,TRUE)))","v":372.35},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,4,TRUE)))","v":358.05},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,5,TRUE)))","v":331.92500000000001},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,6,TRUE)))","v":235.12500000000003},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,7,TRUE)))","v":196.07500000000002},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,8,TRUE)))","v":154.55000000000001}]
[null,null,null,"Anexo: Complicaciones de Maternidad",{"$f":"+IF($F$22=FALSE,0,Tablas!C$1057)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!D$1057)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!E$1057)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!F$1057)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!G$1057)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!H$1057)","v":0}]
[null,null,null,"Anexo: Trasplante Organos",{"$f":"IF($F$23=FALSE,0,Tablas!C$1058)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!D$1058)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!E$1058)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!F$1058)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!G$1058)","v":0},{"$f":"IF($F$23=FALSE,0,Tablas!H$1058)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible",{"$f":"IF($F$24=FALSE,0,Tablas!C$1059)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!D$1059)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$1059)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$1059)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$1059)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$1059)","v":0}]
[null,null,null,"PRIMA NETA",{"$f":"SUM(E61:E66)","v":7120.3000000000011},{"$f":"SUM(F61:F66)","v":6847.5000000000009},{"$f":"SUM(G61:G66)","v":6347.8250000000007},4494.3250000000007,2897.125,1541.65]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G36>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(E61+E62+E63)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(F61+F62+F63)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(G61+G62+G63)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(H61+H62+H63)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(I61+I62+I63)*'INGRESO DE DATOS'!$G$20,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$20>0,-(J61+J62+J63)*'INGRESO DE DATOS'!$G$20,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",75,75,75,75,75,75]
[null,null,null,"IVA (12%)",{"$f":"+(E67+E68+E69)*12%","v":863.43600000000015},{"$f":"+(F67+F68+F69)*12%","v":830.7},{"$f":"+(G67+G68+G69)*12%","v":770.73900000000003},548.31900000000007,356.65499999999997,{"$f":"+(J67+J68+J69)*12%","v":193.99799999999999}]
[null,null,null,"(1ra Cuota)",{"$f":"SUM(E67:E70)","v":8058.7360000000008},7753.2000000000007,7193.5640000000003,5117.6440000000011,3328.7799999999997,1810.6480000000001]
[null,null,null,"(2da a 4ta Cuota)",{"$f":"E67+E68+E70-(E69*0.12)","v":7974.7360000000008},{"$f":"F67+F68+F70-(F69*0.12)","v":7669.2000000000007},{"$f":"G67+G68+G70-(G69*0.12)","v":7109.5640000000003},5033.6440000000011,3244.7799999999997,1726.6480000000001]
[null,null,null,"TOTAL",{"$f":"E71+E72*3","v":31982.944000000003},{"$f":"F71+F72*3","v":30760.800000000003},28522.256000000001,20218.576000000005,13063.119999999999,6990.5920000000006]
[]
[]
[null,null,null,"Tarifas en US $ -   Efectivas partir del 1ro de enero de  2022"]
[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":"Resumen tarifas anuales","index":8,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[[66,2,66,8],[67,2,67,8],[68,2,68,8],[22,2,22,8],[62,2,62,8],[26,2,26,8],[27,2,28,2],[23,2,23,3],[31,2,31,8],[47,2,47,8],[51,2,51,8],[52,1,53,1],[56,2,56,8],[57,1,58,1],[0,0,0,8],[63,2,64,8],[32,2,33,2],[6,3,6,8],[8,3,8,8],[14,1,14,2],[13,1,13,2],[16,3,16,8],[48,1,48,2],[37,2,37,8],[38,2,39,8]]}
["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$14","v":"Nombre"}]
[]
[null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$25","v":"Agente / Agencia"}]
[]
[null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-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,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$18","v":65}]
[]
[null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$18","v":71}]
[null,null,null,null,null," "," "," "]
[null,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!F43","v":45528.671999999999},{"$f":"+Classic!G43","v":38556.224000000002},{"$f":"+Classic!H43","v":27429.248},{"$f":"+Classic!I43","v":17093.383999999998},{"$f":"+Classic!J43","v":9019.4719999999998}]
[]
[]
[null,null,"TARIFAS SEMIANUALES"]
[null,null,"Classic Care","1ra. Cuota",{"$f":"+Classic!$F$56","v":24169.676160000003},{"$f":"+Classic!$G$56","v":20474.278720000002},{"$f":"+Classic!$H$56","v":14576.98144},{"$f":"+Classic!$I$56","v":9098.9735199999996},{"$f":"+Classic!$J$56","v":4819.8001599999998}]
[null,null,null,"2da. Cuota",{"$f":"+Classic!$F$57","v":24085.676160000003},{"$f":"+Classic!$G$57","v":20390.278720000002},{"$f":"+Classic!$H$57","v":14492.98144},{"$f":"+Classic!$I$57","v":9014.9735199999996},{"$f":"+Classic!$J$57","v":4735.8001599999998}]
[null,null,null,"TOTAL",{"$f":"Classic!F58","v":48255.352320000005},{"$f":"Classic!G58","v":40864.557440000004},{"$f":"Classic!H58","v":29069.962879999999},{"$f":"Classic!I58","v":18113.947039999999},{"$f":"Classic!J58","v":9555.6003199999996}]
[]
[null,null,"TARIFAS TRIMESTRALES"]
[null,null,"Classic Care","1ra. Cuota",{"$f":"+Classic!$F$72","v":12581.284800000001},{"$f":"+Classic!$G$72","v":10663.8616},{"$f":"+Classic!$H$72","v":7603.9432000000006},{"$f":"+Classic!$I$72","v":4761.5806000000002},{"$f":"+Classic!$J$72","v":2541.2547999999997}]
[null,null,null,"2da. a 4ta. Cuota",{"$f":"+Classic!$F$73","v":12497.284800000001},{"$f":"+Classic!$G$73","v":10579.8616},{"$f":"+Classic!$H$73","v":7519.9432000000006},{"$f":"+Classic!$I$73","v":4677.5806000000002},{"$f":"+Classic!$J$73","v":2457.2547999999997}]
[null,null,null,"TOTAL",{"$f":"Classic!F74","v":50073.139200000005},{"$f":"Classic!G74","v":42403.446400000001},{"$f":"Classic!H74","v":30163.772800000002},{"$f":"Classic!I74","v":18794.322400000001},{"$f":"Classic!J74","v":9913.0191999999988}]
[]
[]
[null,null,"Tarifas en US $ -  Efectivas a partir del 1ro de enero de  2021"]
[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,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,"Dentro del pais de residencia",null,250,250,1000,5000,10000,20000]
[null,"Fuera del pais de residencia",null,1000,5000,10000,5000,10000,20000]
[]
[]
[null,null,"TARIFAS ANUALES"]
[null,"Essential Care",null,{"$f":"'Essential Care'!E42","v":29083.040000000001},{"$f":"'Essential Care'!F42","v":27972},{"$f":"'Essential Care'!G42","v":25936.959999999999},{"$f":"'Essential Care'!H42","v":18388.16},{"$f":"'Essential Care'!I42","v":11883.2},{"$f":"'Essential Care'!J42","v":6362.72}]
[]
[]
[null,null,"TARIFAS SEMIANUALES"]
[null,"Essential Care","1ra. Cuota",{"$f":"'Essential Care'!E55","v":15453.4912},{"$f":"'Essential Care'!F55","v":14864.64},{"$f":"'Essential Care'!G55","v":13786.068800000001},{"$f":"'Essential Care'!H55","v":9785.2047999999995},{"$f":"'Essential Care'!I55","v":6337.576},{"$f":"'Essential Care'!J55","v":3411.7216000000003}]
[null,null,"2da. Cuota",{"$f":"'Essential Care'!E56","v":15369.4912},{"$f":"'Essential Care'!F56","v":14780.64},{"$f":"'Essential Care'!G56","v":13702.068800000001},{"$f":"'Essential Care'!H56","v":9701.2047999999995},{"$f":"'Essential Care'!I56","v":6253.576},{"$f":"'Essential Care'!J56","v":3327.7216000000003}]
[null,null,"TOTAL",{"$f":"'Essential Care'!E57","v":30822.982400000001},{"$f":"'Essential Care'!F57","v":29645.279999999999},{"$f":"'Essential Care'!G57","v":27488.137600000002},{"$f":"'Essential Care'!H57","v":19486.409599999999},{"$f":"'Essential Care'!I57","v":12591.152},{"$f":"'Essential Care'!J57","v":6739.4432000000006}]
[]
[null,null,"TARIFAS TRIMESTRALES"]
[null,"Essential Care","1ra. Cuota",{"$f":"'Essential Care'!E71","v":8058.7360000000008},{"$f":"'Essential Care'!F71","v":7753.2000000000007},{"$f":"'Essential Care'!G71","v":7193.5640000000003},{"$f":"'Essential Care'!H71","v":5117.6440000000011},{"$f":"'Essential Care'!I71","v":3328.7799999999997},{"$f":"'Essential Care'!J71","v":1810.6480000000001}]
[null,null,"2da. a 4ta. Cuota",{"$f":"'Essential Care'!E72","v":7974.7360000000008},{"$f":"'Essential Care'!F72","v":7669.2000000000007},{"$f":"'Essential Care'!G72","v":7109.5640000000003},{"$f":"'Essential Care'!H72","v":5033.6440000000011},{"$f":"'Essential Care'!I72","v":3244.7799999999997},{"$f":"'Essential Care'!J72","v":1726.6480000000001}]
[null,null,"TOTAL",{"$f":"'Essential Care'!E73","v":31982.944000000003},{"$f":"'Essential Care'!F73","v":30760.800000000003},{"$f":"'Essential Care'!G73","v":28522.256000000001},{"$f":"'Essential Care'!H73","v":20218.576000000005},{"$f":"'Essential Care'!I73","v":13063.119999999999},{"$f":"'Essential Care'!J73","v":6990.5920000000006}]
[]
[]
[null,null,"Tarifas en US $ -  Efectivas a partir del 22 de julio de  2022"]
[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":9,"n_rows":1133,"n_cols":24,"rows_kept":1133,"cut":false,"hidden":true,"merged":[[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,"OK","FACTOR TRIMESTRAL :",null,0.27500000000000002]
["EDAD"]
[" "," ","DW1","DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",12140,7386,5058,3643,2581,1973,null,"Descuento (15%)",null,0.85]
[25,"-  29",12747,7738,5616,4048,2833,2176]
[30,"-  34",13305,8094,6019,4504,3442,2633]
[35,"-  39",14871,9056,6728,5058,3846,2936]
[40,"-  44",16844,10520,7386,5616,4250,3238]
[45,"-  49",18817,11736,8246,6272,4756,3643]
[50,"-  54",24836,15326,10876,8246,6780,5213]
[55,"-  59",26403,16337,11583,8801,7233,5514]
[60,null,28022,17754,12596,10015,8600,6929]
[61,null,30096,19068,13507,10724,9258,7437]
[62,null,32928,20889,14771,11736,10115,8143]
[63,null,35003,22205,15730,12495,10775,8649]
[64,null,37886,24026,16996,13507,11635,9359]
[65,null,39704,31412,22205,17097,15529,13201]
[66,null,41475,36519,25797,19878,18059,15326]
[67,null,45320,39858,28174,21698,19727,16743]
[68,null,50125,44156,31207,24026,21851,18564]
[69,null,55130,48558,34294,26454,24026,20383]
[70,null,65249,59785,41778,31106,27971,23975]
[71,null,67829,62112,43400,32322,29085,24937]
[72,null,69750,63882,44662,33232,29893,25645]
[73,null,72279,66209,46282,34447,31005,26606]
[74,null,73593,67424,47091,35104,31562,27061]
[75,"o más",76781,70357,49163,36619,32928,28224]
[1,"Hijo",2270,4097,1872,1469,1266,911]
[2,"Hijos",3566,6424,2985,2329,1973,1469]
[3,"Hijos o más",5193,9359,4351,3442,2883,2127]
[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",4135.59,3251.55,2226.5300000000002,1603.78,1135.79,868.1400000000001]
[25,"-  29",4342.29,3406.84,2472.4500000000003,1781.8600000000001,1247.0900000000001,957.71]
[30,"-  34",4532.0300000000007,3563.19,2650,1982.73,1514.74,1158.5800000000002]
[35,"-  39",5066.2700000000004,3986.6600000000003,2961.6400000000003,2226.5300000000002,1692.8200000000002,1292.1400000000001]
[40,"-  44",5738.31,4631.67,3251.55,2472.4500000000003,1870.3700000000001,1425.17]
[45,"-  49",6410.35,5166.97,3629.9700000000003,2761.3,2093.5,1603.78]
[50,"-  54",8460.92,6747.43,4788.0200000000004,3629.9700000000003,2984.4300000000003,2294.37]
[55,"-  59",8994.630000000001,7192.63,5099.66,3874.8300000000004,3184.2400000000002,2427.4]
[60,null,9546.36,7816.4400000000005,5545.39,4409.0700000000006,3785.79,3050.6800000000003]
[61,null,10252.85,8395.2000000000007,5946.6,4721.2400000000007,4075.7000000000003,3273.81]
[62,null,11217.980000000001,9197.09,6503.1,5166.97,4453.0600000000004,3584.92]
[63,null,11924.470000000001,9775.85,6925.51,5500.87,4743.5,3808.05]
[64,null,12906.560000000001,10577.74,7482.54,5946.6,5122.45,4120.22]
[65,null,13526.66,13829.820000000002,9775.85,7527.06,6837,5811.9800000000005]
[66,null,14129.800000000001,16078.61,11357.37,8751.8900000000012,7950.5300000000007,6747.43]
[67,null,15439.43,17548.830000000002,12404.12,9553.25,8685.11,7371.2400000000007]
[68,null,17076.600000000002,19440.93,13739.720000000001,10577.74,9620.5600000000013,8173.13]
[69,null,18782.14,21379.14,15098.640000000001,11646.75,10577.74,8973.9600000000009]
[70,null,22228.73,26322.45,18394.18,13695.2,12315.08,10555.480000000001]
[71,null,23107.47,27346.940000000002,19108.09,14230.5,12805.33,10978.95]
[72,null,23762.550000000003,28126.57,19663.530000000002,14631.18,13160.960000000001,11290.59]
[73,null,24623.800000000003,29150.530000000002,20376.91,15165.95,13651.210000000001,11713.53]
[74,null,25071.65,29685.83,20733.07,15455.33,13896.070000000002,11914.400000000001]
[75,"o más",26157.620000000003,30976.91,21645.73,16122.6,14497.62,12426.380000000001]
[1,"Hijo",1395.49,1135.79,824.15000000000009,646.07000000000005,557.03,400.68]
[2,"Hijos",2188.37,1803.0600000000002,1313.8700000000001,1025.02,868.1400000000001,646.07000000000005]
[3,"Hijos o más",3187.9500000000003,2627.21,1915.42,1514.74,1268.8200000000002,935.98]
[1,"Rider Comp. Maternidad",{"$f":"+C33*$L$2","v":0},0,0,119.25,119.25,119.25]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["DIAMOND (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","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",null,null,null,null,null,null,null,"OK"]
[" "," ","CW1","CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",4209,3551,2780,2126,1854,1389]
[25,"-  29",4670,3900,3127,2393,2047,1545]
[30,"-  34",5368,4479,3668,2780,2393,1816]
[35,"-  39",5945,4943,4131,3090,2664,2006]
[40,"-  44",6718,5520,4711,3477,3012,2279]
[45,"-  49",7798,6371,5520,4054,3514,2626]
[50,"-  54",8531,6951,6062,4441,3823,2896]
[55,"-  59",10038,8184,7256,5251,4556,3399]
[60,null,10617,8571,7760,5560,4827,3591]
[61,null,11929,9652,8725,6294,5406,4054]
[62,null,13280,10731,9690,6989,6024,4517]
[63,null,14592,11776,10655,7683,6641,4980]
[64,null,15943,12855,11658,8377,7256,5444]
[65,null,15984,12894,11735,8455,7298,5444]
[66,null,16059,12894,11852,8493,7335,5444]
[67,null,17833,14321,13202,9420,8145,6062]
[68,null,19611,15749,14514,10384,8957,6681]
[69,null,20538,16483,15172,10849,9381,6989]
[70,null,20653,16522,15404,10965,9457,7026]
[71,null,23277,18570,17373,12353,10655,7916]
[72,null,25865,20653,19303,13703,11813,8801]
[73,null,28451,22739,21231,15095,13009,9690]
[74,null,31036,24784,23162,16483,14205,10579]
[75,"o más",33893,27023,25402,18027,15519,11544]
[1,"Hijo",1892,1698,1005,850,734,542]
[2,"Hijos",3127,2896,1508,1352,1159,850]
[3,"Hijos o más",4556,4246,2163,1969,1698,1275]
[1,"Rider Comp. Maternidad",0,225,225,225,225,225]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES ",null,null,null,null,null,null,null,"PENDIENTE"]
["EDAD"]
[" "," ","CW1","CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",1408.21,1562.97,1223.77,935.45,816.2,611.09]
[25,"-  29",1562.97,1716.67,1376.41,1053.1100000000001,901,679.99]
[30,"-  34",1795.64,1971.6000000000001,1614.38,1223.77,1053.1100000000001,799.24]
[35,"-  39",1989.0900000000001,2175.65,1818.43,1359.98,1172.8900000000001,882.98]
[40,"-  44",2247.73,2430.0500000000002,2073.8900000000003,1530.1100000000001,1325.53,1002.7600000000001]
[45,"-  49",2609.19,2804.76,2430.0500000000002,1784.51,1546.5400000000002,1155.93]
[50,"-  54",2854.58,3059.69,2668.55,1954.64,1682.75,1274.6500000000001]
[55,"-  59",3358.61,3602.94,3194.31,2311.33,2005.5200000000002,1496.19]
[60,null,3552.59,3773.07,3415.8500000000004,2447.54,2124.77,1580.99]
[61,null,3991.4300000000003,4249.01,3840.9100000000003,2770.84,2379.7000000000003,1784.51]
[62,null,4443.5200000000004,4724.42,4265.97,3076.65,2651.59,1988.5600000000002]
[63,null,4882.8900000000003,5184.46,4691.0300000000007,3382.46,2923.48,2192.08]
[64,null,5334.9800000000005,5659.34,5132.5200000000004,3687.7400000000002,3194.31,2396.6600000000003]
[65,null,5348.2300000000005,5676.83,5166.4400000000005,3722.19,3212.86,2396.6600000000003]
[66,null,5373.67,5676.83,5217.8500000000004,3739.15,3229.29,2396.6600000000003]
[67,null,5967.8,6304.88,5812.51,4147.25,3585.98,2668.55]
[68,null,6562.46,6933.9900000000007,6390.21,4571.7800000000007,3943.2000000000003,2940.9700000000003]
[69,null,6872.51,7256.76,6679.59,4776.3600000000006,4129.76,3076.65]
[70,null,6911.2000000000007,7274.25,6781.88,4827.2400000000007,4163.68,3093.0800000000004]
[71,null,7789.4100000000008,8175.7800000000007,7648.43,5438.33,4691.0300000000007,3484.75]
[72,null,8654.9,9093.2100000000009,8498.5500000000011,6032.9900000000007,5200.8900000000003,3874.8300000000004]
[73,null,9520.3900000000012,10011.17,9347.61,6645.67,5727.18,4265.97]
[74,null,10385.880000000001,10911.640000000001,10197.730000000001,7256.76,6254,4657.1100000000006]
[75,"o más",11342,11897.44,11183.53,7936.75,6832.2300000000005,5082.17]
[1,"Hijo",632.82000000000005,747.30000000000007,442.02000000000004,373.65000000000003,322.77,237.97]
[2,"Hijos",1046.22,1274.6500000000001,663.56000000000006,594.66000000000008,509.86,373.65000000000003]
[3,"Hijos o más",1524.28,1869.3100000000002,951.88,866.55000000000007,747.3,560.74]
[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]
[]
["ESSENTIAL CARE GUATEMALA",null,null,null,null,null,null,null,"OK"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,1381,1328,1231,872,657,462]
[19,null,1407,1353,1255,888,657,477]
[20,null,1432,1378,1277,904,675,477]
[21,null,1458,1402,1300,920,691,494]
[22,null,1485,1428,1324,938,707,494]
[23,null,1509,1451,1345,953,707,512]
[24,null,1563,1503,1393,987,723,526]
[25,null,1588,1527,1416,1003,741,526]
[26,null,1614,1552,1439,1019,756,544]
[27,null,1642,1579,1463,1036,773,544]
[28,null,1665,1601,1484,1051,790,559]
[29,null,1718,1652,1532,1085,806,575]
[30,null,1771,1703,1579,1118,823,593]
[31,null,1798,1729,1603,1135,839,593]
[32,null,1850,1779,1649,1168,855,607]
[33,null,1901,1828,1695,1200,872,625]
[34,null,1954,1879,1742,1233,904,642]
[35,null,2004,1927,1787,1265,920,657]
[36,null,2058,1979,1834,1299,953,675]
[37,null,2109,2028,1880,1331,969,691]
[38,null,2189,2105,1951,1382,1003,707]
[39,null,2265,2178,2019,1430,1036,723]
[40,null,2318,2229,2067,1463,1051,741]
[41,null,2396,2304,2136,1512,1085,756]
[42,null,2473,2378,2204,1561,1118,773]
[43,null,2550,2453,2274,1610,1150,806]
[44,null,2654,2553,2366,1676,1184,823]
[45,null,2732,2627,2436,1725,1218,855]
[46,null,2811,2703,2506,1774,1249,872]
[47,null,2915,2803,2599,1840,1282,888]
[48,null,3045,2929,2715,1922,1331,920]
[49,null,3150,3030,2808,1989,1382,953]
[50,null,3279,3154,2924,2070,1430,969]
[51,null,3411,3280,3041,2153,1479,1003]
[52,null,3514,3379,3133,2218,1528,1036]
[53,null,3669,3529,3271,2316,1579,1069]
[54,null,3827,3680,3412,2416,1642,1085]
[55,null,3981,3829,3549,2513,1692,1118]
[56,null,4139,3980,3690,2613,1758,1150]
[57,null,4293,4129,3827,2710,1824,1184]
[58,null,4529,4355,4037,2859,1890,1218]
[59,null,4737,4555,4223,2990,1971,1249]
[60,null,4944,4754,4407,3121,2054,1299]
[61,null,5231,5031,4664,3302,2153,1331]
[62,null,5621,5406,5011,3548,2301,1396]
[63,null,6169,5932,5499,3894,2513,1463]
[64,null,6922,6657,6171,4369,2810,1561]
[65,null,7885,7583,7030,4977,3187,1709]
[66,null,9056,8709,8073,5716,3631,1890]
[67,null,10410,10011,9280,6571,4140,2136]
[68,null,11840,11386,10555,7473,4698,2399]
[69,null,13348,12837,11900,8426,5289,2695]
[70,null,14961,14388,13338,9444,5947,3007]
[71,null,16653,16015,14846,10511,6635,3335]
[72,null,18422,17716,16423,11628,7374,3680]
[73,null,20296,19519,18094,12811,8163,4042]
[74,null,22247,21395,19833,14043,9001,4402]
[75,null,24276,23346,21642,15323,9888,4780]
[76,null,26384,25374,23522,16654,10824,5174]
[77,null,28568,27475,25469,18033,11809,5584]
[78,null,30859,29677,27511,19478,12844,5996]
[79,null,33226,31954,29621,20972,13911,6439]
[80,"o mas",35673,34307,31802,22517,15045,6867]
[1,"Hijo",599,576,534,378,316,249]
[2,"Hijos",939,903,837,593,494,390]
[3,"Hijos o más",1354,1302,1207,855,713,562]
[1,"Rider Comp. Maternidad",225,225,225,0,0,0]
[1,"Transplante de organos",300,300,300,300,300,300]
[null,"Deductible Waiver",null,180,345,775,1330,2080]
["TARIFAS SEMESTRALES ",null,null,null,null,null,null,null,"PENDIENTE"]
["EDAD"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,{"$f":"+C274*$L$2","v":731.93000000000006},703.84,652.43000000000006,462.16,348.21000000000004,244.86]
[19,null,{"$f":"+C275*$L$2","v":745.71},717.09,665.15,470.64000000000004,348.21000000000004,252.81]
[20,null,{"$f":"+C276*$L$2","v":758.96},730.34,676.81000000000006,479.12,357.75,252.81]
[21,null,{"$f":"+C277*$L$2","v":772.74},743.06000000000006,689,487.6,366.23,261.82]
[22,null,{"$f":"+C278*$L$2","v":787.05000000000007},756.84,701.72,497.14000000000004,374.71000000000004,261.82]
[23,null,{"$f":"+C279*$L$2","v":799.7700000000001},769.03000000000009,712.85,505.09000000000003,374.71000000000004,271.36]
[24,null,{"$f":"+C280*$L$2","v":828.39},796.59,738.29000000000008,523.11,383.19,278.78000000000003]
[25,null,{"$f":"+C281*$L$2","v":841.64},809.31000000000006,750.48,531.59,392.73,278.78000000000003]
[26,null,{"$f":"+C282*$L$2","v":855.42000000000007},822.56000000000006,762.67000000000007,540.07000000000005,400.68,288.32]
[27,null,{"$f":"+C283*$L$2","v":870.26},836.87,775.39,549.08000000000004,409.69,288.32]
[28,null,{"$f":"+C284*$L$2","v":882.45},848.53000000000009,786.5200000000001,557.03,418.70000000000005,296.27000000000004]
[29,null,{"$f":"+C285*$L$2","v":910.54000000000008},875.56000000000006,811.96,575.05000000000007,427.18,304.75]
[30,null,{"$f":"+C286*$L$2","v":938.63},902.59,836.87,592.54000000000008,436.19,314.29000000000002]
[31,null,{"$f":"+C287*$L$2","v":952.94},916.37,849.59,601.55000000000007,444.67,314.29000000000002]
[32,null,{"$f":"+C288*$L$2","v":980.5},942.87,873.97,619.04000000000008,453.15000000000003,321.71000000000004]
[33,null,{"$f":"+C289*$L$2","v":1007.5300000000001},968.84,898.35,636,462.16,331.25]
[34,null,{"$f":"+C290*$L$2","v":1035.6200000000001},995.87,923.26,653.49,479.12,340.26]
[35,null,{"$f":"+C291*$L$2","v":1062.1200000000001},1021.3100000000001,947.11,670.45,487.6,348.21000000000004]
[36,null,{"$f":"+C292*$L$2","v":1090.74},1048.8700000000001,972.0200000000001,688.47,505.09000000000003,357.75]
[37,null,{"$f":"+C293*$L$2","v":1117.77},1074.8400000000001,996.40000000000009,705.43000000000006,513.57000000000005,366.23]
[38,null,{"$f":"+C294*$L$2","v":1160.17},1115.6500000000001,1034.03,732.46,531.59,374.71000000000004]
[39,null,{"$f":"+C295*$L$2","v":1200.45},1154.3400000000001,1070.0700000000002,757.90000000000009,549.08000000000004,383.19]
[40,null,{"$f":"+C296*$L$2","v":1228.54},1181.3700000000001,1095.51,775.39,557.03,392.73]
[41,null,{"$f":"+C297*$L$2","v":1269.8800000000001},1221.1200000000001,1132.0800000000002,801.36,575.05000000000007,400.68]
[42,null,{"$f":"+C298*$L$2","v":1310.69},1260.3400000000001,1168.1200000000001,827.33,592.54000000000008,409.69]
[43,null,{"$f":"+C299*$L$2","v":1351.5},1300.0900000000001,1205.22,853.30000000000007,609.5,427.18]
[44,null,{"$f":"+C300*$L$2","v":1406.6200000000001},1353.0900000000001,1253.98,888.28000000000009,627.52,436.19]
[45,null,{"$f":"+C301*$L$2","v":1447.96},1392.3100000000002,1291.0800000000002,914.25,645.54000000000008,453.15000000000003]
[46,null,{"$f":"+C302*$L$2","v":1489.8300000000002},1432.5900000000001,1328.18,940.22,661.97,462.16]
[47,null,{"$f":"+C303*$L$2","v":1544.95},1485.5900000000001,1377.47,975.2,679.46,470.64000000000004]
[48,null,{"$f":"+C304*$L$2","v":1613.8500000000001},1552.3700000000001,1438.95,1018.6600000000001,705.43000000000006,487.6]
[49,null,{"$f":"+C305*$L$2","v":1669.5},1605.9,1488.24,1054.17,732.46,505.09000000000003]
[50,null,{"$f":"+C306*$L$2","v":1737.8700000000001},1671.6200000000001,1549.72,1097.1000000000001,757.90000000000009,513.57000000000005]
[51,null,{"$f":"+C307*$L$2","v":1807.8300000000002},1738.4,1611.73,1141.0900000000001,783.87,531.59]
[52,null,{"$f":"+C308*$L$2","v":1862.42},1790.8700000000001,1660.49,1175.54,809.84,549.08000000000004]
[53,null,{"$f":"+C309*$L$2","v":1944.5700000000002},1870.3700000000001,1733.63,1227.48,836.87,566.57000000000005]
[54,null,{"$f":"+C310*$L$2","v":2028.3100000000002},1950.4,1808.3600000000001,1280.48,870.26,575.05000000000007]
[55,null,{"$f":"+C311*$L$2","v":2109.9300000000003},2029.3700000000001,1880.97,1331.89,896.76,592.54000000000008]
[56,null,{"$f":"+C312*$L$2","v":2193.67},2109.4,1955.7,1384.89,931.74,609.5]
[57,null,{"$f":"+C313*$L$2","v":2275.29},2188.37,2028.3100000000002,1436.3000000000002,966.72,627.52]
[58,null,{"$f":"+C314*$L$2","v":2400.3700000000003},2308.15,2139.61,1515.27,1001.7,645.54000000000008]
[59,null,{"$f":"+C315*$L$2","v":2510.61},2414.15,2238.19,1584.7,1044.6300000000001,661.97]
[60,null,{"$f":"+C316*$L$2","v":2620.3200000000002},2519.6200000000003,2335.71,1654.13,1088.6200000000001,688.47]
[61,null,{"$f":"+C317*$L$2","v":2772.4300000000003},2666.4300000000003,2471.92,1750.0600000000002,1141.0900000000001,705.43000000000006]
[62,null,{"$f":"+C318*$L$2","v":2979.13},2865.1800000000003,2655.83,1880.44,1219.53,739.88]
[63,null,{"$f":"+C319*$L$2","v":3269.57},3143.96,2914.4700000000003,2063.8200000000002,1331.89,775.39]
[64,null,{"$f":"+C320*$L$2","v":3668.6600000000003},3528.21,3270.63,2315.5700000000002,1489.3000000000002,827.33]
[65,null,{"$f":"+C321*$L$2","v":4179.05},4018.9900000000002,3725.9,2637.81,1689.1100000000001,905.7700000000001]
[66,null,{"$f":"+C322*$L$2","v":4799.68},4615.7700000000004,4278.6900000000005,3029.48,1924.43,1001.7]
[67,null,{"$f":"+C323*$L$2","v":5517.3},5305.83,4918.4000000000005,3482.63,2194.2000000000003,1132.0800000000002]
[68,null,{"$f":"+C324*$L$2","v":6275.2000000000007},6034.58,5594.1500000000005,3960.69,2489.94,1271.47]
[69,null,{"$f":"+C325*$L$2","v":7074.4400000000005},6803.6100000000006,6307,4465.7800000000007,2803.17,1428.3500000000001]
[70,null,{"$f":"+C326*$L$2","v":7929.3300000000008},7625.64,7069.14,5005.3200000000006,3151.9100000000003,1593.71]
[71,null,{"$f":"+C327*$L$2","v":8826.09},8487.9500000000007,7868.38,5570.83,3516.55,1767.5500000000002]
[72,null,{"$f":"+C328*$L$2","v":9763.66},9389.48,8704.19,6162.84,3908.2200000000003,1950.4]
[73,null,{"$f":"+C329*$L$2","v":10756.880000000001},10345.07,9589.82,6789.83,4326.3900000000003,2142.2600000000002]
[74,null,{"$f":"+C330*$L$2","v":11790.91},11339.35,10511.49,7442.79,4770.5300000000007,2333.06]
[75,null,{"$f":"+C331*$L$2","v":12866.28},12373.380000000001,11470.26,8121.1900000000005,5240.6400000000003,2533.4]
[76,null,{"$f":"+C332*$L$2","v":13983.52},13448.220000000001,12466.66,8826.6200000000008,5736.72,2742.2200000000003]
[77,null,{"$f":"+C333*$L$2","v":15141.04},14561.75,13498.570000000002,9557.49,6258.77,2959.52]
[78,null,{"$f":"+C334*$L$2","v":16355.27},15728.810000000001,14580.83,10323.34,6807.3200000000006,3177.88]
[79,null,{"$f":"+C335*$L$2","v":17609.780000000002},16935.620000000003,15699.130000000001,11115.16,7372.83,3412.67]
[80,"o mas",{"$f":"+C336*$L$2","v":18906.690000000002},18182.71,16855.060000000001,11934.01,7973.85,3639.51]
[1,"Hijo",{"$f":"+C337*$L$2","v":317.47000000000003},305.28000000000003,283.02000000000004,200.34,167.48000000000002,131.97]
[2,"Hijos",{"$f":"+C338*$L$2","v":497.67},478.59000000000003,443.61,314.29000000000002,261.82,206.70000000000002]
[3,"Hijos o más",{"$f":"+C339*$L$2","v":717.62},690.06000000000006,639.71,453.15000000000003,377.89000000000004,297.86]
[1,"Rider Comp. Maternidad",{"$f":"+C340*$L$2","v":119.25},119.25,119.25,0,0,0]
[1,"Transplante de organos",{"$f":"+C341*$L$2","v":159},159,159,159,159,159]
[null,"Deductible Waiver",{"$f":"+C342*$L$2","v":0},95.4,182.85000000000002,410.75,704.90000000000009,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",null,null,null,null,null,null,null,"OK"]
["EDAD",null,null,null,null,null,null,null,null,null,null,"Pegar cifras aquí"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6",null,null,null,"SE1","SE2","SE3","SE4","SE5","SE6",null,null,"SE2","SE3","SE4","SE5","SE6"]
[18,null,{"$f":"L487*$L$6","v":0},{"$f":"T487","v":2571.25},{"$f":"U487","v":1992.3999999999999},1302.2,955.4,671.5,null,null,null,null,3025,2344,1532,1124,790,null,null,{"$f":"(M487)*0.85","v":2571.25},{"$f":"(N487)*0.85","v":1992.3999999999999},1302.2,955.4,671.5]
[19,null,{"$f":"L488*$L$6","v":0},{"$f":"T488","v":2622.25},{"$f":"U488","v":2017.8999999999999},{"$f":"V488","v":1326.85},{"$f":"W488","v":955.4},{"$f":"X488","v":692.75},null,null,null,null,3085,2374,1561,1124,815,null,null,{"$f":"(M488)*0.85","v":2622.25},{"$f":"(N488)*0.85","v":2017.8999999999999},{"$f":"(O488)*0.85","v":1326.85},{"$f":"(P488)*0.85","v":955.4},{"$f":"(Q488)*0.85","v":692.75}]
[20,null,0,2646.0499999999997,2067.1999999999998,1351.5,980.9,692.75,null,null,null,null,3113,2432,1590,1154,815,null,null,2646.0499999999997,2067.1999999999998,1351.5,980.9,692.75]
[21,null,0,2697.0499999999997,2120.75,1375.3,1004.6999999999999,718.25,null,null,null,null,3173,2495,1618,1182,845,null,null,2697.0499999999997,2120.75,1375.3,1004.6999999999999,718.25]
[22,null,0,2749.75,2170.0499999999997,1400.8,1028.5,718.25,null,null,null,null,3235,2553,1648,1210,845,null,null,2749.75,2170.0499999999997,1400.8,1028.5,718.25]
[23,null,0,2773.5499999999997,2193,1422.8999999999999,1028.5,743.75,null,null,null,null,3263,2580,1674,1210,875,null,null,2773.5499999999997,2193,1422.8999999999999,1028.5,743.75]
[24,null,0,2822.85,2245.6999999999998,1473.8999999999999,1051.45,765,null,null,null,null,3321,2642,1734,1237,900,null,null,2822.85,2245.6999999999998,1473.8999999999999,1051.45,765]
[25,null,0,2874.7,2295,1497.7,1076.95,765,null,null,null,null,3382,2700,1762,1267,900,null,null,2874.7,2295,1497.7,1076.95,765]
[26,null,0,2925.7,2345.15,1522.35,1099.05,790.5,null,null,null,null,3442,2759,1791,1293,930,null,null,2925.7,2345.15,1522.35,1099.05,790.5]
[27,null,0,2949.5,2394.4499999999998,1548.7,1123.7,790.5,null,null,null,null,3470,2817,1822,1322,930,null,null,2949.5,2394.4499999999998,1548.7,1123.7,790.5]
[28,null,0,3024.2999999999997,2446.2999999999997,1570.8,1147.5,812.6,null,null,null,null,3558,2878,1848,1350,956,null,null,3024.2999999999997,2446.2999999999997,1570.8,1147.5,812.6]
[29,null,0,3075.2999999999997,2496.4499999999998,1620.1,1170.45,835.55,null,null,null,null,3618,2937,1906,1377,983,null,null,3075.2999999999997,2496.4499999999998,1620.1,1170.45,835.55]
[30,null,0,3151.7999999999997,2571.25,1670.25,1195.95,861.9,null,null,null,null,3708,3025,1965,1407,1014,null,null,3151.7999999999997,2571.25,1670.25,1195.95,861.9]
[31,null,0,3201.1,2622.25,1695.75,1220.5999999999999,861.9,null,null,null,null,3766,3085,1995,1436,1014,null,null,3201.1,2622.25,1695.75,1220.5999999999999,861.9]
[32,null,0,3276.75,2697.0499999999997,1744.2,1242.7,882.3,null,null,null,null,3855,3173,2052,1462,1038,null,null,3276.75,2697.0499999999997,1744.2,1242.7,882.3]
[33,null,0,3353.25,2773.5499999999997,1792.6499999999999,1267.3499999999999,909.5,null,null,null,null,3945,3263,2109,1491,1070,null,null,3353.25,2773.5499999999997,1792.6499999999999,1267.3499999999999,909.5]
[34,null,0,3428.9,2850.9,1841.95,1314.95,933.3,null,null,null,null,4034,3354,2167,1547,1098,null,null,3428.9,2850.9,1841.95,1314.95,933.3]
[35,null,0,3530.9,2925.7,1890.3999999999999,1337.8999999999999,955.4,null,null,null,null,4154,3442,2224,1574,1124,null,null,3530.9,2925.7,1890.3999999999999,1337.8999999999999,955.4]
[36,null,0,3604.85,3001.35,1940.55,1384.6499999999999,980.9,null,null,null,null,4241,3531,2283,1629,1154,null,null,3604.85,3001.35,1940.55,1384.6499999999999,980.9]
[37,null,0,3680.5,3075.2999999999997,1989,1409.3,1004.6999999999999,null,null,null,null,4330,3618,2340,1658,1182,null,null,3680.5,3075.2999999999997,1989,1409.3,1004.6999999999999]
[38,null,0,3781.65,3176.45,2064.65,1456.8999999999999,1028.5,null,null,null,null,4449,3737,2429,1714,1210,null,null,3781.65,3176.45,2064.65,1456.8999999999999,1028.5]
[39,null,0,3882.7999999999997,3276.75,2135.1999999999998,1507.05,1051.45,null,null,null,null,4568,3855,2512,1773,1237,null,null,3882.7999999999997,3276.75,2135.1999999999998,1507.05,1051.45]
[40,null,0,4008.6,3353.25,2186.1999999999998,1528.3,1076.95,null,null,null,null,4716,3945,2572,1798,1267,null,null,4008.6,3353.25,2186.1999999999998,1528.3,1076.95]
[41,null,0,4108.05,3456.1,2259.2999999999997,1576.75,1099.05,null,null,null,null,4833,4066,2658,1855,1293,null,null,4108.05,3456.1,2259.2999999999997,1576.75,1099.05]
[42,null,null,4210.05,3553.85,2331.5499999999997,1625.2,1123.7,null,null,null,null,4953,4181,2743,1912,1322,null,null,4210.05,3553.85,2331.5499999999997,1625.2,1123.7]
[43,null,null,4336.7,3680.5,2405.5,1671.95,1170.45,null,null,null,null,5102,4330,2830,1967,1377,null,null,4336.7,3680.5,2405.5,1671.95,1170.45]
[44,null,null,4462.5,3781.65,2503.25,1721.25,1195.95,null,null,null,null,5250,4449,2945,2025,1407,null,null,4462.5,3781.65,2503.25,1721.25,1195.95]
[45,null,null,4587.45,3907.45,2576.35,1770.55,1242.7,null,null,null,null,5397,4597,3031,2083,1462,null,null,4587.45,3907.45,2576.35,1770.55,1242.7]
[46,null,null,4714.95,4034.1,2650.2999999999997,1816.45,1267.3499999999999,null,null,null,null,5547,4746,3118,2137,1491,null,null,4714.95,4034.1,2650.2999999999997,1816.45,1267.3499999999999]
[47,null,null,4839.8999999999996,4135.25,2748.9,1864.05,1291.1499999999999,null,null,null,null,5694,4865,3234,2193,1519,null,null,4839.8999999999996,4135.25,2748.9,1864.05,1291.1499999999999]
[48,null,null,5041.3499999999995,4310.3499999999995,2871.2999999999997,1935.45,1337.8999999999999,null,null,null,null,5931,5071,3378,2277,1574,null,null,5041.3499999999995,4310.3499999999995,2871.2999999999997,1935.45,1337.8999999999999]
[49,null,null,5217.3,4462.5,2970.75,2009.3999999999999,1384.6499999999999,null,null,null,null,6138,5250,3495,2364,1629,null,null,5217.3,4462.5,2970.75,2009.3999999999999,1384.6499999999999]
[50,null,null,5394.95,4613.8,3093.15,2078.25,1409.3,null,null,null,null,6347,5428,3639,2445,1658,null,null,5394.95,4613.8,3093.15,2078.25,1409.3]
[51,null,null,5570.05,4788.05,3216.4,2150.5,1456.8999999999999,null,null,null,null,6553,5633,3784,2530,1714,null,null,5570.05,4788.05,3216.4,2150.5,1456.8999999999999]
[52,null,null,5746.8499999999995,4940.2,3314.15,2221.9,1507.05,null,null,null,null,6761,5812,3899,2614,1773,null,null,5746.8499999999995,4940.2,3314.15,2221.9,1507.05]
[53,null,null,5974.65,5141.6499999999996,3460.35,2294.15,1553.8,null,null,null,null,7029,6049,4071,2699,1828,null,null,5974.65,5141.6499999999996,3460.35,2294.15,1553.8]
[54,null,null,6200.75,5344.8,3609.1,2386.7999999999997,1576.75,null,null,null,null,7295,6288,4246,2808,1855,null,null,6200.75,5344.8,3609.1,2386.7999999999997,1576.75]
[55,null,null,6427.7,5547.0999999999995,3754.45,2459.9,1625.2,null,null,null,null,7562,6526,4417,2894,1912,null,null,6427.7,5547.0999999999995,3754.45,2459.9,1625.2]
[56,null,null,6653.8,5746.8499999999995,3902.35,2555.1,1671.95,null,null,null,null,7828,6761,4591,3006,1967,null,null,6653.8,5746.8499999999995,3902.35,2555.1,1671.95]
[57,null,null,6881.5999999999995,5948.3,4049.4,2652,1721.25,null,null,null,null,8096,6998,4764,3120,2025,null,null,6881.5999999999995,5948.3,4049.4,2652,1721.25]
[58,null,null,7183.3499999999995,6200.75,4270.3999999999996,2747.2,1770.55,null,null,null,null,8451,7295,5024,3232,2083,null,null,7183.3499999999995,6200.75,4270.3999999999996,2747.2,1770.55]
[59,null,null,7459.5999999999995,6450.65,4466.75,2865.35,1816.45,null,null,null,null,8776,7589,5255,3371,2137,null,null,7459.5999999999995,6450.65,4466.75,2865.35,1816.45]
[60,null,null,7763.9,6730.3,4662.25,2986.0499999999997,1887.85,null,null,null,null,9134,7918,5485,3513,2221,null,null,7763.9,6730.3,4662.25,2986.0499999999997,1887.85]
[61,null,null,8191.45,7082.2,4933.3999999999996,3129.7,1935.45,null,null,null,null,9637,8332,5804,3682,2277,null,null,8191.45,7082.2,4933.3999999999996,3129.7,1935.45]
[62,null,null,8745.65,7584.55,5300.5999999999995,3344.75,2029.8,null,null,null,null,10289,8923,6236,3935,2388,null,null,8745.65,7584.55,5300.5999999999995,3344.75,2029.8]
[63,null,null,9576.1,8293.4499999999989,5817.4,3653.2999999999997,2127.5499999999997,null,null,null,null,11266,9757,6844,4298,2503,null,null,9576.1,8293.4499999999989,5817.4,3653.2999999999997,2127.5499999999997]
[64,null,null,10710,9276.0499999999993,6527.15,4083.4,2268.65,null,null,null,null,12600,10913,7679,4804,2669,null,null,10710,9276.0499999999993,6527.15,4083.4,2268.65]
[65,null,null,12172.85,10536.6,7435.8,4632.5,2484.5499999999997,null,null,null,null,14321,12396,8748,5450,2923,null,null,12172.85,10536.6,7435.8,4632.5,2484.5499999999997]
[66,null,null,13962.1,12122.699999999999,8539.1,5276.8,2747.2,null,null,null,null,16426,14262,10046,6208,3232,null,null,13962.1,12122.699999999999,8539.1,5276.8,2747.2]
[67,null,null,15979.15,13909.4,9816.65,6018,3104.2,null,null,null,null,18799,16364,11549,7080,3652,null,null,15979.15,13909.4,9816.65,6018,3104.2]
[68,null,null,18144.099999999999,15851.65,11164.75,6829.75,3486.7,null,null,null,null,21346,18649,13135,8035,4102,null,null,18144.099999999999,15851.65,11164.75,6829.75,3486.7]
[69,null,null,20412.75,17893.349999999999,12587.65,7687.4,3917.65,null,null,null,null,24015,21051,14809,9044,4609,null,null,20412.75,17893.349999999999,12587.65,7687.4,3917.65]
[70,null,null,22756.2,19981.8,14107.449999999999,8644.5,4370.7,null,null,null,null,26772,23508,16597,10170,5142,null,null,22756.2,19981.8,14107.449999999999,8644.5,4370.7]
[71,null,null,25175.3,22173.95,15702.9,9644.9499999999989,4847.55,null,null,null,null,29618,26087,18474,11347,5703,null,null,25175.3,22173.95,15702.9,9644.9499999999989,4847.55]
[72,null,null,27667.5,24393.3,17371.45,10717.65,5349.05,null,null,null,null,32550,28698,20437,12609,6293,null,null,27667.5,24393.3,17371.45,10717.65,5349.05]
[73,null,null,30213.25,26685.75,19138.599999999999,11865.15,5874.3499999999995,null,null,null,null,35545,31395,22516,13959,6911,null,null,30213.25,26685.75,19138.599999999999,11865.15,5874.3499999999995]
[74,null,null,32782.799999999996,29030.05,20978,13083.199999999999,6398.8,null,null,null,null,38568,34153,24680,15392,7528,null,null,32782.799999999996,29030.05,20978,13083.199999999999,6398.8]
[75,null,null,35428,31397.3,22891.35,14372.65,6948.75,null,null,null,null,41680,36938,26931,16909,8175,null,null,35428,31397.3,22891.35,14372.65,6948.75]
[76,null,null,38100.400000000001,33815.549999999996,24879.5,15733.5,7520.8,null,null,null,null,44824,39783,29270,18510,8848,null,null,38100.400000000001,33815.549999999996,24879.5,15733.5,7520.8]
[77,null,null,40820.400000000001,36259.299999999996,26939.05,17164.899999999998,8116.65,null,null,null,null,48024,42658,31693,20194,9549,null,null,40820.400000000001,36259.299999999996,26939.05,17164.899999999998,8116.65]
[78,null,null,43566.75,38754.9,29098.899999999998,18668.55,8715.9,null,null,null,null,51255,45594,34234,21963,10254,null,null,43566.75,38754.9,29098.899999999998,18668.55,8715.9]
[79,null,null,46340.299999999996,41249.65,31331,20220.649999999998,9359.35,null,null,null,null,54518,48529,36860,23789,11011,null,null,46340.299999999996,41249.65,31331,20220.649999999998,9359.35]
[80,"o mas",null,49135.1,43795.4,33637.9,21867.95,9981.5499999999993,null,null,null,null,57806,51524,39574,25727,11743,null,null,49135.1,43795.4,33637.9,21867.95,9981.5499999999993]
[1,"Hijo",null,1311.55,758.19999999999993,565.25,407.15,288.14999999999998,null,null,null,null,1543,892,665,479,339,null,null,{"$f":"(M550)*0.85","v":1311.55},{"$f":"(N550)*0.85","v":758.19999999999993},{"$f":"(O550)*0.85","v":565.25},{"$f":"(P550)*0.85","v":407.15},{"$f":"(Q550)*0.85","v":288.14999999999998}]
[2,"Hijos",null,{"$f":"T551","v":2193},{"$f":"U551","v":1137.3},{"$f":"V551","v":885.69999999999993},{"$f":"W551","v":623.9},{"$f":"X551","v":431.8},null,null,null,null,2580,1338,1042,734,508,null,null,2193,1137.3,885.69999999999993,623.9,431.8]
[3,"Hijos o más",null,3227.45,1639.6499999999999,1276.7,909.5,646,null,null,null,null,3797,1929,1502,1070,760,null,null,{"$f":"(M552)*0.85","v":3227.45},{"$f":"(N552)*0.85","v":1639.6499999999999},{"$f":"(O552)*0.85","v":1276.7},{"$f":"(P552)*0.85","v":909.5},{"$f":"(Q552)*0.85","v":646}]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225,null,null,null,null,225,225,225,225,225,null,null,{"$f":"M553*0.85","v":191.25},{"$f":"N553*0.85","v":191.25},191.25,191.25,191.25]
[1,"Transplante de organos",null,300,300,300,300,300,null,null,null,null,300,300,300,300,300,null,null,{"$f":"M554*0.85","v":255},{"$f":"N554*0.85","v":255},{"$f":"O554*0.85","v":255},{"$f":"P554*0.85","v":255},{"$f":"Q554*0.85","v":255}]
[null,"Deductible Waiver",null,180,345,775,1330,2080,null,null,null,null,180,345,775,1330,2080,null,null,153,293.25,658.75,1130.5,1768]
["TARIFAS SEMESTRALES "]
["EDAD",null,null,null,null,null,null,null,"PENDIENTE"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,{"$f":"+C487*$L$2","v":0},1362.7625,1055.972,690.16600000000005,506.36200000000002,355.89500000000004]
[19,null,{"$f":"+C488*$L$2","v":0},1389.7925,1069.4870000000001,703.23050000000001,506.36200000000002,367.15750000000003]
[20,null,{"$f":"+C489*$L$2","v":0},1402.4064999999998,1095.616,716.29500000000007,519.87700000000007,367.15750000000003]
[21,null,{"$f":"+C490*$L$2","v":0},1429.4365,1123.9974999999999,728.90899999999999,532.49099999999999,380.67250000000001]
[22,null,{"$f":"+C491*$L$2","v":0},1457.3675000000001,1150.1264999999999,742.42399999999998,545.10500000000002,380.67250000000001]
[23,null,{"$f":"+C492*$L$2","v":0},1469.9814999999999,1162.29,754.13699999999994,545.10500000000002,394.1875]
[24,null,{"$f":"+C493*$L$2","v":0},1496.1105,1190.221,781.16699999999992,557.26850000000002,405.45000000000005]
[25,null,{"$f":"+C494*$L$2","v":0},1523.5909999999999,1216.3500000000001,793.78100000000006,570.7835,405.45000000000005]
[26,null,{"$f":"+C495*$L$2","v":0},1550.6210000000001,1242.9295000000002,806.84550000000002,582.49649999999997,418.96500000000003]
[27,null,{"$f":"+C496*$L$2","v":0},1563.2350000000001,1269.0584999999999,820.81100000000004,595.56100000000004,418.96500000000003]
[28,null,{"$f":"+C497*$L$2","v":0},1602.8789999999999,1296.539,832.524,608.17500000000007,430.67800000000005]
[29,null,{"$f":"+C498*$L$2","v":0},1629.9089999999999,1323.1185,858.65300000000002,620.33850000000007,442.8415]
[30,null,{"$f":"+C499*$L$2","v":0},1670.454,1362.7625,885.23250000000007,633.85350000000005,456.80700000000002]
[31,null,{"$f":"+C500*$L$2","v":0},1696.5830000000001,1389.7925,898.74750000000006,646.91800000000001,456.80700000000002]
[32,null,{"$f":"+C501*$L$2","v":0},1736.6775,1429.4365,924.42600000000004,658.63100000000009,467.61899999999997]
[33,null,{"$f":"+C502*$L$2","v":0},1777.2225000000001,1469.9814999999999,950.10450000000003,671.69550000000004,482.03500000000003]
[34,null,{"$f":"+C503*$L$2","v":0},1817.3170000000002,1510.9770000000001,976.23350000000005,696.9235000000001,494.649]
[35,null,{"$f":"+C504*$L$2","v":0},1871.3770000000002,1550.6210000000001,1001.912,709.08699999999999,506.36200000000002]
[36,null,{"$f":"+C505*$L$2","v":0},1910.5705,1590.7155,1028.4915000000001,733.86450000000002,519.87700000000007]
[37,null,{"$f":"+C506*$L$2","v":0},1950.6650000000002,1629.9089999999999,1054.17,746.92899999999997,532.49099999999999]
[38,null,{"$f":"+C507*$L$2","v":0},2004.2745000000002,1683.5184999999999,1094.2645,772.15699999999993,545.10500000000002]
[39,null,{"$f":"+C508*$L$2","v":0},2057.884,1736.6775,1131.6559999999999,798.73649999999998,557.26850000000002]
[40,null,{"$f":"+C509*$L$2","v":0},2124.558,1777.2225000000001,1158.6859999999999,809.99900000000002,570.7835]
[41,null,{"$f":"+C510*$L$2","v":0},2177.2665000000002,1831.7329999999999,1197.4289999999999,835.67750000000001,582.49649999999997]
[42,null,null,{"$f":"+D511*$L$2","v":2231.3265000000001},1883.5405000000001,1235.7214999999999,861.35600000000011,595.56100000000004]
[43,null,null,{"$f":"+D512*$L$2","v":2298.451},1950.6650000000002,1274.915,886.13350000000003,620.33850000000007]
[44,null,null,{"$f":"+D513*$L$2","v":2365.125},2004.2745000000002,1326.7225000000001,912.26250000000005,633.85350000000005]
[45,null,null,{"$f":"+D514*$L$2","v":2431.3485000000001},2070.9485,1365.4655,938.39150000000006,658.63100000000009]
[46,null,null,{"$f":"+D515*$L$2","v":2498.9234999999999},2138.0729999999999,1404.6589999999999,962.71850000000006,671.69550000000004]
[47,null,null,{"$f":"+D516*$L$2","v":2565.1469999999999},2191.6824999999999,1456.9170000000001,987.94650000000001,684.30949999999996]
[48,null,null,{"$f":"+D517*$L$2","v":2671.9155000000001},2284.4854999999998,1521.789,1025.7885000000001,709.08699999999999]
[49,null,null,{"$f":"+D518*$L$2","v":2765.1690000000003},2365.125,1574.4975000000002,1064.982,733.86450000000002]
[50,null,null,{"$f":"+D519*$L$2","v":2859.3235},2445.3140000000003,1639.3695000000002,1101.4725000000001,746.92899999999997]
[51,null,null,{"$f":"+D520*$L$2","v":2952.1265000000003},2537.6665000000003,1704.6920000000002,1139.7650000000001,772.15699999999993]
[52,null,null,{"$f":"+D521*$L$2","v":3045.8305},2618.306,1756.4995000000001,1177.6070000000002,798.73649999999998]
[53,null,null,{"$f":"+D522*$L$2","v":3166.5645},2725.0745000000002,1833.9855,1215.8995000000002,823.51400000000001]
[54,null,null,{"$f":"+D523*$L$2","v":3286.3975},2832.7440000000001,1912.8230000000001,1265.0039999999999,835.67750000000001]
[55,null,null,{"$f":"+D524*$L$2","v":3406.681},2939.9629999999997,1989.8585,1303.7470000000001,861.35600000000011]
[56,null,null,{"$f":"+D525*$L$2","v":3526.5140000000001},3045.8305,2068.2455,1354.203,886.13350000000003]
[57,null,null,{"$f":"+D526*$L$2","v":3647.248},3152.5990000000002,2146.1820000000002,1405.5600000000002,912.26250000000005]
[58,null,null,{"$f":"+D527*$L$2","v":3807.1754999999998},3286.3975,2263.3119999999999,1456.0160000000001,938.39150000000006]
[59,null,null,{"$f":"+D528*$L$2","v":3953.5879999999997},3418.8445000000002,2367.3775000000001,1518.6355000000001,962.71850000000006]
[60,null,null,{"$f":"+D529*$L$2","v":4114.8670000000002},3567.0590000000002,2470.9925000000003,1582.6064999999999,1000.5605]
[61,null,null,{"$f":"+D530*$L$2","v":4341.4684999999999},3753.5660000000003,2614.7019999999998,1658.741,1025.7885000000001]
[62,null,null,{"$f":"+D531*$L$2","v":4635.1944999999996},4019.8115000000003,2809.3179999999998,1772.7175000000002,1075.7940000000001]
[63,null,null,{"$f":"+D532*$L$2","v":5075.3330000000005},4395.5284999999994,3083.2219999999998,1936.249,1127.6015]
[64,null,null,{"$f":"+D533*$L$2","v":5676.3},4916.3064999999997,3459.3894999999998,2164.2020000000002,1202.3845000000001]
[65,null,null,{"$f":"+D534*$L$2","v":6451.6105000000007},5584.3980000000001,3940.9740000000002,2455.2249999999999,1316.8115]
[66,null,null,{"$f":"+D535*$L$2","v":7399.9130000000005},6425.0309999999999,4525.7230000000009,2796.7040000000002,1456.0160000000001]
[67,null,null,{"$f":"+D536*$L$2","v":8468.9495000000006},7371.982,5202.8244999999997,3189.54,1645.2259999999999]
[68,null,null,{"$f":"+D537*$L$2","v":9616.3729999999996},8401.3744999999999,5917.3175000000001,3619.7675000000004,1847.951]
[69,null,null,{"$f":"+D538*$L$2","v":10818.7575},9483.4755000000005,6671.4544999999998,4074.3220000000001,2076.3545000000004]
[70,null,null,{"$f":"+D539*$L$2","v":12060.786000000002},10590.353999999999,7476.9484999999995,4581.585,2316.471]
[71,null,null,{"$f":"+D540*$L$2","v":13342.909},11752.193500000001,8322.5370000000003,5111.8234999999995,2569.2015000000001]
[72,null,null,{"$f":"+D541*$L$2","v":14663.775000000001},12928.449000000001,9206.8685000000005,5680.3545000000004,2834.9965000000002]
[73,null,null,{"$f":"+D542*$L$2","v":16013.022500000001},14143.4475,10143.458000000001,6288.5295000000006,3113.4054999999998]
[74,null,null,{"$f":"+D543*$L$2","v":17374.883999999998},15385.9265,11118.34,6934.0959999999995,3391.3640000000005]
[75,null,null,{"$f":"+D544*$L$2","v":18776.84},16640.569,12132.415499999999,7617.5045,3682.8375000000001]
[76,null,null,{"$f":"+D545*$L$2","v":20193.212000000003},17922.2415,13186.135,8338.755000000001,3986.0240000000003]
[77,null,null,{"$f":"+D546*$L$2","v":21634.812000000002},19217.429,14277.6965,9097.396999999999,4301.8244999999997]
[78,null,null,{"$f":"+D547*$L$2","v":23090.377500000002},20540.097000000002,15422.416999999999,9894.3315000000002,4619.4269999999997]
[79,null,null,{"$f":"+D548*$L$2","v":24560.359},21862.3145,16605.43,10716.9445,4960.4555]
[80,"o mas",null,{"$f":"+D549*$L$2","v":26041.602999999999},23211.562000000002,17828.087000000003,11590.013500000001,5290.2214999999997]
[1,"Hijo",{"$f":"+C550*$L$2","v":0},695.12149999999997,401.846,299.58250000000004,215.7895,152.71949999999998]
[2,"Hijos",{"$f":"+C551*$L$2","v":0},1162.29,602.76900000000001,469.42099999999999,330.66700000000003,228.85400000000001]
[3,"Hijos o más",{"$f":"+C552*$L$2","v":0},1710.5484999999999,869.0145,676.65100000000007,482.03500000000003,342.38]
[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 "]
["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 BLUE 100 GUATEMALA",null,null,null,null,null,null,null,"?"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","ET1","ET2","ET3","ET4","ET5","ET6"]
[18,null,1326,1102,1079,1018,928,717]
[19,null,1471,1121,1098,1035,944,733]
[20,null,1702,1140,1116,1053,960,748]
[21,null,1883,1159,1136,1070,976,764]
[22,null,2123,1179,1155,1089,993,780]
[23,null,2461,1199,1174,1107,1008,797]
[24,null,2695,1219,1194,1125,1025,813]
[25,null,3185,1237,1212,1142,1043,830]
[26,null,3358,1257,1232,1161,1058,846]
[27,null,3780,1276,1251,1179,1075,863]
[28,null,4205,1300,1274,1200,1094,882]
[29,null,4626,1322,1296,1221,1113,903]
[30,null,5047,1346,1318,1242,1133,924]
[31,null,5068,1368,1341,1263,1153,944]
[32,null,5088,1392,1363,1285,1171,965]
[33,null,5656,1430,1401,1320,1204,994]
[34,null,6225,1468,1438,1355,1236,1024]
[35,null,6508,1506,1476,1391,1268,1053]
[36,null,6554,1544,1513,1426,1300,1083]
[37,null,7376,1582,1551,1461,1333,1112]
[38,null,8198,1622,1589,1497,1366,1144]
[39,null,9021,1660,1627,1534,1398,1175]
[40,null,9842,1699,1665,1569,1430,1207]
[41,null,10752,1738,1703,1605,1463,1238]
[42,null,null,1777,1741,1641,1496,1271]
[43,null,null,1847,1811,1706,1556,1326]
[44,null,null,1918,1879,1771,1615,1383]
[45,null,null,1989,1949,1837,1674,1439]
[46,null,null,2059,2018,1901,1735,1494]
[47,null,null,2130,2088,1967,1794,1551]
[48,null,null,2205,2160,2037,1857,1608]
[49,null,null,2279,2233,2105,1920,1668]
[50,null,null,2354,2307,2174,1983,1725]
[51,null,null,2429,2381,2243,2046,1784]
[52,null,null,2504,2453,2312,2109,1842]
[53,null,null,2592,2541,2394,2182,1914]
[54,null,null,2681,2627,2476,2257,1985]
[55,null,null,2769,2714,2558,2332,2058]
[56,null,null,2858,2801,2639,2407,2128]
[57,null,null,2946,2887,2721,2480,2201]
[58,null,null,3049,2987,2807,2567,2294]
[59,null,null,3150,3087,2893,2652,2387]
[60,null,null,3252,3187,2978,2739,2480]
[61,null,null,3376,3308,3107,2843,2572]
[62,null,null,3528,3457,3259,2971,2689]
[63,null,null,3709,3635,3426,3124,2827]
[64,null,null,3923,3845,3624,3304,2990]
[65,null,null,4179,4095,3860,3519,3213]
[66,null,null,4481,4391,4139,3774,3470]
[67,null,null,4839,4741,4468,4074,3750]
[68,null,null,5250,5145,4848,4420,4067]
[69,null,null,5729,5613,5290,4824,4441]
[70,null,null,6284,6157,5754,5292,4942]
[71,null,null,6920,6781,6391,5826,5441]
[72,null,null,7656,7501,7071,6447,6024]
[73,null,null,8503,8331,7853,7160,6686]
[74,null,null,9480,9290,8755,7982,7457]
[75,null,null,10600,10386,9748,8925,8389]
[76,null,null,11887,11647,10969,10008,9407]
[77,null,null,13350,13081,12328,11241,10565]
[78,null,null,15000,14698,13853,12630,11870]
[79,null,null,16854,16514,15565,14190,13338]
[80,"o mas",null,19072,18687,17612,16059,15092]
[1,"Hijo",604,563,551,520,474,280]
[2,"Hijos",991,949,930,877,800,416]
[3,"Hijos o más",1452,1393,1364,1285,1173,597]
[1,"Rider Comp. Maternidad",225,225,225,225,225,225]
[1,"Transplante de organos",250,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","ET1","ET2","ET3","ET4","ET5","ET6"]
[18,null,{"$f":"+C778*$L$2","v":702.78000000000009},584.06000000000006,571.87,539.54000000000008,491.84000000000003,380.01]
[19,null,779.63,594.13,581.94000000000005,548.55000000000007,500.32000000000005,388.49]
[20,null,902.06000000000006,604.20000000000005,591.48,558.09,508.8,396.44]
[21,null,997.99,614.27,602.08000000000004,567.1,517.28,404.92]
[22,null,1125.19,624.87,612.15,577.17000000000007,526.29000000000008,413.40000000000003]
[23,null,1304.3300000000002,635.47,622.22,586.71,534.24,422.41]
[24,null,1428.3500000000001,646.07000000000005,632.82000000000005,596.25,543.25,430.89000000000004]
[25,null,1688.0500000000002,655.61,642.36,605.26,552.79000000000008,439.90000000000003]
[26,null,1779.74,666.21,652.96,615.33000000000004,560.74,448.38]
[27,null,2003.4,676.28000000000009,663.03000000000009,624.87,569.75,457.39000000000004]
[28,null,{"$f":"+C788*$L$2","v":2228.65},689,675.22,636,579.82000000000005,467.46000000000004]
[29,null,2451.7800000000002,700.66000000000008,686.88,647.13,589.89,478.59000000000003]
[30,null,2674.9100000000003,713.38,698.54000000000008,658.26,600.49,489.72]
[31,null,2686.04,725.04000000000008,710.73,669.39,611.09,500.32000000000005]
[32,null,2696.6400000000003,737.76,722.39,681.05000000000007,620.63,511.45000000000005]
[33,null,2997.6800000000003,757.90000000000009,742.53000000000009,699.6,638.12,526.82000000000005]
[34,null,3299.25,778.04000000000008,762.14,718.15000000000009,655.08000000000004,542.72]
[35,null,3449.2400000000002,798.18000000000006,782.28000000000009,737.23,672.04000000000008,558.09]
[36,null,3473.6200000000003,818.32,801.89,755.78000000000009,689,573.99]
[37,null,3909.28,838.46,822.03000000000009,774.33,706.49,589.36]
[38,null,{"$f":"+C798*$L$2","v":4344.9400000000005},859.66000000000008,842.17000000000007,793.41000000000008,723.98,606.32000000000005]
[39,null,4781.13,879.80000000000007,862.31000000000006,813.0200000000001,740.94,622.75]
[40,null,5216.26,900.47,882.45,831.57,757.90000000000009,639.71]
[41,null,5698.56,921.1400000000001,902.59,850.65000000000009,775.39,656.14]
[42,null,null,{"$f":"+D802*$L$2","v":941.81000000000006},922.73,869.73,792.88,673.63]
[43,null,null,{"$f":"+D803*$L$2","v":978.91000000000008},959.83,904.18000000000006,824.68000000000006,702.78000000000009]
[44,null,null,{"$f":"+D804*$L$2","v":1016.5400000000001},995.87,938.63,855.95,732.99]
[45,null,null,{"$f":"+D805*$L$2","v":1054.17},1032.97,973.61,887.22,762.67000000000007]
[46,null,null,{"$f":"+D806*$L$2","v":1091.27},1069.54,1007.5300000000001,919.55000000000007,791.82]
[47,null,null,{"$f":"+D807*$L$2","v":1128.9000000000001},1106.6400000000001,1042.51,950.82,822.03000000000009]
[48,null,null,{"$f":"+D808*$L$2","v":1168.6500000000001},1144.8,1079.6100000000001,984.21,852.24]
[49,null,null,{"$f":"+D809*$L$2","v":1207.8700000000001},1183.49,1115.6500000000001,1017.6,884.04000000000008]
[50,null,null,{"$f":"+D810*$L$2","v":1247.6200000000001},1222.71,1152.22,1050.99,914.25]
[51,null,null,{"$f":"+D811*$L$2","v":1287.3700000000001},1261.93,1188.79,1084.3800000000001,945.5200000000001]
[52,null,null,{"$f":"+D812*$L$2","v":1327.1200000000001},1300.0900000000001,1225.3600000000001,1117.77,976.2600000000001]
[53,null,null,{"$f":"+D813*$L$2","v":1373.76},1346.73,1268.8200000000002,1156.46,1014.4200000000001]
[54,null,null,{"$f":"+D814*$L$2","v":1420.93},1392.3100000000002,1312.28,1196.21,1052.05]
[55,null,null,{"$f":"+D815*$L$2","v":1467.5700000000002},1438.42,1355.74,1235.96,1090.74]
[56,null,null,{"$f":"+D816*$L$2","v":1514.74},1484.53,1398.67,1275.71,1127.8400000000001]
[57,null,null,{"$f":"+D817*$L$2","v":1561.38},1530.1100000000001,1442.13,1314.4,1166.53]
[58,null,null,{"$f":"+D818*$L$2","v":1615.97},1583.1100000000001,1487.71,1360.51,1215.8200000000002]
[59,null,null,{"$f":"+D819*$L$2","v":1669.5},1636.1100000000001,1533.29,1405.5600000000002,1265.1100000000001]
[60,null,null,{"$f":"+D820*$L$2","v":1723.5600000000002},1689.1100000000001,1578.3400000000001,1451.67,1314.4]
[61,null,null,{"$f":"+D821*$L$2","v":1789.2800000000002},1753.24,1646.71,1506.79,1363.16]
[62,null,null,{"$f":"+D822*$L$2","v":1869.8400000000001},1832.21,1727.27,1574.63,1425.17]
[63,null,null,{"$f":"+D823*$L$2","v":1965.7700000000002},1926.5500000000002,1815.7800000000002,1655.72,1498.3100000000002]
[64,null,null,{"$f":"+D824*$L$2","v":2079.19},2037.8500000000001,1920.72,1751.1200000000001,1584.7]
[65,null,null,{"$f":"+D825*$L$2","v":2214.87},2170.35,2045.8000000000002,1865.0700000000002,1702.89]
[66,null,null,{"$f":"+D826*$L$2","v":2374.9300000000003},2327.23,2193.67,2000.22,1839.1000000000001]
[67,null,null,{"$f":"+D827*$L$2","v":2564.67},2512.73,2368.04,2159.2200000000003,1987.5]
[68,null,null,{"$f":"+D828*$L$2","v":2782.5},2726.8500000000004,2569.44,2342.6,2155.5100000000002]
[69,null,null,{"$f":"+D829*$L$2","v":3036.3700000000003},2974.8900000000003,2803.7000000000003,2556.7200000000003,2353.73]
[70,null,null,{"$f":"+D830*$L$2","v":3330.52},3263.21,3049.6200000000003,2804.76,2619.2600000000002]
[71,null,null,{"$f":"+D831*$L$2","v":3667.6000000000004},3593.9300000000003,3387.23,3087.78,2883.73]
[72,null,null,{"$f":"+D832*$L$2","v":4057.6800000000003},3975.53,3747.63,3416.9100000000003,3192.7200000000003]
[73,null,null,{"$f":"+D833*$L$2","v":4506.59},4415.43,4162.09,3794.8,3543.5800000000004]
[74,null,null,{"$f":"+D834*$L$2","v":5024.4000000000005},4923.7,4640.1500000000005,4230.46,3952.21]
[75,null,null,{"$f":"+D835*$L$2","v":5618},5504.58,5166.4400000000005,4730.25,4446.17]
[76,null,null,{"$f":"+D836*$L$2","v":6300.1100000000006},6172.9100000000008,5813.5700000000006,5304.2400000000007,4985.71]
[77,null,null,{"$f":"+D837*$L$2","v":7075.5},6932.93,6533.84,5957.7300000000005,5599.4500000000007]
[78,null,null,{"$f":"+D838*$L$2","v":7950},7789.9400000000005,7342.09,6693.9000000000005,6291.1]
[79,null,null,{"$f":"+D839*$L$2","v":8932.6200000000008},8752.42,8249.4500000000007,7520.7000000000007,7069.14]
[80,"o mas",null,{"$f":"+D840*$L$2","v":10108.16},9904.11,9334.36,8511.27,7998.76]
[1,"Hijo",{"$f":"+C841*$L$2","v":320.12},298.39000000000004,292.03000000000003,275.60000000000002,251.22,148.4]
[2,"Hijos",{"$f":"+C842*$L$2","v":525.23},502.97,492.90000000000003,464.81,424,220.48000000000002]
[3,"Hijos o más",{"$f":"+C843*$L$2","v":769.56000000000006},738.29000000000008,722.92000000000007,681.05000000000007,621.69000000000005,316.41000000000003]
[1,"Rider Comp. Maternidad",{"$f":"+C844*$L$2","v":119.25},119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",{"$f":"+C845*$L$2","v":132.5},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":2031.15},{"$f":"E6*$L$3","v":1390.95},1001.825,709.77500000000009,542.57500000000005]
[25,"-  29",null,{"$f":"D7*$L$3","v":2127.9500000000003},1544.4,1113.2,779.07500000000005,598.40000000000009]
[30,"-  34",null,2225.8500000000004,1655.2250000000001,1238.6000000000001,946.55000000000007,724.07500000000005]
[35,"-  39",null,2490.4,1850.2,1390.95,1057.6500000000001,807.40000000000009]
[40,"-  44",null,2893.0000000000005,2031.15,1544.4,1168.75,890.45]
[45,"-  49",null,3227.4,2267.65,1724.8000000000002,1307.9000000000001,1001.825]
[50,"-  54",null,4214.6500000000005,2990.9,2267.65,1864.5000000000002,1433.575]
[55,"-  59",null,4492.6750000000002,3185.3250000000003,2420.2750000000001,1989.0750000000003,1516.3500000000001]
[60,null,null,4882.3500000000004,3463.9,2754.125,2365,1905.4750000000001]
[61,null,null,5243.7000000000007,3714.4250000000002,2949.1000000000004,2545.9500000000003,2045.1750000000002]
[62,null,null,5744.4750000000004,4062.0250000000005,3227.4,2781.625,2239.3250000000003]
[63,null,null,6106.3750000000009,4325.75,3436.1250000000005,2963.1250000000005,2378.4750000000004]
[64,null,null,6607.1500000000005,4673.9000000000005,3714.4250000000002,3199.6250000000005,2573.7250000000004]
[65,null,null,8638.3000000000011,6106.3750000000009,4701.6750000000002,4270.4750000000004,3630.2750000000001]
[66,null,null,10042.725,7094.1750000000002,5466.4500000000007,4966.2250000000004,4214.6500000000005]
[67,null,null,10960.95,7747.85,5966.9500000000007,5424.9250000000002,4604.3250000000007]
[68,null,null,12142.900000000001,8581.9250000000011,6607.1500000000005,6009.0250000000005,5105.1000000000004]
[69,null,null,13353.45,9430.85,7274.85,6607.1500000000005,5605.3250000000007]
[70,null,null,16440.875,11488.95,8554.1500000000015,7692.0250000000005,6593.1250000000009]
[71,null,null,17080.800000000003,11935.000000000002,8888.5500000000011,7998.3750000000009,6857.6750000000002]
[72,null,null,17567.550000000003,12282.050000000001,9138.8000000000011,8220.5750000000007,7052.3750000000009]
[73,null,null,18207.475000000002,12727.550000000001,9472.9250000000011,8526.375,7316.6500000000005]
[74,null,null,18541.600000000002,12950.025000000001,9653.6,8679.5500000000011,7441.7750000000005]
[75,"o más",null,19348.175000000003,13519.825000000001,10070.225,9055.2000000000007,7761.6]
[1,"Hijo",null,1126.6750000000002,514.80000000000007,403.97500000000002,348.15000000000003,250.52500000000003]
[2,"Hijos",null,1766.6000000000001,820.87500000000011,640.47500000000002,542.57500000000005,403.97500000000002]
[3,"Hijos o más",null,2573.7250000000004,1196.5250000000001,946.55000000000007,792.82500000000005,584.92500000000007]
[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":976.52500000000009},{"$f":"E140*$L$3","v":764.50000000000011},584.65000000000009,509.85,381.97500000000002]
[25,"-  29",null,{"$f":"D141*$L$3","v":1072.5},859.92500000000007,658.07500000000005,562.92500000000007,424.87500000000006]
[30,"-  34",null,1231.7250000000001,1008.7,764.50000000000011,658.07500000000005,499.40000000000003]
[35,"-  39",null,1359.325,1136.0250000000001,849.75000000000011,732.6,551.65000000000009]
[40,"-  44",null,1518.0000000000002,1295.5250000000001,956.17500000000007,828.30000000000007,626.72500000000002]
[45,"-  49",null,1752.0250000000001,1518.0000000000002,1114.8500000000001,966.35,722.15000000000009]
[50,"-  54",null,1911.5250000000001,1667.0500000000002,1221.2750000000001,1051.325,796.40000000000009]
[55,"-  59",null,2250.6000000000004,1995.4,1444.0250000000001,1252.9000000000001,934.72500000000002]
[60,null,null,2357.0250000000001,2134,1529.0000000000002,1327.4250000000002,987.52500000000009]
[61,null,null,2654.3,2399.375,1730.8500000000001,1486.65,1114.8500000000001]
[62,null,null,2951.0250000000001,2664.75,1921.9750000000001,1656.6000000000001,1242.1750000000002]
[63,null,null,3238.4,2930.1250000000005,2112.8250000000003,1826.2750000000001,1369.5]
[64,null,null,3535.1250000000005,3205.9500000000003,2303.6750000000002,1995.4,1497.1000000000001]
[65,null,null,3545.8500000000004,3227.1250000000005,2325.125,2006.9500000000003,1497.1000000000001]
[66,null,null,3545.8500000000004,3259.3,2335.5750000000003,2017.1250000000002,1497.1000000000001]
[67,null,null,3938.2750000000001,3630.55,2590.5,2239.875,1667.0500000000002]
[68,null,null,4330.9750000000004,3991.3500000000004,2855.6000000000004,2463.1750000000002,1837.2750000000001]
[69,null,null,4532.8250000000007,4172.3,2983.4750000000004,2579.7750000000001,1921.9750000000001]
[70,null,null,4543.55,4236.1000000000004,3015.3750000000005,2600.6750000000002,1932.15]
[71,null,null,5106.75,4777.5750000000007,3397.0750000000003,2930.1250000000005,2176.9]
[72,null,null,5679.5750000000007,5308.3250000000007,3768.3250000000003,3248.5750000000003,2420.2750000000001]
[73,null,null,6253.2250000000004,5838.5250000000005,4151.125,3577.4750000000004,2664.75]
[74,null,null,6815.6,6369.55,4532.8250000000007,3906.3750000000005,2909.2250000000004]
[75,"o más",null,7431.3250000000007,6985.55,4957.4250000000002,4267.7250000000004,3174.6000000000004]
[1,"Hijo",null,466.95000000000005,276.375,233.75000000000003,201.85000000000002,149.05000000000001]
[2,"Hijos",null,796.40000000000009,414.70000000000005,371.8,318.72500000000002,233.75000000000003]
[3,"Hijos o más",null,1167.6500000000001,594.82500000000005,541.47500000000002,466.95000000000005,350.625]
[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]
[]
["ESSENTIAL CARE GUATEMALA"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,{"$f":"+C274*$L$3","v":379.77500000000003},{"$f":"+D274*$L$3","v":365.20000000000005},338.52500000000003,239.8,180.67500000000001,127.05000000000001]
[19,null,{"$f":"+C275*$L$3","v":386.92500000000001},372.07500000000005,345.125,244.20000000000002,180.67500000000001,131.17500000000001]
[20,null,{"$f":"+C276*$L$3","v":393.8},378.95000000000005,351.17500000000001,248.60000000000002,185.62500000000003,131.17500000000001]
[21,null,{"$f":"+C277*$L$3","v":400.95000000000005},385.55,357.50000000000006,253.00000000000003,190.02500000000001,135.85000000000002]
[22,null,{"$f":"+C278*$L$3","v":408.37500000000006},392.70000000000005,364.1,257.95000000000005,194.42500000000001,135.85000000000002]
[23,null,{"$f":"+C279*$L$3","v":414.97500000000002},399.02500000000003,369.87500000000006,262.07500000000005,194.42500000000001,140.80000000000001]
[24,null,{"$f":"+C280*$L$3","v":429.82500000000005},413.32500000000005,383.07500000000005,271.42500000000001,198.82500000000002,144.65]
[25,null,{"$f":"+C281*$L$3","v":436.70000000000005},419.92500000000001,389.40000000000003,275.82500000000005,203.77500000000001,144.65]
[26,null,{"$f":"+C282*$L$3","v":443.85},426.8,395.72500000000002,280.22500000000002,207.9,149.60000000000002]
[27,null,{"$f":"+C283*$L$3","v":451.55},434.22500000000002,402.32500000000005,284.90000000000003,212.57500000000002,149.60000000000002]
[28,null,{"$f":"+C284*$L$3","v":457.87500000000006},440.27500000000003,408.1,289.02500000000003,217.25000000000003,153.72500000000002]
[29,null,{"$f":"+C285*$L$3","v":472.45000000000005},454.3,421.3,298.375,221.65,158.125]
[30,null,{"$f":"+C286*$L$3","v":487.02500000000003},468.32500000000005,434.22500000000002,307.45000000000005,226.32500000000002,163.07500000000002]
[31,null,{"$f":"+C287*$L$3","v":494.45000000000005},475.47500000000002,440.82500000000005,312.125,230.72500000000002,163.07500000000002]
[32,null,{"$f":"+C288*$L$3","v":508.75000000000006},489.22500000000002,453.47500000000002,321.20000000000005,235.12500000000003,166.92500000000001]
[33,null,{"$f":"+C289*$L$3","v":522.77500000000009},502.70000000000005,466.12500000000006,330,239.8,171.875]
[34,null,{"$f":"+C290*$L$3","v":537.35},516.72500000000002,479.05,339.07500000000005,248.60000000000002,176.55]
[35,null,{"$f":"+C291*$L$3","v":551.1},529.92500000000007,491.42500000000001,347.875,253.00000000000003,180.67500000000001]
[36,null,{"$f":"+C292*$L$3","v":565.95000000000005},544.22500000000002,504.35,357.22500000000002,262.07500000000005,185.62500000000003]
[37,null,{"$f":"+C293*$L$3","v":579.97500000000002},557.70000000000005,517,366.02500000000003,266.47500000000002,190.02500000000001]
[38,null,{"$f":"+C294*$L$3","v":601.97500000000002},578.875,536.52500000000009,380.05,275.82500000000005,194.42500000000001]
[39,null,{"$f":"+C295*$L$3","v":622.875},598.95000000000005,555.22500000000002,393.25000000000006,284.90000000000003,198.82500000000002]
[40,null,{"$f":"+C296*$L$3","v":637.45000000000005},612.97500000000002,568.42500000000007,402.32500000000005,289.02500000000003,203.77500000000001]
[41,null,{"$f":"+C297*$L$3","v":658.90000000000009},633.6,587.40000000000009,415.8,298.375,207.9]
[42,null,{"$f":"+C298*$L$3","v":680.07500000000005},653.95000000000005,606.1,429.27500000000003,307.45000000000005,212.57500000000002]
[43,null,{"$f":"+C299*$L$3","v":701.25},674.57500000000005,625.35,442.75000000000006,316.25,221.65]
[44,null,{"$f":"+C300*$L$3","v":729.85},702.07500000000005,650.65000000000009,460.90000000000003,325.60000000000002,226.32500000000002]
[45,null,{"$f":"+C301*$L$3","v":751.30000000000007},722.42500000000007,669.90000000000009,474.37500000000006,334.95000000000005,235.12500000000003]
[46,null,{"$f":"+C302*$L$3","v":773.02500000000009},743.32500000000005,689.15000000000009,487.85,343.47500000000002,239.8]
[47,null,{"$f":"+C303*$L$3","v":801.62500000000011},770.82500000000005,714.72500000000002,506.00000000000006,352.55,244.20000000000002]
[48,null,{"$f":"+C304*$L$3","v":837.37500000000011},805.47500000000002,746.62500000000011,528.55000000000007,366.02500000000003,253.00000000000003]
[49,null,{"$f":"+C305*$L$3","v":866.25000000000011},833.25000000000011,772.2,546.97500000000002,380.05,262.07500000000005]
[50,null,{"$f":"+C306*$L$3","v":901.72500000000002},867.35,804.1,569.25,393.25000000000006,266.47500000000002]
[51,null,{"$f":"+C307*$L$3","v":938.02500000000009},902.00000000000011,836.27500000000009,592.07500000000005,406.72500000000002,275.82500000000005]
[52,null,{"$f":"+C308*$L$3","v":966.35},929.22500000000002,861.57500000000005,609.95000000000005,420.20000000000005,284.90000000000003]
[53,null,{"$f":"+C309*$L$3","v":1008.9750000000001},970.47500000000002,899.52500000000009,636.90000000000009,434.22500000000002,293.97500000000002]
[54,null,{"$f":"+C310*$L$3","v":1052.4250000000002},1012.0000000000001,938.30000000000007,664.40000000000009,451.55,298.375]
[55,null,{"$f":"+C311*$L$3","v":1094.7750000000001},1052.9750000000001,975.97500000000002,691.07500000000005,465.3,307.45000000000005]
[56,null,{"$f":"+C312*$L$3","v":1138.2250000000001},1094.5,1014.7500000000001,718.57500000000005,483.45000000000005,316.25]
[57,null,{"$f":"+C313*$L$3","v":1180.575},1135.4750000000001,1052.4250000000002,745.25000000000011,501.6,325.60000000000002]
[58,null,{"$f":"+C314*$L$3","v":1245.4750000000001},1197.625,1110.1750000000002,786.22500000000002,519.75,334.95000000000005]
[59,null,{"$f":"+C315*$L$3","v":1302.6750000000002},1252.625,1161.325,822.25000000000011,542.02500000000009,343.47500000000002]
[60,null,{"$f":"+C316*$L$3","v":1359.6000000000001},1307.3500000000001,1211.9250000000002,858.27500000000009,564.85,357.22500000000002]
[61,null,{"$f":"+C317*$L$3","v":1438.5250000000001},1383.5250000000001,1282.6000000000001,908.05000000000007,592.07500000000005,366.02500000000003]
[62,null,{"$f":"+C318*$L$3","v":1545.7750000000001},1486.65,1378.0250000000001,975.7,632.77500000000009,383.90000000000003]
[63,null,{"$f":"+C319*$L$3","v":1696.4750000000001},1631.3000000000002,1512.2250000000001,1070.8500000000001,691.07500000000005,402.32500000000005]
[64,null,{"$f":"+C320*$L$3","v":1903.5500000000002},1830.6750000000002,1697.0250000000001,1201.4750000000001,772.75000000000011,429.27500000000003]
[65,null,{"$f":"+C321*$L$3","v":2168.375},2085.3250000000003,1933.2500000000002,1368.6750000000002,876.42500000000007,469.97500000000002]
[66,null,{"$f":"+C322*$L$3","v":2490.4},2394.9750000000004,2220.0750000000003,1571.9,998.52500000000009,519.75]
[67,null,{"$f":"+C323*$L$3","v":2862.7500000000005},2753.0250000000001,2552,1807.0250000000001,1138.5,587.40000000000009]
[68,null,{"$f":"+C324*$L$3","v":3256.0000000000005},3131.15,2902.6250000000005,2055.0750000000003,1291.95,659.72500000000002]
[69,null,{"$f":"+C325*$L$3","v":3670.7000000000003},3530.1750000000002,3272.5000000000005,2317.15,1454.4750000000001,741.12500000000011]
[70,null,{"$f":"+C326*$L$3","v":4114.2750000000005},3956.7000000000003,3667.9500000000003,2597.1000000000004,1635.4250000000002,826.92500000000007]
[71,null,{"$f":"+C327*$L$3","v":4579.5750000000007},4404.125,4082.6500000000005,2890.5250000000001,1824.6250000000002,917.12500000000011]
[72,null,{"$f":"+C328*$L$3","v":5066.05},4871.9000000000005,4516.3250000000007,3197.7000000000003,2027.8500000000001,1012.0000000000001]
[73,null,{"$f":"+C329*$L$3","v":5581.4000000000005},5367.7250000000004,4975.8500000000004,3523.0250000000001,2244.8250000000003,1111.5500000000002]
[74,null,{"$f":"+C330*$L$3","v":6117.9250000000002},5883.6250000000009,5454.0750000000007,3861.8250000000003,2475.2750000000001,1210.5500000000002]
[75,null,{"$f":"+C331*$L$3","v":6675.9000000000005},6420.1500000000005,5951.55,4213.8250000000007,2719.2000000000003,1314.5]
[76,null,{"$f":"+C332*$L$3","v":7255.6},6977.85,6468.55,4579.8500000000004,2976.6000000000004,1422.8500000000001]
[77,null,{"$f":"+C333*$L$3","v":7856.2000000000007},7555.6250000000009,7003.9750000000004,4959.0750000000007,3247.4750000000004,1535.6000000000001]
[78,null,{"$f":"+C334*$L$3","v":8486.2250000000004},8161.1750000000011,7565.5250000000005,5356.4500000000007,3532.1000000000004,1648.9]
[79,null,{"$f":"+C335*$L$3","v":9137.1500000000015},8787.35,8145.7750000000005,5767.3,3825.5250000000001,1770.7250000000001]
[80,"o mas",{"$f":"+C336*$L$3","v":9810.0750000000007},9434.4250000000011,8745.5500000000011,6192.1750000000002,4137.375,1888.4250000000002]
[1,"Hijo",{"$f":"+C337*$L$3","v":164.72500000000002},158.4,146.85000000000002,103.95,86.9,68.475000000000009]
[2,"Hijos",{"$f":"+C338*$L$3","v":258.22500000000002},248.32500000000002,230.17500000000001,163.07500000000002,135.85000000000002,107.25000000000001]
[3,"Hijos o más",{"$f":"+C339*$L$3","v":372.35},358.05,331.92500000000001,235.12500000000003,196.07500000000002,154.55000000000001]
[1,"Rider Comp. Maternidad",{"$f":"+C340*$L$3","v":61.875000000000007},61.875000000000007,61.875000000000007,0,0,0]
[1,"Transplante de organos",{"$f":"+C341*$L$3","v":82.5},82.5,82.5,82.5,82.5,82.5]
[null,"Deductible Waiver",{"$f":"+C342*$L$3","v":0},49.500000000000007,94.875000000000014,213.12500000000003,365.75000000000006,572]
[null,null,{"$f":"+C343*$L$3","v":0},0,0,0,0,0]
["BUPA CLASSIC CARE GUATEMALA"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,null,{"$f":"D487*$L$3","v":707.09375000000011},{"$f":"E487*$L$3","v":547.91},358.10500000000002,262.73500000000001,184.66250000000002]
[19,null,null,{"$f":"D488*$L$3","v":721.11875000000009},554.92250000000001,364.88375000000002,262.73500000000001,190.50625000000002]
[20,null,null,{"$f":"D489*$L$3","v":727.66374999999994},568.48,371.66250000000002,269.7475,190.50625000000002]
[21,null,null,{"$f":"D490*$L$3","v":741.68875000000003},583.20625000000007,378.20750000000004,276.29250000000002,197.51875000000001]
[22,null,null,{"$f":"D491*$L$3","v":756.18125000000009},596.76374999999996,385.22,282.83750000000003,197.51875000000001]
[23,null,null,{"$f":"D492*$L$3","v":762.72624999999994},603.07500000000005,391.29750000000001,282.83750000000003,204.53125000000003]
[24,null,null,{"$f":"D493*$L$3","v":776.28375000000005},617.5675,405.32249999999999,289.14875000000006,210.37500000000003]
[25,null,null,{"$f":"D494*$L$3","v":790.54250000000002},631.125,411.86750000000006,296.16125000000005,210.37500000000003]
[26,null,null,{"$f":"D495*$L$3","v":804.5675},644.9162500000001,418.64625000000001,302.23875000000004,217.38750000000002]
[27,null,null,{"$f":"D496*$L$3","v":811.11250000000007},658.47375,425.89250000000004,309.01750000000004,217.38750000000002]
[28,null,null,{"$f":"D497*$L$3","v":831.6825},672.73249999999996,431.97,315.5625,223.46500000000003]
[29,null,null,{"$f":"D498*$L$3","v":845.70749999999998},686.52374999999995,445.52750000000003,321.87375000000003,229.77625]
[30,null,null,{"$f":"D499*$L$3","v":866.745},707.09375000000011,459.31875000000002,328.88625000000002,237.02250000000001]
[31,null,null,{"$f":"D500*$L$3","v":880.30250000000001},721.11875000000009,466.33125000000001,335.66500000000002,237.02250000000001]
[32,null,null,{"$f":"D501*$L$3","v":901.10625000000005},741.68875000000003,479.65500000000003,341.74250000000006,242.63249999999999]
[33,null,null,{"$f":"D502*$L$3","v":922.14375000000007},762.72624999999994,492.97874999999999,348.52125000000001,250.11250000000001]
[34,null,null,{"$f":"D503*$L$3","v":942.9475000000001},783.99750000000006,506.53625000000005,361.61125000000004,256.65750000000003]
[35,null,null,{"$f":"D504*$L$3","v":970.99750000000006},804.5675,519.86,367.92250000000001,262.73500000000001]
[36,null,null,{"$f":"D505*$L$3","v":991.33375000000001},825.37125000000003,533.65125,380.77875,269.7475]
[37,null,null,{"$f":"D506*$L$3","v":1012.1375},845.70749999999998,546.97500000000002,387.5575,276.29250000000002]
[38,null,null,{"$f":"D507*$L$3","v":1039.9537500000001},873.52375000000006,567.77875000000006,400.64749999999998,282.83750000000003]
[39,null,null,{"$f":"D508*$L$3","v":1067.77},901.10625000000005,587.17999999999995,414.43875000000003,289.14875000000006]
[40,null,null,{"$f":"D509*$L$3","v":1102.365},922.14375000000007,601.20500000000004,420.28250000000003,296.16125000000005]
[41,null,null,{"$f":"D510*$L$3","v":1129.7137500000001},950.42750000000001,621.3075,433.60625000000005,302.23875000000004]
[42,null,null,{"$f":"D511*$L$3","v":1157.7637500000001},977.30875000000003,641.17624999999998,446.93000000000006,309.01750000000004]
[43,null,null,{"$f":"D512*$L$3","v":1192.5925},1012.1375,661.51250000000005,459.78625000000005,321.87375000000003]
[44,null,null,{"$f":"D513*$L$3","v":1227.1875},1039.9537500000001,688.39375000000007,473.34375000000006,328.88625000000002]
[45,null,null,{"$f":"D514*$L$3","v":1261.5487500000002},1074.5487499999999,708.49625000000003,486.90125,341.74250000000006]
[46,null,null,{"$f":"D515*$L$3","v":1296.6112500000002},1109.3775000000001,728.83249999999998,499.52375000000006,348.52125000000001]
[47,null,null,{"$f":"D516*$L$3","v":1330.9725000000001},1137.1937500000001,755.9475000000001,512.61374999999998,355.06624999999997]
[48,null,null,{"$f":"D517*$L$3","v":1386.3712499999999},1185.3462500000001,789.60749999999996,532.24875000000009,367.92250000000001]
[49,null,null,{"$f":"D518*$L$3","v":1434.7575000000002},1227.1875,816.95625000000007,552.58500000000004,380.77875]
[50,null,null,{"$f":"D519*$L$3","v":1483.6112500000002},1268.7950000000001,850.61625000000015,571.51875000000007,387.5575]
[51,null,null,{"$f":"D520*$L$3","v":1531.7637500000001},1316.7137500000001,884.5100000000001,591.38750000000005,400.64749999999998]
[52,null,null,{"$f":"D521*$L$3","v":1580.38375},1358.5550000000001,911.39125000000013,611.02250000000004,414.43875000000003]
[53,null,null,{"$f":"D522*$L$3","v":1643.0287499999999},1413.9537500000001,951.59625000000005,630.89125000000013,427.29500000000002]
[54,null,null,{"$f":"D523*$L$3","v":1705.2062500000002},1469.8200000000002,992.50250000000005,656.37,433.60625000000005]
[55,null,null,{"$f":"D524*$L$3","v":1767.6175000000001},1525.4524999999999,1032.4737500000001,676.47250000000008,446.93000000000006]
[56,null,null,{"$f":"D525*$L$3","v":1829.7950000000003},1580.38375,1073.14625,702.65250000000003,459.78625000000005]
[57,null,null,{"$f":"D526*$L$3","v":1892.44},1635.7825000000003,1113.585,729.30000000000007,473.34375000000006]
[58,null,null,{"$f":"D527*$L$3","v":1975.4212500000001},1705.2062500000002,1174.3599999999999,755.48,486.90125]
[59,null,null,{"$f":"D528*$L$3","v":2051.39},1773.92875,1228.35625,787.97125000000005,499.52375000000006]
[60,null,null,{"$f":"D529*$L$3","v":2135.0725000000002},1850.8325000000002,1282.1187500000001,821.16374999999994,519.15875000000005]
[61,null,null,{"$f":"D530*$L$3","v":2252.6487500000003},1947.605,1356.6849999999999,860.66750000000002,532.24875000000009]
[62,null,null,{"$f":"D531*$L$3","v":2405.05375},2085.7512500000003,1457.665,919.80625000000009,558.19500000000005]
[63,null,null,{"$f":"D532*$L$3","v":2633.4275000000002},2280.69875,1599.7850000000001,1004.6575,585.07624999999996]
[64,null,null,{"$f":"D533*$L$3","v":2945.2500000000005},2550.9137500000002,1794.9662499999999,1122.9350000000002,623.87875000000008]
[65,null,null,{"$f":"D534*$L$3","v":3347.5337500000005},2897.5650000000005,2044.8450000000003,1273.9375,683.25125000000003]
[66,null,null,{"$f":"D535*$L$3","v":3839.5775000000003},3333.7424999999998,2348.2525000000005,1451.1200000000001,755.48]
[67,null,null,{"$f":"D536*$L$3","v":4394.2662500000006},3825.085,2699.5787500000001,1654.95,853.65499999999997]
[68,null,null,{"$f":"D537*$L$3","v":4989.6274999999996},4359.2037500000006,3070.3062500000001,1878.1812500000001,958.84249999999997]
[69,null,null,{"$f":"D538*$L$3","v":5613.5062500000004},4920.6712500000003,3461.6037500000002,2114.0349999999999,1077.3537500000002]
[70,null,null,{"$f":"D539*$L$3","v":6257.9550000000008},5494.9949999999999,3879.5487499999999,2377.2375000000002,1201.9425000000001]
[71,null,null,{"$f":"D540*$L$3","v":6923.2075000000004},6097.8362500000003,4318.2975000000006,2652.3612499999999,1333.0762500000001]
[72,null,null,{"$f":"D541*$L$3","v":7608.5625000000009},6708.1575000000003,4777.1487500000003,2947.3537500000002,1470.9887500000002]
[73,null,null,{"$f":"D542*$L$3","v":8308.6437500000011},7338.5812500000002,5263.1149999999998,3262.9162500000002,1615.44625]
[74,null,null,{"$f":"D543*$L$3","v":9015.27},7983.2637500000001,5768.9500000000007,3597.88,1759.6700000000003]
[75,null,null,{"$f":"D544*$L$3","v":9742.7000000000007},8634.2574999999997,6295.1212500000001,3952.4787500000002,1910.9062500000002]
[76,null,null,{"$f":"D545*$L$3","v":10477.61},9299.276249999999,6841.8625000000002,4326.7125000000005,2068.2200000000003]
[77,null,null,{"$f":"D546*$L$3","v":11225.61},9971.307499999999,7408.2387500000004,4720.3474999999999,2232.0787500000001]
[78,null,null,{"$f":"D547*$L$3","v":11980.856250000001},10657.597500000002,8002.1975000000002,5133.8512500000006,2396.8724999999999]
[79,null,null,{"$f":"D548*$L$3","v":12743.5825},11343.653750000001,8616.0250000000015,5560.67875,2573.8212500000004]
[80,"o mas",null,{"$f":"D549*$L$3","v":13512.1525},12043.735000000001,9250.4225000000006,6013.6862500000007,2744.92625]
[1,"Hijo",null,{"$f":"D550*$L$3","v":360.67625000000004},208.505,155.44375000000002,111.96625,79.241249999999994]
[2,"Hijos",null,{"$f":"D551*$L$3","v":603.07500000000005},312.75749999999999,243.5675,171.57250000000002,118.74500000000002]
[3,"Hijos o más",null,{"$f":"D552*$L$3","v":887.54875000000004},450.90375,351.09250000000003,250.11250000000001,177.65]
[1,"Rider Comp. Maternidad",null,{"$f":"D553*$L$3","v":61.875000000000007},{"$f":"E553*$L$3","v":61.875000000000007},61.875000000000007,61.875000000000007,61.875000000000007]
[1,"Transplante de organos",null,{"$f":"D554*$L$3","v":82.5},82.5,82.5,82.5,82.5]
[null,"Deductible Waiver",null,{"$f":"D555*$L$3","v":49.500000000000007},94.875000000000014,213.12500000000003,365.75000000000006,572]