CPU collection systematization

[Libkin]

How do you store and systemize information about your collection?

I’m looking for optimizing my way of storing information about my collection.

Criteria of good system:
1. Easy and fast way of putting information about CPUs in.
2. Easy text search from PC or mobile.
3. Good visible interpretation of information.
4. Easy and fast find place of physical storage of the chip.
5. Fast way of understanding of completion of series. I mean I need easy way to understand if I’m missing some frequencies/models of family.

My way of storing:

I have google sheet files with single sheet for every big manufacturer. I divide list visually for CPU families and sometime family/core name. Please look at example on the picture. Each CPU I mark with number on label made from easy removable 3M Scotch 811 (http://multimedia.3m.com/mws/media/358878O/811-datablad.pdf) and marker Edding 140S. Number format: XX.YYYY.ZZ – XX number of the manufacturer, YYYY – number of the chip in the collection 1-2-3… each new CPU - i++, ZZ – number of spare if I have more than one.
Physically I store CPUs in plastic cabinets for paper store like Bisley with 30 shelfs or smaller like this https://www.amazon.com/Kapamax-Locking-Cabinet-Organizer-Drawers/dp/B07BSHFWGD/.

Limitations:

1. I spend a lot of time putting data in the list. I want to be able to find CPU quick in the list to check if I have one that’s why I put full information, but I spend a lot of time doing it.
2. I don’t have pictures and I don’t find fast way of picturing CPUs and systemizing images. If I need to photo each CPU from two sides and rename pictures after – it’s big amount of additional work.
3. I don’t think I have a good system of systemizing CPU families/models. What is the right order: by cores? By socket? By package? Do you know where I can find the list of all cores and models sorted by date of announcement or some other logical way?

Any ideas and advises for optimization/changing of my system are very welcome! Do you know any collecting software? Do you store pictures?

[cvandijk]

Right now I also have my collection indexed in an online sheet. I have different sheets for 086, 186, 286 etc. The sheets contains a few columns, like brand, SSPEC, speed and other information.

However, it's a lot of work to check if I already have a CPU if there is a new sale, because you need to be very quick if there is a new sale.

Currently I'm moving the sheets to a self made system, with full text indexes etc., so I can search/check faster. I'm also scanning all unique CPU's, and I have created a small script that extract the individual CPU's using edge detection. I also tried to use OCR for extracting text information from the images, but that didn't work out so well, too many errors. So I need to manually bind the images to the correct entry in my program, so that's gonna take a lot of time.

If I receive new CPU's, most of the times I use cpu-world to extract information like model, family, speed, socket etc. A few months ago I started indexing my collection and my IP was banned because I made to many requests to the site LOL.

Physically I store them in trays, however this is not an ideal situation. Because they are loose in the tray, you need to be careful if you want to see them, otherwise there is a possibility that they fall out of the tray. I think I'm going to move them to small boxes with 6 or 10 mm foam so they are stuck and can't go anywhere. I store the QFP's in those sorting boxes, but I need to find another method.

[H3nrik V!]

Using an Excel sheet.

As my collection - and interest of collection (until now) is limited to Intel and mostly P5-P6 era, I have this sheet showing the basics - information about CPUs, which I own etc. Green with green background, I own, Green text on white background is confirmed ordered, but probably still at AVICC.
I don't collect sspec (yet) and not different core steppings either, but I do have both P54C, and 120MHz P54C and P54CQS as this - from my point of view - is a significant enough difference to be "another" ..

The yellow/orange denotes ES only versions.

* and a number refers to different notes, eg. embedded or mobile etc.

[CPUShack]

I am somewhat less organized LOL
all my chips are scanned front/back
The file name is the brand+part+number+sspec(or whatever else makes it different)

It does make it fairly fast to see what I have (just use file search in windows and instant list w/ pics of what I have)

[Andreycpu]

[Mixeur]

|
|
|
V

[H3nrik V!]

[bccwchan]

Below are my cpu list.

The total cost are recorded and the profit/loss are showed if any .

The item number and the condition are very useful for me to find the cpu.

[Mixeur]