{"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 2023"]
["(Para nuevos negocios emitidos a partir del 1 de enero 2023 y renovaciones de pólizas emitidas a partir del 1 de abril 2018)"]
[null,null,null,null,null,null,null,null,null,null," "]
[]
["INGRESE LOS DATOS DEL PROPUESTO ASEGURADO:"]
[]
[null,null,"Nombre del Asegurado Principal:","Nombre"]
[null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,"Número de Adultos:",null,null,2,"Número de Hijos:",null,2]
[]
[null,null,null,null,null," Edad de Titular:",32,"Edad de Cónyuge:",null,46]
[]
[null,null,null,null,null,"Descuento:",0]
[]
[]
["INGRESE EL NOMBRE DE LA AGENCIA ASESORA:"]
[]
[null,null,"Intermediario:","Agente / Agencia"]
[]
[]
[]
["ESCOJA EL PRODUCTO PARA VISUALIZAR LA COTIZACION RESPECTIVA:"]

{"sheet":"Complete","index":1,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":true,"merged":[[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],[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]]}
["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":"2022-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G20>0,'INGRESO DE DATOS'!G20,\"\")","v":""}]
["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":32}]
["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":2},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
["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":8094},{"$f":"VLOOKUP($J$12,Tablas!$A$6:$H$29,5,TRUE)","v":6019},{"$f":"VLOOKUP($J$12,Tablas!$A$6:$H$29,6,TRUE)","v":4504},{"$f":"VLOOKUP($J$12,Tablas!$A$6:$H$29,7,TRUE)","v":3442},{"$f":"VLOOKUP($J$12,Tablas!$A$6:$H$29,8,TRUE)","v":2633}]
["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":11736},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$6:$H$29,5,TRUE)))","v":8246},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$6:$H$29,6,TRUE)))","v":6272},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$6:$H$29,7,TRUE)))","v":4756},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$6:$H$29,8,TRUE)))","v":3643}]
["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":6424},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$30:$H$32,5,TRUE)))","v":2985},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$30:$H$32,6,TRUE)))","v":2329},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$30:$H$32,7,TRUE)))","v":1973},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$30:$H$32,8,TRUE)))","v":1469}]
["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":26254},{"$f":"SUM(G24:G27)","v":17250},{"$f":"SUM(H24:H27)","v":13105},{"$f":"SUM(I24:I27)","v":10171},{"$f":"SUM(J24:J27)","v":7745}]
["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":3159.48},{"$f":"+(G28+G29+G30)*12%","v":2079},1581.6,1229.52,{"$f":"+(J28+J29+J30)*12%","v":938.4}]
["Viaje de regreso (Asegurado y 1 acompañante)",1,null,"TOTAL","n/a",{"$f":"SUM(F28:F31)","v":29488.48},{"$f":"SUM(G28:G31)","v":19404},14761.6,11475.52,{"$f":"SUM(J28:J31)","v":8758.4}]
["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":3563.19},{"$f":"VLOOKUP($J$12,Tablas!$A$39:$H$62,5,TRUE)","v":2650},{"$f":"VLOOKUP($J$12,Tablas!$A$39:$H$62,6,TRUE)","v":1982.73},{"$f":"VLOOKUP($J$12,Tablas!$A$39:$H$62,7,TRUE)","v":1514.74},{"$f":"VLOOKUP($J$12,Tablas!$A$39:$H$62,8,TRUE)","v":1158.5800000000002}]
["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":5166.97},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$39:$H$62,5,TRUE)))","v":3629.9700000000003},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$39:$H$62,6,TRUE)))","v":2761.3},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$39:$H$62,7,TRUE)))","v":2093.5},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$39:$H$62,8,TRUE)))","v":1603.78}]
["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":1803.0600000000002},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,5,TRUE)))","v":1313.8700000000001},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,6,TRUE)))","v":1025.02},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,7,TRUE)))","v":868.1400000000001},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,8,TRUE)))","v":646.07000000000005}]
["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":10533.22},{"$f":"SUM(G35:G38)","v":7593.84},{"$f":"SUM(H35:H38)","v":5769.0500000000011},{"$f":"SUM(I35:I38)","v":4476.38},{"$f":"SUM(J35:J38)","v":3408.4300000000003}]
["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":1272.9863999999998},{"$f":"+(G39+G40+G41)*12%","v":920.26080000000002},701.28600000000006,546.16560000000004,{"$f":"+(J39+J40+J41)*12%","v":418.01160000000004}]
["Tratamientos especiales",1,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F39:F42)","v":11881.206399999999},{"$f":"SUM(G39:G42)","v":8589.1008000000002},{"$f":"SUM(H39:H42)","v":6545.3360000000011},{"$f":"SUM(I39:I42)","v":5097.5456000000004},{"$f":"SUM(J39:J42)","v":3901.4416000000001}]
["Sala de emergencias",1,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F39+F40+F42-(F41*0.12)","v":11797.206399999999},{"$f":"G39+G40+G42-(G41*0.12)","v":8505.1008000000002},6461.3360000000011,5013.5456000000004,{"$f":"J39+J40+J42-(J41*0.12)","v":3817.4416000000001}]
["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":2225.8500000000004},{"$f":"VLOOKUP($J$12,Tablas!$A$923:$H$946,5,TRUE)","v":1655.2250000000001},{"$f":"VLOOKUP($J$12,Tablas!$A$923:$H$946,6,TRUE)","v":1238.6000000000001},{"$f":"VLOOKUP($J$12,Tablas!$A$923:$H$946,7,TRUE)","v":946.55000000000007},{"$f":"VLOOKUP($J$12,Tablas!$A$923:$H$946,8,TRUE)","v":724.07500000000005}]
["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":3227.4},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$923:$H$946,5,TRUE)))","v":2267.65},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$923:$H$946,6,TRUE)))","v":1724.8000000000002},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$923:$H$946,7,TRUE)))","v":1307.9000000000001},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$923:$H$946,8,TRUE)))","v":1001.825}]
["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":1766.6000000000001},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,5,TRUE)))","v":1313.8700000000001},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,6,TRUE)))","v":1025.02},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,7,TRUE)))","v":868.1400000000001},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$63:$H$65,8,TRUE)))","v":646.07000000000005}]
["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":7219.85},{"$f":"SUM(G47:G50)","v":5236.7449999999999},{"$f":"SUM(H47:H50)","v":3988.4200000000005},{"$f":"SUM(I47:I50)","v":3122.59},{"$f":"SUM(J47:J50)","v":2371.9700000000003}]
[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":875.38200000000006},{"$f":"+(G51+G52+G53)*12%","v":637.40940000000001},487.61040000000003,383.71080000000001,{"$f":"+(J51+J52+J53)*12%","v":293.63640000000004}]
["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":8170.232},{"$f":"SUM(G51:G54)","v":5949.1543999999994},{"$f":"SUM(H51:H54)","v":4551.0304000000006},{"$f":"SUM(I51:I54)","v":3581.3008},{"$f":"SUM(J51:J54)","v":2740.6064000000001}]
["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":8086.232},{"$f":"G51+G52+G54-(G53*0.12)","v":5865.1543999999994},4467.0304000000006,3497.3008,{"$f":"J51+J52+J54-(J53*0.12)","v":2656.6064000000001}]
[]
[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":[[5,4,5,9],[7,4,7,9],[63,3,65,9],[5,0,5,1],[69,3,69,9],[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]]}
["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":"2022-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G20>0,'INGRESO DE DATOS'!G20,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$18","v":32}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":2},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[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":4479},{"$f":"VLOOKUP($J$12,Tablas!$A$140:$H$163,5,TRUE)","v":3668},{"$f":"VLOOKUP($J$12,Tablas!$A$140:$H$163,6,TRUE)","v":2780},{"$f":"VLOOKUP($J$12,Tablas!$A$140:$H$163,7,TRUE)","v":2393},{"$f":"VLOOKUP($J$12,Tablas!$A$140:$H$163,8,TRUE)","v":1816}]
[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":6371},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$140:$H$163,5,TRUE)))","v":5520},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$140:$H$163,6,TRUE)))","v":4054},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$140:$H$163,7,TRUE)))","v":3514},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$140:$H$163,8,TRUE)))","v":2626}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$164:$H$166,4,TRUE)))","v":2896},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$164:$H$166,5,TRUE)))","v":1508},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$164:$H$166,6,TRUE)))","v":1352},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$164:$H$166,7,TRUE)))","v":1159},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$164:$H$166,8,TRUE)))","v":850}]
[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":13746},{"$f":"SUM(G26:G30)","v":10696},8186,7066,5292]
[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":1658.52},{"$f":"+(G31+G32+G33)*12%","v":1292.52},991.31999999999994,856.92,{"$f":"+(J31+J32+J33)*12%","v":644.04}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F31:F34)","v":15479.52},{"$f":"SUM(G31:G34)","v":12063.52},{"$f":"SUM(H31:H34)","v":9252.32},{"$f":"SUM(I31:I34)","v":7997.92},{"$f":"SUM(J31:J34)","v":6011.04}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$12,Tablas!$A$173:$H$196,4,TRUE)","v":1971.6000000000001},{"$f":"VLOOKUP($J$12,Tablas!$A$173:$H$196,5,TRUE)","v":1614.38},{"$f":"VLOOKUP($J$12,Tablas!$A$173:$H$196,6,TRUE)","v":1223.77},{"$f":"VLOOKUP($J$12,Tablas!$A$173:$H$196,7,TRUE)","v":1053.1100000000001},{"$f":"VLOOKUP($J$12,Tablas!$A$173:$H$196,8,TRUE)","v":799.24}]
[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":2804.76},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$173:$H$196,5,TRUE)))","v":2430.0500000000002},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$173:$H$196,6,TRUE)))","v":1784.51},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$173:$H$196,7,TRUE)))","v":1546.5400000000002},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$173:$H$196,8,TRUE)))","v":1155.93}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$197:$H$199,4,TRUE)))","v":1274.6500000000001},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$197:$H$199,5,TRUE)))","v":663.56000000000006},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$197:$H$199,6,TRUE)))","v":594.66000000000008},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$197:$H$199,7,TRUE)))","v":509.86},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$197:$H$199,8,TRUE)))","v":373.65000000000003}]
[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":6051.01},{"$f":"SUM(G38:G42)","v":4707.9900000000007},3602.9399999999996,3109.5100000000007,2328.8200000000002]
[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":735.12120000000004},{"$f":"+(G43+G44+G45)*12%","v":573.95880000000011},441.35279999999995,382.14120000000008,{"$f":"+(J43+J44+J45)*12%","v":288.45839999999998}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F43:F46)","v":6861.1311999999998},{"$f":"SUM(G43:G46)","v":5356.948800000001},{"$f":"SUM(H43:H46)","v":4119.2927999999993},{"$f":"SUM(I43:I46)","v":3566.6512000000007},{"$f":"SUM(J43:J46)","v":2692.2784000000001}]
[null,null,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F43+F44+F46-(F45*0.12)","v":6777.1311999999998},{"$f":"G43+G44+G46-(G45*0.12)","v":5272.948800000001},4035.2927999999997,3482.6512000000007,2608.2784000000001]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$12,Tablas!$A$957:$H$980,4,TRUE)","v":1231.7250000000001},{"$f":"VLOOKUP($J$12,Tablas!$A$957:$H$980,5,TRUE)","v":1008.7},{"$f":"VLOOKUP($J$12,Tablas!$A$957:$H$980,6,TRUE)","v":764.50000000000011},{"$f":"VLOOKUP($J$12,Tablas!$A$957:$H$980,7,TRUE)","v":658.07500000000005},{"$f":"VLOOKUP($J$12,Tablas!$A$957:$H$980,8,TRUE)","v":499.40000000000003}]
[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":1752.0250000000001},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$957:$H$980,5,TRUE)))","v":1518.0000000000002},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$957:$H$980,6,TRUE)))","v":1114.8500000000001},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$957:$H$980,7,TRUE)))","v":966.35},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$957:$H$980,8,TRUE)))","v":722.15000000000009}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$981:$H$983,4,TRUE)))","v":796.40000000000009},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$981:$H$983,5,TRUE)))","v":414.70000000000005},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$981:$H$983,6,TRUE)))","v":371.8},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$981:$H$983,7,TRUE)))","v":318.72500000000002},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$981:$H$983,8,TRUE)))","v":233.75000000000003}]
[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":3780.15},{"$f":"SUM(G51:G55)","v":2941.4000000000005},2251.1500000000005,1943.15,1455.3000000000002]
[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":462.61799999999999},{"$f":"+(G56+G57+G58)*12%","v":361.96800000000007},279.13800000000003,242.178,{"$f":"+(J56+J57+J58)*12%","v":183.63600000000002}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F56:F59)","v":4317.768},{"$f":"SUM(G56:G59)","v":3378.3680000000004},{"$f":"SUM(H56:H59)","v":2605.2880000000005},{"$f":"SUM(I56:I59)","v":2260.328},{"$f":"SUM(J56:J59)","v":1713.9360000000001}]
[null,null,null,"TOTAL  (2da a 4ta Cuota)","n/a",{"$f":"F56+F57+F59-(F58*0.12)","v":4233.768},{"$f":"G56+G57+G59-(G58*0.12)","v":3294.3680000000004},2521.2880000000005,2176.328,1629.9360000000001]
[]
[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":[[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
["Bupa Advantage Care (cobertura solo en Latinoamérica)",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$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":32}]
["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":"2022-12-20T16:06:35.490"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[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":4550},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,5,TRUE)","v":3480},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,6,TRUE)","v":2690},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,7,TRUE)","v":2059},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,8,TRUE)","v":1587}]
[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":6617},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,5,TRUE)))","v":5063},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,6,TRUE)))","v":3827},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,7,TRUE)))","v":2988},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,8,TRUE)))","v":2317}]
["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":2567},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,5,TRUE)))","v":1768},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,6,TRUE)))","v":1402},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,7,TRUE)))","v":1246},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,8,TRUE)))","v":837}]
["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":14259},10836,8444,6818,5266]
["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":14334},{"$f":"SUM(J36:J37)","v":10911},{"$f":"SUM(K36:K37)","v":8519},{"$f":"SUM(L36:L37)","v":6893},{"$f":"SUM(M36:M37)","v":5341}]
["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":2411.5},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,5,TRUE)","v":1844.4},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,6,TRUE)","v":1425.7},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,7,TRUE)","v":1091.27},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,8,TRUE)","v":841.11}]
["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":3507.01},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,5,TRUE)))","v":2683.3900000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,6,TRUE)))","v":2028.3100000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,7,TRUE)))","v":1583.64},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,8,TRUE)))","v":1228.01}]
["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":1360.51},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,5,TRUE)))","v":937.04000000000008},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,6,TRUE)))","v":743.06000000000006},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,7,TRUE)))","v":660.38},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,8,TRUE)))","v":443.61}]
["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":7557.27},5743.0800000000008,4475.3200000000006,3613.54,2790.98]
[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":7632.27},{"$f":"SUM(J46:J47)","v":5818.0800000000008},{"$f":"SUM(K46:K47)","v":4550.3200000000006},{"$f":"SUM(L46:L47)","v":3688.54},{"$f":"SUM(M46:M47)","v":2865.98}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":7557.27},{"$f":"J46","v":5743.0800000000008},4475.3200000000006,3613.54,2790.98]
[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":[[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],[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],[83,3,83,9],[84,3,84,9],[85,3,85,9],[77,3,79,9],[76,3,76,9]]}
[]
[]
[]
[]
[]
[]
[]
[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":"2022-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G20>0,'INGRESO DE DATOS'!G20,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$18","v":32}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":2},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[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":3473.95},{"$f":"VLOOKUP($J$17,Tablas!$A$487:$H$549,5,TRUE)","v":2859.4},{"$f":"VLOOKUP($J$17,Tablas!$A$487:$H$549,6,TRUE)","v":1849.6},{"$f":"VLOOKUP($J$17,Tablas!$A$487:$H$549,7,TRUE)","v":1317.5},{"$f":"VLOOKUP($J$17,Tablas!$A$487:$H$549,8,TRUE)","v":935.85}]
[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":4998},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$487:$H$549,5,TRUE)))","v":4276.3499999999995},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$487:$H$549,6,TRUE)))","v":2810.1},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$487:$H$549,7,TRUE)))","v":1926.1},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$487:$H$549,8,TRUE)))","v":1343.85}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$550:$H$552,4,TRUE)))","v":2324.75},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$550:$H$552,5,TRUE)))","v":1206.1499999999999},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$550:$H$552,6,TRUE)))","v":939.25},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$550:$H$552,7,TRUE)))","v":662.15},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$550:$H$552,8,TRUE)))","v":458.15}]
[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":10796.7},{"$f":"SUM(G33:G38)","v":8341.9},5598.95,3905.75,2737.85]
[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":1304.604},{"$f":"+(G39+G40+G41)*12%","v":1010.0279999999999},680.87399999999991,477.69,{"$f":"+(J39+J40+J41)*12%","v":337.54199999999997}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F39:F42)","v":12176.304},{"$f":"SUM(G39:G42)","v":9426.9279999999999},{"$f":"SUM(H39:H42)","v":6354.8239999999996},{"$f":"SUM(I39:I42)","v":4458.4399999999996},{"$f":"SUM(J39:J42)","v":3150.3919999999998}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$17,Tablas!$A$559:$H$621,4,TRUE)","v":1841.1935000000001},{"$f":"VLOOKUP($J$17,Tablas!$A$559:$H$621,5,TRUE)","v":1515.4820000000002},{"$f":"VLOOKUP($J$17,Tablas!$A$559:$H$621,6,TRUE)","v":980.28800000000001},{"$f":"VLOOKUP($J$17,Tablas!$A$559:$H$621,7,TRUE)","v":698.27500000000009},{"$f":"VLOOKUP($J$17,Tablas!$A$559:$H$621,8,TRUE)","v":496.00050000000005}]
[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":2648.94},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$559:$H$621,5,TRUE)))","v":2266.4654999999998},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$559:$H$621,6,TRUE)))","v":1489.3530000000001},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$559:$H$621,7,TRUE)))","v":1020.833},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$559:$H$621,8,TRUE)))","v":712.2405}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$622:$H$624,4,TRUE)))","v":1232.1175000000001},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$622:$H$624,5,TRUE)))","v":639.2595},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$622:$H$624,6,TRUE)))","v":497.80250000000001},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$622:$H$624,7,TRUE)))","v":350.93950000000001},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$622:$H$624,8,TRUE)))","v":242.81950000000001}]
[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":5722.2510000000002},{"$f":"SUM(G46:G51)","v":4421.2070000000003},2967.4435000000003,2070.0475000000001,1451.0605]
[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":695.67012},{"$f":"+(G52+G53+G54)*12%","v":539.54484000000002},365.09322000000003,257.40570000000002,{"$f":"+(J52+J53+J54)*12%","v":183.12726000000001}]
[null,null,null,"(1ra Cuota)","n/a",{"$f":"SUM(F52:F55)","v":6492.92112},{"$f":"SUM(G52:G55)","v":5035.7518400000008},{"$f":"SUM(H52:H55)","v":3407.5367200000005},{"$f":"SUM(I52:I55)","v":2402.4531999999999},{"$f":"SUM(J52:J55)","v":1709.18776}]
[null,null,null,"(2da Cuota)","n/a",{"$f":"F52+F53+F55-(F54*0.12)","v":6408.92112},{"$f":"G52+G53+G55-(G54*0.12)","v":4951.7518400000008},3323.5367200000005,2318.4531999999999,{"$f":"J52+J53+J55-(J54*0.12)","v":1625.18776}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F56:F57)","v":12901.84224},{"$f":"SUM(G56:G57)","v":9987.5036800000016},6731.073440000001,4720.9063999999998,3334.3755200000001]
[]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$17,Tablas!$A$1065:$H$1127,4,TRUE)","v":955.33625000000006},{"$f":"VLOOKUP($J$17,Tablas!$A$1065:$H$1127,5,TRUE)","v":786.33500000000004},{"$f":"VLOOKUP($J$17,Tablas!$A$1065:$H$1127,6,TRUE)","v":508.64000000000004},{"$f":"VLOOKUP($J$17,Tablas!$A$1065:$H$1127,7,TRUE)","v":362.31250000000006},{"$f":"VLOOKUP($J$17,Tablas!$A$1065:$H$1127,8,TRUE)","v":257.35875000000004}]
[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":1374.45},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1065:$H$1127,5,TRUE)))","v":1175.9962499999999},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1065:$H$1127,6,TRUE)))","v":772.77750000000003},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1065:$H$1127,7,TRUE)))","v":529.67750000000001},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$1065:$H$1127,8,TRUE)))","v":369.55875000000003}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1128:$H$1130,4,TRUE)))","v":639.30625000000009},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1128:$H$1130,5,TRUE)))","v":331.69124999999997},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1128:$H$1130,6,TRUE)))","v":258.29375000000005},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1128:$H$1130,7,TRUE)))","v":182.09125},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1128:$H$1130,8,TRUE)))","v":125.99125000000001}]
[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":2969.0925000000002},{"$f":"SUM(G62:G67)","v":2294.0225},1539.7112500000001,1074.08125,752.90875000000005]
[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":365.29110000000003},{"$f":"+(G68+G69+G70)*12%","v":284.28269999999998},193.76535000000001,137.88974999999999,{"$f":"+(J68+J69+J70)*12%","v":99.349050000000005}]
[null,null,null,"(1ra Cuota)","n/a",{"$f":"SUM(F68:F71)","v":3409.3836000000001},{"$f":"SUM(G68:G71)","v":2653.3051999999998},{"$f":"SUM(H68:H71)","v":1808.4766},{"$f":"SUM(I68:I71)","v":1286.971},{"$f":"SUM(J68:J71)","v":927.25780000000009}]
[null,null,null,"(2da a 4ta Cuota)","n/a",{"$f":"F68+F69+F71-(F70*0.12)","v":3325.3836000000001},{"$f":"G68+G69+G71-(G70*0.12)","v":2569.3051999999998},1724.4766,1202.971,{"$f":"J68+J69+J71-(J70*0.12)","v":843.25780000000009}]
[null,null,null,"TOTAL","n/a",{"$f":"F72+F73*3","v":13385.5344},{"$f":"G72+G73*3","v":10361.220799999999},6981.9063999999998,4895.884,3457.0312000000004]
[]
[]
[null,null,null,"Tarifas en US $ -   Efectivas partir del 1ro de enero de  2023"]
[null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[]
[]
[]
[null,null,null,"Bupa Guatemala, Compañía de Seguros, S.A."]
[null,null,null,"5 Avenida 5-55 Zona 14, Europlaza World Business Center, Torre 3, Nivel 11, Guatemala"]
[null,null,null,"PBX: 2300-8000 / www.bupasalud.com / servicioguatemala@bupalatinamerica.com"]

{"sheet":"Blue 500","index":5,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":true,"merged":[[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[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],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[35,2,40,3],[33,0,33,1],[34,0,34,1],[35,0,42,1],[41,2,42,3],[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]]}
[]
[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":32}]
["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":"2022-12-20T16:06:35.490"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[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":1727},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,5,TRUE)","v":1505},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,6,TRUE)","v":1371},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,7,TRUE)","v":1131},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,8,TRUE)","v":846}]
[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":2564},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,5,TRUE)))","v":2226},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,6,TRUE)))","v":2030},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,7,TRUE)))","v":1754},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,8,TRUE)))","v":1282}]
["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":1184},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,5,TRUE)))","v":1024},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,6,TRUE)))","v":935},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,7,TRUE)))","v":490},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,8,TRUE)))","v":436}]
["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":6000},5280,4861,3900,3089]
[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":720},{"$f":"J36*0.12","v":633.6},583.31999999999994,468,370.68]
[null,null,null,null,null,"GRAN TOTAL :",null,null,{"$f":"SUM(I36:I38)","v":6795},{"$f":"SUM(J36:J38)","v":5988.6},5519.32,4443,3534.68]
[]
[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":915.31000000000006},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,5,TRUE)","v":797.65000000000009},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,6,TRUE)","v":726.63},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,7,TRUE)","v":599.43000000000006},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,8,TRUE)","v":448.38}]
[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":1358.92},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,5,TRUE)))","v":1179.78},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,6,TRUE)))","v":1075.9000000000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,7,TRUE)))","v":929.62},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,8,TRUE)))","v":679.46}]
["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":627.52},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,5,TRUE)))","v":542.72},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,6,TRUE)))","v":495.55},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,7,TRUE)))","v":259.7},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,8,TRUE)))","v":231.08}]
["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":3180},2798.4,2576.3300000000004,2067,1637.17]
["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":381.59999999999997},{"$f":"J47*0.12","v":335.80799999999999},309.15960000000001,248.04,196.46039999999999]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,null,{"$f":"SUM(I47:I49)","v":3636.6},{"$f":"SUM(J47:J49)","v":3209.2080000000001},2960.4896000000003,2390.04,1908.6304]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,null,{"$f":"I47+I49","v":3561.6},{"$f":"J47+J49","v":3134.2080000000001},2885.4896000000003,2315.04,1833.6304]
[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":[[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],[14,0,14,1],[14,2,14,3],[15,0,15,1],[15,2,15,3],[16,0,16,1],[16,2,16,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],[20,0,21,1],[20,2,20,3],[21,2,21,3],[22,0,23,1],[22,2,22,3],[23,2,23,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],[27,0,27,1],[27,2,27,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,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],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[46,0,46,1],[46,2,46,3],[47,0,47,1],[47,2,47,3],[48,0,49,1],[48,2,49,3],[51,5,51,12]]}
[]
[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":32}]
["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":"2022-12-20T16:06:35.490"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[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":1392},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,5,TRUE)","v":1363},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,6,TRUE)","v":1285},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,7,TRUE)","v":1171},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,8,TRUE)","v":965}]
[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":2059},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$778:$H$840,5,TRUE)))","v":2018},{"$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":1735},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$778:$H$840,8,TRUE)))","v":1494}]
["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":949},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,5,TRUE)))","v":930},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,6,TRUE)))","v":877},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,7,TRUE)))","v":800},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,8,TRUE)))","v":416}]
["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":4925},4836,4406,4231,3400]
[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":591},{"$f":"J36*0.12","v":580.31999999999994},528.72,507.71999999999997,408]
[null,null,null,null,null,"GRAN TOTAL :",null,null,{"$f":"SUM(I36:I38)","v":5591},{"$f":"SUM(J36:J38)","v":5491.32},5009.72,4813.72,3883]
[]
[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":737.76},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,5,TRUE)","v":722.39},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,6,TRUE)","v":681.05000000000007},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,7,TRUE)","v":620.63},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,8,TRUE)","v":511.45000000000005}]
[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":1091.27},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,5,TRUE)))","v":1069.54},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,6,TRUE)))","v":1007.5300000000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,7,TRUE)))","v":919.55000000000007},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,8,TRUE)))","v":791.82}]
["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":502.97},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,5,TRUE)))","v":492.90000000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,6,TRUE)))","v":464.81},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,7,TRUE)))","v":424},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,8,TRUE)))","v":220.48000000000002}]
["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":2610.25},2563.08,2431.6400000000003,2242.4300000000003,1802]
["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":313.22999999999996},{"$f":"J47*0.12","v":307.56959999999998},291.79680000000002,269.09160000000003,216.23999999999998]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,null,{"$f":"SUM(I47:I49)","v":2998.48},{"$f":"SUM(J47:J49)","v":2945.6495999999997},2798.4368000000004,2586.5216000000005,2093.2399999999998]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,null,{"$f":"I47+I49","v":2923.48},{"$f":"J47+J49","v":2870.6495999999997},2723.4368000000004,2511.5216000000005,2018.24]
[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":[[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],[10,0,10,1],[16,0,16,1],[22,0,22,1],[9,0,9,1],[69,0,69,1],[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]]}
[]
[]
[]
[]
[]
[]
[]
[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":"2022-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G20>0,'INGRESO DE DATOS'!G20,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$18","v":32}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":2},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,"Complicaciones de Maternidad (planes 1, 2, y 3)"]
[null,null,null,null,null,true]
[null,null,null,null,null,true,null,"Trasplante de Órganos"]
[null,null,null,null,null,false]
[null,null,null," ",null,null,null,"Eliminación de Deducible"]
[null,null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,"Dentro del pais de residencia",250,250,1000,5000,10000,20000]
[null,null,null,"Fuera del pais de residencia",1000,5000,10000,5000,10000,20000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular",{"$f":"VLOOKUP($J$17,Tablas!$A$274:$H$336,3,TRUE)","v":1961},{"$f":"VLOOKUP($J$17,Tablas!$A$274:$H$336,4,TRUE)","v":1886},{"$f":"VLOOKUP($J$17,Tablas!$A$274:$H$336,5,TRUE)","v":1748},{"$f":"VLOOKUP($J$17,Tablas!$A$274:$H$336,6,TRUE)","v":1239},{"$f":"VLOOKUP($J$17,Tablas!$A$274:$H$336,7,TRUE)","v":907},{"$f":"VLOOKUP($J$17,Tablas!$A$274:$H$336,8,TRUE)","v":644}]
[null,null,null,"Prima Cónyuge",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,3,TRUE)))","v":2980},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,4,TRUE)))","v":2866},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,5,TRUE)))","v":2657},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,6,TRUE)))","v":1881},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,7,TRUE)))","v":1324},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$274:$H$336,8,TRUE)))","v":925}]
[null,null,null,"Primas Hijos",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,3,TRUE)))","v":996},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,4,TRUE)))","v":958},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,5,TRUE)))","v":888},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,6,TRUE)))","v":629},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,7,TRUE)))","v":524},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$337:$H$339,8,TRUE)))","v":414}]
[null,null,null,"Anexo: Complicaciones de Maternidad",{"$f":"+IF($F$22=FALSE,0,Tablas!C$340)","v":225},{"$f":"+IF($F$22=FALSE,0,Tablas!D$340)","v":225},{"$f":"+IF($F$22=FALSE,0,Tablas!E$340)","v":225},{"$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":300},{"$f":"IF($F$23=FALSE,0,Tablas!D$341)","v":300},{"$f":"IF($F$23=FALSE,0,Tablas!E$341)","v":300},{"$f":"IF($F$23=FALSE,0,Tablas!F$341)","v":300},{"$f":"IF($F$23=FALSE,0,Tablas!G$341)","v":300},{"$f":"IF($F$23=FALSE,0,Tablas!H$341)","v":300}]
[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":6462},6235,5818,4049,3055,2283]
[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":784.43999999999994},{"$f":"+(F38+F39+F40)*12%","v":757.19999999999993},{"$f":"+(G38+G39+G40)*12%","v":707.16},494.88,375.59999999999997,{"$f":"+(J38+J39+J40)*12%","v":282.95999999999998}]
[null,null,null,"TOTAL",{"$f":"SUM(E38:E41)","v":7321.44},7067.2,6600.16,4618.88,3505.6,2640.96]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular",{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,3,TRUE)","v":1039.3300000000002},{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,4,TRUE)","v":999.58},{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,5,TRUE)","v":926.44},{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,6,TRUE)","v":656.67000000000007},{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,7,TRUE)","v":480.71000000000004},{"$f":"VLOOKUP($J$17,Tablas!$A$346:$H$408,8,TRUE)","v":341.32}]
[null,null,null,"Prima Cónyuge",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,3,TRUE)))","v":1579.4},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,4,TRUE)))","v":1518.98},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,5,TRUE)))","v":1408.21},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,6,TRUE)))","v":996.93000000000006},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,7,TRUE)))","v":701.72},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$346:$H$408,8,TRUE)))","v":490.25}]
[null,null,null,"Primas Hijos",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,3,TRUE)))","v":527.88},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,4,TRUE)))","v":507.74},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,5,TRUE)))","v":470.64000000000004},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,6,TRUE)))","v":333.37},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,7,TRUE)))","v":277.72000000000003},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$409:$H$411,8,TRUE)))","v":219.42000000000002}]
[null,null,null,"Anexo: Complicaciones de Maternidad",{"$f":"+IF($F$22=FALSE,0,Tablas!C$412)","v":119.25},{"$f":"+IF($F$22=FALSE,0,Tablas!D$412)","v":119.25},{"$f":"+IF($F$22=FALSE,0,Tablas!E$412)","v":119.25},{"$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":159},{"$f":"IF($F$23=FALSE,0,Tablas!D$413)","v":159},{"$f":"IF($F$23=FALSE,0,Tablas!E$413)","v":159},{"$f":"IF($F$23=FALSE,0,Tablas!F$413)","v":159},{"$f":"IF($F$23=FALSE,0,Tablas!G$413)","v":159},{"$f":"IF($F$23=FALSE,0,Tablas!H$413)","v":159}]
[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":3424.8600000000006},{"$f":"SUM(F45:F50)","v":3304.55},{"$f":"SUM(G45:G50)","v":3083.54},2145.9700000000003,1619.15,1209.99]
[null,null,null,{"$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":419.98320000000007},{"$f":"+(F51+F52+F53)*12%","v":405.54599999999999},{"$f":"+(G51+G52+G53)*12%","v":379.02479999999997},{"$f":"+(H51+H52+H53)*12%","v":266.51640000000003},{"$f":"+(I51+I52+I53)*12%","v":203.298},{"$f":"+(J51+J52+J53)*12%","v":154.19880000000001}]
[null,null,null,"(1ra Cuota)",{"$f":"SUM(E51:E54)","v":3919.8432000000007},3785.096,3537.5648000000001,2487.4864000000002,1897.4480000000001,1439.1887999999999]
[null,null,null,"(2da Cuota)",{"$f":"E51+E52+E54-(E53*0.12)","v":3835.8432000000007},{"$f":"F51+F52+F54-(F53*0.12)","v":3701.096},{"$f":"G51+G52+G54-(G53*0.12)","v":3453.5648000000001},2403.4864000000002,1813.4480000000001,1355.1887999999999]
[null,null,null,"TOTAL",{"$f":"SUM(E55:E56)","v":7755.6864000000014},{"$f":"SUM(F55:F56)","v":7486.192},6991.1296000000002,4890.9728000000005,3710.8960000000002,2794.3775999999998]
[]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular",{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,3,TRUE)","v":539.27500000000009},{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,4,TRUE)","v":518.65000000000009},{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,5,TRUE)","v":480.70000000000005},{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,6,TRUE)","v":340.72500000000002},{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,7,TRUE)","v":249.42500000000001},{"$f":"VLOOKUP($J$17,Tablas!$A$991:$H$1053,8,TRUE)","v":177.10000000000002}]
[null,null,null,"Prima Cónyuge",{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,3,TRUE)))","v":819.50000000000011},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,4,TRUE)))","v":788.15000000000009},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,5,TRUE)))","v":730.67500000000007},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,6,TRUE)))","v":517.27500000000009},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,7,TRUE)))","v":364.1},{"$f":"IF($G$17=1,0,(VLOOKUP($J$19,Tablas!$A$991:$H$1053,8,TRUE)))","v":254.37500000000003}]
[null,null,null,"Primas Hijos",{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,3,TRUE)))","v":273.90000000000003},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,4,TRUE)))","v":263.45000000000005},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,5,TRUE)))","v":244.20000000000002},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,6,TRUE)))","v":172.97500000000002},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,7,TRUE)))","v":144.10000000000002},{"$f":"IF($G$19=0,0,(VLOOKUP($G$19,Tablas!$A$1054:$H$1056,8,TRUE)))","v":113.85000000000001}]
[null,null,null,"Anexo: Complicaciones de Maternidad",{"$f":"+IF($F$22=FALSE,0,Tablas!C$1057)","v":61.875000000000007},{"$f":"+IF($F$22=FALSE,0,Tablas!D$1057)","v":61.875000000000007},{"$f":"+IF($F$22=FALSE,0,Tablas!E$1057)","v":61.875000000000007},{"$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":82.5},{"$f":"IF($F$23=FALSE,0,Tablas!D$1058)","v":82.5},{"$f":"IF($F$23=FALSE,0,Tablas!E$1058)","v":82.5},{"$f":"IF($F$23=FALSE,0,Tablas!F$1058)","v":82.5},{"$f":"IF($F$23=FALSE,0,Tablas!G$1058)","v":82.5},{"$f":"IF($F$23=FALSE,0,Tablas!H$1058)","v":82.5}]
[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":1777.0500000000002},{"$f":"SUM(F61:F66)","v":1714.6250000000002},{"$f":"SUM(G61:G66)","v":1599.95},1113.4750000000001,840.12500000000011,627.82500000000005]
[null,null,null,{"$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":222.24600000000001},{"$f":"+(F67+F68+F69)*12%","v":214.75500000000002},{"$f":"+(G67+G68+G69)*12%","v":200.994},142.61700000000002,109.81500000000001,{"$f":"+(J67+J68+J69)*12%","v":84.338999999999999}]
[null,null,null,"(1ra Cuota)",{"$f":"SUM(E67:E70)","v":2074.2960000000003},2004.3800000000003,1875.944,1331.0920000000001,1024.94,787.16399999999999]
[null,null,null,"(2da a 4ta Cuota)",{"$f":"E67+E68+E70-(E69*0.12)","v":1990.2960000000003},{"$f":"F67+F68+F70-(F69*0.12)","v":1920.3800000000003},{"$f":"G67+G68+G70-(G69*0.12)","v":1791.944},1247.0920000000001,940.94000000000017,703.16399999999999]
[null,null,null,"TOTAL",{"$f":"E71+E72*3","v":8045.1840000000011},{"$f":"F71+F72*3","v":7765.5200000000013},7251.7759999999998,5072.3680000000004,3847.7600000000007,2896.6559999999999]
[]
[]
[null,null,null,"Tarifas en US $ -   Efectivas partir del 1ro de enero de  2023"]
[null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[]
[null,null,null,"Bupa Guatemala, Compañía de Seguros, S.A."]
[null,null,null,"5 Avenida 5-55 Zona 14, Europlaza World Business Center, Torre 3, Nivel 11, Guatemala"]
[null,null,null,"PBX: 2300-8000 / www.bupasalud.com / servicioguatemala@bupalatinamerica.com"]

{"sheet":"Resumen tarifas anuales","index":8,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[[16,3,16,8],[52,1,53,1],[56,2,56,8],[57,1,58,1],[63,2,64,8],[32,2,33,2],[48,1,48,2],[37,2,37,8],[38,2,39,8],[1,2,1,8],[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],[6,3,6,8],[8,3,8,8],[14,1,14,2],[13,1,13,2]]}
[]
[null,null,"Cotización de Seguro Médico Internacional - BUPA Guatemala"]
[]
[]
[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":"2022-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G20>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G20>0,'INGRESO DE DATOS'!G20,\"\")","v":""}]
[]
[null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$18","v":32}]
[]
[null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":2},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[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":12176.304},{"$f":"+Classic!G43","v":9426.9279999999999},{"$f":"+Classic!H43","v":6354.8239999999996},{"$f":"+Classic!I43","v":4458.4399999999996},{"$f":"+Classic!J43","v":3150.3919999999998}]
[]
[]
[null,null,"TARIFAS SEMIANUALES"]
[null,null,"Classic Care","1ra. Cuota",{"$f":"+Classic!$F$56","v":6492.92112},{"$f":"+Classic!$G$56","v":5035.7518400000008},{"$f":"+Classic!$H$56","v":3407.5367200000005},{"$f":"+Classic!$I$56","v":2402.4531999999999},{"$f":"+Classic!$J$56","v":1709.18776}]
[null,null,null,"2da. Cuota",{"$f":"+Classic!$F$57","v":6408.92112},{"$f":"+Classic!$G$57","v":4951.7518400000008},{"$f":"+Classic!$H$57","v":3323.5367200000005},{"$f":"+Classic!$I$57","v":2318.4531999999999},{"$f":"+Classic!$J$57","v":1625.18776}]
[null,null,null,"TOTAL",{"$f":"Classic!F58","v":12901.84224},{"$f":"Classic!G58","v":9987.5036800000016},{"$f":"Classic!H58","v":6731.073440000001},{"$f":"Classic!I58","v":4720.9063999999998},{"$f":"Classic!J58","v":3334.3755200000001}]
[]
[null,null,"TARIFAS TRIMESTRALES"]
[null,null,"Classic Care","1ra. Cuota",{"$f":"+Classic!$F$72","v":3409.3836000000001},{"$f":"+Classic!$G$72","v":2653.3051999999998},{"$f":"+Classic!$H$72","v":1808.4766},{"$f":"+Classic!$I$72","v":1286.971},{"$f":"+Classic!$J$72","v":927.25780000000009}]
[null,null,null,"2da. a 4ta. Cuota",{"$f":"+Classic!$F$73","v":3325.3836000000001},{"$f":"+Classic!$G$73","v":2569.3051999999998},{"$f":"+Classic!$H$73","v":1724.4766},{"$f":"+Classic!$I$73","v":1202.971},{"$f":"+Classic!$J$73","v":843.25780000000009}]
[null,null,null,"TOTAL",{"$f":"Classic!F74","v":13385.5344},{"$f":"Classic!G74","v":10361.220799999999},{"$f":"Classic!H74","v":6981.9063999999998},{"$f":"Classic!I74","v":4895.884},{"$f":"Classic!J74","v":3457.0312000000004}]
[]
[]
[null,null,"Tarifas en US $ -  Efectivas a partir del 1ro de enero de  2023"]
[null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[]
[null,null,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":7321.44},{"$f":"'Essential Care'!F42","v":7067.2},{"$f":"'Essential Care'!G42","v":6600.16},{"$f":"'Essential Care'!H42","v":4618.88},{"$f":"'Essential Care'!I42","v":3505.6},{"$f":"'Essential Care'!J42","v":2640.96}]
[]
[]
[null,null,"TARIFAS SEMIANUALES"]
[null,"Essential Care","1ra. Cuota",{"$f":"'Essential Care'!E55","v":3919.8432000000007},{"$f":"'Essential Care'!F55","v":3785.096},{"$f":"'Essential Care'!G55","v":3537.5648000000001},{"$f":"'Essential Care'!H55","v":2487.4864000000002},{"$f":"'Essential Care'!I55","v":1897.4480000000001},{"$f":"'Essential Care'!J55","v":1439.1887999999999}]
[null,null,"2da. Cuota",{"$f":"'Essential Care'!E56","v":3835.8432000000007},{"$f":"'Essential Care'!F56","v":3701.096},{"$f":"'Essential Care'!G56","v":3453.5648000000001},{"$f":"'Essential Care'!H56","v":2403.4864000000002},{"$f":"'Essential Care'!I56","v":1813.4480000000001},{"$f":"'Essential Care'!J56","v":1355.1887999999999}]
[null,null,"TOTAL",{"$f":"'Essential Care'!E57","v":7755.6864000000014},{"$f":"'Essential Care'!F57","v":7486.192},{"$f":"'Essential Care'!G57","v":6991.1296000000002},{"$f":"'Essential Care'!H57","v":4890.9728000000005},{"$f":"'Essential Care'!I57","v":3710.8960000000002},{"$f":"'Essential Care'!J57","v":2794.3775999999998}]
[]
[null,null,"TARIFAS TRIMESTRALES"]
[null,"Essential Care","1ra. Cuota",{"$f":"'Essential Care'!E71","v":2074.2960000000003},{"$f":"'Essential Care'!F71","v":2004.3800000000003},{"$f":"'Essential Care'!G71","v":1875.944},{"$f":"'Essential Care'!H71","v":1331.0920000000001},{"$f":"'Essential Care'!I71","v":1024.94},{"$f":"'Essential Care'!J71","v":787.16399999999999}]
[null,null,"2da. a 4ta. Cuota",{"$f":"'Essential Care'!E72","v":1990.2960000000003},{"$f":"'Essential Care'!F72","v":1920.3800000000003},{"$f":"'Essential Care'!G72","v":1791.944},{"$f":"'Essential Care'!H72","v":1247.0920000000001},{"$f":"'Essential Care'!I72","v":940.94000000000017},{"$f":"'Essential Care'!J72","v":703.16399999999999}]
[null,null,"TOTAL",{"$f":"'Essential Care'!E73","v":8045.1840000000011},{"$f":"'Essential Care'!F73","v":7765.5200000000013},{"$f":"'Essential Care'!G73","v":7251.7759999999998},{"$f":"'Essential Care'!H73","v":5072.3680000000004},{"$f":"'Essential Care'!I73","v":3847.7600000000007},{"$f":"'Essential Care'!J73","v":2896.6559999999999}]
[]
[]
[null,null,"Tarifas en US $ -  Efectivas a partir del 22 de julio de  2023"]
[null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[null,null,"Bupa Guatemala, Compañía de Seguros, S.A."]
[null,null,"5 Avenida 5-55 Zona 14, Europlaza World Business Center, Torre 3, Nivel 11, Guatemala"]
[null,null,"PBX: 2300-8000 / www.bupasalud.com / servicioguatemala@bupalatinamerica.com"]

{"sheet":"Tablas","index":9,"n_rows":1133,"n_cols":24,"rows_kept":1133,"cut":false,"hidden":true,"merged":[[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],[629,0,629,7],[630,0,630,1],[630,2,630,6],[701,0,701,7],[702,0,702,1],[702,2,702,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],[628,0,628,7],[482,0,482,7],[483,0,483,7],[484,0,484,1],[484,2,484,6],[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],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[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],[952,0,952,7],[953,0,953,7],[954,0,954,1],[954,2,954,6],[986,0,986,7],[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]]}
[]
["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,1464,1408,1305,925,697,490]
[19,null,1492,1435,1331,942,697,506]
[20,null,1518,1461,1354,959,716,506]
[21,null,1546,1487,1378,976,733,524]
[22,null,1575,1514,1404,995,750,524]
[23,null,1600,1539,1426,1011,750,543]
[24,null,1657,1594,1477,1047,767,558]
[25,null,1684,1619,1501,1064,786,558]
[26,null,1711,1646,1526,1081,802,577]
[27,null,1741,1674,1551,1099,820,577]
[28,null,1765,1698,1574,1115,838,593]
[29,null,1822,1752,1624,1151,855,610]
[30,null,1878,1806,1674,1186,873,629]
[31,null,1906,1833,1700,1204,890,629]
[32,null,1961,1886,1748,1239,907,644]
[33,null,2016,1938,1797,1272,925,663]
[34,null,2072,1992,1847,1307,959,681]
[35,null,2125,2043,1895,1341,976,697]
[36,null,2182,2098,1945,1377,1011,716]
[37,null,2236,2150,1993,1411,1028,733]
[38,null,2321,2232,2069,1465,1064,750]
[39,null,2401,2309,2141,1516,1099,767]
[40,null,2458,2363,2192,1551,1115,786]
[41,null,2540,2443,2265,1603,1151,802]
[42,null,2622,2521,2337,1655,1186,820]
[43,null,2703,2601,2411,1707,1219,855]
[44,null,2814,2707,2508,1777,1256,873]
[45,null,2896,2785,2583,1829,1292,907]
[46,null,2980,2866,2657,1881,1324,925]
[47,null,3090,2972,2755,1951,1359,942]
[48,null,3228,3105,2878,2038,1411,976]
[49,null,3339,3212,2977,2109,1465,1011]
[50,null,3476,3344,3100,2195,1516,1028]
[51,null,3616,3477,3224,2283,1568,1064]
[52,null,3725,3582,3321,2352,1620,1099]
[53,null,3890,3741,3468,2455,1674,1134]
[54,null,4057,3901,3617,2561,1741,1151]
[55,null,4220,4059,3762,2664,1794,1186]
[56,null,4388,4219,3912,2770,1864,1219]
[57,null,4551,4377,4057,2873,1934,1256]
[58,null,4801,4617,4280,3031,2004,1292]
[59,null,5022,4829,4477,3170,2090,1324]
[60,null,5241,5040,4672,3309,2178,1377]
[61,null,5545,5333,4944,3501,2283,1411]
[62,null,5959,5731,5312,3761,2440,1480]
[63,null,6540,6288,5829,4128,2664,1551]
[64,null,7338,7057,6542,4632,2979,1655]
[65,null,8359,8038,7452,5276,3379,1812]
[66,null,9600,9232,8558,6059,3849,2004]
[67,null,11035,10612,9837,6966,4389,2265]
[68,null,12551,12070,11189,7922,4980,2543]
[69,null,14149,13608,12614,8932,5607,2857]
[70,null,15859,15252,14139,10011,6304,3188]
[71,null,17653,16976,15737,11142,7034,3536]
[72,null,19528,18779,17409,12326,7817,3901]
[73,null,21514,20691,19180,13580,8653,4285]
[74,null,23582,22679,21023,14886,9542,4667]
[75,null,25733,24747,22941,16243,10482,5067]
[76,null,27968,26897,24934,17654,11474,5485]
[77,null,30283,29124,26998,19115,12518,5920]
[78,null,32711,31458,29162,20647,13615,6356]
[79,null,35220,33872,31399,22231,14746,6826]
[80,"o mas",37814,36366,33711,23869,15948,7280]
[1,"Hijo",635,611,567,401,335,264]
[2,"Hijos",996,958,888,629,524,414]
[3,"Hijos o más",1436,1381,1280,907,756,596]
[1,"Rider Comp. Maternidad",225,225,225,0,0,0]
[1,"Transplante de organos",300,300,300,300,300,300]
[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":775.92000000000007},746.24,691.65000000000009,490.25,369.41,259.7]
[19,null,{"$f":"+C275*$L$2","v":790.76},760.55000000000007,705.43000000000006,499.26000000000005,369.41,268.18]
[20,null,{"$f":"+C276*$L$2","v":804.54000000000008},774.33,717.62,508.27000000000004,379.48,268.18]
[21,null,{"$f":"+C277*$L$2","v":819.38},788.11,730.34,517.28,388.49,277.72000000000003]
[22,null,{"$f":"+C278*$L$2","v":834.75},802.42000000000007,744.12,527.35,397.5,277.72000000000003]
[23,null,{"$f":"+C279*$L$2","v":848},815.67000000000007,755.78000000000009,535.83000000000004,397.5,287.79000000000002]
[24,null,{"$f":"+C280*$L$2","v":878.21},844.82,782.81000000000006,554.91000000000008,406.51000000000005,295.74]
[25,null,{"$f":"+C281*$L$2","v":892.5200000000001},858.07,795.53000000000009,563.92000000000007,416.58000000000004,295.74]
[26,null,{"$f":"+C282*$L$2","v":906.83},872.38,808.78000000000009,572.93000000000006,425.06,305.81]
[27,null,{"$f":"+C283*$L$2","v":922.73},887.22,822.03000000000009,582.47,434.6,305.81]
[28,null,{"$f":"+C284*$L$2","v":935.45},899.94,834.22,590.95000000000005,444.14000000000004,314.29000000000002]
[29,null,{"$f":"+C285*$L$2","v":965.66000000000008},928.56000000000006,860.72,610.03000000000009,453.15000000000003,323.3]
[30,null,{"$f":"+C286*$L$2","v":995.34},957.18000000000006,887.22,628.58000000000004,462.69,333.37]
[31,null,{"$f":"+C287*$L$2","v":1010.1800000000001},971.49,901,638.12,471.70000000000005,333.37]
[32,null,{"$f":"+C288*$L$2","v":1039.3300000000002},999.58,926.44,656.67000000000007,480.71000000000004,341.32]
[33,null,{"$f":"+C289*$L$2","v":1068.48},1027.1400000000001,952.41000000000008,674.16000000000008,490.25,351.39000000000004]
[34,null,{"$f":"+C290*$L$2","v":1098.1600000000001},1055.76,978.91000000000008,692.71,508.27000000000004,360.93]
[35,null,{"$f":"+C291*$L$2","v":1126.25},1082.79,1004.35,710.73,517.28,369.41]
[36,null,{"$f":"+C292*$L$2","v":1156.46},1111.94,1030.8500000000001,729.81000000000006,535.83000000000004,379.48]
[37,null,{"$f":"+C293*$L$2","v":1185.0800000000002},1139.5,1056.29,747.83,544.84,388.49]
[38,null,{"$f":"+C294*$L$2","v":1230.1300000000001},1182.96,1096.5700000000002,776.45,563.92000000000007,397.5]
[39,null,{"$f":"+C295*$L$2","v":1272.53},1223.77,1134.73,803.48,582.47,406.51000000000005]
[40,null,{"$f":"+C296*$L$2","v":1302.74},1252.3900000000001,1161.76,822.03000000000009,590.95000000000005,416.58000000000004]
[41,null,{"$f":"+C297*$L$2","v":1346.2},1294.79,1200.45,849.59,610.03000000000009,425.06]
[42,null,{"$f":"+C298*$L$2","v":1389.66},1336.13,1238.6100000000001,877.15000000000009,628.58000000000004,434.6]
[43,null,{"$f":"+C299*$L$2","v":1432.5900000000001},1378.53,1277.8300000000002,904.71,646.07000000000005,453.15000000000003]
[44,null,{"$f":"+C300*$L$2","v":1491.42},1434.71,1329.24,941.81000000000006,665.68000000000006,462.69]
[45,null,{"$f":"+C301*$L$2","v":1534.88},1476.0500000000002,1368.99,969.37,684.76,480.71000000000004]
[46,null,{"$f":"+C302*$L$2","v":1579.4},1518.98,1408.21,996.93000000000006,701.72,490.25]
[47,null,{"$f":"+C303*$L$2","v":1637.7},1575.16,1460.15,1034.03,720.27,499.26000000000005]
[48,null,{"$f":"+C304*$L$2","v":1710.8400000000001},1645.65,1525.3400000000001,1080.1400000000001,747.83,517.28]
[49,null,{"$f":"+C305*$L$2","v":1769.67},1702.3600000000001,1577.8100000000002,1117.77,776.45,535.83000000000004]
[50,null,{"$f":"+C306*$L$2","v":1842.2800000000002},1772.3200000000002,1643,1163.3500000000001,803.48,544.84]
[51,null,{"$f":"+C307*$L$2","v":1916.48},1842.8100000000002,1708.72,1209.99,831.04000000000008,563.92000000000007]
[52,null,{"$f":"+C308*$L$2","v":1974.25},1898.46,1760.13,1246.5600000000002,858.6,582.47]
[53,null,{"$f":"+C309*$L$2","v":2061.7000000000003},1982.73,1838.0400000000002,1301.1500000000001,887.22,601.02]
[54,null,{"$f":"+C310*$L$2","v":2150.21},2067.5300000000002,1917.01,1357.3300000000002,922.73,610.03000000000009]
[55,null,{"$f":"+C311*$L$2","v":2236.6},2151.27,1993.8600000000001,1411.92,950.82,628.58000000000004]
[56,null,{"$f":"+C312*$L$2","v":2325.6400000000003},2236.0700000000002,2073.36,1468.1000000000001,987.92000000000007,646.07000000000005]
[57,null,{"$f":"+C313*$L$2","v":2412.0300000000002},2319.81,2150.21,1522.69,1025.02,665.68000000000006]
[58,null,{"$f":"+C314*$L$2","v":2544.5300000000002},2447.0100000000002,2268.4,1606.43,1062.1200000000001,684.76]
[59,null,{"$f":"+C315*$L$2","v":2661.6600000000003},2559.3700000000003,2372.81,1680.1000000000001,1107.7,701.72]
[60,null,{"$f":"+C316*$L$2","v":2777.73},2671.2000000000003,2476.1600000000003,1753.77,1154.3400000000001,729.81000000000006]
[61,null,{"$f":"+C317*$L$2","v":2938.8500000000004},2826.4900000000002,2620.3200000000002,1855.5300000000002,1209.99,747.83]
[62,null,{"$f":"+C318*$L$2","v":3158.27},3037.4300000000003,2815.36,1993.3300000000002,1293.2,784.40000000000009]
[63,null,{"$f":"+C319*$L$2","v":3466.2000000000003},3332.6400000000003,3089.3700000000003,2187.84,1411.92,822.03000000000009]
[64,null,{"$f":"+C320*$L$2","v":3889.1400000000003},3740.21,3467.26,2454.96,1578.8700000000001,877.15000000000009]
[65,null,{"$f":"+C321*$L$2","v":4430.2700000000004},4260.1400000000003,3949.5600000000004,2796.28,1790.8700000000001,960.36]
[66,null,{"$f":"+C322*$L$2","v":5088},4892.96,4535.74,3211.27,2039.97,1062.1200000000001]
[67,null,{"$f":"+C323*$L$2","v":5848.55},5624.3600000000006,5213.6100000000006,3691.98,2326.17,1200.45]
[68,null,{"$f":"+C324*$L$2","v":6652.0300000000007},6397.1,5930.17,4198.66,2639.4,1347.79]
[69,null,{"$f":"+C325*$L$2","v":7498.97},7212.2400000000007,6685.42,4733.96,2971.71,1514.21]
[70,null,{"$f":"+C326*$L$2","v":8405.27},8083.56,7493.67,5305.83,3341.1200000000003,1689.64]
[71,null,{"$f":"+C327*$L$2","v":9356.09},8997.2800000000007,8340.61,5905.26,3728.02,1874.0800000000002]
[72,null,{"$f":"+C328*$L$2","v":10349.84},9952.8700000000008,9226.77,6532.7800000000007,4143.01,2067.5300000000002]
[73,null,{"$f":"+C329*$L$2","v":11402.42},10966.230000000001,10165.4,7197.4000000000005,4586.09,2271.0500000000002]
[74,null,{"$f":"+C330*$L$2","v":12498.460000000001},12019.87,11142.19,7889.5800000000008,5057.26,2473.5100000000002]
[75,null,{"$f":"+C331*$L$2","v":13638.49},13115.91,12158.730000000001,8608.7900000000009,5555.46,2685.51]
[76,null,{"$f":"+C332*$L$2","v":14823.04},14255.41,13215.02,9356.6200000000008,6081.22,2907.05]
[77,null,{"$f":"+C333*$L$2","v":16049.990000000002},15435.720000000001,14308.94,10130.950000000001,6634.54,3137.6000000000004]
[78,null,{"$f":"+C334*$L$2","v":17336.830000000002},16672.740000000002,15455.86,10942.91,7215.9500000000007,3368.6800000000003]
[79,null,{"$f":"+C335*$L$2","v":18666.600000000002},17952.16,16641.47,11782.43,7815.38,3617.78]
[80,"o mas",{"$f":"+C336*$L$2","v":20041.420000000002},19273.98,17866.830000000002,12650.570000000002,8452.44,3858.4]
[1,"Hijo",{"$f":"+C337*$L$2","v":336.55},323.83000000000004,300.51,212.53,177.55,139.92000000000002]
[2,"Hijos",{"$f":"+C338*$L$2","v":527.88},507.74,470.64000000000004,333.37,277.72000000000003,219.42000000000002]
[3,"Hijos o más",{"$f":"+C339*$L$2","v":761.08},731.93000000000006,678.40000000000009,480.71000000000004,400.68,315.88]
[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":2725.95},{"$f":"U487","v":2112.25},1380.3999999999999,1013.1999999999999,712.3,null,null,null,null,3207,2485,1624,1192,838,null,null,{"$f":"(M487)*0.85","v":2725.95},{"$f":"(N487)*0.85","v":2112.25},1380.3999999999999,1013.1999999999999,712.3]
[19,null,{"$f":"L488*$L$6","v":0},{"$f":"T488","v":2780.35},{"$f":"U488","v":2139.4499999999998},{"$f":"V488","v":1406.75},{"$f":"W488","v":1013.1999999999999},{"$f":"X488","v":734.4},null,null,null,null,3271,2517,1655,1192,864,null,null,{"$f":"(M488)*0.85","v":2780.35},{"$f":"(N488)*0.85","v":2139.4499999999998},{"$f":"(O488)*0.85","v":1406.75},{"$f":"(P488)*0.85","v":1013.1999999999999},{"$f":"(Q488)*0.85","v":734.4}]
[20,null,0,2805,2191.2999999999997,1433.1,1040.3999999999999,734.4,null,null,null,null,3300,2578,1686,1224,864,null,null,2805,2191.2999999999997,1433.1,1040.3999999999999,734.4]
[21,null,0,2859.4,2248.25,1458.6,1065.05,761.6,null,null,null,null,3364,2645,1716,1253,896,null,null,2859.4,2248.25,1458.6,1065.05,761.6]
[22,null,0,2915.5,2300.9499999999998,1484.95,1090.55,761.6,null,null,null,null,3430,2707,1747,1283,896,null,null,2915.5,2300.9499999999998,1484.95,1090.55,761.6]
[23,null,0,2940.15,2324.75,1508.75,1090.55,788.8,null,null,null,null,3459,2735,1775,1283,928,null,null,2940.15,2324.75,1508.75,1090.55,788.8]
[24,null,0,2992.85,2380.85,1563.1499999999999,1115.2,810.9,null,null,null,null,3521,2801,1839,1312,954,null,null,2992.85,2380.85,1563.1499999999999,1115.2,810.9]
[25,null,0,3047.25,2432.6999999999998,1587.8,1142.3999999999999,810.9,null,null,null,null,3585,2862,1868,1344,954,null,null,3047.25,2432.6999999999998,1587.8,1142.3999999999999,810.9]
[26,null,0,3101.65,2486.25,1614.1499999999999,1165.3499999999999,838.1,null,null,null,null,3649,2925,1899,1371,986,null,null,3101.65,2486.25,1614.1499999999999,1165.3499999999999,838.1]
[27,null,0,3127.15,2538.9499999999998,1642.2,1191.7,838.1,null,null,null,null,3679,2987,1932,1402,986,null,null,3127.15,2538.9499999999998,1642.2,1191.7,838.1]
[28,null,0,3206.2,2593.35,1665.1499999999999,1216.3499999999999,861.9,null,null,null,null,3772,3051,1959,1431,1014,null,null,3206.2,2593.35,1665.1499999999999,1216.3499999999999,861.9]
[29,null,0,3260.6,2646.9,1717.85,1241,885.69999999999993,null,null,null,null,3836,3114,2021,1460,1042,null,null,3260.6,2646.9,1717.85,1241,885.69999999999993]
[30,null,0,3341.35,2725.95,1770.55,1268.2,913.75,null,null,null,null,3931,3207,2083,1492,1075,null,null,3341.35,2725.95,1770.55,1268.2,913.75]
[31,null,0,3393.2,2780.35,1797.75,1294.55,913.75,null,null,null,null,3992,3271,2115,1523,1075,null,null,3393.2,2780.35,1797.75,1294.55,913.75]
[32,null,0,3473.95,2859.4,1849.6,1317.5,935.85,null,null,null,null,4087,3364,2176,1550,1101,null,null,3473.95,2859.4,1849.6,1317.5,935.85]
[33,null,0,3554.7,2940.15,1900.6,1343.85,964.75,null,null,null,null,4182,3459,2236,1581,1135,null,null,3554.7,2940.15,1900.6,1343.85,964.75]
[34,null,0,3635.45,3022.6,1953.3,1394,989.4,null,null,null,null,4277,3556,2298,1640,1164,null,null,3635.45,3022.6,1953.3,1394,989.4]
[35,null,0,3743.4,3101.65,2004.3,1418.6499999999999,1013.1999999999999,null,null,null,null,4404,3649,2358,1669,1192,null,null,3743.4,3101.65,2004.3,1418.6499999999999,1013.1999999999999]
[36,null,0,3821.6,3181.5499999999997,2057,1467.95,1040.3999999999999,null,null,null,null,4496,3743,2420,1727,1224,null,null,3821.6,3181.5499999999997,2057,1467.95,1040.3999999999999]
[37,null,0,3901.5,3260.6,2108.85,1494.3,1065.05,null,null,null,null,4590,3836,2481,1758,1253,null,null,3901.5,3260.6,2108.85,1494.3,1065.05]
[38,null,0,4008.6,3367.7,2188.75,1544.45,1090.55,null,null,null,null,4716,3962,2575,1817,1283,null,null,4008.6,3367.7,2188.75,1544.45,1090.55]
[39,null,0,4116.55,3473.95,2263.5499999999997,1598,1115.2,null,null,null,null,4843,4087,2663,1880,1312,null,null,4116.55,3473.95,2263.5499999999997,1598,1115.2]
[40,null,0,4249.1499999999996,3554.7,2317.9499999999998,1620.1,1142.3999999999999,null,null,null,null,4999,4182,2727,1906,1344,null,null,4249.1499999999996,3554.7,2317.9499999999998,1620.1,1142.3999999999999]
[41,null,0,4354.55,3663.5,2395.2999999999997,1671.95,1165.3499999999999,null,null,null,null,5123,4310,2818,1967,1371,null,null,4354.55,3663.5,2395.2999999999997,1671.95,1165.3499999999999]
[42,null,null,4463.3499999999995,3767.2,2471.7999999999997,1722.95,1191.7,null,null,null,null,5251,4432,2908,2027,1402,null,null,4463.3499999999995,3767.2,2471.7999999999997,1722.95,1191.7]
[43,null,null,4597.6499999999996,3901.5,2550,1773.1,1241,null,null,null,null,5409,4590,3000,2086,1460,null,null,4597.6499999999996,3901.5,2550,1773.1,1241]
[44,null,null,4730.25,4008.6,2653.7,1824.95,1268.2,null,null,null,null,5565,4716,3122,2147,1492,null,null,4730.25,4008.6,2653.7,1824.95,1268.2]
[45,null,null,4862.8499999999995,4142.05,2731.0499999999997,1876.8,1317.5,null,null,null,null,5721,4873,3213,2208,1550,null,null,4862.8499999999995,4142.05,2731.0499999999997,1876.8,1317.5]
[46,null,null,4998,4276.3499999999995,2810.1,1926.1,1343.85,null,null,null,null,5880,5031,3306,2266,1581,null,null,4998,4276.3499999999995,2810.1,1926.1,1343.85]
[47,null,null,5130.5999999999995,4383.45,2914.65,1976.25,1369.35,null,null,null,null,6036,5157,3429,2325,1611,null,null,5130.5999999999995,4383.45,2914.65,1976.25,1369.35]
[48,null,null,5343.95,4569.5999999999995,3043.85,2051.9,1418.6499999999999,null,null,null,null,6287,5376,3581,2414,1669,null,null,5343.95,4569.5999999999995,3043.85,2051.9,1418.6499999999999]
[49,null,null,5530.95,4730.25,3149.25,2130.1,1467.95,null,null,null,null,6507,5565,3705,2506,1727,null,null,5530.95,4730.25,3149.25,2130.1,1467.95]
[50,null,null,5718.8,4890.8999999999996,3279.2999999999997,2203.1999999999998,1494.3,null,null,null,null,6728,5754,3858,2592,1758,null,null,5718.8,4890.8999999999996,3279.2999999999997,2203.1999999999998,1494.3]
[51,null,null,5904.95,5075.3499999999995,3410.2,2279.6999999999998,1544.45,null,null,null,null,6947,5971,4012,2682,1817,null,null,5904.95,5075.3499999999995,3410.2,2279.6999999999998,1544.45]
[52,null,null,6091.95,5236.8499999999995,3513.0499999999997,2355.35,1598,null,null,null,null,7167,6161,4133,2771,1880,null,null,6091.95,5236.8499999999995,3513.0499999999997,2355.35,1598]
[53,null,null,6333.3499999999995,5450.2,3668.6,2431.85,1647.3,null,null,null,null,7451,6412,4316,2861,1938,null,null,6333.3499999999995,5450.2,3668.6,2431.85,1647.3]
[54,null,null,6573.05,5666.0999999999995,3825.85,2530.4499999999998,1671.95,null,null,null,null,7733,6666,4501,2977,1967,null,null,6573.05,5666.0999999999995,3825.85,2530.4499999999998,1671.95]
[55,null,null,6813.5999999999995,5880.3,3980.5499999999997,2607.7999999999997,1722.95,null,null,null,null,8016,6918,4683,3068,2027,null,null,6813.5999999999995,5880.3,3980.5499999999997,2607.7999999999997,1722.95]
[56,null,null,7053.3,6091.95,4136.95,2708.95,1773.1,null,null,null,null,8298,7167,4867,3187,2086,null,null,7053.3,6091.95,4136.95,2708.95,1773.1]
[57,null,null,7294.7,6305.3,4292.5,2811.7999999999997,1824.95,null,null,null,null,8582,7418,5050,3308,2147,null,null,7294.7,6305.3,4292.5,2811.7999999999997,1824.95]
[58,null,null,7615.15,6573.05,4527.0999999999995,2912.1,1876.8,null,null,null,null,8959,7733,5326,3426,2208,null,null,7615.15,6573.05,4527.0999999999995,2912.1,1876.8]
[59,null,null,7907.55,6838.25,4735.3499999999995,3037.9,1926.1,null,null,null,null,9303,8045,5571,3574,2266,null,null,7907.55,6838.25,4735.3499999999995,3037.9,1926.1]
[60,null,null,8230.5499999999993,7134.9,4942.75,3165.4,2001.75,null,null,null,null,9683,8394,5815,3724,2355,null,null,8230.5499999999993,7134.9,4942.75,3165.4,2001.75]
[61,null,null,8683.6,7507.2,5230.05,3317.5499999999997,2051.9,null,null,null,null,10216,8832,6153,3903,2414,null,null,8683.6,7507.2,5230.05,3317.5499999999997,2051.9]
[62,null,null,9270.9499999999989,8040.15,5619.3499999999995,3546.2,2152.1999999999998,null,null,null,null,10907,9459,6611,4172,2532,null,null,9270.9499999999989,8040.15,5619.3499999999995,3546.2,2152.1999999999998]
[63,null,null,10150.699999999999,8791.5499999999993,6166.75,3872.6,2255.9,null,null,null,null,11942,10343,7255,4556,2654,null,null,10150.699999999999,8791.5499999999993,6166.75,3872.6,2255.9]
[64,null,null,11352.6,9832.7999999999993,6919,4329.05,2405.5,null,null,null,null,13356,11568,8140,5093,2830,null,null,11352.6,9832.7999999999993,6919,4329.05,2405.5]
[65,null,null,12903.85,11169,7882.05,4910.45,2634.15,null,null,null,null,15181,13140,9273,5777,3099,null,null,12903.85,11169,7882.05,4910.45,2634.15]
[66,null,null,14800.199999999999,12850.3,9051.65,5593.8499999999995,2912.1,null,null,null,null,17412,15118,10649,6581,3426,null,null,14800.199999999999,12850.3,9051.65,5593.8499999999995,2912.1]
[67,null,null,16937.95,14744.1,10405.699999999999,6379.25,3291.2,null,null,null,null,19927,17346,12242,7505,3872,null,null,16937.95,14744.1,10405.699999999999,6379.25,3291.2]
[68,null,null,19232.95,16802.8,11835.4,7240.3,3696.65,null,null,null,null,22627,19768,13924,8518,4349,null,null,19232.95,16802.8,11835.4,7240.3,3696.65]
[69,null,null,21637.599999999999,18967.75,13343.3,8148.95,4153.0999999999995,null,null,null,null,25456,22315,15698,9587,4886,null,null,21637.599999999999,18967.75,13343.3,8148.95,4153.0999999999995]
[70,null,null,24122.149999999998,21181.149999999998,14954.05,9163.85,4633.3499999999995,null,null,null,null,28379,24919,17593,10781,5451,null,null,24122.149999999998,21181.149999999998,14954.05,9163.85,4633.3499999999995]
[71,null,null,26686.6,23505.05,16645.55,10223.799999999999,5139.0999999999995,null,null,null,null,31396,27653,19583,12028,6046,null,null,26686.6,23505.05,16645.55,10223.799999999999,5139.0999999999995]
[72,null,null,29327.55,25857,18414.399999999998,11361.1,5670.3499999999995,null,null,null,null,34503,30420,21664,13366,6671,null,null,29327.55,25857,18414.399999999998,11361.1,5670.3499999999995]
[73,null,null,32026.3,28287.149999999998,20286.95,12577.449999999999,6227.0999999999995,null,null,null,null,37678,33279,23867,14797,7326,null,null,32026.3,28287.149999999998,20286.95,12577.449999999999,6227.0999999999995]
[74,null,null,34750.549999999996,30772.55,22236.85,13868.6,6783,null,null,null,null,40883,36203,26161,16316,7980,null,null,34750.549999999996,30772.55,22236.85,13868.6,6783]
[75,null,null,37553.85,33281.75,24264.95,15235.4,7366.0999999999995,null,null,null,null,44181,39155,28547,17924,8666,null,null,37553.85,33281.75,24264.95,15235.4,7366.0999999999995]
[76,null,null,40386.9,35844.5,26372.95,16677.849999999999,7972.15,null,null,null,null,47514,42170,31027,19621,9379,null,null,40386.9,35844.5,26372.95,16677.849999999999,7972.15]
[77,null,null,43270.1,38435.299999999996,28555.75,18195.099999999999,8603.6999999999989,null,null,null,null,50906,45218,33595,21406,10122,null,null,43270.1,38435.299999999996,28555.75,18195.099999999999,8603.6999999999989]
[78,null,null,46181.35,41080.5,30845.649999999998,19788.849999999999,9239.5,null,null,null,null,54331,48330,36289,23281,10870,null,null,46181.35,41080.5,30845.649999999998,19788.849999999999,9239.5]
[79,null,null,49121.5,43724.85,33211.199999999997,21434.45,9921.1999999999989,null,null,null,null,57790,51441,39072,25217,11672,null,null,49121.5,43724.85,33211.199999999997,21434.45,9921.1999999999989]
[80,"o mas",null,52083.75,46423.6,35656.65,23180.35,10580.8,null,null,null,null,61275,54616,41949,27271,12448,null,null,52083.75,46423.6,35656.65,23180.35,10580.8]
[1,"Hijo",null,1390.6,804.1,599.25,431.8,306,null,null,null,null,1636,946,705,508,360,null,null,{"$f":"(M550)*0.85","v":1390.6},{"$f":"(N550)*0.85","v":804.1},{"$f":"(O550)*0.85","v":599.25},{"$f":"(P550)*0.85","v":431.8},{"$f":"(Q550)*0.85","v":306}]
[2,"Hijos",null,{"$f":"T551","v":2324.75},{"$f":"U551","v":1206.1499999999999},{"$f":"V551","v":939.25},{"$f":"W551","v":662.15},{"$f":"X551","v":458.15},null,null,null,null,2735,1419,1105,779,539,null,null,2324.75,1206.1499999999999,939.25,662.15,458.15]
[3,"Hijos o más",null,3421.25,1738.25,1354.05,964.75,685.1,null,null,null,null,4025,2045,1593,1135,806,null,null,{"$f":"(M552)*0.85","v":3421.25},{"$f":"(N552)*0.85","v":1738.25},{"$f":"(O552)*0.85","v":1354.05},{"$f":"(P552)*0.85","v":964.75},{"$f":"(Q552)*0.85","v":685.1}]
[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},1444.7535,1119.4925000000001,731.61199999999997,536.99599999999998,377.51900000000001]
[19,null,{"$f":"+C488*$L$2","v":0},1473.5855000000001,1133.9085,745.57749999999999,536.99599999999998,389.23200000000003]
[20,null,{"$f":"+C489*$L$2","v":0},1486.65,1161.3889999999999,759.54300000000001,551.41199999999992,389.23200000000003]
[21,null,{"$f":"+C490*$L$2","v":0},1515.4820000000002,1191.5725,773.05799999999999,564.47649999999999,403.64800000000002]
[22,null,{"$f":"+C491*$L$2","v":0},1545.2150000000001,1219.5035,787.02350000000001,577.99149999999997,403.64800000000002]
[23,null,{"$f":"+C492*$L$2","v":0},1558.2795000000001,1232.1175000000001,799.63750000000005,577.99149999999997,418.06400000000002]
[24,null,{"$f":"+C493*$L$2","v":0},1586.2105000000001,1261.8505,828.46949999999993,591.05600000000004,429.77699999999999]
[25,null,{"$f":"+C494*$L$2","v":0},1615.0425,1289.3309999999999,841.53399999999999,605.47199999999998,429.77699999999999]
[26,null,{"$f":"+C495*$L$2","v":0},1643.8745000000001,1317.7125000000001,855.49950000000001,617.63549999999998,444.19300000000004]
[27,null,{"$f":"+C496*$L$2","v":0},1657.3895000000002,1345.6434999999999,870.3660000000001,631.601,444.19300000000004]
[28,null,{"$f":"+C497*$L$2","v":0},1699.2860000000001,1374.4755,882.52949999999998,644.66549999999995,456.80700000000002]
[29,null,{"$f":"+C498*$L$2","v":0},1728.1179999999999,1402.8570000000002,910.46050000000002,657.73,469.42099999999999]
[30,null,{"$f":"+C499*$L$2","v":0},1770.9155000000001,1444.7535,938.39150000000006,672.14600000000007,484.28750000000002]
[31,null,{"$f":"+C500*$L$2","v":0},1798.396,1473.5855000000001,952.8075,686.11149999999998,484.28750000000002]
[32,null,{"$f":"+C501*$L$2","v":0},1841.1935000000001,1515.4820000000002,980.28800000000001,698.27500000000009,496.00050000000005]
[33,null,{"$f":"+C502*$L$2","v":0},1883.991,1558.2795000000001,1007.318,712.2405,511.31750000000005]
[34,null,{"$f":"+C503*$L$2","v":0},1926.7885000000001,1601.9780000000001,1035.249,738.82,524.38200000000006]
[35,null,{"$f":"+C504*$L$2","v":0},1984.0020000000002,1643.8745000000001,1062.279,751.8845,536.99599999999998]
[36,null,{"$f":"+C505*$L$2","v":0},2025.4480000000001,1686.2214999999999,1090.21,778.01350000000002,551.41199999999992]
[37,null,{"$f":"+C506*$L$2","v":0},2067.7950000000001,1728.1179999999999,1117.6904999999999,791.97900000000004,564.47649999999999]
[38,null,{"$f":"+C507*$L$2","v":0},2124.558,1784.8810000000001,1160.0375000000001,818.55850000000009,577.99149999999997]
[39,null,{"$f":"+C508*$L$2","v":0},2181.7715000000003,1841.1935000000001,1199.6814999999999,846.94,591.05600000000004]
[40,null,{"$f":"+C509*$L$2","v":0},2252.0495000000001,1883.991,1228.5135,858.65300000000002,605.47199999999998]
[41,null,{"$f":"+C510*$L$2","v":0},2307.9115000000002,1941.6550000000002,1269.509,886.13350000000003,617.63549999999998]
[42,null,null,{"$f":"+D511*$L$2","v":2365.5754999999999},1996.616,1310.0539999999999,913.16350000000011,631.601]
[43,null,null,{"$f":"+D512*$L$2","v":2436.7545},2067.7950000000001,1351.5,939.74300000000005,657.73]
[44,null,null,{"$f":"+D513*$L$2","v":2507.0325000000003},2124.558,1406.461,967.22350000000006,672.14600000000007]
[45,null,null,{"$f":"+D514*$L$2","v":2577.3105},2195.2865000000002,1447.4565,994.70400000000006,698.27500000000009]
[46,null,null,{"$f":"+D515*$L$2","v":2648.94},2266.4654999999998,1489.3530000000001,1020.833,712.2405]
[47,null,null,{"$f":"+D516*$L$2","v":2719.2179999999998},2323.2285000000002,1544.7645000000002,1047.4125000000001,725.75549999999998]
[48,null,null,{"$f":"+D517*$L$2","v":2832.2935000000002},2421.8879999999999,1613.2405000000001,1087.5070000000001,751.8845]
[49,null,null,{"$f":"+D518*$L$2","v":2931.4034999999999},2507.0325000000003,1669.1025000000002,1128.953,778.01350000000002]
[50,null,null,{"$f":"+D519*$L$2","v":3030.9640000000004},2592.1770000000001,1738.029,1167.6959999999999,791.97900000000004]
[51,null,null,{"$f":"+D520*$L$2","v":3129.6235000000001},2689.9355,1807.4059999999999,1208.241,818.55850000000009]
[52,null,null,{"$f":"+D521*$L$2","v":3228.7335000000003},2775.5304999999998,1861.9165,1248.3354999999999,846.94]
[53,null,null,{"$f":"+D522*$L$2","v":3356.6754999999998},2888.6060000000002,1944.3579999999999,1288.8805,873.06900000000007]
[54,null,null,{"$f":"+D523*$L$2","v":3483.7165000000005},3003.0329999999999,2027.7005000000001,1341.1385,886.13350000000003]
[55,null,null,{"$f":"+D524*$L$2","v":3611.2080000000001},3116.5590000000002,2109.6914999999999,1382.134,913.16350000000011]
[56,null,null,{"$f":"+D525*$L$2","v":3738.2490000000003},3228.7335000000003,2192.5835000000002,1435.7435,939.74300000000005]
[57,null,null,{"$f":"+D526*$L$2","v":3866.1910000000003},3341.8090000000002,2275.0250000000001,1490.2539999999999,967.22350000000006]
[58,null,null,{"$f":"+D527*$L$2","v":4036.0295000000001},3483.7165000000005,2399.3629999999998,1543.413,994.70400000000006]
[59,null,null,{"$f":"+D528*$L$2","v":4191.0015000000003},3624.2725,2509.7354999999998,1610.0870000000002,1020.833]
[60,null,null,{"$f":"+D529*$L$2","v":4362.1914999999999},3781.4969999999998,2619.6575000000003,1677.662,1060.9275]
[61,null,null,{"$f":"+D530*$L$2","v":4602.308},3978.8160000000003,2771.9265,1758.3015,1087.5070000000001]
[62,null,null,{"$f":"+D531*$L$2","v":4913.6034999999993},4261.2794999999996,2978.2554999999998,1879.4860000000001,1140.6659999999999]
[63,null,null,{"$f":"+D532*$L$2","v":5379.8710000000001},4659.5214999999998,3268.3775000000001,2052.4780000000001,1195.6270000000002]
[64,null,null,{"$f":"+D533*$L$2","v":6016.8780000000006},5211.384,3667.07,2294.3965000000003,1274.915]
[65,null,null,{"$f":"+D534*$L$2","v":6839.040500000001},5919.5700000000006,4177.4865,2602.5385000000001,1396.0995]
[66,null,null,{"$f":"+D535*$L$2","v":7844.1059999999998},6810.6589999999997,4797.3744999999999,2964.7404999999999,1543.413]
[67,null,null,{"$f":"+D536*$L$2","v":8977.1135000000013},7814.3730000000005,5515.0209999999997,3381.0025000000001,1744.336]
[68,null,null,{"$f":"+D537*$L$2","v":10193.463500000002},8905.4840000000004,6272.7619999999997,3837.3590000000004,1959.2245]
[69,null,null,{"$f":"+D538*$L$2","v":11467.928},10052.907500000001,7071.9489999999996,4318.9435000000003,2201.143]
[70,null,null,{"$f":"+D539*$L$2","v":12784.7395},11226.0095,7925.6464999999998,4856.8405000000002,2455.6754999999998]
[71,null,null,{"$f":"+D540*$L$2","v":14143.897999999999},12457.6765,8822.1414999999997,5418.6139999999996,2723.723]
[72,null,null,{"$f":"+D541*$L$2","v":15543.601500000001},13704.210000000001,9759.6319999999996,6021.3830000000007,3005.2855]
[73,null,null,{"$f":"+D542*$L$2","v":16973.939000000002},14992.1895,10752.083500000001,6666.0484999999999,3300.3629999999998]
[74,null,null,{"$f":"+D543*$L$2","v":18417.791499999999},16309.451500000001,11785.530499999999,7350.3580000000002,3594.9900000000002]
[75,null,null,{"$f":"+D544*$L$2","v":19903.540499999999},17639.327499999999,12860.423500000001,8074.7620000000006,3904.0329999999999]
[76,null,null,{"$f":"+D545*$L$2","v":21405.057000000001},18997.585000000003,13977.663500000001,8839.2605000000003,4225.2394999999997]
[77,null,null,{"$f":"+D546*$L$2","v":22933.153000000002},20370.708999999999,15134.547500000001,9643.4030000000002,4559.9609999999993]
[78,null,null,{"$f":"+D547*$L$2","v":24476.1155},21772.665000000001,16348.1945,10488.0905,4896.9350000000004]
[79,null,null,{"$f":"+D548*$L$2","v":26034.395},23174.1705,17601.935999999998,11360.258500000002,5258.2359999999999]
[80,"o mas",null,{"$f":"+D549*$L$2","v":27604.387500000001},24604.508000000002,18898.024500000003,12285.585499999999,5607.8239999999996]
[1,"Hijo",{"$f":"+C550*$L$2","v":0},737.01800000000003,426.17300000000006,317.60250000000002,228.85400000000001,162.18]
[2,"Hijos",{"$f":"+C551*$L$2","v":0},1232.1175000000001,639.2595,497.80250000000001,350.93950000000001,242.81950000000001]
[3,"Hijos o más",{"$f":"+C552*$L$2","v":0},1813.2625,921.27250000000004,717.64650000000006,511.31750000000005,363.10300000000001]
[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":402.6},{"$f":"+D274*$L$3","v":387.20000000000005},358.87500000000006,254.37500000000003,191.67500000000001,134.75]
[19,null,{"$f":"+C275*$L$3","v":410.3},394.62500000000006,366.02500000000003,259.05,191.67500000000001,139.15]
[20,null,{"$f":"+C276*$L$3","v":417.45000000000005},401.77500000000003,372.35,263.72500000000002,196.9,139.15]
[21,null,{"$f":"+C277*$L$3","v":425.15000000000003},408.92500000000001,378.95000000000005,268.40000000000003,201.57500000000002,144.10000000000002]
[22,null,{"$f":"+C278*$L$3","v":433.12500000000006},416.35,386.1,273.625,206.25000000000003,144.10000000000002]
[23,null,{"$f":"+C279*$L$3","v":440.00000000000006},423.22500000000002,392.15000000000003,278.02500000000003,206.25000000000003,149.32500000000002]
[24,null,{"$f":"+C280*$L$3","v":455.67500000000001},438.35,406.17500000000001,287.92500000000001,210.92500000000001,153.45000000000002]
[25,null,{"$f":"+C281*$L$3","v":463.1},445.22500000000002,412.77500000000003,292.60000000000002,216.15,153.45000000000002]
[26,null,{"$f":"+C282*$L$3","v":470.52500000000003},452.65000000000003,419.65000000000003,297.27500000000003,220.55,158.67500000000001]
[27,null,{"$f":"+C283*$L$3","v":478.77500000000003},460.35,426.52500000000003,302.22500000000002,225.50000000000003,158.67500000000001]
[28,null,{"$f":"+C284*$L$3","v":485.37500000000006},466.95000000000005,432.85,306.625,230.45000000000002,163.07500000000002]
[29,null,{"$f":"+C285*$L$3","v":501.05000000000007},481.8,446.6,316.52500000000003,235.12500000000003,167.75]
[30,null,{"$f":"+C286*$L$3","v":516.45000000000005},496.65000000000003,460.35,326.15000000000003,240.07500000000002,172.97500000000002]
[31,null,{"$f":"+C287*$L$3","v":524.15000000000009},504.07500000000005,467.50000000000006,331.1,244.75000000000003,172.97500000000002]
[32,null,{"$f":"+C288*$L$3","v":539.27500000000009},518.65000000000009,480.70000000000005,340.72500000000002,249.42500000000001,177.10000000000002]
[33,null,{"$f":"+C289*$L$3","v":554.40000000000009},532.95000000000005,494.17500000000007,349.8,254.37500000000003,182.32500000000002]
[34,null,{"$f":"+C290*$L$3","v":569.80000000000007},547.80000000000007,507.92500000000007,359.42500000000001,263.72500000000002,187.27500000000001]
[35,null,{"$f":"+C291*$L$3","v":584.375},561.82500000000005,521.125,368.77500000000003,268.40000000000003,191.67500000000001]
[36,null,{"$f":"+C292*$L$3","v":600.05000000000007},576.95000000000005,534.875,378.67500000000001,278.02500000000003,196.9]
[37,null,{"$f":"+C293*$L$3","v":614.90000000000009},591.25,548.07500000000005,388.02500000000003,282.70000000000005,201.57500000000002]
[38,null,{"$f":"+C294*$L$3","v":638.27500000000009},613.80000000000007,568.97500000000002,402.87500000000006,292.60000000000002,206.25000000000003]
[39,null,{"$f":"+C295*$L$3","v":660.27500000000009},634.97500000000002,588.77500000000009,416.90000000000003,302.22500000000002,210.92500000000001]
[40,null,{"$f":"+C296*$L$3","v":675.95},649.82500000000005,602.80000000000007,426.52500000000003,306.625,216.15]
[41,null,{"$f":"+C297*$L$3","v":698.5},671.82500000000005,622.875,440.82500000000005,316.52500000000003,220.55]
[42,null,{"$f":"+C298*$L$3","v":721.05000000000007},693.27500000000009,642.67500000000007,455.12500000000006,326.15000000000003,225.50000000000003]
[43,null,{"$f":"+C299*$L$3","v":743.32500000000005},715.27500000000009,663.02500000000009,469.42500000000001,335.22500000000002,235.12500000000003]
[44,null,{"$f":"+C300*$L$3","v":773.85},744.42500000000007,689.7,488.67500000000001,345.40000000000003,240.07500000000002]
[45,null,{"$f":"+C301*$L$3","v":796.40000000000009},765.87500000000011,710.32500000000005,502.97500000000002,355.3,249.42500000000001]
[46,null,{"$f":"+C302*$L$3","v":819.50000000000011},788.15000000000009,730.67500000000007,517.27500000000009,364.1,254.37500000000003]
[47,null,{"$f":"+C303*$L$3","v":849.75000000000011},817.30000000000007,757.62500000000011,536.52500000000009,373.72500000000002,259.05]
[48,null,{"$f":"+C304*$L$3","v":887.7},853.87500000000011,791.45,560.45000000000005,388.02500000000003,268.40000000000003]
[49,null,{"$f":"+C305*$L$3","v":918.22500000000002},883.30000000000007,818.67500000000007,579.97500000000002,402.87500000000006,278.02500000000003]
[50,null,{"$f":"+C306*$L$3","v":955.90000000000009},919.6,852.50000000000011,603.625,416.90000000000003,282.70000000000005]
[51,null,{"$f":"+C307*$L$3","v":994.40000000000009},956.17500000000007,886.6,627.82500000000005,431.20000000000005,292.60000000000002]
[52,null,{"$f":"+C308*$L$3","v":1024.375},985.05000000000007,913.27500000000009,646.80000000000007,445.50000000000006,302.22500000000002]
[53,null,{"$f":"+C309*$L$3","v":1069.75},1028.7750000000001,953.7,675.125,460.35,311.85000000000002]
[54,null,{"$f":"+C310*$L$3","v":1115.6750000000002},1072.7750000000001,994.67500000000007,704.27500000000009,478.77500000000003,316.52500000000003]
[55,null,{"$f":"+C311*$L$3","v":1160.5},1116.2250000000001,1034.5500000000002,732.6,493.35,326.15000000000003]
[56,null,{"$f":"+C312*$L$3","v":1206.7},1160.2250000000001,1075.8000000000002,761.75000000000011,512.6,335.22500000000002]
[57,null,{"$f":"+C313*$L$3","v":1251.5250000000001},1203.6750000000002,1115.6750000000002,790.07500000000005,531.85,345.40000000000003]
[58,null,{"$f":"+C314*$L$3","v":1320.2750000000001},1269.6750000000002,1177,833.52500000000009,551.1,355.3]
[59,null,{"$f":"+C315*$L$3","v":1381.0500000000002},1327.9750000000001,1231.1750000000002,871.75000000000011,574.75,364.1]
[60,null,{"$f":"+C316*$L$3","v":1441.2750000000001},1386,1284.8000000000002,909.97500000000002,598.95000000000005,378.67500000000001]
[61,null,{"$f":"+C317*$L$3","v":1524.8750000000002},1466.575,1359.6000000000001,962.77500000000009,627.82500000000005,388.02500000000003]
[62,null,{"$f":"+C318*$L$3","v":1638.7250000000001},1576.0250000000001,1460.8000000000002,1034.2750000000001,671,407.00000000000006]
[63,null,{"$f":"+C319*$L$3","v":1798.5000000000002},1729.2,1602.9750000000001,1135.2,732.6,426.52500000000003]
[64,null,{"$f":"+C320*$L$3","v":2017.9500000000003},1940.6750000000002,1799.0500000000002,1273.8000000000002,819.22500000000002,455.12500000000006]
[65,null,{"$f":"+C321*$L$3","v":2298.7250000000004},2210.4500000000003,2049.3000000000002,1450.9,929.22500000000002,498.30000000000007]
[66,null,{"$f":"+C322*$L$3","v":2640},2538.8000000000002,2353.4500000000003,1666.2250000000001,1058.4750000000001,551.1]
[67,null,{"$f":"+C323*$L$3","v":3034.6250000000005},2918.3,2705.1750000000002,1915.65,1206.9750000000001,622.875]
[68,null,{"$f":"+C324*$L$3","v":3451.5250000000001},3319.2500000000005,3076.9750000000004,2178.5500000000002,1369.5,699.32500000000005]
[69,null,{"$f":"+C325*$L$3","v":3890.9750000000004},3742.2000000000003,3468.8500000000004,2456.3000000000002,1541.9250000000002,785.67500000000007]
[70,null,{"$f":"+C326*$L$3","v":4361.2250000000004},4194.3,3888.2250000000004,2753.0250000000001,1733.6000000000001,876.7]
[71,null,{"$f":"+C327*$L$3","v":4854.5750000000007},4668.4000000000005,4327.6750000000002,3064.05,1934.3500000000001,972.40000000000009]
[72,null,{"$f":"+C328*$L$3","v":5370.2000000000007},5164.2250000000004,4787.4750000000004,3389.65,2149.6750000000002,1072.7750000000001]
[73,null,{"$f":"+C329*$L$3","v":5916.35},5690.0250000000005,5274.5,3734.5000000000005,2379.5750000000003,1178.375]
[74,null,{"$f":"+C330*$L$3","v":6485.05},6236.7250000000004,5781.3250000000007,4093.6500000000005,2624.05,1283.4250000000002]
[75,null,{"$f":"+C331*$L$3","v":7076.5750000000007},6805.4250000000002,6308.7750000000005,4466.8250000000007,2882.55,1393.4250000000002]
[76,null,{"$f":"+C332*$L$3","v":7691.2000000000007},7396.6750000000002,6856.85,4854.8500000000004,3155.3500000000004,1508.3750000000002]
[77,null,{"$f":"+C333*$L$3","v":8327.8250000000007},8009.1,7424.4500000000007,5256.625,3442.4500000000003,1628.0000000000002]
[78,null,{"$f":"+C334*$L$3","v":8995.5250000000015},8650.9500000000007,8019.5500000000011,5677.9250000000002,3744.1250000000005,1747.9]
[79,null,{"$f":"+C335*$L$3","v":9685.5},9314.8000000000011,8634.7250000000004,6113.5250000000005,4055.1500000000005,1877.15]
[80,"o mas",{"$f":"+C336*$L$3","v":10398.85},10000.650000000001,9270.5250000000015,6563.9750000000004,4385.7000000000007,2002.0000000000002]
[1,"Hijo",{"$f":"+C337*$L$3","v":174.625},168.02500000000001,155.92500000000001,110.27500000000001,92.125000000000014,72.600000000000009]
[2,"Hijos",{"$f":"+C338*$L$3","v":273.90000000000003},263.45000000000005,244.20000000000002,172.97500000000002,144.10000000000002,113.85000000000001]
[3,"Hijos o más",{"$f":"+C339*$L$3","v":394.90000000000003},379.77500000000003,352,249.42500000000001,207.9,163.9]
[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":749.63625000000002},{"$f":"E487*$L$3","v":580.86875000000009},379.61,278.63,195.88249999999999]
[19,null,null,{"$f":"D488*$L$3","v":764.59625000000005},588.34875,386.85625000000005,278.63,201.96]
[20,null,null,{"$f":"D489*$L$3","v":771.37500000000011},602.60749999999996,394.10250000000002,286.11,201.96]
[21,null,null,{"$f":"D490*$L$3","v":786.33500000000004},618.26875000000007,401.11500000000001,292.88875000000002,209.44000000000003]
[22,null,null,{"$f":"D491*$L$3","v":801.76250000000005},632.76125000000002,408.36125000000004,299.90125,209.44000000000003]
[23,null,null,{"$f":"D492*$L$3","v":808.5412500000001},639.30625000000009,414.90625000000006,299.90125,216.92000000000002]
[24,null,null,{"$f":"D493*$L$3","v":823.03375000000005},654.73374999999999,429.86624999999998,306.68000000000006,222.9975]
[25,null,null,{"$f":"D494*$L$3","v":837.99375000000009},668.99249999999995,436.64500000000004,314.15999999999997,222.9975]
[26,null,null,{"$f":"D495*$L$3","v":852.95375000000013},683.71875,443.89125000000001,320.47125,230.47750000000002]
[27,null,null,{"$f":"D496*$L$3","v":859.96625000000006},698.21124999999995,451.60500000000008,327.71750000000003,230.47750000000002]
[28,null,null,{"$f":"D497*$L$3","v":881.70500000000004},713.17124999999999,457.91624999999999,334.49624999999997,237.02250000000001]
[29,null,null,{"$f":"D498*$L$3","v":896.66500000000008},727.89750000000004,472.40875,341.27500000000003,243.5675]
[30,null,null,{"$f":"D499*$L$3","v":918.87125000000003},749.63625000000002,486.90125,348.75500000000005,251.28125000000003]
[31,null,null,{"$f":"D500*$L$3","v":933.13},764.59625000000005,494.38125000000002,356.00125000000003,251.28125000000003]
[32,null,null,{"$f":"D501*$L$3","v":955.33625000000006},786.33500000000004,508.64000000000004,362.31250000000006,257.35875000000004]
[33,null,null,{"$f":"D502*$L$3","v":977.54250000000002},808.5412500000001,522.66499999999996,369.55875000000003,265.30625000000003]
[34,null,null,{"$f":"D503*$L$3","v":999.74875000000009},831.21500000000003,537.15750000000003,383.35,272.08500000000004]
[35,null,null,{"$f":"D504*$L$3","v":1029.4350000000002},852.95375000000013,551.1825,390.12874999999997,278.63]
[36,null,null,{"$f":"D505*$L$3","v":1050.94},874.92624999999998,565.67500000000007,403.68625000000003,286.11]
[37,null,null,{"$f":"D506*$L$3","v":1072.9125000000001},896.66500000000008,579.93375000000003,410.9325,292.88875000000002]
[38,null,null,{"$f":"D507*$L$3","v":1102.365},926.11750000000006,601.90625,424.72375000000005,299.90125]
[39,null,null,{"$f":"D508*$L$3","v":1132.0512500000002},955.33625000000006,622.47624999999994,439.45000000000005,306.68000000000006]
[40,null,null,{"$f":"D509*$L$3","v":1168.5162499999999},977.54250000000002,637.43624999999997,445.52750000000003,314.15999999999997]
[41,null,null,{"$f":"D510*$L$3","v":1197.5012500000003},1007.4625000000001,658.70749999999998,459.78625000000005,320.47125]
[42,null,null,{"$f":"D511*$L$3","v":1227.4212499999999},1035.98,679.745,473.81125000000003,327.71750000000003]
[43,null,null,{"$f":"D512*$L$3","v":1264.35375},1072.9125000000001,701.25,487.60250000000002,341.27500000000003]
[44,null,null,{"$f":"D513*$L$3","v":1300.8187500000001},1102.365,729.76750000000004,501.86125000000004,348.75500000000005]
[45,null,null,{"$f":"D514*$L$3","v":1337.2837500000001},1139.0637500000003,751.03874999999994,516.12,362.31250000000006]
[46,null,null,{"$f":"D515*$L$3","v":1374.45},1175.9962499999999,772.77750000000003,529.67750000000001,369.55875000000003]
[47,null,null,{"$f":"D516*$L$3","v":1410.915},1205.44875,801.52875000000006,543.46875,376.57125000000002]
[48,null,null,{"$f":"D517*$L$3","v":1469.5862500000001},1256.6399999999999,837.05875000000003,564.27250000000004,390.12874999999997]
[49,null,null,{"$f":"D518*$L$3","v":1521.01125},1300.8187500000001,866.04375000000005,585.77750000000003,403.68625000000003]
[50,null,null,{"$f":"D519*$L$3","v":1572.67},1344.9974999999999,901.8075,605.88,410.9325]
[51,null,null,{"$f":"D520*$L$3","v":1623.8612500000002},1395.7212500000001,937.80500000000006,626.91750000000002,424.72375000000005]
[52,null,null,{"$f":"D521*$L$3","v":1675.2862500000001},1440.13375,966.08875,647.72125000000005,439.45000000000005]
[53,null,null,{"$f":"D522*$L$3","v":1741.6712500000001},1498.8050000000001,1008.865,668.75875000000008,453.00750000000005]
[54,null,null,{"$f":"D523*$L$3","v":1807.5887500000001},1558.1775,1052.1087500000001,695.87374999999997,459.78625000000005]
[55,null,null,{"$f":"D524*$L$3","v":1873.74},1617.0825000000002,1094.6512500000001,717.14499999999998,473.81125000000003]
[56,null,null,{"$f":"D525*$L$3","v":1939.6575000000003},1675.2862500000001,1137.6612500000001,744.96125000000006,487.60250000000002]
[57,null,null,{"$f":"D526*$L$3","v":2006.0425},1733.9575000000002,1180.4375,773.245,501.86125000000004]
[58,null,null,{"$f":"D527*$L$3","v":2094.1662500000002},1807.5887500000001,1244.9524999999999,800.82749999999999,516.12]
[59,null,null,{"$f":"D528*$L$3","v":2174.5762500000001},1880.5187500000002,1302.2212500000001,835.42250000000013,529.67750000000001]
[60,null,null,{"$f":"D529*$L$3","v":2263.4012499999999},1962.0975000000001,1359.2562500000001,870.48500000000013,550.48125000000005]
[61,null,null,{"$f":"D530*$L$3","v":2387.9900000000002},2064.48,1438.2637500000001,912.32624999999996,564.27250000000004]
[62,null,null,{"$f":"D531*$L$3","v":2549.51125},2211.0412500000002,1545.32125,975.20500000000004,591.85500000000002]
[63,null,null,{"$f":"D532*$L$3","v":2791.4425000000001},2417.67625,1695.85625,1064.9650000000001,620.37250000000006]
[64,null,null,{"$f":"D533*$L$3","v":3121.9650000000001},2704.02,1902.7250000000001,1190.4887500000002,661.51250000000005]
[65,null,null,{"$f":"D534*$L$3","v":3548.5587500000006},3071.4750000000004,2167.5637500000003,1350.37375,724.39125000000013]
[66,null,null,{"$f":"D535*$L$3","v":4070.0549999999998},3533.8325,2489.2037500000001,1538.3087499999999,800.82749999999999]
[67,null,null,{"$f":"D536*$L$3","v":4657.9362500000007},4054.6275000000005,2861.5675000000001,1754.29375,905.08]
[68,null,null,{"$f":"D537*$L$3","v":5289.0612500000007},4620.7700000000004,3254.7350000000001,1991.0825000000002,1016.5787500000001]
[69,null,null,{"$f":"D538*$L$3","v":5950.34},5216.1312500000004,3669.4075000000003,2240.9612500000003,1142.1025]
[70,null,null,{"$f":"D539*$L$3","v":6633.5912499999995},5824.8162499999999,4112.3637500000004,2520.0587500000001,1274.1712499999999]
[71,null,null,{"$f":"D540*$L$3","v":7338.8150000000005},6463.8887500000001,4577.5262499999999,2811.5450000000001,1413.2525000000001]
[72,null,null,{"$f":"D541*$L$3","v":8065.0762500000001},7110.6750000000002,5063.96,3124.3025000000002,1559.3462500000001]
[73,null,null,{"$f":"D542*$L$3","v":8807.2325000000001},7778.9662500000004,5578.911250000001,3458.7987499999999,1712.4525000000001]
[74,null,null,{"$f":"D543*$L$3","v":9556.401249999999},8462.4512500000001,6115.13375,3813.8650000000002,1865.325]
[75,null,null,{"$f":"D544*$L$3","v":10327.30875},9152.4812500000007,6672.8612500000008,4189.7350000000006,2025.6775]
[76,null,null,{"$f":"D545*$L$3","v":11106.397500000001},9857.2375000000011,7252.5612500000007,4586.4087499999996,2192.3412499999999]
[77,null,null,{"$f":"D546*$L$3","v":11899.2775},10569.7075,7852.8312500000002,5003.6525000000001,2366.0174999999999]
[78,null,null,{"$f":"D547*$L$3","v":12699.87125},11297.137500000001,8482.5537500000009,5441.9337500000001,2540.8625000000002]
[79,null,null,{"$f":"D548*$L$3","v":13508.4125},12024.33375,9133.08,5894.473750000001,2728.33]
[80,"o mas",null,{"$f":"D549*$L$3","v":14323.031250000002},12766.49,9805.5787500000006,6374.5962500000005,2909.7200000000003]
[1,"Hijo",null,{"$f":"D550*$L$3","v":382.41500000000002},221.12750000000003,164.79375000000002,118.74500000000002,84.15]
[2,"Hijos",null,{"$f":"D551*$L$3","v":639.30625000000009},331.69124999999997,258.29375000000005,182.09125,125.99125000000001]
[3,"Hijos o más",null,{"$f":"D552*$L$3","v":940.84375000000011},478.01875000000001,372.36375000000004,265.30625000000003,188.40250000000003]
[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]