|The program described on this page is obsolete and has been re-written and available for download here.|
Using Excel for Boat Inventory
|As part of a project initiated on the Pearson 424 Owners maillist I developed an inventory workbook to keep track of all of the items and pieces of equipment we bring on our boats and then promptly lose because we can't remember in which locker we put those items. There are several forms of the workbook to accommodate the various cabin layouts that were used by Pearson on the 424. Three versions of the workbook are available below for download. Click on the links to download the workbooks. The latest version of this application is 2.8. Links to User Documentation are provided at the bottom of this page.|
|I have begun development on the integration of the Inventory workbook with the Maintenance Log workbook application. This initial effort has been released as InventoryMaint workbook version 3.02. That application can be downloaded from the documentation page on this workbook at Integrating the Inventory & Maintenance Workbooks. With the implementation of this integration workbook I will no longer update the individual Inventory and Maintenance applications. Version 2.8 is the final release for the Inventory application. Future Inventory updates will be released through the integrated application. I have removed the download links (other than Sarah's Inventory) below because I've made many changes to the Inventory application since version 2.8. The integrated application can be downloaded from here. This page and those linked to it will remain as documentation. The documentation will be updated to the current version ASAP.|
|This workbook is intended to be customized by each user to their boat layout and their inventory needs. All of the tables used by the program can be added to, modified or removed based on a given boat's configuration without having to modify the underlying Visual Basic for Applications (VBA) code. However the boat layout diagrams in each of these workbooks is specific to the Pearson 424 and would have to be significantly modified to for any other model sailboat (including others from Pearson). These diagrams were developed by another P424 owner, Cada Grove, using MS PowerPoint. Pete Dubler transferred the diagram and the locker identification to an Excel spreadsheet, and then I got hold of it. MS PowerPoint has a limited by fairly easy to use drawing facility, but other packages could be used to produce a suitable layout diagram for a different sailboat. The workbook application doesn't depend on this diagram. It's main benefit is to provide a visual cross-reference between the physical storage spaces on the boat and the locker IDs used by the workbook. If you would like to modify one of the drawings to conform to your boats storage configuration, the PowerPoint files can be downloaded from here.|
|The Inventory application is made up of six user forms that are opened via a small CommandBar that is placed in the Excel workspace when the workbook is opened. The user forms are identified below.|
you first open the workbook it will display the Layout sheet and a
small CommandBar (Red Ellipse in the screen on the left) will appear on the workbook. This CommandBar
(shown on the right) consist of 6 buttons that activate each of the forms
that provide the workbook's functionality.
You can leave it floating over the workbook, but it is usually more convenient drag the bar onto the Excel toolbar at the top of the screen (Red Arrow) using the mouse.
Someday I may attempt to automatically place this CommandBar in the Excel Toolbar, but for now I'll just let the user decide where it should be located.
this screen the Inventory CommandBar has been placed on the second
row of Toolbars in my Excel.
the CommandBar is moved to the Toolbar its appearance changes to
that shown on the right. You may have more or less
toolbars in your Excel and the Inventory CommandBar may be placed
This image of the CommandBar can be used to navigate throughout this documentation. To go to the documentation page on each of the CommandBar buttons just click on the button in the image where every it appears on these pages.
The CommandBar exists only while the Inventory workbook is open. When you close the Inventory Workbook the CommandBar is removed.
If the Inventory workbook is prevented from closing normally (program error in the inventory software, Excel abort, etc.) the ComandBar may be left on your Excel Toolbar. It will not do any harm and can be easily removed by opening the Inventory workbook then closing it normally. The other way to remove this CommandBar is to use the Tools/Customize Excel menu item to delete the Inventory toolbar.
|With version 2.9 the new CommandBar is automatically docked at the bottom of the Excel screen.|
|I have written several pages documenting how to use the Inventory workbook. Those pages are listed and linked below. This documentation is current to version 2.4 (2.5 for the Enter/Edit forms, 2.9 for the Save and Category forms).|