{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["INGRESO DE DATOS","Essential Care","Unique Care","Unique Care - Deducible Cero","Advantage (LA)","Blue 500","Blue 100","Elite Care","Resumen tarifas anuales","Tablas"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INGRESO DE DATOS","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,9],[11,7,11,8],[7,3,7,9],[17,3,17,6],[9,3,9,5],[9,7,9,8],[1,1,1,8],[2,0,2,8]]}
["COTIZACION DE SEGURO MEDICO INTERNACIONAL"]
[null," Tarifas efectivas a partir del 1ro de enero de 2021",null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
["1. INGRESE LOS DATOS DEL PROPUESTO ASEGURADO:"]
[]
[null,null,"Nombre del Asegurado Principal :","Nombre"]
[null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,"Número de Adultos:",null,null,2,"Número de Hijos:",null,3]
[]
[null,null,null,null,null," Edad de Titular:",32,"Edad de Cónyuge:",null,46]
[]
[null,null,null,null,null,"Descuento:",0]
[]
["2. INGRESE EL NOMBRE DE LA AGENCIA ASESORA:"]
[]
[null,null,"Intermediario:","Agente / Agencia"]
[]
[]
["3. ESCOJA EL PRODUCTO PARA VISUALIZAR LA COTIZACION RESPECTIVA:"]

{"sheet":"Essential Care","index":1,"n_rows":90,"n_cols":9,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,3,0,8],[1,3,1,8],[1,0,1,1],[33,0,33,1],[28,0,28,1],[24,0,24,1],[22,3,22,9],[32,3,32,9],[3,0,3,1],[5,4,5,9],[7,4,7,9],[9,0,9,1],[15,0,15,1],[17,3,17,9],[44,3,44,9],[69,3,71,9],[88,0,88,1],[89,0,89,1],[87,0,87,1],[68,3,68,9],[56,3,56,9]]}
[null,null,null,"Cotización de Seguro Médico Internacional"]
["BUPA ESSENTIAL CARE",null,null,"Producto: Bupa Essential Care"]
[]
[]
[]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$8","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$18","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-02-17"},null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G14>0,'INGRESO DE DATOS'!G14,\"\")","v":""}]
[]
[null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!G10","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$12","v":32}]
[]
[null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$10","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$12","v":46}]
[]
[]
[null,null,null,null,null,null,true]
[null,null,null,"Deducibles"]
[null,null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4"]
[null,null,null,"Dentro del pais de residencia",null,0,0,500,2000]
[null,null,null,"Fuera del pais de residencia",null,1000,2000,3000,5000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($I$12,Tablas!$A$6:$H$29,4,TRUE)","v":1829},{"$f":"VLOOKUP($I$12,Tablas!$A$6:$H$29,5,TRUE)","v":1661},{"$f":"VLOOKUP($I$12,Tablas!$A$6:$H$29,6,TRUE)","v":1509},{"$f":"VLOOKUP($I$12,Tablas!$A$6:$H$29,7,TRUE)","v":1301}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$6:$H$29,4,TRUE)))","v":2894},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$6:$H$29,5,TRUE)))","v":2628},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$6:$H$29,6,TRUE)))","v":2388},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$6:$H$29,7,TRUE)))","v":2058}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$30:$H$32,4,TRUE)))","v":1147},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$30:$H$32,5,TRUE)))","v":1042},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$30:$H$32,6,TRUE)))","v":947},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$30:$H$32,7,TRUE)))","v":816}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F24:F26)","v":5870},{"$f":"SUM(G24:G26)","v":5331},{"$f":"SUM(H24:H26)","v":4844},{"$f":"SUM(I24:I26)","v":4175}]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F24+F25+F26)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G24+G25+G26)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H24+H25+H26)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I24+I25+I26)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F27+F28+F29)*0%","v":0},{"$f":"+(G27+G28+G29)*0%","v":0},0,0]
[null,null,null,"TOTAL",null,{"$f":"SUM(F27:F30)","v":5945},{"$f":"SUM(G27:G30)","v":5406},4919,4250]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($I$12,Tablas!$A$39:$H$62,4,TRUE)","v":914.5},{"$f":"VLOOKUP($I$12,Tablas!$A$39:$H$62,5,TRUE)","v":830.5},{"$f":"VLOOKUP($I$12,Tablas!$A$39:$H$62,6,TRUE)","v":754.5},{"$f":"VLOOKUP($I$12,Tablas!$A$39:$H$62,7,TRUE)","v":650.5}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$39:$H$62,4,TRUE)))","v":1447},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$39:$H$62,5,TRUE)))","v":1314},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$39:$H$62,6,TRUE)))","v":1194},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$39:$H$62,7,TRUE)))","v":1029}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$63:$H$65,4,TRUE)))","v":573.5},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$63:$H$65,5,TRUE)))","v":521},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$63:$H$65,6,TRUE)))","v":473.5},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$63:$H$65,7,TRUE)))","v":408}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F34:F36)","v":2935},{"$f":"SUM(G34:G36)","v":2665.5},{"$f":"SUM(H34:H36)","v":2422},{"$f":"SUM(I34:I36)","v":2087.5}]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F34+F35+F36)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G34+G35+G36)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H34+H35+H36)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I34+I35+I36)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F37+F38+F39)*0%","v":0},{"$f":"+(G37+G38+G39)*0%","v":0},0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F37:F40)","v":3010},{"$f":"SUM(G37:G40)","v":2740.5},{"$f":"SUM(H37:H40)","v":2497},{"$f":"SUM(I37:I40)","v":2162.5}]
[null,null,null,"2da Cuota",null,{"$f":"F37+F38+F40","v":2935},{"$f":"G37+G38+G40","v":2665.5},2422,2087.5]
[null,null,null,"TOTAL",null,{"$f":"F41+F42","v":5945},{"$f":"G41+G42","v":5406},4919,4250]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($I$12,Tablas!$A$923:$H$946,4,TRUE)","v":457.25},{"$f":"VLOOKUP($I$12,Tablas!$A$923:$H$946,5,TRUE)","v":415.25},{"$f":"VLOOKUP($I$12,Tablas!$A$923:$H$946,6,TRUE)","v":377.25},{"$f":"VLOOKUP($I$12,Tablas!$A$923:$H$946,7,TRUE)","v":325.25}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$923:$H$946,4,TRUE)))","v":723.5},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$923:$H$946,5,TRUE)))","v":657},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$923:$H$946,6,TRUE)))","v":597},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$923:$H$946,7,TRUE)))","v":514.5}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$947:$H$949,4,TRUE)))","v":286.75},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$947:$H$949,5,TRUE)))","v":260.5},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$947:$H$949,6,TRUE)))","v":236.75},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$947:$H$949,7,TRUE)))","v":204}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F46:F48)","v":1467.5},{"$f":"SUM(G46:G48)","v":1332.75},{"$f":"SUM(H46:H48)","v":1211},{"$f":"SUM(I46:I48)","v":1043.75}]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G26>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F46+F47+F48)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G46+G47+G48)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H46+H47+H48)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I46+I47+I48)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F49+F50+F51)*0%","v":0},{"$f":"+(G49+G50+G51)*0%","v":0},0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F49:F52)","v":1542.5},{"$f":"SUM(G49:G52)","v":1407.75},{"$f":"SUM(H49:H52)","v":1286},{"$f":"SUM(I49:I52)","v":1118.75}]
[null,null,null,"2da a 4ta Cuota",null,{"$f":"F49+F50+F52","v":1467.5},{"$f":"G49+G50+G52","v":1332.75},1211,1043.75]
[null,null,null,"TOTAL",null,{"$f":"F53+F54*3","v":5945},{"$f":"G53+G54*3","v":5406},4919,4250]
[]
[null,null,null,"Tarifas Mensuales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($I$12,Tablas!$A$1215:$H$1243,4,TRUE)","v":170.70666605700001},{"$f":"VLOOKUP($I$12,Tablas!$A$1215:$H$1243,5,TRUE)","v":155.026666113},{"$f":"VLOOKUP($I$12,Tablas!$A$1215:$H$1243,6,TRUE)","v":140.83999949700001},{"$f":"VLOOKUP($I$12,Tablas!$A$1215:$H$1243,7,TRUE)","v":121.42666623300001}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$1215:$H$1243,4,TRUE)))","v":270.10666570199999},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$1215:$H$1243,5,TRUE)))","v":245.279999124},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$1215:$H$1243,6,TRUE)))","v":222.879999204},{"$f":"IF($F$12=1,0,(VLOOKUP($I$14,Tablas!$A$1215:$H$1243,7,TRUE)))","v":192.07999931400002}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$1239:$H$1241,4,TRUE)))","v":107.053332951},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$1239:$H$1241,5,TRUE)))","v":97.253332986000004},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$1239:$H$1241,6,TRUE)))","v":88.386666351000002},{"$f":"IF($F$14=0,0,(VLOOKUP($F$14,Tablas!$A$1239:$H$1241,7,TRUE)))","v":76.159999728000003}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F58:F60)","v":547.86666471000001},{"$f":"SUM(G58:G60)","v":497.55999822299998},{"$f":"SUM(H58:H60)","v":452.10666505200004},{"$f":"SUM(I58:I60)","v":389.66666527500001}]
[null,null,null,"",null,0,0,0,0]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F61+F62+F63)*0%","v":0},{"$f":"+(G61+G62+G63)*0%","v":0},0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F61:F64)","v":622.86666471000001},{"$f":"SUM(G61:G64)","v":572.55999822299998},{"$f":"SUM(H61:H64)","v":527.10666505200004},{"$f":"SUM(I61:I64)","v":464.66666527500001}]
[null,null,null,"2da a 12va Cuota",null,{"$f":"F61+F62+F64","v":547.86666471000001},{"$f":"G61+G62+G64","v":497.55999822299998},452.10666505200004,389.66666527500001]
[null,null,null,"TOTAL",null,{"$f":"F65+F66*11","v":6649.3999765199997},{"$f":"G65+G66*11","v":6045.7199786759993},5500.279980624,4750.9999833000002]
[]
[null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2021"]
[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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bupa Guatemala, Compañía de Seguros, S.A."]
["5 Avenida 5-55 Zona 14, Europlaza World Business Center, Torre 3, Nivel 11, Guatemala"]
["PBX: 2300-8000 / www.bupasalud.com / servicioguatemala@bupalatinamerica.com"]

{"sheet":"Unique Care","index":2,"n_rows":88,"n_cols":11,"rows_kept":88,"cut":false,"hidden":false,"merged":[[85,3,87,9],[54,3,54,9],[69,3,69,9],[85,0,85,1],[86,0,86,1],[87,0,87,1],[39,3,39,9],[84,3,84,9],[51,0,51,1],[32,0,32,1],[0,3,0,8],[1,3,1,8],[1,0,1,1],[5,4,5,9],[7,4,7,9],[37,0,37,1],[21,3,21,9],[5,0,5,1],[11,0,11,1],[17,0,17,1],[26,0,26,1],[26,3,26,9]]}
[null,null,null,"Cotización de Seguro Médico Internacional"]
["BUPA UNIQUE CARE",null,null,"Producto: Bupa Unique Care"]
[]
[]
[null,null,null,null,null,null,null," "," "," "," "]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$8","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$18","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-02-17"},null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G14>0,'INGRESO DE DATOS'!G14,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$10","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$12","v":32}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$10","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$12","v":46}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,"Coberturas / Anexos Adicionales:",null,"Complicaciones de Maternidad (+ $500,000)"]
[null,null,null,null,null,true]
[null,null,null,null,null,true,null,"Trasplante de Órganos (+ $500,000)"]
[null,null,null,null,null,true]
[null,null,null," ",null,null,null,"Eliminación de Deducible"]
[]
[null,null,null,"Deducibles"]
[null,null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5"]
[null,null,null,"Dentro del pais de residencia",null,250,1000,2000,5000,10000]
[null,null,null,"Fuera del pais de residencia",null,1000,2000,3000,5000,10000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$274:$H$336,4,TRUE)","v":3098},{"$f":"VLOOKUP($J$12,Tablas!$A$274:$H$336,5,TRUE)","v":2360},{"$f":"VLOOKUP($J$12,Tablas!$A$274:$H$336,6,TRUE)","v":1947},{"$f":"VLOOKUP($J$12,Tablas!$A$274:$H$336,7,TRUE)","v":1679},{"$f":"VLOOKUP($J$12,Tablas!$A$274:$H$336,8,TRUE)","v":1357}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$274:$H$336,4,TRUE)))","v":4635},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$274:$H$336,5,TRUE)))","v":3474},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$274:$H$336,6,TRUE)))","v":2999},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$274:$H$336,7,TRUE)))","v":2532},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$274:$H$336,8,TRUE)))","v":2042}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$337:$H$339,4,TRUE)))","v":2743},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$337:$H$339,5,TRUE)))","v":2316},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$337:$H$339,6,TRUE)))","v":1234},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$337:$H$339,7,TRUE)))","v":1180},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$337:$H$339,8,TRUE)))","v":992}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$17=FALSE,0,Tablas!D$340)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!E$340)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!F$340)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!G$340)","v":225},{"$f":"+IF($F$17=FALSE,0,Tablas!H$340)","v":225}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!D$341)","v":300},{"$f":"IF($F$18=FALSE,0,Tablas!E$341)","v":300},{"$f":"IF($F$18=FALSE,0,Tablas!F$341)","v":300},{"$f":"IF($F$18=FALSE,0,Tablas!G$341)","v":300},{"$f":"IF($F$18=FALSE,0,Tablas!H$341)","v":300}]
[null,null,null,"Anexo: Eliminacion de Deducible",null,{"$f":"IF($F$19=FALSE,0,Tablas!D$342)","v":45},{"$f":"IF($F$19=FALSE,0,Tablas!E$342)","v":180},{"$f":"IF($F$19=FALSE,0,Tablas!F$342)","v":345},{"$f":"IF($F$19=FALSE,0,Tablas!G$342)","v":775},{"$f":"IF($F$19=FALSE,0,Tablas!H$342)","v":1330}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F28:F33)","v":10821},{"$f":"SUM(G28:G33)","v":8630},6825,6691,6246]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F28+F29+F30)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G28+G29+G30)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H28+H29+H30)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I28+I29+I30)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(J28+J29+J30)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F34+F35+F36)*0%","v":0},{"$f":"+(G34+G35+G36)*0%","v":0},0,0,0]
[null,null,null,"TOTAL",null,{"$f":"SUM(F34:F37)","v":10896},{"$f":"SUM(G34:G37)","v":8705},{"$f":"SUM(H34:H37)","v":6900},{"$f":"SUM(I34:I37)","v":6766},{"$f":"SUM(J34:J37)","v":6321}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$346:$H$408,4,TRUE)","v":1549},{"$f":"VLOOKUP($J$12,Tablas!$A$346:$H$408,5,TRUE)","v":1180},{"$f":"VLOOKUP($J$12,Tablas!$A$346:$H$408,6,TRUE)","v":973.5},{"$f":"VLOOKUP($J$12,Tablas!$A$346:$H$408,7,TRUE)","v":839.5},{"$f":"VLOOKUP($J$12,Tablas!$A$346:$H$408,8,TRUE)","v":678.5}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$346:$H$408,4,TRUE)))","v":2317.5},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$346:$H$408,5,TRUE)))","v":1737},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$346:$H$408,6,TRUE)))","v":1499.5},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$346:$H$408,7,TRUE)))","v":1266},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$346:$H$408,8,TRUE)))","v":1021}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$409:$H$411,4,TRUE)))","v":1371.5},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$409:$H$411,5,TRUE)))","v":1158},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$409:$H$411,6,TRUE)))","v":617},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$409:$H$411,7,TRUE)))","v":590},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$409:$H$411,8,TRUE)))","v":496}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$17=FALSE,0,Tablas!D$412)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!E$412)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!F$412)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!G$412)","v":112.5},{"$f":"+IF($F$17=FALSE,0,Tablas!H$412)","v":112.5}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!D$413)","v":150},{"$f":"IF($F$18=FALSE,0,Tablas!E$413)","v":150},{"$f":"IF($F$18=FALSE,0,Tablas!F$413)","v":150},{"$f":"IF($F$18=FALSE,0,Tablas!G$413)","v":150},{"$f":"IF($F$18=FALSE,0,Tablas!H$413)","v":150}]
[null,null,null,"Anexo: Eliminacion de Deducible",null,{"$f":"IF($F$19=FALSE,0,Tablas!D$414)","v":22.5},{"$f":"IF($F$19=FALSE,0,Tablas!E$414)","v":90},{"$f":"IF($F$19=FALSE,0,Tablas!F$414)","v":172.5},{"$f":"IF($F$19=FALSE,0,Tablas!G$414)","v":387.5},{"$f":"IF($F$19=FALSE,0,Tablas!H$414)","v":665}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F41:F46)","v":5410.5},{"$f":"SUM(G41:G46)","v":4315},3412.5,3345.5,3123]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F41+F42+F43)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G41+G42+G43)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H41+H42+H43)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I41+I42+I43)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(J41+J42+J43)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F47+F48+F49)*0%","v":0},{"$f":"+(G47+G48+G49)*0%","v":0},0,0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F47:F50)","v":5485.5},{"$f":"SUM(G47:G50)","v":4390},{"$f":"SUM(H47:H50)","v":3487.5},{"$f":"SUM(I47:I50)","v":3420.5},{"$f":"SUM(J47:J50)","v":3198}]
[null,null,null,"2da Cuota",null,{"$f":"F47+F48+F50","v":5410.5},{"$f":"G47+G48+G50","v":4315},3412.5,3345.5,3123]
[null,null,null,"TOTAL",null,{"$f":"F51+F52","v":10896},{"$f":"G51+G52","v":8705},6900,6766,6321]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$991:$H$1053,4,TRUE)","v":774.5},{"$f":"VLOOKUP($J$12,Tablas!$A$991:$H$1053,5,TRUE)","v":590},{"$f":"VLOOKUP($J$12,Tablas!$A$991:$H$1053,6,TRUE)","v":486.75},{"$f":"VLOOKUP($J$12,Tablas!$A$991:$H$1053,7,TRUE)","v":419.75},{"$f":"VLOOKUP($J$12,Tablas!$A$991:$H$1053,8,TRUE)","v":339.25}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$991:$H$1053,4,TRUE)))","v":1158.75},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$991:$H$1053,5,TRUE)))","v":868.5},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$991:$H$1053,6,TRUE)))","v":749.75},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$991:$H$1053,7,TRUE)))","v":633},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$991:$H$1053,8,TRUE)))","v":510.5}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1054:$H$1056,4,TRUE)))","v":685.75},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1054:$H$1056,5,TRUE)))","v":579},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1054:$H$1056,6,TRUE)))","v":308.5},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1054:$H$1056,7,TRUE)))","v":295},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1054:$H$1056,8,TRUE)))","v":248}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$17=FALSE,0,Tablas!D$1057)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!E$1057)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!F$1057)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!G$1057)","v":56.25},{"$f":"+IF($F$17=FALSE,0,Tablas!H$1057)","v":56.25}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!D$1058)","v":75},{"$f":"IF($F$18=FALSE,0,Tablas!E$1058)","v":75},{"$f":"IF($F$18=FALSE,0,Tablas!F$1058)","v":75},{"$f":"IF($F$18=FALSE,0,Tablas!G$1058)","v":75},{"$f":"IF($F$18=FALSE,0,Tablas!H$1058)","v":75}]
[null,null,null,"Anexo: Eliminacion de Deducible",null,{"$f":"IF($F$19=FALSE,0,Tablas!D$1059)","v":11.25},{"$f":"IF($F$19=FALSE,0,Tablas!E$1059)","v":45},{"$f":"IF($F$19=FALSE,0,Tablas!F$1059)","v":86.25},{"$f":"IF($F$19=FALSE,0,Tablas!G$1059)","v":193.75},{"$f":"IF($F$19=FALSE,0,Tablas!H$1059)","v":332.5}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F56:F61)","v":2705.25},{"$f":"SUM(G56:G61)","v":2157.5},1706.25,1672.75,1561.5]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G28>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F56+F57+F58)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G56+G57+G58)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H56+H57+H58)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I56+I57+I58)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(J56+J57+J58)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F62+F63+F64)*0%","v":0},{"$f":"+(G62+G63+G64)*0%","v":0},0,0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F62:F65)","v":2780.25},{"$f":"SUM(G62:G65)","v":2232.5},{"$f":"SUM(H62:H65)","v":1781.25},{"$f":"SUM(I62:I65)","v":1747.75},{"$f":"SUM(J62:J65)","v":1636.5}]
[null,null,null,"2da a 4ta Cuota",null,{"$f":"F62+F63+F65","v":2705.25},{"$f":"G62+G63+G65","v":2157.5},1706.25,1672.75,1561.5]
[null,null,null,"TOTAL",null,{"$f":"F66+F67*3","v":10896},{"$f":"G66+G67*3","v":8705},6900,6766,6321]
[]
[null,null,null,"Tarifas Mensuales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$1250:$H$1318,4,TRUE)","v":289.14666563399999},{"$f":"VLOOKUP($J$12,Tablas!$A$1250:$H$1318,5,TRUE)","v":220.26666588000001},{"$f":"VLOOKUP($J$12,Tablas!$A$1250:$H$1318,6,TRUE)","v":181.71999935100001},{"$f":"VLOOKUP($J$12,Tablas!$A$1250:$H$1318,7,TRUE)","v":156.70666610700002},{"$f":"VLOOKUP($J$12,Tablas!$A$1250:$H$1318,8,TRUE)","v":126.65333288100001}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1250:$H$1318,4,TRUE)))","v":432.59999845500005},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1250:$H$1318,5,TRUE)))","v":324.23999884200003},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1250:$H$1318,6,TRUE)))","v":279.90666566700003},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1250:$H$1318,7,TRUE)))","v":236.31999915600002},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1250:$H$1318,8,TRUE)))","v":190.58666598600001}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1313:$H$1315,4,TRUE)))","v":256.01333241899999},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1313:$H$1315,5,TRUE)))","v":216.159999228},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1313:$H$1315,6,TRUE)))","v":115.173332922},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1313:$H$1315,7,TRUE)))","v":110.13333294},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1313:$H$1315,8,TRUE)))","v":92.586666336000008}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$17=FALSE,0,Tablas!D$1057)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!E$1057)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!F$1057)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!G$1057)","v":56.25},{"$f":"+IF($F$17=FALSE,0,Tablas!H$1057)","v":56.25}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!$D$1317)","v":27.999999900000002},{"$f":"IF($F$18=FALSE,0,Tablas!$D$1317)","v":27.999999900000002},{"$f":"IF($F$18=FALSE,0,Tablas!$D$1317)","v":27.999999900000002},{"$f":"IF($F$18=FALSE,0,Tablas!$D$1317)","v":27.999999900000002},{"$f":"IF($F$18=FALSE,0,Tablas!$D$1317)","v":27.999999900000002}]
[null,null,null,"Anexo: Eliminacion de Deducible",null,{"$f":"IF($F$19=FALSE,0,Tablas!D1318)","v":4.1999999849999998},{"$f":"IF($F$19=FALSE,0,Tablas!E1318)","v":16.799999939999999},{"$f":"IF($F$19=FALSE,0,Tablas!F1318)","v":32.199999885000004},{"$f":"IF($F$19=FALSE,0,Tablas!G1318)","v":72.333333074999999},{"$f":"IF($F$19=FALSE,0,Tablas!H1318)","v":124.13333289000001}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F71:F76)","v":1009.959996393},{"$f":"SUM(G71:G76)","v":805.46666379000021},636.99999772500007,659.74333117800006,618.209997993]
[null,null,null,"",null,0,0,0,0,0]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F77+F78+F79)*0%","v":0},{"$f":"+(G77+G78+G79)*0%","v":0},0,0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F77:F80)","v":1084.959996393},{"$f":"SUM(G77:G80)","v":880.46666379000021},{"$f":"SUM(H77:H80)","v":711.99999772500007},{"$f":"SUM(I77:I80)","v":734.74333117800006},{"$f":"SUM(J77:J80)","v":693.209997993}]
[null,null,null,"2da a 12va Cuota",null,{"$f":"F77+F78+F80","v":1009.959996393},{"$f":"G77+G78+G80","v":805.46666379000021},636.99999772500007,659.74333117800006,618.209997993]
[null,null,null,"TOTAL",null,{"$f":"F81+F82*11","v":12194.519956716},{"$f":"G81+G82*11","v":9740.5999654800034},7718.9999727000004,7991.9199741360007,7493.5199759159996]
[]
[null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2021"]
["Bupa Guatemala, Compañía de Seguros, S.A.",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."]
["5 Avenida 5-55 Zona 14, Europlaza World Business Center, Torre 3, Nivel 11, Guatemala"]
["PBX: 2300-8000 / www.bupasalud.com / servicioguatemala@bupalatinamerica.com"]

{"sheet":"Unique Care - Deducible Cero","index":3,"n_rows":93,"n_cols":12,"rows_kept":93,"cut":false,"hidden":false,"merged":[[13,0,13,1],[0,3,0,8],[1,3,1,8],[1,0,1,1],[5,4,5,9],[7,4,7,9],[7,0,7,1],[79,3,81,9],[92,0,92,1],[78,3,78,9],[19,3,19,9],[24,3,24,9],[36,3,36,9],[27,0,27,1],[19,0,19,1],[32,0,32,1],[37,0,37,1],[49,0,49,1],[50,3,50,9],[90,0,90,1],[91,0,91,1],[64,3,64,9]]}
[null,null,null,"Cotización de Seguro Médico Internacional"]
["BUPA UNIQUE CARE - DEDUCIBLE CERO",null,null,"Producto: Bupa Unique Care - Deducible Cero",null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$8","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$18","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-02-17"},null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G14>0,'INGRESO DE DATOS'!G14,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$10","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$12","v":32}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$10","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$12","v":46}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,true,null,"Complicaciones de Maternidad (+ $500,000)"]
[]
[null,null,null,null,null,true,false,"Trasplante de Órganos (+ $500,000)"]
[]
[null,null,null,"Deducibles"]
[null,null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4"]
[null,null,null,"Dentro del pais de residencia",null,0,0,0,0]
[null,null,null,"Fuera del pais de residencia",null,1000,2000,3000,5000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$633:$H$695,4,TRUE)","v":3346},{"$f":"VLOOKUP($J$12,Tablas!$A$633:$H$695,5,TRUE)","v":2944},{"$f":"VLOOKUP($J$12,Tablas!$A$633:$H$695,6,TRUE)","v":2634},{"$f":"VLOOKUP($J$12,Tablas!$A$633:$H$695,7,TRUE)","v":2324}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$633:$H$695,4,TRUE)))","v":5006},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$633:$H$695,5,TRUE)))","v":4404},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$633:$H$695,6,TRUE)))","v":3941},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$633:$H$695,7,TRUE)))","v":3477}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$696:$H$700,4,TRUE)))","v":2963},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$696:$H$700,5,TRUE)))","v":2606},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$696:$H$700,6,TRUE)))","v":2333},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$696:$H$700,7,TRUE)))","v":2058}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$16=FALSE,0,Tablas!D$699)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!E$699)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!F$699)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!G$699)","v":225}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!D$341)","v":300},{"$f":"IF($F$18=FALSE,0,Tablas!E$341)","v":300},{"$f":"IF($F$18=FALSE,0,Tablas!F$341)","v":300},{"$f":"IF($F$18=FALSE,0,Tablas!G$341)","v":300}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F26:F30)","v":11615},{"$f":"SUM(G26:G30)","v":10254},9208,8384]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F26+F27+F28)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G26+G27+G28)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H26+H27+H28)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I26+I27+I28)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F31+F32+F33)*0%","v":0},{"$f":"+(G31+G32+G33)*0%","v":0},0,0]
[null,null,null,"TOTAL",null,{"$f":"SUM(F31:F34)","v":11690},{"$f":"SUM(G31:G34)","v":10329},{"$f":"SUM(H31:H34)","v":9283},{"$f":"SUM(I31:I34)","v":8459}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$705:$H$767,4,TRUE)","v":1673},{"$f":"VLOOKUP($J$12,Tablas!$A$705:$H$767,5,TRUE)","v":1472},{"$f":"VLOOKUP($J$12,Tablas!$A$705:$H$767,6,TRUE)","v":1317},{"$f":"VLOOKUP($J$12,Tablas!$A$705:$H$767,7,TRUE)","v":1162}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$705:$H$767,4,TRUE)))","v":2503},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$705:$H$767,5,TRUE)))","v":2202},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$705:$H$767,6,TRUE)))","v":1970.5},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$705:$H$767,7,TRUE)))","v":1738.5}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$768:$H$772,4,TRUE)))","v":1481.5},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$768:$H$772,5,TRUE)))","v":1303},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$768:$H$772,6,TRUE)))","v":1166.5},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$768:$H$772,7,TRUE)))","v":1029}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$16=FALSE,0,Tablas!D$771)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!E$771)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!F$771)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!G$771)","v":112.5}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!D$413)","v":150},{"$f":"IF($F$18=FALSE,0,Tablas!E$413)","v":150},{"$f":"IF($F$18=FALSE,0,Tablas!F$413)","v":150},{"$f":"IF($F$18=FALSE,0,Tablas!G$413)","v":150}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F38:F42)","v":5807.5},{"$f":"SUM(G38:G42)","v":5127},4604,4192]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F38+F39+F40)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G38+G39+G40)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H38+H39+H40)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I38+I39+I40)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F43+F44+F45)*0%","v":0},{"$f":"+(G43+G44+G45)*0%","v":0},0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F43:F46)","v":5882.5},{"$f":"SUM(G43:G46)","v":5202},{"$f":"SUM(H43:H46)","v":4679},{"$f":"SUM(I43:I46)","v":4267}]
[null,null,null,"2da Cuota",null,{"$f":"F43+F44+F46","v":5807.5},{"$f":"G43+G44+G46","v":5127},4604,4192]
[null,null,null,"TOTAL",null,{"$f":"F47+F48","v":11690},{"$f":"G47+G48","v":10329},9283,8459]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$1139:$H$1201,4,TRUE)","v":836.5},{"$f":"VLOOKUP($J$12,Tablas!$A$1139:$H$1201,5,TRUE)","v":736},{"$f":"VLOOKUP($J$12,Tablas!$A$1139:$H$1201,6,TRUE)","v":658.5},{"$f":"VLOOKUP($J$12,Tablas!$A$1139:$H$1201,7,TRUE)","v":581}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1139:$H$1201,4,TRUE)))","v":1251.5},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1139:$H$1201,5,TRUE)))","v":1101},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1139:$H$1201,6,TRUE)))","v":985.25},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1139:$H$1201,7,TRUE)))","v":869.25}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1202:$H$1207,4,TRUE)))","v":740.75},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1202:$H$1207,5,TRUE)))","v":651.5},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1202:$H$1207,6,TRUE)))","v":583.25},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1202:$H$1207,7,TRUE)))","v":514.5}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$16=FALSE,0,Tablas!D1205)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!E1205)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!F1205)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!G1205)","v":56.25}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!D$1206)","v":75},{"$f":"IF($F$18=FALSE,0,Tablas!E$1206)","v":75},{"$f":"IF($F$18=FALSE,0,Tablas!F$1206)","v":75},{"$f":"IF($F$18=FALSE,0,Tablas!G$1206)","v":75}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F52:F56)","v":2903.75},{"$f":"SUM(G52:G56)","v":2563.5},2302,2096]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G27>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F52+F53+F54)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G52+G53+G54)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H52+H53+H54)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I52+I53+I54)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75]
[null,null,null,null,null,{"$f":"+(F57+F58+F59)*0%","v":0},{"$f":"+(G57+G58+G59)*0%","v":0},0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F57:F60)","v":2978.75},{"$f":"SUM(G57:G60)","v":2638.5},{"$f":"SUM(H57:H60)","v":2377},{"$f":"SUM(I57:I60)","v":2171}]
[null,null,null,"2da a 4ta Cuota",null,{"$f":"F57+F58+F60","v":2903.75},{"$f":"G57+G58+G60","v":2563.5},2302,2096]
[null,null,null,"TOTAL",null,{"$f":"F61+F62*3","v":11690},{"$f":"G61+G62*3","v":10329},9283,8459]
[]
[null,null,null,"Tarifas Mensuales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$1324:$H$1391,4,TRUE)","v":312.29333221799999},{"$f":"VLOOKUP($J$12,Tablas!$A$1324:$H$1391,5,TRUE)","v":274.77333235200001},{"$f":"VLOOKUP($J$12,Tablas!$A$1324:$H$1391,6,TRUE)","v":245.83999912200002},{"$f":"VLOOKUP($J$12,Tablas!$A$1324:$H$1391,7,TRUE)","v":216.90666589200001}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1324:$H$1391,4,TRUE)))","v":467.22666499800005},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1324:$H$1391,5,TRUE)))","v":411.03999853200003},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1324:$H$1391,6,TRUE)))","v":367.82666535300001},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1324:$H$1391,7,TRUE)))","v":324.51999884100002}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1387:$H$1389,4,TRUE)))","v":276.546665679},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1387:$H$1389,5,TRUE)))","v":243.226665798},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1387:$H$1389,6,TRUE)))","v":217.74666588900001},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1387:$H$1389,7,TRUE)))","v":192.07999931400002}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$16=FALSE,0,Tablas!D$1390)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!E$1390)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!F$1390)","v":0},{"$f":"+IF($F$16=FALSE,0,Tablas!G$1390)","v":20.999999925000001}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!D1391)","v":27.999999900000002},{"$f":"IF($F$18=FALSE,0,Tablas!E1391)","v":27.999999900000002},{"$f":"IF($F$18=FALSE,0,Tablas!F1391)","v":27.999999900000002},{"$f":"IF($F$18=FALSE,0,Tablas!G1391)","v":27.999999900000002}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F66:F70)","v":1084.066662795},{"$f":"SUM(G66:G70)","v":957.03999658200007},859.41333026400014,782.5066638720001]
[null,null,null,"",null,0,0,0,0]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F71+F72+F73)*0%","v":0},{"$f":"+(G71+G72+G73)*0%","v":0},0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F71:F74)","v":1159.066662795},{"$f":"SUM(G71:G74)","v":1032.0399965820002},{"$f":"SUM(H71:H74)","v":934.41333026400014},{"$f":"SUM(I71:I74)","v":857.5066638720001}]
[null,null,null,"2da a 12va Cuota",null,{"$f":"F71+F72+F74","v":1084.066662795},{"$f":"G71+G72+G74","v":957.03999658200007},859.41333026400014,782.5066638720001]
[null,null,null,"TOTAL",null,{"$f":"F75+F76*11","v":13083.799953539999},{"$f":"G75+G76*11","v":11559.479958984},10387.959963168001,9465.0799664640017]
[]
[null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2021"]
[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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bupa Guatemala, Compañía de Seguros, S.A."]
["5 Avenida 5-55 Zona 14, Europlaza World Business Center, Torre 3, Nivel 11, Guatemala"]
["PBX: 2300-8000 / www.bupasalud.com / servicioguatemala@bupalatinamerica.com"]

{"sheet":"Advantage (LA)","index":4,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":true,"merged":[[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
["Bupa Advantage Care (cobertura solo en Latinoamérica)",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$8","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$18","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$10","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$12","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":"2021-02-17T17:46:42.250"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$10","v":3},null,null,{"$f":"+'INGRESO DE DATOS'!$J$12","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":3757},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,5,TRUE)))","v":2580},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,6,TRUE)))","v":2048},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,7,TRUE)))","v":1803},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$444:$H$446,8,TRUE)))","v":1269}]
["Ambulancia aérea",null,"$100,000 por año y ticket aéreo de retorno",null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$447)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$447)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$447)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$447)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$447)","v":225}]
["Repatriación restos mortales",null,1,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$448)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$448)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$448)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$448)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$448)","v":300}]
["Medicamentos por receta",null,"$6,000 por Asegurado, por año póliza",null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":15449},11648,9090,7375,5698]
["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":15524},{"$f":"SUM(J36:J37)","v":11723},{"$f":"SUM(K36:K37)","v":9165},{"$f":"SUM(L36:L37)","v":7450},{"$f":"SUM(M36:M37)","v":5773}]
["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":2275},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,5,TRUE)","v":1740},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,6,TRUE)","v":1345},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,7,TRUE)","v":1029.5},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,8,TRUE)","v":793.5}]
["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":3308.5},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,5,TRUE)))","v":2531.5},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,6,TRUE)))","v":1913.5},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,7,TRUE)))","v":1494},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,8,TRUE)))","v":1158.5}]
["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":1878.5},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,5,TRUE)))","v":1290},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,6,TRUE)))","v":1024},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,7,TRUE)))","v":901.5},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,8,TRUE)))","v":634.5}]
["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":112.5},{"$f":"+IF($I$20=FALSE,0,Tablas!E$480)","v":112.5},{"$f":"+IF($I$20=FALSE,0,Tablas!F$480)","v":112.5},{"$f":"+IF($I$20=FALSE,0,Tablas!G$480)","v":112.5},{"$f":"+IF($I$20=FALSE,0,Tablas!H$480)","v":112.5}]
["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":150},{"$f":"IF($I$22=FALSE,0,Tablas!E$481)","v":150},{"$f":"IF($I$22=FALSE,0,Tablas!F$481)","v":150},{"$f":"IF($I$22=FALSE,0,Tablas!G$481)","v":150},{"$f":"IF($I$22=FALSE,0,Tablas!H$481)","v":150}]
["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":7724.5},5824,4545,3687.5,2849]
[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":7799.5},{"$f":"SUM(J46:J47)","v":5899},{"$f":"SUM(K46:K47)","v":4620},{"$f":"SUM(L46:L47)","v":3762.5},{"$f":"SUM(M46:M47)","v":2924}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":7724.5},{"$f":"J46","v":5824},4545,3687.5,2849]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2013"]

{"sheet":"Blue 500","index":5,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":true,"merged":[[43,0,43,1],[34,2,34,3],[48,2,49,3],[48,0,49,1],[46,2,46,3],[47,2,47,3],[44,2,44,3],[46,0,46,1],[47,0,47,1],[44,0,44,1],[45,0,45,1],[45,2,45,3],[22,0,23,1],[24,0,24,1],[35,2,40,3],[33,0,33,1],[34,0,34,1],[35,0,42,1],[41,2,42,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[51,5,51,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[43,2,43,3],[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa Blue 500 Guatemala"]
[]
["Bupa Blue 500 Guatemala",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$8","v":"Nombre"}]
["Cobertura Máxima anual",null,"US$500,000"]
["Cobertura Geografica",null,"Cobertura mundial",null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$18","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$10","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$12","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":"2021-02-17T17:46:42.250"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$10","v":3},null,null,{"$f":"+'INGRESO DE DATOS'!$J$12","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":3346},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,5,TRUE)","v":2944},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,6,TRUE)","v":2634},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,7,TRUE)","v":2324},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,8,TRUE)","v":0}]
[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":5006},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,5,TRUE)))","v":4404},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,6,TRUE)))","v":3941},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,7,TRUE)))","v":3477},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,8,TRUE)))","v":0}]
["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":2963},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,5,TRUE)))","v":2606},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,6,TRUE)))","v":2333},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,7,TRUE)))","v":2058},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,8,TRUE)))","v":0}]
["Ambulancia aérea",null,25000,null,null,"Prima Rider Complic. Maternidad",null,null,{"$f":"+IF($I$20=FALSE,0,Tablas!D$699)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$699)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$699)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$699)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$699)","v":0}]
["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":0}]
["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":11615},10254,9208,8384,0]
[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":1393.8},{"$f":"J36*0.12","v":1230.48},1104.96,1006.0799999999999,0]
[null,null,null,null,null,"GRAN TOTAL :",null,null,{"$f":"SUM(I36:I38)","v":13083.8},{"$f":"SUM(J36:J38)","v":11559.48},10387.959999999999,9465.08,75]
[]
[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":1673},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,5,TRUE)","v":1472},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,6,TRUE)","v":1317},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,7,TRUE)","v":1162},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,8,TRUE)","v":0}]
[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":2503},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,5,TRUE)))","v":2202},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,6,TRUE)))","v":1970.5},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,7,TRUE)))","v":1738.5},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,8,TRUE)))","v":0}]
["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":1481.5},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,5,TRUE)))","v":1303},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,6,TRUE)))","v":1166.5},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,7,TRUE)))","v":1029},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,8,TRUE)))","v":0}]
["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":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$771)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$771)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$771)","v":112.5},{"$f":"+IF($I$20=FALSE,0,Tablas!H$771)","v":0}]
["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":150},{"$f":"IF($I$22=FALSE,0,Tablas!E$772)","v":150},{"$f":"IF($I$22=FALSE,0,Tablas!F$772)","v":150},{"$f":"IF($I$22=FALSE,0,Tablas!G$772)","v":150},{"$f":"IF($I$22=FALSE,0,Tablas!H$772)","v":0}]
["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":5807.5},5127,4604,4192,0]
["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":696.9},{"$f":"J47*0.12","v":615.24},552.48,503.03999999999996,0]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,null,{"$f":"SUM(I47:I49)","v":6579.4},{"$f":"SUM(J47:J49)","v":5817.24},5231.4799999999996,4770.04,75]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,null,{"$f":"I47+I49","v":6504.4},{"$f":"J47+J49","v":5742.24},5156.4799999999996,4695.04,0]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2014"]
[null," "]

{"sheet":"Blue 100","index":6,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":true,"merged":[[47,0,47,1],[47,2,47,3],[48,0,49,1],[48,2,49,3],[51,5,51,12],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[46,0,46,1],[46,2,46,3],[43,0,43,1],[43,2,43,3],[30,0,31,1],[30,2,30,3],[31,2,31,3],[32,0,32,1],[32,2,32,3],[33,0,33,1],[33,2,33,3],[34,0,34,1],[34,2,34,3],[35,0,42,1],[35,2,40,3],[41,2,42,3],[27,0,27,1],[27,2,27,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[24,0,24,1],[24,2,24,3],[25,0,25,1],[25,2,25,3],[26,0,26,1],[26,2,26,3],[20,0,21,1],[20,2,20,3],[21,2,21,3],[22,0,23,1],[22,2,22,3],[23,2,23,3],[16,5,16,6],[17,0,18,1],[17,2,18,3],[17,5,17,6],[19,0,19,1],[19,2,19,3],[14,0,14,1],[14,2,14,3],[15,0,15,1],[15,2,15,3],[16,0,16,1],[16,2,16,3],[13,0,13,1],[13,2,13,3],[13,7,13,12],[9,0,9,12],[11,0,11,3],[11,7,11,12],[12,0,12,1],[12,2,12,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa Blue 100 Guatemala"]
[]
["Bupa Blue 100 Guatemala",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$8","v":"Nombre"}]
["Cobertura Máxima anual",null,"US$100,000"]
["Cobertura Geografica",null,"Cobertura mundial",null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$18","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$10","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$12","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":"2021-02-17T17:46:42.240"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$10","v":3},null,null,{"$f":"+'INGRESO DE DATOS'!$J$12","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":3311},{"$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":1393},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,5,TRUE)))","v":1364},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,6,TRUE)))","v":1285},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,7,TRUE)))","v":1173},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$841:$H$843,8,TRUE)))","v":597}]
["Ambulancia aérea",null,"$10,000 por año y ticket aéreo de retorno ",null,null,"Prima Rider Complic. Maternidad",null,null,{"$f":"+IF($I$20=FALSE,0,Tablas!D$844)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$844)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$844)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$844)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$844)","v":225}]
["Repatriación restos mortales",null,5000,null,null,"Prima Rider Trasplante Organos",null,null,{"$f":"IF($I$22=FALSE,0,Tablas!D$845)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$845)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$845)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$845)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$845)","v":300}]
["Medicamentos por receta",null,"Si son médicamente prescritos tras una hospitalización o en relación con una cirugía ambulatoria entonces $6,000 por los próximos 6 meses.",null,null,"TOTAL PRIMA NETA :",null,null,{"$f":"SUM(I31:I35)","v":5369},5270,6406,4604,3581]
[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":644.28},{"$f":"J36*0.12","v":632.4},768.72,552.48,429.71999999999997]
[null,null,null,null,null,"GRAN TOTAL :",null,null,{"$f":"SUM(I36:I38)","v":6088.28},{"$f":"SUM(J36:J38)","v":5977.4},7249.72,5231.4799999999996,4085.72]
[]
[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":696},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,5,TRUE)","v":681.5},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,6,TRUE)","v":642.5},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,7,TRUE)","v":585.5},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,8,TRUE)","v":482.5}]
[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":1029.5},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,5,TRUE)))","v":1009},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,6,TRUE)))","v":950.5},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,7,TRUE)))","v":867.5},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,8,TRUE)))","v":747}]
["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":696.5},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,5,TRUE)))","v":682},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,6,TRUE)))","v":642.5},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,7,TRUE)))","v":586.5},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,8,TRUE)))","v":298.5}]
["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":112.5},{"$f":"+IF($I$20=FALSE,0,Tablas!E$916)","v":112.5},{"$f":"+IF($I$20=FALSE,0,Tablas!F$916)","v":112.5},{"$f":"+IF($I$20=FALSE,0,Tablas!G$916)","v":112.5},{"$f":"+IF($I$20=FALSE,0,Tablas!H$916)","v":112.5}]
["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":150},{"$f":"IF($I$22=FALSE,0,Tablas!E$917)","v":150},{"$f":"IF($I$22=FALSE,0,Tablas!F$917)","v":150},{"$f":"IF($I$22=FALSE,0,Tablas!G$917)","v":150},{"$f":"IF($I$22=FALSE,0,Tablas!H$917)","v":150}]
["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":2684.5},2635,2498,2302,1790.5]
["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":322.14},{"$f":"J47*0.12","v":316.2},299.76,276.24,214.85999999999999]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,null,{"$f":"SUM(I47:I49)","v":3081.64},{"$f":"SUM(J47:J49)","v":3026.2},2872.76,2653.24,2080.36]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,null,{"$f":"I47+I49","v":3006.64},{"$f":"J47+J49","v":2951.2},2797.76,2578.2399999999998,2005.36]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2014"]
[null," "]

{"sheet":"Elite Care","index":7,"n_rows":118,"n_cols":10,"rows_kept":118,"cut":false,"hidden":false,"merged":[[26,0,26,1],[12,0,12,1],[0,0,0,1],[84,3,84,9],[5,4,5,9],[7,4,7,9],[50,0,50,1],[21,3,21,9],[26,3,26,9],[39,3,39,9],[6,0,6,1],[37,0,37,1],[18,0,18,1],[85,3,87,9],[54,3,54,9],[115,0,115,1],[116,0,116,1],[117,0,117,1],[69,3,69,9]]}
["BUPA ELITE CARE",null,null,null,null,"Cotización de Seguro Médico Internacional"]
[null,null,null,null,null,"Bupa Elite Care"]
[]
[]
[]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$8","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$18","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-02-17"},null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G14>0,'INGRESO DE DATOS'!G14,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$10","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$12","v":32}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$10","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$12","v":46}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,"Coberturas Adicionales:",null,"Complicaciones de Maternidad (+ $500,000)"]
[null,null,null,null,null,true]
[null,null,null,null,null,false,null,"Trasplante de Órganos (+ $500,000)"]
[null,null,null,null,null,false]
[null,null,null,null,null,null,null,"Deducible cero"]
[]
[null,null,null,"Deducibles"]
[null,null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5"]
[null,null,null,"Dentro del pais de residencia",null,1000,2000,5000,10000,20000]
[null,null,null,"Fuera del pais de residencia",null,2000,3000,5000,10000,20000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$487:$H$549,4,TRUE)","v":6741},{"$f":"VLOOKUP($J$12,Tablas!$A$487:$H$549,5,TRUE)","v":4239},{"$f":"VLOOKUP($J$12,Tablas!$A$487:$H$549,6,TRUE)","v":3381},{"$f":"VLOOKUP($J$12,Tablas!$A$487:$H$549,7,TRUE)","v":2814},{"$f":"VLOOKUP($J$12,Tablas!$A$487:$H$549,8,TRUE)","v":2060}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$487:$H$549,4,TRUE)))","v":10230},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$487:$H$549,5,TRUE)))","v":6345},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$487:$H$549,6,TRUE)))","v":5108},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$487:$H$549,7,TRUE)))","v":4087},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$487:$H$549,8,TRUE)))","v":3107}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$550:$H$552,4,TRUE)))","v":4897},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$550:$H$552,5,TRUE)))","v":3602},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$550:$H$552,6,TRUE)))","v":2546},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$550:$H$552,7,TRUE)))","v":2098},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$550:$H$552,8,TRUE)))","v":1827}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$17=FALSE,0,Tablas!D$553)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!E$553)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!F$553)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!G$553)","v":225},{"$f":"+IF($F$17=FALSE,0,Tablas!H$553)","v":225}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!D$554)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!E$554)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!F$554)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!G$554)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!H$554)","v":0}]
[null,null,null,"Anexo: Deducible cero",null,{"$f":"IF($F$19=FALSE,0,Tablas!$D$555)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!$E$555)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!$F$555)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!$G$555)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!$H$555)","v":0}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F28:F33)","v":21868},{"$f":"SUM(G28:G33)","v":14186},11035,9224,7219]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F28+F29+F30)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G28+G29+G30)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H28+H29+H30)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I28+I29+I30)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(J28+J29+J30)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F34+F35+F36)*0%","v":0},{"$f":"+(G34+G35+G36)*0%","v":0},0,0,0]
[null,null,null,"TOTAL",null,{"$f":"SUM(F34:F37)","v":21943},{"$f":"SUM(G34:G37)","v":14261},{"$f":"SUM(H34:H37)","v":11110},{"$f":"SUM(I34:I37)","v":9299},{"$f":"SUM(J34:J37)","v":7294}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$559:$H$621,4,TRUE)","v":3370.5},{"$f":"VLOOKUP($J$12,Tablas!$A$559:$H$621,5,TRUE)","v":2119.5},{"$f":"VLOOKUP($J$12,Tablas!$A$559:$H$621,6,TRUE)","v":1690.5},{"$f":"VLOOKUP($J$12,Tablas!$A$559:$H$621,7,TRUE)","v":1407},{"$f":"VLOOKUP($J$12,Tablas!$A$559:$H$621,8,TRUE)","v":1030}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$559:$H$621,4,TRUE)))","v":5115},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$559:$H$621,5,TRUE)))","v":3172.5},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$559:$H$621,6,TRUE)))","v":2554},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$559:$H$621,7,TRUE)))","v":2043.5},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$559:$H$621,8,TRUE)))","v":1553.5}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$622:$H$624,4,TRUE)))","v":2448.5},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$622:$H$624,5,TRUE)))","v":1801},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$622:$H$624,6,TRUE)))","v":1273},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$622:$H$624,7,TRUE)))","v":1049},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$622:$H$624,8,TRUE)))","v":913.5}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$17=FALSE,0,Tablas!D$625)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!E$625)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!F$625)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!G$625)","v":112.5},{"$f":"+IF($F$17=FALSE,0,Tablas!H$625)","v":112.5}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!D$626)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!E$626)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!F$626)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!G$626)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!H$626)","v":0}]
[null,null,null,"Anexo: Deducible cero",null,{"$f":"IF($F$19=FALSE,0,Tablas!D627)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!E627)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!F627)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!G627)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!H627)","v":0}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F41:F46)","v":10934},{"$f":"SUM(G41:G46)","v":7093},5517.5,4612,3609.5]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F41+F42+F43)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G41+G42+G43)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H41+H42+H43)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I41+I42+I43)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(J41+J42+J43)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F47+F48+F49)*0%","v":0},{"$f":"+(G47+G48+G49)*0%","v":0},0,0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F47:F50)","v":11009},{"$f":"SUM(G47:G50)","v":7168},{"$f":"SUM(H47:H50)","v":5592.5},{"$f":"SUM(I47:I50)","v":4687},{"$f":"SUM(J47:J50)","v":3684.5}]
[null,null,null,"2da Cuota",null,{"$f":"F47+F48+F50","v":10934},{"$f":"G47+G48+G50","v":7093},5517.5,4612,3609.5]
[null,null,null,"TOTAL",null,{"$f":"F51+F52","v":21943},{"$f":"G51+G52","v":14261},11110,9299,7294]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$1065:$H$1127,4,TRUE)","v":1685.25},{"$f":"VLOOKUP($J$12,Tablas!$A$1065:$H$1127,5,TRUE)","v":1059.75},{"$f":"VLOOKUP($J$12,Tablas!$A$1065:$H$1127,6,TRUE)","v":845.25},{"$f":"VLOOKUP($J$12,Tablas!$A$1065:$H$1127,7,TRUE)","v":703.5},{"$f":"VLOOKUP($J$12,Tablas!$A$1065:$H$1127,8,TRUE)","v":515}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1065:$H$1127,4,TRUE)))","v":2557.5},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1065:$H$1127,5,TRUE)))","v":1586.25},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1065:$H$1127,6,TRUE)))","v":1277},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1065:$H$1127,7,TRUE)))","v":1021.75},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1065:$H$1127,8,TRUE)))","v":776.75}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1128:$H$1130,4,TRUE)))","v":1224.25},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1128:$H$1130,5,TRUE)))","v":900.5},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1128:$H$1130,6,TRUE)))","v":636.5},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1128:$H$1130,7,TRUE)))","v":524.5},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1128:$H$1130,8,TRUE)))","v":456.75}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$17=FALSE,0,Tablas!D$1131)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!E$1131)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!F$1131)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!G$1131)","v":56.25},{"$f":"+IF($F$17=FALSE,0,Tablas!H$1131)","v":56.25}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!D$1132)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!E$1132)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!F$1132)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!G$1132)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!H$1132)","v":0}]
[null,null,null,"Anexo: Deducible cero",null,{"$f":"IF($F$19=FALSE,0,Tablas!D1133)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!E1133)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!F1133)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!G1133)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!H1133)","v":0}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F56:F61)","v":5467},{"$f":"SUM(G56:G61)","v":3546.5},2758.75,2306,1804.75]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G28>0,\"Descuento\",\"\")","v":""},null,{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(F56+F57+F58)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(G56+G57+G58)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(H56+H57+H58)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(I56+I57+I58)*'INGRESO DE DATOS'!$G$14,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$14>0,-(J56+J57+J58)*'INGRESO DE DATOS'!$G$14,0)","v":0}]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F62+F63+F64)*0%","v":0},{"$f":"+(G62+G63+G64)*0%","v":0},0,0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F62:F65)","v":5542},{"$f":"SUM(G62:G65)","v":3621.5},{"$f":"SUM(H62:H65)","v":2833.75},{"$f":"SUM(I62:I65)","v":2381},{"$f":"SUM(J62:J65)","v":1879.75}]
[null,null,null,"2da a 4ta Cuota",null,{"$f":"F62+F63+F65","v":5467},{"$f":"G62+G63+G65","v":3546.5},2758.75,2306,1804.75]
[null,null,null,"TOTAL",null,{"$f":"F66+F67*3","v":21943},{"$f":"G66+G67*3","v":14261},11110,9299,7294]
[]
[null,null,null,"Tarifas Mensuales"]
[null,null,null,"Prima Titular",null,{"$f":"VLOOKUP($J$12,Tablas!$A$1398:$H$1466,4,TRUE)","v":629.15999775300008},{"$f":"VLOOKUP($J$12,Tablas!$A$1398:$H$1466,5,TRUE)","v":395.63999858700004},{"$f":"VLOOKUP($J$12,Tablas!$A$1398:$H$1466,6,TRUE)","v":315.55999887300004},{"$f":"VLOOKUP($J$12,Tablas!$A$1398:$H$1466,7,TRUE)","v":262.63999906200002},{"$f":"VLOOKUP($J$12,Tablas!$A$1398:$H$1466,8,TRUE)","v":192.26666598}]
[null,null,null,"Prima Cónyuge",null,{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1398:$H$1466,4,TRUE)))","v":954.79999659000009},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1398:$H$1466,5,TRUE)))","v":592.19999788500002},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1398:$H$1466,6,TRUE)))","v":476.74666496400005},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1398:$H$1466,7,TRUE)))","v":381.45333197100001},{"$f":"IF($G$12=1,0,(VLOOKUP($J$14,Tablas!$A$1398:$H$1466,8,TRUE)))","v":289.98666563099999}]
[null,null,null,"Primas Hijos",null,{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1461:$H$1463,4,TRUE)))","v":457.05333170100005},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1461:$H$1463,5,TRUE)))","v":336.18666546600002},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1461:$H$1463,6,TRUE)))","v":237.62666581800002},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1461:$H$1463,7,TRUE)))","v":195.81333263400001},{"$f":"IF($G$14=0,0,(VLOOKUP($G$14,Tablas!$A$1461:$H$1463,8,TRUE)))","v":170.519999391}]
[null,null,null,"Anexo: Complicaciones de Maternidad",null,{"$f":"+IF($F$17=FALSE,0,Tablas!D1464)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!E1464)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!F1464)","v":0},{"$f":"+IF($F$17=FALSE,0,Tablas!G1464)","v":20.999999925000001},{"$f":"+IF($F$17=FALSE,0,Tablas!H1464)","v":20.999999925000001}]
[null,null,null,"Anexo: Trasplante Organos",null,{"$f":"IF($F$18=FALSE,0,Tablas!D1465)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!E1465)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!F1465)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!G1465)","v":0},{"$f":"IF($F$18=FALSE,0,Tablas!H1465)","v":0}]
[null,null,null,"Anexo: Deducible cero",null,{"$f":"IF($F$19=FALSE,0,Tablas!D1466)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!E1466)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!F1466)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!G1466)","v":0},{"$f":"IF($F$19=FALSE,0,Tablas!H1466)","v":0}]
[null,null,null,"PRIMA NETA",null,{"$f":"SUM(F71:F76)","v":2041.0133260440002},{"$f":"SUM(G71:G76)","v":1324.026661938},1029.9333296550001,860.90666359199997,673.77333092700007]
[null,null,null,"",null,0,0,0,0,0]
[null,null,null,"Costo Administrativo Anual",null,75,75,75,75,75]
[null,null,null,"IVA (12%)",null,{"$f":"+(F77+F78+F79)*0%","v":0},{"$f":"+(G77+G78+G79)*0%","v":0},0,0,0]
[null,null,null,"1ra Cuota",null,{"$f":"SUM(F77:F80)","v":2116.0133260440002},{"$f":"SUM(G77:G80)","v":1399.026661938},{"$f":"SUM(H77:H80)","v":1104.9333296550001},{"$f":"SUM(I77:I80)","v":935.90666359199997},{"$f":"SUM(J77:J80)","v":748.77333092700007}]
[null,null,null,"2da a 12va Cuota",null,{"$f":"F77+F78+F80","v":2041.0133260440002},{"$f":"G77+G78+G80","v":1324.026661938},1029.9333296550001,860.90666359199997,673.77333092700007]
[null,null,null,"TOTAL",null,{"$f":"F81+F82*11","v":24567.159912528004},{"$f":"G81+G82*11","v":15963.319943256},12434.19995586,10405.879963104,8160.2799711240004]
[]
[null,null,null,"Tarifas en US $ -   Efectivas partir del 1ro de enero de  2021"]
[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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bupa Guatemala, Compañía de Seguros, S.A."]
["5 Avenida 5-55 Zona 14, Europlaza World Business Center, Torre 3, Nivel 11, Guatemala"]
["PBX: 2300-8000 / www.bupasalud.com / servicioguatemala@bupalatinamerica.com"]

{"sheet":"Resumen tarifas anuales","index":8,"n_rows":121,"n_cols":9,"rows_kept":121,"cut":false,"hidden":false,"merged":[[31,2,32,2],[34,2,34,8],[106,2,106,8],[86,2,86,8],[91,2,91,8],[92,2,92,8],[98,2,98,8],[99,2,99,3],[102,2,102,8],[103,2,104,2],[35,2,36,2],[38,2,38,8],[39,2,40,2],[43,2,43,8],[44,2,44,8],[75,2,75,3],[19,2,19,8],[20,2,20,8],[26,2,26,8],[27,2,27,3],[30,2,30,8],[0,0,0,8],[6,3,6,8],[8,3,8,8],[14,1,14,2],[13,1,13,2],[50,2,50,8],[54,2,54,8],[55,2,56,2],[51,2,51,3],[58,2,58,8],[74,2,74,8],[59,2,60,2],[62,2,62,8],[63,2,64,2],[67,2,67,8],[68,2,68,8],[78,2,78,8],[79,2,80,2],[82,2,82,8],[83,2,84,2],[87,2,88,2],[118,2,118,8],[119,2,119,8],[120,2,120,8],[107,2,108,2],[110,2,110,8],[111,2,112,2],[114,2,114,8],[115,2,116,8]]}
["Cotización de Seguro Médico Internacional - BUPA Guatemala"]
[null,null,null,null,null," "," "," "]
[]
[]
[null,null,null,null,null," "," "," "," "]
[]
[null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$8","v":"Nombre"}]
[]
[null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$18","v":"Agente / Agencia"}]
[]
[null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-02-17"},null,{"$f":"IF('INGRESO DE DATOS'!G14>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G14>0,'INGRESO DE DATOS'!G14,\"\")","v":""}]
[]
[null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$10","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$12","v":32}]
[]
[null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$10","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$12","v":46}]
[null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,"ESSENTIAL CARE"]
[null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4"]
[null,null,"Dentro del pais de residencia",null,0,0,500,2000]
[null,null,"Fuera del pais de residencia",null,1000,2000,3000,5000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"ESSENTIAL CARE",null,17428,12063,8830,6503]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"ESSENTIAL CARE","1ra Cuota",9272.09,6428.64,4715.1500000000005,3481.84]
[null,null,null,"2da Cuota",9188.09,6344.64,4631.1500000000005,3397.84]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"ESSENTIAL CARE","1ra Cuota",4847.0750000000007,3849.0600000000004,2857.2200000000003,2165.5300000000002]
[null,null,null,"2da a 4ta Cuota",4763.0750000000007,3765.0600000000004,2773.2200000000003,2081.5300000000002]
[]
[null,null,"Tarifas Mensual"]
[null,null,"ESSENTIAL CARE","1ra Cuota",1694.55549,1193.84004,892.10415,674.92524000000003]
[null,null,null,"2da a 12va Cuota",1610.55549,1109.84004,808.10415,590.92524000000003]
[]
[]
[null,null,"UNIQUE CARE"]
[null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5"]
[null,null,"Dentro del pais de residencia",null,250,1000,2000,5000,10000]
[null,null,"Fuera del pais de residencia",null,1000,2000,3000,5000,10000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"UNIQUE CARE",null,10993,8520,7029,6415,6150]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"UNIQUE CARE","1ra Cuota",5861.54,4550.8500000000004,3760.62,3435.2000000000003,3294.7500000000005]
[null,null,null,"2da Cuota",5777.54,4466.8500000000004,3676.62,3351.2000000000003,3210.7500000000005]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"UNIQUE CARE","1ra Cuota",3077.4500000000003,2397.3750000000005,1987.3500000000001,1818.5,1745.625]
[null,null,null,"2da a 4ta Cuota",2993.4500000000003,2313.3750000000005,1903.3500000000001,1734.5,1661.625]
[]
[null,null,"Tarifas Mensuales"]
[null,null,"UNIQUE CARE","1ra Cuota",1222.05429,1021.22475,960.18781999999999,1003.7100500000001,1115.2301]
[null,null,null,"2da a 12va Cuota",1138.05429,937.22474999999997,876.18781999999999,919.71005000000014,1031.2301]
[]
[]
[null,null,"UNIQUE CARE - DEDUCIBLE CERO"]
[null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4"]
[null,null,"Dentro del pais de residencia",null,0,0,0,0]
[null,null,"Fuera del pais de residencia",null,1000,2000,3000,5000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"UNIQUE CARE - DEDUCIBLE CERO",null,9400,7165,5702,5042]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"UNIQUE CARE -DEDUCIBLE CERO","1ra Cuota",5017.25,3832.7000000000003,3057.31,2707.51]
[null,null,null,"2da Cuota",4933.25,3748.7000000000003,2973.31,2623.51]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"UNIQUE CARE -DEDUCIBLE CERO","1ra Cuota",2715.875,2101.25,1698.9250000000002,1517.4250000000002]
[null,null,null,"2da a 4ta Cuota",2631.875,2017.2500000000002,1614.9250000000002,1433.4250000000002]
[]
[null,null,"Tarifas Mensuales"]
[null,null,"UNIQUE CARE -DEDUCIBLE CERO","1ra Cuota",1117.1790000000001,908.58645000000001,772.04466000000002,710.44686000000002]
[null,null,null,"2da a 4ta Cuota",1033.1790000000001,824.58645000000001,688.04466000000002,626.44686000000002]
[]
[]
[null,null,"ELITE CARE"]
[null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5"]
[null,null,"Dentro del pais de residencia",null,1000,2000,5000,10000,20000]
[null,null,"Fuera del pais de residencia",null,2000,3000,5000,10000,20000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"ELITE CARE",null,6940,5260,3798,3001,2290]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"ELITE CARE","1ra Cuota",3713.45,2823.05,2048.19,1625.7800000000002,1248.95]
[null,null,null,"2da Cuota",3629.45,2739.05,1964.19,1541.7800000000002,1164.95]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"ELITE CARE","1ra Cuota",1962.8750000000002,1500.875,1098.825,879.65,684.125]
[null,null,null,"2da a 4ta Cuota",1878.8750000000002,1416.875,1014.825,795.65,600.125]
[]
[null,null,"Tarifas Mensuales"]
[null,null,"ELITE CARE","1ra Cuota",811.08719999999994,654.29279999999994,517.84433999999999,443.46033,377.10270000000003]
[null,null,null,"2da a 4ta Cuota",727.08719999999994,570.29279999999994,433.84433999999999,359.46033,293.10270000000003]
[]
[null,null,"Tarifas en US $ -  Efectivas a partir del 1ro de enero de  2021"]
[null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[null,null,"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":1466,"n_cols":14,"rows_kept":1466,"cut":false,"hidden":true,"merged":[[1321,0,1321,1],[1321,2,1321,6],[1393,0,1393,7],[1394,0,1394,7],[1395,0,1395,1],[1395,2,1395,6],[1246,0,1246,7],[1247,0,1247,1],[1247,2,1247,6],[1319,0,1319,7],[1320,0,1320,7],[1210,0,1210,7],[1211,0,1211,7],[1212,0,1212,1],[1212,2,1212,6],[1245,0,1245,7],[1134,0,1134,7],[1135,0,1135,7],[1136,0,1136,1],[1136,2,1136,6],[1062,0,1062,1],[1062,2,1062,6],[987,0,987,7],[988,0,988,1],[988,2,988,6],[1060,0,1060,7],[1061,0,1061,7],[952,0,952,7],[953,0,953,7],[954,0,954,1],[954,2,954,6],[986,0,986,7],[918,0,918,7],[919,0,919,7],[920,0,920,1],[920,2,920,6],[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[342,0,342,7],[269,0,269,7],[270,0,270,7],[271,0,271,1],[271,2,271,6],[170,2,170,6],[202,0,202,7],[236,0,236,7],[237,0,237,1],[237,2,237,6],[204,0,204,1],[204,2,204,6],[628,0,628,7],[482,0,482,7],[483,0,483,7],[484,0,484,1],[484,2,484,6],[343,2,343,6],[415,0,415,7],[555,0,555,7],[556,0,556,1],[556,2,556,6],[343,0,343,1],[449,0,449,7],[450,0,450,1],[450,2,450,6],[416,0,416,7],[417,0,417,1],[417,2,417,6],[629,0,629,7],[630,0,630,1],[630,2,630,6],[701,0,701,7],[702,0,702,1],[702,2,702,6],[847,0,847,1],[847,2,847,6],[773,0,773,7],[774,0,774,7],[775,0,775,1],[775,2,775,6],[846,0,846,7]]}
[]
["BUPA ESSENTIAL CARE",null,null,null,null,null,null,null,null,"FACTOR SEMESTRAL :",null,0.5,null,0.53]
["TARIFAS ANUALES",null,null,null,null,null,null,null,null,"FACTOR TRIMESTRAL :",null,0.25,null,0.27500000000000002]
["EDAD",null,null,null,null,null,null,null,null,"FACTOR MENSUAL:",null,9.3333333000000004E-2,null,9.3333333000000004E-2]
[" "," ",null,"DW2","DW3","DW4","DW5"]
[18,"-  24",null,1450,1317,1196,1031,null,null,"Descuento (15%)",null,1]
[25,"-  29",null,1632,1482,1346,1160]
[30,"-  34",null,1829,1661,1509,1301]
[35,"-  39",null,2088,1896,1723,1485]
[40,"-  44",null,2421,2198,1997,1722]
[45,"-  49",null,2894,2628,2388,2058]
[50,"-  54",null,3453,3135,2849,2455]
[55,"-  59",null,4110,3732,3391,2923]
[60,null,null,4560,4140,3762,3242]
[61,null,null,4749,4312,3918,3377]
[62,null,null,4977,4519,4106,3539]
[63,null,null,5225,4745,4311,3716]
[64,null,null,5524,5016,4557,3928]
[65,null,null,5936,5390,4897,4221]
[66,null,null,6413,5823,5291,4560]
[67,null,null,6922,6285,5711,4922]
[68,null,null,7502,6811,6189,5334]
[69,null,null,8188,7434,6755,5822]
[70,null,null,9036,8204,7455,6425]
[71,null,null,10030,9107,8274,7132]
[72,null,null,11095,10073,9153,7889]
[73,null,null,12309,11176,10155,8752]
[74,null,null,13718,12456,11317,9755]
[75,"o más",null,15370,13955,12680,10929]
[1,"Hijo",null,512,465,422,364]
[2,"Hijos",null,790,717,652,562]
[3,"Hijos o más",null,1147,1042,947,816]
[1,"Rider Comp. Maternidad",null,0,0,225,225]
[1,"Transplante de organos",0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","DW1","DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",{"$f":"C6*$L$2","v":0},{"$f":"D6*$L$2","v":725},658.5,598,515.5,0]
[25,"-  29",{"$f":"C7*$L$2","v":0},816,741,673,580,0]
[30,"-  34",{"$f":"C8*$L$2","v":0},914.5,830.5,754.5,650.5,0]
[35,"-  39",{"$f":"C9*$L$2","v":0},1044,948,861.5,742.5,0]
[40,"-  44",{"$f":"C10*$L$2","v":0},1210.5,1099,998.5,861,0]
[45,"-  49",{"$f":"C11*$L$2","v":0},1447,1314,1194,1029,0]
[50,"-  54",{"$f":"C12*$L$2","v":0},1726.5,1567.5,1424.5,1227.5,0]
[55,"-  59",{"$f":"C13*$L$2","v":0},2055,1866,1695.5,1461.5,0]
[60,null,{"$f":"C14*$L$2","v":0},2280,2070,1881,1621,0]
[61,null,{"$f":"C15*$L$2","v":0},2374.5,2156,1959,1688.5,0]
[62,null,{"$f":"C16*$L$2","v":0},2488.5,2259.5,2053,1769.5,0]
[63,null,{"$f":"C17*$L$2","v":0},2612.5,2372.5,2155.5,1858,0]
[64,null,{"$f":"C18*$L$2","v":0},2762,2508,2278.5,1964,0]
[65,null,{"$f":"C19*$L$2","v":0},2968,2695,2448.5,2110.5,0]
[66,null,{"$f":"C20*$L$2","v":0},3206.5,2911.5,2645.5,2280,0]
[67,null,{"$f":"C21*$L$2","v":0},3461,3142.5,2855.5,2461,0]
[68,null,{"$f":"C22*$L$2","v":0},3751,3405.5,3094.5,2667,0]
[69,null,{"$f":"C23*$L$2","v":0},4094,3717,3377.5,2911,0]
[70,null,{"$f":"C24*$L$2","v":0},4518,4102,3727.5,3212.5,0]
[71,null,{"$f":"C25*$L$2","v":0},5015,4553.5,4137,3566,0]
[72,null,{"$f":"C26*$L$2","v":0},5547.5,5036.5,4576.5,3944.5,0]
[73,null,{"$f":"C27*$L$2","v":0},6154.5,5588,5077.5,4376,0]
[74,null,{"$f":"C28*$L$2","v":0},6859,6228,5658.5,4877.5,0]
[75,"o más",{"$f":"C29*$L$2","v":0},7685,6977.5,6340,5464.5,0]
[1,"Hijo",{"$f":"C30*$L$2","v":0},256,232.5,211,182,0]
[2,"Hijos",{"$f":"C31*$L$2","v":0},395,358.5,326,281,0]
[3,"Hijos o más",{"$f":"C32*$L$2","v":0},573.5,521,473.5,408,0]
[1,"Rider Comp. Maternidad",{"$f":"+C33*$L$2","v":0},0,0,112.5,112.5,0]
[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":2397},1476,974.5,700.5,496.5,389.5]
[25,"-  29",2514,1548.5,1078,776.5,551.5,433.5]
[30,"-  34",2600,1611.5,1156,871.5,661,520.5]
[35,"-  39",2908,1804.5,1295,975.5,741.5,584]
[40,"-  44",3366.5,2093,1415.5,1084,815,642]
[45,"-  49",3758.5,2340,1584,1212.5,912,718]
[50,"-  54",4886,2995.5,2079,1582,1289,1016.5]
[55,"-  59",5197,3187,2213,1682.5,1372,1082]
[60,null,5528,3472.5,2414,1935.5,1653.5,1344]
[61,null,5938,3731.5,2593.5,2079.5,1777.5,1443]
[62,null,{"$f":"+C83*$L$2","v":6497},4086,2842,2278.5,1946,1581]
[63,null,6906,4343.5,3021,2422,2069.5,1681]
[64,null,7468,4698,3269.5,2621,2237.5,1819.5]
[65,null,7825.5,6144,4265,3314.5,2987,2569.5]
[66,null,8181.5,7137.5,4955.5,3851.5,3471,2984]
[67,null,8933.5,7797.5,5413,4208,3790.5,3260.5]
[68,null,9890,8634,5993,4660,4199,3610]
[69,null,10879,9499.5,6595,5127,4620,3972.5]
[70,null,12874,11692,8030.5,6035.5,5384,4672.5]
[71,null,13379.5,12151.5,8345.5,6272.5,5595,4858]
[72,null,{"$f":"+C93*$L$2","v":13756},12495,8582,6450,5753.5,4993.5]
[73,null,14262.5,12955.5,8896.5,6687.5,5965.5,5178]
[74,null,14513,13184,9055.5,6804.5,6071.5,5270]
[75,"o más",15143.5,13757.5,9449,7102,6335,5500.5]
[1,"Hijo",830,513.5,379,314.5,263.5,206.5]
[2,"Hijos",1304,817,602,499.5,420.5,328]
[3,"Hijos o más",1899,1197.5,883,732.5,617,480.5]
[1,"Rider Comp. Maternidad",0,0,0,112.5,112.5,112.5]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["xx"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","CW1","CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",null,3551,2780,2126,1854,1389]
[25,"-  29",null,3900,3127,2393,2047,1545]
[30,"-  34",null,4479,3668,2780,2393,1816]
[35,"-  39",null,4943,4131,3090,2664,2006]
[40,"-  44",null,5520,4711,3477,3012,2279]
[45,"-  49",null,6371,5520,4054,3514,2626]
[50,"-  54",null,6951,6062,4441,3823,2896]
[55,"-  59",null,8184,7256,5251,4556,3399]
[60,null,null,8571,7760,5560,4827,3591]
[61,null,null,9652,8725,6294,5406,4054]
[62,null,null,10731,9690,6989,6024,4517]
[63,null,null,11776,10655,7683,6641,4980]
[64,null,null,12855,11658,8377,7256,5444]
[65,null,null,12894,11735,8455,7298,5444]
[66,null,null,12894,11852,8493,7335,5444]
[67,null,null,14321,13202,9420,8145,6062]
[68,null,null,15749,14514,10384,8957,6681]
[69,null,null,16483,15172,10849,9381,6989]
[70,null,null,16522,15404,10965,9457,7026]
[71,null,null,18570,17373,12353,10655,7916]
[72,null,null,20653,19303,13703,11813,8801]
[73,null,null,22739,21231,15095,13009,9690]
[74,null,null,24784,23162,16483,14205,10579]
[75,"o más",null,27023,25402,18027,15519,11544]
[1,"Hijo",null,1698,1005,850,734,542]
[2,"Hijos",null,2896,1508,1352,1159,850]
[3,"Hijos o más",null,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 "]
["EDAD"]
[" "," ","CW1","CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",{"$f":"C140*$L$2","v":0},{"$f":"D140*$L$2","v":1775.5},1390,1063,927,694.5]
[25,"-  29",{"$f":"C141*$L$2","v":0},1950,1563.5,1196.5,1023.5,772.5]
[30,"-  34",{"$f":"C142*$L$2","v":0},2239.5,1834,1390,1196.5,908]
[35,"-  39",{"$f":"C143*$L$2","v":0},2471.5,2065.5,1545,1332,1003]
[40,"-  44",{"$f":"C144*$L$2","v":0},2760,2355.5,1738.5,1506,1139.5]
[45,"-  49",{"$f":"C145*$L$2","v":0},3185.5,2760,2027,1757,1313]
[50,"-  54",{"$f":"C146*$L$2","v":0},3475.5,3031,2220.5,1911.5,1448]
[55,"-  59",{"$f":"C147*$L$2","v":0},4092,3628,2625.5,2278,1699.5]
[60,null,{"$f":"C148*$L$2","v":0},4285.5,3880,2780,2413.5,1795.5]
[61,null,{"$f":"C149*$L$2","v":0},4826,4362.5,3147,2703,2027]
[62,null,{"$f":"C150*$L$2","v":0},5365.5,4845,3494.5,3012,2258.5]
[63,null,{"$f":"C151*$L$2","v":0},5888,5327.5,3841.5,3320.5,2490]
[64,null,{"$f":"C152*$L$2","v":0},6427.5,5829,4188.5,3628,2722]
[65,null,{"$f":"C153*$L$2","v":0},6447,5867.5,4227.5,3649,2722]
[66,null,{"$f":"C154*$L$2","v":0},6447,5926,4246.5,3667.5,2722]
[67,null,{"$f":"C155*$L$2","v":0},7160.5,6601,4710,4072.5,3031]
[68,null,{"$f":"C156*$L$2","v":0},7874.5,7257,5192,4478.5,3340.5]
[69,null,{"$f":"C157*$L$2","v":0},8241.5,7586,5424.5,4690.5,3494.5]
[70,null,{"$f":"C158*$L$2","v":0},8261,7702,5482.5,4728.5,3513]
[71,null,{"$f":"C159*$L$2","v":0},9285,8686.5,6176.5,5327.5,3958]
[72,null,{"$f":"C160*$L$2","v":0},10326.5,9651.5,6851.5,5906.5,4400.5]
[73,null,{"$f":"C161*$L$2","v":0},11369.5,10615.5,7547.5,6504.5,4845]
[74,null,{"$f":"C162*$L$2","v":0},12392,11581,8241.5,7102.5,5289.5]
[75,"o más",{"$f":"C163*$L$2","v":0},13511.5,12701,9013.5,7759.5,5772]
[1,"Hijo",{"$f":"C164*$L$2","v":0},849,502.5,425,367,271]
[2,"Hijos",{"$f":"C165*$L$2","v":0},1448,754,676,579.5,425]
[3,"Hijos o más",{"$f":"C166*$L$2","v":0},2123,1081.5,984.5,849,637.5]
[1,"Rider Comp. Maternidad",{"$f":"+C167*$L$2","v":0},112.5,112.5,112.5,112.5,112.5]
[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":2054},1246.5,855.5,611,432,328]
[25,"-  29",2156,1308.5,946.5,677.5,479,363.5]
[30,"-  34",2248.5,1366.5,1014,760,581,442]
[35,"-  39",2515,1529.5,1135.5,852,652,495.5]
[40,"-  44",2849.5,1772,1245,948.5,718.5,547.5]
[45,"-  49",3181,1981,1392,1060.5,803,613]
[50,"-  54",4200,2590.5,1837.5,1394,1148.5,876]
[55,"-  59",4467,2757.5,1955,1482.5,1222,932.5]
[60,null,4742,3002,2123,1688.5,1454,1166.5]
[61,null,5092.5,3226,2281,1813.5,1562.5,1253.5]
[62,null,{"$f":"+C217*$L$2","v":5573},3531,2498.5,1986.5,1711,1373]
[63,null,5922.5,3755,2657,2112,1819.5,1460]
[64,null,6404.5,4062,2874.5,2286,1968.5,1580.5]
[65,null,6711.5,5310,3751,2891.5,2626.5,2229]
[66,null,7016.5,6170.5,4358,3359,3052.5,2591.5]
[67,null,7661,6740.5,4760.5,3669,3334,2831]
[68,null,8480.5,7463.5,5271.5,4063.5,3693.5,3135.5]
[69,null,9328,8212,5800,4470.5,4063.5,3450]
[70,null,11040.5,10108,7062.5,5263,4735,4058.5]
[71,null,11471.5,10504.5,7340.5,5470,4922,4218]
[72,null,{"$f":"+C227*$L$2","v":11796},10801.5,7548.5,5625,5061.5,4338]
[73,null,12228.5,11199,7825.5,5832.5,5246.5,4498]
[74,null,12445,11397.5,7964,5934.5,5340,4577.5]
[75,"o más",12985,11893.5,8310.5,6192.5,5573.5,4776]
[1,"Hijo",697.5,433.5,316,249.5,210.5,156.5]
[2,"Hijos",1093.5,689.5,504.5,397.5,334.5,249]
[3,"Hijos o más",1589.5,1011.5,739.5,583,491.5,363.5]
[1,"Rider Comp. Maternidad",0,0,0,112.5,112.5,112.5]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["UNIQUE CARE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,{"$f":"J274*$L$6","v":0},2422,1883,1466,1299,1054]
[19,null,{"$f":"J275*$L$6","v":0},2466,1914,1498,1326,1071]
[20,null,0,2508,1946,1525,1351,1089]
[21,null,0,2554,1979,1557,1374,1112]
[22,null,0,2600,2010,1589,1399,1133]
[23,null,0,2645,2042,1624,1423,1153]
[24,null,0,2692,2074,1652,1451,1171]
[25,null,0,2738,2108,1684,1475,1195]
[26,null,0,2783,2140,1716,1500,1214]
[27,null,0,2831,2174,1747,1524,1233]
[28,null,0,2883,2210,1790,1556,1262]
[29,null,0,2939,2246,1826,1588,1281]
[30,null,0,2991,2285,1868,1619,1308]
[31,null,0,3047,2322,1905,1649,1334]
[32,null,0,3098,2360,1947,1679,1357]
[33,null,0,3186,2424,2003,1727,1398]
[34,null,0,3273,2487,2066,1776,1435]
[35,null,0,3360,2551,2125,1824,1475]
[36,null,0,3447,2615,2184,1872,1515]
[37,null,0,3536,2678,2241,1920,1553]
[38,null,0,3624,2743,2306,1970,1593]
[39,null,0,3716,2807,2367,2020,1634]
[40,null,0,3804,2875,2432,2073,1673]
[41,null,0,3895,2939,2494,2123,1712]
[42,null,0,3984,3003,2558,2171,1756]
[43,null,0,4147,3119,2664,2260,1825]
[44,null,0,4309,3238,2776,2350,1898]
[45,null,0,4471,3354,2888,2443,1967]
[46,null,0,4635,3474,2999,2532,2042]
[47,null,0,4796,3591,3111,2623,2111]
[48,null,0,4968,3717,3224,2719,2190]
[49,null,0,5141,3843,3338,2814,2267]
[50,null,0,5312,3966,3457,2910,2345]
[51,null,0,5484,4091,3569,3003,2419]
[52,null,0,5656,4217,3686,3098,2497]
[53,null,0,5861,4362,3828,3210,2587]
[54,null,0,6061,4510,3972,3328,2678]
[55,null,0,6264,4659,4109,3441,2768]
[56,null,0,6466,4806,4251,3554,2861]
[57,null,0,6672,4952,4393,3669,2949]
[58,null,0,6921,5124,4564,3810,3064]
[59,null,0,7169,5294,4733,3951,3176]
[60,null,0,7418,5462,4905,4092,3290]
[61,null,0,7691,5662,5109,4245,3412]
[62,null,0,8034,5913,5353,4431,3561]
[63,null,0,8440,6211,5621,4657,3738]
[64,null,0,8918,6560,5942,4920,3953]
[65,null,0,9531,6995,6386,5271,4232]
[66,null,0,10243,7499,6899,5675,4551]
[67,null,0,11058,8094,7446,6129,4909]
[68,null,0,11991,8769,8070,6636,5326]
[69,null,0,13090,9574,8808,7252,5810]
[70,null,0,14425,10492,9720,8016,6423]
[71,null,0,15879,11553,10789,8824,7067]
[72,null,0,17564,12775,11935,9760,7822]
[73,null,0,19490,14180,13241,10829,8676]
[74,null,0,21729,15804,14757,12072,9669]
[75,null,0,24343,17664,16534,13540,10846]
[76,null,0,27298,19808,18604,15186,12159]
[77,null,0,30659,22246,20909,17052,13659]
[78,null,0,34447,24995,23493,19162,15347]
[79,null,0,38703,28083,26396,21529,17245]
[80,"o mas",0,43795,31777,29868,24360,19513]
[1,"Hijo",0,1143,937,551,540,433]
[2,"Hijos",0,1875,1577,850,821,684]
[3,"Hijos o más",{"$f":"J339*$L$6","v":0},2743,2316,1234,1180,992]
[1,"Rider Comp. Maternidad",null,0,0,0,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[null,"Deductible Waiver",null,45,180,345,775,1330]
["TARIFAS SEMESTRALES "]
["EDAD",null,null,null,null,null,null,null,"NO HAY"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,{"$f":"C274*$L$2","v":0},{"$f":"D274*$L$2","v":1211},941.5,733,649.5,527]
[19,null,{"$f":"C275*$L$2","v":0},1233,957,749,663,535.5]
[20,null,{"$f":"C276*$L$2","v":0},1254,973,762.5,675.5,544.5]
[21,null,{"$f":"C277*$L$2","v":0},1277,989.5,778.5,687,556]
[22,null,{"$f":"C278*$L$2","v":0},1300,1005,794.5,699.5,566.5]
[23,null,{"$f":"C279*$L$2","v":0},1322.5,1021,812,711.5,576.5]
[24,null,{"$f":"C280*$L$2","v":0},1346,1037,826,725.5,585.5]
[25,null,{"$f":"C281*$L$2","v":0},1369,1054,842,737.5,597.5]
[26,null,{"$f":"C282*$L$2","v":0},1391.5,1070,858,750,607]
[27,null,{"$f":"C283*$L$2","v":0},1415.5,1087,873.5,762,616.5]
[28,null,{"$f":"C284*$L$2","v":0},1441.5,1105,895,778,631]
[29,null,{"$f":"C285*$L$2","v":0},1469.5,1123,913,794,640.5]
[30,null,{"$f":"C286*$L$2","v":0},1495.5,1142.5,934,809.5,654]
[31,null,{"$f":"C287*$L$2","v":0},1523.5,1161,952.5,824.5,667]
[32,null,{"$f":"C288*$L$2","v":0},1549,1180,973.5,839.5,678.5]
[33,null,{"$f":"C289*$L$2","v":0},1593,1212,1001.5,863.5,699]
[34,null,{"$f":"C290*$L$2","v":0},1636.5,1243.5,1033,888,717.5]
[35,null,{"$f":"C291*$L$2","v":0},1680,1275.5,1062.5,912,737.5]
[36,null,{"$f":"C292*$L$2","v":0},1723.5,1307.5,1092,936,757.5]
[37,null,{"$f":"C293*$L$2","v":0},1768,1339,1120.5,960,776.5]
[38,null,{"$f":"C294*$L$2","v":0},1812,1371.5,1153,985,796.5]
[39,null,{"$f":"C295*$L$2","v":0},1858,1403.5,1183.5,1010,817]
[40,null,{"$f":"C296*$L$2","v":0},1902,1437.5,1216,1036.5,836.5]
[41,null,{"$f":"C297*$L$2","v":0},1947.5,1469.5,1247,1061.5,856]
[42,null,{"$f":"C298*$L$2","v":0},1992,1501.5,1279,1085.5,878]
[43,null,{"$f":"C299*$L$2","v":0},2073.5,1559.5,1332,1130,912.5]
[44,null,{"$f":"C300*$L$2","v":0},2154.5,1619,1388,1175,949]
[45,null,{"$f":"C301*$L$2","v":0},2235.5,1677,1444,1221.5,983.5]
[46,null,{"$f":"C302*$L$2","v":0},2317.5,1737,1499.5,1266,1021]
[47,null,{"$f":"C303*$L$2","v":0},2398,1795.5,1555.5,1311.5,1055.5]
[48,null,{"$f":"C304*$L$2","v":0},2484,1858.5,1612,1359.5,1095]
[49,null,{"$f":"C305*$L$2","v":0},2570.5,1921.5,1669,1407,1133.5]
[50,null,{"$f":"C306*$L$2","v":0},2656,1983,1728.5,1455,1172.5]
[51,null,{"$f":"C307*$L$2","v":0},2742,2045.5,1784.5,1501.5,1209.5]
[52,null,{"$f":"C308*$L$2","v":0},2828,2108.5,1843,1549,1248.5]
[53,null,{"$f":"C309*$L$2","v":0},2930.5,2181,1914,1605,1293.5]
[54,null,{"$f":"C310*$L$2","v":0},3030.5,2255,1986,1664,1339]
[55,null,{"$f":"C311*$L$2","v":0},3132,2329.5,2054.5,1720.5,1384]
[56,null,{"$f":"C312*$L$2","v":0},3233,2403,2125.5,1777,1430.5]
[57,null,{"$f":"C313*$L$2","v":0},3336,2476,2196.5,1834.5,1474.5]
[58,null,{"$f":"C314*$L$2","v":0},3460.5,2562,2282,1905,1532]
[59,null,{"$f":"C315*$L$2","v":0},3584.5,2647,2366.5,1975.5,1588]
[60,null,{"$f":"C316*$L$2","v":0},3709,2731,2452.5,2046,1645]
[61,null,{"$f":"C317*$L$2","v":0},3845.5,2831,2554.5,2122.5,1706]
[62,null,{"$f":"C318*$L$2","v":0},4017,2956.5,2676.5,2215.5,1780.5]
[63,null,{"$f":"C319*$L$2","v":0},4220,3105.5,2810.5,2328.5,1869]
[64,null,{"$f":"C320*$L$2","v":0},4459,3280,2971,2460,1976.5]
[65,null,{"$f":"C321*$L$2","v":0},4765.5,3497.5,3193,2635.5,2116]
[66,null,{"$f":"C322*$L$2","v":0},5121.5,3749.5,3449.5,2837.5,2275.5]
[67,null,{"$f":"C323*$L$2","v":0},5529,4047,3723,3064.5,2454.5]
[68,null,{"$f":"C324*$L$2","v":0},5995.5,4384.5,4035,3318,2663]
[69,null,{"$f":"C325*$L$2","v":0},6545,4787,4404,3626,2905]
[70,null,{"$f":"C326*$L$2","v":0},7212.5,5246,4860,4008,3211.5]
[71,null,{"$f":"C327*$L$2","v":0},7939.5,5776.5,5394.5,4412,3533.5]
[72,null,{"$f":"C328*$L$2","v":0},8782,6387.5,5967.5,4880,3911]
[73,null,{"$f":"C329*$L$2","v":0},9745,7090,6620.5,5414.5,4338]
[74,null,{"$f":"C330*$L$2","v":0},10864.5,7902,7378.5,6036,4834.5]
[75,null,{"$f":"C331*$L$2","v":0},12171.5,8832,8267,6770,5423]
[76,null,{"$f":"C332*$L$2","v":0},13649,9904,9302,7593,6079.5]
[77,null,{"$f":"C333*$L$2","v":0},15329.5,11123,10454.5,8526,6829.5]
[78,null,{"$f":"C334*$L$2","v":0},17223.5,12497.5,11746.5,9581,7673.5]
[79,null,{"$f":"C335*$L$2","v":0},19351.5,14041.5,13198,10764.5,8622.5]
[80,"o mas",{"$f":"C336*$L$2","v":0},21897.5,15888.5,14934,12180,9756.5]
[1,"Hijo",{"$f":"C337*$L$2","v":0},571.5,468.5,275.5,270,216.5]
[2,"Hijos",{"$f":"C338*$L$2","v":0},937.5,788.5,425,410.5,342]
[3,"Hijos o más",{"$f":"C339*$L$2","v":0},1371.5,1158,617,590,496]
[1,"Rider Comp. Maternidad",{"$f":"+C340*$L$2","v":0},0,0,0,112.5,112.5]
[1,"Transplante de organos",0,150,150,150,150,150]
[null,"Deductible Waiver",null,{"$f":"+D342*$L$2","v":22.5},{"$f":"+E342*$L$2","v":90},{"$f":"+F342*$L$2","v":172.5},{"$f":"+G342*$L$2","v":387.5},{"$f":"+H342*$L$2","v":665}]
[]
["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":1161.5},1764.5,1326.5,1014.5,777.5,615.5]
[25,"-  29",1297.5,1965.5,1480,1128,868,681.5]
[30,"-  34",1517.5,2275,1740,1345,1029.5,793.5]
[35,"-  39",1712.5,2522.5,1938,1496.5,1174,880]
[40,"-  44",1939,2847,2197.5,1698,1312.5,996]
[45,"-  49",2241.5,3308.5,2531.5,1913.5,1494,1158.5]
[50,"-  54",2537,3626,2846,2231.5,1677,1272.5]
[55,"-  59",2940,4284.5,3286.5,2468,1945.5,1505]
[60,null,3128,4734,3639,2714.5,2145,1666.5]
[61,null,3521,5329,4094,3056.5,2416,1878]
[62,null,{"$f":"+C430*$L$2","v":3913.5},5922.5,4554.5,3398,2686.5,2087.5]
[63,null,4306.5,6516.5,5010.5,3740,2957,2299]
[64,null,4698.5,7111.5,5468.5,4082.5,3228.5,2507]
[65,null,5161.5,7689,5951,4448.5,3516,2854]
[66,null,5466.5,8142,6301,4712,3724,3025.5]
[67,null,6074.5,9049.5,7004.5,5237,4141.5,3362.5]
[68,null,6683.5,9955.5,7705.5,5763,4557.5,3700]
[69,null,6987,10409,8057,6024,4764.5,3870.5]
[70,null,7136,10542,8185.5,6117,4854,3921.5]
[71,null,8030,11863,9211,6883.5,5464,4412.5]
[72,null,{"$f":"+C440*$L$2","v":8921.5},13184.5,10239,7651.5,6072,4905]
[73,null,9815.5,14504,11265,8418,6681.5,5397.5]
[74,null,10708,15825,12289.5,9184,7290.5,5889.5]
[75,"o más",11693.5,17311,13704,10535,7982,6758]
[1,"Hijo",480,786,560.5,443,392,284.5]
[2,"Hijos",739,1283.5,884,701,623,418.5]
[3,"Hijos o más",1077.5,1878.5,1290,1024,901.5,634.5]
[1,"Rider Comp. Maternidad",112.5,112.5,112.5,112.5,112.5,112.5]
[1,"Transplante de organos",125,150,150,150,150,150]
[]
["ELITE CARE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,{"$f":"L487*$L$6","v":0},5128,3284,2601,2148,1559]
[19,null,{"$f":"L488*$L$6","v":0},5229,3346,2653,2188,1588]
[20,null,0,5334,3407,2705,2230,1617]
[21,null,0,5437,3472,2754,2271,1650]
[22,null,0,5548,3538,2806,2316,1680]
[23,null,0,5651,3600,2860,2356,1710]
[24,null,0,5760,3666,2911,2398,1741]
[25,null,0,5864,3729,2964,2443,1774]
[26,null,0,5972,3793,3019,2484,1806]
[27,null,0,6079,3858,3071,2527,1834]
[28,null,0,6210,3935,3135,2583,1880]
[29,null,0,6344,4011,3199,2640,1924]
[30,null,0,6477,4087,3255,2699,1971]
[31,null,0,6609,4162,3318,2755,2018]
[32,null,0,6741,4239,3381,2814,2060]
[33,null,0,6930,4340,3464,2884,2124]
[34,null,0,7122,4444,3548,2953,2187]
[35,null,0,7310,4544,3633,3021,2249]
[36,null,0,7500,4644,3716,3090,2310]
[37,null,0,7688,4746,3800,3158,2372]
[38,null,0,7943,4912,3939,3255,2449]
[39,null,0,8196,5077,4074,3357,2527]
[40,null,0,8451,5243,4213,3454,2606]
[41,null,0,8703,5410,4351,3554,2680]
[42,null,null,8959,5574,4485,3652,2760]
[43,null,null,9278,5768,4640,3761,2846]
[44,null,null,9593,5960,4797,3872,2934]
[45,null,null,9914,6153,4952,3977,3022]
[46,null,null,10230,6345,5108,4087,3107]
[47,null,null,10548,6537,5260,4193,3200]
[48,null,null,10943,6760,5452,4338,3312]
[49,null,null,11335,6985,5640,4485,3426]
[50,null,null,11731,7210,5827,4630,3539]
[51,null,null,12127,7437,6014,4779,3652]
[52,null,null,12518,7657,6205,4923,3766]
[53,null,null,12998,7958,6428,5102,3910]
[54,null,null,13477,8262,6652,5277,4050]
[55,null,null,13953,8565,6878,5458,4192]
[56,null,null,14433,8867,7104,5635,4335]
[57,null,null,14909,9168,7327,5815,4478]
[58,null,null,15489,9571,7619,6048,4661]
[59,null,null,16072,9973,7908,6288,4849]
[60,null,null,16653,10376,8197,6520,5035]
[61,null,null,17342,10876,8582,6821,5273]
[62,null,null,18152,11481,9067,7193,5628]
[63,null,null,19099,12216,9673,7647,6047]
[64,null,null,20186,13079,10399,8207,6540]
[65,null,null,21436,14078,11253,8890,7111]
[66,null,null,22873,15222,12249,9711,7806]
[67,null,null,24517,16533,13397,10680,8633]
[68,null,null,26448,18086,14736,11818,9602]
[69,null,null,28676,19911,16291,13149,10735]
[70,null,null,31227,22008,18091,14697,12058]
[71,null,null,34134,24398,20150,16479,13585]
[72,null,null,37436,27107,22497,18515,15337]
[73,null,null,41132,30151,25148,20818,17340]
[74,null,null,45315,33592,28146,23405,19618]
[75,null,null,50016,37439,31528,26321,22185]
[76,null,null,55394,41897,35335,29605,25059]
[77,null,null,61850,47047,39721,33382,28328]
[78,null,null,69645,53200,44725,37731,32082]
[79,null,null,79057,60514,50555,42703,36389]
[80,"o mas",null,90351,69158,57501,48632,41495]
[1,"Hijo",null,2180,1516,1106,909,797]
[2,"Hijos",null,3354,2464,1748,1442,1263]
[3,"Hijos o más",null,4897,3602,2546,2098,1827]
[1,"Rider Comp. Maternidad",null,0,0,0,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[null,"Deductible Waiver",null,45,180,345,775,1330]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,{"$f":"+C487*$L$2","v":0},2564,1642,1300.5,1074,779.5]
[19,null,{"$f":"+C488*$L$2","v":0},2614.5,1673,1326.5,1094,794]
[20,null,{"$f":"+C489*$L$2","v":0},2667,1703.5,1352.5,1115,808.5]
[21,null,{"$f":"+C490*$L$2","v":0},2718.5,1736,1377,1135.5,825]
[22,null,{"$f":"+C491*$L$2","v":0},2774,1769,1403,1158,840]
[23,null,{"$f":"+C492*$L$2","v":0},2825.5,1800,1430,1178,855]
[24,null,{"$f":"+C493*$L$2","v":0},2880,1833,1455.5,1199,870.5]
[25,null,{"$f":"+C494*$L$2","v":0},2932,1864.5,1482,1221.5,887]
[26,null,{"$f":"+C495*$L$2","v":0},2986,1896.5,1509.5,1242,903]
[27,null,{"$f":"+C496*$L$2","v":0},3039.5,1929,1535.5,1263.5,917]
[28,null,{"$f":"+C497*$L$2","v":0},3105,1967.5,1567.5,1291.5,940]
[29,null,{"$f":"+C498*$L$2","v":0},3172,2005.5,1599.5,1320,962]
[30,null,{"$f":"+C499*$L$2","v":0},3238.5,2043.5,1627.5,1349.5,985.5]
[31,null,{"$f":"+C500*$L$2","v":0},3304.5,2081,1659,1377.5,1009]
[32,null,{"$f":"+C501*$L$2","v":0},3370.5,2119.5,1690.5,1407,1030]
[33,null,{"$f":"+C502*$L$2","v":0},3465,2170,1732,1442,1062]
[34,null,{"$f":"+C503*$L$2","v":0},3561,2222,1774,1476.5,1093.5]
[35,null,{"$f":"+C504*$L$2","v":0},3655,2272,1816.5,1510.5,1124.5]
[36,null,{"$f":"+C505*$L$2","v":0},3750,2322,1858,1545,1155]
[37,null,{"$f":"+C506*$L$2","v":0},3844,2373,1900,1579,1186]
[38,null,{"$f":"+C507*$L$2","v":0},3971.5,2456,1969.5,1627.5,1224.5]
[39,null,{"$f":"+C508*$L$2","v":0},4098,2538.5,2037,1678.5,1263.5]
[40,null,{"$f":"+C509*$L$2","v":0},4225.5,2621.5,2106.5,1727,1303]
[41,null,{"$f":"+C510*$L$2","v":0},4351.5,2705,2175.5,1777,1340]
[42,null,null,{"$f":"+D511*$L$2","v":4479.5},2787,2242.5,1826,1380]
[43,null,null,{"$f":"+D512*$L$2","v":4639},2884,2320,1880.5,1423]
[44,null,null,{"$f":"+D513*$L$2","v":4796.5},2980,2398.5,1936,1467]
[45,null,null,{"$f":"+D514*$L$2","v":4957},3076.5,2476,1988.5,1511]
[46,null,null,{"$f":"+D515*$L$2","v":5115},3172.5,2554,2043.5,1553.5]
[47,null,null,{"$f":"+D516*$L$2","v":5274},3268.5,2630,2096.5,1600]
[48,null,null,{"$f":"+D517*$L$2","v":5471.5},3380,2726,2169,1656]
[49,null,null,{"$f":"+D518*$L$2","v":5667.5},3492.5,2820,2242.5,1713]
[50,null,null,{"$f":"+D519*$L$2","v":5865.5},3605,2913.5,2315,1769.5]
[51,null,null,{"$f":"+D520*$L$2","v":6063.5},3718.5,3007,2389.5,1826]
[52,null,null,{"$f":"+D521*$L$2","v":6259},3828.5,3102.5,2461.5,1883]
[53,null,null,{"$f":"+D522*$L$2","v":6499},3979,3214,2551,1955]
[54,null,null,{"$f":"+D523*$L$2","v":6738.5},4131,3326,2638.5,2025]
[55,null,null,{"$f":"+D524*$L$2","v":6976.5},4282.5,3439,2729,2096]
[56,null,null,{"$f":"+D525*$L$2","v":7216.5},4433.5,3552,2817.5,2167.5]
[57,null,null,{"$f":"+D526*$L$2","v":7454.5},4584,3663.5,2907.5,2239]
[58,null,null,{"$f":"+D527*$L$2","v":7744.5},4785.5,3809.5,3024,2330.5]
[59,null,null,{"$f":"+D528*$L$2","v":8036},4986.5,3954,3144,2424.5]
[60,null,null,{"$f":"+D529*$L$2","v":8326.5},5188,4098.5,3260,2517.5]
[61,null,null,{"$f":"+D530*$L$2","v":8671},5438,4291,3410.5,2636.5]
[62,null,null,{"$f":"+D531*$L$2","v":9076},5740.5,4533.5,3596.5,2814]
[63,null,null,{"$f":"+D532*$L$2","v":9549.5},6108,4836.5,3823.5,3023.5]
[64,null,null,{"$f":"+D533*$L$2","v":10093},6539.5,5199.5,4103.5,3270]
[65,null,null,{"$f":"+D534*$L$2","v":10718},7039,5626.5,4445,3555.5]
[66,null,null,{"$f":"+D535*$L$2","v":11436.5},7611,6124.5,4855.5,3903]
[67,null,null,{"$f":"+D536*$L$2","v":12258.5},8266.5,6698.5,5340,4316.5]
[68,null,null,{"$f":"+D537*$L$2","v":13224},9043,7368,5909,4801]
[69,null,null,{"$f":"+D538*$L$2","v":14338},9955.5,8145.5,6574.5,5367.5]
[70,null,null,{"$f":"+D539*$L$2","v":15613.5},11004,9045.5,7348.5,6029]
[71,null,null,{"$f":"+D540*$L$2","v":17067},12199,10075,8239.5,6792.5]
[72,null,null,{"$f":"+D541*$L$2","v":18718},13553.5,11248.5,9257.5,7668.5]
[73,null,null,{"$f":"+D542*$L$2","v":20566},15075.5,12574,10409,8670]
[74,null,null,{"$f":"+D543*$L$2","v":22657.5},16796,14073,11702.5,9809]
[75,null,null,{"$f":"+D544*$L$2","v":25008},18719.5,15764,13160.5,11092.5]
[76,null,null,{"$f":"+D545*$L$2","v":27697},20948.5,17667.5,14802.5,12529.5]
[77,null,null,{"$f":"+D546*$L$2","v":30925},23523.5,19860.5,16691,14164]
[78,null,null,{"$f":"+D547*$L$2","v":34822.5},26600,22362.5,18865.5,16041]
[79,null,null,{"$f":"+D548*$L$2","v":39528.5},30257,25277.5,21351.5,18194.5]
[80,"o mas",null,{"$f":"+D549*$L$2","v":45175.5},34579,28750.5,24316,20747.5]
[1,"Hijo",{"$f":"+C550*$L$2","v":0},1090,758,553,454.5,398.5]
[2,"Hijos",{"$f":"+C551*$L$2","v":0},1677,1232,874,721,631.5]
[3,"Hijos o más",{"$f":"+C552*$L$2","v":0},2448.5,1801,1273,1049,913.5]
[1,"Rider Comp. Maternidad",{"$f":"+C553*$L$2","v":0},0,0,0,112.5,112.5]
[1,"Transplante de organos",{"$f":"+C554*$L$2","v":0},150,150,150,150,150]
[null,"Deductible Waiver",null,{"$f":"+D555*$L$2","v":22.5},90,172.5,387.5,665]
[]
["UNIQUE CARE - DEDUCIBLE CERO",null,null,null,null,null,null,null,"?"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"ET2","ET3","ET4","ET5"]
[18,null,null,2616,2302,2060,1818]
[19,null,null,2662,2342,2095,1851]
[20,null,null,2708,2383,2132,1882]
[21,null,null,2758,2427,2172,1917]
[22,null,null,2808,2470,2211,1951]
[23,null,null,2859,2514,2247,1985]
[24,null,null,2908,2556,2288,2019]
[25,null,null,2957,2600,2326,2052]
[26,null,null,3006,2644,2367,2089]
[27,null,null,3057,2691,2407,2125]
[28,null,null,3114,2739,2450,2161]
[29,null,null,3173,2791,2498,2205]
[30,null,null,3229,2841,2543,2243]
[31,null,null,3290,2894,2589,2285]
[32,null,null,3346,2944,2634,2324]
[33,null,null,3441,3027,2708,2390]
[34,null,null,3536,3111,2782,2454]
[35,null,null,3630,3192,2856,2519]
[36,null,null,3722,3274,2930,2587]
[37,null,null,3818,3359,3006,2653]
[38,null,null,3914,3443,3081,2719]
[39,null,null,4013,3530,3159,2788]
[40,null,null,4108,3616,3234,2854]
[41,null,null,4207,3701,3311,2922]
[42,null,null,4303,3786,3389,2989]
[43,null,null,4478,3940,3525,3112]
[44,null,null,4653,4094,3664,3233]
[45,null,null,4828,4249,3801,3354]
[46,null,null,5006,4404,3941,3477]
[47,null,null,5179,4556,4077,3599]
[48,null,null,5365,4719,4221,3727]
[49,null,null,5552,4884,4370,3857]
[50,null,null,5737,5047,4515,3984]
[51,null,null,5921,5210,4661,4113]
[52,null,null,6107,5372,4807,4241]
[53,null,null,6329,5567,4981,4395]
[54,null,null,6546,5760,5152,4547]
[55,null,null,6765,5951,5324,4697]
[56,null,null,6984,6143,5498,4851]
[57,null,null,7206,6337,5672,5005]
[58,null,null,7474,6576,5884,5193]
[59,null,null,7742,6811,6093,5375]
[60,null,null,8012,7046,6305,5563]
[61,null,null,8306,7306,6538,5768]
[62,null,null,8678,7633,6830,6025]
[63,null,null,9116,8018,7174,6331]
[64,null,null,9630,8473,7581,6689]
[65,null,null,10295,9057,8102,7150]
[66,null,null,11063,9732,8706,7682]
[67,null,null,11944,10506,9400,8294]
[68,null,null,12949,11391,10192,8994]
[69,null,null,14137,12436,11127,9818]
[70,null,null,15580,13704,12262,10821]
[71,null,null,17149,15085,13497,11910]
[72,null,null,18969,16686,14930,13173]
[73,null,null,21049,18516,16567,14619]
[74,null,null,23468,20642,18470,16296]
[75,null,null,26289,23126,20692,18258]
[76,null,null,29482,25934,23204,20475]
[77,null,null,33110,29125,26060,22994]
[78,null,null,37202,32724,29280,25836]
[79,null,null,41800,36768,32898,29029]
[80,"o mas",null,47298,41606,37226,32847]
[1,"Hijo",null,1233,1086,972,857]
[2,"Hijos",null,2025,1781,1594,1406]
[3,"Hijos o más",null,2963,2606,2333,2058]
[1,"Rider Comp. Maternidad",null,0,0,0,225]
[1,"Transplante de organos",null,300,300,300,300]
[]
["TARIFAS SEMESTRALES ",null,null,null,null,null,null,null,"?"]
["EDAD"]
[" "," ","ET1","ET2","ET3","ET4","ET5","ET6"]
[18,null,{"$f":"+C633*$L$2","v":0},1308,1151,1030,909,0]
[19,null,0,1331,1171,1047.5,925.5,0]
[20,null,0,1354,1191.5,1066,941,0]
[21,null,0,1379,1213.5,1086,958.5,0]
[22,null,0,1404,1235,1105.5,975.5,0]
[23,null,0,1429.5,1257,1123.5,992.5,0]
[24,null,0,1454,1278,1144,1009.5,0]
[25,null,0,1478.5,1300,1163,1026,0]
[26,null,0,1503,1322,1183.5,1044.5,0]
[27,null,0,1528.5,1345.5,1203.5,1062.5,0]
[28,null,{"$f":"+C643*$L$2","v":0},1557,1369.5,1225,1080.5,0]
[29,null,0,1586.5,1395.5,1249,1102.5,0]
[30,null,0,1614.5,1420.5,1271.5,1121.5,0]
[31,null,0,1645,1447,1294.5,1142.5,0]
[32,null,0,1673,1472,1317,1162,0]
[33,null,0,1720.5,1513.5,1354,1195,0]
[34,null,0,1768,1555.5,1391,1227,0]
[35,null,0,1815,1596,1428,1259.5,0]
[36,null,0,1861,1637,1465,1293.5,0]
[37,null,0,1909,1679.5,1503,1326.5,0]
[38,null,{"$f":"+C653*$L$2","v":0},1957,1721.5,1540.5,1359.5,0]
[39,null,0,2006.5,1765,1579.5,1394,0]
[40,null,0,2054,1808,1617,1427,0]
[41,null,0,2103.5,1850.5,1655.5,1461,0]
[42,null,null,{"$f":"+D657*$L$2","v":2151.5},1893,1694.5,1494.5,0]
[43,null,null,{"$f":"+D658*$L$2","v":2239},1970,1762.5,1556,0]
[44,null,null,{"$f":"+D659*$L$2","v":2326.5},2047,1832,1616.5,0]
[45,null,null,{"$f":"+D660*$L$2","v":2414},2124.5,1900.5,1677,0]
[46,null,null,{"$f":"+D661*$L$2","v":2503},2202,1970.5,1738.5,0]
[47,null,null,{"$f":"+D662*$L$2","v":2589.5},2278,2038.5,1799.5,0]
[48,null,null,{"$f":"+D663*$L$2","v":2682.5},2359.5,2110.5,1863.5,0]
[49,null,null,{"$f":"+D664*$L$2","v":2776},2442,2185,1928.5,0]
[50,null,null,{"$f":"+D665*$L$2","v":2868.5},2523.5,2257.5,1992,0]
[51,null,null,{"$f":"+D666*$L$2","v":2960.5},2605,2330.5,2056.5,0]
[52,null,null,{"$f":"+D667*$L$2","v":3053.5},2686,2403.5,2120.5,0]
[53,null,null,{"$f":"+D668*$L$2","v":3164.5},2783.5,2490.5,2197.5,0]
[54,null,null,{"$f":"+D669*$L$2","v":3273},2880,2576,2273.5,0]
[55,null,null,{"$f":"+D670*$L$2","v":3382.5},2975.5,2662,2348.5,0]
[56,null,null,{"$f":"+D671*$L$2","v":3492},3071.5,2749,2425.5,0]
[57,null,null,{"$f":"+D672*$L$2","v":3603},3168.5,2836,2502.5,0]
[58,null,null,{"$f":"+D673*$L$2","v":3737},3288,2942,2596.5,0]
[59,null,null,{"$f":"+D674*$L$2","v":3871},3405.5,3046.5,2687.5,0]
[60,null,null,{"$f":"+D675*$L$2","v":4006},3523,3152.5,2781.5,0]
[61,null,null,{"$f":"+D676*$L$2","v":4153},3653,3269,2884,0]
[62,null,null,{"$f":"+D677*$L$2","v":4339},3816.5,3415,3012.5,0]
[63,null,null,{"$f":"+D678*$L$2","v":4558},4009,3587,3165.5,0]
[64,null,null,{"$f":"+D679*$L$2","v":4815},4236.5,3790.5,3344.5,0]
[65,null,null,{"$f":"+D680*$L$2","v":5147.5},4528.5,4051,3575,0]
[66,null,null,{"$f":"+D681*$L$2","v":5531.5},4866,4353,3841,0]
[67,null,null,{"$f":"+D682*$L$2","v":5972},5253,4700,4147,0]
[68,null,null,{"$f":"+D683*$L$2","v":6474.5},5695.5,5096,4497,0]
[69,null,null,{"$f":"+D684*$L$2","v":7068.5},6218,5563.5,4909,0]
[70,null,null,{"$f":"+D685*$L$2","v":7790},6852,6131,5410.5,0]
[71,null,null,{"$f":"+D686*$L$2","v":8574.5},7542.5,6748.5,5955,0]
[72,null,null,{"$f":"+D687*$L$2","v":9484.5},8343,7465,6586.5,0]
[73,null,null,{"$f":"+D688*$L$2","v":10524.5},9258,8283.5,7309.5,0]
[74,null,null,{"$f":"+D689*$L$2","v":11734},10321,9235,8148,0]
[75,null,null,{"$f":"+D690*$L$2","v":13144.5},11563,10346,9129,0]
[76,null,null,{"$f":"+D691*$L$2","v":14741},12967,11602,10237.5,0]
[77,null,null,{"$f":"+D692*$L$2","v":16555},14562.5,13030,11497,0]
[78,null,null,{"$f":"+D693*$L$2","v":18601},16362,14640,12918,0]
[79,null,null,{"$f":"+D694*$L$2","v":20900},18384,16449,14514.5,0]
[80,"o mas",null,{"$f":"+D695*$L$2","v":23649},20803,18613,16423.5,0]
[1,"Hijo",{"$f":"+C696*$L$2","v":0},616.5,543,486,428.5,0]
[2,"Hijos",0,1012.5,890.5,797,703,0]
[3,"Hijos o más",0,1481.5,1303,1166.5,1029,0]
[1,"Rider Comp. Maternidad",0,0,0,0,112.5,0]
[1,"Transplante de organos",0,150,150,150,150,0]
[]
["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 ",null,null,null,null,null,null,null,"?"]
["EDAD"]
[" "," ","ET1","ET2","ET3","ET4","ET5","ET6"]
[18,null,{"$f":"+C778*$L$2","v":663},551,539.5,509,464,358.5]
[19,null,735.5,560.5,549,517.5,472,366.5]
[20,null,851,570,558,526.5,480,374]
[21,null,941.5,579.5,568,535,488,382]
[22,null,1061.5,589.5,577.5,544.5,496.5,390]
[23,null,1230.5,599.5,587,553.5,504,398.5]
[24,null,1347.5,609.5,597,562.5,512.5,406.5]
[25,null,1592.5,618.5,606,571,521.5,415]
[26,null,1679,628.5,616,580.5,529,423]
[27,null,1890,638,625.5,589.5,537.5,431.5]
[28,null,{"$f":"+C788*$L$2","v":2102.5},650,637,600,547,441]
[29,null,2313,661,648,610.5,556.5,451.5]
[30,null,2523.5,673,659,621,566.5,462]
[31,null,2534,684,670.5,631.5,576.5,472]
[32,null,2544,696,681.5,642.5,585.5,482.5]
[33,null,2828,715,700.5,660,602,497]
[34,null,3112.5,734,719,677.5,618,512]
[35,null,3254,753,738,695.5,634,526.5]
[36,null,3277,772,756.5,713,650,541.5]
[37,null,3688,791,775.5,730.5,666.5,556]
[38,null,{"$f":"+C798*$L$2","v":4099},811,794.5,748.5,683,572]
[39,null,4510.5,830,813.5,767,699,587.5]
[40,null,4921,849.5,832.5,784.5,715,603.5]
[41,null,5376,869,851.5,802.5,731.5,619]
[42,null,null,{"$f":"+D802*$L$2","v":888.5},870.5,820.5,748,635.5]
[43,null,null,{"$f":"+D803*$L$2","v":923.5},905.5,853,778,663]
[44,null,null,{"$f":"+D804*$L$2","v":959},939.5,885.5,807.5,691.5]
[45,null,null,{"$f":"+D805*$L$2","v":994.5},974.5,918.5,837,719.5]
[46,null,null,{"$f":"+D806*$L$2","v":1029.5},1009,950.5,867.5,747]
[47,null,null,{"$f":"+D807*$L$2","v":1065},1044,983.5,897,775.5]
[48,null,null,{"$f":"+D808*$L$2","v":1102.5},1080,1018.5,928.5,804]
[49,null,null,{"$f":"+D809*$L$2","v":1139.5},1116.5,1052.5,960,834]
[50,null,null,{"$f":"+D810*$L$2","v":1177},1153.5,1087,991.5,862.5]
[51,null,null,{"$f":"+D811*$L$2","v":1214.5},1190.5,1121.5,1023,892]
[52,null,null,{"$f":"+D812*$L$2","v":1252},1226.5,1156,1054.5,921]
[53,null,null,{"$f":"+D813*$L$2","v":1296},1270.5,1197,1091,957]
[54,null,null,{"$f":"+D814*$L$2","v":1340.5},1313.5,1238,1128.5,992.5]
[55,null,null,{"$f":"+D815*$L$2","v":1384.5},1357,1279,1166,1029]
[56,null,null,{"$f":"+D816*$L$2","v":1429},1400.5,1319.5,1203.5,1064]
[57,null,null,{"$f":"+D817*$L$2","v":1473},1443.5,1360.5,1240,1100.5]
[58,null,null,{"$f":"+D818*$L$2","v":1524.5},1493.5,1403.5,1283.5,1147]
[59,null,null,{"$f":"+D819*$L$2","v":1575},1543.5,1446.5,1326,1193.5]
[60,null,null,{"$f":"+D820*$L$2","v":1626},1593.5,1489,1369.5,1240]
[61,null,null,{"$f":"+D821*$L$2","v":1688},1654,1553.5,1421.5,1286]
[62,null,null,{"$f":"+D822*$L$2","v":1764},1728.5,1629.5,1485.5,1344.5]
[63,null,null,{"$f":"+D823*$L$2","v":1854.5},1817.5,1713,1562,1413.5]
[64,null,null,{"$f":"+D824*$L$2","v":1961.5},1922.5,1812,1652,1495]
[65,null,null,{"$f":"+D825*$L$2","v":2089.5},2047.5,1930,1759.5,1606.5]
[66,null,null,{"$f":"+D826*$L$2","v":2240.5},2195.5,2069.5,1887,1735]
[67,null,null,{"$f":"+D827*$L$2","v":2419.5},2370.5,2234,2037,1875]
[68,null,null,{"$f":"+D828*$L$2","v":2625},2572.5,2424,2210,2033.5]
[69,null,null,{"$f":"+D829*$L$2","v":2864.5},2806.5,2645,2412,2220.5]
[70,null,null,{"$f":"+D830*$L$2","v":3142},3078.5,2877,2646,2471]
[71,null,null,{"$f":"+D831*$L$2","v":3460},3390.5,3195.5,2913,2720.5]
[72,null,null,{"$f":"+D832*$L$2","v":3828},3750.5,3535.5,3223.5,3012]
[73,null,null,{"$f":"+D833*$L$2","v":4251.5},4165.5,3926.5,3580,3343]
[74,null,null,{"$f":"+D834*$L$2","v":4740},4645,4377.5,3991,3728.5]
[75,null,null,{"$f":"+D835*$L$2","v":5300},5193,4874,4462.5,4194.5]
[76,null,null,{"$f":"+D836*$L$2","v":5943.5},5823.5,5484.5,5004,4703.5]
[77,null,null,{"$f":"+D837*$L$2","v":6675},6540.5,6164,5620.5,5282.5]
[78,null,null,{"$f":"+D838*$L$2","v":7500},7349,6926.5,6315,5935]
[79,null,null,{"$f":"+D839*$L$2","v":8427},8257,7782.5,7095,6669]
[80,"o mas",null,{"$f":"+D840*$L$2","v":9536},9343.5,8806,8029.5,7546]
[1,"Hijo",{"$f":"+C841*$L$2","v":302},281.5,275.5,260,237,140]
[2,"Hijos",{"$f":"+C842*$L$2","v":495.5},474.5,465,438.5,400,208]
[3,"Hijos o más",{"$f":"+C843*$L$2","v":726},696.5,682,642.5,586.5,298.5]
[1,"Rider Comp. Maternidad",{"$f":"+C844*$L$2","v":112.5},112.5,112.5,112.5,112.5,112.5]
[1,"Transplante de organos",{"$f":"+C845*$L$2","v":125},150,150,150,150,150]
[]
["BUPA ESSENTIAL CARE"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","DW1","DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",null,{"$f":"D6*$L$3","v":362.5},{"$f":"E6*$L$3","v":329.25},299,257.75,0]
[25,"-  29",null,{"$f":"D7*$L$3","v":408},370.5,336.5,290,0]
[30,"-  34",null,457.25,415.25,377.25,325.25,0]
[35,"-  39",null,522,474,430.75,371.25,0]
[40,"-  44",null,605.25,549.5,499.25,430.5,0]
[45,"-  49",null,723.5,657,597,514.5,0]
[50,"-  54",null,863.25,783.75,712.25,613.75,0]
[55,"-  59",null,1027.5,933,847.75,730.75,0]
[60,null,null,1140,1035,940.5,810.5,0]
[61,null,null,1187.25,1078,979.5,844.25,0]
[62,null,null,1244.25,1129.75,1026.5,884.75,0]
[63,null,null,1306.25,1186.25,1077.75,929,0]
[64,null,null,1381,1254,1139.25,982,0]
[65,null,null,1484,1347.5,1224.25,1055.25,0]
[66,null,null,1603.25,1455.75,1322.75,1140,0]
[67,null,null,1730.5,1571.25,1427.75,1230.5,0]
[68,null,null,1875.5,1702.75,1547.25,1333.5,0]
[69,null,null,2047,1858.5,1688.75,1455.5,0]
[70,null,null,2259,2051,1863.75,1606.25,0]
[71,null,null,2507.5,2276.75,2068.5,1783,0]
[72,null,null,2773.75,2518.25,2288.25,1972.25,0]
[73,null,null,3077.25,2794,2538.75,2188,0]
[74,null,null,3429.5,3114,2829.25,2438.75,0]
[75,"o más",null,3842.5,3488.75,3170,2732.25,0]
[1,"Hijo",null,128,116.25,105.5,91,0]
[2,"Hijos",null,197.5,179.25,163,140.5,0]
[3,"Hijos o más",null,286.75,260.5,236.75,204,0]
[1,"Rider Comp. Maternidad",null,0,0,56.25,56.25,0]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["XX"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","CW1","CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",null,{"$f":"D633*$L$3","v":654},{"$f":"E633*$L$3","v":575.5},515,454.5,0]
[25,"-  29",null,{"$f":"D634*$L$3","v":665.5},585.5,523.75,462.75,0]
[30,"-  34",null,{"$f":"D635*$L$3","v":677},595.75,533,470.5,0]
[35,"-  39",null,{"$f":"D636*$L$3","v":689.5},606.75,543,479.25,0]
[40,"-  44",null,{"$f":"D637*$L$3","v":702},617.5,552.75,487.75,0]
[45,"-  49",null,{"$f":"D638*$L$3","v":714.75},628.5,561.75,496.25,0]
[50,"-  54",null,{"$f":"D639*$L$3","v":727},639,572,504.75,0]
[55,"-  59",null,{"$f":"D640*$L$3","v":739.25},650,581.5,513,0]
[60,null,null,{"$f":"D641*$L$3","v":751.5},661,591.75,522.25,0]
[61,null,null,{"$f":"D642*$L$3","v":764.25},672.75,601.75,531.25,0]
[62,null,null,{"$f":"D643*$L$3","v":778.5},684.75,612.5,540.25,0]
[63,null,null,{"$f":"D644*$L$3","v":793.25},697.75,624.5,551.25,0]
[64,null,null,{"$f":"D645*$L$3","v":807.25},710.25,635.75,560.75,0]
[65,null,null,{"$f":"D646*$L$3","v":822.5},723.5,647.25,571.25,0]
[66,null,null,{"$f":"D647*$L$3","v":836.5},736,658.5,581,0]
[67,null,null,{"$f":"D648*$L$3","v":860.25},756.75,677,597.5,0]
[68,null,null,{"$f":"D649*$L$3","v":884},777.75,695.5,613.5,0]
[69,null,null,{"$f":"D650*$L$3","v":907.5},798,714,629.75,0]
[70,null,null,{"$f":"D651*$L$3","v":930.5},818.5,732.5,646.75,0]
[71,null,null,{"$f":"D652*$L$3","v":954.5},839.75,751.5,663.25,0]
[72,null,null,{"$f":"D653*$L$3","v":978.5},860.75,770.25,679.75,0]
[73,null,null,{"$f":"D654*$L$3","v":1003.25},882.5,789.75,697,0]
[74,null,null,{"$f":"D655*$L$3","v":1027},904,808.5,713.5,0]
[75,"o más",null,{"$f":"D656*$L$3","v":1051.75},925.25,827.75,730.5,0]
[1,"Hijo",null,{"$f":"D657*$L$3","v":1075.75},946.5,847.25,747.25,0]
[2,"Hijos",null,{"$f":"D658*$L$3","v":1119.5},985,881.25,778,0]
[3,"Hijos o más",null,{"$f":"D659*$L$3","v":1163.25},1023.5,916,808.25,0]
[1,"Rider Comp. Maternidad",null,{"$f":"D660*$L$3","v":1207},1062.25,950.25,838.5,0]
[1,"Transplante de organos",null,{"$f":"D661*$L$3","v":1251.5},1101,985.25,869.25,0]
[]
["UNIQUE CARE"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,null,{"$f":"D274*$L$3","v":605.5},{"$f":"E274*$L$3","v":470.75},366.5,324.75,263.5]
[19,null,null,{"$f":"D275*$L$3","v":616.5},478.5,374.5,331.5,267.75]
[20,null,null,627,486.5,381.25,337.75,272.25]
[21,null,null,638.5,494.75,389.25,343.5,278]
[22,null,null,650,502.5,397.25,349.75,283.25]
[23,null,null,661.25,510.5,406,355.75,288.25]
[24,null,null,673,518.5,413,362.75,292.75]
[25,null,null,684.5,527,421,368.75,298.75]
[26,null,null,695.75,535,429,375,303.5]
[27,null,null,707.75,543.5,436.75,381,308.25]
[28,null,null,720.75,552.5,447.5,389,315.5]
[29,null,null,734.75,561.5,456.5,397,320.25]
[30,null,null,747.75,571.25,467,404.75,327]
[31,null,null,761.75,580.5,476.25,412.25,333.5]
[32,null,null,774.5,590,486.75,419.75,339.25]
[33,null,null,796.5,606,500.75,431.75,349.5]
[34,null,null,818.25,621.75,516.5,444,358.75]
[35,null,null,840,637.75,531.25,456,368.75]
[36,null,null,861.75,653.75,546,468,378.75]
[37,null,null,884,669.5,560.25,480,388.25]
[38,null,null,906,685.75,576.5,492.5,398.25]
[39,null,null,929,701.75,591.75,505,408.5]
[40,null,null,951,718.75,608,518.25,418.25]
[41,null,null,973.75,734.75,623.5,530.75,428]
[42,null,null,996,750.75,639.5,542.75,439]
[43,null,null,1036.75,779.75,666,565,456.25]
[44,null,null,1077.25,809.5,694,587.5,474.5]
[45,null,null,1117.75,838.5,722,610.75,491.75]
[46,null,null,1158.75,868.5,749.75,633,510.5]
[47,null,null,1199,897.75,777.75,655.75,527.75]
[48,null,null,1242,929.25,806,679.75,547.5]
[49,null,null,1285.25,960.75,834.5,703.5,566.75]
[50,null,null,1328,991.5,864.25,727.5,586.25]
[51,null,null,1371,1022.75,892.25,750.75,604.75]
[52,null,null,1414,1054.25,921.5,774.5,624.25]
[53,null,null,1465.25,1090.5,957,802.5,646.75]
[54,null,null,1515.25,1127.5,993,832,669.5]
[55,null,null,1566,1164.75,1027.25,860.25,692]
[56,null,null,1616.5,1201.5,1062.75,888.5,715.25]
[57,null,null,1668,1238,1098.25,917.25,737.25]
[58,null,null,1730.25,1281,1141,952.5,766]
[59,null,null,1792.25,1323.5,1183.25,987.75,794]
[60,null,null,1854.5,1365.5,1226.25,1023,822.5]
[61,null,null,1922.75,1415.5,1277.25,1061.25,853]
[62,null,null,2008.5,1478.25,1338.25,1107.75,890.25]
[63,null,null,2110,1552.75,1405.25,1164.25,934.5]
[64,null,null,2229.5,1640,1485.5,1230,988.25]
[65,null,null,2382.75,1748.75,1596.5,1317.75,1058]
[66,null,null,2560.75,1874.75,1724.75,1418.75,{"$f":"H322*$L$3","v":1137.75}]
[67,null,null,2764.5,2023.5,1861.5,1532.25,1227.25]
[68,null,null,2997.75,2192.25,2017.5,1659,1331.5]
[69,null,null,3272.5,2393.5,2202,1813,1452.5]
[70,null,null,3606.25,2623,2430,2004,1605.75]
[71,null,null,3969.75,2888.25,2697.25,2206,1766.75]
[72,null,null,4391,3193.75,2983.75,2440,1955.5]
[73,null,null,4872.5,3545,3310.25,2707.25,2169]
[74,null,null,5432.25,3951,3689.25,3018,2417.25]
[75,null,null,6085.75,4416,4133.5,3385,2711.5]
[76,null,null,6824.5,4952,4651,3796.5,3039.75]
[77,null,null,7664.75,5561.5,5227.25,4263,3414.75]
[78,null,null,8611.75,6248.75,5873.25,4790.5,3836.75]
[79,null,null,9675.75,7020.75,6599,5382.25,4311.25]
[80,"o mas",null,10948.75,7944.25,7467,6090,4878.25]
[1,"Hijo",null,285.75,234.25,137.75,135,108.25]
[2,"Hijos",null,468.75,{"$f":"E338*$L$3","v":394.25},212.5,205.25,171]
[3,"Hijos o más",null,{"$f":"D339*$L$3","v":685.75},579,308.5,295,248]
[1,"Rider Comp. Maternidad",null,0,0,0,56.25,56.25]
[1,"Transplante de organos",null,75,75,75,75,75]
[null,"Deductible Waiver",null,11.25,45,86.25,193.75,332.5]
[]
["ELITE CARE"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,null,{"$f":"D487*$L$3","v":1282},{"$f":"E487*$L$3","v":821},650.25,537,389.75]
[19,null,null,{"$f":"D488*$L$3","v":1307.25},836.5,663.25,547,397]
[20,null,null,1333.5,851.75,676.25,557.5,404.25]
[21,null,null,1359.25,868,688.5,567.75,412.5]
[22,null,null,1387,884.5,701.5,579,420]
[23,null,null,1412.75,900,715,589,427.5]
[24,null,null,1440,916.5,727.75,599.5,435.25]
[25,null,null,1466,932.25,741,610.75,443.5]
[26,null,null,1493,948.25,754.75,621,451.5]
[27,null,null,1519.75,964.5,767.75,631.75,458.5]
[28,null,null,1552.5,983.75,783.75,645.75,470]
[29,null,null,1586,1002.75,799.75,660,481]
[30,null,null,1619.25,1021.75,813.75,674.75,492.75]
[31,null,null,1652.25,1040.5,829.5,688.75,504.5]
[32,null,null,1685.25,1059.75,845.25,703.5,515]
[33,null,null,1732.5,1085,866,721,531]
[34,null,null,1780.5,1111,887,738.25,546.75]
[35,null,null,1827.5,1136,908.25,755.25,562.25]
[36,null,null,1875,1161,929,772.5,577.5]
[37,null,null,1922,1186.5,950,789.5,593]
[38,null,null,1985.75,1228,984.75,813.75,612.25]
[39,null,null,2049,1269.25,1018.5,839.25,631.75]
[40,null,null,2112.75,1310.75,1053.25,863.5,651.5]
[41,null,null,2175.75,1352.5,1087.75,888.5,670]
[42,null,null,2239.75,1393.5,1121.25,913,690]
[43,null,null,2319.5,1442,1160,940.25,711.5]
[44,null,null,2398.25,1490,1199.25,968,733.5]
[45,null,null,2478.5,1538.25,1238,994.25,755.5]
[46,null,null,2557.5,1586.25,1277,1021.75,776.75]
[47,null,null,2637,1634.25,1315,1048.25,800]
[48,null,null,2735.75,1690,1363,1084.5,828]
[49,null,null,2833.75,1746.25,1410,1121.25,856.5]
[50,null,null,2932.75,1802.5,1456.75,1157.5,884.75]
[51,null,null,3031.75,1859.25,1503.5,1194.75,913]
[52,null,null,3129.5,1914.25,1551.25,1230.75,941.5]
[53,null,null,3249.5,1989.5,1607,1275.5,977.5]
[54,null,null,3369.25,2065.5,1663,1319.25,1012.5]
[55,null,null,3488.25,2141.25,1719.5,1364.5,1048]
[56,null,null,3608.25,2216.75,1776,1408.75,1083.75]
[57,null,null,3727.25,2292,1831.75,1453.75,1119.5]
[58,null,null,3872.25,2392.75,1904.75,1512,1165.25]
[59,null,null,4018,2493.25,1977,1572,1212.25]
[60,null,null,4163.25,2594,2049.25,1630,1258.75]
[61,null,null,4335.5,2719,2145.5,1705.25,1318.25]
[62,null,null,4538,2870.25,2266.75,1798.25,1407]
[63,null,null,4774.75,3054,2418.25,1911.75,1511.75]
[64,null,null,5046.5,3269.75,2599.75,2051.75,1635]
[65,null,null,5359,3519.5,2813.25,2222.5,1777.75]
[66,null,null,5718.25,3805.5,3062.25,2427.75,{"$f":"H535*$L$3","v":1951.5}]
[67,null,null,6129.25,4133.25,3349.25,2670,2158.25]
[68,null,null,6612,4521.5,3684,2954.5,2400.5]
[69,null,null,7169,4977.75,4072.75,3287.25,2683.75]
[70,null,null,7806.75,5502,4522.75,3674.25,3014.5]
[71,null,null,8533.5,6099.5,5037.5,4119.75,3396.25]
[72,null,null,9359,6776.75,5624.25,4628.75,3834.25]
[73,null,null,10283,7537.75,6287,5204.5,4335]
[74,null,null,11328.75,8398,7036.5,5851.25,4904.5]
[75,null,null,12504,9359.75,7882,6580.25,5546.25]
[76,null,null,13848.5,10474.25,8833.75,7401.25,6264.75]
[77,null,null,15462.5,11761.75,9930.25,8345.5,7082]
[78,null,null,17411.25,13300,11181.25,9432.75,8020.5]
[79,null,null,19764.25,15128.5,12638.75,10675.75,9097.25]
[80,"o mas",null,22587.75,17289.5,14375.25,12158,10373.75]
[1,"Hijo",null,545,379,276.5,227.25,199.25]
[2,"Hijos",null,838.5,{"$f":"E551*$L$3","v":616},437,360.5,315.75]
[3,"Hijos o más",null,{"$f":"D552*$L$3","v":1224.25},900.5,636.5,524.5,456.75]
[1,"Rider Comp. Maternidad",null,0,0,0,56.25,56.25]
[1,"Transplante de organos",null,75,75,75,75,75]
[null,"Deductible Waiver",null,11.25,45,86.25,193.75,332.5]
[]
["UNIQUE CARE -DEDUCIBLE CERO"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,null,{"$f":"D633*$L$3","v":654},{"$f":"E633*$L$3","v":575.5},515,454.5,0]
[19,null,null,{"$f":"D634*$L$3","v":665.5},585.5,523.75,462.75,0]
[20,null,null,{"$f":"D635*$L$3","v":677},595.75,533,470.5,0]
[21,null,null,{"$f":"D636*$L$3","v":689.5},606.75,543,479.25,0]
[22,null,null,{"$f":"D637*$L$3","v":702},617.5,552.75,487.75,0]
[23,null,null,{"$f":"D638*$L$3","v":714.75},628.5,561.75,496.25,0]
[24,null,null,{"$f":"D639*$L$3","v":727},639,572,504.75,0]
[25,null,null,{"$f":"D640*$L$3","v":739.25},650,581.5,513,0]
[26,null,null,{"$f":"D641*$L$3","v":751.5},661,591.75,522.25,0]
[27,null,null,{"$f":"D642*$L$3","v":764.25},672.75,601.75,531.25,0]
[28,null,null,{"$f":"D643*$L$3","v":778.5},684.75,612.5,540.25,0]
[29,null,null,{"$f":"D644*$L$3","v":793.25},697.75,624.5,551.25,0]
[30,null,null,{"$f":"D645*$L$3","v":807.25},710.25,635.75,560.75,0]
[31,null,null,{"$f":"D646*$L$3","v":822.5},723.5,647.25,571.25,0]
[32,null,null,{"$f":"D647*$L$3","v":836.5},736,658.5,581,0]
[33,null,null,{"$f":"D648*$L$3","v":860.25},756.75,677,597.5,0]
[34,null,null,{"$f":"D649*$L$3","v":884},777.75,695.5,613.5,0]
[35,null,null,{"$f":"D650*$L$3","v":907.5},798,714,629.75,0]
[36,null,null,{"$f":"D651*$L$3","v":930.5},818.5,732.5,646.75,0]
[37,null,null,{"$f":"D652*$L$3","v":954.5},839.75,751.5,663.25,0]
[38,null,null,{"$f":"D653*$L$3","v":978.5},860.75,770.25,679.75,0]
[39,null,null,{"$f":"D654*$L$3","v":1003.25},882.5,789.75,697,0]
[40,null,null,{"$f":"D655*$L$3","v":1027},904,808.5,713.5,0]
[41,null,null,{"$f":"D656*$L$3","v":1051.75},925.25,827.75,730.5,0]
[42,null,null,{"$f":"D657*$L$3","v":1075.75},946.5,847.25,747.25,0]
[43,null,null,{"$f":"D658*$L$3","v":1119.5},985,881.25,778,0]
[44,null,null,{"$f":"D659*$L$3","v":1163.25},1023.5,916,808.25,0]
[45,null,null,{"$f":"D660*$L$3","v":1207},1062.25,950.25,838.5,0]
[46,null,null,{"$f":"D661*$L$3","v":1251.5},1101,985.25,869.25,0]
[47,null,null,{"$f":"D662*$L$3","v":1294.75},1139,1019.25,899.75,0]
[48,null,null,{"$f":"D663*$L$3","v":1341.25},1179.75,1055.25,931.75,0]
[49,null,null,{"$f":"D664*$L$3","v":1388},1221,1092.5,964.25,0]
[50,null,null,{"$f":"D665*$L$3","v":1434.25},1261.75,1128.75,996,0]
[51,null,null,{"$f":"D666*$L$3","v":1480.25},1302.5,1165.25,1028.25,0]
[52,null,null,{"$f":"D667*$L$3","v":1526.75},1343,1201.75,1060.25,0]
[53,null,null,{"$f":"D668*$L$3","v":1582.25},1391.75,1245.25,1098.75,0]
[54,null,null,{"$f":"D669*$L$3","v":1636.5},1440,1288,1136.75,0]
[55,null,null,{"$f":"D670*$L$3","v":1691.25},1487.75,1331,1174.25,0]
[56,null,null,{"$f":"D671*$L$3","v":1746},1535.75,1374.5,1212.75,0]
[57,null,null,{"$f":"D672*$L$3","v":1801.5},1584.25,1418,1251.25,0]
[58,null,null,{"$f":"D673*$L$3","v":1868.5},1644,1471,1298.25,0]
[59,null,null,{"$f":"D674*$L$3","v":1935.5},1702.75,1523.25,1343.75,0]
[60,null,null,{"$f":"D675*$L$3","v":2003},1761.5,1576.25,1390.75,0]
[61,null,null,{"$f":"D676*$L$3","v":2076.5},1826.5,1634.5,1442,0]
[62,null,null,{"$f":"D677*$L$3","v":2169.5},1908.25,1707.5,1506.25,0]
[63,null,null,{"$f":"D678*$L$3","v":2279},2004.5,1793.5,1582.75,0]
[64,null,null,{"$f":"D679*$L$3","v":2407.5},2118.25,1895.25,1672.25,0]
[65,null,null,{"$f":"D680*$L$3","v":2573.75},2264.25,2025.5,1787.5,0]
[66,null,null,{"$f":"D681*$L$3","v":2765.75},2433,2176.5,1920.5,0]
[67,null,null,{"$f":"D682*$L$3","v":2986},2626.5,2350,2073.5,0]
[68,null,null,{"$f":"D683*$L$3","v":3237.25},2847.75,2548,2248.5,0]
[69,null,null,{"$f":"D684*$L$3","v":3534.25},3109,2781.75,2454.5,0]
[70,null,null,{"$f":"D685*$L$3","v":3895},3426,3065.5,2705.25,0]
[71,null,null,{"$f":"D686*$L$3","v":4287.25},3771.25,3374.25,2977.5,0]
[72,null,null,{"$f":"D687*$L$3","v":4742.25},4171.5,3732.5,3293.25,0]
[73,null,null,{"$f":"D688*$L$3","v":5262.25},4629,4141.75,3654.75,0]
[74,null,null,{"$f":"D689*$L$3","v":5867},5160.5,4617.5,4074,0]
[75,null,null,{"$f":"D690*$L$3","v":6572.25},5781.5,5173,4564.5,0]
[76,null,null,{"$f":"D691*$L$3","v":7370.5},6483.5,5801,5118.75,0]
[77,null,null,{"$f":"D692*$L$3","v":8277.5},7281.25,6515,5748.5,0]
[78,null,null,{"$f":"D693*$L$3","v":9300.5},8181,7320,6459,0]
[79,null,null,{"$f":"D694*$L$3","v":10450},9192,8224.5,7257.25,0]
[80,"o mas",null,{"$f":"D695*$L$3","v":11824.5},10401.5,9306.5,8211.75,0]
[1,"Hijo",null,{"$f":"D696*$L$3","v":308.25},271.5,243,214.25,0]
[2,"Hijos",null,{"$f":"D697*$L$3","v":506.25},445.25,398.5,351.5,0]
[3,"Hijos o más",null,{"$f":"D698*$L$3","v":740.75},651.5,583.25,514.5,0]
[1,"Rider Comp. Maternidad",null,{"$f":"D699*$L$3","v":0},0,0,56.25,0]
[1,"Transplante de organos",null,{"$f":"D700*$L$3","v":75},75,75,75,0]
[null,"Deductible Waiver",null,{"$f":"D701*$L$3","v":0},0,0,0,0]
[]
[]
[]
["BUPA ESSENTIAL CARE"]
["TARIFAS MENSUAL"]
["EDAD"]
[" "," ",null,"DW2","DW3","DW4","DW5"]
[18,"-  24",{"$f":"C6*$L$4","v":0},{"$f":"D6*$L$4","v":135.33333285000001},122.91999956100001,111.62666626800001,96.226666323000003,0]
[25,"-  29",{"$f":"C7*$L$4","v":0},152.31999945600001,138.31999950600002,125.62666621800001,108.26666628000001,0]
[30,"-  34",{"$f":"C8*$L$4","v":0},170.70666605700001,155.026666113,140.83999949700001,121.42666623300001,0]
[35,"-  39",{"$f":"C9*$L$4","v":0},194.87999930400002,176.95999936800001,160.81333275900002,138.599999505,0]
[40,"-  44",{"$f":"C10*$L$4","v":0},225.95999919300002,205.146665934,186.38666600100001,160.71999942600002,0]
[45,"-  49",{"$f":"C11*$L$4","v":0},270.10666570199999,245.279999124,222.879999204,192.07999931400002,0]
[50,"-  54",{"$f":"C12*$L$4","v":0},322.27999884900004,292.59999895499999,265.90666571700001,229.13333251500001,0]
[55,"-  59",{"$f":"C13*$L$4","v":0},383.59999863000002,348.31999875600002,316.49333220300002,272.81333235900001,0]
[60,null,{"$f":"C14*$L$4","v":0},425.59999848000001,386.39999862000002,351.11999874600002,302.58666558600004,0]
[61,null,{"$f":"C15*$L$4","v":0},443.23999841700004,402.45333189600001,365.67999869400001,315.18666554100002,0]
[62,null,{"$f":"C16*$L$4","v":0},464.51999834100002,421.77333182699999,383.226665298,330.30666548700003,0]
[63,null,{"$f":"C17*$L$4","v":0},487.66666492500002,442.86666508500002,402.35999856300003,346.82666542800001,0]
[64,null,{"$f":"C18*$L$4","v":0},515.57333149200008,468.15999832800003,425.31999848100003,366.61333202400004,0]
[65,null,{"$f":"C19*$L$4","v":0},554.02666468799998,503.06666487000001,457.05333170100005,393.95999859300002,0]
[66,null,{"$f":"C20*$L$4","v":0},598.54666452900005,543.47999805900008,493.82666490300005,425.59999848000001,0]
[67,null,{"$f":"C21*$L$4","v":0},646.05333102600002,586.59999790500001,533.02666476299999,459.386665026,0]
[68,null,{"$f":"C22*$L$4","v":0},700.18666416600001,635.69333106300007,577.63999793699998,497.83999822200002,0]
[69,null,{"$f":"C23*$L$4","v":0},764.21333060400002,693.83999752200009,630.46666441500008,543.38666472600005,0]
[70,null,{"$f":"C24*$L$4","v":0},843.35999698800003,765.70666393200008,695.79999751500009,599.66666452499999,0]
[71,null,{"$f":"C25*$L$4","v":0},936.13332998999999,849.98666363100006,772.23999724200007,665.65333095599999,0]
[72,null,{"$f":"C26*$L$4","v":0},1035.533329635,940.14666330900002,854.27999694900006,736.30666403700002,0]
[73,null,{"$f":"C27*$L$4","v":0},1148.8399958970001,1043.093329608,947.79999661500005,816.85333041600006,0]
[74,null,{"$f":"C28*$L$4","v":0},1280.3466620940001,1162.559995848,1056.2533295610001,910.46666341500008,0]
[75,"o más",{"$f":"C29*$L$4","v":0},1434.53332821,1302.4666620150001,1183.4666624400002,1020.0399963570001,0]
[1,"Hijo",{"$f":"C30*$L$4","v":0},47.786666496000002,43.399999845000004,39.386666525999999,33.973333212,0]
[2,"Hijos",{"$f":"C31*$L$4","v":0},73.73333307,66.919999761,60.853333116000002,52.453333146000006,0]
[3,"Hijos o más",{"$f":"C32*$L$4","v":0},107.053332951,97.253332986000004,88.386666351000002,76.159999728000003,0]
[1,"Rider Comp. Maternidad",{"$f":"C33*$L$4","v":0},0,0,20.999999925000001,20.999999925000001,0]
[1,"Transplante de organos",{"$f":"C34*$L$4","v":0},0,0,0,0,0]
[]
[]
["UNIQUE CARE"]
["TARIFAS MENSUALES"]
["EDAD"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,{"$f":"C274*$L$4","v":0},{"$f":"D274*$L$4","v":226.05333252600002},175.74666603900002,136.82666617800001,121.23999956700001,98.373332982000008]
[19,null,{"$f":"C275*$L$4","v":0},230.15999917800002,178.639999362,139.81333283399999,123.759999558,99.959999643000003]
[20,null,{"$f":"C276*$L$4","v":0},234.07999916400001,181.62666601800001,142.33333282500001,126.093332883,101.639999637]
[21,null,{"$f":"C277*$L$4","v":0},238.37333248200002,184.706666007,145.319999481,128.23999954199999,103.78666629600001]
[22,null,{"$f":"C278*$L$4","v":0},242.6666658,187.59999933,148.30666613700001,130.573332867,105.746666289]
[23,null,{"$f":"C279*$L$4","v":0},246.86666578500001,190.58666598600001,151.573332792,132.81333285900001,107.61333294900001]
[24,null,{"$f":"C280*$L$4","v":0},251.25333243600002,193.573332642,154.186666116,135.42666618300001,109.29333294300001]
[25,null,{"$f":"C281*$L$4","v":0},255.546665754,196.74666596400002,157.17333277200001,137.66666617500002,111.533332935]
[26,null,{"$f":"C282*$L$4","v":0},259.74666573900004,199.73333262,160.15999942800002,139.9999995,113.30666626200001]
[27,null,{"$f":"C283*$L$4","v":0},264.226665723,202.90666594200002,163.053332751,142.23999949200001,115.07999958900001]
[28,null,{"$f":"C284*$L$4","v":0},269.07999903900003,206.26666593000002,167.06666607,145.22666614800002,117.78666624600001]
[29,null,{"$f":"C285*$L$4","v":0},274.30666568700002,209.62666591800001,170.426666058,148.213332804,119.559999573]
[30,null,{"$f":"C286*$L$4","v":0},279.159999003,213.266665905,174.34666604400002,151.10666612700001,122.079999564]
[31,null,{"$f":"C287*$L$4","v":0},284.38666565099999,216.719999226,177.79999936500002,153.90666611700001,124.50666622200001]
[32,null,{"$f":"C288*$L$4","v":0},289.14666563399999,220.26666588000001,181.71999935100001,156.70666610700002,126.65333288100001]
[33,null,{"$f":"C289*$L$4","v":0},297.35999893799999,226.239999192,186.946665999,161.18666609100001,130.479999534]
[34,null,{"$f":"C290*$L$4","v":0},305.47999890900002,232.11999917100002,192.82666597800002,165.759999408,133.933332855]
[35,null,{"$f":"C291*$L$4","v":0},313.59999887999999,238.09333248300001,198.333332625,170.23999939200002,137.66666617500002]
[36,null,{"$f":"C292*$L$4","v":0},321.71999885100001,244.06666579500001,203.839999272,174.719999376,141.399999495]
[37,null,{"$f":"C293*$L$4","v":0},330.02666548799999,249.94666577400002,209.15999925300002,179.19999936000002,144.94666614900001]
[38,null,{"$f":"C294*$L$4","v":0},338.23999879199999,256.01333241899999,215.22666589800002,183.86666601000002,148.67999946899999]
[39,null,{"$f":"C295*$L$4","v":0},346.82666542800001,261.98666573100002,220.919999211,188.53333266000001,152.50666612200001]
[40,null,{"$f":"C296*$L$4","v":0},355.03999873200002,268.333332375,226.986665856,193.47999930900002,156.14666610899999]
[41,null,{"$f":"C297*$L$4","v":0},363.533332035,274.30666568700002,232.77333250200002,198.14666595900002,159.786666096]
[42,null,{"$f":"C298*$L$4","v":0},371.83999867200004,280.27999899899999,238.74666581400001,202.62666594300001,163.89333274800001]
[43,null,{"$f":"C299*$L$4","v":0},387.05333195100002,291.10666562700004,248.639999112,210.93333258000001,170.33333272500002]
[44,null,{"$f":"C300*$L$4","v":0},402.17333189700003,302.21333225400002,259.09333240800004,219.33333255000002,177.14666603400002]
[45,null,{"$f":"C301*$L$4","v":0},417.29333184300003,313.03999888200002,269.54666570400002,228.01333251900002,183.58666601100001]
[46,null,{"$f":"C302*$L$4","v":0},432.59999845500005,324.23999884200003,279.90666566700003,236.31999915600002,190.58666598600001]
[47,null,{"$f":"C303*$L$4","v":0},447.62666506800002,335.15999880300001,290.35999896300001,244.81333245900001,197.026665963]
[48,null,{"$f":"C304*$L$4","v":0},463.67999834400001,346.91999876100004,300.90666559200002,253.77333242700001,204.39999927000002]
[49,null,{"$f":"C305*$L$4","v":0},479.82666495300003,358.67999871900003,311.54666555400001,262.63999906200002,211.58666591100001]
[50,null,{"$f":"C306*$L$4","v":0},495.78666489600005,370.15999867800002,322.653332181,271.59999902999999,218.866665885]
[51,null,{"$f":"C307*$L$4","v":0},511.83999817200004,381.82666530300003,333.10666547700004,280.27999899899999,225.77333252700001]
[52,null,{"$f":"C308*$L$4","v":0},527.89333144800003,393.58666526100001,344.02666543800001,289.14666563399999,233.053332501]
[53,null,{"$f":"C309*$L$4","v":0},547.02666471300006,407.11999854600003,357.279998724,299.59999893000003,241.45333247100001]
[54,null,{"$f":"C310*$L$4","v":0},565.69333131300004,420.93333183000004,370.71999867600005,310.61333222400003,249.94666577400002]
[55,null,{"$f":"C311*$L$4","v":0},584.63999791200001,434.83999844700003,383.50666529700004,321.15999885299999,258.34666574400001]
[56,null,{"$f":"C312*$L$4","v":0},603.49333117800006,448.559998398,396.75999858300003,331.70666548200001,267.026665713]
[57,null,{"$f":"C313*$L$4","v":0},622.71999777600001,462.18666501600001,410.01333186900001,342.43999877700003,275.239999017]
[58,null,{"$f":"C314*$L$4","v":0},645.95999769299999,478.239998292,425.97333181200003,355.59999873000004,285.97333231200003]
[59,null,{"$f":"C315*$L$4","v":0},669.10666427700005,494.10666490200003,441.74666508900003,368.75999868299999,296.42666560800001]
[60,null,{"$f":"C316*$L$4","v":0},692.34666419400003,509.78666484600001,457.79999836500002,381.919998636,307.06666557]
[61,null,{"$f":"C317*$L$4","v":0},717.82666410299998,528.45333144599999,476.83999829700002,396.199998585,318.45333219600002]
[62,null,{"$f":"C318*$L$4","v":0},749.83999732200004,551.87999802900003,499.61333154900001,413.55999852300005,332.359998813]
[63,null,{"$f":"C319*$L$4","v":0},787.73333051999998,579.693331263,524.62666479300003,434.65333178100002,348.87999875400004]
[64,null,{"$f":"C320*$L$4","v":0},832.34666369400009,612.26666448000003,554.58666468600006,459.19999836,368.946665349]
[65,null,{"$f":"C321*$L$4","v":0},889.55999682300001,652.866664335,596.02666453799998,491.95999824300003,394.98666525600004]
[66,null,{"$f":"C322*$L$4","v":0},956.01332991900006,699.90666416700003,643.90666436700008,529.66666477500007,424.759998483]
[67,null,{"$f":"C323*$L$4","v":0},1032.079996314,755.43999730200005,694.95999751800002,572.03999795700008,458.17333169700004]
[68,null,{"$f":"C324*$L$4","v":0},1119.1599960030001,818.43999707700004,753.19999731000007,619.35999778799999,497.09333155800005]
[69,null,{"$f":"C325*$L$4","v":0},1221.73332897,893.57333014200003,822.07999706400005,676.853330916,542.26666473]
[70,null,{"$f":"C326*$L$4","v":0},1346.3333285250001,979.25332983600003,907.19999676000009,748.15999732800003,599.47999785900004]
[71,null,{"$f":"C327*$L$4","v":0},1482.039994707,1078.279996149,1006.9733297370001,823.573330392,659.58666431100005]
[72,null,{"$f":"C328*$L$4","v":0},1639.306660812,1192.3333290750002,1113.9333293550001,910.93333008000002,730.05333072600001]
[73,null,{"$f":"C329*$L$4","v":0},1819.06666017,1323.46666194,1235.826662253,1010.706663057,809.75999710799999]
[74,null,{"$f":"C330*$L$4","v":0},2028.0399927570002,1475.039994732,1377.3199950810001,1126.7199959760001,902.43999677700003]
[75,null,{"$f":"C331*$L$4","v":0},2272.0133252190003,1648.6399941120001,1543.1733278220001,1263.73332882,1012.293329718]
[76,null,{"$f":"C332*$L$4","v":0},2547.813324234,1848.746660064,1736.373327132,1417.359994938,1134.839995947]
[77,null,{"$f":"C333*$L$4","v":0},2861.5066564470003,2076.2933259179999,1951.506659697,1591.5199943160001,1274.8399954470001]
[78,null,{"$f":"C334*$L$4","v":0},3215.053321851,2332.866658335,2192.6799921689999,1788.4533269460001,1432.3866615510001]
[79,null,{"$f":"C335*$L$4","v":0},3612.2799870990002,2621.0799906390002,2463.6266578680002,2009.3733261570001,1609.5333275850001]
[80,"o mas",{"$f":"C336*$L$4","v":0},4087.5333187350002,2965.8533227410003,2787.6799900440001,2273.5999918800003,1821.2133268290002]
[1,"Hijo",{"$f":"C337*$L$4","v":0},106.679999619,87.453333021000006,51.426666483000005,50.399999820000005,40.413333188999999]
[2,"Hijos",{"$f":"C338*$L$4","v":0},174.99999937500002,147.18666614100002,79.333333050000007,76.626666393000008,63.839999772000006]
[3,"Hijos o más",{"$f":"C339*$L$4","v":0},256.01333241899999,216.159999228,115.173332922,110.13333294,92.586666336000008]
[1,"Rider Comp. Maternidad",{"$f":"C340*$L$4","v":0},0,0,0,20.999999925000001,20.999999925000001]
[1,"Transplante de organos",{"$f":"C341*$L$4","v":0},27.999999900000002,27.999999900000002,27.999999900000002,27.999999900000002,27.999999900000002]
[null,"Deductible Waiver",{"$f":"C342*$L$4","v":0},4.1999999849999998,16.799999939999999,32.199999885000004,72.333333074999999,124.13333289000001]
[]
["UNIQUE CARE - DEDUCIBLE CERO"]
["TARIFAS MENSUALES"]
["EDAD"]
[" "," ",null,"ET2","ET3","ET4","ET5"]
[18,null,{"$f":"C633*$L$4","v":0},{"$f":"D633*$L$4","v":244.15999912800001},214.85333256600001,192.26666598,169.67999939400002,0]
[19,null,{"$f":"C634*$L$4","v":0},248.45333244600002,218.58666588600002,195.53333263500002,172.75999938300001,0]
[20,null,{"$f":"C635*$L$4","v":0},252.746665764,222.41333253900001,198.986665956,175.65333270600001,0]
[21,null,{"$f":"C636*$L$4","v":0},257.41333241400002,226.51999919100001,202.71999927600001,178.91999936100001,0]
[22,null,{"$f":"C637*$L$4","v":0},262.07999906399999,230.53333251000001,206.35999926300002,182.093332683,0]
[23,null,{"$f":"C638*$L$4","v":0},266.83999904699999,234.63999916200001,209.71999925100002,185.26666600500002,0]
[24,null,{"$f":"C639*$L$4","v":0},271.41333236400004,238.559999148,213.54666590400001,188.43999932700001,0]
[25,null,{"$f":"C640*$L$4","v":0},275.98666568100003,242.6666658,217.09333255800001,191.519999316,0]
[26,null,{"$f":"C641*$L$4","v":0},280.55999899800003,246.77333245200001,220.919999211,194.973332637,0]
[27,null,{"$f":"C642*$L$4","v":0},285.31999898100003,251.15999910300002,224.65333253100002,198.333332625,0]
[28,null,{"$f":"C643*$L$4","v":0},290.63999896199999,255.63999908700001,228.66666585000002,201.693332613,0]
[29,null,{"$f":"C644*$L$4","v":0},296.14666560900002,260.49333240300001,233.146665834,205.799999265,0]
[30,null,{"$f":"C645*$L$4","v":0},301.37333225700002,265.15999905300004,237.34666581900001,209.346665919,0]
[31,null,{"$f":"C646*$L$4","v":0},307.06666557,270.10666570199999,241.63999913700002,213.266665905,0]
[32,null,{"$f":"C647*$L$4","v":0},312.29333221799999,274.77333235200001,245.83999912200002,216.90666589200001,0]
[33,null,{"$f":"C648*$L$4","v":0},321.15999885299999,282.51999899100002,252.746665764,223.06666587000001,0]
[34,null,{"$f":"C649*$L$4","v":0},330.02666548799999,290.35999896300001,259.653332406,229.039999182,0]
[35,null,{"$f":"C650*$L$4","v":0},338.79999879000002,297.91999893600001,266.55999904800001,235.106665827,0]
[36,null,{"$f":"C651*$L$4","v":0},347.38666542600004,305.57333224199999,273.46666569000001,241.45333247100001,0]
[37,null,{"$f":"C652*$L$4","v":0},356.34666539400001,313.50666554700001,280.55999899800003,247.61333244900001,0]
[38,null,{"$f":"C653*$L$4","v":0},365.30666536199999,321.346665519,287.55999897300001,253.77333242700001,0]
[39,null,{"$f":"C654*$L$4","v":0},374.54666532900001,329.46666549000003,294.83999894700003,260.21333240400003,0]
[40,null,{"$f":"C655*$L$4","v":0},383.41333196400001,337.49333212800002,301.83999892200001,266.373332382,0]
[41,null,{"$f":"C656*$L$4","v":0},392.65333193100003,345.42666543300004,309.02666556299999,272.71999902600004,0]
[42,null,{"$f":"C657*$L$4","v":0},401.613331899,353.359998738,316.30666553700001,278.97333233699999,0]
[43,null,{"$f":"C658*$L$4","v":0},417.94666517400003,367.73333202000003,328.99999882500003,290.45333229600004,0]
[44,null,{"$f":"C659*$L$4","v":0},434.279998449,382.10666530200001,341.97333211200004,301.74666558900003,0]
[45,null,{"$f":"C660*$L$4","v":0},450.61333172400003,396.57333191700002,354.75999873300003,313.03999888200002,0]
[46,null,{"$f":"C661*$L$4","v":0},467.22666499800005,411.03999853200003,367.82666535300001,324.51999884100002,0]
[47,null,{"$f":"C662*$L$4","v":0},483.37333160700001,425.226665148,380.51999864100003,335.90666546700004,0]
[48,null,{"$f":"C663*$L$4","v":0},500.733331545,440.43999842700003,393.95999859300002,347.85333209100003,0]
[49,null,{"$f":"C664*$L$4","v":0},518.18666481600008,455.83999837200003,407.86666521000001,359.98666538100002,0]
[50,null,{"$f":"C665*$L$4","v":0},535.45333142100003,471.05333165100001,421.39999849500003,371.83999867200004,0]
[51,null,{"$f":"C666*$L$4","v":0},552.62666469300007,486.26666493000005,435.02666511300004,383.879998629,0]
[52,null,{"$f":"C667*$L$4","v":0},569.98666463100005,501.386664876,448.65333173100004,395.82666525300004,0]
[53,null,{"$f":"C668*$L$4","v":0},590.70666455700007,519.58666481099999,464.89333167300003,410.19999853500002,0]
[54,null,{"$f":"C669*$L$4","v":0},610.95999781800003,537.59999807999998,480.85333161600005,424.38666515100005,0]
[55,null,{"$f":"C670*$L$4","v":0},631.39999774500006,555.42666468300001,496.90666489200004,438.38666510100001,0]
[56,null,{"$f":"C671*$L$4","v":0},651.83999767199998,573.34666461900008,513.14666483400003,452.75999838300004,0]
[57,null,{"$f":"C672*$L$4","v":0},672.559997598,591.45333122099998,529.38666477599998,467.13333166500001,0]
[58,null,{"$f":"C673*$L$4","v":0},697.57333084200002,613.75999780799998,549.17333137200001,484.67999826900001,0]
[59,null,{"$f":"C674*$L$4","v":0},722.58666408600004,635.69333106300007,568.67999796900006,501.66666487500004,0]
[60,null,{"$f":"C675*$L$4","v":0},747.78666399600002,657.62666431800005,588.46666456499997,519.21333147899998,0]
[61,null,{"$f":"C676*$L$4","v":0},775.22666389800008,681.89333089800004,610.213331154,538.34666474400001,0]
[62,null,{"$f":"C677*$L$4","v":0},809.94666377400006,712.41333078900004,637.46666439000001,562.33333132500002,0]
[63,null,{"$f":"C678*$L$4","v":0},850.82666362800001,748.34666399399998,669.57333094199998,590.89333122300002,0]
[64,null,{"$f":"C679*$L$4","v":0},898.79999679000002,790.81333050900002,707.55999747300007,624.30666443699999,0]
[65,null,{"$f":"C680*$L$4","v":0},960.86666323500003,845.31999698100003,756.18666396600008,667.33333095,0]
[66,null,{"$f":"C681*$L$4","v":0},1032.5466629790001,908.31999675600002,812.55999709800005,716.98666410600003,0]
[67,null,{"$f":"C682*$L$4","v":0},1114.773329352,980.55999649800003,877.33333020000009,774.10666390200004,0]
[68,null,{"$f":"C683*$L$4","v":0},1208.5733290170001,1063.159996203,951.253329936,839.43999700200004,0]
[69,null,{"$f":"C684*$L$4","v":0},1319.4533286210001,1160.693329188,1038.5199962910001,916.34666339400007,0]
[70,null,{"$f":"C685*$L$4","v":0},1454.13332814,1279.0399954320001,1144.4533292460001,1009.9599963930001,0]
[71,null,{"$f":"C686*$L$4","v":0},1600.5733276170001,1407.933328305,1259.7199955010001,1111.5999960300001,0]
[72,null,{"$f":"C687*$L$4","v":0},1770.4399936770001,1557.3599944380001,1393.4666616900001,1229.4799956090001,0]
[73,null,{"$f":"C688*$L$4","v":0},1964.573326317,1728.1599938280001,1546.253327811,1364.439995127,0]
[74,null,{"$f":"C689*$L$4","v":0},2190.3466588440001,1926.5866597860002,1723.86666051,1520.9599945680002,0]
[75,null,{"$f":"C690*$L$4","v":0},2453.6399912370002,2158.4266589580002,1931.2533264360002,1704.0799939140002,0]
[76,null,{"$f":"C691*$L$4","v":0},2751.6533235060001,2420.506658022,2165.7066589320002,1910.9999931750001,0]
[77,null,{"$f":"C692*$L$4","v":0},3090.2666556300001,2718.333323625,2432.2666579800002,2146.106659002,0]
[78,null,{"$f":"C693*$L$4","v":0},3472.186654266,3054.2399890920001,2732.7999902400002,2411.3599913880003,0]
[79,null,{"$f":"C694*$L$4","v":0},3901.3333194000002,3431.6799877440003,3070.479989034,2709.3733236570001,0]
[80,"o mas",{"$f":"C695*$L$4","v":0},4414.4799842339999,3883.226652798,3474.4266542580003,3065.7199890510001,0]
[1,"Hijo",{"$f":"C696*$L$4","v":0},115.07999958900001,101.35999963800001,90.719999676,79.986666381000006,0]
[2,"Hijos",{"$f":"C697*$L$4","v":0},188.999999325,166.22666607300002,148.773332802,131.226666198,0]
[3,"Hijos o más",{"$f":"C698*$L$4","v":0},276.546665679,243.226665798,217.74666588900001,192.07999931400002,0]
[1,"Rider Comp. Maternidad",{"$f":"C699*$L$4","v":0},0,0,0,20.999999925000001,0]
[1,"Transplante de organos",{"$f":"C700*$L$4","v":0},27.999999900000002,27.999999900000002,27.999999900000002,27.999999900000002,0]
[]
[]
["ELITE CARE"]
["TARIFAS MENSUAL"]
["EDAD"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,{"$f":"C487*$L$4","v":0},{"$f":"D487*$L$4","v":478.61333162400001},306.50666557200003,242.75999913300001,200.479999284,145.506666147]
[19,null,{"$f":"C488*$L$4","v":0},488.03999825700004,312.29333221799999,247.61333244900001,204.21333260400002,148.213332804]
[20,null,{"$f":"C489*$L$4","v":0},497.83999822200002,317.98666553100003,252.46666576500002,208.13333259000001,150.919999461]
[21,null,{"$f":"C490*$L$4","v":0},507.45333152100005,324.05333217600003,257.03999908200001,211.959999243,153.99999945000002]
[22,null,{"$f":"C491*$L$4","v":0},517.81333148400006,330.213332154,261.89333239799998,216.159999228,156.79999943999999]
[23,null,{"$f":"C492*$L$4","v":0},527.42666478299998,335.99999880000001,266.93333238000002,219.89333254800002,159.59999943]
[24,null,{"$f":"C493*$L$4","v":0},537.59999807999998,342.15999877799999,271.69333236300002,223.81333253400001,162.493332753]
[25,null,{"$f":"C494*$L$4","v":0},547.30666471200004,348.03999875700003,276.63999901200003,228.01333251900002,165.57333274200002]
[26,null,{"$f":"C495*$L$4","v":0},557.38666467600001,354.013332069,281.77333232699999,231.83999917200001,168.559999398]
[27,null,{"$f":"C496*$L$4","v":0},567.37333130700006,360.079998714,286.62666564300002,235.853332491,171.173332722]
[28,null,{"$f":"C497*$L$4","v":0},579.59999792999997,367.26666535500004,292.59999895499999,241.07999913900002,175.46666604000001]
[29,null,{"$f":"C498*$L$4","v":0},592.10666455199998,374.359998663,298.57333226700001,246.39999912000002,179.57333269200001]
[30,null,{"$f":"C499*$L$4","v":0},604.51999784100008,381.45333197100001,303.799998915,251.90666576700002,183.95999934300002]
[31,null,{"$f":"C500*$L$4","v":0},616.83999779700002,388.45333194599999,309.67999889399999,257.13333241499998,188.34666599400001]
[32,null,{"$f":"C501*$L$4","v":0},629.15999775300008,395.63999858700004,315.55999887300004,262.63999906200002,192.26666598]
[33,null,{"$f":"C502*$L$4","v":0},646.79999769000005,405.06666522,323.306665512,269.173332372,198.23999929200002]
[34,null,{"$f":"C503*$L$4","v":0},664.71999762600001,414.77333185200001,331.14666548400004,275.61333234900002,204.11999927100001]
[35,null,{"$f":"C504*$L$4","v":0},682.26666423000006,424.10666515200001,339.079998789,281.959998993,209.906665917]
[36,null,{"$f":"C505*$L$4","v":0},699.99999750000006,433.439998452,346.82666542800001,288.39999897000001,215.59999923000001]
[37,null,{"$f":"C506*$L$4","v":0},717.546664104,442.959998418,354.6666654,294.74666561399999,221.38666587600002]
[38,null,{"$f":"C507*$L$4","v":0},741.34666401900006,458.45333169600002,367.639998687,303.799998915,228.57333251700001]
[39,null,{"$f":"C508*$L$4","v":0},764.95999726800005,473.85333164100001,380.23999864200005,313.319998881,235.853332491]
[40,null,{"$f":"C509*$L$4","v":0},788.759997183,489.34666491900003,393.21333192899999,322.37333218200001,243.226665798]
[41,null,{"$f":"C510*$L$4","v":0},812.27999709900007,504.93333153000003,406.09333188300002,331.70666548200001,250.13333244]
[42,null,{"$f":"C511*$L$4","v":0},836.17333034700005,520.23999814199999,418.59999850500003,340.85333211599999,257.59999908000003]
[43,null,{"$f":"C512*$L$4","v":0},865.94666357400001,538.34666474400001,433.06666512000004,351.02666541299999,265.62666571800003]
[44,null,{"$f":"C513*$L$4","v":0},895.34666346900008,556.26666468000008,447.719998401,361.386665376,273.83999902200003]
[45,null,{"$f":"C514*$L$4","v":0},925.30666336199999,574.27999794900006,462.18666501600001,371.18666534100004,282.05333232600003]
[46,null,{"$f":"C515*$L$4","v":0},954.79999659000009,592.19999788500002,476.74666496400005,381.45333197100001,289.98666563099999]
[47,null,{"$f":"C516*$L$4","v":0},984.47999648400003,610.11999782100008,490.93333158000002,391.34666526900003,298.66666559999999]
[48,null,{"$f":"C517*$L$4","v":0},1021.3466630190001,630.93333108000002,508.85333151600003,404.879998554,309.11999889600003]
[49,null,{"$f":"C518*$L$4","v":0},1057.933329555,651.93333100500001,526.39999812000008,418.59999850500003,319.75999885800002]
[50,null,{"$f":"C519*$L$4","v":0},1094.8933294230001,672.93333093000001,543.85333139099998,432.13333179,330.30666548700003]
[51,null,{"$f":"C520*$L$4","v":0},1131.8533292910001,694.11999752100007,561.306664662,446.03999840700004,340.85333211599999]
[52,null,{"$f":"C521*$L$4","v":0},1168.3466624940002,714.65333078100002,579.13333126500004,459.47999835900004,351.49333207800004]
[53,null,{"$f":"C522*$L$4","v":0},1213.146662334,742.74666401400009,599.94666452400008,476.18666496600002,364.93333203000003]
[54,null,{"$f":"C523*$L$4","v":0},1257.8533288410001,771.11999724600003,620.85333111600005,492.519998241,377.99999865000001]
[55,null,{"$f":"C524*$L$4","v":0},1302.279995349,799.39999714500004,641.94666437400008,509.41333151400005,391.253331936]
[56,null,{"$f":"C525*$L$4","v":0},1347.0799951890001,827.58666371100003,663.039997632,525.93333145500003,404.59999855500001]
[57,null,{"$f":"C526*$L$4","v":0},1391.506661697,855.6799969440001,683.85333089100004,542.73333139500005,417.94666517400003]
[58,null,{"$f":"C527*$L$4","v":0},1445.6399948370001,893.29333014300005,711.10666412700004,564.47999798400008,435.02666511300004]
[59,null,{"$f":"C528*$L$4","v":0},1500.053327976,930.81333000900008,738.07999736400006,586.87999790399999,452.57333171700003]
[60,null,{"$f":"C529*$L$4","v":0},1554.279994449,968.42666320800004,765.05333060100008,608.53333115999999,469.93333165500002]
[61,null,{"$f":"C530*$L$4","v":0},1618.5866608860001,1015.0933297080001,800.98666380600002,636.62666439300006,492.14666490900004]
[62,null,{"$f":"C531*$L$4","v":0},1694.1866606160002,1071.5599961729999,846.25333031100001,671.34666426900003,525.27999812400003]
[63,null,{"$f":"C532*$L$4","v":0},1782.5733269670002,1140.1599959279999,902.81333010900005,713.71999745100004,564.38666465100005]
[64,null,{"$f":"C533*$L$4","v":0},1884.0266599380002,1220.706662307,970.5733298670001,765.98666393100007,610.39999782000007]
[65,null,{"$f":"C534*$L$4","v":0},2000.6933261880001,1313.9466619740001,1050.2799962490001,829.73333037000009,663.69333096299999]
[66,null,{"$f":"C535*$L$4","v":0},2134.8133257090003,1420.719994926,1143.239995917,906.35999676300003,728.55999739800006]
[67,null,{"$f":"C536*$L$4","v":0},2288.2533251610002,1543.079994489,1250.386662201,996.79999644000009,805.74666378900008]
[68,null,{"$f":"C537*$L$4","v":0},2468.479991184,1688.0266606380001,1375.359995088,1103.013329394,896.18666346600003]
[69,null,{"$f":"C538*$L$4","v":0},2676.4266571080002,1858.3599933630001,1520.4933279030001,1227.239995617,1001.933329755]
[70,null,{"$f":"C539*$L$4","v":0},2914.519989591,2054.0799926640002,1688.4933273030001,1371.719995101,1125.4133293140001]
[71,null,{"$f":"C540*$L$4","v":0},3185.839988622,2277.1466585339999,1880.6666599500002,1538.0399945070001,1267.933328805]
[72,null,{"$f":"C541*$L$4","v":0},3494.0266541880001,2529.9866576310001,2099.719992501,1728.0666604950002,1431.453328221]
[73,null,{"$f":"C542*$L$4","v":0},3838.9866529560004,2814.0933232830002,2347.1466582840003,1943.0133263940002,1618.3999942200001]
[74,null,{"$f":"C543*$L$4","v":0},4229.3999848949998,3135.253322136,2626.9599906180001,2184.4666588650002,1831.013326794]
[75,null,{"$f":"C544*$L$4","v":0},4668.1599833280006,3494.3066541870003,2942.6133228240001,2456.6266578929999,2070.5999926049999]
[76,null,{"$f":"C545*$L$4","v":0},5170.1066482020005,3910.386652701,3297.933321555,2763.1333234650001,2338.8399916470003]
[77,null,{"$f":"C546*$L$4","v":0},5772.6666460500001,4391.0533176509998,3707.2933200930001,3115.6533222060002,2643.9466572240003]
[78,null,{"$f":"C547*$L$4","v":0},6500.1999767850002,4965.3333155999999,4174.3333184250005,3521.5599874230002,2994.319989306]
[79,null,{"$f":"C548*$L$4","v":0},7378.6533069810002,5647.9733131620005,4718.466649815,3985.6133190990004,3396.3066545370002]
[80,"o mas",{"$f":"C549*$L$4","v":0},8432.7599698829999,6454.7466436140003,5366.7599808330006,4538.9866504560005,3872.866652835]
[1,"Hijo",{"$f":"C550*$L$4","v":0},203.46666594000001,141.49333282800001,103.226666298,84.83999969700001,74.386666400999999]
[2,"Hijos",{"$f":"C551*$L$4","v":0},313.03999888200002,229.97333251200001,163.146666084,134.586666186,117.879999579]
[3,"Hijos o más",{"$f":"C552*$L$4","v":0},457.05333170100005,336.18666546600002,237.62666581800002,195.81333263400001,170.519999391]
[1,"Rider Comp. Maternidad",{"$f":"C553*$L$4","v":0},0,0,0,20.999999925000001,20.999999925000001]
[1,"Transplante de organos",{"$f":"C554*$L$4","v":0},27.999999900000002,27.999999900000002,27.999999900000002,27.999999900000002,27.999999900000002]
[null,"Deductible Waiver",{"$f":"C555*$L$4","v":0},4.1999999849999998,16.799999939999999,32.199999885000004,72.333333074999999,124.13333289000001]