TableInterpolation3D

This function performs a double interpolation using two columns of data, and a value for each column, to compute the corresponding value in a third column of data. The data in the two columns used for the double interpolation must be in ascending order.

Description

Table lookup with double linear interpolation.
Type

NUMERIC
Arguments

Type

Meaning

1

SLOT

Table slot on which to do the lookup
2

NUMERIC

This is the column number (zero based) corresponding to the first column of data in the table - the data to use for the outer/first interpolation
3

NUMERIC

The value to use for the first column
4

NUMERIC

This is the column number (zero based) corresponding to the second column of data in the table - the data to use for the inner/second interpolation
5

NUMERIC

The value to use for the second column
6

NUMERIC

This is the column number of the third column of data in the table - where the answer will be computed
7

DATETIME

datetime context for unit conversions
Evaluation

 
Mathematical Expression

 
Comments

If the given slot is not a table slot or if the columns do not exist in the table, the function aborts the run with an error. Column numbers are zero based with a unit type of NONE. If a value is not the same unit type as the values in the corresponding column, the function aborts the run with an error. If the values in the table do not encompass the values passed into the function, the function aborts the run with an error. Also, the values in the columns used for both the inner and outer interpolations MUST BE IN ASCENDING ORDER.
 
TableInterpolation3D(LowerReach.Interpolated GainLoss Table, 0, GetDayOfYear(@"t"), 1, LowerReach.Inflow[], 2, @"t")
 
1.344