Step

Syntax

Step(Year1, Value1, Year2, Value2,... YearN, ValueN) or
Step(ExcelFilename, ExcelRangeName)
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.

Examples

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

2000 = 300.0
2012 = 500.0
2022 = 900.0

NB: The base yearThe first historical year of a LEAP analysis. 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 Current AccountsThe starting data for all scenarios. The Current Accounts can include data for just a single Base Year, or data for multiple historical years between the Base Year and one year before the First Scenario Year. ) is 200.0 then the function above will results in the value 200.0 for both 1998 and 1999.