After a year of struggling on how to organize my components I have finally figured out my solution and I am mostly done implementing it. I used to keep the parts in the bags as they shipped, and felt it was messy and it was a pain rumaging through the retailer bags to find something that could fit the need. I knew I had stuff, but was hard to find and even harder to figure out what would be the best part choice out of what I had.
At some point, I got a couple of Akro-mils organizers, with a mix of small and double size drawers and started to place stuff on them. It worked well for a lot of the eBay purchased items, like headers, small mechanical parts... but it became obvious it would not solve the retailers (Mouser, e14..) bags problem without re-bagging.
I also gave a try to test tubes, but soon decided they were not the thing for me. On the other hand, I have found the Chinese "Sample" handbooks to be a good solution for SMD resistors.
For the low cost TH resistor sets, 1/8W and 1/4W, I started organizing each decade to a drawer, but they where taking 12 mostly empty double drawers and moved to place three decades per drawer. Keeping them ordered by value makes it easy to access the desired (or closest) value.
I got to the conclusion that I needed to keep some kind of inventory record and decided EXCEL was the simplest solution. Getting down to it, I created one worksheet for main component types (diodes, transistors, capacitors...) with columns like part number(w/datasheet hyperlink), package, voltage, current, power, unit cost, etc... I included my own 4-char SKU column. I loaded the parts from the vendor invoices.
With that done, I was confronted with printing labels from the worksheets. I took my wife's Brother label printer (P-Touch PT-2730) . I downloaded the P-Touch software from Brother, trying to print directly from EXCEL worksheets. Then I found that the existing plugin for EXCEL does not work on 64bits. I resolved to write a VBA macro to generate formatted CSV from the worksheets. It allows me to print different label formats by component class.
I did not include the cheap TH resistor sets in the inventory. I decided "file-cabinet_search" was good enough.
With the process mostly completed, I find it very convenient to browse the EXCEL for parts, access datasheets for research and locate parts easily.
The pictures (here and next post) show how it looks.