TriLookup
Details
| Size: | 1.04MB |
| Last Update: | 2007-11-30 10:24:30 |
| Version: | 2.2 |
| OS Support: | Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000 |
| License/Program Type: | Shareware |
| Publisher: | Trimill Industrial Systems Inc. |
| Price: | $20.00 |
Description:
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.System requirements:Excel 97, 2000, XP or
2003
Awarded High Quality program
0 comments
Add to
TriLookup Version History
Related Software
|
|
From category: Components-and-Libraries |
| Aspose.Office is a product suite including all individual products:Aspose.Excel, Aspose.Word, Aspose.PowerPoint, Aspose.Project. If you need more than one product, you&039;re strongly recommended to... |
|
|
From category: Components-and-Libraries |
| Our PDF417 Win32 DLL can create device independent 2D barcode image for your applications, you can save the barcode as either BMP or WMF image file or copy barcode WMF image to clipboard.... |
|
|
From category: Development-Kits |
| Style Master is an easy to use CSS editor combining WYSIWYG editors with hand coding. Internal previewing, wizards, templates, validation, integrated browser support and cascading style sheet info mak... |
|
|
From category: Compilers |
| Vbs2Exe is an application that allows you to protect your script and batch files by compiling them to standalone windows executables.... |
|
|
From category: Development-Kits |
| DNC or file transfer between computer and CNC Control. You can use ConnectCNC for any number of machines, and simultaneous transfer or DNC capability is limited only by the number of COM ports on your... |
|
|
From category: Databases |
| Do you need to move data from one database to another?Do you want to validate and clean key information?Do you want to export data to send to customers?Are you fed up with re-keying data?DataSlave is... |
|
|
From category: Components-and-Libraries |
| ZylCPUUsage is a visual Delphi component that diplays the usage level of the processor in a chart.... |
|
|
From category: Debugging |
| XSL-FO Debugger is the software for visual debugging of XSL stylesheets. In short, XSL-FO Debugger takes an XSL-FO file as an input, follows XSL-FO formatting instructions and generates a PDF document... |
|
|
From category: ActiveX |
| Active Metadata is an ActiveX component to get and set additional image information. Usually these includes copyright, digital camera model, or program by which this image is made. Also you can get cr... |
|
|
From category: Installation-Builders |
| Agentix Installer is a development tool that creates Windows compatible software installers. It has the advanced set of features such as multilanguage support, .NET applications support, files compres... |
|
|
From category: Development-Kits |
| Avral Tramigo is a friendly localization solution for Macromedia Flash MX professionals and translators. It allows you to translate Flash MX SWF into foreign languages in three simple steps:
Extract... |
|
|
From category: Databases |
| Deploy new releases of your Microsoft Access applications to workstations automatically. Take control of version management via a server based console. Update workstations with one click saving time a... |
|
|
From category: Components-and-Libraries |
| The Magi Systems Network Library is a 100% Java-based network library that can be used asthe foundation of a network based Java application, where there is a central multi-threaded server and multiple... |
|
|
From category: File-Editors |
| With WebmateX you can be up and trading on the Web TODAY. No previous knowledge of HTML, scripting or programming is required. WebmateX automates the process of designing and running really cool web s... |
|
|
From category: Packers-Crypters-and-Protectors |
| The Cyber Software Development Kit (SDK) spreadsheet type active-X grid plug-in contains dbgrid & navigator actveX controls for developers using Visual C++ or Visual Basic that need more out of a cont... |
Leave a comment