The Acaeum Dungeons & Dragons
Collecting Forums

Collection finally being counted and catalogued
Post new topic Reply to topic Page 1 of 21, 2
Author

User avatar

Long-Winded Collector
Acaeum Donor

Posts: 3601
Joined: Dec 20, 2003
Last Visit: Jan 13, 2026
Location: Canada

Post Posted: Thu Nov 25, 2010 1:25 pm 
 

Well after almost 10 years since the last inventory I am updating my collection list.   This time it is all going in one giant database.  I always had a very good idea of what I needed but some the printings were never carefully counted or catalogued.  For common stuff I used to buy lots, keep the good stuff and box up the stuff I know I had to sell later, this has resulted in around 40 magazine boxes of extras.  Already in my collection of stuff I have found 3 copies of B10 8O  (complete with counters) multiple C mods (how about 4 copies of C5 all Near mint or better) and I am sure this list will grow.

The result will be a giant sell off of my extras in the New Year (hopefully February), There are even a few rares (like the R mods) that I have upgraded that will be going out the door.  The goal is to unload the 40 boxes and make room for more stuff I do not already own.

Anyway I am very excited to get this done :D , already catalogued around 200 items (on the first day).  It is really cool to finger through the old stuff while bagging and boarding.  I even got some official Role Playing Size storage bags from a local card shop.


Games can get you through times of no money but money can not get you through times of no games!!

 WWW  

User avatar

Grandstanding Collector

Posts: 6172
Joined: May 03, 2003
Last Visit: Feb 10, 2026
Location: Waterloo, Ontario, Canada

Post Posted: Thu Nov 25, 2010 1:48 pm 
 

I wish you well!  I have been meaning to do the same thing for years with not so much success.  I've also been selling off a few thousand extra items lately too and its a lot of work.

 WWW  


Long-Winded Collector

Posts: 3549
Joined: Oct 10, 2006
Last Visit: May 16, 2026
Location: Wandering aimlessly on the 8th level down...

Post Posted: Thu Nov 25, 2010 1:57 pm 
 

I have trouble with my handful of items, so also wish you luck and have fun! If you have any spares you don't want....


Rolls a '3'

"Did I hit.....?"

  


Grandstanding Collector

Posts: 5923
Joined: Nov 16, 2002
Last Visit: Jul 31, 2026
Location: Wichita, KS, USA

Post Posted: Sat Nov 27, 2010 11:34 pm 
 

Great news Jeff.  I'm in a similar position, and really do need to start cataloging things (if only for insurance...).  

What have you been using as your db schema:  have you adapted one of the many TSR inventory spreadsheets here to Access, or are you using Excel, etc.?  Inquiring minds want to know! :D


Allan Grohe (grodog@gmail.com)
Greyhawk, grodog Style

Editor and Project Manager, Black Blade Publishing
https://www.facebook.com/BlackBladePublishing/

 WWW  


Sage Collector

Posts: 2024
Joined: Feb 12, 2005
Last Visit: Jul 04, 2026

Post Posted: Sun Nov 28, 2010 12:08 am 
 

i use excel. i had mentioned to Bracton earlier today that having recently finished going through all of the items i've acquired in the last four years, and reorganizing the wall, i'm at 7962 different frp items, magazines, manuscripts and maps (like the sole surviving city-state map and rob kuntzs' demonworld map). i couldn't have done it without excel-and my niece doing all of that typing for me...

  

User avatar

Long-Winded Collector

Posts: 4756
Joined: Oct 31, 2004
Last Visit: May 02, 2025
Location: Caddo Mills, TX

Post Posted: Sun Nov 28, 2010 12:25 am 
 

Pretty awesome Jeff.  I've been doing pretty much the same thing recently (only I dont have any extras to sell).  I have been putting everything into an Excel spreadsheet, breaking it up into workbooks that correspond to a particular game (D&D, AD&D, Runequest, etc.) or company (Judges Guild, GDW, etc.).  I finished the spreadsheet awhile back and just a couple of weeks ago finished taking photos of all the items as well.  Going to try to embed the .jpgs into the .xls file but that may be a bit unwieldy and I may end up just linking them instead.  It took me almost a month to take approximately 2000 photos.  It will probably take longer to insert them all into the spreadsheet.  8O  I have done the same with my video games as well.  No damn way I am doing this for my comic book collection.  :P  

Looking forward to your sale.  :D


You don't like your job, you don't strike. You go in every day and do it really half-assed. That's the American way. - Homer Simpson

  

User avatar

Long-Winded Collector
Acaeum Donor

Posts: 3601
Joined: Dec 20, 2003
Last Visit: Jan 13, 2026
Location: Canada

Post Posted: Sun Nov 28, 2010 3:25 am 
 

I am using excell as well!  I just do not know how to use Access properly so that writes that one off.

It is very cool, can't wait to fill the holes know :)


Games can get you through times of no money but money can not get you through times of no games!!

 WWW  

User avatar

Long-Winded Collector
Acaeum Donor

Posts: 3865
Joined: Feb 21, 2004
Last Visit: Jul 20, 2023
Location: Milford, Michigan

Post Posted: Sun Nov 28, 2010 12:35 pm 
 

i use excel.

Same here. Most of my collection is pretty up to date. Maybe last six months or so needs updating, but I have not been on much of a buying spree lately.

I like John's idea of taking pictures. But I would need to do something about memory space on the computer and back up.


And I could've bought these damn modules off the 1$ rack!!!

New modules for your Old School game http://pacesettergames.com/

Everything Pacesetter at http://pacesettergames.blog.com/

 WWW  

User avatar

Verbose Collector

Posts: 1655
Joined: Mar 08, 2008
Last Visit: Aug 02, 2026
Location: Toronto, Canada

Post Posted: Sun Nov 28, 2010 6:27 pm 
 

I'm newer to collecting than many here... luckily I began with an Excel sheet, and have carried thru so it's current... I like the idea of embedding jpegs in the worksheet (have to figure that one out yet :) )  I tried photobucket but maxed out my account on Dragon images (!)

  

User avatar

Long-Winded Collector
Subweb Admin
JG Valuation Board

Posts: 4597
Joined: Nov 08, 2002
Last Visit: Aug 06, 2026
Location: Land of 10,000 ponds

Post Posted: Sun Nov 28, 2010 7:02 pm 
 

I've used a list in Word, then spreadsheets then Excel for I don't know how long now.  Course this idea of adding pictures sounds like it would make the file size enormous.  Has anyone tried this before and does it?

ShaneG.


I reject your reality and substitute my own

 WWW  

User avatar

Sage Collector
Acaeum Donor

Posts: 2483
Joined: Nov 06, 2002
Last Visit: Jul 24, 2026
Location: Queensland, Australia

Post Posted: Sun Nov 28, 2010 8:45 pm 
 

I of course use excel.. I haven't thought of embedding images, I know what Dragon Mags looks like and I can always google an image.. sounds like a lot of work with no real added benefit.. besides sites like the acaeum wiki/ Noble knight/ToT/ Amazon have the images pretty well covered..

Brette:)


Being healthy is merely the slowest possible rate at which one can die.

 WWW  

User avatar

Long-Winded Collector

Posts: 4756
Joined: Oct 31, 2004
Last Visit: May 02, 2025
Location: Caddo Mills, TX

Post Posted: Sun Nov 28, 2010 9:09 pm 
 

beasterbrook wrote:I haven't thought of embedding images, I know what Dragon Mags looks like and I can always google an image.. sounds like a lot of work with no real added benefit.

The photos I take arent for casual reference.  They are for insurance purposes.

Plaag wrote:Course this idea of adding pictures sounds like it would make the file size enormous. Has anyone tried this before and does it?

I havent tried it but based on what I know of Excel and what I "googled" about it, it should work.  I currently have a bit over 4 GB of photos of just my RPG collection.  Hyperlinking the photos can become a problem if you move the photos.  That breaks the links in the spreadsheet.  Embedding them means that if I decide to move the spreadsheet to an external hard drive or memory stick, there are no links to break.

This is just an idea.  I may realize later that it isnt worth the effort.  :)


You don't like your job, you don't strike. You go in every day and do it really half-assed. That's the American way. - Homer Simpson

  

User avatar

Long-Winded Collector
Acaeum Donor

Posts: 3865
Joined: Feb 21, 2004
Last Visit: Jul 20, 2023
Location: Milford, Michigan

Post Posted: Sun Nov 28, 2010 10:20 pm 
 

My first thought was to hyperlink, but I agree about the moving file issue. Way too much work with a possibility of a break.

I have not tried to directly embed, but maybe I will give it a shot.

By the way, I have a folder with pratically every item I ever sold on ebay in pic form. It is huge!


And I could've bought these damn modules off the 1$ rack!!!

New modules for your Old School game http://pacesettergames.com/

Everything Pacesetter at http://pacesettergames.blog.com/

 WWW  

User avatar

Sage Collector

Posts: 2736
Joined: May 31, 2007
Last Visit: Jul 09, 2026

Post Posted: Sun Nov 28, 2010 10:35 pm 
 

Nice. I've gotten through three shelves so far. But, my stuff is nowhere neat as yours, so who cares. Maybe I'll have some spare money to buy a thing if you decide to sell... if the price is right.


Those who can, don't. Those who should not, do.

  

User avatar

Grandstanding Collector

Posts: 6172
Joined: May 03, 2003
Last Visit: Feb 10, 2026
Location: Waterloo, Ontario, Canada

Post Posted: Mon Nov 29, 2010 12:34 am 
 

Generally, the images aren't actually wrapped up into the excel file are they?  I think normally the images are still stored somewhere else and it links in the location (directory path and name) for the file.  You probably set the column type to be "image" or something so it knows to interpret it as an image and show a thumbnail.

I guess they probably could have an option to encapsulate everything into one giant excel file but that just seems crazy.

I remember working on a project like this when I worked up North for a surveying company.  They were scanning in all their surveying maps and getting rid of the huge warehouse of bins that stored the originals.  Everything was going into the excel file to quick and easy access instead of sending someone to the warehouse to try and find a specific map.  Also, digital storage is cheaper than the warehouse rental.

 WWW  

User avatar

Long-Winded Collector

Posts: 4756
Joined: Oct 31, 2004
Last Visit: May 02, 2025
Location: Caddo Mills, TX

Post Posted: Mon Nov 29, 2010 1:17 am 
 

You can do it several different ways.  Some are easier than others I have figured out.  I was able to attach the photos to individual cells in the spreadsheet but it was a pain to deal with shrinking the photos down to a more manageable size.  They werent linked since I tested moving the photo to a different location and the picture still appeared (file size increased as well).  However if I hyperlinked it and moved it, the link no longer worked.  Embedding vs. linking also creates a whole different problem when printing as you might imagine.

Messing around with this has made me realize that Excel just isnt built to do some of the stuff I want.  I guess could use Access but I dont really know how to use it that well and I really dont want to spend the time learning to.  :roll:

Another idea I considered is putting everything in my LibraryThing account (or creating a new one specifically for RPGs).  And if I really want to there is the option to upload your own photos.  Only problem is, if the item doesnt have an ISBN you may not be able to add it.


You don't like your job, you don't strike. You go in every day and do it really half-assed. That's the American way. - Homer Simpson

  

User avatar

Prolific Collector

Posts: 541
Joined: Oct 26, 2005
Last Visit: Jun 02, 2026

Post Posted: Mon Nov 29, 2010 8:24 am 
 

You guys are way more organized than me.  But this thread has inspired me to catalog my own very modest collection.  I'm moving in a couple of weeks anyway, so I may as well take the opportunity to spread my stuff out and see what I've got.

It does sound like a good idea for insurance too, but does insurance even cover this kind of stuff?


The owls are not what they seem...

  

User avatar

Long-Winded Collector

Posts: 4756
Joined: Oct 31, 2004
Last Visit: May 02, 2025
Location: Caddo Mills, TX

Post Posted: Mon Nov 29, 2010 9:09 am 
 

Agent Cooper wrote:It does sound like a good idea for insurance too, but does insurance even cover this kind of stuff?


It really depends on which company you have your homeowner's insurance with.  My wife is an adjuster with Kemper and they offer a specialized policy that covers replacement costs for stuff like this.  But if you are with a company like Allstate or Farmers it may not.  And if they dont there are specialty insurance groups that do valuations and write policies just for collectibles of this nature.


You don't like your job, you don't strike. You go in every day and do it really half-assed. That's the American way. - Homer Simpson

  
Next
Post new topic Reply to topic Page 1 of 21, 2