Data

Syntax

Data(Year1, Value1, Year2, Value2,... YearN, ValueN) or
Data(ExcelFile, ExcelRange), or
Data(Branch:Variable)

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

Summary

Specifies time-series data values as year/value pairs.  Values are not interpolated between data points.  Any unspecified data years are assumed to have zero value.  

Typically you will use this function to specify historical data in the Current Accounts scenario. Data specified in this fashion can also be referred to by other time-series functions.  For example, you might specify time-series once in a key assumption branch called TimeValues using the Data function, and then refer to it in other branches as Interp(Key\TimeValues).

Example

Data(2000, 10, 2001, 16, 2003, 20)

2000 = 10
2001 = 16
2002 =   0
2003 = 20