Prufrock wrote:Hi Guys,My collection is growing quite large. I have now run into the problem of keeping track of everything (electronically). I have separate exel sheets for D & D Modules, AD &D Modules, Books & Rule Sets, Forgotten Realms, Greyhawk, Periodicals (Dungeon, Polyhedron, Dragon magazines). The problem is (as some of you well know) some of this stuff fits more than one catagory. Example AD & D I14 Swords of the Legion - I have placed this on the AD & D modules spreadsheet. However, since it is a Forgotten Realms Module it could go onto the Forgotten Realms spreadsheet. I guess I would like to hear how you all (especially those of you with incredibly large collections) keep it all straight?Thanks Martin
bclarkie wrote:Prufrock wrote:Hi Guys,My collection is growing quite large. I have now run into the problem of keeping track of everything (electronically). I have separate exel sheets for D & D Modules, AD &D Modules, Books & Rule Sets, Forgotten Realms, Greyhawk, Periodicals (Dungeon, Polyhedron, Dragon magazines). The problem is (as some of you well know) some of this stuff fits more than one catagory. Example AD & D I14 Swords of the Legion - I have placed this on the AD & D modules spreadsheet. However, since it is a Forgotten Realms Module it could go onto the Forgotten Realms spreadsheet. I guess I would like to hear how you all (especially those of you with incredibly large collections) keep it all straight?Thanks MartinTruthfully, I do it via memory for the most part. I have doen inventories in the past just by writing a "want list" after going through my stuff and finding the holes, but for the most part I work from memory. Obvious Note: This is proabably not the best way to keep track of your stuff.
bclarkie wrote:Prufrock wrote:Hi Guys,My collection is growing quite large. I have now run into the problem of keeping track of everything (electronically). I have separate exel sheets for D & D Modules, AD &D Modules, Books & Rule Sets, Forgotten Realms, Greyhawk, Periodicals (Dungeon, Polyhedron, Dragon magazines). The problem is (as some of you well know) some of this stuff fits more than one catagory. Example AD & D I14 Swords of the Legion - I have placed this on the AD & D modules spreadsheet. However, since it is a Forgotten Realms Module it could go onto the Forgotten Realms spreadsheet. I guess I would like to hear how you all (especially those of you with incredibly large collections) keep it all straight?Thanks MartinTruthfully, I do it via memory for the most part. I have doen inventories in the past just by writing a "want list" after going through my stuff and finding the holes, but for the most part I work from memory. :) Obvious Note: This is proabably not the best way to keep track of your stuff. :roll:
Blackmoor wrote: I did the memory thing for a while, ended up with 3 copies of the marklands (never could remeber if I had that one) and none of Iuz the Evil (I was sure I had that one ) I now use a very comprehensive Excell sheet, spilts printings, condition, values. It rules.J
bclarkie wrote:Blackmoor wrote: I did the memory thing for a while, ended up with 3 copies of the marklands (never could remeber if I had that one) and none of Iuz the Evil (I was sure I had that one :? ) I now use a very comprehensive Excell sheet, spilts printings, condition, values. It rules.JYea, every once in a while I have come with unintentional dups. I also for the longest time though that I had all the AC supps, but lo and behold I just realized several months ago that I had dup copies of AC8 and none of AC3. :x Now it reamains as the only item outdide of the lever 4 & 5 rarities that I dont have at least 1 copy of. :roll: Of course that does stop me from bidding on items I already own looking to upgrade and hopefully in the not so distant future will be able to finally complete my collecting goal of owning at least 1 copy of 1st ed AD&D/D&D common modules and itmes in original shrink. 8O
Blackmoor wrote: I did the memory thing for a while, ended up with 3 copies of the marklands (never could remeber if I had that one) and none of Iuz the Evil (I was sure I had that one :? ) I now use a very comprehensive Excell sheet, spilts printings, condition, values. It rules.J
Prufrock wrote:Hi Guys,I have separate exel sheets ...The problem is (as some of you well know) some of this stuff fits more than one catagory.
Marlith wrote:I go back and forth on shrinkwrap. I want to be able to read it. Often time the only reason I buy in the shrink is so I can get an item in better shape. If I can't pick it up, open it and read it then I have to question why I own it, unless it is to perhaps years down the road resell.
beyondthebreach wrote:This reminds me of a question I have. I use excel to track all my sales, however, I have been wondering for some time how you can add a "drop down arrow" feature to a cell so that it can be used for multiple formulas (i.e. you click the drop down which lists two or more possible formulas and select which one you want to the cell to use).Every time I think of it, I get bored trying to navigate through the miasma of Excel "help". This would aid me greatly in computing the cost for Paypal fees (domestic vs. international) and ebay fees when the sale goes above $25. For years I've been manually changing the equations when these situations come up.thanks!!!
Prufrock wrote:Marlith wrote:"Earlier this year or late last year someone sent me a PDF that was basically a checklist. I printed it out and have my copy but for the life of me I can not find the electronic. It was made to look like a 1st or 2nd edition module and had the letters CC in its code. Does anyone here remember this as this would work well for what Prufrok wants I think".I have a copy of this, thanks Marlith. I will be going thru the collection with it in hand to determine the holes I have. I was just wondering how everyone else keeps track of their collection. Martin
Prufrock wrote:I guess I would like to hear how you all (especially those of you with incredibly large collections) keep it all straight?
bclarkie wrote:Truthfully, I do it via memory for the most part.
afoolandhis$ wrote:Unlike most of the "well-endowed" members of this board, mine is actually a fairly small collection...and I don't mind admitting to it because in this case it's not really the size that counts. :P Er...riiiiight.So, I just keep a mental list, and can see most of it on the bookshelf. However, I have been giving thought to listing it all in an Excel spreadsheet or something like that. I guess the main reason I haven't to date is because doing so would undoubtedly tempt me to add up the amount I've spent building this little collection, and that's more than I want to know.