{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["INGRESO DE DATOS","Exclusive","Privilege","Advantage (Mundial)","Advantage (LA)","Secure","Essential","Critical","Resumen tarifas anuales","Comparacion de Beneficios","Tablas"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":0,"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":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,0,7,9],[13,3,13,9],[9,0,9,9],[22,3,22,9]]}
[]
[null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null," "," "," "," "]
[]
["COTIZACION DE SEGURO MEDICO INTERNACIONAL"]
[]
["(Para nuevos negocios y renovaciones con fecha de emisión a partir del 1 de enero de 2022)"]
[]
["1. INGRESE LOS DATOS DEL PROPUESTO ASEGURADO :"]
[]
[null,null,"Nombre del Asegurado principal :","NOMBRE COMPLETO"]
[]
[null,null,null,null,null,"Número de adultos en la póliza : ",1,null,"Número de hijos en la póliza :",0]
[]
[null,null,null,null,null," Edad del titular :",18,null,"Edad de cónyuge :",46]
[]
[]
["2. INGRESE EL NOMBRE DE LA AGENCIA ASESORA :"]
[]
[null,null,"Nombre de la Agencia :","AGENTE"]
[]
[]
["3. ESCOJA EL PRODUCTO PARA VISUALIZAR LA COTIZACION RESPECTIVA :"]

{"sheet":"Exclusive","index":1,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[51,0,51,1],[51,2,51,3],[50,0,50,1],[50,2,50,3],[28,2,28,3],[32,0,32,1],[33,0,33,1],[32,2,32,3],[44,2,44,3],[39,0,39,1],[34,2,34,3],[33,2,33,3],[41,2,41,3],[42,2,42,3],[39,2,39,3],[43,2,43,3],[40,2,40,3],[35,2,35,3],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[12,0,12,1],[17,0,18,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[9,2,9,12],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[23,2,23,3],[30,2,30,3],[46,2,46,3],[17,2,18,3],[29,2,29,3],[24,2,24,3],[19,2,19,3],[20,2,20,3],[22,2,22,3],[46,0,46,1],[19,0,19,1],[26,0,26,1],[21,2,21,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[25,0,25,1],[26,2,26,3],[27,0,27,1],[20,0,21,1],[28,0,28,1],[31,2,31,3],[27,2,27,3],[29,0,29,1],[30,0,31,1],[49,5,50,12],[48,0,49,1],[48,2,49,3],[34,0,34,1],[45,0,45,1],[40,0,40,1],[41,0,41,1],[45,2,45,3],[43,0,43,1],[44,0,44,1],[42,0,42,1],[47,0,47,1],[47,2,47,3],[35,0,35,1],[36,0,38,1],[36,2,38,3]]}
[]
[null,null,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 EXCLUSIVE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$14","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$23","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$18","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2022-01-06T13:36:44.600"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null," ",false]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,4,TRUE)","v":8563},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":5665},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":4043},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":2853},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":2243}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$33)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":8563},{"$f":"SUM(J31:J34)","v":5665},{"$f":"SUM(K31:K34)","v":4043},{"$f":"SUM(L31:L34)","v":2853},{"$f":"SUM(M31:M34)","v":2243}]
[null,null,null,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(I35:I36)","v":8638},{"$f":"SUM(J35:J36)","v":5740},{"$f":"SUM(K35:K36)","v":4118},{"$f":"SUM(L35:L36)","v":2928},{"$f":"SUM(M35:M36)","v":2318}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,4,TRUE)","v":4538.3900000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":3002.4500000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":2142.79},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":1512.0900000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":1188.79}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$66)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":4538.3900000000003},{"$f":"SUM(J40:J43)","v":3002.4500000000003},{"$f":"SUM(K40:K43)","v":2142.79},{"$f":"SUM(L40:L43)","v":1512.0900000000001},{"$f":"SUM(M40:M43)","v":1188.79}]
[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(I44:I45)","v":4613.3900000000003},{"$f":"SUM(J44:J45)","v":3077.4500000000003},{"$f":"SUM(K44:K45)","v":2217.79},{"$f":"SUM(L44:L45)","v":1587.0900000000001},{"$f":"SUM(M44:M45)","v":1263.79}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":4538.3900000000003},{"$f":"J44","v":3002.4500000000003},2142.79,1512.0900000000001,1188.79]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 01 enero de 2022"]
[]
[null,null,null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[null," "]

{"sheet":"Privilege","index":2,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[49,0,49,1],[49,2,49,3],[48,0,48,1],[48,2,48,3],[13,7,13,12],[17,5,17,6],[16,5,16,6],[16,0,16,1],[35,2,35,3],[36,0,36,1],[42,2,42,3],[36,2,36,3],[43,0,43,1],[43,2,43,3],[39,2,39,3],[40,2,40,3],[37,2,37,3],[38,2,38,3],[11,0,11,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[22,2,22,3],[31,2,31,3],[26,2,26,3],[20,2,20,3],[25,2,25,3],[32,2,32,3],[29,2,29,3],[27,2,27,3],[28,2,28,3],[9,2,9,12],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,18,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[21,2,21,3],[46,2,47,3],[11,7,11,12],[42,0,42,1],[19,0,19,1],[17,0,18,1],[20,0,21,1],[46,0,47,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[32,0,32,1],[49,5,50,12],[33,0,33,1],[34,0,34,1],[29,0,29,1],[41,2,41,3],[37,0,37,1],[38,0,38,1],[34,2,34,3],[39,0,39,1],[40,0,40,1],[41,0,41,1],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[35,0,35,1]]}
[]
[null,null,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 PRIVILEGE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$14","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$23","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$18","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2022-01-06T13:36:44.600"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null," ",false]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,4,TRUE)","v":7203},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":4952},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":3510},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":2463},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":1876}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$167)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":7203},{"$f":"SUM(J31:J34)","v":4952},{"$f":"SUM(K31:K34)","v":3510},{"$f":"SUM(L31:L34)","v":2463},{"$f":"SUM(M31:M34)","v":1876}]
[null,null,null,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(I35:I36)","v":7278},{"$f":"SUM(J35:J36)","v":5027},{"$f":"SUM(K35:K36)","v":3585},{"$f":"SUM(L35:L36)","v":2538},{"$f":"SUM(M35:M36)","v":1951}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,4,TRUE)","v":3817.59},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":2624.56},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":1860.3000000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":1305.3900000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":994.28000000000009}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$200)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":3817.59},{"$f":"SUM(J40:J43)","v":2624.56},{"$f":"SUM(K40:K43)","v":1860.3000000000002},{"$f":"SUM(L40:L43)","v":1305.3900000000001},{"$f":"SUM(M40:M43)","v":994.28000000000009}]
[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(I44:I45)","v":3892.59},{"$f":"SUM(J44:J45)","v":2699.56},{"$f":"SUM(K44:K45)","v":1935.3000000000002},{"$f":"SUM(L44:L45)","v":1380.39},{"$f":"SUM(M44:M45)","v":1069.2800000000002}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":3817.59},{"$f":"J44","v":2624.56},1860.3000000000002,1305.3900000000001,994.28000000000009]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 01 enero de 2022"]
[]
[null,null,null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[null," "]

{"sheet":"Advantage (Mundial)","index":3,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[9,2,9,12],[11,7,11,12],[11,0,11,3],[12,0,12,1],[54,0,54,1],[54,2,54,3],[53,0,53,1],[53,2,53,3],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[47,2,47,3],[29,2,29,3],[20,2,20,3],[17,0,18,1],[17,2,18,3],[49,2,49,3],[13,7,13,12],[17,5,17,6],[16,5,16,6],[48,2,48,3],[25,2,25,3],[23,2,23,3],[21,2,21,3],[22,2,22,3],[19,2,19,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[42,0,42,1],[20,0,21,1],[22,0,23,1],[24,2,24,3],[42,2,42,3],[24,0,24,1],[25,0,25,1],[30,0,31,1],[35,2,39,3],[40,2,41,3],[28,2,28,3],[19,0,19,1],[30,2,30,3],[33,2,33,3],[31,2,31,3],[35,0,41,1],[26,0,26,1],[26,2,26,3],[27,2,27,3],[33,0,33,1],[34,0,34,1],[29,0,29,1],[34,2,34,3],[32,2,32,3],[32,0,32,1],[27,0,27,1],[28,0,28,1],[51,5,52,12],[44,0,44,1],[46,0,46,1],[45,2,45,3],[45,0,45,1],[51,2,52,3],[51,0,52,1],[50,2,50,3],[46,2,46,3],[44,2,44,3],[49,0,49,1],[50,0,50,1],[47,0,47,1],[48,0,48,1],[49,5,49,12]]}
[]
[null,null,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"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$14","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$23","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$18","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2022-01-06T13:36:44.600"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,false,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,4,TRUE)","v":4749},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":3570},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":2708},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":2061},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":1634}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$301)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$302)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$302)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$302)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$302)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$302)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":4749},3570,2708,2061,1634]
[null,null,null,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":4824},{"$f":"SUM(J36:J37)","v":3645},{"$f":"SUM(K36:K37)","v":2783},{"$f":"SUM(L36:L37)","v":2136},{"$f":"SUM(M36:M37)","v":1709}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,4,TRUE)","v":2516.9700000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":1892.1000000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":1435.24},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":1092.3300000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":866.0200000000001}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$334)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$335)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$335)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$335)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$335)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$335)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":2516.9700000000003},1892.1000000000001,1435.24,1092.3300000000002,866.0200000000001]
[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":2591.9700000000003},{"$f":"SUM(J46:J47)","v":1967.1000000000001},{"$f":"SUM(K46:K47)","v":1510.24},{"$f":"SUM(L46:L47)","v":1167.3300000000002},{"$f":"SUM(M46:M47)","v":941.0200000000001}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2516.9700000000003},{"$f":"J46","v":1892.1000000000001},1435.24,1092.3300000000002,866.0200000000001]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 01 enero de 2022"]
[]
[null,null,null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[]
[null," "]

{"sheet":"Advantage (LA)","index":4,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":true,"merged":[[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
["Bupa Advantage Care (cobertura solo en Latinoamérica)",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$14","v":"NOMBRE COMPLETO"}]
["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"}]
["Condiciones médicas cubiertas",null,"Todas las condiciones médicas"]
["Redes de proveedores",null,"Red de Proveedores \"Bupa Advantage\"",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$18","v":18}]
["Opciones fuera de la Red",null,"NO, solo en casos de emergencia",null,null,"FECHA DE COTIZACION :"]
["Requiere preautorización",null,"SI, 30% de penalización por omitir prenotificación",null,null,{"$f":"NOW()","v":"2022-01-06T13:36:44.600"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[null,null,null,null,null,null,null,null,null," "," "," "]
["Número máximo de días de hospitalización",null,"Ilimitado",null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
["Habitación y alimentación",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
["Cuidados Intensivos",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null," "]
["Cobertura de Maternidad",null,"$5,000 (Excepto planes 4,5, y 6)",null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Cobertura Provisional de Recién Nacido",null,"$30,000 por los primeros 90 días",null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Cuidado del Recién Nacido saludable",null,"Ya incluída dentro del beneficio de Maternidad",null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
["Cobertura de Complicaciones de Maternidad",null,"Disponible a través de cobertura opcional adicional"]
["Trasplante de Organos",null,"$1,000,000 de por vida, por diagnóstico"]
["Condiciones congénitas y hereditarias",null,"<18 años $300,000 de por vida; >=18 al 100%",null,null,"Tarifas Anuales"]
["Coberturas opcionales (Riders)",null,"Complicaciones de Maternidad por $500,000",null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,4,TRUE)","v":0},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":0},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":0},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":0},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":0}]
[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$341:$H$364,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,8,TRUE)))","v":0}]
["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$365:$H$367,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":0}]
["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$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$368)","v":0}]
["Repatriación restos mortales",null,1,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$369)","v":0}]
["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":0},0,0,0,0]
["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":75},{"$f":"SUM(J36:J37)","v":75},{"$f":"SUM(K36:K37)","v":75},{"$f":"SUM(L36:L37)","v":75},{"$f":"SUM(M36:M37)","v":75}]
["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$374:$H$397,4,TRUE)","v":0},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":0},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":0},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":0},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":0}]
["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$374:$H$397,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,8,TRUE)))","v":0}]
["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$398:$H$400,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":0}]
["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$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$401)","v":0}]
["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$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$402)","v":0}]
["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":0},0,0,0,0]
[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":75},{"$f":"SUM(J46:J47)","v":75},{"$f":"SUM(K46:K47)","v":75},{"$f":"SUM(L46:L47)","v":75},{"$f":"SUM(M46:M47)","v":75}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":0},{"$f":"J46","v":0},0,0,0]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2013"]

{"sheet":"Secure","index":5,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[9,2,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],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[15,0,15,1],[20,2,20,3],[17,2,18,3],[32,0,32,1],[32,2,32,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,2,22,3],[21,2,21,3],[25,2,25,3],[16,0,16,1],[19,0,19,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,0,29,1],[26,0,26,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[20,0,21,1],[42,2,42,3],[42,0,42,1],[43,0,43,1],[35,2,39,3],[49,5,49,12],[46,2,46,3],[49,0,49,1],[49,2,49,3],[51,5,53,12],[33,2,33,3],[31,2,31,3],[47,0,48,1],[47,2,48,3],[45,2,45,3],[46,0,46,1],[45,0,45,1],[33,0,33,1],[34,0,34,1],[35,0,41,1],[44,0,44,1],[34,2,34,3],[40,2,41,3],[43,2,43,3],[44,2,44,3]]}
[]
[null,null,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 SECURE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$14","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$23","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$18","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2022-01-06T13:36:44.600"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,false,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,4,TRUE)","v":3372},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":2645},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":2016},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":1727},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":1317}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$435)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$435)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$435)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$435)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$435)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$436)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$436)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$436)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$436)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$436)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":3372},2645,2016,1727,1317]
[null,null,null,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":3447},{"$f":"SUM(J36:J37)","v":2720},{"$f":"SUM(K36:K37)","v":2091},{"$f":"SUM(L36:L37)","v":1802},{"$f":"SUM(M36:M37)","v":1392}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,4,TRUE)","v":1787.16},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":1401.8500000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":1068.48},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":915.31000000000006},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":698.01}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$468)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$468)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$468)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$468)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$468)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$469)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$469)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$469)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$469)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$469)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":1787.16},1401.8500000000001,1068.48,915.31000000000006,698.01]
[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":1862.16},{"$f":"SUM(J46:J47)","v":1476.8500000000001},{"$f":"SUM(K46:K47)","v":1143.48},{"$f":"SUM(L46:L47)","v":990.31000000000006},{"$f":"SUM(M46:M47)","v":773.01}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":1787.16},{"$f":"J46","v":1401.8500000000001},1068.48,915.31000000000006,698.01]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 01 enero de 2022"]
[null," "]
[null," ",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":"Essential","index":6,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[49,0,49,1],[49,2,49,3],[42,0,42,1],[34,2,34,3],[47,2,48,3],[47,0,48,1],[45,2,45,3],[46,2,46,3],[43,2,43,3],[45,0,45,1],[46,0,46,1],[43,0,43,1],[44,0,44,1],[44,2,44,3],[42,2,42,3],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[35,2,39,3],[33,0,33,1],[34,0,34,1],[35,0,41,1],[40,2,41,3],[33,2,33,3],[23,2,23,3],[24,2,24,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],[29,2,29,3],[30,2,30,3],[19,2,19,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],[51,5,53,12],[9,2,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]]}
[]
[null,null,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 ESSENTIAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$14","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$23","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$18","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2022-01-06T13:36:44.600"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,4,TRUE)","v":2360},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":1848},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":1410},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":1209},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":916}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$502)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$503)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$503)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$503)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$503)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$503)","v":300}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":2660},2148,1710,1509,1216]
[null,null,null,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":2735},{"$f":"SUM(J36:J37)","v":2223},{"$f":"SUM(K36:K37)","v":1785},{"$f":"SUM(L36:L37)","v":1584},{"$f":"SUM(M36:M37)","v":1291}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,4,TRUE)","v":1250.8},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":979.44},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":747.30000000000007},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":640.77},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":485.48}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$535)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$536)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$536)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$536)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$536)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$536)","v":159}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":1409.8},1138.44,906.30000000000007,799.77,644.48]
[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":1484.8},{"$f":"SUM(J46:J47)","v":1213.44},{"$f":"SUM(K46:K47)","v":981.30000000000007},{"$f":"SUM(L46:L47)","v":874.77},{"$f":"SUM(M46:M47)","v":719.48}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":1409.8},{"$f":"J46","v":1138.44},906.30000000000007,799.77,644.48]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 01 enero de 2022"]
[null," "]
[null," ",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":"Critical","index":7,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[14,0,14,1],[13,0,13,1],[15,0,15,1],[16,0,16,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[23,10,24,11],[33,10,36,12],[21,5,22,7],[21,8,22,9],[9,2,9,12],[26,2,26,3],[17,2,18,3],[19,2,19,3],[20,2,20,3],[16,2,16,3],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[21,10,22,12],[11,7,11,12],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[45,2,45,3],[35,2,39,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[32,2,32,3],[33,2,33,3],[20,0,21,1],[21,2,21,3],[22,2,22,3],[25,0,25,1],[25,2,25,3],[23,2,23,3],[24,2,24,3],[19,0,19,1],[41,2,41,3],[44,0,44,1],[32,0,32,1],[35,0,39,1],[33,0,33,1],[34,0,34,1],[43,0,43,1],[22,0,23,1],[24,0,24,1],[30,2,31,3],[27,0,27,1],[28,0,28,1],[34,2,34,3],[29,0,29,1],[30,0,31,1],[45,0,45,1],[23,5,24,7],[25,5,26,7],[27,5,28,7],[29,5,30,7],[31,5,32,7],[33,5,34,7],[35,5,36,7],[44,2,44,3],[26,0,26,1],[43,2,43,3],[40,0,40,1],[41,0,41,1],[42,0,42,1],[42,2,42,3],[40,2,40,3],[52,5,54,12],[35,8,35,9],[36,8,36,9],[25,10,25,11],[26,10,26,11],[27,10,27,11],[32,10,32,11],[31,8,31,9],[32,8,32,9],[33,8,33,9],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[49,5,49,12],[34,8,34,9]]}
[]
[null,null,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 CRITICAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$14","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$23","v":"AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$18","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2022-01-06T13:36:44.600"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,null,true,null,null,{"$f":"IF(M16>=M18,M16,M18)","v":46}]
[]
[null,null,null,null,null,"CONDICION CRITICA CUBIERTA",null,null,"MAXIMO POR AÑO POLIZA",null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,"Enfermedades neurológicas y accidentes cerebro-vasculares",null,null,150000,null,"Tipo de trasplante",null,"Máximo Vitalicio"]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,null,null,"por persona"]
[null,null,null,null,null,"Cirugías cardíacas y angioplastías",null,null,150000,null,"Corazón",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Corazón y Pulmón (simultáneamente)",null,300000]
[null,null,null,null,null,"Tratamiento de cáncer",null,null,200000,null,"Pulmón",null,250000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Pancreas",null,250000]
[null,null,null,null,null,"Trauma grave (Politraumatismos)",null,null,150000,null,"Pancreas y Riñón (simultáneamente)",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Riñón",null,200000]
[null,null,null,null,null,"Insuficiencia renal crónica (Diálisis)",null,null,100000,null,"Hígado",null,200000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Médula ósea",null,250000]
[null,null,null,null,null,"Quemaduras graves ",null,null,300000,null,"La cobertura de trasplante de órganos está limitada a la Red de Proveedores para Procedimiento de Trasplante de la Compañía y no se proporcionará cobertura en proveedores fuera de esta Red especializada."]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[null,null,null,null,null,"Desorden infeccioso grave (Septicemia)",null,null,150000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[null,null,null,null,null,"Fuera del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima por plan individual :",null,{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,3,TRUE)),0)","v":2255},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,6,TRUE)),0)","v":1964},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,9,TRUE)),0)","v":1682},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,12,TRUE)),0)","v":1292},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,15,TRUE)),0)","v":917},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,18,TRUE)),0)","v":516}]
[null,null,null,null,null,"Prima por plan para 2 personas :",null,{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,4,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,7,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,10,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,13,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,16,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,19,TRUE)),0)","v":0}]
[null,null,null,null,null,"Prima por plan familiar :",null,{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,5,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,8,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,11,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,14,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,17,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,20,TRUE)),0)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":2255},{"$f":"SUM(I44:I46)","v":1964},1682,1292,917,516]
[null," ",null,null,null,"Costo Administrativo Anual :",null,75,75,75,75,75,75]
[null," ",null,null,null,"GRAN TOTAL :",null,{"$f":"SUM(H47:H48)","v":2330},2039,1757,1367,992,591]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 01 enero de 2022"]
[]
[]
[null,null,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":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[13,2,13,7],[15,2,15,7],[19,0,19,1],[18,0,18,1],[11,2,11,7],[39,0,41,7],[37,0,37,7],[28,0,28,1],[21,0,21,1],[26,0,26,1],[29,0,29,1],[30,0,30,1],[36,0,36,1],[27,0,27,1],[25,0,25,1],[25,2,25,7],[32,0,32,1],[35,2,35,7]]}
[]
[null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null," "," "," "," "]
[]
[]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - BUPA CARE "]
[]
[null,null,{"$f":"+'INGRESO DE DATOS'!$D$14","v":"NOMBRE COMPLETO"}]
[]
[null,null,{"$f":"+'INGRESO DE DATOS'!$D$23","v":"AGENTE"}]
[]
[null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$18","v":18}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2022-01-06T13:36:44.600"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$18","v":46}]
[null,null,null,null," "," "," "]
["Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
["PRODUCTOS",null,"Tarifas Anuales"]
["Bupa Exclusive Care",null,"n/a",{"$f":"+Exclusive!I37","v":8638},{"$f":"+Exclusive!J37","v":5740},{"$f":"+Exclusive!K37","v":4118},{"$f":"+Exclusive!L37","v":2928},{"$f":"+Exclusive!M37","v":2318}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":7278},{"$f":"+Privilege!J37","v":5027},{"$f":"+Privilege!K37","v":3585},{"$f":"+Privilege!L37","v":2538},{"$f":"+Privilege!M37","v":1951}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":4824},{"$f":"+'Advantage (Mundial)'!J38","v":3645},{"$f":"+'Advantage (Mundial)'!K38","v":2783},{"$f":"+'Advantage (Mundial)'!L38","v":2136},{"$f":"+'Advantage (Mundial)'!M38","v":1709}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":3447},{"$f":"+Secure!J38","v":2720},{"$f":"+Secure!K38","v":2091},{"$f":"+Secure!L38","v":1802},{"$f":"+Secure!M38","v":1392}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":2735},{"$f":"+Essential!J38","v":2223},{"$f":"+Essential!K38","v":1785},{"$f":"+Essential!L38","v":1584},{"$f":"+Essential!M38","v":1291}]
[]
["Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Dentro del pais de residencia",null,2000,3500,5000,10000,20000,50000]
["Fuera del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[null,null,"Tarifas Anuales"]
["Bupa Critical Care",null,{"$f":"+Critical!H49","v":2330},{"$f":"+Critical!I49","v":2039},{"$f":"+Critical!J49","v":1757},{"$f":"+Critical!K49","v":1367},{"$f":"+Critical!L49","v":992},{"$f":"+Critical!M49","v":591}]
["Tarifas en US$ —  Válidas desde 01 enero de 2022"]
[]
["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":"Comparacion de Beneficios","index":9,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[47,0,48,0],[50,0,52,0],[1,1,3,6],[4,1,4,6],[10,0,12,0],[14,0,15,0],[16,0,17,0],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[32,6,34,6],[40,4,42,4],[40,5,42,5],[39,6,42,6],[18,0,20,0],[38,0,42,0],[25,0,27,0],[26,1,27,1],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[28,0,29,0],[30,0,31,0],[32,0,34,0],[32,1,34,1],[32,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5]]}
[]
[null,"2022 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":558,"n_cols":20,"rows_kept":558,"cut":false,"hidden":true,"merged":[[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[303,0,303,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],[470,0,470,7],[403,0,403,7],[404,0,404,7],[405,0,405,1],[405,2,405,6],[304,2,304,6],[336,0,336,7],[437,0,437,7],[438,0,438,1],[438,2,438,6],[304,0,304,1],[370,0,370,7],[371,0,371,1],[371,2,371,6],[337,0,337,7],[338,0,338,1],[338,2,338,6],[539,0,539,1],[471,0,471,7],[472,0,472,1],[472,2,472,6],[504,0,504,7],[505,0,505,1],[505,2,505,6],[538,0,538,19],[537,0,537,19],[539,2,539,6],[540,14,540,16],[540,17,540,19],[547,14,547,16],[547,17,547,19],[545,0,545,19],[540,2,540,4],[547,2,547,4],[547,5,547,7],[547,8,547,10],[546,0,546,1],[546,2,546,6],[540,5,540,7],[540,8,540,10],[547,11,547,13],[540,11,540,13]]}
[]
["EXCLUSIVE",null,null,null,null,null,null,null,null,"FACTOR SEMESTRAL :",null,0.53]
["TARIFAS ANUALES"]
["EDAD",null,null,null,null,null,null,null,null,"Valor original",null,null,null,null,null,"Con 70%"]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6",null,"DW2","DW3","DW4","DW5","DW6",null,"DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",null,{"$f":"P6","v":8563},{"$f":"Q6","v":5665},{"$f":"R6","v":4043},{"$f":"S6","v":2853},{"$f":"T6","v":2243},null,8563,5665,4043,2853,2243,null,{"$f":"(J6-50)*1+50","v":8563},{"$f":"(K6-50)*1+50","v":5665},4043,2853,2243]
[25,"-  29",null,8982,6257,4476,3155,2483,null,8982,6257,4476,3155,2483,null,{"$f":"(J7-50)*1+50","v":8982},{"$f":"(K7-50)*1+50","v":6257},{"$f":"(L7-50)*1+50","v":4476},{"$f":"(M7-50)*1+50","v":3155},{"$f":"(N7-50)*1+50","v":2483}]
[30,"-  34",null,9341,6708,5011,3777,2980,null,9341,6708,5011,3777,2980,null,9341,6708,5011,3777,2980]
[35,"-  39",null,10465,7512,5614,4233,3337,null,10465,7512,5614,4233,3337,null,10465,7512,5614,4233,3337]
[40,"-  44",null,12127,8209,6231,4649,3666,null,12127,8209,6231,4649,3666,null,12127,8209,6231,4649,3666]
[45,"-  49",null,13555,9183,6957,5198,4097,null,13555,9183,6957,5198,4097,null,13555,9183,6957,5198,4097]
[50,"-  54",null,17347,12042,9080,7340,5790,null,17347,12042,9080,7340,5790,null,17347,12042,9080,7340,5790]
[55,"-  59",null,18452,12814,9660,7808,6162,null,18452,12814,9660,7808,6162,null,18452,12814,9660,7808,6162]
[60,null,null,20099,13979,11110,9402,7653,null,20099,13979,11110,9402,7653,null,20099,13979,11110,9402,7653]
[61,null,null,21596,15020,11927,10105,8219,null,21596,15020,11927,10105,8219,null,21596,15020,11927,10105,8219]
[62,null,null,23645,16445,13069,11057,8998,null,23645,16445,13069,11057,8998,null,23645,16445,13069,11057,8998]
[63,null,null,25137,17485,13889,11764,9569,null,25137,17485,13889,11764,9569,null,25137,17485,13889,11764,9569]
[64,null,null,27190,18922,15028,12724,10351,null,27190,18922,15028,12724,10351,null,27190,18922,15028,12724,10351]
[65,null,null,35537,24676,18996,16964,14593,null,35537,24676,18996,16964,14593,null,35537,24676,18996,16964,14593]
[66,null,null,41283,28668,22074,19714,16955,null,41283,28668,22074,19714,16955,null,41283,28668,22074,19714,16955]
[67,null,null,45094,31309,24110,21531,18515,null,45094,31309,24110,21531,18515,null,45094,31309,24110,21531,18515]
[68,null,null,49927,34666,26692,23843,20507,null,49927,34666,26692,23843,20507,null,49927,34666,26692,23843,20507]
[69,null,null,54936,38147,29366,26228,22560,null,54936,38147,29366,26228,22560,null,54936,38147,29366,26228,22560]
[70,null,null,67606,46441,34571,30562,26531,null,67606,46441,34571,30562,26531,null,67606,46441,34571,30562,26531]
[71,null,null,70260,48267,35928,31764,27573,null,70260,48267,35928,31764,27573,null,70260,48267,35928,31764,27573]
[72,null,null,72252,49625,36941,32662,28360,null,72252,49625,36941,32662,28360,null,72252,49625,36941,32662,28360]
[73,null,null,74905,51450,38299,33866,29399,null,74905,51450,38299,33866,29399,null,74905,51450,38299,33866,29399]
[74,null,null,76229,52358,38979,34461,29918,null,76229,52358,38979,34461,29918,null,76229,52358,38979,34461,29918]
[75,"o más",null,79548,54641,40673,35963,31222,null,79548,54641,40673,35963,31222,null,79548,54641,40673,35963,31222]
[1,"Hijo",null,2974,2188,1801,1502,1173,null,2974,2188,1801,1502,1173,null,{"$f":"J30*1","v":2974},{"$f":"K30*1","v":2188},1801,1502,1173]
[2,"Hijos",null,4725,3484,2861,2387,1857,null,4725,3484,2861,2387,1857,null,{"$f":"J31*1","v":4725},{"$f":"K31*1","v":3484},{"$f":"L31*1","v":2861},{"$f":"M31*1","v":2387},{"$f":"N31*1","v":1857}]
[3,"Hijos o más",null,6929,5100,4195,3500,2726,null,6929,5100,4195,3500,2726,null,6929,5100,4195,3500,2726]
[1,"Rider Comp. Maternidad",null,0,0,225,225,225]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",null,{"$f":"D6*$L$2","v":4538.3900000000003},{"$f":"E6*$L$2","v":3002.4500000000003},2142.79,1512.0900000000001,1188.79]
[25,"-  29",null,{"$f":"D7*$L$2","v":4760.46},3316.21,2372.2800000000002,1672.15,1315.99]
[30,"-  34",null,{"$f":"D8*$L$2","v":4950.7300000000005},3555.2400000000002,2655.83,2001.8100000000002,1579.4]
[35,"-  39",null,{"$f":"D9*$L$2","v":5546.4500000000007},3981.36,2975.42,2243.4900000000002,1768.6100000000001]
[40,"-  44",null,{"$f":"D10*$L$2","v":6427.31},4350.7700000000004,3302.4300000000003,2463.9700000000003,1942.98]
[45,"-  49",null,{"$f":"D11*$L$2","v":7184.1500000000005},4866.9900000000007,3687.21,2754.94,2171.4100000000003]
[50,"-  54",null,{"$f":"D12*$L$2","v":9193.91},6382.26,4812.4000000000005,3890.2000000000003,3068.7000000000003]
[55,"-  59",null,{"$f":"D13*$L$2","v":9779.5600000000013},6791.42,5119.8,4138.24,3265.86]
[60,null,null,{"$f":"D14*$L$2","v":10652.470000000001},7408.8700000000008,5888.3,4983.0600000000004,4056.09]
[61,null,null,{"$f":"D15*$L$2","v":11445.880000000001},7960.6,6321.31,5355.6500000000005,4356.0700000000006]
[62,null,null,{"$f":"D16*$L$2","v":12531.85},8715.85,6926.5700000000006,5860.21,4768.9400000000005]
[63,null,null,{"$f":"D17*$L$2","v":13322.61},9267.0500000000011,7361.17,6234.92,5071.5700000000006]
[64,null,null,{"$f":"D18*$L$2","v":14410.7},10028.66,7964.84,6743.72,{"$f":"H18*$L$2","v":5486.0300000000007}]
[65,null,null,{"$f":"D19*$L$2","v":18834.61},13078.28,10067.880000000001,8990.92,7734.29]
[66,null,null,{"$f":"D20*$L$2","v":21879.99},15194.04,11699.220000000001,10448.42,8986.15]
[67,null,null,{"$f":"D21*$L$2","v":23899.82},16593.77,12778.300000000001,11411.43,9812.9500000000007]
[68,null,null,{"$f":"D22*$L$2","v":26461.31},18372.98,14146.76,12636.79,10868.710000000001]
[69,null,null,{"$f":"D23*$L$2","v":29116.080000000002},20217.91,15563.980000000001,13900.84,11956.800000000001]
[70,null,null,{"$f":"D24*$L$2","v":35831.18},24613.73,18322.63,16197.86,14061.43]
[71,null,null,{"$f":"D25*$L$2","v":37237.800000000003},25581.510000000002,19041.84,16834.920000000002,14613.69]
[72,null,null,{"$f":"D26*$L$2","v":38293.560000000005},26301.25,19578.73,17310.86,15030.800000000001]
[73,null,null,{"$f":"D27*$L$2","v":39699.65},27268.5,20298.47,17948.98,15581.470000000001]
[74,null,null,{"$f":"D28*$L$2","v":40401.370000000003},27749.74,20658.870000000003,18264.330000000002,15856.54]
[75,"o más",null,{"$f":"D29*$L$2","v":42160.44},28959.730000000003,21556.690000000002,19060.39,16547.66]
[1,"Hijo",null,{"$f":"D30*$L$2","v":1576.22},1159.6400000000001,954.53000000000009,796.06000000000006,621.69000000000005]
[2,"Hijos",null,{"$f":"D31*$L$2","v":2504.25},1846.52,1516.3300000000002,1265.1100000000001,984.21]
[3,"Hijos o más",null,{"$f":"D32*$L$2","v":3672.3700000000003},2703,2223.35,1855,1444.78]
[1,"Rider Comp. Maternidad",null,{"$f":"+D33*$L$2","v":0},0,119.25,119.25,119.25]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["DIAMOND (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["PRIVILEGE"]
["TARIFAS ANUALES"]
["EDAD",null,null,null,null,null,null,null,null,"ORIGINAL",null,null,null,null,null,0.7]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6",null,"CW2","CW3","CW4","CW5","CW6",null,"CW2","CW3"," CW4","CW5","CW6"]
[18,"-  24",null,{"$f":"P140","v":7203},{"$f":"Q140","v":4952},{"$f":"R140","v":3510},{"$f":"S140","v":2463},{"$f":"T140","v":1876},null,7203,4952,3510,2463,1876,null,{"$f":"(J140-50)*1+50","v":7203},{"$f":"(K140-50)*1+50","v":4952},3510,2463,1876]
[25,"-  29",null,7557,5475,3889,2730,2084,null,7557,5475,3889,2730,2084,null,{"$f":"(J141-50)*1+50","v":7557},{"$f":"(K141-50)*1+50","v":5475},{"$f":"(L141-50)*1+50","v":3889},{"$f":"(M141-50)*1+50","v":2730},{"$f":"(N141-50)*1+50","v":2084}]
[30,"-  34",null,7898,5868,4357,3307,2522,null,7898,5868,4357,3307,2522,null,7898,5868,4357,3307,2522]
[35,"-  39",null,8841,6567,4881,3704,2825,null,8841,6567,4881,3704,2825,null,8841,6567,4881,3704,2825]
[40,"-  44",null,10234,7194,5427,4083,3116,null,10234,7194,5427,4083,3116,null,10234,7194,5427,4083,3116]
[45,"-  49",null,11428,8041,6072,4561,3486,null,11428,8041,6072,4561,3486,null,11428,8041,6072,4561,3486]
[50,"-  54",null,14940,10602,7969,6509,4975,null,14940,10602,7969,6509,4975,null,14940,10602,7969,6509,4975]
[55,"-  59",null,15897,11280,8480,6927,5296,null,15897,11280,8480,6927,5296,null,15897,11280,8480,6927,5296]
[60,null,null,17312,12253,9646,8242,6616,null,17312,12253,9646,8242,6616,null,17312,12253,9646,8242,6616]
[61,null,null,18597,13160,10361,8851,7105,null,18597,13160,10361,8851,7105,null,18597,13160,10361,8851,7105]
[62,null,null,20358,14412,11348,9691,7784,null,20358,14412,11348,9691,7784,null,20358,14412,11348,9691,7784]
[63,null,null,21646,15319,12063,10303,8275,null,21646,15319,12063,10303,8275,null,21646,15319,12063,10303,8275]
[64,null,null,23412,16574,13050,11146,8953,null,23412,16574,13050,11146,8953,null,23412,16574,13050,11146,8953]
[65,null,null,30601,21618,16502,14860,12621,null,30601,21618,16502,14860,12621,null,30601,21618,16502,14860,12621]
[66,null,null,35553,25115,19171,17268,14669,null,35553,25115,19171,17268,14669,null,35553,25115,19171,17268,14669]
[67,null,null,38834,27434,20937,18860,16016,null,38834,27434,20937,18860,16016,null,38834,27434,20937,18860,16016]
[68,null,null,43002,30375,23190,20891,17735,null,43002,30375,23190,20891,17735,null,43002,30375,23190,20891,17735]
[69,null,null,47308,33417,25511,22978,19514,null,47308,33417,25511,22978,19514,null,47308,33417,25511,22978,19514]
[70,null,null,58219,40688,30026,26778,22954,null,58219,40688,30026,26778,22954,null,58219,40688,30026,26778,22954]
[71,null,null,60504,42279,31209,27825,23854,null,60504,42279,31209,27825,23854,null,60504,42279,31209,27825,23854]
[72,null,null,62211,43482,32091,28616,24529,null,62211,43482,32091,28616,24529,null,62211,43482,32091,28616,24529]
[73,null,null,64508,45077,33269,29666,25432,null,64508,45077,33269,29666,25432,null,64508,45077,33269,29666,25432]
[74,null,null,65646,45876,33854,30190,25881,null,65646,45876,33854,30190,25881,null,65646,45876,33854,30190,25881]
[75,"o más",null,68501,47867,35330,31506,27008,null,68501,47867,35330,31506,27008,null,68501,47867,35330,31506,27008]
[1,"Hijo",null,2498,1825,1426,1192,882,null,2498,1825,1426,1192,882,null,{"$f":"J164*1","v":2498},{"$f":"K164*1","v":1825},1426,1192,882]
[2,"Hijos",null,3975,2907,2268,1897,1402,null,3975,2907,2268,1897,1402,null,{"$f":"J165*1","v":3975},{"$f":"K165*1","v":2907},{"$f":"L165*1","v":2268},{"$f":"M165*1","v":1897},{"$f":"N165*1","v":1402}]
[3,"Hijos o más",null,5823,4260,3325,2778,2057,null,5823,4260,3325,2778,2057,null,5823,4260,3325,2778,2057]
[1,"Rider Comp. Maternidad",null,0,0,225,225,225]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",null,{"$f":"D140*$L$2","v":3817.59},{"$f":"E140*$L$2","v":2624.56},1860.3000000000002,1305.3900000000001,994.28000000000009]
[25,"-  29",null,{"$f":"D141*$L$2","v":4005.21},2901.75,2061.17,1446.9,1104.52]
[30,"-  34",null,{"$f":"D142*$L$2","v":4185.9400000000005},3110.04,2309.21,1752.71,1336.66]
[35,"-  39",null,{"$f":"D143*$L$2","v":4685.7300000000005},3480.51,2586.9300000000003,1963.1200000000001,1497.25]
[40,"-  44",null,{"$f":"D144*$L$2","v":5424.02},3812.82,2876.31,2163.9900000000002,1651.48]
[45,"-  49",null,{"$f":"D145*$L$2","v":6056.84},4261.7300000000005,3218.1600000000003,2417.33,1847.5800000000002]
[50,"-  54",null,{"$f":"D146*$L$2","v":7918.2000000000007},5619.06,4223.5700000000006,3449.77,2636.75]
[55,"-  59",null,{"$f":"D147*$L$2","v":8425.41},5978.4000000000005,4494.4000000000005,3671.3100000000004,2806.88]
[60,null,null,{"$f":"D148*$L$2","v":9175.36},6494.09,5112.38,4368.26,3506.48]
[61,null,null,{"$f":"D149*$L$2","v":9856.41},6974.8,5491.33,4691.0300000000007,3765.65]
[62,null,null,{"$f":"D150*$L$2","v":10789.74},7638.3600000000006,6014.4400000000005,5136.2300000000005,4125.5200000000004]
[63,null,null,{"$f":"D151*$L$2","v":11472.380000000001},8119.0700000000006,6393.39,5460.59,4385.75]
[64,null,null,{"$f":"D152*$L$2","v":12408.36},8784.2200000000012,6916.5,5907.38,4745.09]
[65,null,null,{"$f":"D153*$L$2","v":16218.53},11457.54,8746.0600000000013,7875.8,6689.13]
[66,null,null,{"$f":"D154*$L$2","v":18843.09},13310.95,10160.630000000001,9152.0400000000009,7774.5700000000006]
[67,null,null,{"$f":"D155*$L$2","v":20582.02},14540.02,11096.61,9995.8000000000011,8488.48]
[68,null,null,{"$f":"D156*$L$2","v":22791.06},16098.75,12290.7,11072.230000000001,9399.5500000000011]
[69,null,null,{"$f":"D157*$L$2","v":25073.24},17711.010000000002,13520.83,12178.34,10342.42]
[70,null,null,{"$f":"D158*$L$2","v":30856.070000000003},21564.639999999999,15913.78,14192.34,12165.62]
[71,null,null,{"$f":"D159*$L$2","v":32067.120000000003},22407.870000000003,16540.77,14747.25,12642.62]
[72,null,null,{"$f":"D160*$L$2","v":32971.83},23045.460000000003,17008.23,15166.480000000001,13000.37]
[73,null,null,{"$f":"D161*$L$2","v":34189.240000000005},23890.81,17632.57,15722.980000000001,13478.960000000001]
[74,null,null,{"$f":"D162*$L$2","v":34792.380000000005},24314.280000000002,17942.620000000003,16000.7,13716.93]
[75,"o más",null,{"$f":"D163*$L$2","v":36305.53},25369.510000000002,18724.900000000001,16698.18,14314.240000000002]
[1,"Hijo",null,{"$f":"D164*$L$2","v":1323.94},967.25,755.78000000000009,631.76,467.46000000000004]
[2,"Hijos",null,{"$f":"D165*$L$2","v":2106.75},1540.71,1202.04,1005.4100000000001,743.06000000000006]
[3,"Hijos o más",null,{"$f":"D166*$L$2","v":3086.19},2257.8000000000002,1762.25,1472.3400000000001,1090.21]
[1,"Rider Comp. Maternidad",null,{"$f":"+D167*$L$2","v":0},0,119.25,119.25,119.25]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["COMPLETE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["ADVANTAGE (WORLDWIDE)"]
["TARIFAS ANUALES"]
["EDAD",null,null,null,null,null,null,null,null,"ORIGINAL",null,null,null,null,null,0.7]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6",null,"AW2","AW3","AW4","AW5","AW6",null,"AW2","AW3","AW4","AW5","AW6"]
[18,"-  24",null,{"$f":"P274","v":4749},{"$f":"Q274","v":3570},{"$f":"R274","v":2708},{"$f":"S274","v":2061},{"$f":"T274","v":1634},null,4749,3570,2708,2061,1634,null,{"$f":"(J274-50)*1+50","v":4749},{"$f":"(K274-50)*1+50","v":3570},2708,2061,1634]
[25,"-  29",null,5281,3984,3015,2298,1810,null,5281,3984,3015,2298,1810,null,{"$f":"(J275-50)*1+50","v":5281},{"$f":"(K275-50)*1+50","v":3984},{"$f":"(L275-50)*1+50","v":3015},{"$f":"(M275-50)*1+50","v":2298},{"$f":"(N275-50)*1+50","v":1810}]
[30,"-  34",null,6117,4681,3584,2723,2104,null,6117,4681,3584,2723,2104,null,6117,4681,3584,2723,2104]
[35,"-  39",null,6778,5212,3987,3106,2334,null,6778,5212,3987,3106,2334,null,6778,5212,3987,3106,2334]
[40,"-  44",null,7649,5906,4518,3469,2635,null,7649,5906,4518,3469,2635,null,7649,5906,4518,3469,2635]
[45,"-  49",null,8885,6801,5090,3944,3064,null,8885,6801,5090,3944,3064,null,8885,6801,5090,3944,3064]
[50,"-  54",null,9734,7646,5931,4432,3365,null,9734,7646,5931,4432,3365,null,9734,7646,5931,4432,3365]
[55,"-  59",null,11504,8825,6565,5126,3974,null,11504,8825,6565,5126,3974,null,11504,8825,6565,5126,3974]
[60,null,null,12710,9768,7221,5659,4395,null,12710,9768,7221,5659,4395,null,12710,9768,7221,5659,4395]
[61,null,null,14300,10996,8122,6372,4953,null,14300,10996,8122,6372,4953,null,14300,10996,8122,6372,4953]
[62,null,null,15897,12219,9025,7082,5500,null,15897,12219,9025,7082,5500,null,15897,12219,9025,7082,5500]
[63,null,null,17487,13442,9933,7792,6061,null,17487,13442,9933,7792,6061,null,17487,13442,9933,7792,6061]
[64,null,null,19079,14669,10841,8503,6613,null,19079,14669,10841,8503,6613,null,19079,14669,10841,8503,6613]
[65,null,null,20623,15960,11814,9261,7526,null,20623,15960,11814,9261,7526,null,20623,15960,11814,9261,7526]
[66,null,null,21845,16907,12511,9809,7973,null,21845,16907,12511,9809,7973,null,21845,16907,12511,9809,7973]
[67,null,null,24279,18787,13908,10904,8859,null,24279,18787,13908,10904,8859,null,24279,18787,13908,10904,8859]
[68,null,null,26704,20667,15296,11994,9743,null,26704,20667,15296,11994,9743,null,26704,20667,15296,11994,9743]
[69,null,null,27922,21608,15998,12543,10192,null,27922,21608,15998,12543,10192,null,27922,21608,15998,12543,10192]
[70,null,null,28285,21952,16240,12779,10326,null,28285,21952,16240,12779,10326,null,28285,21952,16240,12779,10326]
[71,null,null,31826,24700,18273,14380,11618,null,31826,24700,18273,14380,11618,null,31826,24700,18273,14380,11618]
[72,null,null,35363,27454,20309,15981,12909,null,35363,27454,20309,15981,12909,null,35363,27454,20309,15981,12909]
[73,null,null,38903,30193,22340,17584,14207,null,38903,30193,22340,17584,14207,null,38903,30193,22340,17584,14207]
[74,null,null,42443,32945,24377,19184,15498,null,42443,32945,24377,19184,15498,null,42443,32945,24377,19184,15498]
[75,"o más",null,46426,36745,27955,20997,17786,null,46426,36745,27955,20997,17786,null,46426,36745,27955,20997,17786]
[1,"Hijo",null,2116,1506,1179,1038,748,null,2116,1506,1179,1038,748,null,{"$f":"J298*1","v":2116},{"$f":"K298*1","v":1506},1179,1038,748]
[2,"Hijos",null,3441,2377,1869,1638,1100,null,3441,2377,1869,1638,1100,null,{"$f":"J299*1","v":3441},{"$f":"K299*1","v":2377},{"$f":"L299*1","v":1869},{"$f":"M299*1","v":1638},{"$f":"N299*1","v":1100}]
[3,"Hijos o más",null,5038,3464,2714,2379,1671,null,5038,3464,2714,2379,1671,null,5038,3464,2714,2379,1671]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6"]
[18,"-  24",null,{"$f":"D274*$L$2","v":2516.9700000000003},{"$f":"E274*$L$2","v":1892.1000000000001},1435.24,1092.3300000000002,866.0200000000001]
[25,"-  29",null,{"$f":"D275*$L$2","v":2798.9300000000003},2111.52,1597.95,1217.94,959.30000000000007]
[30,"-  34",null,{"$f":"D276*$L$2","v":3242.01},2480.9300000000003,1899.52,1443.19,1115.1200000000001]
[35,"-  39",null,{"$f":"D277*$L$2","v":3592.34},2762.36,2113.11,1646.18,1237.02]
[40,"-  44",null,{"$f":"D278*$L$2","v":4053.9700000000003},3130.1800000000003,2394.54,1838.5700000000002,1396.5500000000002]
[45,"-  49",null,{"$f":"D279*$L$2","v":4709.05},3604.53,2697.7000000000003,2090.3200000000002,1623.92]
[50,"-  54",null,{"$f":"D280*$L$2","v":5159.0200000000004},4052.38,3143.4300000000003,2348.96,1783.45]
[55,"-  59",null,{"$f":"D281*$L$2","v":6097.12},4677.25,3479.4500000000003,2716.78,2106.2200000000003]
[60,null,null,{"$f":"D282*$L$2","v":6736.3},5177.04,3827.13,2999.27,2329.35]
[61,null,null,{"$f":"D283*$L$2","v":7579},5827.88,4304.66,3377.1600000000003,2625.09]
[62,null,null,{"$f":"D284*$L$2","v":8425.41},6476.0700000000006,4783.25,3753.46,2915]
[63,null,null,{"$f":"D285*$L$2","v":9268.11},7124.26,5264.4900000000007,4129.76,3212.3300000000004]
[64,null,null,{"$f":"D286*$L$2","v":10111.870000000001},7774.5700000000006,5745.7300000000005,4506.59,3504.8900000000003]
[65,null,null,{"$f":"D287*$L$2","v":10930.19},8458.8000000000011,6261.42,4908.33,3988.78]
[66,null,null,{"$f":"D288*$L$2","v":11577.85},8960.7100000000009,6630.83,5198.7700000000004,4225.6900000000005]
[67,null,null,{"$f":"D289*$L$2","v":12867.87},9957.11,7371.2400000000007,5779.12,4695.2700000000004]
[68,null,null,{"$f":"D290*$L$2","v":14153.12},10953.51,8106.88,6356.8200000000006,5163.79]
[69,null,null,{"$f":"D291*$L$2","v":14798.66},11452.24,8478.94,6647.79,5401.76]
[70,null,null,{"$f":"D292*$L$2","v":14991.050000000001},11634.560000000001,8607.2000000000007,6772.87,5472.7800000000007]
[71,null,null,{"$f":"D293*$L$2","v":16867.780000000002},13091,9684.69,7621.4000000000005,6157.54]
[72,null,null,{"$f":"D294*$L$2","v":18742.39},14550.62,10763.77,8469.93,6841.77]
[73,null,null,{"$f":"D295*$L$2","v":20618.59},16002.29,11840.2,9319.52,7529.71]
[74,null,null,{"$f":"D296*$L$2","v":22494.79},17460.850000000002,12919.810000000001,10167.52,8213.94]
[75,"o más",null,{"$f":"D297*$L$2","v":24605.780000000002},19474.850000000002,14816.150000000001,11128.41,9426.58]
[1,"Hijo",null,{"$f":"D298*$L$2","v":1121.48},798.18000000000006,624.87,550.14,396.44]
[2,"Hijos",null,{"$f":"D299*$L$2","v":1823.73},1259.8100000000002,990.57,868.1400000000001,583]
[3,"Hijos o más",null,{"$f":"D300*$L$2","v":2670.1400000000003},1835.92,1438.42,1260.8700000000001,885.63]
[1,"Rider Comp. Maternidad",null,{"$f":"D301*$L$2","v":119.25},119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,{"$f":"D302*$L$2","v":159},159,159,159,159]
[]
["ADVANTAGE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD",null,null,null,null,null,null,null,"ORIGINAL",null,null,null,null,0.1]
[" "," ",null,null,null,null,null,null,"D1","D2","D3","D4","D5","D1","D2","D3","D4","D5"]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD",null,null,null,null,null,null,null,"ORIGINAL",null,null,null,null,0.1]
[" "," ",null,null,null,null,null,null,"D1","D2","D3","D4","D5","D1","D2","D3","D4","D5"]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["SECURE"]
["TARIFAS ANUALES"]
["EDAD",null,null,null,null,null,null,null,null,"ORIGINAL",null,null,null,null,null,0.7]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6",null,"SE2","SE3","SE4","SE5","SE6",null,"SE2","SE3","SE4","SE5","SE6"]
[18,"-  24",null,{"$f":"P408","v":3372},{"$f":"Q408","v":2645},{"$f":"R408","v":2016},{"$f":"S408","v":1727},{"$f":"T408","v":1317},null,3372,2645,2016,1727,1317,null,{"$f":"(J408-50)*1+50","v":3372},{"$f":"(K408-50)*1+50","v":2645},2016,1727,1317]
[25,"-  29",null,3712,2974,2243,1922,1457,null,3712,2974,2243,1922,1457,null,{"$f":"(J409-50)*1+50","v":3712},{"$f":"(K409-50)*1+50","v":2974},{"$f":"(L409-50)*1+50","v":2243},{"$f":"(M409-50)*1+50","v":1922},{"$f":"(N409-50)*1+50","v":1457}]
[30,"-  34",null,4253,3498,2605,2233,1691,null,4253,3498,2605,2233,1691,null,4253,3498,2605,2233,1691]
[35,"-  39",null,4689,3913,2896,2481,1874,null,4689,3913,2896,2481,1874,null,4689,3913,2896,2481,1874]
[40,"-  44",null,5261,4472,3275,2810,2110,null,5261,4472,3275,2810,2110,null,5261,4472,3275,2810,2110]
[45,"-  49",null,6057,5233,3814,3264,2458,null,6057,5233,3814,3264,2458,null,6057,5233,3814,3264,2458]
[50,"-  54",null,6605,5765,4181,3583,2682,null,6605,5765,4181,3583,2682,null,6605,5765,4181,3583,2682]
[55,"-  59",null,7767,6881,4957,4238,3175,null,7767,6881,4957,4238,3175,null,7767,6881,4957,4238,3175]
[60,null,null,8125,7351,5245,4487,3354,null,8125,7351,5245,4487,3354,null,8125,7351,5245,4487,3354]
[61,null,null,9146,8277,5907,5056,3782,null,9146,8277,5907,5056,3782,null,9146,8277,5907,5056,3782]
[62,null,null,10167,9202,6565,5624,4206,null,10167,9202,6565,5624,4206,null,10167,9202,6565,5624,4206]
[63,null,null,11187,10117,7225,6185,4629,null,11187,10117,7225,6185,4629,null,11187,10117,7225,6185,4629]
[64,null,null,12206,11049,7883,6752,5056,null,12206,11049,7883,6752,5056,null,12206,11049,7883,6752,5056]
[65,null,null,12222,11155,7934,6789,5077,null,12222,11155,7934,6789,5077,null,12222,11155,7934,6789,5077]
[66,null,null,12238,11254,7979,6823,5095,null,12238,11254,7979,6823,5095,null,12238,11254,7979,6823,5095]
[67,null,null,13596,12511,8873,7582,5662,null,13596,12511,8873,7582,5662,null,13596,12511,8873,7582,5662]
[68,null,null,14961,13764,9761,8348,6235,null,14961,13764,9761,8348,6235,null,14961,13764,9761,8348,6235]
[69,null,null,15642,14389,10208,8725,6519,null,15642,14389,10208,8725,6519,null,15642,14389,10208,8725,6519]
[70,null,null,15670,14633,10314,8810,6550,null,15670,14633,10314,8810,6550,null,15670,14633,10314,8810,6550]
[71,null,null,17638,16466,11610,9922,7375,null,17638,16466,11610,9922,7375,null,17638,16466,11610,9922,7375]
[72,null,null,19599,18306,12901,11032,8200,null,19599,18306,12901,11032,8200,null,19599,18306,12901,11032,8200]
[73,null,null,21566,20136,14195,12131,9024,null,21566,20136,14195,12131,9024,null,21566,20136,14195,12131,9024]
[74,null,null,23529,21965,15489,13240,9847,null,23529,21965,15489,13240,9847,null,23529,21965,15489,13240,9847]
[75,"o más",null,25643,24098,16940,14481,10757,null,25643,24098,16940,14481,10757,null,25643,24098,16940,14481,10757]
[1,"Hijo",null,1626,959,812,693,513,null,1626,959,812,693,513,null,{"$f":"J432*1","v":1626},{"$f":"K432*1","v":959},812,693,513]
[2,"Hijos",null,2741,1426,1276,1097,811,null,2741,1426,1276,1097,811,null,{"$f":"J433*1","v":2741},{"$f":"K433*1","v":1426},{"$f":"L433*1","v":1276},{"$f":"M433*1","v":1097},{"$f":"N433*1","v":811}]
[3,"Hijos o más",null,4026,2050,1856,1588,1172,null,4026,2050,1856,1588,1172,null,4026,2050,1856,1588,1172]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6"]
[18,"-  24",null,{"$f":"+D408*$L$2","v":1787.16},1401.8500000000001,1068.48,915.31000000000006,698.01]
[25,"-  29",null,{"$f":"+D409*$L$2","v":1967.3600000000001},1576.22,1188.79,1018.6600000000001,772.21]
[30,"-  34",null,{"$f":"+D410*$L$2","v":2254.09},1853.94,1380.65,1183.49,896.23]
[35,"-  39",null,{"$f":"+D411*$L$2","v":2485.17},2073.8900000000003,1534.88,1314.93,993.22]
[40,"-  44",null,{"$f":"+D412*$L$2","v":2788.33},2370.1600000000003,1735.75,1489.3000000000002,1118.3]
[45,"-  49",null,{"$f":"+D413*$L$2","v":3210.21},2773.4900000000002,2021.42,1729.92,1302.74]
[50,"-  54",null,{"$f":"+D414*$L$2","v":3500.65},3055.4500000000003,2215.9300000000003,1898.99,1421.46]
[55,"-  59",null,{"$f":"+D415*$L$2","v":4116.51},3646.9300000000003,2627.21,2246.1400000000003,1682.75]
[60,null,null,{"$f":"+D416*$L$2","v":4306.25},3896.03,2779.8500000000004,2378.11,1777.6200000000001]
[61,null,null,{"$f":"+D417*$L$2","v":4847.38},4386.8100000000004,3130.71,2679.6800000000003,2004.46]
[62,null,null,{"$f":"+D418*$L$2","v":5388.51},4877.0600000000004,3479.4500000000003,2980.7200000000003,2229.1800000000003]
[63,null,null,{"$f":"+D419*$L$2","v":5929.1100000000006},5362.01,3829.25,3278.05,2453.3700000000003]
[64,null,null,{"$f":"+D420*$L$2","v":6469.18},5855.97,4177.99,3578.5600000000004,2679.6800000000003]
[65,null,null,{"$f":"+D421*$L$2","v":6477.6600000000008},5912.1500000000005,4205.0200000000004,3598.17,2690.81]
[66,null,null,{"$f":"+D422*$L$2","v":6486.14},5964.62,4228.87,3616.19,2700.35]
[67,null,null,{"$f":"+D423*$L$2","v":7205.88},6630.83,4702.6900000000005,4018.46,3000.86]
[68,null,null,{"$f":"+D424*$L$2","v":7929.3300000000008},7294.92,5173.33,4424.4400000000005,3304.55]
[69,null,null,{"$f":"+D425*$L$2","v":8290.26},7626.17,5410.2400000000007,4624.25,3455.07]
[70,null,null,{"$f":"+D426*$L$2","v":8305.1},7755.4900000000007,5466.42,4669.3,3471.5]
[71,null,null,{"$f":"+D427*$L$2","v":9348.1400000000012},8726.98,6153.3,5258.66,3908.75]
[72,null,null,{"$f":"+D428*$L$2","v":10387.470000000001},9702.18,6837.5300000000007,5846.96,4346]
[73,null,null,{"$f":"+D429*$L$2","v":11429.980000000001},10672.08,7523.35,6429.43,4782.72]
[74,null,null,{"$f":"+D430*$L$2","v":12470.37},11641.45,8209.17,7017.2000000000007,5218.91]
[75,"o más",null,{"$f":"+D431*$L$2","v":13590.79},12771.94,8978.2000000000007,7674.93,5701.21]
[1,"Hijo",null,{"$f":"+D432*$L$2","v":861.78000000000009},508.27000000000004,430.36,367.29,271.89]
[2,"Hijos",null,{"$f":"+D433*$L$2","v":1452.73},755.78000000000009,676.28000000000009,581.41000000000008,429.83000000000004]
[3,"Hijos o más",null,{"$f":"+D434*$L$2","v":2133.7800000000002},1086.5,983.68000000000006,841.64,621.16000000000008]
[1,"Rider Comp. Maternidad",null,{"$f":"+D435*$L$2","v":119.25},119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,{"$f":"+D436*$L$2","v":159},159,159,159,159]
[]
["ESSENTIAL"]
["TARIFAS ANUALES"]
["EDAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7]
[" "," ",null,"ET2","ET3","ET4","ET5","ET6",null,"ET2","ET3","ET4","ET5","ET6",null,"ET2","ET3","ET4","ET5","ET6"]
[18,"-  24",null,{"$f":"P475","v":2360},{"$f":"Q475","v":1848},{"$f":"R475","v":1410},{"$f":"S475","v":1209},{"$f":"T475","v":916},null,2360,1848,1410,1209,916,null,{"$f":"(J475-50)*1+50","v":2360},{"$f":"(K475-50)*1+50","v":1848},1410,1209,916]
[25,"-  29",null,2597,2086,1567,1352,1020,null,2597,2086,1567,1352,1020,null,{"$f":"(J476-50)*1+50","v":2597},{"$f":"(K476-50)*1+50","v":2086},{"$f":"(L476-50)*1+50","v":1567},{"$f":"(M476-50)*1+50","v":1352},{"$f":"(N476-50)*1+50","v":1020}]
[30,"-  34",null,2977,2454,1824,1569,1180,null,2977,2454,1824,1569,1180,null,2977,2454,1824,1569,1180]
[35,"-  39",null,3284,2742,2030,1744,1312,null,3284,2742,2030,1744,1312,null,3284,2742,2030,1744,1312]
[40,"-  44",null,3688,3135,2293,1973,1479,null,3688,3135,2293,1973,1479,null,3688,3135,2293,1973,1479]
[45,"-  49",null,4248,3672,2670,2295,1723,null,4248,3672,2670,2295,1723,null,4248,3672,2670,2295,1723]
[50,"-  54",null,4631,4047,2930,2518,1887,null,4631,4047,2930,2518,1887,null,4631,4047,2930,2518,1887]
[55,"-  59",null,5448,4832,3471,2989,2230,null,5448,4832,3471,2989,2230,null,5448,4832,3471,2989,2230]
[60,null,null,5705,5164,3682,3164,2361,null,5705,5164,3682,3164,2361,null,5705,5164,3682,3164,2361]
[61,null,null,6423,5812,4147,3563,2665,null,6423,5812,4147,3563,2665,null,6423,5812,4147,3563,2665]
[62,null,null,7143,6463,4608,3966,2968,null,7143,6463,4608,3966,2968,null,7143,6463,4608,3966,2968]
[63,null,null,7857,7115,5079,4364,3266,null,7857,7115,5079,4364,3266,null,7857,7115,5079,4364,3266]
[64,null,null,8581,7762,5541,4762,3563,null,8581,7762,5541,4762,3563,null,8581,7762,5541,4762,3563]
[65,null,null,8585,7838,5570,4792,3578,null,8585,7838,5570,4792,3578,null,8585,7838,5570,4792,3578]
[66,null,null,8596,7908,5608,4815,3585,null,8596,7908,5608,4815,3585,null,8596,7908,5608,4815,3585]
[67,null,null,9551,8795,6233,5356,3991,null,9551,8795,6233,5356,3991,null,9551,8795,6233,5356,3991]
[68,null,null,10516,9675,6859,5895,4395,null,10516,9675,6859,5895,4395,null,10516,9675,6859,5895,4395]
[69,null,null,10990,10116,7174,6157,4602,null,10990,10116,7174,6157,4602,null,10990,10116,7174,6157,4602]
[70,null,null,11015,10289,7251,6220,4624,null,11015,10289,7251,6220,4624,null,11015,10289,7251,6220,4624]
[71,null,null,12399,11580,8160,7006,5202,null,12399,11580,8160,7006,5202,null,12399,11580,8160,7006,5202]
[72,null,null,13776,12874,9071,7787,5790,null,13776,12874,9071,7787,5790,null,13776,12874,9071,7787,5790]
[73,null,null,15165,14162,9982,8572,6368,null,15165,14162,9982,8572,6368,null,15165,14162,9982,8572,6368]
[74,null,null,16546,15454,10891,9354,6956,null,16546,15454,10891,9354,6956,null,16546,15454,10891,9354,6956]
[75,"o más",null,18035,16948,11916,10233,7598,null,18035,16948,11916,10233,7598,null,18035,16948,11916,10233,7598]
[1,"Hijo",null,1147,678,572,494,366,null,1147,678,572,494,366,null,{"$f":"J499*1","v":1147},{"$f":"K499*1","v":678},572,494,366]
[2,"Hijos",null,1932,1006,897,772,574,null,1932,1006,897,772,574,null,{"$f":"J500*1","v":1932},{"$f":"K500*1","v":1006},{"$f":"L500*1","v":897},{"$f":"M500*1","v":772},{"$f":"N500*1","v":574}]
[3,"Hijos o más",null,2834,1444,1304,1121,828,null,2834,1444,1304,1121,828,null,2834,1444,1304,1121,828]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"ET2","ET3","ET4","ET5","ET6"]
[18,"-  24",null,{"$f":"+D475*$L$2","v":1250.8},979.44,747.30000000000007,640.77,485.48]
[25,"-  29",null,1376.41,1105.5800000000002,830.51,716.56000000000006,540.6]
[30,"-  34",null,1577.8100000000002,1300.6200000000001,966.72,831.57,625.4]
[35,"-  39",null,1740.52,1453.26,1075.9000000000001,924.32,695.36]
[40,"-  44",null,1954.64,1661.5500000000002,1215.29,1045.69,783.87]
[45,"-  49",null,2251.44,1946.16,1415.1000000000001,1216.3500000000001,913.19]
[50,"-  54",null,2454.4300000000003,2144.9100000000003,1552.9,1334.54,1000.11]
[55,"-  59",null,2887.44,2560.96,1839.63,1584.17,1181.9000000000001]
[60,null,null,3023.65,2736.92,1951.46,1676.92,1251.3300000000002]
[61,null,null,3404.19,3080.36,2197.9100000000003,1888.39,1412.45]
[62,null,null,{"$f":"+D485*$L$2","v":3785.79},3425.3900000000003,2442.2400000000002,2101.98,1573.0400000000002]
[63,null,null,4164.21,3770.9500000000003,2691.8700000000003,2312.92,1730.98]
[64,null,null,4547.93,4113.8600000000006,2936.73,2523.86,1888.39]
[65,null,null,4550.05,4154.1400000000003,2952.1000000000004,2539.7600000000002,1896.3400000000001]
[66,null,null,4555.88,4191.24,2972.2400000000002,2551.9500000000003,1900.0500000000002]
[67,null,null,5062.0300000000007,4661.3500000000004,3303.4900000000002,2838.6800000000003,2115.23]
[68,null,null,5573.4800000000005,5127.75,3635.27,3124.3500000000004,2329.35]
[69,null,null,5824.7000000000007,5361.4800000000005,3802.2200000000003,3263.21,2439.06]
[70,null,null,5837.9500000000007,5453.17,3843.03,3296.6000000000004,2450.7200000000003]
[71,null,null,6571.47,6137.4000000000005,4324.8,3713.1800000000003,2757.06]
[72,null,null,{"$f":"+D495*$L$2","v":7301.2800000000007},6823.22,4807.63,4127.1100000000006,3068.7000000000003]
[73,null,null,8037.4500000000007,7505.8600000000006,5290.46,4543.16,3375.04]
[74,null,null,8769.380000000001,8190.6200000000008,5772.2300000000005,4957.62,3686.6800000000003]
[75,"o más",null,9558.5500000000011,8982.44,6315.4800000000005,5423.4900000000007,4026.94]
[1,"Hijo",null,607.91000000000008,359.34000000000003,303.16000000000003,261.82,193.98000000000002]
[2,"Hijos",null,1023.96,533.18000000000006,475.41,409.16,304.22000000000003]
[3,"Hijos o más",null,1502.02,765.32,691.12,594.13,438.84000000000003]
[1,"Rider Comp. Maternidad",null,119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,159,159,159,159,159]
[]
["CRITICAL"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","CR1",null,null,"CR2",null,null,"CR3",null,null,"CR4",null,null,"CR5",null,null,"CR6"]
[null,null,"INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR"]
[18,"-  49",{"$f":"C557","v":2255},{"$f":"D557","v":4100},5950,1964,3492,5024,1682,3044,4396,1292,2309,3325,917,1607,2299,516,856,1202]
[50,"o más",{"$f":"C558","v":2898},4748,6595,2523,4048,5578,2161,3516,4867,1648,2662,3680,1153,1853,2536,637,980,1327]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","CR1",null,null,"CR2",null,null,"CR3",null,null,"CR4",null,null,"CR5",null,null,"CR6"]
[null,null,"INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR"]
[18,"-  25",{"$f":"+C543*$L$2","v":1195.1500000000001},2173,3153.5,1040.92,1850.76,2662.7200000000003,891.46,1613.3200000000002,2329.88,684.76,1223.77,1762.25,486.01000000000005,851.71,1218.47,273.48,453.68,637.06000000000006]
[75,"o más",{"$f":"+C544*$L$2","v":1535.94},2516.44,3495.3500000000004,1337.19,2145.44,2956.34,1145.3300000000002,1863.48,2579.5100000000002,873.44,1410.8600000000001,1950.4,611.09,982.09,1344.0800000000002,337.61,519.4,703.31000000000006]
[]
[]
[]
[]
[]
[null,null,2255,4100,5950,1964,3492,5024,1682,3044,4396,1292,2309,3325,917,1607,2299,516,856,1202]
[null,null,2898,4748,6595,2523,4048,5578,2161,3516,4867,1648,2662,3680,1153,1853,2536,637,980,1327]