Excel spreadsheet Checklist? |
08-15-2006, 11:27 AM
|
#1 | | plays guitar/not a virgin Join Date: Nov 2003 Posts: 5,357 Location: St. Paul, MN Collection Count: 340+ | Excel spreadsheet Checklist? Is there an excel spreadsheet checklist anywhere that has a list of all released transformers? I would like to start an inventory of my collection, incorporating loose and misb values into the spreadsheet. Anyone have anything like that, or do I need to start one from scratch?
Let me know if anyone is interested in helping me out if there isn't one.
Thanks.
I saw a Boxing commercial and it said "It's a fight to the finish" Thats a good place to end.
|
| |
08-15-2006, 11:49 AM
|
#2 | | Yo Gabba Gabba! Join Date: Mar 2004 Posts: 23,375 Location: louisville Collection Count: +alot | Thought we had one here somewhere.. Do we? We NEED one!
Plan d can be copying the alpha-bit list from tfu.info  Don't look at my stuff!! Which is Here! XBox live gamertag- chaos muffin |
| |
08-15-2006, 12:12 PM
|
#3 | | Animated FTL!!! Join Date: Jul 2002 Posts: 11,024 Location: Seattle, WA Collection Count: a Lot. Probably Too many :p News Credits: 3 | Kinda urprising no one has made a list like that.
Hell, i'd probably drop $10 for a copy. i need to inventory my collection, that'd make it a lot easier. "all the slammin' shorties in the house say "yeah!""
—Optimus Prime |
| |
08-15-2006, 12:22 PM
|
#5 | | plays guitar/not a virgin Join Date: Nov 2003 Posts: 5,357 Location: St. Paul, MN Collection Count: 340+ | Well, I got started. Maybe I should get some feedback on what you guys want.
So far each series will be separated on different sheets. It will show the character name in alphabetical order, then loose qty. loose value, MISB qty. MISB value.
Then at the bottom it will show the totals. On a separate page it will show grand totals.
What sight do you think is best to find out the value of each toy? and is there anything I am missing that you guys would want incorporated?
I saw a Boxing commercial and it said "It's a fight to the finish" Thats a good place to end.
|
| |
08-15-2006, 12:54 PM
|
#6 | | plays guitar/not a virgin Join Date: Nov 2003 Posts: 5,357 Location: St. Paul, MN Collection Count: 340+ | Quote: |
Originally Posted by DanLyons snkeyes069 posted one here | That will work. A little messy for me (I'm a stickler for clean looking spreadsheets)
but I can clean it up a little. Thanks DanLyons and snkeyes069
I saw a Boxing commercial and it said "It's a fight to the finish" Thats a good place to end.
|
| |
08-15-2006, 01:04 PM
|
#7 | | Lets the balls touch. Join Date: Jul 2002 Posts: 7,364 Location: State of Independance Collection Count: 944 News Credits: 2 | Mine's a little more cumbersome, but I have one workbook for each series, then one sheet for each size class (i.e. scout, deluxe, mega, etc). I then have one master workbook that gives me a total collection count by pulling the numbers from the other sheets. Which reminds me my Cybertron sheet is due for an update. CURE ME OF MY COMPLETIST WAYS  -Soon to be King of the Animated Road!
Sig pic by Josh - you rule dude!!!
|
| |
08-15-2006, 01:15 PM
|
#8 | | Push my button. Join Date: Feb 2005 Posts: 217 | What would you guys think about having a TF database ala tfu.info, with an added feature to create your own inventory to show in your own profile? I bet I could make something like this... |
| |
08-15-2006, 01:39 PM
|
#9 | | plays guitar/not a virgin Join Date: Nov 2003 Posts: 5,357 Location: St. Paul, MN Collection Count: 340+ | Quote: |
Originally Posted by JaviSRK What would you guys think about having a TF database ala tfu.info, with an added feature to create your own inventory to show in your own profile? I bet I could make something like this... | It would be pretty cool. But I think a lot of people need it to be pretty involved. Not only do I need inventory, but I need to keep track of how much I spent (Not just retail price, as I have received many as gifts) As well as the quantities I have for both loose and packaged, and atleast a rough estimate on the current value for both.
I basically need to know what I have, what I spent, what it is worth and my ROI.
I saw a Boxing commercial and it said "It's a fight to the finish" Thats a good place to end.
|
| |
08-15-2006, 01:56 PM
|
#10 | | Animated FTL!!! Join Date: Jul 2002 Posts: 11,024 Location: Seattle, WA Collection Count: a Lot. Probably Too many :p News Credits: 3 | seperating it by years would be good for G1, BWs and other multi year series, and seperating by Size Class would be handy, especially for the modern series. "all the slammin' shorties in the house say "yeah!""
—Optimus Prime |
| |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts HTML code is Off | | | | Tools and Information | | | | | | | Excel spreadsheet Checklist?. Transformer World 2005 is the largest fan community related to Transformers toys. Features information on Transformers 2, the sequel to the Transformers Movie, Transformers Animated, Classics 2.0, Optimus Prime and Megatron. Daily news, toy resources, galleries, Transformers wallpapers and more are available.
Check us out for Transformers, Transformer, Transformers 2, Transformers Movie 2, Transformers Movie, Transformers Animated, Classics 2.0, Transformers Universe, Transformers Toys, Transformers DVD, Transformers Wallpapers, Transformers Images, Transformers News, Transformers Resources, news, sequel, Transformers Comics, Optimus Prime, Megatron, Bumblebee. |  |