Home Add-ins Visual Basic Fuel Tax Contact Us

Spinnaker Data Base Add-ins

Up

 

Screens
Columns
Extracts
Filters
Functions
Merges
Prints
Strings
Sorts
Conversions
IRR, ROI, IRRDATE
 

 

 


My Fuel Tax 4.0 available for Download








Spinnaker Data Base Tools is a compilation of various add-ins below that we have developed over the years. Most of these 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

Microsoft Office Marketplace logo

 

 

ZDNet Rating: 
5 Stars

  • 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 charge. 
  • Spinnaker Columns quickly and easily moves, deletes, hides and unhides columns in your spreadsheet. Price: $15.00
  • 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: $30.00
  • 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. DSUM, DGET, 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 also provides 4 extra logical functions and 4 "checkdigit" functions. Price: $30.00
  • 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, AddLeadingZeroToExpirationDate, AddUPCCheckDigit, 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.

 

ZDNet:

"Spinnaker 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.
Rating 5 Stars

Microsoft and the Office logo are trademarks or registered trademarks of 
Microsoft Corporation in the United States and/or other countries.
  
Please feel free to ask for more Information at: getinfo@spinnakeradd-ins.com