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

{"sheet":"INGRESO DE DATOS","index":0,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,0,7,9],[11,3,11,9],[20,3,20,9]]}
[]
[null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null," "," "," "," "]
[]
["COTIZACION DE SEGURO MEDICO INTERNACIONAL"]
[]
["1. INGRESE LOS DATOS DEL PROPUESTO ASEGURADO:"]
[]
[null,null,"Nombre del Asegurado principal:","NOMBRE COMPLETO"]
[]
[null,null,null,null,null,"Número de adultos en la póliza: ",2,null,"Número de hijos en la póliza:",5]
[]
[null,null,null,null,null," Edad del titular:",50,null,"Edad de cónyuge:",55]
[]
[]
["2. INGRESE EL NOMBRE DE LA AGENCIA ASESORA:"]
[]
[null,null,"Nombre de la Agencia :","AGENCIA"]
[]
[]
["3. ESCOJA EL PRODUCTO PARA VISUALIZAR LA COTIZACION RESPECTIVA:"]

{"sheet":"Exclusive","index":1,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[47,0,47,1],[47,2,47,3],[35,0,35,1],[36,0,38,1],[36,2,38,3],[46,0,46,1],[45,0,45,1],[40,0,40,1],[41,0,41,1],[45,2,45,3],[43,0,43,1],[44,0,44,1],[42,0,42,1],[19,0,19,1],[26,0,26,1],[21,2,21,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[25,0,25,1],[26,2,26,3],[9,2,9,12],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[23,2,23,3],[30,2,30,3],[46,2,46,3],[17,2,18,3],[29,2,29,3],[24,2,24,3],[19,2,19,3],[20,2,20,3],[22,2,22,3],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[12,0,12,1],[17,0,18,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[27,0,27,1],[20,0,21,1],[28,0,28,1],[31,2,31,3],[27,2,27,3],[29,0,29,1],[30,0,31,1],[28,2,28,3],[32,0,32,1],[33,0,33,1],[32,2,32,3],[44,2,44,3],[39,0,39,1],[34,2,34,3],[33,2,33,3],[41,2,41,3],[42,2,42,3],[39,2,39,3],[43,2,43,3],[40,2,40,3],[35,2,35,3],[34,0,34,1],[51,0,51,1],[51,2,51,3],[50,0,50,1],[50,2,50,3],[49,5,50,12],[48,0,49,1],[48,2,49,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa EXCLUSIVE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:00.180"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null," ",false]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,4,TRUE)","v":40486},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":28113},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":19652},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":15868},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":12505}]
[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":43082},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,5,TRUE)))","v":29915},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,6,TRUE)))","v":20911},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,7,TRUE)))","v":16891},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,8,TRUE)))","v":13315}]
[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":16193},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":11945},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":9101},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":7597},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":5911}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$33)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":99761},{"$f":"SUM(J31:J34)","v":69973},{"$f":"SUM(K31:K34)","v":49664},{"$f":"SUM(L31:L34)","v":40356},{"$f":"SUM(M31:M34)","v":31731}]
[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":99836},{"$f":"SUM(J35:J36)","v":70048},{"$f":"SUM(K35:K36)","v":49739},{"$f":"SUM(L35:L36)","v":40431},{"$f":"SUM(M35:M36)","v":31806}]
[]
[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":21457.58},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":14899.890000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":10415.560000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":8410.0400000000009},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":6627.6500000000005}]
[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":22833.460000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,5,TRUE)))","v":15854.95},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,6,TRUE)))","v":11082.83},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,7,TRUE)))","v":8952.23},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,8,TRUE)))","v":7056.9500000000007}]
[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":8582.2900000000009},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":6330.85},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":4823.5300000000007},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":4026.4100000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":3132.8300000000004}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$66)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":52873.330000000009},{"$f":"SUM(J40:J43)","v":37085.69},{"$f":"SUM(K40:K43)","v":26321.919999999998},{"$f":"SUM(L40:L43)","v":21388.68},{"$f":"SUM(M40:M43)","v":16817.430000000004}]
[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":52948.330000000009},{"$f":"SUM(J44:J45)","v":37160.69},{"$f":"SUM(K44:K45)","v":26396.92},{"$f":"SUM(L44:L45)","v":21463.68},{"$f":"SUM(M44:M45)","v":16892.430000000004}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":52873.330000000009},{"$f":"J44","v":37085.69},26321.919999999998,21388.68,16817.430000000004]
[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":[[34,2,34,3],[39,0,39,1],[40,0,40,1],[41,0,41,1],[36,0,36,1],[25,0,25,1],[32,2,32,3],[26,0,26,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,2,29,3],[32,0,32,1],[29,0,29,1],[27,2,27,3],[28,2,28,3],[46,0,47,1],[33,0,33,1],[34,0,34,1],[37,0,37,1],[38,0,38,1],[45,0,45,1],[9,2,9,12],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,18,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[21,2,21,3],[46,2,47,3],[11,7,11,12],[11,0,11,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[45,2,45,3],[35,0,35,1],[35,2,35,3],[42,2,42,3],[36,2,36,3],[43,0,43,1],[43,2,43,3],[39,2,39,3],[40,2,40,3],[37,2,37,3],[38,2,38,3],[41,2,41,3],[42,0,42,1],[13,7,13,12],[17,5,17,6],[16,5,16,6],[16,0,16,1],[44,0,44,1],[44,2,44,3],[19,0,19,1],[17,0,18,1],[20,0,21,1],[22,2,22,3],[31,2,31,3],[26,2,26,3],[20,2,20,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[49,0,49,1],[49,2,49,3],[48,0,48,1],[48,2,48,3],[49,5,50,12]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa PRIVILEGE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:00.180"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null," ",false]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,4,TRUE)","v":34833},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":24728},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":17247},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":14086},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":10765}]
[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":37067},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,5,TRUE)))","v":26314},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,6,TRUE)))","v":18348},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,7,TRUE)))","v":14989},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,8,TRUE)))","v":11461}]
[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":13582},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":9928},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":7190},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":5993},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":4449}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$167)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$167)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$167)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$167)","v":225}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":85482},{"$f":"SUM(J31:J34)","v":60970},{"$f":"SUM(K31:K34)","v":43010},{"$f":"SUM(L31:L34)","v":35293},{"$f":"SUM(M31:M34)","v":26900}]
[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":85557},{"$f":"SUM(J35:J36)","v":61045},{"$f":"SUM(K35:K36)","v":43085},{"$f":"SUM(L35:L36)","v":35368},{"$f":"SUM(M35:M36)","v":26975}]
[]
[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":18461.490000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":13105.84},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":9140.91},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":7465.58},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":5705.4500000000007}]
[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":19645.510000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,5,TRUE)))","v":13946.42},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,6,TRUE)))","v":9724.44},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,7,TRUE)))","v":7944.17},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,8,TRUE)))","v":6074.33}]
[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":7198.46},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":5261.84},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":3810.7000000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":3176.29},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":2357.9700000000003}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$200)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$200)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$200)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$200)","v":119.25}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":45305.46},{"$f":"SUM(J40:J43)","v":32314.100000000002},{"$f":"SUM(K40:K43)","v":22795.3},{"$f":"SUM(L40:L43)","v":18705.29},{"$f":"SUM(M40:M43)","v":14257}]
[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":45380.46},{"$f":"SUM(J44:J45)","v":32389.100000000002},{"$f":"SUM(K44:K45)","v":22870.3},{"$f":"SUM(L44:L45)","v":18780.29},{"$f":"SUM(M44:M45)","v":14332}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":45305.46},{"$f":"J44","v":32314.100000000002},22795.3,18705.29,14257]
[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":[[35,0,41,1],[48,2,48,3],[47,2,47,3],[44,0,44,1],[46,0,46,1],[45,2,45,3],[45,0,45,1],[26,0,26,1],[26,2,26,3],[27,2,27,3],[33,0,33,1],[34,0,34,1],[32,2,32,3],[32,0,32,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[19,0,19,1],[24,2,24,3],[51,0,52,1],[28,2,28,3],[29,2,29,3],[30,2,30,3],[33,2,33,3],[31,2,31,3],[49,0,49,1],[50,0,50,1],[47,0,47,1],[48,0,48,1],[42,0,42,1],[42,2,42,3],[29,0,29,1],[34,2,34,3],[9,2,9,12],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,18,3],[49,2,49,3],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[22,2,22,3],[20,2,20,3],[51,5,52,12],[50,2,50,3],[46,2,46,3],[44,2,44,3],[51,2,52,3],[25,2,25,3],[23,2,23,3],[54,0,54,1],[54,2,54,3],[53,0,53,1],[53,2,53,3],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[35,2,39,3],[40,2,41,3],[20,0,21,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[19,2,19,3],[21,2,21,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:00.180"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,4,TRUE)","v":23113},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":18149},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":13192},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":9759},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":7405}]
[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":27316},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,5,TRUE)))","v":20952},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,6,TRUE)))","v":14591},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,7,TRUE)))","v":11309},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,8,TRUE)))","v":8752}]
[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":11960},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":8212},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":6044},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":5249},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":3690}]
[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":62914},47838,34352,26842,20372]
[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":62989},{"$f":"SUM(J36:J37)","v":47913},{"$f":"SUM(K36:K37)","v":34427},{"$f":"SUM(L36:L37)","v":26917},{"$f":"SUM(M36:M37)","v":20447}]
[]
[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":12249.890000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":9618.9700000000012},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":6991.76},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":5172.2700000000004},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":3924.65}]
[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":14477.480000000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,5,TRUE)))","v":11104.560000000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,6,TRUE)))","v":7733.2300000000005},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,7,TRUE)))","v":5993.77},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,8,TRUE)))","v":4638.5600000000004}]
[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":6338.8},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":4352.3600000000006},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":3203.32},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":2781.9700000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":1955.7}]
[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":33344.420000000006},25354.140000000003,18206.560000000001,14226.260000000002,10797.160000000002]
[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":33419.420000000006},{"$f":"SUM(J46:J47)","v":25429.140000000003},{"$f":"SUM(K46:K47)","v":18281.560000000001},{"$f":"SUM(L46:L47)","v":14301.260000000002},{"$f":"SUM(M46:M47)","v":10872.160000000002}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":33344.420000000006},{"$f":"J46","v":25354.140000000003},18206.560000000001,14226.260000000002,10797.160000000002]
[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":true,"merged":[[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
["Bupa Advantage Care (cobertura solo en Latinoamérica)",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
["Cobertura Máxima anual",null,"US $ 3,500,000"]
["Cobertura Geografica",null,"Limitada a Latinoamérica excluyendo México",null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
["Condiciones médicas cubiertas",null,"Todas las condiciones médicas"]
["Redes de proveedores",null,"Red de Proveedores \"Bupa Advantage\"",null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
["Opciones fuera de la Red",null,"NO, solo en casos de emergencia",null,null,"FECHA DE COTIZACION :"]
["Requiere preautorización",null,"SI, 30% de penalización por omitir prenotificación",null,null,{"$f":"NOW()","v":"2023-08-16T10:35:00.180"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[null,null,null,null,null,null,null,null,null," "," "," "]
["Número máximo de días de hospitalización",null,"Ilimitado",null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
["Habitación y alimentación",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
["Cuidados Intensivos",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null," "]
["Cobertura de Maternidad",null,"$5,000 (Excepto planes 4,5, y 6)",null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Cobertura Provisional de Recién Nacido",null,"$30,000 por los primeros 90 días",null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Cuidado del Recién Nacido saludable",null,"Ya incluída dentro del beneficio de Maternidad",null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
["Cobertura de Complicaciones de Maternidad",null,"Disponible a través de cobertura opcional adicional"]
["Trasplante de Organos",null,"$1,000,000 de por vida, por diagnóstico"]
["Condiciones congénitas y hereditarias",null,"<18 años $300,000 de por vida; >=18 al 100%",null,null,"Tarifas Anuales"]
["Coberturas opcionales (Riders)",null,"Complicaciones de Maternidad por $500,000",null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,4,TRUE)","v":23095},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":18131},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":13196},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":9747},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":7397}]
[null,null,"Trasplante de órganos por $ 300,000 adicionales",null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,4,TRUE)))","v":27290},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,5,TRUE)))","v":20932},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,6,TRUE)))","v":14596},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,7,TRUE)))","v":11305},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,8,TRUE)))","v":8747}]
["Acompañamiento de menores hospitalizados",null,"$300 por día",null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,4,TRUE)))","v":11967},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":8220},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":6057},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":5241},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":3690}]
["Ambulancia aérea",null,"$100,000 por año y ticket aéreo de retorno",null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$368)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$368)","v":0}]
["Repatriación restos mortales",null,1,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$369)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$369)","v":0}]
["Medicamentos por receta",null,"$6,000 por Asegurado, por año póliza",null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":62352},47283,33849,26293,19834]
["Almacenamiento de sangre de cordon umbilical",null,"$500  (Excepto planes 4,5, y 6)",null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL :",null,"n/a",{"$f":"SUM(I36:I37)","v":62427},{"$f":"SUM(J36:J37)","v":47358},{"$f":"SUM(K36:K37)","v":33924},{"$f":"SUM(L36:L37)","v":26368},{"$f":"SUM(M36:M37)","v":19909}]
["Atención médica en el hogar",null,"100% de usual/acostumbrado y razonable"]
["Rehabilitación",null,"100% de usual/acostumbrado y razonable",null,null,"Tarifas Semestrales"]
["Residencia y cuidados paliativos",null,"100% de usual/acostumbrado y razonable",null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,4,TRUE)","v":12240.35},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":9609.43},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":6993.88},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":5165.91},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":3920.4100000000003}]
["Cobertura de actividades peligrosas",null,1,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,4,TRUE)))","v":14463.7},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,5,TRUE)))","v":11093.960000000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,6,TRUE)))","v":7735.88},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,7,TRUE)))","v":5991.6500000000005},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,8,TRUE)))","v":4635.91}]
["Chequeos generales de rutina",null,"Hasta US$150 por año póliza.Sin deducible",null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,4,TRUE)))","v":6342.51},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":4356.6000000000004},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":3210.21},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":2777.73},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":1955.7}]
["Cobertura de VIH, SIDA, CAS",null,"Solo como efecto de transfusión de sangre",null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$401)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$401)","v":0}]
["Cobertura de brazos y piernas artificiales",null,"$30,000 por año y hasta $120,000 de por vida",null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$402)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$402)","v":0}]
["Cobertura extendida para dependientes en caso de muerte de asegurado principal",null,"2 años sin costo",null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":33046.560000000005},25059.989999999998,17939.97,13935.29,10512.02]
[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":33121.560000000005},{"$f":"SUM(J46:J47)","v":25134.989999999998},{"$f":"SUM(K46:K47)","v":18014.97},{"$f":"SUM(L46:L47)","v":14010.29},{"$f":"SUM(M46:M47)","v":10587.02}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":33046.560000000005},{"$f":"J46","v":25059.989999999998},17939.97,13935.29,10512.02]
[null," ",null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2013"]

{"sheet":"Secure","index":5,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[33,2,33,3],[31,2,31,3],[47,0,48,1],[47,2,48,3],[45,2,45,3],[46,0,46,1],[45,0,45,1],[33,0,33,1],[34,0,34,1],[35,0,41,1],[44,0,44,1],[34,2,34,3],[40,2,41,3],[43,2,43,3],[44,2,44,3],[42,2,42,3],[42,0,42,1],[43,0,43,1],[35,2,39,3],[49,5,49,12],[46,2,46,3],[49,0,49,1],[49,2,49,3],[16,0,16,1],[19,0,19,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,0,29,1],[26,0,26,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[20,0,21,1],[15,0,15,1],[20,2,20,3],[17,2,18,3],[32,0,32,1],[32,2,32,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,2,22,3],[21,2,21,3],[25,2,25,3],[51,5,53,12],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa SECURE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:00.180"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,4,TRUE)","v":17040},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":14871},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":10199},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":8728},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":6541}]
[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":20026},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,5,TRUE)))","v":17754},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,6,TRUE)))","v":12083},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,7,TRUE)))","v":10335},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,8,TRUE)))","v":7728}]
[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":10391},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":5294},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":4527},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":3865},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":2860}]
[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":47982},38444,27334,23453,17654]
[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":48057},{"$f":"SUM(J36:J37)","v":38519},{"$f":"SUM(K36:K37)","v":27409},{"$f":"SUM(L36:L37)","v":23528},{"$f":"SUM(M36:M37)","v":17729}]
[]
[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":9031.2000000000007},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":7881.63},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":5405.47},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":4625.84},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":3466.73}]
[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":10613.78},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,5,TRUE)))","v":9409.6200000000008},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,6,TRUE)))","v":6403.9900000000007},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,7,TRUE)))","v":5477.55},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,8,TRUE)))","v":4095.84}]
[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":5507.2300000000005},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":2805.82},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":2399.31},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":2048.4500000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":1515.8000000000002}]
[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":25430.460000000003},20375.32,14487.02,12430.09,9356.619999999999]
[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":25505.460000000003},{"$f":"SUM(J46:J47)","v":20450.32},{"$f":"SUM(K46:K47)","v":14562.02},{"$f":"SUM(L46:L47)","v":12505.09},{"$f":"SUM(M46:M47)","v":9431.619999999999}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":25430.460000000003},{"$f":"J46","v":20375.32},14487.02,12430.09,9356.619999999999]
[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":[[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[20,0,21,1],[16,2,16,3],[20,2,20,3],[17,2,18,3],[23,2,23,3],[19,2,19,3],[22,0,23,1],[49,2,49,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[24,0,24,1],[35,2,39,3],[33,0,33,1],[34,0,34,1],[35,0,41,1],[40,2,41,3],[29,2,29,3],[30,2,30,3],[33,2,33,3],[27,2,27,3],[24,2,24,3],[51,5,53,12],[42,0,42,1],[34,2,34,3],[47,2,48,3],[47,0,48,1],[45,2,45,3],[46,2,46,3],[43,2,43,3],[45,0,45,1],[46,0,46,1],[43,0,43,1],[44,0,44,1],[44,2,44,3],[49,5,49,12],[42,2,42,3],[49,0,49,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa ESSENTIAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:00.180"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,4,TRUE)","v":14093},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":12304},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":8428},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":7210},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":5408}]
[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":16571},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,5,TRUE)))","v":14694},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,6,TRUE)))","v":9995},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,7,TRUE)))","v":8558},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,8,TRUE)))","v":6393}]
[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":8610},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":4386},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":3753},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":3202},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":2368}]
[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":39799},31909,22701,19495,14694]
[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":39874},{"$f":"SUM(J36:J37)","v":31984},{"$f":"SUM(K36:K37)","v":22776},{"$f":"SUM(L36:L37)","v":19570},{"$f":"SUM(M36:M37)","v":14769}]
[]
[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":7469.29},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":6521.12},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":4466.84},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":3821.3},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":2866.2400000000002}]
[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":8782.630000000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,5,TRUE)))","v":7787.8200000000006},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,6,TRUE)))","v":5297.35},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,7,TRUE)))","v":4535.74},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,8,TRUE)))","v":3388.29}]
[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":4563.3},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":2324.58},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":1989.0900000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":1697.0600000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":1255.04}]
[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":21093.47},16911.77,12031.53,10332.35,7787.8200000000006]
[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":21168.47},{"$f":"SUM(J46:J47)","v":16986.77},{"$f":"SUM(K46:K47)","v":12106.53},{"$f":"SUM(L46:L47)","v":10407.35},{"$f":"SUM(M46:M47)","v":7862.8200000000006}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":21093.47},{"$f":"J46","v":16911.77},12031.53,10332.35,7787.8200000000006]
[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":[[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[29,8,29,9],[30,8,30,9],[45,0,45,1],[23,5,24,7],[25,5,26,7],[27,5,28,7],[29,5,30,7],[31,5,32,7],[33,5,34,7],[35,5,36,7],[44,2,44,3],[26,0,26,1],[43,2,43,3],[40,0,40,1],[41,0,41,1],[42,0,42,1],[42,2,42,3],[40,2,40,3],[19,0,19,1],[41,2,41,3],[44,0,44,1],[32,0,32,1],[35,0,39,1],[33,0,33,1],[34,0,34,1],[43,0,43,1],[22,0,23,1],[24,0,24,1],[30,2,31,3],[27,0,27,1],[28,0,28,1],[34,2,34,3],[29,0,29,1],[30,0,31,1],[25,0,25,1],[25,2,25,3],[23,2,23,3],[24,2,24,3],[27,2,27,3],[21,5,22,7],[21,8,22,9],[20,0,21,1],[21,2,21,3],[22,2,22,3],[45,2,45,3],[23,10,24,11],[33,10,36,12],[28,2,28,3],[29,2,29,3],[32,2,32,3],[33,2,33,3],[35,8,35,9],[36,8,36,9],[25,10,25,11],[26,10,26,11],[27,10,27,11],[32,10,32,11],[31,8,31,9],[32,8,32,9],[33,8,33,9],[9,2,9,12],[26,2,26,3],[17,2,18,3],[19,2,19,3],[20,2,20,3],[16,2,16,3],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[21,10,22,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[52,5,54,12],[17,0,18,1],[12,0,12,1],[14,0,14,1],[13,0,13,1],[15,0,15,1],[16,0,16,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[35,2,39,3],[34,8,34,9],[27,8,27,9],[28,8,28,9]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa CRITICAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:35:00.180"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,null,true,null,null,{"$f":"IF(M16>=M18,M16,M18)","v":55}]
[]
[null,null,null,null,null,"CONDICION CRITICA CUBIERTA",null,null,"MAXIMO POR AÑO POLIZA",null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,"Enfermedades neurológicas y accidentes cerebro-vasculares",null,null,150000,null,"Tipo de trasplante",null,"Máximo Vitalicio"]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,null,null,"por persona"]
[null,null,null,null,null,"Cirugías cardíacas y angioplastías",null,null,150000,null,"Corazón",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Corazón y Pulmón (simultáneamente)",null,300000]
[null,null,null,null,null,"Tratamiento de cáncer",null,null,200000,null,"Pulmón",null,250000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Pancreas",null,250000]
[null,null,null,null,null,"Trauma grave (Politraumatismos)",null,null,150000,null,"Pancreas y Riñón (simultáneamente)",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Riñón",null,200000]
[null,null,null,null,null,"Insuficiencia renal crónica (Diálisis)",null,null,100000,null,"Hígado",null,200000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Médula ósea",null,250000]
[null,null,null,null,null,"Quemaduras graves ",null,null,300000,null,"La cobertura de trasplante de órganos está limitada a la Red de Proveedores para Procedimiento de Trasplante de la Compañía y no se proporcionará cobertura en proveedores fuera de esta Red especializada."]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[null,null,null,null,null,"Desorden infeccioso grave (Septicemia)",null,null,150000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[null,null,null,null,null,"Fuera del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima por plan individual :",null,{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,3,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,6,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,9,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,12,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,15,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$Q$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:$Q$544,4,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,7,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,10,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,13,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,16,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$Q$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:$Q$544,5,TRUE)),0)","v":11616},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,8,TRUE)),0)","v":9022},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,11,TRUE)),0)","v":7744},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,14,TRUE)),0)","v":5920},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,17,TRUE)),0)","v":4178},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$Q$544,20,TRUE)),0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":11616},{"$f":"SUM(I44:I46)","v":9022},7744,5920,4178,{"$error":"#REF!"}]
[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":11691},9097,7819,5995,4253,{"$error":"#REF!"}]
[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":[[11,2,11,7],[37,0,37,7],[28,0,28,1],[21,0,21,1],[26,0,26,1],[29,0,29,1],[30,0,30,1],[36,0,36,1],[27,0,27,1],[25,0,25,1],[25,2,25,7],[32,0,32,1],[35,2,35,7],[39,0,41,7],[13,2,13,7],[15,2,15,7],[19,0,19,1],[18,0,18,1]]}
[]
[null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null," "," "," "," "]
[]
[]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - BUPA CARE "]
[]
[null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":50}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2023-08-16T10:35:00.180"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":5},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":55}]
[null,null,null,null," "," "," "]
["Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
["PRODUCTOS",null,"Tarifas Anuales"]
["Bupa Exclusive Care",null,"n/a",{"$f":"+Exclusive!I37","v":99836},{"$f":"+Exclusive!J37","v":70048},{"$f":"+Exclusive!K37","v":49739},{"$f":"+Exclusive!L37","v":40431},{"$f":"+Exclusive!M37","v":31806}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":85557},{"$f":"+Privilege!J37","v":61045},{"$f":"+Privilege!K37","v":43085},{"$f":"+Privilege!L37","v":35368},{"$f":"+Privilege!M37","v":26975}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":62989},{"$f":"+'Advantage (Mundial)'!J38","v":47913},{"$f":"+'Advantage (Mundial)'!K38","v":34427},{"$f":"+'Advantage (Mundial)'!L38","v":26917},{"$f":"+'Advantage (Mundial)'!M38","v":20447}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":48057},{"$f":"+Secure!J38","v":38519},{"$f":"+Secure!K38","v":27409},{"$f":"+Secure!L38","v":23528},{"$f":"+Secure!M38","v":17729}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":39874},{"$f":"+Essential!J38","v":31984},{"$f":"+Essential!K38","v":22776},{"$f":"+Essential!L38","v":19570},{"$f":"+Essential!M38","v":14769}]
[]
["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":11691},{"$f":"+Critical!I49","v":9097},{"$f":"+Critical!J49","v":7819},{"$f":"+Critical!K49","v":5995},{"$f":"+Critical!L49","v":4253},{"$f":"+Critical!M49","v":{"$error":"#REF!"}}]
["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":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,4,7],[25,5,26,5],[25,6,26,6],[27,0,28,0],[29,0,30,0],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[86,0,87,0],[89,0,91,0],[9,0,11,0],[13,0,14,0],[15,0,16,0],[37,0,41,0],[24,0,26,0],[31,0,33,0],[31,7,33,7],[39,5,41,5],[39,6,41,6],[38,7,41,7],[17,0,19,0],[32,6,33,6],[25,2,26,2],[25,3,26,3],[25,4,26,4],[31,2,33,2],[31,3,33,3],[32,4,33,4],[32,5,33,5]]}
["2023 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":551,"n_cols":17,"rows_kept":551,"cut":false,"hidden":true,"merged":[[540,14,540,16],[547,14,547,16],[545,0,545,16],[540,2,540,4],[547,2,547,4],[547,5,547,7],[547,8,547,10],[546,0,546,1],[546,2,546,6],[540,5,540,7],[540,8,540,10],[547,11,547,13],[540,11,540,13],[539,0,539,1],[471,0,471,7],[472,0,472,1],[472,2,472,6],[504,0,504,7],[505,0,505,1],[505,2,505,6],[538,0,538,16],[537,0,537,16],[539,2,539,6],[304,2,304,6],[336,0,336,7],[437,0,437,7],[438,0,438,1],[438,2,438,6],[304,0,304,1],[370,0,370,7],[371,0,371,1],[371,2,371,6],[337,0,337,7],[338,0,338,1],[338,2,338,6],[470,0,470,7],[403,0,403,7],[404,0,404,7],[405,0,405,1],[405,2,405,6],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[303,0,303,7],[269,0,269,7],[270,0,270,7],[271,0,271,1],[271,2,271,6],[170,2,170,6],[202,0,202,7],[236,0,236,7],[237,0,237,1],[237,2,237,6],[204,0,204,1],[204,2,204,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6]]}
[]
["EXCLUSIVE",null,null,null,null,null,null,null,null,"FACTOR SEMESTRAL :",null,0.53]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6",null,2,6,10,14,18]
[18,"18-24",null,19965,13185,8718,6125,4814,null,0,0,0,0,0]
[25,"25-29",null,20940,14572,9655,6792,5334,null,0,0,0,0,0]
[30,"30-34",null,21790,15636,10819,8141,6415,null,0,0,0,0,0]
[35,"35-39",null,24398,17502,12135,9131,7187,null,0,0,0,0,0]
[40,"40-44",null,28288,19152,13465,10046,7902,null,0,0,0,0,0]
[45,"45-49",null,31632,21417,15053,11232,8843,null,0,0,0,0,0]
[50,"50-54",null,40486,28113,19652,15868,12505,null,0,0,0,0,0]
[55,"55-59",null,43082,29915,20911,16891,13315,null,0,0,0,0,0]
[60,"60",null,46936,32645,24069,20355,16547,null,0,0,0,0,0]
[61,"61",null,50427,35072,25850,21883,17783,null,0,0,0,0,0]
[62,"62",null,55211,38418,28311,23950,19476,null,0,0,0,0,0]
[63,"63",null,58707,40844,30099,25476,20708,null,0,0,0,0,0]
[64,"64",null,63513,44201,32571,27561,22416,null,0,0,0,0,0]
[65,"65",null,83034,57657,41193,36767,31620,null,0,0,0,0,0]
[66,"66",null,96467,67010,47873,42741,36743,null,0,0,0,0,0]
[67,"67",null,105370,73186,52294,46671,40139,null,0,0,0,0,0]
[68,"68",null,116679,81039,57900,51695,44452,null,0,0,0,0,0]
[69,"69",null,128381,89160,63712,56874,48918,null,0,0,0,0,0]
[70,"70",null,158016,108580,75013,66291,57541,null,0,0,0,0,0]
[71,"71",null,164217,112839,77957,68894,59805,null,0,0,0,0,0]
[72,"72",null,168872,116034,80156,70838,61500,null,0,0,0,0,0]
[73,"73",null,175073,120305,83099,73456,63765,null,0,0,0,0,0]
[74,"74",null,178175,122426,84585,74752,64887,null,0,0,0,0,0]
[75,"75+",null,185937,127756,88256,78010,67715,null,0,0,0,0,0]
[1,"1 Child",null,6945,5115,3907,3266,2546,null,0,0,0,0,0]
[2,"2 Children",null,11045,8147,6216,5185,4031,null,0,0,0,0,0]
[3,"3+ Children",null,16193,11945,9101,7597,5911,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":10581.45},{"$f":"$L$2*E6","v":6988.05},4620.54,3246.25,2551.42,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D7","v":11098.2},7723.1600000000008,5117.1500000000005,3599.76,2827.02,null,0,0,0,0,0]
[30,"30-34",null,11548.7,8287.08,5734.0700000000006,4314.7300000000005,3399.9500000000003,null,0,0,0,0,0]
[35,"35-39",null,12930.94,9276.0600000000013,6431.55,4839.43,3809.11,null,0,0,0,0,0]
[40,"40-44",null,14992.640000000001,10150.560000000001,7136.4500000000007,5324.38,4188.0600000000004,null,0,0,0,0,0]
[45,"45-49",null,16764.96,11351.01,7978.09,5952.96,4686.79,null,0,0,0,0,0]
[50,"50-54",null,21457.58,14899.890000000001,10415.560000000001,8410.0400000000009,6627.6500000000005,null,0,0,0,0,0]
[55,"55-59",null,22833.460000000003,15854.95,11082.83,8952.23,7056.9500000000007,null,0,0,0,0,0]
[60,"60",null,24876.080000000002,17301.850000000002,12756.570000000002,10788.15,8769.91,null,0,0,0,0,0]
[61,"61",null,26726.31,18588.16,13700.5,11597.99,9424.99,null,0,0,0,0,0]
[62,"62",null,29261.83,20361.54,15004.83,12693.5,10322.280000000001,null,0,0,0,0,0]
[63,"63",null,31114.710000000003,21647.32,15952.470000000001,{"$f":"$L$2*G17","v":13502.28},10975.24,null,0,0,0,0,0]
[64,"64",null,33661.89,23426.530000000002,17262.63,14607.33,11880.480000000001,null,0,0,0,0,0]
[65,"65",null,44008.020000000004,30558.210000000003,21832.29,19486.510000000002,16758.600000000002,null,0,0,0,0,0]
[66,"66",null,51127.51,35515.300000000003,25372.690000000002,22652.73,19473.79,null,0,0,0,0,0]
[67,"67",null,55846.100000000006,38788.58,27715.82,24735.63,21273.670000000002,null,0,0,0,0,0]
[68,"68",null,61839.87,42950.670000000006,30687,27398.350000000002,23559.56,null,0,0,0,0,0]
[69,"69",null,68041.930000000008,47254.8,33767.360000000001,30143.22,25926.54,null,0,0,0,0,0]
[70,"70",null,83748.48000000001,57547.4,39756.89,35134.230000000003,30496.730000000003,null,0,0,0,0,0]
[71,"71",null,87035.010000000009,59804.670000000006,41317.21,36513.82,31696.65,null,0,0,0,0,0]
[72,"72",null,89502.16,61498.020000000004,42482.68,37544.14,32595,null,0,0,0,0,0]
[73,"73",null,92788.69,63761.65,44042.47,38931.68,33795.450000000004,null,0,0,0,0,0]
[74,"74",null,94432.75,64885.780000000006,44830.05,39618.560000000005,34390.11,null,0,0,0,0,0]
[75,"75+",null,98546.61,67710.680000000008,46775.68,41345.300000000003,35888.950000000004,null,0,0,0,0,0]
[1,"1 Child",null,3680.8500000000004,2710.9500000000003,2070.71,1730.98,1349.38,null,0,0,0,0,0]
[2,"2 Children",null,5853.85,4317.91,3294.48,2748.05,2136.4300000000003,null,0,0,0,0,0]
[3,"3+ Children",null,8582.2900000000009,6330.85,4823.5300000000007,4026.4100000000003,3132.8300000000004,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"]
[" "," ","DL1","DL2","DL3","DL4","DL5","DL6"]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","DL1","DL2","DL3","DL4","DL5","DL6"]
[18,"-  24",{"$f":"+C73*$L$2","v":0},0,0,0,0,0]
[25,"-  29",0,0,0,0,0,0]
[30,"-  34",0,0,0,0,0,0]
[35,"-  39",0,0,0,0,0,0]
[40,"-  44",0,0,0,0,0,0]
[45,"-  49",0,0,0,0,0,0]
[50,"-  54",0,0,0,0,0,0]
[55,"-  59",0,0,0,0,0,0]
[60,null,0,0,0,0,0,0]
[61,null,0,0,0,0,0,0]
[62,null,{"$f":"+C83*$L$2","v":0},0,0,0,0,0]
[63,null,0,0,0,0,0,0]
[64,null,0,0,0,0,0,0]
[65,null,0,0,0,0,0,0]
[66,null,0,0,0,0,0,0]
[67,null,0,0,0,0,0,0]
[68,null,0,0,0,0,0,0]
[69,null,0,0,0,0,0,0]
[70,null,0,0,0,0,0,0]
[71,null,0,0,0,0,0,0]
[72,null,{"$f":"+C93*$L$2","v":0},0,0,0,0,0]
[73,null,0,0,0,0,0,0]
[74,null,0,0,0,0,0,0]
[75,"o más",0,0,0,0,0,0]
[1,"Hijo",0,0,0,0,0,0]
[2,"Hijos",0,0,0,0,0,0]
[3,"Hijos o más",0,0,0,0,0,0]
[1,"Rider Comp. Maternidad",0,0,0,0,0,0]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["PRIVILEGE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6",null,2,6,10,14,18]
[18,"18-24",null,16796,11547,7587,5331,4054,null,0,0,0,0,0]
[25,"25-29",null,17620,12777,8402,5906,4499,null,0,0,0,0,0]
[30,"30-34",null,18388,13666,9429,7145,5449,null,0,0,0,0,0]
[35,"35-39",null,20602,15299,10565,8004,6115,null,0,0,0,0,0]
[40,"40-44",null,23848,16775,11745,8822,6734,null,0,0,0,0,0]
[45,"45-49",null,26645,18748,13137,9862,7534,null,0,0,0,0,0]
[50,"50-54",null,34833,24728,17247,14086,10765,null,0,0,0,0,0]
[55,"55-59",null,37067,26314,18348,14989,11461,null,0,0,0,0,0]
[60,"60",null,40368,28574,20892,17833,14308,null,0,0,0,0,0]
[61,"61",null,43365,30688,22437,19151,15374,null,0,0,0,0,0]
[62,"62",null,47465,33606,24567,20972,16837,null,0,0,0,0,0]
[63,"63",null,50472,35733,26118,22303,17909,null,0,0,0,0,0]
[64,"64",null,54598,38658,28260,24119,19381,null,0,0,0,0,0]
[65,"65",null,71373,50434,35731,32166,27314,null,0,0,0,0,0]
[66,"66",null,82913,58596,41513,37391,31745,null,0,0,0,0,0]
[67,"67",null,90560,64002,45344,40836,34669,null,0,0,0,0,0]
[68,"68",null,100270,70852,50210,45217,38380,null,0,0,0,0,0]
[69,"69",null,110321,77958,55237,49749,42242,null,0,0,0,0,0]
[70,"70",null,135767,94934,65024,57963,49686,null,0,0,0,0,0]
[71,"71",null,141096,98652,67580,60245,51640,null,0,0,0,0,0]
[72,"72",null,145098,101442,69491,61954,53101,null,0,0,0,0,0]
[73,"73",null,150416,105172,72038,64225,55065,null,0,0,0,0,0]
[74,"74",null,153099,107038,73322,65363,56027,null,0,0,0,0,0]
[75,"75+",null,159748,111695,76509,68205,58464,null,0,0,0,0,0]
[1,"1 Child",null,5819,4260,3090,2575,1911,null,0,0,0,0,0]
[2,"2 Children",null,9267,6777,4910,4089,3035,null,0,0,0,0,0]
[3,"3+ Children",null,13582,9928,7190,5993,4449,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":8901.880000000001},{"$f":"$L$2*E140","v":6119.91},4021.11,2825.4300000000003,2148.62,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D141","v":9338.6},6771.81,4453.0600000000004,3130.1800000000003,2384.4700000000003,null,0,0,0,0,0]
[30,"30-34",null,9745.6400000000012,7242.9800000000005,4997.37,3786.8500000000004,2887.9700000000003,null,0,0,0,0,0]
[35,"35-39",null,10919.060000000001,8108.47,5599.4500000000007,4242.12,{"$f":"$L$2*H143","v":3240.9500000000003},null,0,0,0,0,0]
[40,"40-44",null,12639.44,8890.75,6224.85,4675.66,3569.02,null,0,0,0,0,0]
[45,"45-49",null,14121.85,9936.44,6962.6100000000006,5226.8600000000006,3993.02,null,0,0,0,0,0]
[50,"50-54",null,18461.490000000002,13105.84,9140.91,7465.58,5705.4500000000007,null,0,0,0,0,0]
[55,"55-59",null,19645.510000000002,13946.42,9724.44,7944.17,6074.33,null,0,0,0,0,0]
[60,"60",null,21395.040000000001,15144.220000000001,11072.76,9451.49,7583.2400000000007,null,0,0,0,0,0]
[61,"61",null,22983.45,16264.640000000001,11891.61,10150.030000000001,8148.22,null,0,0,0,0,0]
[62,"62",null,25156.45,17811.18,13020.51,11115.16,8923.61,null,0,0,0,0,0]
[63,"63",null,26750.16,18938.490000000002,13842.54,11820.59,9491.77,null,0,0,0,0,0]
[64,"64",null,28936.940000000002,20488.740000000002,14977.800000000001,12783.070000000002,10271.93,null,0,0,0,0,0]
[65,"65",null,37827.69,26730.02,18937.43,17047.98,14476.42,null,0,0,0,0,0]
[66,"66",null,43943.89,31055.88,22001.89,19817.23,16824.850000000002,null,0,0,0,0,0]
[67,"67",null,47996.800000000003,33921.060000000005,24032.32,21643.08,18374.57,null,0,0,0,0,0]
[68,"68",null,53143.100000000006,37551.560000000005,26611.300000000003,23965.010000000002,20341.400000000001,null,0,0,0,0,0]
[69,"69",null,58470.130000000005,41317.740000000005,29275.61,26366.97,22388.260000000002,null,0,0,0,0,0]
[70,"70",null,71956.510000000009,50315.020000000004,34462.720000000001,30720.390000000003,26333.58,null,0,0,0,0,0]
[71,"71",null,74780.88,52285.560000000005,35817.4,31929.850000000002,27369.200000000001,null,0,0,0,0,0]
[72,"72",null,76901.94,53764.26,36830.230000000003,32835.620000000003,28143.530000000002,null,0,0,0,0,0]
[73,"73",null,79720.48000000001,55741.16,38180.14,34039.25,29184.45,null,0,0,0,0,0]
[74,"74",null,81142.47,56730.14,38860.660000000003,34642.39,29694.31,null,0,0,0,0,0]
[75,"75+",null,84666.44,59198.350000000006,40549.770000000004,36148.65,30985.920000000002,null,0,0,0,0,0]
[1,"1 Child",null,3084.07,2257.8000000000002,1637.7,1364.75,1012.83,null,0,0,0,0,0]
[2,"2 Children",null,4911.51,3591.8100000000004,2602.3000000000002,{"$f":"$L$2*G165","v":2167.17},1608.5500000000002,null,0,0,0,0,0]
[3,"3+ Children",null,7198.46,5261.84,3810.7000000000003,3176.29,2357.9700000000003,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"]
[" "," ","CL1","CL2","CL3","CL4","CL5","CL6"]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","CL1","CL2","CL3","CL4","CL5","CL6"]
[18,"-  24",{"$f":"+C207*$L$2","v":0},0,0,0,0,0]
[25,"-  29",0,0,0,0,0,0]
[30,"-  34",0,0,0,0,0,0]
[35,"-  39",0,0,0,0,0,0]
[40,"-  44",0,0,0,0,0,0]
[45,"-  49",0,0,0,0,0,0]
[50,"-  54",0,0,0,0,0,0]
[55,"-  59",0,0,0,0,0,0]
[60,null,0,0,0,0,0,0]
[61,null,0,0,0,0,0,0]
[62,null,{"$f":"+C217*$L$2","v":0},0,0,0,0,0]
[63,null,0,0,0,0,0,0]
[64,null,0,0,0,0,0,0]
[65,null,0,0,0,0,0,0]
[66,null,0,0,0,0,0,0]
[67,null,0,0,0,0,0,0]
[68,null,0,0,0,0,0,0]
[69,null,0,0,0,0,0,0]
[70,null,0,0,0,0,0,0]
[71,null,0,0,0,0,0,0]
[72,null,{"$f":"+C227*$L$2","v":0},0,0,0,0,0]
[73,null,0,0,0,0,0,0]
[74,null,0,0,0,0,0,0]
[75,"o más",0,0,0,0,0,0]
[1,"Hijo",0,0,0,0,0,0]
[2,"Hijos",0,0,0,0,0,0]
[3,"Hijos o más",0,0,0,0,0,0]
[1,"Rider Comp. Maternidad",0,0,0,0,0,0]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["ADVANTAGE (WORLDWIDE)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6",null,6,10,14,18,22]
[18,"18-24",null,11274,8468,6008,4524,3596,null,0,0,0,0,0]
[25,"25-29",null,12539,9454,6697,5057,3984,null,0,0,0,0,0]
[30,"30-34",null,14513,11113,7965,6006,4628,null,0,0,0,0,0]
[35,"35-39",null,16087,12364,8855,6837,5127,null,0,0,0,0,0]
[40,"40-44",null,18158,14021,10049,7643,5808,null,0,0,0,0,0]
[45,"45-49",null,21085,16143,11320,8701,6741,null,0,0,0,0,0]
[50,"50-54",null,23113,18149,13192,9759,7405,null,0,0,0,0,0]
[55,"55-59",null,27316,20952,14591,11309,8752,null,0,0,0,0,0]
[60,"60",null,30177,23199,16056,12470,9692,null,0,0,0,0,0]
[61,"61",null,33962,26114,18072,14044,10917,null,0,0,0,0,0]
[62,"62",null,37746,29025,20086,15620,12140,null,0,0,0,0,0]
[63,"63",null,41524,31932,22115,17187,13362,null,0,0,0,0,0]
[64,"64",null,45307,34844,24120,18760,14588,null,0,0,0,0,0]
[65,"65",null,48992,37923,26299,20431,16597,null,0,0,0,0,0]
[66,"66",null,51876,40156,27844,21641,17568,null,0,0,0,0,0]
[67,"67",null,57649,44636,30950,24053,19536,null,0,0,0,0,0]
[68,"68",null,63425,49104,34053,26460,21496,null,0,0,0,0,0]
[69,"69",null,66312,51338,35605,27669,22483,null,0,0,0,0,0]
[70,"70",null,67163,52154,36150,28183,22773,null,0,0,0,0,0]
[71,"71",null,75578,58694,40674,31720,25623,null,0,0,0,0,0]
[72,"72",null,83983,65216,45206,35258,28481,null,0,0,0,0,0]
[73,"73",null,92388,71749,49728,38798,31345,null,0,0,0,0,0]
[74,"74",null,100800,78287,54264,42328,34200,null,0,0,0,0,0]
[75,"75+",null,110269,87300,62236,46336,39241,null,0,0,0,0,0]
[1,"1 Child",null,5020,3582,2630,2283,1653,null,0,0,0,0,0]
[2,"2 Children",null,8168,5644,4147,3616,2438,null,0,0,0,0,0]
[3,"3+ Children",null,11960,8212,6044,5249,3690,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,7,11,15,19,23]
[18,"18-24",null,{"$f":"+D274*$L$2","v":5975.22},4488.04,3184.2400000000002,2397.7200000000003,1905.88,null,0,0,0,0,0]
[25,"25-29",null,6645.67,5010.62,3549.4100000000003,2680.21,2111.52,null,0,0,0,0,0]
[30,"30-34",null,7691.89,5889.89,4221.45,3183.1800000000003,2452.84,null,0,0,0,0,0]
[35,"35-39",null,8526.11,6552.92,4693.1500000000005,3623.61,2717.31,null,0,0,0,0,0]
[40,"40-44",null,9623.74,7431.13,5325.97,4050.7900000000004,3078.2400000000002,null,0,0,0,0,0]
[45,"45-49",null,11175.050000000001,8555.7900000000009,5999.6,4611.5300000000007,3572.73,null,0,0,0,0,0]
[50,"50-54",null,12249.890000000001,9618.9700000000012,6991.76,5172.2700000000004,3924.65,null,0,0,0,0,0]
[55,"55-59",null,14477.480000000001,11104.560000000001,7733.2300000000005,5993.77,4638.5600000000004,null,0,0,0,0,0]
[60,"60",null,15993.810000000001,12295.470000000001,8509.68,6609.1,5136.76,null,0,0,0,0,0]
[61,"61",null,17999.86,13840.42,9578.16,7443.3200000000006,5786.01,null,0,0,0,0,0]
[62,"62",null,{"$f":"+D284*$L$2","v":20005.38},15383.25,10645.58,8278.6,6434.2000000000007,null,0,0,0,0,0]
[63,"63",null,22007.72,16923.96,11720.95,9109.11,7081.8600000000006,null,0,0,0,0,0]
[64,"64",null,24012.710000000003,18467.32,12783.6,9942.8000000000011,7731.64,null,0,0,0,0,0]
[65,"65",null,25965.760000000002,20099.190000000002,13938.470000000001,10828.43,8796.41,null,0,0,0,0,0]
[66,"66",null,27494.280000000002,21282.68,14757.320000000002,11469.730000000001,9311.0400000000009,null,0,0,0,0,0]
[67,"67",null,30553.97,23657.08,16403.5,12748.09,10354.08,null,0,0,0,0,0]
[68,"68",null,33615.25,26025.120000000003,18048.09,14023.800000000001,11392.880000000001,null,0,0,0,0,0]
[69,"69",null,35145.360000000001,27209.140000000003,18870.650000000001,14664.570000000002,11915.99,null,0,0,0,0,0]
[70,"70",null,35596.39,27641.620000000003,19159.5,14936.990000000002,12069.69,null,0,0,0,0,0]
[71,"71",null,40056.340000000004,31107.820000000003,21557.22,16811.600000000002,13580.19,null,0,0,0,0,0]
[72,"72",null,{"$f":"+D294*$L$2","v":44510.990000000005},34564.480000000003,23959.18,18686.740000000002,15094.93,null,0,0,0,0,0]
[73,"73",null,48965.64,38026.97,26355.84,20562.940000000002,16612.850000000002,null,0,0,0,0,0]
[74,"74",null,53424,41492.11,28759.920000000002,22433.84,18126,null,0,0,0,0,0]
[75,"75+",null,58442.57,46269,32985.08,24558.080000000002,20797.73,null,0,0,0,0,0]
[1,"1 Child",null,2660.6,1898.46,1393.9,1209.99,876.09,null,0,0,0,0,0]
[2,"2 Children",null,4329.04,2991.32,2197.9100000000003,1916.48,1292.1400000000001,null,0,0,0,0,0]
[3,"3+ Children",null,6338.8,4352.3600000000006,3203.32,2781.9700000000003,1955.7,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,119.25,119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,159,159,159,159,159]
[]
["ADVANTAGE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"AL2","AL3","AL4","AL5","AL6",null,6,10,14,18,22]
[18,"18-24",null,11240,8450,6003,4521,3578,null,0,0,0,0,0]
[25,"25-29",null,12522,9432,6676,5046,3960,null,0,0,0,0,0]
[30,"30-34",null,14491,11087,7953,5984,4611,null,0,0,0,0,0]
[35,"35-39",null,16068,12342,8853,6822,5116,null,0,0,0,0,0]
[40,"40-44",null,18135,13999,10040,7628,5791,null,0,0,0,0,0]
[45,"45-49",null,21074,16127,11319,8682,6734,null,0,0,0,0,0]
[50,"50-54",null,23095,18131,13196,9747,7397,null,0,0,0,0,0]
[55,"55-59",null,27290,20932,14596,11305,8747,null,0,0,0,0,0]
[60,"60",null,30152,23179,16056,12465,9685,null,0,0,0,0,0]
[61,"61",null,33942,26076,18072,14038,10913,null,0,0,0,0,0]
[62,"62",null,37722,29010,20091,15611,12132,null,0,0,0,0,0]
[63,"63",null,41505,31913,22117,17178,13360,null,0,0,0,0,0]
[64,"64",null,45292,34829,24140,18760,14569,null,0,0,0,0,0]
[65,"65",null,48973,37903,26303,20431,16582,null,0,0,0,0,0]
[66,"66",null,51857,40135,27861,21635,17581,null,0,0,0,0,0]
[67,"67",null,57634,44613,30968,24062,19536,null,0,0,0,0,0]
[68,"68",null,63406,49074,34077,26482,21499,null,0,0,0,0,0]
[69,"69",null,66294,51314,35619,27680,22488,null,0,0,0,0,0]
[70,"70",null,67143,52135,36169,28205,22786,null,0,0,0,0,0]
[71,"71",null,75557,58666,40705,31745,25636,null,0,0,0,0,0]
[72,"72",null,83973,65215,45242,35276,28498,null,0,0,0,0,0]
[73,"73",null,92378,71746,49775,38821,31358,null,0,0,0,0,0]
[74,"74",null,100789,78269,54304,42358,34218,null,0,0,0,0,0]
[75,"75+",null,110253,87280,62287,46373,39262,null,0,0,0,0,0]
[1,"1 Child",null,5009,3572,2624,2281,1656,null,0,0,0,0,0]
[2,"2 Children",null,8181,5634,4146,3620,2438,null,0,0,0,0,0]
[3,"3+ Children",null,11967,8220,6057,5241,3690,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"AL2","AL3","AL4","AL5","AL6",null,7,11,15,19,23]
[18,"18-24",null,{"$f":"+D341*$L$2","v":5957.2000000000007},4478.5,3181.59,2396.13,1896.3400000000001,null,0,0,0,0,0]
[25,"25-29",null,6636.6600000000008,4998.96,3538.28,2674.38,2098.8000000000002,null,0,0,0,0,0]
[30,"30-34",null,7680.2300000000005,5876.1100000000006,4215.09,3171.52,2443.83,null,0,0,0,0,0]
[35,"35-39",null,{"$f":"+D344*$L$2","v":8516.0400000000009},6541.26,4692.09,3615.6600000000003,2711.48,null,0,0,0,0,0]
[40,"40-44",null,9611.5500000000011,7419.47,5321.2,4042.84,3069.23,null,0,0,0,0,0]
[45,"45-49",null,11169.220000000001,8547.3100000000013,5999.0700000000006,4601.46,3569.02,null,0,0,0,0,0]
[50,"50-54",null,12240.35,9609.43,6993.88,5165.91,3920.4100000000003,null,0,0,0,0,0]
[55,"55-59",null,14463.7,11093.960000000001,7735.88,5991.6500000000005,4635.91,null,0,0,0,0,0]
[60,"60",null,15980.560000000001,12284.87,8509.68,6606.4500000000007,5133.05,null,0,0,0,0,0]
[61,"61",null,17989.260000000002,13820.28,9578.16,7440.14,5783.89,null,0,0,0,0,0]
[62,"62",null,{"$f":"+D351*$L$2","v":19992.66},15375.300000000001,10648.230000000001,8273.83,6429.96,null,0,0,0,0,0]
[63,"63",null,21997.65,16913.89,11722.01,9104.34,7080.8,null,0,0,0,0,0]
[64,"64",null,24004.760000000002,18459.370000000003,12794.2,9942.8000000000011,7721.5700000000006,null,0,0,0,0,0]
[65,"65",null,25955.690000000002,20088.59,13940.59,10828.43,8788.4600000000009,null,0,0,0,0,0]
[66,"66",null,27484.210000000003,21271.55,14766.33,11466.550000000001,9317.93,null,0,0,0,0,0]
[67,"67",null,30546.02,23644.89,16413.04,12752.86,10354.08,null,0,0,0,0,0]
[68,"68",null,33605.18,26009.22,18060.810000000001,14035.460000000001,11394.470000000001,null,0,0,0,0,0]
[69,"69",null,35135.82,27196.420000000002,18878.07,14670.400000000001,11918.640000000001,null,0,0,0,0,0]
[70,"70",null,35585.79,27631.550000000003,19169.57,14948.650000000001,12076.58,null,0,0,0,0,0]
[71,"71",null,40045.21,31092.980000000003,21573.65,16824.850000000002,13587.08,null,0,0,0,0,0]
[72,"72",null,{"$f":"+D361*$L$2","v":44505.69},{"$f":"+E361*$L$2","v":34563.950000000004},23978.260000000002,18696.280000000002,15103.94,null,0,0,0,0,0]
[73,"73",null,48960.340000000004,38025.380000000005,26380.75,20575.13,16619.740000000002,null,0,0,0,0,0]
[74,"74",null,53418.170000000006,41482.57,28781.120000000003,22449.74,18135.54,null,0,0,0,0,0]
[75,"75+",null,58434.090000000004,46258.400000000001,33012.11,24577.690000000002,20808.86,null,0,0,0,0,0]
[1,"1 Child",null,2654.77,1893.16,1390.72,1208.93,877.68000000000006,null,0,0,0,0,0]
[2,"2 Children",null,4335.93,2986.02,2197.38,1918.6000000000001,1292.1400000000001,null,0,0,0,0,0]
[3,"3+ Children",null,6342.51,4356.6000000000004,3210.21,2777.73,1955.7,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,0,0,0,0,0]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["SECURE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6",null,6,10,14,18,22]
[18,"18-24",null,8692,6814,4903,4197,3192,null,0,0,0,0,0]
[25,"25-29",null,9576,7674,5453,4678,3539,null,0,0,0,0,0]
[30,"30-34",null,10962,9022,6337,5432,4112,null,0,0,0,0,0]
[35,"35-39",null,12094,10100,7053,6047,4559,null,0,0,0,0,0]
[40,"40-44",null,13565,11516,7986,6833,5141,null,0,0,0,0,0]
[45,"45-49",null,15612,13500,9297,7960,5977,null,0,0,0,0,0]
[50,"50-54",null,17040,14871,10199,8728,6541,null,0,0,0,0,0]
[55,"55-59",null,20026,17754,12083,10335,7728,null,0,0,0,0,0]
[60,"60",null,20962,18976,12802,10947,8180,null,0,0,0,0,0]
[61,"61",null,23590,21360,14408,12327,9216,null,0,0,0,0,0]
[62,"62",null,26229,23735,16023,13710,10252,null,0,0,0,0,0]
[63,"63",null,28862,26127,17634,15088,11288,null,0,0,0,0,0]
[64,"64",null,31496,28517,19239,16465,12328,null,0,0,0,0,0]
[65,"65",null,31524,28786,19354,16559,12381,null,0,0,0,0,0]
[66,"66",null,31569,29048,19475,16638,12418,null,0,0,0,0,0]
[67,"67",null,35084,32292,21635,18508,13804,null,0,0,0,0,0]
[68,"68",null,38600,35525,23821,20364,15202,null,0,0,0,0,0]
[69,"69",null,40371,37144,24903,21294,15897,null,0,0,0,0,0]
[70,"70",null,40430,37772,25157,21504,15971,null,0,0,0,0,0]
[71,"71",null,45509,42506,28320,24194,17990,null,0,0,0,0,0]
[72,"72",null,50577,47244,31479,26906,19996,null,0,0,0,0,0]
[73,"73",null,55646,51982,34638,29602,22007,null,0,0,0,0,0]
[74,"74",null,60710,56714,37792,32303,24021,null,0,0,0,0,0]
[75,"75+",null,66165,62210,41344,35329,26239,null,0,0,0,0,0]
[1,"1 Child",null,4204,2475,1979,1682,1244,null,0,0,0,0,0]
[2,"2 Children",null,7088,3670,3118,2657,1972,null,0,0,0,0,0]
[3,"3+ Children",null,10391,5294,4527,3865,2860,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,7,11,15,19,23]
[18,"18-24",null,{"$f":"+D408*$L$2","v":4606.76},3611.42,2598.59,2224.4100000000003,1691.76,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"+D409*$L$2","v":5075.2800000000007},4067.2200000000003,2890.09,2479.34,1875.67,null,0,0,0,0,0]
[30,"30-34",null,{"$f":"+D410*$L$2","v":5809.8600000000006},4781.66,3358.61,2878.96,2179.36,null,0,0,0,0,0]
[35,"35-39",null,{"$f":"+D411*$L$2","v":6409.8200000000006},{"$f":"+E411*$L$2","v":5353},3738.09,3204.9100000000003,2416.27,null,0,0,0,0,0]
[40,"40-44",null,{"$f":"+D412*$L$2","v":7189.4500000000007},6103.4800000000005,4232.58,3621.4900000000002,2724.73,null,0,0,0,0,0]
[45,"45-49",null,{"$f":"+D413*$L$2","v":8274.36},7155,4927.41,4218.8,3167.81,null,0,0,0,0,0]
[50,"50-54",null,{"$f":"+D414*$L$2","v":9031.2000000000007},7881.63,5405.47,4625.84,3466.73,null,0,0,0,0,0]
[55,"55-59",null,{"$f":"+D415*$L$2","v":10613.78},9409.6200000000008,6403.9900000000007,5477.55,4095.84,null,0,0,0,0,0]
[60,"60",null,{"$f":"+D416*$L$2","v":11109.86},10057.280000000001,6785.06,5801.91,4335.4000000000005,null,0,0,0,0,0]
[61,"61",null,{"$f":"+D417*$L$2","v":12502.7},11320.800000000001,7636.2400000000007,6533.31,4884.4800000000005,null,0,0,0,0,0]
[62,"62",null,{"$f":"+D418*$L$2","v":13901.37},12579.550000000001,8492.19,7266.3,5433.56,null,0,0,0,0,0]
[63,"63",null,{"$f":"+D419*$L$2","v":15296.86},13847.310000000001,9346.02,7996.64,5982.64,null,0,0,0,0,0]
[64,"64",null,{"$f":"+D420*$L$2","v":16692.88},15114.01,10196.67,8726.4500000000007,6533.84,null,0,0,0,0,0]
[65,"65",null,{"$f":"+D421*$L$2","v":16707.72},15256.58,10257.620000000001,8776.27,6561.93,null,0,0,0,0,0]
[66,"66",null,{"$f":"+D422*$L$2","v":16731.57},15395.44,10321.75,8818.1400000000012,6581.54,null,0,0,0,0,0]
[67,"67",null,{"$f":"+D423*$L$2","v":18594.52},17114.760000000002,11466.550000000001,9809.24,7316.1200000000008,null,0,0,0,0,0]
[68,"68",null,{"$f":"+D424*$L$2","v":20458},18828.25,12625.130000000001,10792.92,8057.06,null,0,0,0,0,0]
[69,"69",null,{"$f":"+D425*$L$2","v":21396.63},19686.32,13198.59,11285.82,8425.41,null,0,0,0,0,0]
[70,"70",null,{"$f":"+D426*$L$2","v":21427.9},20019.16,13333.210000000001,11397.12,8464.630000000001,null,0,0,0,0,0]
[71,"71",null,{"$f":"+D427*$L$2","v":24119.77},22528.18,15009.6,12822.820000000002,9534.7000000000007,null,0,0,0,0,0]
[72,"72",null,{"$f":"+D428*$L$2","v":26805.81},25039.32,16683.870000000003,14260.18,10597.880000000001,null,0,0,0,0,0]
[73,"73",null,{"$f":"+D429*$L$2","v":29492.38},27550.460000000003,18358.14,15689.060000000001,11663.710000000001,null,0,0,0,0,0]
[74,"74",null,{"$f":"+D430*$L$2","v":32176.300000000003},30058.420000000002,20029.760000000002,17120.59,12731.130000000001,null,0,0,0,0,0]
[75,"75+",null,{"$f":"+D431*$L$2","v":35067.450000000004},32971.300000000003,21912.32,18724.370000000003,13906.67,null,0,0,0,0,0]
[1,"1 Child",null,{"$f":"+D432*$L$2","v":2228.12},1311.75,1048.8700000000001,891.46,659.32,null,0,0,0,0,0]
[2,"2 Children",null,{"$f":"+D433*$L$2","v":3756.6400000000003},1945.1000000000001,1652.5400000000002,1408.21,1045.1600000000001,null,0,0,0,0,0]
[3,"3+ Children",null,{"$f":"+D434*$L$2","v":5507.2300000000005},2805.82,2399.31,2048.4500000000003,1515.8000000000002,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D435*$L$2","v":119.25},119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,{"$f":"+D436*$L$2","v":159},159,159,159,159]
[]
["ESSENTIAL"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"ET2","ET3","ET4","ET5","ET6",null,6,10,14,18,22]
[18,"18-24",null,7182,5621,4041,3471,2627,null,0,0,0,0,0]
[25,"25-29",null,7920,6336,4508,3874,2917,null,0,0,0,0,0]
[30,"30-34",null,9060,7458,5240,4496,3387,null,0,0,0,0,0]
[35,"35-39",null,9999,8357,5837,4992,3764,null,0,0,0,0,0]
[40,"40-44",null,11213,9531,6600,5653,4248,null,0,0,0,0,0]
[45,"45-49",null,12910,11177,7691,6580,4938,null,0,0,0,0,0]
[50,"50-54",null,14093,12304,8428,7210,5408,null,0,0,0,0,0]
[55,"55-59",null,16571,14694,9995,8558,6393,null,0,0,0,0,0]
[60,"60",null,17350,15706,10582,9057,6761,null,0,0,0,0,0]
[61,"61",null,19520,17686,11915,10197,7632,null,0,0,0,0,0]
[62,"62",null,21702,19656,13263,11344,8482,null,0,0,0,0,0]
[63,"63",null,23897,21628,14594,12490,9345,null,0,0,0,0,0]
[64,"64",null,26080,23615,15926,13628,10199,null,0,0,0,0,0]
[65,"65",null,26106,23831,16027,13703,10238,null,0,0,0,0,0]
[66,"66",null,26132,24057,16126,13772,10272,null,0,0,0,0,0]
[67,"67",null,29046,26744,17913,15313,11422,null,0,0,0,0,0]
[68,"68",null,31967,29435,19716,16856,12580,null,0,0,0,0,0]
[69,"69",null,33424,30762,20622,17627,13156,null,0,0,0,0,0]
[70,"70",null,33470,31278,20830,17798,13224,null,0,0,0,0,0]
[71,"71",null,37683,35210,23453,20036,14885,null,0,0,0,0,0]
[72,"72",null,41883,39131,26075,22279,16552,null,0,0,0,0,0]
[73,"73",null,46079,43055,28685,24513,18229,null,0,0,0,0,0]
[74,"74",null,50277,46970,31302,26758,19876,null,0,0,0,0,0]
[75,"75+",null,54792,51540,34243,29253,21723,null,0,0,0,0,0]
[1,"1 Child",null,3484,2051,1631,1396,1045,null,0,0,0,0,0]
[2,"2 Children",null,5870,3038,2580,2212,1634,null,0,0,0,0,0]
[3,"3+ Children",null,8610,4386,3753,3202,2368,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,7,11,15,19,23]
[18,"18-24",null,{"$f":"+D475*$L$2","v":3806.46},2979.13,2141.73,1839.63,1392.3100000000002,null,0,0,0,0,0]
[25,"25-29",null,4197.6000000000004,3358.0800000000004,2389.2400000000002,2053.2200000000003,1546.01,null,0,0,0,0,0]
[30,"30-34",null,4801.8,3952.7400000000002,2777.2000000000003,2382.88,1795.1100000000001,null,0,0,0,0,0]
[35,"35-39",null,5299.47,4429.21,3093.61,2645.76,1994.92,null,0,0,0,0,0]
[40,"40-44",null,5942.89,5051.43,3498,2996.09,2251.44,null,0,0,0,0,0]
[45,"45-49",null,6842.3,5923.81,4076.23,3487.4,2617.1400000000003,null,0,0,0,0,0]
[50,"50-54",null,7469.29,6521.12,4466.84,3821.3,2866.2400000000002,null,0,0,0,0,0]
[55,"55-59",null,8782.630000000001,7787.8200000000006,5297.35,4535.74,3388.29,null,0,0,0,0,0]
[60,"60",null,9195.5,8324.18,5608.46,4800.21,3583.3300000000004,null,0,0,0,0,0]
[61,"61",null,10345.6,9373.58,6314.9500000000007,5404.41,4044.96,null,0,0,0,0,0]
[62,"62",null,{"$f":"+D485*$L$2","v":11502.060000000001},10417.68,7029.39,6012.3200000000006,4495.46,null,0,0,0,0,0]
[63,"63",null,12665.41,11462.84,7734.8200000000006,6619.7000000000007,4952.8500000000004,null,0,0,0,0,0]
[64,"64",null,13822.400000000001,12515.95,8440.7800000000007,7222.84,5405.47,null,0,0,0,0,0]
[65,"65",null,13836.18,12630.43,8494.3100000000013,7262.59,5426.14,null,0,0,0,0,0]
[66,"66",null,13849.960000000001,12750.210000000001,8546.7800000000007,7299.1600000000008,5444.16,null,0,0,0,0,0]
[67,"67",null,15394.380000000001,14174.320000000002,9493.8900000000012,8115.89,6053.66,null,0,0,0,0,0]
[68,"68",null,16942.510000000002,15600.550000000001,10449.480000000001,8933.68,6667.4000000000005,null,0,0,0,0,0]
[69,"69",null,17714.72,16303.86,10929.66,9342.3100000000013,6972.68,null,0,0,0,0,0]
[70,"70",null,17739.100000000002,16577.34,11039.900000000001,9432.94,7008.72,null,0,0,0,0,0]
[71,"71",null,19971.990000000002,18661.3,12430.09,10619.08,7889.05,null,0,0,0,0,0]
[72,"72",null,{"$f":"+D495*$L$2","v":22197.99},20739.43,13819.75,11807.87,8772.5600000000013,null,0,0,0,0,0]
[73,"73",null,24421.870000000003,22819.15,15203.050000000001,12991.890000000001,9661.3700000000008,null,0,0,0,0,0]
[74,"74",null,26646.81,24894.100000000002,16590.060000000001,14181.740000000002,10534.28,null,0,0,0,0,0]
[75,"75+",null,29039.760000000002,27316.2,18148.79,15504.09,11513.19,null,0,0,0,0,0]
[1,"1 Child",null,1846.52,1087.03,864.43000000000006,739.88,553.85,null,0,0,0,0,0]
[2,"2 Children",null,3111.1000000000004,1610.14,1367.4,1172.3600000000001,866.0200000000001,null,0,0,0,0,0]
[3,"3+ Children",null,4563.3,2324.58,1989.0900000000001,1697.0600000000002,1255.04,null,0,0,0,0,0]
[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,"INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR"]
[18,"-  49",4167,7342,10498,3376,5750,8144,2876,4953,7024,2283,3830,5391,1707,2763,3816]
[50,"o más",5280,8441,11616,4250,6622,9022,3608,5675,7744,2818,4366,5920,2072,3124,4178]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","CR1",null,null,"CR2",null,null,"CR3",null,null,"CR4",null,null,"CR5"]
[null,null,"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":2208.5100000000002},3891.26,5563.9400000000005,1789.2800000000002,3047.5,4316.3200000000006,1524.28,2625.09,3722.7200000000003,1209.99,2029.9,2857.23,904.71,1464.39,2022.48]
[75,"o más",{"$f":"+C544*$L$2","v":2798.4},4473.7300000000005,6156.4800000000005,2252.5,3509.6600000000003,4781.66,1912.24,3007.75,4104.3200000000006,1493.54,2313.98,3137.6000000000004,1098.1600000000001,1655.72,2214.34]