License:
Shareware
Price:
$20.00
Expires after 30 days
Information:
This provides 11 advanced look-up and interpolation functions for Excel, with extrapolation, and one, two or three-variable look-up. Interpolation modes include closest-value look-up, linear interpolation, interpolation using parabolic and hyperbolic piecewise curves, cubic splines and polynomial curves of order, up to 20.
The program's functions can process tables with missing and invalid values, and the "TVPOLYDATA and THPOLYDATA" functions allow you to determine polynomial curve coefficients, with order up to 20. The polynomial curves are fitted through the X-Y data points given in a table, using the least squares method. The best fit polynomial curve is automatically determined.
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. Complete online help and examples are included.
| Additional Software Required: |
| Microsoft Excel 98, 2000, XP or 2003 |
 |
|
|
|
