@majstro, I would suggest the most up-to-date list you will find would be available from the ATA (American Topical Association).
Here is my post with the suggested links to their website. If you click on the pdf checklist, you will see an 8 page list of Bear Topicals about 1/4 of the way down the first page. I think you can order this list directly from the ATA without a membership.
I realize this is an old thread, but after searching the site for a better thread, I decided this is about the best thread to post the following. If there is a better thread, let me apologize now for the error.
Regarding cataloging of a person's collection, I have workflow I use which may help someone. Along with cataloging, I also design my own pages for my albums.
First, using an old pocket Scott catalog, I marked off stamps to be included one each album page. Using the marked catalog as an information guide, I design the page using PageCreator. After finishing the page design, I locate the relevant stamps and placing them on my scanner with a black background, I scan the stamps at 300dpi and 100 percent. I then use Stamp Image Bursting Application which automatically select each stamp in the scan and allow me to save the individual stamp images. If needed I load the individual image in Image Viewer and crop and straighten as required. The information on the stamp is then placed in StampManage, the scanned image included and the stamp saved. The stamp in then mounted on the page I created.
Once all the stamps for the particular page have been scanned, cataloged and mounted, I go on to the next marked page and begin the process over again.
It have been a good cold winter and/or rainy day project for me. In the end, I have a stamp album done the way I want it done, and my stamps cataloged.
I use 2 WORD files, one is a document that has every Scott number listed. It wasn't that bad to implement as I have a program that generates catalog numbers using a few definitions. Using indicators and color codes I know what I have and where. The second document is a table with information from document 1 transferred to the table, including color codes. This table has the Mint and Used values of each item. Since, I only have 3 countries, I update the value tables every year.
Sounds like a lot of work but I have a "ton" of VBA (Visual Basic for Applications) code. There are "screens" that automate the entire system. It was initially developed on a mainframe in 1979 and, over the years, converted to various languages. Right now I am converting it to VB.NET (although slowly). With the VB.NET I am going to get rid of WORD and use a custom relational database that I wrote and almost have completed.
I know that up to MS Office 2013 VBA is available, I am not sure after that. If you are using EXCEL, screens can be added to EXCEL, with VBA, and spreadsheets automated.
We are Happy to have you here!! New members, we would love to get to know you. Please feel free to introduce yourself HERE
Otherwise - Jump right on into the conversations!! We look forward to your participation.
If you are not a member yet, register today!! It's all free and we want to hear from you!!
Please share our site on social media networks. Thanks!!!