{"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":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,0,7,9],[15,7,15,8],[11,3,11,9],[19,3,19,6],[13,3,13,5],[13,7,13,8]]}
[]
[null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null," "," "," "," "]
[]
["COTIZACION DE SEGURO MEDICO INTERNACIONAL"]
[]
["1. INGRESE LOS DATOS DEL PROPUESTO ASEGURADO :"]
[]
[null,"Nombre del Asegurado principal :",null,"NOMBRE COMPLETO"]
[]
[null,null,null,"Número de adultos en la póliza : ",null,null,1,"Número de hijos en la póliza :",null,0]
[]
[null,null,null,null," Edad del titular :",null,18,"Edad de cónyuge :",null,18]
[]
["2. INGRESE EL NOMBRE DE LA AGENCIA ASESORA :"]
[]
[null,"Nombre de la Agencia :",null,"AGENCIA"]
[]
["3. ESCOJA EL PRODUCTO PARA VISUALIZAR LA COTIZACION RESPECTIVA :"]

{"sheet":"Exclusive","index":1,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[32,0,32,1],[33,0,33,1],[32,2,32,3],[44,2,44,3],[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],[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],[34,2,34,3],[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],[33,2,33,3],[41,2,41,3],[27,0,27,1],[20,0,21,1],[31,2,31,3],[27,2,27,3],[29,0,29,1],[30,0,31,1],[20,2,20,3],[22,2,22,3],[28,2,28,3],[28,0,28,1],[9,2,9,12],[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],[40,2,40,3],[35,2,35,3],[39,0,39,1],[46,0,46,1],[47,2,47,3],[35,0,35,1],[36,0,38,1],[36,2,38,3],[39,2,39,3],[42,2,42,3],[51,0,51,1],[51,2,51,3],[50,0,50,1],[50,2,50,3],[43,2,43,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$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$20","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-10-25T11:24:40.820"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,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":9549},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":6307},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":4433},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":3145},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":2473}]
[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":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$33)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$33)","v":225}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":9549},{"$f":"SUM(J31:J34)","v":6307},{"$f":"SUM(K31:K34)","v":4658},{"$f":"SUM(L31:L34)","v":3370},{"$f":"SUM(M31:M34)","v":2698}]
[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":9624},{"$f":"SUM(J35:J36)","v":6382},{"$f":"SUM(K35:K36)","v":4733},{"$f":"SUM(L35:L36)","v":3445},{"$f":"SUM(M35:M36)","v":2773}]
[]
[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":5060.97},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":3342.71},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":2349.4900000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":1666.8500000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":1310.69}]
[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":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$66)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$66)","v":119.25}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":5060.97},{"$f":"SUM(J40:J43)","v":3342.71},{"$f":"SUM(K40:K43)","v":2468.7400000000002},{"$f":"SUM(L40:L43)","v":1786.1000000000001},{"$f":"SUM(M40:M43)","v":1429.94}]
[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":5135.97},{"$f":"SUM(J44:J45)","v":3417.71},{"$f":"SUM(K44:K45)","v":2543.7400000000002},{"$f":"SUM(L44:L45)","v":1861.1000000000001},{"$f":"SUM(M44:M45)","v":1504.94}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":5060.97},{"$f":"J44","v":3342.71},2468.7400000000002,1786.1000000000001,1429.94]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2021"]
[]
[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":"Privilege","index":2,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,0,48,1],[48,2,48,3],[45,0,45,1],[45,2,45,3],[35,0,35,1],[46,2,47,3],[35,2,35,3],[36,0,36,1],[42,2,42,3],[36,2,36,3],[43,0,43,1],[39,2,39,3],[40,2,40,3],[37,2,37,3],[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],[38,2,38,3],[30,0,31,1],[29,2,29,3],[32,0,32,1],[22,2,22,3],[43,2,43,3],[19,0,19,1],[17,0,18,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[26,2,26,3],[32,2,32,3],[26,0,26,1],[27,0,27,1],[33,2,33,3],[31,2,31,3],[42,0,42,1],[28,0,28,1],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,18,3],[49,0,49,1],[49,2,49,3],[47,5,47,12],[12,2,12,3],[13,2,13,3],[46,0,47,1],[44,2,44,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[21,2,21,3],[20,2,20,3],[25,2,25,3],[27,2,27,3],[28,2,28,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 PRIVILEGE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$20","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-10-25T11:24:40.820"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,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":7991},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":5496},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":3836},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":2721},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":2070}]
[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":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$167)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$167)","v":225}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":7991},{"$f":"SUM(J31:J34)","v":5496},{"$f":"SUM(K31:K34)","v":4061},{"$f":"SUM(L31:L34)","v":2946},{"$f":"SUM(M31:M34)","v":2295}]
[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":8066},{"$f":"SUM(J35:J36)","v":5571},{"$f":"SUM(K35:K36)","v":4136},{"$f":"SUM(L35:L36)","v":3021},{"$f":"SUM(M35:M36)","v":2370}]
[]
[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":4235.2300000000005},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":2912.88},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":2033.0800000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":1442.13},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":1097.1000000000001}]
[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":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$200)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$200)","v":119.25}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":4235.2300000000005},{"$f":"SUM(J40:J43)","v":2912.88},{"$f":"SUM(K40:K43)","v":2152.33},{"$f":"SUM(L40:L43)","v":1561.38},{"$f":"SUM(M40:M43)","v":1216.3500000000001}]
[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":4310.2300000000005},{"$f":"SUM(J44:J45)","v":2987.88},{"$f":"SUM(K44:K45)","v":2227.33},{"$f":"SUM(L44:L45)","v":1636.38},{"$f":"SUM(M44:M45)","v":1291.3500000000001}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":4235.2300000000005},{"$f":"J44","v":2912.88},2152.33,1561.38,1216.3500000000001]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2021"]
[]
[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":[[51,5,52,12],[33,0,33,1],[34,0,34,1],[48,2,48,3],[47,2,47,3],[44,0,44,1],[46,0,46,1],[45,2,45,3],[45,0,45,1],[35,0,41,1],[51,0,52,1],[33,2,33,3],[49,0,49,1],[50,0,50,1],[47,0,47,1],[48,0,48,1],[19,0,19,1],[24,2,24,3],[42,0,42,1],[42,2,42,3],[29,0,29,1],[34,2,34,3],[32,2,32,3],[32,0,32,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[26,0,26,1],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[20,0,21,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[30,2,30,3],[21,2,21,3],[22,2,22,3],[20,2,20,3],[25,2,25,3],[23,2,23,3],[50,2,50,3],[46,2,46,3],[44,2,44,3],[51,2,52,3],[35,2,39,3],[40,2,41,3],[49,5,49,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],[49,2,49,3],[31,2,31,3],[19,2,19,3],[54,0,54,1],[54,2,54,3],[53,0,53,1],[53,2,53,3],[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]]}
[]
[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$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$20","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-10-25T11:24:40.820"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,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$274:$H$297,4,TRUE)","v":5313},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":3993},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":2990},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":2293},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":1816}]
[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":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$301)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$301)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$301)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$301)","v":225}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$302)","v":300}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":5838},4518,3515,2818,2341]
[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":5913},{"$f":"SUM(J36:J37)","v":4593},{"$f":"SUM(K36:K37)","v":3590},{"$f":"SUM(L36:L37)","v":2893},{"$f":"SUM(M36:M37)","v":2416}]
[]
[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":2815.8900000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":2116.29},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":1584.7},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":1215.29},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":962.48}]
[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":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$334)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$334)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$334)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$334)","v":119.25}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$335)","v":159}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":3094.1400000000003},2394.54,1862.95,1493.54,1240.73]
[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":3169.1400000000003},{"$f":"SUM(J46:J47)","v":2469.54},{"$f":"SUM(K46:K47)","v":1937.95},{"$f":"SUM(L46:L47)","v":1568.54},{"$f":"SUM(M46:M47)","v":1315.73}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":3094.1400000000003},{"$f":"J46","v":2394.54},1862.95,1493.54,1240.73]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2021"]
[]
[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":[[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
["Bupa Advantage Care (cobertura solo en Latinoamérica)",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE 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$20","v":"AGENCIA"}]
["Condiciones médicas cubiertas",null,"Todas las condiciones médicas"]
["Redes de proveedores",null,"Red de Proveedores \"Bupa Advantage\"",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","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":"2021-10-25T11:24:40.820"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
["Número máximo de días de hospitalización",null,"Ilimitado",null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
["Habitación y alimentación",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
["Cuidados Intensivos",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null," "]
["Cobertura de Maternidad",null,"$5,000 (Excepto planes 4,5, y 6)",null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Cobertura Provisional de Recién Nacido",null,"$30,000 por los primeros 90 días",null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Cuidado del Recién Nacido saludable",null,"Ya incluída dentro del beneficio de Maternidad",null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
["Cobertura de Complicaciones de Maternidad",null,"Disponible a través de cobertura opcional adicional"]
["Trasplante de Organos",null,"$1,000,000 de por vida, por diagnóstico"]
["Condiciones congénitas y hereditarias",null,"<18 años $300,000 de por vida; >=18 al 100%",null,null,"Tarifas Anuales"]
["Coberturas opcionales (Riders)",null,"Complicaciones de Maternidad por $500,000",null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,4,TRUE)","v":3936},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":2956},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":2212},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":1689},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":1335}]
[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":3936},2956,2212,1689,1335]
["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":4011},{"$f":"SUM(J36:J37)","v":3031},{"$f":"SUM(K36:K37)","v":2287},{"$f":"SUM(L36:L37)","v":1764},{"$f":"SUM(M36:M37)","v":1410}]
["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":2086.08},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":1566.68},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":1172.3600000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":895.17000000000007},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":707.55000000000007}]
["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":2086.08},1566.68,1172.3600000000001,895.17000000000007,707.55000000000007]
[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":2161.08},{"$f":"SUM(J46:J47)","v":1641.68},{"$f":"SUM(K46:K47)","v":1247.3600000000001},{"$f":"SUM(L46:L47)","v":970.17000000000007},{"$f":"SUM(M46:M47)","v":782.55000000000007}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2086.08},{"$f":"J46","v":1566.68},1172.3600000000001,895.17000000000007,707.55000000000007]
[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":[[43,2,43,3],[44,2,44,3],[51,5,53,12],[43,0,43,1],[35,2,39,3],[49,5,49,12],[46,2,46,3],[42,2,42,3],[42,0,42,1],[49,0,49,1],[49,2,49,3],[9,2,9,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],[22,0,23,1],[24,0,24,1],[25,0,25,1],[20,0,21,1],[25,2,25,3],[34,2,34,3],[40,2,41,3],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,0,29,1],[15,0,15,1],[26,0,26,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],[16,0,16,1],[19,0,19,1],[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]]}
[]
[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$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$20","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-10-25T11:24:40.820"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,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$408:$H$431,4,TRUE)","v":4067},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":3191},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":2398},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":2076},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":1575}]
[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":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$435)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$435)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$435)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$435)","v":225}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$436)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$436)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$436)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$436)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$436)","v":300}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":4592},3716,2923,2601,2100]
[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":4667},{"$f":"SUM(J36:J37)","v":3791},{"$f":"SUM(K36:K37)","v":2998},{"$f":"SUM(L36:L37)","v":2676},{"$f":"SUM(M36:M37)","v":2175}]
[]
[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":2155.5100000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":1691.23},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":1270.94},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":1100.28},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":834.75}]
[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":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$468)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$468)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$468)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$468)","v":119.25}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$469)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$469)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$469)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$469)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$469)","v":159}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":2433.7600000000002},1969.48,1549.19,1378.53,1113]
[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":2508.7600000000002},{"$f":"SUM(J46:J47)","v":2044.48},{"$f":"SUM(K46:K47)","v":1624.19},{"$f":"SUM(L46:L47)","v":1453.53},{"$f":"SUM(M46:M47)","v":1188}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2433.7600000000002},{"$f":"J46","v":1969.48},1549.19,1378.53,1113]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2021"]
[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":[[51,5,53,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],[9,2,9,12],[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],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[35,2,39,3],[33,0,33,1],[34,0,34,1],[35,0,41,1],[40,2,41,3],[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]]}
[]
[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$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$20","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-10-25T11:24:40.820"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[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":3416},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":2681},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":2011},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":1737},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":1323}]
[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":3716},2981,2311,2037,1623]
[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":3791},{"$f":"SUM(J36:J37)","v":3056},{"$f":"SUM(K36:K37)","v":2386},{"$f":"SUM(L36:L37)","v":2112},{"$f":"SUM(M36:M37)","v":1698}]
[]
[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":1810.48},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":1420.93},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":1065.8300000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":920.61},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":701.19}]
[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":1969.48},1579.93,1224.8300000000002,1079.6100000000001,860.19]
[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":2044.48},{"$f":"SUM(J46:J47)","v":1654.93},{"$f":"SUM(K46:K47)","v":1299.8300000000002},{"$f":"SUM(L46:L47)","v":1154.6100000000001},{"$f":"SUM(M46:M47)","v":935.19}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":1969.48},{"$f":"J46","v":1579.93},1224.8300000000002,1079.6100000000001,860.19]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2021"]
[]
[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":[[52,5,54,12],[25,8,25,9],[26,8,26,9],[21,10,22,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],[23,8,23,9],[24,8,24,9],[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],[29,0,29,1],[30,0,31,1],[29,2,29,3],[32,2,32,3],[33,2,33,3],[27,2,27,3],[28,2,28,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],[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],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[35,2,39,3],[34,8,34,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[45,2,45,3],[23,10,24,11],[33,10,36,12],[21,5,22,7],[21,8,22,9],[26,2,26,3],[17,2,18,3],[19,2,19,3],[20,2,20,3],[16,2,16,3],[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],[14,0,14,1],[13,0,13,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," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa CRITICAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$20","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-10-25T11:24:40.820"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[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":18}]
[]
[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":2195},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,6,TRUE)),0)","v":1778},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,9,TRUE)),0)","v":1519},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,12,TRUE)),0)","v":1207},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,15,TRUE)),0)","v":907},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,18,TRUE)),0)","v":568}]
[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":2195},{"$f":"SUM(I44:I46)","v":1778},1519,1207,907,568]
[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":2270},1853,1594,1282,982,643]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2021"]
[]
[]
[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":[[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],[13,2,13,7],[15,2,15,7],[19,0,19,1],[18,0,18,1],[11,2,11,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$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,{"$f":"+'INGRESO DE DATOS'!$D$20","v":"AGENCIA"}]
[]
[null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2021-10-25T11:24:40.820"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[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":9624},{"$f":"+Exclusive!J37","v":6382},{"$f":"+Exclusive!K37","v":4733},{"$f":"+Exclusive!L37","v":3445},{"$f":"+Exclusive!M37","v":2773}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":8066},{"$f":"+Privilege!J37","v":5571},{"$f":"+Privilege!K37","v":4136},{"$f":"+Privilege!L37","v":3021},{"$f":"+Privilege!M37","v":2370}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":5913},{"$f":"+'Advantage (Mundial)'!J38","v":4593},{"$f":"+'Advantage (Mundial)'!K38","v":3590},{"$f":"+'Advantage (Mundial)'!L38","v":2893},{"$f":"+'Advantage (Mundial)'!M38","v":2416}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":4667},{"$f":"+Secure!J38","v":3791},{"$f":"+Secure!K38","v":2998},{"$f":"+Secure!L38","v":2676},{"$f":"+Secure!M38","v":2175}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":3791},{"$f":"+Essential!J38","v":3056},{"$f":"+Essential!K38","v":2386},{"$f":"+Essential!L38","v":2112},{"$f":"+Essential!M38","v":1698}]
[]
["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":2270},{"$f":"+Critical!I49","v":1853},{"$f":"+Critical!J49","v":1594},{"$f":"+Critical!K49","v":1282},{"$f":"+Critical!L49","v":982},{"$f":"+Critical!M49","v":643}]
["Tarifas en US $ -  Válidas desde 01 enero 2021"]
[]
["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":[[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],[38,0,42,0],[25,0,27,0],[26,1,27,1],[26,2,27,2],[26,3,27,3],[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]]}
[]
[null,"2021 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":557,"n_cols":20,"rows_kept":557,"cut":false,"hidden":false,"merged":[[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],[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],[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],[470,0,470,7],[403,0,403,7],[404,0,404,7],[405,0,405,1],[405,2,405,6],[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],[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],[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]]}
[]
["EXCLUSIVE",null,null,null,null,null,null,null,null,"FACTOR SEMESTRAL :",null,0.53]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",null,9549,6307,4433,3145,2473,null,true,true,true,true,true]
[25,"-  29",null,10015,6970,4913,3488,2740,null,true,true,true,true,true]
[30,"-  34",null,10420,7477,5500,4182,3298,null,true,true,true,true,true]
[35,"-  39",null,11670,8371,6167,4688,3693,null,true,true,true,true,true]
[40,"-  44",null,13531,9159,6843,5154,4060,null,true,true,true,true,true]
[45,"-  49",null,15129,10241,7651,5756,4538,null,true,true,true,true,true]
[50,"-  54",null,19358,13435,9983,8137,6415,null,true,true,true,true,true]
[55,"-  59",null,20598,14299,10619,8658,6830,null,true,true,true,true,true]
[60,null,null,22440,15597,12221,10432,8483,null,true,true,true,true,true]
[61,null,null,24106,16763,13126,11213,9118,null,true,true,true,true,true]
[62,null,null,26393,18359,14381,12275,9983,null,true,true,true,true,true]
[63,null,null,28066,19520,15282,13057,10614,null,true,true,true,true,true]
[64,null,null,30357,21123,16539,14122,11489,null,true,true,true,true,true]
[65,null,null,39687,27549,20911,18834,16200,null,true,true,true,true,true]
[66,null,null,46105,32014,24298,21897,18825,null,true,true,true,true,true]
[67,null,null,50363,34966,26541,23908,20564,null,true,true,true,true,true]
[68,null,null,55765,38712,29392,26482,22769,null,true,true,true,true,true]
[69,null,null,61357,42592,32340,29133,25056,null,true,true,true,true,true]
[70,null,null,75512,51866,38070,33948,29475,null,true,true,true,true,true]
[71,null,null,78482,53902,39567,35285,30636,null,true,true,true,true,true]
[72,null,null,80703,55428,40682,36284,31500,null,true,true,true,true,true]
[73,null,null,83667,57469,42174,37616,32654,null,true,true,true,true,true]
[74,null,null,85147,58480,42930,38286,33235,null,true,true,true,true,true]
[75,"o más",null,88857,61027,44791,39951,34686,null,true,true,true,true,true]
[1,"Hijo",null,3318,2444,1981,1673,1303,null,true,true,true,true,true]
[2,"Hijos",null,5279,3892,3155,2651,2069,null,true,true,true,true,true]
[3,"Hijos o más",null,7735,5700,4620,3890,3031,null,true,true,true,true,true]
[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":"$L$2*D6","v":5060.97},{"$f":"$L$2*E6","v":3342.71},2349.4900000000002,1666.8500000000001,1310.69]
[25,"-  29",null,{"$f":"$L$2*D7","v":5307.95},3694.1000000000004,2603.8900000000003,1848.64,1452.2]
[30,"-  34",null,5522.6,3962.8100000000004,2915,2216.46,1747.94]
[35,"-  39",null,6185.1,4436.63,3268.51,2484.6400000000003,1957.2900000000002]
[40,"-  44",null,7171.43,4854.2700000000004,3626.79,2731.6200000000003,2151.8000000000002]
[45,"-  49",null,8018.3700000000008,5427.7300000000005,4055.03,3050.6800000000003,2405.1400000000003]
[50,"-  54",null,10259.74,7120.55,5290.9900000000007,4312.6100000000006,3399.9500000000003]
[55,"-  59",null,10916.94,7578.47,5628.0700000000006,4588.74,3619.9]
[60,null,null,11893.2,8266.41,6477.13,5528.96,4495.99]
[61,null,null,12776.18,8884.3900000000012,6956.7800000000007,5942.89,4832.54]
[62,null,null,13988.29,9730.27,7621.93,6505.75,5290.9900000000007]
[63,null,null,14874.980000000001,10345.6,8099.46,6920.21,5625.42]
[64,null,null,16089.210000000001,11195.19,8765.67,7484.6600000000008,6089.17]
[65,null,null,21034.11,14600.970000000001,11082.83,9982.02,8586]
[66,null,null,24435.65,16967.420000000002,12877.94,11605.41,9977.25]
[67,null,null,26692.390000000003,18531.98,14066.730000000001,12671.24,10898.92]
[68,null,null,29555.45,20517.36,15577.76,14035.460000000001,12067.57]
[69,null,null,32519.210000000003,22573.760000000002,17140.2,15440.490000000002,13279.68]
[70,null,null,40021.360000000001,27488.98,20177.100000000002,17992.440000000002,15621.75]
[71,null,null,41595.46,28568.06,20970.510000000002,18701.05,16237.08]
[72,null,null,42772.590000000004,29376.84,21561.460000000003,19230.52,16695]
[73,null,null,44343.51,30458.570000000003,22352.22,19936.48,17306.620000000003]
[74,null,null,45127.91,30994.400000000001,22752.9,20291.580000000002,17614.55]
[75,"o más",null,47094.21,32344.31,23739.23,21174.030000000002,18383.580000000002]
[1,"Hijo",null,1758.5400000000002,1295.3200000000002,1049.93,886.69,690.59]
[2,"Hijos",null,2797.8700000000003,2062.7600000000002,1672.15,1405.03,1096.5700000000002]
[3,"Hijos o más",null,4099.55,3021,2448.6,2061.7000000000003,1606.43]
[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,"CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",null,7991,5496,3836,2721,2070,null,true,true,true,true,true]
[25,"-  29",null,8386,6079,4248,3013,2296,null,true,true,true,true,true]
[30,"-  34",null,8761,6502,4767,3642,2787,null,true,true,true,true,true]
[35,"-  39",null,9805,7277,5341,4086,3117,null,true,true,true,true,true]
[40,"-  44",null,11352,7983,5940,4504,3440,null,true,true,true,true,true]
[45,"-  49",null,12685,8922,6637,5036,3848,null,true,true,true,true,true]
[50,"-  54",null,16579,11770,8714,7181,5490,null,true,true,true,true,true]
[55,"-  59",null,17636,12516,9272,7642,5844,null,true,true,true,true,true]
[60,null,null,19208,13591,10555,9088,7305,null,true,true,true,true,true]
[61,null,null,20636,14601,11336,9769,7845,null,true,true,true,true,true]
[62,null,null,22589,15992,12415,10695,8592,null,true,true,true,true,true]
[63,null,null,24019,17000,13199,11375,9133,null,true,true,true,true,true]
[64,null,null,25977,18396,14285,12306,9883,null,true,true,true,true,true]
[65,null,null,33964,23987,18055,16406,13931,null,true,true,true,true,true]
[66,null,null,39455,27874,20977,19068,16186,null,true,true,true,true,true]
[67,null,null,43090,30442,22912,20818,17683,null,true,true,true,true,true]
[68,null,null,47711,33704,25374,23057,19576,null,true,true,true,true,true]
[69,null,null,52494,37080,27912,25365,21543,null,true,true,true,true,true]
[70,null,null,64605,45150,32857,29561,25334,null,true,true,true,true,true]
[71,null,null,67142,46920,34144,30719,26334,null,true,true,true,true,true]
[72,null,null,69047,48248,35114,31587,27077,null,true,true,true,true,true]
[73,null,null,71575,50023,36400,32750,28077,null,true,true,true,true,true]
[74,null,null,72843,50907,37047,33333,28571,null,true,true,true,true,true]
[75,"o más",null,76016,53123,38660,34782,29811,null,true,true,true,true,true]
[1,"Hijo",null,2770,2025,1559,1317,974,null,true,true,true,true,true]
[2,"Hijos",null,4403,3223,2483,2092,1549,null,true,true,true,true,true]
[3,"Hijos o más",null,6461,4722,3637,3062,2269,null,true,true,true,true,true]
[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":"$L$2*D140","v":4235.2300000000005},{"$f":"$L$2*E140","v":2912.88},2033.0800000000002,1442.13,1097.1000000000001]
[25,"-  29",null,{"$f":"$L$2*D141","v":4444.58},3221.8700000000003,2251.44,1596.89,1216.8800000000001]
[30,"-  34",null,4643.33,3446.0600000000004,2526.5100000000002,1930.26,1477.1100000000001]
[35,"-  39",null,5196.6500000000005,3856.8100000000004,2830.73,2165.58,1652.01]
[40,"-  44",null,6016.56,4230.99,3148.2000000000003,2387.1200000000003,1823.2]
[45,"-  49",null,6723.05,4728.66,3517.61,2669.08,2039.44]
[50,"-  54",null,8786.8700000000008,6238.1,4618.42,3805.9300000000003,2909.7000000000003]
[55,"-  59",null,9347.08,6633.4800000000005,4914.16,4050.26,3097.32]
[60,null,null,10180.24,7203.2300000000005,5594.1500000000005,4816.6400000000003,3871.65]
[61,null,null,10937.08,7738.5300000000007,6008.08,5177.5700000000006,4157.8500000000004]
[62,null,null,11972.17,8475.76,6579.9500000000007,5668.35,4553.76]
[63,null,null,12730.070000000002,9010,6995.47,6028.75,4840.4900000000007]
[64,null,null,13767.810000000001,9749.880000000001,7571.05,6522.18,5237.9900000000007]
[65,null,null,18000.920000000002,12713.11,9569.15,8695.18,7383.43]
[66,null,null,20911.150000000001,14773.220000000001,11117.810000000001,10106.040000000001,8578.58]
[67,null,null,22837.7,16134.26,12143.36,11033.54,9371.99]
[68,null,null,25286.83,17863.120000000003,13448.220000000001,12220.210000000001,10375.280000000001]
[69,null,null,27821.82,19652.400000000001,14793.36,13443.45,11417.79]
[70,null,null,34240.65,23929.5,17414.21,15667.33,13427.02]
[71,null,null,35585.26,24867.600000000002,18096.32,16281.070000000002,13957.02]
[72,null,null,36594.910000000003,25571.440000000002,18610.420000000002,16741.11,14350.810000000001]
[73,null,null,37934.75,26512.190000000002,19292,17357.5,14880.810000000001]
[74,null,null,38606.79,26980.710000000003,19634.91,17666.490000000002,15142.630000000001]
[75,"o más",null,40288.480000000003,28155.190000000002,20489.8,18434.46,15799.83]
[1,"Hijo",null,1468.1000000000001,1073.25,826.2700000000001,698.01,516.22]
[2,"Hijos",null,2333.59,1708.19,1315.99,1108.76,820.97]
[3,"Hijos o más",null,3424.3300000000004,2502.6600000000003,1927.6100000000001,1622.8600000000001,1202.5700000000002]
[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,"AW2","AW3","AW4","AW5","AW6"]
[18,"-  24",null,5313,3993,2990,2293,1816,null,true,true,true,true,true]
[25,"-  29",null,5907,4451,3326,2561,2019,null,true,true,true,true,true]
[30,"-  34",null,6837,5234,3952,3031,2338,null,true,true,true,true,true]
[35,"-  39",null,7585,5828,4396,3455,2590,null,true,true,true,true,true]
[40,"-  44",null,8560,6602,4983,3859,2934,null,true,true,true,true,true]
[45,"-  49",null,9945,7608,5623,4395,3407,null,true,true,true,true,true]
[50,"-  54",null,10894,8551,6550,4931,3740,null,true,true,true,true,true]
[55,"-  59",null,12873,9870,7245,5712,4424,null,true,true,true,true,true]
[60,null,null,14223,10929,7963,6302,4897,null,true,true,true,true,true]
[61,null,null,16005,12299,8969,7093,5517,null,true,true,true,true,true]
[62,null,null,17792,13669,9970,7886,6129,null,true,true,true,true,true]
[63,null,null,19572,15044,10967,8682,6747,null,true,true,true,true,true]
[64,null,null,21352,16412,11970,9476,7362,null,true,true,true,true,true]
[65,null,null,23086,17864,13047,10320,8379,null,true,true,true,true,true]
[66,null,null,24444,18918,13817,10926,8875,null,true,true,true,true,true]
[67,null,null,27164,21018,15355,12146,9862,null,true,true,true,true,true]
[68,null,null,29888,23131,16896,13359,10855,null,true,true,true,true,true]
[69,null,null,31246,24178,17664,13969,11353,null,true,true,true,true,true]
[70,null,null,31651,24568,17933,14231,11497,null,true,true,true,true,true]
[71,null,null,35611,27644,20176,16017,12941,null,true,true,true,true,true]
[72,null,null,39577,30715,22421,17798,14383,null,true,true,true,true,true]
[73,null,null,43537,33792,24663,19582,15821,null,true,true,true,true,true]
[74,null,null,47500,36870,26917,21373,17261,null,true,true,true,true,true]
[75,"o más",null,51964,41124,30870,23393,19812,null,true,true,true,true,true]
[1,"Hijo",null,2367,1686,1305,1154,829,null,true,true,true,true,true]
[2,"Hijos",null,3852,2659,2057,1828,1223,null,true,true,true,true,true]
[3,"Hijos o más",null,5637,3873,2998,2647,1858,null,true,true,true,true,true]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6"]
[18,"-  24",null,{"$f":"$L$2*D274","v":2815.8900000000003},{"$f":"$L$2*E274","v":2116.29},1584.7,1215.29,962.48]
[25,"-  29",null,{"$f":"$L$2*D275","v":3130.71},2359.0300000000002,1762.7800000000002,1357.3300000000002,1070.0700000000002]
[30,"-  34",null,3623.61,2774.02,2094.56,1606.43,1239.1400000000001]
[35,"-  39",null,4020.05,3088.84,2329.88,1831.15,1372.7]
[40,"-  44",null,4536.8,3499.0600000000004,2640.9900000000002,2045.2700000000002,1555.02]
[45,"-  49",null,5270.85,4032.2400000000002,2980.19,2329.35,1805.71]
[50,"-  54",null,5773.8200000000006,4532.0300000000007,3471.5,2613.4300000000003,1982.2]
[55,"-  59",null,6822.6900000000005,5231.1000000000004,3839.8500000000004,3027.36,2344.7200000000003]
[60,null,null,7538.1900000000005,5792.37,4220.3900000000003,3340.06,2595.4100000000003]
[61,null,null,8482.65,6518.47,4753.5700000000006,3759.29,2924.01]
[62,null,null,9429.76,7244.5700000000006,5284.1,4179.58,3248.3700000000003]
[63,null,null,10373.16,7973.3200000000006,5812.51,4601.46,3575.9100000000003]
[64,null,null,11316.560000000001,8698.36,6344.1,5022.2800000000007,3901.86]
[65,null,null,12235.58,9467.92,6914.9100000000008,5469.6,4440.87]
[66,null,null,12955.320000000002,10026.540000000001,7323.01,5790.7800000000007,4703.75]
[67,null,null,14396.92,11139.54,8138.1500000000005,6437.38,5226.8600000000006]
[68,null,null,15840.640000000001,12259.43,8954.880000000001,7080.27,5753.1500000000005]
[69,null,null,16560.38,12814.34,9361.92,7403.5700000000006,6017.09]
[70,null,null,16775.030000000002,13021.04,9504.49,7542.43,6093.41]
[71,null,null,18873.830000000002,14651.320000000002,10693.28,8489.01,6858.7300000000005]
[72,null,null,20975.81,16278.95,11883.130000000001,9432.94,7622.9900000000007]
[73,null,null,23074.61,17909.760000000002,13071.390000000001,10378.460000000001,8385.130000000001]
[74,null,null,25175,19541.100000000002,14266.01,11327.69,9148.33]
[75,"o más",null,27540.920000000002,21795.72,16361.1,12398.29,10500.36]
[1,"Hijo",null,1254.51,893.58,691.65000000000009,611.62,439.37]
[2,"Hijos",null,2041.5600000000002,1409.27,1090.21,968.84,648.19000000000005]
[3,"Hijos o más",null,2987.61,2052.69,1588.94,1402.91,984.74]
[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,159,159,159,159,159]
[]
["ADVANTAGE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," "]
[18,"-  24",null,3936,2956,2212,1689,1335,null,true,true,true,true,true]
[25,"-  29",null,4373,3293,2454,1884,1481,null,true,true,true,true,true]
[30,"-  34",null,5071,3876,2925,2238,1724,null,true,true,true,true,true]
[35,"-  39",null,5623,4316,3256,2554,1911,null,true,true,true,true,true]
[40,"-  44",null,6344,4897,3692,2855,2170,null,true,true,true,true,true]
[45,"-  49",null,7377,5636,4167,3250,2523,null,true,true,true,true,true]
[50,"-  54",null,8085,6342,4856,3659,2770,null,true,true,true,true,true]
[55,"-  59",null,9550,7328,5375,4236,3275,null,true,true,true,true,true]
[60,null,null,10558,8115,5915,4673,3625,null,true,true,true,true,true]
[61,null,null,11884,9130,6657,5262,4082,null,true,true,true,true,true]
[62,null,null,13211,10149,7401,5855,4541,null,true,true,true,true,true]
[63,null,null,14536,11171,8152,6445,5007,null,true,true,true,true,true]
[64,null,null,15860,12188,8893,7036,5465,null,true,true,true,true,true]
[65,null,null,17143,13268,9696,7667,6219,null,true,true,true,true,true]
[66,null,null,18159,14051,10269,8113,6595,null,true,true,true,true,true]
[67,null,null,20186,15616,11418,9022,7328,null,true,true,true,true,true]
[68,null,null,22208,17182,12560,9932,8066,null,true,true,true,true,true]
[69,null,null,23218,17965,13128,10385,8436,null,true,true,true,true,true]
[70,null,null,23523,18250,13332,10579,8545,null,true,true,true,true,true]
[71,null,null,26465,20541,15005,11910,9619,null,true,true,true,true,true]
[72,null,null,29414,22822,16683,13237,10687,null,true,true,true,true,true]
[73,null,null,32358,25112,18349,14565,11760,null,true,true,true,true,true]
[74,null,null,35307,27399,20020,15890,12840,null,true,true,true,true,true]
[75,"o más",null,38624,30560,22968,17400,14733,null,true,true,true,true,true]
[1,"Hijo",null,1761,1254,967,856,625,null,true,true,true,true,true]
[2,"Hijos",null,2863,1977,1528,1359,914,null,true,true,true,true,true]
[3,"Hijos o más",null,4188,2881,2235,1970,1383,null,true,true,true,true,true]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," "]
[18,"-  24",null,{"$f":"$L$2*D341","v":2086.08},{"$f":"$L$2*E341","v":1566.68},1172.3600000000001,895.17000000000007,707.55000000000007]
[25,"-  29",null,{"$f":"$L$2*D342","v":2317.69},1745.2900000000002,1300.6200000000001,998.5200000000001,784.93000000000006]
[30,"-  34",null,2687.63,2054.2800000000002,1550.25,1186.1400000000001,913.72]
[35,"-  39",null,2980.19,2287.48,1725.68,1353.6200000000001,1012.83]
[40,"-  44",null,3362.32,2595.4100000000003,1956.76,1513.15,1150.1000000000001]
[45,"-  49",null,3909.8100000000004,2987.08,2208.5100000000002,1722.5,1337.19]
[50,"-  54",null,4285.05,3361.26,2573.6800000000003,1939.2700000000002,1468.1000000000001]
[55,"-  59",null,5061.5,3883.84,2848.75,2245.08,1735.75]
[60,null,null,5595.7400000000007,4300.95,3134.9500000000003,2476.69,1921.25]
[61,null,null,6298.52,4838.9000000000005,3528.21,2788.86,2163.46]
[62,null,null,7001.83,5378.97,3922.53,3103.15,2406.73]
[63,null,null,7704.0800000000008,5920.63,4320.5600000000004,3415.8500000000004,2653.71]
[64,null,null,8405.8000000000011,6459.64,4713.29,3729.0800000000004,2896.4500000000003]
[65,null,null,9085.7900000000009,7032.04,5138.88,4063.51,3296.07]
[66,null,null,9624.27,7447.0300000000007,5442.5700000000006,4299.8900000000003,3495.3500000000004]
[67,null,null,10698.58,8276.48,6051.54,4781.66,3883.84]
[68,null,null,11770.24,9106.4600000000009,6656.8,5263.96,4274.9800000000005]
[69,null,null,12305.54,9521.4500000000007,6957.84,5504.05,4471.08]
[70,null,null,12467.19,9672.5,7065.96,5606.87,4528.8500000000004]
[71,null,null,14026.45,10886.730000000001,7952.6500000000005,6312.3,5098.0700000000006]
[72,null,null,15589.42,12095.66,8841.99,7015.6100000000006,5664.1100000000006]
[73,null,null,17149.740000000002,13309.36,9724.9700000000012,7719.4500000000007,6232.8]
[74,null,null,18712.71,14521.470000000001,10610.6,8421.7000000000007,6805.2000000000007]
[75,"o más",null,20470.72,16196.800000000001,12173.04,9222,7808.4900000000007]
[1,"Hijo",null,933.33,664.62,512.51,453.68,331.25]
[2,"Hijos",null,1517.39,1047.81,809.84,720.27,484.42]
[3,"Hijos o más",null,2219.6400000000003,1526.93,1184.55,1044.1000000000001,732.99]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["SECURE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6"]
[18,"-  24",null,4067,3191,2398,2076,1575,null,true,true,true,true,true]
[25,"-  29",null,4489,3599,2673,2315,1752,null,true,true,true,true,true]
[30,"-  34",null,5143,4227,3103,2690,2030,null,true,true,true,true,true]
[35,"-  39",null,5662,4722,3453,2986,2247,null,true,true,true,true,true]
[40,"-  44",null,6348,5386,3900,3374,2540,null,true,true,true,true,true]
[45,"-  49",null,7305,6322,4541,3920,2948,null,true,true,true,true,true]
[50,"-  54",null,7973,6958,4979,4302,3223,null,true,true,true,true,true]
[55,"-  59",null,9370,8304,5906,5104,3815,null,true,true,true,true,true]
[60,null,null,9806,8879,6253,5397,4039,null,true,true,true,true,true]
[61,null,null,11047,9991,7038,6079,4549,null,true,true,true,true,true]
[62,null,null,12276,11108,7833,6758,5060,null,true,true,true,true,true]
[63,null,null,13504,12222,8616,7439,5573,null,true,true,true,true,true]
[64,null,null,14744,13337,9405,8118,6081,null,true,true,true,true,true]
[65,null,null,14753,13464,9460,8164,6102,null,true,true,true,true,true]
[66,null,null,14769,13594,9513,8203,6121,null,true,true,true,true,true]
[67,null,null,16423,15110,10572,9126,6808,null,true,true,true,true,true]
[68,null,null,18065,16617,11638,10041,7498,null,true,true,true,true,true]
[69,null,null,18891,17369,12169,10495,7840,null,true,true,true,true,true]
[70,null,null,18923,17666,12290,10600,7878,null,true,true,true,true,true]
[71,null,null,21294,19884,13837,11931,8872,null,true,true,true,true,true]
[72,null,null,23669,22101,15383,13260,9859,null,true,true,true,true,true]
[73,null,null,26040,24309,16922,14591,10851,null,true,true,true,true,true]
[74,null,null,28411,26523,18468,15923,11843,null,true,true,true,true,true]
[75,"o más",null,30966,29093,20192,17416,12944,null,true,true,true,true,true]
[1,"Hijo",null,1963,1155,969,833,613,null,true,true,true,true,true]
[2,"Hijos",null,3306,1728,1521,1315,973,null,true,true,true,true,true]
[3,"Hijos o más",null,4858,2480,2209,1903,1406,null,true,true,true,true,true]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6"]
[18,"-  24",null,{"$f":"$L$2*D408","v":2155.5100000000002},{"$f":"$L$2*E408","v":1691.23},1270.94,1100.28,834.75]
[25,"-  29",null,{"$f":"$L$2*D409","v":2379.17},1907.47,1416.69,1226.95,928.56000000000006]
[30,"-  34",null,2725.79,2240.31,1644.5900000000001,1425.7,1075.9000000000001]
[35,"-  39",null,3000.86,2502.6600000000003,1830.0900000000001,1582.5800000000002,1190.9100000000001]
[40,"-  44",null,3364.44,2854.58,2067,1788.22,1346.2]
[45,"-  49",null,3871.65,3350.6600000000003,2406.73,2077.6,1562.44]
[50,"-  54",null,4225.6900000000005,3687.7400000000002,2638.8700000000003,2280.06,1708.19]
[55,"-  59",null,4966.1000000000004,4401.12,3130.1800000000003,2705.1200000000003,2021.95]
[60,null,null,5197.18,4705.87,3314.09,2860.4100000000003,2140.67]
[61,null,null,5854.91,5295.2300000000005,3730.1400000000003,3221.8700000000003,2410.9700000000003]
[62,null,null,6506.2800000000007,5887.2400000000007,4151.49,3581.7400000000002,2681.8]
[63,null,null,7157.1200000000008,6477.6600000000008,4566.4800000000005,3942.67,2953.69]
[64,null,null,7814.3200000000006,7068.6100000000006,4984.6500000000005,4302.54,3222.9300000000003]
[65,null,null,7819.09,7135.92,5013.8,4326.92,3234.06]
[66,null,null,7827.5700000000006,7204.8200000000006,5041.8900000000003,4347.59,3244.13]
[67,null,null,8704.19,8008.3,5603.16,4836.7800000000007,3608.2400000000002]
[68,null,null,9574.4500000000007,8807.01,6168.14,5321.7300000000005,3973.94]
[69,null,null,10012.230000000001,9205.57,6449.5700000000006,5562.35,4155.2]
[70,null,null,10029.19,9362.98,6513.7000000000007,5618,4175.34]
[71,null,null,11285.82,10538.52,7333.6100000000006,6323.43,4702.16]
[72,null,null,12544.570000000002,11713.53,8152.9900000000007,7027.8,5225.2700000000004]
[73,null,null,13801.2,12883.77,8968.66,7733.2300000000005,5751.0300000000007]
[74,null,null,15057.83,14057.19,9788.0400000000009,8439.19,6276.79]
[75,"o más",null,16411.98,15419.29,10701.76,9230.48,6860.3200000000006]
[1,"Hijo",null,1040.3900000000001,612.15,513.57000000000005,441.49,324.89000000000004]
[2,"Hijos",null,1752.18,915.84,806.13,696.95,515.69000000000005]
[3,"Hijos o más",null,2574.7400000000002,1314.4,1170.77,1008.59,745.18000000000006]
[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,"ET2","ET3","ET4","ET5","ET6"]
[18,"-  24",null,3416,2681,2011,1737,1323,null,true,true,true,true,true]
[25,"-  29",null,3768,3019,2244,1944,1468,null,true,true,true,true,true]
[30,"-  34",null,4320,3546,2606,2256,1697,null,true,true,true,true,true]
[35,"-  39",null,4764,3973,2899,2506,1889,null,true,true,true,true,true]
[40,"-  44",null,5337,4534,3273,2832,2131,null,true,true,true,true,true]
[45,"-  49",null,6146,5315,3821,3299,2477,null,true,true,true,true,true]
[50,"-  54",null,6708,5855,4188,3622,2709,null,true,true,true,true,true]
[55,"-  59",null,7880,6992,4967,4284,3207,null,true,true,true,true,true]
[60,null,null,8251,7471,5258,4540,3393,null,true,true,true,true,true]
[61,null,null,9290,8411,5924,5108,3824,null,true,true,true,true,true]
[62,null,null,10334,9348,6586,5684,4256,null,true,true,true,true,true]
[63,null,null,11371,10290,7251,6256,4684,null,true,true,true,true,true]
[64,null,null,12403,11227,7915,6834,5115,null,true,true,true,true,true]
[65,null,null,12420,11338,7964,6866,5133,null,true,true,true,true,true]
[66,null,null,12431,11443,8012,6904,5154,null,true,true,true,true,true]
[67,null,null,13824,12718,8903,7679,5730,null,true,true,true,true,true]
[68,null,null,15207,13994,9794,8448,6312,null,true,true,true,true,true]
[69,null,null,15904,14627,10247,8836,6597,null,true,true,true,true,true]
[70,null,null,15929,14884,10352,8921,6635,null,true,true,true,true,true]
[71,null,null,17924,16747,11650,10047,7471,null,true,true,true,true,true]
[72,null,null,19928,18606,12949,11165,8294,null,true,true,true,true,true]
[73,null,null,21921,20472,14249,12285,9132,null,true,true,true,true,true]
[74,null,null,23924,22338,15545,13408,9968,null,true,true,true,true,true]
[75,"o más",null,26070,24498,17007,14660,10891,null,true,true,true,true,true]
[1,"Hijo",null,1653,980,817,699,517,null,true,true,true,true,true]
[2,"Hijos",null,2789,1452,1281,1103,821,null,true,true,true,true,true]
[3,"Hijos o más",null,4093,2089,1866,1602,1187,null,true,true,true,true,true]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"ET2","ET3","ET4","ET5","ET6"]
[18,"-  24",null,{"$f":"$L$2*D475","v":1810.48},{"$f":"$L$2*E475","v":1420.93},1065.8300000000002,920.61,701.19]
[25,"-  29",null,{"$f":"$L$2*D476","v":1997.0400000000002},1600.0700000000002,1189.3200000000002,1030.3200000000002,778.04000000000008]
[30,"-  34",null,2289.6,1879.38,1381.18,1195.68,899.41000000000008]
[35,"-  39",null,2524.92,2105.69,1536.47,1328.18,1001.1700000000001]
[40,"-  44",null,2828.61,2403.02,1734.69,1500.96,1129.43]
[45,"-  49",null,3257.38,2816.9500000000003,2025.13,1748.47,1312.8100000000002]
[50,"-  54",null,3555.2400000000002,3103.15,2219.6400000000003,1919.66,1435.77]
[55,"-  59",null,4176.4000000000005,3705.76,2632.51,2270.52,1699.71]
[60,null,null,4373.0300000000007,3959.63,2786.7400000000002,2406.2000000000003,1798.2900000000002]
[61,null,null,4923.7,4457.83,3139.7200000000003,2707.2400000000002,2026.72]
[62,null,null,5477.02,4954.4400000000005,3490.5800000000004,3012.52,2255.6800000000003]
[63,null,null,6026.63,5453.7000000000007,3843.03,3315.6800000000003,2482.52]
[64,null,null,6573.59,5950.31,4194.95,3622.02,2710.9500000000003]
[65,null,null,6582.6,6009.14,4220.92,3638.98,2720.4900000000002]
[66,null,null,6588.43,6064.79,4246.3600000000006,3659.1200000000003,2731.6200000000003]
[67,null,null,7326.72,6740.54,4718.59,4069.8700000000003,3036.9]
[68,null,null,8059.71,7416.8200000000006,5190.8200000000006,4477.4400000000005,3345.36]
[69,null,null,8429.1200000000008,7752.31,5430.91,4683.08,3496.4100000000003]
[70,null,null,8442.3700000000008,7888.52,5486.56,4728.13,3516.55]
[71,null,null,9499.7200000000012,8875.91,6174.5,5324.91,3959.63]
[72,null,null,10561.84,9861.18,6862.97,5917.4500000000007,4395.8200000000006]
[73,null,null,11618.130000000001,10850.16,7551.97,6511.05,4839.96]
[74,null,null,12679.720000000001,11839.140000000001,8238.85,7106.2400000000007,5283.04]
[75,"o más",null,13817.1,12983.94,9013.7100000000009,7769.8,5772.2300000000005]
[1,"Hijo",null,876.09,519.4,433.01000000000005,370.47,274.01]
[2,"Hijos",null,1478.17,769.56000000000006,678.93000000000006,584.59,435.13]
[3,"Hijos o más",null,2169.29,1107.17,988.98,849.06000000000006,629.11]
[1,"Rider Comp. Maternidad",null,{"$f":"+D502*$L$2","v":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",2195,3865,5534,1778,3033,4289,1519,2612,3698,1207,2023,2836,907,1460,2015,568,837,1107]
[50,"o más",2782,4446,6111,2240,3496,4745,1896,2995,4074,1488,2304,3125,1098,1650,2208,661,929,1203]
[]
["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":1163.3500000000001},2048.4500000000003,2933.02,942.34,1607.49,2273.17,805.07,1384.3600000000001,1959.94,522.05000000000007,1072.19,1503.0800000000002,480.71000000000004,773.80000000000007,1067.95,301.04000000000002,443.61,586.71]
[75,"o más",{"$f":"+C544*$L$2","v":1474.46},2356.38,3238.8300000000004,1187.2,1852.88,2514.85,1004.88,1587.3500000000001,2159.2200000000003,788.64,1221.1200000000001,1656.25,581.94000000000005,874.5,1170.24,350.33000000000004,492.37,637.59]
[]
[]
[]
[]
[null,null,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true]
[null,null,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true,true]