Google Sheets

The Philosophy of the Shop Battery Organization in a creative space is far more than a tidy aesthetic; it is a vital material science that facilitates the flow of craftsmanship. Dr. Evelyn Reed views the collection of hardware in a shop—numbering into the hundreds of thousands—as a "shop battery." This battery stores potential energy. When an artisan can locate a specific Sortimo bin containing a #4-40 machine screw in seconds, they preserve the momentum of their work. Without a system, the shop becomes a graveyard of lost parts, forcing the maker to abandon the bench for the hardware store, severing the tactile connection to the project at hand. Adam Savage manages a massive collection of approximately 72 to 76 individual cases. Within these bins reside over half a million objects. Managing such volume requires a move away from memory-based retrieval toward a documented, searchable hierarchy. This guide explores the meticulous process of auditing, consolidating, and indexing a hardware collection to ensure that every minute spent in the shop is spent creating, not searching. Tools and Materials Needed To replicate this high-level inventory system, you must gather tools that bridge the physical and digital worlds. The tactile nature of the shop requires physical records, while the complexity of the data demands digital processing. * **Camera or Smartphone**: For visual documentation of every drawer and bin. * **Numbered Markers**: Physical tags (1–76) to place inside bins during photography to ensure every image is tied to a specific location. * **Spreadsheet Software**: Microsoft Excel or Google Sheets for data entry and alphabetical sorting. * **Printer and Toner**: High-quality color prints are essential for the culling and mapping phase. * **Adhesive and Mounting Board**: To display the final printed list prominently in the workspace. * **Clear Packing Tape**: For laminating and protecting the physical list from shop dust and oils. * **Storage Modality**: While Savage Industries uses custom orange Sortimo cases, this system adapts to Dixie cups, cardboard trays, or hardware store cabinets. Step-by-Step Instructions for Hardware Auditing Phase One: The Visual Audit Begin by assigning a permanent number to every drawer or container in your system. Place a physical digit inside the bin and take a clear, top-down photograph. This visual record is the foundation of the entire system. Do not rely on your memory or the digital file name; the number must be visible in the image itself. Once you have photographed all units—in this case, 72 distinct boxes—print them out in color. Physical paper allows for a spatial reasoning that a computer monitor cannot replicate. You can spread the pages across a workbench, seeing the entire "battery" at once. Phase Two: Culling and Confluence Review the printed photos to identify redundancies. In a mature shop, hardware often migrates. You might find wire grommets in bin 11 and strain relief components in bin 40. These are functionally related and should live together. Use your paper prints to mark these moves. Identify "completed" bins—those full of a single hardware type, like rivets—and set them aside. Focus your energy on bins with "real estate," or empty compartments, where you can consolidate disparate categories. This phase requires about six hours of focused attention to move physical parts and update the mapping. Phase Three: The Digital Index Open your spreadsheet software and create two primary columns: Bin Number and Item Name. Create a new row for every category within a bin. If Bin 14 contains wall anchors, self-tapping screws, and shoulder bolts, create three separate rows for Bin 14. To maximize searchability, use redundant naming conventions. A rubber cork should be listed as both "Rubber Cork" and "Cork, Rubber." This ensures that no matter how your brain searches for the item six months from now, the list will provide the answer. Phase Four: Alphabetization and Display Once data entry is complete, use the software’s sort function to organize the entire list alphabetically by the Item Name column. This transforms a location-based list into a functional index. Print the resulting list—which may reach lengths of 50 to 60 inches for a large collection—and mount it to a piece of wood or a cabinet door. Protect the paper with clear tape to ensure its longevity in a working environment. Tips and Troubleshooting One common pitfall is the pursuit of perfection. As Adam Savage notes, "the perfect is the enemy of the good." You will inevitably forget items, such as Pogo pins or specific magnetic connectors. Do not restart the entire process for a single omission. Simply hand-write the addition onto your physical list and update the digital master file for the next printing cycle, which should occur every few months or years as the shop evolves. Another tip involves the "intimacy" of the drawers. Your organizational logic is personal. While some categorize by material (brass vs. stainless), others categorize by function (fastening vs. electrical). The most effective system mirrors your own cognitive map. If you frequently associate buckles with webbing, store them near your textile supplies rather than with general hardware, even if they are technically "metal fasteners." Conclusion: The Reward of Order The final outcome of this rigorous process is a shop that functions as an extension of the artisan's mind. By investing a weekend into photography, culling, and indexing, you eliminate the cognitive load of remembering where 240 different categories of items are hidden. The expected benefit is a significant increase in "bench time" and a reduction in the frustration that kills the creative spirit. A well-indexed shop is a respectful nod to the history of the tools and materials we use, ensuring they are always ready to serve the next act of creation.