Excel 外接程序具有 11 个强大的工作表函数，用于 1、2 和 3 个变量查找和插值。插值模式包括：最接近值、线性、分片抛物线或双曲、立方样条和多项式，最多为第 20 阶。这些函数还可以处理包含缺失和无效数据的表。 包括通过一组 X-Y 数据点拟合多项式曲线的函数，并返回多项式曲线系数表，以及确定最佳拟合多项式曲线。 如果出现错误，TriLookup 函数可以返回标准 Excel 错误代码或详细的文本错误消息，指示错误的性质并指向错误的原因。 包括联机帮助和示例工作簿。需要 Microsoft Excel （32 位） 97、2000、XP、2003、2007 或 2010 （Windows） 或 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.22 发布于 2012-05-15
软件信息
- 软件分类： 业务 > 数学与科学工具
- 发布者： Trimill Industrial Systems Inc.
- 许可： 免费试用
- 价格： $20.00
- 版本： 2.22
- 适用平台： windows
终端用户许可协议
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. 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-2012 Trimill Industrial Systems Inc., All rights Reserved.