Building a Pencil Catalog

A collection becomes dramatically more useful when it is cataloged.

My basic fields are brand, model, grade, country of manufacture, barrel shape, finish, eraser or end type, acquisition date, source, quantity, condition, and notes. For vintage examples I also transcribe the imprint exactly.

I assign each distinct variant its own entry. If two pencils have different ferrules or country markings, I want that difference visible in the data even if the model name is identical.

Photographs are linked to the entry rather than stored as anonymous files. A collector should be able to move from spreadsheet row to image in seconds.

Condition should be descriptive rather than emotional. “Unsharpened, light paint rub near grade stamp” is more useful than “excellent.” Clear descriptions make later comparisons possible.

A catalog also prevents duplicate purchases. Before buying an unfamiliar box, I can check whether I already own the same variant or only a similar one.

The real reward appears after a few years. The catalog begins to reveal patterns: which countries dominate the collection, which grades I use most, which models changed over time, and where the gaps are. At that point the spreadsheet becomes part of the collection itself.