So, there comes the time you become the owner of a shoebox full of almost-no-value one-hundredish vacuum tubes and you need to sort them out. I do want to use (some of) them, not immediately. I also have no facilities to keep them sorted in a logical way, so I had to do it efficiently.
First of all I separated the magic eyes, since they can be easily recognised and tested.
Then ... I simply transferred the tubes one-by-one from one box to another and typed the part number in a spreadsheet, when still visible. Those tubes without a usable marking have been compared physically & visually to others and some got a supposed part number with a marker pen. A dozen were left anonymous, separated from the rest, for other projects.
Once all the names are in a spreadsheet just create a pivot table to see how many different types you've got, and how many each.
Now go back online and look for projects with those tubes :)
