[Boatanchors] tube inventory

[Kim Herron]

Hi Dick!!

   I built mine using Microsoft Access since it's already a database
program.  You can sort it what ever way you want and tell it to sort by
column as well.  I probably am more used to it since we use it at the USPS
to do our vehicle reports for inspection etc.  But you can do anything you
want with it and I find it easier to use than Excel.  

Kim Herron W8ZV 
www.goldenradioservice.com
kim.herron at sbcglobal.net
1-616-677-3706

-----Original Message-----
From: boatanchors-bounces at mailman.qth.net
[mailto:boatanchors-bounces at mailman.qth.net] On Behalf Of Ian Wilson
Sent: Tuesday, February 17, 2009 6:55 PM
To: boatanchors at mailman.qth.net
Subject: Re: [Boatanchors] tube inventory


I have found that Excel is a straightforward way to to this.

I use a very simple format with the tube number in the first column,
quantity in stock in the second column, brief definition in the third column
(e.g. "2t med-mu" for medium-mu double triode), storage location in the 4th
column, notes (such as heater voltage, plate dissipation for PA tubes, etc)
in 5th and subsequent columns.

This allows you to enter the data fairly blindly, then once you have most of
it in:
  - sort by the 'definition' column
  - add blank rows between groups of similar devices
  - sort each group by the 'tube number' column

This would give you a set of groups (e.g. all the dual triodes together),
with the tubes sorted by number within the groups.

I have used this format to organize tubes, transformers, xtals, etc, all
with the same basic layout and no frills whatsoever.

The only real trick is finding the Sort command (somewhat unhelpfully under
the 'Data' menu).

Dick - I can send you one of my tube spreadsheets if you'd like.

73, ian K3IMW ______________________________________________________________
Boatanchors mailing list
Home: http://mailman.qth.net/mailman/listinfo/boatanchors
Help: http://mailman.qth.net/mmfaq.htm
Post: mailto:Boatanchors at mailman.qth.net

This list hosted by: http://www.qsl.net
Please help support this email list: http://www.qsl.net/donate.html