Search our site:

TriLookup 2.2

Size

 1.04 MB

License

 Shareware

Price

 20 USD

Category

 Business & Finance / Spreadsheets

Operating System

 Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000

Developer

 Trimill Industrial Systems Inc.

 

TriLookup 2.2 Review




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.
Program system requirements: Excel 97, 2000, XP or 2003

Screenshot:

TriLookup
Download Now
File size 1.04 MB

Buy Now
excel add-in, spreadsheet, lookup, interpolation, curve fitting,

Top Spreadsheets / Business & Finance programs

Excel Add Data, Text & Characters To All Cells Software 1)   Excel Add Data, Text & Characters To All Cells Software 1.1
Add text to beginning, end or inside multiple Excel cells.

Excel VBA Models Set 1 2)   Excel VBA Models Set 1 XL-VBA1.0
Excel VBA Models Open Source Code Learning Tool - Finance and Statistics Models

Excel Backup File Auto Save Software 3)   Excel Backup File Auto Save Software 7.0
Automatically backup-save copies of your open Excel files while you work.

Excel VBA Models Combo Set 4)   Excel VBA Models Combo Set XL-VBA4 1.0
Excel VBA Open Source Code Models contains 37 programs in finance and statistics

Customer Invoice Template 5)   Customer Invoice Template 1.0
A customer invoice management system with order tracking and sales reporting.

Excel Add, Subtract, Multiply, Divide All Cells Software 6)   Excel Add, Subtract, Multiply, Divide All Cells Software 1.1
Apply math operation to selected Excel cells.

Excel VBA Models Set 3 7)   Excel VBA Models Set 3 XL-VBA3.0
Excel VBA Models Open Source Code - Numerical Methods and Option Pricing Set


New Spreadsheets / Business & Finance programs

DBF to CSV 1)   DBF to CSV 1.51.04
Allows you to convert your dbf files to csv (comma-separated value) format.

Zip Express 2)   Zip Express 2.5
Search by zip code, city, county, state or area code. Copy to clipboard or print

Print Designer GOLD 3)   Print Designer GOLD 9.0.1.0
A single, powerful product for all your printing needs!

Label Designer Plus DELUXE 4)   Label Designer Plus DELUXE 9.0.1.0
A single, powerful product for all your labeling needs!

Business Card Designer Plus 5)   Business Card Designer Plus 9.0.1.0
Design and print great looking business cards quickly and easily.

Excel Export To Multiple CSV Files Software 6)   Excel Export To Multiple CSV Files Software 7.0
Convert one or many MS Excel files to CSV files. Excel 2000 or higher required.

Excel Remove Error Cells In Multiple Files Software 7)   Excel Remove Error Cells In Multiple Files Software 7.0
Delete cells with #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, and #NULL!.