{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Simulacion","par","fallecimiento+total","invalidez_total","invalidez_absoluta","fall_accidente"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":41,"comments":3,"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":"Simulacion","index":0,"n_rows":188,"n_cols":15,"rows_kept":188,"cut":false,"hidden":false,"merged":[[59,2,59,9],[34,2,34,6],[39,2,39,6],[44,2,44,6],[49,2,49,6],[1,2,1,10],[28,6,28,10],[54,2,54,9],[26,7,26,9],[17,2,17,9],[18,2,18,9],[20,2,21,9],[6,4,6,9],[24,2,24,8]]}
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"- Proyecto realizado para\"","v":"- Proyecto realizado para"},":"]
[null,null,{"$f":"\"- Fecha de nacimiento del Titular\"","v":"- Fecha de nacimiento del Titular"},":"]
[]
[]
[null,null,{"$f":"\"- Fecha de Efecto\"","v":"- Fecha de Efecto"},":"]
[null,null,{"$f":"\"- Capital a Asegurar\"","v":"- Capital a Asegurar"},":"]
[null,null,{"$f":"\"- Recargo por sobreprima cobertura fallecimiento\"","v":"- Recargo por sobreprima cobertura fallecimiento"},":",0]
[null,null,{"$f":"\"- Recargo por sobreprima cobertura invalidez\"","v":"- Recargo por sobreprima cobertura invalidez"},":",0]
[]
[null,null,"3. Coberturas del seguro"]
[null,null,"- Prestación principal: fallecimiento por cualquier causa"]
[null,null,"- Prestaciones complementarias opcionales: invalidez permanente total o absoluta, y fallecimiento por accidente y por accidente de circulación (doble / triple capital)"]
[null,null,"- Incorpora una Prestación de supervivencia y fidelidad que se abona cada tres periodos de vigencia sucesivos, cuando el asegurado haya renovado la póliza sin causar otra prestación:"]
[null,null,"    * primer abono: 1% de la prima comercial que se abona al final del periodo de vigencia de la segunda renovación"]
[null,null,"    * sucesivos abonos: 0,5% adicional (1,5%, 2,0%, 2,5%, 3,0%, 3,5%, 4,0%, 4,5%, 5,0% máximo) de la prima comercial que se abona al final del periodo de vigencia de cada tres renovaciones"]
[]
[]
[null,null,"4. Periodo de vigencia"]
[null,null,"El Seguro se contrata por un año y se renueva anualmente los días 1 de febrero de cada año"]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"- Edad a fecha simulación\"","v":"- Edad a fecha simulación"},null,{"$f":"IF(Validacion<>TRUE,\"\",Edad_Actuarial)","v":""},"años",null,{"$f":"\"Fecha simulación\"","v":"Fecha simulación"},null,{"$f":"+TODAY()","v":"2021-09-21"}]
[]
[]
[null,null,{"$f":"\"Cobertura: fallecimiento por cualquier causa\"","v":"Cobertura: fallecimiento por cualquier causa"}]
[null,null,{"$f":"\"- Prima primer trimestre\"","v":"- Prima primer trimestre"},null,{"$f":"IF(Validacion<>TRUE,\"\",par!$B$70+par!$B$71)","v":""},null,null,null,{"$f":"\" - Recargos (valoración anual) \"","v":" - Recargos (valoración anual) "},{"$f":"IF(Validacion<>TRUE,\"\",par!$B$71)","v":""}]
[]
[null,null,{"$f":"\"- Prima resto trimestres\"","v":"- Prima resto trimestres"},null,{"$f":"IF(Validacion<>TRUE,\"\",par!$B$65)","v":""}]
[]
[null,null,{"$f":"\"Coberturas: fallecimiento por cualquier causa + invalidez permanente absoluta\"","v":"Coberturas: fallecimiento por cualquier causa + invalidez permanente absoluta"}]
[null,null,{"$f":"\"- Prima primer trimestre\"","v":"- Prima primer trimestre"},null,{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$76+par!$B$77))","v":""},null,null,null,{"$f":"\" - Recargos (valoración anual) \"","v":" - Recargos (valoración anual) "},{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$77))","v":""}]
[]
[null,null,{"$f":"\"- Prima resto trimestres\"","v":"- Prima resto trimestres"},null,{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$76))","v":""}]
[]
[null,null,{"$f":"\"Coberturas: fallecimiento por cualquier causa + invalidez permanente total\"","v":"Coberturas: fallecimiento por cualquier causa + invalidez permanente total"}]
[null,null,{"$f":"\"- Prima primer trimestre\"","v":"- Prima primer trimestre"},null,{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$72+par!$B$73))","v":""},null,null,null,{"$f":"\" - Recargos (valoración anual) \"","v":" - Recargos (valoración anual) "},{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$73))","v":""}]
[]
[null,null,{"$f":"\"- Prima resto trimestres\"","v":"- Prima resto trimestres"},null,{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$72))","v":""}]
[]
[null,null,{"$f":"\"Coberturas: fallecimiento por cualquier causa + fallecimiento por accidente\"","v":"Coberturas: fallecimiento por cualquier causa + fallecimiento por accidente"}]
[null,null,{"$f":"\"- Prima primer trimestre\"","v":"- Prima primer trimestre"},null,{"$f":"IF(Validacion<>TRUE,\"\",par!$B$80+par!$B$81)","v":""},null,null,null,{"$f":"\" - Recargos (valoración anual) \"","v":" - Recargos (valoración anual) "},{"$f":"IF(Validacion<>TRUE,\"\",par!$B$81)","v":""}]
[]
[null,null,{"$f":"\"- Prima resto trimestres\"","v":"- Prima resto trimestres"},null,{"$f":"IF(Validacion<>TRUE,\"\",par!$B$80)","v":""}]
[]
[null,null,{"$f":"\"Coberturas: fallecimiento por cualquier causa + invalidez permanente absoluta + fallecimiento por accidente\"","v":"Coberturas: fallecimiento por cualquier causa + invalidez permanente absoluta + fallecimiento por accidente"}]
[null,null,{"$f":"\"- Prima primer trimestre\"","v":"- Prima primer trimestre"},null,{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$78+par!$B$79))","v":""},null,null,null,{"$f":"\" - Recargos (valoración anual) \"","v":" - Recargos (valoración anual) "},{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$79))","v":""}]
[]
[null,null,{"$f":"\"- Prima resto trimestres\"","v":"- Prima resto trimestres"},null,{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$78))","v":""}]
[]
[null,null,"Coberturas: fallecimiento por cualquier causa + invalidez permanente total + fallecimiento por accidente"]
[null,null,{"$f":"\"- Prima primer trimestre\"","v":"- Prima primer trimestre"},null,{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$74+par!$B$75))","v":""},null,null,null,{"$f":"\" - Recargos (valoración anual) \"","v":" - Recargos (valoración anual) "},{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$75))","v":""}]
[]
[null,null,{"$f":"\"- Prima resto trimestres\"","v":"- Prima resto trimestres"},null,{"$f":"+IF(E14=\"\",\"\",IF(Validacion<>TRUE,\"\",par!$B$74))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"- Edad Actuarial (*)",null,"",null," Fecha Actual ",42327]
[]
["- Edad Actuarial (*)",null,"",null," Fecha Actual ",42327]
[null,null,""]
["- Prima Trimestral Resultante",null,"",null,null," - Recargos (valoración anual) ",""]
[]
[]
[]
[null,null,false,null,null,null,null,null,null,null,null,null,null,"Sexo no se utiliza","HOMBRE"]
["Mostrar Simulación",null,"Prima",null,"Recargos",null,"Edad actuarial"]
["FALSE",null,{"$f":"+IF(ISNUMBER(par!A69),par!A69,\"\")","v":""},null,{"$f":"+IF(ISNUMBER(par!A73+par!A77),par!A73+par!A77,\"\")","v":""},null,{"$f":"+INT(YEARFRAC(F_Efecto,F_Nac_Titular,0))","v":0}]
[]
[null,null,"Prima",null,"Recargos"]
[null,null,{"$f":"+IF(ISNUMBER(par!C69),par!C69,\"\")","v":0},null,{"$f":"+IF(ISNUMBER(par!C73+par!C77),par!C73+par!C77,\"\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($E$12>50000,\"error\",$E$12)","v":0},"Capital a asegurar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N95/1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MUJER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+G98*$N$96","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+G99*$N$96","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+G163*$N$96","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"par","index":1,"n_rows":81,"n_cols":10,"rows_kept":81,"cut":false,"hidden":true,"merged":[]}
[]
["Absoluta"]
["Tasas por 1.000"]
["% hombre",0.5,{"$f":"\" <- Proporcion Qx en fallecimiento y Ix en Invalidez\"","v":" <- Proporcion Qx en fallecimiento y Ix en Invalidez"}]
[]
["ajuste total",1.7,{"$f":"\" <- Recargo sobre las tasas de Invalidez Absoluta para obtener la Tasa de Invalidez Total\"","v":" <- Recargo sobre las tasas de Invalidez Absoluta para obtener la Tasa de Invalidez Total"}]
["minimo IAP",2.0000000000000001E-4]
["minimo ITP",4.4999999999999999E-4]
[]
["edad ajuste",75,{"$f":"\" <- Edad Límite de aseguramiento\"","v":" <- Edad Límite de aseguramiento"}]
[]
["Reduccuon PASEM",1,{"$f":"\" <- Factor Ajuste a la Q (Varon+Mujer) hasta la edad de de Ajuste\"","v":" <- Factor Ajuste a la Q (Varon+Mujer) hasta la edad de de Ajuste"}]
["minimo fall",0]
[]
[]
["% premio supervivencia año",0.01]
[]
[null,null,null,"Gastos Internos",null,"Gastos Externos"]
["Tasa de gastos",0.36,null,0.16,null,0.2]
[]
["capital",100000,{"$f":"\" <- Capital utlizado por el Dto. Actuarial para el analisis y creación de Tarifa. NO se utiliza en la simulación ni para la Nota Informativa\"","v":" <- Capital utlizado por el Dto. Actuarial para el analisis y creación de Tarifa. NO se utiliza en la simulación ni para la Nota Informativa"}]
["Inicio ajuste",100,{"$f":"\" <- Edad hasta la que se aplica el Factor de Ajuste a la tabla de fallecimiento\"","v":" <- Edad hasta la que se aplica el Factor de Ajuste a la tabla de fallecimiento"}]
[]
["interes",0,{"$f":"\" <- Interes Tecnico aplicado\"","v":" <- Interes Tecnico aplicado"}]
[]
[]
[]
[null,"INFORMACION Y CALCULOS SIMULACIONES"]
[]
[null,"Rec. Fracc.",0.01]
[]
[null,"V^0,5",{"$f":"+(1/(1+interes)^(1/2))","v":1}]
[]
[null,"IPS",0.08,"cambiado el 01/01/2021. anteriormente al 6%"]
[]
[null,"Edad",{"$f":"Edad_Actuarial","v":0},null,null,null,{"$f":" \" <- Campo Calculado desde la SIMULACION\"","v":" <- Campo Calculado desde la SIMULACION"}]
[]
[null,"Capital final simulacion",{"$f":"IF(Edad_Actuarial>=70, MIN(120000,Simulacion!E12),Simulacion!E12)","v":0},"(limitado a 120.000 para edad>=70 años)",null,null,{"$f":"\" <- Campo Copiado de la SIMULACION\"","v":" <- Campo Copiado de la SIMULACION"}]
[]
[null,{"$f":"\" · Q a la edad de \" & TEXT(C36,\"##\")","v":" · Q a la edad de "},{"$f":"VLOOKUP($C$36,'fallecimiento+total'!$A$2:$G$59,4)","v":{"$error":"#N/A"}},{"$f":"\" · tpx a la edad de \" & TEXT(C36,\"##\")","v":" · tpx a la edad de "},{"$f":"1-Q_a_Edad","v":{"$error":"#N/A"}},null,{"$f":"\" <- fallecimiento\"","v":" <- fallecimiento"}]
[]
[null,{"$f":"\" · ITP a la edad de \" & TEXT(C36,\"##\")","v":" · ITP a la edad de "},{"$f":"VLOOKUP($C$36,'fallecimiento+total'!$A$2:$G$59,6)","v":{"$error":"#N/A"}},null,null,null,{"$f":"\" <- invalidez total y permanente\"","v":" <- invalidez total y permanente"}]
[]
[null,{"$f":"\" · IAP a la edad de \" & TEXT(C36,\"##\")","v":" · IAP a la edad de "},{"$f":"VLOOKUP($C$36,'fallecimiento+total'!$A$2:$G$59,5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"\" <- invalidez absoluta y permanente\"","v":" <- invalidez absoluta y permanente"}]
[]
[null,{"$f":"\" · Q a la edad de \" & TEXT(C36,\"##\")","v":" · Q a la edad de "},{"$f":"VLOOKUP($C$36,'fallecimiento+total'!$A$2:$G$59,7)","v":{"$error":"#N/A"}},null,null,null,{"$f":"\" <- fallecimiento por accidente\"","v":" <- fallecimiento por accidente"}]
[]
[null,"Fallecimiento Anual",{"$f":"ROUND((Q_a_Edad*V_Exp_0_5_c)/(1-GastosN)*Capital_final,2)*(1+Simulacion!$E$13)","v":{"$error":"#N/A"}},"sin ajuste edad ",null,null,{"$f":"\" <- Recordar. Importe sin recargo por fraccionamiento\"","v":" <- Recordar. Importe sin recargo por fraccionamiento"}]
[]
[null,"Invalidez Total Anual",{"$f":"ROUND((I_a_Edad*V_Exp_0_5_c)/(1-GastosN)*Capital_final,2)*(1+Simulacion!$E$14)","v":{"$error":"#N/A"}},"sin ajuste edad ",null,null,{"$f":"\" <- Recordar. Importe sin recargo por fraccionamiento\"","v":" <- Recordar. Importe sin recargo por fraccionamiento"}]
[]
[null,"Invalidez Absoluta Anual",{"$f":"ROUND(($C$44*V_Exp_0_5_c)/(1-GastosN)*Capital_final,2)*(1+Simulacion!$E$14)","v":{"$error":"#N/A"}},"sin ajuste edad",null,null,{"$f":"\" <- Recordar. Importe sin recargo por fraccionamiento\"","v":" <- Recordar. Importe sin recargo por fraccionamiento"}]
[]
[null,"Fall. Accidente Anual",{"$f":"ROUND((·_Q_a_la_edad_2*V_Exp_0_5_c)/(1-GastosN)*Capital_final,2)","v":{"$error":"#N/A"}},null,null,null,{"$f":"\" <- Recordar. Importe sin recargo por fraccionamiento\"","v":" <- Recordar. Importe sin recargo por fraccionamiento"}]
[]
[null,"Fallecimiento Trim.",{"$f":"ROUND(((C48)/4)*(1+Rec_Fracc_Trim_c),2)","v":{"$error":"#N/A"}},null,{"$f":"+C56*4*($E$40*premio_supervivencia)","v":{"$error":"#N/A"}},null,{"$f":"\" <- Recordar. Importe con 1% de recargo por fraccionamiento trimestral\"","v":" <- Recordar. Importe con 1% de recargo por fraccionamiento trimestral"}]
[]
[null,"Invalidez ITP Trim.",{"$f":"ROUND(((C50)/4)*(1+Rec_Fracc_Trim_c),2)","v":{"$error":"#N/A"}},null,{"$f":"+C58*4*(E40*premio_supervivencia)","v":{"$error":"#N/A"}},null,{"$f":"\" <- Recordar. Importe con 1% de recargo por fraccionamiento trimestral\"","v":" <- Recordar. Importe con 1% de recargo por fraccionamiento trimestral"}]
[]
[null,"Invalidez IAP Trim.",{"$f":"ROUND(((C52)/4)*(1+Rec_Fracc_Trim_c),2)","v":{"$error":"#N/A"}},null,{"$f":"+C60*4*(E40*premio_supervivencia)","v":{"$error":"#N/A"}},null,{"$f":"\" <- Recordar. Importe con 1% de recargo por fraccionamiento trimestral\"","v":" <- Recordar. Importe con 1% de recargo por fraccionamiento trimestral"}]
[]
[null,"Fall. accidentes Trim.",{"$f":"ROUND(((C54)/4)*(1+Rec_Fracc_Trim_c),2)","v":{"$error":"#N/A"}},null,{"$f":"+C62*4*(E40*premio_supervivencia)","v":{"$error":"#N/A"}},null,{"$f":"\" <- Recordar. Importe con 1% de recargo por fraccionamiento trimestral\"","v":" <- Recordar. Importe con 1% de recargo por fraccionamiento trimestral"}]
[]
[null,"FALL","IAP","ITP","ACC"]
["PRIMA FRACCIONADA",{"$f":"+IFERROR(C56,0)","v":0},{"$f":"+IF(Edad_Actuarial>=70,0,IFERROR(C60,0))","v":0},{"$f":"+IF(Edad_Actuarial>=70,0,IFERROR(C58,0))","v":0},{"$f":"+IFERROR(C62,0)","v":0},null,null,"P = (1-%tpx)* C *qx*(1+i)^-0,5 + %tpx * ( C*qx*(1+i)^-0,5)"]
["RECARGOS IMPUESTO/S PRIMA",null,{"$f":"+ROUND(C65*0.08,2)","v":0},{"$f":"+ROUND(D65*0.08,2)","v":0},{"$f":"+ROUND(E65*0.08,2)","v":0}]
["RECARGOS LEA",null,{"$f":"+C65*0.15/100","v":0},{"$f":"+D65*0.15/100","v":0},0]
["RECARGOS CONSORCIO",null,{"$f":"+ROUND((IF(C65=0,0,Capital_Simulacion*0.003/1000)),2)+IF(AND(C65=0,Edad_Actuarial>=70),ROUND(Capital_final*0.003/1000,2),0)","v":0},{"$f":"+ROUND((IF(D65=0,0,Capital_Simulacion*0.003/1000)),2)+IF(AND(D65=0,Edad_Actuarial>=70),ROUND(Capital_final*0.003/1000,2),0)","v":0},{"$f":"+ROUND(IF(E65=0,0,Capital_Simulacion*2*0.003/1000),2)","v":0},null,null,"% Rec. LEA"]
["TOTAL (prima + ips)",{"$f":"+B66+B65","v":0},{"$f":"+C66+C65","v":0},0,0,null,null,1.5E-3]
["TOTAL FALL ",{"$f":"+B69","v":0},null,null,null,null,null,"% Rec. CRE",null,"Mín. Valor CRE"]
["RECARGO (VALORACION ANUAL)",{"$f":"+IF(B70=0,\"\",MAX(0.01,ROUND(Capital_final*0.003/1000,2))+B67*4)","v":""},null,null,null,null,null,3.0000000000000001E-6,null,0.01]
["TOTAL FALL + ITP",{"$f":"IF(Edad_Actuarial>=70,0,+B69+D69)","v":0}]
["RECARGO (VALORACION ANUAL)",{"$f":"+IF(Edad_Actuarial>=70,0,IF(B72=0,0,MAX(0.01,D68)+D67*4))","v":0}]
["TOTAL FALL + ITP+ACC",{"$f":"IF(Edad_Actuarial>=70,0,+B69+D69+E69+F69)","v":0}]
["RECARGO (VALORACION ANUAL)",{"$f":"+IF(Edad_Actuarial>=70,0,IF(B74=0,0,MAX(0.03,(D68+E68+F68))+(+E67+F67+D67)*4))","v":0}]
["TOTAL FALL + IAP",{"$f":"IF(Edad_Actuarial>=70,0,+B69+C69)","v":0}]
["RECARGO (VALORACION ANUAL)",{"$f":"IF(Edad_Actuarial>=70,0,+IF(B76=0,0,MAX(0.01,C68)+C67*4))","v":0}]
["TOTAL FALL + IAP+ACC",{"$f":"IF(Edad_Actuarial>=70,0,+B69+C69+E69+F69)","v":0}]
["RECARGO (VALORACION ANUAL)",{"$f":"IF(Edad_Actuarial>=70,0,+IF(B78=0,0,MAX(0.03,(C68+E68+F68))+(+E67+F67+C67)*4))","v":0}]
["TOTAL FALL+ACC",{"$f":"+B69+E69+F69","v":0}]
["RECARGO (VALORACION ANUAL)",{"$f":"+IF(B80=0,0,MAX(0.03,ROUND(Capital_final*0.003/1000,2))+E68+F68)+(+E67+F67)*4","v":0}]

{"sheet":"fallecimiento+total","index":2,"n_rows":124,"n_cols":27,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
["EDAD","fall pasem2019 no relacionada individual  1  ord  m","fall pasem2019 no relacionada individual  1  ord  y","Tasa Fallecimiento PASEM\n ajustada con la Correccion por Edad","Invalidez Absoluta Permanente\n ajustada con la Correccion por Edad","Invalidez Total Permanente\n ajustada con la Correccion por Edad","Tasa fallecimiento por accidente + tasa fallecimiento por accidente de circulacion","tpx fallecimiento PASEM","V^0,5","V^0,5      fraccionaria","ANUAL FALL","ANUAL IAP","ANUAL ITP","ANUAL FALL ACC","FRACCIONARIA TRIM. FALL.","FRACCIONARIA TRIM. IAP","FRACCIONARIA TRIM. ITP","FRACCIONARIA TRIM. ACC","Prima Trim.\nFallec.","Prima Trim.\nIAP","Prima Trim.\nITP","Prima Trim.\nACC","Prima Trim.\nFall+IAP","Prima Trim.\nFall+ITP","Prima Trim.\nFall+ACC\n","Prima Trim.\nFall+IAP+ACC\n","Prima Trim.\nFall+ITP+ACC\n"]
[18,2.5961780261990263E-4,1.1364121399635588E-4,{"$f":"+MAX(min_fall,(+B2*hombre+C2*(1-hombre)))","v":1.8662950830812926E-4},{"$f":"+VLOOKUP(A2,invalidez_absoluta!A2:E54,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A2,invalidez_total!A2:E54,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A2,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},{"$f":"1-D2","v":0.99981337049169183},{"$f":"+(1/(1+interes)^(1/2))","v":1},{"$f":"+(1/(1+interes)^(1/(2*4)))","v":1},{"$f":"ROUND((+$D2*$I2)/(1-GastosN)*capital,2)","v":29.16},{"$f":"ROUND((+$E2*$I2)/(1-GastosN)*capital,2)","v":31.25},{"$f":"ROUND((+$F2*$I2)/(1-GastosN)*capital,2)","v":70.31},{"$f":"ROUND((+$G2*$I2)/(1-GastosN)*capital,2)","v":105.47},{"$f":"ROUND((1+0.02)*(+($D2/4)*$J2)/(1-GastosN)*capital,2)","v":7.44},{"$f":"ROUND((1+0.02)*(+($E2/4)*$J2)/(1-GastosN)*capital,2)","v":7.97},{"$f":"ROUND((1+0.02)*(+($F2/4)*$J2)/(1-GastosN)*capital,2)","v":17.93},{"$f":"ROUND((1+0.02)*(+($G2/4)*$J2)/(1-GastosN)*capital,2)","v":26.89},{"$f":"ROUND(((K2)/4)*1.01,2)","v":7.36},{"$f":"ROUND(((L2)/4)*1.01,2)","v":7.89},{"$f":"ROUND(((M2)/4)*1.01,2)","v":17.75},{"$f":"ROUND(((N2)/4)*1.01,2)","v":26.63},{"$f":"+S2+T2","v":15.25},{"$f":"ROUND(S2+U2,2)","v":25.11},{"$f":"+S2+V2","v":33.99},{"$f":"+S2+T2+V2","v":41.879999999999995},{"$f":"+S2+U2+V2","v":51.739999999999995}]
[19,2.6491973585609526E-4,1.1036493254947701E-4,1.8764233420278612E-4,{"$f":"+VLOOKUP(A3,invalidez_absoluta!A3:E55,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A3,invalidez_total!A3:E55,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A3,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},{"$f":"1-D3","v":0.99981235766579724},1,1,{"$f":"ROUND((+$D3*$I3)/(1-GastosN)*capital,2)","v":29.32},31.25,70.31,105.47,7.48,7.97,17.93,26.89,{"$f":"ROUND(((K3)/4)*1.01,2)","v":7.4},{"$f":"ROUND(((L3)/4)*1.01,2)","v":7.89},{"$f":"ROUND(((M3)/4)*1.01,2)","v":17.75},{"$f":"ROUND(((N3)/4)*1.01,2)","v":26.63},{"$f":"+S3+T3","v":15.29},{"$f":"ROUND(S3+U3,2)","v":25.15},{"$f":"+S3+V3","v":34.03},{"$f":"+S3+T3+V3","v":41.92},{"$f":"+S3+U3+V3","v":51.78}]
[20,2.7145176510918177E-4,1.0908295904422492E-4,1.9026736207670335E-4,{"$f":"+VLOOKUP(A4,invalidez_absoluta!A4:E56,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A4,invalidez_total!A4:E56,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A4,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99980973263792328,1,1,29.73,31.25,70.31,105.47,7.58,7.97,17.93,26.89,7.51,7.89,17.75,26.63,15.399999999999999,25.26,34.14,42.03,51.89]
[21,2.7841346832149306E-4,1.0911586532450584E-4,1.9376466682299946E-4,{"$f":"+VLOOKUP(A5,invalidez_absoluta!A5:E57,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A5,invalidez_total!A5:E57,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A5,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99980623533317703,1,1,30.28,31.25,70.31,105.47,7.72,7.97,17.93,26.89,7.65,7.89,17.75,26.63,15.54,25.4,34.28,42.17,52.03]
[22,2.8651023873067419E-4,1.1038695485392943E-4,1.9844859679230182E-4,{"$f":"+VLOOKUP(A6,invalidez_absoluta!A6:E58,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A6,invalidez_total!A6:E58,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A6,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.9998015514032077,1,1,31.01,31.25,70.31,105.47,7.91,7.97,17.93,26.89,7.83,7.89,17.75,26.63,15.719999999999999,25.58,34.46,42.349999999999994,52.209999999999994]
[23,2.938861846499591E-4,1.1189579855401537E-4,2.0289099160198724E-4,{"$f":"+VLOOKUP(A7,invalidez_absoluta!A7:E59,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A7,invalidez_total!A7:E59,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A7,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99979710900839802,1,1,31.7,31.25,70.31,105.47,8.08,7.97,17.93,26.89,8,7.89,17.75,26.63,15.89,25.75,34.629999999999995,42.519999999999996,52.379999999999995]
[24,3.005620622963381E-4,1.1348882981953143E-4,2.0702544605793476E-4,{"$f":"+VLOOKUP(A8,invalidez_absoluta!A8:E60,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A8,invalidez_total!A8:E60,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A8,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99979297455394212,1,1,32.35,31.25,70.31,105.47,8.25,7.97,17.93,26.89,8.17,7.89,17.75,26.63,16.059999999999999,25.92,34.799999999999997,42.69,52.55]
[25,3.0551705904306747E-4,1.147624188573823E-4,2.1013973895022488E-4,{"$f":"+VLOOKUP(A9,invalidez_absoluta!A9:E61,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A9,invalidez_total!A9:E61,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A9,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99978986026104977,1,1,32.83,31.25,70.31,105.47,8.3699999999999992,7.97,17.93,26.89,8.2899999999999991,7.89,17.75,26.63,16.18,26.04,34.92,42.81,52.67]
[26,3.0689896345341677E-4,1.1514848580763704E-4,2.110237246305269E-4,{"$f":"+VLOOKUP(A10,invalidez_absoluta!A10:E62,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A10,invalidez_total!A10:E62,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A10,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99978897627536945,1,1,32.97,31.25,70.31,105.47,8.41,7.97,17.93,26.89,8.32,7.89,17.75,26.63,16.21,26.07,34.950000000000003,42.84,52.7]
[27,3.0492299449487876E-4,1.1496089851106714E-4,2.0994194650297295E-4,{"$f":"+VLOOKUP(A11,invalidez_absoluta!A11:E63,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A11,invalidez_total!A11:E63,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A11,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99979005805349708,1,1,32.799999999999997,31.25,70.31,105.47,8.36,7.97,17.93,26.89,8.2799999999999994,7.89,17.75,26.63,16.169999999999998,26.03,34.909999999999997,42.8,52.66]
[28,2.9983882381978634E-4,1.1450972115347519E-4,2.0717427248663077E-4,{"$f":"+VLOOKUP(A12,invalidez_absoluta!A12:E64,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A12,invalidez_total!A12:E64,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A12,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99979282572751338,1,1,32.369999999999997,31.25,70.31,105.47,8.25,7.97,17.93,26.89,8.17,7.89,17.75,26.63,16.059999999999999,25.92,34.799999999999997,42.69,52.55]
[29,2.9233138541229556E-4,1.141642442061136E-4,2.0324781480920458E-4,{"$f":"+VLOOKUP(A13,invalidez_absoluta!A13:E65,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A13,invalidez_total!A13:E65,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A13,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99979675218519082,1,1,31.76,31.25,70.31,105.47,8.1,7.97,17.93,26.89,8.02,7.89,17.75,26.63,15.91,25.77,34.65,42.54,52.4]
[30,2.8607571880324322E-4,1.1536011147274355E-4,2.0071791513799338E-4,{"$f":"+VLOOKUP(A14,invalidez_absoluta!A14:E66,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A14,invalidez_total!A14:E66,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A14,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99979928208486202,1,1,31.36,31.25,70.31,105.47,8,7.97,17.93,26.89,7.92,7.89,17.75,26.63,15.809999999999999,25.67,34.549999999999997,42.44,52.3]
[31,2.8177303378828708E-4,1.1838394244429328E-4,2.0007848811629019E-4,{"$f":"+VLOOKUP(A15,invalidez_absoluta!A15:E67,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A15,invalidez_total!A15:E67,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A15,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99979992151188368,1,1,31.26,31.25,70.31,105.47,7.97,7.97,17.93,26.89,7.89,7.89,17.75,26.63,15.78,25.64,34.519999999999996,42.41,52.269999999999996]
[32,2.8168895209615587E-4,1.2419576398881341E-4,2.0294235804248464E-4,{"$f":"+VLOOKUP(A16,invalidez_absoluta!A16:E68,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A16,invalidez_total!A16:E68,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A16,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99979705764195748,1,1,31.71,31.25,70.31,105.47,8.09,7.97,17.93,26.89,8.01,7.89,17.75,26.63,15.899999999999999,25.76,34.64,42.53,52.39]
[33,2.8849191771294089E-4,1.3409642227271175E-4,2.1129416999282632E-4,{"$f":"+VLOOKUP(A17,invalidez_absoluta!A17:E69,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A17,invalidez_total!A17:E69,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A17,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99978870583000712,1,1,33.01,31.25,70.31,105.47,8.42,7.97,17.93,26.89,8.34,7.89,17.75,26.63,16.23,26.09,34.97,42.86,52.72]
[34,3.0446747891460215E-4,1.4945682209692581E-4,2.2696215050576398E-4,{"$f":"+VLOOKUP(A18,invalidez_absoluta!A18:E70,5,FALSE)","v":2.0000000000000001E-4},{"$f":"+VLOOKUP(A18,invalidez_total!A18:E70,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A18,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99977303784949423,1,1,35.46,31.25,70.31,105.47,9.0399999999999991,7.97,17.93,26.89,8.9499999999999993,7.89,17.75,26.63,16.84,26.7,35.58,43.47,53.33]
[35,3.300592467679482E-4,1.7089349189983473E-4,2.5047636933389145E-4,{"$f":"+VLOOKUP(A19,invalidez_absoluta!A19:E71,5,FALSE)","v":2.0968068424990591E-4},{"$f":"+VLOOKUP(A19,invalidez_total!A19:E71,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A19,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99974952363066616,1,1,39.14,32.76,70.31,105.47,9.98,8.35,17.93,26.89,9.8800000000000008,8.27,17.75,26.63,18.149999999999999,27.63,36.51,44.78,54.260000000000005]
[36,3.6166605077502868E-4,1.9674516749849331E-4,2.7920560913676098E-4,{"$f":"+VLOOKUP(A20,invalidez_absoluta!A20:E72,5,FALSE)","v":2.2970152570559479E-4},{"$f":"+VLOOKUP(A20,invalidez_total!A20:E72,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A20,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99972079439086325,1,1,43.63,35.89,70.31,105.47,11.12,9.15,17.93,26.89,11.02,9.06,17.75,26.63,20.079999999999998,28.77,37.65,46.709999999999994,55.4]
[37,3.9718807828195224E-4,2.2563260652039651E-4,3.1141034240117439E-4,{"$f":"+VLOOKUP(A21,invalidez_absoluta!A21:E73,5,FALSE)","v":2.5087786442741885E-4},{"$f":"+VLOOKUP(A21,invalidez_total!A21:E73,5,FALSE)","v":4.4999999999999999E-4},{"$f":"+VLOOKUP(A21,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99968858965759888,1,1,48.66,39.200000000000003,70.31,105.47,12.41,10,17.93,26.89,12.29,9.9,17.75,26.63,22.189999999999998,30.04,38.92,48.819999999999993,56.67]
[38,4.3454784297474158E-4,2.557960402543106E-4,3.4517194161452606E-4,{"$f":"+VLOOKUP(A22,invalidez_absoluta!A22:E74,5,FALSE)","v":2.7459909088973898E-4},{"$f":"+VLOOKUP(A22,invalidez_total!A22:E74,5,FALSE)","v":4.6681845451255626E-4},{"$f":"+VLOOKUP(A22,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99965482805838546,1,1,53.93,42.91,72.94,105.47,13.75,10.94,18.600000000000001,26.89,13.62,10.83,18.420000000000002,26.63,24.45,32.04,40.25,51.08,58.67]
[39,4.7384086787373729E-4,2.8647526785829816E-4,3.8015806786601773E-4,{"$f":"+VLOOKUP(A23,invalidez_absoluta!A23:E75,5,FALSE)","v":3.0045709719746743E-4},{"$f":"+VLOOKUP(A23,invalidez_total!A23:E75,5,FALSE)","v":5.1077706523569458E-4},{"$f":"+VLOOKUP(A23,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99961984193213393,1,1,59.4,46.95,79.81,105.47,15.15,11.97,20.350000000000001,26.89,15,11.85,20.149999999999999,26.63,26.85,35.15,41.629999999999995,53.480000000000004,61.78]
[40,5.1767821731970242E-4,3.1838253958438339E-4,4.1803037845204293E-4,{"$f":"+VLOOKUP(A24,invalidez_absoluta!A24:E76,5,FALSE)","v":3.2862780246913586E-4},{"$f":"+VLOOKUP(A24,invalidez_total!A24:E76,5,FALSE)","v":5.5866726419753093E-4},{"$f":"+VLOOKUP(A24,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99958196962154799,1,1,65.319999999999993,51.35,87.29,105.47,16.66,13.09,22.26,26.89,16.489999999999998,12.97,22.04,26.63,29.46,38.53,43.12,56.09,65.16]
[41,5.6853253592738359E-4,3.5219132867829673E-4,4.6036193230284013E-4,{"$f":"+VLOOKUP(A25,invalidez_absoluta!A25:E77,5,FALSE)","v":3.5983040944295768E-4},{"$f":"+VLOOKUP(A25,invalidez_total!A25:E77,5,FALSE)","v":6.1171169605302807E-4},{"$f":"+VLOOKUP(A25,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99953963806769719,1,1,71.930000000000007,56.22,95.58,105.47,18.34,14.34,24.37,26.89,18.16,14.2,24.13,26.63,32.36,42.29,44.79,58.989999999999995,68.92]
[42,6.5847089735040555E-4,4.0692002858418511E-4,5.3269546296729527E-4,{"$f":"+VLOOKUP(A26,invalidez_absoluta!A26:E78,5,FALSE)","v":3.9336951204728318E-4},{"$f":"+VLOOKUP(A26,invalidez_total!A26:E78,5,FALSE)","v":6.6872817048038138E-4},{"$f":"+VLOOKUP(A26,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.9994673045370327,1,1,83.23,61.46,104.49,105.47,21.22,15.67,26.64,26.89,21.02,15.52,26.38,26.63,36.54,47.4,47.65,63.17,74.03]
[43,7.7350075234113524E-4,4.7279843066383681E-4,6.2314959150248602E-4,{"$f":"+VLOOKUP(A27,invalidez_absoluta!A27:E79,5,FALSE)","v":4.3074706045455633E-4},{"$f":"+VLOOKUP(A27,invalidez_total!A27:E79,5,FALSE)","v":7.3227000277274572E-4},{"$f":"+VLOOKUP(A27,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99937685040849755,1,1,97.37,67.3,114.42,105.47,24.83,17.16,29.18,26.89,24.59,16.989999999999998,28.89,26.63,41.58,53.48,51.22,68.209999999999994,80.11]
[44,9.1264351633170567E-4,5.4810892364469898E-4,7.3037621998820238E-4,{"$f":"+VLOOKUP(A28,invalidez_absoluta!A28:E80,5,FALSE)","v":4.7124531712655946E-4},{"$f":"+VLOOKUP(A28,invalidez_total!A28:E80,5,FALSE)","v":8.0111703911515107E-4},{"$f":"+VLOOKUP(A28,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99926962378001183,1,1,114.12,73.63,125.17,105.47,29.1,18.78,31.92,26.89,28.82,18.59,31.61,26.63,47.41,60.43,55.45,74.039999999999992,87.06]
[45,1.0744924223186438E-3,6.3135978099505548E-4,8.5292610165684966E-4,{"$f":"+VLOOKUP(A29,invalidez_absoluta!A29:E81,5,FALSE)","v":5.1575792199119448E-4},{"$f":"+VLOOKUP(A29,invalidez_total!A29:E81,5,FALSE)","v":8.7678846738503062E-4},{"$f":"+VLOOKUP(A29,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99914707389834312,1,1,133.27000000000001,80.59,137,105.47,33.979999999999997,20.55,34.93,26.89,33.65,20.350000000000001,34.590000000000003,26.63,54,68.239999999999995,60.28,80.63,94.87]
[46,1.2618328272402783E-3,7.2421707441476686E-4,9.9302495082752252E-4,{"$f":"+VLOOKUP(A30,invalidez_absoluta!A30:E82,5,FALSE)","v":5.6434687806645502E-4},{"$f":"+VLOOKUP(A30,invalidez_total!A30:E82,5,FALSE)","v":9.5938969271297352E-4},{"$f":"+VLOOKUP(A30,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99900697504917246,1,1,155.16,88.18,149.9,105.47,39.57,22.49,38.229999999999997,26.89,39.18,22.27,37.85,26.63,61.45,77.03,65.81,88.08,103.66]
[47,1.4811488318983103E-3,8.3087965952001333E-4,1.1560142457091617E-3,{"$f":"+VLOOKUP(A31,invalidez_absoluta!A31:E83,5,FALSE)","v":6.1757571321491365E-4},{"$f":"+VLOOKUP(A31,invalidez_total!A31:E83,5,FALSE)","v":1.0498787124653532E-3},{"$f":"+VLOOKUP(A31,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99884398575429079,1,1,180.63,96.5,164.04,105.47,46.06,24.61,41.83,26.89,45.61,24.37,41.42,26.63,69.98,87.03,72.239999999999995,96.61,113.66]
[48,1.7276718417995221E-3,9.4943124311441796E-4,1.3385515424569701E-3,{"$f":"+VLOOKUP(A32,invalidez_absoluta!A32:E84,5,FALSE)","v":6.7571889046426413E-4},{"$f":"+VLOOKUP(A32,invalidez_total!A32:E84,5,FALSE)","v":1.1487221137892491E-3},{"$f":"+VLOOKUP(A32,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99866144845754301,1,1,209.15,105.58,179.49,105.47,53.33,26.92,45.77,26.89,52.81,26.66,45.32,26.63,79.47,98.13,79.44,106.1,124.75999999999999]
[49,2.005349930868192E-3,1.0828353021237243E-3,1.5440926164959582E-3,{"$f":"+VLOOKUP(A33,invalidez_absoluta!A33:E85,5,FALSE)","v":7.3977306490289468E-4},{"$f":"+VLOOKUP(A33,invalidez_total!A33:E85,5,FALSE)","v":1.2576142103349209E-3},{"$f":"+VLOOKUP(A33,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99845590738350409,1,1,241.26,115.59,196.5,105.47,61.52,29.48,50.11,26.89,60.92,29.19,49.62,26.63,90.11,110.54,87.55,116.74,137.16999999999999]
[50,2.3105604605004743E-3,1.2293003138792939E-3,{"$f":"+MAX(min_fall,(+B34*hombre+C34*(1-hombre)))","v":1.7699303871898842E-3},{"$f":"+VLOOKUP(A34,invalidez_absoluta!A34:E86,5,FALSE)","v":8.0944929909465037E-4},{"$f":"+VLOOKUP(A34,invalidez_total!A34:E86,5,FALSE)","v":1.3760638084609055E-3},{"$f":"+VLOOKUP(A34,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99823006961281013,{"$f":"+(1/(1+interes)^(1/2))","v":1},{"$f":"+(1/(1+interes)^(1/(2*4)))","v":1},{"$f":"ROUND((+$D34*$I34)/(1-GastosN)*capital,2)","v":276.55},{"$f":"ROUND((+$E34*$I34)/(1-GastosN)*capital,2)","v":126.48},{"$f":"ROUND((+$F34*$I34)/(1-GastosN)*capital,2)","v":215.01},{"$f":"ROUND((+$G34*$I34)/(1-GastosN)*capital,2)","v":105.47},{"$f":"ROUND((1+0.02)*(+($D34/4)*$J34)/(1-GastosN)*capital,2)","v":70.52},{"$f":"ROUND((1+0.02)*(+($E34/4)*$J34)/(1-GastosN)*capital,2)","v":32.25},{"$f":"ROUND((1+0.02)*(+($F34/4)*$J34)/(1-GastosN)*capital,2)","v":54.83},{"$f":"ROUND((1+0.02)*(+($G34/4)*$J34)/(1-GastosN)*capital,2)","v":26.89},69.83,31.94,54.29,26.63,101.77,124.12,96.46,128.4,150.75]
[51,2.5590228857281781E-3,1.3437723291799459E-3,1.951397607454062E-3,{"$f":"+VLOOKUP(A35,invalidez_absoluta!A35:E87,5,FALSE)","v":8.8543122183485572E-4},{"$f":"+VLOOKUP(A35,invalidez_total!A35:E87,5,FALSE)","v":1.5052330771192547E-3},{"$f":"+VLOOKUP(A35,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99804860239254589,1,1,304.91000000000003,138.35,235.19,105.47,77.75,35.28,59.97,26.89,76.989999999999995,34.93,59.39,26.63,111.91999999999999,136.38,103.61999999999999,138.54999999999998,163.01]
[52,2.8231961572382572E-3,1.4635424079225622E-3,2.1433692825804096E-3,{"$f":"+VLOOKUP(A36,invalidez_absoluta!A36:E88,5,FALSE)","v":9.6930633769978629E-4},{"$f":"+VLOOKUP(A36,invalidez_total!A36:E88,5,FALSE)","v":1.6478207740896367E-3},{"$f":"+VLOOKUP(A36,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99785663071741959,1,1,334.9,151.44999999999999,257.47000000000003,105.47,85.4,38.619999999999997,65.66,26.89,84.56,38.24,65.010000000000005,26.63,122.80000000000001,149.57,111.19,149.43,176.2]
[53,3.1027549988649362E-3,1.5860542105863168E-3,2.3444046047256264E-3,{"$f":"+VLOOKUP(A37,invalidez_absoluta!A37:E89,5,FALSE)","v":1.0609240648334936E-3},{"$f":"+VLOOKUP(A37,invalidez_total!A37:E89,5,FALSE)","v":1.8035709102169391E-3},{"$f":"+VLOOKUP(A37,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99765559539527437,1,1,366.31,165.77,281.81,105.47,93.41,42.27,71.86,26.89,92.49,41.86,71.16,26.63,134.35,163.65,119.11999999999999,160.97999999999999,190.27999999999997]
[54,3.3988143050472245E-3,1.7094746886625357E-3,2.5541444968548801E-3,{"$f":"+VLOOKUP(A38,invalidez_absoluta!A38:E90,5,FALSE)","v":1.1610554022153034E-3},{"$f":"+VLOOKUP(A38,invalidez_total!A38:E90,5,FALSE)","v":1.9737941837660159E-3},{"$f":"+VLOOKUP(A38,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99744585550314513,1,1,399.09,181.41,308.41000000000003,105.47,101.77,46.26,78.64,26.89,100.77,45.81,77.87,26.63,146.57999999999998,178.64,127.39999999999999,173.20999999999998,205.26999999999998]
[55,3.7135129228627688E-3,1.8333708073631572E-3,2.7734418651129628E-3,{"$f":"+VLOOKUP(A39,invalidez_absoluta!A39:E91,5,FALSE)","v":1.2704171543521051E-3},{"$f":"+VLOOKUP(A39,invalidez_total!A39:E91,5,FALSE)","v":2.1597091623985786E-3},{"$f":"+VLOOKUP(A39,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99722655813488703,1,1,433.35,198.5,337.45,105.47,110.5,50.62,86.05,26.89,109.42,50.12,85.21,26.63,159.54,194.63,136.05000000000001,186.17,221.26]
[56,4.049805032374473E-3,1.9589428054521702E-3,3.0043739189133216E-3,{"$f":"+VLOOKUP(A40,invalidez_absoluta!A40:E92,5,FALSE)","v":1.3903470594468401E-3},{"$f":"+VLOOKUP(A40,invalidez_total!A40:E92,5,FALSE)","v":2.3635900010596281E-3},{"$f":"+VLOOKUP(A40,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99699562608108672,1,1,469.43,217.24,369.31,105.47,119.71,55.4,94.17,26.89,118.53,54.85,93.25,26.63,173.38,211.78,145.16,200.01,238.41]
[57,4.4102477307637142E-3,2.0885376323694672E-3,3.2493926815665907E-3,{"$f":"+VLOOKUP(A41,invalidez_absoluta!A41:E93,5,FALSE)","v":1.521430945059782E-3},{"$f":"+VLOOKUP(A41,invalidez_total!A41:E93,5,FALSE)","v":2.5864326066016292E-3},{"$f":"+VLOOKUP(A41,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99675060731843346,1,1,507.72,237.72,404.13,105.47,129.47,60.62,103.05,26.89,128.19999999999999,60.02,102.04,26.63,188.22,230.24,154.82999999999998,214.85,256.87]
[58,4.7967150351784175E-3,2.2254016825740994E-3,3.5110583588762586E-3,{"$f":"+VLOOKUP(A42,invalidez_absoluta!A42:E94,5,FALSE)","v":1.6652973817264495E-3},{"$f":"+VLOOKUP(A42,invalidez_total!A42:E94,5,FALSE)","v":2.831005548934964E-3},{"$f":"+VLOOKUP(A42,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99648894164112378,1,1,548.6,260.2,442.34,105.47,139.88999999999999,66.349999999999994,112.8,26.89,138.52000000000001,65.7,111.69,26.63,204.22000000000003,250.21,165.15,230.85000000000002,276.84000000000003]
[59,5.2104776076972968E-3,2.3734649664347868E-3,3.7919712870660418E-3,{"$f":"+VLOOKUP(A43,invalidez_absoluta!A43:E95,5,FALSE)","v":1.8223927952855374E-3},{"$f":"+VLOOKUP(A43,invalidez_total!A43:E95,5,FALSE)","v":3.0980677519854135E-3},{"$f":"+VLOOKUP(A43,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99620802871293401,1,1,592.5,284.75,484.07,105.47,151.09,72.61,123.44,26.89,149.61000000000001,71.900000000000006,122.23,26.63,221.51000000000002,271.83999999999997,176.24,248.14000000000001,298.47000000000003]
[60,5.6521193646103755E-3,2.5368491449303935E-3,4.0944842547703843E-3,{"$f":"+VLOOKUP(A44,invalidez_absoluta!A44:E96,5,FALSE)","v":1.9948162078463651E-3},{"$f":"+VLOOKUP(A44,invalidez_total!A44:E96,5,FALSE)","v":3.3911875533388204E-3},{"$f":"+VLOOKUP(A44,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99590551574522956,1,1,639.76,311.69,529.87,105.47,163.13999999999999,79.48,135.12,26.89,161.54,78.7,133.79,26.63,240.24,295.33,188.17,266.87,321.95999999999998]
[61,6.1225089494419196E-3,2.7197344706992028E-3,4.4211217100705615E-3,{"$f":"+VLOOKUP(A45,invalidez_absoluta!A45:E97,5,FALSE)","v":2.1832764163294627E-3},{"$f":"+VLOOKUP(A45,invalidez_total!A45:E97,5,FALSE)","v":3.7115699077600863E-3},{"$f":"+VLOOKUP(A45,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99557887828992941,1,1,690.8,341.14,579.92999999999995,105.47,176.15,86.99,147.88,26.89,174.43,86.14,146.43,26.63,260.57,320.86,201.06,287.2,347.49]
[62,6.6245718293964397E-3,2.9263013678422511E-3,4.7754365986193452E-3,{"$f":"+VLOOKUP(A46,invalidez_absoluta!A46:E98,5,FALSE)","v":2.3894509908019322E-3},{"$f":"+VLOOKUP(A46,invalidez_total!A46:E98,5,FALSE)","v":4.0620666843632844E-3},{"$f":"+VLOOKUP(A46,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99522456340138066,1,1,746.16,373.35,634.70000000000005,105.47,190.27,95.2,161.85,26.89,188.41,94.27,160.26,26.63,282.68,348.67,215.04,309.31,375.29999999999995]
[63,7.1630636553259002E-3,3.1601239189559234E-3,5.1615937871409123E-3,{"$f":"+VLOOKUP(A47,invalidez_absoluta!A47:E99,5,FALSE)","v":2.6157125755058132E-3},{"$f":"+VLOOKUP(A47,invalidez_total!A47:E99,5,FALSE)","v":4.4467113783598824E-3},{"$f":"+VLOOKUP(A47,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99483840621285913,1,1,806.5,408.71,694.8,105.47,205.66,104.22,177.17,26.89,203.64,103.2,175.44,26.63,306.83999999999997,379.08,230.26999999999998,333.46999999999997,405.71]
[64,7.7448812453403924E-3,3.4244222254351015E-3,5.5846517353877467E-3,{"$f":"+VLOOKUP(A48,invalidez_absoluta!A48:E100,5,FALSE)","v":2.863074736579626E-3},{"$f":"+VLOOKUP(A48,invalidez_total!A48:E100,5,FALSE)","v":4.8672270521853645E-3},{"$f":"+VLOOKUP(A48,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99441534826461231,1,1,872.6,447.36,760.5,105.47,222.51,114.08,193.93,26.89,220.33,112.96,192.03,26.63,333.29,412.36,246.96,359.92,438.99]
[65,8.378829997388924E-3,3.722243999708393E-3,6.0505369985486583E-3,{"$f":"+VLOOKUP(A49,invalidez_absoluta!A49:E101,5,FALSE)","v":3.1338293908899245E-3},{"$f":"+VLOOKUP(A49,invalidez_total!A49:E101,5,FALSE)","v":5.3275099645128717E-3},{"$f":"+VLOOKUP(A49,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99394946300145137,1,1,945.4,489.66,832.42,105.47,241.08,124.86,212.27,26.89,238.71,123.64,210.19,26.63,362.35,448.9,265.34000000000003,388.98,475.53]
[66,9.0751708657067949E-3,4.0572647463469865E-3,6.5662178060268903E-3,{"$f":"+VLOOKUP(A50,invalidez_absoluta!A50:E102,5,FALSE)","v":3.4301887148562673E-3},{"$f":"+VLOOKUP(A50,invalidez_total!A50:E102,5,FALSE)","v":5.8313208152556539E-3},{"$f":"+VLOOKUP(A50,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99343378219397316,1,1,1025.97,535.97,911.14,105.47,261.62,136.66999999999999,232.34,26.89,259.06,135.33000000000001,230.06,26.63,394.39,489.12,285.69,421.02,515.75]
[67,9.846343067267678E-3,4.4354519636230078E-3,7.1408975154453429E-3,{"$f":"+VLOOKUP(A51,invalidez_absoluta!A51:E103,5,FALSE)","v":3.7545740855362913E-3},{"$f":"+VLOOKUP(A51,invalidez_total!A51:E103,5,FALSE)","v":6.3827759454116954E-3},{"$f":"+VLOOKUP(A51,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99285910248455467,1,1,1115.77,586.65,997.31,105.47,284.52,149.6,254.31,26.89,281.73,148.13,251.82,26.63,429.86,533.54999999999995,308.36,456.49,560.17999999999995]
[68,1.0706628062059227E-2,4.8658959722529408E-3,7.7862620171560842E-3,{"$f":"+VLOOKUP(A52,invalidez_absoluta!A52:E104,5,FALSE)","v":4.1096358642680013E-3},{"$f":"+VLOOKUP(A52,invalidez_total!A52:E104,5,FALSE)","v":6.9863809692556024E-3},{"$f":"+VLOOKUP(A52,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99221373798284396,1,1,1216.5999999999999,642.13,1091.6199999999999,105.47,310.23,163.74,278.36,26.89,307.19,162.13999999999999,275.63,26.63,469.33,582.82000000000005,333.82,495.96,609.44999999999993]
[69,1.1671688699051563E-2,5.3614823789499893E-3,8.5165855390007764E-3,{"$f":"+VLOOKUP(A53,invalidez_absoluta!A53:E105,5,FALSE)","v":4.4982750512074154E-3},{"$f":"+VLOOKUP(A53,invalidez_total!A53:E105,5,FALSE)","v":7.6470675870526058E-3},{"$f":"+VLOOKUP(A53,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99148341446099919,1,1,1330.72,702.86,1194.8499999999999,105.47,339.33,179.23,304.69,26.89,336.01,177.47,301.7,26.63,513.48,637.71,362.64,540.11,664.34]
[70,1.2759850245735871E-2,5.9392681670503407E-3,9.3495592063931061E-3,{"$f":"+VLOOKUP(A54,invalidez_absoluta!A54:E106,5,FALSE)","v":4.9236669876880201E-3},{"$f":"+VLOOKUP(A54,invalidez_total!A54:E106,5,FALSE)","v":8.3702338790696343E-3},{"$f":"+VLOOKUP(A54,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.99065044079360687,1,1,1460.87,769.32,1307.8499999999999,105.47,372.52,196.18,333.5,26.89,368.87,194.25,330.23,26.63,563.12,699.1,395.5,589.75,725.73]
[71,1.3992240487010423E-2,6.6199746801552063E-3,1.0306107583582814E-2,0,0,{"$f":"+VLOOKUP(A55,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.98969389241641714,1,1,1610.33,0,0,105.47,410.63,0,0,26.89,406.61,0,0,26.63,406.61,406.61,433.24,433.24,433.24]
[72,1.5392989549506584E-2,7.4260177025301747E-3,1.1409503626018379E-2,0,0,{"$f":"+VLOOKUP(A56,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.98859049637398166,1,1,1782.73,0,0,105.47,454.6,0,0,26.89,450.14,0,0,26.63,450.14,450.14,476.77,476.77,476.77]
[73,1.6987161825290194E-2,8.3778067808354985E-3,1.2682484303062846E-2,0,0,{"$f":"+VLOOKUP(A57,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.98731751569693715,1,1,1981.64,0,0,105.47,505.32,0,0,26.89,500.36,0,0,26.63,500.36,500.36,526.99,526.99,526.99]
[74,1.8800871163136196E-2,9.4908334990796706E-3,1.4145852331107933E-2,0,0,{"$f":"+VLOOKUP(A58,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.98585414766889201,1,1,2210.29,0,0,105.47,563.62,0,0,26.89,558.1,0,0,26.63,558.1,558.1,584.73,584.73,584.73]
[75,2.0860756946803304E-2,1.0777399304704557E-2,1.5819078125753928E-2,0,0,{"$f":"+VLOOKUP(A59,fall_accidente!$A$2:$D$59,4,FALSE)","v":6.7500000000000004E-4},0.98418092187424611,1,1,2471.73,0,0,105.47,630.29,0,0,26.89,624.11,0,0,26.63,624.11,624.11,650.74,650.74,650.74]
[]
[]
[null,"Rec. Fracc. Trim.",null,"V^0,5",null,"Capital Nota Informativa",null,"IPS"]
[null,0.01,null,{"$f":"+(1/(1+interes)^(1/2))","v":1},null,10000,null,0.06]
[]
[null,null,null,null,null,null,null,null,null,"FALL+ITP","FALL+ITP+ACC","FALL+ITP","FALL+ITP+ACC"]
["Edad","Fallecimiento Anual","Invalidez Anual","Fall. Accidentes Anual","Prima Trim. Fallecimiento","Prima Trim. Invalidez","Prima Trim. Fall. Acc","IPS (sin acc)","IPS (con acc.)","Prima Trim. TOTAL","Prima Trim. TOTAL","Para control Prima sin IPS","Para control Prima sin IPS"]
[{"$f":"A2","v":18},2.1800000000000002,6.08,{"$f":"ROUND((+$G2*V_Exp_0_5)/(1-GastosN)*Capital_N_Informativa,2)","v":10.55},{"$f":"ROUND(((B67)/4)*(1+Rec_Fracc_Trim),2)","v":0.55000000000000004},{"$f":"ROUND(((C67)/4)*(1+Rec_Fracc_Trim),2)","v":1.54},{"$f":"ROUND(((D67)/4)*(1+Rec_Fracc_Trim),2)","v":2.66},{"$f":"ROUND(F67*PC_IPS,2)","v":0.09},{"$f":"ROUND((+F67+G67)*PC_IPS,2)","v":0.25},{"$f":"E67+F67+H67","v":2.1799999999999997},{"$f":"+E67+F67+G67+I67","v":5},{"$f":"E67+F67","v":2.09},{"$f":"+E67+F67+G67","v":4.75},{"$f":"+M67/L67-1","v":1.2727272727272729}]
[{"$f":"A3","v":19},2.19,6.08,10.55,0.55000000000000004,1.54,2.66,0.09,0.25,2.1799999999999997,{"$f":"+E68+F68+G68+I68","v":5},2.09,4.75,{"$f":"+M68/L68-1","v":1.2727272727272729}]
[20,2.2200000000000002,6.08,10.55,0.56000000000000005,1.54,2.66,0.09,0.25,2.19,5.01,2.1,4.76,1.2666666666666666]
[21,2.2599999999999998,6.08,10.55,0.56999999999999995,1.54,2.66,0.09,0.25,2.1999999999999997,5.0199999999999996,2.11,4.7699999999999996,1.2606635071090047]
[22,2.3199999999999998,6.08,10.55,0.59,1.54,2.66,0.09,0.25,2.2199999999999998,5.04,2.13,4.79,1.2488262910798125]
[23,2.37,6.08,10.55,0.6,1.54,2.66,0.09,0.25,2.23,5.0500000000000007,2.14,4.8000000000000007,1.2429906542056077]
[24,2.42,6.08,10.55,0.61,1.54,2.66,0.09,0.25,2.2399999999999998,5.0600000000000005,2.15,4.8100000000000005,1.2372093023255819]
[25,2.4500000000000002,6.08,10.55,0.62,1.54,2.66,0.09,0.25,2.25,5.07,2.16,4.82,1.2314814814814814]
[26,2.46,6.08,10.55,0.62,1.54,2.66,0.09,0.25,2.25,5.07,2.16,4.82,1.2314814814814814]
[27,2.4500000000000002,6.08,10.55,0.62,1.54,2.66,0.09,0.25,2.25,5.07,2.16,4.82,1.2314814814814814]
[28,2.42,6.08,10.55,0.61,1.54,2.66,0.09,0.25,2.2399999999999998,5.0600000000000005,2.15,4.8100000000000005,1.2372093023255819]
[29,2.37,6.08,10.55,0.6,1.54,2.66,0.09,0.25,2.23,5.0500000000000007,2.14,4.8000000000000007,1.2429906542056077]
[30,2.34,6.08,10.55,0.59,1.54,2.66,0.09,0.25,2.2199999999999998,5.04,2.13,4.79,1.2488262910798125]
[31,2.34,6.08,10.55,0.59,1.54,2.66,0.09,0.25,2.2199999999999998,5.04,2.13,4.79,1.2488262910798125]
[32,2.37,6.08,10.55,0.6,1.54,2.66,0.09,0.25,2.23,5.0500000000000007,2.14,4.8000000000000007,1.2429906542056077]
[33,2.4700000000000002,6.08,10.55,0.62,1.54,2.66,0.09,0.25,2.25,5.07,2.16,4.82,1.2314814814814814]
[34,2.65,6.08,10.55,0.67,1.54,2.66,0.09,0.25,2.2999999999999998,5.12,2.21,4.87,1.2036199095022626]
[35,2.93,6.08,10.55,0.74,1.54,2.66,0.09,0.25,2.37,5.19,2.2800000000000002,4.9400000000000004,1.1666666666666665]
[36,3.26,6.08,10.55,0.82,1.54,2.66,0.09,0.25,2.4499999999999997,5.27,2.36,5.0199999999999996,1.1271186440677967]
[37,3.64,6.08,10.55,0.92,1.54,2.66,0.09,0.25,2.5499999999999998,5.37,2.46,5.12,1.0813008130081303]
[38,4.03,6.08,10.55,1.02,1.54,2.66,0.09,0.25,2.65,5.4700000000000006,2.56,5.2200000000000006,1.0390625]
[39,4.4400000000000004,6.4,10.55,1.1200000000000001,1.62,2.66,0.1,0.26,2.8400000000000003,5.66,2.74,5.4,0.97080291970802923]
[40,4.88,7,10.55,1.23,1.77,2.66,0.11,0.27,3.11,5.93,3,5.66,0.88666666666666671]
[41,5.38,7.66,10.55,1.36,1.93,2.66,0.12,0.28000000000000003,3.41,6.23,3.29,5.95,0.8085106382978724]
[42,6.22,8.3699999999999992,10.55,1.57,2.11,2.66,0.13,0.28999999999999998,3.8099999999999996,6.63,3.6799999999999997,6.34,0.72282608695652173]
[43,7.28,9.17,10.55,1.84,2.3199999999999998,2.66,0.14000000000000001,0.3,4.3,7.12,4.16,6.82,0.63942307692307687]
[44,8.5299999999999994,10.029999999999999,10.55,2.15,2.5299999999999998,2.66,0.15,0.31,4.83,7.6499999999999995,4.68,7.34,0.56837606837606836]
[45,9.9600000000000009,10.98,10.55,2.5099999999999998,2.77,2.66,0.17,0.33,5.4499999999999993,8.27,5.2799999999999994,7.9399999999999995,0.5037878787878789]
[46,11.6,12.01,10.55,2.93,3.03,2.66,0.18,0.34,6.14,8.9600000000000009,5.96,8.620000000000001,0.44630872483221484]
[47,13.5,13.15,10.55,3.41,3.32,2.66,0.2,0.36,6.9300000000000006,9.75,6.73,9.39,0.39524517087667155]
[48,15.63,14.38,10.55,3.95,3.63,2.66,0.22,0.38,7.8,10.620000000000001,7.58,10.24,0.35092348284960417]
[49,18.03,15.75,10.55,4.55,3.98,2.66,0.24,0.4,8.77,11.59,8.5299999999999994,11.19,0.31184056271981242]
[50,20.67,17.23,{"$f":"ROUND((+$G34*V_Exp_0_5)/(1-GastosN)*Capital_N_Informativa,2)","v":10.55},{"$f":"ROUND(((B99)/4)*(1+Rec_Fracc_Trim),2)","v":5.22},{"$f":"ROUND(((C99)/4)*(1+Rec_Fracc_Trim),2)","v":4.3499999999999996},{"$f":"ROUND(((D99)/4)*(1+Rec_Fracc_Trim),2)","v":2.66},{"$f":"ROUND(F99*PC_IPS,2)","v":0.26},{"$f":"ROUND((+F99+G99)*PC_IPS,2)","v":0.42},{"$f":"E99+F99+H99","v":9.83},12.65,{"$f":"E99+F99","v":9.57},{"$f":"+E99+F99+G99","v":12.23},0.27795193312434696]
[51,22.79,18.850000000000001,10.55,5.75,4.76,2.66,0.28999999999999998,0.45,10.799999999999999,13.62,10.51,13.17,0.25309229305423409]
[52,25.03,20.63,10.55,6.32,5.21,2.66,0.31,0.47,11.840000000000002,14.660000000000002,11.530000000000001,14.190000000000001,0.23070251517779705]
[53,27.38,22.59,10.55,6.91,5.7,2.66,0.34,0.5,12.95,15.77,12.61,15.27,0.21094369547977787]
[54,29.83,24.72,10.55,7.53,6.24,2.66,0.37,0.53,14.139999999999999,16.96,13.77,16.43,0.19317356572258526]
[55,33.74,27.05,10.55,8.52,6.83,2.66,0.41,0.56999999999999995,15.76,18.579999999999998,15.35,18.009999999999998,0.17328990228013019]
[56,36.549999999999997,29.6,10.55,9.23,7.47,2.66,0.45,0.61,17.149999999999999,19.97,16.7,19.36,0.15928143712574849]
[57,39.53,32.39,10.55,9.98,8.18,2.66,0.49,0.65,18.649999999999999,21.47,18.16,20.82,0.1464757709251101]
[58,42.71,35.450000000000003,10.55,10.78,8.9499999999999993,2.66,0.54,0.7,20.269999999999996,23.089999999999996,19.729999999999997,22.389999999999997,0.13482007095793214]
[59,46.13,38.799999999999997,10.55,11.65,9.8000000000000007,2.66,0.59,0.75,22.040000000000003,24.860000000000003,21.450000000000003,24.110000000000003,0.12400932400932407]
[60,49.81,42.47,10.55,12.58,10.72,2.66,0.64,0.8,23.94,26.76,23.3,25.96,0.11416309012875536]
[{"$f":"A45","v":61},53.78,46.48,10.55,13.58,11.74,2.66,0.7,0.86,26.02,28.84,25.32,27.98,0.10505529225908372]
[62,58.09,50.87,10.55,14.67,12.84,2.66,0.77,0.93,28.279999999999998,31.099999999999998,27.509999999999998,30.169999999999998,9.6692111959287619E-2]
[63,62.79,55.68,10.55,15.85,14.06,2.66,0.84,1,30.75,33.57,29.91,32.57,8.8933467067870309E-2]
[64,67.94,60.95,10.55,17.149999999999999,15.39,2.66,0.92,1.08,33.46,36.28,32.54,35.200000000000003,8.1745543945912935E-2]
[65,73.599999999999994,66.709999999999994,10.55,18.579999999999998,16.84,2.66,1.01,1.17,36.43,39.25,35.42,38.08,7.5098814229249022E-2]
[66,79.88,73.02,10.55,20.170000000000002,18.440000000000001,2.66,1.1100000000000001,1.27,39.72,42.54,38.61,41.269999999999996,6.8894068894068905E-2]
[67,86.87,79.930000000000007,10.55,21.93,20.18,2.66,1.21,1.37,43.32,46.139999999999993,42.11,44.769999999999996,6.3167893611968617E-2]
[68,94.72,87.49,10.55,23.92,22.09,2.66,1.33,1.49,47.34,50.160000000000004,46.010000000000005,48.67,5.7813518800260644E-2]
[{"$f":"A53","v":69},103.6,95.76,10.55,26.16,24.18,2.66,1.45,1.61,51.790000000000006,54.61,50.34,53,5.2840683353198248E-2]
[70,113.74,104.82,10.55,28.72,26.47,2.66,1.59,1.75,56.78,59.599999999999994,55.19,57.849999999999994,4.819713716252938E-2]
[71,125.37,0,10.55,31.66,0,2.66,0,0.16,31.66,34.479999999999997,31.66,34.32,8.4017687934301977E-2]
[72,138.79,0,10.55,35.04,0,2.66,0,0.16,35.04,37.86,35.04,37.700000000000003,7.5913242009132631E-2]
[{"$f":"A57","v":73},154.28,0,10.55,38.96,0,2.66,0,0.16,38.96,41.78,38.96,41.620000000000005,6.8275154004106886E-2]
[74,172.08,0,10.55,43.45,0,2.66,0,0.16,43.45,46.269999999999996,43.45,46.11,6.1219792865362388E-2]
[75,192.44,0,10.55,48.59,0,2.66,0,0.16,48.59,51.41,48.59,51.25,5.4743774439184989E-2]

{"sheet":"invalidez_total","index":3,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["EDAD","peaimf-2007g (IAP) M","peaimf-2007g (IAP) F","Combinada Proporcion %Hombre%Mujer","sin ajustada con la Correccion por Edad"]
[18,6.3999999999999997E-5,5.3999999999999998E-5,{"$f":"+B2*hombre+C2*(1-hombre)","v":5.8999999999999998E-5},{"$f":"MAX(TsaminT,D2*((ajuste-10)/ajuste)^((A2/10))*ajuste_total)","v":4.4999999999999999E-4}]
[19,7.1000000000000005E-5,6.0000000000000002E-5,{"$f":"+B3*hombre+C3*(1-hombre)","v":6.5500000000000006E-5},4.4999999999999999E-4]
[20,8.0000000000000007E-5,6.4999999999999994E-5,7.25E-5,4.4999999999999999E-4]
[21,8.7999999999999998E-5,7.2000000000000002E-5,7.9999999999999993E-5,4.4999999999999999E-4]
[22,9.8999999999999994E-5,8.0000000000000007E-5,8.9500000000000007E-5,4.4999999999999999E-4]
[23,1.1E-4,8.7999999999999998E-5,9.8999999999999994E-5,4.4999999999999999E-4]
[24,1.22E-4,9.7999999999999997E-5,1.0999999999999999E-4,4.4999999999999999E-4]
[25,1.37E-4,1.08E-4,1.225E-4,4.4999999999999999E-4]
[26,1.5100000000000001E-4,1.1900000000000001E-4,1.35E-4,4.4999999999999999E-4]
[27,1.6899999999999999E-4,1.3200000000000001E-4,1.505E-4,4.4999999999999999E-4]
[28,1.8799999999999999E-4,1.45E-4,1.6649999999999998E-4,4.4999999999999999E-4]
[29,2.0900000000000001E-4,1.6000000000000001E-4,1.8450000000000001E-4,4.4999999999999999E-4]
[30,2.33E-4,1.7799999999999999E-4,2.0550000000000001E-4,4.4999999999999999E-4]
[31,2.5999999999999998E-4,1.9599999999999999E-4,2.2799999999999999E-4,4.4999999999999999E-4]
[32,2.8899999999999998E-4,2.1699999999999999E-4,2.5299999999999997E-4,4.4999999999999999E-4]
[33,3.2200000000000002E-4,2.4000000000000001E-4,2.81E-4,4.4999999999999999E-4]
[34,3.59E-4,2.6400000000000002E-4,3.1150000000000004E-4,4.4999999999999999E-4]
[35,3.9899999999999999E-4,2.9300000000000002E-4,3.4600000000000001E-4,4.4999999999999999E-4]
[36,4.4499999999999997E-4,3.2400000000000001E-4,3.8449999999999997E-4,4.4999999999999999E-4]
[37,4.9399999999999997E-4,3.5799999999999997E-4,4.2599999999999995E-4,4.4999999999999999E-4]
[38,5.5099999999999995E-4,3.9500000000000001E-4,4.73E-4,4.6681845451255626E-4]
[39,6.1399999999999996E-4,4.3600000000000003E-4,5.2499999999999997E-4,5.1077706523569458E-4]
[40,6.8199999999999999E-4,4.8299999999999998E-4,5.8250000000000001E-4,5.5866726419753093E-4]
[41,7.6000000000000004E-4,5.3399999999999997E-4,6.4700000000000001E-4,6.1171169605302807E-4]
[42,8.4599999999999996E-4,5.8900000000000001E-4,7.1750000000000004E-4,6.6872817048038138E-4]
[43,9.4200000000000002E-4,6.5200000000000002E-4,7.9699999999999997E-4,7.3227000277274572E-4]
[44,1.049E-3,7.2000000000000005E-4,8.8450000000000009E-4,8.0111703911515107E-4]
[45,1.1670000000000001E-3,7.9699999999999997E-4,9.8200000000000002E-4,8.7678846738503062E-4]
[46,1.2999999999999999E-3,8.8000000000000003E-4,1.09E-3,9.5938969271297352E-4]
[47,1.4469999999999999E-3,9.7300000000000002E-4,1.2099999999999999E-3,1.0498787124653532E-3]
[48,1.611E-3,1.075E-3,1.343E-3,1.1487221137892491E-3]
[49,1.794E-3,1.189E-3,1.4915E-3,1.2576142103349209E-3]
[50,1.9970000000000001E-3,1.3140000000000001E-3,1.6555000000000001E-3,{"$f":"MAX(TsaminT,D34*((ajuste-10)/ajuste)^((A34/10))*ajuste_total)","v":1.3760638084609055E-3}]
[51,2.2230000000000001E-3,1.451E-3,1.8370000000000001E-3,1.5052330771192547E-3]
[52,2.4750000000000002E-3,1.6050000000000001E-3,2.0400000000000001E-3,1.6478207740896367E-3]
[53,2.7560000000000002E-3,1.774E-3,2.2650000000000001E-3,1.8035709102169391E-3]
[54,3.0690000000000001E-3,1.9599999999999999E-3,2.5145000000000002E-3,1.9737941837660159E-3]
[55,3.4160000000000002E-3,2.166E-3,2.7910000000000001E-3,2.1597091623985786E-3]
[56,3.803E-3,2.3939999999999999E-3,3.0984999999999997E-3,2.3635900010596281E-3]
[57,4.2339999999999999E-3,2.6450000000000002E-3,3.4394999999999998E-3,2.5864326066016292E-3]
[58,4.7140000000000003E-3,2.9239999999999999E-3,3.8190000000000003E-3,2.831005548934964E-3]
[59,5.2469999999999999E-3,3.2320000000000001E-3,4.2395000000000002E-3,3.0980677519854135E-3]
[60,5.842E-3,3.5729999999999998E-3,4.7074999999999999E-3,3.3911875533388204E-3]
[61,6.5040000000000002E-3,3.9490000000000003E-3,5.2265000000000002E-3,3.7115699077600863E-3]
[62,7.241E-3,4.3639999999999998E-3,5.8025000000000004E-3,4.0620666843632844E-3]
[63,8.0630000000000007E-3,4.8240000000000002E-3,6.4435000000000004E-3,4.4467113783598824E-3]
[64,8.9770000000000006E-3,5.3319999999999999E-3,7.1545000000000003E-3,4.8672270521853645E-3]
[65,{"$f":"+B48*$I$47","v":0},{"$f":"+$M$47*C48","v":0},{"$f":"+D48*D48/D47","v":7.9439544114223645E-3},5.3275099645128717E-3]
[66,{"$f":"+B49*$I$47","v":0},{"$f":"+$M$47*C49","v":0},{"$f":"+D49*D49/D48","v":8.8205201887982167E-3},5.8313208152556539E-3]
[67,0,0,9.7938095275482036E-3,6.3827759454116954E-3]
[68,0,0,1.0874495268851344E-2,6.9863809692556024E-3]
[69,0,0,1.2074427935283145E-2,7.6470675870526058E-3]
[70,0,0,1.3406765680605767E-2,8.3702338790696343E-3]

{"sheet":"invalidez_absoluta","index":4,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["EDAD","peaimf-2007g (IAP) M","peaimf-2007g (IAP) F","Combinada Proporcion %Hombre%Mujer","sin ajustada con la Correccion por Edad"]
[18,6.3999999999999997E-5,5.3999999999999998E-5,{"$f":"+B2*hombre+C2*(1-hombre)","v":5.8999999999999998E-5},{"$f":"MAX(TasaminA,D2*((ajuste-10)/ajuste)^((A2/10)))","v":2.0000000000000001E-4}]
[19,7.1000000000000005E-5,6.0000000000000002E-5,6.5500000000000006E-5,2.0000000000000001E-4]
[20,8.0000000000000007E-5,6.4999999999999994E-5,7.25E-5,2.0000000000000001E-4]
[21,8.7999999999999998E-5,7.2000000000000002E-5,7.9999999999999993E-5,2.0000000000000001E-4]
[22,9.8999999999999994E-5,8.0000000000000007E-5,8.9500000000000007E-5,2.0000000000000001E-4]
[23,1.1E-4,8.7999999999999998E-5,9.8999999999999994E-5,2.0000000000000001E-4]
[24,1.22E-4,9.7999999999999997E-5,1.0999999999999999E-4,2.0000000000000001E-4]
[25,1.37E-4,1.08E-4,1.225E-4,2.0000000000000001E-4]
[26,1.5100000000000001E-4,1.1900000000000001E-4,1.35E-4,2.0000000000000001E-4]
[27,1.6899999999999999E-4,1.3200000000000001E-4,1.505E-4,2.0000000000000001E-4]
[28,1.8799999999999999E-4,1.45E-4,1.6649999999999998E-4,2.0000000000000001E-4]
[29,2.0900000000000001E-4,1.6000000000000001E-4,1.8450000000000001E-4,2.0000000000000001E-4]
[30,2.33E-4,1.7799999999999999E-4,2.0550000000000001E-4,2.0000000000000001E-4]
[31,2.5999999999999998E-4,1.9599999999999999E-4,2.2799999999999999E-4,2.0000000000000001E-4]
[32,2.8899999999999998E-4,2.1699999999999999E-4,2.5299999999999997E-4,2.0000000000000001E-4]
[33,3.2200000000000002E-4,2.4000000000000001E-4,2.81E-4,2.0000000000000001E-4]
[34,3.59E-4,2.6400000000000002E-4,3.1150000000000004E-4,2.0000000000000001E-4]
[35,3.9899999999999999E-4,2.9300000000000002E-4,3.4600000000000001E-4,2.0968068424990591E-4]
[36,4.4499999999999997E-4,3.2400000000000001E-4,3.8449999999999997E-4,2.2970152570559479E-4]
[37,4.9399999999999997E-4,3.5799999999999997E-4,4.2599999999999995E-4,2.5087786442741885E-4]
[38,5.5099999999999995E-4,3.9500000000000001E-4,4.73E-4,2.7459909088973898E-4]
[39,6.1399999999999996E-4,4.3600000000000003E-4,5.2499999999999997E-4,3.0045709719746743E-4]
[40,6.8199999999999999E-4,4.8299999999999998E-4,5.8250000000000001E-4,3.2862780246913586E-4]
[41,7.6000000000000004E-4,5.3399999999999997E-4,6.4700000000000001E-4,3.5983040944295768E-4]
[42,8.4599999999999996E-4,5.8900000000000001E-4,7.1750000000000004E-4,3.9336951204728318E-4]
[43,9.4200000000000002E-4,6.5200000000000002E-4,7.9699999999999997E-4,4.3074706045455633E-4]
[44,1.049E-3,7.2000000000000005E-4,8.8450000000000009E-4,4.7124531712655946E-4]
[45,1.1670000000000001E-3,7.9699999999999997E-4,9.8200000000000002E-4,5.1575792199119448E-4]
[46,1.2999999999999999E-3,8.8000000000000003E-4,1.09E-3,5.6434687806645502E-4]
[47,1.4469999999999999E-3,9.7300000000000002E-4,1.2099999999999999E-3,6.1757571321491365E-4]
[48,1.611E-3,1.075E-3,1.343E-3,6.7571889046426413E-4]
[49,1.794E-3,1.189E-3,1.4915E-3,7.3977306490289468E-4]
[50,1.9970000000000001E-3,1.3140000000000001E-3,1.6555000000000001E-3,{"$f":"MAX(TasaminA,D34*((ajuste-10)/ajuste)^((A34/10)))","v":8.0944929909465037E-4}]
[51,2.2230000000000001E-3,1.451E-3,1.8370000000000001E-3,8.8543122183485572E-4]
[52,2.4750000000000002E-3,1.6050000000000001E-3,2.0400000000000001E-3,9.6930633769978629E-4]
[53,2.7560000000000002E-3,1.774E-3,2.2650000000000001E-3,1.0609240648334936E-3]
[54,3.0690000000000001E-3,1.9599999999999999E-3,2.5145000000000002E-3,1.1610554022153034E-3]
[55,3.4160000000000002E-3,2.166E-3,2.7910000000000001E-3,1.2704171543521051E-3]
[56,3.803E-3,2.3939999999999999E-3,3.0984999999999997E-3,1.3903470594468401E-3]
[57,4.2339999999999999E-3,2.6450000000000002E-3,3.4394999999999998E-3,1.521430945059782E-3]
[58,4.7140000000000003E-3,2.9239999999999999E-3,3.8190000000000003E-3,1.6652973817264495E-3]
[59,5.2469999999999999E-3,3.2320000000000001E-3,4.2395000000000002E-3,1.8223927952855374E-3]
[60,5.842E-3,3.5729999999999998E-3,4.7074999999999999E-3,1.9948162078463651E-3]
[61,6.5040000000000002E-3,3.9490000000000003E-3,5.2265000000000002E-3,2.1832764163294627E-3]
[62,7.241E-3,4.3639999999999998E-3,5.8025000000000004E-3,2.3894509908019322E-3]
[63,8.0630000000000007E-3,4.8240000000000002E-3,6.4435000000000004E-3,2.6157125755058132E-3]
[64,8.9770000000000006E-3,5.3319999999999999E-3,7.1545000000000003E-3,2.863074736579626E-3]
[65,{"$f":"+B48*$H$47","v":0},{"$f":"+$L$47*C48","v":0},{"$f":"+D48*D48/D47","v":7.9439544114223645E-3},3.1338293908899245E-3]
[66,0,0,{"$f":"+D49*D49/D48","v":8.8205201887982167E-3},3.4301887148562673E-3]
[67,0,0,9.7938095275482036E-3,3.7545740855362913E-3]
[68,0,0,1.0874495268851344E-2,4.1096358642680013E-3]
[69,0,0,1.2074427935283145E-2,4.4982750512074154E-3]
[70,0,0,1.3406765680605767E-2,4.9236669876880201E-3]

{"sheet":"fall_accidente","index":5,"n_rows":59,"n_cols":4,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
["EDAD","fall. accidente","fall accidente de circulacion","total"]
[18,3.7500000000000001E-4,2.9999999999999997E-4,{"$f":"+C2+B2","v":6.7500000000000004E-4}]
[19,3.7500000000000001E-4,2.9999999999999997E-4,{"$f":"+C3+B3","v":6.7500000000000004E-4}]
[20,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[21,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[22,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[23,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[24,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[25,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[26,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[27,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[28,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[29,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[30,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[31,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[32,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[33,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[34,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[35,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[36,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[37,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[38,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[39,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[40,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[41,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[42,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[43,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[44,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[45,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[46,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[47,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[48,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[49,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[50,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[51,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[52,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[53,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[54,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[55,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[56,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[57,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[58,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[59,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[60,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[61,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[62,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[63,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[64,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[65,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[66,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[67,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[68,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[69,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[70,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[71,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[72,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[73,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[74,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]
[75,3.7500000000000001E-4,2.9999999999999997E-4,6.7500000000000004E-4]