How do you inventory your collection?
Post new topic Reply to topic Page 1 of 21, 2
Author


Prolific Collector

Posts: 117
Joined: Feb 05, 2005
Last Visit: Sep 14, 2008
Location: Ottawa, Canada

Post Posted: Thu Feb 16, 2006 3:00 pm 
 

My last question about the size of collections showed some really big ones that give us beginning collectors some idea what we're in for over the long haul.

So, I have another question for you.  How do you keep track of what you've got?

Again, I'll start this and say I keep everything in an Excel file that contains a wealth of information about the product including my purchase cost.  That being said, I'm in the process of migrating that simple flat database to a fully realtional one in Access.


Gary H. Kramer

  


Active Collector

Posts: 99
Joined: Jan 27, 2006
Last Visit: May 04, 2015

Post Posted: Thu Feb 16, 2006 3:22 pm 
 

I used to have an incomplete longhand on legal pad but I'm now entering final details into an Excel doc. Will probably build a custom one once I'm finished (to include photos, long personal notes and such).

I'd love to hear how guys like Frank, et al and the big online sellers keep track.


"Surely you don't disbelieve the prophecies just because you had a hand in bringing them about?" J.R.R. Tolkien

  

User avatar

Long-Winded Collector
Subweb Admin
JG Valuation Board

Posts: 4497
Joined: Nov 08, 2002
Last Visit: Jul 29, 2021
Location: Land of 10,000 ponds

Post Posted: Thu Feb 16, 2006 3:24 pm 
 

I keep track of my collection as a Word document, listed roughly by edition or company, book price, and value. Not the greatest information wise, but serves its purpose.

ShaneG.

 WWW  

User avatar

Grandstanding Collector

Posts: 5634
Joined: Jun 30, 2003
Last Visit: Jul 27, 2021
Location: New Hampsha

Post Posted: Thu Feb 16, 2006 4:24 pm 
 

Multiple Word documents. One for hardcovers, one for modules, one for rares, etc. I leave a printout on each shelf with what it contains, and if something comes in I write it on the sheet, then update every once in a while.
I could probably bribe the wife into making Excel sheets, but I'm too cheap to bother.

 WWW  


Prolific Collector

Posts: 671
Joined: Dec 17, 2005
Last Visit: Feb 13, 2019
Location: Italy

Post Posted: Thu Feb 16, 2006 4:24 pm 
 

Basically, I use the famous checklist pdf, keeping in memory whatever is missing on that list.

I am planning to move to a MySQL database when I have the time and I'm in the right mood.

 ICQ  

User avatar

Sage Collector
Acaeum Donor

Posts: 2459
Joined: Nov 06, 2002
Last Visit: Jul 05, 2021
Location: Queensland, Australia

Post Posted: Thu Feb 16, 2006 4:43 pm 
 

multiple excel sheets, one for every letter of the alphabet, then listed by company name, system, name,  stock number, print date and notes

Brette:)

 WWW  


Sage Collector
Acaeum Donor

Posts: 2884
Joined: Nov 04, 2004
Last Visit: May 09, 2020

Post Posted: Thu Feb 16, 2006 4:45 pm 
 

Excel. I'd prefer a database, but I'm a 12th-level Excel user and a zero-level NPC with any database programs.

 WWW  


Prolific Collector

Posts: 261
Joined: Dec 17, 2003
Last Visit: Dec 09, 2017
Location: Upstate New York

Post Posted: Thu Feb 16, 2006 5:13 pm 
 

i use an access database.  it does the job right now, just not pretty.  it's a work in progress, meaning it will never be done ;)


-dave

  

User avatar

Long-Winded Collector
Acaeum Donor

Posts: 3593
Joined: Dec 20, 2003
Last Visit: Jul 27, 2021
Location: Canada

Post Posted: Thu Feb 16, 2006 5:16 pm 
 

Multiple page excell document.  It is getting really huge to.

J


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: 3861
Joined: Feb 21, 2004
Last Visit: Jul 20, 2021
Location: Milford, Michigan

Post Posted: Thu Feb 16, 2006 5:17 pm 
 

Excel.

I have it broken down by manufacturer with some sublists.


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  


** Banned **

Posts: 148
Joined: Dec 02, 2005
Last Visit: Jan 26, 2007
Location: San Francisco, CA

Post Posted: Thu Feb 16, 2006 5:43 pm 
 

Another vote for multi sheet Excel document. One sheet for fantasy RPGs, another for milsim RPGs, another for wargames, another for wargame magazines (mags w/ games in them), etc.

For the FRPG section everything is organized first according to system(AD&D 1st ed, AD&D 2n ed, OD&D, Hackmaster, etc) then alphabetically. Columns include system, title, edition, contents (adventure, sourcebook, camaign, etc), code reference, publisher, year, condition, and cost. Seems to work great for me. I take a printed copy with me place to place.

 WWW  


Verbose Collector
Acaeum Donor

Posts: 1043
Joined: Jan 06, 2004
Last Visit: Jul 01, 2020
Location: Leicester, UK

Post Posted: Thu Feb 16, 2006 7:28 pm 
 

Nothing.  Its all in my head! :? Which expalins why I often end up buying stuff I already own.

  


Sage Collector
JG Valuation Board

Posts: 2749
Joined: Feb 10, 2003
Last Visit: Jul 29, 2021
Location: Olde London Towne

Post Posted: Thu Feb 16, 2006 7:46 pm 
 

Oh yes, yet another vote for excel.
I am a complete spreadsheet geek.  :)


Let's go fly a kite
Up to the highest height!

  


Grandstanding Collector
Acaeum Donor

Posts: 6463
Joined: Dec 13, 2004
Last Visit: Apr 04, 2021

Post Posted: Thu Feb 16, 2006 7:46 pm 
 

johnhuck wrote:Nothing.  Its all in my head! :? Which expalins why I often end up buying stuff I already own.


Hmmm, this sounds amazingly familiar. :?


"He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you." -Neitzche

  

User avatar

Sage Collector

Posts: 2495
Joined: Feb 07, 2006
Last Visit: Jul 27, 2021
Location: France / Cité des Papes

Post Posted: Thu Feb 16, 2006 8:59 pm 
 

Plaag wrote:I keep track of my collection as a Word document, listed roughly by edition or company, book price, and value. Not the greatest information wise, but serves its purpose.

ShaneG.


Me too :)

And for my boardgames on a wonderfull website trictrac.com

 WWW  


Prolific Collector

Posts: 125
Joined: Oct 27, 2003
Last Visit: Aug 23, 2017
Location: Atop a heap of slain orcs

Post Posted: Thu Feb 16, 2006 9:21 pm 
 

Big cardboard box, little cardboard box.  :?


Bree-Yark!

  

User avatar

Prolific Collector
Acaeum Donor

Posts: 558
Joined: Sep 02, 2004
Last Visit: Jul 26, 2021
Location: Cape Cod

Post Posted: Thu Feb 16, 2006 9:34 pm 
 

johnhuck wrote:Nothing.  Its all in my head! :? Which expalins why I often end up buying stuff I already own.


ditto here

  

User avatar

Verbose Collector
Acaeum Donor

Posts: 1253
Joined: Jan 01, 2003
Last Visit: Jul 27, 2021

Post Posted: Fri Feb 17, 2006 12:04 am 
 

On multiple legal pads, though one day I fantasize about having the spare time to put it all together in Access or MySQL.

  

User avatar

Grandstanding Collector

Posts: 6077
Joined: May 03, 2003
Last Visit: Jul 29, 2021
Location: Waterloo, Ontario, Canada

Post Posted: Fri Feb 17, 2006 12:18 pm 
 

I would really like to put it all into a spreadsheet but for the most part my collection listing is by what i don't have.  I maintain a list of the items I need and then cross them off.  It is a small font and 3 columns per side so it fits on one sheet of paper :)

 WWW  

User avatar

Verbose Collector
Acaeum Donor

Posts: 1709
Joined: Feb 04, 2004
Last Visit: Aug 23, 2016
Location: Chandler, AZ

Post Posted: Fri Feb 17, 2006 1:24 pm 
 

My personal collection is quite small - only a few hundred items and I don't even botter keeping inventory of them.

However, I have sold about 4,500+ items over the last 3 years.  I have tracked every single item I sold in excel.  I have 4 different Workbooks, each with about 5 worksheets.  All items are tracked to the lot I purchased them in and the lot cost.  These are listed individually with the sale price and shipping charge.  The spreadsheet then calculates that Net price after deducting all applicable ebay, paypal and shipping costs.  All items sold are then added and count against the purchase price of the lot, ultimately ending in a "Net Profit" (or loss).

I am at about #360 (which indicates the 360th lot I purchased from ebay or other sources.

I also have 8,000 scans/digital pics (1.6 GB) - I used to delete them or I'd have quite a bit more.  Each scan is kept in a folder for the particular RPG and/or publisher and listed by the game, name and lot #.  

i.e. ADDtombofhorrorslot291.jpg , warhammerapocryphanowlot221.jpg , changelingkithbooksatyrslot98.jpg ,etc.  Unless I took a digital picture of a box set and contents, these usually all have a corresponding scan of the back cover (listed with "back").


"Gleemonex makes it feel like it's seventy-two degrees in your head... all... the... time! "

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