|
|
| Excel add-in with eleven powerful worksheet functions for 1, 2 and 3 variable lookup and interpolation (closest-value, linear, piecewise parabolic or hyperbolic, cubic spline) and polynomial curve fitting. Includes online help and example workbooks. |
|
| Updated |
Jul 6, 2004 19:09:31 | | Size | 758 kb | | Licence | Shareware | | Status | New Release | | Languages | English | | Tags | Excel add-in, spreadsheet, lookup, interpolation, curve fitting | | OS | Mac OS | | Homepage | trimill.com | | Email | info@trimill.com | | Author | Branko Stojkovic |
|
|
 click for full size
|
| Other author's software: | - TriLookup 2.21 — Excel add-in with eleven powerful worksheet functions for 1, 2 and 3 variable lookup and interpolation (closest-value, linear, piecewise parabolic or hyperbolic, cubic spline) and polynomial curve fitting. Includes online help and example workbooks.
| | Show all author's software |
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. | Short tags:
Excel add-in, spreadsheet, lookup, interpolation, curve fitting | System Requirements:
Excel 98, 2001, X or 2008 | Change Info:
First Macintosh release | |
| | Freeware alternatives TriLookup Mac 2.2 |
|  Free Download TriLookup Mac 2.2 from trimill.com |
| Similar software shotlights: | - Visual Fitting 2.11 — Math tool for linear, nonlinear curve fitting and surface fitting, curve and surface can be created. Math tool for linear, nonlinear curve fitting and surface fitting. 1. Implement curve fitting and…
| | Find all software similar on TriLookup Mac 2.2 |
| Similar smart reviews: | - Excel Workbook Splitter 1.05, Fastest And Easiest Way — Trends in today’s software industry have brought us many monster-like huge «suites». In fact, «multifeatured and universal software suites» take any niche where enough users can be found. It is not that bad, these suites are typically really useful and pleasant to use, but they don’t suit many situations, when you need to do one easy operation but many times…
- Excel Merge Tool: Few Clicks that Save Hours — Merging a report out of a multitude of Excel spreadsheets is quite a challenge. Although data from a couple of spreadsheets could be merged by hand, with the copy/paste command and a bit of patience, merging data from a few dozens or hundreds of tables requires totally different approaches. Excel Merge Tool provides the functionality you need to merge…
- Easy Adder 1.7.3, It's All About Communication — The new age of Web, with its social services, had extended ways of communication far beyond usual e-mail/IM measures. Social services like MySpace have introduced a very important concept of a «friend», which, despite its name, means a completely new thing in the world. This concept with related actions (like «Add as a friend») alongside is a completely new method…
- Perspector Professional Edition – add a new exciting dimension to your presentations! — PowerPoint presentations containing text and graphics are the most popular method of delivering complex business and scientific messages to audiences. However, excessive use of bulleted lists and plain charts may diminish the effect you intend to produce with your presentation. In hectic business environments, people want to grasp the essence of your message as soon as possible and not waste time…
- AlphaControls - adding fashion to your applications has never been easier — As a developer, you should be primarily concerned with the functionality of your application and its stability in different conditions. As a smart developer, you should also be concerned with the appearance of your products. This important factor often becomes the final incentive that makes people choose a specific product among dozens of identical ones. Therefore, creating applications with…
- AutoDirector - an easy way to add a car showroom to your website — A good online car catalog should possess several important characteristics — intuitive navigation, short loading times, ease of support and maintenance and completeness of product information. If you are building a car rental or sales website for your own company or your client, you can choose to build this module on your own or opt for an available third-party application…
- Real Desktop Light - add a new dimension to a familiar OS interface — As a computer enthusiast, you must have tried all kinds of operating systems, interface add-ons and themes — from Vista’s Aero Glass to its various Linux counterparts. However, if you are looking for something totally different that would give you a new way of managing your documents and files, you should definitely check out Real Desktop Light! Real Desktop Light is a free…
- Bluff Titler DX9 - an easy way to add impressive 3D titles to your videos — If you use your camcorder a lot to make movies about your family, parties, vacations and other memorable events and have lots of great footage waiting to be edited and added to your collection, you must be looking for a way to exercise your creativity and add a couple of cool things to your home-made films. Every movie starts with an introduction of some soft…
- CD-Cover Editor 3.0 - the simplest way of adding style to your CD or DVD collection — If you start burning at least several disks each month, you will enter the next year with an impressive stack of CD’s and DVD’s containing music, movies, backups and other data. If you don’t label each and every of them properly, finding the necessary compilation will be more than difficult. Apparently, a magic marker can help, but not too much. If you are seeking…
| | Find all smart reviews similar on TriLookup Mac 2.2 |
|
