PC Soft Land>Business>Spreadsheets

TriLookup Mac

Categories

  Publisher: Trimill Industrial Systems Inc.
Support Email: info@trimill.com
License: Shareware
Price($): 20
OS: MAC 68K,MAC PPC
File Size(KB): 777
Version: 2.2
Last Update: June 02 04
Rating: 4 stars rating
Screenshot: Preview
Download Now  Buy now
Publisher's 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.

กก

Visit TriLookup Mac Home Page

กก

Related Products:
TriLookup - Advanced 1, 2 and 3 variable look-up and interpolation functions for Excel.

Excel Join (Merge, Match) Two Tables Software - Merge / combine two tables based on a common column.

Excel Typos Finder - Aren't you sick and tired of typos? Kill typos in your Excel workbooks!

Synkronizer - Synkronizer compares, updates and synchronizes Excel spreadsheets.

Advanced Excel Find - Easy and fast search through multiple worksheets and workbooks in Excel.

Advanced Excel Select - An Excel tool that enriches the built-in Special Cells dialog.

Multiple Regression Analysis and Forecasting - Producing statistically sound value driver identification for forecasting data

Excel Macro Processor - Apply Microsoft Excel macros to a lot of documents with this automation tool.

ADX Toys for Microsoft Excel - Is a COM add-in that adds several useful features to Microsoft Excel

Color Palette Professional - Bring life, color and style to your Excel charts and reports.


Search similar software using these keywords: Excel add-in, spreadsheet, lookup, interpolation, curve fitting, TriLookup Mac 
 
Web www.pcsoftland.com

What I'm Interested In?
advanced excel lookup sort on a spreadsheets excel search worksheets professional looking excel charts excel macro interpolate excel lookup macro excel macros excel search multiple worksheets excel multiple regression analysis 3 variable regression excel how to create a schedule in excel excel find search excel color palette excel schedules advanced excel macro schedules in excel searching for multiple values in excel create class schedule class schedule excel regression analysis in excel duplicates excel freeware currency converter formula macro excel find multiple regression tools excel macro automation excel multiple find macro processor multiple regression business excel multiple regression typos list
Submit a file | Link to us | About us

Copyright 2004 PC Soft Land Inc. All Rights Reserved.