|
More tags: excel add-in, spreadsheet, lookup, interpolation, curve fitting,
|
Category : |
Business - Spreadsheets |
|
|
|
Platform : |
MAC 68k, Mac PPC |
|
|
Price : |
USD 20 |
|
|
Developer: |
|
|
|
Rating : |
|
|
|
License : |
Shareware |
|
|
Limitations: |
30 Days |
|
|
Date : |
06/02/2004 |
|
|
Size : |
0.77 MB |
|
|
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.
Learn Windows Programming by WAGmobShop Plush BoutiqueSnow Cone Machine LiteGPS Wake Up CallВЕСЁЛЫЙ ПОВАР МОЕ ДЕТСТВОCassidy SongBook
|
|
Also See
1)
XPPort
XPPort(TM) ports Microsoft(R) Excel data to PowerPoint(R). A proven Excel add-in that views as a toolbar for use with all your spreadsheets and charts. When you are ready to convert Excel data to Powe...
License:Shareware USD 19.00
Size:0.78 MB
2)
Tax Assistant for Excel
Tax Assistant for Excel is a custom application written for Microsoft Excel and requires Microsoft Excel 97/2000/XP/2003/2007 or higher. It simplifies your Federal Income Tax preparation by providing ...
License:Shareware USD 14.95
Size:4.97 MB
3)
4TOPS Excel Import to Access XP/03
4TOPS Excel Import Assistant is an Access add-in for importing excel into access in a controlled way. Instead of entering data one by one from a spreadsheet or another source that can be converted int...
License:Shareware USD 99
Size:1.86 MB
excel to access, import, export, ms access, access, excel, convert excel to access,
4)
Shift Scheduler for Excel
Shift Scheduler is a Microsoft Excel spreadsheet that creates employee schedules, and tracks the number of hours that have been scheduled. It's perfect for small businesses or departments where the ma...
License:Demo USD 29.99
Size:0.02 MB
|
1)
Waha Transformer Lite
Customer data, sales data, order data, classification data, sales results, budget administration, various testing data, questionarie tabulation, etc. Transforms data to fit your needs while simplifyin...
License:Demo USD 99.95
Size:15.71 MB
2)
ChequePRO Cheque Printing Writing System
The ChequePRO (Cheque Printing writing Software) program helps you to print on any bank cheque, and manage your customer and bank information pro actively. ChequePRO does not only print on to a bank c...
License:Shareware USD 50
Size:8.84 MB
3)
Effective Meetings
What are you talking about? Ever find yourself in meetings that have no purpose? Ever find yourself in meetings where there's no agenda, no record of what's being discussed and nobody seems to be acco...
License:Shareware USD 39
Size:2.50 MB
effective meetings,
4)
Biometric Handpunch Manager Professional
Biometric Handpunch Manager allows you to manage all of your Handpunch devices in seconds. Backup, Restore, Synchronize, Date and Time Setup, Bell Schedules, Device Calibration, User Enrollment and Tr...
License:Shareware USD 99.99
Size:3.26 MB
5)
Estalo Converter for Palm
The contact with different measure units in the technical area and the need of converting values in several currencies in the commercial area are some of the needs in a globalized world. Estalo Conver...
License:Freeware
Size:3.93 MB
6)
AutoTyping Pro Edition
The Easiest Way to Speed Typing and Avoid Spelling Errors. AutoTyping speeds up your typing by display suggested words and phrases in a pop-up list window. You only need to input part of the word or p...
License:Shareware USD 39.98
Size:1.62 MB
7)
Parsnips
If you are like most people, you constantly come across useful bits of information throughout the day while using your computer. It may come from a web site, e-mail, chat sessions, usenet news article...
License:Shareware USD 27
Size:1.07 MB
8)
Bifrost Inventory Management
Bifrost Inventory Management is an easy-to-use tool. The user-friendly interface let you easily and quickly organize your household possessions. Bifrost Inventory Management record and store the detai...
License:Shareware USD 29.95
Size:2.05 MB
9)
Habil Software GRATUITO de Controle Financeiro
Mais de 3.9 milhoes de copias distribuidas. Sem custo de aquisicao, sem custo de manutencao, sem custo de atualizacao, totalmente gratuito. Contas a pagar e a receber, controle bancario, controle do c...
License:Freeware USD 0
Size:2.19 MB
10)
BusinessCards MX
This program will help to design and print a professional business card. The interface of the program has been designed in such a way that even a beginning user will not have problems with using the p...
License:Shareware USD 29.95
Size:62.65 MB
Tags: software, program, creator, maker, business, templates, template, designer
|
|
More tags: excel add-in, spreadsheet, lookup, interpolation, curve fitting,
|
|