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

{"sheet":"INGRESO DE DATOS","index":0,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[15,7,15,8],[11,3,11,9],[13,3,13,5],[13,7,13,8],[22,3,22,9]]}
[]
[]
[]
[]
[" "]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
["1. INGRESE LOS DATOS DEL PROPUESTO ASEGURADO:"]
[]
[null,null,"Nombre del Asegurado Principal:","Nombre"]
[null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,"Número de Adultos:",null,null,2,"Número de Hijos:",null,3]
[]
[null,null,null,null,null," Edad de Titular:",65,"Edad de Cónyuge:",null,18]
[]
[null,null,null,null,null,"Descuento:",0]
[]
[]
["2. INGRESE EL NOMBRE DE LA AGENCIA ASESORA:"]
[]
[null,null,"Intermediario:","Agente / Agencia"]
[]
[]
[]
["3. ESCOJA EL PRODUCTO PARA VISUALIZAR LA COTIZACION RESPECTIVA:"]

{"sheet":"Complete","index":1,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[[64,3,66,9],[51,3,51,9],[72,0,72,1],[73,0,73,1],[71,0,71,1],[63,3,63,9],[55,0,55,1],[7,3,7,9],[8,3,8,9],[9,0,9,1],[40,0,40,1],[35,0,35,1],[30,0,30,1],[28,3,28,9],[39,3,39,9],[11,4,11,9],[13,4,13,9],[15,0,15,1],[21,0,21,1],[23,3,23,9]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Cotización de Seguro Médico Internacional"]
[null,null,null,"Producto: Bupa Complete Care"]
["BUPA COMPLETE CARE"]
[]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$23","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G18>0,'INGRESO DE DATOS'!G18,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!G14","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":65}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,"Complicaciones de Maternidad (+ $500,000)"]
[null,null,null,null,null,null,null,false]
[null,null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$6:$H$29,4,TRUE)","v":42627},{"$f":"VLOOKUP($J$18,Tablas!$A$6:$H$29,5,TRUE)","v":30133},{"$f":"VLOOKUP($J$18,Tablas!$A$6:$H$29,6,TRUE)","v":22612},{"$f":"VLOOKUP($J$18,Tablas!$A$6:$H$29,7,TRUE)","v":20003},{"$f":"VLOOKUP($J$18,Tablas!$A$6:$H$29,8,TRUE)","v":17004}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$6:$H$29,4,TRUE)))","v":10023},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$6:$H$29,5,TRUE)))","v":6865},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$6:$H$29,6,TRUE)))","v":4819},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$6:$H$29,7,TRUE)))","v":3326},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$6:$H$29,8,TRUE)))","v":2542}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$30:$H$32,4,TRUE)))","v":8099},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$30:$H$32,5,TRUE)))","v":5905},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$30:$H$32,6,TRUE)))","v":4553},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$30:$H$32,7,TRUE)))","v":3714},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$30:$H$32,8,TRUE)))","v":2741}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($H$23=FALSE,0,Tablas!D$33)","v":0},{"$f":"+IF($H$23=FALSE,0,Tablas!E$33)","v":0},{"$f":"+IF($H$23=FALSE,0,Tablas!F$33)","v":0},{"$f":"+IF($H$23=FALSE,0,Tablas!G$33)","v":0},{"$f":"+IF($H$23=FALSE,0,Tablas!H$33)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F30:F33)","v":60749},{"$f":"SUM(G30:G33)","v":42903},{"$f":"SUM(H30:H33)","v":31984},{"$f":"SUM(I30:I33)","v":27043},{"$f":"SUM(J30:J33)","v":22287}]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F30+F31+F32)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G30+G31+G32)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H30+H31+H32)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I30+I31+I32)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J30+J31+J32)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F34+F35+F36)*12%","v":7298.88},{"$f":"+(G34+G35+G36)*12%","v":5157.3599999999997},3847.08,3254.16,{"$f":"+(J34+J35+J36)*12%","v":2683.44}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F34:F37)","v":68122.880000000005},{"$f":"SUM(G34:G37)","v":48135.360000000001},35906.080000000002,30372.16,{"$f":"SUM(J34:J37)","v":25045.439999999999}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$39:$H$62,4,TRUE)","v":22592.31},{"$f":"VLOOKUP($J$18,Tablas!$A$39:$H$62,5,TRUE)","v":15970.490000000002},{"$f":"VLOOKUP($J$18,Tablas!$A$39:$H$62,6,TRUE)","v":11984.36},{"$f":"VLOOKUP($J$18,Tablas!$A$39:$H$62,7,TRUE)","v":10601.59},{"$f":"VLOOKUP($J$18,Tablas!$A$39:$H$62,8,TRUE)","v":9012.1200000000008}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$39:$H$62,4,TRUE)))","v":5312.1900000000005},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$39:$H$62,5,TRUE)))","v":3638.4500000000003},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$39:$H$62,6,TRUE)))","v":2554.0700000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$39:$H$62,7,TRUE)))","v":1762.7800000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$39:$H$62,8,TRUE)))","v":1347.26}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,4,TRUE)))","v":4292.47},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,5,TRUE)))","v":3129.65},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,6,TRUE)))","v":2413.09},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,7,TRUE)))","v":1968.42},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,8,TRUE)))","v":1452.73}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$66)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$66)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$66)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$66)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$66)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F41:F44)","v":32196.97},{"$f":"SUM(G41:G44)","v":22738.590000000004},{"$f":"SUM(H41:H44)","v":16951.52},{"$f":"SUM(I41:I44)","v":14332.79},{"$f":"SUM(J41:J44)","v":11812.11}]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F41+F42+F43)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G41+G42+G43)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H41+H42+H43)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I41+I42+I43)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J41+J42+J43)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F45+F46+F47)*12%","v":3872.6363999999999},{"$f":"+(G45+G46+G47)*12%","v":2737.6308000000004},2043.1823999999999,1728.9348,{"$f":"+(J45+J46+J47)*12%","v":1426.4531999999999}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F45:F48)","v":36144.606400000004},{"$f":"SUM(G45:G48)","v":25551.220800000003},{"$f":"SUM(H45:H48)","v":19069.702400000002},{"$f":"SUM(I45:I48)","v":16136.7248},{"$f":"SUM(J45:J48)","v":13313.563200000001}]
[null,null,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F45+F46+F48-(F47*0.12)","v":36060.606400000004},{"$f":"G45+G46+G48-(G47*0.12)","v":25467.220800000003},18985.702400000002,16052.7248,{"$f":"J45+J46+J48-(J47*0.12)","v":13229.563200000001}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$923:$H$946,4,TRUE)","v":11722.425000000001},{"$f":"VLOOKUP($J$18,Tablas!$A$923:$H$946,5,TRUE)","v":8286.5750000000007},{"$f":"VLOOKUP($J$18,Tablas!$A$923:$H$946,6,TRUE)","v":6218.3},{"$f":"VLOOKUP($J$18,Tablas!$A$923:$H$946,7,TRUE)","v":5500.8250000000007},{"$f":"VLOOKUP($J$18,Tablas!$A$923:$H$946,8,TRUE)","v":4676.1000000000004}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$923:$H$946,4,TRUE)))","v":2756.3250000000003},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$923:$H$946,5,TRUE)))","v":1887.8750000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$923:$H$946,6,TRUE)))","v":1325.2250000000001},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$923:$H$946,7,TRUE)))","v":914.65000000000009},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$923:$H$946,8,TRUE)))","v":699.05000000000007}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$947:$H$949,4,TRUE)))","v":2227.2250000000004},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,5,TRUE)))","v":3129.65},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,6,TRUE)))","v":2413.09},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,7,TRUE)))","v":1968.42},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$63:$H$65,8,TRUE)))","v":1452.73}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$950)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$950)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$950)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$950)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$950)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F53:F56)","v":16705.975000000002},{"$f":"SUM(G53:G56)","v":13304.1},{"$f":"SUM(H53:H56)","v":9956.6150000000016},{"$f":"SUM(I53:I56)","v":8383.8950000000004},{"$f":"SUM(J53:J56)","v":6827.880000000001}]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G32>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F53+F54+F55)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G53+G54+G55)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H53+H54+H55)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I53+I54+I55)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J53+J54+J55)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F57+F58+F59)*12%","v":2013.7170000000001},{"$f":"+(G57+G58+G59)*12%","v":1605.492},1203.7938000000001,1015.0674,{"$f":"+(J57+J58+J59)*12%","v":828.3456000000001}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F57:F60)","v":18794.692000000003},{"$f":"SUM(G57:G60)","v":14984.592000000001},{"$f":"SUM(H57:H60)","v":11235.408800000001},{"$f":"SUM(I57:I60)","v":9473.9624000000003},{"$f":"SUM(J57:J60)","v":7731.2256000000016}]
[null,null,null,"TOTAL  (2da a 4ta Cuota)","n/a",{"$f":"F57+F58+F60-(F59*0.12)","v":18710.692000000003},{"$f":"G57+G58+G60-(G59*0.12)","v":14900.592000000001},11151.408800000001,9389.9624000000003,{"$f":"J57+J58+J60-(J59*0.12)","v":7647.2256000000016}]
[]
[null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2022"]
[null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Secure","index":2,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,3,71,9],[72,0,72,1],[68,3,68,9],[25,3,25,9],[30,3,30,9],[42,3,42,9],[33,0,33,1],[25,0,25,1],[38,0,38,1],[43,0,43,1],[54,0,54,1],[55,3,55,9],[70,0,70,1],[71,0,71,1],[7,3,7,9],[8,3,8,9],[19,0,19,1],[9,3,9,8],[9,0,9,1],[11,4,11,9],[13,4,13,9],[13,0,13,1]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Cotización de Seguro Médico Internacional"]
[null,null,null,"Producto: Bupa Secure Care "]
["BUPA SECURE CARE",null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$23","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G18>0,'INGRESO DE DATOS'!G18,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":65}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,false,null,"Complicaciones de Maternidad (+ $500,000)"]
[]
[null,null,null,null,null,false,false,"Trasplante de Órganos (+ $500,000)"]
[]
[null,null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$140:$H$163,4,TRUE)","v":17795},{"$f":"VLOOKUP($J$18,Tablas!$A$140:$H$163,5,TRUE)","v":16196},{"$f":"VLOOKUP($J$18,Tablas!$A$140:$H$163,6,TRUE)","v":11378},{"$f":"VLOOKUP($J$18,Tablas!$A$140:$H$163,7,TRUE)","v":9569},{"$f":"VLOOKUP($J$18,Tablas!$A$140:$H$163,8,TRUE)","v":7138}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$140:$H$163,4,TRUE)))","v":4901},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$140:$H$163,5,TRUE)))","v":3837},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$140:$H$163,6,TRUE)))","v":2861},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$140:$H$163,7,TRUE)))","v":2432},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$140:$H$163,8,TRUE)))","v":1822}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$164:$H$166,4,TRUE)))","v":5860},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$164:$H$166,5,TRUE)))","v":2986},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$164:$H$166,6,TRUE)))","v":2651},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$164:$H$166,7,TRUE)))","v":2227},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$164:$H$166,8,TRUE)))","v":1673}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$22=FALSE,0,Tablas!D$167)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!E$167)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!F$167)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!G$167)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!H$167)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$341)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$341)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$341)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$341)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$341)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F32:F36)","v":28556},{"$f":"SUM(G32:G36)","v":23019},16890,14228,10633]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F32+F33+F34)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G32+G33+G34)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H32+H33+H34)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I32+I33+I34)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J32+J33+J34)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F37+F38+F39)*12%","v":3435.72},{"$f":"+(G37+G38+G39)*12%","v":2771.2799999999997},2035.8,1716.36,{"$f":"+(J37+J38+J39)*12%","v":1284.96}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F37:F40)","v":32066.720000000001},{"$f":"SUM(G37:G40)","v":25865.279999999999},{"$f":"SUM(H37:H40)","v":19000.8},{"$f":"SUM(I37:I40)","v":16019.36},{"$f":"SUM(J37:J40)","v":11992.96}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$173:$H$196,4,TRUE)","v":9431.35},{"$f":"VLOOKUP($J$18,Tablas!$A$173:$H$196,5,TRUE)","v":8583.880000000001},{"$f":"VLOOKUP($J$18,Tablas!$A$173:$H$196,6,TRUE)","v":6030.34},{"$f":"VLOOKUP($J$18,Tablas!$A$173:$H$196,7,TRUE)","v":5071.5700000000006},{"$f":"VLOOKUP($J$18,Tablas!$A$173:$H$196,8,TRUE)","v":3783.1400000000003}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$173:$H$196,4,TRUE)))","v":2597.5300000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$173:$H$196,5,TRUE)))","v":2033.6100000000001},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$173:$H$196,6,TRUE)))","v":1516.3300000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$173:$H$196,7,TRUE)))","v":1288.96},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$173:$H$196,8,TRUE)))","v":965.66000000000008}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$197:$H$199,4,TRUE)))","v":3105.8},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$197:$H$199,5,TRUE)))","v":1582.5800000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$197:$H$199,6,TRUE)))","v":1405.03},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$197:$H$199,7,TRUE)))","v":1180.3100000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$197:$H$199,8,TRUE)))","v":886.69}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$22=FALSE,0,Tablas!D$200)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!E$200)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!F$200)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!G$200)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!H$200)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$413)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F44:F48)","v":15134.68},{"$f":"SUM(G44:G48)","v":12200.070000000002},8951.7000000000007,7540.8400000000011,5635.49]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F44+F45+F46)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G44+G45+G46)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H44+H45+H46)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I44+I45+I46)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J44+J45+J46)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F49+F50+F51)*12%","v":1825.1615999999999},{"$f":"+(G49+G50+G51)*12%","v":1473.0084000000002},1083.204,913.90080000000012,{"$f":"+(J49+J50+J51)*12%","v":685.25879999999995}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F49:F52)","v":17034.8416},{"$f":"SUM(G49:G52)","v":13748.078400000002},{"$f":"SUM(H49:H52)","v":10109.904},{"$f":"SUM(I49:I52)","v":8529.7408000000014},{"$f":"SUM(J49:J52)","v":6395.7487999999994}]
[null,null,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F49+F50+F52-(F51*0.12)","v":16950.8416},{"$f":"G49+G50+G52-(G51*0.12)","v":13664.078400000002},10025.904,8445.7408000000014,6311.7487999999994]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$957:$H$980,4,TRUE)","v":4893.625},{"$f":"VLOOKUP($J$18,Tablas!$A$957:$H$980,5,TRUE)","v":4453.9000000000005},{"$f":"VLOOKUP($J$18,Tablas!$A$957:$H$980,6,TRUE)","v":3128.9500000000003},{"$f":"VLOOKUP($J$18,Tablas!$A$957:$H$980,7,TRUE)","v":2631.4750000000004},{"$f":"VLOOKUP($J$18,Tablas!$A$957:$H$980,8,TRUE)","v":1962.95}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$957:$H$980,4,TRUE)))","v":1347.7750000000001},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$957:$H$980,5,TRUE)))","v":1055.1750000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$957:$H$980,6,TRUE)))","v":786.77500000000009},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$957:$H$980,7,TRUE)))","v":668.80000000000007},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$957:$H$980,8,TRUE)))","v":501.05000000000007}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$981:$H$983,4,TRUE)))","v":1611.5000000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$981:$H$983,5,TRUE)))","v":821.15000000000009},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$981:$H$983,6,TRUE)))","v":729.02500000000009},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$981:$H$983,7,TRUE)))","v":612.42500000000007},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$981:$H$983,8,TRUE)))","v":460.07500000000005}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$22=FALSE,0,Tablas!D$984)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!E$984)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!F$984)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!G$984)","v":0},{"$f":"+IF($F$22=FALSE,0,Tablas!H$984)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$413)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F57:F61)","v":7852.9},{"$f":"SUM(G57:G61)","v":6330.2250000000004},4644.75,3912.7000000000007,2924.0749999999998]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G33>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F57+F58+F59)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G57+G58+G59)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H57+H58+H59)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I57+I58+I59)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J57+J58+J59)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F62+F63+F64)*12%","v":951.34799999999996},{"$f":"+(G62+G63+G64)*12%","v":768.62700000000007},566.37,478.52400000000006,{"$f":"+(J62+J63+J64)*12%","v":359.88899999999995}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F62:F65)","v":8879.2479999999996},{"$f":"SUM(G62:G65)","v":7173.8520000000008},{"$f":"SUM(H62:H65)","v":5286.12},{"$f":"SUM(I62:I65)","v":4466.2240000000011},{"$f":"SUM(J62:J65)","v":3358.9639999999999}]
[null,null,null,"TOTAL  (2da a 4ta Cuota)","n/a",{"$f":"F62+F63+F65-(F64*0.12)","v":8795.2479999999996},{"$f":"G62+G63+G65-(G64*0.12)","v":7089.8520000000008},5202.12,4382.2240000000011,3274.9639999999999]
[]
[null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2022"]
[null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Premium","index":3,"n_rows":75,"n_cols":11,"rows_kept":75,"cut":false,"hidden":false,"merged":[[9,0,9,1],[11,4,11,9],[13,4,13,9],[7,3,7,9],[8,3,8,9],[27,3,27,9],[11,0,11,1],[17,0,17,1],[23,0,23,1],[74,3,76,9],[59,3,59,9],[73,0,73,1],[74,0,74,1],[75,0,75,1],[32,0,32,1],[32,3,32,9],[45,3,45,9],[73,3,73,9],[57,0,57,1],[38,0,38,1],[43,0,43,1]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Cotización de Seguro Médico Internacional"]
[null,null,null,"Producto: Bupa Premium Care"]
["BUPA PREMIUM CARE"]
[null,null,null,null,null,null,null," "," "," "," "]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$23","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G18>0,'INGRESO DE DATOS'!G18,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":65}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,"Complicaciones de Maternidad (+ $500,000)"]
[null,null,null,null,null,false]
[null,null,null,null,null,false,null,"Trasplante de Órganos (+ $500,000)"]
[null,null,null,null,null,false]
[null,null,null," ",null,null,null,"Eliminación de Deducible"]
[]
[null,null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$274:$H$336,4,TRUE)","v":21751},{"$f":"VLOOKUP($J$18,Tablas!$A$274:$H$336,5,TRUE)","v":19089},{"$f":"VLOOKUP($J$18,Tablas!$A$274:$H$336,6,TRUE)","v":16742},{"$f":"VLOOKUP($J$18,Tablas!$A$274:$H$336,7,TRUE)","v":12051},{"$f":"VLOOKUP($J$18,Tablas!$A$274:$H$336,8,TRUE)","v":6381}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$274:$H$336,4,TRUE)))","v":5138},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$274:$H$336,5,TRUE)))","v":3830},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$274:$H$336,6,TRUE)))","v":2777},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$274:$H$336,7,TRUE)))","v":2084},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$274:$H$336,8,TRUE)))","v":1641}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$337:$H$339,4,TRUE)))","v":5742},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$337:$H$339,5,TRUE)))","v":3924},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$337:$H$339,6,TRUE)))","v":2961},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$337:$H$339,7,TRUE)))","v":2526},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$337:$H$339,8,TRUE)))","v":1775}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$340)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$340)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$340)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$340)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$340)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$341)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$341)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$341)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$341)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$341)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$342)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!E$342)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!F$342)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!G$342)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!H$342)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F34:F39)","v":32631},{"$f":"SUM(G34:G39)","v":26843},22480,16661,9797]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F34+F35+F36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G34+G35+G36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H34+H35+H36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I34+I35+I36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J34+J35+J36)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F40+F41+F42)*12%","v":3924.72},{"$f":"+(G40+G41+G42)*12%","v":3230.16},2706.6,2008.32,{"$f":"+(J40+J41+J42)*12%","v":1184.6399999999999}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F40:F43)","v":36630.720000000001},{"$f":"SUM(G40:G43)","v":30148.16},{"$f":"SUM(H40:H43)","v":25261.599999999999},{"$f":"SUM(I40:I43)","v":18744.32},{"$f":"SUM(J40:J43)","v":11056.64}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$346:$H$408,4,TRUE)","v":11528.03},{"$f":"VLOOKUP($J$18,Tablas!$A$346:$H$408,5,TRUE)","v":10117.17},{"$f":"VLOOKUP($J$18,Tablas!$A$346:$H$408,6,TRUE)","v":8873.26},{"$f":"VLOOKUP($J$18,Tablas!$A$346:$H$408,7,TRUE)","v":6387.0300000000007},{"$f":"VLOOKUP($J$18,Tablas!$A$346:$H$408,8,TRUE)","v":3381.9300000000003}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$346:$H$408,4,TRUE)))","v":2723.1400000000003},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$346:$H$408,5,TRUE)))","v":2029.9},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$346:$H$408,6,TRUE)))","v":1471.8100000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$346:$H$408,7,TRUE)))","v":1104.52},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$346:$H$408,8,TRUE)))","v":869.73}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$409:$H$411,4,TRUE)))","v":3043.26},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$409:$H$411,5,TRUE)))","v":2079.7200000000003},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$409:$H$411,6,TRUE)))","v":1569.3300000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$409:$H$411,7,TRUE)))","v":1338.78},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$409:$H$411,8,TRUE)))","v":940.75}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$412)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$412)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$412)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$412)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$412)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$413)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$413)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$414)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!E$414)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!F$414)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!G$414)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!H$414)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F47:F52)","v":17294.43},{"$f":"SUM(G47:G52)","v":14226.79},11914.4,8830.3300000000017,5192.41]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F47+F48+F49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G47+G48+G49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H47+H48+H49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I47+I48+I49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J47+J48+J49)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F53+F54+F55)*12%","v":2084.3316},{"$f":"+(G53+G54+G55)*12%","v":1716.2148},{"$f":"+(H53+H54+H55)*12%","v":1438.7279999999998},{"$f":"+(I53+I54+I55)*12%","v":1068.6396000000002},{"$f":"+(J53+J54+J55)*12%","v":632.08920000000001}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F53:F56)","v":19453.761600000002},{"$f":"SUM(G53:G56)","v":16018.004800000001},{"$f":"SUM(H53:H56)","v":13428.127999999999},{"$f":"SUM(I53:I56)","v":9973.9696000000022},{"$f":"SUM(J53:J56)","v":5899.4992000000002}]
[null,null,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F53+F54+F56-(F55*0.12)","v":19369.761600000002},{"$f":"G53+G54+G56-(G55*0.12)","v":15934.004800000001},13344.127999999999,9889.9696000000022,5815.4992000000002]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$991:$H$1053,4,TRUE)","v":5981.5250000000005},{"$f":"VLOOKUP($J$18,Tablas!$A$991:$H$1053,5,TRUE)","v":5249.4750000000004},{"$f":"VLOOKUP($J$18,Tablas!$A$991:$H$1053,6,TRUE)","v":4604.05},{"$f":"VLOOKUP($J$18,Tablas!$A$991:$H$1053,7,TRUE)","v":3314.0250000000001},{"$f":"VLOOKUP($J$18,Tablas!$A$991:$H$1053,8,TRUE)","v":1754.7750000000001}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$991:$H$1053,4,TRUE)))","v":1412.95},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$991:$H$1053,5,TRUE)))","v":1053.25},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$991:$H$1053,6,TRUE)))","v":763.67500000000007},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$991:$H$1053,7,TRUE)))","v":573.1},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$991:$H$1053,8,TRUE)))","v":451.27500000000003}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1054:$H$1056,4,TRUE)))","v":1579.0500000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1054:$H$1056,5,TRUE)))","v":1079.1000000000001},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1054:$H$1056,6,TRUE)))","v":814.27500000000009},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1054:$H$1056,7,TRUE)))","v":694.65000000000009},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1054:$H$1056,8,TRUE)))","v":488.12500000000006}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$1057)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$1057)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$1057)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$1057)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$1057)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$1058)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$1058)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$1058)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$1058)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$1058)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$1059)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!E$1059)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!F$1059)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!G$1059)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!H$1059)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F61:F66)","v":8973.5250000000015},{"$f":"SUM(G61:G66)","v":7381.8250000000007},6182,4581.7749999999996,2694.1750000000002]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G34>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F61+F62+F63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G61+G62+G63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H61+H62+H63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I61+I62+I63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J61+J62+J63)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F67+F68+F69)*12%","v":1085.8230000000001},{"$f":"+(G67+G68+G69)*12%","v":894.81900000000007},750.83999999999992,558.81299999999999,{"$f":"+(J67+J68+J69)*12%","v":332.30099999999999}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F67:F70)","v":10134.348000000002},{"$f":"SUM(G67:G70)","v":8351.6440000000002},{"$f":"SUM(H67:H70)","v":7007.84},{"$f":"SUM(I67:I70)","v":5215.5879999999997},{"$f":"SUM(J67:J70)","v":3101.4760000000001}]
[null,null,null,"TOTAL  (2da a 4ta Cuota)","n/a",{"$f":"F67+F68+F70-(F69*0.12)","v":10050.348000000002},{"$f":"G67+G68+G70-(G69*0.12)","v":8267.6440000000002},6923.84,5131.5879999999997,3017.4760000000001]
[]
[null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2022"]
[null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Advantage (LA)","index":4,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":true,"merged":[[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
["Bupa Advantage Care (cobertura solo en Latinoamérica)",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","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$23","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$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":65}]
["Opciones fuera de la Red",null,"NO, solo en casos de emergencia",null,null,"FECHA DE COTIZACION :"]
["Requiere preautorización",null,"SI, 30% de penalización por omitir prenotificación",null,null,{"$f":"NOW()","v":"2021-12-20T18:27:15.930"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
["Número máximo de días de hospitalización",null,"Ilimitado",null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
["Habitación y alimentación",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
["Cuidados Intensivos",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null," "]
["Cobertura de Maternidad",null,"$5,000 (Excepto planes 4,5, y 6)",null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Cobertura Provisional de Recién Nacido",null,"$30,000 por los primeros 90 días",null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Cuidado del Recién Nacido saludable",null,"Ya incluída dentro del beneficio de Maternidad",null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
["Cobertura de Complicaciones de Maternidad",null,"Disponible a través de cobertura opcional adicional"]
["Trasplante de Organos",null,"$1,000,000 de por vida, por diagnóstico"]
["Condiciones congénitas y hereditarias",null,"<18 años $300,000 de por vida; >=18 al 100%",null,null,"Tarifas Anuales"]
["Coberturas opcionales (Riders)",null,"Complicaciones de Maternidad por $500,000",null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,4,TRUE)","v":15378},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,5,TRUE)","v":11902},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,6,TRUE)","v":8897},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,7,TRUE)","v":7032},{"$f":"VLOOKUP($M$16,Tablas!$A$420:$H$443,8,TRUE)","v":5708}]
[null,null,"Trasplante de órganos por $ 300,000 adicionales",null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,4,TRUE)))","v":3529},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,5,TRUE)))","v":2653},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,6,TRUE)))","v":2029},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,7,TRUE)))","v":1555},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$420:$H$443,8,TRUE)))","v":1231}]
["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":23189},17660,13499,10915,8733]
["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":23264},{"$f":"SUM(J36:J37)","v":17735},{"$f":"SUM(K36:K37)","v":13574},{"$f":"SUM(L36:L37)","v":10990},{"$f":"SUM(M36:M37)","v":8808}]
["Atención médica en el hogar",null,"100% de usual/acostumbrado y razonable"]
["Rehabilitación",null,"100% de usual/acostumbrado y razonable",null,null,"Tarifas Semestrales"]
["Residencia y cuidados paliativos",null,"100% de usual/acostumbrado y razonable",null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,4,TRUE)","v":8150.34},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,5,TRUE)","v":6308.06},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,6,TRUE)","v":4715.41},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,7,TRUE)","v":3726.96},{"$f":"VLOOKUP($M$16,Tablas!$A$453:$H$476,8,TRUE)","v":3025.2400000000002}]
["Cobertura de actividades peligrosas",null,1,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,4,TRUE)))","v":1870.3700000000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,5,TRUE)))","v":1406.0900000000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,6,TRUE)))","v":1075.3700000000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,7,TRUE)))","v":824.15000000000009},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$453:$H$476,8,TRUE)))","v":652.43000000000006}]
["Chequeos generales de rutina",null,"Hasta US$150 por año póliza.Sin deducible",null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,4,TRUE)))","v":1991.21},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,5,TRUE)))","v":1367.4},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,6,TRUE)))","v":1085.44},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,7,TRUE)))","v":955.59},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$477:$H$479,8,TRUE)))","v":672.57}]
["Cobertura de VIH, SIDA, CAS",null,"Solo como efecto de transfusión de sangre",null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$480)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$480)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$480)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$480)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$480)","v":119.25}]
["Cobertura de brazos y piernas artificiales",null,"$30,000 por año y hasta $120,000 de por vida",null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$481)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$481)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$481)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$481)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$481)","v":159}]
["Cobertura extendida para dependientes en caso de muerte de asegurado principal",null,"2 años sin costo",null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":12290.170000000002},9359.8000000000011,7154.4699999999993,5784.9500000000007,4628.49]
[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":12365.170000000002},{"$f":"SUM(J46:J47)","v":9434.8000000000011},{"$f":"SUM(K46:K47)","v":7229.4699999999993},{"$f":"SUM(L46:L47)","v":5859.9500000000007},{"$f":"SUM(M46:M47)","v":4703.49}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":12290.170000000002},{"$f":"J46","v":9359.8000000000011},7154.4699999999993,5784.9500000000007,4628.49]
[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":[[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[51,5,51,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[43,2,43,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[35,2,40,3],[33,0,33,1],[34,0,34,1],[35,0,42,1],[41,2,42,3],[43,0,43,1],[34,2,34,3],[48,2,49,3],[48,0,49,1],[46,2,46,3],[47,2,47,3],[44,2,44,3],[46,0,46,1],[47,0,47,1],[44,0,44,1],[45,0,45,1],[45,2,45,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa Blue 500 Guatemala"]
[]
["Bupa Blue 500 Guatemala",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"Nombre"}]
["Cobertura Máxima anual",null,"US$500,000"]
["Cobertura Geografica",null,"Cobertura mundial",null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$23","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$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":65}]
["Opciones fuera de la Red",null,"30%/70%",null,null,"FECHA DE COTIZACION :"]
["Requiere preautorización",null,"SI, 30% de penalización por omitir prenotificación",null,null,{"$f":"NOW()","v":"2021-12-20T18:27:15.930"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
["Número máximo de días de hospitalización",null,"Ilimitado",null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
["Habitación y alimentación",null,"100% dentro de Red Bupa"]
[null,null,"70% fuera de la Red Bupa",null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
["Cuidados Intensivos",null,"100% dentro de Red Bupa"]
[null,null,"70% fuera de la Red Bupa",null,null,null," "]
["Cobertura de Maternidad",null,"$3,500 (Excepto planes 4,5, y 6)",null,null,"Deducibles",null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5"]
["Cobertura Provisional de Recién Nacido",null,"$10,000 por los primeros 90 días",null,null,"Dentro del pais de residencia",null,null,250,500,1000,2000,5000]
["Cuidado del Recién Nacido saludable",null,"2 visitas por año/ $50 vacunas",null,null,"Fuera del pais de residencia",null,null,500,1000,2000,4000,5000]
["Cobertura de Complicaciones de Maternidad",null,50000]
["Trasplante de Organos",null,250000]
["Condiciones congénitas y hereditarias",null,"<18 años $75,000 de por vida; >=18 al 100%",null,null,"Tarifas Anuales"]
["Coberturas opcionales (Riders)",null,"Complicaciones de Maternidad por $500,000",null,null,"Prima de Titular :",null,null,{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,4,TRUE)","v":5200},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,5,TRUE)","v":4523},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,6,TRUE)","v":4123},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,7,TRUE)","v":3767},{"$f":"VLOOKUP($M$16,Tablas!$A$633:$H$695,8,TRUE)","v":2698}]
[null,null,"Trasplante de órganos por $ 500,000 de por vida",null,null,"Prima de Cónyuge",null,null,{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,4,TRUE)))","v":1371},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,5,TRUE)))","v":1193},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,6,TRUE)))","v":1086},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,7,TRUE)))","v":837},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$695,8,TRUE)))","v":650}]
["Acompañamiento de menores hospitalizados",null,"No incluye",null,null,"Primas Hijos :",null,null,{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,4,TRUE)))","v":1736},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,5,TRUE)))","v":1505},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,6,TRUE)))","v":1371},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,7,TRUE)))","v":703},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$696:$H$698,8,TRUE)))","v":641}]
["Ambulancia aérea",null,25000,null,null,"Prima Rider Complic. Maternidad",null,null,{"$f":"+IF($I$20=FALSE,0,Tablas!D$699)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$699)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$699)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$699)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$699)","v":225}]
["Repatriación restos mortales",null,5000,null,null,"Prima Rider Trasplante Organos",null,null,{"$f":"IF($I$22=FALSE,0,Tablas!D$700)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$700)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$700)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$700)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$700)","v":300}]
["Medicamentos por receta",null,"Si son médicamente prescritos tras una hospitalización o en relación con una cirugía ambulatoria entonces $7,000 por los próximos 6 meses.",null,null,"TOTAL PRIMA NETA :",null,null,{"$f":"SUM(I31:I35)","v":8832},7746,7105,5832,4514]
[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":1059.8399999999999},{"$f":"J36*0.12","v":929.52},852.6,699.83999999999992,541.67999999999995]
[null,null,null,null,null,"GRAN TOTAL :",null,null,{"$f":"SUM(I36:I38)","v":9966.84},{"$f":"SUM(J36:J38)","v":8750.52},8032.6,6606.84,5130.68]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,"Medicamentos por receta ambulatoria $1,500",null,null,"Prima de Titular :",null,null,{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,4,TRUE)","v":2756},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,5,TRUE)","v":2397.19},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,6,TRUE)","v":2185.19},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,7,TRUE)","v":1996.51},{"$f":"VLOOKUP($M$16,Tablas!$A$705:$H$767,8,TRUE)","v":1429.94}]
[null,null,null,null,null,"Prima de Cónyuge",null,null,{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,4,TRUE)))","v":726.63},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,5,TRUE)))","v":632.29000000000008},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,6,TRUE)))","v":575.58000000000004},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,7,TRUE)))","v":443.61},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$705:$H$767,8,TRUE)))","v":344.5}]
["Atención médica en el hogar",null,"$200 por día, hasta 60 días por año por incidente",null,null,"Primas Hijos :",null,null,{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,4,TRUE)))","v":920.08},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,5,TRUE)))","v":797.65000000000009},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,6,TRUE)))","v":726.63},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,7,TRUE)))","v":372.59000000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$768:$H$770,8,TRUE)))","v":339.73}]
["Rehabilitación",null,"100% de UCR hasta 40 sesiones por año",null,null,"Prima Rider Complic. Maternidad",null,null,{"$f":"+IF($I$20=FALSE,0,Tablas!D$771)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$771)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$771)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$771)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$771)","v":119.25}]
["Residencia y cuidados paliativos",null,"100% de usual/acostumbrado y razonable",null,null,"Prima Rider Trasplante Organos",null,null,{"$f":"IF($I$22=FALSE,0,Tablas!D$772)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$772)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$772)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$772)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$772)","v":159}]
["Cobertura de actividades peligrosas",null,"100% siempre que no sea práctica profesional",null,null,"TOTAL PRIMA NETA :",null,null,{"$f":"SUM(I42:I46)","v":4680.96},4105.38,3765.65,3090.96,2392.42]
["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":561.71519999999998},{"$f":"J47*0.12","v":492.6456},451.87799999999999,370.91519999999997,287.09039999999999]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,null,{"$f":"SUM(I47:I49)","v":5317.6751999999997},{"$f":"SUM(J47:J49)","v":4673.0255999999999},4292.5280000000002,3536.8751999999999,2754.5104000000001]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,null,{"$f":"I47+I49","v":5242.6751999999997},{"$f":"J47+J49","v":4598.0255999999999},4217.5280000000002,3461.8751999999999,2679.5104000000001]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2014"]
[null," "]

{"sheet":"Blue 100","index":6,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":true,"merged":[[13,0,13,1],[13,2,13,3],[13,7,13,12],[9,0,9,12],[11,0,11,3],[11,7,11,12],[12,0,12,1],[12,2,12,3],[14,0,14,1],[14,2,14,3],[15,0,15,1],[15,2,15,3],[16,0,16,1],[16,2,16,3],[16,5,16,6],[17,0,18,1],[17,2,18,3],[17,5,17,6],[19,0,19,1],[19,2,19,3],[20,0,21,1],[20,2,20,3],[21,2,21,3],[22,0,23,1],[22,2,22,3],[23,2,23,3],[24,0,24,1],[24,2,24,3],[25,0,25,1],[25,2,25,3],[26,0,26,1],[26,2,26,3],[27,0,27,1],[27,2,27,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[43,0,43,1],[43,2,43,3],[30,0,31,1],[30,2,30,3],[31,2,31,3],[32,0,32,1],[32,2,32,3],[33,0,33,1],[33,2,33,3],[34,0,34,1],[34,2,34,3],[35,0,42,1],[35,2,40,3],[41,2,42,3],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[46,0,46,1],[46,2,46,3],[47,0,47,1],[47,2,47,3],[48,0,49,1],[48,2,49,3],[51,5,51,12]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa Blue 100 Guatemala"]
[]
["Bupa Blue 100 Guatemala",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"Nombre"}]
["Cobertura Máxima anual",null,"US$100,000"]
["Cobertura Geografica",null,"Cobertura mundial",null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$23","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$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":65}]
["Opciones fuera de la Red",null,"30%/70%",null,null,"FECHA DE COTIZACION :"]
["Requiere preautorización",null,"Sí, 30% de penalización por omitir prenotificación",null,null,{"$f":"NOW()","v":"2021-12-20T18:27:15.930"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
["Número máximo de días de hospitalización",null,"Ilimitado",null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
["Habitación y alimentación",null,"100% dentro de Red Bupa"]
[null,null,"70% fuera de la Red Bupa",null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
["Cuidados Intensivos",null,"100% dentro de Red Bupa"]
[null,null,"70% fuera de la Red Bupa",null,null,null," "]
["Cobertura de Maternidad",null,"$3,500 (Excepto planes 4,5, y 6)",null,null,"Deducibles",null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5"]
["Cobertura Provisional de Recién Nacido",null,"$7,500 por los primeros 90 días",null,null,"Dentro del pais de residencia",null,null,250,500,1000,2000,5000]
["Cuidado del Recién Nacido saludable",null,"2 visitas por año. $50 vacunas",null,null,"Fuera del pais de residencia",null,null,500,1000,2000,4000,5000]
["Cobertura de Complicaciones de Maternidad",null,25000]
["Trasplante de Organos",null,100000]
["Condiciones congénitas y hereditarias",null,"<18 años $50,000 de por vida; >=18 al 100%",null,null,"Tarifas Anuales"]
["Coberturas opcionales (Riders)",null,"Complicaciones de Maternidad por $500,000",null,null,"Prima de Titular :",null,null,{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,4,TRUE)","v":4179},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,5,TRUE)","v":4095},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,6,TRUE)","v":3860},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,7,TRUE)","v":3519},{"$f":"VLOOKUP($M$16,Tablas!$A$778:$H$840,8,TRUE)","v":3213}]
[null,null,"Trasplante de órganos por $ 500,000 de por vida",null,null,"Prima de Cónyuge",null,null,{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$778:$H$840,4,TRUE)))","v":1102},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$778:$H$840,5,TRUE)))","v":1079},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$633:$H$656,6,TRUE)))","v":1086},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$778:$H$840,7,TRUE)))","v":928},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$778:$H$840,8,TRUE)))","v":717}]
["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":7199},7063,6756,6145,5052]
[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":863.88},{"$f":"J36*0.12","v":847.56},810.71999999999991,737.4,606.24]
[null,null,null,null,null,"GRAN TOTAL :",null,null,{"$f":"SUM(I36:I38)","v":8137.88},{"$f":"SUM(J36:J38)","v":7985.5599999999995},7641.72,6957.4,5733.24]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,"Tratamiento Ambulatorio a US$1,500",null,null,"Prima de Titular :",null,null,{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,4,TRUE)","v":2214.87},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,5,TRUE)","v":2170.35},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,6,TRUE)","v":2045.8000000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,7,TRUE)","v":1865.0700000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$850:$H$912,8,TRUE)","v":1702.89}]
[null,null,null,null,null,"Prima de Cónyuge",null,null,{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,4,TRUE)))","v":584.06000000000006},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,5,TRUE)))","v":571.87},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,6,TRUE)))","v":539.54000000000008},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,7,TRUE)))","v":491.84000000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$850:$H$912,8,TRUE)))","v":380.01}]
["Atención médica en el hogar",null,"$200 por día, hasta 60 días por año por incidente",null,null,"Primas Hijos :",null,null,{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,4,TRUE)))","v":738.29000000000008},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,5,TRUE)))","v":722.92000000000007},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,6,TRUE)))","v":681.05000000000007},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,7,TRUE)))","v":621.69000000000005},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$913:$H$915,8,TRUE)))","v":316.41000000000003}]
["Rehabilitación",null,"100% de UCR hasta 30 sesiones por año",null,null,"Prima Rider Complic. Maternidad",null,null,{"$f":"+IF($I$20=FALSE,0,Tablas!D$916)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$916)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$916)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$916)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$916)","v":119.25}]
["Residencia y cuidados paliativos",null,"100% de usual/acostumbrado y razonable",null,null,"Prima Rider Trasplante Organos",null,null,{"$f":"IF($I$22=FALSE,0,Tablas!D$917)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$917)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$917)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$917)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$917)","v":159}]
["Cobertura de actividades peligrosas",null,"100% siempre que no sea práctica profesional",null,null,"TOTAL PRIMA NETA :",null,null,{"$f":"SUM(I42:I46)","v":3815.47},3743.39,3544.6400000000003,3256.8500000000004,2677.56]
["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":457.85639999999995},{"$f":"J47*0.12","v":449.20679999999999},425.35680000000002,390.822,321.30719999999997]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,null,{"$f":"SUM(I47:I49)","v":4348.3263999999999},{"$f":"SUM(J47:J49)","v":4267.5968000000003},4044.9968000000003,3722.6720000000005,3073.8671999999997]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,null,{"$f":"I47+I49","v":4273.3263999999999},{"$f":"J47+J49","v":4192.5968000000003},3969.9968000000003,3647.6720000000005,2998.8671999999997]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2014"]
[null," "]

{"sheet":"Classic","index":7,"n_rows":75,"n_cols":10,"rows_kept":75,"cut":false,"hidden":false,"merged":[[18,0,18,1],[74,3,76,9],[59,3,59,9],[69,0,69,1],[70,0,70,1],[71,0,71,1],[7,0,7,1],[73,3,73,9],[11,4,11,9],[13,4,13,9],[56,0,56,1],[27,3,27,9],[32,3,32,9],[45,3,45,9],[12,0,12,1],[43,0,43,1],[38,0,38,1],[24,0,24,1],[7,3,7,9],[8,3,8,9],[9,0,9,1],[32,0,32,1]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Cotización de Seguro Médico Internacional"]
[null,null,null,"Bupa Classic Care"]
["BUPA CLASSIC CARE"]
[]
[null,null,null,"Nombre del Asegurado:",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"Nombre"}]
[]
[null,null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$23","v":"Agente / Agencia"}]
[]
[null,null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G18>0,'INGRESO DE DATOS'!G18,\"\")","v":""}]
[]
[null,null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":65}]
[]
[null,null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,"Complicaciones de Maternidad (+ $500,000)"]
[null,null,null,null,null,false]
[null,null,null,null,null,false,null,"Trasplante de Órganos (+ $500,000)"]
[null,null,null,null,null,false]
[null,null,null,null,null,null,null,"Eliminación de Deducible"]
[]
[null,null,null,"Deducibles"]
[null,null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[null,null,null,"Tarifas Anuales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$487:$H$549,4,TRUE)","v":14321},{"$f":"VLOOKUP($J$18,Tablas!$A$487:$H$549,5,TRUE)","v":12396},{"$f":"VLOOKUP($J$18,Tablas!$A$487:$H$549,6,TRUE)","v":8748},{"$f":"VLOOKUP($J$18,Tablas!$A$487:$H$549,7,TRUE)","v":5450},{"$f":"VLOOKUP($J$18,Tablas!$A$487:$H$549,8,TRUE)","v":2923}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$487:$H$549,4,TRUE)))","v":3025},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$487:$H$549,5,TRUE)))","v":2344},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$487:$H$549,6,TRUE)))","v":1532},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$487:$H$549,7,TRUE)))","v":1124},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$487:$H$549,8,TRUE)))","v":790}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$550:$H$552,4,TRUE)))","v":3797},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$550:$H$552,5,TRUE)))","v":1929},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$550:$H$552,6,TRUE)))","v":1502},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$550:$H$552,7,TRUE)))","v":1070},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$550:$H$552,8,TRUE)))","v":760}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$553)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$553)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$553)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$553)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$553)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$554)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$554)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$554)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$554)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$554)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$555)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!E$555)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!F$555)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!G$555)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!H$555)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F34:F39)","v":21143},{"$f":"SUM(G34:G39)","v":16669},11782,7644,4473]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F34+F35+F36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G34+G35+G36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H34+H35+H36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I34+I35+I36)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J34+J35+J36)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F40+F41+F42)*12%","v":2546.16},{"$f":"+(G40+G41+G42)*12%","v":2009.28},1422.84,926.28,{"$f":"+(J40+J41+J42)*12%","v":545.76}]
[null,null,null,"TOTAL","n/a",{"$f":"SUM(F40:F43)","v":23764.16},{"$f":"SUM(G40:G43)","v":18753.28},{"$f":"SUM(H40:H43)","v":13279.84},{"$f":"SUM(I40:I43)","v":8645.2800000000007},{"$f":"SUM(J40:J43)","v":5093.76}]
[]
[null,null,null,"Tarifas Semestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$559:$H$621,4,TRUE)","v":7590.13},{"$f":"VLOOKUP($J$18,Tablas!$A$559:$H$621,5,TRUE)","v":6569.88},{"$f":"VLOOKUP($J$18,Tablas!$A$559:$H$621,6,TRUE)","v":4636.4400000000005},{"$f":"VLOOKUP($J$18,Tablas!$A$559:$H$621,7,TRUE)","v":2888.5},{"$f":"VLOOKUP($J$18,Tablas!$A$559:$H$621,8,TRUE)","v":1549.19}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$559:$H$621,4,TRUE)))","v":1603.25},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$559:$H$621,5,TRUE)))","v":1242.3200000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$559:$H$621,6,TRUE)))","v":811.96},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$559:$H$621,7,TRUE)))","v":595.72},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$559:$H$621,8,TRUE)))","v":418.70000000000005}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$622:$H$624,4,TRUE)))","v":2012.41},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$622:$H$624,5,TRUE)))","v":1022.37},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$622:$H$624,6,TRUE)))","v":796.06000000000006},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$622:$H$624,7,TRUE)))","v":567.1},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$622:$H$624,8,TRUE)))","v":402.8}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$625)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$625)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$625)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$625)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$625)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$626)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$626)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$626)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$626)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$626)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$627)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!E$627)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!F$627)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!G$627)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!H$627)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F47:F52)","v":11205.79},{"$f":"SUM(G47:G52)","v":8834.5700000000015},6244.4600000000009,4051.32,2370.69]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F47+F48+F49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G47+G48+G49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H47+H48+H49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I47+I48+I49)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J47+J48+J49)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F53+F54+F55)*12%","v":1353.6948},{"$f":"+(G53+G54+G55)*12%","v":1069.1484},758.3352000000001,495.15839999999997,{"$f":"+(J53+J54+J55)*12%","v":293.4828}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F53:F56)","v":12634.4848},{"$f":"SUM(G53:G56)","v":9978.7184000000016},{"$f":"SUM(H53:H56)","v":7077.7952000000014},{"$f":"SUM(I53:I56)","v":4621.4784},{"$f":"SUM(J53:J56)","v":2739.1728000000003}]
[null,null,null,"TOTAL  (2da Cuota)","n/a",{"$f":"F53+F54+F56-(F55*0.12)","v":12550.4848},{"$f":"G53+G54+G56-(G55*0.12)","v":9894.7184000000016},6993.7952000000014,4537.4784,{"$f":"J53+J54+J56-(J55*0.12)","v":2655.1728000000003}]
[]
[null,null,null,"Tarifas Trimestrales"]
[null,null,null,"Prima Titular","n/a",{"$f":"VLOOKUP($J$18,Tablas!$A$1065:$H$1127,4,TRUE)","v":3938.2750000000001},{"$f":"VLOOKUP($J$18,Tablas!$A$1065:$H$1127,5,TRUE)","v":3408.9},{"$f":"VLOOKUP($J$18,Tablas!$A$1065:$H$1127,6,TRUE)","v":2405.7000000000003},{"$f":"VLOOKUP($J$18,Tablas!$A$1065:$H$1127,7,TRUE)","v":1498.7500000000002},{"$f":"VLOOKUP($J$18,Tablas!$A$1065:$H$1127,8,TRUE)","v":803.82500000000005}]
[null,null,null,"Prima Cónyuge","n/a",{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$1065:$H$1127,4,TRUE)))","v":831.87500000000011},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$1065:$H$1127,5,TRUE)))","v":644.6},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$1065:$H$1127,6,TRUE)))","v":421.3},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$1065:$H$1127,7,TRUE)))","v":309.10000000000002},{"$f":"IF($G$18=1,0,(VLOOKUP($J$20,Tablas!$A$1065:$H$1127,8,TRUE)))","v":217.25000000000003}]
[null,null,null,"Primas Hijos","n/a",{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1128:$H$1130,4,TRUE)))","v":1044.1750000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1128:$H$1130,5,TRUE)))","v":530.47500000000002},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1128:$H$1130,6,TRUE)))","v":413.05},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1128:$H$1130,7,TRUE)))","v":294.25},{"$f":"IF($G$20=0,0,(VLOOKUP($G$20,Tablas!$A$1128:$H$1130,8,TRUE)))","v":209.00000000000003}]
[null,null,null,"Anexo: Complicaciones de Maternidad","n/a",{"$f":"+IF($F$23=FALSE,0,Tablas!D$1131)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!E$1131)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!F$1131)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!G$1131)","v":0},{"$f":"+IF($F$23=FALSE,0,Tablas!H$1131)","v":0}]
[null,null,null,"Anexo: Trasplante Organos","n/a",{"$f":"IF($F$24=FALSE,0,Tablas!D$1132)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!E$1132)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!F$1132)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!G$1132)","v":0},{"$f":"IF($F$24=FALSE,0,Tablas!H$1132)","v":0}]
[null,null,null,"Anexo: Eliminacion de Deducible","n/a",{"$f":"IF($F$25=FALSE,0,Tablas!D$1133)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!E$1133)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!F$1133)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!G$1133)","v":0},{"$f":"IF($F$25=FALSE,0,Tablas!H$1133)","v":0}]
[null,null,null,"PRIMA NETA","n/a",{"$f":"SUM(F61:F66)","v":5814.3250000000007},{"$f":"SUM(G61:G66)","v":4583.9750000000004},3240.0500000000006,2102.1000000000004,1230.075]
[null,null,null,{"$f":"IF('INGRESO DE DATOS'!G34>0,\"Descuento\",\"\")","v":""},"n/a",{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(F61+F62+F63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(G61+G62+G63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(H61+H62+H63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(I61+I62+I63)*'INGRESO DE DATOS'!$G$18,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$G$18>0,-(J61+J62+J63)*'INGRESO DE DATOS'!$G$18,0)","v":0}]
[null,null,null,"Costo Administrativo Anual","n/a",75,75,75,75,75]
[null,null,null,"IVA (12%)","n/a",{"$f":"+(F67+F68+F69)*12%","v":706.71900000000005},{"$f":"+(G67+G68+G69)*12%","v":559.077},397.80600000000004,261.25200000000001,{"$f":"+(J67+J68+J69)*12%","v":156.60900000000001}]
[null,null,null,"TOTAL  (1ra Cuota)","n/a",{"$f":"SUM(F67:F70)","v":6596.0440000000008},{"$f":"SUM(G67:G70)","v":5218.0520000000006},{"$f":"SUM(H67:H70)","v":3712.8560000000007},{"$f":"SUM(I67:I70)","v":2438.3520000000003},{"$f":"SUM(J67:J70)","v":1461.684}]
[null,null,null,"TOTAL  (2da a 4ta Cuota)","n/a",{"$f":"F67+F68+F70-(F69*0.12)","v":6512.0440000000008},{"$f":"G67+G68+G70-(G69*0.12)","v":5134.0520000000006},3628.8560000000007,2354.3520000000003,{"$f":"J67+J68+J70-(J69*0.12)","v":1377.684}]
[]
[null,null,null,"Tarifas en US $ -   Efectivas partir del 1ro de enero de  2022"]
[null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Resumen tarifas anuales","index":8,"n_rows":107,"n_cols":9,"rows_kept":107,"cut":false,"hidden":false,"merged":[[74,2,74,8],[75,2,76,2],[60,2,60,8],[66,2,66,8],[67,2,67,3],[70,2,70,8],[71,2,72,2],[50,2,50,8],[51,2,52,2],[54,2,54,8],[55,2,56,2],[59,2,59,8],[35,2,36,2],[39,2,39,8],[40,2,40,8],[46,2,46,8],[47,2,47,3],[0,0,0,8],[101,2,102,8],[95,2,96,2],[6,3,6,8],[8,3,8,8],[14,1,14,2],[13,1,13,2],[80,2,80,8],[79,2,79,8],[19,2,19,8],[20,2,20,8],[26,2,26,8],[27,2,27,3],[30,2,30,8],[31,2,32,2],[34,2,34,8],[104,2,104,8],[105,2,105,8],[106,2,106,8],[86,2,86,8],[100,2,100,8],[90,2,90,8],[91,2,92,2],[87,2,87,3],[94,2,94,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$12","v":"Nombre"}]
[]
[null,null,"Intermediario:",{"$f":"+'INGRESO DE DATOS'!$D$23","v":"Agente / Agencia"}]
[]
[null,null,"Fecha:",{"$f":"+TODAY()","v":"2021-12-20"},null,{"$f":"IF('INGRESO DE DATOS'!G18>0,\"Descuento\",\"\")","v":""},{"$f":"IF('INGRESO DE DATOS'!G18>0,'INGRESO DE DATOS'!G18,\"\")","v":""}]
[]
[null,null,null,null,"Numero de Adultos:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular:",{"$f":"+'INGRESO DE DATOS'!$G$16","v":65}]
[]
[null,null,null,null,"Numero de Hijos:",{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,"Edad de Conyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,"COMPLETE CARE"]
[null,null,"Deducibles"]
[null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"Complete Care",null,{"$f":"+Complete!F38","v":68122.880000000005},{"$f":"+Complete!G38","v":48135.360000000001},{"$f":"+Complete!H38","v":35906.080000000002},{"$f":"+Complete!I38","v":30372.16},{"$f":"+Complete!J38","v":25045.439999999999}]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"Complete Care","1ra Cuota",{"$f":"+Complete!F49","v":36144.606400000004},{"$f":"+Complete!G49","v":25551.220800000003},{"$f":"+Complete!H49","v":19069.702400000002},{"$f":"+Complete!I49","v":16136.7248},{"$f":"+Complete!J49","v":13313.563200000001}]
[null,null,null,"2da Cuota",{"$f":"+Complete!F50","v":36060.606400000004},{"$f":"+Complete!G50","v":25467.220800000003},{"$f":"+Complete!H50","v":18985.702400000002},{"$f":"+Complete!I50","v":16052.7248},{"$f":"+Complete!J50","v":13229.563200000001}]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"Complete Care","1ra Cuota",{"$f":"+Complete!F61","v":18794.692000000003},{"$f":"+Complete!G61","v":14984.592000000001},{"$f":"+Complete!H61","v":11235.408800000001},{"$f":"+Complete!I61","v":9473.9624000000003},{"$f":"+Complete!J61","v":7731.2256000000016}]
[null,null,null,"2da a 4ta Cuota",{"$f":"+Complete!F62","v":18710.692000000003},{"$f":"+Complete!G62","v":14900.592000000001},{"$f":"+Complete!H62","v":11151.408800000001},{"$f":"+Complete!I62","v":9389.9624000000003},{"$f":"+Complete!J62","v":7647.2256000000016}]
[]
[]
[null,null,"SECURE CARE"]
[null,null,"Deducibles"]
[null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"Secure Care",null,{"$f":"+Secure!F41","v":32066.720000000001},{"$f":"+Secure!G41","v":25865.279999999999},{"$f":"+Secure!H41","v":19000.8},{"$f":"+Secure!I41","v":16019.36},{"$f":"+Secure!J41","v":11992.96}]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"Secure Care","1ra Cuota",{"$f":"+Secure!F53","v":17034.8416},{"$f":"+Secure!G53","v":13748.078400000002},{"$f":"+Secure!H53","v":10109.904},{"$f":"+Secure!I53","v":8529.7408000000014},{"$f":"+Secure!J53","v":6395.7487999999994}]
[null,null,null,"2da Cuota",{"$f":"+Secure!F54","v":16950.8416},{"$f":"+Secure!G54","v":13664.078400000002},{"$f":"+Secure!H54","v":10025.904},{"$f":"+Secure!I54","v":8445.7408000000014},{"$f":"+Secure!J54","v":6311.7487999999994}]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"Complete Care","1ra Cuota",{"$f":"+Secure!F66","v":8879.2479999999996},{"$f":"+Secure!G66","v":7173.8520000000008},{"$f":"+Secure!H66","v":5286.12},{"$f":"+Secure!I66","v":4466.2240000000011},{"$f":"+Secure!J66","v":3358.9639999999999}]
[null,null,null,"2da a 4ta Cuota",{"$f":"+Secure!F67","v":8795.2479999999996},{"$f":"+Secure!G67","v":7089.8520000000008},{"$f":"+Secure!H67","v":5202.12},{"$f":"+Secure!I67","v":4382.2240000000011},{"$f":"+Secure!J67","v":3274.9639999999999}]
[]
[]
[null,null,"PREMIUM CARE"]
[null,null,"Deducibles"]
[null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"Premium Care",null,{"$f":"+Premium!F44","v":36630.720000000001},{"$f":"+Premium!G44","v":30148.16},{"$f":"+Premium!H44","v":25261.599999999999},{"$f":"+Premium!I44","v":18744.32},{"$f":"+Premium!J44","v":11056.64}]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"Premium Care","1ra Cuota",{"$f":"+Premium!F57","v":19453.761600000002},{"$f":"+Premium!G57","v":16018.004800000001},{"$f":"+Premium!H57","v":13428.127999999999},{"$f":"+Premium!I57","v":9973.9696000000022},{"$f":"+Premium!J57","v":5899.4992000000002}]
[null,null,null,"2da Cuota",{"$f":"+Premium!F58","v":19369.761600000002},{"$f":"+Premium!G58","v":15934.004800000001},{"$f":"+Premium!H58","v":13344.127999999999},{"$f":"+Premium!I58","v":9889.9696000000022},{"$f":"+Premium!J58","v":5815.4992000000002}]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"Premium Care","1ra Cuota",{"$f":"+Premium!F71","v":10134.348000000002},{"$f":"+Premium!G71","v":8351.6440000000002},{"$f":"+Premium!H71","v":7007.84},{"$f":"+Premium!I71","v":5215.5879999999997},{"$f":"+Premium!J71","v":3101.4760000000001}]
[null,null,null,"2da a 4ta Cuota",{"$f":"+Premium!F72","v":10050.348000000002},{"$f":"+Premium!G72","v":8267.6440000000002},{"$f":"+Premium!H72","v":6923.84},{"$f":"+Premium!I72","v":5131.5879999999997},{"$f":"+Premium!J72","v":3017.4760000000001}]
[]
[]
[null,null,"CLASSIC CARE"]
[null,null,"Deducibles"]
[null,null,null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,"Dentro del pais de residencia","n/a",1000,2000,5000,10000,20000]
[null,null,"Fuera del pais de residencia","n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,"Tarifas Anuales"]
[null,null,"Classic Care",null,{"$f":"+Classic!F44","v":23764.16},{"$f":"+Classic!G44","v":18753.28},{"$f":"+Classic!H44","v":13279.84},{"$f":"+Classic!I44","v":8645.2800000000007},{"$f":"+Classic!J44","v":5093.76}]
[]
[]
[null,null,"Tarifas Semestrales"]
[null,null,"Classic Care","1ra Cuota",{"$f":"+Classic!$F$57","v":12634.4848},{"$f":"+Classic!$G$57","v":9978.7184000000016},{"$f":"+Classic!$H$57","v":7077.7952000000014},{"$f":"+Classic!$I$57","v":4621.4784},{"$f":"+Classic!$J$57","v":2739.1728000000003}]
[null,null,null,"2da Cuota",{"$f":"+Classic!$F$58","v":12550.4848},{"$f":"+Classic!$G$58","v":9894.7184000000016},{"$f":"+Classic!$H$58","v":6993.7952000000014},{"$f":"+Classic!$I$58","v":4537.4784},{"$f":"+Classic!$J$58","v":2655.1728000000003}]
[]
[null,null,"Tarifas Trimestrales"]
[null,null,"Classic Care","1ra Cuota",{"$f":"+Classic!$F$71","v":6596.0440000000008},{"$f":"+Classic!$G$71","v":5218.0520000000006},{"$f":"+Classic!$H$71","v":3712.8560000000007},{"$f":"+Classic!$I$71","v":2438.3520000000003},{"$f":"+Classic!$J$71","v":1461.684}]
[null,null,null,"2da a 4ta Cuota",{"$f":"+Classic!$F$72","v":6512.0440000000008},{"$f":"+Classic!$G$72","v":5134.0520000000006},{"$f":"+Classic!$H$72","v":3628.8560000000007},{"$f":"+Classic!$I$72","v":2354.3520000000003},{"$f":"+Classic!$J$72","v":1377.684}]
[]
[]
[]
[null,null,"Tarifas en US $ -  Efectivas a partir del 1ro de enero de  2022"]
[null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[null,null,"Bupa Guatemala, Compañía de Seguros, S.A."]
[null,null,"5 Avenida 5-55 Zona 14, Europlaza World Business Center, Torre 3, Nivel 11, Guatemala"]
[null,null,"PBX: 2300-8000 / www.bupasalud.com / servicioguatemala@bupalatinamerica.com"]

{"sheet":"Tablas","index":9,"n_rows":1133,"n_cols":26,"rows_kept":1133,"cut":false,"hidden":true,"merged":[[847,0,847,1],[847,2,847,6],[773,0,773,7],[774,0,774,7],[775,0,775,1],[775,2,775,6],[846,0,846,7],[629,0,629,7],[630,0,630,1],[630,2,630,6],[701,0,701,7],[702,0,702,1],[702,2,702,6],[343,2,343,6],[415,0,415,7],[555,0,555,7],[556,0,556,1],[556,2,556,6],[343,0,343,1],[449,0,449,7],[450,0,450,1],[450,2,450,6],[416,0,416,7],[417,0,417,1],[417,2,417,6],[628,0,628,7],[482,0,482,7],[483,0,483,7],[484,0,484,1],[484,2,484,6],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[342,0,342,7],[269,0,269,7],[270,0,270,7],[271,0,271,1],[271,2,271,6],[170,2,170,6],[202,0,202,7],[236,0,236,7],[237,0,237,1],[237,2,237,6],[204,0,204,1],[204,2,204,6],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[918,0,918,7],[919,0,919,7],[920,0,920,1],[920,2,920,6],[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[952,0,952,7],[953,0,953,7],[954,0,954,1],[954,2,954,6],[986,0,986,7],[1062,0,1062,1],[1062,2,1062,6],[987,0,987,7],[988,0,988,1],[988,2,988,6],[1060,0,1060,7],[1061,0,1061,7]]}
[]
["BUPA COMPLETE GUATEMALA",null,null,null,null,null,null,null,null,"FACTOR SEMESTRAL :",null,0.53]
["TARIFAS ANUALES",null,null,null,null,null,null,null,null,"FACTOR TRIMESTRAL :",null,0.27500000000000002]
["EDAD"]
[" "," ","DW1","DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",16474,10023,6865,4819,3326,2542,null,"Descuento (15%)",null,1,null,10791,6565,4496,3238,2294,1753,null,true,true,true,true,true,true]
[25,"-  29",17299,10501,7622,5355,3649,2804,null,null,null,null,null,11330,6878,4992,3598,2518,1934,null,true,true,true,true,true,true]
[30,"-  34",18056,10985,8168,5957,4435,3392,null,null,null,null,null,11826,7194,5350,4003,3059,2340,null,true,true,true,true,true,true]
[35,"-  39",20181,12290,9131,6690,4954,3783,null,null,null,null,null,13218,8049,5980,4496,3418,2609,null,true,true,true,true,true,true]
[40,"-  44",22858,14276,10023,7428,5475,4171,null,null,null,null,null,14972,9351,6565,4992,3777,2878,null,true,true,true,true,true,true]
[45,"-  49",25536,15927,11190,8295,6127,4693,null,null,null,null,null,16726,10432,7329,5575,4227,3238,null,true,true,true,true,true,true]
[50,"-  54",33704,20798,14760,10906,8733,6715,null,null,null,null,null,22076,13623,9667,7329,6026,4633,null,true,true,true,true,true,true]
[55,"-  59",35830,22170,15719,11641,9317,7104,null,null,null,null,null,23469,14521,10296,7823,6429,4901,null,true,true,true,true,true,true]
[60,null,38027,24094,17094,13246,11077,8926,null,null,null,null,null,24908,15781,11196,8902,7644,6159,null,true,true,true,true,true,true]
[61,null,40841,25877,18331,14183,11925,9580,null,null,null,null,null,26752,16949,12006,9532,8229,6610,null,true,true,true,true,true,true]
[62,null,44685,28348,20045,15522,13029,10489,null,null,null,null,null,29269,18568,13129,10432,8991,7238,null,true,true,true,true,true,true]
[63,null,47500,30133,21347,16526,13880,11141,null,null,null,null,null,31113,19737,13982,11106,9577,7688,null,true,true,true,true,true,true]
[64,null,51412,32604,23065,17865,14987,12055,null,null,null,null,null,33676,21356,15107,12006,10342,8319,null,true,true,true,true,true,true]
[65,null,53879,42627,30133,22612,20003,17004,null,null,null,null,null,35292,27921,19737,15197,13803,11734,null,true,true,true,true,true,true]
[66,null,56283,49557,35008,26289,23261,19740,null,null,null,null,null,36866,32461,22930,17669,16052,13623,null,true,true,true,true,true,true]
[67,null,61500,54088,38234,28696,25410,21566,null,null,null,null,null,40284,35429,25043,19287,17535,14882,null,true,true,true,true,true,true]
[68,null,68020,59921,42350,31775,28145,23911,null,null,null,null,null,44555,39249,27739,21356,19423,16501,null,true,true,true,true,true,true]
[69,null,74812,65894,46539,34987,30946,26254,null,null,null,null,null,49004,43162,30483,23514,21356,18118,null,true,true,true,true,true,true]
[70,null,88544,81129,56694,41138,36028,30881,null,null,null,null,null,57999,53142,37136,27649,24863,21311,null,true,true,true,true,true,true]
[71,null,92045,84287,58894,42747,37462,32120,null,null,null,null,null,60292,55210,38577,28730,25853,22166,null,true,true,true,true,true,true]
[72,null,94652,86689,60608,43950,38503,33032,null,null,null,null,null,62000,56784,39699,29539,26571,22795,null,true,true,true,true,true,true]
[73,null,98083,89847,62806,45558,39935,34269,null,null,null,null,null,64248,58852,41139,30619,27560,23649,null,true,true,true,true,true,true]
[74,null,99866,91495,63903,46426,40653,34856,null,null,null,null,null,65416,59932,41858,31203,28055,24054,null,true,true,true,true,true,true]
[75,"o más",104193,95475,66715,48429,42413,36353,null,null,null,null,null,68249,62539,43700,32550,29269,25088,null,true,true,true,true,true,true]
[1,"Hijo",5561,3504,2541,1944,1631,1174,null,null,null,null,null,3641,2294,1664,1305,1125,809,null,true,true,true,true,true,true]
[2,"Hijos",8718,5561,4051,3081,2542,1893,null,null,null,null,null,5710,3641,2653,2070,1753,1305,null,true,true,true,true,true,true]
[3,"Hijos o más",12701,8099,5905,4553,3714,2741,null,null,null,null,null,8319,5304,3867,3059,2562,1890,null,true,true,true,true,true,true]
[1,"Rider Comp. Maternidad",0,0,0,225,225,225]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","DW1","DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",{"$f":"C6*$L$2","v":8731.2200000000012},{"$f":"D6*$L$2","v":5312.1900000000005},3638.4500000000003,2554.0700000000002,1762.7800000000002,1347.26]
[25,"-  29",{"$f":"C7*$L$2","v":9168.4700000000012},5565.5300000000007,4039.6600000000003,2838.15,1933.97,1486.1200000000001]
[30,"-  34",{"$f":"C8*$L$2","v":9569.68},5822.05,4329.04,3157.21,2350.5500000000002,1797.76]
[35,"-  39",{"$f":"C9*$L$2","v":10695.93},6513.7000000000007,4839.43,3545.7000000000003,2625.6200000000003,2004.99]
[40,"-  44",{"$f":"C10*$L$2","v":12114.74},7566.2800000000007,5312.1900000000005,3936.84,2901.75,2210.63]
[45,"-  49",{"$f":"C11*$L$2","v":13534.08},8441.3100000000013,5930.7000000000007,4396.3500000000004,3247.31,2487.29]
[50,"-  54",{"$f":"C12*$L$2","v":17863.120000000003},11022.94,7822.8,5780.18,4628.49,3558.9500000000003]
[55,"-  59",{"$f":"C13*$L$2","v":18989.900000000001},11750.1,8331.07,6169.7300000000005,4938.01,3765.1200000000003]
[60,null,{"$f":"C14*$L$2","v":20154.310000000001},12769.820000000002,9059.82,7020.38,5870.81,4730.7800000000007]
[61,null,{"$f":"C15*$L$2","v":21645.73},13714.810000000001,9715.43,7516.9900000000007,6320.25,5077.4000000000005]
[62,null,{"$f":"C16*$L$2","v":23683.050000000003},15024.44,10623.85,8226.66,6905.3700000000008,5559.17]
[63,null,{"$f":"C17*$L$2","v":25175},15970.490000000002,11313.91,8758.7800000000007,7356.4000000000005,5904.7300000000005]
[64,null,{"$f":"C18*$L$2","v":27248.36},17280.120000000003,12224.45,9468.4500000000007,7943.1100000000006,6389.1500000000005]
[65,null,{"$f":"C19*$L$2","v":28555.870000000003},22592.31,15970.490000000002,11984.36,10601.59,9012.1200000000008]
[66,null,{"$f":"C20*$L$2","v":29829.99},26265.210000000003,18554.240000000002,13933.17,12328.33,10462.200000000001]
[67,null,{"$f":"C21*$L$2","v":32595},28666.640000000003,20264.02,15208.880000000001,13467.300000000001,11429.980000000001]
[68,null,{"$f":"C22*$L$2","v":36050.6},31758.13,22445.5,16840.75,14916.85,12672.83]
[69,null,{"$f":"C23*$L$2","v":39650.36},34923.82,24665.670000000002,18543.11,16401.38,13914.62]
[70,null,{"$f":"C24*$L$2","v":46928.32},42998.37,30047.82,21803.14,19094.84,16366.93]
[71,null,{"$f":"C25*$L$2","v":48783.850000000006},44672.11,31213.820000000003,22655.91,19854.86,17023.600000000002]
[72,null,{"$f":"C26*$L$2","v":50165.560000000005},45945.170000000006,32122.240000000002,23293.5,20406.59,17506.96]
[73,null,{"$f":"C27*$L$2","v":51983.990000000005},47618.91,33287.18,24145.74,21165.55,18162.57]
[74,null,{"$f":"C28*$L$2","v":52928.98},48492.350000000006,33868.590000000004,24605.780000000002,21546.09,18473.68]
[75,"o más",{"$f":"C29*$L$2","v":55222.29},50601.75,35358.950000000004,25667.370000000003,22478.89,19267.09]
[1,"Hijo",{"$f":"C30*$L$2","v":2947.33},1857.1200000000001,1346.73,1030.3200000000002,864.43000000000006,622.22]
[2,"Hijos",{"$f":"C31*$L$2","v":4620.54},2947.33,2147.0300000000002,1632.93,1347.26,1003.2900000000001]
[3,"Hijos o más",{"$f":"C32*$L$2","v":6731.5300000000007},4292.47,3129.65,2413.09,1968.42,1452.73]
[1,"Rider Comp. Maternidad",{"$f":"+C33*$L$2","v":0},0,0,119.25,119.25,119.25]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["DIAMOND (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","DL1","DL2","DL3","DL4","DL5","DL6"]
[18,"-  24",4794,2952,1949,1401,993,779]
[25,"-  29",5028,3097,2156,1553,1103,867]
[30,"-  34",5200,3223,2312,1743,1322,1041]
[35,"-  39",5816,3609,2590,1951,1483,1168]
[40,"-  44",6733,4186,2831,2168,1630,1284]
[45,"-  49",7517,4680,3168,2425,1824,1436]
[50,"-  54",9772,5991,4158,3164,2578,2033]
[55,"-  59",10394,6374,4426,3365,2744,2164]
[60,null,11056,6945,4828,3871,3307,2688]
[61,null,11876,7463,5187,4159,3555,2886]
[62,null,12994,8172,5684,4557,3892,3162]
[63,null,13812,8687,6042,4844,4139,3362]
[64,null,14936,9396,6539,5242,4475,3639]
[65,null,15651,12288,8530,6629,5974,5139]
[66,null,16363,14275,9911,7703,6942,5968]
[67,null,17867,15595,10826,8416,7581,6521]
[68,null,19780,17268,11986,9320,8398,7220]
[69,null,21758,18999,13190,10254,9240,7945]
[70,null,25748,23384,16061,12071,10768,9345]
[71,null,26759,24303,16691,12545,11190,9716]
[72,null,27512,24990,17164,12900,11507,9987]
[73,null,28525,25911,17793,13375,11931,10356]
[74,null,29026,26368,18111,13609,12143,10540]
[75,"o más",30287,27515,18898,14204,12670,11001]
[1,"Hijo",1660,1027,758,629,527,413]
[2,"Hijos",2608,1634,1204,999,841,656]
[3,"Hijos o más",3798,2395,1766,1465,1234,961]
[1,"Rider Comp. Maternidad",0,0,0,225,225,225]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","DL1","DL2","DL3","DL4","DL5","DL6"]
[18,"-  24",{"$f":"+C73*$L$2","v":2540.8200000000002},1564.5600000000002,1032.97,742.53000000000009,526.29000000000008,412.87]
[25,"-  29",2664.84,1641.41,1142.68,823.09,584.59,459.51000000000005]
[30,"-  34",2756,1708.19,1225.3600000000001,923.79000000000008,700.66000000000008,551.73]
[35,"-  39",3082.48,1912.7700000000002,1372.7,1034.03,785.99,619.04000000000008]
[40,"-  44",3568.4900000000002,2218.58,1500.43,1149.04,863.90000000000009,680.52]
[45,"-  49",3984.01,2480.4,1679.0400000000002,1285.25,966.72,761.08]
[50,"-  54",5179.16,3175.23,2203.7400000000002,1676.92,1366.3400000000001,1077.49]
[55,"-  59",5508.8200000000006,3378.2200000000003,2345.7800000000002,1783.45,1454.3200000000002,1146.92]
[60,null,5859.68,3680.8500000000004,2558.84,2051.63,1752.71,1424.64]
[61,null,6294.2800000000007,3955.3900000000003,2749.11,2204.27,1884.15,1529.5800000000002]
[62,null,{"$f":"+C83*$L$2","v":6886.8200000000006},4331.16,3012.52,2415.21,2062.7600000000002,1675.8600000000001]
[63,null,7320.3600000000006,4604.1100000000006,3202.26,2567.3200000000002,2193.67,1781.8600000000001]
[64,null,7916.0800000000008,4979.88,3465.67,2778.26,2371.75,1928.67]
[65,null,8295.0300000000007,6512.64,4520.9000000000005,3513.3700000000003,3166.2200000000003,2723.67]
[66,null,8672.3900000000012,7565.75,5252.83,4082.59,3679.26,3163.04]
[67,null,9469.51,8265.35,5737.7800000000007,4460.4800000000005,4017.9300000000003,3456.13]
[68,null,10483.4,9152.0400000000009,6352.58,4939.6000000000004,4450.9400000000005,3826.6000000000004]
[69,null,11531.74,10069.470000000001,6990.7000000000007,5434.62,4897.2,4210.8500000000004]
[70,null,13646.44,12393.52,8512.33,6397.63,5707.04,4952.8500000000004]
[71,null,14182.27,12880.59,8846.23,6648.85,5930.7000000000007,5149.4800000000005]
[72,null,{"$f":"+C93*$L$2","v":14581.36},13244.7,9096.92,6837,6098.71,5293.1100000000006]
[73,null,15118.25,13732.83,9430.2900000000009,7088.75,6323.43,5488.68]
[74,null,15383.78,13975.04,9598.83,7212.77,6435.79,5586.2000000000007]
[75,"o más",16052.11,14582.95,10015.94,7528.1200000000008,6715.1,5830.5300000000007]
[1,"Hijo",879.80000000000007,544.31000000000006,401.74,333.37,279.31,218.89000000000001]
[2,"Hijos",1382.24,866.0200000000001,638.12,529.47,445.73,347.68]
[3,"Hijos o más",2012.94,1269.3500000000001,935.98,776.45,654.02,509.33000000000004]
[1,"Rider Comp. Maternidad",0,0,0,119.25,119.25,119.25]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["BUPA SECURE GUATEMALA"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","CW1","CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",5810,4901,3837,2861,2432,1822,null,true,true,true,true,true,true]
[25,"-  29",6446,5382,4317,3220,2685,2026,null,true,true,true,true,true,true]
[30,"-  34",7409,6182,5063,3741,3138,2382,null,true,true,true,true,true,true]
[35,"-  39",8205,6822,5702,4159,3493,2630,null,true,true,true,true,true,true]
[40,"-  44",9272,7618,6502,4679,3949,2988,null,true,true,true,true,true,true]
[45,"-  49",10762,8793,7618,5456,4608,3443,null,true,true,true,true,true,true]
[50,"-  54",11774,9593,8367,5977,5013,3798,null,true,true,true,true,true,true]
[55,"-  59",13853,11295,10014,7066,5974,4457,null,true,true,true,true,true,true]
[60,null,14652,11829,10709,7481,6330,4709,null,true,true,true,true,true,true]
[61,null,16463,13320,12041,8470,7088,5316,null,true,true,true,true,true,true]
[62,null,18327,14810,13373,9405,7898,5923,null,true,true,true,true,true,true]
[63,null,20138,16252,14705,10339,8708,6529,null,true,true,true,true,true,true]
[64,null,22002,17741,16089,11272,9514,7138,null,true,true,true,true,true,true]
[65,null,22059,17795,16196,11378,9569,7138,null,true,true,true,true,true,true]
[66,null,22162,17795,16356,11428,9618,7138,null,true,true,true,true,true,true]
[67,null,24610,19764,18220,12675,10679,7949,null,true,true,true,true,true,true]
[68,null,27064,21735,20031,13973,11744,8760,null,true,true,true,true,true,true]
[69,null,28343,22748,20938,14599,12300,9164,null,true,true,true,true,true,true]
[70,null,28502,22802,21258,14754,12399,9212,null,true,true,true,true,true,true]
[71,null,32123,25628,23975,16622,13970,10379,null,true,true,true,true,true,true]
[72,null,35694,28502,26639,18439,15487,11540,null,true,true,true,true,true,true]
[73,null,39263,31380,29300,20312,17056,12705,null,true,true,true,true,true,true]
[74,null,42831,34203,31965,22179,18624,13870,null,true,true,true,true,true,true]
[75,"o más",46773,37293,35056,24257,20346,15135,null,true,true,true,true,true,true]
[1,"Hijo",2612,2344,1388,1145,964,712,null,true,true,true,true,true,true]
[2,"Hijos",4317,3998,2082,1820,1520,1115,null,true,true,true,true,true,true]
[3,"Hijos o más",6288,5860,2986,2651,2227,1673,null,true,true,true,true,true,true]
[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":3079.3},{"$f":"D140*$L$2","v":2597.5300000000002},2033.6100000000001,1516.3300000000002,1288.96,965.66000000000008]
[25,"-  29",{"$f":"C141*$L$2","v":3416.38},2852.46,2288.0100000000002,1706.6000000000001,1423.0500000000002,1073.78]
[30,"-  34",{"$f":"C142*$L$2","v":3926.77},3276.46,2683.3900000000003,1982.73,1663.14,1262.46]
[35,"-  39",{"$f":"C143*$L$2","v":4348.6500000000005},3615.6600000000003,3022.06,2204.27,1851.2900000000002,1393.9]
[40,"-  44",{"$f":"C144*$L$2","v":4914.16},4037.5400000000004,3446.0600000000004,2479.8700000000003,2092.9700000000003,1583.64]
[45,"-  49",{"$f":"C145*$L$2","v":5703.8600000000006},4660.29,4037.5400000000004,2891.6800000000003,2442.2400000000002,1824.7900000000002]
[50,"-  54",{"$f":"C146*$L$2","v":6240.22},5084.29,4434.51,3167.81,2656.8900000000003,2012.94]
[55,"-  59",{"$f":"C147*$L$2","v":7342.09},5986.35,5307.42,3744.98,3166.2200000000003,2362.21]
[60,null,{"$f":"C148*$L$2","v":7765.56},6269.37,5675.77,3964.9300000000003,3354.9,2495.77]
[61,null,{"$f":"C149*$L$2","v":8725.3900000000012},7059.6,6381.7300000000005,4489.1000000000004,3756.6400000000003,2817.48]
[62,null,{"$f":"C150*$L$2","v":9713.3100000000013},7849.3,7087.6900000000005,4984.6500000000005,4185.9400000000005,3139.19]
[63,null,{"$f":"C151*$L$2","v":10673.140000000001},8613.5600000000013,7793.6500000000005,5479.67,4615.24,3460.3700000000003]
[64,null,{"$f":"C152*$L$2","v":11661.060000000001},9402.73,8527.17,5974.16,5042.42,3783.1400000000003]
[65,null,{"$f":"C153*$L$2","v":11691.27},9431.35,8583.880000000001,6030.34,5071.5700000000006,3783.1400000000003]
[66,null,{"$f":"C154*$L$2","v":11745.86},9431.35,8668.68,6056.84,5097.54,3783.1400000000003]
[67,null,{"$f":"C155*$L$2","v":13043.300000000001},10474.92,9656.6,6717.75,5659.87,4212.97]
[68,null,{"$f":"C156*$L$2","v":14343.92},11519.550000000001,10616.43,7405.6900000000005,6224.3200000000006,4642.8]
[69,null,{"$f":"C157*$L$2","v":15021.79},12056.44,11097.140000000001,7737.47,6519,4856.92]
[70,null,{"$f":"C158*$L$2","v":15106.060000000001},12085.060000000001,11266.74,7819.6200000000008,6571.47,4882.3600000000006]
[71,null,{"$f":"C159*$L$2","v":17025.190000000002},13582.84,12706.75,8809.66,7404.1,5500.87]
[72,null,{"$f":"C160*$L$2","v":18917.82},15106.060000000001,14118.67,9772.67,8208.11,6116.2000000000007]
[73,null,{"$f":"C161*$L$2","v":20809.39},16631.400000000001,15529,10765.36,9039.68,6733.6500000000005]
[74,null,{"$f":"C162*$L$2","v":22700.43},18127.59,16941.45,11754.87,9870.7200000000012,7351.1]
[75,"o más",{"$f":"C163*$L$2","v":24789.690000000002},19765.29,18579.68,12856.210000000001,10783.380000000001,8021.55]
[1,"Hijo",{"$f":"C164*$L$2","v":1384.3600000000001},1242.3200000000002,735.64,606.85,510.92,377.36]
[2,"Hijos",{"$f":"C165*$L$2","v":2288.0100000000002},2118.94,1103.46,964.6,805.6,590.95000000000005]
[3,"Hijos o más",{"$f":"C166*$L$2","v":3332.6400000000003},3105.8,1582.5800000000002,1405.03,1180.3100000000002,886.69]
[1,"Rider Comp. Maternidad",{"$f":"+C167*$L$2","v":0},119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["COMPLETE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","CL1","CL2","CL3","CL4","CL5","CL6"]
[18,"-  24",4108,2493,1711,1222,864,656]
[25,"-  29",4312,2617,1893,1355,958,727]
[30,"-  34",4497,2733,2028,1520,1162,884]
[35,"-  39",5030,3059,2271,1704,1304,991]
[40,"-  44",5699,3544,2490,1897,1437,1095]
[45,"-  49",6362,3962,2784,2121,1606,1226]
[50,"-  54",8400,5181,3675,2788,2297,1752]
[55,"-  59",8934,5515,3910,2965,2444,1865]
[60,null,9484,6004,4246,3377,2908,2333]
[61,null,10185,6452,4562,3627,3125,2507]
[62,null,11146,7062,4997,3973,3422,2746]
[63,null,11845,7510,5314,4224,3639,2920]
[64,null,12809,8124,5749,4572,3937,3161]
[65,null,13423,10620,7502,5783,5253,4458]
[66,null,14033,12341,8716,6718,6105,5183]
[67,null,15322,13481,9521,7338,6668,5662]
[68,null,16961,14927,10543,8127,7387,6271]
[69,null,18656,16424,11600,8941,8127,6900]
[70,null,22081,20216,14125,10526,9470,8117]
[71,null,22943,21009,14681,10940,9844,8436]
[72,null,23592,21603,15097,11250,10123,8676]
[73,null,24457,22398,15651,11665,10493,8996]
[74,null,24890,22795,15928,11869,10680,9155]
[75,"o más",25970,23787,16621,12385,11147,9552]
[1,"Hijo",1395,867,632,499,421,313]
[2,"Hijos",2187,1379,1009,795,669,498]
[3,"Hijos o más",3179,2023,1479,1166,983,727]
[1,"Rider Comp. Maternidad",0,0,0,225,225,225]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","CL1","CL2","CL3","CL4","CL5","CL6"]
[18,"-  24",{"$f":"+C207*$L$2","v":2177.2400000000002},1321.29,906.83,647.66000000000008,457.92,347.68]
[25,"-  29",2285.36,1387.01,1003.2900000000001,718.15000000000009,507.74,385.31]
[30,"-  34",2383.4100000000003,1448.49,1074.8400000000001,805.6,615.86,468.52000000000004]
[35,"-  39",2665.9,1621.27,1203.6300000000001,903.12,691.12,525.23]
[40,"-  44",3020.4700000000003,1878.3200000000002,1319.7,1005.4100000000001,761.61,580.35]
[45,"-  49",3371.86,2099.86,1475.52,1124.1300000000001,851.18000000000006,649.78000000000009]
[50,"-  54",4452,2745.9300000000003,1947.75,1477.64,1217.4100000000001,928.56000000000006]
[55,"-  59",4735.0200000000004,2922.9500000000003,2072.3000000000002,1571.45,1295.3200000000002,988.45]
[60,null,5026.5200000000004,3182.1200000000003,2250.38,1789.8100000000002,1541.24,1236.49]
[61,null,5398.05,3419.56,2417.86,1922.3100000000002,1656.25,1328.71]
[62,null,{"$f":"+C217*$L$2","v":5907.38},3742.86,2648.4100000000003,2105.69,1813.66,1455.38]
[63,null,6277.85,3980.3,2816.42,2238.7200000000003,1928.67,1547.6000000000001]
[64,null,6788.77,4305.72,3046.9700000000003,2423.1600000000003,2086.61,1675.3300000000002]
[65,null,7114.1900000000005,5628.6,3976.0600000000004,3064.9900000000002,2784.09,2362.7400000000002]
[66,null,7437.4900000000007,6540.7300000000005,4619.4800000000005,3560.54,3235.65,2746.9900000000002]
[67,null,8120.6600000000008,7144.93,5046.13,3889.1400000000003,3534.04,3000.86]
[68,null,8989.33,7911.31,5587.79,4307.3100000000004,3915.11,3323.63]
[69,null,9887.68,8704.7200000000012,6148,4738.7300000000005,4307.3100000000004,3657]
[70,null,11702.93,10714.480000000001,7486.25,5578.7800000000007,5019.1000000000004,4302.01]
[71,null,12159.79,11134.77,7780.93,5798.2000000000007,5217.3200000000006,4471.08]
[72,null,{"$f":"+C227*$L$2","v":12503.76},11449.59,8001.4100000000008,5962.5,5365.1900000000005,4598.2800000000007]
[73,null,12962.210000000001,11870.94,8295.0300000000007,6182.4500000000007,5561.29,4767.88]
[74,null,13191.7,12081.35,8441.84,6290.5700000000006,5660.4000000000005,4852.1500000000005]
[75,"o más",13764.1,12607.11,8809.130000000001,6564.05,5907.91,5062.5600000000004]
[1,"Hijo",739.35,459.51000000000005,334.96000000000004,264.47000000000003,223.13000000000002,165.89000000000001]
[2,"Hijos",1159.1100000000001,730.87,534.77,421.35,354.57,263.94]
[3,"Hijos o más",1684.8700000000001,1072.19,783.87,617.98,520.99,385.31]
[1,"Rider Comp. Maternidad",0,0,0,119.25,119.25,119.25]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["PREMIUM GUATEMALA"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,{"$f":"J274*$L$6","v":1},5138,3830,2777,2084,1641,null,true,true,true,true,true]
[19,null,{"$f":"J275*$L$6","v":1},5183,3877,2823,2127,1686,null,true,true,true,true,true]
[20,null,1,5275,3970,2869,2174,1730,null,true,true,true,true,true]
[21,null,1,5369,4063,2961,2174,1730,null,true,true,true,true,true]
[22,null,1,5462,4108,3004,2218,1775,null,true,true,true,true,true]
[23,null,1,5603,4204,3049,2261,1819,null,true,true,true,true,true]
[24,null,1,5695,4297,3095,2305,1819,null,true,true,true,true,true]
[25,null,1,5787,4343,3140,2349,1862,null,true,true,true,true,true]
[26,null,1,5884,4435,3232,2395,1909,null,true,true,true,true,true]
[27,null,1,5977,4528,3277,2438,1952,null,true,true,true,true,true]
[28,null,1,6069,4624,3369,2526,1952,null,true,true,true,true,true]
[29,null,1,6210,4716,3413,2572,1995,null,true,true,true,true,true]
[30,null,1,6350,4856,3502,2616,2039,null,true,true,true,true,true]
[31,null,1,6442,4949,3597,2704,2084,null,true,true,true,true,true]
[32,null,1,6584,5041,3689,2749,2127,null,true,true,true,true,true]
[33,null,1,6723,5183,3778,2836,2174,null,true,true,true,true,true]
[34,null,1,6908,5322,3913,2926,2218,null,true,true,true,true,true]
[35,null,1,7049,5462,4050,3014,2261,null,true,true,true,true,true]
[36,null,1,7235,5603,4142,3104,2305,null,true,true,true,true,true]
[37,null,1,7377,5742,4278,3191,2349,null,true,true,true,true,true]
[38,null,1,7564,5884,4413,3281,2438,null,true,true,true,true,true]
[39,null,1,7748,6069,4551,3369,2482,null,true,true,true,true,true]
[40,null,1,7938,6257,4689,3503,2526,null,true,true,true,true,true]
[41,null,1,8170,6397,4870,3592,2572,null,true,true,true,true,true]
[42,null,1,8358,6584,5008,3724,2662,null,true,true,true,true,true]
[43,null,1,8587,6769,5187,3857,2704,null,true,true,true,true,true]
[44,null,1,8821,7004,5370,3990,2794,null,true,true,true,true,true]
[45,null,1,9059,7191,5550,4122,2836,null,true,true,true,true,true]
[46,null,1,9289,7424,5734,4253,2926,null,true,true,true,true,true]
[47,null,1,9522,7611,5961,4389,2970,null,true,true,true,true,true]
[48,null,1,9805,7890,6189,4567,3058,null,true,true,true,true,true]
[49,null,1,10130,8170,6461,4743,3148,null,true,true,true,true,true]
[50,null,1,10455,8450,6733,4920,3235,null,true,true,true,true,true]
[51,null,1,10736,8729,7009,5096,3324,null,true,true,true,true,true]
[52,null,1,11063,9059,7235,5275,3411,null,true,true,true,true,true]
[53,null,1,11437,9384,7596,5541,3503,null,true,true,true,true,true]
[54,null,1,11857,9754,7917,5761,3635,null,true,true,true,true,true]
[55,null,1,12230,10130,8279,5981,3724,null,true,true,true,true,true]
[56,null,1,12605,10455,8597,6249,3857,null,true,true,true,true,true]
[57,null,1,13024,10832,8964,6466,3944,null,true,true,true,true,true]
[58,null,1,13537,11297,9418,6781,4078,null,true,true,true,true,true]
[59,null,1,14050,11764,9872,7090,4209,null,true,true,true,true,true]
[60,null,1,14517,12230,10327,7398,4343,null,true,true,true,true,true]
[61,null,1,15219,12884,10919,7842,4567,null,true,true,true,true,true]
[62,null,1,16150,13770,11828,8418,4785,null,true,true,true,true,true]
[63,null,1,17502,15029,13012,9307,5141,null,true,true,true,true,true]
[64,null,1,19373,16758,14647,10500,5673,null,true,true,true,true,true]
[65,null,1,21751,19089,16742,12051,6381,null,true,true,true,true,true]
[66,null,1,24690,21940,19243,13956,7266,null,true,true,true,true,true]
[67,null,1,27957,25111,22061,16083,8330,null,true,true,true,true,true]
[68,null,1,31458,28612,25111,18340,9438,null,true,true,true,true,true]
[69,null,1,35146,32298,28248,20778,10681,null,true,true,true,true,true]
[70,null,1,38974,36080,31524,23257,11918,null,true,true,true,true,true]
[71,null,1,42891,39999,34889,25829,13203,null,true,true,true,true,true]
[72,null,1,46953,44013,38345,28443,14575,null,true,true,true,true,true]
[73,null,1,51059,48121,41894,31144,15949,null,true,true,true,true,true]
[74,null,1,55260,52319,45488,33889,17321,null,true,true,true,true,true]
[75,null,1,59556,56615,49126,36679,18784,null,true,true,true,true,true]
[76,null,{"$error":"#N/A"},59556,56615,49126,36679,18784,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[77,null,{"$error":"#N/A"},59556,56615,49126,36679,18784,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[78,null,{"$error":"#N/A"},59556,56615,49126,36679,18784,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[79,null,{"$error":"#N/A"},59556,56615,49126,36679,18784,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[80,"o mas",{"$error":"#N/A"},59556,56615,49126,36679,18784,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[1,"Hijo",1,2382,1729,1276,1110,800,null,true,true,true,true,true]
[2,"Hijos",1,3924,2710,2004,1730,1152,null,true,true,true,true,true]
[3,"Hijos o más",{"$f":"J339*$L$6","v":1},5742,3924,2961,2526,1775,null,true,true,true,true,true]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[null,"Deductible Waiver",null,180,345,775,1330,2080]
["TARIFAS SEMESTRALES "]
["EDAD",null,null,null,null,null,null,null,"NO HAY"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,{"$f":"C274*$L$2","v":0.53},{"$f":"D274*$L$2","v":2723.1400000000003},2029.9,1471.8100000000002,1104.52,869.73]
[19,null,{"$f":"C275*$L$2","v":0.53},2746.9900000000002,2054.81,1496.19,1127.31,893.58]
[20,null,{"$f":"C276*$L$2","v":0.53},2795.75,2104.1,1520.5700000000002,1152.22,916.90000000000009]
[21,null,{"$f":"C277*$L$2","v":0.53},2845.57,2153.3900000000003,1569.3300000000002,1152.22,916.90000000000009]
[22,null,{"$f":"C278*$L$2","v":0.53},2894.86,2177.2400000000002,1592.1200000000001,1175.54,940.75]
[23,null,{"$f":"C279*$L$2","v":0.53},2969.59,2228.12,1615.97,1198.3300000000002,964.07]
[24,null,{"$f":"C280*$L$2","v":0.53},3018.3500000000004,2277.4100000000003,1640.3500000000001,1221.6500000000001,964.07]
[25,null,{"$f":"C281*$L$2","v":0.53},3067.11,2301.79,1664.2,1244.97,986.86]
[26,null,{"$f":"C282*$L$2","v":0.53},3118.52,2350.5500000000002,1712.96,1269.3500000000001,1011.7700000000001]
[27,null,{"$f":"C283*$L$2","v":0.53},3167.81,2399.84,1736.8100000000002,1292.1400000000001,1034.56]
[28,null,{"$f":"C284*$L$2","v":0.53},3216.57,2450.7200000000003,1785.5700000000002,1338.78,1034.56]
[29,null,{"$f":"C285*$L$2","v":0.53},3291.3,2499.48,1808.89,1363.16,1057.3500000000001]
[30,null,{"$f":"C286*$L$2","v":0.53},3365.5,2573.6800000000003,1856.0600000000002,1386.48,1080.67]
[31,null,{"$f":"C287*$L$2","v":0.53},3414.26,2622.9700000000003,1906.41,1433.1200000000001,1104.52]
[32,null,{"$f":"C288*$L$2","v":0.53},3489.52,2671.73,1955.17,1456.97,1127.31]
[33,null,{"$f":"C289*$L$2","v":0.53},3563.19,2746.9900000000002,2002.3400000000001,1503.0800000000002,1152.22]
[34,null,{"$f":"C290*$L$2","v":0.53},3661.2400000000002,2820.6600000000003,2073.8900000000003,1550.78,1175.54]
[35,null,{"$f":"C291*$L$2","v":0.53},3735.9700000000003,2894.86,2146.5,1597.42,1198.3300000000002]
[36,null,{"$f":"C292*$L$2","v":0.53},3834.55,2969.59,2195.2600000000002,1645.1200000000001,1221.6500000000001]
[37,null,{"$f":"C293*$L$2","v":0.53},3909.8100000000004,3043.26,2267.34,1691.23,1244.97]
[38,null,{"$f":"C294*$L$2","v":0.53},4008.92,3118.52,2338.8900000000003,1738.93,1292.1400000000001]
[39,null,{"$f":"C295*$L$2","v":0.53},4106.4400000000005,3216.57,2412.0300000000002,1785.5700000000002,1315.46]
[40,null,{"$f":"C296*$L$2","v":0.53},4207.1400000000003,3316.21,2485.17,1856.5900000000001,1338.78]
[41,null,{"$f":"C297*$L$2","v":0.53},4330.1000000000004,3390.4100000000003,2581.1,1903.76,1363.16]
[42,null,{"$f":"C298*$L$2","v":0.53},4429.74,3489.52,2654.2400000000002,1973.72,1410.8600000000001]
[43,null,{"$f":"C299*$L$2","v":0.53},4551.1100000000006,3587.57,2749.11,2044.21,1433.1200000000001]
[44,null,{"$f":"C300*$L$2","v":0.53},4675.13,3712.1200000000003,2846.1000000000004,2114.7000000000003,1480.8200000000002]
[45,null,{"$f":"C301*$L$2","v":0.53},4801.2700000000004,3811.23,2941.5,2184.6600000000003,1503.0800000000002]
[46,null,{"$f":"C302*$L$2","v":0.53},4923.17,3934.7200000000003,3039.02,2254.09,1550.78]
[47,null,{"$f":"C303*$L$2","v":0.53},5046.66,4033.8300000000004,3159.3300000000004,2326.17,1574.1000000000001]
[48,null,{"$f":"C304*$L$2","v":0.53},5196.6500000000005,4181.7,3280.17,2420.5100000000002,1620.74]
[49,null,{"$f":"C305*$L$2","v":0.53},5368.9000000000005,4330.1000000000004,3424.3300000000004,2513.79,1668.44]
[50,null,{"$f":"C306*$L$2","v":0.53},5541.1500000000005,4478.5,3568.4900000000002,2607.6,1714.5500000000002]
[51,null,{"$f":"C307*$L$2","v":0.53},5690.08,4626.37,3714.77,2700.88,1761.72]
[52,null,{"$f":"C308*$L$2","v":0.53},5863.39,4801.2700000000004,3834.55,2795.75,1807.8300000000002]
[53,null,{"$f":"C309*$L$2","v":0.53},6061.6100000000006,4973.5200000000004,4025.88,2936.73,1856.5900000000001]
[54,null,{"$f":"C310*$L$2","v":0.53},6284.21,5169.62,4196.01,3053.33,1926.5500000000002]
[55,null,{"$f":"C311*$L$2","v":0.53},6481.9000000000005,5368.9000000000005,4387.87,3169.9300000000003,1973.72]
[56,null,{"$f":"C312*$L$2","v":0.53},6680.6500000000005,5541.1500000000005,4556.41,3311.9700000000003,2044.21]
[57,null,{"$f":"C313*$L$2","v":0.53},6902.72,5740.96,4750.92,3426.98,2090.3200000000002]
[58,null,{"$f":"C314*$L$2","v":0.53},7174.6100000000006,5987.41,4991.54,3593.9300000000003,2161.34]
[59,null,{"$f":"C315*$L$2","v":0.53},7446.5,6234.92,5232.16,3757.7000000000003,2230.77]
[60,null,{"$f":"C316*$L$2","v":0.53},7694.01,6481.9000000000005,5473.31,3920.94,2301.79]
[61,null,{"$f":"C317*$L$2","v":0.53},8066.0700000000006,6828.52,5787.0700000000006,4156.26,2420.5100000000002]
[62,null,{"$f":"C318*$L$2","v":0.53},8559.5,7298.1,6268.84,4461.54,2536.0500000000002]
[63,null,{"$f":"C319*$L$2","v":0.53},9276.0600000000013,7965.3700000000008,6896.3600000000006,4932.71,2724.73]
[64,null,{"$f":"C320*$L$2","v":0.53},10267.69,8881.74,7762.9100000000008,5565,3006.69]
[65,null,{"$f":"C321*$L$2","v":0.53},11528.03,10117.17,8873.26,6387.0300000000007,3381.9300000000003]
[66,null,{"$f":"C322*$L$2","v":0.53},13085.7,11628.2,10198.790000000001,7396.68,3850.98]
[67,null,{"$f":"C323*$L$2","v":0.53},14817.210000000001,13308.83,11692.33,8523.99,4414.9000000000005]
[68,null,{"$f":"C324*$L$2","v":0.53},16672.740000000002,15164.36,13308.83,9720.2000000000007,5002.1400000000003]
[69,null,{"$f":"C325*$L$2","v":0.53},18627.38,17117.940000000002,14971.44,11012.34,5660.93]
[70,null,{"$f":"C326*$L$2","v":0.53},20656.22,19122.400000000001,16707.72,12326.210000000001,6316.54]
[71,null,{"$f":"C327*$L$2","v":0.53},22732.23,21199.47,18491.170000000002,13689.37,6997.59]
[72,null,{"$f":"C328*$L$2","v":0.53},24885.09,23326.89,20322.850000000002,15074.79,7724.75]
[73,null,{"$f":"C329*$L$2","v":0.53},27061.27,25504.13,22203.82,16506.32,8452.9700000000012]
[74,null,{"$f":"C330*$L$2","v":0.53},29287.800000000003,27729.07,24108.639999999999,17961.170000000002,9180.130000000001]
[75,null,{"$f":"C331*$L$2","v":0.53},31564.68,30005.95,26036.780000000002,19439.870000000003,9955.52]
[76,null,{"$f":"C332*$L$2","v":{"$error":"#N/A"}},31564.68,30005.95,26036.780000000002,19439.870000000003,9955.52]
[77,null,{"$f":"C333*$L$2","v":{"$error":"#N/A"}},31564.68,30005.95,26036.780000000002,19439.870000000003,9955.52]
[78,null,{"$f":"C334*$L$2","v":{"$error":"#N/A"}},31564.68,30005.95,26036.780000000002,19439.870000000003,9955.52]
[79,null,{"$f":"C335*$L$2","v":{"$error":"#N/A"}},31564.68,30005.95,26036.780000000002,19439.870000000003,9955.52]
[80,"o mas",{"$f":"C336*$L$2","v":{"$error":"#N/A"}},31564.68,30005.95,26036.780000000002,19439.870000000003,9955.52]
[1,"Hijo",{"$f":"C337*$L$2","v":0.53},1262.46,916.37,676.28000000000009,588.30000000000007,424]
[2,"Hijos",{"$f":"C338*$L$2","v":0.53},2079.7200000000003,1436.3000000000002,1062.1200000000001,916.90000000000009,610.56000000000006]
[3,"Hijos o más",{"$f":"C339*$L$2","v":0.53},3043.26,2079.7200000000003,1569.3300000000002,1338.78,940.75]
[1,"Rider Comp. Maternidad",{"$f":"+C340*$L$2","v":0},119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",0,159,159,159,159,159]
[null,"Deductible Waiver",null,{"$f":"+D342*$L$2","v":95.4},{"$f":"+E342*$L$2","v":182.85000000000002},{"$f":"+F342*$L$2","v":410.75},{"$f":"+G342*$L$2","v":704.90000000000009},{"$f":"+H342*$L$2","v":1102.4000000000001}]
[]
["ADVANTAGE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","AL1","AL2","AL3","AL4","AL5","AL6"]
[18,"-  24",2323,3529,2653,2029,1555,1231]
[25,"-  29",2595,3931,2960,2256,1736,1363]
[30,"-  34",3035,4550,3480,2690,2059,1587]
[35,"-  39",3425,5045,3876,2993,2348,1760]
[40,"-  44",3878,5694,4395,3396,2625,1992]
[45,"-  49",4483,6617,5063,3827,2988,2317]
[50,"-  54",5074,7252,5692,4463,3354,2545]
[55,"-  59",5880,8569,6573,4936,3891,3010]
[60,null,6256,9468,7278,5429,4290,3333]
[61,null,7042,10658,8188,6113,4832,3756]
[62,null,7827,11845,9109,6796,5373,4175]
[63,null,8613,13033,10021,7480,5914,4598]
[64,null,9397,14223,10937,8165,6457,5014]
[65,null,10323,15378,11902,8897,7032,5708]
[66,null,10933,16284,12602,9424,7448,6051]
[67,null,12149,18099,14009,10474,8283,6725]
[68,null,13367,19911,15411,11526,9115,7400]
[69,null,13974,20818,16114,12048,9529,7741]
[70,null,14272,21084,16371,12234,9708,7843]
[71,null,16060,23726,18422,13767,10928,8825]
[72,null,17843,26369,20478,15303,12144,9810]
[73,null,19631,29008,22530,16836,13363,10795]
[74,null,21416,31650,24579,18368,14581,11779]
[75,"o más",23387,34622,27408,21070,15964,13516]
[1,"Hijo",960,1572,1121,886,784,569]
[2,"Hijos",1478,2567,1768,1402,1246,837]
[3,"Hijos o más",2155,3757,2580,2048,1803,1269]
[1,"Rider Comp. Maternidad",225,225,225,225,225,225]
[1,"Transplante de organos",250,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","AL1","AL2","AL3","AL4","AL5","AL6"]
[18,"-  24",{"$f":"+C420*$L$2","v":1231.19},1870.3700000000001,1406.0900000000001,1075.3700000000001,824.15000000000009,652.43000000000006]
[25,"-  29",1375.3500000000001,2083.4300000000003,1568.8000000000002,1195.68,920.08,722.39]
[30,"-  34",1608.5500000000002,2411.5,1844.4,1425.7,1091.27,841.11]
[35,"-  39",1815.25,2673.85,2054.2800000000002,1586.2900000000002,1244.44,932.80000000000007]
[40,"-  44",2055.34,3017.82,2329.35,1799.88,1391.25,1055.76]
[45,"-  49",2375.9900000000002,3507.01,2683.3900000000003,2028.3100000000002,1583.64,1228.01]
[50,"-  54",2689.2200000000003,3843.5600000000004,3016.76,2365.3900000000003,1777.6200000000001,1348.8500000000001]
[55,"-  59",3116.4,4541.5700000000006,3483.69,2616.08,2062.23,1595.3000000000002]
[60,null,3315.6800000000003,5018.04,3857.34,2877.3700000000003,2273.7000000000003,1766.49]
[61,null,3732.26,5648.7400000000007,4339.6400000000003,3239.8900000000003,2560.96,1990.68]
[62,null,{"$f":"+C430*$L$2","v":4148.3100000000004},6277.85,4827.7700000000004,3601.88,2847.69,2212.75]
[63,null,4564.8900000000003,6907.4900000000007,5311.13,3964.4,3134.42,2436.94]
[64,null,4980.41,7538.1900000000005,5796.6100000000006,4327.45,3422.21,2657.42]
[65,null,5471.1900000000005,8150.34,6308.06,4715.41,3726.96,3025.2400000000002]
[66,null,5794.4900000000007,8630.52,6679.06,4994.72,3947.44,3207.03]
[67,null,6438.97,9592.4700000000012,7424.77,5551.22,4389.99,3564.25]
[68,null,7084.51,10552.83,8167.8300000000008,6108.7800000000007,4830.95,3922]
[69,null,7406.22,11033.54,8540.42,6385.4400000000005,5050.37,4102.7300000000005]
[70,null,7564.1600000000008,11174.52,8676.630000000001,6484.02,5145.2400000000007,4156.79]
[71,null,8511.8000000000011,12574.78,9763.66,7296.51,5791.84,4677.25]
[72,null,{"$f":"+C440*$L$2","v":9456.7900000000009},13975.570000000002,10853.34,8110.59,6436.3200000000006,5199.3]
[73,null,10404.43,15374.240000000002,11940.900000000001,8923.08,7082.39,5721.35]
[74,null,11350.480000000001,16774.5,13026.87,9735.0400000000009,7727.93,6242.87]
[75,"o más",12395.11,18349.66,14526.240000000002,11167.1,8460.92,7163.4800000000005]
[1,"Hijo",508.8,833.16000000000008,594.13,469.58000000000004,415.52000000000004,301.57]
[2,"Hijos",783.34,1360.51,937.04000000000008,743.06000000000006,660.38,443.61]
[3,"Hijos o más",1142.1500000000001,1991.21,1367.4,1085.44,955.59,672.57]
[1,"Rider Comp. Maternidad",119.25,119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",132.5,159,159,159,159,159]
[]
["CLASSIC GUATEMALA"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,{"$f":"L487*$L$6","v":0},3025,2344,1532,1124,790,null,null,null,null,true,true,true,true,true]
[19,null,{"$f":"L488*$L$6","v":0},3085,2374,1561,1124,815,null,null,null,null,true,true,true,true,true]
[20,null,0,3113,2432,1590,1154,815,null,null,null,null,true,true,true,true,true]
[21,null,0,3173,2495,1618,1182,845,null,null,null,null,true,true,true,true,true]
[22,null,0,3235,2553,1648,1210,845,null,null,null,null,true,true,true,true,true]
[23,null,0,3263,2580,1674,1210,875,null,null,null,null,true,true,true,true,true]
[24,null,0,3321,2642,1734,1237,900,null,null,null,null,true,true,true,true,true]
[25,null,0,3382,2700,1762,1267,900,null,null,null,null,true,true,true,true,true]
[26,null,0,3442,2759,1791,1293,930,null,null,null,null,true,true,true,true,true]
[27,null,0,3470,2817,1822,1322,930,null,null,null,null,true,true,true,true,true]
[28,null,0,3558,2878,1848,1350,956,null,null,null,null,true,true,true,true,true]
[29,null,0,3618,2937,1906,1377,983,null,null,null,null,true,true,true,true,true]
[30,null,0,3708,3025,1965,1407,1014,null,null,null,null,true,true,true,true,true]
[31,null,0,3766,3085,1995,1436,1014,null,null,null,null,true,true,true,true,true]
[32,null,0,3855,3173,2052,1462,1038,null,null,null,null,true,true,true,true,true]
[33,null,0,3945,3263,2109,1491,1070,null,null,null,null,true,true,true,true,true]
[34,null,0,4034,3354,2167,1547,1098,null,null,null,null,true,true,true,true,true]
[35,null,0,4154,3442,2224,1574,1124,null,null,null,null,true,true,true,true,true]
[36,null,0,4241,3531,2283,1629,1154,null,null,null,null,true,true,true,true,true]
[37,null,0,4330,3618,2340,1658,1182,null,null,null,null,true,true,true,true,true]
[38,null,0,4449,3737,2429,1714,1210,null,null,null,null,true,true,true,true,true]
[39,null,0,4568,3855,2512,1773,1237,null,null,null,null,true,true,true,true,true]
[40,null,0,4716,3945,2572,1798,1267,null,null,null,null,true,true,true,true,true]
[41,null,0,4833,4066,2658,1855,1293,null,null,null,null,true,true,true,true,true]
[42,null,null,4953,4181,2743,1912,1322,null,null,null,null,true,true,true,true,true]
[43,null,null,5102,4330,2830,1967,1377,null,null,null,null,true,true,true,true,true]
[44,null,null,5250,4449,2945,2025,1407,null,null,null,null,true,true,true,true,true]
[45,null,null,5397,4597,3031,2083,1462,null,null,null,null,true,true,true,true,true]
[46,null,null,5547,4746,3118,2137,1491,null,null,null,null,true,true,true,true,true]
[47,null,null,5694,4865,3234,2193,1519,null,null,null,null,true,true,true,true,true]
[48,null,null,5931,5071,3378,2277,1574,null,null,null,null,true,true,true,true,true]
[49,null,null,6138,5250,3495,2364,1629,null,null,null,null,true,true,true,true,true]
[50,null,null,6347,5428,3639,2445,1658,null,null,null,null,true,true,true,true,true]
[51,null,null,6553,5633,3784,2530,1714,null,null,null,null,true,true,true,true,true]
[52,null,null,6761,5812,3899,2614,1773,null,null,null,null,true,true,true,true,true]
[53,null,null,7029,6049,4071,2699,1828,null,null,null,null,true,true,true,true,true]
[54,null,null,7295,6288,4246,2808,1855,null,null,null,null,true,true,true,true,true]
[55,null,null,7562,6526,4417,2894,1912,null,null,null,null,true,true,true,true,true]
[56,null,null,7828,6761,4591,3006,1967,null,null,null,null,true,true,true,true,true]
[57,null,null,8096,6998,4764,3120,2025,null,null,null,null,true,true,true,true,true]
[58,null,null,8451,7295,5024,3232,2083,null,null,null,null,true,true,true,true,true]
[59,null,null,8776,7589,5255,3371,2137,null,null,null,null,true,true,true,true,true]
[60,null,null,9134,7918,5485,3513,2221,null,null,null,null,true,true,true,true,true]
[61,null,null,9637,8332,5804,3682,2277,null,null,null,null,true,true,true,true,true]
[62,null,null,10289,8923,6236,3935,2388,null,null,null,null,true,true,true,true,true]
[63,null,null,11266,9757,6844,4298,2503,null,null,null,null,true,true,true,true,true]
[64,null,null,12600,10913,7679,4804,2669,null,null,null,null,true,true,true,true,true]
[65,null,null,14321,12396,8748,5450,2923,null,null,null,null,true,true,true,true,true]
[66,null,null,16426,14262,10046,6208,3232,null,null,null,null,true,true,true,true,true]
[67,null,null,18799,16364,11549,7080,3652,null,null,null,null,true,true,true,true,true]
[68,null,null,21346,18649,13135,8035,4102,null,null,null,null,true,true,true,true,true]
[69,null,null,24015,21051,14809,9044,4609,null,null,null,null,true,true,true,true,true]
[70,null,null,26772,23508,16597,10170,5142,null,null,null,null,true,true,true,true,true]
[71,null,null,29618,26087,18474,11347,5703,null,null,null,null,true,true,true,true,true]
[72,null,null,32550,28698,20437,12609,6293,null,null,null,null,true,true,true,true,true]
[73,null,null,35545,31395,22516,13959,6911,null,null,null,null,true,true,true,true,true]
[74,null,null,38568,34153,24680,15392,7528,null,null,null,null,true,true,true,true,true]
[75,null,null,41680,36938,26931,16909,8175,null,null,null,null,true,true,true,true,true]
[76,null,null,44824,39783,29270,18510,8848,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[77,null,null,48024,42658,31693,20194,9549,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[78,null,null,51255,45594,34234,21963,10254,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[79,null,null,54518,48529,36860,23789,11011,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[80,"o mas",null,57806,51524,39574,25727,11743,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[1,"Hijo",null,1543,892,665,479,339,null,null,null,null,true,true,true,true,true]
[2,"Hijos",null,2580,1338,1042,734,508,null,null,null,null,true,true,true,true,true]
[3,"Hijos o más",null,3797,1929,1502,1070,760,null,null,null,null,true,true,true,true,true]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[null,"Deductible Waiver",null,180,345,775,1330,2080]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6",null,null,null,"SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,{"$f":"+C487*$L$2","v":0},1603.25,1242.3200000000002,811.96,595.72,418.70000000000005,null,null,null,{"$f":"+L487*$L$2","v":0},1168.6500000000001,905.7700000000001,607.91000000000008,457.92,321.71000000000004]
[19,null,{"$f":"+C488*$L$2","v":0},1635.0500000000002,1258.22,827.33,595.72,431.95000000000005,null,null,null,0,1192.5,916.90000000000009,619.57000000000005,457.92,332.31]
[20,null,{"$f":"+C489*$L$2","v":0},{"$f":"C6*$L$2","v":8731.2200000000012},1288.96,842.7,611.62,431.95000000000005,null,null,null,0,1203.1000000000001,939.69,630.17000000000007,470.11,332.31]
[21,null,{"$f":"+C490*$L$2","v":0},1681.69,1322.3500000000001,857.54000000000008,626.46,447.85,null,null,null,0,1226.42,963.54000000000008,641.83000000000004,481.24,343.97]
[22,null,{"$f":"+C491*$L$2","v":0},1714.5500000000002,1353.0900000000001,873.44,641.30000000000007,447.85,null,null,null,0,1249.74,986.33,653.49,492.90000000000003,343.97]
[23,null,{"$f":"+C492*$L$2","v":0},1729.39,1367.4,887.22,641.30000000000007,463.75,null,null,null,0,1260.8700000000001,997.46,664.62,492.90000000000003,356.16]
[24,null,{"$f":"+C493*$L$2","v":0},1760.13,1400.26,919.0200000000001,655.61,477,null,null,null,0,1283.6600000000001,1020.7800000000001,687.94,504.03000000000003,366.76]
[25,null,{"$f":"+C494*$L$2","v":0},1792.46,1431,933.86,671.51,477,null,null,null,0,1306.98,1043.5700000000002,699.07,516.22,366.76]
[26,null,{"$f":"+C495*$L$2","v":0},1824.26,1462.27,949.23,685.29000000000008,492.90000000000003,null,null,null,0,1330.3,1066.3600000000001,710.73,527.35,378.95000000000005]
[27,null,{"$f":"+C496*$L$2","v":0},1839.1000000000001,1493.01,965.66000000000008,700.66000000000008,492.90000000000003,null,null,null,0,1340.9,1089.1500000000001,722.39,538.48,378.95000000000005]
[28,null,{"$f":"+C497*$L$2","v":0},1885.74,1525.3400000000001,979.44,715.5,506.68,null,null,null,0,1375.3500000000001,1111.94,732.99,550.67000000000007,389.02000000000004]
[29,null,{"$f":"+C498*$L$2","v":0},1917.5400000000002,1556.6100000000001,1010.1800000000001,729.81000000000006,520.99,null,null,null,0,1398.14,1135.26,756.84,561.27,400.68]
[30,null,{"$f":"+C499*$L$2","v":0},1965.24,1603.25,1041.45,745.71,537.42000000000007,null,null,null,0,1433.1200000000001,1168.6500000000001,779.63,573.46,412.87]
[31,null,{"$f":"+C500*$L$2","v":0},1995.98,1635.0500000000002,1057.3500000000001,761.08,537.42000000000007,null,null,null,0,1455.38,1192.5,791.82,585.12,412.87]
[32,null,{"$f":"+C501*$L$2","v":0},2043.15,1681.69,1087.56,774.86,550.14,null,null,null,0,1490.3600000000001,1226.42,814.08,595.72,423.47]
[33,null,{"$f":"+C502*$L$2","v":0},2090.85,1729.39,1117.77,790.23,567.1,null,null,null,0,1524.8100000000002,1260.8700000000001,836.87,607.91000000000008,435.66]
[34,null,{"$f":"+C503*$L$2","v":0},2138.02,1777.6200000000001,1148.51,819.91000000000008,581.94000000000005,null,null,null,0,1559.26,1295.8500000000001,860.19,630.17000000000007,446.79]
[35,null,{"$f":"+C504*$L$2","v":0},2201.62,1824.26,1178.72,834.22,595.72,null,null,null,0,1605.3700000000001,1330.3,882.45,641.83000000000004,457.92]
[36,null,{"$f":"+C505*$L$2","v":0},2247.73,1871.43,1209.99,863.37,611.62,null,null,null,0,1639.2900000000002,1364.75,905.7700000000001,664.62,470.11]
[37,null,{"$f":"+C506*$L$2","v":0},2294.9,1917.5400000000002,1240.2,878.74,626.46,null,null,null,0,1673.74,1398.14,928.56000000000006,675.75,481.24]
[38,null,{"$f":"+C507*$L$2","v":0},2357.9700000000003,1980.6100000000001,1287.3700000000001,908.42000000000007,641.30000000000007,null,null,null,0,1719.3200000000002,1444.25,963.54000000000008,699.07,492.90000000000003]
[39,null,{"$f":"+C508*$L$2","v":0},2421.04,2043.15,1331.3600000000001,939.69,655.61,null,null,null,0,1765.96,1490.3600000000001,997.46,722.39,504.03000000000003]
[40,null,{"$f":"+C509*$L$2","v":0},2499.48,2090.85,1363.16,952.94,671.51,null,null,null,0,1823.2,1524.8100000000002,1020.7800000000001,732.99,516.22]
[41,null,{"$f":"+C510*$L$2","v":0},2561.4900000000002,2154.98,1408.74,983.15000000000009,685.29000000000008,null,null,null,0,1868.25,1571.45,1054.7,756.84,527.35]
[42,null,null,{"$f":"+D511*$L$2","v":2625.09},2215.9300000000003,1453.79,1013.36,700.66000000000008,null,null,null,null,1914.89,1615.97,1089.1500000000001,779.63,538.48]
[43,null,null,{"$f":"+D512*$L$2","v":2704.06},2294.9,1499.9,1042.51,729.81000000000006,null,null,null,null,1972.13,1673.74,1123.0700000000002,802.42000000000007,561.27]
[44,null,null,{"$f":"+D513*$L$2","v":2782.5},2357.9700000000003,1560.8500000000001,1073.25,745.71,null,null,null,null,2029.3700000000001,1719.3200000000002,1168.6500000000001,825.74,573.46]
[45,null,null,{"$f":"+D514*$L$2","v":2860.4100000000003},2436.4100000000003,1606.43,1103.99,774.86,null,null,null,null,2086.61,1777.0900000000001,1203.1000000000001,849.06000000000006,595.72]
[46,null,null,{"$f":"+D515*$L$2","v":2939.9100000000003},2515.38,1652.5400000000002,1132.6100000000001,790.23,null,null,null,null,2143.85,1834.3300000000002,1238.0800000000002,870.79000000000008,607.91000000000008]
[47,null,null,{"$f":"+D516*$L$2","v":3017.82},2578.4500000000003,1714.02,1162.29,805.07,null,null,null,null,2201.09,1880.44,1283.6600000000001,894.11,619.57000000000005]
[48,null,null,{"$f":"+D517*$L$2","v":3143.4300000000003},2687.63,1790.3400000000001,1206.8100000000002,834.22,null,null,null,null,2292.7800000000002,1960.47,1340.9,928.56000000000006,641.83000000000004]
[49,null,null,{"$f":"+D518*$L$2","v":3253.1400000000003},2782.5,1852.3500000000001,1252.92,863.37,null,null,null,null,2372.81,2029.3700000000001,1387.01,963.54000000000008,664.62]
[50,null,null,{"$f":"+D519*$L$2","v":3363.9100000000003},2876.84,1928.67,1295.8500000000001,878.74,null,null,null,null,2453.3700000000003,2098.27,1444.25,997.46,675.75]
[51,null,null,{"$f":"+D520*$L$2","v":3473.09},2985.4900000000002,2005.5200000000002,1340.9,908.42000000000007,null,null,null,null,2533.4,2177.77,1502.02,1031.9100000000001,699.07]
[52,null,null,{"$f":"+D521*$L$2","v":3583.3300000000004},3080.36,2066.4700000000003,1385.42,939.69,null,null,null,null,2613.4300000000003,2247.2000000000003,1547.6000000000001,1066.3600000000001,722.39]
[53,null,null,{"$f":"+D522*$L$2","v":3725.3700000000003},3205.9700000000003,2157.63,1430.47,968.84,null,null,null,null,2717.31,2338.8900000000003,1615.97,1101.3400000000001,745.18000000000006]
[54,null,null,{"$f":"+D523*$L$2","v":3866.3500000000004},3332.6400000000003,2250.38,1488.24,983.15000000000009,null,null,null,null,2820.6600000000003,2430.58,1685.4,1145.8600000000001,756.84]
[55,null,null,{"$f":"+D524*$L$2","v":4007.86},3458.78,2341.0100000000002,1533.8200000000002,1013.36,null,null,null,null,2923.48,2522.8000000000002,1753.77,1180.8400000000001,779.63]
[56,null,null,{"$f":"+D525*$L$2","v":4148.84},3583.3300000000004,2433.23,1593.18,1042.51,null,null,null,null,3026.83,2613.4300000000003,1823.2,1226.42,802.42000000000007]
[57,null,null,{"$f":"+D526*$L$2","v":4290.88},3708.94,2524.92,1653.6000000000001,1073.25,null,null,null,null,3129.65,2705.1200000000003,1891.0400000000002,1272.53,825.74]
[58,null,null,{"$f":"+D527*$L$2","v":4479.0300000000007},3866.3500000000004,2662.7200000000003,1712.96,1103.99,null,null,null,null,3267.98,2820.6600000000003,1994.92,1318.1100000000001,849.06000000000006]
[59,null,null,{"$f":"+D528*$L$2","v":4651.2800000000007},4022.17,2785.15,1786.63,1132.6100000000001,null,null,null,null,3393.06,2934.61,2086.61,1375.3500000000001,870.79000000000008]
[60,null,null,{"$f":"+D529*$L$2","v":4841.0200000000004},4196.54,2907.05,1861.89,1177.1300000000001,null,null,null,null,3531.3900000000003,3061.28,2177.77,1433.1200000000001,905.7700000000001]
[61,null,null,{"$f":"+D530*$L$2","v":5107.6100000000006},4415.96,3076.1200000000003,1951.46,1206.8100000000002,null,null,null,null,3725.9,3221.34,2304.44,1502.02,928.56000000000006]
[62,null,null,{"$f":"+D531*$L$2","v":5453.17},4729.1900000000005,3305.0800000000004,2085.5500000000002,1265.6400000000001,null,null,null,null,3978.1800000000003,3450.3,2476.1600000000003,1605.3700000000001,974.1400000000001]
[63,null,null,{"$f":"+D532*$L$2","v":5970.9800000000005},5171.21,3627.32,2277.94,1326.5900000000001,null,null,null,null,4356.0700000000006,3772.01,2717.31,1753.77,1020.7800000000001]
[64,null,null,{"$f":"+D533*$L$2","v":6678},5783.89,4069.8700000000003,2546.1200000000003,1414.5700000000002,null,null,null,null,4871.76,4219.33,3049.6200000000003,1960.47,1089.1500000000001]
[65,null,null,{"$f":"+D534*$L$2","v":7590.13},6569.88,4636.4400000000005,2888.5,1549.19,null,null,null,null,5537.4400000000005,4792.79,3474.15,2223.88,1192.5]
[66,null,null,{"$f":"+D535*$L$2","v":8705.7800000000007},7558.8600000000006,5324.38,3290.2400000000002,1712.96,null,null,null,null,6351.52,5514.6500000000005,3989.84,2533.4,1318.1100000000001]
[67,null,null,{"$f":"+D536*$L$2","v":9963.4700000000012},8672.92,6120.97,3752.4,1935.5600000000002,null,null,null,null,7268.9500000000007,6327.67,4586.09,2889.03,1490.3600000000001]
[68,null,null,{"$f":"+D537*$L$2","v":11313.380000000001},9883.9700000000012,6961.55,4258.55,2174.06,null,null,null,null,8254.2200000000012,7211.18,5216.26,3278.5800000000004,1673.74]
[69,null,null,{"$f":"+D538*$L$2","v":12727.95},11157.03,7848.77,4793.3200000000006,2442.77,null,null,null,null,9286.130000000001,8139.7400000000007,5880.88,3691.4500000000003,1880.44]
[70,null,null,{"$f":"+D539*$L$2","v":14189.16},12459.24,8796.41,5390.1,2725.26,null,null,null,null,10352.49,9091.09,6591.6100000000006,4150.43,2098.27]
[71,null,null,{"$f":"+D540*$L$2","v":15697.54},13826.11,9791.2200000000012,6013.91,3022.59,null,null,null,null,11453.300000000001,10088.02,7336.79,4631.1400000000003,2327.23]
[72,null,null,{"$f":"+D541*$L$2","v":17251.5},15209.94,10831.61,6682.77,3335.29,null,null,null,null,12587.5,11097.67,8116.42,5146.83,2567.85]
[73,null,null,{"$f":"+D542*$L$2","v":18838.850000000002},16639.350000000002,11933.480000000001,7398.27,3662.8300000000004,null,null,null,null,13745.550000000001,12140.710000000001,8942.16,5697.5,2820.6600000000003]
[74,null,null,{"$f":"+D543*$L$2","v":20441.04},18101.09,13080.400000000001,8157.76,3989.84,null,null,null,null,14915.26,13207.070000000002,9801.82,6282.62,3072.4100000000003]
[75,null,null,{"$f":"+D544*$L$2","v":22090.400000000001},19577.14,14273.43,8961.77,4332.75,null,null,null,null,16118.890000000001,14284.560000000001,10695.93,6901.6600000000008,3336.3500000000004]
[76,null,null,{"$f":"+D545*$L$2","v":23756.720000000001},21084.99,15513.1,9810.3000000000011,4689.4400000000005,null,null,null,null,17334.18,15384.84,11625.02,7555.1500000000005,3610.8900000000003]
[77,null,null,{"$f":"+D546*$L$2","v":25452.720000000001},22608.74,16797.29,10702.82,5060.97,null,null,null,null,18572.260000000002,16496.780000000002,12587.5,8243.09,3897.6200000000003]
[78,null,null,{"$f":"+D547*$L$2","v":27165.15},24164.82,18144.02,11640.390000000001,5434.62,null,null,null,null,19821.47,17632.04,13596.62,8964.9500000000007,4184.88]
[79,null,null,{"$f":"+D548*$L$2","v":28894.54},25720.370000000003,19535.8,12608.17,5835.83,null,null,null,null,21082.870000000003,18766.77,14639.66,9710.130000000001,4493.87]
[80,"o mas",null,{"$f":"+D549*$L$2","v":30637.18},27307.72,20974.22,13635.310000000001,6223.79,null,null,null,null,22354.870000000003,19925.350000000002,15717.68,10501.42,4792.79]
[1,"Hijo",{"$f":"+C550*$L$2","v":0},817.79000000000008,472.76000000000005,352.45000000000005,253.87,179.67000000000002,null,null,null,{"$f":"+L550*$L$2","v":0},595.72,343.97,263.41000000000003,194.51000000000002,137.27000000000001]
[2,"Hijos",{"$f":"+C551*$L$2","v":0},1367.4,709.14,552.26,389.02000000000004,269.24,null,null,null,0,997.46,516.22,412.87,298.39000000000004,206.17000000000002]
[3,"Hijos o más",{"$f":"+C552*$L$2","v":0},2012.41,1022.37,796.06000000000006,567.1,402.8,null,null,null,0,1467.5700000000002,745.18000000000006,595.72,435.66,309.52000000000004]
[1,"Rider Comp. Maternidad",{"$f":"+C553*$L$2","v":0},119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",{"$f":"+C554*$L$2","v":0},159,159,159,159,159]
[null,"Deductible Waiver",null,{"$f":"+D555*$L$2","v":95.4},182.85000000000002,410.75,704.90000000000009,1102.4000000000001]
[]
["BUPA BLUE 500 GUATEMALA",null,null,null,null,null,null,null,"?"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","ET1","ET2","ET3","ET4","ET5","ET6"]
[18,null,1326,1371,1193,1086,837,650]
[19,null,1471,1398,1211,1104,855,659]
[20,null,1702,1416,1229,1122,873,677]
[21,null,1883,1443,1256,1140,899,686]
[22,null,2123,1469,1273,1166,917,703]
[23,null,2461,1487,1300,1184,935,712]
[24,null,2695,1514,1318,1202,953,730]
[25,null,3185,1540,1336,1220,971,739]
[26,null,3358,1567,1362,1238,988,757]
[27,null,3780,1585,1380,1256,1015,766]
[28,null,4205,1621,1407,1282,1033,784]
[29,null,4626,1647,1434,1309,1060,801]
[30,null,5047,1674,1460,1327,1086,819]
[31,null,5068,1701,1478,1353,1104,828]
[32,null,5088,1727,1505,1371,1131,846]
[33,null,5656,1781,1549,1407,1166,873]
[34,null,6225,1825,1585,1451,1202,899]
[35,null,6508,1879,1630,1487,1238,926]
[36,null,6554,1923,1674,1523,1273,944]
[37,null,7376,1968,1710,1558,1300,971]
[38,null,8198,2021,1754,1603,1345,997]
[39,null,9021,2066,1799,1638,1380,1024]
[40,null,9842,2119,1843,1674,1416,1051]
[41,null,10752,2164,1879,1719,1451,1077]
[42,null,null,2208,1923,1754,1487,1095]
[43,null,null,2297,1995,1825,1558,1149]
[44,null,null,2386,2075,1897,1621,1193]
[45,null,null,2475,2155,1959,1683,1238]
[46,null,null,2564,2226,2030,1754,1282]
[47,null,null,2654,2306,2101,1816,1336]
[48,null,null,2743,2386,2173,1888,1380]
[49,null,null,2841,2467,2253,1950,1434]
[50,null,null,2930,2547,2324,2021,1478]
[51,null,null,3019,2627,2395,2093,1532]
[52,null,null,3117,2707,2475,2155,1576]
[53,null,null,3223,2805,2556,2244,1638]
[54,null,null,3339,2903,2645,2324,1692]
[55,null,null,3446,3001,2734,2413,1754]
[56,null,null,3553,3090,2823,2493,1808]
[57,null,null,3669,3188,2903,2582,1870]
[58,null,null,3793,3295,3001,2689,1941]
[59,null,null,3918,3410,3090,2796,2021]
[60,null,null,4052,3517,3179,2903,2093]
[61,null,null,4203,3651,3321,3010,2173]
[62,null,null,4390,3820,3482,3152,2271]
[63,null,null,4621,4016,3660,3312,2386]
[64,null,null,4880,4247,3873,3499,2520]
[65,null,null,5200,4523,4123,3767,2698]
[66,null,null,5574,4853,4425,4069,2912]
[67,null,null,6019,5236,4773,4390,3143]
[68,null,null,6536,5681,5182,4764,3410]
[69,null,null,7132,6197,5654,5200,3722]
[70,null,null,7818,6803,6144,5788,4114]
[71,null,null,8611,7489,6830,6376,4532]
[72,null,null,9528,8290,7551,7061,5022]
[73,null,null,10587,9198,8388,7836,5574]
[74,null,null,11798,10258,9350,8735,6215]
[75,null,null,13196,11469,10418,9830,6972]
[76,null,null,14790,12867,11718,11024,7818]
[77,null,null,16616,14443,13170,12377,8780]
[78,null,null,18673,16233,14799,13909,9866]
[79,null,null,20979,18236,16633,15627,11086]
[80,"o mas",null,23739,20640,18815,17684,12546]
[1,"Hijo",604,703,605,552,329,276]
[2,"Hijos",991,1184,1024,935,490,436]
[3,"Hijos o más",1452,1736,1505,1371,703,641]
[1,"Rider Comp. Maternidad",225,225,225,225,225,225]
[1,"Transplante de organos",250,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES ",null,null,null,null,null,null,null,"?"]
["EDAD"]
[" "," ","ET1","ET2","ET3","ET4","ET5","ET6"]
[18,null,{"$f":"+C633*$L$2","v":702.78000000000009},726.63,632.29000000000008,575.58000000000004,443.61,344.5]
[19,null,779.63,740.94,641.83000000000004,585.12,453.15000000000003,349.27000000000004]
[20,null,902.06000000000006,750.48,651.37,594.66000000000008,462.69,358.81]
[21,null,997.99,764.79000000000008,665.68000000000006,604.20000000000005,476.47,363.58000000000004]
[22,null,1125.19,778.57,674.69,617.98,486.01000000000005,372.59000000000003]
[23,null,1304.3300000000002,788.11,689,627.52,495.55,377.36]
[24,null,1428.3500000000001,802.42000000000007,698.54000000000008,637.06000000000006,505.09000000000003,386.90000000000003]
[25,null,1688.0500000000002,816.2,708.08,646.6,514.63,391.67]
[26,null,1779.74,830.51,721.86,656.14,523.64,401.21000000000004]
[27,null,2003.4,840.05000000000007,731.40000000000009,665.68000000000006,537.95000000000005,405.98]
[28,null,{"$f":"+C643*$L$2","v":2228.65},859.13,745.71,679.46,547.49,415.52000000000004]
[29,null,2451.7800000000002,872.91000000000008,760.02,693.77,561.80000000000007,424.53000000000003]
[30,null,2674.9100000000003,887.22,773.80000000000007,703.31000000000006,575.58000000000004,434.07000000000005]
[31,null,2686.04,901.53000000000009,783.34,717.09,585.12,438.84000000000003]
[32,null,2696.6400000000003,915.31000000000006,797.65000000000009,726.63,599.43000000000006,448.38]
[33,null,2997.6800000000003,943.93000000000006,820.97,745.71,617.98,462.69]
[34,null,3299.25,967.25,840.05000000000007,769.03000000000009,637.06000000000006,476.47]
[35,null,3449.2400000000002,995.87,863.90000000000009,788.11,656.14,490.78000000000003]
[36,null,3473.6200000000003,1019.19,887.22,807.19,674.69,500.32000000000005]
[37,null,3909.28,1043.04,906.30000000000007,825.74,689,514.63]
[38,null,{"$f":"+C653*$L$2","v":4344.9400000000005},1071.1300000000001,929.62,849.59,712.85,528.41000000000008]
[39,null,4781.13,1094.98,953.47,868.1400000000001,731.40000000000009,542.72]
[40,null,5216.26,1123.0700000000002,976.79000000000008,887.22,750.48,557.03]
[41,null,5698.56,1146.92,995.87,911.07,769.03000000000009,570.81000000000006]
[42,null,null,{"$f":"+D657*$L$2","v":1170.24},1019.19,929.62,788.11,580.35]
[43,null,null,{"$f":"+D658*$L$2","v":1217.4100000000001},1057.3500000000001,967.25,825.74,608.97]
[44,null,null,{"$f":"+D659*$L$2","v":1264.5800000000002},1099.75,1005.4100000000001,859.13,632.29000000000008]
[45,null,null,{"$f":"+D660*$L$2","v":1311.75},1142.1500000000001,1038.27,891.99,656.14]
[46,null,null,{"$f":"+D661*$L$2","v":1358.92},1179.78,1075.9000000000001,929.62,679.46]
[47,null,null,{"$f":"+D662*$L$2","v":1406.6200000000001},1222.18,1113.53,962.48,708.08]
[48,null,null,{"$f":"+D663*$L$2","v":1453.79},1264.5800000000002,1151.69,1000.6400000000001,731.40000000000009]
[49,null,null,{"$f":"+D664*$L$2","v":1505.73},1307.51,1194.0900000000001,1033.5,760.02]
[50,null,null,{"$f":"+D665*$L$2","v":1552.9},1349.91,1231.72,1071.1300000000001,783.34]
[51,null,null,{"$f":"+D666*$L$2","v":1600.0700000000002},1392.3100000000002,1269.3500000000001,1109.29,811.96]
[52,null,null,{"$f":"+D667*$L$2","v":1652.01},1434.71,1311.75,1142.1500000000001,835.28000000000009]
[53,null,null,{"$f":"+D668*$L$2","v":1708.19},1486.65,1354.68,1189.3200000000002,868.1400000000001]
[54,null,null,{"$f":"+D669*$L$2","v":1769.67},1538.5900000000001,1401.8500000000001,1231.72,896.76]
[55,null,null,{"$f":"+D670*$L$2","v":1826.38},1590.53,1449.02,1278.8900000000001,929.62]
[56,null,null,{"$f":"+D671*$L$2","v":1883.0900000000001},1637.7,1496.19,1321.29,958.24]
[57,null,null,{"$f":"+D672*$L$2","v":1944.5700000000002},1689.64,1538.5900000000001,1368.46,991.1]
[58,null,null,{"$f":"+D673*$L$2","v":2010.2900000000002},1746.3500000000001,1590.53,1425.17,1028.73]
[59,null,null,{"$f":"+D674*$L$2","v":2076.54},1807.3000000000002,1637.7,1481.88,1071.1300000000001]
[60,null,null,{"$f":"+D675*$L$2","v":2147.56},1864.01,1684.8700000000001,1538.5900000000001,1109.29]
[61,null,null,{"$f":"+D676*$L$2","v":2227.59},1935.0300000000002,1760.13,1595.3000000000002,1151.69]
[62,null,null,{"$f":"+D677*$L$2","v":2326.7000000000003},2024.6000000000001,1845.46,1670.5600000000002,1203.6300000000001]
[63,null,null,{"$f":"+D678*$L$2","v":2449.13},2128.48,1939.8000000000002,1755.3600000000001,1264.5800000000002]
[64,null,null,{"$f":"+D679*$L$2","v":2586.4},2250.9100000000003,2052.69,1854.47,1335.6000000000001]
[65,null,null,{"$f":"+D680*$L$2","v":2756},2397.19,2185.19,1996.51,1429.94]
[66,null,null,{"$f":"+D681*$L$2","v":2954.2200000000003},2572.09,2345.25,2156.5700000000002,1543.3600000000001]
[67,null,null,{"$f":"+D682*$L$2","v":3190.07},2775.08,2529.69,2326.7000000000003,1665.7900000000002]
[68,null,null,{"$f":"+D683*$L$2","v":3464.0800000000004},3010.9300000000003,2746.46,2524.92,1807.3000000000002]
[69,null,null,{"$f":"+D684*$L$2","v":3779.96},3284.4100000000003,2996.6200000000003,2756,1972.66]
[70,null,null,{"$f":"+D685*$L$2","v":4143.54},3605.59,3256.32,3067.6400000000003,2180.42]
[71,null,null,{"$f":"+D686*$L$2","v":4563.83},3969.17,3619.9,3379.28,2401.96]
[72,null,null,{"$f":"+D687*$L$2","v":5049.84},4393.7,4002.03,3742.3300000000004,2661.6600000000003]
[73,null,null,{"$f":"+D688*$L$2","v":5611.1100000000006},4874.9400000000005,4445.6400000000003,4153.08,2954.2200000000003]
[74,null,null,{"$f":"+D689*$L$2","v":6252.9400000000005},5436.7400000000007,4955.5,4629.55,3293.9500000000003]
[75,null,null,{"$f":"+D690*$L$2","v":6993.88},6078.5700000000006,5521.54,5209.9000000000005,3695.1600000000003]
[76,null,null,{"$f":"+D691*$L$2","v":7838.7000000000007},6819.51,6210.54,5842.72,4143.54]
[77,null,null,{"$f":"+D692*$L$2","v":8806.48},7654.79,6980.1,6559.81,4653.4000000000005]
[78,null,null,{"$f":"+D693*$L$2","v":9896.69},8603.49,7843.47,7371.77,5228.9800000000005]
[79,null,null,{"$f":"+D694*$L$2","v":11118.87},9665.08,8815.49,8282.3100000000013,5875.58]
[80,"o mas",null,{"$f":"+D695*$L$2","v":12581.67},10939.2,9971.9500000000007,9372.52,6649.38]
[1,"Hijo",{"$f":"+C696*$L$2","v":320.12},372.59000000000003,320.65000000000003,292.56,174.37,146.28]
[2,"Hijos",525.23,627.52,542.72,495.55,259.7,231.08]
[3,"Hijos o más",769.56000000000006,920.08,797.65000000000009,726.63,372.59000000000003,339.73]
[1,"Rider Comp. Maternidad",119.25,119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",132.5,159,159,159,159,159]
[]
["BUPA 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":702.78000000000009},584.06000000000006,571.87,539.54000000000008,491.84000000000003,380.01]
[19,null,779.63,594.13,581.94000000000005,548.55000000000007,500.32000000000005,388.49]
[20,null,902.06000000000006,604.20000000000005,591.48,558.09,508.8,396.44]
[21,null,997.99,614.27,602.08000000000004,567.1,517.28,404.92]
[22,null,1125.19,624.87,612.15,577.17000000000007,526.29000000000008,413.40000000000003]
[23,null,1304.3300000000002,635.47,622.22,586.71,534.24,422.41]
[24,null,1428.3500000000001,646.07000000000005,632.82000000000005,596.25,543.25,430.89000000000004]
[25,null,1688.0500000000002,655.61,642.36,605.26,552.79000000000008,439.90000000000003]
[26,null,1779.74,666.21,652.96,615.33000000000004,560.74,448.38]
[27,null,2003.4,676.28000000000009,663.03000000000009,624.87,569.75,457.39000000000004]
[28,null,{"$f":"+C788*$L$2","v":2228.65},689,675.22,636,579.82000000000005,467.46000000000004]
[29,null,2451.7800000000002,700.66000000000008,686.88,647.13,589.89,478.59000000000003]
[30,null,2674.9100000000003,713.38,698.54000000000008,658.26,600.49,489.72]
[31,null,2686.04,725.04000000000008,710.73,669.39,611.09,500.32000000000005]
[32,null,2696.6400000000003,737.76,722.39,681.05000000000007,620.63,511.45000000000005]
[33,null,2997.6800000000003,757.90000000000009,742.53000000000009,699.6,638.12,526.82000000000005]
[34,null,3299.25,778.04000000000008,762.14,718.15000000000009,655.08000000000004,542.72]
[35,null,3449.2400000000002,798.18000000000006,782.28000000000009,737.23,672.04000000000008,558.09]
[36,null,3473.6200000000003,818.32,801.89,755.78000000000009,689,573.99]
[37,null,3909.28,838.46,822.03000000000009,774.33,706.49,589.36]
[38,null,{"$f":"+C798*$L$2","v":4344.9400000000005},859.66000000000008,842.17000000000007,793.41000000000008,723.98,606.32000000000005]
[39,null,4781.13,879.80000000000007,862.31000000000006,813.0200000000001,740.94,622.75]
[40,null,5216.26,900.47,882.45,831.57,757.90000000000009,639.71]
[41,null,5698.56,921.1400000000001,902.59,850.65000000000009,775.39,656.14]
[42,null,null,{"$f":"+D802*$L$2","v":941.81000000000006},922.73,869.73,792.88,673.63]
[43,null,null,{"$f":"+D803*$L$2","v":978.91000000000008},959.83,904.18000000000006,824.68000000000006,702.78000000000009]
[44,null,null,{"$f":"+D804*$L$2","v":1016.5400000000001},995.87,938.63,855.95,732.99]
[45,null,null,{"$f":"+D805*$L$2","v":1054.17},1032.97,973.61,887.22,762.67000000000007]
[46,null,null,{"$f":"+D806*$L$2","v":1091.27},1069.54,1007.5300000000001,919.55000000000007,791.82]
[47,null,null,{"$f":"+D807*$L$2","v":1128.9000000000001},1106.6400000000001,1042.51,950.82,822.03000000000009]
[48,null,null,{"$f":"+D808*$L$2","v":1168.6500000000001},1144.8,1079.6100000000001,984.21,852.24]
[49,null,null,{"$f":"+D809*$L$2","v":1207.8700000000001},1183.49,1115.6500000000001,1017.6,884.04000000000008]
[50,null,null,{"$f":"+D810*$L$2","v":1247.6200000000001},1222.71,1152.22,1050.99,914.25]
[51,null,null,{"$f":"+D811*$L$2","v":1287.3700000000001},1261.93,1188.79,1084.3800000000001,945.5200000000001]
[52,null,null,{"$f":"+D812*$L$2","v":1327.1200000000001},1300.0900000000001,1225.3600000000001,1117.77,976.2600000000001]
[53,null,null,{"$f":"+D813*$L$2","v":1373.76},1346.73,1268.8200000000002,1156.46,1014.4200000000001]
[54,null,null,{"$f":"+D814*$L$2","v":1420.93},1392.3100000000002,1312.28,1196.21,1052.05]
[55,null,null,{"$f":"+D815*$L$2","v":1467.5700000000002},1438.42,1355.74,1235.96,1090.74]
[56,null,null,{"$f":"+D816*$L$2","v":1514.74},1484.53,1398.67,1275.71,1127.8400000000001]
[57,null,null,{"$f":"+D817*$L$2","v":1561.38},1530.1100000000001,1442.13,1314.4,1166.53]
[58,null,null,{"$f":"+D818*$L$2","v":1615.97},1583.1100000000001,1487.71,1360.51,1215.8200000000002]
[59,null,null,{"$f":"+D819*$L$2","v":1669.5},1636.1100000000001,1533.29,1405.5600000000002,1265.1100000000001]
[60,null,null,{"$f":"+D820*$L$2","v":1723.5600000000002},1689.1100000000001,1578.3400000000001,1451.67,1314.4]
[61,null,null,{"$f":"+D821*$L$2","v":1789.2800000000002},1753.24,1646.71,1506.79,1363.16]
[62,null,null,{"$f":"+D822*$L$2","v":1869.8400000000001},1832.21,1727.27,1574.63,1425.17]
[63,null,null,{"$f":"+D823*$L$2","v":1965.7700000000002},1926.5500000000002,1815.7800000000002,1655.72,1498.3100000000002]
[64,null,null,{"$f":"+D824*$L$2","v":2079.19},2037.8500000000001,1920.72,1751.1200000000001,1584.7]
[65,null,null,{"$f":"+D825*$L$2","v":2214.87},2170.35,2045.8000000000002,1865.0700000000002,1702.89]
[66,null,null,{"$f":"+D826*$L$2","v":2374.9300000000003},2327.23,2193.67,2000.22,1839.1000000000001]
[67,null,null,{"$f":"+D827*$L$2","v":2564.67},2512.73,2368.04,2159.2200000000003,1987.5]
[68,null,null,{"$f":"+D828*$L$2","v":2782.5},2726.8500000000004,2569.44,2342.6,2155.5100000000002]
[69,null,null,{"$f":"+D829*$L$2","v":3036.3700000000003},2974.8900000000003,2803.7000000000003,2556.7200000000003,2353.73]
[70,null,null,{"$f":"+D830*$L$2","v":3330.52},3263.21,3049.6200000000003,2804.76,2619.2600000000002]
[71,null,null,{"$f":"+D831*$L$2","v":3667.6000000000004},3593.9300000000003,3387.23,3087.78,2883.73]
[72,null,null,{"$f":"+D832*$L$2","v":4057.6800000000003},3975.53,3747.63,3416.9100000000003,3192.7200000000003]
[73,null,null,{"$f":"+D833*$L$2","v":4506.59},4415.43,4162.09,3794.8,3543.5800000000004]
[74,null,null,{"$f":"+D834*$L$2","v":5024.4000000000005},4923.7,4640.1500000000005,4230.46,3952.21]
[75,null,null,{"$f":"+D835*$L$2","v":5618},5504.58,5166.4400000000005,4730.25,4446.17]
[76,null,null,{"$f":"+D836*$L$2","v":6300.1100000000006},6172.9100000000008,5813.5700000000006,5304.2400000000007,4985.71]
[77,null,null,{"$f":"+D837*$L$2","v":7075.5},6932.93,6533.84,5957.7300000000005,5599.4500000000007]
[78,null,null,{"$f":"+D838*$L$2","v":7950},7789.9400000000005,7342.09,6693.9000000000005,6291.1]
[79,null,null,{"$f":"+D839*$L$2","v":8932.6200000000008},8752.42,8249.4500000000007,7520.7000000000007,7069.14]
[80,"o mas",null,{"$f":"+D840*$L$2","v":10108.16},9904.11,9334.36,8511.27,7998.76]
[1,"Hijo",{"$f":"+C841*$L$2","v":320.12},298.39000000000004,292.03000000000003,275.60000000000002,251.22,148.4]
[2,"Hijos",{"$f":"+C842*$L$2","v":525.23},502.97,492.90000000000003,464.81,424,220.48000000000002]
[3,"Hijos o más",{"$f":"+C843*$L$2","v":769.56000000000006},738.29000000000008,722.92000000000007,681.05000000000007,621.69000000000005,316.41000000000003]
[1,"Rider Comp. Maternidad",{"$f":"+C844*$L$2","v":119.25},119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",{"$f":"+C845*$L$2","v":132.5},159,159,159,159,159]
[]
["BUPA COMPLETE GUATEMALA"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","DW1","DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",null,{"$f":"D6*$L$3","v":2756.3250000000003},{"$f":"E6*$L$3","v":1887.8750000000002},1325.2250000000001,914.65000000000009,699.05000000000007]
[25,"-  29",null,{"$f":"D7*$L$3","v":2887.7750000000001},2096.0500000000002,1472.6250000000002,1003.4750000000001,771.1]
[30,"-  34",null,3020.8750000000005,2246.2000000000003,1638.1750000000002,1219.625,932.80000000000007]
[35,"-  39",null,3379.7500000000005,2511.0250000000001,1839.7500000000002,1362.3500000000001,1040.325]
[40,"-  44",null,3925.9,2756.3250000000003,2042.7000000000003,1505.6250000000002,1147.0250000000001]
[45,"-  49",null,4379.9250000000002,3077.2500000000005,2281.125,1684.9250000000002,1290.575]
[50,"-  54",null,5719.4500000000007,4059.0000000000005,2999.15,2401.5750000000003,1846.6250000000002]
[55,"-  59",null,6096.7500000000009,4322.7250000000004,3201.2750000000001,2562.1750000000002,1953.6000000000001]
[60,null,null,6625.85,4700.8500000000004,3642.65,3046.1750000000002,2454.65]
[61,null,null,7116.1750000000002,5041.0250000000005,3900.3250000000003,3279.3750000000005,2634.5]
[62,null,null,7795.7000000000007,5512.375,4268.55,3582.9750000000004,2884.4750000000004]
[63,null,null,8286.5750000000007,5870.4250000000002,4544.6500000000005,3817.0000000000005,3063.7750000000001]
[64,null,null,8966.1,6342.8750000000009,4912.875,4121.4250000000002,3315.1250000000005]
[65,null,null,11722.425000000001,8286.5750000000007,6218.3,5500.8250000000007,4676.1000000000004]
[66,null,null,13628.175000000001,9627.2000000000007,7229.4750000000004,6396.7750000000005,5428.5]
[67,null,null,14874.2,10514.35,7891.4000000000005,6987.7500000000009,5930.6500000000005]
[68,null,null,16478.275000000001,11646.250000000002,8738.125,7739.8750000000009,6575.5250000000005]
[69,null,null,18120.850000000002,12798.225,9621.4250000000011,8510.1500000000015,7219.85]
[70,null,null,22310.475000000002,15590.85,11312.95,9907.7000000000007,8492.2750000000015]
[71,null,null,23178.925000000003,16195.850000000002,11755.425000000001,10302.050000000001,8833]
[72,null,null,23839.475000000002,16667.2,12086.250000000002,10588.325000000001,9083.8000000000011]
[73,null,null,24707.925000000003,17271.650000000001,12528.45,10982.125,9423.9750000000004]
[74,null,null,25161.125000000004,17573.325000000001,12767.150000000001,11179.575000000001,9585.4000000000015]
[75,"o más",null,26255.625000000004,18346.625,13317.975,11663.575000000001,9997.0750000000007]
[1,"Hijo",null,963.6,698.77500000000009,534.6,448.52500000000003,322.85000000000002]
[2,"Hijos",null,1529.2750000000001,1114.0250000000001,847.27500000000009,699.05000000000007,520.57500000000005]
[3,"Hijos o más",null,2227.2250000000004,1623.8750000000002,1252.075,1021.3500000000001,753.77500000000009]
[1,"Rider Comp. Maternidad",null,0,0,61.875000000000007,61.875000000000007,61.875000000000007]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["BUPA SECURE GUATEMALA"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","CW1","CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",null,{"$f":"D140*$L$3","v":1347.7750000000001},{"$f":"E140*$L$3","v":1055.1750000000002},786.77500000000009,668.80000000000007,501.05000000000007]
[25,"-  29",null,{"$f":"D141*$L$3","v":1480.0500000000002},1187.1750000000002,885.50000000000011,738.37500000000011,557.15000000000009]
[30,"-  34",null,1700.0500000000002,1392.325,1028.7750000000001,862.95,655.05000000000007]
[35,"-  39",null,1876.0500000000002,1568.0500000000002,1143.7250000000001,960.57500000000005,723.25000000000011]
[40,"-  44",null,2094.9500000000003,1788.0500000000002,1286.7250000000001,1085.9750000000001,821.7]
[45,"-  49",null,2418.0750000000003,2094.9500000000003,1500.4,1267.2,946.82500000000005]
[50,"-  54",null,2638.0750000000003,2300.9250000000002,1643.6750000000002,1378.575,1044.45]
[55,"-  59",null,3106.1250000000005,2753.8500000000004,1943.15,1642.8500000000001,1225.6750000000002]
[60,null,null,3252.9750000000004,2944.9750000000004,2057.2750000000001,1740.7500000000002,1294.9750000000001]
[61,null,null,3663.0000000000005,3311.2750000000001,2329.25,1949.2,1461.9]
[62,null,null,4072.7500000000005,3677.5750000000003,2586.375,2171.9500000000003,1628.825]
[63,null,null,4469.3,4043.8750000000005,2843.2250000000004,2394.7000000000003,1795.4750000000001]
[64,null,null,4878.7750000000005,4424.4750000000004,3099.8,2616.3500000000004,1962.95]
[65,null,null,4893.625,4453.9000000000005,3128.9500000000003,2631.4750000000004,1962.95]
[66,null,null,4893.625,4497.9000000000005,3142.7000000000003,2644.9500000000003,1962.95]
[67,null,null,5435.1,5010.5,3485.6250000000005,2936.7250000000004,2185.9750000000004]
[68,null,null,5977.1250000000009,5508.5250000000005,3842.5750000000003,3229.6000000000004,2409]
[69,null,null,6255.7000000000007,5757.9500000000007,4014.7250000000004,3382.5000000000005,2520.1000000000004]
[70,null,null,6270.55,5845.9500000000007,4057.3500000000004,3409.7250000000004,2533.3000000000002]
[71,null,null,7047.7000000000007,6593.1250000000009,4571.05,3841.7500000000005,2854.2250000000004]
[72,null,null,7838.05,7325.7250000000004,5070.7250000000004,4258.9250000000002,3173.5000000000005]
[73,null,null,8629.5,8057.5000000000009,5585.8,4690.4000000000005,3493.8750000000005]
[74,null,null,9405.8250000000007,8790.375,6099.2250000000004,5121.6000000000004,3814.2500000000005]
[75,"o más",null,10255.575000000001,9640.4000000000015,6670.6750000000002,5595.1500000000005,4162.125]
[1,"Hijo",null,644.6,381.70000000000005,314.875,265.10000000000002,195.8]
[2,"Hijos",null,1099.45,572.55000000000007,500.50000000000006,418.00000000000006,306.625]
[3,"Hijos o más",null,1611.5000000000002,821.15000000000009,729.02500000000009,612.42500000000007,460.07500000000005]
[1,"Rider Comp. Maternidad",null,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["BUPA PREMIUM GUATEMALA"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","AW1","AW2","AW3","AW4","AW5","AW6"]
[18,null,null,{"$f":"D274*$L$3","v":1412.95},{"$f":"E274*$L$3","v":1053.25},763.67500000000007,573.1,451.27500000000003]
[19,null,null,{"$f":"D275*$L$3","v":1425.325},1066.1750000000002,776.32500000000005,584.92500000000007,463.65000000000003]
[20,null,null,1450.6250000000002,1091.75,788.97500000000002,597.85,475.75000000000006]
[21,null,null,1476.4750000000001,1117.325,814.27500000000009,597.85,475.75000000000006]
[22,null,null,1502.0500000000002,1129.7,826.1,609.95000000000005,488.12500000000006]
[23,null,null,1540.825,1156.1000000000001,838.47500000000002,621.77500000000009,500.22500000000002]
[24,null,null,1566.1250000000002,1181.6750000000002,851.12500000000011,633.875,500.22500000000002]
[25,null,null,1591.4250000000002,1194.325,863.50000000000011,645.97500000000002,512.05000000000007]
[26,null,null,1618.1000000000001,1219.625,888.80000000000007,658.625,524.97500000000002]
[27,null,null,1643.6750000000002,1245.2,901.17500000000007,670.45,536.80000000000007]
[28,null,null,1668.9750000000001,1271.6000000000001,926.47500000000002,694.65000000000009,536.80000000000007]
[29,null,null,1707.7500000000002,1296.9000000000001,938.57500000000005,707.30000000000007,548.625]
[30,null,null,1746.2500000000002,1335.4,963.05000000000007,719.40000000000009,560.72500000000002]
[31,null,null,1771.5500000000002,1360.9750000000001,989.17500000000007,743.6,573.1]
[32,null,null,1810.6000000000001,1386.2750000000001,1014.4750000000001,755.97500000000002,584.92500000000007]
[33,null,null,1848.825,1425.325,1038.95,779.90000000000009,597.85]
[34,null,null,1899.7,1463.5500000000002,1076.075,804.65000000000009,609.95000000000005]
[35,null,null,1938.4750000000001,1502.0500000000002,1113.75,828.85,621.77500000000009]
[36,null,null,1989.6250000000002,1540.825,1139.0500000000002,853.6,633.875]
[37,null,null,2028.6750000000002,1579.0500000000002,1176.45,877.52500000000009,645.97500000000002]
[38,null,null,2080.1000000000004,1618.1000000000001,1213.575,902.27500000000009,670.45]
[39,null,null,2130.7000000000003,1668.9750000000001,1251.5250000000001,926.47500000000002,682.55000000000007]
[40,null,null,2182.9500000000003,1720.6750000000002,1289.4750000000001,963.32500000000005,694.65000000000009]
[41,null,null,2246.75,1759.1750000000002,1339.25,987.80000000000007,707.30000000000007]
[42,null,null,2298.4500000000003,1810.6000000000001,1377.2,1024.1000000000001,732.05000000000007]
[43,null,null,2361.4250000000002,1861.4750000000001,1426.4250000000002,1060.6750000000002,743.6]
[44,null,null,2425.7750000000001,1926.1000000000001,1476.7500000000002,1097.25,768.35]
[45,null,null,2491.2250000000004,1977.5250000000001,1526.2500000000002,1133.5500000000002,779.90000000000009]
[46,null,null,2554.4750000000004,2041.6000000000001,1576.8500000000001,1169.575,804.65000000000009]
[47,null,null,2618.5500000000002,2093.0250000000001,1639.2750000000001,1206.9750000000001,816.75000000000011]
[48,null,null,2696.375,2169.75,1701.9750000000001,1255.9250000000002,840.95]
[49,null,null,2785.75,2246.75,1776.7750000000001,1304.325,865.7]
[50,null,null,2875.1250000000005,2323.75,1851.575,1353,889.62500000000011]
[51,null,null,2952.4,2400.4750000000004,1927.4750000000001,1401.4,914.1]
[52,null,null,3042.3250000000003,2491.2250000000004,1989.6250000000002,1450.6250000000002,938.02500000000009]
[53,null,null,3145.1750000000002,2580.6000000000004,2088.9,1523.7750000000001,963.32500000000005]
[54,null,null,3260.6750000000002,2682.3500000000004,2177.1750000000002,1584.2750000000001,999.62500000000011]
[55,null,null,3363.2500000000005,2785.75,2276.7250000000004,1644.7750000000001,1024.1000000000001]
[56,null,null,3466.3750000000005,2875.1250000000005,2364.1750000000002,1718.4750000000001,1060.6750000000002]
[57,null,null,3581.6000000000004,2978.8,2465.1000000000004,1778.15,1084.6000000000001]
[58,null,null,3722.6750000000002,3106.6750000000002,2589.9500000000003,1864.7750000000001,1121.45]
[59,null,null,3863.7500000000005,3235.1000000000004,2714.8,1949.7500000000002,1157.4750000000001]
[60,null,null,3992.1750000000002,3363.2500000000005,2839.9250000000002,2034.4500000000003,1194.325]
[61,null,null,4185.2250000000004,3543.1000000000004,3002.7250000000004,2156.5500000000002,1255.9250000000002]
[62,null,null,4441.25,3786.7500000000005,3252.7000000000003,2314.9500000000003,1315.875]
[63,null,null,4813.05,4132.9750000000004,3578.3,2559.4250000000002,1413.7750000000001]
[64,null,null,5327.5750000000007,4608.4500000000007,4027.9250000000002,2887.5000000000005,1560.075]
[65,null,null,5981.5250000000005,5249.4750000000004,4604.05,3314.0250000000001,1754.7750000000001]
[66,null,null,6789.7500000000009,6033.5000000000009,5291.8250000000007,3837.9,{"$f":"H322*$L$3","v":1998.15}]
[67,null,null,7688.1750000000002,6905.5250000000005,6066.7750000000005,4422.8250000000007,2290.75]
[68,null,null,8650.9500000000007,7868.3,6905.5250000000005,5043.5,2595.4500000000003]
[69,null,null,9665.1500000000015,8881.9500000000007,7768.2000000000007,5713.9500000000007,2937.2750000000001]
[70,null,null,10717.85,9922,8669.1,6395.6750000000002,3277.4500000000003]
[71,null,null,11795.025000000001,10999.725,9594.4750000000004,7102.9750000000004,3630.8250000000003]
[72,null,null,12912.075000000001,12103.575000000001,10544.875,7821.8250000000007,4008.1250000000005]
[73,null,null,14041.225,13233.275000000001,11520.85,8564.6,4385.9750000000004]
[74,null,null,15196.500000000002,14387.725,12509.2,9319.4750000000004,4763.2750000000005]
[75,null,null,16377.900000000001,15569.125000000002,13509.650000000001,10086.725,5165.6000000000004]
[76,null,null,16377.900000000001,15569.125000000002,13509.650000000001,10086.725,5165.6000000000004]
[77,null,null,16377.900000000001,15569.125000000002,13509.650000000001,10086.725,5165.6000000000004]
[78,null,null,16377.900000000001,15569.125000000002,13509.650000000001,10086.725,5165.6000000000004]
[79,null,null,16377.900000000001,15569.125000000002,13509.650000000001,10086.725,5165.6000000000004]
[80,"o mas",null,16377.900000000001,15569.125000000002,13509.650000000001,10086.725,5165.6000000000004]
[1,"Hijo",null,655.05000000000007,475.47500000000002,350.90000000000003,305.25,220.00000000000003]
[2,"Hijos",null,1079.1000000000001,{"$f":"E338*$L$3","v":745.25000000000011},551.1,475.75000000000006,316.8]
[3,"Hijos o más",null,{"$f":"D339*$L$3","v":1579.0500000000002},1079.1000000000001,814.27500000000009,694.65000000000009,488.12500000000006]
[1,"Rider Comp. Maternidad",null,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007]
[1,"Transplante de organos",null,82.5,82.5,82.5,82.5,82.5]
[null,"Deductible Waiver",null,49.500000000000007,94.875000000000014,213.12500000000003,365.75000000000006,572]
[]
["BUPA CLASSIC GUATEMALA"]
["TARIFAS TRIMESTRALES"]
["EDAD"]
[" "," ","SE1","SE2","SE3","SE4","SE5","SE6"]
[18,null,null,{"$f":"D487*$L$3","v":831.87500000000011},{"$f":"E487*$L$3","v":644.6},421.3,309.10000000000002,217.25000000000003]
[19,null,null,{"$f":"D488*$L$3","v":848.37500000000011},652.85,429.27500000000003,309.10000000000002,224.12500000000003]
[20,null,null,856.07500000000005,668.80000000000007,437.25000000000006,317.35000000000002,224.12500000000003]
[21,null,null,872.57500000000005,686.125,444.95000000000005,325.05,232.37500000000003]
[22,null,null,889.62500000000011,702.07500000000005,453.20000000000005,332.75,232.37500000000003]
[23,null,null,897.32500000000005,709.50000000000011,460.35,332.75,240.62500000000003]
[24,null,null,913.27500000000009,726.55000000000007,476.85,340.17500000000001,247.50000000000003]
[25,null,null,930.05000000000007,742.50000000000011,484.55,348.42500000000001,247.50000000000003]
[26,null,null,946.55000000000007,758.72500000000002,492.52500000000003,355.57500000000005,255.75000000000003]
[27,null,null,954.25000000000011,774.67500000000007,501.05000000000007,363.55,255.75000000000003]
[28,null,null,978.45,791.45,508.20000000000005,371.25000000000006,262.90000000000003]
[29,null,null,994.95,807.67500000000007,524.15000000000009,378.67500000000001,270.32500000000005]
[30,null,null,1019.7,831.87500000000011,540.375,386.92500000000001,278.85000000000002]
[31,null,null,1035.6500000000001,848.37500000000011,548.625,394.90000000000003,278.85000000000002]
[32,null,null,1060.125,872.57500000000005,564.30000000000007,402.05,285.45000000000005]
[33,null,null,1084.875,897.32500000000005,579.97500000000002,410.02500000000003,294.25]
[34,null,null,1109.3500000000001,922.35,595.92500000000007,425.42500000000001,301.95000000000005]
[35,null,null,1142.3500000000001,946.55000000000007,611.6,432.85,309.10000000000002]
[36,null,null,1166.2750000000001,971.02500000000009,627.82500000000005,447.97500000000002,317.35000000000002]
[37,null,null,1190.75,994.95,643.5,455.95000000000005,325.05]
[38,null,null,1223.4750000000001,1027.6750000000002,667.97500000000002,471.35,332.75]
[39,null,null,1256.2,1060.125,690.80000000000007,487.57500000000005,340.17500000000001]
[40,null,null,1296.9000000000001,1084.875,707.30000000000007,494.45000000000005,348.42500000000001]
[41,null,null,1329.075,1118.1500000000001,730.95,510.12500000000006,355.57500000000005]
[42,null,null,1362.075,1149.7750000000001,754.32500000000005,525.80000000000007,363.55]
[43,null,null,1403.0500000000002,1190.75,778.25000000000011,540.92500000000007,378.67500000000001]
[44,null,null,1443.7500000000002,1223.4750000000001,809.87500000000011,556.875,386.92500000000001]
[45,null,null,1484.1750000000002,1264.1750000000002,833.52500000000009,572.82500000000005,402.05]
[46,null,null,1525.4250000000002,1305.1500000000001,857.45,587.67500000000007,410.02500000000003]
[47,null,null,1565.8500000000001,1337.875,889.35,603.07500000000005,417.72500000000002]
[48,null,null,1631.0250000000001,1394.5250000000001,928.95,626.17500000000007,432.85]
[49,null,null,1687.95,1443.7500000000002,961.12500000000011,650.1,447.97500000000002]
[50,null,null,1745.4250000000002,1492.7,1000.7250000000001,672.375,455.95000000000005]
[51,null,null,1802.075,1549.075,1040.6000000000001,695.75,471.35]
[52,null,null,1859.2750000000001,1598.3000000000002,1072.2250000000001,718.85,487.57500000000005]
[53,null,null,1932.9750000000001,1663.4750000000001,1119.5250000000001,742.22500000000002,502.70000000000005]
[54,null,null,2006.1250000000002,1729.2,1167.6500000000001,772.2,510.12500000000006]
[55,null,null,2079.5500000000002,1794.65,1214.6750000000002,795.85,525.80000000000007]
[56,null,null,2152.7000000000003,1859.2750000000001,1262.5250000000001,826.65000000000009,540.92500000000007]
[57,null,null,2226.4,1924.45,1310.1000000000001,858.00000000000011,556.875]
[58,null,null,2324.0250000000001,2006.1250000000002,1381.6000000000001,888.80000000000007,572.82500000000005]
[59,null,null,2413.4,2086.9750000000004,1445.1250000000002,927.02500000000009,587.67500000000007]
[60,null,null,2511.8500000000004,2177.4500000000003,1508.3750000000002,966.07500000000005,610.77500000000009]
[61,null,null,2650.1750000000002,2291.3000000000002,1596.1000000000001,1012.5500000000001,626.17500000000007]
[62,null,null,2829.4750000000004,2453.8250000000003,1714.9,1082.125,656.7]
[63,null,null,3098.15,2683.1750000000002,1882.1000000000001,1181.95,688.32500000000005]
[64,null,null,3465.0000000000005,3001.0750000000003,2111.7250000000004,1321.1000000000001,733.97500000000002]
[65,null,null,3938.2750000000001,3408.9,2405.7000000000003,1498.7500000000002,803.82500000000005]
[66,null,null,4517.1500000000005,3922.05,2762.65,1707.2,{"$f":"H535*$L$3","v":888.80000000000007}]
[67,null,null,5169.7250000000004,4500.1000000000004,3175.9750000000004,1947.0000000000002,1004.3000000000001]
[68,null,null,5870.1500000000005,5128.4750000000004,3612.1250000000005,2209.625,1128.0500000000002]
[69,null,null,6604.1250000000009,5789.0250000000005,4072.4750000000004,2487.1000000000004,1267.4750000000001]
[70,null,null,7362.3,6464.7000000000007,4564.1750000000002,2796.75,1414.0500000000002]
[71,null,null,8144.9500000000007,7173.9250000000002,5080.3500000000004,3120.4250000000002,1568.325]
[72,null,null,8951.25,7891.9500000000007,5620.1750000000002,3467.4750000000004,1730.575]
[73,null,null,9774.875,8633.625,6191.9000000000005,3838.7250000000004,1900.5250000000001]
[74,null,null,10606.2,9392.0750000000007,6787.0000000000009,4232.8,2070.2000000000003]
[75,null,null,11462.000000000002,10157.950000000001,7406.0250000000005,4649.9750000000004,2248.125]
[76,null,null,12326.6,10940.325000000001,8049.2500000000009,5090.25,2433.2000000000003]
[77,null,null,13206.6,11730.95,8715.5750000000007,5553.35,2625.9750000000004]
[78,null,null,14095.125000000002,12538.35,9414.35,6039.8250000000007,2819.8500000000004]
[79,null,null,14992.45,13345.475,10136.5,6541.9750000000004,3028.0250000000001]
[80,"o mas",null,15896.650000000001,14169.1,10882.85,7074.9250000000002,3229.3250000000003]
[1,"Hijo",null,424.32500000000005,245.3,182.87500000000003,131.72500000000002,93.225000000000009]
[2,"Hijos",null,709.50000000000011,{"$f":"E551*$L$3","v":367.95000000000005},286.55,201.85000000000002,139.70000000000002]
[3,"Hijos o más",null,{"$f":"D552*$L$3","v":1044.1750000000002},530.47500000000002,413.05,294.25,209.00000000000003]
[1,"Rider Comp. Maternidad",null,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007,61.875000000000007]
[1,"Transplante de organos",null,82.5,82.5,82.5,82.5,82.5]
[null,"Deductible Waiver",null,49.500000000000007,94.875000000000014,213.12500000000003,365.75000000000006,572]