Searching \ for '[PIC] Managing parts inventory' in subject line. ()
Make payments with PayPal - it's fast, free and secure! Help us get a faster server
FAQ page: www.piclist.com/techref/microchip/devices.htm?key=pic
Search entire site for: 'Managing parts inventory'.

Exact match. Not showing close matches.
PICList Thread
'[PIC] Managing parts inventory'
2005\05\21@114738 by Anthony Van Herrewege

picon face
Hi,

Last week, I counted all the chips/resistors/... I have and I concluded that for example I have way more types of chips than I will ever be able to remember. So I was wondering, how do you keep track of what parts (type, quantity, ...) you have? Do you use Access (or some other kind of database) or a specially made program or ....?

Regards, Anthony


Website: http://members.lycos.nl/anthonyvh

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

2005\05\21@122917 by Dave Turner

picon face
I keep a text file.  On each chip, I stick a label with a number on.
In the text file, I keep track of which numbered chip is which model,
and what program and version it's currently running.  Also, I keep
track of what hardware each chip is designed to run on, and
oscillators/RCs, etc.

On 5/21/05, Anthony Van Herrewege <spam_OUTanthony_v_hTakeThisOuTspamyahoo.com> wrote:
{Quote hidden}

> -

2005\05\21@171821 by Howard Winter

face
flavicon
picon face
Anthony,

On Sat, 21 May 2005 08:47:37 -0700 (PDT), Anthony Van Herrewege wrote:

> Hi,
>  
> Last week, I counted all the chips/resistors/... I have and I concluded that for example I have way more
types of chips than I will ever be able to remember. So I was wondering, how do you keep track of what parts
(type, quantity, ...) you have? Do you use Access (or some other kind of database) or a specially made program
or ....?

I wouldn't use Access for anything at all!  :-)  

I find a spreadsheet is adequate (and easier).  I have one sheet with a row for each type of chip that I have,
and the major specs across from them.  Another sheet, linked to the first, has the count of stock of each,
with a column for each location (I keep chips in several places!).

It's dead easy to update stock as I receive or use chips, and the specs page makes it a handy at-a-glance way
to choose something for a particular job.

Cheers,



2005\05\21@173036 by Howard McGinnis

flavicon
face
Parts & Vendors. Great little program for keeping track of bill of materials, inventory.

Howard

On Sat, 21 May 2005 08:47:37 -0700 (PDT), Anthony Van Herrewege wrote:

>Hi,
>
>Last week, I counted all the chips/resistors/... I have and I concluded that for example I have way more types of chips than I will ever be able to


2005\05\21@175843 by John J. McDonough
flavicon
face
----- Original Message -----
From: "Howard Winter" <.....HDRWKILLspamspam@spam@H2Org.demon.co.uk>
Subject: Re: [PIC] Managing parts inventory


> I wouldn't use Access for anything at all!  :-)

I dunno.  Access is pretty passable for making quick updates to a Postgres
database.

--McD


2005\05\21@181516 by Peter

picon face

On Sat, 21 May 2005, Anthony Van Herrewege wrote:

> Last week, I counted all the chips/resistors/... I have and I
> concluded that for example I have way more types of chips than I will
> ever be able to remember. So I was wondering, how do you keep track of
> what parts (type, quantity, ...) you have? Do you use Access (or some
> other kind of database) or a specially made program or ....?

In the beginning I used a flat text file, one part per line. Later I
moved part of it to SQL. The flat text file works fine for up to about a
thousand types (you use text search to find what you need, and sort to
find duplicates).

Peter

2005\05\21@201849 by John Ferrell

face picon face
I started an inventory file on a TRS-80 in about 1979-80 using VisiCalc,
PCFile DBII etc. I eventually converted to Reflex, which was later bought by
Borland and eventually buried there.

It is currently on Excel. My advice from experience is to never get involved
with any database that will not give up your files in CSV format because
that is the only universal input. Also, if it is not easy to add a field,
you will be sorry.

Also, don't get involved in inventorying individual resistors! There has to
be a low end cut off. Also, keep separated the used from new stock. And
never,never return ant item to stock that you are not certain is good. This
game is tough enough without self inflicted problems!

Keep tools & test equipment in your inventory as well.
I figure I know 80% of what I have and can usually find it. Not too shabby
for 25 years of junk collecting.

John Ferrell
http://DixieNC.US

{Original Message removed}

2005\05\22@034012 by Wouter van Ooijen

face picon face
> I wouldn't use Access for anything at all!  :-)  

I use Access for everything, including inventory, administration, price
calculation, etc. Much easier than a spreadsheet!

Wouter van Ooijen

-- -------------------------------------------
Van Ooijen Technische Informatica: http://www.voti.nl
consultancy, development, PICmicro products
docent Hogeschool van Utrecht: http://www.voti.nl/hvu


2005\05\23@100924 by Aza D. Oberman

flavicon
face
<Anthony Van Herrewege>
>  So I was wondering, how do you keep track of what parts (type, quantity,
...)
> you have? Do you use Access (or some other kind of database) or a
specially
> made program or ....?

We once used Parts & Vendors.  A bit quirky but useable.  Alas they kept
forcing us to but upgrades and finally they orphaned  product so we went
over to just using a general purpose spreadsheet (Excel).

Actually, we should have had a hint that P&V was not suitable for us when
the "low price" software turned out to be subtly crippled -- odd things like
not being able to edit certain columns.  We ended up spending a good bit
more for the software only to find out that we had to buy it all over again
(about a year and a half later) when they came out with the W2K version.

Cheaper to roll-your-own IMHO.

Aza D. Oberman

2005\05\23@215605 by James Newton, Host

face picon face
I don't suppose anyone would be interested in developing an online inventory
management program that we could all use? With piclist.com as an
"applications service provider."

The advantage of your inventory, my inventory and everyone elses all being
in the same database is that when anyone adds information about the part,
everyone benefits. E.g. If Howard takes the time to type in the properties
of a chip, and I happen to have that chip in my inventory, now "my"
inventory program knows more about the device.

If people were willing to put in what they paid for a part and where, then
everyone could buy from the lowest cost supplier. This is something my wife
does for groceries, etc... And she shares information with a few people in
the neighborhood. They call it a "price book" and it just records what they
paid and where. They share the book around and use it to plan grocery
shopping. One of the advantages of being a "stay at home mom."

In our case, it led to a co-op for purchasing in volume which we do
regularly. There are catalog companies for food that will only accept orders
of $500 or $1000. Our friend Tammy gets everyone's order and money together,
places the order with the company and then sorts out the orders for each of
us when they come. I know there have been times when people on this list
have gone in together on large quantity orders to get a good price or
because the product was restricted to large qty orders.

Anyway, I've been thinking about that sort of thing for a long time and I
have a web page about it:
http://www.piclist.com/idea/website/pricebook.htm Rather than try to explain
everything here, go take a look at the page and see if anything makes sense.

I will copy this one part from the page: "I already have a spread sheet for
each of the kits I sell that knows about minimum orders, shipping costs and
quantity discounts for each part, then it figures out the absolute best set
of orders, from one, or many different distributors, for a given number of
kits I want to put together." It is cool as hell to change the quantity of
kits I want to put together and watch it change from "order everything from
mouser" to "order this stuff from mouser, this from digikey, this from
Jameco" and know that it is always, for sure, the lowest possible total
price without me having to do figuring.

That sort of thing could easily be added to an online inventory program. And
again, sharing the data helps everyone.

---
James Newton: PICList webmaster/Admin
jamesnewtonspamKILLspampiclist.com  1-619-652-0593 phone
http://www.piclist.com/member/JMN-EFP-786
PIC/PICList FAQ: http://www.piclist.com



2005\05\23@223703 by rosoftwarecontrol

flavicon
face
yes, it is also functional as "part shear/exchange".

I have some parts I think definitely is spare, like 1000 hc244, 4000 green
smt led.
could put into inventory for exchange parts I need.







{Original Message removed}

More... (looser matching)
- Last day of these posts
- In 2005 , 2006 only
- Today
- New search...