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

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

{"sheet":"Exclusive","index":1,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[32,0,32,1],[33,0,33,1],[32,2,32,3],[44,2,44,3],[49,5,50,12],[48,0,49,1],[48,2,49,3],[34,0,34,1],[45,0,45,1],[40,0,40,1],[41,0,41,1],[45,2,45,3],[43,0,43,1],[44,0,44,1],[42,0,42,1],[47,0,47,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],[34,2,34,3],[47,5,47,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[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],[33,2,33,3],[41,2,41,3],[27,0,27,1],[20,0,21,1],[31,2,31,3],[27,2,27,3],[29,0,29,1],[30,0,31,1],[20,2,20,3],[22,2,22,3],[28,2,28,3],[28,0,28,1],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[12,0,12,1],[17,0,18,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[40,2,40,3],[35,2,35,3],[39,0,39,1],[46,0,46,1],[47,2,47,3],[35,0,35,1],[36,0,38,1],[36,2,38,3],[39,2,39,3],[42,2,42,3],[51,0,51,1],[51,2,51,3],[50,0,50,1],[50,2,50,3],[43,2,43,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa EXCLUSIVE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:37:45.530"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null," ",false]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,4,TRUE)","v":10919},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":7213},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":5189},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":3683},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":2896}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$33)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$33)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!G$33)","v":225},{"$f":"+IF($I$20=FALSE,0,Tablas!H$33)","v":225}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I34)","v":10919},{"$f":"SUM(J31:J34)","v":7213},{"$f":"SUM(K31:K34)","v":5414},{"$f":"SUM(L31:L34)","v":3908},{"$f":"SUM(M31:M34)","v":3121}]
[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":10994},{"$f":"SUM(J35:J36)","v":7288},{"$f":"SUM(K35:K36)","v":5489},{"$f":"SUM(L35:L36)","v":3983},{"$f":"SUM(M35:M36)","v":3196}]
[]
[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":5787.0700000000006},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":3822.8900000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":2750.17},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":1951.99},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":1534.88}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$66)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$66)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!G$66)","v":119.25},{"$f":"+IF($I$20=FALSE,0,Tablas!H$66)","v":119.25}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I40:I43)","v":5787.0700000000006},{"$f":"SUM(J40:J43)","v":3822.8900000000003},{"$f":"SUM(K40:K43)","v":2869.42},{"$f":"SUM(L40:L43)","v":2071.2399999999998},{"$f":"SUM(M40:M43)","v":1654.13}]
[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":5862.0700000000006},{"$f":"SUM(J44:J45)","v":3897.8900000000003},{"$f":"SUM(K44:K45)","v":2944.42},{"$f":"SUM(L44:L45)","v":2146.2399999999998},{"$f":"SUM(M44:M45)","v":1729.13}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":5787.0700000000006},{"$f":"J44","v":3822.8900000000003},2869.42,2071.2399999999998,1654.13]
[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":"Privilege","index":2,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,0,48,1],[48,2,48,3],[45,0,45,1],[45,2,45,3],[35,0,35,1],[46,2,47,3],[35,2,35,3],[36,0,36,1],[42,2,42,3],[36,2,36,3],[43,0,43,1],[39,2,39,3],[40,2,40,3],[37,2,37,3],[49,5,50,12],[33,0,33,1],[34,0,34,1],[29,0,29,1],[41,2,41,3],[37,0,37,1],[38,0,38,1],[34,2,34,3],[39,0,39,1],[40,0,40,1],[41,0,41,1],[44,0,44,1],[38,2,38,3],[30,0,31,1],[29,2,29,3],[32,0,32,1],[22,2,22,3],[43,2,43,3],[19,0,19,1],[17,0,18,1],[20,0,21,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[26,2,26,3],[32,2,32,3],[26,0,26,1],[27,0,27,1],[33,2,33,3],[31,2,31,3],[42,0,42,1],[28,0,28,1],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,18,3],[49,0,49,1],[49,2,49,3],[47,5,47,12],[12,2,12,3],[13,2,13,3],[46,0,47,1],[44,2,44,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[21,2,21,3],[20,2,20,3],[25,2,25,3],[27,2,27,3],[28,2,28,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa PRIVILEGE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:37:45.530"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null," ",false]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,4,TRUE)","v":9139},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":6286},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":4491},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":3185},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":2423}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":0}]
[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":9139},{"$f":"SUM(J31:J34)","v":6286},{"$f":"SUM(K31:K34)","v":4716},{"$f":"SUM(L31:L34)","v":3410},{"$f":"SUM(M31:M34)","v":2648}]
[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":9214},{"$f":"SUM(J35:J36)","v":6361},{"$f":"SUM(K35:K36)","v":4791},{"$f":"SUM(L35:L36)","v":3485},{"$f":"SUM(M35:M36)","v":2723}]
[]
[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":4843.67},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":3331.5800000000004},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":2380.23},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":1688.0500000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":1284.19}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":0}]
[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":4843.67},{"$f":"SUM(J40:J43)","v":3331.5800000000004},{"$f":"SUM(K40:K43)","v":2499.48},{"$f":"SUM(L40:L43)","v":1807.3000000000002},{"$f":"SUM(M40:M43)","v":1403.44}]
[null,null,null,null,null,"Costo Administrativo Anual :",null,"n/a",75,75,75,75,75]
[null,null,null,null,null,"GRAN TOTAL  (1ra Cuota) :",null,"n/a",{"$f":"SUM(I44:I45)","v":4918.67},{"$f":"SUM(J44:J45)","v":3406.5800000000004},{"$f":"SUM(K44:K45)","v":2574.48},{"$f":"SUM(L44:L45)","v":1882.3000000000002},{"$f":"SUM(M44:M45)","v":1478.44}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":4843.67},{"$f":"J44","v":3331.5800000000004},2499.48,1807.3000000000002,1403.44]
[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":[[51,5,52,12],[33,0,33,1],[34,0,34,1],[48,2,48,3],[47,2,47,3],[44,0,44,1],[46,0,46,1],[45,2,45,3],[45,0,45,1],[35,0,41,1],[51,0,52,1],[33,2,33,3],[49,0,49,1],[50,0,50,1],[47,0,47,1],[48,0,48,1],[19,0,19,1],[24,2,24,3],[42,0,42,1],[42,2,42,3],[29,0,29,1],[34,2,34,3],[32,2,32,3],[32,0,32,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[26,0,26,1],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[20,0,21,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[30,2,30,3],[21,2,21,3],[22,2,22,3],[20,2,20,3],[25,2,25,3],[23,2,23,3],[50,2,50,3],[46,2,46,3],[44,2,44,3],[51,2,52,3],[35,2,39,3],[40,2,41,3],[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],[31,2,31,3],[19,2,19,3],[54,0,54,1],[54,2,54,3],[53,0,53,1],[53,2,53,3],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:37:45.530"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,4,TRUE)","v":5913},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":4445},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":3404},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":2611},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":2068}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":0}]
[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":6438},4970,3929,3136,2593]
[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":6513},{"$f":"SUM(J36:J37)","v":5045},{"$f":"SUM(K36:K37)","v":4004},{"$f":"SUM(L36:L37)","v":3211},{"$f":"SUM(M36:M37)","v":2668}]
[]
[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":3133.8900000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":2355.85},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":1804.1200000000001},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":1383.8300000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":1096.04}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":0}]
[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":3412.1400000000003},2634.1,2082.37,1662.0800000000002,1374.29]
[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":3487.1400000000003},{"$f":"SUM(J46:J47)","v":2709.1},{"$f":"SUM(K46:K47)","v":2157.37},{"$f":"SUM(L46:L47)","v":1737.0800000000002},{"$f":"SUM(M46:M47)","v":1449.29}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":3412.1400000000003},{"$f":"J46","v":2634.1},2082.37,1662.0800000000002,1374.29]
[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":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
["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:37:45.530"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
["Número máximo de días de hospitalización",null,"Ilimitado",null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
["Habitación y alimentación",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
["Cuidados Intensivos",null,"100% dentro de Red Bupa"]
[null,null,"\"UCR\" para L.A. en emergencias fuera de  Red Bupa",null,null,null," "]
["Cobertura de Maternidad",null,"$5,000 (Excepto planes 4,5, y 6)",null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Cobertura Provisional de Recién Nacido",null,"$30,000 por los primeros 90 días",null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Cuidado del Recién Nacido saludable",null,"Ya incluída dentro del beneficio de Maternidad",null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
["Cobertura de Complicaciones de Maternidad",null,"Disponible a través de cobertura opcional adicional"]
["Trasplante de Organos",null,"$1,000,000 de por vida, por diagnóstico"]
["Condiciones congénitas y hereditarias",null,"<18 años $300,000 de por vida; >=18 al 100%",null,null,"Tarifas Anuales"]
["Coberturas opcionales (Riders)",null,"Complicaciones de Maternidad por $500,000",null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,4,TRUE)","v":4381},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":3291},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":2519},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":1924},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":1520}]
[null,null,"Trasplante de órganos por $ 300,000 adicionales",null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,8,TRUE)))","v":0}]
["Acompañamiento de menores hospitalizados",null,"$300 por día",null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":0}]
["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":4381},3291,2519,1924,1520]
["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":4456},{"$f":"SUM(J36:J37)","v":3366},{"$f":"SUM(K36:K37)","v":2594},{"$f":"SUM(L36:L37)","v":1999},{"$f":"SUM(M36:M37)","v":1595}]
["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":2321.9300000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":1744.23},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":1335.0700000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":1019.72},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":805.6}]
["Cobertura de actividades peligrosas",null,1,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,8,TRUE)))","v":0}]
["Chequeos generales de rutina",null,"Hasta US$150 por año póliza.Sin deducible",null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":0}]
["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":2321.9300000000003},1744.23,1335.0700000000002,1019.72,805.6]
[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":2396.9300000000003},{"$f":"SUM(J46:J47)","v":1819.23},{"$f":"SUM(K46:K47)","v":1410.0700000000002},{"$f":"SUM(L46:L47)","v":1094.72},{"$f":"SUM(M46:M47)","v":880.6}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2321.9300000000003},{"$f":"J46","v":1744.23},1335.0700000000002,1019.72,805.6]
[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":[[43,2,43,3],[44,2,44,3],[51,5,53,12],[43,0,43,1],[35,2,39,3],[49,5,49,12],[46,2,46,3],[42,2,42,3],[42,0,42,1],[49,0,49,1],[49,2,49,3],[9,2,9,12],[33,2,33,3],[31,2,31,3],[47,0,48,1],[47,2,48,3],[45,2,45,3],[46,0,46,1],[45,0,45,1],[33,0,33,1],[34,0,34,1],[35,0,41,1],[44,0,44,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[20,0,21,1],[25,2,25,3],[34,2,34,3],[40,2,41,3],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,0,29,1],[15,0,15,1],[26,0,26,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],[16,0,16,1],[19,0,19,1],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa SECURE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:37:45.530"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,true,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,4,TRUE)","v":4233},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":3321},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":2551},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":2168},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":1644}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":0}]
[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":4758},3846,3076,2693,2169]
[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":4833},{"$f":"SUM(J36:J37)","v":3921},{"$f":"SUM(K36:K37)","v":3151},{"$f":"SUM(L36:L37)","v":2768},{"$f":"SUM(M36:M37)","v":2244}]
[]
[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":2243.4900000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":1760.13},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":1352.03},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":1149.04},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":871.32}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":0}]
[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":2521.7400000000002},2038.38,1630.28,1427.29,1149.5700000000002]
[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":2596.7400000000002},{"$f":"SUM(J46:J47)","v":2113.38},{"$f":"SUM(K46:K47)","v":1705.28},{"$f":"SUM(L46:L47)","v":1502.29},{"$f":"SUM(M46:M47)","v":1224.5700000000002}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2521.7400000000002},{"$f":"J46","v":2038.38},1630.28,1427.29,1149.5700000000002]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[null," "]
[null," ",null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Essential","index":6,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,5,53,12],[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],[9,2,9,12],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[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],[35,2,39,3],[33,0,33,1],[34,0,34,1],[35,0,41,1],[40,2,41,3],[49,0,49,1],[49,2,49,3],[42,0,42,1],[34,2,34,3],[47,2,48,3],[47,0,48,1],[45,2,45,3],[46,2,46,3],[43,2,43,3],[45,0,45,1],[46,0,46,1],[43,0,43,1],[44,0,44,1],[44,2,44,3],[42,2,42,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa ESSENTIAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:37:45.530"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,4,TRUE)","v":3556},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":2790},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":2140},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":1814},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":1381}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$502)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$502)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$503)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$503)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$503)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$503)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$503)","v":300}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":3856},3090,2440,2114,1681]
[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":3931},{"$f":"SUM(J36:J37)","v":3165},{"$f":"SUM(K36:K37)","v":2515},{"$f":"SUM(L36:L37)","v":2189},{"$f":"SUM(M36:M37)","v":1756}]
[]
[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":1884.68},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":1478.7},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":1134.2},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":961.42000000000007},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":731.93000000000006}]
[null,null,null,null,null,"Prima de Cónyuge",null,"n/a",{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,4,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,5,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,6,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,7,TRUE)))","v":0},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,8,TRUE)))","v":0}]
[null,null,null,null,null,"Primas Hijos :",null,"n/a",{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,4,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":0},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":0}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$535)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$535)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$536)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$536)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$536)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$536)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$536)","v":159}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":2043.68},1637.7,1293.2,1120.42,890.93000000000006]
[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":2118.6800000000003},{"$f":"SUM(J46:J47)","v":1712.7},{"$f":"SUM(K46:K47)","v":1368.2},{"$f":"SUM(L46:L47)","v":1195.42},{"$f":"SUM(M46:M47)","v":965.93000000000006}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":2043.68},{"$f":"J46","v":1637.7},1293.2,1120.42,890.93000000000006]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[]
[null," ",null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Critical","index":7,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,5,54,12],[25,8,25,9],[26,8,26,9],[21,10,22,12],[35,8,35,9],[36,8,36,9],[25,10,25,11],[26,10,26,11],[27,10,27,11],[32,10,32,11],[31,8,31,9],[32,8,32,9],[33,8,33,9],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[23,8,23,9],[24,8,24,9],[45,0,45,1],[23,5,24,7],[25,5,26,7],[27,5,28,7],[29,5,30,7],[31,5,32,7],[33,5,34,7],[35,5,36,7],[44,2,44,3],[26,0,26,1],[43,2,43,3],[40,0,40,1],[41,0,41,1],[42,0,42,1],[42,2,42,3],[40,2,40,3],[29,0,29,1],[30,0,31,1],[29,2,29,3],[32,2,32,3],[33,2,33,3],[27,2,27,3],[28,2,28,3],[19,0,19,1],[41,2,41,3],[44,0,44,1],[32,0,32,1],[35,0,39,1],[33,0,33,1],[34,0,34,1],[43,0,43,1],[22,0,23,1],[24,0,24,1],[30,2,31,3],[27,0,27,1],[28,0,28,1],[34,2,34,3],[20,0,21,1],[21,2,21,3],[22,2,22,3],[25,0,25,1],[25,2,25,3],[23,2,23,3],[24,2,24,3],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[35,2,39,3],[34,8,34,9],[27,8,27,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[45,2,45,3],[23,10,24,11],[33,10,36,12],[21,5,22,7],[21,8,22,9],[26,2,26,3],[17,2,18,3],[19,2,19,3],[20,2,20,3],[16,2,16,3],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[14,0,14,1],[13,0,13,1],[15,0,15,1],[16,0,16,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa CRITICAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:37:45.530"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,null,true,null,null,{"$f":"IF(M16>=M18,M16,M18)","v":18}]
[]
[null,null,null,null,null,"CONDICION CRITICA CUBIERTA",null,null,"MAXIMO POR AÑO POLIZA",null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,"Enfermedades neurológicas y accidentes cerebro-vasculares",null,null,150000,null,"Tipo de trasplante",null,"Máximo Vitalicio"]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,null,null,"por persona"]
[null,null,null,null,null,"Cirugías cardíacas y angioplastías",null,null,150000,null,"Corazón",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Corazón y Pulmón (simultáneamente)",null,300000]
[null,null,null,null,null,"Tratamiento de cáncer",null,null,200000,null,"Pulmón",null,250000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Pancreas",null,250000]
[null,null,null,null,null,"Trauma grave (Politraumatismos)",null,null,150000,null,"Pancreas y Riñón (simultáneamente)",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Riñón",null,200000]
[null,null,null,null,null,"Insuficiencia renal crónica (Diálisis)",null,null,100000,null,"Hígado",null,200000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Médula ósea",null,250000]
[null,null,null,null,null,"Quemaduras graves ",null,null,300000,null,"La cobertura de trasplante de órganos está limitada a la Red de Proveedores para Procedimiento de Trasplante de la Compañía y no se proporcionará cobertura en proveedores fuera de esta Red especializada."]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[null,null,null,null,null,"Desorden infeccioso grave (Septicemia)",null,null,150000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[null,null,null,null,null,"Fuera del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima por plan individual :",null,{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,3,TRUE)),0)","v":2320},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,6,TRUE)),0)","v":1879},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,9,TRUE)),0)","v":1640},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,12,TRUE)),0)","v":1304},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,15,TRUE)),0)","v":980},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,18,TRUE)),0)","v":613}]
[null,null,null,null,null,"Prima por plan para 2 personas :",null,{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,4,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,7,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,10,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,13,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,16,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,19,TRUE)),0)","v":0}]
[null,null,null,null,null,"Prima por plan familiar :",null,{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,5,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,8,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,11,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,14,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,17,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,20,TRUE)),0)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":2320},{"$f":"SUM(I44:I46)","v":1879},1640,1304,980,613]
[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":2395},1954,1715,1379,1055,688]
[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":[[39,0,41,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],[13,2,13,7],[15,2,15,7],[19,0,19,1],[18,0,18,1],[11,2,11,7]]}
[]
[null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null," "," "," "," "]
[]
[]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - BUPA CARE "]
[]
[null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":18}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2023-08-16T10:37:45.530"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":0},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null," "," "," "]
["Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
["Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
["PRODUCTOS",null,"Tarifas Anuales"]
["Bupa Exclusive Care",null,"n/a",{"$f":"+Exclusive!I37","v":10994},{"$f":"+Exclusive!J37","v":7288},{"$f":"+Exclusive!K37","v":5489},{"$f":"+Exclusive!L37","v":3983},{"$f":"+Exclusive!M37","v":3196}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":9214},{"$f":"+Privilege!J37","v":6361},{"$f":"+Privilege!K37","v":4791},{"$f":"+Privilege!L37","v":3485},{"$f":"+Privilege!M37","v":2723}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":6513},{"$f":"+'Advantage (Mundial)'!J38","v":5045},{"$f":"+'Advantage (Mundial)'!K38","v":4004},{"$f":"+'Advantage (Mundial)'!L38","v":3211},{"$f":"+'Advantage (Mundial)'!M38","v":2668}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":4833},{"$f":"+Secure!J38","v":3921},{"$f":"+Secure!K38","v":3151},{"$f":"+Secure!L38","v":2768},{"$f":"+Secure!M38","v":2244}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":3931},{"$f":"+Essential!J38","v":3165},{"$f":"+Essential!K38","v":2515},{"$f":"+Essential!L38","v":2189},{"$f":"+Essential!M38","v":1756}]
[]
["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":2395},{"$f":"+Critical!I49","v":1954},{"$f":"+Critical!J49","v":1715},{"$f":"+Critical!K49","v":1379},{"$f":"+Critical!L49","v":1055},{"$f":"+Critical!M49","v":688}]
["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,3,6],[67,0,71,0],[54,0,56,0],[55,1,56,1],[55,2,56,2],[55,3,56,3],[57,0,58,0],[59,0,60,0],[61,0,63,0],[61,1,63,1],[61,2,63,2],[62,3,63,3],[4,1,4,6],[61,6,63,6],[69,4,71,4],[69,5,71,5],[68,6,71,6],[55,4,56,4],[55,5,56,5],[62,4,63,4],[62,5,63,5]]}
["2023 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":551,"n_cols":20,"rows_kept":551,"cut":false,"hidden":true,"merged":[[540,14,540,16],[540,17,540,19],[547,14,547,16],[547,17,547,19],[545,0,545,19],[540,2,540,4],[547,2,547,4],[547,5,547,7],[547,8,547,10],[546,0,546,1],[546,2,546,6],[540,5,540,7],[540,8,540,10],[547,11,547,13],[540,11,540,13],[539,0,539,1],[471,0,471,7],[472,0,472,1],[472,2,472,6],[504,0,504,7],[505,0,505,1],[505,2,505,6],[538,0,538,19],[537,0,537,19],[539,2,539,6],[304,2,304,6],[336,0,336,7],[437,0,437,7],[438,0,438,1],[438,2,438,6],[304,0,304,1],[370,0,370,7],[371,0,371,1],[371,2,371,6],[337,0,337,7],[338,0,338,1],[338,2,338,6],[470,0,470,7],[403,0,403,7],[404,0,404,7],[405,0,405,1],[405,2,405,6],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[303,0,303,7],[269,0,269,7],[270,0,270,7],[271,0,271,1],[271,2,271,6],[170,2,170,6],[202,0,202,7],[236,0,236,7],[237,0,237,1],[237,2,237,6],[204,0,204,1],[204,2,204,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6],[554,17,554,19],[554,2,554,4],[554,5,554,7],[554,8,554,10],[554,11,554,13],[554,14,554,16]]}
[]
["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,10919,7213,5189,3683,2896,null,0,0,0,0,0]
[25,"25-29",null,11452,7970,5751,4083,3207,null,0,0,0,0,0]
[30,"30-34",null,11915,8551,6437,4895,3860,null,0,0,0,0,0]
[35,"35-39",null,13345,9573,7218,5487,4323,null,0,0,0,0,0]
[40,"40-44",null,15472,10474,8008,6033,4753,null,0,0,0,0,0]
[45,"45-49",null,17300,11710,8956,6737,5313,null,0,0,0,0,0]
[50,"50-54",null,22135,15362,11683,9524,7508,null,0,0,0,0,0]
[55,"55-59",null,23553,16351,12427,10133,7994,null,0,0,0,0,0]
[60,"60",null,25660,17835,14303,12210,9928,null,0,0,0,0,0]
[61,"61",null,27564,19168,15361,13124,10672,null,0,0,0,0,0]
[62,"62",null,30179,20994,16832,14366,11683,null,0,0,0,0,0]
[63,"63",null,32092,22321,17885,15282,12422,null,0,0,0,0,0]
[64,"64",null,34712,24153,19356,16528,13446,null,0,0,0,0,0]
[65,"65",null,45381,31500,24472,22042,18960,null,0,0,0,0,0]
[66,"66",null,52719,36607,28436,25626,22032,null,0,0,0,0,0]
[67,"67",null,57588,39982,31061,27979,24066,null,0,0,0,0,0]
[68,"68",null,63764,44265,34398,30992,26648,null,0,0,0,0,0]
[69,"69",null,70157,48701,37848,34094,29323,null,0,0,0,0,0]
[70,"70",null,86345,59307,44553,39730,34495,null,0,0,0,0,0]
[71,"71",null,89739,61635,46306,41294,35854,null,0,0,0,0,0]
[72,"72",null,92280,63380,47609,42463,36865,null,0,0,0,0,0]
[73,"73",null,95669,65712,49356,44022,38216,null,0,0,0,0,0]
[74,"74",null,97360,66869,50240,44806,38895,null,0,0,0,0,0]
[75,"75+",null,101602,69781,52419,46754,40594,null,0,0,0,0,0]
[1,"1 Child",null,3795,2796,2320,1958,1526,null,0,0,0,0,0]
[2,"2 Children",null,6037,4450,3693,3104,2422,null,0,0,0,0,0]
[3,"3+ Children",null,8845,6519,5408,4553,3549,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":5787.0700000000006},{"$f":"$L$2*E6","v":3822.8900000000003},2750.17,1951.99,1534.88,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D7","v":6069.56},4224.1000000000004,3048.03,2163.9900000000002,1699.71,null,0,0,0,0,0]
[30,"30-34",null,6314.9500000000007,4532.0300000000007,3411.61,2594.35,2045.8000000000002,null,0,0,0,0,0]
[35,"35-39",null,7072.85,5073.6900000000005,3825.5400000000004,2908.11,2291.19,null,0,0,0,0,0]
[40,"40-44",null,8200.16,5551.22,4244.24,3197.4900000000002,2519.09,null,0,0,0,0,0]
[45,"45-49",null,9169,6206.3,4746.68,3570.61,2815.8900000000003,null,0,0,0,0,0]
[50,"50-54",null,11731.550000000001,8141.8600000000006,6191.9900000000007,5047.72,3979.2400000000002,null,0,0,0,0,0]
[55,"55-59",null,12483.09,8666.0300000000007,6586.31,5370.4900000000007,4236.8200000000006,null,0,0,0,0,0]
[60,"60",null,13599.800000000001,9452.5500000000011,7580.59,6471.3,5261.84,null,0,0,0,0,0]
[61,"61",null,14608.92,10159.040000000001,8141.3300000000008,6955.72,5656.16,null,0,0,0,0,0]
[62,"62",null,15994.87,11126.82,8920.9600000000009,7613.9800000000005,6191.9900000000007,null,0,0,0,0,0]
[63,"63",null,17008.760000000002,11830.130000000001,9479.0500000000011,8099.46,6583.6600000000008,null,0,0,0,0,0]
[64,"64",null,18397.36,12801.09,10258.68,8759.84,7126.38,null,0,0,0,0,0]
[65,"65",null,24051.93,16695,12970.16,11682.26,10048.800000000001,null,0,0,0,0,0]
[66,"66",null,27941.07,19401.710000000003,15071.08,13581.78,11676.960000000001,null,0,0,0,0,0]
[67,"67",null,30521.640000000003,21190.460000000003,16462.330000000002,14828.87,12754.980000000001,null,0,0,0,0,0]
[68,"68",null,33794.92,23460.45,18230.940000000002,16425.760000000002,14123.44,null,0,0,0,0,0]
[69,"69",null,37183.21,25811.530000000002,20059.440000000002,18069.82,{"$f":"$L$2*H23","v":15541.19},null,0,0,0,0,0]
[70,"70",null,45762.850000000006,31432.710000000003,23613.09,21056.9,18282.350000000002,null,0,0,0,0,0]
[71,"71",null,47561.670000000006,32666.550000000003,24542.18,21885.82,19002.620000000003,null,0,0,0,0,0]
[72,"72",null,48908.4,33591.4,25232.77,22505.39,19538.45,null,0,0,0,0,0]
[73,"73",null,50704.57,34827.360000000001,26158.68,23331.66,20254.48,null,0,0,0,0,0]
[74,"74",null,51600.800000000003,35440.57,26627.200000000001,23747.18,20614.350000000002,null,0,0,0,0,0]
[75,"75+",null,53849.060000000005,36983.93,27782.07,24779.620000000003,21514.82,null,0,0,0,0,0]
[1,"1 Child",null,2011.3500000000001,1481.88,1229.6000000000001,1037.74,808.78000000000009,null,0,0,0,0,0]
[2,"2 Children",null,3199.61,2358.5,1957.2900000000002,1645.1200000000001,1283.6600000000001,null,0,0,0,0,0]
[3,"3+ Children",null,4687.8500000000004,3455.07,2866.2400000000002,2413.09,1880.97,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D33*$L$2","v":0},0,119.25,119.25,119.25]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["DIAMOND (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["PRIVILEGE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6",null,2,6,10,14,18]
[18,"18-24",null,9139,6286,4491,3185,2423,null,0,0,0,0,0]
[25,"25-29",null,9590,6953,4972,3528,2687,null,0,0,0,0,0]
[30,"30-34",null,10019,7436,5580,4262,3262,null,0,0,0,0,0]
[35,"35-39",null,11212,8323,6252,4783,3649,null,0,0,0,0,0]
[40,"40-44",null,12981,9128,6953,5272,4028,null,0,0,0,0,0]
[45,"45-49",null,14506,10203,7768,5895,4505,null,0,0,0,0,0]
[50,"50-54",null,18959,13460,10199,8404,6426,null,0,0,0,0,0]
[55,"55-59",null,20166,14312,10852,8944,6840,null,0,0,0,0,0]
[60,"60",null,21964,15540,12353,10637,8551,null,0,0,0,0,0]
[61,"61",null,23598,16696,13267,11432,9182,null,0,0,0,0,0]
[62,"62",null,25829,18287,14530,12518,10056,null,0,0,0,0,0]
[63,"63",null,27465,19439,15448,13313,10689,null,0,0,0,0,0]
[64,"64",null,29705,21036,16719,14403,11567,null,0,0,0,0,0]
[65,"65",null,38836,27429,21132,19201,16304,null,0,0,0,0,0]
[66,"66",null,45115,31872,24549,22316,18943,null,0,0,0,0,0]
[67,"67",null,49272,34810,26814,24364,20695,null,0,0,0,0,0]
[68,"68",null,54555,38540,29695,26984,22911,null,0,0,0,0,0]
[69,"69",null,60025,42399,32665,29684,25213,null,0,0,0,0,0]
[70,"70",null,73871,51627,38453,34595,29648,null,0,0,0,0,0]
[71,"71",null,76773,53650,39960,35950,30820,null,0,0,0,0,0]
[72,"72",null,78950,55169,41093,36967,31688,null,0,0,0,0,0]
[73,"73",null,81842,57198,42600,38328,32859,null,0,0,0,0,0]
[74,"74",null,83293,58210,43356,39009,33438,null,0,0,0,0,0]
[75,"75+",null,86920,60744,45243,40706,34887,null,0,0,0,0,0]
[1,"1 Child",null,3169,2317,1825,1543,1141,null,0,0,0,0,0]
[2,"2 Children",null,5036,3686,2907,2450,1814,null,0,0,0,0,0]
[3,"3+ Children",null,7389,5401,4258,3584,2657,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":4843.67},{"$f":"$L$2*E140","v":3331.5800000000004},2380.23,1688.0500000000002,1284.19,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D141","v":5082.7},3685.09,2635.1600000000003,1869.8400000000001,1424.1100000000001,null,0,0,0,0,0]
[30,"30-34",null,5310.0700000000006,3941.0800000000004,2957.4,2258.86,1728.8600000000001,null,0,0,0,0,0]
[35,"35-39",null,5942.3600000000006,4411.1900000000005,3313.56,2534.9900000000002,{"$f":"$L$2*H143","v":1933.97},null,0,0,0,0,0]
[40,"40-44",null,6879.93,4837.84,3685.09,2794.1600000000003,2134.84,null,0,0,0,0,0]
[45,"45-49",null,7688.18,5407.59,4117.04,3124.3500000000004,2387.65,null,0,0,0,0,0]
[50,"50-54",null,10048.27,7133.8,5405.47,4454.12,3405.78,null,0,0,0,0,0]
[55,"55-59",null,10687.980000000001,7585.3600000000006,5751.56,4740.3200000000006,3625.2000000000003,null,0,0,0,0,0]
[60,"60",null,11640.92,8236.2000000000007,6547.09,5637.6100000000006,4532.0300000000007,null,0,0,0,0,0]
[61,"61",null,12506.94,8848.880000000001,7031.51,6058.96,4866.46,null,0,0,0,0,0]
[62,"62",null,13689.37,9692.11,7700.9000000000005,6634.54,5329.68,null,0,0,0,0,0]
[63,"63",null,14556.45,{"$f":"$L$2*E151","v":10302.67},8187.4400000000005,7055.89,5665.17,null,0,0,0,0,0]
[64,"64",null,15743.650000000001,11149.08,8861.07,7633.59,6130.51,null,0,0,0,0,0]
[65,"65",null,20583.080000000002,14537.37,11199.960000000001,10176.530000000001,8641.1200000000008,null,0,0,0,0,0]
[66,"66",null,23910.95,16892.16,13010.970000000001,11827.480000000001,10039.790000000001,null,0,0,0,0,0]
[67,"67",null,{"$f":"$L$2*D155","v":26114.16},18449.3,14211.42,12912.92,10968.35,null,0,0,0,0,0]
[68,"68",null,28914.15,20426.2,15738.35,14301.52,12142.83,null,0,0,0,0,0]
[69,"69",null,31813.25,22471.47,17312.45,15732.52,13362.890000000001,null,0,0,0,0,0]
[70,"70",null,39151.630000000005,27362.31,20380.09,18335.350000000002,15713.44,null,0,0,0,0,0]
[71,"71",null,40689.69,28434.5,21178.799999999999,19053.5,16334.6,null,0,0,0,0,0]
[72,"72",null,41843.5,29239.57,21779.29,19592.510000000002,16794.64,null,0,0,0,0,0]
[73,"73",null,43376.26,30314.940000000002,22578,20313.84,17415.27,null,0,0,0,0,0]
[74,"74",null,44145.29,30851.300000000003,22978.68,20674.77,17722.14,null,0,0,0,0,0]
[75,"75+",null,46067.600000000006,32194.320000000003,23978.79,21574.18,18490.11,null,0,0,0,0,0]
[1,"1 Child",null,1679.5700000000002,1228.01,967.25,817.79000000000008,604.73,null,0,0,0,0,0]
[2,"2 Children",null,2669.08,1953.5800000000002,1540.71,1298.5,961.42000000000007,null,0,0,0,0,0]
[3,"3+ Children",null,3916.17,2862.53,2256.7400000000002,1899.52,1408.21,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D167*$L$2","v":0},0,119.25,119.25,119.25]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["COMPLETE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," "]
[18,"-  24"]
[25,"-  29"]
[30,"-  34"]
[35,"-  39"]
[40,"-  44"]
[45,"-  49"]
[50,"-  54"]
[55,"-  59"]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75,"o más"]
[1,"Hijo"]
[2,"Hijos"]
[3,"Hijos o más"]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["ADVANTAGE (WORLDWIDE)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6",null,6,10,14,18,22]
[18,"18-24",null,5913,4445,3404,2611,2068,null,0,0,0,0,0]
[25,"25-29",null,6574,4954,3787,2916,2299,null,0,0,0,0,0]
[30,"30-34",null,7610,5826,4500,3451,2663,null,0,0,0,0,0]
[35,"35-39",null,8442,6486,5005,3934,2949,null,0,0,0,0,0]
[40,"40-44",null,9526,7348,5672,4393,3341,null,0,0,0,0,0]
[45,"45-49",null,11068,8467,6401,5004,3879,null,0,0,0,0,0]
[50,"50-54",null,12124,9516,7456,5614,4258,null,0,0,0,0,0]
[55,"55-59",null,14325,10984,8247,6502,5037,null,0,0,0,0,0]
[60,"60",null,15828,12164,9065,7175,5575,null,0,0,0,0,0]
[61,"61",null,17812,13688,10209,8075,6280,null,0,0,0,0,0]
[62,"62",null,19800,15212,11349,8977,6977,null,0,0,0,0,0]
[63,"63",null,21781,16742,12484,9883,7680,null,0,0,0,0,0]
[64,"64",null,23761,18264,13625,10786,8380,null,0,0,0,0,0]
[65,"65",null,25691,19880,14852,11747,9540,null,0,0,0,0,0]
[66,"66",null,27202,21053,15728,12438,10104,null,0,0,0,0,0]
[67,"67",null,30229,23391,17477,13826,11226,null,0,0,0,0,0]
[68,"68",null,33260,25741,19233,15207,12356,null,0,0,0,0,0]
[69,"69",null,34771,26906,20107,15901,12923,null,0,0,0,0,0]
[70,"70",null,35222,27340,20414,16199,13087,null,0,0,0,0,0]
[71,"71",null,39628,30764,22965,18232,14731,null,0,0,0,0,0]
[72,"72",null,44042,34181,25520,20259,16373,null,0,0,0,0,0]
[73,"73",null,48448,37604,28072,22290,18008,null,0,0,0,0,0]
[74,"74",null,52859,41029,30638,24327,19648,null,0,0,0,0,0]
[75,"75+",null,57826,45764,35137,26627,22552,null,0,0,0,0,0]
[1,"1 Child",null,2635,1878,1486,1314,946,null,0,0,0,0,0]
[2,"2 Children",null,4288,2960,2342,2081,1393,null,0,0,0,0,0]
[3,"3+ Children",null,6275,4311,3413,3013,2115,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":"$L$2*D274","v":3133.8900000000003},{"$f":"$L$2*E274","v":2355.85},1804.1200000000001,1383.8300000000002,1096.04,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D275","v":3484.2200000000003},2625.6200000000003,2007.1100000000001,1545.48,1218.47,null,0,0,0,0,0]
[30,"30-34",null,4033.3,3087.78,2385,1829.0300000000002,1411.39,null,0,0,0,0,0]
[35,"35-39",null,4474.26,3437.5800000000004,2652.65,2085.02,1562.97,null,0,0,0,0,0]
[40,"40-44",null,{"$f":"$L$2*D278","v":5048.7800000000007},3894.44,3006.1600000000003,2328.29,1770.73,null,0,0,0,0,0]
[45,"45-49",null,5866.04,4487.51,3392.53,2652.1200000000003,2055.87,null,0,0,0,0,0]
[50,"50-54",null,6425.72,5043.4800000000005,3951.6800000000003,2975.42,2256.7400000000002,null,0,0,0,0,0]
[55,"55-59",null,7592.25,5821.52,4370.91,3446.0600000000004,2669.61,null,0,0,0,0,0]
[60,"60",null,8388.84,6446.92,4804.45,3802.75,{"$f":"$L$2*H282","v":2954.75},null,0,0,0,0,0]
[61,"61",null,9440.36,7254.64,5410.77,4279.75,3328.4,null,0,0,0,0,0]
[62,"62",null,10494,8062.3600000000006,6014.97,4757.8100000000004,3697.8100000000004,null,0,0,0,0,0]
[63,"63",null,11543.93,8873.26,6616.52,5237.9900000000007,4070.4,null,0,0,0,0,0]
[64,"64",null,12593.33,9679.92,7221.25,5716.58,4441.4000000000005,null,0,0,0,0,0]
[65,"65",null,13616.230000000001,10536.4,7871.56,6225.9100000000008,5056.2,null,0,0,0,0,0]
[66,"66",null,14417.060000000001,11158.09,8335.84,6592.14,5355.12,null,0,0,0,0,0]
[67,"67",null,16021.37,12397.230000000001,9262.8100000000013,7327.7800000000007,5949.7800000000007,null,0,0,0,0,0]
[68,"68",null,17627.8,13642.730000000001,10193.49,8059.71,6548.68,null,0,0,0,0,0]
[69,"69",null,18428.63,14260.18,10656.710000000001,8427.5300000000007,6849.1900000000005,null,0,0,0,0,0]
[70,"70",null,18667.66,14490.2,10819.42,8585.4700000000012,6936.1100000000006,null,0,0,0,0,0]
[71,"71",null,21002.84,16304.92,12171.45,9662.9600000000009,7807.43,null,0,0,0,0,0]
[72,"72",null,23342.260000000002,18115.93,13525.6,10737.27,8677.69,null,0,0,0,0,0]
[73,"73",null,25677.440000000002,19930.120000000003,14878.16,11813.7,9544.24,null,0,0,0,0,0]
[74,"74",null,28015.27,21745.370000000003,16238.140000000001,12893.310000000001,10413.44,null,0,0,0,0,0]
[75,"75+",null,30647.780000000002,24254.920000000002,18622.61,14112.310000000001,11952.560000000001,null,0,0,0,0,0]
[1,"1 Child",null,1396.5500000000002,995.34,787.58,696.42000000000007,501.38000000000005,null,0,0,0,0,0]
[2,"2 Children",null,2272.6400000000003,1568.8000000000002,1241.26,1102.93,{"$f":"$L$2*H299","v":738.29000000000008},null,0,0,0,0,0]
[3,"3+ Children",null,3325.75,2284.83,1808.89,1596.89,1120.95,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D301*$L$2","v":119.25},119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,159,159,159,159,159]
[]
["ADVANTAGE (LATINAMERICA ONLY)"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,null,null,null,null,null,null,6,10,14,18,22]
[18,"18-24",null,4381,3291,2519,1924,1520,null,0,0,0,0,0]
[25,"25-29",null,4868,3666,2795,2145,1687,null,0,0,0,0,0]
[30,"30-34",null,5644,4314,3330,2547,1963,null,0,0,0,0,0]
[35,"35-39",null,6258,4804,3707,2908,2177,null,0,0,0,0,0]
[40,"40-44",null,7061,5450,4203,3251,2471,null,0,0,0,0,0]
[45,"45-49",null,8210,6274,4745,3701,2873,null,0,0,0,0,0]
[50,"50-54",null,8997,7059,5528,4166,3154,null,0,0,0,0,0]
[55,"55-59",null,10628,8155,6119,4822,3728,null,0,0,0,0,0]
[60,"60",null,11750,9031,6734,5319,4128,null,0,0,0,0,0]
[61,"61",null,13225,10161,7578,5990,4647,null,0,0,0,0,0]
[62,"62",null,14702,11295,8425,6666,5169,null,0,0,0,0,0]
[63,"63",null,16177,12432,9279,7336,5699,null,0,0,0,0,0]
[64,"64",null,17649,13565,10123,8008,6221,null,0,0,0,0,0]
[65,"65",null,19079,14765,11037,8728,7080,null,0,0,0,0,0]
[66,"66",null,20209,15637,11690,9236,7507,null,0,0,0,0,0]
[67,"67",null,22464,17377,12998,10270,8342,null,0,0,0,0,0]
[68,"68",null,24714,19121,14297,11306,9182,null,0,0,0,0,0]
[69,"69",null,25839,19992,14944,11822,9603,null,0,0,0,0,0]
[70,"70",null,26178,20309,15175,12043,9728,null,0,0,0,0,0]
[71,"71",null,29452,22860,17080,13557,10950,null,0,0,0,0,0]
[72,"72",null,32732,25398,18990,15068,12165,null,0,0,0,0,0]
[73,"73",null,36010,27946,20886,16580,13386,null,0,0,0,0,0]
[74,"74",null,39290,30490,22789,18087,14616,null,0,0,0,0,0]
[75,"75+",null,42982,34008,26142,19805,16770,null,0,0,0,0,0]
[1,"1 Child",null,1960,1396,1103,975,712,null,0,0,0,0,0]
[2,"2 Children",null,3188,2201,1740,1548,1041,null,0,0,0,0,0]
[3,"3+ Children",null,4662,3207,2545,2243,1575,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,null,null,null,null,null,null,7,11,15,19,23]
[18,"18-24",null,{"$f":"$L$2*D341","v":2321.9300000000003},{"$f":"$L$2*E341","v":1744.23},1335.0700000000002,1019.72,805.6,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D342","v":2580.04},1942.98,1481.3500000000001,1136.8500000000001,894.11,null,0,0,0,0,0]
[30,"30-34",null,2991.32,2286.42,1764.9,1349.91,1040.3900000000001,null,0,0,0,0,0]
[35,"35-39",null,3316.7400000000002,2546.1200000000003,1964.71,1541.24,1153.81,null,0,0,0,0,0]
[40,"40-44",null,3742.3300000000004,2888.5,2227.59,1723.0300000000002,1309.6300000000001,null,0,0,0,0,0]
[45,"45-49",null,4351.3,3325.2200000000003,2514.85,1961.5300000000002,1522.69,null,0,0,0,0,0]
[50,"50-54",null,4768.41,3741.27,2929.84,2207.98,1671.6200000000001,null,0,0,0,0,0]
[55,"55-59",null,5632.84,4322.1500000000005,3243.07,2555.6600000000003,1975.8400000000001,null,0,0,0,0,0]
[60,"60",null,6227.5,4786.43,3569.02,2819.07,2187.84,null,0,0,0,0,0]
[61,"61",null,7009.25,5385.33,4016.34,3174.7000000000003,2462.9100000000003,null,0,0,0,0,0]
[62,"62",null,7792.06,5986.35,4465.25,3532.98,2739.57,null,0,0,0,0,0]
[63,"63",null,8573.8100000000013,6588.96,4917.87,3888.0800000000004,3020.4700000000003,null,0,0,0,0,0]
[64,"64",null,9353.9700000000012,7189.4500000000007,5365.1900000000005,4244.24,3297.13,null,0,0,0,0,0]
[65,"65",null,10111.870000000001,7825.4500000000007,5849.6100000000006,4625.84,3752.4,null,0,0,0,0,0]
[66,"66",null,10710.77,8287.61,6195.7000000000007,4895.08,3978.71,null,0,0,0,0,0]
[67,"67",null,11905.92,9209.8100000000013,6888.9400000000005,5443.1,4421.26,null,0,0,0,0,0]
[68,"68",null,13098.42,10134.130000000001,7577.4100000000008,5992.18,4866.46,null,0,0,0,0,0]
[69,"69",null,13694.67,10595.76,7920.3200000000006,6265.6600000000008,5089.59,null,0,0,0,0,0]
[70,"70",null,13874.34,10763.77,8042.75,6382.79,5155.84,null,0,0,0,0,0]
[71,"71",null,15609.560000000001,12115.800000000001,9052.4,7185.21,5803.5,null,0,0,0,0,0]
[72,"72",null,17347.96,13460.94,10064.700000000001,7986.04,6447.4500000000007,null,0,0,0,0,0]
[73,"73",null,19085.3,14811.380000000001,11069.58,8787.4,7094.58,null,0,0,0,0,0]
[74,"74",null,20823.7,16159.7,12078.17,9586.11,7746.4800000000005,null,0,0,0,0,0]
[75,"75+",null,22780.460000000003,18024.240000000002,13855.26,10496.65,8888.1,null,0,0,0,0,0]
[1,"1 Child",null,1038.8,739.88,584.59,516.75,377.36,null,0,0,0,0,0]
[2,"2 Children",null,1689.64,1166.53,922.2,820.44,551.73,null,0,0,0,0,0]
[3,"3+ Children",null,2470.86,1699.71,1348.8500000000001,1188.79,834.75,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["SECURE"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6",null,6,10,14,18,22]
[18,"18-24",null,4233,3321,2551,2168,1644,null,0,0,0,0,0]
[25,"25-29",null,4671,3746,2844,2416,1829,null,0,0,0,0,0]
[30,"30-34",null,5353,4399,3301,2808,2119,null,0,0,0,0,0]
[35,"35-39",null,5893,4914,3674,3117,2346,null,0,0,0,0,0]
[40,"40-44",null,6607,5606,4150,3522,2651,null,0,0,0,0,0]
[45,"45-49",null,7602,6579,4830,4093,3077,null,0,0,0,0,0]
[50,"50-54",null,8298,7241,5297,4491,3366,null,0,0,0,0,0]
[55,"55-59",null,9751,8642,6283,5327,3984,null,0,0,0,0,0]
[60,"60",null,10205,9240,6651,5635,4216,null,0,0,0,0,0]
[61,"61",null,11496,10397,7487,6345,4748,null,0,0,0,0,0]
[62,"62",null,12775,11560,8332,7054,5282,null,0,0,0,0,0]
[63,"63",null,14052,12719,9164,7766,5817,null,0,0,0,0,0]
[64,"64",null,15343,13878,10003,8474,6348,null,0,0,0,0,0]
[65,"65",null,15352,14011,10062,8521,6369,null,0,0,0,0,0]
[66,"66",null,15369,14145,10118,8563,6389,null,0,0,0,0,0]
[67,"67",null,17090,15724,11245,9526,7106,null,0,0,0,0,0]
[68,"68",null,18798,17292,12378,10481,7827,null,0,0,0,0,0]
[69,"69",null,19658,18074,12943,10954,8184,null,0,0,0,0,0]
[70,"70",null,19691,18383,13073,11064,8223,null,0,0,0,0,0]
[71,"71",null,22159,20691,14718,12454,9261,null,0,0,0,0,0]
[72,"72",null,24629,22999,16362,13841,10290,null,0,0,0,0,0]
[73,"73",null,27097,25295,17999,15230,11326,null,0,0,0,0,0]
[74,"74",null,29563,27599,19642,16620,12361,null,0,0,0,0,0]
[75,"75+",null,32222,30273,21476,18178,13510,null,0,0,0,0,0]
[1,"1 Child",null,2043,1203,1032,871,641,null,0,0,0,0,0]
[2,"2 Children",null,3441,1799,1618,1373,1017,null,0,0,0,0,0]
[3,"3+ Children",null,5057,2582,2351,1988,1468,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":"$L$2*D408","v":2243.4900000000002},{"$f":"$L$2*E408","v":1760.13},1352.03,1149.04,871.32,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D409","v":2475.63},1985.38,1507.3200000000002,1280.48,969.37,null,0,0,0,0,0]
[30,"30-34",null,2837.09,2331.4700000000003,1749.5300000000002,1488.24,1123.0700000000002,null,0,0,0,0,0]
[35,"35-39",null,3123.29,2604.42,1947.22,1652.01,1243.3800000000001,null,0,0,0,0,0]
[40,"40-44",null,3501.71,2971.1800000000003,2199.5,1866.66,1405.03,null,0,0,0,0,0]
[45,"45-49",null,4029.0600000000004,3486.8700000000003,2559.9,2169.29,1630.8100000000002,null,0,0,0,0,0]
[50,"50-54",null,4397.9400000000005,3837.73,2807.4100000000003,2380.23,1783.98,null,0,0,0,0,0]
[55,"55-59",null,5168.0300000000007,4580.26,3329.9900000000002,2823.31,2111.52,null,0,0,0,0,0]
[60,"60",null,5408.6500000000005,4897.2,3525.03,2986.55,2234.48,null,0,0,0,0,0]
[61,"61",null,6092.88,{"$f":"$L$2*E417","v":5510.41},3968.11,3362.8500000000004,2516.44,null,0,0,0,0,0]
[62,"62",null,6770.75,6126.8,4415.96,3738.6200000000003,{"$f":"$L$2*H418","v":2799.46},null,0,0,0,0,0]
[63,"63",null,7447.56,6741.0700000000006,4856.92,4115.9800000000005,{"$f":"$L$2*H419","v":3083.01},null,0,0,0,0,0]
[64,"64",null,8131.79,7355.34,5301.59,4491.22,3364.44,null,0,0,0,0,0]
[65,"65",null,8136.56,7425.83,5332.8600000000006,4516.13,3375.57,null,0,0,0,0,0]
[66,"66",null,8145.5700000000006,7496.85,5362.54,4538.3900000000003,3386.17,null,0,0,0,0,0]
[67,"67",null,9057.7000000000007,8333.7200000000012,5959.85,5048.7800000000007,3766.1800000000003,null,0,0,0,0,0]
[68,"68",null,9962.94,9164.76,6560.34,5554.93,4148.3100000000004,null,0,0,0,0,0]
[69,"69",null,10418.74,9579.2200000000012,{"$f":"$L$2*F425","v":6859.79},5805.62,4337.5200000000004,null,0,0,0,0,0]
[70,"70",null,10436.230000000001,9742.99,6928.6900000000005,5863.92,4358.1900000000005,null,0,0,0,0,0]
[71,"71",null,11744.27,10966.230000000001,7800.54,6600.62,4908.33,null,0,0,0,0,0]
[72,"72",null,13053.37,12189.470000000001,8671.86,7335.7300000000005,5453.7000000000007,null,0,0,0,0,0]
[73,"73",null,14361.41,13406.35,9539.4700000000012,8071.9000000000005,6002.7800000000007,null,0,0,0,0,0]
[74,"74",null,15668.390000000001,14627.470000000001,10410.26,8808.6,6551.33,null,0,0,0,0,0]
[75,"75+",null,17077.66,16044.69,11382.28,9634.34,7160.3,null,0,0,0,0,0]
[1,"1 Child",null,1082.79,637.59,546.96,461.63,339.73,null,0,0,0,0,0]
[2,"2 Children",null,1823.73,953.47,857.54000000000008,727.69,539.01,null,0,0,0,0,0]
[3,"3+ Children",null,2680.21,1368.46,1246.03,1053.6400000000001,778.04000000000008,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,3556,2790,2140,1814,1381,null,0,0,0,0,0]
[25,"25-29",null,3922,3142,2387,2030,1533,null,0,0,0,0,0]
[30,"30-34",null,4497,3691,2773,2355,1773,null,0,0,0,0,0]
[35,"35-39",null,4958,4135,3084,2616,1971,null,0,0,0,0,0]
[40,"40-44",null,5554,4718,3481,2958,2225,null,0,0,0,0,0]
[45,"45-49",null,6396,5532,4066,3444,2586,null,0,0,0,0,0]
[50,"50-54",null,6981,6094,4455,3782,2828,null,0,0,0,0,0]
[55,"55-59",null,8200,7276,5283,4473,3348,null,0,0,0,0,0]
[60,"60",null,8586,7774,5594,4738,3543,null,0,0,0,0,0]
[61,"61",null,9668,8754,6301,5332,3992,null,0,0,0,0,0]
[62,"62",null,10754,9728,7006,5934,4443,null,0,0,0,0,0]
[63,"63",null,11833,10709,7713,6530,4890,null,0,0,0,0,0]
[64,"64",null,12906,11683,8419,7133,5340,null,0,0,0,0,0]
[65,"65",null,12925,11798,8471,7167,5358,null,0,0,0,0,0]
[66,"66",null,12936,11909,8523,7206,5381,null,0,0,0,0,0]
[67,"67",null,14385,13235,9470,8015,5980,null,0,0,0,0,0]
[68,"68",null,15825,14563,10417,8819,6588,null,0,0,0,0,0]
[69,"69",null,16549,15221,10900,9223,6887,null,0,0,0,0,0]
[70,"70",null,16576,15489,11011,9311,6925,null,0,0,0,0,0]
[71,"71",null,18651,17426,12391,10487,7798,null,0,0,0,0,0]
[72,"72",null,20738,19362,13774,11654,8657,null,0,0,0,0,0]
[73,"73",null,22811,21302,15155,12822,9533,null,0,0,0,0,0]
[74,"74",null,24894,23244,16534,13994,10404,null,0,0,0,0,0]
[75,"75+",null,27128,25493,18088,15301,11369,null,0,0,0,0,0]
[1,"1 Child",null,1722,1020,870,731,540,null,0,0,0,0,0]
[2,"2 Children",null,2902,1512,1363,1153,858,null,0,0,0,0,0]
[3,"3+ Children",null,4259,2175,1987,1672,1239,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":"$L$2*D475","v":1884.68},{"$f":"$L$2*E475","v":1478.7},1134.2,961.42000000000007,731.93000000000006,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D476","v":2078.6600000000003},1665.26,1265.1100000000001,1075.9000000000001,812.49,null,0,0,0,0,0]
[30,"30-34",null,2383.4100000000003,1956.23,1469.69,1248.1500000000001,939.69,null,0,0,0,0,0]
[35,"35-39",null,2627.7400000000002,2191.5500000000002,1634.52,1386.48,1044.6300000000001,null,0,0,0,0,0]
[40,"40-44",null,2943.6200000000003,2500.54,1844.93,1567.74,1179.25,null,0,0,0,0,0]
[45,"45-49",null,3389.88,2931.96,2154.98,1825.3200000000002,1370.5800000000002,null,0,0,0,0,0]
[50,"50-54",null,3699.9300000000003,3229.82,2361.15,2004.46,1498.8400000000001,null,0,0,0,0,0]
[55,"55-59",null,4346,3856.28,2799.9900000000002,2370.69,1774.44,null,0,0,0,0,0]
[60,"60",null,4550.58,4120.22,2964.82,2511.1400000000003,1877.7900000000002,null,0,0,0,0,0]
[61,"61",null,5124.04,4639.62,3339.53,2825.96,2115.7600000000002,null,0,0,0,0,0]
[62,"62",null,5699.62,5155.84,3713.1800000000003,3145.02,2354.79,null,0,0,0,0,0]
[63,"63",null,6271.4900000000007,5675.77,4087.8900000000003,3460.9,2591.7000000000003,null,0,0,0,0,0]
[64,"64",null,6840.18,6191.9900000000007,4462.0700000000006,3780.4900000000002,2830.2000000000003,null,0,0,0,0,0]
[65,"65",null,6850.25,6252.9400000000005,4489.63,3798.51,2839.7400000000002,null,0,0,0,0,0]
[66,"66",null,6856.08,6311.77,4517.1900000000005,3819.1800000000003,2851.9300000000003,null,0,0,0,0,0]
[67,"67",null,7624.05,7014.55,5019.1000000000004,4247.95,3169.4,null,0,0,0,0,0]
[68,"68",null,8387.25,7718.39,5521.01,4674.0700000000006,3491.6400000000003,null,0,0,0,0,0]
[69,"69",null,8770.9700000000012,8067.13,5777,4888.1900000000005,3650.11,null,0,0,0,0,0]
[70,"70",null,8785.2800000000007,8209.17,5835.83,4934.83,3670.25,null,0,0,0,0,0]
[71,"71",null,9885.0300000000007,9235.7800000000007,6567.2300000000005,5558.1100000000006,4132.9400000000005,null,0,0,0,0,0]
[72,"72",null,10991.140000000001,10261.86,7300.22,6176.62,4588.21,null,0,0,0,0,0]
[73,"73",null,12089.83,11290.060000000001,8032.1500000000005,6795.6600000000008,5052.4900000000007,null,0,0,0,0,0]
[74,"74",null,13193.820000000002,12319.320000000002,8763.02,7416.8200000000006,5514.12,null,0,0,0,0,0]
[75,"75+",null,14377.84,13511.29,9586.6400000000012,8109.5300000000007,6025.5700000000006,null,0,0,0,0,0]
[1,"1 Child",null,912.66000000000008,540.6,461.1,387.43,286.2,null,0,0,0,0,0]
[2,"2 Children",null,1538.0600000000002,801.36,722.39,611.09,454.74,null,0,0,0,0,0]
[3,"3+ Children",null,2257.27,1152.75,1053.1100000000001,886.16000000000008,656.67000000000007,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",null,{"$f":"+D502*$L$2","v":119.25},119.25,119.25,119.25,119.25]
[1,"Transplante de organos",null,159,159,159,159,159]
[]
["CRITICAL"]
["TARIFAS ANUALES"]
["EDAD"]
[" "," ","CR1",null,null,"CR2",null,null,"CR3",null,null,"CR4",null,null,"CR5",null,null,"CR6"]
[null,null,"INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR"]
[18,"-  49",2320,4083,5846,1879,3205,4531,1640,2820,3992,1304,2184,3061,980,1577,2174,613,903,1196]
[50,"o más",2939,4697,6456,2367,3693,5012,2047,3233,4398,1607,2487,3373,1185,1782,2384,714,1004,1299]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ","CR1",null,null,"CR2",null,null,"CR3",null,null,"CR4",null,null,"CR5",null,null,"CR6"]
[null,null,"INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR","INDIVIDUAL","2 PERSONAS","FAMILIAR"]
[18,"-  25",{"$f":"+C543*$L$2","v":1229.6000000000001},2163.9900000000002,3098.38,995.87,1698.65,2401.4300000000003,869.2,1494.6000000000001,{"$f":"+K543*$L$2","v":2115.7600000000002},{"$f":"+L543*$L$2","v":691.12},1157.52,1622.3300000000002,519.4,835.81000000000006,1152.22,324.89000000000004,478.59000000000003,633.88]
[75,"o más",{"$f":"+C544*$L$2","v":1557.67},2489.4100000000003,3421.6800000000003,1254.51,1957.2900000000002,2656.36,1084.9100000000001,1713.49,2330.94,851.71,1318.1100000000001,1787.69,628.05000000000007,944.46,1263.52,378.42,532.12,688.47]