{"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 : ",2,null,"Número de hijos en la póliza :",5]
[]
[null,null,null,null,null," Edad del titular :",50,null,"Edad de cónyuge :",55]
[]
[]
["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":[[47,0,47,1],[47,2,47,3],[35,0,35,1],[36,0,38,1],[36,2,38,3],[46,0,46,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],[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],[9,2,9,12],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[23,2,23,3],[30,2,30,3],[46,2,46,3],[17,2,18,3],[29,2,29,3],[24,2,24,3],[19,2,19,3],[20,2,20,3],[22,2,22,3],[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],[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],[28,2,28,3],[32,0,32,1],[33,0,33,1],[32,2,32,3],[44,2,44,3],[39,0,39,1],[34,2,34,3],[33,2,33,3],[41,2,41,3],[42,2,42,3],[39,2,39,3],[43,2,43,3],[40,2,40,3],[35,2,35,3],[34,0,34,1],[51,0,51,1],[51,2,51,3],[50,0,50,1],[50,2,50,3],[49,5,50,12],[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$21","v":"AGENCIA"}]
[]
[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":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T16:57:39.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[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":33738},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":23427},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":16941},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":13679},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":10780}]
[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":35901},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,5,TRUE)))","v":24929},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,6,TRUE)))","v":18026},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,7,TRUE)))","v":14561},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,8,TRUE)))","v":11478}]
[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":13494},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":9954},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":7845},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":6549},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":5095}]
[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":83133},{"$f":"SUM(J31:J34)","v":58310},{"$f":"SUM(K31:K34)","v":42812},{"$f":"SUM(L31:L34)","v":34789},{"$f":"SUM(M31:M34)","v":27353}]
[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":83208},{"$f":"SUM(J35:J36)","v":58385},{"$f":"SUM(K35:K36)","v":42887},{"$f":"SUM(L35:L36)","v":34864},{"$f":"SUM(M35:M36)","v":27428}]
[]
[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":17881.14},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":12416.310000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":8978.73},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":7249.8700000000008},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":5713.4000000000005}]
[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":19027.530000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,5,TRUE)))","v":13212.37},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,6,TRUE)))","v":9553.7800000000007},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,7,TRUE)))","v":7717.3300000000008},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,8,TRUE)))","v":6083.34}]
[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":7151.8200000000006},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":5275.62},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":4157.8500000000004},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":3470.9700000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":2700.35}]
[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":44060.49},{"$f":"SUM(J40:J43)","v":30904.3},{"$f":"SUM(K40:K43)","v":22690.36},{"$f":"SUM(L40:L43)","v":18438.170000000002},{"$f":"SUM(M40:M43)","v":14497.090000000002}]
[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":44135.49},{"$f":"SUM(J44:J45)","v":30979.3},{"$f":"SUM(K44:K45)","v":22765.360000000001},{"$f":"SUM(L44:L45)","v":18513.170000000002},{"$f":"SUM(M44:M45)","v":14572.090000000002}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":44060.49},{"$f":"J44","v":30904.3},22690.36,18438.170000000002,14497.090000000002]
[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":[[34,2,34,3],[39,0,39,1],[40,0,40,1],[41,0,41,1],[36,0,36,1],[25,0,25,1],[32,2,32,3],[26,0,26,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,2,29,3],[32,0,32,1],[29,0,29,1],[27,2,27,3],[28,2,28,3],[46,0,47,1],[33,0,33,1],[34,0,34,1],[37,0,37,1],[38,0,38,1],[45,0,45,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],[17,2,18,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[21,2,21,3],[46,2,47,3],[11,7,11,12],[11,0,11,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[45,2,45,3],[35,0,35,1],[35,2,35,3],[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],[41,2,41,3],[42,0,42,1],[13,7,13,12],[17,5,17,6],[16,5,16,6],[16,0,16,1],[44,0,44,1],[44,2,44,3],[19,0,19,1],[17,0,18,1],[20,0,21,1],[22,2,22,3],[31,2,31,3],[26,2,26,3],[20,2,20,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[49,0,49,1],[49,2,49,3],[48,0,48,1],[48,2,48,3],[49,5,50,12]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa 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":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T16:57:39.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[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":29027},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":20606},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":14868},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":12143},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":9280}]
[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":30889},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,5,TRUE)))","v":21928},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,6,TRUE)))","v":15817},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,7,TRUE)))","v":12921},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,8,TRUE)))","v":9880}]
[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":11318},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":8273},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":6198},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":5166},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":3835}]
[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":71234},{"$f":"SUM(J31:J34)","v":50807},{"$f":"SUM(K31:K34)","v":37108},{"$f":"SUM(L31:L34)","v":30455},{"$f":"SUM(M31:M34)","v":23220}]
[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":71309},{"$f":"SUM(J35:J36)","v":50882},{"$f":"SUM(K35:K36)","v":37183},{"$f":"SUM(L35:L36)","v":30530},{"$f":"SUM(M35:M36)","v":23295}]
[]
[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":15384.310000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":10921.18},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":7880.04},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":6435.79},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":4918.4000000000005}]
[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":16371.17},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,5,TRUE)))","v":11621.84},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,6,TRUE)))","v":8383.01},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,7,TRUE)))","v":6848.13},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,8,TRUE)))","v":5236.4000000000005}]
[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":5998.54},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":4384.6900000000005},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":3284.94},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":2737.98},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":2032.5500000000002}]
[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":37754.020000000004},{"$f":"SUM(J40:J43)","v":26927.71},{"$f":"SUM(K40:K43)","v":19667.239999999998},{"$f":"SUM(L40:L43)","v":16141.15},{"$f":"SUM(M40:M43)","v":12306.600000000002}]
[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":37829.020000000004},{"$f":"SUM(J44:J45)","v":27002.71},{"$f":"SUM(K44:K45)","v":19742.239999999998},{"$f":"SUM(L44:L45)","v":16216.15},{"$f":"SUM(M44:M45)","v":12381.600000000002}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":37754.020000000004},{"$f":"J44","v":26927.71},19667.239999999998,16141.15,12306.600000000002]
[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":[[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],[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],[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],[29,0,29,1],[34,2,34,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],[22,2,22,3],[20,2,20,3],[51,5,52,12],[50,2,50,3],[46,2,46,3],[44,2,44,3],[51,2,52,3],[25,2,25,3],[23,2,23,3],[54,0,54,1],[54,2,54,3],[53,0,53,1],[53,2,53,3],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[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]]}
[]
[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":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T16:57:39.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,4,TRUE)","v":19101},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":14999},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":11179},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":8341},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":6329}]
[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":22575},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,5,TRUE)))","v":17315},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,6,TRUE)))","v":12365},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,7,TRUE)))","v":9665},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,8,TRUE)))","v":7480}]
[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":9884},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":6786},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":5122},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":4486},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":3153}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$301)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$301)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$301)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$301)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$301)","v":225}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$302)","v":300}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":52085},39625,29191,23017,17487]
[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":52160},{"$f":"SUM(J36:J37)","v":39700},{"$f":"SUM(K36:K37)","v":29266},{"$f":"SUM(L36:L37)","v":23092},{"$f":"SUM(M36:M37)","v":17562}]
[]
[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":10123.530000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":7949.47},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":5924.87},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":4420.7300000000005},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":3354.3700000000003}]
[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":11964.75},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,5,TRUE)))","v":9176.9500000000007},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,6,TRUE)))","v":6553.4500000000007},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,7,TRUE)))","v":5122.45},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,8,TRUE)))","v":3964.4}]
[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":5238.5200000000004},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":3596.5800000000004},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":2714.6600000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":2377.58},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":1671.0900000000001}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$334)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$334)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$334)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$334)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$334)","v":119.25}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$335)","v":159}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":27605.05},21001.250000000004,15471.23,12199.01,9268.11]
[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":27680.05},{"$f":"SUM(J46:J47)","v":21076.250000000004},{"$f":"SUM(K46:K47)","v":15546.23},{"$f":"SUM(L46:L47)","v":12274.01},{"$f":"SUM(M46:M47)","v":9343.11}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":27605.05},{"$f":"J46","v":21001.250000000004},15471.23,12199.01,9268.11]
[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":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
["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-04T16:57:39.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[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":19086},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":14984},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":11183},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":8330},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":6322}]
[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":22553},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,5,TRUE)))","v":17299},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,6,TRUE)))","v":12369},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,7,TRUE)))","v":9662},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,8,TRUE)))","v":7476}]
["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":9890},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":6793},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":5133},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":4479},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":3153}]
["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":51529},39076,28685,22471,16951]
["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":51604},{"$f":"SUM(J36:J37)","v":39151},{"$f":"SUM(K36:K37)","v":28760},{"$f":"SUM(L36:L37)","v":22546},{"$f":"SUM(M36:M37)","v":17026}]
["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":10115.58},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":7941.52},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":5926.9900000000007},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":4414.9000000000005},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":3350.6600000000003}]
["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":11953.09},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,5,TRUE)))","v":9168.4700000000012},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,6,TRUE)))","v":6555.5700000000006},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,7,TRUE)))","v":5120.8600000000006},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,8,TRUE)))","v":3962.28}]
["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":5241.7},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":3600.29},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":2720.4900000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":2373.8700000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":1671.0900000000001}]
["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":27310.37},20710.280000000002,15203.050000000001,11909.630000000003,8984.0300000000007]
[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":27385.37},{"$f":"SUM(J46:J47)","v":20785.280000000002},{"$f":"SUM(K46:K47)","v":15278.050000000001},{"$f":"SUM(L46:L47)","v":11984.630000000003},{"$f":"SUM(M46:M47)","v":9059.0300000000007}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":27310.37},{"$f":"J46","v":20710.280000000002},15203.050000000001,11909.630000000003,8984.0300000000007]
[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":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T16:57:39.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,4,TRUE)","v":14200},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":12392},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":8643},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":7396},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":5543}]
[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":16688},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,5,TRUE)))","v":14795},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,6,TRUE)))","v":10239},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,7,TRUE)))","v":8758},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,8,TRUE)))","v":6549}]
[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":8659},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":4411},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":3836},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":3275},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":2423}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$435)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$435)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$435)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$435)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$435)","v":225}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$436)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$436)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$436)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$436)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$436)","v":300}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":40072},32123,23243,19954,15040]
[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":40147},{"$f":"SUM(J36:J37)","v":32198},{"$f":"SUM(K36:K37)","v":23318},{"$f":"SUM(L36:L37)","v":20029},{"$f":"SUM(M36:M37)","v":15115}]
[]
[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":7526},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":6567.76},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":4580.79},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":3919.88},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":2937.79}]
[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":8844.6400000000012},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,5,TRUE)))","v":7841.35},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,6,TRUE)))","v":5426.67},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,7,TRUE)))","v":4641.74},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,8,TRUE)))","v":3470.9700000000003}]
[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":4589.2700000000004},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":2337.83},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":2033.0800000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":1735.75},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":1284.19}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$468)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$468)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$468)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$468)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$468)","v":119.25}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$469)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$469)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$469)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$469)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$469)","v":159}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":21238.160000000003},17025.190000000002,12318.789999999999,10575.619999999999,7971.2000000000007]
[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":21313.160000000003},{"$f":"SUM(J46:J47)","v":17100.190000000002},{"$f":"SUM(K46:K47)","v":12393.789999999999},{"$f":"SUM(L46:L47)","v":10650.619999999999},{"$f":"SUM(M46:M47)","v":8046.2000000000007}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":21238.160000000003},{"$f":"J46","v":17025.190000000002},12318.789999999999,10575.619999999999,7971.2000000000007]
[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":[[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":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T16:57:39.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[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$475:$H$498,4,TRUE)","v":11744},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":10253},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":7142},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":6110},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":4583}]
[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":13809},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,5,TRUE)))","v":12245},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,6,TRUE)))","v":8470},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,7,TRUE)))","v":7252},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,8,TRUE)))","v":5417}]
[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":7175},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":3655},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":3180},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":2713},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":2006}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$502)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!E$502)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!F$502)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$502)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$502)","v":225}]
[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":33253},26678,19317,16600,12531]
[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":33328},{"$f":"SUM(J36:J37)","v":26753},{"$f":"SUM(K36:K37)","v":19392},{"$f":"SUM(L36:L37)","v":16675},{"$f":"SUM(M36:M37)","v":12606}]
[]
[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":6224.3200000000006},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":5434.09},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":3785.26},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":3238.3},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":2428.9900000000002}]
[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":7318.77},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,5,TRUE)))","v":6489.85},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,6,TRUE)))","v":4489.1000000000004},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,7,TRUE)))","v":3843.5600000000004},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,8,TRUE)))","v":2871.01}]
[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":3802.75},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":1937.15},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":1685.4},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":1437.89},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":1063.18}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$535)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!E$535)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!F$535)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$535)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$535)","v":119.25}]
[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":17624.09},14139.34,10238.01,8798,6641.43]
[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":17699.09},{"$f":"SUM(J46:J47)","v":14214.34},{"$f":"SUM(K46:K47)","v":10313.01},{"$f":"SUM(L46:L47)","v":8873},{"$f":"SUM(M46:M47)","v":6716.43}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":17624.09},{"$f":"J46","v":14139.34},10238.01,8798,6641.43]
[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":"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":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2021-11-04T16:57:39.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[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":55}]
[]
[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":9680},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,8,TRUE)),0)","v":7518},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,11,TRUE)),0)","v":6453},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,14,TRUE)),0)","v":4933},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,17,TRUE)),0)","v":3481},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,20,TRUE)),0)","v":1940}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":9680},{"$f":"SUM(I44:I46)","v":7518},6453,4933,3481,1940]
[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":9755},7593,6528,5008,3556,2015]
[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":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2021-11-04T16:57:39.430"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[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":83208},{"$f":"+Exclusive!J37","v":58385},{"$f":"+Exclusive!K37","v":42887},{"$f":"+Exclusive!L37","v":34864},{"$f":"+Exclusive!M37","v":27428}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":71309},{"$f":"+Privilege!J37","v":50882},{"$f":"+Privilege!K37","v":37183},{"$f":"+Privilege!L37","v":30530},{"$f":"+Privilege!M37","v":23295}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":52160},{"$f":"+'Advantage (Mundial)'!J38","v":39700},{"$f":"+'Advantage (Mundial)'!K38","v":29266},{"$f":"+'Advantage (Mundial)'!L38","v":23092},{"$f":"+'Advantage (Mundial)'!M38","v":17562}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":40147},{"$f":"+Secure!J38","v":32198},{"$f":"+Secure!K38","v":23318},{"$f":"+Secure!L38","v":20029},{"$f":"+Secure!M38","v":15115}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":33328},{"$f":"+Essential!J38","v":26753},{"$f":"+Essential!K38","v":19392},{"$f":"+Essential!L38","v":16675},{"$f":"+Essential!M38","v":12606}]
[]
["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":9755},{"$f":"+Critical!I49","v":7593},{"$f":"+Critical!J49","v":6528},{"$f":"+Critical!K49","v":5008},{"$f":"+Critical!L49","v":3556},{"$f":"+Critical!M49","v":2015}]
["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":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[[26,5,27,5],[26,6,27,6],[28,0,29,0],[30,0,31,0],[32,0,34,0],[32,2,34,2],[32,3,34,3],[33,4,34,4],[33,5,34,5],[33,6,34,6],[38,0,42,0],[25,0,27,0],[26,2,27,2],[26,3,27,3],[26,4,27,4],[47,0,48,0],[50,0,52,0],[1,2,3,7],[4,2,4,7],[10,0,12,0],[14,0,15,0],[16,0,17,0],[11,4,12,4],[11,5,12,5],[11,6,12,6],[11,7,12,7],[32,7,34,7],[40,5,42,5],[40,6,42,6],[39,7,42,7],[18,0,20,0]]}
[]
[null,null,"2022 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":556,"n_cols":20,"rows_kept":556,"cut":false,"hidden":true,"merged":[[553,17,553,19],[553,2,553,4],[553,5,553,7],[553,8,553,10],[553,11,553,13],[553,14,553,16],[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",null,1,2,3,4,5]
[18,"-  24",null,16637,10987,7515,5280,4150,null,true,true,true,true,true]
[25,"-  29",null,17450,12143,8323,5855,4598,null,true,true,true,true,true]
[30,"-  34",null,18158,13030,9326,7018,5530,null,true,true,true,true,true]
[35,"-  39",null,20331,14585,10461,7871,6195,null,true,true,true,true,true]
[40,"-  44",null,23573,15960,11607,8660,6812,null,true,true,true,true,true]
[45,"-  49",null,26360,17847,12976,9682,7623,null,true,true,true,true,true]
[50,"-  54",null,33738,23427,16941,13679,10780,null,true,true,true,true,true]
[55,"-  59",null,35901,24929,18026,14561,11478,null,true,true,true,true,true]
[60,null,null,39113,27204,20749,17547,14264,null,true,true,true,true,true]
[61,null,null,42022,29226,22284,18864,15330,null,true,true,true,true,true]
[62,null,null,46009,32015,24406,20646,16789,null,true,true,true,true,true]
[63,null,null,48922,34036,25947,21962,17851,null,true,true,true,true,true]
[64,null,null,52927,36834,28078,23759,19324,null,true,true,true,true,true]
[65,null,null,69195,48047,35511,31695,27258,null,true,true,true,true,true]
[66,null,null,80389,55841,41269,36845,31675,null,true,true,true,true,true]
[67,null,null,87808,60988,45081,40233,34602,null,true,true,true,true,true]
[68,null,null,97232,67532,49913,44564,38320,null,true,true,true,true,true]
[69,null,null,106984,74300,54924,49029,42170,null,true,true,true,true,true]
[70,null,null,131680,90483,64666,57147,49604,null,true,true,true,true,true]
[71,null,null,136847,94032,67204,59391,51556,null,true,true,true,true,true]
[72,null,null,140726,96695,69100,61067,53017,null,true,true,true,true,true]
[73,null,null,145894,100254,71637,63324,54969,null,true,true,true,true,true]
[74,null,null,148479,102021,72918,64441,55937,null,true,true,true,true,true]
[75,"o más",null,154947,106463,76082,67250,58375,null,true,true,true,true,true]
[1,"Hijo",null,5787,4262,3368,2815,2194,null,true,true,true,true,true]
[2,"Hijos",null,9204,6789,5358,4469,3475,null,true,true,true,true,true]
[3,"Hijos o más",null,13494,9954,7845,6549,5095,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":8817.61},{"$f":"$L$2*E6","v":5823.1100000000006},3982.9500000000003,2798.4,2199.5]
[25,"-  29",null,{"$f":"$L$2*D7","v":9248.5},6435.79,4411.1900000000005,3103.15,2436.94]
[30,"-  34",null,9623.74,6905.9000000000005,4942.7800000000007,3719.54,2930.9]
[35,"-  39",null,10775.43,7730.05,5544.33,4171.63,3283.3500000000004]
[40,"-  44",null,12493.69,8458.8000000000011,6151.71,4589.8,3610.36]
[45,"-  49",null,13970.800000000001,9458.91,6877.2800000000007,5131.46,4040.19]
[50,"-  54",null,17881.14,12416.310000000001,8978.73,7249.8700000000008,5713.4000000000005]
[55,"-  59",null,19027.530000000002,13212.37,9553.7800000000007,7717.3300000000008,6083.34]
[60,null,null,20729.89,14418.12,10996.970000000001,9299.91,7559.92]
[61,null,null,22271.66,15489.78,11810.52,9997.92,8124.9000000000005]
[62,null,null,24384.77,16967.95,12935.18,10942.380000000001,8898.17]
[63,null,null,25928.66,18039.080000000002,13751.91,{"$f":"$L$2*G17","v":11639.86},9461.0300000000007]
[64,null,null,28051.31,19522.02,14881.34,12592.27,10241.720000000001]
[65,null,null,36673.35,25464.91,18820.830000000002,16798.350000000002,14446.740000000002]
[66,null,null,42606.170000000006,29595.730000000003,21872.57,19527.850000000002,16787.75]
[67,null,null,46538.240000000005,32323.640000000003,23892.93,21323.49,18339.060000000001]
[68,null,null,51532.959999999999,35791.96,26453.890000000003,23618.920000000002,20309.600000000002]
[69,null,null,56701.520000000004,39379,29109.72,25985.370000000003,22350.100000000002]
[70,null,null,69790.400000000009,47955.990000000005,34272.980000000003,30287.91,26290.120000000003]
[71,null,null,72528.91,49836.959999999999,35618.120000000003,31477.230000000003,27324.68]
[72,null,null,74584.78,51248.350000000006,36623,32365.510000000002,28099.010000000002]
[73,null,null,77323.820000000007,53134.62,37967.61,33561.72,29133.57]
[74,null,null,78693.87000000001,54071.130000000005,38646.54,34153.730000000003,29646.61]
[75,"o más",null,82121.91,56425.39,40323.46,35642.5,30938.75]
[1,"Hijo",null,3067.11,2258.86,1785.0400000000002,1491.95,1162.8200000000002]
[2,"Hijos",null,4878.12,3598.17,2839.7400000000002,2368.5700000000002,1841.75]
[3,"Hijos o más",null,7151.8200000000006,5275.62,4157.8500000000004,3470.9700000000003,2700.35]
[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"]
[" "," ","DL1","DL2","DL3","DL4","DL5","DL6"]
[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",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","DL1","DL2","DL3","DL4","DL5","DL6"]
[18,"-  24",{"$f":"+C73*$L$2","v":0},0,0,0,0,0]
[25,"-  29",0,0,0,0,0,0]
[30,"-  34",0,0,0,0,0,0]
[35,"-  39",0,0,0,0,0,0]
[40,"-  44",0,0,0,0,0,0]
[45,"-  49",0,0,0,0,0,0]
[50,"-  54",0,0,0,0,0,0]
[55,"-  59",0,0,0,0,0,0]
[60,null,0,0,0,0,0,0]
[61,null,0,0,0,0,0,0]
[62,null,{"$f":"+C83*$L$2","v":0},0,0,0,0,0]
[63,null,0,0,0,0,0,0]
[64,null,0,0,0,0,0,0]
[65,null,0,0,0,0,0,0]
[66,null,0,0,0,0,0,0]
[67,null,0,0,0,0,0,0]
[68,null,0,0,0,0,0,0]
[69,null,0,0,0,0,0,0]
[70,null,0,0,0,0,0,0]
[71,null,0,0,0,0,0,0]
[72,null,{"$f":"+C93*$L$2","v":0},0,0,0,0,0]
[73,null,0,0,0,0,0,0]
[74,null,0,0,0,0,0,0]
[75,"o más",0,0,0,0,0,0]
[1,"Hijo",0,0,0,0,0,0]
[2,"Hijos",0,0,0,0,0,0]
[3,"Hijos o más",0,0,0,0,0,0]
[1,"Rider Comp. Maternidad",0,0,0,0,0,0]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["PRIVILEGE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6",null,2,3,4,5,6]
[18,"-  24",null,13996,9622,6540,4595,3494,null,true,true,true,true,true]
[25,"-  29",null,14683,10647,7243,5091,3878,null,true,true,true,true,true]
[30,"-  34",null,15323,11388,8128,6159,4697,null,true,true,true,true,true]
[35,"-  39",null,17168,12749,9107,6900,5271,null,true,true,true,true,true]
[40,"-  44",null,19873,13979,10125,7605,5805,null,true,true,true,true,true]
[45,"-  49",null,22204,15623,11325,8501,6494,null,true,true,true,true,true]
[50,"-  54",null,29027,20606,14868,12143,9280,null,true,true,true,true,true]
[55,"-  59",null,30889,21928,15817,12921,9880,null,true,true,true,true,true]
[60,null,null,33640,23811,18010,15373,12334,null,true,true,true,true,true]
[61,null,null,36137,25573,19342,16509,13253,null,true,true,true,true,true]
[62,null,null,39554,28005,21178,18079,14514,null,true,true,true,true,true]
[63,null,null,42060,29777,22515,19226,15438,null,true,true,true,true,true]
[64,null,null,45498,32215,24362,20792,16707,null,true,true,true,true,true]
[65,null,null,59477,42028,30802,27729,23546,null,true,true,true,true,true]
[66,null,null,69094,48830,35787,32233,27366,null,true,true,true,true,true]
[67,null,null,75466,53335,39089,35203,29887,null,true,true,true,true,true]
[68,null,null,83558,59043,43284,38980,33086,null,true,true,true,true,true]
[69,null,null,91934,64965,47618,42887,36415,null,true,true,true,true,true]
[70,null,null,113139,79111,56055,49968,42832,null,true,true,true,true,true]
[71,null,null,117580,82210,58258,51935,44517,null,true,true,true,true,true]
[72,null,null,120915,84535,59906,53408,45776,null,true,true,true,true,true]
[73,null,null,125346,87643,62101,55366,47469,null,true,true,true,true,true]
[74,null,null,127582,89198,63208,56347,48299,null,true,true,true,true,true]
[75,"o más",null,133123,93079,65956,58797,50400,null,true,true,true,true,true]
[1,"Hijo",null,4849,3550,2663,2219,1647,null,true,true,true,true,true]
[2,"Hijos",null,7722,5647,4232,3525,2616,null,true,true,true,true,true]
[3,"Hijos o más",null,11318,8273,6198,5166,3835,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":7417.88},{"$f":"$L$2*E140","v":5099.66},3466.2000000000003,2435.35,1851.8200000000002]
[25,"-  29",null,{"$f":"$L$2*D141","v":7781.9900000000007},5642.91,3838.7900000000004,2698.23,2055.34]
[30,"-  34",null,8121.1900000000005,6035.64,4307.84,3264.27,2489.4100000000003]
[35,"-  39",null,9099.0400000000009,6756.97,4826.71,3657,{"$f":"$L$2*H143","v":2793.63}]
[40,"-  44",null,10532.69,7408.8700000000008,5366.25,4030.65,3076.65]
[45,"-  49",null,11768.12,8280.19,6002.25,4505.5300000000007,3441.82]
[50,"-  54",null,15384.310000000001,10921.18,7880.04,6435.79,4918.4000000000005]
[55,"-  59",null,16371.17,11621.84,8383.01,6848.13,5236.4000000000005]
[60,null,null,17829.2,12619.83,9545.3000000000011,8147.6900000000005,6537.02]
[61,null,null,19152.61,13553.69,10251.26,8749.77,7024.09]
[62,null,null,20963.620000000003,14842.650000000001,11224.34,9581.8700000000008,7692.42]
[63,null,null,22291.800000000003,15781.810000000001,11932.95,10189.780000000001,8182.14]
[64,null,null,24113.940000000002,17073.95,12911.86,11019.76,8854.7100000000009]
[65,null,null,31522.81,22274.84,16325.060000000001,14696.37,12479.380000000001]
[66,null,null,36619.82,25879.9,18967.11,17083.490000000002,14503.980000000001]
[67,null,null,39996.980000000003,28267.550000000003,20717.170000000002,18657.59,15840.11]
[68,null,null,44285.740000000005,31292.79,22940.52,20659.400000000001,17535.580000000002]
[69,null,null,48725.020000000004,34431.450000000004,25237.54,22730.11,19299.95]
[70,null,null,59963.670000000006,41928.83,29709.15,26483.040000000001,22700.960000000003]
[71,null,null,62317.4,43571.3,30876.74,27525.550000000003,23594.010000000002]
[72,null,null,64084.950000000004,44803.55,31750.18,28306.240000000002,24261.280000000002]
[73,null,null,66433.38,46450.79,32913.53,29343.980000000003,25158.57]
[74,null,null,67618.460000000006,47274.94,33500.240000000005,29863.91,25598.47]
[75,"o más",null,70555.19,49331.87,34956.68,31162.41,26712]
[1,"Hijo",null,2569.9700000000003,1881.5,1411.39,1176.0700000000002,872.91000000000008]
[2,"Hijos",null,4092.6600000000003,2992.9100000000003,2242.96,{"$f":"$L$2*G165","v":1868.25},1386.48]
[3,"Hijos o más",null,5998.54,4384.6900000000005,3284.94,2737.98,2032.5500000000002]
[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"]
[" "," ","CL1","CL2","CL3","CL4","CL5","CL6"]
[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",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","CL1","CL2","CL3","CL4","CL5","CL6"]
[18,"-  24",{"$f":"+C207*$L$2","v":0},0,0,0,0,0]
[25,"-  29",0,0,0,0,0,0]
[30,"-  34",0,0,0,0,0,0]
[35,"-  39",0,0,0,0,0,0]
[40,"-  44",0,0,0,0,0,0]
[45,"-  49",0,0,0,0,0,0]
[50,"-  54",0,0,0,0,0,0]
[55,"-  59",0,0,0,0,0,0]
[60,null,0,0,0,0,0,0]
[61,null,0,0,0,0,0,0]
[62,null,{"$f":"+C217*$L$2","v":0},0,0,0,0,0]
[63,null,0,0,0,0,0,0]
[64,null,0,0,0,0,0,0]
[65,null,0,0,0,0,0,0]
[66,null,0,0,0,0,0,0]
[67,null,0,0,0,0,0,0]
[68,null,0,0,0,0,0,0]
[69,null,0,0,0,0,0,0]
[70,null,0,0,0,0,0,0]
[71,null,0,0,0,0,0,0]
[72,null,{"$f":"+C227*$L$2","v":0},0,0,0,0,0]
[73,null,0,0,0,0,0,0]
[74,null,0,0,0,0,0,0]
[75,"o más",0,0,0,0,0,0]
[1,"Hijo",0,0,0,0,0,0]
[2,"Hijos",0,0,0,0,0,0]
[3,"Hijos o más",0,0,0,0,0,0]
[1,"Rider Comp. Maternidad",0,0,0,0,0,0]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["ADVANTAGE (WORLDWIDE)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6",null,2,3,4,5,6]
[18,"-  24",null,9317,6998,5091,3866,3073,null,true,true,true,true,true]
[25,"-  29",null,10362,7813,5675,4322,3405,null,true,true,true,true,true]
[30,"-  34",null,11994,9184,6750,5133,3955,null,true,true,true,true,true]
[35,"-  39",null,13295,10218,7504,5843,4382,null,true,true,true,true,true]
[40,"-  44",null,15006,11587,8516,6532,4964,null,true,true,true,true,true]
[45,"-  49",null,17425,13341,9593,7436,5761,null,true,true,true,true,true]
[50,"-  54",null,19101,14999,11179,8341,6329,null,true,true,true,true,true]
[55,"-  59",null,22575,17315,12365,9665,7480,null,true,true,true,true,true]
[60,null,null,24939,19172,13606,10658,8283,null,true,true,true,true,true]
[61,null,null,28067,21581,15315,12003,9330,null,true,true,true,true,true]
[62,null,null,31195,23987,17022,13350,10376,null,true,true,true,true,true]
[63,null,null,34317,26390,18741,14689,11420,null,true,true,true,true,true]
[64,null,null,37443,28796,20440,16034,12468,null,true,true,true,true,true]
[65,null,null,40489,31341,22287,17462,14185,null,true,true,true,true,true]
[66,null,null,42872,33186,23596,18496,15015,null,true,true,true,true,true]
[67,null,null,47643,36889,26228,20558,16697,null,true,true,true,true,true]
[68,null,null,52417,40581,28858,22615,18372,null,true,true,true,true,true]
[69,null,null,54803,42428,30173,23648,19216,null,true,true,true,true,true]
[70,null,null,55506,43102,30635,24088,19464,null,true,true,true,true,true]
[71,null,null,62461,48507,34469,27111,21900,null,true,true,true,true,true]
[72,null,null,69407,53897,38310,30135,24342,null,true,true,true,true,true]
[73,null,null,76353,59296,42142,33160,26790,null,true,true,true,true,true]
[74,null,null,83305,64700,45986,36177,29230,null,true,true,true,true,true]
[75,"o más",null,91131,72148,52742,39603,33539,null,true,true,true,true,true]
[1,"Hijo",null,4148,2960,2228,1951,1412,null,true,true,true,true,true]
[2,"Hijos",null,6750,4664,3514,3090,2083]
[3,"Hijos o más",null,9884,6786,5122,4486,3153]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6"]
[18,"-  24",null,{"$f":"+D274*$L$2","v":4938.01},3708.94,2698.23,2048.98,1628.69]
[25,"-  29",null,5491.8600000000006,4140.8900000000003,3007.75,2290.6600000000003,1804.65]
[30,"-  34",null,6356.8200000000006,4867.5200000000004,3577.5,2720.4900000000002,2096.15]
[35,"-  39",null,7046.35,5415.54,3977.1200000000003,3096.79,2322.46]
[40,"-  44",null,7953.18,6141.1100000000006,4513.4800000000005,3461.96,2630.92]
[45,"-  49",null,9235.25,7070.7300000000005,5084.29,3941.0800000000004,3053.33]
[50,"-  54",null,10123.530000000001,7949.47,5924.87,4420.7300000000005,3354.3700000000003]
[55,"-  59",null,11964.75,9176.9500000000007,6553.4500000000007,5122.45,3964.4]
[60,null,null,13217.67,10161.16,7211.18,5648.7400000000007,4389.99]
[61,null,null,14875.51,11437.93,8116.9500000000007,6361.59,4944.9000000000005]
[62,null,null,{"$f":"+D284*$L$2","v":16533.350000000002},12713.11,9021.66,7075.5,5499.2800000000007]
[63,null,null,18188.010000000002,13986.7,9932.7300000000014,7785.17,6052.6]
[64,null,null,19844.79,15261.880000000001,10833.2,8498.02,6608.04]
[65,null,null,21459.170000000002,16610.73,11812.11,9254.86,7518.05]
[66,null,null,22722.16,17588.580000000002,12505.880000000001,9802.880000000001,7957.9500000000007]
[67,null,null,25250.79,19551.170000000002,13900.84,10895.74,8849.41]
[68,null,null,27781.010000000002,21507.93,15294.740000000002,11985.95,9737.16]
[69,null,null,29045.59,22486.84,15991.69,12533.44,10184.480000000001]
[70,null,null,29418.18,22844.06,16236.550000000001,12766.640000000001,10315.92]
[71,null,null,33104.33,25708.710000000003,18268.57,14368.83,11607]
[72,null,null,{"$f":"+D294*$L$2","v":36785.71},28565.41,20304.3,15971.550000000001,12901.26]
[73,null,null,40467.090000000004,31426.880000000001,22335.260000000002,17574.8,14198.7]
[74,null,null,44151.65,34291,24372.58,19173.810000000001,15491.900000000001]
[75,"o más",null,48299.43,38238.44,27953.260000000002,20989.59,17775.670000000002]
[1,"Hijo",null,2198.44,1568.8000000000002,1180.8400000000001,1034.03,748.36]
[2,"Hijos",null,3577.5,2471.92,1862.42,1637.7,1103.99]
[3,"Hijos o más",null,5238.5200000000004,3596.5800000000004,2714.6600000000003,2377.58,1671.0900000000001]
[1,"Rider Comp. Maternidad",null,119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,159,159,159,159,159]
[]
["ADVANTAGE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"AL2","AL3","AL4","AL5","AL6",null,2,3,4,5,6]
[18,"-  24",null,9289,6983,5087,3864,3058,null,true,true,true,true,true]
[25,"-  29",null,10348,7795,5657,4312,3384,null,true,true,true,true,true]
[30,"-  34",null,11976,9162,6739,5114,3941,null,true,true,true,true,true]
[35,"-  39",null,13279,10200,7502,5830,4372,null,true,true,true,true,true]
[40,"-  44",null,14987,11569,8508,6519,4949,null,true,true,true,true,true]
[45,"-  49",null,17416,13328,9592,7420,5755,null,true,true,true,true,true]
[50,"-  54",null,19086,14984,11183,8330,6322,null,true,true,true,true,true]
[55,"-  59",null,22553,17299,12369,9662,7476,null,true,true,true,true,true]
[60,null,null,24919,19156,13606,10653,8277,null,true,true,true,true,true]
[61,null,null,28051,21550,15315,11998,9327,null,true,true,true,true,true]
[62,null,null,31175,23975,17026,13342,10369,null,true,true,true,true,true]
[63,null,null,34301,26374,18743,14682,11418,null,true,true,true,true,true]
[64,null,null,37431,28784,20457,16034,12452,null,true,true,true,true,true]
[65,null,null,40473,31324,22290,17462,14172,null,true,true,true,true,true]
[66,null,null,42857,33169,23611,18491,15026,null,true,true,true,true,true]
[67,null,null,47631,36870,26244,20565,16697,null,true,true,true,true,true]
[68,null,null,52401,40557,28878,22634,18375,null,true,true,true,true,true]
[69,null,null,54788,42408,30185,23658,19220,null,true,true,true,true,true]
[70,null,null,55490,43086,30651,24106,19475,null,true,true,true,true,true]
[71,null,null,62443,48484,34495,27132,21911,null,true,true,true,true,true]
[72,null,null,69399,53896,38340,30150,24357,null,true,true,true,true,true]
[73,null,null,76345,59294,42182,33180,26801,null,true,true,true,true,true]
[74,null,null,83296,64685,46020,36203,29246,null,true,true,true,true,true]
[75,"o más",null,91118,72132,52785,39635,33557,null,true,true,true,true,true]
[1,"Hijo",null,4139,2952,2223,1949,1415,null,true,true,true,true,true]
[2,"Hijos",null,6761,4656,3513,3094,2083,null,true,true,true,true,true]
[3,"Hijos o más",null,9890,6793,5133,4479,3153,null,true,true,true,true,true]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"AL2","AL3","AL4","AL5","AL6"]
[18,"-  24",null,{"$f":"+D341*$L$2","v":4923.17},3700.9900000000002,2696.11,2047.92,1620.74]
[25,"-  29",null,5484.4400000000005,4131.3500000000004,2998.21,2285.36,1793.52]
[30,"-  34",null,6347.2800000000007,4855.8600000000006,3571.67,2710.42,2088.73]
[35,"-  39",null,{"$f":"+D344*$L$2","v":7037.8700000000008},5406,3976.0600000000004,3089.9,2317.1600000000003]
[40,"-  44",null,7943.1100000000006,6131.5700000000006,4509.24,3455.07,2622.9700000000003]
[45,"-  49",null,9230.48,7063.84,5083.76,3932.6000000000004,3050.15]
[50,"-  54",null,10115.58,7941.52,5926.9900000000007,4414.9000000000005,3350.6600000000003]
[55,"-  59",null,11953.09,9168.4700000000012,6555.5700000000006,5120.8600000000006,3962.28]
[60,null,null,13207.070000000002,10152.68,7211.18,5646.09,4386.8100000000004]
[61,null,null,14867.03,11421.5,8116.9500000000007,6358.9400000000005,4943.3100000000004]
[62,null,null,{"$f":"+D351*$L$2","v":16522.75},12706.75,9023.7800000000007,7071.26,5495.5700000000006]
[63,null,null,18179.530000000002,13978.220000000001,9933.7900000000009,7781.46,6051.54]
[64,null,null,19838.43,15255.52,10842.210000000001,8498.02,6599.56]
[65,null,null,21450.690000000002,16601.72,11813.7,9254.86,7511.1600000000008]
[66,null,null,22714.210000000003,17579.57,12513.83,9800.2300000000014,7963.7800000000007]
[67,null,null,25244.43,19541.100000000002,13909.320000000002,10899.45,8849.41]
[68,null,null,27772.530000000002,21495.210000000003,15305.34,11996.02,9738.75]
[69,null,null,29037.640000000003,22476.240000000002,15998.050000000001,12538.74,10186.6]
[70,null,null,29409.7,22835.58,16245.03,12776.18,10321.75]
[71,null,null,33094.79,25696.52,18282.350000000002,14379.960000000001,11612.83]
[72,null,null,{"$f":"+D361*$L$2","v":36781.47},{"$f":"+E361*$L$2","v":28564.880000000001},20320.2,15979.5,12909.210000000001]
[73,null,null,40462.85,31425.820000000003,22356.460000000003,17585.400000000001,14204.53]
[74,null,null,44146.880000000005,34283.050000000003,24390.600000000002,19187.59,15500.380000000001]
[75,"o más",null,48292.54,38229.96,27976.050000000003,21006.55,17785.21]
[1,"Hijo",null,2193.67,1564.5600000000002,1178.19,1032.97,749.95]
[2,"Hijos",null,3583.3300000000004,2467.6800000000003,1861.89,1639.8200000000002,1103.99]
[3,"Hijos o más",null,5241.7,3600.29,2720.4900000000002,2373.8700000000003,1671.0900000000001]
[1,"Rider Comp. Maternidad",null,0,0,0,0,0]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["SECURE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6",null,2,3,4,5,6]
[18,"-  24",null,7243,5678,4155,3556,2705,null,true,true,true,true,true]
[25,"-  29",null,7980,6395,4621,3964,2999,null,true,true,true,true,true]
[30,"-  34",null,9135,7518,5370,4603,3484,null,true,true,true,true,true]
[35,"-  39",null,10078,8416,5977,5124,3863,null,true,true,true,true,true]
[40,"-  44",null,11304,9596,6767,5790,4356,null,true,true,true,true,true]
[45,"-  49",null,13010,11250,7878,6745,5065,null,true,true,true,true,true]
[50,"-  54",null,14200,12392,8643,7396,5543,null,true,true,true,true,true]
[55,"-  59",null,16688,14795,10239,8758,6549,null,true,true,true,true,true]
[60,null,null,17468,15813,10849,9277,6932,null,true,true,true,true,true]
[61,null,null,19658,17800,12210,10446,7810,null,true,true,true,true,true]
[62,null,null,21857,19779,13578,11618,8688,null,true,true,true,true,true]
[63,null,null,24051,21772,14944,12786,9566,null,true,true,true,true,true]
[64,null,null,26246,23764,16304,13953,10447,null,true,true,true,true,true]
[65,null,null,26270,23988,16401,14033,10492,null,true,true,true,true,true]
[66,null,null,26307,24206,16504,14100,10523,null,true,true,true,true,true]
[67,null,null,29236,26910,18334,15684,11698,null,true,true,true,true,true]
[68,null,null,32166,29604,20187,17257,12883,null,true,true,true,true,true]
[69,null,null,33642,30953,21104,18045,13472,null,true,true,true,true,true]
[70,null,null,33691,31476,21319,18223,13534,null,true,true,true,true,true]
[71,null,null,37924,35421,24000,20503,15245,null,true,true,true,true,true]
[72,null,null,42147,39370,26677,22801,16945,null,true,true,true,true,true]
[73,null,null,46371,43318,29354,25086,18650,null,true,true,true,true,true]
[74,null,null,50591,47261,32027,27375,20356,null,true,true,true,true,true]
[75,"o más",null,55137,51841,35037,29939,22236,null,true,true,true,true,true]
[1,"Hijo",null,3503,2062,1677,1425,1054,null,true,true,true,true,true]
[2,"Hijos",null,5906,3058,2642,2251,1671,null,true,true,true,true,true]
[3,"Hijos o más",null,8659,4411,3836,3275,2423,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":"+D408*$L$2","v":3838.7900000000004},3009.34,2202.15,1884.68,1433.65]
[25,"-  29",null,{"$f":"+D409*$L$2","v":4229.4000000000005},3389.3500000000004,2449.13,2100.92,1589.47]
[30,"-  34",null,{"$f":"+D410*$L$2","v":4841.55},3984.5400000000004,2846.1000000000004,2439.59,1846.52]
[35,"-  39",null,{"$f":"+D411*$L$2","v":5341.34},{"$f":"+E411*$L$2","v":4460.4800000000005},3167.81,2715.7200000000003,2047.39]
[40,"-  44",null,{"$f":"+D412*$L$2","v":5991.12},5085.88,3586.51,3068.7000000000003,2308.6800000000003]
[45,"-  49",null,{"$f":"+D413*$L$2","v":6895.3},5962.5,4175.34,3574.8500000000004,2684.4500000000003]
[50,"-  54",null,{"$f":"+D414*$L$2","v":7526},6567.76,4580.79,3919.88,2937.79]
[55,"-  59",null,{"$f":"+D415*$L$2","v":8844.6400000000012},7841.35,5426.67,4641.74,3470.9700000000003]
[60,null,null,{"$f":"+D416*$L$2","v":9258.0400000000009},8380.8900000000012,5749.97,4916.8100000000004,3673.96]
[61,null,null,{"$f":"+D417*$L$2","v":10418.74},9434,6471.3,5536.38,4139.3]
[62,null,null,{"$f":"+D418*$L$2","v":11584.210000000001},10482.870000000001,7196.34,6157.54,4604.6400000000003]
[63,null,null,{"$f":"+D419*$L$2","v":12747.03},11539.16,7920.3200000000006,6776.58,5069.9800000000005]
[64,null,null,{"$f":"+D420*$L$2","v":13910.380000000001},12594.92,8641.1200000000008,7395.09,5536.91]
[65,null,null,{"$f":"+D421*$L$2","v":13923.1},12713.640000000001,8692.5300000000007,7437.4900000000007,5560.76]
[66,null,null,{"$f":"+D422*$L$2","v":13942.710000000001},12829.18,8747.1200000000008,7473,5577.1900000000005]
[67,null,null,{"$f":"+D423*$L$2","v":15495.08},14262.300000000001,9717.02,8312.52,6199.9400000000005]
[68,null,null,{"$f":"+D424*$L$2","v":17047.98},15690.12,10699.11,9146.2100000000009,6827.9900000000007]
[69,null,null,{"$f":"+D425*$L$2","v":17830.260000000002},16405.09,11185.12,9563.85,7140.1600000000008]
[70,null,null,{"$f":"+D426*$L$2","v":17856.23},16682.280000000002,11299.07,9658.19,7173.02]
[71,null,null,{"$f":"+D427*$L$2","v":20099.72},18773.13,12720,10866.59,8079.85]
[72,null,null,{"$f":"+D428*$L$2","v":22337.91},20866.100000000002,14138.810000000001,12084.53,8980.85]
[73,null,null,{"$f":"+D429*$L$2","v":24576.63},22958.54,15557.62,13295.58,9884.5]
[74,null,null,{"$f":"+D430*$L$2","v":26813.23},25048.33,16974.310000000001,14508.75,10788.68]
[75,"o más",null,{"$f":"+D431*$L$2","v":29222.61},27475.73,18569.61,15867.67,11785.08]
[1,"Hijo",null,{"$f":"+D432*$L$2","v":1856.5900000000001},1092.8600000000001,888.81000000000006,755.25,558.62]
[2,"Hijos",null,{"$f":"+D433*$L$2","v":3130.1800000000003},1620.74,1400.26,1193.03,885.63]
[3,"Hijos o más",null,{"$f":"+D434*$L$2","v":4589.2700000000004},2337.83,2033.0800000000002,1735.75,1284.19]
[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",null,2,3,4,5,6]
[18,"-  24",null,5985,4684,3424,2941,2226,null,true,true,true,true,true]
[25,"-  29",null,6600,5280,3820,3283,2472,null,true,true,true,true,true]
[30,"-  34",null,7550,6215,4440,3810,2870,null,true,true,true,true,true]
[35,"-  39",null,8332,6964,4946,4230,3189,null,true,true,true,true,true]
[40,"-  44",null,9344,7942,5593,4790,3600,null,true,true,true,true,true]
[45,"-  49",null,10758,9314,6517,5576,4184,null,true,true,true,true,true]
[50,"-  54",null,11744,10253,7142,6110,4583,null,true,true,true,true,true]
[55,"-  59",null,13809,12245,8470,7252,5417,null,true,true,true,true,true]
[60,null,null,14458,13088,8967,7675,5729,null,true,true,true,true,true]
[61,null,null,16266,14738,10097,8641,6467,null,true,true,true,true,true]
[62,null,null,18085,16380,11239,9613,7188,null,true,true,true,true,true]
[63,null,null,19914,18023,12367,10584,7919,null,true,true,true,true,true]
[64,null,null,21733,19679,13496,11549,8643,null,true,true,true,true,true]
[65,null,null,21755,19859,13582,11612,8676,null,true,true,true,true,true]
[66,null,null,21776,20047,13666,11671,8705,null,true,true,true,true,true]
[67,null,null,24205,22286,15180,12977,9679,null,true,true,true,true,true]
[68,null,null,26639,24529,16708,14284,10661,null,true,true,true,true,true]
[69,null,null,27853,25635,17476,14938,11149,null,true,true,true,true,true]
[70,null,null,27891,26065,17652,15083,11206,null,true,true,true,true,true]
[71,null,null,31402,29341,19875,16979,12614,null,true,true,true,true,true]
[72,null,null,34902,32609,22097,18880,14027,null,true,true,true,true,true]
[73,null,null,38399,35879,24309,20773,15448,null,true,true,true,true,true]
[74,null,null,41897,39141,26527,22676,16844,null,true,true,true,true,true]
[75,"o más",null,45660,42950,29019,24790,18409,null,true,true,true,true,true]
[1,"Hijo",null,2903,1709,1382,1183,885,null,true,true,true,true,true]
[2,"Hijos",null,4891,2531,2186,1874,1384,null,true,true,true,true,true]
[3,"Hijos o más",null,7175,3655,3180,2713,2006,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":"+D475*$L$2","v":3172.05},2482.52,1814.72,1558.73,1179.78]
[25,"-  29",null,3498,2798.4,2024.6000000000001,1739.99,1310.1600000000001]
[30,"-  34",null,4001.5,3293.9500000000003,2353.2000000000003,2019.3000000000002,1521.1000000000001]
[35,"-  39",null,4415.96,3690.92,2621.38,2241.9,1690.17]
[40,"-  44",null,4952.3200000000006,4209.26,2964.29,2538.7000000000003,1908]
[45,"-  49",null,5701.7400000000007,4936.42,3454.01,2955.28,2217.52]
[50,"-  54",null,6224.3200000000006,5434.09,3785.26,3238.3,2428.9900000000002]
[55,"-  59",null,7318.77,6489.85,4489.1000000000004,3843.5600000000004,2871.01]
[60,null,null,7662.7400000000007,6936.64,4752.51,4067.75,3036.3700000000003]
[61,null,null,8620.98,7811.14,5351.41,4579.7300000000005,3427.51]
[62,null,null,{"$f":"+D485*$L$2","v":9585.0500000000011},8681.4,5956.67,5094.8900000000003,3809.6400000000003]
[63,null,null,10554.42,9552.19,6554.51,5609.52,4197.0700000000006]
[64,null,null,11518.49,10429.870000000001,7152.88,6120.97,4580.79]
[65,null,null,11530.150000000001,10525.27,7198.46,6154.3600000000006,4598.2800000000007]
[66,null,null,11541.28,10624.91,7242.9800000000005,6185.63,4613.6500000000005]
[67,null,null,12828.650000000001,11811.58,8045.4000000000005,6877.81,5129.87]
[68,null,null,14118.67,13000.37,8855.24,7570.52,5650.33]
[69,null,null,14762.09,13586.550000000001,9262.2800000000007,7917.14,5908.97]
[70,null,null,14782.230000000001,13814.45,9355.5600000000013,7993.9900000000007,5939.18]
[71,null,null,16643.060000000001,15550.730000000001,10533.75,8998.8700000000008,6685.42]
[72,null,null,{"$f":"+D495*$L$2","v":18498.060000000001},17282.77,11711.41,10006.4,7434.31]
[73,null,null,20351.47,19015.870000000003,12883.77,11009.69,8187.4400000000005]
[74,null,null,22205.41,20744.73,14059.310000000001,12018.28,8927.32]
[75,"o más",null,24199.800000000003,22763.5,15380.070000000002,13138.7,9756.77]
[1,"Hijo",null,1538.5900000000001,905.7700000000001,732.46,626.99,469.05]
[2,"Hijos",null,2592.23,1341.43,1158.5800000000002,993.22,733.52]
[3,"Hijos o más",null,3802.75,1937.15,1685.4,1437.89,1063.18]
[1,"Rider Comp. Maternidad",null,119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,159,159,159,159,159]
[]
["CRITICAL"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","CR1",null,null,"CR2",null,null,"CR3",null,null,"CR4",null,null,"CR5",null,null,"CR6"]
[null,null,"INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR"]
[18,"-  49",3472,6118,8748,2813,4791,6786,2396,4127,5853,1902,3191,4492,1422,2302,3180,907,1357,1789]
[50,"o más",4400,7034,9680,3541,5518,7518,3006,4729,6453,2348,3638,4933,1726,2603,3481,1056,1506,1940]
[]
["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":1840.16},3242.54,4636.4400000000005,1490.89,2539.23,3596.5800000000004,1269.8800000000001,2187.31,3102.09,1008.0600000000001,1691.23,2380.7600000000002,753.66000000000008,1220.0600000000002,1685.4,480.71000000000004,719.21,948.17000000000007]
[75,"o más",{"$f":"+C544*$L$2","v":2332},3728.02,5130.4000000000005,1876.73,2924.54,3984.5400000000004,1593.18,2506.3700000000003,3420.09,1244.44,1928.14,2614.4900000000002,914.78000000000009,1379.5900000000001,1844.93,559.68000000000006,798.18000000000006,1028.2]
[]
[]
[null,null,2,null,null,3,null,null,4,null,null,5,null,null,6,null,null,7]
[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]