Examples of Expressions

Type

Description

Example Syntax and Graph

Simple Number

Calculates a constant value in all scenario years

3.1415

Simple Formula

Calculates a constant value in all scenario years

0.1 * 5970

Growth Rate

Calculates exponential growth over time from a base year value. NB: only valid in scenario expressions - not in Current Account expressions.

Growth(3.2%)

Interpolation

Calculates straight-line change between specified pairs of data years and values. An optional final parameter lets you specify an exponential growth rate after the last data year. The function can include any number of year/value pairs, which need to be entered in ascending chronological order. Notice that the value parameters in this function can themselves be specified as mathematical functions.

Interp(2000, 40, 2010, 65, 2020, 80)

 

Step

 

Similar to the Interpolation function except that it calculates discrete changes between specified pairs of data years and values.

Step(2000, 300, 2005, 500, 2020, 700)

 

Remainder

Calculates remaining value in one branch by subtracting values of all other neighboring branches from the function parameter. This function is useful for ”r;share” branches, for example where you want to specify some branches as changing percentage share, and have one branch account for the remaining share.

Remainder(100)

Branch and Variable References

Any LEAP variable can be calculated as a function of another variable (with some restrictions)

Passenger: Activity Level + 10%

GrowthAs

Calculates a value in any given year based on its previous year's value and the rate of growth in another named branch, raised to the power of an elasticity.

GrowthAs(Key\Income,1.1)