sponsored links
TriLookup
Advanced 1, 2 and 3 variable look-up and interpolation functions for Excel.
Description
"Advanced 1, 2 and 3 variables Look-up and interpolation functions for Excel."
Excel add-1, 2 and 3 for variable search Eleven powerful worksheet functions and interpolation. Interpolation modes include: closest-value, partial parabolic or hyperbolic, cubic spline and polynomial up to 20 linear order. The tables containing missing and invalid data functionality can operate.
With a set of XY data points and polynomial curve fit polynomial curve coefficients back table, as well as to determine the most appropriate functions include polynomial curve.
TriLookup fonksiyonları ya, hata niteliği gösteren standart bir Excel hata kodu veya detaylı bir metin hata mesajı dönebilirsiniz> The reason for this sign.
Includes online help and example workbooks. Requires Microsoft Excel 97, 2000, XP or 2003 (Windows) or Excel 98, 2001 or X (Mac).
Search for in the search column TVLOOKUP & search for the most TVLKP column to return a value back to the same table and column lines. Can I use interpolation and handle missing values.
Search and the search for THLOOKUP line for a multi-line search THLKP in the same column of the table and return line returns a value. Can I use interpolation and handle missing values.
Y values in the top row and left column of x values in the search for T2LOOKUP & T2LKP a 2D (XY) table and returns a value of intersecting rows and columns. Can I use interpolation and handle missing values.
X, Y and Z values for the search T3LOOKUP & T3LKP a 3D (XYZ) table. Return value V (x, y, z) intersects the row, column and table. Can I use interpolation and handle missing values.
Calculate polynomial curve coefficients up TVPOLYDATA & THPOLYDATA a specific order () XY data points given in a table for the least squares method. Also determines the most appropriate curve.
TPOLY X value, polynomial order and a set of polynomial curve coefficients for a given polynomial curve Y value returns. This optional value can return a variant. Now you can download free TriLookup 2.2.
sponsored links
Visitor rates
4 Star
41
Member rates
4 Star
29
Ortalama oy:
3,8