PDA

View Full Version : Tracking my Star Wars collection



Jedi4Spam
06-15-2005, 09:56 PM
Hello All...

I am a newbe to these forum groups and I have a question regarding my large Star Wars collection. I am sure there are alot of people out there that have a large Star Wars collection. The problem where I come into is... when I go to the store to purchase another figure or buy a Star Wars collectible on Ebay... I am not sure what I have already. So my question is... is there an application out there that tracks this type of information... e.g. figures, ships, videos, games etc.? If I could enter this information and then print out a report of the figures for example that I already have... it would make my life a lot simpler.

Cheers!

Brett

Bobby Fett
06-15-2005, 10:38 PM
Welcome aboard! :)

I use Excel and am very happy with it. 1-2-3 would also do a fine job.

The initial data entry is tedious, but once that's done it's a snap to keep it up to date. You just have to be conscientious about updating it.

I have also used Word to create a pocket checklist of what I need. Using 6 point type, my list fits on both sides of one sheet. I fold it up and carry it in my wallet.

Kidhuman
06-16-2005, 12:51 AM
I go off of memory, which is a feat in itself considering I can remember all I have and it is alot. I will sit down one day and make a list and execl spreadsheet or something, but until Alzheimers sets in, memory is the way to go. A mind is a terrible thing to waste.

Slicker
06-16-2005, 02:15 AM
I go off of memory, which is a feat in itself considering I can remember all I have and it is alot. I do the same thing which is probably why I have at least 20 double figures just chillin' in my storage garage. I do pretty well but I know for a fact that I'm forgetting some of the earlier stuff that I passed on so I could buy it at a later date. If I had some motivation I'd put it on my computer but I could care less.

megaprime33
06-16-2005, 06:07 AM
I actually archived all of my toys, not just TFs, in Word. It's a very simple looking archive, but at least it's all listed. I did the same with my dvd collection. It's a pain to catalog everything when you first do it, but it's fairly easy after that. Just remember to update it!

Sith Lord 0498
06-17-2005, 04:45 PM
I used MS Works Database. I have item descriptions, category and sub-cat, series/line, company, price paid, market value, exclusive or not, any customizations I did, and special notes (such as edition number, etc.) It works very well.

Lowly Bantha Cleaner
06-20-2005, 01:47 PM
I too strongly recommend using a database to catalogue. I remember way back when, when I first started to list the items I had, I did it by hand on paper. It became very monotonous and I had lots of erase marks. Didn't look neat or professional, especially with my chicken scratch.

Excel is now what I use to list the items I get and the catergories I have are item name with room for a description or special note, condition, whether it is boxed or loose, the price paid, where purchased, and # of items. There are different colored cells to indicate which line the product came from (like for my Cinema Scenes area) and different colors also indicate if the item was acquired in a trade or if it was purchased less than retail. At the bottom of the spreadsheet, I included a formula to list the total I paid for my collection and right now it stands at around $4,700 for 10 years of collecting. The total does not compile gas money or wasted tears :cry:

Everytime I get something new, I keep it by the computer until it gets listed. Once it has been listed it is free to move around the house.

JetsAndHeels
06-20-2005, 03:19 PM
Just today I organized and did an inventory on my SW collection. Most of what I have is boxed up and/or in rubbermaid containers, but I wanted to actually mark on the box/container what its contents were.
So I spent a good part of the day today re-organizing and labeling all my stuff. Got things stored by movie and set...Ep1, 2, 3, POTJ, POTF2, deluxes, vehicles, miscellaneous, etc. For each box or container I listed each figure and type (red card, orange card, saber variations, etc) and also the quantity (for those I had extras of).
It took a good deal of time, but it was well worth it and I was also able to refresh my memory on all the figures and collectibles I have.

nash
06-20-2005, 06:57 PM
I wish i had this problem. My collection is just not big enough yet :bored:

JetsAndHeels
06-20-2005, 07:38 PM
I wish i had this problem. My collection is just not big enough yet :bored:

Patience...it will grow in time. And for folks like me it doesn't take long when we buy things in mass quantities!! :D

bobafrett
06-20-2005, 10:37 PM
I go off of memory, which is a feat in itself considering I can remember all I have and it is alot. I will sit down one day and make a list and execl spreadsheet or something, but until Alzheimers sets in, memory is the way to go. A mind is a terrible thing to waste.


I also go that way, and I have like 5 princess Leia's. Today I almost bought a Clone commander, until I realized I had 2 at home. Luckily I was right.

It's also nice to have an inventory for insurance purposes. If any damage or theft was to occur, you would be able to collect depending on your policy. It's better than trying to ":remember" everything you have when you are stressing because your house got flooded and all your carded figures are in a wet mucky pile.

Sith Lord 0498
06-21-2005, 05:14 PM
At the bottom of the spreadsheet, I included a formula to list the total I paid for my collection and right now it stands at around $4,700 for 10 years of collecting. The total does not compile gas money or wasted tears :cry:

Everytime I get something new, I keep it by the computer until it gets listed. Once it has been listed it is free to move around the house.

Don't feel too bad. My current 10 year total is at $6,480. Keep in mind that items I've sold or traded off are not counted in that total, so I'd estimate that the actual total is somewhere around $7,000. And I'm only 23, so that's a fairly shocking total.

X13VADER
07-13-2005, 08:08 AM
Well Does Anyone Have A Sample Page They Can Show For Demo Only?

Lowly Bantha Cleaner
07-13-2005, 09:25 AM
Here is a sample, on Microsoft Word, that displays part of my collection that is stored on a Spreadsheet for Excel. Excel spreadsheets aren't valid files to be uploaded on this site, so that is why I used Microsoft Word. I copied from Excel and pasted it on to Word. The margins look uneven, but in reality, everything is aligned on Microsoft Excel.

Notice that I included a key at the bottom of the sheet to discern the multitude of colors for each collection. I also have a formula that computes the amount spent on the collection, as shown at the bottom as well.

I could also have a few more columns, with things like date purchased, manufacturer, etc. but I have kept it simple for now.

kool-aid killer
07-13-2005, 11:38 AM
From POTF2 to the start of the Saga line ive got it all scribbled down on a notebook, it takes up a couple of pages, with each page having two columns worth of figures names on them. From the Saga line on its all in the old noggin. Plus, its not difficult when i think in terms of what i am missing as opposed to what i do have.