TriLookup is a Business::Other software developed by Trimill Industrial Systems Inc.. After our trial and test, the software was found to be official, secure and free. Here is the official description for TriLookup: Excel add-in with eleven powerful worksheet functions for 1, 2 and 3 variable lookup and interpolation. Interpolation modes include: closest-value, linear, piecewise parabolic or hyperbolic, cubic spline and polynomial up to 20th order. The functions can also handle tables containing missing and invalid data.
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, determine the best fit polynomial curve.
In case of an error, TriLookup functions can either return a standard Excel error code or a detailed text error message, indicating the nature of the error and pointing to the cause of it.
Includes online help and example workbooks. Requires Microsoft Excel (32 Bit) (Windows).
TVLOOKUP & TVLKP 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. Can use interpolation and handle missing values.
THLOOKUP & THLKP 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. Can use interpolation and handle missing values.
T2LOOKUP & T2LKP 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. Can use interpolation and handle missing values.
T3LOOKUP & T3LKP search a 3D (X-Y-Z) table for X, Y and Z values. Return a value V(x,y,z) from the intersecting row, column and table. Can use interpolation and handle missing values.
TVPOLYDATA & THPOLYDATA Calculate polynomial curve coefficients up to a specified order (using the least squares method) for the X-Y data points given in a table. Also determine the best fit curve.
TPOLY returns the Y value of a polynomial curve for given a X value, polynomial order and an array of polynomial curve coefficients. It can optionally return the value of a derivative.
Added TriLookupLite Freeware edition. Added installation for Excel 2016 for Windows. Added support for 64 bit Excel for Windows. Revised User's Manual.
|Platforms:||Win2000,WinXP,Win7 x32,Win7 x64,Windows 8,Windows 10,WinServer,WinOther,Windows2000,Windows2003,Windows Server 2000,Windows Server 2003,Windows Server 2008,Windows Server 2008r2,Windows Server 2012,Windows Tablet PC Edition 2005,Windows Media Center|
|Publisher:||About Trimill Industrial Systems Inc. | Trimill Industrial Systems Inc. titles | Visit Trimill Industrial Systems Inc. | Country: Canada|
|Downloads:||0 last month, 129 total|
|Last updated:||More than a year ago ()|
|Requirements:||Excel 97 to 2016|
|Watch for updates:|
|Email a friend... Get the best software deals each week!|
|TextPipe Pro - Slam-dunk the most challenging edit tasks with TextPipe Pro - a powerful text-processing utility that combines 270+ conversion,... ...|