Interp
Syntax
Interp(Year1, Value1, Year2, Value2,... YearN, ValueN, [ Growthrate]) or
Interp(ExcelFile, ExcelRange, [ Growthrate])
Interp(Branch:Variable)
Summary
Calculates a value in any given year by linear interpolation of a time-series of year/value pairs. The final optional parameter to the function is a growth rate that is applied after the last specified year. If no growth rate is specified zero growth is assumed (i.e. values are not extrapolated). Each intermediate year's value is calculated as follows:
Where:
iy = the intermediate period, the value of which is to be interpolated.
ey = the end period used as the basis for the interpolation.
fy = the first period used as the basis for the interpolation.
Example
Interp(2000, 10.0, 2010, 16.0, 2020, 30.0, 2%)
2000 = 10.0
2005 = 13.0
2020 = 30.0
2021 = 30.6
NB: the base year value is always implicit in the above function, and will override any value explicitly entered for that year by the user. For example, if the base year is 1998 and the base year value (entered in Current Accounts ) is 6.0 then the function above will result in the value 8.0 1999.