{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["INGRESO DE DATOS","Exclusive","Privilege","Advantage (Mundial)","Advantage (LA)","Secure","Essential","Critical","Resumen tarifas anuales","Comparacion de Beneficios","Tablas","Sheet1"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INGRESO DE DATOS","index":0,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,23,9],[11,1,11,2],[7,0,7,9],[11,3,11,9],[20,3,20,9],[9,0,9,9],[18,0,18,9]]}
[]
[null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null," "," "," "," "]
[]
["COTIZACION DE SEGURO MEDICO INTERNACIONAL"]
[]
["INGRESE LOS DATOS DEL PROPUESTO ASEGURADO:"]
[]
[null,"Nombre del Asegurado principal:",null,"NOMBRE COMPLETO"]
[]
[null,null,null,null,null,"Número de adultos en la póliza: ",1,null,"Número de hijos en la póliza:",2]
[]
[null,null,null,null,null," Edad del titular:",18,null,"Edad de cónyuge:",18]
[]
[]
["INGRESE EL NOMBRE DE LA AGENCIA ASESORA:"]
[]
[null,null,"Nombre de la Agencia:","AGENCIA"]
[]
[]
["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":[[49,5,50,12],[32,0,32,1],[33,0,33,1],[32,2,32,3],[44,2,44,3],[39,0,39,1],[34,2,34,3],[33,2,33,3],[41,2,41,3],[42,2,42,3],[39,2,39,3],[43,2,43,3],[40,2,40,3],[35,2,35,3],[48,0,49,1],[48,2,49,3],[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],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[12,0,12,1],[17,0,18,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[9,2,9,12],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[23,2,23,3],[30,2,30,3],[46,2,46,3],[17,2,18,3],[29,2,29,3],[24,2,24,3],[19,2,19,3],[20,2,20,3],[22,2,22,3],[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],[35,0,35,1],[36,0,38,1],[36,2,38,3],[46,0,46,1],[34,0,34,1],[45,0,45,1],[40,0,40,1],[41,0,41,1],[45,2,45,3],[43,0,43,1],[44,0,44,1],[42,0,42,1],[51,0,51,1],[51,2,51,3],[50,0,50,1],[50,2,50,3],[47,0,47,1],[47,2,47,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa EXCLUSIVE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:39.970"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null," ",false]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,4,TRUE)","v":18751},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":12385},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":8260},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":5853},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":4609}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,4,TRUE)))","v":10368},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":7652},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":5886},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":4948},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":3853}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$33)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$33)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$33)","v":225}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":29119},{"$f":"SUM(J31:J34)","v":20037},{"$f":"SUM(K31:K34)","v":14371},{"$f":"SUM(L31:L34)","v":11026},{"$f":"SUM(M31:M34)","v":8687}]
[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":29194},{"$f":"SUM(J35:J36)","v":20112},{"$f":"SUM(K35:K36)","v":14446},{"$f":"SUM(L35:L36)","v":11101},{"$f":"SUM(M35:M36)","v":8762}]
[]
[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":9938.0300000000007},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":6564.05},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":4377.8},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":3102.09},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":2442.77}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,4,TRUE)))","v":5495.04},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":4055.5600000000004},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":3119.5800000000004},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":2622.44},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":2042.0900000000001}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$66)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$66)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$66)","v":119.25}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":15433.07},{"$f":"SUM(J40:J43)","v":10619.61},{"$f":"SUM(K40:K43)","v":7616.630000000001},{"$f":"SUM(L40:L43)","v":5843.7800000000007},{"$f":"SUM(M40:M43)","v":4604.1100000000006}]
[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":15508.07},{"$f":"SUM(J44:J45)","v":10694.61},{"$f":"SUM(K44:K45)","v":7691.630000000001},{"$f":"SUM(L44:L45)","v":5918.7800000000007},{"$f":"SUM(M44:M45)","v":4679.1100000000006}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":15433.07},{"$f":"J44","v":10619.61},7616.630000000001,5843.7800000000007,4604.1100000000006]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[]
[null,null,null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[null," "]

{"sheet":"Privilege","index":2,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[49,5,50,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[35,0,35,1],[35,2,35,3],[47,5,47,12],[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],[43,2,43,3],[39,2,39,3],[26,0,26,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[9,2,9,12],[11,7,11,12],[19,0,19,1],[17,0,18,1],[20,0,21,1],[29,2,29,3],[27,2,27,3],[28,2,28,3],[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],[25,0,25,1],[48,0,48,1],[48,2,48,3],[33,0,33,1],[34,0,34,1],[42,2,42,3],[43,0,43,1],[46,0,47,1],[42,0,42,1],[40,2,40,3],[37,2,37,3],[38,2,38,3],[29,0,29,1],[49,0,49,1],[49,2,49,3],[32,0,32,1],[32,2,32,3],[41,2,41,3],[37,0,37,1],[38,0,38,1],[34,2,34,3],[39,0,39,1],[40,0,40,1],[41,0,41,1],[36,0,36,1],[36,2,36,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa PRIVILEGE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:39.970"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null," ",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":15762},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":10834},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":7180},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":5088},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":3883}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,4,TRUE)))","v":8698},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":6360},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":4643},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":3922},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":2898}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$167)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":24460},{"$f":"SUM(J31:J34)","v":17194},{"$f":"SUM(K31:K34)","v":11823},{"$f":"SUM(L31:L34)","v":9010},{"$f":"SUM(M31:M34)","v":6781}]
[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":24535},{"$f":"SUM(J35:J36)","v":17269},{"$f":"SUM(K35:K36)","v":11898},{"$f":"SUM(L35:L36)","v":9085},{"$f":"SUM(M35:M36)","v":6856}]
[]
[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":8353.86},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":5742.02},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":3805.4},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":2696.6400000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":2057.9900000000002}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,4,TRUE)))","v":4609.9400000000005},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":3370.8},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":2460.79},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":2078.6600000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":1535.94}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$200)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":12963.800000000001},{"$f":"SUM(J40:J43)","v":9112.82},{"$f":"SUM(K40:K43)","v":6266.1900000000005},{"$f":"SUM(L40:L43)","v":4775.3000000000011},{"$f":"SUM(M40:M43)","v":3593.9300000000003}]
[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":13038.800000000001},{"$f":"SUM(J44:J45)","v":9187.82},{"$f":"SUM(K44:K45)","v":6341.1900000000005},{"$f":"SUM(L44:L45)","v":4850.3000000000011},{"$f":"SUM(M44:M45)","v":3668.9300000000003}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":12963.800000000001},{"$f":"J44","v":9112.82},6266.1900000000005,4775.3000000000011,3593.9300000000003]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[]
[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":[[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[51,5,52,12],[50,2,50,3],[46,2,46,3],[44,2,44,3],[51,2,52,3],[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],[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],[21,2,21,3],[22,2,22,3],[20,2,20,3],[25,2,25,3],[23,2,23,3],[19,0,19,1],[24,2,24,3],[51,0,52,1],[28,2,28,3],[29,2,29,3],[30,2,30,3],[33,2,33,3],[31,2,31,3],[49,0,49,1],[50,0,50,1],[47,0,47,1],[48,0,48,1],[42,0,42,1],[42,2,42,3],[29,0,29,1],[34,2,34,3],[26,0,26,1],[26,2,26,3],[27,2,27,3],[33,0,33,1],[34,0,34,1],[32,2,32,3],[32,0,32,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[54,0,54,1],[54,2,54,3],[53,0,53,1],[53,2,53,3],[35,0,41,1],[48,2,48,3],[47,2,47,3],[44,0,44,1],[46,0,46,1],[45,2,45,3],[45,0,45,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:39.970"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,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":10587},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":7958},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":5662},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":4335},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":3434}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,4,TRUE)))","v":7680},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":5300},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":3889},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":3449},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":2319}]
[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":18792},13783,10076,8309,6278]
[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":18867},{"$f":"SUM(J36:J37)","v":13858},{"$f":"SUM(K36:K37)","v":10151},{"$f":"SUM(L36:L37)","v":8384},{"$f":"SUM(M36:M37)","v":6353}]
[]
[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":5611.1100000000006},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":4217.74},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":3000.86},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":2297.5500000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":1820.02}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,4,TRUE)))","v":4070.4},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":2809},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":2061.17},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":1827.97},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":1229.0700000000002}]
[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":9959.76},7304.99,5340.2800000000007,4403.7700000000004,3327.34]
[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":10034.76},{"$f":"SUM(J46:J47)","v":7379.99},{"$f":"SUM(K46:K47)","v":5415.2800000000007},{"$f":"SUM(L46:L47)","v":4478.7700000000004},{"$f":"SUM(M46:M47)","v":3402.34}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":9959.76},{"$f":"J46","v":7304.99},5340.2800000000007,4403.7700000000004,3327.34]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[]
[null,null,null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[]
[null," "]

{"sheet":"Advantage (LA)","index":4,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["                           Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:39.970"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,4,TRUE)","v":8195},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":6147},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":4356},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":3337},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":2635}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,4,TRUE)))","v":5967},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":4131},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":3034},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":2693},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":1804}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$368)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$369)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":14162},10278,7390,6030,4439]
[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":14237},{"$f":"SUM(J36:J37)","v":10353},{"$f":"SUM(K36:K37)","v":7465},{"$f":"SUM(L36:L37)","v":6105},{"$f":"SUM(M36:M37)","v":4514}]
[]
[null,null,null,null,null,"Tarifas Semestrales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,4,TRUE)","v":4343.3500000000004},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":3257.9100000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":2308.6800000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":1768.6100000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":1396.5500000000002}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,4,TRUE)))","v":3162.51},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":2189.4300000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":1608.02},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":1427.29},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":956.12}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$401)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$402)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":7505.8600000000006},5447.34,3916.7000000000003,3195.9,2352.67]
[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":7580.8600000000006},{"$f":"SUM(J46:J47)","v":5522.34},{"$f":"SUM(K46:K47)","v":3991.7000000000003},{"$f":"SUM(L46:L47)","v":3270.9},{"$f":"SUM(M46:M47)","v":2427.67}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":7505.8600000000006},{"$f":"J46","v":5447.34},3916.7000000000003,3195.9,2352.67]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2023"]

{"sheet":"Secure","index":5,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[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],[15,0,15,1],[20,2,20,3],[17,2,18,3],[32,0,32,1],[32,2,32,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,2,22,3],[21,2,21,3],[25,2,25,3],[16,0,16,1],[19,0,19,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,0,29,1],[26,0,26,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[20,0,21,1],[42,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],[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]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa SECURE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:39.970"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,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":8581},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":6732},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":4681},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":3947},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":3008}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,4,TRUE)))","v":6987},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":3638},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":2976},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":2494},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":1862}]
[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":16093},10895,8182,6966,5395]
[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":16168},{"$f":"SUM(J36:J37)","v":10970},{"$f":"SUM(K36:K37)","v":8257},{"$f":"SUM(L36:L37)","v":7041},{"$f":"SUM(M36:M37)","v":5470}]
[]
[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":4547.93},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":3567.96},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":2480.9300000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":2091.9100000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":1594.24}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,4,TRUE)))","v":3703.11},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":1928.14},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":1577.28},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":1321.8200000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":986.86}]
[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":8529.2900000000009},5774.35,4336.46,3691.9800000000005,2859.35]
[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":8604.2900000000009},{"$f":"SUM(J46:J47)","v":5849.35},{"$f":"SUM(K46:K47)","v":4411.46},{"$f":"SUM(L46:L47)","v":3766.9800000000005},{"$f":"SUM(M46:M47)","v":2934.35}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":8529.2900000000009},{"$f":"J46","v":5774.35},4336.46,3691.9800000000005,2859.35]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[null," "]
[null," ",null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Essential","index":6,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,5,53,12],[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],[35,2,39,3],[33,0,33,1],[34,0,34,1],[35,0,41,1],[40,2,41,3],[33,2,33,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[29,2,29,3],[30,2,30,3],[27,2,27,3],[24,2,24,3],[19,2,19,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[21,2,21,3],[22,2,22,3],[20,0,21,1],[22,0,23,1],[24,0,24,1],[15,2,15,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[23,2,23,3],[49,2,49,3],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[12,2,12,3],[13,2,13,3],[14,2,14,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa ESSENTIAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:39.970"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,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":7086},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":5248},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":3873},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":3256},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":2467}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,4,TRUE)))","v":5788},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":3017},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":2464},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":2064},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":1548}]
[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":13399},8790,6862,5845,4540]
[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":13474},{"$f":"SUM(J36:J37)","v":8865},{"$f":"SUM(K36:K37)","v":6937},{"$f":"SUM(L36:L37)","v":5920},{"$f":"SUM(M36:M37)","v":4615}]
[]
[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":3755.5800000000004},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":2781.44},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":2052.69},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":1725.68},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":1307.51}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,4,TRUE)))","v":3067.6400000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":1599.01},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":1305.92},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":1093.92},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":820.44}]
[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":7101.4700000000012},4658.7,3636.86,3097.8500000000004,2406.1999999999998]
[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":7176.4700000000012},{"$f":"SUM(J46:J47)","v":4733.7},{"$f":"SUM(K46:K47)","v":3711.86},{"$f":"SUM(L46:L47)","v":3172.8500000000004},{"$f":"SUM(M46:M47)","v":2481.1999999999998}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":7101.4700000000012},{"$f":"J46","v":4658.7},3636.86,3097.8500000000004,2406.1999999999998]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[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":[[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],[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],[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],[21,5,22,7],[21,8,22,9],[20,0,21,1],[21,2,21,3],[22,2,22,3],[25,0,25,1],[25,2,25,3],[23,2,23,3],[24,2,24,3],[27,2,27,3],[19,0,19,1],[41,2,41,3],[44,0,44,1],[32,0,32,1],[35,0,39,1],[33,0,33,1],[34,0,34,1],[43,0,43,1],[22,0,23,1],[24,0,24,1],[30,2,31,3],[27,0,27,1],[28,0,28,1],[34,2,34,3],[29,0,29,1],[30,0,31,1],[45,0,45,1],[23,5,24,7],[25,5,26,7],[27,5,28,7],[29,5,30,7],[31,5,32,7],[33,5,34,7],[35,5,36,7],[44,2,44,3],[26,0,26,1],[43,2,43,3],[40,0,40,1],[41,0,41,1],[42,0,42,1],[42,2,42,3],[40,2,40,3],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[29,8,29,9],[30,8,30,9]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa CRITICAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:39.970"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,null,true,null,null,{"$f":"IF(M16>=M18,M16,M18)","v":18}]
[]
[null,null,null,null,null,"CONDICION CRITICA CUBIERTA",null,null,"MAXIMO POR AÑO POLIZA",null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,"Enfermedades neurológicas y accidentes cerebro-vasculares",null,null,150000,null,"Tipo de trasplante",null,"Máximo Vitalicio"]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,null,null,"por persona"]
[null,null,null,null,null,"Cirugías cardíacas y angioplastías",null,null,150000,null,"Corazón",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Corazón y Pulmón (simultáneamente)",null,300000]
[null,null,null,null,null,"Tratamiento de cáncer",null,null,200000,null,"Pulmón",null,250000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Pancreas",null,250000]
[null,null,null,null,null,"Trauma grave (Politraumatismos)",null,null,150000,null,"Pancreas y Riñón (simultáneamente)",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Riñón",null,200000]
[null,null,null,null,null,"Insuficiencia renal crónica (Diálisis)",null,null,100000,null,"Hígado",null,200000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Médula ósea",null,250000]
[null,null,null,null,null,"Quemaduras graves ",null,null,300000,null,"La cobertura de trasplante de órganos está limitada a la Red de Proveedores para Procedimiento de Trasplante de la Compañía y no se proporcionará cobertura en proveedores fuera de esta Red especializada."]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[null,null,null,null,null,"Desorden infeccioso grave (Septicemia)",null,null,150000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[null,null,null,null,null,"Fuera del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima por plan individual :",null,{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,3,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,6,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,9,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,12,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,15,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,18,TRUE)),0)","v":0}]
[null,null,null,null,null,"Prima por plan para 2 personas :",null,{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,4,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,7,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,10,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,13,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,16,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,19,TRUE)),0)","v":0}]
[null,null,null,null,null,"Prima por plan familiar :",null,{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,5,TRUE)),0)","v":12683},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,8,TRUE)),0)","v":10691},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,11,TRUE)),0)","v":9158},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,14,TRUE)),0)","v":6920},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,17,TRUE)),0)","v":4779},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,20,TRUE)),0)","v":2501}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":12683},{"$f":"SUM(I44:I46)","v":10691},9158,6920,4779,2501]
[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":12758},10766,9233,6995,4854,2576]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[]
[]
[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":[[25,2,25,7],[32,0,32,1],[35,2,35,7],[39,0,41,7],[37,0,37,7],[28,0,28,1],[11,0,11,7],[13,2,13,7],[15,2,15,7],[19,0,19,1],[18,0,18,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]]}
[]
[null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null," "," "," "," "]
[]
[]
[]
[]
[]
["Cotización de Seguro Médico Internacional - BUPA CARE "]
[]
[null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2023-08-16T10:35:39.970"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null," "," "," "]
["Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
["PRODUCTOS",null,"Tarifas Anuales"]
["Bupa Exclusive Care",null,"n/a",{"$f":"+Exclusive!I37","v":29194},{"$f":"+Exclusive!J37","v":20112},{"$f":"+Exclusive!K37","v":14446},{"$f":"+Exclusive!L37","v":11101},{"$f":"+Exclusive!M37","v":8762}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":24535},{"$f":"+Privilege!J37","v":17269},{"$f":"+Privilege!K37","v":11898},{"$f":"+Privilege!L37","v":9085},{"$f":"+Privilege!M37","v":6856}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":18867},{"$f":"+'Advantage (Mundial)'!J38","v":13858},{"$f":"+'Advantage (Mundial)'!K38","v":10151},{"$f":"+'Advantage (Mundial)'!L38","v":8384},{"$f":"+'Advantage (Mundial)'!M38","v":6353}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":16168},{"$f":"+Secure!J38","v":10970},{"$f":"+Secure!K38","v":8257},{"$f":"+Secure!L38","v":7041},{"$f":"+Secure!M38","v":5470}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":13474},{"$f":"+Essential!J38","v":8865},{"$f":"+Essential!K38","v":6937},{"$f":"+Essential!L38","v":5920},{"$f":"+Essential!M38","v":4615}]
[]
["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":12758},{"$f":"+Critical!I49","v":10766},{"$f":"+Critical!J49","v":9233},{"$f":"+Critical!K49","v":6995},{"$f":"+Critical!L49","v":4854},{"$f":"+Critical!M49","v":2576}]
["Tarifas en US $ -  Válidas desde 01 enero 2023"]
[]
["Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Comparacion de Beneficios","index":9,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[6,5,7,5],[26,0,30,0],[35,0,36,0],[38,0,40,0],[1,1,3,6],[4,1,4,6],[5,6,7,6],[28,4,30,4],[28,5,30,5],[27,6,30,6],[5,0,7,0],[5,1,7,1],[5,2,7,2],[6,3,7,3],[6,4,7,4]]}
[]
[null,"2023 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":551,"n_cols":20,"rows_kept":551,"cut":false,"hidden":true,"merged":[[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[303,0,303,7],[269,0,269,7],[270,0,270,7],[271,0,271,1],[271,2,271,6],[170,2,170,6],[202,0,202,7],[236,0,236,7],[237,0,237,1],[237,2,237,6],[204,0,204,1],[204,2,204,6],[470,0,470,7],[403,0,403,7],[404,0,404,7],[405,0,405,1],[405,2,405,6],[304,2,304,6],[336,0,336,7],[437,0,437,7],[438,0,438,1],[438,2,438,6],[304,0,304,1],[370,0,370,7],[371,0,371,1],[371,2,371,6],[337,0,337,7],[338,0,338,1],[338,2,338,6],[539,0,539,1],[471,0,471,7],[472,0,472,1],[472,2,472,6],[504,0,504,7],[505,0,505,1],[505,2,505,6],[538,0,538,19],[537,0,537,19],[539,2,539,6],[540,14,540,16],[540,17,540,19],[547,14,547,16],[547,17,547,19],[545,0,545,19],[540,2,540,4],[547,2,547,4],[547,5,547,7],[547,8,547,10],[546,0,546,1],[546,2,546,6],[540,5,540,7],[540,8,540,10],[547,11,547,13],[540,11,540,13]]}
[]
["EXCLUSIVE",null,null,null,null,null,null,null,null,"FACTOR SEMESTRAL :",null,0.53]
["TARIFAS ANUALES"]
["EDAD",null,null,null,null,null,null,null,null,2,6,10,14,18]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6",null,"DW2","DW3","DW4","DW5","DW6"]
[18,"18-24",null,18751,12385,8260,5853,4609,null,0,0,0,0,0]
[25,"25-29",null,19663,13686,9152,6500,5104,null,0,0,0,0,0]
[30,"30-34",null,20455,14680,10247,7781,6137,null,0,0,0,0,0]
[35,"35-39",null,22909,16438,11489,8727,6874,null,0,0,0,0,0]
[40,"40-44",null,26568,17980,12749,9603,7553,null,0,0,0,0,0]
[45,"45-49",null,29700,20107,14262,10728,8451,null,0,0,0,0,0]
[50,"50-54",null,38011,26401,18607,15163,11956,null,0,0,0,0,0]
[55,"55-59",null,40443,28087,19802,16140,12725,null,0,0,0,0,0]
[60,"60",null,44065,30652,22784,19442,15818,null,0,0,0,0,0]
[61,"61",null,47348,32927,24475,20905,16994,null,0,0,0,0,0]
[62,"62",null,51833,36066,26808,22882,18607,null,0,0,0,0,0]
[63,"63",null,55118,38343,28500,24336,19787,null,0,0,0,0,0]
[64,"64",null,59620,41508,30841,26329,21410,null,0,0,0,0,0]
[65,"65",null,77949,54132,38998,35126,30212,null,0,0,0,0,0]
[66,"66",null,90561,62906,45313,40832,35109,null,0,0,0,0,0]
[67,"67",null,98914,68704,49502,44576,38343,null,0,0,0,0,0,null," "]
[68,"68",null,109530,76072,54815,49390,42464,null,0,0,0,0,0]
[69,"69",null,120510,83699,60320,54336,46726,null,0,0,0,0,0]
[70,"70",null,148323,101924,71005,63318,54970,null,0,0,0,0,0]
[71,"71",null,154156,105927,73795,65810,57137,null,0,0,0,0,0]
[72,"72",null,158521,108919,75874,67668,58752,null,0,0,0,0,0]
[73,"73",null,164345,112935,78665,70163,60915,null,0,0,0,0,0]
[74,"74",null,167250,114923,80063,71405,61984,null,0,0,0,0,0]
[75,"75+",null,174533,119930,83546,74520,64697,null,0,0,0,0,0]
[1,"1 Child",null,6518,4802,3698,3117,2433,null,0,0,0,0,0]
[2,"2 Children",null,10368,7652,5886,4948,3853,null,0,0,0,0,0]
[3,"3+ Children",null,15189,11208,8614,7256,5655,null,0,0,0,0,0]
[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",null,3,7,11,15,19]
[18,"18-24",null,{"$f":"$L$2*D6","v":9938.0300000000007},{"$f":"$L$2*E6","v":6564.05},4377.8,3102.09,2442.77,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D7","v":10421.390000000001},7253.58,4850.5600000000004,3445,2705.1200000000003,null,0,0,0,0,0]
[30,"30-34",null,10841.15,7780.4000000000005,5430.91,4123.93,3252.61,null,0,0,0,0,0]
[35,"35-39",null,12141.77,8712.1400000000012,6089.17,4625.3100000000004,3643.2200000000003,null,0,0,0,0,0]
[40,"40-44",null,14081.04,9529.4,6756.97,5089.59,4003.09,null,0,0,0,0,0]
[45,"45-49",null,15741,10656.710000000001,7558.8600000000006,5685.84,4479.0300000000007,null,0,0,0,0,0]
[50,"50-54",null,20145.830000000002,13992.53,9861.7100000000009,8036.39,6336.68,null,0,0,0,0,0]
[55,"55-59",null,21434.79,14886.11,10495.060000000001,8554.2000000000007,6744.25,null,0,0,0,0,0]
[60,"60",null,23354.45,16245.560000000001,12075.52,10304.26,8383.5400000000009,null,0,0,0,0,0]
[61,"61",null,25094.440000000002,17451.310000000001,12971.75,11079.650000000001,9006.82,null,0,0,0,0,0]
[62,"62",null,27471.49,19114.98,14208.240000000002,12127.460000000001,9861.7100000000009,null,0,0,0,0,0]
[63,"63",null,29212.54,20321.79,15105,12898.08,10487.11,null,0,0,0,0,0]
[64,"64",null,31598.600000000002,21999.24,16345.730000000001,13954.37,11347.300000000001,null,0,0,0,0,0]
[65,"65",null,41312.97,28689.960000000003,20668.940000000002,18616.780000000002,16012.36,null,0,0,0,0,0]
[66,"66",null,47997.33,33340.18,24015.89,21640.960000000003,18607.77,null,0,0,0,0,0]
[67,"67",null,52424.420000000006,36413.120000000003,26236.06,23625.280000000002,20321.79,null,0,0,0,0,0]
[68,"68",null,58050.9,40318.160000000003,29051.95,26176.7,22505.920000000002,null,0,0,0,0,0]
[69,"69",null,63870.3,44360.47,31969.600000000002,28798.080000000002,24764.780000000002,null,0,0,0,0,0]
[70,"70",null,78611.19,54019.72,37632.65,33558.54,29134.100000000002,null,0,0,0,0,0]
[71,"71",null,81702.680000000008,56141.310000000005,39111.35,34879.300000000003,30282.61,null,0,0,0,0,0]
[72,"72",null,84016.13,57727.07,40213.22,35864.04,31138.560000000001,null,0,0,0,0,0]
[73,"73",null,87102.85,59855.55,41692.450000000004,37186.39,32284.95,null,0,0,0,0,0]
[74,"74",null,88642.5,60909.19,42433.39,37844.65,32851.520000000004,null,0,0,0,0,0]
[75,"75+",null,92502.49,63562.9,44279.380000000005,39495.599999999999,34289.410000000003,null,0,0,0,0,0]
[1,"1 Child",null,{"$f":"$L$2*D30","v":3454.54},2545.06,1959.94,1652.01,1289.49,null,0,0,0,0,0]
[2,"2 Children",null,{"$f":"$L$2*D31","v":5495.04},4055.5600000000004,3119.5800000000004,2622.44,2042.0900000000001,null,0,0,0,0,0]
[3,"3+ Children",null,{"$f":"$L$2*D32","v":8050.17},5940.2400000000007,4565.42,3845.6800000000003,2997.15,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D33*$L$2","v":0},0,119.25,119.25,119.25]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["DIAMOND (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos",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,"DW2","DW3","DW4","DW5","DW6"]
[18,"18-24",null,15762,10834,7180,5088,3883,null,0,0,0,0,0]
[25,"25-29",null,16545,12001,7952,5645,4301,null,0,0,0,0,0]
[30,"30-34",null,17269,12834,8930,6818,5200,null,0,0,0,0,0]
[35,"35-39",null,19337,14365,10002,7645,5834,null,0,0,0,0,0]
[40,"40-44",null,22387,15750,11119,8433,6437,null,0,0,0,0,0]
[45,"45-49",null,25014,17595,12430,9429,7201,null,0,0,0,0,0]
[50,"50-54",null,32701,23218,16319,13452,10287,null,0,0,0,0,0]
[55,"55-59",null,34790,24705,17371,14315,10940,null,0,0,0,0,0]
[60,"60",null,37882,26829,19767,17029,13666,null,0,0,0,0,0]
[61,"61",null,40716,28802,21247,18299,14684,null,0,0,0,0,0]
[62,"62",null,44558,31555,23259,20036,16088,null,0,0,0,0,0]
[63,"63",null,47370,33551,24725,21300,17108,null,0,0,0,0,0]
[64,"64",null,51247,36295,26753,23040,18509,null,0,0,0,0,0]
[65,"65",null,66990,47337,33824,30727,26096,null,0,0,0,0,0]
[66,"66",null,77827,54999,39290,35706,30326,null,0,0,0,0,0]
[67,"67",null,85003,60066,42912,38998,33119,null,0,0,0,0,0]
[68,"68",null,94126,66516,47531,43194,36667,null,0,0,0,0,0]
[69,"69",null,103548,73182,52288,47513,40355,null,0,0,0,0,0]
[70,"70",null,127444,89106,61543,55368,47459,null,0,0,0,0,0]
[71,"71",null,132431,92609,63957,57540,49324,null,0,0,0,0,0]
[72,"72",null,136189,95225,65774,59173,50720,null,0,0,0,0,0]
[73,"73",null,141197,98722,68192,61347,52589,null,0,0,0,0,0]
[74,"74",null,143688,100466,69400,62439,53519,null,0,0,0,0,0]
[75,"75+",null,149947,104842,72423,65145,55855,null,0,0,0,0,0]
[1,"1 Child",null,5472,4002,2926,2465,1828,null,0,0,0,0,0]
[2,"2 Children",null,8698,6360,4643,3922,2898,null,0,0,0,0,0]
[3,"3+ Children",null,12742,9314,6808,5742,4246,null,0,0,0,0,0]
[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",null,3,7,11,15,19]
[18,"18-24",null,{"$f":"$L$2*D140","v":8353.86},{"$f":"$L$2*E140","v":5742.02},3805.4,2696.6400000000003,2057.9900000000002,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D141","v":8768.85},{"$f":"$L$2*E141","v":6360.5300000000007},4214.5600000000004,2991.8500000000004,2279.5300000000002,null,0,0,0,0,0]
[30,"30-34",null,9152.57,6802.02,4732.9000000000005,3613.54,2756,null,0,0,0,0,0]
[35,"35-39",null,10248.61,7613.4500000000007,5301.06,4051.8500000000004,3092.02,null,0,0,0,0,0]
[40,"40-44",null,11865.11,8347.5,5893.0700000000006,4469.49,3411.61,null,0,0,0,0,0]
[45,"45-49",null,13257.42,9325.35,6587.9000000000005,4997.37,3816.53,null,0,0,0,0,0]
[50,"50-54",null,17331.530000000002,12305.54,8649.07,7129.56,5452.1100000000006,null,0,0,0,0,0]
[55,"55-59",null,18438.7,13093.650000000001,9206.630000000001,7586.9500000000007,5798.2000000000007,null,0,0,0,0,0]
[60,"60",null,20077.460000000003,14219.37,10476.51,9025.3700000000008,7242.9800000000005,null,0,0,0,0,0]
[61,"61",null,21579.48,15265.060000000001,11260.91,9698.4700000000012,7782.52,null,0,0,0,0,0]
[62,"62",null,23615.74,16724.150000000001,12327.27,10619.08,8526.6400000000012,null,0,0,0,0,0]
[63,"63",null,25106.100000000002,17782.030000000002,13104.25,11289,9067.24,null,0,0,0,0,0]
[64,"64",null,27160.91,19236.350000000002,14179.09,12211.2,9809.77,null,0,0,0,0,0]
[65,"65",null,35504.700000000004,25088.61,17926.72,16285.310000000001,13830.880000000001,null,0,0,0,0,0]
[66,"66",null,41248.310000000005,29149.47,20823.7,{"$f":"$L$2*G154","v":18924.18},16072.78,null,0,0,0,0,0]
[67,"67",null,45051.590000000004,31834.980000000003,22743.360000000001,20668.940000000002,17553.07,null,0,0,0,0,0]
[68,"68",null,49886.780000000006,35253.480000000003,25191.43,22892.82,19433.510000000002,null,0,0,0,0,0]
[69,"69",null,54880.44,38786.46,27712.640000000003,25181.890000000003,21388.15,null,0,0,0,0,0]
[70,"70",null,67545.320000000007,47226.18,32617.79,29345.040000000001,25153.27,null,0,0,0,0,0]
[71,"71",null,70188.430000000008,49082.770000000004,33897.21,30496.2,26141.72,null,0,0,0,0,0]
[72,"72",null,72180.17,50469.25,34860.22,31361.690000000002,26881.600000000002,null,0,0,0,0,0]
[73,"73",null,74834.41,52322.66,36141.760000000002,32513.91,27872.170000000002,null,0,0,0,0,0]
[74,"74",null,76154.64,53246.98,36782,33092.67,28365.07,null,0,0,0,0,0]
[75,"75+",null,79471.91,55566.26,38384.19,34526.85,29603.15,null,0,0,0,0,0]
[1,"1 Child",null,2900.1600000000003,2121.06,1550.78,1306.45,968.84,null,0,0,0,0,0]
[2,"2 Children",null,4609.9400000000005,3370.8,2460.79,2078.6600000000003,1535.94,null,0,0,0,0,0]
[3,"3+ Children",null,6753.26,4936.42,3608.2400000000002,3043.26,2250.38,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D167*$L$2","v":0},0,119.25,119.25,119.25]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["COMPLETE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","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,null,null,null,null,null,null,null,2,6,10,14,18]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6",null,"DW2","DW3","DW4","DW5","DW6"]
[18,"18-24",null,10587,7958,5662,4335,3434,null,0,0,0,0,0]
[25,"25-29",null,11772,8874,6284,4831,3801,null,0,0,0,0,0]
[30,"30-34",null,13620,10424,7477,5732,4415,null,0,0,0,0,0]
[35,"35-39",null,15115,11608,8312,6529,4904,null,0,0,0,0,0]
[40,"40-44",null,17047,13164,9420,7300,5545,null,0,0,0,0,0]
[45,"45-49",null,19806,15159,10631,8306,6448,null,0,0,0,0,0]
[50,"50-54",null,21699,17046,12389,9332,7083,null,0,0,0,0,0]
[55,"55-59",null,25644,19669,13711,10807,8371,null,0,0,0,0,0]
[60,"60",null,28334,21782,15076,11924,9263,null,0,0,0,0,0]
[61,"61",null,31876,24513,16963,13418,10432,null,0,0,0,0,0]
[62,"62",null,35441,27250,18863,14923,11594,null,0,0,0,0,0]
[63,"63",null,38993,29975,20747,16424,12765,null,0,0,0,0,0]
[64,"64",null,42539,32715,22645,17918,13930,null,0,0,0,0,0]
[65,"65",null,45982,35609,24682,19517,15853,null,0,0,0,0,0]
[66,"66",null,48704,37700,26139,20671,16795,null,0,0,0,0,0]
[67,"67",null,54123,41904,29056,22974,18661,null,0,0,0,0,0]
[68,"68",null,59539,46096,31960,25278,20542,null,0,0,0,0,0]
[69,"69",null,62257,48192,33417,26433,21474,null,0,0,0,0,0]
[70,"70",null,63057,48961,33919,26936,21756,null,0,0,0,0,0]
[71,"71",null,70940,55094,38183,30318,24485,null,0,0,0,0,0]
[72,"72",null,78838,61218,42433,33686,27205,null,0,0,0,0,0]
[73,"73",null,86742,67351,46671,37056,29947,null,0,0,0,0,0]
[74,"74",null,94626,73487,50931,40432,32666,null,0,0,0,0,0]
[75,"75+",null,103514,81955,58418,44266,37489,null,0,0,0,0,0]
[1,"1 Child",null,4719,3357,2475,2185,1578,null,0,0,0,0,0]
[2,"2 Children",null,7680,5300,3889,3449,2319,null,0,0,0,0,0]
[3,"3+ Children",null,11231,7722,5673,5001,3519,null,0,0,0,0,0]
[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",null,3,7,11,15,19]
[18,"18-24",null,{"$f":"$L$2*D274","v":5611.1100000000006},{"$f":"$L$2*E274","v":4217.74},3000.86,2297.5500000000002,1820.02,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[25,"25-29",null,{"$f":"$L$2*D275","v":6239.1600000000008},{"$f":"$L$2*E275","v":4703.22},3330.52,2560.4300000000003,2014.5300000000002,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[30,"30-34",null,7218.6,5524.72,3962.8100000000004,3037.96,2339.9500000000003,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[35,"35-39",null,8010.9500000000007,6152.2400000000007,4405.3600000000006,3460.3700000000003,2599.1200000000003,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[40,"40-44",null,9034.91,6976.92,4992.6000000000004,3869,2938.8500000000004,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[45,"45-49",null,10497.18,8034.27,5634.43,4402.18,3417.44,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[50,"50-54",null,11500.470000000001,9034.380000000001,6566.17,4945.96,3753.9900000000002,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[55,"55-59",null,13591.320000000002,10424.57,7266.83,5727.71,4436.63,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[60,"60",null,15017.02,11544.460000000001,7990.2800000000007,6319.72,4909.3900000000003,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[61,"61",null,16894.280000000002,12991.890000000001,8990.3900000000012,7111.54,5528.96,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[62,"62",null,18783.73,14442.5,9997.3900000000012,7909.1900000000005,6144.8200000000006,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[63,"63",null,20666.29,15886.75,10995.91,8704.7200000000012,6765.4500000000007,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[64,"64",null,22545.670000000002,17338.95,12001.85,9496.5400000000009,7382.9000000000005,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[65,"65",null,24370.460000000003,18872.77,13081.460000000001,10344.01,8402.09,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[66,"66",null,25813.120000000003,19981,13853.67,10955.630000000001,8901.35,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[67,"67",null,28685.190000000002,22209.120000000003,15399.68,12176.220000000001,9890.33,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[68,"68",null,31555.670000000002,24430.880000000001,16938.8,13397.34,10887.26,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[69,"69",null,32996.21,25541.760000000002,17711.010000000002,14009.490000000002,11381.220000000001,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[70,"70",null,33420.21,25949.33,17977.07,14276.08,11530.68,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[71,"71",null,37598.200000000004,29199.82,20236.990000000002,16068.54,12977.050000000001,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[72,"72",null,41784.14,32445.54,{"$f":"$L$2*F294","v":22489.49},17853.580000000002,14418.650000000001,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[73,"73",null,45973.26,35696.03,24735.63,19639.68,15871.910000000002,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[74,"74",null,50151.780000000006,38948.11,26993.43,21428.960000000003,17312.98,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[75,"75+",null,54862.420000000006,43436.15,30961.54,23460.98,19869.170000000002,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[1,"1 Child",null,2501.0700000000002,1779.21,1311.75,1158.05,836.34,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[2,"2 Children",null,4070.4,2809,2061.17,1827.97,1229.0700000000002,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[3,"3+ Children",null,5952.43,4092.6600000000003,3006.69,2650.53,1865.0700000000002,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[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"]
[" "," ","AL1","AL2","AL3","AL4","AL5","AL6",null,2,6,10,14,18]
[18,"18-24",null,8195,6147,4356,3337,2635,null,"DW2","DW3","DW4","DW5","DW6"]
[25,"25-29",null,9114,6864,4856,3729,2929,null,0,0,0,0,0]
[30,"30-34",null,10556,8068,5795,4427,3406,null,0,0,0,0,0]
[35,"35-39",null,11710,8996,6448,5051,3783,null,0,0,0,0,0]
[40,"40-44",null,13219,10204,7311,5652,4283,null,0,0,0,0,0]
[45,"45-49",null,15360,11757,8247,6430,4987,null,0,0,0,0,0]
[50,"50-54",null,16839,13219,9609,7230,5477,null,0,0,0,0,0]
[55,"55-59",null,19906,15269,10635,8375,6478,null,0,0,0,0,0]
[60,"60",null,21993,16895,11699,9249,7176,null,0,0,0,0,0]
[61,"61",null,24751,19027,13172,10418,8093,null,0,0,0,0,0]
[62,"62",null,27524,21160,14649,11590,8990,null,0,0,0,0,0]
[63,"63",null,30280,23279,16127,12752,9899,null,0,0,0,0,0]
[64,"64",null,33060,25412,17599,13911,10812,null,0,0,0,0,0]
[65,"65",null,35725,27650,19190,15162,12314,null,0,0,0,0,0]
[66,"66",null,37841,29284,20320,16061,13038,null,0,0,0,0,0]
[67,"67",null,42057,32554,22591,17856,14499,null,0,0,0,0,0]
[68,"68",null,46270,35821,24852,19644,15957,null,0,0,0,0,0]
[69,"69",null,48386,37446,25990,20545,16688,null,0,0,0,0,0]
[70,"70",null,49007,38047,26381,20937,16911,null,0,0,0,0,0]
[71,"71",null,55146,42820,29690,23566,19030,null,0,0,0,0,0]
[72,"72",null,61287,47578,33008,26200,21152,null,0,0,0,0,0]
[73,"73",null,67434,52353,36312,28823,23282,null,0,0,0,0,0]
[74,"74",null,73565,57124,39619,31447,25406,null,0,0,0,0,0]
[75,"75+",null,80474,63708,45457,34432,29154,null,0,0,0,0,0]
[1,"1 Child",null,3672,2618,1920,1706,1234,null,0,0,0,0,0]
[2,"2 Children",null,5967,4131,3034,2693,1804,null,0,0,0,0,0]
[3,"3+ Children",null,8740,6017,4415,3907,2745,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","AL1","AL2","AL3","AL4","AL5","AL6"]
[18,"18-24",{"$f":"+C341*$L$2","v":0},{"$f":"$L$2*D341","v":4343.3500000000004},{"$f":"$L$2*E341","v":3257.9100000000003},2308.6800000000003,1768.6100000000001,1396.5500000000002,null,3,7,11,15,19]
[25,"25-29",0,{"$f":"$L$2*D342","v":4830.42},3637.92,2573.6800000000003,1976.3700000000001,1552.3700000000001,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[30,"30-34",0,5594.68,4276.04,3071.3500000000004,2346.31,1805.18,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[35,"35-39",0,6206.3,4767.88,3417.44,2677.03,2004.99,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[40,"40-44",0,7006.0700000000006,5408.12,3874.8300000000004,2995.56,2269.9900000000002,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[45,"45-49",0,8140.8,6231.21,4370.91,3407.9,2643.11,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[50,"50-54",0,8924.67,7006.0700000000006,5092.7700000000004,3831.9,2902.81,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[55,"55-59",0,10550.18,8092.5700000000006,5636.55,4438.75,3433.34,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[60,"60",0,11656.29,8954.35,6200.47,4901.97,3803.28,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[61,"61",0,13118.03,10084.310000000001,6981.1600000000008,5521.54,4289.29,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[62,"62",{"$f":"+C351*$L$2","v":0},14587.720000000001,11214.800000000001,7763.97,6142.7000000000007,4764.7,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[63,"63",0,16048.400000000001,12337.87,8547.3100000000013,6758.56,{"$f":"$L$2*H352","v":5246.47},null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[64,"64",0,17521.8,13468.36,9327.4700000000012,7372.83,5730.3600000000006,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[65,"65",0,18934.25,14654.5,10170.700000000001,8035.8600000000006,6526.42,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[66,"66",0,20055.73,15520.52,10769.6,8512.33,6910.14,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[67,"67",0,22290.210000000003,17253.620000000003,11973.230000000001,9463.68,7684.47,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[68,"68",0,24523.100000000002,18985.13,13171.560000000001,10411.32,8457.2100000000009,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[69,"69",0,25644.58,19846.38,13774.7,10888.85,8844.6400000000012,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[70,"70",0,25973.710000000003,20164.91,13981.93,11096.61,8962.83,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[71,"71",0,29227.38,22694.600000000002,15735.7,12489.980000000001,10085.9,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[72,"72",{"$f":"+C361*$L$2","v":0},32482.11,25216.34,17494.240000000002,13886,11210.560000000001,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[73,"73",0,35740.020000000004,27747.09,19245.36,15276.19,12339.460000000001,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[74,"74",0,38989.450000000004,30275.72,20998.07,16666.91,13465.18,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[75,"75+",0,42651.22,33765.240000000005,24092.210000000003,18248.96,15451.62,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[1,"1 Child",0,1946.16,1387.54,1017.6,904.18000000000006,654.02,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[2,"2 Children",0,3162.51,2189.4300000000003,1608.02,1427.29,956.12,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[3,"3+ Children",0,4632.2,3189.01,2339.9500000000003,2070.71,1454.8500000000001,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[1,"Rider Comp. Maternidad",0,0,0,0,0,0,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["SECURE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6",null,"DW2","DW3","DW4","DW5","DW6"]
[18,"18-24",null,8581,6732,4681,3947,3008,null,0,0,0,0,0]
[25,"25-29",null,9454,7579,5219,4407,3332,null,0,0,0,0,0]
[30,"30-34",null,10840,8913,6072,5117,3858,null,0,0,0,0,0]
[35,"35-39",null,11954,9984,6751,5675,4280,null,0,0,0,0,0]
[40,"40-44",null,13395,11381,7633,6432,4835,null,0,0,0,0,0]
[45,"45-49",null,15434,13338,8884,7467,5611,null,0,0,0,0,0]
[50,"50-54",null,16832,14689,9746,8199,6138,null,0,0,0,0,0]
[55,"55-59",null,19779,17549,11546,9711,7265,null,0,0,0,0,0]
[60,"60",null,20698,18736,12226,10280,7689,null,0,0,0,0,0]
[61,"61",null,23297,21092,13759,11571,8662,null,0,0,0,0,0]
[62,"62",null,25897,23454,15308,12872,9637,null,0,0,0,0,0]
[63,"63",null,28501,25809,16847,14168,10598,null,0,0,0,0,0]
[64,"64",null,31110,28167,18396,15470,11584,null,0,0,0,0,0]
[65,"65",null,31139,28427,18495,15545,11625,null,0,0,0,0,0]
[66,"66",null,31169,28690,18601,15630,11663,null,0,0,0,0,0]
[67,"67",null,34652,31892,20684,17375,12971,null,0,0,0,0,0]
[68,"68",null,38129,35104,22765,19119,14272,null,0,0,0,0,0]
[69,"69",null,39862,36694,23795,20002,14927,null,0,0,0,0,0]
[70,"70",null,39935,37307,24047,20184,15002,null,0,0,0,0,0]
[71,"71",null,44941,41973,27066,22724,16891,null,0,0,0,0,0]
[72,"72",null,49952,46659,30078,25253,18780,null,0,0,0,0,0]
[73,"73",null,54956,51330,33095,27795,20667,null,0,0,0,0,0]
[74,"74",null,59971,56009,36113,30332,22549,null,0,0,0,0,0]
[75,"75+",null,65351,61439,39494,33173,24642,null,0,0,0,0,0]
[1,"1 Child",null,4137,2441,1891,1583,1168,null,0,0,0,0,0]
[2,"2 Children",null,6987,3638,2976,2494,1862,null,0,0,0,0,0]
[3,"3+ Children",null,10263,5231,4319,3622,2688,null,0,0,0,0,0]
[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",null,3,7,11,15,19]
[18,"18-24",null,{"$f":"$L$2*D408","v":4547.93},{"$f":"$L$2*E408","v":3567.96},2480.9300000000003,2091.9100000000003,1594.24,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[25,"25-29",null,{"$f":"$L$2*D409","v":5010.62},4016.8700000000003,2766.07,2335.71,1765.96,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[30,"30-34",null,5745.2000000000007,4723.8900000000003,3218.1600000000003,2712.01,2044.74,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[35,"35-39",null,6335.62,5291.52,3578.03,3007.75,2268.4,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[40,"40-44",null,7099.35,6031.93,4045.4900000000002,3408.96,2562.5500000000002,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[45,"45-49",null,8180.02,7069.14,4708.5200000000004,3957.51,2973.83,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[50,"50-54",null,8920.9600000000009,7785.17,5165.38,4345.47,3253.1400000000003,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[55,"55-59",null,10482.870000000001,9300.9700000000012,6119.38,5146.83,3850.4500000000003,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[60,"60",null,10969.94,9930.08,6479.7800000000007,5448.4000000000005,4075.17,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[61,"61",null,12347.41,11178.76,7292.27,6132.63,4590.8600000000006,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[62,"62",null,13725.41,12430.62,8113.2400000000007,6822.1600000000008,5107.6100000000006,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[63,"63",null,15105.53,13678.77,8928.91,7509.04,5616.9400000000005,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[64,"64",null,16488.3,14928.51,9749.880000000001,8199.1,6139.52,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[65,"65",null,16503.670000000002,15066.310000000001,9802.35,8238.85,6161.25,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[66,"66",null,16519.57,15205.7,9858.5300000000007,8283.9,6181.39,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[67,"67",null,18365.560000000001,16902.760000000002,10962.52,9208.75,6874.63,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[68,"68",null,20208.370000000003,18605.120000000003,12065.45,10133.07,7564.1600000000008,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[69,"69",null,21126.86,19447.82,12611.35,10601.060000000001,7911.31,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[70,"70",null,21165.55,19772.710000000003,12744.91,10697.52,7951.06,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[71,"71",null,23818.73,22245.690000000002,14344.980000000001,12043.720000000001,8952.23,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[72,"72",null,26474.560000000001,24729.27,15941.34,13384.09,9953.4,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[73,"73",null,29126.68,{"$f":"$L$2*E429","v":27204.9},17540.350000000002,14731.35,10953.51,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[74,"74",null,31784.63,29684.77,19139.89,16075.960000000001,11950.970000000001,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[75,"75+",null,34636.03,32562.670000000002,20931.82,17581.690000000002,13060.26,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[1,"1 Child",null,2192.61,1293.73,1002.23,838.99,619.04000000000008,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[2,"2 Children",null,3703.11,1928.14,1577.28,1321.8200000000002,986.86,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[3,"3+ Children",null,5439.39,2772.4300000000003,2289.0700000000002,1919.66,{"$f":"$L$2*H434","v":1424.64},null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[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]
[]
["ESSENTIAL"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"ET2","ET3","ET4","ET5","ET6",null,"DW2","DW3","DW4","DW5","DW6"]
[18,"18-24",null,7086,5248,3873,3256,2467,null,0,0,0,0,0]
[25,"25-29",null,7820,5951,4319,3634,2748,null,0,0,0,0,0]
[30,"30-34",null,8951,7049,5014,4219,3185,null,0,0,0,0,0]
[35,"35-39",null,9872,7936,5571,4698,3528,null,0,0,0,0,0]
[40,"40-44",null,11080,9097,6302,5304,3989,null,0,0,0,0,0]
[45,"45-49",null,12751,10722,7347,6176,4632,null,0,0,0,0,0]
[50,"50-54",null,13920,11840,8054,6772,5077,null,0,0,0,0,0]
[55,"55-59",null,16371,14199,9554,8033,6010,null,0,0,0,0,0]
[60,"60",null,17128,15193,10119,8501,6354,null,0,0,0,0,0]
[61,"61",null,19283,17144,11389,9568,7163,null,0,0,0,0,0]
[62,"62",null,21438,19103,12672,10651,7964,null,0,0,0,0,0]
[63,"63",null,23593,21054,13942,11725,8763,null,0,0,0,0,0]
[64,"64",null,25747,22998,15229,12801,9581,null,0,0,0,0,0]
[65,"65",null,25777,23223,15315,12868,9620,null,0,0,0,0,0]
[66,"66",null,25804,23443,15399,12939,9644,null,0,0,0,0,0]
[67,"67",null,28687,26101,17126,14375,10732,null,0,0,0,0,0]
[68,"68",null,31566,28749,18840,15829,11809,null,0,0,0,0,0]
[69,"69",null,32997,30071,19709,16554,12349,null,0,0,0,0,0]
[70,"70",null,33075,30575,19914,16716,12424,null,0,0,0,0,0]
[71,"71",null,37209,34444,22415,18813,13975,null,0,0,0,0,0]
[72,"72",null,41356,38332,24911,20914,15547,null,0,0,0,0,0]
[73,"73",null,45519,42202,27406,23006,17107,null,0,0,0,0,0]
[74,"74",null,49664,46082,29911,25115,18673,null,0,0,0,0,0]
[75,"75+",null,54119,50574,32709,27466,20399,null,0,0,0,0,0]
[1,"1 Child",null,3425,2026,1573,1316,970,null,0,0,0,0,0]
[2,"2 Children",null,5788,3017,2464,2064,1548,null,0,0,0,0,0]
[3,"3+ Children",null,8496,4329,3587,3003,2222,null,0,0,0,0,0]
[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",null,3,7,11,15,19]
[18,"18-24",null,{"$f":"$L$2*D475","v":3755.5800000000004},{"$f":"$L$2*E475","v":2781.44},2052.69,1725.68,1307.51,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[25,"25-29",null,{"$f":"$L$2*D476","v":4144.6000000000004},3154.03,2289.0700000000002,1926.0200000000002,1456.44,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[30,"30-34",null,4744.0300000000007,3735.9700000000003,2657.42,2236.0700000000002,1688.0500000000002,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[35,"35-39",null,5232.16,4206.08,2952.63,2489.94,1869.8400000000001,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[40,"40-44",null,5872.4000000000005,4821.41,3340.06,2811.1200000000003,2114.17,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[45,"45-49",null,6758.0300000000007,5682.66,3893.9100000000003,3273.28,2454.96,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[50,"50-54",null,7377.6,6275.2000000000007,4268.62,3589.1600000000003,2690.81,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[55,"55-59",null,8676.630000000001,7525.47,5063.62,4257.49,3185.3,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[60,"60",null,9077.84,8052.29,5363.0700000000006,4505.5300000000007,3367.6200000000003,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[61,"61",null,10219.99,9086.32,6036.17,5071.04,3796.3900000000003,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[62,"62",null,11362.140000000001,10124.59,6716.1600000000008,5645.0300000000007,4220.92,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[63,"63",null,12504.29,11158.62,7389.26,6214.25,4644.3900000000003,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[64,"64",null,13645.91,12188.94,8071.3700000000008,6784.5300000000007,5077.93,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[65,"65",null,13661.810000000001,12308.19,8116.9500000000007,6820.04,5098.6000000000004,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[66,"66",null,13676.12,12424.79,8161.47,6857.67,5111.3200000000006,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[67,"67",null,15204.11,13833.53,9076.7800000000007,7618.75,5687.96,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[68,"68",null,16729.98,15236.970000000001,9985.2000000000007,8389.3700000000008,6258.77,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[69,"69",null,17488.41,15937.630000000001,10445.77,8773.6200000000008,6544.97,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[70,"70",null,17529.75,16204.75,10554.42,8859.48,6584.72,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[71,"71",null,19720.77,18255.32,11879.95,9970.8900000000012,7406.75,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[72,"72",null,21918.68,20315.960000000003,13202.83,11084.42,8239.91,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[73,"73",null,24125.07,22367.06,14525.18,12193.18,9066.7100000000009,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[74,"74",null,26321.920000000002,24423.460000000003,15852.83,13310.95,9896.69,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[75,"75+",null,28683.07,26804.22,17335.77,14556.980000000001,10811.470000000001,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[1,"1 Child",null,1815.25,1073.78,833.69,697.48,514.1,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[2,"2 Children",null,3067.6400000000003,1599.01,1305.92,1093.92,820.44,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[3,"3+ Children",null,4502.88,2294.37,1901.1100000000001,1591.5900000000001,1177.6600000000001,null," $                      -  "," $                      -  "," $                      -  "," $                      -  "," $                      -  "]
[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",4785,8728,12683,4161,7432,10691,3497,6330,9158,2676,4800,6920,1891,3333,4779,1048,1778,2501]
[50,"o más",6165,10101,14047,5354,8616,11874,4486,7308,10150,3432,5551,7670,2401,3832,5282,1294,2031,2744]
[]
["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":2536.0500000000002},{"$f":"+D543*$L$2","v":4625.84},6721.9900000000007,2205.33,3938.96,5666.2300000000005,1853.41,3354.9,4853.7400000000007,1418.28,2544,3667.6000000000004,1002.23,1766.49,2532.8700000000003,555.44000000000005,942.34,1325.53]
[75,"o más",{"$f":"+C544*$L$2","v":3267.4500000000003},5353.5300000000007,7444.9100000000008,2837.6200000000003,4566.4800000000005,6293.22,2377.58,3873.2400000000002,5379.5,1818.96,2942.03,4065.1000000000004,1272.53,2030.96,2799.46,685.82,1076.43,1454.3200000000002]

{"sheet":"Sheet1","index":11,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[null,"Deductible",2000,null,3500,null,5000,null,10000,null,20000,null,50000]
[null,null,"Annual","Semi-Annual","Annual","Semi-Annual","Annual","Semi-Annual","Annual","Semi-Annual","Annual","Semi-Annual","Annual","Semi-Annual"]
[null,"Under 50"]
[null,"0 1 Member",4785,2536.0500000000002,4161,2205.33,3497,1853.41,2676,1418.28,1891,1002.23,1048,555.44000000000005]
[null,"0 2 Members",8728,4625.84,7432,3938.96,6330,3354.9,4800,2544,3333,1766.49,1778,942.34]
[null,"0 3+ Members",12683,6721.9900000000007,10691,5666.2300000000005,9158,4853.7400000000007,6920,3667.6000000000004,4779,2532.8700000000003,2501,1325.53]
[null,""]
[null,"Over 50"]
[null,"50 1 Member",6165,3267.4500000000003,5354,2837.6200000000003,4486,2377.58,3432,1818.96,2401,1272.53,1294,685.82]
[null,"50 2 Members",10101,5353.5300000000007,8616,4566.4800000000005,7308,3873.2400000000002,5551,2942.03,3832,2030.96,2031,1076.43]
[null,"50 3+ Members",14047,7444.9100000000008,11874,6293.22,10150,5379.5,7670,4065.1000000000004,5282,2799.46,2744,1454.3200000000002]