Step

Syntax

Step(Year1, Value1, Year2, Value2,... YearN, ValueN) 
Step(ExcelFilename, ExcelRangeName)
Step(LCDS, SeriesName, Filter1, Filter2, [CountryISO3])
Step(Branch:Variable)

See Also

Using Time-Series Functions, Interp

Summary

Calculates a value in any given year using a step function between a time-series of year/value pairs.

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.

Examples

Step (2000, 300.0, 2010, 500.0, 2020, 900.0)

2000 = 300.0
2012 = 500.0
2022 = 900.0

NB: The value is always implicit in the function, and will override any value explicitly entered for that year by the user. For example, if the base year is 1997 and the base year value (entered in ) is 200.0 then the function above will results in the value 200.0 for both 1998 and 1999.