Does Anyone Write Up Their Collection?

I do the same thing, I use excel sheets to keep record of all my collections. Name of article, year, catalog #, total I paid for, total I sold it for if I sold it, condition, catalog value and date and location where it was bought. I even have the total I paid for all my items and the total I received for all my sells.

What does "write up" mean? I have written articles for BNR.

I have never exhibited but I have given plenty of programs at shows. In fact, I will be giving one on collecting USDA Food Coupons at CPMX in March.

I do an Excel spreadsheet!
Convenient

Personally I couldn't see how someone won't catalogue, or write up their collection? (ok it takes time, but that is part of the hobby right? )

Personally, I started out with literally writiting down every single coin I had. But then I figured out I better put it on the PC. By now I have several documents tracking every single thing I add / remove from my collection. Nothing fancy, and pretty chaotic... but there is a method to the madness I use 3 sorts of documents: Words, Noteblock, Excel

For example, the original document were ALL coins and notes are in is a word document of approximate: 117 pages and counting... (ALL in Times New Roman 12 )

But I have several core collections, so I started using excel to filter the cool coins & notes: world coins from 1500 / 1945, Dutch Banknotes, Silver, Euro's, USA, Switserland, Etc.

So I ended up with several sub documents, some more elaborate than others (depending on my personal attachment of the collecting area) it can get a bit confusing at times. So that is why I always keep my original word doc. from 117 pages

It's late here, or early I must say So sorry for my ramblings...but here are some examples of my excel fromats!

All world coins:


Banknotes


Old World Coins & Silver Personal favorite

I don't do anything, which is weird considering I haven't seen my collection for nearly a year now and won't see it for more than a year to come.

But then again my note collection is small, and sporadic, mainly based on countries I have been to. My chinese collection is okay at the moment.

I think the best way to do it is google docs-spreadsheet , which will help you to escape any sort of hard drive crashes and it automatically saves even if the net goes down while you are working on it..

Having a spreadsheet and backup is most useful in event of fire, flood, robbery, etc. Some folks make videos, or scan pages of coins.

, Desolate-Tomb!