InterpFSY

Syntax

InterpFSY(Year1, Value1, Year2, Value2,... YearN, ValueN, [ Growthrate]) or
InterpFSY(ExcelFile, ExcelRange, [ Growthrate])
InterpFSY(LCDS, SeriesName, Filter1, Filter2, [CountryISO3])
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.

The second syntax of the function retrieves years and values from a specified Excel file and range. The third syntax of the function retrieves years and values from the online LEAP Cloud Data Server (LCDS). In both cases, retrieving this data initially may takes some time (typically a second or less depending on your internet connection), but thereafter values are cached locally for near-instant retrieval.  Use the Time-Series wizard to help specify the parameters required when using these syntax.