Description

Get a column map value from a periodic slot given a date and a value. This is the inverse of the way values are usually accessed in periodic slots with column maps (i.e., given a date and column map value, find the corresponding slot value).

Type

NUMERIC

Arguments

Type

Meaning

1

SLOT

The periodic slot to be accessed.

2

DATETIME

The date to be used to index into the time dimension of the Periodic Slot (its row map).

3

NUMERIC

The value to use for the lookup, having the same type of units as the values in the periodic slot itself.

Evaluation

If the default access method for the table is "lookup", then we first find the row whose associated time interval contains the input date. We then find the two consecutive values in that row whose values bracket the input value. We then find the column map values associated with these two values, and return a value interpolated between them according to where the input value falls between its two bracketing values.

If the default access method is "interpolation" then the procedure described above is followed for the row whose time interval follows the given date, and the return value is interpolated between the values found for the two rows.

Comments

The input slot must be a periodic slot with a column map, the numeric value must have units compatible with the units of the periodic slot, for the relevant time interval(s), the slot values must be either a monotonically non-decreasing or monotonically non-increasing function of the column map values, and the input value must fall within the domain of that function. If there are multiple possible return values, i.e., if the input value appears for multiple columns, then the largest column map value is returned.