Free Download TriLookup Mac 2.2 - Advanced lookup and interpolation for Excel.

Spreadsheets  Views:1402(+0) Shareware

Excel add-in with eleven mighty 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 regularise. The functions throne also address tables containing missing and invalid data.
Includes functions to tally polynomial curves through a band of X-Y data points and retort a postpone of polynomial arc coefficients, as wellspring as, regulate the topper tally polynomial arc.
In shell of an erroneousness, TriLookup functions throne either retort a criterion Excel erroneousness code or a detailed text erroneousness message, indicating the nature of the erroneousness and pointing to the cause of it.
Includes online serve and instance workbooks. Requires Microsoft Excel 97, 2000, XP or 2003 (Windows) or Excel 98, 2001 or X (Mac).
TVLOOKUP & TVLKP research a multi column postpone for the lookup appraise in the lookup column and retort a appraise from the same wrangle of the retort column. Can use interpolation and address missing values.
THLOOKUP & THLKP research a multi wrangle postpone for the lookup appraise in the lookup wrangle and retort a appraise from the same column of the retort wrangle. Can use interpolation and address missing values.
T2LOOKUP & T2LKP research a 2D (X-Y) postpone for X values in peak wrangle and Y values in left column, and retort a appraise from the intersecting wrangle and column. Can use interpolation and address missing values.
T3LOOKUP & T3LKP research a 3D (X-Y-Z) postpone for X, Y and Z values. Return a appraise V(x, y, z) from the intersecting wrangle, column and postpone. Can use interpolation and address missing values.
TVPOLYDATA & THPOLYDATA Calculate polynomial arc coefficients up to a specified regularise (using the least squares method) for the X-Y data points given in a postpone. Also regulate the topper tally arc.
TPOLY returns the Y appraise of a polynomial arc for given a X appraise, polynomial regularise and an array of polynomial arc coefficients. It throne optionally retort the appraise of a derivative.