Examples of linear and bilinear interpolation in table lookup data references

Linear interpolation example

In a tank strapping table that contains a Level column and a Volume column, the following configuration string interpolates the volume based on the level reading:

SELECT Volume FROM MyTable WHERE INTERPOLATE(Level, @MyLevelReading)

Assume the sample table has the following rows:

• A Level reading of 2.2 results in a returned Volume of 22.0.

• A Level reading of 2.7 results in a returned Volume of 20.0 when Stepped is selected (true).

• Extrapolation: A Level reading of 6.5 results in a returned Volume of 75.0 when Stepped is cleared (false).

• Extrapolation: A Level reading of 6.5 results in a returned Volume or 70.0 when Stepped is selected (true).

Bilinear interpolation example

In an air velocity table that contains an X Horizontal Position column, a Y Vertical Position column, and a Velocity column, the following configuration string interpolates the velocity based on the X horizontal and Y vertical positions.

SELECT Velocity FROM Table1 WHERE INTERPOLATE([X Horizontal Position], @X) AND INTERPOLATE([Y Vertical Position], @Y)

Assume the sample table has the following rows:

An X Horizontal Position of 245 and a Y Vertical Position of 165 results in a returned Velocity of 3.2171875.