Excel Functions in EAC ToolsExcel Functions in EAC Tools\More PV functionsMore PV functions\ProjScale

ProjScale

ProjScale returns a factor at age 𝑥 for a given mortality improvement projection scale.

Syntax

ProjScale (ScaleName, Age, [Sex], [Year])

Parameter Name

Description

ScaleName

Mortality improvement projection scale name.

Age

Current age 𝑥.

Sex

"m" or "f", not used if sex is implicit in the table name.

Year

Year, necessary for 2-dimensional table (e.g. BB2D, MP2014, MP2015, …).
Optional, not used for a 1-dimensional table.