Recommended Software

VentaFax Business 6.0

VentaFax is a full-featured fax and answering machine software with color fax support. It sends and receives faxes and turns your PC with a fax modem into a versatile answering machine with remote control and email integration. You can retrieve your fax and voice messages from any touchtone phone...

DOWNLOAD

Software Catalog

Business & Productivity Tools	Desktop
Developer Tools	Drivers
Education	Games
Home & Personal	Internet & Networking
Multimedia & Design	Operating Systems
Utilities

TriLookup

TriLookup 2.2

Category: Business & Productivity Tools / Spreadsheets | Author: Trimill Industrial Systems Inc.

Excel add-in with eleven powerful worksheet functions for 1, 2 and 3 variable lookup and interpolation (closest-value, linear, piecewise parabolic or hyperbolic, cubic spline) and polynomial curve fitting. Includes online help and example workbooks.

DOWNLOAD GET FULL VER Cost: $20.00 USD, 30.00 CAD
License: Shareware
Size: 1.0 MB
Download Counter: 13

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.

Requirements: Excel 97, 2000, XP or 2003
OS Support: Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP
Language Support: English

Released: June 02, 2004 | Added: June 05, 2004 | Viewed: 146

Related Software

TriLookup Mac - Excel add-in with eleven powerful worksheet functions for 1, 2 and 3 variable lookup and interpolation (closest-value, linear, piecewise parabolic or hyperbolic, cubic spline) and polynomial curve fitting. Includes online help and example workbooks.
Data Curve Fit Creator Add-in - Adds data curve fitting, interpolation and data smoothing functions to Excel. Functions include polynomial fits, several types of splines, and local regressions. Filters include moving average, Gaussian smoothing and median filtering.
NLREG - NLREG performs nonlinear regression and curve fitting. NLREG fits a mathematical function whose form you specify to a set of data values. Virtually any type of function can be fitted.
Regression Analysis - CurveFitter - CurveFitter program performs statistical regression analysis to estimate the values of parameters for linear, multivariate, polynomial, exponential and nonlinear functions.
FindGraph - FindGraph is comprehensive, feature-rich graph editor, as well as a curve-fitting and digitizing tool for engineers, scientists and graduate students. Discover the model that best describes your data.
CurvFit - a curve fitting program: Lorentzian, Sine, Exponential and Power series are available models to match your data. A Lorentzian series is recommended for real data especially for multiple peaked data.This is a Fortran Calculus demo application.
Advanced Grapher - Graphing, curve fitting and calculating software. Graphs Cartesian, polar and parametric functions, graphs of tables, implicit functions and inequalities. Calculus features: regression analysis, derivatives, tangents, normals and more.
MicroStation Excel- {Cadig AutoTable 3 } - { Cadig AutoTable 3.0 } is designed to import Excel spreadsheet to MicroStation and modify it with Excel at anytime. Besides, you can update table in MicroStation to synchronize it with the original Excel spreadsheet. == http://www.cadig.com ==
AutoCAD LT Excel- {Cadig AutoTable 3.0} - { Cadig AutoTable 3.0 } is designed to import Excel spreadsheet to AutoCAD LT and modify it with Excel at anytime. Besides, you can update table in AutoCAD to synchronize it with the original Excel spreadsheet. == http://www.cadig.com ==
AutoCAD Excel - { Cadig AutoTable 3.0 } - { Cadig AutoTable 3.0 } is designed to import Excel spreadsheet to AutoCAD and modify it with Excel at anytime. Besides, you can update table in AutoCAD to synchronize it with the original Excel spreadsheet. == http://www.cadig.com ==

Top Downloads

New Downloads

User Reviews and Articles about Software

New Reviews