{"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":8,"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,2,"Número de hijos en la póliza :",null,1]
[]
[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,"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],[47,0,47,1],[47,2,47,3],[35,0,35,1],[36,0,38,1],[36,2,38,3],[46,0,46,1],[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],[20,2,20,3],[22,2,22,3],[28,2,28,3],[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],[14,0,14,1],[15,0,15,1],[16,0,16,1],[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],[9,2,9,12],[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],[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],[49,5,50,12],[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],[48,0,49,1],[48,2,49,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":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},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-11-05T09:31:27.990"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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," ",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":14535},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":9604},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":6572},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":4619},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":3635}]
[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":14535},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,5,TRUE)))","v":9604},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,6,TRUE)))","v":6572},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,7,TRUE)))","v":4619},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,8,TRUE)))","v":3635}]
[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":5050},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":3720},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":2939},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":2456},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":1910}]
[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":34120},{"$f":"SUM(J31:J34)","v":22928},{"$f":"SUM(K31:K34)","v":16083},{"$f":"SUM(L31:L34)","v":11694},{"$f":"SUM(M31:M34)","v":9180}]
[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":34195},{"$f":"SUM(J35:J36)","v":23003},{"$f":"SUM(K35:K36)","v":16158},{"$f":"SUM(L35:L36)","v":11769},{"$f":"SUM(M35:M36)","v":9255}]
[]
[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":7703.55},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":5090.12},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":3483.1600000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":2448.0700000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":1926.5500000000002}]
[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":7703.55},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,5,TRUE)))","v":5090.12},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,6,TRUE)))","v":3483.1600000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,7,TRUE)))","v":2448.0700000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,8,TRUE)))","v":1926.5500000000002}]
[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":2676.5},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":1971.6000000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":1557.67},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":1301.68},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":1012.3000000000001}]
[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":18083.599999999999},{"$f":"SUM(J40:J43)","v":12151.84},{"$f":"SUM(K40:K43)","v":8523.9900000000016},{"$f":"SUM(L40:L43)","v":6197.8200000000006},{"$f":"SUM(M40:M43)","v":4865.4000000000005}]
[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":18158.599999999999},{"$f":"SUM(J44:J45)","v":12226.84},{"$f":"SUM(K44:K45)","v":8598.9900000000016},{"$f":"SUM(L44:L45)","v":6272.8200000000006},{"$f":"SUM(M44:M45)","v":4940.4000000000005}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":18083.599999999999},{"$f":"J44","v":12151.84},8523.9900000000016,6197.8200000000006,4865.4000000000005]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 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],[31,2,31,3],[34,0,34,1],[41,2,41,3],[37,0,37,1],[38,0,38,1],[34,2,34,3],[39,0,39,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[40,0,40,1],[41,0,41,1],[32,2,32,3],[26,0,26,1],[27,0,27,1],[33,0,33,1],[33,2,33,3],[19,0,19,1],[17,0,18,1],[20,0,21,1],[29,2,29,3],[32,0,32,1],[29,0,29,1],[21,2,21,3],[28,0,28,1],[30,0,31,1],[20,2,20,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[25,0,25,1],[27,2,27,3],[28,2,28,3],[46,2,47,3],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[46,0,47,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],[42,0,42,1],[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],[22,2,22,3],[26,2,26,3],[49,5,50,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],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,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":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},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-11-05T09:31:27.990"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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," ",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":12227},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":8405},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":5713},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":4018},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":3055}]
[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":12227},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,5,TRUE)))","v":8405},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,6,TRUE)))","v":5713},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,7,TRUE)))","v":4018},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,8,TRUE)))","v":3055}]
[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":4238},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":3092},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":2320},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":1939},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":1438}]
[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":28692},{"$f":"SUM(J31:J34)","v":19902},{"$f":"SUM(K31:K34)","v":13746},{"$f":"SUM(L31:L34)","v":9975},{"$f":"SUM(M31:M34)","v":7548}]
[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":28767},{"$f":"SUM(J35:J36)","v":19977},{"$f":"SUM(K35:K36)","v":13821},{"$f":"SUM(L35:L36)","v":10050},{"$f":"SUM(M35:M36)","v":7623}]
[]
[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":6480.31},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":4454.6500000000005},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":3027.8900000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":2129.54},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":1619.15}]
[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":6480.31},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,5,TRUE)))","v":4454.6500000000005},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,6,TRUE)))","v":3027.8900000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,7,TRUE)))","v":2129.54},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,8,TRUE)))","v":1619.15}]
[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":2246.1400000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":1638.76},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":1229.6000000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":1027.67},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":762.14}]
[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":15206.760000000002},{"$f":"SUM(J40:J43)","v":10548.060000000001},{"$f":"SUM(K40:K43)","v":7285.380000000001},{"$f":"SUM(L40:L43)","v":5286.75},{"$f":"SUM(M40:M43)","v":4000.44}]
[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":15281.760000000002},{"$f":"SUM(J44:J45)","v":10623.060000000001},{"$f":"SUM(K44:K45)","v":7360.380000000001},{"$f":"SUM(L44:L45)","v":5361.75},{"$f":"SUM(M44:M45)","v":4075.44}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":15206.760000000002},{"$f":"J44","v":10548.060000000001},7285.380000000001,5286.75,4000.44]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 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":[[54,0,54,1],[54,2,54,3],[53,0,53,1],[53,2,53,3],[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],[29,0,29,1],[50,0,50,1],[47,0,47,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[48,0,48,1],[42,0,42,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[26,2,26,3],[19,0,19,1],[24,2,24,3],[50,2,50,3],[46,2,46,3],[44,2,44,3],[19,2,19,3],[21,2,21,3],[22,2,22,3],[20,2,20,3],[25,2,25,3],[23,2,23,3],[42,2,42,3],[34,2,34,3],[32,2,32,3],[32,0,32,1],[20,0,21,1],[51,2,52,3],[35,2,39,3],[40,2,41,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,18,3],[49,2,49,3],[30,2,30,3],[31,2,31,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[51,5,52,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 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":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},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-11-05T09:31:27.990"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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,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":8064},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":6057},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":4457},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":3390},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":2686}]
[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":8064},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,5,TRUE)))","v":6057},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,6,TRUE)))","v":4457},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,7,TRUE)))","v":3390},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,8,TRUE)))","v":2686}]
[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":3591},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":2559},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":1941},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":1704},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":1226}]
[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":19719},14673,10855,8484,6598]
[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":19794},{"$f":"SUM(J36:J37)","v":14748},{"$f":"SUM(K36:K37)","v":10930},{"$f":"SUM(L36:L37)","v":8559},{"$f":"SUM(M36:M37)","v":6673}]
[]
[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":4273.92},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":3210.21},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":2362.21},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":1796.7},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":1423.5800000000002}]
[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":4273.92},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,5,TRUE)))","v":3210.21},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,6,TRUE)))","v":2362.21},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,7,TRUE)))","v":1796.7},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,8,TRUE)))","v":1423.5800000000002}]
[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":1903.23},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":1356.27},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":1028.73},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":903.12},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":649.78000000000009}]
[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":10451.07},7776.6900000000005,5753.15,4496.5200000000004,3496.9400000000005]
[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":10526.07},{"$f":"SUM(J46:J47)","v":7851.6900000000005},{"$f":"SUM(K46:K47)","v":5828.15},{"$f":"SUM(L46:L47)","v":4571.5200000000004},{"$f":"SUM(M46:M47)","v":3571.9400000000005}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":10451.07},{"$f":"J46","v":7776.6900000000005},5753.15,4496.5200000000004,3496.9400000000005]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 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":false,"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)"]
[]
[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":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},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-11-05T09:31:27.990"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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$341:$H$364,4,TRUE)","v":6243},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":4688},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":3447},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":2611},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":2062}]
[null,null,null,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":6243},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,5,TRUE)))","v":4688},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,6,TRUE)))","v":3447},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,7,TRUE)))","v":2611},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,8,TRUE)))","v":2062}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,4,TRUE)))","v":2795},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":1990},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":1509},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":1323},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":962}]
[null,null,null,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}]
[null,null,null,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}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":15281},11366,8403,6545,5086]
[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":15356},{"$f":"SUM(J36:J37)","v":11441},{"$f":"SUM(K36:K37)","v":8478},{"$f":"SUM(L36:L37)","v":6620},{"$f":"SUM(M36:M37)","v":5161}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,4,TRUE)","v":3308.79},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":2484.6400000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":1826.91},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":1383.8300000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":1092.8600000000001}]
[null,null,null,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":3308.79},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,5,TRUE)))","v":2484.6400000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,6,TRUE)))","v":1826.91},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,7,TRUE)))","v":1383.8300000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,8,TRUE)))","v":1092.8600000000001}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,4,TRUE)))","v":1481.3500000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":1054.7},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":799.7700000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":701.19},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":509.86}]
[null,null,null,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}]
[null,null,null,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}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":8098.93},6023.9800000000005,4453.59,3468.8500000000004,2695.5800000000004]
[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":8173.93},{"$f":"SUM(J46:J47)","v":6098.9800000000005},{"$f":"SUM(K46:K47)","v":4528.59},{"$f":"SUM(L46:L47)","v":3543.8500000000004},{"$f":"SUM(M46:M47)","v":2770.5800000000004}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":8098.93},{"$f":"J46","v":6023.9800000000005},4453.59,3468.8500000000004,2695.5800000000004]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2022"]

{"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],[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],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,0,29,1],[32,0,32,1],[27,2,27,3],[28,2,28,3],[25,2,25,3],[34,2,34,3],[40,2,41,3],[32,2,32,3],[29,2,29,3],[30,2,30,3],[15,0,15,1],[26,0,26,1],[20,2,20,3],[17,2,18,3],[19,2,19,3],[22,2,22,3],[21,2,21,3],[16,0,16,1],[23,2,23,3],[24,2,24,3],[26,2,26,3],[51,5,53,12],[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":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},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-11-05T09:31:27.990"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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,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":6490},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":5090},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":3725},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":3113},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":2365}]
[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":6490},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,5,TRUE)))","v":5090},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,6,TRUE)))","v":3725},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,7,TRUE)))","v":3113},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,8,TRUE)))","v":2365}]
[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":3133},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":1842},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":1506},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":1250},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":917}]
[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":16113},12022,8956,7476,5647]
[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":16188},{"$f":"SUM(J36:J37)","v":12097},{"$f":"SUM(K36:K37)","v":9031},{"$f":"SUM(L36:L37)","v":7551},{"$f":"SUM(M36:M37)","v":5722}]
[]
[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":3439.7000000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":2697.7000000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":1974.25},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":1649.89},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":1253.45}]
[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":3439.7000000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,5,TRUE)))","v":2697.7000000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,6,TRUE)))","v":1974.25},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,7,TRUE)))","v":1649.89},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,8,TRUE)))","v":1253.45}]
[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":1660.49},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":976.2600000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":798.18000000000006},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":662.5},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":486.01000000000005}]
[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":8539.8900000000012},6371.6600000000008,4746.68,3962.28,2992.9100000000003]
[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":8614.8900000000012},{"$f":"SUM(J46:J47)","v":6446.6600000000008},{"$f":"SUM(K46:K47)","v":4821.68},{"$f":"SUM(L46:L47)","v":4037.28},{"$f":"SUM(M46:M47)","v":3067.9100000000003}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":8539.8900000000012},{"$f":"J46","v":6371.6600000000008},4746.68,3962.28,2992.9100000000003]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 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":[[50,0,50,1],[50,2,50,3],[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],[19,0,19,1],[28,0,28,1],[28,2,28,3],[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],[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],[51,5,53,12],[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],[49,0,49,1],[49,2,49,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":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},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-11-05T09:31:27.990"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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,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$475:$H$498,4,TRUE)","v":5365},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":4208},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":3076},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":2567},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":1949}]
[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":5365},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,5,TRUE)))","v":4208},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,6,TRUE)))","v":3076},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,7,TRUE)))","v":2567},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,8,TRUE)))","v":1949}]
[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":2597},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":1539},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":1251},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":1036},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":763}]
[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":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$503)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":13327},9955,7403,6170,4661]
[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":13402},{"$f":"SUM(J36:J37)","v":10030},{"$f":"SUM(K36:K37)","v":7478},{"$f":"SUM(L36:L37)","v":6245},{"$f":"SUM(M36:M37)","v":4736}]
[]
[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":2843.4500000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":2230.2400000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":1630.28},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":1360.51},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":1032.97}]
[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":2843.4500000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,5,TRUE)))","v":2230.2400000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,6,TRUE)))","v":1630.28},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,7,TRUE)))","v":1360.51},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,8,TRUE)))","v":1032.97}]
[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":1376.41},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":815.67000000000007},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":663.03000000000009},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":549.08000000000004},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":404.39000000000004}]
[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":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$536)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":7063.31},5276.1500000000005,3923.59,3270.1,2470.33]
[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":7138.31},{"$f":"SUM(J46:J47)","v":5351.1500000000005},{"$f":"SUM(K46:K47)","v":3998.59},{"$f":"SUM(L46:L47)","v":3345.1},{"$f":"SUM(M46:M47)","v":2545.33}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":7063.31},{"$f":"J46","v":5276.1500000000005},3923.59,3270.1,2470.33]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2022"]
[]
[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":[[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],[40,2,40,3],[29,0,29,1],[30,0,31,1],[29,2,29,3],[32,2,32,3],[33,2,33,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],[42,2,42,3],[25,0,25,1],[25,2,25,3],[23,2,23,3],[24,2,24,3],[27,2,27,3],[21,8,22,9],[20,0,21,1],[21,2,21,3],[22,2,22,3],[20,2,20,3],[16,2,16,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],[52,5,54,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],[14,0,14,1],[13,0,13,1],[15,0,15,1],[16,0,16,1],[26,2,26,3],[17,2,18,3],[19,2,19,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 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":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},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-11-05T09:31:27.990"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,6,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,9,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,12,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,15,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,18,TRUE)),0)","v":0}]
[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":8026},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,8,TRUE)),0)","v":6224},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,11,TRUE)),0)","v":5365},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,14,TRUE)),0)","v":4116},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,17,TRUE)),0)","v":2926},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,20,TRUE)),0)","v":1612}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":8026},{"$f":"SUM(I44:I46)","v":6224},5365,4116,2926,1612]
[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":8101},6299,5440,4191,3001,1687]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 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":[[11,2,11,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],[39,0,41,7],[13,2,13,7],[15,2,15,7],[19,0,19,1],[18,0,18,1]]}
[]
[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":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2021-11-05T09:31:27.990"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":34195},{"$f":"+Exclusive!J37","v":23003},{"$f":"+Exclusive!K37","v":16158},{"$f":"+Exclusive!L37","v":11769},{"$f":"+Exclusive!M37","v":9255}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":28767},{"$f":"+Privilege!J37","v":19977},{"$f":"+Privilege!K37","v":13821},{"$f":"+Privilege!L37","v":10050},{"$f":"+Privilege!M37","v":7623}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":19794},{"$f":"+'Advantage (Mundial)'!J38","v":14748},{"$f":"+'Advantage (Mundial)'!K38","v":10930},{"$f":"+'Advantage (Mundial)'!L38","v":8559},{"$f":"+'Advantage (Mundial)'!M38","v":6673}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":16188},{"$f":"+Secure!J38","v":12097},{"$f":"+Secure!K38","v":9031},{"$f":"+Secure!L38","v":7551},{"$f":"+Secure!M38","v":5722}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":13402},{"$f":"+Essential!J38","v":10030},{"$f":"+Essential!K38","v":7478},{"$f":"+Essential!L38","v":6245},{"$f":"+Essential!M38","v":4736}]
[]
["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":8101},{"$f":"+Critical!I49","v":6299},{"$f":"+Critical!J49","v":5440},{"$f":"+Critical!K49","v":4191},{"$f":"+Critical!L49","v":3001},{"$f":"+Critical!M49","v":1687}]
["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,"2022 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":557,"n_cols":20,"rows_kept":557,"cut":false,"hidden":true,"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,14535,9604,6572,4619,3635,null,true,true,true,true,true]
[25,"-  29",null,15248,10615,7282,5122,4026,null,true,true,true,true,true]
[30,"-  34",null,15862,11383,8152,6141,4842,null,true,true,true,true,true]
[35,"-  39",null,17765,12743,9141,6883,5422,null,true,true,true,true,true]
[40,"-  44",null,20604,13940,10147,7570,5962,null,true,true,true,true,true]
[45,"-  49",null,23034,15591,11341,8456,6666,null,true,true,true,true,true]
[50,"-  54",null,29474,20457,14799,11956,9424,null,true,true,true,true,true]
[55,"-  59",null,31360,21769,15741,12720,10032,null,true,true,true,true,true]
[60,null,null,34163,23748,18120,15323,12465,null,true,true,true,true,true]
[61,null,null,36702,25521,19459,16475,13393,null,true,true,true,true,true]
[62,null,null,40184,27950,21315,18028,14666,null,true,true,true,true,true]
[63,null,null,42727,29719,22654,19182,15589,null,true,true,true,true,true]
[64,null,null,46217,32155,24519,20744,16879,null,true,true,true,true,true]
[65,null,null,60423,41945,31001,27670,23801,null,true,true,true,true,true]
[66,null,null,70195,48740,36021,32167,27653,null,true,true,true,true,true]
[67,null,null,76676,53234,39346,35125,30209,null,true,true,true,true,true]
[68,null,null,84903,58940,43569,38902,33450,null,true,true,true,true,true]
[69,null,null,93416,64846,47940,42799,36810,null,true,true,true,true,true]
[70,null,null,114965,78965,56434,49868,43302,null,true,true,true,true,true]
[71,null,null,119485,82063,58655,51834,45003,null,true,true,true,true,true]
[72,null,null,122870,84387,60303,53302,46276,null,true,true,true,true,true]
[73,null,null,127381,87492,62522,55264,47967,null,true,true,true,true,true]
[74,null,null,129637,89039,63641,56241,48826,null,true,true,true,true,true]
[75,"o más",null,135280,92912,66400,58691,50959,null,true,true,true,true,true]
[1,"Hijo",null,5050,3720,2939,2456,1910,null,true,true,true,true,true]
[2,"Hijos",null,8033,5926,4678,3898,3040,null,true,true,true,true,true]
[3,"Hijos o más",null,11780,8679,6850,5713,4448,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":7703.55},{"$f":"$L$2*E6","v":5090.12},3483.1600000000003,2448.0700000000002,1926.5500000000002]
[25,"-  29",null,{"$f":"$L$2*D7","v":8081.4400000000005},5625.9500000000007,3859.46,2714.6600000000003,2133.7800000000002]
[30,"-  34",null,8406.86,6032.9900000000007,4320.5600000000004,3254.73,2566.2600000000002]
[35,"-  39",null,9415.4500000000007,6753.79,4844.7300000000005,3647.9900000000002,2873.6600000000003]
[40,"-  44",null,10920.12,7388.2000000000007,5377.91,4012.1000000000004,3159.86]
[45,"-  49",null,12208.02,8263.23,6010.7300000000005,4481.68,3532.98]
[50,"-  54",null,15621.220000000001,10842.210000000001,7843.47,6336.68,4994.72]
[55,"-  59",null,16620.8,11537.57,8342.73,6741.6,5316.96]
[60,null,null,18106.39,12586.44,9603.6,8121.1900000000005,6606.4500000000007]
[61,null,null,19452.060000000001,13526.130000000001,10313.27,8731.75,7098.29]
[62,null,null,21297.52,14813.5,11296.95,9554.84,7772.9800000000005]
[63,null,null,22645.31,15751.070000000002,12006.62,10166.460000000001,8262.17]
[64,null,null,24495.010000000002,17042.150000000001,12995.070000000002,10994.32,8945.8700000000008]
[65,null,null,32024.190000000002,22230.850000000002,16430.530000000002,14665.1,12614.53]
[66,null,null,37203.35,25832.2,19091.13,17048.510000000002,14656.09]
[67,null,null,40638.28,28214.02,20853.38,18616.25,16010.77]
[68,null,null,44998.590000000004,31238.2,23091.57,20618.060000000001,17728.5]
[69,null,null,49510.48,34368.380000000005,25408.2,22683.47,19509.3]
[70,null,null,60931.450000000004,41851.450000000004,29910.02,26430.04,22950.06]
[71,null,null,63327.05,43493.39,31087.15,27472.02,23851.59]
[72,null,null,65121.100000000006,44725.11,31960.59,28250.06,24526.280000000002]
[73,null,null,67511.930000000008,46370.76,33136.660000000003,29289.920000000002,25422.510000000002]
[74,null,null,68707.61,47190.670000000006,33729.730000000003,29807.730000000003,25877.780000000002]
[75,"o más",null,71698.400000000009,49243.360000000001,35192,31106.230000000003,27008.27]
[1,"Hijo",null,2676.5,1971.6000000000001,1557.67,1301.68,1012.3000000000001]
[2,"Hijos",null,4257.49,3140.78,2479.34,2065.94,1611.2]
[3,"Hijos o más",null,6243.4000000000005,4599.87,3630.5,3027.8900000000003,2357.44]
[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,12227,8405,5713,4018,3055,null,true,true,true,true,true]
[25,"-  29",null,12825,9299,6327,4447,3386,null,true,true,true,true,true]
[30,"-  34",null,13399,9946,7101,5374,4112,null,true,true,true,true,true]
[35,"-  39",null,14999,11134,7958,6028,4603,null,true,true,true,true,true]
[40,"-  44",null,17365,12211,8847,6648,5081,null,true,true,true,true,true]
[45,"-  49",null,19401,13645,9884,7432,5675,null,true,true,true,true,true]
[50,"-  54",null,25358,17999,12979,10595,8103,null,true,true,true,true,true]
[55,"-  59",null,26975,19146,13811,11280,8621,null,true,true,true,true,true]
[60,null,null,29377,20787,15718,13412,10782,null,true,true,true,true,true]
[61,null,null,31560,22331,16885,14415,11579,null,true,true,true,true,true]
[62,null,null,34547,24458,18490,15783,12679,null,true,true,true,true,true]
[63,null,null,36737,26002,19657,16789,13478,null,true,true,true,true,true]
[64,null,null,39732,28136,21269,18161,14585,null,true,true,true,true,true]
[65,null,null,51949,36691,26888,24213,20561,null,true,true,true,true,true]
[66,null,null,60345,42633,31243,28141,23890,null,true,true,true,true,true]
[67,null,null,65905,46562,34124,30723,26094,null,true,true,true,true,true]
[68,null,null,72978,51551,37789,34026,28894,null,true,true,true,true,true]
[69,null,null,80288,56715,41568,37432,31795,null,true,true,true,true,true]
[70,null,null,98812,69061,48933,43628,37387,null,true,true,true,true,true]
[71,null,null,102693,71763,50848,45336,38865,null,true,true,true,true,true]
[72,null,null,105604,73793,52294,46620,39960,null,true,true,true,true,true]
[73,null,null,109476,76510,54211,48334,41440,null,true,true,true,true,true]
[74,null,null,111414,77859,55171,49196,42162,null,true,true,true,true,true]
[75,"o más",null,116266,81252,57571,51333,43998,null,true,true,true,true,true]
[1,"Hijo",null,4238,3092,2320,1939,1438,null,true,true,true,true,true]
[2,"Hijos",null,6736,4928,3700,3087,2285,null,true,true,true,true,true]
[3,"Hijos o más",null,9880,7221,5416,4524,3350,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":6480.31},{"$f":"$L$2*E140","v":4454.6500000000005},3027.8900000000003,2129.54,1619.15]
[25,"-  29",null,{"$f":"$L$2*D141","v":6797.25},4928.47,3353.31,2356.9100000000003,1794.5800000000002]
[30,"-  34",null,7101.47,5271.38,3763.53,2848.2200000000003,2179.36]
[35,"-  39",null,7949.47,5901.02,4217.74,3194.84,2439.59]
[40,"-  44",null,9203.4500000000007,6471.83,4688.91,3523.44,2692.9300000000003]
[45,"-  49",null,10282.530000000001,7231.85,5238.5200000000004,3938.96,3007.75]
[50,"-  54",null,13439.74,9539.4700000000012,6878.8700000000008,5615.35,4294.59]
[55,"-  59",null,14296.75,10147.380000000001,7319.83,5978.4000000000005,4569.13]
[60,null,null,15569.810000000001,11017.11,8330.5400000000009,7108.3600000000006,5714.46]
[61,null,null,16726.8,11835.43,8949.0500000000011,7639.9500000000007,6136.87]
[62,null,null,18309.91,12962.74,9799.7000000000007,8364.99,6719.87]
[63,null,null,19470.61,13781.060000000001,10418.210000000001,8898.17,7143.34]
[64,null,null,21057.960000000003,14912.08,11272.57,9625.33,7730.05]
[65,null,null,27532.97,19446.23,14250.640000000001,12832.890000000001,10897.33]
[66,null,null,31982.850000000002,22595.49,16558.79,14914.730000000001,12661.7]
[67,null,null,34929.65,24677.86,18085.72,16283.19,13829.820000000002]
[68,null,null,38678.340000000004,27322.030000000002,20028.170000000002,18033.780000000002,15313.820000000002]
[69,null,null,42552.639999999999,30058.95,22031.040000000001,19838.960000000003,16851.350000000002]
[70,null,null,52370.36,36602.33,25934.49,23122.84,19815.11]
[71,null,null,54427.29,38034.39,26949.440000000002,24028.080000000002,20598.45]
[72,null,null,55970.12,39110.29,27715.82,24708.600000000002,21178.799999999999]
[73,null,null,58022.280000000006,40550.300000000003,28731.83,25617.02,21963.200000000001]
[74,null,null,59049.420000000006,41265.270000000004,29240.63,26073.88,22345.86]
[75,"o más",null,61620.98,43063.560000000005,30512.63,27206.49,23318.940000000002]
[1,"Hijo",null,2246.1400000000003,1638.76,1229.6000000000001,1027.67,762.14]
[2,"Hijos",null,3570.0800000000004,2611.84,1961,1636.1100000000001,1211.05]
[3,"Hijos o más",null,5236.4000000000005,3827.13,2870.48,2397.7200000000003,1775.5]
[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,8064,6057,4457,3390,2686,null,true,true,true,true,true]
[25,"-  29",null,8965,6757,4958,3778,2978,null,true,true,true,true,true]
[30,"-  34",null,10375,7946,5893,4480,3454,null,true,true,true,true,true]
[35,"-  39",null,11508,8843,6554,5104,3827,null,true,true,true,true,true]
[40,"-  44",null,12992,10017,7431,5698,4333,null,true,true,true,true,true]
[45,"-  49",null,15093,11545,8384,6494,5035,null,true,true,true,true,true]
[50,"-  54",null,16534,12971,9764,7282,5525,null,true,true,true,true,true]
[55,"-  59",null,19533,14982,10799,8440,6536,null,true,true,true,true,true]
[60,null,null,21582,16589,11873,9314,7235,null,true,true,true,true,true]
[61,null,null,24291,18664,13370,10478,8149,null,true,true,true,true,true]
[62,null,null,26996,20747,14859,11652,9057,null,true,true,true,true,true]
[63,null,null,29701,22829,16351,12826,9969,null,true,true,true,true,true]
[64,null,null,32400,24907,17843,13996,10877,null,true,true,true,true,true]
[65,null,null,35034,27110,19448,15244,12377,null,true,true,true,true,true]
[66,null,null,37095,28705,20598,16141,13115,null,true,true,true,true,true]
[67,null,null,41223,31897,22891,17938,14570,null,true,true,true,true,true]
[68,null,null,45359,35102,25185,19736,16038,null,true,true,true,true,true]
[69,null,null,47418,36694,26327,20635,16769,null,true,true,true,true,true]
[70,null,null,48033,37280,26732,21020,16984,null,true,true,true,true,true]
[71,null,null,54039,41953,30076,23661,19118,null,true,true,true,true,true]
[72,null,null,60060,46610,33425,26294,21247,null,true,true,true,true,true]
[73,null,null,66067,51278,36765,28928,23375,null,true,true,true,true,true]
[74,null,null,72079,55949,40123,31575,25501,null,true,true,true,true,true]
[75,"o más",null,78855,62404,46019,34556,29266,null,true,true,true,true,true]
[1,"Hijo",null,3591,2559,1941,1704,1226,null,true,true,true,true,true]
[2,"Hijos",null,5845,4033,3062,2698,1802,null,true,true,true,true,true]
[3,"Hijos o más",null,8559,5876,4469,3909,2743,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":4273.92},{"$f":"$L$2*E274","v":3210.21},2362.21,1796.7,1423.5800000000002]
[25,"-  29",null,{"$f":"$L$2*D275","v":4751.45},3581.21,2627.7400000000002,2002.3400000000001,1578.3400000000001]
[30,"-  34",null,5498.75,4211.38,3123.29,2374.4,1830.6200000000001]
[35,"-  39",null,6099.2400000000007,4686.79,3473.6200000000003,2705.1200000000003,2028.3100000000002]
[40,"-  44",null,6885.76,5309.01,3938.4300000000003,3019.94,2296.4900000000002]
[45,"-  49",null,7999.29,6118.85,4443.5200000000004,3441.82,2668.55]
[50,"-  54",null,8763.02,6874.63,5174.92,3859.46,2928.25]
[55,"-  59",null,10352.49,7940.46,5723.47,4473.2,3464.0800000000004]
[60,null,null,11438.460000000001,8792.17,6292.6900000000005,4936.42,3834.55]
[61,null,null,12874.230000000001,9891.92,7086.1,5553.34,4318.97]
[62,null,null,14307.880000000001,10995.91,7875.27,6175.56,4800.21]
[63,null,null,15741.53,12099.37,8666.0300000000007,6797.7800000000007,5283.5700000000006]
[64,null,null,17172,13200.710000000001,9456.7900000000009,7417.88,5764.81]
[65,null,null,18568.02,14368.300000000001,10307.44,8079.3200000000006,6559.81]
[66,null,null,19660.350000000002,15213.650000000001,10916.94,8554.73,6950.9500000000007]
[67,null,null,21848.190000000002,16905.41,12132.230000000001,9507.1400000000012,7722.1]
[68,null,null,24040.27,18604.060000000001,13348.050000000001,10460.08,8500.1400000000012]
[69,null,null,25131.54,19447.82,13953.310000000001,10936.550000000001,8887.57]
[70,null,null,25457.49,19758.400000000001,14167.960000000001,11140.6,9001.52]
[71,null,null,28640.670000000002,22235.09,15940.28,12540.33,10132.540000000001]
[72,null,null,31831.800000000003,24703.300000000003,17715.25,13935.820000000002,11260.91]
[73,null,null,35015.51,27177.34,19485.45,15331.84,12388.75]
[74,null,null,38201.870000000003,29652.97,21265.190000000002,16734.75,13515.53]
[75,"o más",null,41793.15,33074.120000000003,24390.07,18314.68,15510.980000000001]
[1,"Hijo",null,1903.23,1356.27,1028.73,903.12,649.78000000000009]
[2,"Hijos",null,3097.8500000000004,2137.4900000000002,1622.8600000000001,1429.94,955.06000000000006]
[3,"Hijos o más",null,4536.2700000000004,3114.28,2368.5700000000002,2071.77,1453.79]
[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,6243,4688,3447,2611,2062,null,true,true,true,true,true]
[25,"-  29",null,6942,5229,3826,2909,2291,null,true,true,true,true,true]
[30,"-  34",null,8044,6153,4561,3456,2662,null,true,true,true,true,true]
[35,"-  39",null,8925,6848,5078,3949,2954,null,true,true,true,true,true]
[40,"-  44",null,10072,7769,5759,4410,3351,null,true,true,true,true,true]
[45,"-  49",null,11710,8942,6497,5023,3899,null,true,true,true,true,true]
[50,"-  54",null,12829,10064,7572,5651,4279,null,true,true,true,true,true]
[55,"-  59",null,15161,11630,8382,6549,5063,null,true,true,true,true,true]
[60,null,null,16761,12875,9223,7221,5599,null,true,true,true,true,true]
[61,null,null,18862,14490,10381,8133,6307,null,true,true,true,true,true]
[62,null,null,20972,16111,11537,9045,7016,null,true,true,true,true,true]
[63,null,null,23066,17736,12707,9960,7735,null,true,true,true,true,true]
[64,null,null,25172,19348,13862,10866,8441,null,true,true,true,true,true]
[65,null,null,27213,21057,15116,11841,9609,null,true,true,true,true,true]
[66,null,null,28822,22298,16008,12537,10189,null,true,true,true,true,true]
[67,null,null,32041,24783,17797,13941,11323,null,true,true,true,true,true]
[68,null,null,35245,27271,19581,15341,12459,null,true,true,true,true,true]
[69,null,null,36853,28512,20468,16046,13034,null,true,true,true,true,true]
[70,null,null,37333,28967,20783,16346,13198,null,true,true,true,true,true]
[71,null,null,42003,32600,23393,18400,14861,null,true,true,true,true,true]
[72,null,null,46682,36223,26009,20453,16515,null,true,true,true,true,true]
[73,null,null,51362,39853,28610,22505,18172,null,true,true,true,true,true]
[74,null,null,56037,43490,31213,24550,19836,null,true,true,true,true,true]
[75,"o más",null,61304,48503,35807,26884,22764,null,true,true,true,true,true]
[1,"Hijo",null,2795,1990,1509,1323,962,null,true,true,true,true,true]
[2,"Hijos",null,4545,3141,2386,2103,1407,null,true,true,true,true,true]
[3,"Hijos o más",null,6648,4571,3483,3046,2140,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":3308.79},{"$f":"$L$2*E341","v":2484.6400000000003},1826.91,1383.8300000000002,1092.8600000000001]
[25,"-  29",null,{"$f":"$L$2*D342","v":3679.26},2771.3700000000003,2027.7800000000002,1541.77,1214.23]
[30,"-  34",null,4263.3200000000006,3261.09,2417.33,1831.68,1410.8600000000001]
[35,"-  39",null,4730.25,3629.44,2691.34,2092.9700000000003,1565.6200000000001]
[40,"-  44",null,5338.16,4117.5700000000006,3052.27,2337.3000000000002,1776.0300000000002]
[45,"-  49",null,6206.3,4739.26,3443.4100000000003,2662.19,2066.4700000000003]
[50,"-  54",null,6799.37,5333.92,4013.1600000000003,2995.03,2267.87]
[55,"-  59",null,8035.3300000000008,6163.9000000000005,4442.46,3470.9700000000003,2683.3900000000003]
[60,null,null,8883.33,6823.75,4888.1900000000005,3827.13,2967.4700000000003]
[61,null,null,9996.86,7679.7000000000007,5501.93,4310.49,3342.71]
[62,null,null,11115.16,8538.83,6114.6100000000006,4793.8500000000004,3718.48]
[63,null,null,12224.980000000001,9400.08,6734.71,5278.8,4099.55]
[64,null,null,13341.16,10254.44,7346.8600000000006,5758.9800000000005,4473.7300000000005]
[65,null,null,14422.890000000001,11160.210000000001,8011.4800000000005,6275.7300000000005,5092.7700000000004]
[66,null,null,15275.660000000002,11817.94,8484.24,6644.6100000000006,5400.17]
[67,null,null,16981.73,13134.99,9432.41,7388.7300000000005,6001.1900000000005]
[68,null,null,18679.850000000002,14453.630000000001,10377.93,8130.7300000000005,6603.27]
[69,null,null,19532.09,15111.36,10848.04,8504.380000000001,6908.02]
[70,null,null,19786.490000000002,15352.51,11014.99,8663.380000000001,6994.9400000000005]
[71,null,null,22261.59,17278,12398.29,9752,7876.3300000000008]
[72,null,null,24741.460000000003,19198.190000000002,13784.77,10840.09,8752.9500000000007]
[73,null,null,27221.86,21122.09,15163.300000000001,11927.650000000001,9631.16]
[74,null,null,29699.61,23049.7,16542.89,13011.5,10513.08]
[75,"o más",null,32491.120000000003,25706.59,18977.710000000003,14248.52,12064.92]
[1,"Hijo",null,1481.3500000000001,1054.7,799.7700000000001,701.19,509.86]
[2,"Hijos",null,2408.85,1664.73,1264.5800000000002,1114.5900000000001,745.71]
[3,"Hijos o más",null,3523.44,2422.63,1845.99,1614.38,1134.2]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["SECURE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6"]
[18,"-  24",null,6490,5090,3725,3113,2365,null,true,true,true,true,true]
[25,"-  29",null,7163,5743,4157,3469,2632,null,true,true,true,true,true]
[30,"-  34",null,8207,6740,4825,4031,3045,null,true,true,true,true,true]
[35,"-  39",null,9038,7538,5371,4483,3371,null,true,true,true,true,true]
[40,"-  44",null,10130,8602,6066,5066,3811,null,true,true,true,true,true]
[45,"-  49",null,11658,10087,7065,5882,4421,null,true,true,true,true,true]
[50,"-  54",null,12725,11105,7746,6456,4838,null,true,true,true,true,true]
[55,"-  59",null,14952,13255,9184,7654,5720,null,true,true,true,true,true]
[60,null,null,15653,14169,9719,8102,6060,null,true,true,true,true,true]
[61,null,null,17628,15943,10946,9122,6823,null,true,true,true,true,true]
[62,null,null,19593,17727,12183,10138,7595,null,true,true,true,true,true]
[63,null,null,21551,19507,13398,11161,8359,null,true,true,true,true,true]
[64,null,null,23530,21286,14624,12182,9124,null,true,true,true,true,true]
[65,null,null,23546,21490,14710,12251,9155,null,true,true,true,true,true]
[66,null,null,23570,21691,14790,12314,9184,null,true,true,true,true,true]
[67,null,null,26207,24111,16443,13694,10215,null,true,true,true,true,true]
[68,null,null,28830,26517,18098,15072,11249,null,true,true,true,true,true]
[69,null,null,30150,27720,18922,15747,11767,null,true,true,true,true,true]
[70,null,null,30199,28197,19114,15905,11821,null,true,true,true,true,true]
[71,null,null,33980,31731,21517,17902,13312,null,true,true,true,true,true]
[72,null,null,37775,35271,23920,19899,14797,null,true,true,true,true,true]
[73,null,null,41555,38792,26315,21895,16277,null,true,true,true,true,true]
[74,null,null,45340,42331,28715,23894,17769,null,true,true,true,true,true]
[75,"o más",null,49413,46432,31398,26134,19419,null,true,true,true,true,true]
[1,"Hijo",null,3133,1842,1506,1250,917,null,true,true,true,true,true]
[2,"Hijos",null,5280,2759,2366,1969,1461,null,true,true,true,true,true]
[3,"Hijos o más",null,7753,3956,3436,2854,2117,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":3439.7000000000003},{"$f":"$L$2*E408","v":2697.7000000000003},1974.25,1649.89,1253.45]
[25,"-  29",null,{"$f":"$L$2*D409","v":3796.3900000000003},3043.79,2203.21,1838.5700000000002,1394.96]
[30,"-  34",null,4349.71,3572.2000000000003,2557.25,2136.4300000000003,1613.8500000000001]
[35,"-  39",null,4790.1400000000003,3995.1400000000003,2846.63,2375.9900000000002,1786.63]
[40,"-  44",null,5368.9000000000005,4559.0600000000004,3214.98,2684.98,2019.8300000000002]
[45,"-  49",null,6178.7400000000007,5346.1100000000006,3744.4500000000003,3117.46,2343.13]
[50,"-  54",null,6744.25,5885.6500000000005,4105.38,3421.6800000000003,2564.1400000000003]
[55,"-  59",null,7924.56,7025.1500000000005,4867.5200000000004,4056.6200000000003,3031.6000000000004]
[60,null,null,8296.09,7509.5700000000006,5151.0700000000006,4294.0600000000004,3211.8]
[61,null,null,9342.84,8449.7900000000009,5801.38,4834.66,3616.19]
[62,null,null,10384.290000000001,9395.3100000000013,6456.9900000000007,5373.14,4025.3500000000004]
[63,null,null,11422.03,10338.710000000001,7100.9400000000005,5915.33,4430.2700000000004]
[64,null,null,12470.900000000001,11281.58,7750.72,6456.46,4835.72]
[65,null,null,12479.380000000001,11389.7,7796.3,6493.0300000000007,4852.1500000000005]
[66,null,null,12492.1,11496.230000000001,7838.7000000000007,6526.42,4867.5200000000004]
[67,null,null,13889.710000000001,12778.83,8714.7900000000009,7257.8200000000006,5413.95]
[68,null,null,15279.900000000001,14054.01,9591.94,7988.1600000000008,5961.97]
[69,null,null,15979.5,14691.6,10028.66,8345.91,6236.51]
[70,null,null,16005.470000000001,14944.41,10130.42,8429.65,6265.13]
[71,null,null,18009.400000000001,16817.43,11404.01,9488.0600000000013,7055.3600000000006]
[72,null,null,20020.75,18693.63,12677.6,10546.470000000001,7842.4100000000008]
[73,null,null,22024.15,20559.760000000002,13946.95,11604.35,8626.8100000000013]
[74,null,null,24030.2,22435.43,15218.95,12663.820000000002,9417.57]
[75,"o más",null,26188.890000000003,24608.960000000003,16640.940000000002,13851.02,10292.07]
[1,"Hijo",null,1660.49,976.2600000000001,798.18000000000006,662.5,486.01000000000005]
[2,"Hijos",null,2798.4,1462.27,1253.98,1043.5700000000002,774.33]
[3,"Hijos o más",null,4109.09,2096.6800000000003,1821.0800000000002,1512.6200000000001,1122.01]
[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,5365,4208,3076,2567,1949,null,true,true,true,true,true]
[25,"-  29",null,5918,4740,3434,2870,2169,null,true,true,true,true,true]
[30,"-  34",null,6782,5566,3988,3327,2505,null,true,true,true,true,true]
[35,"-  39",null,7477,6241,4433,3700,2788,null,true,true,true,true,true]
[40,"-  44",null,8379,7119,5010,4184,3148,null,true,true,true,true,true]
[45,"-  49",null,9648,8344,5849,4870,3655,null,true,true,true,true,true]
[50,"-  54",null,10535,9194,6407,5348,3997,null,true,true,true,true,true]
[55,"-  59",null,12370,10981,7597,6325,4735,null,true,true,true,true,true]
[60,null,null,12951,11731,8049,6701,5007,null,true,true,true,true,true]
[61,null,null,14586,13206,9060,7546,5646,null,true,true,true,true,true]
[62,null,null,16223,14676,10076,8391,6281,null,true,true,true,true,true]
[63,null,null,17857,16152,11088,9238,6911,null,true,true,true,true,true]
[64,null,null,19476,17624,12106,10085,7549,null,true,true,true,true,true]
[65,null,null,19499,17800,12186,10139,7573,null,true,true,true,true,true]
[66,null,null,19518,17967,12258,10190,7607,null,true,true,true,true,true]
[67,null,null,21704,19965,13622,11334,8458,null,true,true,true,true,true]
[68,null,null,23874,21978,14987,12471,9313,null,true,true,true,true,true]
[69,null,null,24968,22971,15675,13044,9738,null,true,true,true,true,true]
[70,null,null,25009,23364,15839,13165,9789,null,true,true,true,true,true]
[71,null,null,28141,26295,17822,14830,11028,null,true,true,true,true,true]
[72,null,null,31289,29215,19810,16486,12242,null,true,true,true,true,true]
[73,null,null,34417,32144,21797,18133,13480,null,true,true,true,true,true]
[74,null,null,37568,35077,23787,19791,14710,null,true,true,true,true,true]
[75,"o más",null,40933,38469,26018,21642,16078,null,true,true,true,true,true]
[1,"Hijo",null,2597,1539,1251,1036,763,null,true,true,true,true,true]
[2,"Hijos",null,4376,2282,1958,1628,1210,null,true,true,true,true,true]
[3,"Hijos o más",null,6427,3276,2854,2365,1749,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":2843.4500000000003},{"$f":"$L$2*E475","v":2230.2400000000002},1630.28,1360.51,1032.97]
[25,"-  29",null,{"$f":"$L$2*D476","v":3136.54},2512.2000000000003,1820.02,1521.1000000000001,1149.5700000000002]
[30,"-  34",null,3594.46,2949.98,2113.6400000000003,1763.3100000000002,1327.65]
[35,"-  39",null,3962.8100000000004,3307.73,2349.4900000000002,1961,1477.64]
[40,"-  44",null,4440.87,3773.07,2655.3,2217.52,1668.44]
[45,"-  49",null,5113.4400000000005,4422.3200000000006,3099.9700000000003,2581.1,1937.15]
[50,"-  54",null,5583.55,4872.8200000000006,3395.71,2834.44,2118.4100000000003]
[55,"-  59",null,6556.1,5819.93,4026.4100000000003,3352.25,2509.5500000000002]
[60,null,null,6864.0300000000007,6217.43,4265.97,3551.53,2653.71]
[61,null,null,7730.5800000000008,6999.18,4801.8,3999.38,2992.38]
[62,null,null,8598.19,7778.2800000000007,5340.2800000000007,4447.2300000000005,3328.9300000000003]
[63,null,null,9464.2100000000009,8560.5600000000013,5876.64,4896.1400000000003,3662.8300000000004]
[64,null,null,10322.280000000001,9340.7200000000012,6416.18,5345.05,4000.9700000000003]
[65,null,null,10334.470000000001,9434,6458.58,5373.67,4013.69]
[66,null,null,10344.540000000001,9522.51,6496.7400000000007,5400.7,4031.71]
[67,null,null,11503.12,10581.45,7219.6600000000008,6007.02,4482.74]
[68,null,null,12653.220000000001,11648.34,7943.1100000000006,6609.63,4935.8900000000003]
[69,null,null,13233.04,12174.630000000001,8307.75,6913.3200000000006,5161.1400000000003]
[70,null,null,13254.77,12382.92,8394.67,6977.4500000000007,5188.17]
[71,null,null,14914.730000000001,13936.35,9445.66,7859.9000000000005,5844.84]
[72,null,null,16583.170000000002,15483.95,10499.300000000001,8737.58,6488.26]
[73,null,null,18241.010000000002,17036.32,11552.41,9610.49,7144.4000000000005]
[74,null,null,19911.04,18590.810000000001,12607.11,10489.230000000001,7796.3]
[75,"o más",null,21694.49,20388.57,13789.54,11470.26,8521.34]
[1,"Hijo",null,1376.41,815.67000000000007,663.03000000000009,549.08000000000004,404.39000000000004]
[2,"Hijos",null,2319.2800000000002,1209.46,1037.74,862.84,641.30000000000007]
[3,"Hijos o más",null,3406.31,1736.2800000000002,1512.6200000000001,1253.45,926.97]
[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",3191,5612,8026,2578,4400,6224,2206,3794,5365,1753,2935,4116,1315,2120,2926,824,1215,1612]
[50,"o más",4035,6452,8870,3257,5075,6886,2751,4346,5915,2163,3342,4535,1593,2396,3205,963,1349,1750]
[]
["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":1691.23},2974.36,4253.7800000000007,1366.3400000000001,2332,3298.7200000000003,1169.18,2010.8200000000002,2843.4500000000003,929.09,1555.5500000000002,2181.48,696.95,1123.6000000000001,1550.78,436.72,643.95000000000005,854.36]
[75,"o más",{"$f":"+C544*$L$2","v":2138.5500000000002},3419.56,4701.1000000000004,1726.21,2689.75,3649.5800000000004,1458.03,2303.38,3134.9500000000003,1146.3900000000001,1771.26,2403.5500000000002,844.29000000000008,1269.8800000000001,1698.65,510.39000000000004,714.97,927.5]
[]
[]
[]
[]
[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]