| Company | Trimill Industrial Systems Inc. |
| Website | http://www.trimill.com |
| Country | Canada |
| Email | info@trimill.com |
| Os | MAC 68k, Mac PPC |
| Requirements | Excel 98, 2001 or X |
| Language | English |
| Release Date | 02 06 2004 |
| License | Shareware |
| Limitations | |
|
|
|
|
|
|
Buy Nowfor $20
|
Free Download
0.74 Mb
|
|
Mac:Mac OS:Business:Spreadsheets
Views 800 (+0) / Rating 0.71 / Shareware
By Trimill Industrial Systems Inc.
Excel add-in with eleven potent 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 regulate. The functions bottom also hold tables containing missing and invalid data.
Includes functions to correspond polynomial curves through a put of X-Y data points and repay a remit of polynomial crook coefficients, as good as, decide the trump correspond polynomial crook.
In pillowcase of an fault, TriLookup functions bottom either repay a criterion Excel fault code or a detailed text fault message, indicating the nature of the fault and pointing to the cause of it.
Includes online supporter and lesson workbooks. Requires Microsoft Excel 97, 2000, XP or 2003 (Windows) or Excel 98, 2001 or X (Mac).
TVLOOKUP & TVLKP seek a multi column remit for the lookup treasure in the lookup column and repay a treasure from the same quarrel of the repay column. Can use interpolation and hold missing values.
THLOOKUP & THLKP seek a multi quarrel remit for the lookup treasure in the lookup quarrel and repay a treasure from the same column of the repay quarrel. Can use interpolation and hold missing values.
T2LOOKUP & T2LKP seek a 2D (X-Y) remit for X values in crown quarrel and Y values in left column, and repay a treasure from the intersecting quarrel and column. Can use interpolation and hold missing values.
T3LOOKUP & T3LKP seek a 3D (X-Y-Z) remit for X, Y and Z values. Return a treasure V(x, y, z) from the intersecting quarrel, column and remit. Can use interpolation and hold missing values.
TVPOLYDATA & THPOLYDATA Calculate polynomial crook coefficients up to a specified regulate (using the least squares method) for the X-Y data points given in a remit. Also decide the trump correspond crook.
TPOLY returns the Y treasure of a polynomial crook for given a X treasure, polynomial regulate and an array of polynomial crook coefficients. It bottom optionally repay the treasure of a derivative.
|
