Excel 外接程式具有 11 個強大的工作表函數，用於 1、2 和 3 個變數查找和插值。插值模式包括：最接近值、線性、分片拋物線或雙曲、立方樣條和多項式，最多為第 20 階。這些函數還可以處理包含缺失和無效數據的表。 包括通過一組 X-Y 數據點擬合多項式曲線的函數，並返回多項式曲線係數表，以及確定最佳擬合多項式曲線。 如果出現錯誤，TriLookup 函數可以返回標準 Excel 錯誤代碼或詳細的文本錯誤消息，指示錯誤的性質並指向錯誤的原因。 包括聯機説明和示例工作簿。需要 Microsoft Excel 97、2000、XP 或 2003（視窗）或 Excel 98、2001 或 X （Mac）。 TVLOOKUP 和 TVLKP 在多列表中搜索查找列中的查找值，並返回返回列的同一行中的值。可以使用插值和處理缺失值。 THLOOKUP 和 THLKP 在多行表中搜索查找行中的查找值，並返回返回行同一列中的值。可以使用插值和處理缺失值。 T2LOOKUP 和 T2LKP 在 2D （X-Y） 表中搜尋上行中的 X 值和左列中的 Y 值，然後從相交的行和列返回一個值。可以使用插值和處理缺失值。 T3LOOKUP 和 T3LKP 搜索 X、Y 和 Z 值的 3D （X-Y-Z） 表。從相交的行、列和表返回值 V（x，y，z）。可以使用插值和處理缺失值。 TVPOLYDATA 和 THPOLYDATA 計算表中給定的 X-Y 數據點的多項式曲線係數，以指定順序（使用最少平方法）。還要確定最佳擬合曲線。 TPOLY 傳回給定 X 值、多項式順序和多項式曲線係數陣列的多項式曲線的 Y 值。它可以選擇返回衍生工具的值。
版本歷史記錄
- 版本 2.2 發佈於 2004-06-02
第一個麥金托什版本
軟體細節
- 軟體分類： 業務 > 辦公套房和工具
- 發佈者： Trimill Industrial Systems
- 軟體性質： 免費試用
- 價格： $20.00
- 版本： 2.2
- 作業系統： mac
終端使用者許可協定
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 ("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. SHAREWARE VERSION 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! REGISTRATION 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. GENERAL 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 - 2009 Trimill Industrial Systems, All rights Reserved.