{"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:",1]
[]
[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":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[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],[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],[9,0,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],[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],[28,2,28,3],[19,0,19,1],[26,0,26,1],[21,2,21,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[25,0,25,1],[26,2,26,3],[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],[47,2,47,3],[35,0,35,1],[36,0,38,1],[36,2,38,3],[46,0,46,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa 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":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:38:41"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":17049},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":11277},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":7932},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":5639},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":4442}]
[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":17049},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,5,TRUE)))","v":11277},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,6,TRUE)))","v":7932},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,7,TRUE)))","v":5639},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,8,TRUE)))","v":4442}]
[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":5919},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":4357},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":3531},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":2972},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":2325}]
[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":40017},{"$f":"SUM(J31:J34)","v":26911},{"$f":"SUM(K31:K34)","v":19620},{"$f":"SUM(L31:L34)","v":14475},{"$f":"SUM(M31:M34)","v":11434}]
[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":40092},{"$f":"SUM(J35:J36)","v":26986},{"$f":"SUM(K35:K36)","v":19695},{"$f":"SUM(L35:L36)","v":14550},{"$f":"SUM(M35:M36)","v":11509}]
[]
[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":9035.9700000000012},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":5976.81},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":4203.96},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":2988.67},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":2354.2600000000002}]
[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":9035.9700000000012},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,5,TRUE)))","v":5976.81},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,6,TRUE)))","v":4203.96},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,7,TRUE)))","v":2988.67},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,8,TRUE)))","v":2354.2600000000002}]
[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":3137.07},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":2309.21},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":1871.43},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":1575.16},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":1232.25}]
[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":21209.010000000002},{"$f":"SUM(J40:J43)","v":14262.830000000002},{"$f":"SUM(K40:K43)","v":10398.6},{"$f":"SUM(L40:L43)","v":7671.75},{"$f":"SUM(M40:M43)","v":6060.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(I44:I45)","v":21284.010000000002},{"$f":"SUM(J44:J45)","v":14337.830000000002},{"$f":"SUM(K44:K45)","v":10473.6},{"$f":"SUM(L44:L45)","v":7746.75},{"$f":"SUM(M44:M45)","v":6135.02}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":21209.010000000002},{"$f":"J44","v":14262.830000000002},10398.6,7671.75,6060.02]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2023"]
[]
[]
[]
[null," "]
[null," "]

{"sheet":"Privilege","index":2,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"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],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[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],[44,0,44,1],[44,2,44,3],[45,0,45,1],[45,2,45,3],[35,0,35,1],[35,2,35,3],[36,0,36,1],[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],[42,0,42,1],[19,0,19,1],[17,0,18,1],[20,0,21,1],[46,0,47,1],[20,2,20,3],[22,0,23,1],[24,0,24,1],[25,2,25,3],[25,0,25,1],[27,2,27,3],[28,2,28,3],[22,2,22,3],[31,2,31,3],[26,2,26,3],[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],[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]]}
[]
[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":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:38:41"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":14336},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":9850},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":6887},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":4879},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":3717}]
[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":14336},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,5,TRUE)))","v":9850},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,6,TRUE)))","v":6887},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,7,TRUE)))","v":4879},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,8,TRUE)))","v":3717}]
[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":4978},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":3637},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":2795},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":2356},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":1741}]
[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":33650},{"$f":"SUM(J31:J34)","v":23337},{"$f":"SUM(K31:K34)","v":16794},{"$f":"SUM(L31:L34)","v":12339},{"$f":"SUM(M31:M34)","v":9400}]
[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":33725},{"$f":"SUM(J35:J36)","v":23412},{"$f":"SUM(K35:K36)","v":16869},{"$f":"SUM(L35:L36)","v":12414},{"$f":"SUM(M35:M36)","v":9475}]
[]
[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":7598.08},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":5220.5},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":3650.11},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":2585.8700000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":1970.01}]
[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":7598.08},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,5,TRUE)))","v":5220.5},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,6,TRUE)))","v":3650.11},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,7,TRUE)))","v":2585.8700000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,8,TRUE)))","v":1970.01}]
[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":2638.34},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":1927.6100000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":1481.3500000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":1248.68},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":922.73}]
[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":17834.5},{"$f":"SUM(J40:J43)","v":12368.61},{"$f":"SUM(K40:K43)","v":8900.82},{"$f":"SUM(L40:L43)","v":6539.670000000001},{"$f":"SUM(M40:M43)","v":4982}]
[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":17909.5},{"$f":"SUM(J44:J45)","v":12443.61},{"$f":"SUM(K44:K45)","v":8975.82},{"$f":"SUM(L44:L45)","v":6614.670000000001},{"$f":"SUM(M44:M45)","v":5057}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I44","v":17834.5},{"$f":"J44","v":12368.61},8900.82,6539.670000000001,4982]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 Ene 2023"]
[]
[null," "]
[null," "]

{"sheet":"Advantage (Mundial)","index":3,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[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],[22,2,22,3],[20,2,20,3],[50,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],[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],[19,0,19,1],[24,2,24,3],[51,0,52,1],[28,2,28,3],[29,2,29,3],[30,2,30,3],[33,2,33,3],[31,2,31,3],[49,0,49,1],[50,0,50,1],[47,0,47,1],[48,0,48,1],[42,0,42,1],[42,2,42,3],[29,0,29,1],[34,2,34,3],[26,0,26,1],[26,2,26,3],[27,2,27,3],[33,0,33,1],[34,0,34,1],[32,2,32,3],[32,0,32,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[35,0,41,1],[48,2,48,3],[47,2,47,3],[44,0,44,1],[46,0,46,1],[45,2,45,3],[45,0,45,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care "]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},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:38:41"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,true,null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,null," "]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,"n/a",1000,2000,5000,10000,20000]
[null,null,null,null,null,"Fuera del pais de residencia",null,"n/a",2000,3000,5000,10000,20000]
[]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima de Titular :",null,"n/a",{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,4,TRUE)","v":9542},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":7176},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":5365},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":4122},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":3269}]
[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":9542},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,5,TRUE)))","v":7176},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,6,TRUE)))","v":5365},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,7,TRUE)))","v":4122},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,8,TRUE)))","v":3269}]
[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":4251},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":3024},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":2340},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":2069},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":1495}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$301)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$301)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!E$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!F$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!G$302)","v":300},{"$f":"IF($I$22=FALSE,0,Tablas!H$302)","v":300}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":23635},17676,13370,10613,8333]
[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":23710},{"$f":"SUM(J36:J37)","v":17751},{"$f":"SUM(K36:K37)","v":13445},{"$f":"SUM(L36:L37)","v":10688},{"$f":"SUM(M36:M37)","v":8408}]
[]
[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":5057.26},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":3803.28},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":2843.4500000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":2184.6600000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":1732.5700000000002}]
[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":5057.26},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,5,TRUE)))","v":3803.28},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,6,TRUE)))","v":2843.4500000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,7,TRUE)))","v":2184.6600000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,8,TRUE)))","v":1732.5700000000002}]
[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":2253.0300000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":1602.72},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":1240.2},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":1096.5700000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":792.35}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$20=FALSE,0,Tablas!D$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!E$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!F$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!G$334)","v":0},{"$f":"+IF($I$20=FALSE,0,Tablas!H$334)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$22=FALSE,0,Tablas!D$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!E$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!F$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!G$335)","v":159},{"$f":"IF($I$22=FALSE,0,Tablas!H$335)","v":159}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":12526.550000000001},9368.2800000000007,7086.1,5624.8900000000012,4416.4900000000007]
[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":12601.550000000001},{"$f":"SUM(J46:J47)","v":9443.2800000000007},{"$f":"SUM(K46:K47)","v":7161.1},{"$f":"SUM(L46:L47)","v":5699.8900000000012},{"$f":"SUM(M46:M47)","v":4491.4900000000007}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":12526.550000000001},{"$f":"J46","v":9368.2800000000007},7086.1,5624.8900000000012,4416.4900000000007]
[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":[[45,0,46,1],[42,0,42,1],[41,2,41,3],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,44,1],[44,2,44,3],[39,0,39,1],[40,0,40,1],[39,2,39,3],[41,0,41,1],[40,2,40,3],[22,0,23,1],[24,0,24,1],[33,0,33,1],[34,0,34,1],[38,2,38,3],[38,0,38,1],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[34,2,34,3],[19,0,19,1],[28,0,28,1],[28,2,28,3],[32,0,32,1],[25,2,25,3],[25,0,25,1],[26,0,26,1],[26,2,26,3],[32,2,32,3],[21,2,21,3],[22,2,22,3],[31,2,31,3],[27,0,27,1],[29,0,29,1],[30,0,31,1],[20,0,21,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[27,2,27,3],[16,2,16,3],[20,2,20,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[33,2,33,3],[45,2,46,3],[9,0,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
["Cotización de Seguro Médico Internacional - Bupa ADVANTAGE Care (cobertura solo Latinoamérica)"]
[]
["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":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:38:41"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":7386},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":5540},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":4147},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":3174},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":2507}]
[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":7386},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,5,TRUE)))","v":5540},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,6,TRUE)))","v":4147},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,7,TRUE)))","v":3174},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,8,TRUE)))","v":2507}]
["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":3301},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":2352},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":1821},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":1617},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":1166}]
["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":18073},13432,10115,7965,6180]
["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":18148},{"$f":"SUM(J36:J37)","v":13507},{"$f":"SUM(K36:K37)","v":10190},{"$f":"SUM(L36:L37)","v":8040},{"$f":"SUM(M36:M37)","v":6255}]
["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":3914.5800000000004},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":2936.2000000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":2197.9100000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":1682.22},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":1328.71}]
["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":3914.5800000000004},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,5,TRUE)))","v":2936.2000000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,6,TRUE)))","v":2197.9100000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,7,TRUE)))","v":1682.22},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,8,TRUE)))","v":1328.71}]
["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":1749.5300000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":1246.5600000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":965.13},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":857.01},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":617.98}]
["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":9578.69},7118.9600000000009,5360.9500000000007,4221.45,3275.4]
[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":9653.69},{"$f":"SUM(J46:J47)","v":7193.9600000000009},{"$f":"SUM(K46:K47)","v":5435.9500000000007},{"$f":"SUM(L46:L47)","v":4296.45},{"$f":"SUM(M46:M47)","v":3350.4}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":9578.69},{"$f":"J46","v":7118.9600000000009},5360.9500000000007,4221.45,3275.4]
[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":[[51,5,53,12],[9,2,9,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[17,0,18,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[15,0,15,1],[20,2,20,3],[17,2,18,3],[32,0,32,1],[32,2,32,3],[29,2,29,3],[30,2,30,3],[23,2,23,3],[24,2,24,3],[19,2,19,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[22,2,22,3],[21,2,21,3],[25,2,25,3],[16,0,16,1],[19,0,19,1],[27,0,27,1],[28,0,28,1],[30,0,31,1],[29,0,29,1],[26,0,26,1],[22,0,23,1],[24,0,24,1],[25,0,25,1],[20,0,21,1],[42,0,42,1],[43,0,43,1],[35,2,39,3],[49,5,49,12],[46,2,46,3],[49,0,49,1],[49,2,49,3],[33,2,33,3],[31,2,31,3],[47,0,48,1],[47,2,48,3],[45,2,45,3],[46,0,46,1],[45,0,45,1],[33,0,33,1],[34,0,34,1],[35,0,41,1],[44,0,44,1],[34,2,34,3],[40,2,41,3],[43,2,43,3],[44,2,44,3],[42,2,42,3]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa SECURE Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},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:38:41"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":7366},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":5776},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":4344},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":3756},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":2860}]
[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":7366},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,5,TRUE)))","v":5776},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,6,TRUE)))","v":4344},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,7,TRUE)))","v":3756},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,8,TRUE)))","v":2860}]
[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":3556},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":2094},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":1749},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":1507},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":1113}]
[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":18813},14171,10962,9544,7358]
[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":18888},{"$f":"SUM(J36:J37)","v":14246},{"$f":"SUM(K36:K37)","v":11037},{"$f":"SUM(L36:L37)","v":9619},{"$f":"SUM(M36:M37)","v":7433}]
[]
[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":3903.98},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":3061.28},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":2302.3200000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":1990.68},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":1515.8000000000002}]
[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":3903.98},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,5,TRUE)))","v":3061.28},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,6,TRUE)))","v":2302.3200000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,7,TRUE)))","v":1990.68},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,8,TRUE)))","v":1515.8000000000002}]
[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":1884.68},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":1109.8200000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":926.97},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":798.71},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":589.89}]
[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":9970.89},7510.630000000001,5809.8600000000006,5058.32,3899.7400000000002]
[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":10045.89},{"$f":"SUM(J46:J47)","v":7585.630000000001},{"$f":"SUM(K46:K47)","v":5884.8600000000006},{"$f":"SUM(L46:L47)","v":5133.32},{"$f":"SUM(M46:M47)","v":3974.7400000000002}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":9970.89},{"$f":"J46","v":7510.630000000001},5809.8600000000006,5058.32,3899.7400000000002]
[null,null,null,null,null,"Tarifas en US $ -  Válidas desde 01 enero 2023"]
[null," "]
[null," ",null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Essential","index":6,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,5,53,12],[42,0,42,1],[34,2,34,3],[47,2,48,3],[47,0,48,1],[45,2,45,3],[46,2,46,3],[43,2,43,3],[45,0,45,1],[46,0,46,1],[43,0,43,1],[44,0,44,1],[44,2,44,3],[49,5,49,12],[42,2,42,3],[49,0,49,1],[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],[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],[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],[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]]}
[]
[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":18}]
[null,null,null,null,null,"FECHA DE COTIZACION :"]
[null,null,null,null,null,{"$f":"NOW()","v":"2023-08-16T10:38:41"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[null,null,null,null,null,null,null,null,false,null,"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":4977},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":3897},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":2934},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":2544},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":1925}]
[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":4977},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,5,TRUE)))","v":3897},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,6,TRUE)))","v":2934},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,7,TRUE)))","v":2544},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,8,TRUE)))","v":1925}]
[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":2417},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":1429},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":1193},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":1035},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":766}]
[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":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$503)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$503)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":12371},9223,7061,6123,4616]
[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":12446},{"$f":"SUM(J36:J37)","v":9298},{"$f":"SUM(K36:K37)","v":7136},{"$f":"SUM(L36:L37)","v":6198},{"$f":"SUM(M36:M37)","v":4691}]
[]
[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":2637.81},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":2065.4100000000003},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":1555.02},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":1348.3200000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":1020.25}]
[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":2637.81},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,5,TRUE)))","v":2065.4100000000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,6,TRUE)))","v":1555.02},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,7,TRUE)))","v":1348.3200000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,8,TRUE)))","v":1020.25}]
[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":1281.01},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":757.37},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":632.29000000000008},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":548.55000000000007},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":405.98}]
[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":0},{"$f":"IF($I$22=FALSE,0,Tablas!E$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!F$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!G$536)","v":0},{"$f":"IF($I$22=FALSE,0,Tablas!H$536)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":6556.63},4888.1900000000005,3742.33,3245.1900000000005,2446.48]
[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":6631.63},{"$f":"SUM(J46:J47)","v":4963.1900000000005},{"$f":"SUM(K46:K47)","v":3817.33},{"$f":"SUM(L46:L47)","v":3320.1900000000005},{"$f":"SUM(M46:M47)","v":2521.48}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":6556.63},{"$f":"J46","v":4888.1900000000005},3742.33,3245.1900000000005,2446.48]
[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":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,5,52,12],[17,0,18,1],[12,0,12,1],[14,0,14,1],[13,0,13,1],[15,0,15,1],[16,0,16,1],[49,5,49,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[35,2,39,3],[34,8,34,9],[27,8,27,9],[28,8,28,9],[9,2,9,12],[26,2,26,3],[17,2,18,3],[19,2,19,3],[20,2,20,3],[16,2,16,3],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[21,10,22,12],[11,7,11,12],[13,7,13,12],[17,5,17,6],[16,5,16,6],[11,0,11,3],[45,2,45,3],[23,10,24,11],[33,10,36,12],[28,2,28,3],[29,2,29,3],[32,2,32,3],[33,2,33,3],[35,8,35,9],[36,8,36,9],[25,10,25,11],[26,10,26,11],[27,10,27,11],[32,10,32,11],[31,8,31,9],[32,8,32,9],[33,8,33,9],[21,5,22,7],[21,8,22,9],[20,0,21,1],[21,2,21,3],[22,2,22,3],[25,0,25,1],[25,2,25,3],[23,2,23,3],[24,2,24,3],[27,2,27,3],[19,0,19,1],[41,2,41,3],[44,0,44,1],[32,0,32,1],[35,0,39,1],[33,0,33,1],[34,0,34,1],[43,0,43,1],[22,0,23,1],[24,0,24,1],[30,2,31,3],[27,0,27,1],[28,0,28,1],[34,2,34,3],[29,0,29,1],[30,0,31,1],[45,0,45,1],[23,5,24,7],[25,5,26,7],[27,5,28,7],[29,5,30,7],[31,5,32,7],[33,5,34,7],[35,5,36,7],[44,2,44,3],[26,0,26,1],[43,2,43,3],[40,0,40,1],[41,0,41,1],[42,0,42,1],[42,2,42,3],[40,2,40,3],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[29,8,29,9],[30,8,30,9]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa CRITICAL Care"]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$D$21","v":"AGENCIA"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},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:38:41"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":18}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,null,true,null,null,{"$f":"IF(M16>=M18,M16,M18)","v":18}]
[]
[null,null,null,null,null,"CONDICION CRITICA CUBIERTA",null,null,"MAXIMO POR AÑO POLIZA",null,"TRASPLANTE DE ORGANOS"]
[]
[null,null,null,null,null,"Enfermedades neurológicas y accidentes cerebro-vasculares",null,null,150000,null,"Tipo de trasplante",null,"Máximo Vitalicio"]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,null,null,"por persona"]
[null,null,null,null,null,"Cirugías cardíacas y angioplastías",null,null,150000,null,"Corazón",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Corazón y Pulmón (simultáneamente)",null,300000]
[null,null,null,null,null,"Tratamiento de cáncer",null,null,200000,null,"Pulmón",null,250000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Pancreas",null,250000]
[null,null,null,null,null,"Trauma grave (Politraumatismos)",null,null,150000,null,"Pancreas y Riñón (simultáneamente)",null,300000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Riñón",null,200000]
[null,null,null,null,null,"Insuficiencia renal crónica (Diálisis)",null,null,100000,null,"Hígado",null,200000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza",null,"Médula ósea",null,250000]
[null,null,null,null,null,"Quemaduras graves ",null,null,300000,null,"La cobertura de trasplante de órganos está limitada a la Red de Proveedores para Procedimiento de Trasplante de la Compañía y no se proporcionará cobertura en proveedores fuera de esta Red especializada."]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[null,null,null,null,null,"Desorden infeccioso grave (Septicemia)",null,null,150000]
[null,null,null,null,null,null,null,null,"por asegurado  por  año póliza"]
[]
[null,null,null,null,null,"Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
[null,null,null,null,null,"Dentro del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[null,null,null,null,null,"Fuera del pais de residencia",null,2000,3500,5000,10000,20000,50000]
[]
[null,null,null,null,null,"Tarifas Anuales"]
[null,null,null,null,null,"Prima por plan individual :",null,{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,3,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,6,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,9,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,12,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,15,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=1),(VLOOKUP($M$20,Tablas!$A$543:$T$544,18,TRUE)),0)","v":0}]
[null,null,null,null,null,"Prima por plan para 2 personas :",null,{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,4,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,7,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,10,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,13,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,16,TRUE)),0)","v":0},{"$f":"IF((($J$16+$J$18)=2),(VLOOKUP($M$20,Tablas!$A$543:$T$544,19,TRUE)),0)","v":0}]
[null,null,null,null,null,"Prima por plan familiar :",null,{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,5,TRUE)),0)","v":13529},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,8,TRUE)),0)","v":11418},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,11,TRUE)),0)","v":9785},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,14,TRUE)),0)","v":7399},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,17,TRUE)),0)","v":5118},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,20,TRUE)),0)","v":2678}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":13529},{"$f":"SUM(I44:I46)","v":11418},9785,7399,5118,2678]
[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":13604},11493,9860,7474,5193,2753]
[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,40,7],[13,2,13,7],[15,2,15,7],[19,0,19,1],[18,0,18,1],[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]]}
[]
[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":18}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2023-08-16T10:38:41"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":1},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":40092},{"$f":"+Exclusive!J37","v":26986},{"$f":"+Exclusive!K37","v":19695},{"$f":"+Exclusive!L37","v":14550},{"$f":"+Exclusive!M37","v":11509}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I37","v":33725},{"$f":"+Privilege!J37","v":23412},{"$f":"+Privilege!K37","v":16869},{"$f":"+Privilege!L37","v":12414},{"$f":"+Privilege!M37","v":9475}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":23710},{"$f":"+'Advantage (Mundial)'!J38","v":17751},{"$f":"+'Advantage (Mundial)'!K38","v":13445},{"$f":"+'Advantage (Mundial)'!L38","v":10688},{"$f":"+'Advantage (Mundial)'!M38","v":8408}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":18888},{"$f":"+Secure!J38","v":14246},{"$f":"+Secure!K38","v":11037},{"$f":"+Secure!L38","v":9619},{"$f":"+Secure!M38","v":7433}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":12446},{"$f":"+Essential!J38","v":9298},{"$f":"+Essential!K38","v":7136},{"$f":"+Essential!L38","v":6198},{"$f":"+Essential!M38","v":4691}]
[]
["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":13604},{"$f":"+Critical!I49","v":11493},{"$f":"+Critical!J49","v":9860},{"$f":"+Critical!K49","v":7474},{"$f":"+Critical!L49","v":5193},{"$f":"+Critical!M49","v":2753}]
["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":[[60,0,61,0],[4,1,4,6],[0,0,3,6]]}
["2023 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":551,"n_cols":20,"rows_kept":551,"cut":false,"hidden":true,"merged":[[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[303,0,303,7],[269,0,269,7],[270,0,270,7],[271,0,271,1],[271,2,271,6],[170,2,170,6],[202,0,202,7],[236,0,236,7],[237,0,237,1],[237,2,237,6],[204,0,204,1],[204,2,204,6],[470,0,470,7],[403,0,403,7],[404,0,404,7],[405,0,405,1],[405,2,405,6],[304,2,304,6],[336,0,336,7],[437,0,437,7],[438,0,438,1],[438,2,438,6],[304,0,304,1],[370,0,370,7],[371,0,371,1],[371,2,371,6],[337,0,337,7],[338,0,338,1],[338,2,338,6],[539,0,539,1],[471,0,471,7],[472,0,472,1],[472,2,472,6],[504,0,504,7],[505,0,505,1],[505,2,505,6],[538,0,538,19],[537,0,537,19],[539,2,539,6],[540,14,540,16],[540,17,540,19],[547,14,547,16],[547,17,547,19],[545,0,545,19],[540,2,540,4],[547,2,547,4],[547,5,547,7],[547,8,547,10],[546,0,546,1],[546,2,546,6],[540,5,540,7],[540,8,540,10],[547,11,547,13],[540,11,540,13],[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,17049,11277,7932,5639,4442,null,0,0,0,0,0]
[25,"25-29",null,17883,12455,8783,6253,4918,null,0,0,0,0,0]
[30,"30-34",null,18596,13353,9834,7484,5904,null,0,0,0,0,0]
[35,"35-39",null,20825,14951,11017,8380,6611,null,0,0,0,0,0]
[40,"40-44",null,24135,16341,12222,9207,7261,null,0,0,0,0,0]
[45,"45-49",null,26983,18281,13650,10289,8110,null,0,0,0,0,0]
[50,"50-54",null,34527,23968,17819,14528,11463,null,0,0,0,0,0]
[55,"55-59",null,36731,25505,18954,15466,12205,null,0,0,0,0,0]
[60,"60",null,40010,27825,21806,18619,15155,null,0,0,0,0,0]
[61,"61",null,42986,29902,23410,20017,16277,null,0,0,0,0,0]
[62,"62",null,47062,32735,25646,21900,17819,null,0,0,0,0,0]
[63,"63",null,50034,34807,27256,23299,18946,null,0,0,0,0,0]
[64,"64",null,54124,37664,29489,25192,20495,null,0,0,0,0,0]
[65,"65",null,70739,49116,37279,33590,28900,null,0,0,0,0,0]
[66,"66",null,82175,57063,43320,39038,33576,null,0,0,0,0,0]
[67,"67",null,89768,62328,47310,42629,36662,null,0,0,0,0,0]
[68,"68",null,99383,69006,52382,47217,40604,null,0,0,0,0,0]
[69,"69",null,109360,75928,57629,51942,44674,null,0,0,0,0,0]
[70,"70",null,134578,92446,67846,60522,52545,null,0,0,0,0,0]
[71,"71",null,139861,96079,70504,62902,54601,null,0,0,0,0,0]
[72,"72",null,143826,98789,72493,64679,56154,null,0,0,0,0,0]
[73,"73",null,149106,102422,75162,67062,58218,null,0,0,0,0,0]
[74,"74",null,151737,104227,76489,68240,59250,null,0,0,0,0,0]
[75,"75+",null,158351,108765,79817,71219,61826,null,0,0,0,0,0]
[1,"1 Child",null,5919,4357,3531,2972,2325,null,0,0,0,0,0]
[2,"2 Children",null,9401,6935,5615,4730,3675,null,0,0,0,0,0]
[3,"3+ Children",null,13786,10149,8232,6927,5394,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",0,0,0,225,225,225]
[1,"Transplante de organos",0,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":9035.9700000000012},{"$f":"$L$2*E6","v":5976.81},4203.96,2988.67,2354.2600000000002,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D7","v":9477.99},{"$f":"$L$2*E7","v":6601.1500000000005},4654.99,3314.09,2606.54,null,0,0,0,0,0]
[30,"30-34",null,9855.880000000001,{"$f":"$L$2*E8","v":7077.09},5212.0200000000004,3966.52,3129.1200000000003,null,0,0,0,0,0]
[35,"35-39",null,11037.25,{"$f":"$L$2*E9","v":7924.0300000000007},5839.01,4441.4000000000005,3503.8300000000004,null,0,0,0,0,0]
[40,"40-44",null,12791.550000000001,{"$f":"$L$2*E10","v":8660.73},6477.6600000000008,4879.71,3848.3300000000004,null,0,0,0,0,0]
[45,"45-49",null,14300.990000000002,{"$f":"$L$2*E11","v":9688.93},7234.5,5453.17,4298.3,null,0,0,0,0,0]
[50,"50-54",null,18299.310000000001,{"$f":"$L$2*E12","v":12703.04},9444.07,7699.84,6075.39,null,0,0,0,0,0]
[55,"55-59",null,19467.43,{"$f":"$L$2*E13","v":13517.650000000001},10045.620000000001,8196.98,6468.6500000000005,null,0,0,0,0,0]
[60,"60",null,21205.3,{"$f":"$L$2*E14","v":14747.25},11557.18,9868.07,8032.1500000000005,null,0,0,0,0,0]
[61,"61",null,22782.58,{"$f":"$L$2*E15","v":15848.060000000001},12407.300000000001,10609.01,8626.8100000000013,null,0,0,0,0,0]
[62,"62",null,24942.86,{"$f":"$L$2*E16","v":17349.55},13592.380000000001,11607,9444.07,null,0,0,0,0,0]
[63,"63",null,26518.02,{"$f":"$L$2*E17","v":18447.71},14445.68,12348.470000000001,10041.380000000001,null,0,0,0,0,0]
[64,"64",null,28685.72,{"$f":"$L$2*E18","v":19961.920000000002},15629.17,13351.76,10862.35,null,0,0,0,0,0]
[65,"65",null,37491.67,{"$f":"$L$2*E19","v":26031.48},19757.870000000003,17802.7,15317,null,0,0,0,0,0]
[66,"66",null,43552.75,{"$f":"$L$2*E20","v":30243.390000000003},22959.600000000002,20690.14,17795.280000000002,null,0,0,0,0,0]
[67,"67",null,47577.04,{"$f":"$L$2*E21","v":33033.840000000004},25074.300000000003,22593.370000000003,19430.86,null,0,0,0,0,0]
[68,"68",null,52672.990000000005,{"$f":"$L$2*E22","v":36573.18},27762.460000000003,25025.010000000002,21520.120000000003,null,0,0,0,0,0]
[69,"69",null,57960.800000000003,{"$f":"$L$2*E23","v":40241.840000000004},30543.370000000003,27529.260000000002,23677.22,null,0,0,0,0,0]
[70,"70",null,71326.34,{"$f":"$L$2*E24","v":48996.380000000005},35958.380000000005,32076.66,27848.850000000002,null,0,0,0,0,0]
[71,"71",null,74126.33,{"$f":"$L$2*E25","v":50921.87},37367.120000000003,33338.060000000005,28938.530000000002,null,0,0,0,0,0]
[72,"72",null,76227.78,{"$f":"$L$2*E26","v":52358.170000000006},38421.29,34279.870000000003,29761.620000000003,null,0,0,0,0,0]
[73,"73",null,79026.180000000008,{"$f":"$L$2*E27","v":54283.66},39835.86,35542.86,30855.54,null,0,0,0,0,0]
[74,"74",null,80420.61,{"$f":"$L$2*E28","v":55240.310000000005},40539.170000000006,36167.200000000004,31402.5,null,0,0,0,0,0]
[75,"75+",null,83926.03,{"$f":"$L$2*E29","v":57645.450000000004},42303.01,37746.07,32767.780000000002,null,0,0,0,0,0]
[1,"1 Child",null,3137.07,{"$f":"$L$2*E30","v":2309.21},1871.43,1575.16,1232.25,null,0,0,0,0,0]
[2,"2 Children",null,4982.5300000000007,{"$f":"$L$2*E31","v":3675.55},2975.9500000000003,2506.9,1947.75,null,0,0,0,0,0]
[3,"3+ Children",null,7306.58,{"$f":"$L$2*E32","v":5378.97},4362.96,3671.3100000000004,2858.82,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",{"$f":"+C33*$L$2","v":0},0,0,119.25,119.25,119.25]
[1,"Transplante de organos",0,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,14336,9850,6887,4879,3717,null,0,0,0,0,0]
[25,"25-29",null,15044,10899,7630,5406,4125,null,0,0,0,0,0]
[30,"30-34",null,15714,11681,8549,6546,4993,null,0,0,0,0,0]
[35,"35-39",null,17596,13073,9581,7334,5598,null,0,0,0,0,0]
[40,"40-44",null,20364,14321,10653,8085,6167,null,0,0,0,0,0]
[45,"45-49",null,22748,16003,11917,9028,6902,null,0,0,0,0,0]
[50,"50-54",null,29742,21103,15637,12890,9857,null,0,0,0,0,0]
[55,"55-59",null,31642,22454,16640,13716,10490,null,0,0,0,0,0]
[60,"60",null,34458,24393,18934,16319,13099,null,0,0,0,0,0]
[61,"61",null,37017,26195,20338,17527,14072,null,0,0,0,0,0]
[62,"62",null,40522,28685,22276,19191,15414,null,0,0,0,0,0]
[63,"63",null,43092,30496,23677,20406,16382,null,0,0,0,0,0]
[64,"64",null,46601,32988,25609,22070,17736,null,0,0,0,0,0]
[65,"65",null,60917,43030,32383,29424,24994,null,0,0,0,0,0]
[66,"66",null,70766,49997,37622,34198,29045,null,0,0,0,0,0]
[67,"67",null,77300,54609,41089,37348,31715,null,0,0,0,0,0]
[68,"68",null,85598,60462,45511,41367,35121,null,0,0,0,0,0]
[69,"69",null,94165,66518,50063,45504,38646,null,0,0,0,0,0]
[70,"70",null,115892,80985,58922,53030,45451,null,0,0,0,0,0]
[71,"71",null,120434,84164,61244,55106,47237,null,0,0,0,0,0]
[72,"72",null,123837,86554,62971,56666,48575,null,0,0,0,0,0]
[73,"73",null,128406,89729,65289,58743,50361,null,0,0,0,0,0]
[74,"74",null,130673,91322,66440,59786,51247,null,0,0,0,0,0]
[75,"75+",null,136358,95287,69334,62392,53478,null,0,0,0,0,0]
[1,"1 Child",null,4978,3637,2795,2356,1741,null,0,0,0,0,0]
[2,"2 Children",null,7915,5788,4453,3753,2776,null,0,0,0,0,0]
[3,"3+ Children",null,11588,8475,6522,5494,4070,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",0,0,0,225,225,225]
[1,"Transplante de organos",0,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6",null,3,7,11,15,19]
[18,"18-24",{"$f":"+C140*$L$2","v":0},{"$f":"$L$2*D140","v":7598.08},{"$f":"$L$2*E140","v":5220.5},3650.11,2585.8700000000003,1970.01,null,0,0,0,0,0]
[25,"25-29",0,{"$f":"$L$2*D141","v":7973.3200000000006},5776.47,4043.9,2865.1800000000003,2186.25,null,0,0,0,0,0]
[30,"30-34",0,8328.42,6190.93,4530.97,3469.38,2646.29,null,0,0,0,0,0]
[35,"35-39",0,9325.880000000001,6928.6900000000005,5077.93,3887.02,2966.94,null,0,0,0,0,0]
[40,"40-44",0,10792.92,7590.13,5646.09,4285.05,3268.51,null,0,0,0,0,0]
[45,"45-49",0,12056.44,8481.59,6316.01,4784.84,3658.0600000000004,null,0,0,0,0,0]
[50,"50-54",0,15763.26,11184.59,8287.61,6831.7000000000007,5224.21,null,0,0,0,0,0]
[55,"55-59",0,16770.260000000002,11900.62,8819.2000000000007,7269.4800000000005,5559.7000000000007,null,0,0,0,0,0]
[60,"60",0,18262.740000000002,12928.29,10035.02,{"$f":"$L$2*G148","v":8649.07},6942.47,null,0,0,0,0,0]
[61,"61",0,19619.010000000002,13883.35,10779.140000000001,9289.3100000000013,7458.1600000000008,null,0,0,0,0,0]
[62,"62",{"$f":"+C150*$L$2","v":0},{"$f":"$L$2*D150","v":21476.66},15203.050000000001,11806.28,10171.230000000001,8169.42,null,0,0,0,0,0]
[63,"63",0,22838.760000000002,16162.880000000001,12548.810000000001,10815.18,8682.4600000000009,null,0,0,0,0,0]
[64,"64",0,24698.530000000002,17483.64,13572.77,11697.1,9400.08,null,0,0,0,0,0]
[65,"65",0,32286.010000000002,22805.9,17162.990000000002,15594.720000000001,13246.820000000002,null,0,0,0,0,0]
[66,"66",0,37505.980000000003,26498.41,19939.66,18124.940000000002,15393.85,null,0,0,0,0,0]
[67,"67",0,40969,28942.77,21777.170000000002,19794.440000000002,16808.95,null,0,0,0,0,0]
[68,"68",0,45366.94,32044.86,24120.83,21924.510000000002,18614.13,null,0,0,0,0,0]
[69,"69",0,49907.450000000004,35254.54,26533.390000000003,24117.120000000003,20482.38,null,0,0,0,0,0]
[70,"70",0,61422.76,42922.05,31228.66,28105.9,{"$f":"$L$2*H158","v":24089.030000000002},null,0,0,0,0,0]
[71,"71",0,63830.020000000004,44606.920000000006,32459.320000000003,29206.18,25035.61,null,0,0,0,0,0]
[72,"72",{"$f":"+C160*$L$2","v":0},65633.61,45873.62,33374.630000000005,30032.980000000003,25744.75,null,0,0,0,0,0]
[73,"73",0,68055.180000000008,47556.37,34603.17,31133.79,26691.33,null,0,0,0,0,0]
[74,"74",0,69256.69,48400.66,35213.200000000004,31686.58,27160.91,null,0,0,0,0,0]
[75,"75+",0,72269.740000000005,50502.11,36747.020000000004,33067.760000000002,28343.34,null,0,0,0,0,0]
[1,"1 Child",0,2638.34,1927.6100000000001,1481.3500000000001,1248.68,922.73,null,0,0,0,0,0]
[2,"2 Children",0,4194.95,3067.6400000000003,2360.09,1989.0900000000001,1471.28,null,0,0,0,0,0]
[3,"3+ Children",0,6141.64,4491.75,3456.6600000000003,2911.82,2157.1,null,0,0,0,0,0]
[1,"Rider Comp. Maternidad",0,0,0,119.25,119.25,119.25]
[1,"Transplante de organos",0,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,9542,7176,5365,4122,3269,null,0,0,0,0,0]
[25,"25-29",null,10615,8008,5975,4596,3619,null,0,0,0,0,0]
[30,"30-34",null,12286,9405,7098,5443,4204,null,0,0,0,0,0]
[35,"35-39",null,13619,10471,7901,6208,4664,null,0,0,0,0,0]
[40,"40-44",null,15369,11867,8957,6938,5272,null,0,0,0,0,0]
[45,"45-49",null,17854,13665,10088,7889,6129,null,0,0,0,0,0]
[50,"50-54",null,19566,15364,11762,8864,6726,null,0,0,0,0,0]
[55,"55-59",null,23120,17730,13013,10260,7950,null,0,0,0,0,0]
[60,"60",null,25537,19632,14311,11319,8791,null,0,0,0,0,0]
[61,"61",null,28734,22092,16099,12743,9909,null,0,0,0,0,0]
[62,"62",null,31940,24550,17892,14164,11003,null,0,0,0,0,0]
[63,"63",null,35145,27018,19690,15586,12124,null,0,0,0,0,0]
[64,"64",null,38341,29475,21493,17011,13224,null,0,0,0,0,0]
[65,"65",null,41441,32072,23417,18526,15050,null,0,0,0,0,0]
[66,"66",null,43895,33978,24805,19625,15944,null,0,0,0,0,0]
[67,"67",null,48782,37749,27569,21810,17720,null,0,0,0,0,0]
[68,"68",null,53660,41534,30322,23992,19488,null,0,0,0,0,0]
[69,"69",null,56113,43420,31710,25084,20385,null,0,0,0,0,0]
[70,"70",null,56831,44112,32190,25568,20658,null,0,0,0,0,0]
[71,"71",null,63953,49633,36226,28767,23236,null,0,0,0,0,0]
[72,"72",null,71060,55164,40255,31968,25825,null,0,0,0,0,0]
[73,"73",null,78169,60676,44283,35174,28414,null,0,0,0,0,0]
[74,"74",null,85288,66202,48323,38376,31005,null,0,0,0,0,0]
[75,"75+",null,93291,73838,55420,42002,35577,null,0,0,0,0,0]
[1,"1 Child",null,4251,3024,2340,2069,1495,null,0,0,0,0,0]
[2,"2 Children",null,6917,4773,3704,3273,2199,null,0,0,0,0,0]
[3,"3+ Children",null,10121,6959,5383,4757,3345,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":5057.26},{"$f":"$L$2*E274","v":3803.28},2843.4500000000003,2184.6600000000003,1732.5700000000002,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D275","v":5625.9500000000007},4244.24,3166.75,2435.88,1918.0700000000002,null,0,0,0,0,0]
[30,"30-34",null,6511.58,4984.6500000000005,3761.94,2884.79,2228.12,null,0,0,0,0,0]
[35,"35-39",null,7218.0700000000006,5549.63,4187.5300000000007,3290.2400000000002,{"$f":"$L$2*H277","v":2471.92},null,0,0,0,0,0]
[40,"40-44",null,8145.5700000000006,6289.51,4747.21,3677.1400000000003,2794.1600000000003,null,0,0,0,0,0]
[45,"45-49",null,9462.6200000000008,7242.4500000000007,5346.64,4181.17,3248.3700000000003,null,0,0,0,0,0]
[50,"50-54",null,10369.980000000001,8142.92,6233.8600000000006,4697.92,3564.78,null,0,0,0,0,0]
[55,"55-59",null,12253.6,9396.9,6896.89,5437.8,4213.5,null,0,0,0,0,0]
[60,"60",null,13534.61,10404.960000000001,7584.83,5999.0700000000006,4659.2300000000005,null,0,0,0,0,0]
[61,"61",null,{"$f":"$L$2*D283","v":15229.02},11708.76,8532.4700000000012,6753.79,5251.77,null,0,0,0,0,0]
[62,"62",null,16928.2,13011.5,9482.76,7506.92,5831.59,null,0,0,0,0,0]
[63,"63",null,18626.850000000002,14319.54,10435.700000000001,8260.58,6425.72,null,0,0,0,0,0]
[64,"64",null,20320.73,15621.75,11391.29,9015.83,7008.72,null,0,0,0,0,0]
[65,"65",null,21963.73,16998.16,12411.01,9818.7800000000007,7976.5,null,0,0,0,0,0]
[66,"66",null,23264.350000000002,18008.34,13146.650000000001,10401.25,8450.32,null,0,0,0,0,0]
[67,"67",null,25854.460000000003,20006.97,14611.570000000002,11559.300000000001,9391.6,null,0,0,0,0,0]
[68,"68",null,28439.800000000003,22013.02,16070.660000000002,12715.76,10328.640000000001,null,0,0,0,0,0]
[69,"69",null,29739.890000000003,23012.600000000002,{"$f":"$L$2*F291","v":16806.3},13294.52,10804.050000000001,null,0,0,0,0,0]
[70,"70",null,30120.43,23379.360000000001,17060.7,13551.04,10948.74,null,0,0,0,0,0]
[71,"71",null,33895.090000000004,26305.49,19199.780000000002,15246.51,12315.08,null,0,0,0,0,0]
[72,"72",null,37661.800000000003,29236.920000000002,21335.15,16943.04,13687.25,null,0,0,0,0,0]
[73,"73",null,41429.57,32158.280000000002,23469.99,18642.22,15059.42,null,0,0,0,0,0]
[74,"74",null,45202.64,35087.060000000005,25611.190000000002,20339.280000000002,16432.650000000001,null,0,0,0,0,0]
[75,"75+",null,49444.23,39134.14,29372.600000000002,22261.06,18855.810000000001,null,0,0,0,0,0]
[1,"1 Child",null,2253.0300000000002,1602.72,1240.2,1096.5700000000002,792.35,null,0,0,0,0,0]
[2,"2 Children",null,3666.01,2529.69,1963.1200000000001,1734.69,1165.47,null,0,0,0,0,0]
[3,"3+ Children",null,5364.13,3688.27,2852.9900000000002,2521.21,1772.8500000000001,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,7386,5540,4147,3174,2507,null,0,0,0,0,0]
[25,"25-29",null,8219,6188,4626,3547,2793,null,0,0,0,0,0]
[30,"30-34",null,9522,7283,5495,4207,3242,null,0,0,0,0,0]
[35,"35-39",null,10558,8109,6115,4805,3605,null,0,0,0,0,0]
[40,"40-44",null,11923,9194,6944,5363,4070,null,0,0,0,0,0]
[45,"45-49",null,13846,10590,7819,6111,4727,null,0,0,0,0,0]
[50,"50-54",null,15174,11916,9129,6878,5206,null,0,0,0,0,0]
[55,"55-59",null,17937,13755,10099,7958,6145,null,0,0,0,0,0]
[60,"60",null,19818,15234,11118,8782,6819,null,0,0,0,0,0]
[61,"61",null,22316,17147,12498,9886,7675,null,0,0,0,0,0]
[62,"62",null,24810,19067,13901,10992,8540,null,0,0,0,0,0]
[63,"63",null,27290,20979,15297,12112,9402,null,0,0,0,0,0]
[64,"64",null,29789,22883,16702,13213,10260,null,0,0,0,0,0]
[65,"65",null,32205,24922,18202,14389,11692,null,0,0,0,0,0]
[66,"66",null,34105,26388,19281,15236,12378,null,0,0,0,0,0]
[67,"67",null,37904,29335,21434,16949,13769,null,0,0,0,0,0]
[68,"68",null,41698,32273,23582,18655,15151,null,0,0,0,0,0]
[69,"69",null,43604,33745,24653,19506,15838,null,0,0,0,0,0]
[70,"70",null,44175,34275,25039,19873,16041,null,0,0,0,0,0]
[71,"71",null,49715,38573,28176,22364,18064,null,0,0,0,0,0]
[72,"72",null,55226,42876,31308,24862,20076,null,0,0,0,0,0]
[73,"73",null,60774,47163,34450,27350,22089,null,0,0,0,0,0]
[74,"74",null,66308,51467,37595,29852,24112,null,0,0,0,0,0]
[75,"75+",null,72529,57399,43128,32681,27669,null,0,0,0,0,0]
[1,"1 Child",null,3301,2352,1821,1617,1166,null,0,0,0,0,0]
[2,"2 Children",null,5375,3716,2880,2555,1710,null,0,0,0,0,0]
[3,"3+ Children",null,7874,5406,4202,3694,2602,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":3914.5800000000004},{"$f":"$L$2*E341","v":2936.2000000000003},2197.9100000000003,1682.22,1328.71,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D342","v":4356.0700000000006},3279.6400000000003,2451.7800000000002,1879.91,1480.29,null,0,0,0,0,0]
[30,"30-34",null,5046.66,3859.9900000000002,2912.3500000000004,2229.71,1718.26,null,0,0,0,0,0]
[35,"35-39",null,5595.7400000000007,4297.7700000000004,3240.9500000000003,2546.65,1910.65,null,0,0,0,0,0]
[40,"40-44",null,6319.1900000000005,4872.8200000000006,3680.32,2842.3900000000003,{"$f":"$L$2*H345","v":2157.1},null,0,0,0,0,0]
[45,"45-49",null,7338.38,5612.7000000000007,4144.0700000000006,3238.8300000000004,2505.31,null,0,0,0,0,0]
[50,"50-54",null,8042.22,6315.4800000000005,4838.37,3645.34,2759.1800000000003,null,0,0,0,0,0]
[55,"55-59",null,9506.61,7290.1500000000005,5352.47,4217.74,3256.8500000000004,null,0,0,0,0,0]
[60,"60",null,10503.54,8074.02,5892.54,4654.46,3614.07,null,0,0,0,0,0]
[61,"61",null,{"$f":"$L$2*D350","v":11827.480000000001},9087.91,6623.9400000000005,5239.58,4067.75,null,0,0,0,0,0]
[62,"62",null,13149.300000000001,10105.51,7367.5300000000007,5825.76,4526.2,null,0,0,0,0,0]
[63,"63",null,14463.7,11118.87,8107.4100000000008,6419.3600000000006,4983.0600000000004,null,0,0,0,0,0]
[64,"64",null,15788.17,12127.99,8852.0600000000013,7002.89,5437.8,null,0,0,0,0,0]
[65,"65",null,17068.650000000001,13208.66,9647.0600000000013,7626.17,6196.76,null,0,0,0,0,0]
[66,"66",null,18075.650000000001,13985.640000000001,10218.93,8075.0800000000008,6560.34,null,0,0,0,0,0]
[67,"67",null,20089.120000000003,15547.550000000001,11360.02,8982.9700000000012,7297.5700000000006,null,0,0,0,0,0]
[68,"68",null,22099.940000000002,17104.690000000002,12498.460000000001,9887.15,8030.0300000000007,null,0,0,0,0,0]
[69,"69",null,23110.120000000003,17884.850000000002,13066.09,10338.18,8394.1400000000012,null,0,0,0,0,0]
[70,"70",null,23412.75,18165.75,{"$f":"$L$2*F359","v":13270.67},10532.69,8501.73,null,0,0,0,0,0]
[71,"71",null,26348.95,20443.690000000002,{"$f":"$L$2*F360","v":14933.28},11852.92,9573.92,null,0,0,0,0,0]
[72,"72",null,29269.780000000002,22724.280000000002,{"$f":"$L$2*F361","v":16593.240000000002},13176.86,10640.28,null,0,0,0,0,0]
[73,"73",null,32210.22,24996.390000000003,18258.5,14495.5,11707.17,null,0,0,0,0,0]
[74,"74",null,35143.240000000005,27277.510000000002,19925.350000000002,15821.560000000001,12779.36,null,0,0,0,0,0]
[75,"75+",null,38440.370000000003,30421.47,22857.84,17320.93,14664.570000000002,null,0,0,0,0,0]
[1,"1 Child",null,1749.5300000000002,1246.5600000000002,965.13,857.01,617.98,null,0,0,0,0,0]
[2,"2 Children",null,2848.75,1969.48,1526.4,1354.15,906.30000000000007,null,0,0,0,0,0]
[3,"3+ Children",null,4173.22,2865.1800000000003,2227.06,1957.8200000000002,1379.0600000000002,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,7366,5776,4344,3756,2860,null,0,0,0,0,0]
[25,"25-29",null,8115,6502,4840,4187,3167,null,0,0,0,0,0]
[30,"30-34",null,9296,7644,5614,4861,3680,null,0,0,0,0,0]
[35,"35-39",null,10250,8553,6246,5401,4074,null,0,0,0,0,0]
[40,"40-44",null,11499,9772,7071,6116,4596,null,0,0,0,0,0]
[45,"45-49",null,13236,11438,8222,7097,5346,null,0,0,0,0,0]
[50,"50-54",null,14430,12593,9013,7794,5838,null,0,0,0,0,0]
[55,"55-59",null,16970,15042,10691,9229,6916,null,0,0,0,0,0]
[60,"60",null,17759,16067,11313,9769,7304,null,0,0,0,0,0]
[61,"61",null,19984,18078,12740,11004,8225,null,0,0,0,0,0]
[62,"62",null,22215,20107,14164,12239,9154,null,0,0,0,0,0]
[63,"63",null,24447,22116,15591,13463,10079,null,0,0,0,0,0]
[64,"64",null,26670,24146,17001,14698,11004,null,0,0,0,0,0]
[65,"65",null,26705,24371,17116,14781,11049,null,0,0,0,0,0]
[66,"66",null,26742,24593,17209,14853,11085,null,0,0,0,0,0]
[67,"67",null,29712,27340,19146,16509,12320,null,0,0,0,0,0]
[68,"68",null,32692,30078,21056,18173,13571,null,0,0,0,0,0]
[69,"69",null,34185,31438,22023,18991,14195,null,0,0,0,0,0]
[70,"70",null,34239,31976,22244,19185,14256,null,0,0,0,0,0]
[71,"71",null,38540,35984,25041,21594,16055,null,0,0,0,0,0]
[72,"72",null,42823,40000,27832,24013,17847,null,0,0,0,0,0]
[73,"73",null,47128,44001,30621,26409,19645,null,0,0,0,0,0]
[74,"74",null,51413,48000,33410,28818,21438,null,0,0,0,0,0]
[75,"75+",null,56035,52661,36543,31516,23418,null,0,0,0,0,0]
[1,"1 Child",null,3556,2094,1749,1507,1113,null,0,0,0,0,0]
[2,"2 Children",null,5992,3114,2752,2385,1760,null,0,0,0,0,0]
[3,"3+ Children",null,8793,4477,4003,3450,2549,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":3903.98},{"$f":"$L$2*E408","v":3061.28},2302.3200000000002,1990.68,1515.8000000000002,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D409","v":4300.95},3446.0600000000004,2565.2000000000003,2219.11,1678.51,null,0,0,0,0,0]
[30,"30-34",null,4926.88,4051.32,2975.42,2576.33,1950.4,null,0,0,0,0,0]
[35,"35-39",null,5432.5,4533.09,3310.38,2862.53,2159.2200000000003,null,0,0,0,0,0]
[40,"40-44",null,6094.47,5179.16,3747.63,3241.48,2435.88,null,0,0,0,0,0]
[45,"45-49",null,7015.08,6062.14,4357.66,3761.4100000000003,2833.38,null,0,0,0,0,0]
[50,"50-54",null,7647.9000000000005,6674.29,4776.8900000000003,4130.8200000000006,3094.1400000000003,null,0,0,0,0,0]
[55,"55-59",null,8994.1,7972.26,5666.2300000000005,4891.37,{"$f":"$L$2*H415","v":3665.48},null,0,0,0,0,0]
[60,"60",null,9412.27,8515.51,5995.89,5177.5700000000006,3871.1200000000003,null,0,0,0,0,0]
[61,"61",null,10591.52,9581.34,6752.2000000000007,5832.12,4359.25,null,0,0,0,0,0]
[62,"62",null,11773.95,10656.710000000001,7506.92,6486.67,4851.62,null,0,0,0,0,0]
[63,"63",null,12956.91,11721.480000000001,8263.23,7135.39,5341.87,null,0,0,0,0,0]
[64,"64",null,14135.1,12797.380000000001,9010.5300000000007,7789.9400000000005,5832.12,null,0,0,0,0,0]
[65,"65",null,14153.650000000001,12916.630000000001,9071.48,7833.93,5855.97,null,0,0,0,0,0]
[66,"66",null,14173.26,13034.29,9120.77,7872.09,5875.05,null,0,0,0,0,0]
[67,"67",null,15747.36,14490.2,10147.380000000001,8749.77,6529.6,null,0,0,0,0,0]
[68,"68",null,17326.760000000002,15941.34,11159.68,{"$f":"$L$2*G424","v":9631.69},7192.63,null,0,0,0,0,0]
[69,"69",null,18118.05,16662.14,11672.19,10065.230000000001,7523.35,null,0,0,0,0,0]
[70,"70",null,18146.670000000002,16947.280000000002,11789.32,10168.050000000001,7555.68,null,0,0,0,0,0]
[71,"71",null,20426.2,19071.52,13271.730000000001,11444.82,8509.15,null,0,0,0,0,0]
[72,"72",null,22696.190000000002,21200,14750.960000000001,12726.890000000001,9458.91,null,0,0,0,0,0]
[73,"73",null,24977.84,23320.530000000002,16229.130000000001,13996.77,10411.85,null,0,0,0,0,0]
[74,"74",null,27248.890000000003,25440,17707.3,15273.54,11362.140000000001,null,0,0,0,0,0]
[75,"75+",null,29698.550000000003,27910.33,19367.79,16703.48,12411.54,null,0,0,0,0,0]
[1,"1 Child",null,1884.68,1109.8200000000002,926.97,798.71,589.89,null,0,0,0,0,0]
[2,"2 Children",null,3175.76,1650.42,1458.5600000000002,1264.05,932.80000000000007,null,0,0,0,0,0]
[3,"3+ Children",null,4660.29,2372.81,2121.59,1828.5,1350.97,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,4977,3897,2934,2544,1925,null,0,0,0,0,0]
[25,"25-29",null,5479,4396,3263,2843,2143,null,0,0,0,0,0]
[30,"30-34",null,6291,5181,3795,3294,2476,null,0,0,0,0,0]
[35,"35-39",null,6931,5788,4223,3663,2756,null,0,0,0,0,0]
[40,"40-44",null,7781,6607,4773,4147,3113,null,0,0,0,0,0]
[45,"45-49",null,8962,7753,5566,4825,3616,null,0,0,0,0,0]
[50,"50-54",null,9768,8537,6104,5295,3962,null,0,0,0,0,0]
[55,"55-59",null,11498,10198,7231,6285,4690,null,0,0,0,0,0]
[60,"60",null,12035,10895,7670,6648,4963,null,0,0,0,0,0]
[61,"61",null,13554,12267,8636,7496,5595,null,0,0,0,0,0]
[62,"62",null,15066,13636,9601,8338,6234,null,0,0,0,0,0]
[63,"63",null,16583,15007,10578,9173,6865,null,0,0,0,0,0]
[64,"64",null,18102,16386,11542,10013,7496,null,0,0,0,0,0]
[65,"65",null,18117,16543,11603,10072,7520,null,0,0,0,0,0]
[66,"66",null,18138,16683,11679,10118,7540,null,0,0,0,0,0]
[67,"67",null,20158,18553,12986,11253,8390,null,0,0,0,0,0]
[68,"68",null,22193,20413,14283,12392,9238,null,0,0,0,0,0]
[69,"69",null,23191,21348,14942,12949,9665,null,0,0,0,0,0]
[70,"70",null,23241,21709,15102,13082,9720,null,0,0,0,0,0]
[71,"71",null,26162,24436,16996,14729,10940,null,0,0,0,0,0]
[72,"72",null,29071,27169,18894,16367,12167,null,0,0,0,0,0]
[73,"73",null,32004,29882,20792,18015,13385,null,0,0,0,0,0]
[74,"74",null,34913,32617,22683,19659,14615,null,0,0,0,0,0]
[75,"75+",null,38061,35767,24819,21513,15978,null,0,0,0,0,0]
[1,"1 Child",null,2417,1429,1193,1035,766,null,0,0,0,0,0]
[2,"2 Children",null,4074,2118,1875,1625,1203,null,0,0,0,0,0]
[3,"3+ Children",null,5977,3046,2726,2359,1738,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":2637.81},{"$f":"$L$2*E475","v":2065.4100000000003},1555.02,1348.3200000000002,1020.25,null,0,0,0,0,0]
[25,"25-29",null,{"$f":"$L$2*D476","v":2903.8700000000003},2329.88,1729.39,1506.79,1135.79,null,0,0,0,0,0]
[30,"30-34",null,3334.23,2745.9300000000003,2011.3500000000001,1745.8200000000002,1312.28,null,0,0,0,0,0]
[35,"35-39",null,3673.4300000000003,3067.6400000000003,2238.19,{"$f":"$L$2*G478","v":1941.39},1460.68,null,0,0,0,0,0]
[40,"40-44",null,4123.93,3501.71,2529.69,2197.9100000000003,1649.89,null,0,0,0,0,0]
[45,"45-49",null,4749.8600000000006,4109.09,2949.98,2557.25,1916.48,null,0,0,0,0,0]
[50,"50-54",null,5177.04,4524.6100000000006,3235.1200000000003,2806.3500000000004,2099.86,null,0,0,0,0,0]
[55,"55-59",null,6093.9400000000005,5404.9400000000005,3832.4300000000003,{"$f":"$L$2*G482","v":3331.05},2485.7000000000003,null,0,0,0,0,0]
[60,"60",null,6378.55,5774.35,4065.1000000000004,3523.44,2630.3900000000003,null,0,0,0,0,0]
[61,"61",null,7183.6200000000008,6501.51,4577.08,3972.88,2965.3500000000004,null,0,0,0,0,0]
[62,"62",null,7984.9800000000005,7227.08,5088.5300000000007,4419.1400000000003,3304.02,null,0,0,0,0,0]
[63,"63",null,8788.99,7953.71,5606.34,4861.6900000000005,3638.4500000000003,null,0,0,0,0,0]
[64,"64",null,9594.0600000000013,8684.58,6117.26,5306.89,3972.88,null,0,0,0,0,0]
[65,"65",null,9602.01,8767.7900000000009,6149.59,5338.16,3985.6000000000004,null,0,0,0,0,0]
[66,"66",null,9613.1400000000012,{"$f":"$L$2*E489","v":8841.99},6189.87,5362.54,3996.2000000000003,null,0,0,0,0,0]
[67,"67",null,10683.74,9833.09,6882.58,5964.09,4446.7,null,0,0,0,0,0]
[68,"68",null,11762.29,{"$f":"$L$2*E491","v":10818.890000000001},7569.9900000000007,6567.76,4896.1400000000003,null,0,0,0,0,0]
[69,"69",null,12291.230000000001,11314.44,7919.26,6862.97,5122.45,null,0,0,0,0,0]
[70,"70",null,12317.730000000001,11505.77,8004.06,6933.46,5151.6000000000004,null,0,0,0,0,0]
[71,"71",null,13865.86,12951.08,9007.880000000001,7806.3700000000008,5798.2000000000007,null,0,0,0,0,0]
[72,"72",null,15407.630000000001,14399.570000000002,10013.82,8674.51,{"$f":"$L$2*H495","v":6448.51},null,0,0,0,0,0]
[73,"73",null,16962.120000000003,15837.460000000001,11019.76,9547.9500000000007,7094.05,null,0,0,0,0,0]
[74,"74",null,18503.89,17287.010000000002,12021.99,10419.27,7745.9500000000007,null,0,0,0,0,0]
[75,"75+",null,{"$f":"$L$2*D498","v":20172.330000000002},18956.510000000002,13154.070000000002,11401.890000000001,8468.34,null,0,0,0,0,0]
[1,"1 Child",null,1281.01,757.37,632.29000000000008,548.55000000000007,405.98,null,0,0,0,0,0]
[2,"2 Children",null,2159.2200000000003,1122.54,993.75,861.25,637.59,null,0,0,0,0,0]
[3,"3+ Children",null,3167.81,1614.38,1444.78,1250.27,921.1400000000001,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",5129,9319,13529,4462,7935,11418,3742,6772,9785,2873,5138,7399,2038,3574,5118,1147,1910,2678]
[50,"o más",6592,10793,14993,5728,9202,12682,4804,7822,10829,3665,5923,8193,2560,4122,5643,1414,2187,2954]
[]
["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":"$L$2*C543","v":2718.3700000000003},{"$f":"$L$2*D543","v":4939.0700000000006},7170.3700000000008,2364.86,4205.55,6051.54,1983.26,3589.1600000000003,5186.05,1522.69,2723.1400000000003,3921.4700000000003,1080.1400000000001,1894.22,2712.54,607.91000000000008,1012.3000000000001,1419.3400000000001]
[75,"o más",{"$f":"$L$2*C544","v":3493.76},{"$f":"$L$2*D544","v":5720.29},7946.29,3035.84,4877.0600000000004,6721.46,2546.1200000000003,4145.66,5739.37,1942.45,3139.19,4342.29,1356.8000000000002,2184.6600000000003,2990.79,749.42000000000007,1159.1100000000001,1565.6200000000001]