Page 1 of 1
How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 11:57 amby Aeros
So I had some time on my hands and an empty room so I dicided to pull all my TF boxes out of my closet and take a look at all i had packed away. Now i have over 100 TF on display on shelves in this room but i decided it was time to take an inventory. My Girlfriend decided to help and she whipped up a spread sheet and we started inventorying all i had collected since G1
I have to say thank Primus for
http://www.TFU.info there were so many names I had forgotten it really helped me pin point 99% of the bots I had forgotten. When all was said and done including about 100 minicons i have
607 Transformers from most lines American and Japanese. To make it even worse last night i even added dollar amounts to each one to denote how much i approx. paid for each. with a excel formula it all added up to close to 10,000 dollars.
So my question is has anyone else gone to any lengths like this to inventory your collection?
Re: How many TFs do you own/ Is making a spread sheet make me a
Posted:
Wed Oct 15, 2008 12:00 pmby OPTIMUS MAGNUS
Wow man, sounds like a nice one! My offical count including MISB, doubles and kitbashed/re-painted is 298.
Re: How many TFs do you own/ Is making a spread sheet make me a
Posted:
Wed Oct 15, 2008 12:10 pmby Counterpunch
Aeros wrote:So I had some time on my hands and an empty room so I dicided to pull all my TF boxes out of my closet and take a look at all i had packed away. Now i have over 100 TF on display on shelves in this room but i decided it was time to take an inventory. My Girlfriend decided to help and she whipped up a spread sheet and we started inventorying all i had collected since G1
I have to say thank Primus for
http://www.TFU.info there were so many names I had forgotten it really helped me pin point 99% of the bots I had forgotten. When all was said and done including about 100 minicons i have 607 Transformers from most lines American and Japanese. To make it even worse last night i even added dollar amounts to each one to denote how much i approx. paid for each. with a excel formula it all added up to close to 10,000 dollars.
So my question is has anyone else gone to any lengths like this to inventory your collection?
Yes.
I made a massive spreadsheet about a year or so back which calculates MSRP, what I actually paid, and current worth. It runs all kinds of stats for each series and then for the collection as a whole.
I made it available to a lot of people last year when it was just starting out, but have kind of quit doing so.
Insurance makes me do crazy things.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 12:13 pmby TFBuyer
One day I'll do this, but it's got to be nearing 1,000... That's TFs from every line (with limited G2, though) since G1, many of those lines nearly complete.
Insurance alone should make me want to do this sooner rather than later...
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 12:18 pmby Aeros
ok Question about insurance. DOes general home owners insurance cover a collection of "toys" or do you need to get a specialized insurance?
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 12:22 pmby Counterpunch
Aeros wrote:ok Question about insurance. DOes general home owners insurance cover a collection of "toys" or do you need to get a specialized insurance?
I'm a walking public service announcement.
viewtopic.php?f=4&t=34185
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 1:16 pmby DJSoundwave
I've done spreadsheets for several toyline including Transformers ... and I have over 4000 transformers.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 1:55 pmby WolfDawg
I think my collection is around 210 or so. I've thought about doing a spread sheet but I've never gotten around to it. I may end up doing a spreadsheet by the end of the week though, thanks to this thread. I'm interested to see how much my collection is worth.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 2:06 pmby muswp1
I made a spread sheet this summer to calculate mine, but I haven't updated it in a month. Last time I checked, I had 453.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 2:23 pmby payload
I have well over 2000 transformers as of last count. I'm probably at around the 3000 mark at this point, just don't have the time to count them all. I've been collecting for over 20 years though so it's not like they have all been bought at once, it's been a work in progress.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 2:28 pmby GuyIncognito
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 2:46 pmby Powersa
I have a spreadsheet for my TFs, about 195 or so, a few figures from each line.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 4:45 pmby Primacron's Little Helper
If the missing word from the title is geek then I think it makes you a sensible geek!
It makes sense for insurance purposes and generally for keeping track of how much you've spent - I'm sure we've all had that horrible realisation of how much you've spent, which you can then try and keep under better control.
My lucky number is 173.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 8:17 pmby El Duque
A spreadsheet is a good idea and something I need to do. Currently I have between 400 and 500 figures. I've been pretty selective about what I buy not a lot of filler figures.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 8:42 pmby Cascadia
My collection count is 100. Having checklists and an inventory of what you have is an excellent idea.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 8:55 pmby Zeds
I did up a spreadsheet and took photos of each and every one for insurance purposes. I ended up with 2,000 TFs from G1 to present with a total value of $65,000. I would recommend doing the spreadsheet and taking photos just to insure the collection in case of any act of God.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 9:27 pmby Firebird
I've been meaning to do this for a few years now. For 2 reasons,
First my collection really has grown since the movie line and classics. And second I just really like messing around with Excel.
Maybe I will make it next week. Oh and Guy, I like how you set yours up. I may have to steal parts of it.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Wed Oct 15, 2008 10:35 pmby OhioBot
Inventoried and photographed. I have a digital copy of my collection, a paper copy of my collection, and photographs in my safe deposit box at a bank. I update them biweekly. Since I'm finally off tomorrow, I'm finishing the paperwork on the insurance for the collection. I have over 1400 bots with a value of $20000. They currently occupy the spare bedroom, but my partner wants to turn that into a walk in closet/ironing room/utility room kinda thing, so we are going to finish the basement and set up a display room. I love my toys
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Thu Oct 16, 2008 2:25 amby thedistinctroom
I've got 63 in my not-for-sale collection. However, I do have over 100 in my for-sale-or-trade collection.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Thu Oct 16, 2008 12:22 pmby SentinelA
I've never gotten around to counting my TFs. I've tried to create a spreadsheet but never have been sucessful because I many customize or renamed TF so they'd fit into my continumm. I'd guestimate that I have 200 TFs.
Re: How many TFs do you own/ Does making a spreadsheet make me a
Posted:
Thu Oct 16, 2008 6:24 pmby Windsweeper
I have a spreadsheet done up for my 700-800 Transformers. No prices though as I'd probably be physically sick were I to count the cost of 6 years of collecting.
Has it really been 6 years? So much has happened.
Haven't bought too many this year as not fond of the Movie or Animated aesthetic for the toys. Not fond of Classics either. shame really as I love the Movie and the Animated series. Huge G1 fan too but just not loving the toys of the last 2 years, especially with the awful Legends seemingly replacing the Basic size class which has been my favouite. Despise Robot Heroes, Actionmasters were much cooler.