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 97, 2000, XP or 2003 (Windows) or Excel 98, 2001 or X (Mac).
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.

• TriLookup 2.2
  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...

• WebCab Functions (J2EE Edition) 2.0
  EJB Component Suite offering refined numerical procedures to either construct a function of one or two variables from a set of points (i

• WebCab Functions (J2SE Edition) 2.0
  Java API Components offering refined numerical procedures to either construct a function of one or two variables from a set of points (i.e. interpolate), or solve an equation of one variable. The interpolation procedures provided include Newton...

• FindGraph 1.924
  FindGraph is an engineering and science tool that simplifies the task of curve fitting and regression analysis

• WebCab Portfolio for Delphi 5.0
  3-in-1: Delphi, COM and XML Web service implementation of Markowitz Theory and Capital Asset Pricing Model (CAPM) to analyze and construct the optimal portfolio with/without asset weight constraints with respect to Markowitz Theory by giving the risk, return or investors utility function; or with respect to CAPM by given the risk, return or Market...

• WebCab Portfolio for .NET 4.2
  .NET, COM and XML Web service implementation of Markowitz Theory and Capital Asset Pricing Model (CAPM) to analyze and construct the optimal portfolio with/without asset weight constraints with respect to Markowitz Theory by giving the risk, return or investors utility function; or with respect to CAPM by given the risk, return or Market Portfolio weighting. Also includes Performance Evaluation, extensive auxiliary classes/methods including equation solve and interpolation procedures, analysis of Efficient Frontier, Market Portfolio and CML. Utility Functionality included: Interpolation - Cubic spline and general polynomial interpolation procedures to assist in the study of the Efficient Frontier SolveFrontier - Solve the Efficient Frontier with respect to the risk, return, or the investors utility function. MaxRange - Maximum range of the constrained Efficient Frontier AssetParameters - Evaluation of the covariance matrix, expected return, volatility, portfolio risk/variance. Performance Evaluation - Offers a number of procedures for accessing the return and risk adjusted return (Treynors Measure, Sharpes Ratio). This product also has the following technology aspects: 3-in-1: .NET, COM, and XML Web services - Three DLLs, Three API Docs, Three Sets of Client Example all in 1 product. Offering a 1st class .NET, COM, and XML Web service product implementation. Extensive Client Examples - Multiple client examples including .NET (C#, VB.NET, C++.NET), COM and XML Web services (C#, VB.NET) ADO Mediator - The ADO Mediator assists the .NET developer in writing DBMS enabled applications by transparently combining the financial and mathematical functionality of our .NET components with the ADO.NET Database Connectivity model. Compatible Containers - Visual Studio 6, Visual Studio .NET, Borland's C++ Builder, Borland Delphi 3 - 2005, Office 97/2000/XP/2003 ASP.NET Web Application Examples ASP.NET Examples with Synthetic ADO.NET