How do you do it?

Discussion in 'Transformers General Discussion' started by CrackerBoy, Dec 26, 2005.

  1. CrackerBoy

    CrackerBoy SeƱor Member TFW2005 Supporter

    Joined:
    May 31, 2005
    Posts:
    1,387
    Trophy Points:
    206
    Likes:
    +0
    How do you keep track of your collection??

    Do you use an excel spreadsheet or a database of some sort?? I'm curious because as my collection is slowly growing i've been wondering how to keep track of it all. I was thinking a making an access database where you could pick ... say Op. Prime. Then select all the series he's been in i.e. G1, G2, etc.. then select the version (hasbro, hasbro reissue, Taraka reissue) and a list of all the parts for that release would display. You could select what parts you have, or if it's MISB or MIB etc. I'd also add a cost field and date field so i know what i paid and when... cause i care.

    Anyone use anything like that?? or would use?
     
  2. fschuler

    fschuler Member TFW2005 Supporter

    Joined:
    Nov 28, 2005
    Posts:
    2,202
    Trophy Points:
    216
    Likes:
    +0
    Hey Crackerboy,

    I have used an Excel sheet in the past, but, I last updated it roughly 75 TFs ago. I need to get my @$$ back into gear. And yeah, the Access database is a good idea too.

    Each row in my excel spreadsheet consisted of TF name, allegiance, series (G1, 2, BW, etc.), subgroup (aerialbot, headmaster, etc.), condition (C1-10), completeness, and approximate value. I figured the approximate value field is largely useless, since there's no guarantee that I would get a certain amount for the bot or expect to pay some certain amount for a bot (just look at some of the prices given in the price guides on http://www.coldhardslag.com/ and compare those to prices on ebay and in online shops; big differences! I did, however, "toy" around with the idea of including the amount I actually paid for an item so that I could track, potential, return on investment, if any :cry  .

    If I'm not mistaken, I believe there are ready made "collectors" database programs out there, though, they may be more than what you need for your own personal purposes. Have fun!
     
  3. butz

    butz slippery when wet

    Joined:
    Dec 18, 2003
    Posts:
    6,904
    Trophy Points:
    211
    Likes:
    +0
    I just try to keep track of it by memory; it usually works, but every once in a while I forget I already have something and wind up buying it twice... doesn't happen too often though. I usually only slip up when I go back to a part of my collection I've been neglecting for awhile.
     
  4. Rumble02

    Rumble02 Radicon of Obliticons

    Joined:
    Sep 29, 2005
    Posts:
    10,204
    Trophy Points:
    267
    Likes:
    +25
    im just so geeky that i dont forget
     
  5. Firestorm

    Firestorm Red Mage in Training

    Joined:
    Oct 21, 2002
    Posts:
    262
    Trophy Points:
    111
    Likes:
    +0
    I'll usually remember if I have a toy or not, so I don't write them down (my mother tried to get me to spreadsheet them, but it was too much hassle).

    The only figures I own multiples of are ones that I bought, then someone gave me one as a gift, or if it was a second-hand figure that I later found one in better condition.
     
  6. Nerd Bomber

    Nerd Bomber Consulting your needs

    Joined:
    Jul 16, 2002
    Posts:
    5,690
    Trophy Points:
    211
    Likes:
    +0
    I have a giant brain that is able to reduce any complex machine into a simple yes or no answer. Keeping track is no problem.
     
  7. Cruellock

    Cruellock Disney Villain

    Joined:
    Feb 14, 2004
    Posts:
    4,857
    Trophy Points:
    186
    Likes:
    +0
    I've got no problems keeping track of my collection. Of course, I have no idea how many Transformers I have in total.
     
  8. Backscatter

    Backscatter Autobot Brainmaster TFW2005 Supporter

    Joined:
    Mar 24, 2003
    Posts:
    6,774
    News Credits:
    3
    Trophy Points:
    241
    Likes:
    +3

    Same, I know more names of Transformers than I do of people. For the most part I find TFs more interesting too. (TF Fans excluded). I'm a computer Geek and get paid for it.

    P.S. I lost the exact number count of Transformers I had in the late 90's. But I would know if one was missing.
     
  9. Chaos Muffin

    Chaos Muffin Misadventure Veteran

    Joined:
    Mar 26, 2004
    Posts:
    28,751
    Trophy Points:
    322
    Likes:
    +4
    Giant notebook. All seperated by year & faction. Then a A-Z list of other toylines including what I have for each.
    Plus a custom Encyclopedia with pics, checklists, fold out catalogs etc. From Diaclone to Energon.
    Also a gaint binder full of figure cards and some homeade Gen1 cards for bio & info on the G1's I own
     
  10. Gears

    Gears buh-buh-body ya Veteran

    Joined:
    Dec 19, 2004
    Posts:
    24,583
    News Credits:
    12
    Trophy Points:
    296
    Likes:
    +12
    Ebay:
    I can remember all of the stuff I have, no problemo!
     
  11. soundwaveCA

    soundwaveCA Veteran

    Joined:
    Jul 4, 2002
    Posts:
    13,862
    News Credits:
    2
    Trophy Points:
    266
    Likes:
    +2
  12. Greyryder

    Greyryder Kitbashed

    Joined:
    May 9, 2004
    Posts:
    4,585
    Trophy Points:
    186
    Likes:
    +0
    I don't have enough stuff to forget that I have things.

    Though, I do seem to have more stuff, than I have shelves....
     
  13. Orodruin

    Orodruin @deathformer TFW2005 Supporter

    Joined:
    Aug 2, 2004
    Posts:
    11,393
    News Credits:
    4
    Trophy Points:
    286
    Likes:
    +5
    I keep what I have in my head, though every once in a while there will be a figure that I can't remember if I have or not. I think I should do that next year though, keep track with a spreadsheet or something. Just for kicks as stuff.

    The stuff I'm still after is what I usually write down though.
     
  14. Sol Fury

    Sol Fury The British Butcher Administrator News Staff

    Joined:
    Nov 22, 2002
    Posts:
    35,576
    News Credits:
    4
    Trophy Points:
    317
    Likes:
    +34
    Facebook:
    Instagram:
    I know most stuff, unless we start getting into Micromasters. Those guys are impossible for me to keep track of.
     
  15. Rodimus Prime

    Rodimus Prime Sola Gratia, Sola Fide TFW2005 Supporter

    Joined:
    Jul 12, 2002
    Posts:
    11,520
    Trophy Points:
    287
    Likes:
    +23
    My mind and my boxes. Real men remember. :p 
     
  16. GALVATOM

    GALVATOM Well-Known Member

    Joined:
    Jun 26, 2005
    Posts:
    1,725
    Trophy Points:
    187
    Likes:
    +39
    I pretty much know every one I have, I just miss ones out if people ask me to tell them what Ive got. So I have a list I keep track of in Word Document.
     
  17. SydneyY

    SydneyY @syd_tfw Veteran TFW2005 Supporter

    Joined:
    Mar 29, 2005
    Posts:
    11,516
    News Credits:
    74
    Trophy Points:
    276
    Likes:
    +74
    I don't have many so naturally I don't forget. (Maybe except for Minicons)
    But sometimes I forget why I passed on a certain figure and get it later on.
     
  18. Kupp

    Kupp Ford Fanboy TFW2005 Supporter

    Joined:
    Jun 1, 2005
    Posts:
    2,729
    News Credits:
    1
    Trophy Points:
    216
    Likes:
    +1
    I use an excel spreadsheet, and have it set up to do the math for me. I also keep track of my allegiance sizes as well as remove duplicates for actual faction composition counts. Yes, I am anal.
     
  19. Neomarsala

    Neomarsala Transform and Roll Out

    Joined:
    Aug 24, 2002
    Posts:
    1,121
    Trophy Points:
    161
    Likes:
    +0
    I have an Excel spreadsheet, but I just use it as a checklist. I have a page for each category(i.e. G1 Autobots, G1 Decepticons, BW Maxies, BW Preds, etc...). Each page has one column with all the toys that I want and one column with all the toys that I own. Whenever I buy something I move it from the "want" column to the "own" column. I have other columns where I can list missing parts and stuff. I don't have a huge collection right now so I can probably remember everything I have, but I thought it would be fun to make a checklist. I guess that way I can feel like I'm working towards something.
     
  20. Steeljaw

    Steeljaw Owner of TF Rebellion.com

    Joined:
    Nov 11, 2004
    Posts:
    250
    Trophy Points:
    111
    Likes:
    +0
    Ditto
     

Share This Page