{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INGRESO DE DATOS","BUPA ESSENTIAL CARE","RESUMEN DE TARIFAS","Tablas"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"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":47,"n_cols":20,"rows_kept":47,"cut":false,"hidden":false,"merged":[[55,3,55,4],[55,6,55,7],[10,0,10,12],[44,0,44,1],[36,0,36,1],[38,0,38,1],[40,0,40,1],[42,0,42,1],[14,10,14,12],[38,4,40,5],[41,4,41,5],[38,7,40,9],[41,7,41,9],[10,14,10,16],[36,2,36,12],[21,14,21,18],[36,14,36,18],[44,14,44,18],[10,18,17,18],[41,14,41,16]]}
[]
[null,null,null,null,null,null,null," "," ",null,null,null,null,null,"24 years",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coaseguro (Panamá)",false]
[]
[]
[null,null,null,null,null,null,null," "," "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Descuento 24 años (por edad)",null,null,null,"Type","Nuevo Negocio"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"age","Discount (%)","Parameter",null,null,"Renovación"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,35,{"$f":"1-P13/100","v":0.65}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,30,{"$f":"1-P14/100","v":0.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,25,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,20,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,15,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,6,0.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All ages",0,1,null,"Type selected",1]
[]
[null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NEW BUSINESS DISCOUNT (ENTRADA MANUAL)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essential"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Descuento de 24 años:",{"$f":"IF(P2,_xlfn.SWITCH(C43,O13,Q13,O14,Q14,O15,Q15,O16,Q16,O17,Q17,O18,Q18,Q19),Q19)","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Descuento por variante de coaseguro",{"$f":"IF(P3=TRUE,0.25,1)","v":1}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Descuento si es nuevo negocio:"]
[]
["Nombre del Asegurado Titular:",null,"John Doe",null,null,null,null,null,null,null,null,null,null,null,"NEW BUSINESS DISCOUNT (MULTIPLICATION FACTOR)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essential"]
["Número de adultos en la póliza:",null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$19=1,(O24/100),0)","v":0},{"$f":"IF($T$19=1,(P24/100),0)","v":0},{"$f":"IF($T$19=1,(Q24/100),0)","v":0},{"$f":"IF($T$19=1,(R24/100),0)","v":0},{"$f":"IF($T$19=1,(S24/100),0)","v":0}]
[]
["Número total de dependientes en la póliza:",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Descuento combinado 24 años y Nuevo Negocio"]
["Edad del Asegurado Titular:",null,32]
[]
["Edad del/la cónyuge:",null,46,null,null,null,null,null,null,null,null,null,null,null,"NEW BUSINESS DISCOUNT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essential"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1-O39)*$P$30","v":1},{"$f":"(1-P39)*$P$30","v":1},{"$f":"(1-Q39)*$P$30","v":1},1,1]

{"sheet":"BUPA ESSENTIAL CARE","index":1,"n_rows":79,"n_cols":26,"rows_kept":79,"cut":false,"hidden":false,"merged":[[73,0,73,1],[22,0,22,2],[78,0,81,7],[65,0,65,7],[66,0,66,1],[67,0,67,1],[68,0,68,1],[72,0,72,1],[39,0,39,7],[40,0,40,1],[41,0,41,1],[42,0,42,1],[45,0,45,1],[30,0,30,1],[31,0,31,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[0,0,3,7],[4,0,10,7],[12,1,12,7],[18,5,18,6],[16,2,16,3],[69,0,69,1],[71,0,71,1],[44,0,44,1],[57,0,57,1],[70,0,70,1],[56,0,56,1],[58,0,58,1],[46,0,46,1],[47,0,47,1],[52,0,52,7],[53,0,53,1],[54,0,54,1],[55,0,55,1],[59,0,59,1],[60,0,60,1],[0,10,0,23],[0,25,0,38],[23,28,23,29],[23,13,23,14],[33,0,33,1],[20,1,20,2],[25,0,25,1],[26,0,26,1],[28,0,28,7],[29,0,29,1]]}
[" ",null,null,null,null,null,null,null,null,null,"RESUMEN DE BENEFICIOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESUMEN DE BENEFICIOS"]
[]
[]
[]
["Cotización de Seguro Médico Internacional\nBupa Essential Care\nTarifas en US$ | Validas: 1 de enero de 2024"]
[]
[]
[]
[]
[]
[]
[]
["Nombre del Asegurado Titular",{"$f":"+'INGRESO DE DATOS'!$C$37","v":"John Doe"}]
[]
["Número de adultos en la póliza",{"$f":"+'INGRESO DE DATOS'!$C$39","v":2}]
[]
["Número de Dependientes en la póliza",{"$f":"+'INGRESO DE DATOS'!$C$41","v":2},{"$f":"IF('INGRESO DE DATOS'!$P$2=TRUE, \"Cotización para dependiente de 24 años\",\"\")","v":""}]
[]
["Edad del Asegurado Titular",{"$f":"+'INGRESO DE DATOS'!$C$43","v":32},null,null,null,"Edad del/la conyuge",null,{"$f":"+'INGRESO DE DATOS'!$C$45","v":46}]
[]
["Fecha de la cotización",{"$f":"NOW()","v":"2024-01-10T13:30:10.240"}]
[]
[{"$f":"IF('INGRESO DE DATOS'!P3=TRUE,\"Variante con coaseguro fuera del país de residencia: SI\",\"Variante con coaseguro fuera del país de residencia: NO\")","v":"Variante con coaseguro fuera del país de residencia: NO"}]
[null,null," ",null,null,null,null," "]
["Deducibles",null,"PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 6"]
["En el país de residencia",null,500,1000,1000,1000,10000,20000]
["Fuera del país de residencia",null,2000,5000,10000,20000,10000,20000]
[]
["TARIFAS ANUALES"]
["Prima para Asegurado Titular",null,{"$f":"VLOOKUP($B$19,Tablas!$A$10:$H$76,3,TRUE)","v":2234},{"$f":"VLOOKUP($B$19,Tablas!$A$10:$H$76,4,TRUE)","v":1993},{"$f":"VLOOKUP($B$19,Tablas!$A$10:$H$76,5,TRUE)","v":1813},{"$f":"VLOOKUP($B$19,Tablas!$A$10:$H$76,6,TRUE)","v":1622},{"$f":"VLOOKUP($B$19,Tablas!$A$10:$H$76,7,TRUE)","v":1496},{"$f":"VLOOKUP($B$19,Tablas!$A$10:$H$76,8,TRUE)","v":1182}]
["Prima para conyuge",null,{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$10:$H$76,3,TRUE)))","v":3169},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$10:$H$76,4,TRUE)))","v":2829},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$10:$H$76,5,TRUE)))","v":2572},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$10:$H$76,6,TRUE)))","v":2301},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$10:$H$76,7,TRUE)))","v":2123},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$10:$H$76,8,TRUE)))","v":1676}]
["Prima para hijo (s)",null,{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$77:$H$79,3,TRUE)))","v":1265},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$77:$H$79,4,TRUE)))","v":1129},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$77:$H$79,5,TRUE)))","v":1026},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$77:$H$79,6,TRUE)))","v":918},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$77:$H$79,7,TRUE)))","v":848},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$77:$H$79,8,TRUE)))","v":669}]
["Total de Prima neta",null,{"$f":"SUM(C30:C32)","v":6668},{"$f":"SUM(D30:D32)","v":5951},5411,{"$f":"SUM(F30:F32)","v":4841},{"$f":"SUM(G30:G32)","v":4467},3527]
["Ajuste por la variante con coaseguro fuera\n del país de residencia",null,{"$f":"IF('INGRESO DE DATOS'!$P$3,C33*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,D33*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,E33*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,F33*-15%,0)","v":0}]
["Tarifa administrativa anual",null,75,75,75,75,75,75]
["VAT (5%) :",null,{"$f":"(C33+C34)*5%","v":333.40000000000003},{"$f":"(D33+D34)*5%","v":297.55},270.55,{"$f":"(F33+F34)*5%","v":242.05},{"$f":"(G33+G34)*5%","v":223.35000000000002},{"$f":"(H33+H34)*5%","v":176.35000000000002}]
["ITBMS (7%)",null,{"$f":"+C35*7%","v":5.2500000000000009},{"$f":"+D35*7%","v":5.2500000000000009},5.2500000000000009,{"$f":"+F35*7%","v":5.2500000000000009},{"$f":"+G35*7%","v":5.2500000000000009},5.2500000000000009]
["TOTAL ANUAL",null,{"$f":"SUM(C33:C37)","v":7081.65},{"$f":"SUM(D33:D37)","v":6328.8},5761.8,{"$f":"SUM(F33:F37)","v":5163.3},4770.6000000000004,3783.6]
[]
["TARIFAS SEMESTRALES"]
["Prima para Asegurado Titular",null,{"$f":"VLOOKUP($B$19,Tablas!$A$158:$H$224,3,TRUE)","v":1184.02},{"$f":"VLOOKUP($B$19,Tablas!$A$158:$H$224,4,TRUE)","v":1056.29},{"$f":"VLOOKUP($B$19,Tablas!$A$158:$H$224,5,TRUE)","v":960.8900000000001},{"$f":"VLOOKUP($B$19,Tablas!$A$158:$H$224,6,TRUE)","v":859.66000000000008},{"$f":"VLOOKUP($B$19,Tablas!$A$158:$H$224,7,TRUE)","v":792.88},{"$f":"VLOOKUP($B$19,Tablas!$A$158:$H$224,8,TRUE)","v":626.46}]
["Prima para conyuge",null,{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$158:$H$224,3,TRUE)))","v":1679.5700000000002},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$158:$H$224,4,TRUE)))","v":1499.3700000000001},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$158:$H$224,5,TRUE)))","v":1363.16},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$158:$H$224,6,TRUE)))","v":1219.53},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$158:$H$224,7,TRUE)))","v":1125.19},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$158:$H$224,8,TRUE)))","v":888.28000000000009}]
["Prima para hijo (s)",null,{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$225:$H$227,3,TRUE)))","v":670.45},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$225:$H$227,4,TRUE)))","v":598.37},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$225:$H$227,5,TRUE)))","v":543.78},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$225:$H$227,6,TRUE)))","v":486.54},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$225:$H$227,7,TRUE)))","v":449.44},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$225:$H$227,8,TRUE)))","v":354.57}]
["Total de Prima neta",null,{"$f":"SUM(C41:C43)","v":3534.04},{"$f":"SUM(D41:D43)","v":3154.0299999999997},2867.83,{"$f":"SUM(F41:F43)","v":2565.73},{"$f":"SUM(G41:G43)","v":2367.5100000000002},1869.3100000000002]
["Ajuste por la variante con coaseguro fuera\n del país de residencia",null,{"$f":"IF('INGRESO DE DATOS'!$P$3,C44*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,D44*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,E44*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,F44*-15%,0)","v":0}]
["Tarifa administrativa anual",null,75,75,75,75,75,75]
["VAT (5%) :",null,{"$f":"(C30+C31+C32+C34)*5%/2","v":166.70000000000002},{"$f":"(D30+D31+D32+D34)*5%/2","v":148.77500000000001},135.27500000000001,{"$f":"(F30+F31+F32+F34)*5%/2","v":121.02500000000001},{"$f":"(G30+G31+G32+G34)*5%/2","v":111.67500000000001},88.175000000000011]
["ITBMS (7%)",null,{"$f":"+C46*7%+ ((C30+C31+C32+C34)*0.06*0.07)/2","v":19.252800000000001},{"$f":"+D46*7%+ ((D30+D31+D32+D34)*0.06*0.07)/2","v":17.747100000000003},16.613099999999999,{"$f":"+F46*7%+ ((F30+F31+F32+F34)*0.06*0.07)/2","v":15.4161},{"$f":"+G46*7%+ ((G30+G31+G32+G34)*0.06*0.07)/2","v":14.630700000000001},12.656700000000001]
["TOTAL de primera cuota",null,{"$f":"SUM(C44:C48)","v":3794.9928},{"$f":"SUM(D44:D48)","v":3395.5520999999999},3094.7181,{"$f":"SUM(F44:F48)","v":2777.1711},{"$f":"SUM(G44:G48)","v":2568.8157000000006},2045.1417000000001]
["Costo de segunda cuota",null,{"$f":"((C44+C45)+ C47)+ ((C30+C31+C32+C34)*0.06*0.07)/2","v":3714.7428},{"$f":"((D44+D45)+ D47)+ ((D30+D31+D32+D34)*0.06*0.07)/2","v":3315.3020999999999},3014.4681,{"$f":"((F44+F45)+ F47)+ ((F30+F31+F32+F34)*0.06*0.07)/2","v":2696.9211},{"$f":"((G44+G45)+ G47)+ ((G30+G31+G32+G34)*0.06*0.07)/2","v":2488.5657000000006},1964.8917000000001]
["TOTAL ANUAL",null,{"$f":"C49+C50","v":7509.7356},{"$f":"D49+D50","v":6710.8541999999998},6109.1862000000001,{"$f":"F49+F50","v":5474.0922},5057.3814000000011,4010.0334000000003]
[]
["TARIFAS TRIMESTRALES"]
["Prima para Asegurado Titular",null,{"$f":"VLOOKUP($B$19,Tablas!$A$233:$H$299,3,TRUE)","v":614.35},{"$f":"VLOOKUP($B$19,Tablas!$A$233:$H$299,4,TRUE)","v":548.07500000000005},{"$f":"VLOOKUP($B$19,Tablas!$A$233:$H$299,5,TRUE)","v":498.57500000000005},{"$f":"VLOOKUP($B$19,Tablas!$A$233:$H$299,6,TRUE)","v":446.05},{"$f":"VLOOKUP($B$19,Tablas!$A$233:$H$299,7,TRUE)","v":411.40000000000003},{"$f":"VLOOKUP($B$19,Tablas!$A$233:$H$299,8,TRUE)","v":325.05}]
["Prima para conyuge",null,{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$233:$H$299,3,TRUE)))","v":871.47500000000002},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$233:$H$299,4,TRUE)))","v":777.97500000000002},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$233:$H$299,5,TRUE)))","v":707.30000000000007},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$233:$H$299,6,TRUE)))","v":632.77500000000009},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$233:$H$299,7,TRUE)))","v":583.82500000000005},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$233:$H$299,8,TRUE)))","v":460.90000000000003}]
["Prima para hijo (s)",null,{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$300:$H$302,3,TRUE)))","v":347.875},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$300:$H$302,4,TRUE)))","v":310.47500000000002},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$300:$H$302,5,TRUE)))","v":282.15000000000003},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$300:$H$302,6,TRUE)))","v":252.45000000000002},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$300:$H$302,7,TRUE)))","v":233.20000000000002},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$300:$H$302,8,TRUE)))","v":183.97500000000002}]
["Total de Prima neta",null,{"$f":"SUM(C54:C56)","v":1833.7},{"$f":"SUM(D54:D56)","v":1636.5250000000001},1488.0250000000001,{"$f":"SUM(F54:F56)","v":1331.2750000000001},{"$f":"SUM(G54:G56)","v":1228.4250000000002},969.92500000000007]
["Ajuste por la variante con coaseguro fuera\n del país de residencia",null,{"$f":"IF('INGRESO DE DATOS'!$P$3,C57*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,D57*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,E57*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,F57*-15%,0)","v":0}]
["Tarifa administrativa anual",null,75,75,75,75,75,75]
["VAT (5%) :",null,{"$f":"(C30+C31+C32+C34)*5%/4","v":83.350000000000009},{"$f":"(D30+D31+D32+D34)*5%/4","v":74.387500000000003},67.637500000000003,{"$f":"(F30+F31+F32+F34)*5%/4","v":60.512500000000003},{"$f":"(G30+G31+G32+G34)*5%/4","v":55.837500000000006},44.087500000000006]
["ITBMS (7%)",null,{"$f":"+C59*7% + ((C30+C31+C32+C34)*0.1*0.07)/4","v":16.919000000000004},{"$f":"+D59*7% + ((D30+D31+D32+D34)*0.1*0.07)/4","v":15.664250000000003},14.719250000000002,{"$f":"+F59*7% + ((F30+F31+F32+F34)*0.1*0.07)/4","v":13.721750000000004},{"$f":"+G59*7% + ((G30+G31+G32+G34)*0.1*0.07)/4","v":13.067250000000001},11.422250000000002]
["TOTAL de primera cuota",null,{"$f":"SUM(C57:C61)","v":2008.9690000000001},{"$f":"SUM(D57:D61)","v":1801.5767500000002},1645.3817500000002,{"$f":"SUM(F57:F61)","v":1480.5092500000001},{"$f":"SUM(G57:G61)","v":1372.3297500000003},1100.4347500000003]
["Costo de tarifa trimestral 2 a 4",null,{"$f":"((C57+C58)+ C60)+((C30+C31+C32+C34)*0.1*0.07)/4","v":1928.7190000000001},{"$f":"((D57+D58)+ D60)+((D30+D31+D32+D34)*0.1*0.07)/4","v":1721.3267500000002},1565.1317500000002,{"$f":"((F57+F58)+ F60)+((F30+F31+F32+F34)*0.1*0.07)/4","v":1400.2592500000001},{"$f":"((G57+G58)+ G60)+((G30+G31+G32+G34)*0.1*0.07)/4","v":1292.0797500000003},1020.18475]
["TOTAL ANUAL",null,{"$f":"C62+(C63*3)","v":7795.1260000000002},{"$f":"D62+(D63*3)","v":6965.5570000000007},6340.777000000001,{"$f":"F62+(F63*3)","v":5681.2870000000003},5248.5690000000013,4160.9890000000005]
[]
["TARIFAS MENSUALES"]
["Prima para Asegurado Titular",null,{"$f":"VLOOKUP($B$19,Tablas!$A$84:$H$150,3,TRUE)","v":208.50666666666669},{"$f":"VLOOKUP($B$19,Tablas!$A$84:$H$150,4,TRUE)","v":186.01333333333335},{"$f":"VLOOKUP($B$19,Tablas!$A$84:$H$150,5,TRUE)","v":169.21333333333334},{"$f":"VLOOKUP($B$19,Tablas!$A$84:$H$150,6,TRUE)","v":151.38666666666668},{"$f":"VLOOKUP($B$19,Tablas!$A$84:$H$150,7,TRUE)","v":139.62666666666667},{"$f":"VLOOKUP($B$19,Tablas!$A$84:$H$150,8,TRUE)","v":110.32000000000001}]
["Prima para conyuge",null,{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$84:$H$150,3,TRUE)))","v":295.77333333333337},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$84:$H$150,4,TRUE)))","v":264.04000000000002},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$84:$H$150,5,TRUE)))","v":240.05333333333334},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$84:$H$150,6,TRUE)))","v":214.76000000000002},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$84:$H$150,7,TRUE)))","v":198.14666666666668},{"$f":"IF($B$15=1,0,(VLOOKUP($H$19,Tablas!$A$84:$H$150,8,TRUE)))","v":156.42666666666668}]
["Prima para hijo (s)",null,{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$151:$H$153,3,TRUE)))","v":118.06666666666668},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$151:$H$153,4,TRUE)))","v":105.37333333333333},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$151:$H$153,5,TRUE)))","v":95.76},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$151:$H$153,6,TRUE)))","v":85.68},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$151:$H$153,7,TRUE)))","v":79.146666666666675},{"$f":"IF($B$17=0,0,(VLOOKUP($B$17,Tablas!$A$151:$H$153,8,TRUE)))","v":62.440000000000005}]
["Total de Prima neta",null,{"$f":"SUM(C67:C69)","v":622.34666666666681},{"$f":"SUM(D67:D69)","v":555.42666666666673},505.02666666666664,{"$f":"SUM(F67:F69)","v":451.82666666666671},{"$f":"SUM(G67:G69)","v":416.91999999999996},329.18666666666667]
["Ajuste por la variante con coaseguro fuera\n del país de residencia",null,{"$f":"IF('INGRESO DE DATOS'!$P$3,C70*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,D70*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,E70*-15%,0)","v":0},{"$f":"IF('INGRESO DE DATOS'!$P$3,F70*-15%,0)","v":0}]
["Tarifa administrativa anual",null,75,75,75,75,75,75]
["VAT (5%) :",null,{"$f":"(C30+C31+C32+C34)*5%/12","v":27.783333333333335},{"$f":"(D30+D31+D32+D34)*5%/12","v":24.795833333333334},22.545833333333334,{"$f":"(F30+F31+F32+F34)*5%/12","v":20.170833333333334},{"$f":"(G30+G31+G32+G34)*5%/12","v":18.612500000000001},14.695833333333335]
["ITBMS (7%)",null,{"$f":"C72*7% + ((C30+C31+C32+C34)*0.12*0.07)/12","v":9.9176000000000002},{"$f":"D72*7% + ((D30+D31+D32+D34)*0.12*0.07)/12","v":9.4157000000000011},9.037700000000001,{"$f":"F72*7% + ((F30+F31+F32+F34)*0.12*0.07)/12","v":8.6387},{"$f":"G72*7% + ((G30+G31+G32+G34)*0.12*0.07)/12","v":8.3769000000000009},7.7189000000000014]
["TOTAL de primera cuota",null,{"$f":"SUM(C70:C74)","v":735.0476000000001},{"$f":"SUM(D70:D74)","v":664.6382000000001},611.61019999999996,{"$f":"SUM(F70:F74)","v":555.63620000000003},{"$f":"SUM(G70:G74)","v":518.90940000000001},426.60140000000001]
["Costo de Tarifa mensual de 2 a 12",null,{"$f":"((C70 + C71)+C73)+((C30+C31+C32+C34)*0.12*0.07)/12","v":654.7976000000001},{"$f":"((D70 + D71)+D73)+((D30+D31+D32+D34)*0.12*0.07)/12","v":584.3882000000001},531.36019999999996,{"$f":"((F70 + F71)+F73)+((F30+F31+F32+F34)*0.12*0.07)/12","v":475.38620000000003},{"$f":"((G70 + G71)+G73)+((G30+G31+G32+G34)*0.12*0.07)/12","v":438.65939999999995},346.35140000000001]
["TOTAL ANUAL",null,{"$f":"C75+(C76*11)","v":7937.8212000000012},{"$f":"D75+(D76*11)","v":7092.9084000000012},6456.5724,{"$f":"F75+(F76*11)","v":5784.8843999999999},5344.1628000000001,4236.4668000000001]
[]
["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\nde riesgo por parte de Bupa y a la recepción de todos los pagos de prima requeridos."]

{"sheet":"RESUMEN DE TARIFAS","index":2,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,3,5],[20,1,20,2],[41,0,42,6],[28,1,28,6],[26,1,26,6],[32,1,32,6],[36,1,36,6],[22,0,22,6],[12,1,12,6],[4,0,10,6],[16,2,16,3]]}
[" "]
[]
[]
[]
["Cotización de Seguro Médico Internacional\nBupa Essential Care\nResumen de Tarifas\nTarifas en US$ | Validas: 1 de enero de 2024"]
[]
[]
[]
[]
[]
[]
[]
["Nombre del Asegurado Titular",{"$f":"+'INGRESO DE DATOS'!$C$37","v":"John Doe"}]
[]
["Número de adultos en la póliza",{"$f":"+'INGRESO DE DATOS'!$C$39","v":2}]
[]
["Número de Dependientes en la póliza",{"$f":"+'INGRESO DE DATOS'!$C$41","v":2},{"$f":"IF('INGRESO DE DATOS'!$P$2=TRUE, \"Cotización para dependiente de 24 años\",\"\")","v":""}]
[]
["Edad del Asegurado Titular",{"$f":"+'INGRESO DE DATOS'!$C$43","v":32},null,null,"Edad del/la conyuge",{"$f":"+'INGRESO DE DATOS'!$C$45","v":46}]
[]
["Fecha de la cotización",{"$f":"NOW()","v":"2024-01-10T13:30:10.240"}]
[]
["BUPA ESSENTIAL CARE"]
["DEDUCIBLES","PLAN 1","PLAN 2","PLAN 3","PLAN 4","PLAN 5","PLAN 5"]
["En el país de residencia",250,1000,1000,1000,10000,20000]
["Fuera del país de residencia",2000,5000,10000,20000,10000,20000]
[null,"TARIFAS ANUALES"]
[null,{"$f":"'BUPA ESSENTIAL CARE'!C38","v":7081.65},{"$f":"'BUPA ESSENTIAL CARE'!D38","v":6328.8},{"$f":"'BUPA ESSENTIAL CARE'!E38","v":5761.8},{"$f":"'BUPA ESSENTIAL CARE'!F38","v":5163.3},{"$f":"'BUPA ESSENTIAL CARE'!G38","v":4770.6000000000004},{"$f":"'BUPA ESSENTIAL CARE'!H38","v":3783.6}]
[null,"TARIFAS SEMESTRALES"]
[null,{"$f":"'BUPA ESSENTIAL CARE'!C49","v":3794.9928},{"$f":"'BUPA ESSENTIAL CARE'!D49","v":3395.5520999999999},{"$f":"'BUPA ESSENTIAL CARE'!E49","v":3094.7181},{"$f":"'BUPA ESSENTIAL CARE'!F49","v":2777.1711},{"$f":"'BUPA ESSENTIAL CARE'!G49","v":2568.8157000000006},{"$f":"'BUPA ESSENTIAL CARE'!H49","v":2045.1417000000001}]
[null,{"$f":"'BUPA ESSENTIAL CARE'!C50","v":3714.7428},{"$f":"'BUPA ESSENTIAL CARE'!D50","v":3315.3020999999999},{"$f":"'BUPA ESSENTIAL CARE'!E50","v":3014.4681},{"$f":"'BUPA ESSENTIAL CARE'!F50","v":2696.9211},{"$f":"'BUPA ESSENTIAL CARE'!G50","v":2488.5657000000006},{"$f":"'BUPA ESSENTIAL CARE'!H50","v":1964.8917000000001}]
[null,{"$f":"'BUPA ESSENTIAL CARE'!C51","v":7509.7356},{"$f":"'BUPA ESSENTIAL CARE'!D51","v":6710.8541999999998},{"$f":"'BUPA ESSENTIAL CARE'!E51","v":6109.1862000000001},{"$f":"'BUPA ESSENTIAL CARE'!F51","v":5474.0922},{"$f":"'BUPA ESSENTIAL CARE'!G51","v":5057.3814000000011},{"$f":"'BUPA ESSENTIAL CARE'!H51","v":4010.0334000000003}]
[null,"TARIFAS TRIMESTRALES"]
[null,{"$f":"'BUPA ESSENTIAL CARE'!C62","v":2008.9690000000001},{"$f":"'BUPA ESSENTIAL CARE'!D62","v":1801.5767500000002},{"$f":"'BUPA ESSENTIAL CARE'!E62","v":1645.3817500000002},{"$f":"'BUPA ESSENTIAL CARE'!F62","v":1480.5092500000001},{"$f":"'BUPA ESSENTIAL CARE'!G62","v":1372.3297500000003},{"$f":"'BUPA ESSENTIAL CARE'!H62","v":1100.4347500000003}]
[null,{"$f":"'BUPA ESSENTIAL CARE'!C63","v":1928.7190000000001},{"$f":"'BUPA ESSENTIAL CARE'!D63","v":1721.3267500000002},{"$f":"'BUPA ESSENTIAL CARE'!E63","v":1565.1317500000002},{"$f":"'BUPA ESSENTIAL CARE'!F63","v":1400.2592500000001},{"$f":"'BUPA ESSENTIAL CARE'!G63","v":1292.0797500000003},{"$f":"'BUPA ESSENTIAL CARE'!H63","v":1020.18475}]
[null,{"$f":"'BUPA ESSENTIAL CARE'!C64","v":7795.1260000000002},{"$f":"'BUPA ESSENTIAL CARE'!D64","v":6965.5570000000007},{"$f":"'BUPA ESSENTIAL CARE'!E64","v":6340.777000000001},{"$f":"'BUPA ESSENTIAL CARE'!F64","v":5681.2870000000003},{"$f":"'BUPA ESSENTIAL CARE'!G64","v":5248.5690000000013},{"$f":"'BUPA ESSENTIAL CARE'!H64","v":4160.9890000000005}]
[null,"TARIFAS MENSUALES"]
[null,{"$f":"'BUPA ESSENTIAL CARE'!C75","v":735.0476000000001},{"$f":"'BUPA ESSENTIAL CARE'!D75","v":664.6382000000001},{"$f":"'BUPA ESSENTIAL CARE'!E75","v":611.61019999999996},{"$f":"'BUPA ESSENTIAL CARE'!F75","v":555.63620000000003},{"$f":"'BUPA ESSENTIAL CARE'!G75","v":518.90940000000001},{"$f":"'BUPA ESSENTIAL CARE'!H75","v":426.60140000000001}]
[null,{"$f":"'BUPA ESSENTIAL CARE'!C76","v":654.7976000000001},{"$f":"'BUPA ESSENTIAL CARE'!D76","v":584.3882000000001},{"$f":"'BUPA ESSENTIAL CARE'!E76","v":531.36019999999996},{"$f":"'BUPA ESSENTIAL CARE'!F76","v":475.38620000000003},{"$f":"'BUPA ESSENTIAL CARE'!G76","v":438.65939999999995},{"$f":"'BUPA ESSENTIAL CARE'!H76","v":346.35140000000001}]
[null,{"$f":"'BUPA ESSENTIAL CARE'!C77","v":7937.8212000000012},{"$f":"'BUPA ESSENTIAL CARE'!D77","v":7092.9084000000012},{"$f":"'BUPA ESSENTIAL CARE'!E77","v":6456.5724},{"$f":"'BUPA ESSENTIAL CARE'!F77","v":5784.8843999999999},{"$f":"'BUPA ESSENTIAL CARE'!G77","v":5344.1628000000001},{"$f":"'BUPA ESSENTIAL CARE'!H77","v":4236.4668000000001}]
[]
["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.\n\nUna tarifa administrativa de US$75 se cargará automáticamente al primer pago.\n\n*Basado en un modo de pago anual"]

{"sheet":"Tablas","index":3,"n_rows":302,"n_cols":23,"rows_kept":302,"cut":false,"hidden":true,"merged":[[8,17,8,22],[1,0,1,6],[2,0,2,6],[4,0,4,1],[3,2,3,6],[7,2,7,6],[1,20,1,22],[5,0,5,7],[6,0,6,7],[8,9,8,14],[231,0,231,1],[8,0,8,1],[2,12,2,13],[3,12,3,13],[1,8,1,9],[155,0,155,7],[230,0,230,7],[82,0,82,1],[81,0,81,7],[156,0,156,1]]}
[]
[null,null,null,null,null,null,null,null,"FACTOR MENSUAL:",null,9.3333333333333338E-2,null,"Descuento de 24 años",{"$f":"'INGRESO DE DATOS'!P30","v":1},"Essential"]
[null,null,null,null,null,null,null,null,"FACTOR TRIMESTRAL:",null,0.27500000000000002,null,"Descuento de producto (%)",null,{"$f":"'INGRESO DE DATOS'!O39","v":0}]
[null,null,null,null,null,null,null,null,"FACTOR SEMIANUAL:",null,0.53,null,"Factor para el descuento combinado",null,{"$f":"'INGRESO DE DATOS'!O47","v":1}]
[]
["BUPA ESSENTIAL CARE"]
["TARIFAS ANUALES"]
[]
["EDAD",null,500,1000,1000,1000,10000,20000,null,"TARIFAS BASE",null,null,null,null,null,null,null,"TARIFAS BASE CON DESCUENTO"]
[18,null,{"$f":"R10","v":1662},1483,1348,1207,1113,879,null,1662,1483,1348,1207,1113,879,null,null,{"$f":"J10*$O$4","v":1662},{"$f":"K10*$O$4","v":1483},1348,1207,{"$f":"N10*$O$4","v":1113},{"$f":"O10*$O$4","v":879}]
[19,null,{"$f":"R11","v":1689},{"$f":"S11","v":1507},{"$f":"T11","v":1370},{"$f":"U11","v":1226},{"$f":"V11","v":1131},{"$f":"W11","v":893},null,1689,1507,1370,1226,1131,893,null,null,{"$f":"J11*$O$4","v":1689},{"$f":"K11*$O$4","v":1507},{"$f":"L11*$O$4","v":1370},{"$f":"M11*$O$4","v":1226},{"$f":"N11*$O$4","v":1131},{"$f":"O11*$O$4","v":893}]
[20,null,1715,1531,1392,1246,1150,907,null,1715,1531,1392,1246,1150,907,null,null,1715,1531,1392,1246,1150,907]
[21,null,1742,1555,1414,1265,1167,922,null,1742,1555,1414,1265,1167,922,null,null,1742,1555,1414,1265,1167,922]
[22,null,1768,1578,1436,1285,1185,936,null,1768,1578,1436,1285,1185,936,null,null,1768,1578,1436,1285,1185,936]
[23,null,1796,1602,1457,1304,1203,950,null,1796,1602,1457,1304,1203,950,null,null,1796,1602,1457,1304,1203,950]
[24,null,1822,1626,1479,1323,1221,963,null,1822,1626,1479,1323,1221,963,null,null,1822,1626,1479,1323,1221,963]
[25,null,1849,1651,1501,1343,1238,977,null,1849,1651,1501,1343,1238,977,null,null,1849,1651,1501,1343,1238,977]
[26,null,1908,1703,1548,1385,1278,1008,null,1908,1703,1548,1385,1278,1008,null,null,1908,1703,1548,1385,1278,1008]
[27,null,1966,1754,1596,1427,1318,1039,null,1966,1754,1596,1427,1318,1039,null,null,1966,1754,1596,1427,1318,1039]
[28,null,2025,1807,1643,1470,1356,1070,null,2025,1807,1643,1470,1356,1070,null,null,2025,1807,1643,1470,1356,1070]
[29,null,2083,1859,1691,1512,1396,1102,null,2083,1859,1691,1512,1396,1102,null,null,2083,1859,1691,1512,1396,1102]
[30,null,2141,1911,1738,1555,1435,1133,null,2141,1911,1738,1555,1435,1133,null,null,2141,1911,1738,1555,1435,1133]
[31,null,2188,1952,1775,1588,1466,1157,null,2188,1952,1775,1588,1466,1157,null,null,2188,1952,1775,1588,1466,1157]
[32,null,2234,1993,1813,1622,1496,1182,null,2234,1993,1813,1622,1496,1182,null,null,2234,1993,1813,1622,1496,1182]
[33,null,2280,2034,1851,1655,1527,1205,null,2280,2034,1851,1655,1527,1205,null,null,2280,2034,1851,1655,1527,1205]
[34,null,2325,2075,1887,1689,1558,1230,null,2325,2075,1887,1689,1558,1230,null,null,2325,2075,1887,1689,1558,1230]
[35,null,2371,2116,1925,1722,1589,1255,null,2371,2116,1925,1722,1589,1255,null,null,2371,2116,1925,1722,1589,1255]
[36,null,2433,2171,1975,1766,1630,1287,null,2433,2171,1975,1766,1630,1287,null,null,2433,2171,1975,1766,1630,1287]
[37,null,2494,2226,2024,1811,1672,1319,null,2494,2226,2024,1811,1672,1319,null,null,2494,2226,2024,1811,1672,1319]
[38,null,2557,2281,2074,1856,1712,1352,null,2557,2281,2074,1856,1712,1352,null,null,2557,2281,2074,1856,1712,1352]
[39,null,2618,2337,2124,1900,1754,1384,null,2618,2337,2124,1900,1754,1384,null,null,2618,2337,2124,1900,1754,1384]
[40,null,2679,2391,2175,1944,1795,1416,null,2679,2391,2175,1944,1795,1416,null,null,2679,2391,2175,1944,1795,1416]
[41,null,2765,2468,2244,2007,1853,1462,null,2765,2468,2244,2007,1853,1462,null,null,2765,2468,2244,2007,1853,1462]
[42,null,2852,2545,2314,2070,1910,1508,null,2852,2545,2314,2070,1910,1508,null,null,2852,2545,2314,2070,1910,1508]
[43,null,2938,2622,2384,2132,1968,1553,null,2938,2622,2384,2132,1968,1553,null,null,2938,2622,2384,2132,1968,1553]
[44,null,3024,2698,2454,2195,2026,1599,null,3024,2698,2454,2195,2026,1599,null,null,3024,2698,2454,2195,2026,1599]
[45,null,3110,2776,2524,2258,2084,1645,null,3110,2776,2524,2258,2084,1645,null,null,3110,2776,2524,2258,2084,1645]
[46,null,3169,2829,2572,2301,2123,1676,null,3169,2829,2572,2301,2123,1676,null,null,3169,2829,2572,2301,2123,1676]
[47,null,3229,2882,2621,2344,2163,1707,null,3229,2882,2621,2344,2163,1707,null,null,3229,2882,2621,2344,2163,1707]
[48,null,3289,2935,2669,2387,2204,1739,null,3289,2935,2669,2387,2204,1739,null,null,3289,2935,2669,2387,2204,1739]
[49,null,3348,2988,2717,2430,2243,1770,null,3348,2988,2717,2430,2243,1770,null,null,3348,2988,2717,2430,2243,1770]
[50,null,3408,3041,2765,2474,2283,1801,null,3408,3041,2765,2474,2283,1801,null,null,3408,3041,2765,2474,2283,1801]
[51,null,{"$f":"R43","v":3532},{"$f":"S43","v":3152},{"$f":"T43","v":2866},{"$f":"U43","v":2564},2366,1868,null,3532,3152,2866,2564,2366,1868,null,null,3532,3152,2866,2564,2366,1868]
[52,null,3656,3263,2967,2654,2450,1933,null,3656,3263,2967,2654,2450,1933,null,null,3656,3263,2967,2654,2450,1933]
[53,null,3781,3374,3068,2745,2533,1999,null,3781,3374,3068,2745,2533,1999,null,null,3781,3374,3068,2745,2533,1999]
[54,null,3905,3486,3169,2835,2617,2065,null,3905,3486,3169,2835,2617,2065,null,null,3905,3486,3169,2835,2617,2065]
[55,null,4030,3597,3270,2925,2700,2131,null,4030,3597,3270,2925,2700,2131,null,null,4030,3597,3270,2925,2700,2131]
[56,null,4074,3636,3306,2958,2730,2154,null,4074,3636,3306,2958,2730,2154,null,null,4074,3636,3306,2958,2730,2154]
[57,null,4119,3676,3342,2990,2759,2178,null,4119,3676,3342,2990,2759,2178,null,null,4119,3676,3342,2990,2759,2178]
[58,null,4163,3716,3379,3022,2789,2201,null,4163,3716,3379,3022,2789,2201,null,null,4163,3716,3379,3022,2789,2201]
[59,null,4208,3755,3414,3055,2819,2225,null,4208,3755,3414,3055,2819,2225,null,null,4208,3755,3414,3055,2819,2225]
[60,null,4251,3795,3450,3087,2849,2249,null,4251,3795,3450,3087,2849,2249,null,null,4251,3795,3450,3087,2849,2249]
[61,null,4790,4275,3887,3477,3209,2532,null,4790,4275,3887,3477,3209,2532,null,null,4790,4275,3887,3477,3209,2532]
[62,null,5327,4755,4323,3867,3569,2817,null,5327,4755,4323,3867,3569,2817,null,null,5327,4755,4323,3867,3569,2817]
[63,null,5866,5235,4760,4258,3930,3101,null,5866,5235,4760,4258,3930,3101,null,null,5866,5235,4760,4258,3930,3101]
[64,null,6405,5716,5197,4650,4291,3386,null,6405,5716,5197,4650,4291,3386,null,null,6405,5716,5197,4650,4291,3386]
[65,null,6430,5739,5218,4668,4308,3400,null,6430,5739,5218,4668,4308,3400,null,null,6430,5739,5218,4668,4308,3400]
[66,null,6457,5762,5240,4688,4325,3414,null,6457,5762,5240,4688,4325,3414,null,null,6457,5762,5240,4688,4325,3414]
[67,null,7178,6406,5825,5210,4808,3795,null,7178,6406,5825,5210,4808,3795,null,null,7178,6406,5825,5210,4808,3795]
[68,null,7902,7052,6412,5736,5294,4178,null,7902,7052,6412,5736,5294,4178,null,null,7902,7052,6412,5736,5294,4178]
[69,null,8264,7375,6706,5999,5536,4368,null,8264,7375,6706,5999,5536,4368,null,null,8264,7375,6706,5999,5536,4368]
[70,null,8322,7427,6753,6041,5575,4399,null,8322,7427,6753,6041,5575,4399,null,null,8322,7427,6753,6041,5575,4399]
[71,null,9370,8362,7604,6802,6277,4954,null,9370,8362,7604,6802,6277,4954,null,null,9370,8362,7604,6802,6277,4954]
[72,null,10415,9295,8453,7560,6978,5507,null,10415,9295,8453,7560,6978,5507,null,null,10415,9295,8453,7560,6978,5507]
[73,null,11463,10230,9301,8321,7679,6060,null,11463,10230,9301,8321,7679,6060,null,null,11463,10230,9301,8321,7679,6060]
[74,null,12510,11166,10152,9082,8381,6614,null,12510,11166,10152,9082,8381,6614,null,null,12510,11166,10152,9082,8381,6614]
[75,null,13669,12199,11092,9922,9158,7226,null,13669,12199,11092,9922,9158,7226,null,null,13669,12199,11092,9922,9158,7226]
[76,null,13669,12199,11092,9922,9158,7226,null,13669,12199,11092,9922,9158,7226,null,null,13669,12199,11092,9922,9158,7226]
[77,null,13669,12199,11092,9922,9158,7226,null,13669,12199,11092,9922,9158,7226,null,null,13669,12199,11092,9922,9158,7226]
[78,null,13669,12199,11092,9922,9158,7226,null,13669,12199,11092,9922,9158,7226,null,null,13669,12199,11092,9922,9158,7226]
[79,null,13669,12199,11092,9922,9158,7226,null,13669,12199,11092,9922,9158,7226,null,null,13669,12199,11092,9922,9158,7226]
[80,null,13669,12199,11092,9922,9158,7226,null,13669,12199,11092,9922,9158,7226,null,null,13669,12199,11092,9922,9158,7226]
[81,null,13669,12199,11092,9922,9158,7226,null,13669,12199,11092,9922,9158,7226,null,null,13669,12199,11092,9922,9158,7226]
[82,null,13669,12199,11092,9922,9158,7226,null,13669,12199,11092,9922,9158,7226,null,null,13669,12199,11092,9922,9158,7226]
[83,null,13669,12199,11092,9922,{"$f":"V75","v":9158},{"$f":"W75","v":7226},null,13669,12199,11092,9922,9158,7226,null,null,{"$f":"J75*$O$4","v":13669},{"$f":"K75*$O$4","v":12199},{"$f":"L75*$O$4","v":11092},{"$f":"M75*$O$4","v":9922},{"$f":"N75*$O$4","v":9158},{"$f":"O75*$O$4","v":7226}]
[84,"o más",13669,12199,11092,9922,9158,7226,null,13669,12199,11092,9922,9158,7226,null,null,13669,12199,11092,9922,9158,7226]
[1,"Hijo",772,690,627,561,517,408,null,772,690,627,561,517,408,null,null,772,690,627,561,517,408]
[2,"Hijos",1265,1129,1026,918,848,669,null,1265,1129,1026,918,848,669,null,null,1265,1129,1026,918,848,669]
[3,"Hijos o más",1848,1650,1500,1342,1238,977,null,1848,1650,1500,1342,1238,977,null,null,1848,1650,1500,1342,1238,977]
[]
[]
["BUPA GLOBAL PREMIER - MENSUALES"]
["EDAD",null,500,1000,1000,1000,10000,20000]
[18,null,{"$f":"C10*$K$2","v":155.12},{"$f":"D10*$K$2","v":138.41333333333333},125.81333333333333,112.65333333333334,103.88000000000001,82.04]
[19,null,{"$f":"C11*$K$2","v":157.64000000000001},140.65333333333334,127.86666666666667,114.42666666666668,105.56,83.346666666666664]
[20,null,{"$f":"C12*$K$2","v":160.06666666666666},142.89333333333335,129.92000000000002,116.29333333333334,107.33333333333334,84.653333333333336]
[21,null,{"$f":"C13*$K$2","v":162.58666666666667},145.13333333333333,131.97333333333333,118.06666666666668,108.92,86.053333333333342]
[22,null,{"$f":"C14*$K$2","v":165.01333333333335},147.28,134.02666666666667,119.93333333333334,110.60000000000001,87.36]
[23,null,{"$f":"C15*$K$2","v":167.62666666666667},149.52000000000001,135.98666666666668,121.70666666666668,112.28,88.666666666666671]
[24,null,{"$f":"C16*$K$2","v":170.05333333333334},151.76000000000002,138.04000000000002,123.48,113.96000000000001,89.88000000000001]
[25,null,{"$f":"C17*$K$2","v":172.57333333333335},154.09333333333333,140.09333333333333,125.34666666666668,115.54666666666667,91.186666666666667]
[26,null,{"$f":"C18*$K$2","v":178.08},158.94666666666669,144.48000000000002,129.26666666666668,119.28,94.08]
[27,null,{"$f":"C19*$K$2","v":183.49333333333334},163.70666666666668,148.96,133.18666666666667,123.01333333333334,96.973333333333343]
[28,null,{"$f":"C20*$K$2","v":189},168.65333333333334,153.34666666666666,137.20000000000002,126.56,99.866666666666674]
[29,null,{"$f":"C21*$K$2","v":194.41333333333336},173.50666666666666,157.82666666666668,141.12,130.29333333333335,102.85333333333334]
[30,null,{"$f":"C22*$K$2","v":199.82666666666668},178.36,162.21333333333334,145.13333333333333,133.93333333333334,105.74666666666667]
[31,null,{"$f":"C23*$K$2","v":204.21333333333334},182.18666666666667,165.66666666666669,148.21333333333334,136.82666666666668,107.98666666666666]
[32,null,{"$f":"C24*$K$2","v":208.50666666666669},186.01333333333335,169.21333333333334,151.38666666666668,139.62666666666667,110.32000000000001]
[33,null,{"$f":"C25*$K$2","v":212.8},189.84,172.76000000000002,154.46666666666667,142.52000000000001,112.46666666666667]
[34,null,{"$f":"C26*$K$2","v":217},193.66666666666669,176.12,157.64000000000001,145.41333333333333,114.80000000000001]
[35,null,{"$f":"C27*$K$2","v":221.29333333333335},197.49333333333334,179.66666666666669,160.72,148.30666666666667,117.13333333333334]
[36,null,{"$f":"C28*$K$2","v":227.08},202.62666666666667,184.33333333333334,164.82666666666668,152.13333333333335,120.12]
[37,null,{"$f":"C29*$K$2","v":232.77333333333334},207.76000000000002,188.90666666666667,169.02666666666667,156.05333333333334,123.10666666666667]
[38,null,{"$f":"C30*$K$2","v":238.65333333333334},212.89333333333335,193.57333333333335,173.22666666666669,159.78666666666666,126.18666666666667]
[39,null,{"$f":"C31*$K$2","v":244.34666666666666},218.12,198.24,177.33333333333334,163.70666666666668,129.17333333333335]
[40,null,{"$f":"C32*$K$2","v":250.04000000000002},223.16,203,181.44,167.53333333333333,132.16]
[41,null,{"$f":"C33*$K$2","v":258.06666666666666},230.34666666666666,209.44,187.32000000000002,172.94666666666669,136.45333333333335]
[42,null,{"$f":"C34*$K$2","v":266.18666666666667},237.53333333333333,215.97333333333333,193.20000000000002,178.26666666666668,140.74666666666667]
[43,null,{"$f":"C35*$K$2","v":274.21333333333337},244.72,222.50666666666669,198.98666666666668,183.68,144.94666666666669]
[44,null,{"$f":"C36*$K$2","v":282.24},251.81333333333333,229.04000000000002,204.86666666666667,189.09333333333333,149.24]
[45,null,{"$f":"C37*$K$2","v":290.26666666666665},259.09333333333336,235.57333333333335,210.74666666666667,194.50666666666669,153.53333333333333]
[46,null,{"$f":"C38*$K$2","v":295.77333333333337},264.04000000000002,240.05333333333334,214.76000000000002,198.14666666666668,156.42666666666668]
[47,null,{"$f":"C39*$K$2","v":301.37333333333333},268.98666666666668,244.62666666666667,218.77333333333334,201.88,159.32]
[48,null,{"$f":"C40*$K$2","v":306.97333333333336},273.93333333333334,249.10666666666668,222.78666666666669,205.70666666666668,162.30666666666667]
[49,null,{"$f":"C41*$K$2","v":312.48},278.88,253.58666666666667,226.8,209.34666666666666,165.20000000000002]
[50,null,{"$f":"C42*$K$2","v":318.08000000000004},283.82666666666665,258.06666666666666,230.90666666666667,213.08,168.09333333333333]
[51,null,{"$f":"C43*$K$2","v":329.65333333333336},294.18666666666667,267.49333333333334,239.30666666666667,220.82666666666668,174.34666666666666]
[52,null,{"$f":"C44*$K$2","v":341.22666666666669},304.54666666666668,276.92,247.70666666666668,228.66666666666669,180.41333333333336]
[53,null,{"$f":"C45*$K$2","v":352.89333333333337},314.90666666666669,286.34666666666669,256.2,236.41333333333336,186.57333333333335]
[54,null,{"$f":"C46*$K$2","v":364.4666666666667},325.36,295.77333333333337,264.60000000000002,244.25333333333333,192.73333333333335]
[55,null,{"$f":"C47*$K$2","v":376.13333333333333},335.72,305.2,273,252,198.89333333333335]
[56,null,{"$f":"C48*$K$2","v":380.24},339.36,308.56,276.08000000000004,254.8,201.04000000000002]
[57,null,{"$f":"C49*$K$2","v":384.44},343.09333333333336,311.92,279.06666666666666,257.50666666666666,203.28]
[58,null,{"$f":"C50*$K$2","v":388.54666666666668},346.82666666666671,315.37333333333333,282.05333333333334,260.30666666666667,205.42666666666668]
[59,null,{"$f":"C51*$K$2","v":392.74666666666667},350.4666666666667,318.64,285.13333333333333,263.10666666666668,207.66666666666669]
[60,null,{"$f":"C52*$K$2","v":396.76},354.2,322,288.12,265.90666666666669,209.90666666666667]
[61,null,{"$f":"C53*$K$2","v":447.06666666666666},399,362.78666666666669,324.52000000000004,299.50666666666666,236.32000000000002]
[62,null,{"$f":"C54*$K$2","v":497.18666666666667},443.8,403.48,360.92,333.10666666666668,262.92]
[63,null,{"$f":"C55*$K$2","v":547.49333333333334},488.6,444.26666666666671,397.41333333333336,366.8,289.42666666666668]
[64,null,{"$f":"C56*$K$2","v":597.80000000000007},533.49333333333334,485.05333333333334,434,400.49333333333334,316.0266666666667]
[65,null,{"$f":"C57*$K$2","v":600.13333333333333},535.64,487.01333333333338,435.68,402.08000000000004,317.33333333333337]
[66,null,{"$f":"C58*$K$2","v":602.65333333333331},537.78666666666675,489.06666666666666,437.54666666666668,403.66666666666669,318.64]
[67,null,{"$f":"C59*$K$2","v":669.94666666666672},597.89333333333332,543.66666666666674,486.26666666666671,448.74666666666667,354.2]
[68,null,{"$f":"C60*$K$2","v":737.52},658.18666666666672,598.45333333333338,535.36,494.10666666666668,389.94666666666666]
[69,null,{"$f":"C61*$K$2","v":771.30666666666673},688.33333333333337,625.89333333333332,559.90666666666664,516.69333333333338,407.68]
[70,null,{"$f":"C62*$K$2","v":776.72},693.18666666666672,630.28,563.82666666666671,520.33333333333337,410.57333333333338]
[71,null,{"$f":"C63*$K$2","v":874.53333333333342},780.45333333333338,709.70666666666671,634.85333333333335,585.85333333333335,462.37333333333333]
[72,null,{"$f":"C64*$K$2","v":972.06666666666672},867.53333333333342,788.94666666666672,705.6,651.28000000000009,513.98666666666668]
[73,null,{"$f":"C65*$K$2","v":1069.8800000000001},954.80000000000007,868.09333333333336,776.62666666666667,716.70666666666671,565.6]
[74,null,{"$f":"C66*$K$2","v":1167.6000000000001},1042.1600000000001,947.5200000000001,847.65333333333342,782.22666666666669,617.30666666666673]
[75,null,{"$f":"C67*$K$2","v":1275.7733333333333},1138.5733333333335,1035.2533333333333,926.0533333333334,854.74666666666667,674.42666666666673]
[76,null,{"$f":"C68*$K$2","v":1275.7733333333333},1138.5733333333335,1035.2533333333333,926.0533333333334,854.74666666666667,674.42666666666673]
[77,null,{"$f":"C69*$K$2","v":1275.7733333333333},1138.5733333333335,1035.2533333333333,926.0533333333334,854.74666666666667,674.42666666666673]
[78,null,{"$f":"C70*$K$2","v":1275.7733333333333},1138.5733333333335,1035.2533333333333,926.0533333333334,854.74666666666667,674.42666666666673]
[79,null,{"$f":"C71*$K$2","v":1275.7733333333333},1138.5733333333335,1035.2533333333333,926.0533333333334,854.74666666666667,674.42666666666673]
[80,null,{"$f":"C72*$K$2","v":1275.7733333333333},1138.5733333333335,1035.2533333333333,926.0533333333334,854.74666666666667,674.42666666666673]
[81,null,{"$f":"C73*$K$2","v":1275.7733333333333},1138.5733333333335,1035.2533333333333,926.0533333333334,854.74666666666667,674.42666666666673]
[82,null,{"$f":"C74*$K$2","v":1275.7733333333333},1138.5733333333335,1035.2533333333333,926.0533333333334,854.74666666666667,674.42666666666673]
[83,null,{"$f":"C75*$K$2","v":1275.7733333333333},1138.5733333333335,1035.2533333333333,926.0533333333334,854.74666666666667,674.42666666666673]
[84,"o más",{"$f":"C76*$K$2","v":1275.7733333333333},1138.5733333333335,1035.2533333333333,926.0533333333334,854.74666666666667,674.42666666666673]
[1,"Hijo",{"$f":"C77*$K$2","v":72.053333333333342},64.400000000000006,58.52,52.36,48.253333333333337,38.08]
[2,"Hijos",{"$f":"C78*$K$2","v":118.06666666666668},105.37333333333333,95.76,85.68,79.146666666666675,62.440000000000005]
[3,"Hijos o más",{"$f":"C79*$K$2","v":172.48000000000002},154,140,125.25333333333334,115.54666666666667,91.186666666666667]
[]
[]
["TARIFAS SEMESTRALES"]
["EDAD",null,500,1000,1000,1000,10000,20000]
[18,null,{"$f":"C10*$K$4","v":880.86},{"$f":"D10*$K$4","v":785.99},{"$f":"E10*$K$4","v":714.44},{"$f":"F10*$K$4","v":639.71},{"$f":"G10*$K$4","v":589.89},465.87]
[19,null,{"$f":"C11*$K$4","v":895.17000000000007},798.71,726.1,{"$f":"F11*$K$4","v":649.78000000000009},599.43000000000006,473.29]
[20,null,908.95,811.43000000000006,737.76,{"$f":"F12*$K$4","v":660.38},609.5,480.71000000000004]
[21,null,923.26,824.15000000000009,749.42000000000007,{"$f":"F13*$K$4","v":670.45},618.51,488.66]
[22,null,937.04000000000008,836.34,761.08,{"$f":"F14*$K$4","v":681.05000000000007},628.05000000000007,496.08000000000004]
[23,null,951.88,849.06000000000006,772.21,{"$f":"F15*$K$4","v":691.12},637.59,503.5]
[24,null,965.66000000000008,861.78000000000009,783.87,{"$f":"F16*$K$4","v":701.19},647.13,510.39000000000004]
[25,null,979.97,875.03000000000009,795.53000000000009,{"$f":"F17*$K$4","v":711.79000000000008},656.14,517.81000000000006]
[26,null,1011.24,902.59,820.44,{"$f":"F18*$K$4","v":734.05000000000007},677.34,534.24]
[27,null,1041.98,929.62,845.88,{"$f":"F19*$K$4","v":756.31000000000006},698.54000000000008,550.67000000000007]
[28,null,1073.25,957.71,870.79000000000008,{"$f":"F20*$K$4","v":779.1},718.68000000000006,567.1]
[29,null,1103.99,985.2700000000001,896.23,{"$f":"F21*$K$4","v":801.36},739.88,584.06000000000006]
[30,null,1134.73,1012.83,921.1400000000001,{"$f":"F22*$K$4","v":824.15000000000009},760.55000000000007,600.49]
[31,null,1159.6400000000001,1034.56,940.75,{"$f":"F23*$K$4","v":841.64},776.98,613.21]
[32,null,1184.02,1056.29,960.8900000000001,{"$f":"F24*$K$4","v":859.66000000000008},792.88,626.46]
[33,null,1208.4000000000001,1078.02,981.03000000000009,{"$f":"F25*$K$4","v":877.15000000000009},809.31000000000006,638.65]
[34,null,1232.25,1099.75,1000.11,{"$f":"F26*$K$4","v":895.17000000000007},825.74,651.9]
[35,null,1256.6300000000001,1121.48,1020.25,{"$f":"F27*$K$4","v":912.66000000000008},842.17000000000007,665.15]
[36,null,1289.49,1150.6300000000001,1046.75,{"$f":"F28*$K$4","v":935.98},863.90000000000009,682.11]
[37,null,1321.8200000000002,1179.78,1072.72,{"$f":"F29*$K$4","v":959.83},886.16000000000008,699.07]
[38,null,1355.21,1208.93,1099.22,{"$f":"F30*$K$4","v":983.68000000000006},907.36,716.56000000000006]
[39,null,{"$f":"C31*$K$4","v":1387.54},1238.6100000000001,1125.72,{"$f":"F31*$K$4","v":1007},929.62,733.52]
[40,null,1419.8700000000001,1267.23,1152.75,{"$f":"F32*$K$4","v":1030.3200000000002},951.35,750.48]
[41,null,1465.45,1308.04,1189.3200000000002,{"$f":"F33*$K$4","v":1063.71},982.09,774.86]
[42,null,1511.5600000000002,1348.8500000000001,1226.42,{"$f":"F34*$K$4","v":1097.1000000000001},1012.3000000000001,799.24]
[43,null,1557.14,1389.66,1263.52,{"$f":"F35*$K$4","v":1129.96},1043.04,823.09]
[44,null,1602.72,1429.94,1300.6200000000001,{"$f":"F36*$K$4","v":1163.3500000000001},1073.78,847.47]
[45,null,1648.3000000000002,1471.28,1337.72,{"$f":"F37*$K$4","v":1196.74},1104.52,871.85]
[46,null,1679.5700000000002,1499.3700000000001,1363.16,{"$f":"F38*$K$4","v":1219.53},1125.19,888.28000000000009]
[47,null,1711.3700000000001,1527.46,1389.13,{"$f":"F39*$K$4","v":1242.3200000000002},1146.3900000000001,904.71]
[48,null,1743.17,1555.5500000000002,1414.5700000000002,{"$f":"F40*$K$4","v":1265.1100000000001},1168.1200000000001,921.67000000000007]
[49,null,1774.44,1583.64,1440.01,{"$f":"F41*$K$4","v":1287.9000000000001},1188.79,938.1]
[50,null,1806.24,1611.73,1465.45,{"$f":"F42*$K$4","v":1311.22},1209.99,954.53000000000009]
[51,null,1871.96,1670.5600000000002,1518.98,{"$f":"F43*$K$4","v":1358.92},1253.98,990.04000000000008]
[52,null,1937.68,1729.39,1572.51,{"$f":"F44*$K$4","v":1406.6200000000001},1298.5,1024.49]
[53,null,2003.93,1788.22,1626.0400000000002,{"$f":"F45*$K$4","v":1454.8500000000001},1342.49,1059.47]
[54,null,2069.65,1847.5800000000002,1679.5700000000002,{"$f":"F46*$K$4","v":1502.5500000000002},1387.01,1094.45]
[55,null,2135.9,1906.41,1733.1000000000001,{"$f":"F47*$K$4","v":1550.25},1431,1129.43]
[56,null,2159.2200000000003,1927.0800000000002,1752.18,{"$f":"F48*$K$4","v":1567.74},1446.9,1141.6200000000001]
[57,null,2183.0700000000002,1948.2800000000002,1771.26,{"$f":"F49*$K$4","v":1584.7},1462.27,1154.3400000000001]
[58,null,2206.3900000000003,1969.48,1790.8700000000001,{"$f":"F50*$K$4","v":1601.66},1478.17,1166.53]
[59,null,{"$f":"C51*$K$4","v":2230.2400000000002},1990.15,1809.42,{"$f":"F51*$K$4","v":1619.15},1494.0700000000002,1179.25]
[60,null,2253.0300000000002,2011.3500000000001,1828.5,{"$f":"F52*$K$4","v":1636.1100000000001},1509.97,1191.97]
[61,null,2538.7000000000003,2265.75,2060.11,{"$f":"F53*$K$4","v":1842.8100000000002},1700.77,1341.96]
[62,null,2823.31,2520.15,2291.19,{"$f":"F54*$K$4","v":2049.5100000000002},1891.5700000000002,1493.01]
[63,null,3108.98,2774.55,2522.8000000000002,{"$f":"F55*$K$4","v":2256.7400000000002},2082.9,1643.53]
[64,null,3394.65,3029.48,2754.4100000000003,{"$f":"F56*$K$4","v":2464.5},2274.23,1794.5800000000002]
[65,null,3407.9,3041.67,2765.54,{"$f":"F57*$K$4","v":2474.04},2283.2400000000002,1802]
[66,null,3422.21,3053.86,2777.2000000000003,{"$f":"F58*$K$4","v":2484.6400000000003},2292.25,1809.42]
[67,null,3804.34,3395.1800000000003,3087.25,{"$f":"F59*$K$4","v":2761.3},2548.2400000000002,2011.3500000000001]
[68,null,4188.0600000000004,3737.5600000000004,3398.36,{"$f":"F60*$K$4","v":3040.08},2805.82,2214.34]
[69,null,4379.92,3908.75,3554.1800000000003,{"$f":"F61*$K$4","v":3179.4700000000003},2934.08,2315.04]
[70,null,4410.66,3936.3100000000004,3579.09,{"$f":"F62*$K$4","v":3201.73},2954.75,2331.4700000000003]
[71,null,4966.1000000000004,4431.8600000000006,4030.1200000000003,{"$f":"F63*$K$4","v":3605.0600000000004},3326.81,2625.6200000000003]
[72,null,5519.9500000000007,4926.3500000000004,4480.09,{"$f":"F64*$K$4","v":4006.8},3698.34,2918.71]
[73,null,6075.39,5421.9000000000005,4929.5300000000007,{"$f":"F65*$K$4","v":4410.13},4069.8700000000003,3211.8]
[74,null,6630.3,5917.9800000000005,5380.56,{"$f":"F66*$K$4","v":4813.46},4441.93,3505.42]
[75,null,7244.5700000000006,6465.47,5878.76,{"$f":"F67*$K$4","v":5258.66},4853.7400000000007,3829.78]
[76,null,7244.5700000000006,6465.47,5878.76,{"$f":"F68*$K$4","v":5258.66},4853.7400000000007,3829.78]
[77,null,7244.5700000000006,6465.47,5878.76,{"$f":"F69*$K$4","v":5258.66},4853.7400000000007,3829.78]
[78,null,7244.5700000000006,6465.47,5878.76,{"$f":"F70*$K$4","v":5258.66},4853.7400000000007,3829.78]
[79,null,{"$f":"C71*$K$4","v":7244.5700000000006},6465.47,5878.76,{"$f":"F71*$K$4","v":5258.66},4853.7400000000007,3829.78]
[80,null,7244.5700000000006,6465.47,5878.76,{"$f":"F72*$K$4","v":5258.66},4853.7400000000007,3829.78]
[81,null,7244.5700000000006,6465.47,5878.76,{"$f":"F73*$K$4","v":5258.66},4853.7400000000007,3829.78]
[82,null,7244.5700000000006,6465.47,5878.76,{"$f":"F74*$K$4","v":5258.66},4853.7400000000007,3829.78]
[83,null,7244.5700000000006,6465.47,5878.76,{"$f":"F75*$K$4","v":5258.66},4853.7400000000007,3829.78]
[84,"o más",7244.5700000000006,6465.47,5878.76,{"$f":"F76*$K$4","v":5258.66},4853.7400000000007,3829.78]
[1,"Hijo",409.16,365.70000000000005,332.31,{"$f":"F77*$K$4","v":297.33000000000004},274.01,216.24]
[2,"Hijos",670.45,598.37,543.78,{"$f":"F78*$K$4","v":486.54},449.44,354.57]
[3,"Hijos o más",979.44,874.5,795,{"$f":"F79*$K$4","v":711.26},656.14,517.81000000000006]
[]
[]
[]
["TARIFAS TRIMESTRALES"]
["EDAD",null,500,1000,1000,1000,10000,20000]
[18,null,{"$f":"C10*$K$3","v":457.05},{"$f":"D10*$K$3","v":407.82500000000005},{"$f":"E10*$K$3","v":370.70000000000005},{"$f":"F10*$K$3","v":331.92500000000001},{"$f":"G10*$K$3","v":306.07500000000005},241.72500000000002]
[19,null,{"$f":"C11*$K$3","v":464.47500000000002},414.42500000000001,376.75000000000006,{"$f":"F11*$K$3","v":337.15000000000003},311.02500000000003,245.57500000000002]
[20,null,471.62500000000006,421.02500000000003,382.8,{"$f":"F12*$K$3","v":342.65000000000003},316.25,249.42500000000001]
[21,null,479.05,427.62500000000006,388.85,{"$f":"F13*$K$3","v":347.875},320.92500000000001,253.55]
[22,null,486.20000000000005,433.95000000000005,394.90000000000003,{"$f":"F14*$K$3","v":353.37500000000006},325.875,257.40000000000003]
[23,null,493.90000000000003,440.55,400.67500000000001,{"$f":"F15*$K$3","v":358.6},330.82500000000005,261.25]
[24,null,501.05000000000007,447.15000000000003,406.72500000000002,{"$f":"F16*$K$3","v":363.82500000000005},335.77500000000003,264.82500000000005]
[25,null,508.47500000000002,454.02500000000003,412.77500000000003,{"$f":"F17*$K$3","v":369.32500000000005},340.45000000000005,268.67500000000001]
[26,null,524.70000000000005,468.32500000000005,425.70000000000005,{"$f":"F18*$K$3","v":380.87500000000006},351.45000000000005,277.20000000000005]
[27,null,540.65000000000009,482.35,438.90000000000003,{"$f":"F19*$K$3","v":392.42500000000001},362.45000000000005,285.72500000000002]
[28,null,556.875,496.92500000000007,451.82500000000005,{"$f":"F20*$K$3","v":404.25000000000006},372.90000000000003,294.25]
[29,null,572.82500000000005,511.22500000000002,465.02500000000003,{"$f":"F21*$K$3","v":415.8},383.90000000000003,303.05]
[30,null,588.77500000000009,525.52500000000009,477.95000000000005,{"$f":"F22*$K$3","v":427.62500000000006},394.62500000000006,311.57500000000005]
[31,null,601.70000000000005,536.80000000000007,488.12500000000006,{"$f":"F23*$K$3","v":436.70000000000005},403.15000000000003,318.17500000000001]
[32,null,614.35,548.07500000000005,498.57500000000005,{"$f":"F24*$K$3","v":446.05},411.40000000000003,325.05]
[33,null,627,559.35,509.02500000000003,{"$f":"F25*$K$3","v":455.12500000000006},419.92500000000001,331.375]
[34,null,639.375,570.625,518.92500000000007,{"$f":"F26*$K$3","v":464.47500000000002},428.45000000000005,338.25]
[35,null,652.02500000000009,581.90000000000009,529.375,{"$f":"F27*$K$3","v":473.55},436.97500000000002,345.125]
[36,null,669.07500000000005,597.02500000000009,543.125,{"$f":"F28*$K$3","v":485.65000000000003},448.25000000000006,353.92500000000001]
[37,null,685.85,612.15000000000009,556.6,{"$f":"F29*$K$3","v":498.02500000000003},459.8,362.72500000000002]
[38,null,703.17500000000007,627.27500000000009,570.35,{"$f":"F30*$K$3","v":510.40000000000003},470.8,371.8]
[39,null,{"$f":"C31*$K$3","v":719.95},642.67500000000007,584.1,{"$f":"F31*$K$3","v":522.5},482.35,380.6]
[40,null,736.72500000000002,657.52500000000009,598.125,{"$f":"F32*$K$3","v":534.6},493.62500000000006,389.40000000000003]
[41,null,760.37500000000011,678.7,617.1,{"$f":"F33*$K$3","v":551.92500000000007},509.57500000000005,402.05]
[42,null,784.30000000000007,699.875,636.35,{"$f":"F34*$K$3","v":569.25},525.25,414.70000000000005]
[43,null,807.95,721.05000000000007,655.6,{"$f":"F35*$K$3","v":586.30000000000007},541.20000000000005,427.07500000000005]
[44,null,831.6,741.95,674.85,{"$f":"F36*$K$3","v":603.625},557.15000000000009,439.72500000000002]
[45,null,855.25000000000011,763.40000000000009,694.1,{"$f":"F37*$K$3","v":620.95000000000005},573.1,452.37500000000006]
[46,null,871.47500000000002,777.97500000000002,707.30000000000007,{"$f":"F38*$K$3","v":632.77500000000009},583.82500000000005,460.90000000000003]
[47,null,887.97500000000002,792.55000000000007,720.77500000000009,{"$f":"F39*$K$3","v":644.6},594.82500000000005,469.42500000000001]
[48,null,904.47500000000002,807.12500000000011,733.97500000000002,{"$f":"F40*$K$3","v":656.42500000000007},606.1,478.22500000000002]
[49,null,920.7,821.7,747.17500000000007,{"$f":"F41*$K$3","v":668.25},616.82500000000005,486.75000000000006]
[50,null,937.2,836.27500000000009,760.37500000000011,{"$f":"F42*$K$3","v":680.35},627.82500000000005,495.27500000000003]
[51,null,971.30000000000007,866.80000000000007,788.15000000000009,{"$f":"F43*$K$3","v":705.1},650.65000000000009,513.70000000000005]
[52,null,1005.4000000000001,897.32500000000005,815.92500000000007,{"$f":"F44*$K$3","v":729.85},673.75,531.57500000000005]
[53,null,1039.7750000000001,927.85,843.7,{"$f":"F45*$K$3","v":754.87500000000011},696.57500000000005,549.72500000000002]
[54,null,1073.875,958.65000000000009,871.47500000000002,{"$f":"F46*$K$3","v":779.62500000000011},719.67500000000007,567.875]
[55,null,1108.25,989.17500000000007,899.25000000000011,{"$f":"F47*$K$3","v":804.37500000000011},742.50000000000011,586.02500000000009]
[56,null,1120.3500000000001,999.90000000000009,909.15000000000009,{"$f":"F48*$K$3","v":813.45},750.75000000000011,592.35]
[57,null,1132.7250000000001,1010.9000000000001,919.05000000000007,{"$f":"F49*$K$3","v":822.25000000000011},758.72500000000002,598.95000000000005]
[58,null,1144.825,1021.9000000000001,929.22500000000002,{"$f":"F50*$K$3","v":831.05000000000007},766.97500000000002,605.27500000000009]
[59,null,{"$f":"C51*$K$3","v":1157.2},1032.625,938.85,{"$f":"F51*$K$3","v":840.12500000000011},775.22500000000002,611.875]
[60,null,1169.0250000000001,1043.625,948.75000000000011,{"$f":"F52*$K$3","v":848.92500000000007},783.47500000000002,618.47500000000002]
[61,null,1317.25,1175.625,1068.9250000000002,{"$f":"F53*$K$3","v":956.17500000000007},882.47500000000002,696.30000000000007]
[62,null,1464.9250000000002,1307.625,1188.825,{"$f":"F54*$K$3","v":1063.4250000000002},981.47500000000002,774.67500000000007]
[63,null,1613.15,1439.6250000000002,1309,{"$f":"F55*$K$3","v":1170.95},1080.75,852.77500000000009]
[64,null,1761.3750000000002,1571.9,1429.1750000000002,{"$f":"F56*$K$3","v":1278.75},1180.0250000000001,931.15000000000009]
[65,null,1768.2500000000002,1578.2250000000001,1434.95,{"$f":"F57*$K$3","v":1283.7},1184.7,935.00000000000011]
[66,null,1775.6750000000002,1584.5500000000002,1441.0000000000002,{"$f":"F58*$K$3","v":1289.2},1189.375,938.85]
[67,null,1973.9500000000003,1761.65,1601.8750000000002,{"$f":"F59*$K$3","v":1432.7500000000002},1322.2,1043.625]
[68,null,2173.0500000000002,1939.3000000000002,1763.3000000000002,{"$f":"F60*$K$3","v":1577.4},1455.8500000000001,1148.95]
[69,null,2272.6000000000004,2028.1250000000002,1844.15,{"$f":"F61*$K$3","v":1649.7250000000001},1522.4,1201.2]
[70,null,2288.5500000000002,2042.4250000000002,1857.075,{"$f":"F62*$K$3","v":1661.2750000000001},1533.1250000000002,1209.7250000000001]
[71,null,2576.75,2299.5500000000002,2091.1000000000004,{"$f":"F63*$K$3","v":1870.5500000000002},1726.1750000000002,1362.3500000000001]
[72,null,2864.1250000000005,2556.125,2324.5750000000003,{"$f":"F64*$K$3","v":2079},1918.95,1514.4250000000002]
[73,null,3152.3250000000003,2813.25,2557.7750000000001,{"$f":"F65*$K$3","v":2288.2750000000001},2111.7250000000004,1666.5000000000002]
[74,null,3440.2500000000005,3070.65,2791.8,{"$f":"F66*$K$3","v":2497.5500000000002},2304.7750000000001,1818.8500000000001]
[75,null,3758.9750000000004,3354.7250000000004,3050.3,{"$f":"F67*$K$3","v":2728.55},2518.4500000000003,1987.15]
[76,null,3758.9750000000004,3354.7250000000004,3050.3,{"$f":"F68*$K$3","v":2728.55},2518.4500000000003,1987.15]
[77,null,3758.9750000000004,3354.7250000000004,3050.3,{"$f":"F69*$K$3","v":2728.55},2518.4500000000003,1987.15]
[78,null,3758.9750000000004,3354.7250000000004,3050.3,{"$f":"F70*$K$3","v":2728.55},2518.4500000000003,1987.15]
[79,null,{"$f":"C71*$K$3","v":3758.9750000000004},3354.7250000000004,3050.3,{"$f":"F71*$K$3","v":2728.55},2518.4500000000003,1987.15]
[80,null,3758.9750000000004,3354.7250000000004,3050.3,{"$f":"F72*$K$3","v":2728.55},2518.4500000000003,1987.15]
[81,null,3758.9750000000004,3354.7250000000004,3050.3,{"$f":"F73*$K$3","v":2728.55},2518.4500000000003,1987.15]
[82,null,3758.9750000000004,3354.7250000000004,3050.3,{"$f":"F74*$K$3","v":2728.55},2518.4500000000003,1987.15]
[83,null,3758.9750000000004,3354.7250000000004,3050.3,{"$f":"F75*$K$3","v":2728.55},2518.4500000000003,1987.15]
[84,"o más",3758.9750000000004,3354.7250000000004,3050.3,{"$f":"F76*$K$3","v":2728.55},2518.4500000000003,1987.15]
[1,"Hijo",212.3,189.75000000000003,172.42500000000001,{"$f":"F77*$K$3","v":154.27500000000001},142.17500000000001,112.2]
[2,"Hijos",347.875,310.47500000000002,282.15000000000003,{"$f":"F78*$K$3","v":252.45000000000002},233.20000000000002,183.97500000000002]
[3,"Hijos o más",508.20000000000005,453.75000000000006,412.50000000000006,{"$f":"F79*$K$3","v":369.05},340.45000000000005,268.67500000000001]