{"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":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,0,7,9],[11,3,11,9],[20,3,20,9]]}
[]
[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,null,"Nombre del Asegurado principal :","NOMBRE COMPLETO"]
[]
[null,null,null,null,null,"Número de adultos en la póliza : ",1,null,"Número de hijos en la póliza :",2]
[]
[null,null,null,null,null," Edad del titular :",25,null,"Edad de cónyuge :",18]
[]
[]
["2. INGRESE EL NOMBRE DE LA AGENCIA ASESORA :"]
[]
[null,null,"Nombre de la Agencia :","AGENCIA"]
[]
[]
["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":[[50,0,50,1],[50,2,50,3],[47,0,47,1],[47,2,47,3],[48,0,49,1],[48,2,49,3],[20,2,20,3],[22,2,22,3],[46,0,46,1],[44,0,44,1],[42,0,42,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],[20,0,21,1],[28,0,28,1],[29,0,29,1],[30,0,31,1],[9,2,9,12],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[23,2,23,3],[30,2,30,3],[46,2,46,3],[17,2,18,3],[29,2,29,3],[24,2,24,3],[19,2,19,3],[31,2,31,3],[27,2,27,3],[19,0,19,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],[14,0,14,1],[15,0,15,1],[16,0,16,1],[28,2,28,3],[27,0,27,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],[35,0,35,1],[36,0,38,1],[36,2,38,3],[51,0,51,1],[51,2,51,3],[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]]}
[]
[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$21","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":25}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T17:01:35.340"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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":11116},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":7739},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":5413},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":3777},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":2974}]
[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":5848},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":4309},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":3465},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":2860},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":2226}]
[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":16964},{"$f":"SUM(J31:J34)","v":12048},{"$f":"SUM(K31:K34)","v":9103},{"$f":"SUM(L31:L34)","v":6862},{"$f":"SUM(M31:M34)","v":5425}]
[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":17039},{"$f":"SUM(J35:J36)","v":12123},{"$f":"SUM(K35:K36)","v":9178},{"$f":"SUM(L35:L36)","v":6937},{"$f":"SUM(M35:M36)","v":5500}]
[]
[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":5891.4800000000005},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":4101.67},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":2868.8900000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":2001.8100000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":1576.22}]
[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":3099.44},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":2283.77},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":1836.45},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":1515.8000000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":1179.78}]
[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":8990.92},{"$f":"SUM(J40:J43)","v":6385.4400000000005},{"$f":"SUM(K40:K43)","v":4824.59},{"$f":"SUM(L40:L43)","v":3636.8600000000006},{"$f":"SUM(M40:M43)","v":2875.25}]
[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":9065.92},{"$f":"SUM(J44:J45)","v":6460.4400000000005},{"$f":"SUM(K44:K45)","v":4899.59},{"$f":"SUM(L44:L45)","v":3711.8600000000006},{"$f":"SUM(M44:M45)","v":2950.25}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":8990.92},{"$f":"J44","v":6385.4400000000005},4824.59,3636.8600000000006,2875.25]
[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":[[38,0,38,1],[34,2,34,3],[39,0,39,1],[40,0,40,1],[41,0,41,1],[36,0,36,1],[36,2,36,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[25,0,25,1],[48,0,48,1],[48,2,48,3],[33,0,33,1],[34,0,34,1],[42,2,42,3],[43,0,43,1],[46,0,47,1],[42,0,42,1],[40,2,40,3],[37,2,37,3],[38,2,38,3],[29,0,29,1],[9,2,9,12],[11,7,11,12],[19,0,19,1],[17,0,18,1],[20,0,21,1],[20,2,20,3],[11,0,11,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[46,2,47,3],[43,2,43,3],[39,2,39,3],[26,0,26,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,2,29,3],[27,2,27,3],[28,2,28,3],[31,2,31,3],[26,2,26,3],[32,0,32,1],[32,2,32,3],[41,2,41,3],[37,0,37,1],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[21,2,21,3],[22,2,22,3],[49,0,49,1],[49,2,49,3],[49,5,50,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[16,0,16,1],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[35,0,35,1],[35,2,35,3],[47,5,47,12],[16,2,16,3],[17,2,18,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$21","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":25}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T17:01:35.340"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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":9355},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":6786},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":4702},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":3269},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":2489}]
[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":4923},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":3601},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":2746},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":2271},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":1680}]
[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":14278},{"$f":"SUM(J31:J34)","v":10387},{"$f":"SUM(K31:K34)","v":7673},{"$f":"SUM(L31:L34)","v":5765},{"$f":"SUM(M31:M34)","v":4394}]
[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":14353},{"$f":"SUM(J35:J36)","v":10462},{"$f":"SUM(K35:K36)","v":7748},{"$f":"SUM(L35:L36)","v":5840},{"$f":"SUM(M35:M36)","v":4469}]
[]
[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":4958.1500000000005},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":3596.5800000000004},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":2492.06},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":1732.5700000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":1319.17}]
[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":2609.19},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":1908.5300000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":1455.38},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":1203.6300000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":890.40000000000009}]
[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":7567.34},{"$f":"SUM(J40:J43)","v":5505.1100000000006},{"$f":"SUM(K40:K43)","v":4066.69},{"$f":"SUM(L40:L43)","v":3055.4500000000003},{"$f":"SUM(M40:M43)","v":2328.8200000000002}]
[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":7642.34},{"$f":"SUM(J44:J45)","v":5580.1100000000006},{"$f":"SUM(K44:K45)","v":4141.6900000000005},{"$f":"SUM(L44:L45)","v":3130.4500000000003},{"$f":"SUM(M44:M45)","v":2403.8200000000002}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":7567.34},{"$f":"J44","v":5505.1100000000006},4066.69,3055.4500000000003,2328.8200000000002]
[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":[[53,0,53,1],[53,2,53,3],[35,0,41,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],[29,0,29,1],[34,2,34,3],[26,0,26,1],[26,2,26,3],[27,2,27,3],[33,0,33,1],[34,0,34,1],[32,2,32,3],[32,0,32,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[25,2,25,3],[23,2,23,3],[19,0,19,1],[24,2,24,3],[51,0,52,1],[28,2,28,3],[29,2,29,3],[30,2,30,3],[33,2,33,3],[31,2,31,3],[49,0,49,1],[50,0,50,1],[47,0,47,1],[48,0,48,1],[42,0,42,1],[42,2,42,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],[16,2,16,3],[17,2,18,3],[49,2,49,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],[51,5,52,12],[50,2,50,3],[46,2,46,3],[44,2,44,3],[51,2,52,3],[54,0,54,1],[54,2,54,3],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[35,2,39,3],[40,2,41,3],[20,0,21,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[19,2,19,3],[21,2,21,3],[22,2,22,3],[20,2,20,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$21","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":25}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T17:01:35.340"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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$274:$H$297,4,TRUE)","v":6596},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":4975},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":3677},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":2775},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":2190}]
[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":4296},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":2966},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":2281},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":1984},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":1328}]
[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":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":11192},8241,6258,5059,3818]
[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":11267},{"$f":"SUM(J36:J37)","v":8316},{"$f":"SUM(K36:K37)","v":6333},{"$f":"SUM(L36:L37)","v":5134},{"$f":"SUM(M36:M37)","v":3893}]
[]
[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":3495.88},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":2636.75},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":1948.8100000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":1470.75},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":1160.7}]
[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":2276.88},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":1571.98},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":1208.93},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":1051.52},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":703.84}]
[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":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":5931.76},4367.7299999999996,3316.7400000000002,2681.27,2023.54]
[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":6006.76},{"$f":"SUM(J46:J47)","v":4442.7299999999996},{"$f":"SUM(K46:K47)","v":3391.7400000000002},{"$f":"SUM(L46:L47)","v":2756.27},{"$f":"SUM(M46:M47)","v":2098.54}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":5931.76},{"$f":"J46","v":4367.7299999999996},3316.7400000000002,2681.27,2023.54]
[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":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$21","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":25}]
["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-11-04T17:01:35.340"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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":5107},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":3842},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":2846},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":2140},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":1683}]
[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":3347},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":2316},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":1779},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":1547},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":1034}]
["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":8454},6158,4625,3687,2717]
["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":8529},{"$f":"SUM(J36:J37)","v":6233},{"$f":"SUM(K36:K37)","v":4700},{"$f":"SUM(L36:L37)","v":3762},{"$f":"SUM(M36:M37)","v":2792}]
["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":2706.71},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":2036.26},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":1508.38},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":1134.2},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":891.99}]
["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":1773.91},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":1227.48},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":942.87},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":819.91000000000008},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":548.02}]
["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":4480.62},3263.74,2451.25,1954.1100000000001,1440.01]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,"n/a",{"$f":"SUM(I46:I47)","v":4555.62},{"$f":"SUM(J46:J47)","v":3338.74},{"$f":"SUM(K46:K47)","v":2526.25},{"$f":"SUM(L46:L47)","v":2029.1100000000001},{"$f":"SUM(M46:M47)","v":1515.01}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":4480.62},{"$f":"J46","v":3263.74},2451.25,1954.1100000000001,1440.01]
[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":[[33,2,33,3],[31,2,31,3],[47,0,48,1],[47,2,48,3],[45,2,45,3],[46,0,46,1],[45,0,45,1],[33,0,33,1],[34,0,34,1],[35,0,41,1],[44,0,44,1],[34,2,34,3],[40,2,41,3],[43,2,43,3],[44,2,44,3],[42,2,42,3],[42,0,42,1],[43,0,43,1],[35,2,39,3],[49,5,49,12],[46,2,46,3],[49,0,49,1],[49,2,49,3],[16,0,16,1],[19,0,19,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,0,29,1],[26,0,26,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[20,0,21,1],[15,0,15,1],[20,2,20,3],[17,2,18,3],[32,0,32,1],[32,2,32,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,2,22,3],[21,2,21,3],[25,2,25,3],[51,5,53,12],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[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$21","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":25}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T17:01:35.340"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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$408:$H$431,4,TRUE)","v":4956},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":3970},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":2926},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":2488},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":1882}]
[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":3658},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":1901},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":1667},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":1416},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":1047}]
[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":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":8914},6171,4893,4204,3229]
[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":8989},{"$f":"SUM(J36:J37)","v":6246},{"$f":"SUM(K36:K37)","v":4968},{"$f":"SUM(L36:L37)","v":4279},{"$f":"SUM(M36:M37)","v":3304}]
[]
[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":2626.6800000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":2104.1},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":1550.78},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":1318.64},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":997.46}]
[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":1938.74},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":1007.5300000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":883.51},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":750.48},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":554.91000000000008}]
[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":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":4724.42},3270.63,2593.29,2228.12,1711.3700000000001]
[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":4799.42},{"$f":"SUM(J46:J47)","v":3345.63},{"$f":"SUM(K46:K47)","v":2668.29},{"$f":"SUM(L46:L47)","v":2303.12},{"$f":"SUM(M46:M47)","v":1786.3700000000001}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":4724.42},{"$f":"J46","v":3270.63},2593.29,2228.12,1711.3700000000001]
[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":true,"merged":[[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,0,21,1],[16,2,16,3],[20,2,20,3],[17,2,18,3],[23,2,23,3],[19,2,19,3],[22,0,23,1],[49,2,49,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],[24,0,24,1],[35,2,39,3],[33,0,33,1],[34,0,34,1],[35,0,41,1],[40,2,41,3],[29,2,29,3],[30,2,30,3],[33,2,33,3],[27,2,27,3],[24,2,24,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],[49,5,49,12],[42,2,42,3],[49,0,49,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 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$21","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":25}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T17:01:35.340"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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":4204},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":3366},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":2480},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":2100},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":1589}]
[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":3107},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":1611},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":1417},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":1204},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":889}]
[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":7611},5277,4197,3604,2778]
[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":7686},{"$f":"SUM(J36:J37)","v":5352},{"$f":"SUM(K36:K37)","v":4272},{"$f":"SUM(L36:L37)","v":3679},{"$f":"SUM(M36:M37)","v":2853}]
[]
[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":2228.12},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":1783.98},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":1314.4},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":1113},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":842.17000000000007}]
[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":1646.71},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":853.83},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":751.01},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":638.12},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":471.17}]
[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":4033.83},2796.81,2224.41,1910.12,1472.3400000000001]
[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":4108.83},{"$f":"SUM(J46:J47)","v":2871.81},{"$f":"SUM(K46:K47)","v":2299.41},{"$f":"SUM(L46:L47)","v":1985.12},{"$f":"SUM(M46:M47)","v":1547.3400000000001}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":4033.83},{"$f":"J46","v":2796.81},2224.41,1910.12,1472.3400000000001]
[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":"Critical","index":7,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[29,8,29,9],[30,8,30,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],[19,0,19,1],[41,2,41,3],[44,0,44,1],[32,0,32,1],[35,0,39,1],[33,0,33,1],[34,0,34,1],[43,0,43,1],[22,0,23,1],[24,0,24,1],[30,2,31,3],[27,0,27,1],[28,0,28,1],[34,2,34,3],[29,0,29,1],[30,0,31,1],[25,0,25,1],[25,2,25,3],[23,2,23,3],[24,2,24,3],[27,2,27,3],[21,5,22,7],[21,8,22,9],[20,0,21,1],[21,2,21,3],[22,2,22,3],[45,2,45,3],[23,10,24,11],[33,10,36,12],[28,2,28,3],[29,2,29,3],[32,2,32,3],[33,2,33,3],[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],[9,2,9,12],[26,2,26,3],[17,2,18,3],[19,2,19,3],[20,2,20,3],[16,2,16,3],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[21,10,22,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[52,5,54,12],[17,0,18,1],[12,0,12,1],[14,0,14,1],[13,0,13,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],[35,2,39,3],[34,8,34,9],[27,8,27,9],[28,8,28,9]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa CRITICAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","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":25}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T17:01:35.340"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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":25}]
[]
[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":6741},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,8,TRUE)),0)","v":5180},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,11,TRUE)),0)","v":4467},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,14,TRUE)),0)","v":3369},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,17,TRUE)),0)","v":2392},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,20,TRUE)),0)","v":1353}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":6741},{"$f":"SUM(I44:I46)","v":5180},4467,3369,2392,1353]
[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":6816},5255,4542,3444,2467,1428]
[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$21","v":"AGENCIA"}]
[]
[null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":25}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2021-11-04T17:01:35.340"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},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":17039},{"$f":"+Exclusive!J37","v":12123},{"$f":"+Exclusive!K37","v":9178},{"$f":"+Exclusive!L37","v":6937},{"$f":"+Exclusive!M37","v":5500}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":14353},{"$f":"+Privilege!J37","v":10462},{"$f":"+Privilege!K37","v":7748},{"$f":"+Privilege!L37","v":5840},{"$f":"+Privilege!M37","v":4469}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":11267},{"$f":"+'Advantage (Mundial)'!J38","v":8316},{"$f":"+'Advantage (Mundial)'!K38","v":6333},{"$f":"+'Advantage (Mundial)'!L38","v":5134},{"$f":"+'Advantage (Mundial)'!M38","v":3893}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":8989},{"$f":"+Secure!J38","v":6246},{"$f":"+Secure!K38","v":4968},{"$f":"+Secure!L38","v":4279},{"$f":"+Secure!M38","v":3304}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":7686},{"$f":"+Essential!J38","v":5352},{"$f":"+Essential!K38","v":4272},{"$f":"+Essential!L38","v":3679},{"$f":"+Essential!M38","v":2853}]
[]
["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":6816},{"$f":"+Critical!I49","v":5255},{"$f":"+Critical!J49","v":4542},{"$f":"+Critical!K49","v":3444},{"$f":"+Critical!L49","v":2467},{"$f":"+Critical!M49","v":1428}]
["Tarifas en US $ -  Válidas desde 01 enero 2022"]
[]
["Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Comparacion de Beneficios","index":9,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[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,10598,7011,4887,3412,2686,null,true,true,true,true,true]
[25,"-  29",null,11116,7739,5413,3777,2974,null,true,true,true,true,true]
[30,"-  34",null,11557,8307,6060,4520,3566,null,true,true,true,true,true]
[35,"-  39",null,12947,9298,6791,5069,3995,null,true,true,true,true,true]
[40,"-  44",null,15006,10171,7533,5571,4389,null,true,true,true,true,true]
[45,"-  49",null,16778,11369,8419,6226,4908,null,true,true,true,true,true]
[50,"-  54",null,21465,14911,10986,8793,6933,null,true,true,true,true,true]
[55,"-  59",null,22836,15864,11685,9352,7378,null,true,true,true,true,true]
[60,null,null,24877,17309,13442,11264,9163,null,true,true,true,true,true]
[61,null,null,26723,18594,14436,12109,9846,null,true,true,true,true,true]
[62,null,null,29260,20367,15812,13247,10784,null,true,true,true,true,true]
[63,null,null,31114,21654,16800,14090,11462,null,true,true,true,true,true]
[64,null,null,33649,23429,18177,15245,12399,null,true,true,true,true,true]
[65,null,null,43987,30556,22981,20325,17479,null,true,true,true,true,true]
[66,null,null,51095,35501,26710,23621,20313,null,true,true,true,true,true]
[67,null,null,55819,38773,29173,25796,22186,null,true,true,true,true,true]
[68,null,null,61797,42936,32300,28567,24569,null,true,true,true,true,true]
[69,null,null,67994,47236,35533,31427,27033,null,true,true,true,true,true]
[70,null,null,83681,57512,41833,36619,31791,null,true,true,true,true,true]
[71,null,null,86966,59770,43474,38059,33043,null,true,true,true,true,true]
[72,null,null,89429,61457,44698,39138,33983,null,true,true,true,true,true]
[73,null,null,92714,63716,46343,40580,35231,null,true,true,true,true,true]
[74,null,null,94352,64842,47162,41294,35858,null,true,true,true,true,true]
[75,"o más",null,98465,67661,49216,43099,37414,null,true,true,true,true,true]
[1,"Hijo",null,3680,2709,2177,1802,1409,null,true,true,true,true,true]
[2,"Hijos",null,5848,4309,3465,2860,2226,null,true,true,true,true,true]
[3,"Hijos o más",null,8575,6320,5074,4197,3268,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":5616.9400000000005},{"$f":"$L$2*E6","v":3715.8300000000004},2590.11,1808.3600000000001,1423.5800000000002]
[25,"-  29",null,{"$f":"$L$2*D7","v":5891.4800000000005},4101.67,2868.8900000000003,2001.8100000000002,1576.22]
[30,"-  34",null,6125.21,4402.71,3211.8,2395.6,1889.98]
[35,"-  39",null,6861.9100000000008,4927.9400000000005,3599.23,2686.57,2117.35]
[40,"-  44",null,7953.18,5390.63,3992.4900000000002,2952.63,2326.17]
[45,"-  49",null,8892.34,6025.5700000000006,4462.0700000000006,3299.78,2601.2400000000002]
[50,"-  54",null,11376.45,7902.8300000000008,5822.58,4660.29,3674.4900000000002]
[55,"-  59",null,12103.08,8407.92,6193.05,4956.5600000000004,3910.34]
[60,null,null,13184.810000000001,9173.77,7124.26,5969.92,4856.3900000000003]
[61,null,null,14163.19,9854.82,7651.0800000000008,6417.77,5218.38]
[62,null,null,15507.800000000001,10794.51,8380.36,7020.9100000000008,5715.52]
[63,null,null,16490.420000000002,11476.62,8904,7467.7000000000007,6074.8600000000006]
[64,null,null,17833.97,12417.37,9633.8100000000013,8079.85,6571.47]
[65,null,null,23313.11,16194.68,12179.93,10772.25,9263.8700000000008]
[66,null,null,27080.350000000002,18815.530000000002,14156.300000000001,12519.130000000001,10765.890000000001]
[67,null,null,29584.07,20549.690000000002,15461.69,13671.880000000001,11758.58]
[68,null,null,32752.41,22756.080000000002,17119,15140.51,13021.570000000002]
[69,null,null,36036.82,25035.08,18832.490000000002,16656.310000000001,14327.490000000002]
[70,null,null,44350.93,30481.360000000001,22171.49,19408.07,16849.23]
[71,null,null,46091.98,31678.100000000002,23041.22,20171.27,17512.79]
[72,null,null,47397.37,32572.210000000003,23689.940000000002,20743.14,18010.990000000002]
[73,null,null,49138.420000000006,33769.480000000003,24561.79,21507.4,18672.43]
[74,null,null,50006.560000000005,34366.26,24995.86,21885.82,19004.740000000002]
[75,"o más",null,52186.450000000004,35860.33,26084.48,22842.47,19829.420000000002]
[1,"Hijo",null,1950.4,1435.77,1153.81,955.06000000000006,746.77]
[2,"Hijos",null,3099.44,2283.77,1836.45,1515.8000000000002,1179.78]
[3,"Hijos o más",null,4544.75,3349.6000000000004,2689.2200000000003,2224.4100000000003,1732.0400000000002]
[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,8916,6131,4242,2953,2252,null,true,true,true,true,true]
[25,"-  29",null,9355,6786,4702,3269,2489,null,true,true,true,true,true]
[30,"-  34",null,9773,7263,5273,3955,3020,null,true,true,true,true,true]
[35,"-  39",null,10942,8131,5905,4435,3382,null,true,true,true,true,true]
[40,"-  44",null,12664,8907,6571,4890,3733,null,true,true,true,true,true]
[45,"-  49",null,14148,9954,7345,5465,4178,null,true,true,true,true,true]
[50,"-  54",null,18496,13130,9637,7800,5958,null,true,true,true,true,true]
[55,"-  59",null,19677,13970,10261,8297,6346,null,true,true,true,true,true]
[60,null,null,21428,15174,11672,9868,7929,null,true,true,true,true,true]
[61,null,null,23021,16291,12540,10610,8513,null,true,true,true,true,true]
[62,null,null,25199,17845,13733,11617,9322,null,true,true,true,true,true]
[63,null,null,26795,18973,14598,12347,9913,null,true,true,true,true,true]
[64,null,null,28983,20528,15794,13356,10727,null,true,true,true,true,true]
[65,null,null,37886,26773,19969,17815,15124,null,true,true,true,true,true]
[66,null,null,44013,31110,23202,20701,17576,null,true,true,true,true,true]
[67,null,null,48072,33982,25339,22602,19196,null,true,true,true,true,true]
[68,null,null,53231,37620,28069,25041,21254,null,true,true,true,true,true]
[69,null,null,58563,41384,30873,27542,23387,null,true,true,true,true,true]
[70,null,null,72071,50398,36340,32091,27510,null,true,true,true,true,true]
[71,null,null,74905,52374,37767,33353,28594,null,true,true,true,true,true]
[72,null,null,77026,53859,38836,34298,29396,null,true,true,true,true,true]
[73,null,null,79856,55838,40268,35554,30485,null,true,true,true,true,true]
[74,null,null,81267,56821,40976,36189,31023,null,true,true,true,true,true]
[75,"o más",null,84812,59295,42760,37765,32368,null,true,true,true,true,true]
[1,"Hijo",null,3094,2264,1726,1428,1054,null,true,true,true,true,true]
[2,"Hijos",null,4923,3601,2746,2271,1680,null,true,true,true,true,true]
[3,"Hijos o más",null,7205,5279,4020,3326,2465,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":4725.4800000000005},{"$f":"$L$2*E140","v":3249.4300000000003},2248.2600000000002,1565.0900000000001,1193.5600000000002]
[25,"-  29",null,{"$f":"$L$2*D141","v":4958.1500000000005},3596.5800000000004,2492.06,1732.5700000000002,1319.17]
[30,"-  34",null,5179.6900000000005,3849.3900000000003,2794.69,2096.15,1600.6000000000001]
[35,"-  39",null,5799.26,4309.43,3129.65,2350.5500000000002,1792.46]
[40,"-  44",null,6711.92,4720.71,3482.63,2591.7000000000003,1978.49]
[45,"-  49",null,7498.4400000000005,5275.62,3892.8500000000004,2896.4500000000003,2214.34]
[50,"-  54",null,9802.880000000001,6958.9000000000005,5107.6100000000006,4134,3157.7400000000002]
[55,"-  59",null,10428.810000000001,7404.1,5438.33,4397.41,3363.38]
[60,null,null,11356.84,8042.22,6186.1600000000008,5230.04,4202.37]
[61,null,null,12201.130000000001,8634.23,6646.2000000000007,5623.3,4511.8900000000003]
[62,null,null,13355.470000000001,9457.85,7278.4900000000007,6157.01,4940.66]
[63,null,null,14201.35,10055.69,7736.9400000000005,6543.9100000000008,5253.89]
[64,null,null,15360.990000000002,10879.84,8370.82,7078.68,5685.31]
[65,null,null,20079.580000000002,14189.69,10583.57,9441.9500000000007,8015.72]
[66,null,null,23326.89,16488.3,12297.060000000001,10971.53,9315.2800000000007]
[67,null,null,25478.16,18010.46,13429.67,11979.060000000001,10173.880000000001]
[68,null,null,28212.43,19938.600000000002,14876.570000000002,13271.730000000001,11264.62]
[69,null,null,31038.390000000003,21933.52,16362.69,14597.26,12395.11]
[70,null,null,38197.630000000005,26710.940000000002,19260.2,17008.23,14580.300000000001]
[71,null,null,39699.65,27758.22,20016.510000000002,17677.09,15154.820000000002]
[72,null,null,40823.78,28545.27,20583.080000000002,18177.940000000002,15579.880000000001]
[73,null,null,42323.68,29594.140000000003,21342.04,18843.620000000003,16157.050000000001]
[74,null,null,43071.51,30115.13,21717.280000000002,19180.170000000002,16442.190000000002]
[75,"o más",null,44950.36,31426.350000000002,22662.800000000003,20015.45,17155.04]
[1,"Hijo",null,1639.8200000000002,1199.92,914.78000000000009,756.84,558.62]
[2,"Hijos",null,2609.19,1908.5300000000002,1455.38,1203.6300000000001,890.40000000000009]
[3,"Hijos o más",null,3818.65,2797.8700000000003,2130.6,1762.7800000000002,1306.45]
[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,5931,4462,3309,2491,1973,null,true,true,true,true,true]
[25,"-  29",null,6596,4975,3677,2775,2190,null,true,true,true,true,true]
[30,"-  34",null,7633,5849,4369,3290,2535,null,true,true,true,true,true]
[35,"-  39",null,8466,6508,4865,3752,2820,null,true,true,true,true,true]
[40,"-  44",null,9547,7376,5521,4193,3189,null,true,true,true,true,true]
[45,"-  49",null,11094,8494,6221,4771,3706,null,true,true,true,true,true]
[50,"-  54",null,12160,9547,7245,5356,4068,null,true,true,true,true,true]
[55,"-  59",null,14368,11021,8020,6201,4804,null,true,true,true,true,true]
[60,null,null,15875,12205,8816,6845,5318,null,true,true,true,true,true]
[61,null,null,17861,13735,9919,7707,5988,null,true,true,true,true,true]
[62,null,null,19854,15270,11029,8566,6658,null,true,true,true,true,true]
[63,null,null,21845,16799,12135,9431,7326,null,true,true,true,true,true]
[64,null,null,23829,18330,13244,10290,7997,null,true,true,true,true,true]
[65,null,null,25767,19946,14434,11208,9106,null,true,true,true,true,true]
[66,null,null,27289,21124,15290,11870,9643,null,true,true,true,true,true]
[67,null,null,30325,23478,16996,13193,10717,null,true,true,true,true,true]
[68,null,null,33359,25828,18689,14512,11791,null,true,true,true,true,true]
[69,null,null,34876,27004,19543,15176,12327,null,true,true,true,true,true]
[70,null,null,35330,27434,19847,15461,12491,null,true,true,true,true,true]
[71,null,null,39757,30869,22330,17399,14057,null,true,true,true,true,true]
[72,null,null,44175,34305,24817,19333,15624,null,true,true,true,true,true]
[73,null,null,48598,37734,27297,21276,17187,null,true,true,true,true,true]
[74,null,null,53024,41176,29786,23213,18752,null,true,true,true,true,true]
[75,"o más",null,57995,45921,34160,25411,21519,null,true,true,true,true,true]
[1,"Hijo",null,2642,1884,1443,1252,906,null,true,true,true,true,true]
[2,"Hijos",null,4296,2966,2281,1984,1328,null,true,true,true,true,true]
[3,"Hijos o más",null,6289,4330,3324,2873,2020,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":3143.4300000000003},{"$f":"$L$2*E274","v":2364.86},1753.77,1320.23,1045.69]
[25,"-  29",null,{"$f":"$L$2*D275","v":3495.88},2636.75,1948.8100000000002,1470.75,1160.7]
[30,"-  34",null,4045.4900000000002,3099.9700000000003,2315.5700000000002,1743.7,1343.55]
[35,"-  39",null,4486.9800000000005,3449.2400000000002,2578.4500000000003,1988.5600000000002,1494.6000000000001]
[40,"-  44",null,5059.91,3909.28,2926.13,2222.29,1690.17]
[45,"-  49",null,5879.8200000000006,4501.8200000000006,3297.13,2528.63,1964.18]
[50,"-  54",null,6444.8,5059.91,3839.8500000000004,2838.6800000000003,2156.04]
[55,"-  59",null,7615.04,5841.13,4250.6000000000004,3286.53,2546.1200000000003]
[60,null,null,8413.75,6468.6500000000005,4672.4800000000005,3627.8500000000004,2818.54]
[61,null,null,9466.33,7279.55,5257.0700000000006,4084.71,3173.6400000000003]
[62,null,null,10522.62,8093.1,5845.37,4539.9800000000005,3528.7400000000002]
[63,null,null,11577.85,8903.4700000000012,6431.55,4998.43,3882.78]
[64,null,null,12629.37,9714.9,7019.3200000000006,5453.7000000000007,4238.41]
[65,null,null,13656.51,10571.380000000001,7650.02,5940.2400000000007,4826.18]
[66,null,null,14463.17,11195.720000000001,8103.7000000000007,6291.1,5110.79]
[67,null,null,16072.25,12443.34,9007.880000000001,6992.29,5680.01]
[68,null,null,17680.27,13688.84,9905.17,7691.3600000000006,6249.2300000000005]
[69,null,null,18484.280000000002,14312.12,10357.790000000001,8043.2800000000007,6533.31]
[70,null,null,18724.900000000001,14540.02,10518.91,8194.33,6620.2300000000005]
[71,null,null,21071.210000000003,16360.570000000002,11834.900000000001,9221.4700000000012,7450.21]
[72,null,null,23412.75,18181.650000000001,13153.01,10246.49,8280.7200000000012]
[73,null,null,25756.940000000002,19999.02,14467.41,11276.28,9109.11]
[74,null,null,28102.720000000001,21823.280000000002,15786.58,12302.890000000001,9938.5600000000013]
[75,"o más",null,30737.350000000002,24338.13,18104.8,13467.83,11405.07]
[1,"Hijo",null,1400.26,998.5200000000001,764.79000000000008,663.56000000000006,480.18]
[2,"Hijos",null,2276.88,1571.98,1208.93,1051.52,703.84]
[3,"Hijos o más",null,3333.17,2294.9,1761.72,1522.69,1070.6000000000001]
[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,4592,3449,2552,1919,1513,null,true,true,true,true,true]
[25,"-  29",null,5107,3842,2846,2140,1683,null,true,true,true,true,true]
[30,"-  34",null,5913,4527,3382,2543,1954,null,true,true,true,true,true]
[35,"-  39",null,6558,5044,3771,2902,2173,null,true,true,true,true,true]
[40,"-  44",null,7405,5713,4275,3240,2459,null,true,true,true,true,true]
[45,"-  49",null,8600,6585,4819,3692,2860,null,true,true,true,true,true]
[50,"-  54",null,9432,7405,5623,4151,3147,null,true,true,true,true,true]
[55,"-  59",null,11149,8554,6221,4807,3721,null,true,true,true,true,true]
[60,null,null,12319,9468,6849,5307,4121,null,true,true,true,true,true]
[61,null,null,13873,10663,7706,5980,4641,null,true,true,true,true,true]
[62,null,null,15417,11852,8570,6644,5164,null,true,true,true,true,true]
[63,null,null,16966,13048,9430,7323,5681,null,true,true,true,true,true]
[64,null,null,18517,14230,10292,7992,6206,null,true,true,true,true,true]
[65,null,null,20017,15496,11218,8709,7071,null,true,true,true,true,true]
[66,null,null,21201,16409,11879,9219,7486,null,true,true,true,true,true]
[67,null,null,23565,18241,13209,10254,8324,null,true,true,true,true,true]
[68,null,null,25919,20071,14536,11279,9161,null,true,true,true,true,true]
[69,null,null,27104,20984,15197,11793,9577,null,true,true,true,true,true]
[70,null,null,27459,21314,15428,12018,9700,null,true,true,true,true,true]
[71,null,null,30896,23991,17371,13526,10922,null,true,true,true,true,true]
[72,null,null,34330,26662,19303,15037,12140,null,true,true,true,true,true]
[73,null,null,37780,29332,21238,16541,13357,null,true,true,true,true,true]
[74,null,null,41216,32008,23171,18059,14581,null,true,true,true,true,true]
[75,"o más",null,45086,35698,26582,19769,16736,null,true,true,true,true,true]
[1,"Hijo",null,2051,1465,1122,977,709,null,true,true,true,true,true]
[2,"Hijos",null,3347,2316,1779,1547,1034,null,true,true,true,true,true]
[3,"Hijos o más",null,4894,3366,2587,2231,1573,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":2433.7600000000002},{"$f":"$L$2*E341","v":1827.97},1352.5600000000002,1017.07,801.89]
[25,"-  29",null,{"$f":"$L$2*D342","v":2706.71},2036.26,1508.38,1134.2,891.99]
[30,"-  34",null,3133.8900000000003,2399.31,1792.46,1347.79,1035.6200000000001]
[35,"-  39",null,3475.7400000000002,2673.32,1998.63,1538.0600000000002,1151.69]
[40,"-  44",null,3924.65,3027.8900000000003,2265.75,1717.2,1303.27]
[45,"-  49",null,4558,3490.05,2554.0700000000002,1956.76,1515.8000000000002]
[50,"-  54",null,4998.96,3924.65,2980.19,2200.0300000000002,1667.91]
[55,"-  59",null,5908.97,4533.62,3297.13,2547.71,1972.13]
[60,null,null,6529.0700000000006,5018.04,3629.9700000000003,2812.71,2184.13]
[61,null,null,7352.6900000000005,5651.39,4084.1800000000003,3169.4,2459.73]
[62,null,null,8171.01,6281.56,4542.1000000000004,3521.32,2736.92]
[63,null,null,8991.98,6915.4400000000005,4997.9000000000005,3881.19,3010.9300000000003]
[64,null,null,9814.01,7541.9000000000005,5454.76,4235.76,3289.1800000000003]
[65,null,null,10609.01,8212.880000000001,5945.54,4615.7700000000004,3747.63]
[66,null,null,11236.53,8696.77,6295.87,4886.0700000000006,3967.5800000000004]
[67,null,null,12489.45,9667.7300000000014,7000.77,5434.62,4411.72]
[68,null,null,13737.070000000002,10637.630000000001,7704.0800000000008,5977.87,4855.33]
[69,null,null,14365.12,11121.52,8054.4100000000008,6250.29,5075.8100000000004]
[70,null,null,14553.27,11296.42,8176.84,6369.54,5141]
[71,null,null,16374.880000000001,12715.230000000001,9206.630000000001,7168.7800000000007,5788.66]
[72,null,null,18194.900000000001,14130.86,10230.59,7969.6100000000006,6434.2000000000007]
[73,null,null,20023.400000000001,15545.960000000001,11256.140000000001,8766.73,7079.21]
[74,null,null,21844.48,16964.240000000002,12280.630000000001,9571.27,7727.93]
[75,"o más",null,23895.58,18919.940000000002,14088.460000000001,10477.57,8870.08]
[1,"Hijo",null,1087.03,776.45,594.66000000000008,517.81000000000006,375.77000000000004]
[2,"Hijos",null,1773.91,1227.48,942.87,819.91000000000008,548.02]
[3,"Hijos o más",null,2593.8200000000002,1783.98,1371.1100000000001,1182.43,833.69]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["SECURE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6"]
[18,"-  24",null,4499,3530,2627,2233,1693,null,true,true,true,true,true]
[25,"-  29",null,4956,3970,2926,2488,1882,null,true,true,true,true,true]
[30,"-  34",null,5678,4672,3399,2888,2185,null,true,true,true,true,true]
[35,"-  39",null,6257,5225,3785,3213,2418,null,true,true,true,true,true]
[40,"-  44",null,7020,5965,4277,3631,2733,null,true,true,true,true,true]
[45,"-  49",null,8076,6985,4977,4223,3171,null,true,true,true,true,true]
[50,"-  54",null,8814,7695,5456,4631,3469,null,true,true,true,true,true]
[55,"-  59",null,10362,9187,6470,5485,4105,null,true,true,true,true,true]
[60,null,null,10839,9816,6852,5803,4343,null,true,true,true,true,true]
[61,null,null,12201,11046,7712,6540,4895,null,true,true,true,true,true]
[62,null,null,13570,12289,8581,7267,5438,null,true,true,true,true,true]
[63,null,null,14929,13516,9441,7998,5992,null,true,true,true,true,true]
[64,null,null,16291,14757,10303,8736,6540,null,true,true,true,true,true]
[65,null,null,16315,14897,10369,8787,6565,null,true,true,true,true,true]
[66,null,null,16333,15031,10425,8825,6585,null,true,true,true,true,true]
[67,null,null,18150,16701,11594,9811,7325,null,true,true,true,true,true]
[68,null,null,19970,18385,12751,10801,8067,null,true,true,true,true,true]
[69,null,null,20881,19219,13336,11289,8431,null,true,true,true,true,true]
[70,null,null,20921,19545,13476,11402,8475,null,true,true,true,true,true]
[71,null,null,23546,21992,15166,12837,9543,null,true,true,true,true,true]
[72,null,null,26164,24446,16857,14275,10607,null,true,true,true,true,true]
[73,null,null,28790,26889,18548,15696,11678,null,true,true,true,true,true]
[74,null,null,31409,29341,20237,17129,12744,null,true,true,true,true,true]
[75,"o más",null,34231,32183,22136,18732,13922,null,true,true,true,true,true]
[1,"Hijo",null,2171,1276,1058,895,660,null,true,true,true,true,true]
[2,"Hijos",null,3658,1901,1667,1416,1047,null,true,true,true,true,true]
[3,"Hijos o más",null,5376,2733,2422,2053,1515,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":2384.4700000000003},{"$f":"$L$2*E408","v":1870.9},1392.3100000000002,1183.49,897.29000000000008]
[25,"-  29",null,{"$f":"$L$2*D409","v":2626.6800000000003},2104.1,1550.78,1318.64,997.46]
[30,"-  34",null,3009.34,2476.1600000000003,1801.47,1530.64,1158.05]
[35,"-  39",null,3316.21,2769.25,2006.0500000000002,1702.89,1281.54]
[40,"-  44",null,3720.6000000000004,3161.4500000000003,2266.81,1924.43,1448.49]
[45,"-  49",null,4280.2800000000007,3702.05,2637.81,2238.19,1680.63]
[50,"-  54",null,4671.42,4078.3500000000004,2891.6800000000003,2454.4300000000003,1838.5700000000002]
[55,"-  59",null,5491.8600000000006,4869.1100000000006,3429.1000000000004,2907.05,2175.65]
[60,null,null,5744.67,5202.4800000000005,3631.5600000000004,3075.59,2301.79]
[61,null,null,6466.5300000000007,5854.38,4087.36,3466.2000000000003,2594.35]
[62,null,null,7192.1,6513.17,4547.93,3851.51,2882.1400000000003]
[63,null,null,7912.3700000000008,7163.4800000000005,5003.7300000000005,4238.9400000000005,3175.76]
[64,null,null,8634.23,7821.21,5460.59,4630.08,3466.2000000000003]
[65,null,null,8646.9500000000007,7895.4100000000008,5495.5700000000006,4657.1100000000006,3479.4500000000003]
[66,null,null,8656.49,7966.43,5525.25,4677.25,3490.05]
[67,null,null,9619.5,8851.5300000000007,6144.8200000000006,5199.83,3882.25]
[68,null,null,10584.1,9744.0500000000011,6758.0300000000007,5724.5300000000007,4275.51]
[69,null,null,11066.93,10186.07,7068.08,5983.17,4468.43]
[70,null,null,11088.130000000001,10358.85,7142.2800000000007,6043.06,4491.75]
[71,null,null,12479.380000000001,11655.76,8037.9800000000005,6803.6100000000006,5057.79]
[72,null,null,13866.92,12956.380000000001,8934.2100000000009,7565.75,5621.71]
[73,null,null,15258.7,14251.17,9830.44,8318.880000000001,6189.34]
[74,null,null,16646.77,15550.730000000001,10725.61,9078.3700000000008,6754.3200000000006]
[75,"o más",null,18142.43,17056.990000000002,11732.08,9927.9600000000009,7378.6600000000008]
[1,"Hijo",null,1150.6300000000001,676.28000000000009,560.74,474.35,349.8]
[2,"Hijos",null,1938.74,1007.5300000000001,883.51,750.48,554.91000000000008]
[3,"Hijos o más",null,2849.28,1448.49,1283.6600000000001,1088.0900000000001,802.95]
[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,3814,2989,2224,1888,1430,null,true,true,true,true,true]
[25,"-  29",null,4204,3366,2480,2100,1589,null,true,true,true,true,true]
[30,"-  34",null,4815,3959,2882,2443,1851,null,true,true,true,true,true]
[35,"-  39",null,5307,4433,3202,2723,2048,null,true,true,true,true,true]
[40,"-  44",null,5947,5056,3627,3077,2314,null,true,true,true,true,true]
[45,"-  49",null,6855,5925,4223,3580,2688,null,true,true,true,true,true]
[50,"-  54",null,7479,6532,4628,3927,2941,null,true,true,true,true,true]
[55,"-  59",null,8794,7802,5492,4649,3476,null,true,true,true,true,true]
[60,null,null,9200,8334,5817,4928,3679,null,true,true,true,true,true]
[61,null,null,10367,9382,6545,5550,4150,null,true,true,true,true,true]
[62,null,null,11520,10439,7288,6171,4620,null,true,true,true,true,true]
[63,null,null,12679,11486,8017,6792,5086,null,true,true,true,true,true]
[64,null,null,13832,12529,8749,7416,5550,null,true,true,true,true,true]
[65,null,null,13849,12652,8801,7457,5571,null,true,true,true,true,true]
[66,null,null,13867,12767,8856,7499,5590,null,true,true,true,true,true]
[67,null,null,15410,14194,9841,8334,6218,null,true,true,true,true,true]
[68,null,null,16959,15614,10833,9175,6845,null,true,true,true,true,true]
[69,null,null,17732,16324,11331,9595,7161,null,true,true,true,true,true]
[70,null,null,17767,16604,11448,9681,7193,null,true,true,true,true,true]
[71,null,null,19996,18684,12881,10903,8100,null,true,true,true,true,true]
[72,null,null,22222,20771,14323,12124,9010,null,true,true,true,true,true]
[73,null,null,24457,22850,15760,13332,9917,null,true,true,true,true,true]
[74,null,null,26684,24931,17192,14555,10821,null,true,true,true,true,true]
[75,"o más",null,29081,27344,18805,15918,11823,null,true,true,true,true,true]
[1,"Hijo",null,1847,1087,895,764,564,null,true,true,true,true,true]
[2,"Hijos",null,3107,1611,1417,1204,889,null,true,true,true,true,true]
[3,"Hijos o más",null,4565,2325,2063,1741,1288,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":2021.42},{"$f":"$L$2*E475","v":1584.17},1178.72,1000.6400000000001,757.90000000000009]
[25,"-  29",null,{"$f":"$L$2*D476","v":2228.12},1783.98,1314.4,1113,842.17000000000007]
[30,"-  34",null,2551.9500000000003,2098.27,1527.46,1294.79,981.03000000000009]
[35,"-  39",null,2812.71,2349.4900000000002,1697.0600000000002,1443.19,1085.44]
[40,"-  44",null,3151.9100000000003,2679.6800000000003,1922.3100000000002,1630.8100000000002,1226.42]
[45,"-  49",null,3633.15,3140.25,2238.19,1897.4,1424.64]
[50,"-  54",null,3963.8700000000003,3461.96,2452.84,2081.31,1558.73]
[55,"-  59",null,4660.8200000000006,4135.0600000000004,2910.76,2463.9700000000003,1842.2800000000002]
[60,null,null,4876,4417.0200000000004,3083.01,2611.84,1949.8700000000001]
[61,null,null,5494.51,4972.46,3468.8500000000004,2941.5,2199.5]
[62,null,null,6105.6,5532.67,3862.6400000000003,3270.63,2448.6]
[63,null,null,6719.87,6087.58,4249.01,3599.76,2695.58]
[64,null,null,7330.96,6640.37,4636.97,3930.48,2941.5]
[65,null,null,7339.97,6705.56,4664.5300000000007,3952.21,2952.63]
[66,null,null,7349.51,6766.51,4693.68,3974.4700000000003,2962.7000000000003]
[67,null,null,8167.3,7522.8200000000006,5215.7300000000005,4417.0200000000004,3295.54]
[68,null,null,8988.27,8275.42,5741.4900000000007,4862.75,3627.8500000000004]
[69,null,null,9397.9600000000009,8651.7200000000012,6005.43,5085.3500000000004,3795.3300000000004]
[70,null,null,9416.51,8800.1200000000008,6067.4400000000005,5130.93,3812.2900000000004]
[71,null,null,10597.880000000001,9902.52,6826.93,5778.59,4293]
[72,null,null,11777.66,11008.630000000001,7591.1900000000005,6425.72,4775.3]
[73,null,null,12962.210000000001,12110.5,8352.8000000000011,7065.96,5256.01]
[74,null,null,14142.52,13213.43,9111.76,7714.1500000000005,5735.13]
[75,"o más",null,15412.93,14492.320000000002,9966.65,8436.5400000000009,6266.1900000000005]
[1,"Hijo",null,978.91000000000008,576.11,474.35,404.92,298.92]
[2,"Hijos",null,1646.71,853.83,751.01,638.12,471.17]
[3,"Hijos o más",null,2419.4500000000003,1232.25,1093.3900000000001,922.73,682.64]
[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",2686,4715,6741,2154,3665,5180,1846,3157,4467,1429,2406,3369,1076,1736,2392,696,1022,1353]
[50,"o más",3392,5419,7454,2706,4225,5736,2300,3616,4928,1772,2734,3706,1299,1959,2616,808,1135,1461]
[]
["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":1423.5800000000002},2498.9500000000003,3572.73,1141.6200000000001,1942.45,2745.4,978.38,1673.21,2367.5100000000002,757.37,1275.18,1785.5700000000002,570.28,920.08,1267.76,368.88,541.66000000000008,717.09]
[75,"o más",{"$f":"+C544*$L$2","v":1797.76},2872.07,3950.6200000000003,1434.18,2239.25,3040.08,1219,1916.48,2611.84,939.16000000000008,1449.02,1964.18,688.47,1038.27,1386.48,428.24,601.55000000000007,774.33]
[]
[]
[]
[]
[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]