|
General Vintage Technology Discussions For general discussions about vintage radio and other vintage electronics etc. |
|
Thread Tools |
5th Nov 2022, 10:50 pm | #1 |
Octode
Join Date: Mar 2020
Location: Blackburn with Darwen, Lancashire, UK.
Posts: 1,567
|
Valve sorting do you use a dBase or spreadsheet?
I am going through my valves, many are pulls etc but some boxed. The problem is I can not remember what I have got so have started to put things into a LibreOffice spreadsheet.
Up to now the columns are Type, Make, Boxed, New, Used, Comment, Base, Location. This is not for selling anything and many are not tested so at the moment just to figure what I have,. I was just wondering what others have done and if any have used a database? Adrian |
5th Nov 2022, 11:23 pm | #2 |
Nonode
Join Date: Oct 2017
Location: Bristol, UK.
Posts: 2,369
|
Re: Valve sorting do you use a dBase or spreadsheet?
It can't think what a database would do for you that a spreadsheet wouldn't, and I guess the spreadsheet is marginally simpler; you can sort on type number very easily which helps when visually searching hard copy. On mine I also include test results and enter equivalent numbers which is useful when searching electronically.
|
6th Nov 2022, 7:22 am | #3 |
Banned
Join Date: Jun 2015
Location: Mareeba, North Queensland, Australia
Posts: 2,704
|
Re: Valve sorting do you use a dBase or spreadsheet?
GCstar is already setup for almost any collection you wish.
IF the particular "unit " isnt represented, simply rename a data base that is. Runs under perl, which is super configurable. https://gitlab.com/GCstar/ Joe |
6th Nov 2022, 7:24 am | #4 |
Banned
Join Date: Jun 2015
Location: Mareeba, North Queensland, Australia
Posts: 2,704
|
Re: Valve sorting do you use a dBase or spreadsheet?
fot those that have steam punk powered games machines,
https://en.freedownloadmanager.org/W...star-FREE.html Joe |
6th Nov 2022, 7:26 am | #5 |
Banned
Join Date: Jun 2015
Location: Mareeba, North Queensland, Australia
Posts: 2,704
|
Re: Valve sorting do you use a dBase or spreadsheet?
|
6th Nov 2022, 8:12 am | #6 |
Heptode
Join Date: May 2017
Location: Konongo, Ghana
Posts: 510
|
Re: Valve sorting do you use a dBase or spreadsheet?
I use three Word-documents, ones for my new valves, one for my used valves and one for my valves in non-diy equipment.
The first two documents have blocks of rows and columns per sort of valve (triode, double diode-triode, etc.). There are four columns in each block, one for the type (AC2, CC2, DC70, etc. in alphabetic order), one for the brand, one for (the meaning of) extra markings on the valve (factory codes, manufacturer, date codes, etc.), and one column which indicates if the valve is available or is being used in one of my builds, and if so, in what build. In the document for my used valves I use either black of green writing per valve. Green indicates that the valve is tested. The third document has blocks of rows/columns per apparatus, with three columns per block, one for the valve type, one for the brand and one for extra markings. I keep almost all of my valves in plastic transparent containers, mostly containing only one sort of valve (power pentodes, double triodes, triode-pentodes, etc.). In each container I keep the used valves inside a transparent plastic bag. With this 'system' I never felt the need to register the location of my valves. I have about 2500 valves in total which I registered this way. Besides that I have a large plastic container with used 10-pin television valves and a carton box with mostly large line duty output valves which I did all sort out but which I didn't test and didn't register yet. Attached a picture of the corner in our former attic where most of my valves were situated. My valves are currently on transport from The Netherlands to Ghana. I hope they all arrive in good order.
__________________
Robert Last edited by Robert Gribnau; 6th Nov 2022 at 8:20 am. Reason: Addition |
6th Nov 2022, 9:14 am | #7 |
Octode
Join Date: Mar 2020
Location: Blackburn with Darwen, Lancashire, UK.
Posts: 1,567
|
Re: Valve sorting do you use a dBase or spreadsheet?
OK thanks for the replies, I was wondering if there was any natty programs out there as database programs are something I struggle with, when it comes to writing the reports for them etc. I will have a look at GCstar when I can.
But I generally think that a spreadsheet will do for me, I may only have about 350 valves and it will allow me to sort on types, bases etc. I have no quick tester, so what I want to know at the moment is what I have, how many etc. Testing generally comes when I build something, and I see how it works. I do have a home made thing where I can set up the DC voltages and compare Ia against the data sheet, but that takes time to do. So thanks for the responses, it is interesting how others look at it.. Adrian |
6th Nov 2022, 9:24 am | #8 |
Dekatron
Join Date: Sep 2011
Location: Rugeley, Staffordshire, UK.
Posts: 8,809
|
Re: Valve sorting do you use a dBase or spreadsheet?
Probably unconventional, but it works for me, I use a simple excel based spreadsheet for different types of valve bases. So, British 4&5, British 7, octal, magic eyes, etc. A few columns per sheet showing valve name, quantity, and notes eg new boxed, tested etc. The valves themselves are kept in nylon storage containers with tops, and labels to match the spread sheet names applied to them.
You can become fanatical and create sheets and boxes for much more defined groups of valves, eg output, mixer, triode etc etc but you have to consider how many valves you own ie are you unnecessarily complicating a database when the truth is a simple one is ultimately easier to handle and use? So in my case, the use of a single section for say B7 valves entails just a few minutes search in that box(s) for the required valve that I know is in there, and I know what it looks like, not a problem. Unless you have a huge quantity of valves and are having to delve into them on a daily basis then a more complex system is just further encumbrance in itself. Match the complexity of the database to the size of the stock.
__________________
A digital radio is the latest thing, but a vintage wireless is forever.. |
6th Nov 2022, 9:58 am | #9 |
Moderator
Join Date: Jan 2003
Location: Ipswich, Suffolk, IP4, UK.
Posts: 21,193
|
Re: Valve sorting do you use a dBase or spreadsheet?
My Excel spreadsheet is very simple.
TYPE DESCRIPTION NOS USED TESTED NOTES
__________________
Graham. Forum Moderator Reach for your meter before you reach for your soldering iron. |
6th Nov 2022, 10:04 am | #10 |
Dekatron
Join Date: Jun 2013
Location: East Sussex, UK.
Posts: 3,315
|
Re: Valve sorting do you use a dBase or spreadsheet?
|
6th Nov 2022, 3:18 pm | #11 |
Nonode
Join Date: Oct 2017
Location: Bristol, UK.
Posts: 2,369
|
Re: Valve sorting do you use a dBase or spreadsheet?
And before you give up the hobby, or shuffle off this mortal coil, leave a copy of the list inside the box it refers to. Could save somebody in future hours of effort working out what is in there! Jerry
|
6th Nov 2022, 6:05 pm | #12 |
Hexode
Join Date: Apr 2007
Location: Milton Keynes, Buckinghamshire, UK.
Posts: 329
|
Re: Valve sorting do you use a dBase or spreadsheet?
The system that works for me is to keep new, used tested & used untested valves separate. New valves are in boxes in the attic (bankers boxes are good & cheap) & the used ones are in steel drawers in the workshop.
I have an excel document with a separate page for each box or drawer. The categories are Rectifiers, Outputs, Small signal, RF & Eye. B7G battery valves are in their own box. If i need a valve I'll use a used tested one first (or test an untested one) before I use a new one. |
6th Nov 2022, 6:07 pm | #13 |
Nonode
Join Date: Dec 2002
Location: Coulsdon, Surrey, UK.
Posts: 2,109
|
Re: Valve sorting do you use a dBase or spreadsheet?
Another vote for an excel spreadsheet- all you really need.
As well as the main inventory, I have adjacent tabs showing where the boxes are located and an equivalents lookup list. Storage Boxes are filled up and then another started as needed. No attempt being made to arrange the contents as the spreadsheet can give all the relevant details. I include the valve carton details as well, making it easier to locate items within a box. Using an excel pivot table, I can see total quantities of each type across all the different storage boxes and this can also be searched using the standard ctl + f function. Andy |
6th Nov 2022, 6:41 pm | #14 |
Dekatron
Join Date: Apr 2012
Location: Wiltshire, UK.
Posts: 13,953
|
Re: Valve sorting do you use a dBase or spreadsheet?
Nice thing about spreadsheets is that you can sort on any column, and do pivot tables or filters to display, let's say, 'all B7g valves with a 12.6V heater'.
And you don't need to enter the data in any particular order, just put it in then use the spreadsheet to sort and order it for your immediate needs. I only have a couple of hundred valves here, stored in plastic trays with kitchen roll to stop them rattling too much when I pull out a tray.
__________________
I'm the Operator of my Pocket Calculator. -Kraftwerk. |
6th Nov 2022, 7:45 pm | #15 |
Octode
Join Date: Mar 2020
Location: Blackburn with Darwen, Lancashire, UK.
Posts: 1,567
|
Re: Valve sorting do you use a dBase or spreadsheet?
I have another two boxes to enter into the spread sheet and have got to 340 valves, so may be around 400 all in, not counting what is in any gear.
The main point was to figure out what I have, many of them are pulls from previous owners I guess, but there are some boxed new and a few rectifiers that should stop me needing to buy GZ34's in the future found about three 5Z4G/T Valves and a U50. What I was wondering initially was if I could tie in a database with all the details of the valve specs, but it is way too complicated for me. As I said I do not have a simple tester so these will have to be tested when there is a chance of them being used. Up to now a valve type could be in any one of many boxes, so perhaps a next stage will be to organize them again so that all the same are in one box, that may give me an easier chance to test types in one go and get rid of the bad ones, who knows. It is keeping me occupied for a while if nothing else. Adrian |
6th Nov 2022, 8:59 pm | #16 |
Dekatron
Join Date: Jun 2009
Location: Staffordshire Moorlands, UK.
Posts: 5,263
|
Re: Valve sorting do you use a dBase or spreadsheet?
I dont use any sort of database as I have no idea what I'm doing.
I have my valves in boxes based on type designation For example boxes marked E-Series-Small and E-Series-Large. P-series. American nXn series. All numeric. All alphabetical. Mazda type nomenclature, K-series, A-Series etc.
__________________
Kevin |
8th Nov 2022, 3:10 am | #17 |
Heptode
Join Date: May 2017
Location: Konongo, Ghana
Posts: 510
|
Re: Valve sorting do you use a dBase or spreadsheet?
Your reaction seems a bit contradictory to me. The way you describe your system makes it look, at least to me, that you are in control of your valves in your own way. And isn't that what counts? Or are we talking about large quantities?
__________________
Robert |
8th Nov 2022, 9:17 am | #18 |
Heptode
Join Date: Sep 2010
Location: Hythe, Hampshire, UK.
Posts: 626
|
Re: Valve sorting do you use a dBase or spreadsheet?
I recently sorted and tested all my valves and only kept the ones that were up to spec. I then used a Spreadsheet which lists the valve type, quantity, monetary value and box number each one is in.
I have them sorted by physical size into the different boxes. |
8th Nov 2022, 11:50 am | #19 |
Dekatron
Join Date: Nov 2006
Location: London, UK.
Posts: 3,496
|
Re: Valve sorting do you use a dBase or spreadsheet?
There's no need for a database. You can make an Xcel or similar spreadsheet with virtually infinite properties and easily compare things that way. Happy listing!
__________________
Al |
8th Nov 2022, 10:18 pm | #20 |
Pentode
Join Date: Aug 2008
Location: Taunton, Somerset, UK.
Posts: 135
|
Re: Valve sorting do you use a dBase or spreadsheet?
I've kept a database of my valves, transistors and ICs for about the last twenty years. It started out as a Microsoft Access database but a few years ago converted it to an Excel spreadsheet. Its a lot more convenient as a spreadsheet as I can view it on different devices and the filter/sort tools are very good. For the transistors I record quantity and package and for the ICs I record the use. Thats been very handy when starting a new project where I might want to see what op-amps I have in stock etc.
|