{"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":11,"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," "," "," "," "]
[]
["Cotización de Seguro Médico Internacional: para nuevos negocios a partir de enero 1, 2023 y renovaciones de pólizas emitidas en 2022"]
[]
["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: ",3]
[]
[null,null,null,null,null," Edad del titular: ",74,null,"Edad de cónyuge: ",74]
[]
[]
[" INGRESE EL NOMBRE DE LA AGENCIA ASESORA: "]
[]
[null,null,"Nombre de la Agencia: ","NOMBRE DE LA AGENCIA/AGENTE"]
[]
[]
["ESCOJA EL PRODUCTO PARA VISUALIZAR LA COTIZACION RESPECTIVA: "]

{"sheet":"Exclusive","index":1,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[48,5,49,12],[31,0,31,1],[32,0,32,1],[31,2,31,3],[43,2,43,3],[38,0,38,1],[33,2,33,3],[32,2,32,3],[40,2,40,3],[41,2,41,3],[38,2,38,3],[42,2,42,3],[39,2,39,3],[34,2,34,3],[47,0,48,1],[47,2,48,3],[9,2,9,12],[27,0,27,1],[30,2,30,3],[27,2,27,3],[28,0,28,1],[29,0,30,1],[11,7,11,12],[13,7,13,12],[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],[46,5,46,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],[29,2,29,3],[45,2,45,3],[17,2,18,3],[28,2,28,3],[24,2,24,3],[22,2,22,3],[44,2,44,3],[25,2,25,3],[26,2,26,3],[42,0,42,1],[43,0,43,1],[41,0,41,1],[22,0,22,1],[26,0,26,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[28,5,28,12],[37,5,37,12],[50,0,50,1],[50,2,50,3],[49,0,49,1],[49,2,49,3],[46,0,46,1],[46,2,46,3],[34,0,34,1],[35,0,37,1],[35,2,37,3],[45,0,45,1],[33,0,33,1],[44,0,44,1],[39,0,39,1],[40,0,40,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 EXCLUSIVE Care"]
[]
[null,null,null,null,null,null,"Nombre del asegurado :",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,"Broker / Agente :",{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,"Número de adultos en la póliza:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular :",{"$f":"+'INGRESO DE DATOS'!$G$16","v":74}]
[]
[null,null,null,null,null,null,null,null,"Número hijos (menos 24 de años):",{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,"Edad de Cónyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":74}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,"Fecha de cotización: ",{"$f":"NOW()","v":"2022-12-22T15:39:02.120"}]
[]
[]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[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":75617.31},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,5,TRUE)","v":51944.43},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,6,TRUE)","v":36199.26},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,7,TRUE)","v":31717.72},{"$f":"VLOOKUP($M$16,Tablas!$A$6:$H$29,8,TRUE)","v":27539}]
[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":75617.31},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,5,TRUE)))","v":51944.43},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,6,TRUE)))","v":36199.26},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,7,TRUE)))","v":31717.72},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$6:$H$29,8,TRUE)))","v":27539}]
[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":6869.3099999999995},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,5,TRUE)))","v":5061.21},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,6,TRUE)))","v":3893.54},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,7,TRUE)))","v":3219.2999999999997},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$30:$H$32,8,TRUE)))","v":2506.84}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$23=FALSE,0,Tablas!D$33)","v":0},{"$f":"+IF($I$23=FALSE,0,Tablas!E$33)","v":0},{"$f":"+IF($I$23=FALSE,0,Tablas!F$33)","v":0},{"$f":"+IF($I$23=FALSE,0,Tablas!G$33)","v":0},{"$f":"+IF($I$23=FALSE,0,Tablas!H$33)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I30:I33)","v":158103.93},{"$f":"SUM(J30:J33)","v":108950.07},{"$f":"SUM(K30:K33)","v":76292.06},{"$f":"SUM(L30:L33)","v":66654.740000000005},{"$f":"SUM(M30:M33)","v":57584.84}]
[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(I34:I35)","v":158178.93},{"$f":"SUM(J34:J35)","v":109025.07},{"$f":"SUM(K34:K35)","v":76367.06},{"$f":"SUM(L34:L35)","v":66729.740000000005},{"$f":"SUM(M34:M35)","v":57659.839999999997}]
[]
[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":40077.174299999999},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,5,TRUE)","v":27530.547900000001},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,6,TRUE)","v":19185.607800000002},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,7,TRUE)","v":16810.391600000003},{"$f":"VLOOKUP($M$16,Tablas!$A$39:$H$62,8,TRUE)","v":14595.67}]
[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":40077.174299999999},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,5,TRUE)))","v":27530.547900000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,6,TRUE)))","v":19185.607800000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,7,TRUE)))","v":16810.391600000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$39:$H$62,8,TRUE)))","v":14595.67}]
[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":3640.7343000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,5,TRUE)))","v":2682.4413},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,6,TRUE)))","v":2063.5762},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,7,TRUE)))","v":1706.229},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$63:$H$65,8,TRUE)))","v":1328.6252000000002}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$23=FALSE,0,Tablas!D$66)","v":0},{"$f":"+IF($I$23=FALSE,0,Tablas!E$66)","v":0},{"$f":"+IF($I$23=FALSE,0,Tablas!F$66)","v":0},{"$f":"+IF($I$23=FALSE,0,Tablas!G$66)","v":0},{"$f":"+IF($I$23=FALSE,0,Tablas!H$66)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I39:I42)","v":83795.082899999994},{"$f":"SUM(J39:J42)","v":57743.537100000001},{"$f":"SUM(K39:K42)","v":40434.791800000006},{"$f":"SUM(L39:L42)","v":35327.012200000005},{"$f":"SUM(M39:M42)","v":30519.965199999999}]
[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(I43:I44)","v":83870.082899999994},{"$f":"SUM(J43:J44)","v":57818.537100000001},{"$f":"SUM(K43:K44)","v":40509.791800000006},{"$f":"SUM(L43:L44)","v":35402.012200000005},{"$f":"SUM(M43:M44)","v":30594.965199999999}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I43","v":83795.082899999994},{"$f":"J43","v":57743.537100000001},40434.791800000006,35327.012200000005,30519.965199999999]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 1ro. de enero de 2023"]
[]
[null,null,null,null,null,"Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]
[]
[]
[null," "]

{"sheet":"Privilege","index":2,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,5,48,12],[9,2,9,12],[11,7,11,12],[13,7,13,12],[11,0,11,3],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[45,5,45,12],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[21,0,21,1],[17,0,18,1],[22,0,22,1],[27,2,27,3],[30,0,30,1],[27,0,27,1],[26,0,26,1],[28,0,29,1],[17,2,18,3],[28,2,28,3],[23,2,23,3],[21,2,21,3],[25,2,25,3],[22,2,22,3],[23,0,23,1],[24,2,24,3],[38,0,38,1],[39,0,39,1],[38,2,38,3],[37,0,37,1],[37,2,37,3],[24,0,24,1],[26,2,26,3],[30,2,30,3],[25,0,25,1],[35,0,35,1],[27,5,27,12],[29,2,29,3],[32,0,32,1],[36,5,36,12],[36,0,36,1],[32,2,32,3],[31,0,31,1],[31,2,31,3],[33,0,33,1],[34,2,34,3],[35,2,35,3],[36,2,36,3],[33,2,33,3],[34,0,34,1],[47,0,47,1],[47,2,47,3],[46,0,46,1],[46,2,46,3],[39,2,39,3],[44,2,45,3],[42,0,42,1],[42,2,42,3],[43,0,43,1],[43,2,43,3],[44,0,45,1],[40,2,40,3],[41,0,41,1],[41,2,41,3],[40,0,40,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 PRIVILEGE Care"]
[]
[null,null,null,null,null,null,"Nombre del asegurado :",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,"Broker / Agente :",{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,"Número de adultos en la póliza:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular :",{"$f":"+'INGRESO DE DATOS'!$G$16","v":74}]
[]
[null,null,null,null,null,null,null,null,"Número hijos (menos 24 de años):",{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,"Edad de Cónyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":74}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,"Fecha de cotización: ",{"$f":"NOW()","v":"2022-12-22T15:39:02.120"}]
[]
[null,null,null,null,null,null,null,null,false,null,"COMPLICACIONES DE MATERNIDAD"]
[]
[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":64991.17},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,5,TRUE)","v":45425.47},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,6,TRUE)","v":31385.01},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,7,TRUE)","v":27747.739999999998},{"$f":"VLOOKUP($M$16,Tablas!$A$140:$H$163,8,TRUE)","v":23784.13}]
[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":64991.17},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,5,TRUE)))","v":45425.47},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,6,TRUE)))","v":31385.01},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,7,TRUE)))","v":27747.739999999998},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$140:$H$163,8,TRUE)))","v":23784.13}]
[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":5761.42},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,5,TRUE)))","v":4210.57},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,6,TRUE)))","v":3078.67},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,7,TRUE)))","v":2549.4699999999998},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$164:$H$166,8,TRUE)))","v":1887.97}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$22=FALSE,0,Tablas!D$167)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!E$167)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!F$167)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!G$167)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!H$167)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I29:I32)","v":135743.76},{"$f":"SUM(J29:J32)","v":95061.510000000009},{"$f":"SUM(K29:K32)","v":65848.69},{"$f":"SUM(L29:L32)","v":58044.95},{"$f":"SUM(M29:M32)","v":49456.23}]
[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(I33:I34)","v":135818.76},{"$f":"SUM(J33:J34)","v":95136.510000000009},{"$f":"SUM(K33:K34)","v":65923.69},{"$f":"SUM(L33:L34)","v":58119.95},{"$f":"SUM(M33:M34)","v":49531.23}]
[]
[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":34445.320099999997},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,5,TRUE)","v":24075.499100000001},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,6,TRUE)","v":16634.0553},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,7,TRUE)","v":14706.3022},{"$f":"VLOOKUP($M$16,Tablas!$A$173:$H$196,8,TRUE)","v":12605.588900000001}]
[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":34445.320099999997},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,5,TRUE)))","v":24075.499100000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,6,TRUE)))","v":16634.0553},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,7,TRUE)))","v":14706.3022},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$173:$H$196,8,TRUE)))","v":12605.588900000001}]
[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":3053.5526},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,5,TRUE)))","v":2231.6021000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,6,TRUE)))","v":1631.6951000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,7,TRUE)))","v":1351.2191},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$197:$H$199,8,TRUE)))","v":1000.6241000000001}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$22=FALSE,0,Tablas!D$200)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!E$200)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!F$200)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!G$200)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!H$200)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I38:I41)","v":71944.19279999999},{"$f":"SUM(J38:J41)","v":50382.600300000006},{"$f":"SUM(K38:K41)","v":34899.805699999997},{"$f":"SUM(L38:L41)","v":30763.823499999999},{"$f":"SUM(M38:M41)","v":26211.801900000002}]
[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(I42:I43)","v":72019.19279999999},{"$f":"SUM(J42:J43)","v":50457.600300000006},{"$f":"SUM(K42:K43)","v":34974.805699999997},{"$f":"SUM(L42:L43)","v":30838.823499999999},{"$f":"SUM(M42:M43)","v":26286.801900000002}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I42","v":71944.19279999999},{"$f":"J42","v":50382.600300000006},34899.805699999997,30763.823499999999,26211.801900000002]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 1ro. de enero de 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],[9,2,9,12],[11,7,11,12],[13,7,13,12],[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],[51,2,52,3],[35,2,39,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,18,3],[27,2,27,3],[25,2,25,3],[28,0,28,1],[49,2,49,3],[30,2,30,3],[31,2,31,3],[28,2,28,3],[29,2,29,3],[33,2,33,3],[40,2,41,3],[29,0,29,1],[47,0,47,1],[50,2,50,3],[46,2,46,3],[44,2,44,3],[21,2,21,3],[23,2,23,3],[22,2,22,3],[26,2,26,3],[24,2,24,3],[42,2,42,3],[34,2,34,3],[32,2,32,3],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[21,0,21,1],[22,0,23,1],[29,5,29,12],[39,5,39,12],[30,0,31,1],[48,0,48,1],[42,0,42,1],[32,0,32,1],[54,0,54,1],[54,2,54,3],[53,0,53,1],[53,2,53,3],[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],[49,0,49,1],[50,0,50,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,"Nombre del asegurado :",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,"Broker / Agente :",{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,"Número de adultos en la póliza:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular :",{"$f":"+'INGRESO DE DATOS'!$G$16","v":74}]
[]
[null,null,null,null,null,null,null,null,"Número hijos (menos 24 de años):",{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,"Edad de Cónyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":74}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,"Fecha de cotización: ",{"$f":"NOW()","v":"2022-12-22T15:39:02.120"}]
[]
[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$274:$H$297,4,TRUE)","v":45102.12},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,5,TRUE)","v":35014.1},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,6,TRUE)","v":24691.29},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,7,TRUE)","v":19101.38},{"$f":"VLOOKUP($M$16,Tablas!$A$274:$H$297,8,TRUE)","v":15431.660000000002}]
[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":45102.12},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,5,TRUE)))","v":35014.1},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,6,TRUE)))","v":24691.29},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,7,TRUE)))","v":19101.38},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$274:$H$297,8,TRUE)))","v":15431.660000000002}]
[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":5353},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,5,TRUE)))","v":3675.02},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,6,TRUE)))","v":2748.05},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,7,TRUE)))","v":2362.21},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$298:$H$300,8,TRUE)))","v":1657.8400000000001}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$22=FALSE,0,Tablas!D$301)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!E$301)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!F$301)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!G$301)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!H$301)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$24=FALSE,0,Tablas!D$302)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!E$302)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!F$302)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!G$302)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!H$302)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":95557.24},73703.22,52130.630000000005,40564.97,32521.160000000003]
[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":95632.24},{"$f":"SUM(J36:J37)","v":73778.22},{"$f":"SUM(K36:K37)","v":52205.630000000005},{"$f":"SUM(L36:L37)","v":40639.97},{"$f":"SUM(M36:M37)","v":32596.160000000003}]
[]
[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":23904.123600000003},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,5,TRUE)","v":18557.473000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,6,TRUE)","v":13086.3837},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,7,TRUE)","v":10123.731400000001},{"$f":"VLOOKUP($M$16,Tablas!$A$307:$H$330,8,TRUE)","v":8178.7798000000012}]
[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":23904.123600000003},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,5,TRUE)))","v":18557.473000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,6,TRUE)))","v":13086.3837},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,7,TRUE)))","v":10123.731400000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$307:$H$330,8,TRUE)))","v":8178.7798000000012}]
[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":2837.09},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,5,TRUE)))","v":1947.7606000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,6,TRUE)))","v":1456.4665000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,7,TRUE)))","v":1251.9713000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$331:$H$333,8,TRUE)))","v":878.65520000000015}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$22=FALSE,0,Tablas!D$334)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!E$334)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!F$334)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!G$334)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!H$334)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$24=FALSE,0,Tablas!D$335)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!E$335)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!F$335)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!G$335)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!H$335)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":50645.337200000009},39062.706600000005,27629.233899999999,21499.434100000002,17236.214800000002]
[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":50720.337200000009},{"$f":"SUM(J46:J47)","v":39137.706600000005},{"$f":"SUM(K46:K47)","v":27704.233899999999},{"$f":"SUM(L46:L47)","v":21574.434100000002},{"$f":"SUM(M46:M47)","v":17311.214800000002}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":50645.337200000009},{"$f":"J46","v":39062.706600000005},27629.233899999999,21499.434100000002,17236.214800000002]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 1ro. de enero de 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":"NOMBRE DE LA AGENCIA/AGENTE"}]
["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":74}]
["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":"2022-12-22T15:39:02.120"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":74}]
[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":66124},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,5,TRUE)","v":51319},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,6,TRUE)","v":36208},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,7,TRUE)","v":27987},{"$f":"VLOOKUP($M$16,Tablas!$A$341:$H$364,8,TRUE)","v":22614}]
[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":66124},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,5,TRUE)))","v":51319},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,6,TRUE)))","v":36208},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,7,TRUE)))","v":27987},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$341:$H$364,8,TRUE)))","v":22614}]
["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":7845},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,5,TRUE)))","v":5394},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,6,TRUE)))","v":4041},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,7,TRUE)))","v":3473},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$365:$H$367,8,TRUE)))","v":2440}]
["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":140093},108032,76457,59447,47668]
["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":140168},{"$f":"SUM(J36:J37)","v":108107},{"$f":"SUM(K36:K37)","v":76532},{"$f":"SUM(L36:L37)","v":59522},{"$f":"SUM(M36:M37)","v":47743}]
["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":35045.72},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,5,TRUE)","v":27199.07},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,6,TRUE)","v":19190.240000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,7,TRUE)","v":14833.11},{"$f":"VLOOKUP($M$16,Tablas!$A$374:$H$397,8,TRUE)","v":11985.42}]
["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":35045.72},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,5,TRUE)))","v":27199.07},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,6,TRUE)))","v":19190.240000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,7,TRUE)))","v":14833.11},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$374:$H$397,8,TRUE)))","v":11985.42}]
["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":4157.8500000000004},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,5,TRUE)))","v":2858.82},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,6,TRUE)))","v":2141.73},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,7,TRUE)))","v":1840.69},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$398:$H$400,8,TRUE)))","v":1293.2}]
["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":74249.290000000008},57256.959999999999,40522.210000000006,31506.91,25264.04]
[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":74324.290000000008},{"$f":"SUM(J46:J47)","v":57331.96},{"$f":"SUM(K46:K47)","v":40597.210000000006},{"$f":"SUM(L46:L47)","v":31581.91},{"$f":"SUM(M46:M47)","v":25339.040000000001}]
[null," ",null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":74249.290000000008},{"$f":"J46","v":57256.959999999999},40522.210000000006,31506.91,25264.04]
[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],[21,0,21,1],[11,7,11,12],[13,7,13,12],[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],[27,0,27,1],[22,2,22,3],[17,2,18,3],[21,2,21,3],[23,2,23,3],[16,0,16,1],[24,2,24,3],[25,2,25,3],[27,2,27,3],[26,2,26,3],[34,2,34,3],[28,0,28,1],[30,0,31,1],[29,0,29,1],[32,0,32,1],[28,2,28,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],[24,0,24,1],[25,0,25,1],[26,0,26,1],[22,0,23,1],[49,5,49,12],[46,2,46,3],[42,2,42,3],[42,0,42,1],[49,0,49,1],[49,2,49,3],[29,5,29,12],[39,5,39,12],[43,2,43,3],[44,2,44,3],[43,0,43,1],[35,2,39,3],[40,2,41,3],[32,2,32,3],[29,2,29,3],[30,2,30,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,"Nombre del asegurado :",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,"Broker / Agente :",{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,"Número de adultos en la póliza:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular :",{"$f":"+'INGRESO DE DATOS'!$G$16","v":74}]
[]
[null,null,null,null,null,null,null,null,"Número hijos (menos 24 de años):",{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,"Edad de Cónyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":74}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,"Fecha de cotización: ",{"$f":"NOW()","v":"2022-12-22T15:39:02.120"}]
[]
[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$408:$H$431,4,TRUE)","v":25471.9},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,5,TRUE)","v":23783.24},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,6,TRUE)","v":15481.62},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,7,TRUE)","v":12667.34},{"$f":"VLOOKUP($M$16,Tablas!$A$408:$H$431,8,TRUE)","v":9427.1}]
[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":25471.9},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,5,TRUE)))","v":23783.24},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,6,TRUE)))","v":15481.62},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,7,TRUE)))","v":12667.34},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$408:$H$431,8,TRUE)))","v":9427.1}]
[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":4351.1400000000003},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,5,TRUE)))","v":2220.42},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,6,TRUE)))","v":1849.66},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,7,TRUE)))","v":1510.18},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$432:$H$434,8,TRUE)))","v":1120.1000000000001}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$22=FALSE,0,Tablas!D$435)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!E$435)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!F$435)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!G$435)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!H$435)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$24=FALSE,0,Tablas!D$436)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!E$436)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!F$436)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!G$436)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!H$436)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":55294.94},49786.9,32812.9,26844.86,19974.3]
[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":55369.94},{"$f":"SUM(J36:J37)","v":49861.9},{"$f":"SUM(K36:K37)","v":32887.9},{"$f":"SUM(L36:L37)","v":26919.86},{"$f":"SUM(M36:M37)","v":20049.3}]
[]
[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":13500.107000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,5,TRUE)","v":12605.117200000001},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,6,TRUE)","v":8205.258600000001},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,7,TRUE)","v":6713.6902},{"$f":"VLOOKUP($M$16,Tablas!$A$441:$H$464,8,TRUE)","v":4996.3630000000003}]
[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":13500.107000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,5,TRUE)))","v":12605.117200000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,6,TRUE)))","v":8205.258600000001},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,7,TRUE)))","v":6713.6902},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$441:$H$464,8,TRUE)))","v":4996.3630000000003}]
[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":2306.1042000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,5,TRUE)))","v":1176.8226000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,6,TRUE)))","v":980.3198000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,7,TRUE)))","v":800.39540000000011},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$465:$H$467,8,TRUE)))","v":593.65300000000013}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$22=FALSE,0,Tablas!D$468)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!E$468)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!F$468)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!G$468)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!H$468)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$24=FALSE,0,Tablas!D$469)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!E$469)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!F$469)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!G$469)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!H$469)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":29306.318200000005},26387.057000000001,17390.837000000003,14227.775799999999,10586.379000000001]
[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":29381.318200000005},{"$f":"SUM(J46:J47)","v":26462.057000000001},{"$f":"SUM(K46:K47)","v":17465.837000000003},{"$f":"SUM(L46:L47)","v":14302.775799999999},{"$f":"SUM(M46:M47)","v":10661.379000000001}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":29306.318200000005},{"$f":"J46","v":26387.057000000001},17390.837000000003,14227.775799999999,10586.379000000001]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 1ro. de enero de 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],[42,2,42,3],[49,0,49,1],[49,2,49,3],[26,2,26,3],[26,0,26,1],[27,0,27,1],[27,2,27,3],[32,2,32,3],[31,2,31,3],[29,0,29,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],[16,2,16,3],[22,2,22,3],[17,2,18,3],[29,2,29,3],[30,2,30,3],[24,2,24,3],[25,2,25,3],[21,2,21,3],[33,2,33,3],[35,2,39,3],[29,5,29,12],[39,5,39,12],[50,0,50,1],[50,2,50,3],[30,0,31,1],[33,0,33,1],[34,0,34,1],[35,0,41,1],[40,2,41,3],[32,0,32,1],[21,0,21,1],[28,0,28,1],[28,2,28,3],[11,7,11,12],[13,7,13,12],[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],[23,2,23,3],[22,0,23,1],[24,0,24,1],[25,0,25,1]]}
[]
[null,null,null,null,null,null,null,null,null," "," "," "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "," "," "," "]
[]
[]
[]
[null,null,"Cotización de Seguro Médico Internacional - Bupa ESSENTIAL Care"]
[]
[null,null,null,null,null,null,"Nombre del asegurado :",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,"Broker / Agente :",{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,"Número de adultos en la póliza:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular :",{"$f":"+'INGRESO DE DATOS'!$G$16","v":74}]
[]
[null,null,null,null,null,null,null,null,"Número hijos (menos 24 de años):",{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,"Edad de Cónyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":74}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,"Fecha de cotización: ",{"$f":"NOW()","v":"2022-12-22T15:39:02.120"}]
[]
[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":17905.37},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,5,TRUE)","v":16720.16},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,6,TRUE)","v":10884.59},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,7,TRUE)","v":8906.9},{"$f":"VLOOKUP($M$16,Tablas!$A$475:$H$498,8,TRUE)","v":6628.13}]
[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":17905.37},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,5,TRUE)))","v":16720.16},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,6,TRUE)))","v":10884.59},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,7,TRUE)))","v":8906.9},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$475:$H$498,8,TRUE)))","v":6628.13}]
[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":3057.9900000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,5,TRUE)))","v":1558.8300000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,6,TRUE)))","v":1302.6000000000001},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,7,TRUE)))","v":1060.8},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$499:$H$501,8,TRUE)))","v":784.68000000000006}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$22=FALSE,0,Tablas!D$502)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!E$502)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!F$502)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!G$502)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!H$502)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$24=FALSE,0,Tablas!D$503)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!E$503)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!F$503)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!G$503)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!H$503)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I31:I35)","v":38868.729999999996},34999.15,23071.78,18874.599999999999,14040.94]
[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":38943.729999999996},{"$f":"SUM(J36:J37)","v":35074.15},{"$f":"SUM(K36:K37)","v":23146.78},{"$f":"SUM(L36:L37)","v":18949.599999999999},{"$f":"SUM(M36:M37)","v":14115.94}]
[]
[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":9489.8461000000007},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,5,TRUE)","v":8861.6848000000009},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,6,TRUE)","v":5768.8326999999999},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,7,TRUE)","v":4720.6570000000002},{"$f":"VLOOKUP($M$16,Tablas!$A$508:$H$531,8,TRUE)","v":3512.9089000000004}]
[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":9489.8461000000007},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,5,TRUE)))","v":8861.6848000000009},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,6,TRUE)))","v":5768.8326999999999},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,7,TRUE)))","v":4720.6570000000002},{"$f":"IF($J$16=1,0,(VLOOKUP($M$18,Tablas!$A$508:$H$531,8,TRUE)))","v":3512.9089000000004}]
[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":1620.7347000000002},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,5,TRUE)))","v":826.17990000000009},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,6,TRUE)))","v":690.37800000000016},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,7,TRUE)))","v":562.22400000000005},{"$f":"IF($J$18=0,0,(VLOOKUP($J$18,Tablas!$A$532:$H$534,8,TRUE)))","v":415.88040000000007}]
[null,null,null,null,null,"Prima Rider Complic. Maternidad",null,"n/a",{"$f":"+IF($I$22=FALSE,0,Tablas!D$535)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!E$535)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!F$535)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!G$535)","v":0},{"$f":"+IF($I$22=FALSE,0,Tablas!H$535)","v":0}]
[null,null,null,null,null,"Prima Rider Trasplante Organos",null,"n/a",{"$f":"IF($I$24=FALSE,0,Tablas!D$536)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!E$536)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!F$536)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!G$536)","v":0},{"$f":"IF($I$24=FALSE,0,Tablas!H$536)","v":0}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,"n/a",{"$f":"SUM(I41:I45)","v":20600.426900000002},18549.549500000001,12228.0434,10003.538,7441.6982000000007]
[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":20675.426900000002},{"$f":"SUM(J46:J47)","v":18624.549500000001},{"$f":"SUM(K46:K47)","v":12303.0434},{"$f":"SUM(L46:L47)","v":10078.538},{"$f":"SUM(M46:M47)","v":7516.6982000000007}]
[null,null,null,null,null,"GRAN TOTAL  (2da Cuota) :",null,"n/a",{"$f":"I46","v":20600.426900000002},{"$f":"J46","v":18549.549500000001},12228.0434,10003.538,7441.6982000000007]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 1ro. de enero de 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],[9,2,9,12],[11,7,11,12],[13,7,13,12],[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],[26,2,26,3],[17,2,18,3],[19,2,19,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],[33,8,33,9],[45,2,45,3],[23,10,24,11],[33,10,36,12],[21,5,22,7],[21,8,22,9],[27,2,27,3],[28,2,28,3],[41,2,41,3],[30,2,31,3],[31,10,31,11],[23,8,23,9],[24,8,24,9],[21,10,22,12],[35,8,35,9],[36,8,36,9],[25,10,25,11],[20,0,21,1],[21,2,21,3],[22,2,22,3],[16,2,16,3],[25,0,25,1],[25,2,25,3],[23,2,23,3],[24,2,24,3],[19,0,19,1],[22,0,23,1],[24,0,24,1],[44,0,44,1],[32,0,32,1],[35,0,39,1],[33,0,33,1],[34,0,34,1],[43,0,43,1],[27,0,27,1],[28,0,28,1],[34,2,34,3],[42,2,42,3],[42,0,42,1],[40,2,40,3],[29,0,29,1],[30,0,31,1],[29,2,29,3],[32,2,32,3],[33,2,33,3],[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,5,42,12],[25,8,25,9],[26,8,26,9],[26,10,26,11],[27,10,27,11],[32,10,32,11],[31,8,31,9],[32,8,32,9],[28,10,28,11],[29,10,29,11],[30,10,30,11]]}
[]
[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,"Nombre del asegurado :",{"$f":"+'INGRESO DE DATOS'!$D$12","v":"NOMBRE COMPLETO"}]
[]
[null,null,null,null,null,null,"Broker / Agente :",{"$f":"+'INGRESO DE DATOS'!$D$21","v":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,null,null,null,null,"Número de adultos en la póliza:",{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,"Edad de Titular :",{"$f":"+'INGRESO DE DATOS'!$G$16","v":74}]
[]
[null,null,null,null,null,null,null,null,"Número hijos (menos 24 de años):",{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,"Edad de Cónyuge:",{"$f":"+'INGRESO DE DATOS'!$J$16","v":74}]
[null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,"Fecha de cotización: ",{"$f":"NOW()","v":"2022-12-22T15:39:02.120"},null,"Edad del adulto mayor en la pareja :",{"$f":"IF(M16>=M18,M16,M18)","v":74}]
[]
[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":10467},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,8,TRUE)),0)","v":8126},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,11,TRUE)),0)","v":6980},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,14,TRUE)),0)","v":5352},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,17,TRUE)),0)","v":3782},{"$f":"IF((($J$16+$J$18)>=3),(VLOOKUP($M$20,Tablas!$A$543:$T$544,20,TRUE)),0)","v":2065}]
[null,null,null,null,null,"TOTAL PRIMA NETA :",null,{"$f":"SUM(H44:H46)","v":10467},{"$f":"SUM(I44:I46)","v":8126},6980,5352,3782,2065]
[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":10542},8201,7055,5427,3857,2140]
[null,null,null,null,null,"Tarifas en US$ —  Válidas desde 1ro. de enero de 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],[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":"NOMBRE DE LA AGENCIA/AGENTE"}]
[]
[null,null,null,null,{"$f":"+'INGRESO DE DATOS'!$G$14","v":2},null,null,{"$f":"+'INGRESO DE DATOS'!$G$16","v":74}]
["FECHA DE COTIZACION :"]
[{"$f":"NOW()","v":"2022-12-22T15:39:02.120"},null,null,null,{"$f":"+'INGRESO DE DATOS'!$J$14","v":3},null,null,{"$f":"+'INGRESO DE DATOS'!$J$16","v":74}]
[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!I36","v":158178.93},{"$f":"+Exclusive!J36","v":109025.07},{"$f":"+Exclusive!K36","v":76367.06},{"$f":"+Exclusive!L36","v":66729.740000000005},{"$f":"+Exclusive!M36","v":57659.839999999997}]
["Bupa Privilege Care",null,"n/a",{"$f":"+Privilege!I35","v":135818.76},{"$f":"+Privilege!J35","v":95136.510000000009},{"$f":"+Privilege!K35","v":65923.69},{"$f":"+Privilege!L35","v":58119.95},{"$f":"+Privilege!M35","v":49531.23}]
["Bupa Advantage Care",null,"n/a",{"$f":"+'Advantage (Mundial)'!I38","v":95632.24},{"$f":"+'Advantage (Mundial)'!J38","v":73778.22},{"$f":"+'Advantage (Mundial)'!K38","v":52205.630000000005},{"$f":"+'Advantage (Mundial)'!L38","v":40639.97},{"$f":"+'Advantage (Mundial)'!M38","v":32596.160000000003}]
["Bupa Secure Care",null,"n/a",{"$f":"+Secure!I38","v":55369.94},{"$f":"+Secure!J38","v":49861.9},{"$f":"+Secure!K38","v":32887.9},{"$f":"+Secure!L38","v":26919.86},{"$f":"+Secure!M38","v":20049.3}]
["Bupa Essential Care",null,"n/a",{"$f":"+Essential!I38","v":38943.729999999996},{"$f":"+Essential!J38","v":35074.15},{"$f":"+Essential!K38","v":23146.78},{"$f":"+Essential!L38","v":18949.599999999999},{"$f":"+Essential!M38","v":14115.94}]
[]
["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":10542},{"$f":"+Critical!I49","v":8201},{"$f":"+Critical!J49","v":7055},{"$f":"+Critical!K49","v":5427},{"$f":"+Critical!L49","v":3857},{"$f":"+Critical!M49","v":2140}]
["Tarifas en US$ —  Válidas desde 1ro. de enero de 2023"]
[]
["Este presupuesto solamente tiene carácter informativo y en ningún momento expresa compromiso legal para suministrarle cobertura de seguro. La emisión de una póliza de seguro Bupa está sujeta a todas las evaluaciones de riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"Comparacion de Beneficios","index":9,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,3,6],[4,1,4,6],[10,0,12,0],[14,0,15,0],[16,0,17,0],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[26,3,27,3],[26,4,27,4],[26,5,27,5],[28,0,29,0],[30,0,31,0],[18,0,20,0],[38,0,42,0],[25,0,27,0],[26,1,27,1],[26,2,27,2],[32,0,34,0],[32,1,34,1],[32,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[32,6,34,6],[40,4,42,4],[40,5,42,5],[39,6,42,6]]}
[]
[null,"2023 BUPA CARE COMPARACION DE BENEFICIOS"]

{"sheet":"Tablas","index":10,"n_rows":561,"n_cols":20,"rows_kept":561,"cut":false,"hidden":true,"merged":[[1,0,1,7],[2,0,2,7],[36,0,36,1],[36,2,36,6],[35,0,35,7],[3,0,3,1],[3,2,3,6],[135,0,135,7],[69,0,69,7],[70,0,70,1],[70,2,70,6],[203,0,203,7],[136,0,136,7],[137,0,137,1],[137,2,137,6],[169,0,169,7],[170,0,170,1],[68,0,68,7],[102,0,102,7],[103,0,103,1],[103,2,103,6],[303,0,303,7],[269,0,269,7],[270,0,270,7],[271,0,271,1],[271,2,271,6],[170,2,170,6],[202,0,202,7],[236,0,236,7],[237,0,237,1],[237,2,237,6],[204,0,204,1],[204,2,204,6],[470,0,470,7],[403,0,403,7],[404,0,404,7],[405,0,405,1],[405,2,405,6],[304,2,304,6],[336,0,336,7],[437,0,437,7],[438,0,438,1],[438,2,438,6],[304,0,304,1],[370,0,370,7],[371,0,371,1],[371,2,371,6],[337,0,337,7],[338,0,338,1],[338,2,338,6],[539,0,539,1],[471,0,471,7],[472,0,472,1],[472,2,472,6],[504,0,504,7],[505,0,505,1],[505,2,505,6],[538,0,538,19],[537,0,537,19],[539,2,539,6],[540,14,540,16],[540,17,540,19],[547,14,547,16],[547,17,547,19],[545,0,545,19],[540,2,540,4],[547,2,547,4],[547,5,547,7],[547,8,547,10],[546,0,546,1],[546,2,546,6],[540,5,540,7],[540,8,540,10],[547,11,547,13],[540,11,540,13]]}
[]
["EXCLUSIVE",null,null,null,null,null,null,null,null,"FACTOR SEMESTRAL :",null,0.53]
["TARIFAS ANUALES"]
["EDAD",null,null,null,null,null,null,null,"OK"]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6",null,"DW2","DW3","DW4","DW5","DW6","DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",null,{"$f":"O6","v":8501.0300000000007},{"$f":"P6","v":5625.71},3761.2599999999998,2628.38,2074.19,null,17297,11429,7624,5312,4181,{"$f":"(J6-50)*0.49+50","v":8501.0300000000007},{"$f":"(K6-50)*0.49+50","v":5625.71},3761.2599999999998,2628.38,2074.19]
[25,"-  29",null,{"$f":"O7","v":8917.0399999999991},{"$f":"P7","v":6215.18},{"$f":"Q7","v":4165.0199999999995},{"$f":"R7","v":2912.09},{"$f":"S7","v":2294.1999999999998},null,18146,12632,8448,5891,4630,{"$f":"(J7-50)*0.49+50","v":8917.0399999999991},{"$f":"(K7-50)*0.49+50","v":6215.18},{"$f":"(L7-50)*0.49+50","v":4165.0199999999995},{"$f":"(M7-50)*0.49+50","v":2912.09},{"$f":"(N7-50)*0.49+50","v":2294.1999999999998}]
[30,"-  34",null,9274.74,6663.04,4659.43,3486.37,2754.31,null,18876,13546,9457,7063,5569,9274.74,6663.04,4659.43,3486.37,2754.31]
[35,"-  39",null,10384.59,7456.3499999999995,5221.46,3904.34,3081.14,null,21141,15165,10604,7916,6236,10384.59,7456.3499999999995,5221.46,3904.34,3081.14]
[40,"-  44",null,12039.81,8154.11,5793.29,4291.4399999999996,3385.43,null,24519,16589,11771,8706,6857,12039.81,8154.11,5793.29,4291.4399999999996,3385.43]
[45,"-  49",null,13456.89,9116.9599999999991,6471.94,4790.75,3781.84,null,27411,18554,13156,9725,7666,13456.89,9116.9599999999991,6471.94,4790.75,3781.84]
[50,"-  54",null,17212.25,11954.06,8437.33,6763,5336.12,null,35075,24344,17167,13750,10838,17212.25,11954.06,8437.33,6763,5336.12]
[55,"-  59",null,18311.810000000001,12719.44,8972.9,7193.22,5678.63,null,37319,25906,18260,14628,11537,18311.810000000001,12719.44,8972.9,7193.22,5678.63]
[60,null,null,19945.96,13873.39,10325.299999999999,8660.2800000000007,7049.65,null,40654,28261,21020,17622,14335,19945.96,13873.39,10325.299999999999,8660.2800000000007,7049.65]
[61,null,null,21426.739999999998,14906.8,11086.27,9309.5300000000007,7572.48,null,43676,30370,22573,18947,15402,21426.739999999998,14906.8,11086.27,9309.5300000000007,7572.48]
[62,null,null,23456.81,16323.39,12141.24,10184.67,8289.84,null,47819,33261,24726,20733,16866,23456.81,16323.39,12141.24,10184.67,8289.84]
[63,null,null,24940.04,17354.84,12902.21,10834.9,8810.2199999999993,null,50846,35366,26279,22060,17928,24940.04,17354.84,12902.21,10834.9,8810.2199999999993]
[64,null,null,26975.01,18775.349999999999,13962.57,11714.94,9536.89,null,54999,38265,28443,23856,19411,26975.01,18775.349999999999,13962.57,11714.94,9536.89]
[65,null,null,35258.46,24483.85,17646.88,15617.789999999999,13437.78,null,71904,49915,35962,31821,27372,35258.46,24483.85,17646.88,15617.789999999999,13437.78]
[66,null,null,40956.67,28445.989999999998,20500.149999999998,18152.07,15607.99,null,83533,58001,41785,36993,31801,40956.67,28445.989999999998,20500.149999999998,18152.07,15607.99]
[67,null,null,44735.549999999996,31066.51,22390.079999999998,19818.560000000001,17048.59,null,91245,63349,45642,40394,34741,44735.549999999996,31066.51,22390.079999999998,19818.560000000001,17048.59]
[68,null,null,49532.65,34393.61,24790.59,21947.119999999999,18874.82,null,101035,70139,50541,44738,38468,49532.65,34393.61,24790.59,21947.119999999999,18874.82]
[69,null,null,54496.84,37837.33,27274.89,24142.81,20768.18,null,111166,77167,55611,49219,42332,54496.84,37837.33,27274.89,24142.81,20768.18]
[70,null,null,67061.91,46070.31,32102.86,28126.51,24426.52,null,136809,93969,65464,57349,49798,67061.91,46070.31,32102.86,28126.51,24426.52]
[71,null,null,69697.62,47876.45,33365.1,29234.399999999998,25384.959999999999,null,142188,97655,68040,59610,51754,69697.62,47876.45,33365.1,29234.399999999998,25384.959999999999]
[72,null,null,71671.34,49231.79,34301.979999999996,30061.52,26102.32,null,146216,100421,69952,61298,53218,71671.34,49231.79,34301.979999999996,30061.52,26102.32]
[73,null,null,74301.66,51042.34,35563.24,31166.959999999999,27055.37,null,151584,104116,72526,63554,55163,74301.66,51042.34,35563.24,31166.959999999999,27055.37]
[74,null,null,75617.31,51944.43,36199.26,31717.72,27539,null,154269,105957,73824,64678,56150,75617.31,51944.43,36199.26,31717.72,27539]
[75,"o más",null,78907.66,54202.84,37767.26,33098.050000000003,28740.97,null,160984,110566,77024,67495,58603,78907.66,54202.84,37767.26,33098.050000000003,28740.97]
[1,"Hijo",null,2944.9,2169.23,1670.8999999999999,1384.25,1076.53,null,6010,4427,3410,2825,2197,{"$f":"(J30)*0.49","v":2944.9},{"$f":"(K30)*0.49","v":2169.23},1670.8999999999999,1384.25,1076.53]
[2,"Hijos",null,4684.3999999999996,3455.48,2659.23,2196.67,1713.04,null,9560,7052,5427,4483,3496,{"$f":"(J31)*0.49","v":4684.3999999999996},{"$f":"(K31)*0.49","v":3455.48},{"$f":"(L31)*0.49","v":2659.23},{"$f":"(M31)*0.49","v":2196.67},{"$f":"(N31)*0.49","v":1713.04}]
[3,"Hijos o más",null,6869.3099999999995,5061.21,3893.54,3219.2999999999997,2506.84,null,14019,10329,7946,6570,5116,6869.3099999999995,5061.21,3893.54,3219.2999999999997,2506.84]
[1,"Rider Comp. Maternidad",null,0,0,225,225,225]
[1,"Transplante de organos",null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,"OK"]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"DW2","DW3","DW4","DW5","DW6"]
[18,"-  24",null,{"$f":"D6*$L$2","v":4505.545900000001},{"$f":"E6*$L$2","v":2981.6263000000004},1993.4677999999999,1393.0414000000001,1099.3207]
[25,"-  29",null,{"$f":"D7*$L$2","v":4726.0311999999994},3294.0454000000004,2207.4605999999999,1543.4077000000002,1215.9259999999999]
[30,"-  34",null,{"$f":"D8*$L$2","v":4915.6122000000005},3531.4112,2469.4979000000003,1847.7761,1459.7843]
[35,"-  39",null,{"$f":"D9*$L$2","v":5503.8326999999999},3951.8654999999999,2767.3738000000003,2069.3002000000001,1633.0042000000001]
[40,"-  44",null,{"$f":"D10*$L$2","v":6381.0992999999999},4321.6783000000005,3070.4437000000003,2274.4631999999997,1794.2779]
[45,"-  49",null,{"$f":"D11*$L$2","v":7132.1517000000003},4831.9888000000001,3430.1282000000001,2539.0975000000003,2004.3752000000002]
[50,"-  54",null,{"$f":"D12*$L$2","v":9122.4925000000003},6335.6517999999996,4471.7849000000006,3584.3900000000003,2828.1435999999999]
[55,"-  59",null,{"$f":"D13*$L$2","v":9705.2593000000015},6741.3032000000003,4755.6369999999997,3812.4066000000003,3009.6739000000002]
[60,null,null,{"$f":"D14*$L$2","v":10571.3588},7352.8967000000002,5472.4089999999997,4589.9484000000002,3736.3145]
[61,null,null,{"$f":"D15*$L$2","v":11356.172199999999},7900.6040000000003,5875.7231000000002,4934.0509000000002,4013.4144000000001]
[62,null,null,{"$f":"D16*$L$2","v":12432.109300000002},8651.3966999999993,6434.8572000000004,5397.8751000000002,4393.6152000000002]
[63,null,null,{"$f":"D17*$L$2","v":13218.221200000002},9198.0652000000009,6838.1713,5742.4970000000003,4669.4165999999996]
[64,null,null,{"$f":"D18*$L$2","v":14296.755300000001},9950.9354999999996,7400.1621000000005,6208.918200000001,5054.5517]
[65,null,null,{"$f":"D19*$L$2","v":18686.983800000002},12976.440500000001,9352.8464000000004,8277.4287000000004,7122.0234000000009]
[66,null,null,{"$f":"D20*$L$2","v":21707.035100000001},15076.3747,10865.0795,9620.5971000000009,8272.2347000000009]
[67,null,null,{"$f":"D21*$L$2","v":23709.841499999999},16465.2503,11866.742399999999,10503.836800000001,9035.7527000000009]
[68,null,null,{"$f":"D22*$L$2","v":26252.304500000002},18228.613300000001,13139.012700000001,11631.973599999999,10003.6546]
[69,null,null,{"$f":"D23*$L$2","v":28883.325199999999},20053.784900000002,14455.691700000001,12795.689300000002,11007.135400000001]
[70,null,null,{"$f":"D24*$L$2","v":35542.812300000005},24417.264299999999,17014.515800000001,14907.050300000001,12946.055600000002]
[71,null,null,{"$f":"D25*$L$2","v":36939.738599999997},25374.518499999998,17683.503000000001,15494.232,13454.0288]
[72,null,null,{"$f":"D26*$L$2","v":37985.8102},26092.848700000002,18180.0494,15932.605600000001,13834.229600000001]
[73,null,null,{"$f":"D27*$L$2","v":39379.879800000002},27052.440200000001,18848.517199999998,16518.488799999999,14339.346100000001]
[74,null,null,{"$f":"D28*$L$2","v":40077.174299999999},27530.547900000001,19185.607800000002,16810.391600000003,14595.67]
[75,"o más",null,{"$f":"D29*$L$2","v":41821.059800000003},28727.5052,20016.647800000002,17541.966500000002,15232.714100000001]
[1,"Hijo",null,{"$f":"D30*$L$2","v":1560.797},1149.6919,885.577,733.65250000000003,570.56090000000006]
[2,"Hijos",null,{"$f":"D31*$L$2","v":2482.732},1831.4044000000001,1409.3919000000001,1164.2351000000001,907.91120000000001]
[3,"Hijos o más",null,{"$f":"D32*$L$2","v":3640.7343000000001},2682.4413,2063.5762,1706.229,1328.6252000000002]
[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",null,null,null,null,null,null,null,"OK"]
["EDAD"]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6",null,"CW2","CW3","CW4","CW5","CW6","CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",null,{"$f":"O140","v":7155.49},{"$f":"P140","v":4926.4799999999996},3273.22,2289.79,1747.36,null,14551,10002,6628,4621,3514,{"$f":"(J140-50)*0.49+50","v":7155.49},{"$f":"(K140-50)*0.49+50","v":4926.4799999999996},3273.22,2289.79,1747.36]
[25,"-  29",null,{"$f":"O141","v":7503.88},{"$f":"P141","v":5447.84},{"$f":"Q141","v":3622.1},{"$f":"R141","v":2531.85},{"$f":"S141","v":1933.56},null,15262,11066,7340,5115,3894,{"$f":"(J141-50)*0.49+50","v":7503.88},{"$f":"(K141-50)*0.49+50","v":5447.84},{"$f":"(L141-50)*0.49+50","v":3622.1},{"$f":"(M141-50)*0.49+50","v":2531.85},{"$f":"(N141-50)*0.49+50","v":1933.56}]
[30,"-  34",null,7838.55,5825.14,4062.12,3054.19,2342.71,null,15945,11836,8238,6181,4729,7838.55,5825.14,4062.12,3054.19,2342.71]
[35,"-  39",null,8771.51,6518,4549.18,3422.67,2619.56,null,17849,13250,9232,6933,5294,8771.51,6518,4549.18,3422.67,2619.56]
[40,"-  44",null,10151.35,7146.18,5054.37,3772.04,2889.06,null,20665,14532,10263,7646,5844,10151.35,7146.18,5054.37,3772.04,2889.06]
[45,"-  49",null,11338.619999999999,7982.12,5643.84,4213.53,3223.73,null,23088,16238,11466,8547,6527,11338.619999999999,7982.12,5643.84,4213.53,3223.73]
[50,"-  54",null,14812.23,10520.81,7402.94,5996.15,4591.8099999999995,null,30177,21419,15056,12185,9319,14812.23,10520.81,7402.94,5996.15,4591.8099999999995]
[55,"-  59",null,15754.99,11189.66,7875.79,6381.78,4883.8500000000004,null,32101,22784,16021,12972,9915,15754.99,11189.66,7875.79,6381.78,4883.8500000000004]
[60,null,null,17155.41,12146.63,8959.67,7583.26,6101.5,null,34959,24737,18233,15424,12400,17155.41,12146.63,8959.67,7583.26,6101.5]
[61,null,null,18428.43,13046.76,9623.1299999999992,8148.72,6550.34,null,37557,26574,19587,16578,13316,18428.43,13046.76,9623.1299999999992,8148.72,6550.34]
[62,null,null,20169.89,14287.44,10535.51,8919.49,7170.19,null,41111,29106,21449,18151,14581,20169.89,14287.44,10535.51,8919.49,7170.19]
[63,null,null,21447.32,15187.57,11198.97,9486.42,7620.5,null,43718,30943,22803,19308,15500,21447.32,15187.57,11198.97,9486.42,7620.5]
[64,null,null,23193.68,16431.68,12115.27,10259.64,8244.27,null,47282,33482,24673,20886,16773,23193.68,16431.68,12115.27,10259.64,8244.27]
[65,null,null,30317.3,21420.37,15309.09,13669.55,11612.039999999999,null,61820,43663,31191,27845,23646,30317.3,21420.37,15309.09,13669.55,11612.039999999999]
[66,null,null,35212.89,24885.16,17784.079999999998,15883.369999999999,13487.76,null,71811,50734,36242,32363,27474,35212.89,24885.16,17784.079999999998,15883.369999999999,13487.76]
[67,null,null,38454.729999999996,27175.91,19421.66,17338.18,14729.91,null,78427,55409,39584,35332,30009,38454.729999999996,27175.91,19421.66,17338.18,14729.91]
[68,null,null,42579.06,30085.040000000001,21505.14,19199.2,16307.71,null,86844,61346,43836,39130,33229,42579.06,30085.040000000001,21505.14,19199.2,16307.71]
[69,null,null,46841.57,33096.089999999997,23652.81,21118.53,17942.349999999999,null,95543,67491,48219,43047,36565,46841.57,33096.089999999997,23652.81,21118.53,17942.349999999999]
[70,null,null,57643.13,40295.17,27839.37,24610.27,21093.54,null,117587,82183,56763,50173,42996,57643.13,40295.17,27839.37,24610.27,21093.54]
[71,null,null,59905.95,41870.519999999997,28927.66,25572.63,21926.05,null,122205,85398,58984,52137,44695,59905.95,41870.519999999997,28927.66,25572.63,21926.05]
[72,null,null,61603.31,43054.36,29749.88,26295.87,22542.959999999999,null,125669,87814,60662,53613,45954,61603.31,43054.36,29749.88,26295.87,22542.959999999999]
[73,null,null,63861.229999999996,44638.53,30839.149999999998,27262.149999999998,23376.94,null,130277,91047,62885,55585,47656,63861.229999999996,44638.53,30839.149999999998,27262.149999999998,23376.94]
[74,null,null,64991.17,45425.47,31385.01,27747.739999999998,23784.13,null,132583,92653,63999,56576,48487,64991.17,45425.47,31385.01,27747.739999999998,23784.13]
[75,"o más",null,67820.429999999993,47403.6,32749.17,28951.67,24818.52,null,138357,96690,66783,59033,50598,67820.429999999993,47403.6,32749.17,28951.67,24818.52]
[1,"Hijo",null,2471.56,1803.2,1319.08,1092.7,810.46,null,5044,3680,2692,2230,1654,{"$f":"(J164)*0.49","v":2471.56},{"$f":"(K164)*0.49","v":1803.2},1319.08,1092.7,810.46]
[2,"Hijos",null,3927.84,2873.85,2103.08,1739.99,1287.72,null,8016,5865,4292,3551,2628,{"$f":"(J165)*0.49","v":3927.84},{"$f":"(K165)*0.49","v":2873.85},{"$f":"(L165)*0.49","v":2103.08},{"$f":"(M165)*0.49","v":1739.99},{"$f":"(N165)*0.49","v":1287.72}]
[3,"Hijos o más",null,5761.42,4210.57,3078.67,2549.4699999999998,1887.97,null,11758,8593,6283,5203,3853,5761.42,4210.57,3078.67,2549.4699999999998,1887.97]
[1,"Rider Comp. Maternidad",null,0,0,225,225,225]
[1,"Transplante de organos",null,0,0,0,0,0]
[]
["TARIFAS SEMESTRALES "]
["EDAD",null,null,null,null,null,null,null,"OK"]
[" "," ",null,"CW2","CW3","CW4","CW5","CW6"]
[18,"-  24",null,{"$f":"D140*$L$2","v":3792.4097000000002},{"$f":"E140*$L$2","v":2611.0344},1734.8065999999999,1213.5887,926.10080000000005]
[25,"-  29",null,{"$f":"D141*$L$2","v":3977.0564000000004},2887.3552000000004,1919.713,1341.8805,1024.7868000000001]
[30,"-  34",null,{"$f":"D142*$L$2","v":4154.4315000000006},3087.3242000000005,2152.9236000000001,1618.7207000000001,1241.6363000000001]
[35,"-  39",null,{"$f":"D143*$L$2","v":4648.9003000000002},3454.54,2411.0654000000004,1814.0151000000001,1388.3668]
[40,"-  44",null,{"$f":"D144*$L$2","v":5380.2155000000002},3787.4754000000003,2678.8161,1999.1812,1531.2018]
[45,"-  49",null,{"$f":"D145*$L$2","v":6009.4686000000002},4230.5236000000004,2991.2352000000001,2233.1709000000001,1708.5769]
[50,"-  54",null,{"$f":"D146*$L$2","v":7850.4818999999998},5576.0293000000001,3923.5581999999999,3177.9594999999999,2433.6592999999998]
[55,"-  59",null,{"$f":"D147*$L$2","v":8350.1447000000007},5930.5198,4174.1687000000002,3382.3434000000002,2588.4405000000002]
[60,null,null,{"$f":"D148*$L$2","v":9092.3672999999999},6437.7138999999997,4748.6251000000002,4019.1278000000002,3233.7950000000001]
[61,null,null,{"$f":"D149*$L$2","v":9767.0679},6914.7828000000009,5100.2588999999998,4318.8216000000002,3471.6802000000002]
[62,null,null,{"$f":"D150*$L$2","v":10690.0417},7572.3432000000003,5583.8203000000003,4727.3297000000002,3800.2006999999999]
[63,null,null,{"$f":"D151*$L$2","v":11367.079600000001},8049.4121000000005,5935.4540999999999,5027.8026,4038.8650000000002]
[64,null,null,{"$f":"D152*$L$2","v":12292.6504},8708.7903999999999,6421.093100000001,5437.6091999999999,4369.4631000000008]
[65,null,null,{"$f":"D153*$L$2","v":16068.169},11352.7961,8113.8177000000005,7244.8615,6154.3811999999998]
[66,null,null,{"$f":"D154*$L$2","v":18662.831699999999},13189.1348,9425.5623999999989,8418.186099999999,7148.5128000000004]
[67,null,null,{"$f":"D155*$L$2","v":20381.0069},14403.232300000001,10293.479800000001,9189.2354000000014,7806.8523000000005]
[68,null,null,{"$f":"D156*$L$2","v":22566.9018},15945.071200000002,11397.724200000001,10175.576000000001,8643.0863000000008]
[69,null,null,{"$f":"D157*$L$2","v":24826.0321},17540.9277,12535.989300000001,11192.820900000001,9509.4454999999998]
[70,null,null,{"$f":"D158*$L$2","v":30550.858899999999},21356.4401,14754.866100000001,13043.4431,11179.576200000001]
[71,null,null,{"$f":"D159*$L$2","v":31750.1535},22191.375599999999,15331.659800000001,13553.493900000001,11620.806500000001]
[72,null,null,{"$f":"D160*$L$2","v":32649.754300000001},22818.810800000003,15767.436400000001,13936.811100000001,11947.7688]
[73,null,null,{"$f":"D161*$L$2","v":33846.4519},23658.420900000001,16344.7495,14448.9395,12389.778200000001]
[74,null,null,{"$f":"D162*$L$2","v":34445.320099999997},24075.499100000001,16634.0553,14706.3022,12605.588900000001]
[75,"o más",null,{"$f":"D163*$L$2","v":35944.827899999997},25123.907999999999,17357.060099999999,15344.3851,13153.815600000002]
[1,"Hijo",null,{"$f":"D164*$L$2","v":1309.9268},955.69600000000003,699.11239999999998,579.13100000000009,429.54380000000003]
[2,"Hijos",null,{"$f":"D165*$L$2","v":2081.7552000000001},1523.1405,1114.6324,922.19470000000001,682.49160000000006]
[3,"Hijos o más",null,{"$f":"D166*$L$2","v":3053.5526},2231.6021000000001,1631.6951000000001,1351.2191,1000.6241000000001]
[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",null,null,null,null,null,null,null,"OK"]
["EDAD"]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6",null,"AW2","AW3","AW4","AW5","AW6","AW2","AW3","AW4","AW5","AW6"]
[18,"-  24",null,{"$f":"O274","v":5066.9800000000005},{"$f":"P274","v":3811.94},2764.13,2071.9499999999998,1646.89,null,9516,7148,5171,3865,3063,{"$f":"(J274-50)*0.53+50","v":5066.9800000000005},{"$f":"(K274-50)*0.53+50","v":3811.94},2764.13,2071.9499999999998,1646.89]
[25,"-  29",null,{"$f":"O275","v":5630.37},{"$f":"P275","v":4249.72},{"$f":"Q275","v":3072.06},{"$f":"R275","v":2306.21},{"$f":"S275","v":1822.8500000000001},null,10579,7974,5752,4307,3395,{"$f":"(J275-50)*0.53+50","v":5630.37},{"$f":"(K275-50)*0.53+50","v":4249.72},{"$f":"(L275-50)*0.53+50","v":3072.06},{"$f":"(M275-50)*0.53+50","v":2306.21},{"$f":"(N275-50)*0.53+50","v":1822.8500000000001}]
[30,"-  34",null,6512.29,4993.3100000000004,3646.5800000000004,2730.7400000000002,2110.6400000000003,null,12243,9377,6836,5108,3938,6512.29,4993.3100000000004,3646.5800000000004,2730.7400000000002,2110.6400000000003]
[35,"-  39",null,7220.9000000000005,5554.05,4053.09,3107.57,2335.8900000000003,null,13580,10435,7603,5819,4363,7220.9000000000005,5554.05,4053.09,3107.57,2335.8900000000003]
[40,"-  44",null,8148.93,6288.63,4592.1000000000004,3466.38,2641.7000000000003,null,15331,11821,8620,6496,4940,8148.93,6288.63,4592.1000000000004,3466.38,2641.7000000000003]
[45,"-  49",null,9462.8000000000011,7244.22,5178.2800000000007,3947.6200000000003,3065.7000000000003,null,17810,13624,9726,7404,5740,9462.8000000000011,7244.22,5178.2800000000007,3947.6200000000003,3065.7000000000003]
[50,"-  54",null,10364.33,8135.68,6026.81,4423.5600000000004,3361.9700000000003,null,19511,15306,11327,8302,6299,10364.33,8135.68,6026.81,4423.5600000000004,3361.9700000000003]
[55,"-  59",null,12239.470000000001,9393.3700000000008,6662.81,5123.16,3973.0600000000004,null,23049,17679,12527,9622,7452,12239.470000000001,9393.3700000000008,6662.81,5123.16,3973.0600000000004]
[60,null,null,13521.01,10398.780000000001,7323.1900000000005,5651.04,4394.9400000000005,null,25467,19576,13773,10618,8248,13521.01,10398.780000000001,7323.1900000000005,5651.04,4394.9400000000005]
[61,null,null,15215.42,11696.220000000001,8243.8000000000011,6354.35,4947.2,null,28664,22024,15510,11945,9290,15215.42,11696.220000000001,8243.8000000000011,6354.35,4947.2]
[62,null,null,16907.18,12998.960000000001,9159.11,7064.02,5495.75,null,31856,24482,17237,13284,10325,16907.18,12998.960000000001,9159.11,7064.02,5495.75]
[63,null,null,18598.940000000002,14301.17,10076.540000000001,7773.1600000000008,6046.9500000000007,null,35048,26939,18968,14622,11365,18598.940000000002,14301.17,10076.540000000001,7773.1600000000008,6046.9500000000007]
[64,null,null,20286.460000000003,15600.730000000001,10993.44,8480.18,6595.5,null,38232,29391,20698,15956,12400,20286.460000000003,15600.730000000001,10993.44,8480.18,6595.5]
[65,null,null,21934.23,16978.2,11980.300000000001,9234.3700000000008,7501.8,null,41341,31990,22560,17379,14110,21934.23,16978.2,11980.300000000001,9234.3700000000008,7501.8]
[66,null,null,23223.190000000002,17975.66,12687.320000000002,9776.0300000000007,7948.06,null,43773,33872,23894,18401,14952,23223.190000000002,17975.66,12687.320000000002,9776.0300000000007,7948.06]
[67,null,null,25804.82,19972.170000000002,14097.12,10862,8826.8000000000011,null,48644,37639,26554,20450,16610,25804.82,19972.170000000002,14097.12,10862,8826.8000000000011]
[68,null,null,28391.22,21976.63,15507.45,11948.5,9714.02,null,53524,41421,29215,22500,18284,28391.22,21976.63,15507.45,11948.5,9714.02]
[69,null,null,29679.120000000003,22971.97,16209.7,12491.220000000001,10155.51,null,55954,43299,30540,23524,19117,29679.120000000003,22971.97,16209.7,12491.220000000001,10155.51]
[70,null,null,30063.370000000003,23338.73,16458.8,12723.890000000001,10285.36,null,56679,43991,31010,23963,19362,30063.370000000003,23338.73,16458.8,12723.890000000001,10285.36]
[71,null,null,33820.01,26261.15,18514.670000000002,14319.720000000001,11574.85,null,63767,49505,34889,26974,21795,33820.01,26261.15,18514.670000000002,14319.720000000001,11574.85]
[72,null,null,37585.130000000005,29173.5,20573.190000000002,15910.78,12861.16,null,70871,55000,38773,29976,24222,37585.130000000005,29173.5,20573.190000000002,15910.78,12861.16]
[73,null,null,41342.300000000003,32093.27,22626.940000000002,17501.84,14146.94,null,77960,60509,42648,32978,26648,41342.300000000003,32093.27,22626.940000000002,17501.84,14146.94]
[74,null,null,45102.12,35014.1,24691.29,19101.38,15431.660000000002,null,85054,66020,46543,35996,29072,45102.12,35014.1,24691.29,19101.38,15431.660000000002]
[75,"o más",null,49339.47,39051.11,28316.49,20902.32,17706.420000000002,null,93049,73637,53383,39394,33364,49339.47,39051.11,28316.49,20902.32,17706.420000000002]
[1,"Hijo",null,2246.1400000000003,1600.6000000000001,1193.5600000000002,1029.79,740.94,null,4238,3020,2252,1943,1398,{"$f":"(J298)*0.53","v":2246.1400000000003},{"$f":"(K298)*0.53","v":1600.6000000000001},1193.5600000000002,1029.79,740.94]
[2,"Hijos",null,3655.94,2522.27,1882.5600000000002,1630.28,1089.1500000000001,null,6898,4759,3552,3076,2055,{"$f":"(J299)*0.53","v":3655.94},{"$f":"(K299)*0.53","v":2522.27},{"$f":"(L299)*0.53","v":1882.5600000000002},{"$f":"(M299)*0.53","v":1630.28},{"$f":"(N299)*0.53","v":1089.1500000000001}]
[3,"Hijos o más",null,5353,3675.02,2748.05,2362.21,1657.8400000000001,null,10100,6934,5185,4457,3128,5353,3675.02,2748.05,2362.21,1657.8400000000001]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES ",null,null,null,null,null,null,null,"OK"]
["EDAD"]
[" "," ",null,"AW2","AW3","AW4","AW5","AW6"]
[18,"-  24",null,{"$f":"D274*$L$2","v":2685.4994000000006},{"$f":"E274*$L$2","v":2020.3282000000002},1464.9889000000001,1098.1334999999999,872.85170000000005]
[25,"-  29",null,{"$f":"D275*$L$2","v":2984.0961000000002},2252.3516000000004,1628.1918000000001,1222.2913000000001,966.11050000000012]
[30,"-  34",null,{"$f":"D276*$L$2","v":3451.5137},2646.4543000000003,1932.6874000000003,1447.2922000000001,1118.6392000000003]
[35,"-  39",null,{"$f":"D277*$L$2","v":3827.0770000000007},2943.6465000000003,2148.1377000000002,1647.0121000000001,1238.0217000000002]
[40,"-  44",null,{"$f":"D278*$L$2","v":4318.9329000000007},3332.9739000000004,2433.8130000000001,1837.1814000000002,1400.1010000000001]
[45,"-  49",null,{"$f":"D279*$L$2","v":5015.2840000000006},3839.4366000000005,2744.4884000000006,2092.2386000000001,1624.8210000000001]
[50,"-  54",null,{"$f":"D280*$L$2","v":5493.0949000000001},4311.9104000000007,3194.2093000000004,2344.4868000000001,1781.8441000000003]
[55,"-  59",null,{"$f":"D281*$L$2","v":6486.919100000001},4978.486100000001,3531.2893000000004,2715.2748000000001,2105.7218000000003]
[60,null,null,{"$f":"D282*$L$2","v":7166.1353000000008},5511.3534000000009,3881.2907000000005,2995.0512000000003,2329.3182000000002]
[61,null,null,{"$f":"D283*$L$2","v":8064.1726000000008},6198.9966000000013,4369.2140000000009,3367.8055000000004,2622.0160000000001]
[62,null,null,{"$f":"D284*$L$2","v":8960.8054000000011},6889.448800000001,4854.3283000000001,3743.9306000000006,2912.7474999999999]
[63,null,null,{"$f":"D285*$L$2","v":9857.4382000000023},7579.6201000000001,5340.5662000000011,4119.7748000000011,3204.8835000000004]
[64,null,null,{"$f":"D286*$L$2","v":10751.823800000002},8268.3869000000013,5826.5232000000005,4494.4954000000007,3495.6150000000002]
[65,null,null,{"$f":"D287*$L$2","v":11625.141900000001},8998.4460000000017,6349.5590000000011,4894.2161000000006,3975.9540000000002]
[66,null,null,{"$f":"D288*$L$2","v":12308.290700000001},9527.0998,6724.2796000000008,5181.295900000001,4212.4718000000003]
[67,null,null,{"$f":"D289*$L$2","v":13676.554600000001},10585.250100000001,7471.4736000000012,5756.8600000000006,4678.2040000000006]
[68,null,null,{"$f":"D290*$L$2","v":15047.346600000001},11647.6139,8218.9485000000004,6332.7049999999999,5148.4306000000006]
[69,null,null,{"$f":"D291*$L$2","v":15729.933600000002},12175.144100000001,8591.1410000000014,6620.3466000000008,5382.4203000000007]
[70,null,null,{"$f":"D292*$L$2","v":15933.586100000002},12369.526900000001,8723.1640000000007,6743.6617000000006,5451.2408000000005]
[71,null,null,{"$f":"D293*$L$2","v":17924.605300000003},13918.409500000002,9812.7751000000007,7589.4516000000012,6134.6705000000002]
[72,null,null,{"$f":"D294*$L$2","v":19920.118900000005},15461.955,10903.790700000001,8432.7134000000005,6816.4148000000005]
[73,null,null,{"$f":"D295*$L$2","v":21911.419000000002},17009.433100000002,11992.278200000002,9275.9752000000008,7497.878200000001]
[74,null,null,{"$f":"D296*$L$2","v":23904.123600000003},18557.473000000002,13086.3837,10123.731400000001,8178.7798000000012]
[75,"o más",null,{"$f":"D297*$L$2","v":26149.919100000003},20697.088300000003,15007.739700000002,11078.229600000001,9384.4026000000013]
[1,"Hijo",null,{"$f":"D298*$L$2","v":1190.4542000000001},848.3180000000001,632.58680000000015,545.78870000000006,392.69820000000004]
[2,"Hijos",null,{"$f":"D299*$L$2","v":1937.6482000000001},1336.8031000000001,997.75680000000011,864.04840000000002,577.24950000000013]
[3,"Hijos o más",null,{"$f":"D300*$L$2","v":2837.09},1947.7606000000001,1456.4665000000002,1251.9713000000002,878.65520000000015]
[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",null,null,null,null,null,null,null,"OK"]
["EDAD",null,null,null,null,null,null,null,"ORIGINAL",null,null,null,null,0.40200000000000002]
[" "," "]
[18,"-  24",null,7367,5532,3999,2977,2351]
[25,"-  29",null,8192,6171,4439,3317,2612]
[30,"-  34",null,9492,7261,5291,3940,3035]
[35,"-  39",null,10532,8081,5891,4502,3368]
[40,"-  44",null,11885,9168,6681,5028,3821]
[45,"-  49",null,13818,10552,7537,5727,4445]
[50,"-  54",null,15139,11876,8784,6443,4879]
[55,"-  59",null,17890,13724,9724,7466,5772]
[60,null,null,19778,15193,10699,8232,6383]
[61,null,null,22258,17099,12042,9272,7190]
[62,null,null,24747,19011,13383,10312,7999]
[63,null,null,27218,20929,14741,11355,8818]
[64,null,null,29703,22831,16080,12388,9623]
[65,null,null,32112,24848,17535,13499,10955]
[66,null,null,34010,26312,18570,14293,11616]
[67,null,null,37809,29244,20645,15893,12909]
[68,null,null,41590,32180,22714,17489,14204]
[69,null,null,43487,33645,23743,18293,14859]
[70,null,null,44053,34182,24109,18635,15046]
[71,null,null,49564,38468,27136,20976,16942]
[72,null,null,55085,42744,30171,23317,18828]
[73,null,null,60608,47027,33188,25656,20717]
[74,null,null,66124,51319,36208,27987,22614]
[75,"o más",null,72339,57234,41537,30648,25951]
[1,"Hijo",null,3299,2349,1751,1509,1097]
[2,"Hijos",null,5364,3707,2768,2398,1604]
[3,"Hijos o más",null,7845,5394,4041,3473,2440]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["TARIFAS SEMESTRALES ",null,null,null,null,null,null,null,"OK"]
["EDAD"]
[" "," ",null,null,null,null,null,null,"DA1","DA2","DA3","DA4","DA5","DA1","DA2","DA3","DA4","DA5"]
[18,"-  24",null,{"$f":"$L$2*D341","v":3904.51},{"$f":"$L$2*E341","v":2931.96},2119.4700000000003,1577.8100000000002,1246.03]
[25,"-  29",null,{"$f":"$L$2*D342","v":4341.76},3270.63,2352.67,1758.01,1384.3600000000001]
[30,"-  34",null,5030.76,3848.3300000000004,2804.23,2088.2000000000003,1608.5500000000002]
[35,"-  39",null,5581.96,4282.93,3122.23,2386.06,1785.0400000000002]
[40,"-  44",null,6299.05,4859.04,3540.9300000000003,2664.84,2025.13]
[45,"-  49",null,7323.54,5592.56,3994.61,3035.31,2355.85]
[50,"-  54",null,8023.67,6294.2800000000007,4655.5200000000004,3414.79,2585.8700000000003]
[55,"-  59",null,9481.7000000000007,7273.72,5153.72,3956.98,3059.1600000000003]
[60,null,null,10482.34,8052.29,5670.47,4362.96,3382.9900000000002]
[61,null,null,11796.74,9062.4700000000012,6382.26,4914.16,3810.7000000000003]
[62,null,null,13115.91,10075.83,7092.9900000000007,5465.3600000000006,4239.47]
[63,null,null,14425.54,11092.37,7812.7300000000005,6018.1500000000005,4673.54]
[64,null,null,15742.59,12100.43,8522.4,6565.64,5100.1900000000005]
[65,null,null,17019.36,13169.44,9293.5500000000011,7154.47,5806.1500000000005]
[66,null,null,18025.3,13945.36,9842.1,7575.29,6156.4800000000005]
[67,null,null,20038.77,15499.320000000002,10941.85,8423.2900000000009,6841.77]
[68,null,null,22042.7,17055.400000000001,12038.42,9269.17,7528.1200000000008]
[69,null,null,23048.11,17831.850000000002,12583.79,9695.2900000000009,7875.27]
[70,null,null,23348.09,18116.46,12777.77,9876.5500000000011,7974.38]
[71,null,null,26268.920000000002,20388.04,14382.08,11117.28,8979.26]
[72,null,null,29195.050000000003,22654.32,15990.630000000001,12358.01,9978.84]
[73,null,null,32122.240000000002,24924.31,17589.64,13597.68,10980.01]
[74,null,null,35045.72,27199.07,19190.240000000002,14833.11,11985.42]
[75,"o más",null,38339.670000000006,30334.02,22014.61,16243.44,13754.03]
[1,"Hijo",null,1748.47,1244.97,928.03000000000009,799.7700000000001,581.41000000000008]
[2,"Hijos",null,2842.92,1964.71,1467.04,1270.94,850.12]
[3,"Hijos o más",null,{"$f":"$L$2*D367","v":4157.8500000000004},{"$f":"$L$2*E367","v":2858.82},2141.73,1840.69,1293.2]
[1,"Rider Comp. Maternidad"]
[1,"Transplante de organos"]
[]
["SECURE"]
["TARIFAS ANUALES",null,null,null,null,null,null,null,"OK"]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6",null,"SE2","SE3","SE4","SE5","SE6","SE2","SE3","SE4","SE5","SE6"]
[18,"-  24",null,{"$f":"O408","v":3669.28},{"$f":"P408","v":2883.6},2032.14,1673.8000000000002,1278.2,null,7918,6210,4359,3580,2720,{"$f":"(J408-50)*0.46+50","v":3669.28},{"$f":"(K408-50)*0.46+50","v":2883.6},2032.14,1673.8000000000002,1278.2]
[25,"-  29",null,{"$f":"O409","v":4046.94},{"$f":"P409","v":3250.2200000000003},{"$f":"Q409","v":2264.44},{"$f":"R409","v":1862.4},{"$f":"S409","v":1419.42},null,8739,7007,4864,3990,3027,{"$f":"(J409-50)*0.46+50","v":4046.94},{"$f":"(K409-50)*0.46+50","v":3250.2200000000003},{"$f":"(L409-50)*0.46+50","v":2264.44},{"$f":"(M409-50)*0.46+50","v":1862.4},{"$f":"(N409-50)*0.46+50","v":1419.42}]
[30,"-  34",null,4632.9800000000005,3809.5800000000004,2624.1600000000003,2159.56,1637.92,null,10013,8223,5646,4636,3502,4632.9800000000005,3809.5800000000004,2624.1600000000003,2159.56,1637.92]
[35,"-  39",null,5099.42,4257.62,2918.1,2398.7600000000002,1810.42,null,11027,9197,6285,5156,3877,5099.42,4257.62,2918.1,2398.7600000000002,1810.42]
[40,"-  44",null,5712.14,4854.7,3292.08,2706.96,2043.18,null,12359,10495,7098,5826,4383,5712.14,4854.7,3292.08,2706.96,2043.18]
[45,"-  49",null,6569.58,5688.22,3829.82,3138.9,2366.1,null,14223,12307,8267,6765,5085,6569.58,5688.22,3829.82,3138.9,2366.1]
[50,"-  54",null,7168.5,6259.54,4195.9800000000005,3442.5,2586.44,null,15525,13549,9063,7425,5564,7168.5,6259.54,4195.9800000000005,3442.5,2586.44]
[55,"-  59",null,8418.32,7466.12,4970.16,4076.38,3052.88,null,18242,16172,10746,8803,6578,8418.32,7466.12,4970.16,4076.38,3052.88]
[60,null,null,8811.6200000000008,7979.02,5258.12,4313.28,3232.7400000000002,null,19097,17287,11372,9318,6969,8811.6200000000008,7979.02,5258.12,4313.28,3232.7400000000002]
[61,null,null,9920.2200000000012,8974.4600000000009,5918.22,4852.8600000000006,3636.6200000000003,null,21507,19451,12807,10491,7847,9920.2200000000012,8974.4600000000009,5918.22,4852.8600000000006,3636.6200000000003]
[62,null,null,11022.84,9975.42,6584.3,5390.14,4045.1000000000004,null,23904,21627,14255,11659,8735,11022.84,9975.42,6584.3,5390.14,4045.1000000000004]
[63,null,null,12121.78,10974.54,7237.96,5931.56,4448.9800000000005,null,26293,23799,15676,12836,9613,12121.78,10974.54,7237.96,5931.56,4448.9800000000005]
[64,null,null,13232.220000000001,11972.74,7898.06,6471.6,4853.7800000000007,null,28707,25969,17111,14010,10493,13232.220000000001,11972.74,7898.06,6471.6,4853.7800000000007]
[65,null,null,13241.42,12087.28,7944.06,6507.9400000000005,4870.34,null,28727,26218,17211,14089,10529,13241.42,12087.28,7944.06,6507.9400000000005,4870.34]
[66,null,null,13254.76,12200.44,7987.3,6541.52,4885.5200000000004,null,28756,26464,17305,14162,10562,13254.76,12200.44,7987.3,6541.52,4885.5200000000004]
[67,null,null,14734.58,13558.36,8876.94,7271.54,5431.08,null,31973,29416,19239,15749,11748,14734.58,13558.36,8876.94,7271.54,5431.08]
[68,null,null,16206.58,14908.460000000001,9767.5,8000.18,5978.02,null,35173,32351,21175,17333,12937,16206.58,14908.460000000001,9767.5,8000.18,5978.02]
[69,null,null,16947.18,15583.74,10210.94,8357.6,6252.18,null,36783,33819,22139,18110,13533,16947.18,15583.74,10210.94,8357.6,6252.18]
[70,null,null,16974.780000000002,15851.460000000001,10314.44,8440.86,6280.7,null,36843,34401,22364,18291,13595,16974.780000000002,15851.460000000001,10314.44,8440.86,6280.7]
[71,null,null,19096.760000000002,17834.52,11607.5,9497.48,7069.14,null,41456,38712,25175,20588,15309,19096.760000000002,17834.52,11607.5,9497.48,7069.14]
[72,null,null,21226.560000000001,19821.260000000002,12901.02,10553.640000000001,7854.8200000000006,null,46086,43031,27987,22884,17017,21226.560000000001,19821.260000000002,12901.02,10553.640000000001,7854.8200000000006]
[73,null,null,23348.080000000002,21797.420000000002,14189.94,11609.800000000001,8637.74,null,50698,47327,30789,25180,18719,23348.080000000002,21797.420000000002,14189.94,11609.800000000001,8637.74]
[74,null,null,25471.9,23783.24,15481.62,12667.34,9427.1,null,55315,51644,33597,27479,20435,25471.9,23783.24,15481.62,12667.34,9427.1]
[75,"o más",null,27757.64,26085.08,16925.560000000001,13852.300000000001,10299.720000000001,null,60284,56648,36736,30055,22332,27757.64,26085.08,16925.560000000001,13852.300000000001,10299.720000000001]
[1,"Hijo",null,1758.5800000000002,1034.0800000000002,810.98,661.48,485.3,null,3823,2248,1763,1438,1055,{"$f":"(J432)*0.46","v":1758.5800000000002},{"$f":"(K432)*0.46","v":1034.0800000000002},810.98,661.48,485.3]
[2,"Hijos",null,2963.32,1548.3600000000001,1273.74,1041.9000000000001,773.26,null,6442,3366,2769,2265,1681,{"$f":"(J433)*0.46","v":2963.32},{"$f":"(K433)*0.46","v":1548.3600000000001},{"$f":"(L433)*0.46","v":1273.74},{"$f":"(M433)*0.46","v":1041.9000000000001},{"$f":"(N433)*0.46","v":773.26}]
[3,"Hijos o más",null,4351.1400000000003,2220.42,1849.66,1510.18,1120.1000000000001,null,9459,4827,4021,3283,2435,4351.1400000000003,2220.42,1849.66,1510.18,1120.1000000000001]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[null,null,null,null,null,null,null,null,"OK"]
["TARIFAS SEMESTRALES "]
["EDAD"]
[" "," ",null,"SE2","SE3","SE4","SE5","SE6"]
[18,"-  24",null,{"$f":"D408*$L$2","v":1944.7184000000002},{"$f":"E408*$L$2","v":1528.308},1077.0342000000001,887.11400000000015,677.44600000000003]
[25,"-  29",null,{"$f":"D409*$L$2","v":2144.8782000000001},1722.6166000000003,1200.1532000000002,987.07200000000012,752.29260000000011]
[30,"-  34",null,{"$f":"D410*$L$2","v":2455.4794000000002},2019.0774000000004,1390.8048000000003,1144.5668000000001,868.09760000000006]
[35,"-  39",null,{"$f":"D411*$L$2","v":2702.6926000000003},2256.5385999999999,1546.5930000000001,1271.3428000000001,959.52260000000012]
[40,"-  44",null,{"$f":"D412*$L$2","v":3027.4342000000001},2572.991,1744.8024,1434.6888000000001,1082.8854000000001]
[45,"-  49",null,{"$f":"D413*$L$2","v":3481.8774000000003},3014.7566000000002,2029.8046000000002,1663.6170000000002,1254.0329999999999]
[50,"-  54",null,{"$f":"D414*$L$2","v":3799.3050000000003},3317.5562,2223.8694000000005,1824.5250000000001,1370.8132000000001]
[55,"-  59",null,{"$f":"D415*$L$2","v":4461.7096000000001},3957.0436,2634.1848,2160.4814000000001,1618.0264000000002]
[60,null,null,{"$f":"D416*$L$2","v":4670.1586000000007},4228.8806000000004,2786.8036000000002,2286.0383999999999,1713.3522000000003]
[61,null,null,{"$f":"D417*$L$2","v":5257.7166000000007},4756.4638000000004,3136.6566000000003,2572.0158000000006,1927.4086000000002]
[62,null,null,{"$f":"D418*$L$2","v":5842.1052},5286.9726000000001,3489.6790000000001,2856.7742000000003,2143.9030000000002]
[63,null,null,{"$f":"D419*$L$2","v":6424.5434000000005},5816.5062000000007,3836.1188000000002,3143.7268000000004,2357.9594000000002]
[64,null,null,{"$f":"D420*$L$2","v":7013.0766000000012},6345.5522000000001,4185.9718000000003,3429.9480000000003,2572.5034000000005]
[65,null,null,{"$f":"D421*$L$2","v":7017.9526000000005},6406.2584000000006,4210.3518000000004,3449.2082000000005,2581.2802000000001]
[66,null,null,{"$f":"D422*$L$2","v":7025.0228000000006},6466.2332000000006,4233.2690000000002,3467.0056000000004,2589.3256000000006]
[67,null,null,{"$f":"D423*$L$2","v":7809.3274000000001},7185.930800000001,4704.7782000000007,3853.9162000000001,2878.4724000000001]
[68,null,null,{"$f":"D424*$L$2","v":8589.4874},7901.4838000000009,5176.7750000000005,4240.0954000000002,3168.3506000000002]
[69,null,null,{"$f":"D425*$L$2","v":8982.0054},8259.3822,5411.7982000000002,4429.5280000000002,3313.6554000000001]
[70,null,null,{"$f":"D426*$L$2","v":8996.6334000000024},8401.2738000000008,5466.6532000000007,4473.6558000000005,3328.7710000000002]
[71,null,null,{"$f":"D427*$L$2","v":10121.282800000001},9452.2956000000013,6151.9750000000004,5033.6643999999997,3746.6442000000002]
[72,null,null,{"$f":"D428*$L$2","v":11250.076800000001},10505.267800000001,6837.5406000000003,5593.4292000000005,4163.0546000000004]
[73,null,null,{"$f":"D429*$L$2","v":12374.482400000001},11552.632600000001,7520.668200000001,6153.1940000000013,4578.0021999999999]
[74,null,null,{"$f":"D430*$L$2","v":13500.107000000002},12605.117200000001,8205.258600000001,6713.6902,4996.3630000000003]
[75,"o más",null,{"$f":"D431*$L$2","v":14711.549200000001},13825.092400000001,8970.5468000000019,7341.719000000001,5458.8516000000009]
[1,"Hijo",null,{"$f":"D432*$L$2","v":932.04740000000015},548.06240000000014,429.81940000000003,350.58440000000002,257.209]
[2,"Hijos",null,{"$f":"D433*$L$2","v":1570.5596000000003},820.63080000000014,675.08220000000006,552.20700000000011,409.82780000000002]
[3,"Hijos o más",null,{"$f":"D434*$L$2","v":2306.1042000000002},1176.8226000000002,980.3198000000001,800.39540000000011,593.65300000000013]
[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",null,null,null,null,null,null,null,"OK"]
["EDAD"]
[" "," ",null,"ET2","ET3","ET4","ET5","ET6",null,"ET2","ET3","ET4","ET5","ET6","ET2","ET3","ET4","ET5","ET6"]
[18,"-  24",null,{"$f":"O475","v":2583.44},{"$f":"P475","v":2032.76},1434.1100000000001,1182.17,904.88,null,6546,5134,3599,2953,2242,{"$f":"(J475-50)*0.39+50","v":2583.44},{"$f":"(K475-50)*0.39+50","v":2032.76},1434.1100000000001,1182.17,904.88]
[25,"-  29",null,{"$f":"O476","v":2846.3},{"$f":"P476","v":2285.87},{"$f":"Q476","v":1597.52},{"$f":"R476","v":1317.89},{"$f":"S476","v":1003.5500000000001},null,7220,5783,4018,3301,2495,{"$f":"(J476-50)*0.39+50","v":2846.3},{"$f":"(K476-50)*0.39+50","v":2285.87},{"$f":"(L476-50)*0.39+50","v":1597.52},{"$f":"(M476-50)*0.39+50","v":1317.89},{"$f":"(N476-50)*0.39+50","v":1003.5500000000001}]
[30,"-  34",null,3257.75,2678.9900000000002,1850.24,1523.03,1154.0900000000001,null,8275,6791,4666,3827,2881,3257.75,2678.9900000000002,1850.24,1523.03,1154.0900000000001]
[35,"-  39",null,3588.08,3000.35,2053.4300000000003,1689.95,1281.23,null,9122,7615,5187,4255,3207,3588.08,3000.35,2053.4300000000003,1689.95,1281.23]
[40,"-  44",null,4017.4700000000003,3418.04,2316.6800000000003,1907.18,1442.69,null,10223,8686,5862,4812,3621,4017.4700000000003,3418.04,2316.6800000000003,1907.18,1442.69]
[45,"-  49",null,4621.1900000000005,4000.7000000000003,2699.6600000000003,2214.89,1670.06,null,11771,10180,6844,5601,4204,4621.1900000000005,4000.7000000000003,2699.6600000000003,2214.89,1670.06]
[50,"-  54",null,5043.17,4405.13,2954.33,2429.39,1823.3300000000002,null,12853,11217,7497,6151,4597,5043.17,4405.13,2954.33,2429.39,1823.3300000000002]
[55,"-  59",null,5916.38,5255.33,3497.21,2867.36,2154.44,null,15092,13397,8889,7274,5446,5916.38,5255.33,3497.21,2867.36,2154.44]
[60,null,null,6192.89,5612.18,3703.52,3036.23,2276.5100000000002,null,15801,14312,9418,7707,5759,6192.89,5612.18,3703.52,3036.23,2276.5100000000002]
[61,null,null,6970.55,6314.18,4164.8900000000003,3414.92,2562.77,null,17795,16112,10601,8678,6493,6970.55,6314.18,4164.8900000000003,3414.92,2562.77]
[62,null,null,7749.77,7013.45,4628.21,3794,2847.86,null,19793,17905,11789,9650,7224,7749.77,7013.45,4628.21,3794,2847.86]
[63,null,null,8527.0400000000009,7715.84,5089.97,4173.8600000000006,3130.2200000000003,null,21786,19706,12973,10624,7948,8527.0400000000009,7715.84,5089.97,4173.8600000000006,3130.2200000000003]
[64,null,null,9297.2900000000009,8416.2800000000007,5554.85,4553.72,3416.48,null,23761,21502,14165,11598,8682,9297.2900000000009,8416.2800000000007,5554.85,4553.72,3416.48]
[65,null,null,9308.2100000000009,8499.74,5591.12,4577.9000000000005,3427.01,null,23789,21716,14258,11660,8709,9308.2100000000009,8499.74,5591.12,4577.9000000000005,3427.01]
[66,null,null,9317.18,8579.3000000000011,5623.88,4600.91,3442.61,null,23812,21920,14342,11719,8749,9317.18,8579.3000000000011,5623.88,4600.91,3442.61]
[67,null,null,10357.31,9530.1200000000008,6246.3200000000006,5114.1500000000005,3824.03,null,26479,24358,15938,13035,9727,10357.31,9530.1200000000008,6246.3200000000006,5114.1500000000005,3824.03]
[68,null,null,11390.03,10487.960000000001,6869.1500000000005,5623.88,4207.4000000000005,null,29127,26814,17535,14342,10710,11390.03,10487.960000000001,6869.1500000000005,5623.88,4207.4000000000005]
[69,null,null,11910.29,10960.25,7183.1,5880.89,4398.1100000000006,null,30461,28025,18340,15001,11199,11910.29,10960.25,7183.1,5880.89,4398.1100000000006]
[70,null,null,11929.79,11147.45,7257.9800000000005,5935.1,4421.12,null,30511,28505,18532,15140,11258,11929.79,11147.45,7257.9800000000005,5935.1,4421.12]
[71,null,null,13420.37,12541.7,8162.7800000000007,6681.95,4976.87,null,34333,32080,20852,17055,12683,13420.37,12541.7,8162.7800000000007,6681.95,4976.87]
[72,null,null,14917.970000000001,13931.27,9069.92,7424.51,5521.31,null,38173,35643,23178,18959,14079,14917.970000000001,13931.27,9069.92,7424.51,5521.31]
[73,null,null,16406.21,15324.74,9976.67,8163.17,6076.2800000000007,null,41989,39216,25503,20853,15502,16406.21,15324.74,9976.67,8163.17,6076.2800000000007]
[74,null,null,17905.37,16720.16,10884.59,8906.9,6628.13,null,45833,42794,27831,22760,16917,17905.37,16720.16,10884.59,8906.9,6628.13]
[75,"o más",null,19506.71,18334.37,11902.880000000001,9737.2100000000009,7241.6,null,49939,46933,30442,24889,18490,19506.71,18334.37,11902.880000000001,9737.2100000000009,7241.6]
[1,"Hijo",null,1235.9100000000001,732.42000000000007,570.96,464.88,342.42,null,3169,1878,1464,1192,878,{"$f":"(J499)*0.39","v":1235.9100000000001},{"$f":"(K499)*0.39","v":732.42000000000007},570.96,464.88,342.42]
[2,"Hijos",null,2082.21,1086.1500000000001,893.49,730.47,542.88,null,5339,2785,2291,1873,1392,{"$f":"(J500)*0.39","v":2082.21},{"$f":"(K500)*0.39","v":1086.1500000000001},{"$f":"(L500)*0.39","v":893.49},{"$f":"(M500)*0.39","v":730.47},{"$f":"(N500)*0.39","v":542.88}]
[3,"Hijos o más",null,3057.9900000000002,1558.8300000000002,1302.6000000000001,1060.8,784.68000000000006,null,7841,3997,3340,2720,2012,3057.9900000000002,1558.8300000000002,1302.6000000000001,1060.8,784.68000000000006]
[1,"Rider Comp. Maternidad",null,225,225,225,225,225]
[1,"Transplante de organos",null,300,300,300,300,300]
[]
["TARIFAS SEMESTRALES ",null,null,null,null,null,null,null,"OK"]
["EDAD"]
[" "," ",null,"ET2","ET3","ET4","ET5","ET6"]
[18,"-  24",null,{"$f":"D475*$L$2","v":1369.2232000000001},{"$f":"E475*$L$2","v":1077.3628000000001},760.07830000000013,626.55010000000004,479.58640000000003]
[25,"-  29",null,{"$f":"D476*$L$2","v":1508.5390000000002},1211.5110999999999,846.68560000000002,698.48170000000005,531.88150000000007]
[30,"-  34",null,{"$f":"D477*$L$2","v":1726.6075000000001},1419.8647000000001,980.62720000000002,807.20590000000004,611.66770000000008]
[35,"-  39",null,{"$f":"D478*$L$2","v":1901.6824000000001},1590.1855,1088.3179000000002,895.6735000000001,679.05190000000005]
[40,"-  44",null,{"$f":"D479*$L$2","v":2129.2591000000002},1811.5612000000001,1227.8404000000003,1010.8054000000001,764.62570000000005]
[45,"-  49",null,{"$f":"D480*$L$2","v":2449.2307000000005},2120.3710000000001,1430.8198000000002,1173.8916999999999,885.1318]
[50,"-  54",null,{"$f":"D481*$L$2","v":2672.8801000000003},2334.7189000000003,1565.7949000000001,1287.5767000000001,966.36490000000015]
[55,"-  59",null,{"$f":"D482*$L$2","v":3135.6814000000004},2785.3249000000001,1853.5213000000001,1519.7008000000001,1141.8532]
[60,null,null,{"$f":"D483*$L$2","v":3282.2317000000003},2974.4554000000003,1962.8656000000001,1609.2019,1206.5503000000001]
[61,null,null,{"$f":"D484*$L$2","v":3694.3915000000002},3346.5154000000002,2207.3917000000001,1809.9076000000002,1358.2681]
[62,null,null,{"$f":"D485*$L$2","v":4107.3781000000008},3717.1285000000003,2452.9513000000002,2010.8200000000002,1509.3658]
[63,null,null,{"$f":"D486*$L$2","v":4519.3312000000005},4089.3952000000004,2697.6841000000004,2212.1458000000002,1659.0166000000002]
[64,null,null,{"$f":"D487*$L$2","v":4927.5637000000006},{"$f":"E487*$L$2","v":4460.6284000000005},2944.0705000000003,2413.4716000000003,1810.7344000000001]
[65,null,null,{"$f":"D488*$L$2","v":4933.3513000000012},4504.8622000000005,2963.2936,2426.2870000000003,1816.3153000000002]
[66,null,null,{"$f":"D489*$L$2","v":4938.1054000000004},4547.0290000000005,2980.6564000000003,2438.4823000000001,1824.5833000000002]
[67,null,null,{"$f":"D490*$L$2","v":5489.3743000000004},5050.963600000001,3310.5496000000003,2710.4995000000004,2026.7359000000001]
[68,null,null,{"$f":"D491*$L$2","v":6036.7159000000011},5558.6188000000011,3640.6495000000004,2980.6564000000003,2229.9220000000005]
[69,null,null,{"$f":"D492*$L$2","v":6312.4537000000009},5808.9324999999999,3807.0430000000006,3116.8717000000001,2330.9983000000002]
[70,null,null,{"$f":"D493*$L$2","v":6322.788700000001},5908.1485000000002,3846.7294000000006,3145.6030000000005,2343.1936000000001]
[71,null,null,{"$f":"D494*$L$2","v":7112.7961000000005},6647.1010000000006,4326.2734000000009,3541.4335000000001,2637.7411000000002]
[72,null,null,{"$f":"D495*$L$2","v":7906.5241000000015},7383.5731000000005,4807.0576000000001,3934.9903000000004,2926.2943000000005]
[73,null,null,{"$f":"D496*$L$2","v":8695.2913000000008},8122.1122000000005,5287.6351000000004,4326.4801000000007,3220.4284000000007]
[74,null,null,{"$f":"D497*$L$2","v":9489.8461000000007},8861.6848000000009,5768.8326999999999,4720.6570000000002,3512.9089000000004]
[75,"o más",null,{"$f":"D498*$L$2","v":10338.5563},9717.2160999999996,6308.5264000000006,5160.7213000000011,3838.0480000000002]
[1,"Hijo",null,{"$f":"D499*$L$2","v":655.03230000000008},388.18260000000004,302.60880000000003,246.38640000000001,181.48260000000002]
[2,"Hijos",null,{"$f":"D500*$L$2","v":1103.5713000000001},575.65950000000009,473.54970000000003,387.14910000000003,287.72640000000001]
[3,"Hijos o más",null,{"$f":"D501*$L$2","v":1620.7347000000002},826.17990000000009,690.37800000000016,562.22400000000005,415.88040000000007]
[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",{"$f":"C556","v":3766},{"$f":"D556","v":6623},9471,3043,5192,7345,2604,4477,6331,2069,3464,4857,1552,2502,3453,973,1434,1903]
[50,"o más",{"$f":"C557","v":4762},7614,10467,3844,5989,8126,3247,5129,6980,2553,3944,5352,1880,2828,3782,1137,1592,2065]
[]
["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":1995.98},3510.19,5019.63,1612.7900000000002,2751.76,3892.8500000000004,1380.1200000000001,2372.81,3355.4300000000003,1096.5700000000002,1835.92,2574.21,822.56000000000006,1326.0600000000002,1830.0900000000001,515.69000000000005,760.02,1008.59]
[75,"o más",2523.86,4035.42,5547.51,2037.3200000000002,3174.17,4306.7800000000007,1720.91,2718.3700000000003,3699.4,1353.0900000000001,2090.3200000000002,2836.56,996.40000000000009,1498.8400000000001,2004.46,602.61,843.76,1094.45]
[]
[]
[]
[]
[null,null,3766,6623,9471,3043,5192,7345,2604,4477,6331,2069,3464,4857,1552,2502,3453,973,1434,1903]
[null,null,4762,7614,10467,3844,5989,8126,3247,5129,6980,2553,3944,5352,1880,2828,3782,1137,1592,2065]
[]
[]
[null,null,{"$f":"(C556-50)*0.598+50","v":2272.1680000000001},{"$f":"(D556-50)*0.598+50","v":3980.654},5683.7579999999998,1839.8139999999999,3124.9159999999997,4412.41,1577.2919999999999,2697.346,3806.038,1257.3619999999999,2091.5720000000001,2924.5859999999998,948.19599999999991,1516.296,2084.9939999999997,601.95399999999995,877.63199999999995,1158.0940000000001]
[null,null,{"$f":"(C557-50)*0.598+50","v":2867.7759999999998},4573.2719999999999,6279.366,2318.8119999999999,3601.5219999999999,4879.4479999999994,1961.8059999999998,3087.2419999999997,4194.1399999999994,1546.7939999999999,2378.6120000000001,3220.596,1144.3399999999999,1711.2439999999999,2281.7359999999999,700.02599999999995,972.11599999999999,1254.97]