Windows Software / Business

TriLookup 2.21

Date Added: October 27, 2009 | Visits: 7.157

Full screenshot

Report Broken Link
Printer Friendly Version
Order Now

Product Homepage
Download (626 downloads)

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: No special requirements

Release Date: June 02, 2004

Platforms: Windows 95, Windows 98, Windows Me, Windows NT 4.x, Windows 2000, Windows XP, Windows 2003, Windows Vista Starter, Windows Vista Home Basic, Windows Vista Home Premium, Windows Vista Business, Windows Vista Enterprise, Windows Vista Ultimate, Windows Vista Home Basic x64, Windows Vista Home Premium x64, Windows Vista Business x64, Windows Vista Enterprise x64, Windows Vista Ultimate x64

Keyword: Curve Fitting, Excel Add-in, Interpolation, Lookup, Spreadsheet

Version 2.21 Changes: Excel 2007 install

Users rating: 0/10

License: Shareware

Cost: $20.00 USD

Size: 1.02 MB

USER REVIEWS

More Reviews or Write Review

TRILOOKUP RELATED

Vertical Markets - MyRouteOnline Excel Add-in Route Planner 1.1 MyRouteOnline is an easy to use route planner that that allows you to plan routes from Excel spreadsheet. Excel Add-in that uploads addresses and saves time, fuel and money by helping you map multiple locations and find the best route. Online...	3.11 MB
MP3 Tools - PlusX Excel Add-In 1.2 PlusX Excel Add-In is a 100% free and 100% safe addition to Excel, shown as a new tab on the standart menu. The application has several groups of functionality: Charts , Shortcuts , Rates and Browser. It enables the user to create 5 addititonal...	974 KB
Database Tools - Excel Add-in for Oracle 2.5 Devart Excel Add-in for Oracle allows you to use powerful Excel capabilities for processing and analysis of data from Oracle database, edit external data as usual excel spreadsheets and save data changes back to Oracle database Key Features:...	5.1 MB
Spreadsheets - Data Curve Fit Creator Add-in 2.80 Data Curve Fit Creator Add-in is an easy-to-use data analysis add-in for Microsoft Excel. It adds curve fitting, interpolation, and data smoothing functions to Excel. Curve fitting functions include polynomial fits and a versatile local...	7.12 MB
MP3 Tools - OfficeTent Excel Add-in 2.0 Bookmark,Add a bookmark in the current cell. When you want to return, then easy to click on the "Previous Bookmark" to the cell referred to the bookmark. Find & Replace Plus,More than 40+ types condition settings for find and replace. The default...	3.92 MB
MP3 Tools - Barcode Word/Excel Add-In TBarCode Office 10.5.5 BARCODE ADD-IN FOR MICROSOFT OFFICE 2007/2010/2013 TBarCode Office is a powerful barcode add-in for Microsoft Word and Excel (2007/2010/2013). Creating barcode lists, barcode documents and barcode serial letters has never been easier!...	12.79 MB
MP3 Tools - Barcode Word/Excel Add-In TBarCode Officeac 10.5.2 BARCODE ADD-IN FOR MICROSOFT OFFICE 2007/2010/2013 TBarCode Office is a powerful barcode add-in for Microsoft Word and Excel (2007/2010/2013). Creating barcode lists, barcode documents and barcode serial letters has never been easier!...	12.63 MB
Development Tools - Ideal Rankine Cycle Excel Add-In 1.0 This demo uses MATLAB Builder for Excel to create an Excel Add-In from a MATLAB function rankine.m. The spreadsheet uses the Add-In to compute the thermodynamic properties of an Ideal Rankine cycle.Two points of interest to this demo are the use...	1013.76 KB
MP3 Tools - Excel Add-in for SQL Server 1.1 Devart Excel Add-in for SQL Server allows you to use powerful Excel capabilities for processing and analysis of data from SQL Server or SQL Azure, edit external data as usual excel spreadsheets and save data changes back to SQL Server database....	3.92 MB
MP3 Tools - Excel Add-in for MySQL 1.1 Devart Excel Add-in for MySQL allows you to use powerful Excel capabilities for processing and analysis of data from MySQL or MariaDB, edit external data as usual excel spreadsheets and save data changes back to the data source Key Features:...	3.92 MB

NEW DOWNLOADS IN WINDOWS SOFTWARE, BUSINESS

Windows Software - AnyGo 7.2.0 AnyGo offers you 5 modes namely Teleport Mode, Two-Spot Route, Multi-Spot Route, Joystick Mode, and importing GPX routes to change your location or simulate the movement of your GPS easily. You can connect different iOS/Android devices to the same...	136.13 MB
Windows Software - FonesGo Location Changer 7.2.0 FonesGo Location Changer is your best friend for GPS-based games and apps that work on both iOS and Android devices. This powerful software can instantly change your GPS location without the need to jailbreak your iPhone or root your Android...	101.09 MB
Windows Software - WonderFox DVD Ripper Speedy 23.0 Decrypt CSS and Region Code Protections Commonly purchased DVD (Movie, TV show, tutorial, etc.) has one or more copy protection to avoid copying DVD content from DVD disk. There are some popular DVD encryption technologies including CSS,...	53.45 MB
Windows Software - TunesKit Activation Unlocker for Windows 1.2.0 Don't know how to bypass iCloud Activation lock on iPhone? Or Don't know how to turn off the Find My iPhone feature without entering the passcode? Now, you can use the newly released and professional iCloud Activation lock to save your iCloud...	13 B
Windows Software - eSoftTools Excel to ICS Converter 2.5 Try eSoftTools Excel to ICS Converter software for quick Excel to ICS file conversion. Using this tool, convert Excel files with calendar records to ICS and many other file types. Make this conversion process faster and more accurate with its...	6.34 MB
Business - Aml Assist 3.60 What is Aml Assist Aml Assist is a popular plug-in for Aml Pages that provides a lot of routines in more suitable ways. And quite a long ago, by users demands, its been included in official Aml Pages distributive. Aml Pages plug-in renders on a...	278.43 KB
Business - Aml Pages Spanish Version 9.99b2950 Aml Pages is tree-structured notes manager for Windows. It contains all your notes, information, web pages, passwords, URL-address in the form of a tree, so you can quickly find what you need. Manage megatons of your notes with ease at work and at...	4.68 MB
Business - Aml Pages Polish Version 9.99b2950 Aml Pages is tree-structured notes manager for Windows. It contains all your notes, information, web pages, passwords, URL-address in the form of a tree, so you can quickly find what you need. Manage megatons of your notes with ease at work and at...	4.75 MB
Business - Aml Pages French Version 9.99b2950 Aml Pages is a feature-rich application developed for managing documents, web pages, notes, passwords and other important information in a single place. A somewhat crowded but quite functional user interface The interface is represented by...	4.73 MB
Business - Doxillion Plus Edition 10.00 Doxillion is a PDF converter to convert docx, doc, rtf, html, xml, wpd, odt, txt and other text file formats. Convert a single file or batch convert several PDFs at a time. Easily add Doxillion to your right click menu to add fast and simple...	2.79 MB

Windows Software	BeOS Software
Macintosh Software	Linux Software
PDA Software	OS/2 Software
Mobile Software	Scripts