InterpFSY

Syntax

InterpFSY(Year1, Value1, Year2, Value2,... YearN, ValueN, [ Growthrate]) or
InterpFSY(ExcelFile, ExcelRange, [ Growthrate])
InterpFSY(Branch:Variable)

See also: Using Time-Series Functions and Specifying Excel File and Range Parameters, Interp.

Summary

Calculates a value in any given year by linear interpolation of a time-series of year/value pairs. Similar to the Interp function, but with the following differences:

• In the standard Interp function, the base yearThe first historical year of a LEAP analysis. value is always an implicit interpolated value and will override any value explicitly entered for that year by the user.

• In the InterpFSY function, the year immediately before the First Scenario Year is the implicit interpolated value.

The Base Year and First Scenario Year are both defined on the General: Settings: Years screen.