This Excel add-in offers eleven potent worksheet functions for 1-3 variable lookup and interpolation. It includes various interpolation methods, such as closest-value, linear, and cubic spline, plus an online help feature and sample workbooks for easy implementation. Polynomial curve fitting is also included.
This Excel add-in offers a range of powerful worksheet functions for 1, 2, and 3 variable lookup and interpolation. With a variety of interpolation modes to choose from, including closest-value, linear, piecewise parabolic or hyperbolic, cubic spline and polynomial up to 20th order, the user has the flexibility to find the perfect fit for their data.
Additionally, these functions are able to handle tables containing missing and invalid data with ease. The add-in even includes functions to fit polynomial curves through a set of X-Y data points and return a table of polynomial curve coefficients, as well as determining the best fit polynomial curve.
In the case of an error, the TriLookup functions can either return a standard Excel error code or provide the user with a detailed text error message, indicating the nature of the error and pointing to the cause of it. With online help and example workbooks included, users can easily navigate and utilize the add-in.
To use this software, Microsoft Excel (32 Bit) (Windows) is required. The TVLOOKUP & TVLKP functions allow the user to search a multi column table for the lookup value in the lookup column and return a value from the same row of the return column. These functions are also able to use interpolation and handle missing values.
Similarly, THLOOKUP & THLKP functions search a multi row table for the lookup value in the lookup row and return a value from the same column of the return row. T2LOOKUP & T2LKP functions take it a step further and let the user search a 2D (X-Y) table for X values in top row and Y values in left column, and return a value from the intersecting row and column. These functions can also use interpolation and handle missing values.
Lastly, the T3LOOKUP & T3LKP functions allow the user to search a 3D (X-Y-Z) table for X, Y and Z values and return a value V(x,y,z) from the intersecting row, column and table. As expected, these functions can use interpolation and handle missing values. The TVPOLYDATA & THPOLYDATA functions will calculate polynomial curve coefficients up to a specified order (using the least squares method) for the X-Y data points given in a table, and determine the best fit curve.
The TPOLY function returns the Y value of a polynomial curve for a given X value, polynomial order, and an array of polynomial curve coefficients. It can optionally return the value of a derivative. Overall, this Excel add-in offers a comprehensive solution for those in need of advanced lookup and interpolation functions in their data analysis.
Additionally, these functions are able to handle tables containing missing and invalid data with ease. The add-in even includes functions to fit polynomial curves through a set of X-Y data points and return a table of polynomial curve coefficients, as well as determining the best fit polynomial curve.
In the case of an error, the TriLookup functions can either return a standard Excel error code or provide the user with a detailed text error message, indicating the nature of the error and pointing to the cause of it. With online help and example workbooks included, users can easily navigate and utilize the add-in.
To use this software, Microsoft Excel (32 Bit) (Windows) is required. The TVLOOKUP & TVLKP functions allow the user to search a multi column table for the lookup value in the lookup column and return a value from the same row of the return column. These functions are also able to use interpolation and handle missing values.
Similarly, THLOOKUP & THLKP functions search a multi row table for the lookup value in the lookup row and return a value from the same column of the return row. T2LOOKUP & T2LKP functions take it a step further and let the user search a 2D (X-Y) table for X values in top row and Y values in left column, and return a value from the intersecting row and column. These functions can also use interpolation and handle missing values.
Lastly, the T3LOOKUP & T3LKP functions allow the user to search a 3D (X-Y-Z) table for X, Y and Z values and return a value V(x,y,z) from the intersecting row, column and table. As expected, these functions can use interpolation and handle missing values. The TVPOLYDATA & THPOLYDATA functions will calculate polynomial curve coefficients up to a specified order (using the least squares method) for the X-Y data points given in a table, and determine the best fit curve.
The TPOLY function returns the Y value of a polynomial curve for a given X value, polynomial order, and an array of polynomial curve coefficients. It can optionally return the value of a derivative. Overall, this Excel add-in offers a comprehensive solution for those in need of advanced lookup and interpolation functions in their data analysis.
What's New
Version 3.0:
Added TriLookupLite Freeware edition.
Added installation for Excel 2016 for Windows.
Added support for 64 bit Excel for Windows.
Revised User's Manual.