diyAudio

diyAudio (http://www.diyaudio.com/forums/)
-   Parts (http://www.diyaudio.com/forums/parts/)
-   -   Do you keep an inventory ? (http://www.diyaudio.com/forums/parts/108807-do-you-keep-inventory.html)

travis 21st September 2007 01:04 AM

Do you keep an inventory ?
 
In the process of moving I realized that I have a lot of components. Lots of stuff from projects that I never finished that I forgot that I owned. I thought to myself, You should put all this stuff into an inventory on your computer if you have time, self.

So I was just wondering if there are programs out there for this type of thing. Do you use one? Which one? Would you if one existed?

Conrad Hoffman 21st September 2007 02:10 AM

It would take me more time to count things than the parts are worth, but I do keep a list of semiconductors and resistors, just so I know what's available. Any database or Excel, or Access, works fine. I certainly wouldn't fool with a specialty program, though it would be easy enough to write one.

ocool_15 21st September 2007 03:18 AM

I just use excel sheets as you can always search if your not sure if you already have a part.

I inventory my crossover parts so when I'm designing I try to work with components I already own. I keep my Packing slips so I have a list of things that should be around like power caps and semiconductors.

PeteMcK 21st September 2007 03:36 AM

I'd rather spend the time not finishing another project...

wrenchone 21st September 2007 03:51 AM

Better than keeping a stuffy list in a computer somewhere is having the parts in a labeled drawer so you can do a quick visual scan of what's there and stuff some boards. Right now a lot of my goodies are residing in small brown paper sacks - that's got to change, as one brown paper bag looks pretty much like the other.

Conrad Hoffman 21st September 2007 04:11 AM

Actually, I try to keep 5-10 of every part ever made on hand. That way an inventory sheet isn't really necessary.

Geek 21st September 2007 05:36 AM

Quote:

Originally posted by Conrad Hoffman
Actually, I try to keep 5-10 of every part ever made on hand. That way an inventory sheet isn't really necessary.

There's the right idea! :D

error401 21st September 2007 07:54 AM

Quote:

Originally posted by Conrad Hoffman
Actually, I try to keep 5-10 of every part ever made on hand. That way an inventory sheet isn't really necessary.
Then the problem just becomes finding what you need ;)

I have a small enough 'inventory' of spare parts that I usually have an intuitive sense for what I should have laying around. The problem always becomes finding what I'm looking for among the 3 or 4 open DigiKey boxes I usually have laying around my work area. In fact, it's usually a worse problem because I rummage quickly without reading the labels...

cpemma 24th September 2007 03:39 PM

One way I try to do is to keep the invoices in a folder and cross things off (or reduce the number) as they're used; it's easier than trying to read the markings on semis and less work than transferring to another paper or PC system.

taj 24th September 2007 10:56 PM

I did create a quick and dirty inventory database in Filemaker Pro, but if you miss updating it after one purchase or soldering session, then it's not accurate, so it's useless.

You're welcome to have a copy of that database if you want, but it requires the Filemaker program to run, and it's probably much simpler for you to just use Excel or Access or even a text file list.

..Todd


All times are GMT. The time now is 08:02 AM.


vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Copyright 1999-2014 diyAudio


Content Relevant URLs by vBSEO 3.3.2