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

TriLookup 2.2 - Free Download

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.

	Size	1040KB
	License	Shareware
	Price	20
	Category	Business & Finance / Spreadsheets
	Operating System	Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000
	Developer	Trimill Industrial Systems Inc.
	Download link

Related keywords: Excel add-in, spreadsheet, lookup, interpolation, curve fitting,

Top Business & Finance / Spreadsheets softs

1) Excel Unique & Duplicate Data Remover 1.1
Search and delete duplicate and unique entries, values, cells, records, rows, numbers in any list or selection with this Excel Addin. Finding and removing duplicates and uniques will save you hours of tedious work.
License:Shareware, $19.82 to buy Size: 383KB

2) Excel List Compare 1
This useful Excel macro will compare rows in 2 lists of data based on 1 to 3 columns in each list. Creates a new spreadsheet with matched rows from original 2 lists merged together on the same row and unmatched rows highlighted on seperate rows.
License:Freeware, $0 to buy Size: 48KB

3) Profit Loss Report Spreadsheet 3.2
Award-winning Excel spreadsheet is a simple alternative to accounting software for a small business to track income and expenses. Easier for you and tax preparer when tax time rolls around. Save time, money and tax time headaches. Requires MS Excel.
License:Demo, $19.95 to buy Size: 432KB

4) Financial Analysis - standard 2.17
Financial Analysis is a software product that even in it`s basic standard edition offers great possibilities for evaluating business or portfolio performances. This easy to use program gives you results rich in numerical and graphic presentation.
License:Demo, $98 to buy Size: 3712KB

5) Mobile Database Viewer(Access,xls,Oracle)for S60 1.5
View Access,FoxPro,dBase,Excel.Oracle and any ODBC enable Database on S60 mobile phone like Nokia 7650,3650 .View database tables: all at a time or record at a time. View all at a time or record at a time.Support of Search records:
License:Shareware, $14.95 to buy Size: 635KB

6) Barcode ActiveX - 2D Barcode PDF417 by Wolf Software 1.5
2D Barcode PDF417 ActiveX Control creates the 2 D code PDF417. Price includes royalty-free redistribution.
License:Shareware, $99 to buy Size: 5000KB

7) Employee Scheduler for Excel and OpenOffice 2.1
The Employee Scheduler is an affordable spreadsheet to help you schedule hourly employees and manage your labor costs as a percentage of sales. (Requires Microsoft Excel or OpenOffice to run).
License:Demo, $29.99 to buy Size: 65000KB

8) United States ZIP Code Database (Gold + Multi-County Edition) December 2007
United States ZIP codes database subscription includes ZIP code, city name, alias name, state code, phone area code, city type, county name, FIPS, time zone, day light saving flag, latitude, longitude, elevation, MSA, PMSA, CBSA and Census 2000 data.
License:Commercial, $99.95 to buy Size: 306KB

9) Excel Backup File Save Scheduler 1.1
Automatically create backup save copies of your Excel files while you work. You set the how often to save, where to save, and what file name to use. This Excel Add-in resides within Excel making usage simple.
License:Shareware, $19.82 to buy Size: 430KB

10) Excel to MySQL Import, Export & Convert 1.2
Connect Excel to your MySQL database. This Excel Add-in allows you to import and export tables to (and from) MySQL while you work in Excel. No SQL query knowledge needed.
License:Shareware, $19.82 to buy Size: 5832KB

New Business & Finance / Spreadsheets softs

1) United States ZIP Code Database (Gold + Multi-County Edition) December 2007
United States ZIP codes database subscription includes ZIP code, city name, alias name, state code, phone area code, city type, county name, FIPS, time zone, day light saving flag, latitude, longitude, elevation, MSA, PMSA, CBSA and Census 2000 data.
License:Commercial, $99.95 to buy Size: 306KB

2) Unit Converter for Excel 3.1
Unit Converter for Excel is an addin for the Microsoft Excel to perform various conversions between many types of measurement units.
License:Shareware, $24 to buy Size: 1048KB

3) Worksheet Search 2.0.1
Worksheet search and activation add-in for Microsoft Excel. Worksheet search integrates into the Excel toolbar and adds fast worksheet search using sheet name or a wildcard.
License:Shareware, $5.55 to buy Size: 924KB

4) DoneEx XCell Compiler 1.7.1
Compile XLS to EXE application (which requires MS Excel to run) with securely hidden formulas. Main features:protect EXE with regkey; set limit of work period for EXE file; save/load changed data; apply your own image as a splash screen; and more.
License:Shareware, $49.00 to buy Size: 2860KB

5) GeoDataSource World Structural Features Database (Basic Edition) November 2007
GeoDataSource World Structural Database Basic Edition contains structural feature names in original language and English, feature type classifications, country names in FIPS and ISO, regions and sub-regions. Database available in text format.
License:Data Only, $699.95 to buy Size: 37KB

6) Insta-Graph 1.0
Graph cell values automatically and instantly by selecting a range in Excel.
License:Shareware, $47.97 to buy Size: 9530KB

7) ReplaceMagic ExcelOnly Standard 1.8.2
Have you ever been in situation that you need to change text, header, footer, comments, OLE object links, hyperlinks or even more in thousands of files and you had to open each file manually to make changes? With ReplaceMagic that is very simple.
License:Shareware, $62 to buy Size: 2068KB

8) ReplaceMagic ExcelOnly Professional 1.8.2
Have you ever been in situation that you need to change text, header, footer, comments, OLE object links, hyperlinks or even more in thousands of files and you had to open each file manually to make changes? With ReplaceMagic that is very simple.
License:Shareware, $125 to buy Size: 2069KB

9) North American Area Code Database (Gold Edition) October - December 2007
North American area codes database one month subscription service. The database includes NPA (area code), NXX (exchange), country, state, county, latitude, longitude, LATA, timezone, day light saving, population, FIPS, MSA, PMSA, CBSA and ZIP code.
License:Data Only, $299.95 to buy Size: 25KB

10) Invoice - Billing software 6.2
Invoice Organizer Pro is a flexible invoicing and billing software for all professionals such as lawyers, artists, constructors, developers, consultants, field experts, designers, architects, accountants, programmers, consultants, landscapers.
License:Shareware, $195 to buy Size: 10301KB