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 (32 Bit) 97, 2000, XP, 2003, 2007 or 2010 (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.
» version 2.22 - posted on 2012-05-15
» version 2.2 - posted on 2004-06-02
EULA - End User License Agreement
TriLookup Software License
YOUR AGREEMENT TO THIS LICENSE
You should carefully read the following terms and conditions before using, installing or distributing this software. Unless you have a different license agreement signed by Trimill Industrial Systems Inc. ("Trimill") your use, distribution, or installation of TriLookup indicates your acceptance of this agreement ("License").
If you do not agree to all of the terms and conditions of this License, then do not copy, install, distribute or use any copy of TriLookup with which this License is included.
You may not alter or modify the TriLookup software in any way, nor give anyone permission to do so. You may not rent, lease, modify, translate, reverse engineer, decompile, disassemble, or create derivative works based on, TriLookup. You may not make access to TriLookup available to others in connection with a service bureau, application service provider, or similar business.
All rights of any kind for TriLookup which are not expressly granted in this License are entirely and exclusively reserved to and by Trimill.
You have the right to test this program for a period of 30 days. You are allowed to copy this Shareware version (and ONLY the Shareware version) and give it to any other person, as long as it is not modified in any way. Under modifications is understood the changing, adding or removing of any files of this package without a written permission from Trimill. You are NOT allowed to pack this program together with a commercial program or a book. Shareware dealers are allowed to sell the Shareware version for a small fee, but it must be clear to the buyer that he/she isn't receiving the full version! The distribution on CD-ROM is also permitted, as long as the original files are not changed in any way. Please contact Trimill if you want to distribute the program with a different installation program, changed files etc.
Use of this software after the trial period of 30 days is in violation of international Copyright law!
This program is neither freeware nor public domain. Use after the 30 day trial period requires registration. The registration fee is only USD 20.- or EUR 20.- or CAD 30.- for a personal license.
REGISTERED VERSION (PERSONAL LICENSE)
The registered version may be installed on as many computers as desired, as long as it is used by only one person at any one time (I.e. one installation at home and one at the office used by the same person). The usage by multiple people at the same time (on multiple computers) requires additional licenses.
ADDITIONAL LICENSES (MULTI-USER LICENSES)
Additional licenses allow an institution, company or school to install the program on multiple computers or on a server. All licenses are issued to the same (company) name, which appears in the About TriLookup dialog. The program must not run on more machines at the same time than there are licenses purchased. Additional licenses cost USD 10.- or EUR 10.- or CAD 15.-for the 2nd to 10th license, etc. For larger amounts than 1000 please contact Trimill. Each additional license also allows a single user to use the program at home.
WARRANTY DISCLAIMERS AND LIABILITY LIMITATIONS
TRILOOKUP, AND ANY AND ALL ACCOMPANYING SOFTWARE, FILES, DATA AND MATERIALS, ARE DISTRIBUTED AND PROVIDED "AS IS" AND WITH NO WARRANTIES OF ANY KIND, WHETHER EXPRESS OR IMPLIED. You acknowledge that good data processing procedure dictates that any program, including TriLookup, must be thoroughly tested with non-critical data before you rely on it, and you hereby assume the entire risk of using the program. THIS DISCLAIMER OF WARRANTY CONSTITUTES AN ESSENTIAL PART OF THIS LICENSE.
ANY LIABILITY OF TRIMILL WILL BE LIMITED EXCLUSIVELY TO REFUND OF REGISTRATION FEE, IF ANY. IN ADDITION, IN NO EVENT SHALL TRIMILL, OR ITS PRINCIPALS, SHAREHOLDERS, OFFICERS, EMPLOYEES, AFFILIATES, CONTRACTORS, SUBSIDIARIES, OR PARENT ORGANIZATIONS, BE LIABLE FOR ANY INDIRECT, INCIDENTAL, CONSEQUENTIAL, OR PUNITIVE DAMAGES WHATSOEVER RELATING TO THE USE OF TRILOOKUP, OR TO YOUR RELATIONSHIP WITH TRIMILL.
IN ADDITION, IN NO EVENT DOES TRIMILL AUTHORIZE YOU TO USE TRILOOKUP IN APPLICATIONS OR SYSTEMS WHERE ITS FAILURE TO PERFORM CAN REASONABLY BE EXPECTED TO RESULT IN A SIGNIFICANT PHYSICAL INJURY, OR IN LOSS OF LIFE. ANY SUCH USE BY YOU IS ENTIRELY AT YOUR OWN RISK, AND YOU AGREE TO HOLD TRIMILL HARMLESS FROM ANY AND ALL CLAIMS OR LOSSES RELATING TO SUCH UNAUTHORIZED USE.
This License is the complete statement of the agreement between the parties on the subject matter, and merges and supersedes all other or prior understandings, purchase orders, agreements and arrangements. This License shall be governed by the laws of the Province of British Columbia, Canada. Exclusive jurisdiction and venue for all matters relating to this License shall be in the courts located in the Province of British Columbia, Canada, and you consent to such jurisdiction and venue. There are no third party beneficiaries of any promises, obligations or representations made by Trimill herein. Any waiver by Trimill of any violation of this License by you shall not constitute or contribute to a waiver of any other or future violation by you of the same provision, or any other provision, of this License.
Copyright © 2003-2012 Trimill Industrial Systems Inc., All rights Reserved.