PC Soft Land>Business>Spreadsheets

TriLookup

Categories

  Publisher: Trimill Industrial Systems Inc.
Support Email: info@trimill.com
License: Shareware
Price($): 20
OS: WIN95,WIN98,WINME,WINNT 4.X,WINXP,2000
File Size(KB): 1040
Version: 2.2
Last Update: June 02 04
Rating: 5 stars rating
Screenshot: Preview
Download Now  Buy now
Publisher's Description
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.

กก

Visit TriLookup Home Page

กก

Related Products:
Excel Join (Merge, Match) Two Tables Software - Merge / combine two tables based on a common column.

Excel Typos Finder - Aren't you sick and tired of typos? Kill typos in your Excel workbooks!

Synkronizer - Synkronizer compares, updates and synchronizes Excel spreadsheets.

Advanced Excel Find - Easy and fast search through multiple worksheets and workbooks in Excel.

Advanced Excel Select - An Excel tool that enriches the built-in Special Cells dialog.

TriLookup Mac - Advanced 1, 2 and 3 variable look-up and interpolation functions for Excel.

Multiple Regression Analysis and Forecasting - Producing statistically sound value driver identification for forecasting data

Excel Macro Processor - Apply Microsoft Excel macros to a lot of documents with this automation tool.

ADX Toys for Microsoft Excel - Is a COM add-in that adds several useful features to Microsoft Excel

Color Palette Professional - Bring life, color and style to your Excel charts and reports.


Search similar software using these keywords: Excel add-in, spreadsheet, lookup, interpolation, curve fitting, TriLookup 
 
Web www.pcsoftland.com

What I'm Interested In?
excel schedule excel find multiple regression excel excel macro find microsoft excel macros create schedule in excel search for duplicates in excel excel find macro advanced excel excel interpolation find macro in excel interpolation excel library excel macro excel macro library microsoft excel macro excel macro to search a excel workbook excel interpolation macro microsoft excel schedule regression analysis excel find duplicates in excel excel regression analysis multiple regression analysis in excel multiple regression analysis professional excel charts advanced excel charts search multiple workbooks multiple regression in excel excel macro processor schedule excel macro excel multiple lookup
Submit a file | Link to us | About us

Copyright 2004 PC Soft Land Inc. All Rights Reserved.