How do you manage "on stock" component on your personal lab?

FYI. Most distributors will save your cart if you are logged in. So anytime I realize I am low on parts, I either highlight the row in my spreadsheet or add them to a cart right away. (I really like when they let you name the carts!)

When I remember, I also use the disty's "custom part number" feature to remind myself it is a "STOCK" part. That way, when it shows up randomly on my next order, I have a reminder of why I bought it.

Your (a) method is basically a type of kanban system (from JIT manufacturing). Kanban maintains adequate stock with minimal administrative overhead. I use a modified version of kanban for generic parts - mainly overlaying a more complex decision matrix of when to restock. I don't automatically restock when a low stock level is detected, I decide if I will order immediately or wait until I have a need, based on cost, price breaks and probabilities. 

Your (b) method (database) devolves into a bunch of expedient techniques where some documentation is utilized with built-in search methods, some physical hierarchical organization of bins allows visual physical searches and some pure physical search methods of physical bins. I guess I use all of that for various aspects of my stock to try to minimize the administrative overhead.

shabaz said:

For a home lab, resistor kit books, capacitor kits and so on are great

I don't have any of those, but I think I will buy some in the near future because as you said they are great. Key point is to be sure to always have enough components and to "refill" when runnning low.

I had to think back to when I created this spreadsheet. Originally, I started the spreadsheet as a way to organize what I had. I intended to then create a SQLlite database and import the data.

One of the issues I was concerned about is how different part types have different key characteristics. So, I decided to do separate tabs to understand how I would build the database's schema.

After doing that initial inventory step, I realized the spreadsheet was all I actually wanted. Plus, I didn't have to build any UI since all of the data sorting/analysis tools were already there.

Like many projects, I had all kinda of crazy ideas for how to extend the functionality. And I suppose in the future, I could still move to a small database.

But after committing to this idea for a year, I'd rather solder stuff instead.

It’s not a massive commitment recording mechanism is simple and their location is also recorded.  When I have a project, I do check what I have in-stock and everything else is ordered.  Stuff goes in a project box and once the project is deemed completed, whatever left is then recorded.  I don’t bother recording stuff that gets consumed immediately; I do record, for example, how much heat shrink I used, or wire, connectors etc because these tend to get bought in bulk.  It isn’t a big overhead to keep it up to date, the tedious bit was actually recording my on-hand stuff in the first place.  I suspect it’s that first setup that puts most people off.

There is an online application called PartsBox that looks pretty useful.

Oh, and I treat some generic discrete semiconductors in category (a) too. I've got plastic trays (conductive ones) with little pots, each one can fit quite a lot of (say) SOT-23 parts, which are my favorite size for them. 

I think that in the end I'm doing something similar to your spreadsheet: I find myself mainly using filters too and nothing more. I actually like the additional column with the location of the component and the "sort and label" functionality with numeric value and "human readable" value.

I have them in labelled containers and identified shelves which is recorded against the inventory.

Hi!
In a design lab where I worked, there were about four main ways to get parts into your hands to build projects! And two important ways were:

(a) Generic parts like connectors, resistors, capacitors, etc., were not tracked, there were just boxes of them, so you could take as many as you like. For a home lab, resistor kit books, capacitor kits and so on are great. I get through loads of pin headers and sockets, so I don't track those either, and have a little plastic container full of pin headers, and a little component drawer full of those too, so I always have them available one way or another. I think I've got every E24 value of resistor, in 0805, and a smaller range in 0603 and wire-ended, and they are not tracked, I just make sure I have many of those since they are low-cost. I've got a few resistor books and capacitor kits, and quite a lot of Coilcraft kits (I like those for RF projects), one or two Wurth kits, and don't track the parts in those.

(b) Semiconductors and all non-generic parts in a warehouse/store, and there was a database to use to check out parts. I've got an Excel spreadsheet that is now inaccurate, but since I usually order from Farnell, I just use e-mail search to see if I have ever ordered the part, to know if I have it or have had it in the past. I have about four boxes (about the size of shoe-boxes) for semiconductors, one containing analog and data conversion parts(in their original Farnell bags), one containing discrete parts, one containing digital parts, and one containing microcontrollers. I don't organize them any deeper than that, and just tip the relevant box out to search for what I want. Some semiconductors come in trays or long plastic tubes that won't fit in the boxes, so they are in effectively a small wastepaper bin type container with no organization, I'll just search through that.

dougw said:

Knowing where they are located is the harder part. Good labels are important

That's a good point. I don't have this problem at the moment due to limited number of components, but it's definitely something I will keep in mind