IRR, ROI, IRRDATE
Fuel Tax 4.0 available for Download
|Spinnaker Data Base Tools is a compilation of
add-ins below that we have developed over the years. Most of
add-ins originated from custom projects and repeated questions in the Excel newsgroups. Filters, Merges, Functions, and Prints
were developed partly as a response to accommodate ex-Lotus123
users. This set that comprises all add-ins described below, plus
enhancements, costs $90.00 (Enhanced Features
Exclusively in DB Tools). The prices for the individual
add-ins range between $15.00 and $30.00 and would total $170.00.
version 2.67 size 601 KB
- Spinnaker Screens
sets your screen options (i.e. scrollbars, gridlines, sheet tabs, etc.) in a snap.
It also organizes your Spinnaker DB Add-ins toolbar and
assists you when you are ready to register the suite. Price: no
- Spinnaker Columns quickly and
easily moves, deletes, hides and unhides columns in your spreadsheet.
- Spinnaker Extracts copies data from multiple sheets
from multiple workbooks to a different or new workbook based on one search
criterion. This greatly facilitates the editing of the original data. Price:
- Spinnaker Filters will make it very easy for you to apply complex
data filters to any database you can open in Excel and you can save the
filter profiles you develop for later use too! Price: $30.00
- Spinnaker Functions features an optional set of D-functions (i.e.
DCOUNT, DMIN, DMAX, DAVERAGE, etc.). The big difference between these
functions and the Excel functions is that they allow you to specify the
criteria in the function instead of an external range. Spinnaker Functions
provides 4 extra logical functions and 4 "checkdigit" functions.
- Spinnaker Merges combines data
from multiple excel data tables based on a single matching
field between one (Master)file and one or more (Source)files. Example: If
you have names and addresses in one workbook, and names with phone
numbers in another workbook, you can quickly add a field of phone
numbers to the first list, or vice versa. Price: $25.00
- Spinnaker Prints allows you to make multi range and multi section prints
on one page otherwise hard to make in Excel. Price: $15.00
- Spinnaker Strings features an easy to use concatenation and
text to columns feature along with a choice of 16 String modification
procedures. If you do a lot of text modifications in Excel you should give
this add-in a try. Price: $25.00
- Enhanced Features available only in
Spinnaker DB Tools:
- You can now easily sort on 6 keys instead of 3 keys
- Concatenate all cells in a range with a separator of your choice
using this function: (SPINCONCATENATE(myrange,separator).
The limitation of this function is 2^31 characters, which is a
string with a length of 2,147,483,648 characters. We didn't test
this limit, but if you create a string longer than that, the
function will let you know with a message box that it can't
calculate the complete string.
Note: Excel can only display up to a certain number of characters
in a cell. When you create very long strings, over 1200 characters,
only part of the string will be visible.
- Conversion functions for distance,
weight, and temperature.
- IRRDATE function.
- You can also easily apply the checkdigit functions (AddCreditCardCheckDigit,
CheckCreditCardNo), and the conversion functions (CELC,
FAHR, FOOT, METRIC, FTDC, FTIN, KILO, LB, LBDC, LBOZ) to a
selection of your choice. This eliminates the need to enter
functions in a new column and copy and paste those values over the
original data, then delete the new column.
- When using the extracts feature, you can now select and
de-select all sheets in the open workbooks at once by clicking on
the "Select All" checkbox.
Tools brings you the complete suite of Spinnaker add-ins to
Microsoft Excel. It's a well-organized collection of solutions
to those nagging shortcomings of your spreadsheets, with an
integrated toolbar interface to keep the components at your
fingertips. You choose only the tools you want and register just
the ones you use. Try Merges to bring data tables together, or
Strings to globally edit text strings. You'll also find Columns
to deal with melding columns and Filters to get just the data
you need out of large workbooks. Prints lets you quickly select
ranges or pages, and Functions adds some powerful new
data-management functions to your command list. Extracts copies
data from multiple lists or databases. Well-written
documentation explains each of the add-ins clearly. Try all of
the tools and register only the ones you keep."
Reviewed on May 29 2000.
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.