Right now, I have one Excel sheet for every set I collect. They're not easy to search, unless I'm in front of a computer. And even then, searching takes time. I'm putting together one database, for all of the sets I collect. This will have entries for cards I have, and cards I do not, since I'll need them eventually.
I would like FCB's input on what data should be recorded about each card. I'm trying to avoid a generic "notes" field, because that would be unstructured and muddy the search results. Below are the properties I have so far. What else would you add?
AcqCost (Acquisition cost)
AcqFrom (Acquired from - eBay, COMC, etc.)
Brand (Topps, Upper Deck)
CardNum (Numeric or letters, doesn't matter)
EstPrice (Estimated price I could sell it for)
InTransit (true/false - I don't count it as being in my inventory until I take possession)
Redemption (true or false)
QtyMade (what's it short printed or numbered to)
ItemID (this will be my own creation to uniquely identify each card)