[Boatanchors] on topic, looking for software

[J Forster]

That's essentially what I suggested in Excel or Work, but you have to sort the
entries with a command. It does give you more flexibility. You can likely find
an old ('95) Office that will do just fine for $10 or so.

IMO, setting up a 'fill in the blank' form application would simply not be worth
the effort unless you can get some dummy to do the data entry.

Best,
-John



kim.herron at sbcglobal.net wrote:

> Hi Gang!!
>     I found that using Microsoft (I know) Access database works really neat.
> They tell me that the Open Office program has a database that does the same
> thing.  That whole program can be had for under $10.00 on E-Bay.  It makes
> keeping the tube inventory up and in order easy.  You can put it in, in any
> order you want and when you save and reopen it, its all in order.  So when
> you add a bunch of stuff to the inventory all you have to do is to scan down
> the list by tube number, i.e. 6SA7, and go to the column where the quantity
> is and up date it.  If it;'s 7 and you have three, highlite and backspace
> the 7 and type in 10.  If you want to be able to do this automatically and
> sell and receive out of said inventory, then you want an old version of
> Quickbooks (I use that too).  You can create an inventory in that and update
> the quantities and sell out of it as well and it will update when items are
> used.  The Quickbooks is a little overblown to start with, but it will do
> what you want.  If you don't want to mess with that, The plain database will
> do the same thing.  You just have to do the manual addition and subtraction.
> They tell me  that you can build macros (Huh, what's that??) to do that but
> I don't bother. You passed the Extra class exam, so I know that you can do
> math.  The database is probably the way to do it.
> ----- Original Message -----
> From: "J Forster" <jfor at quik.com>
> To: "Ken" <n5cm at rtconline.com>
> Cc: <boatanchors at mailman.qth.net>; "Dick KF4NS" <kf4nsradio at verizon.net>
> Sent: Wednesday, January 30, 2008 5:49 PM
> Subject: Re: [Boatanchors] on topic, looking for software
>
> > It would be simple if you were willing to just go through your list to the
> > tube type and add or subtract the quantities by hand.  That could be done
> > in
> > a Word Table or Excel Spreadsheet. You can easily sort the tables too.
> >
> > However, what you are asking requires a form, interfaced to Excel. That's
> > significantly more work.
> >
> > FWIW,
> > -John
> >
> >
> >
> >
> > Ken wrote:
> >
> >> Hi Dick & Gang,
> >>
> >> I too would like a simple inventory type program, simple and
> >> easy to use.
> >> Problem I find with a lot of programs is that the author puts
> >> everything he can think of into it (including the kitchen sink!).
> >> Who needs all that krappp?
> >> I have a bushel of tubes. To go thru them I would like to
> >> add a number after they type, each time I enter a duplicate
> >> type, it would up the quantity figure one, etc.
> >> When taking one out of inventory, a method of subtracting
> >> one from the total shown should be possible.
> >> I have had several suggestions down thru the years of using
> >> a program already written but I have to wade thru a  bunch
> >> of un-needed info to find what I need.
> >> Oh well, I can hope, can't I?
> >> Take care,
> >>
> >> Ken   N5CM
> >
> > _______________________________________________