NetworkTFW2005 - TransformersHissTank - GI JoeToyark - Action Figures and ToysISHTALKERS - Movies and Entertainment Blog
tfw2005
Stylin Online T-Shirts
HOME BOARDS
tfw2005
Go Back   TFW2005 - The 2005 Boards > Transformers > Transformers General Discussion
Register Rules / Info Members List Mark Forums Read
IshTalkers.com - Entertainment and Movies TFSource Big Bad Toy Store Tempting Toys for Transformers and Godzilla! Kapow Toys Automaton Toys

Tags
checklist, excel, spreadsheet

Excel spreadsheet Checklist?

Reply Thread Tools
Old 08-15-2006, 11:27 AM   #1
plays guitar/not a virgin
funkatron101's Avatar
funkatron101's Ebay Auctions
Join Date: Nov 2003
Posts: 5,357
Location: St. Paul, MN
Collection Count: 340+
Send a message via AIM to funkatron101
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.
funkatron101 is online now   Reply With Quote
Old 08-15-2006, 11:49 AM   #2
Yo Gabba Gabba!

Chaos Muffin's Avatar
Chaos Muffin's Ebay Auctions
Join Date: Mar 2004
Posts: 23,375
Location: louisville
Collection Count: +alot
Send a message via AIM to Chaos Muffin Send a message via Yahoo to Chaos Muffin
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
Chaos Muffin is offline   Reply With Quote
Old 08-15-2006, 12:12 PM   #3
Animated FTL!!!
artiepants's Avatar
Join Date: Jul 2002
Posts: 11,024
Location: Seattle, WA
Collection Count: a Lot. Probably Too many :p
News Credits: 3
Send a message via MSN to artiepants
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
artiepants is offline   Reply With Quote
Old 08-15-2006, 12:17 PM   #4
Vintage Lurker
DanLyons's Avatar
Join Date: Apr 2004
Posts: 191
Location: Natick, MA
Collection Count: over 1,000
snkeyes069 posted one here
Till All are One…

Ok, maybe not that long - till All are Six or Seven.

Junkion Exchange Feedback Thread
My Home Page
My Company Site (iPhone App Development)
DanLyons is online now   Reply With Quote
Old 08-15-2006, 12:22 PM   #5
plays guitar/not a virgin
funkatron101's Avatar
funkatron101's Ebay Auctions
Join Date: Nov 2003
Posts: 5,357
Location: St. Paul, MN
Collection Count: 340+
Send a message via AIM to funkatron101
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.
funkatron101 is online now   Reply With Quote
Old 08-15-2006, 12:54 PM   #6
plays guitar/not a virgin
funkatron101's Avatar
funkatron101's Ebay Auctions
Join Date: Nov 2003
Posts: 5,357
Location: St. Paul, MN
Collection Count: 340+
Send a message via AIM to funkatron101
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.
funkatron101 is online now   Reply With Quote
Old 08-15-2006, 01:04 PM   #7
Lets the balls touch.
Motor_Master's Avatar
Join Date: Jul 2002
Posts: 7,364
Location: State of Independance
Collection Count: 944
News Credits: 2
Send a message via MSN to Motor_Master
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!!!
Motor_Master is offline   Reply With Quote
Old 08-15-2006, 01:15 PM   #8
Push my button.
JaviSRK's Avatar
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...
JaviSRK is offline   Reply With Quote
Old 08-15-2006, 01:39 PM   #9
plays guitar/not a virgin
funkatron101's Avatar
funkatron101's Ebay Auctions
Join Date: Nov 2003
Posts: 5,357
Location: St. Paul, MN
Collection Count: 340+
Send a message via AIM to funkatron101
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.
funkatron101 is online now   Reply With Quote
Old 08-15-2006, 01:56 PM   #10
Animated FTL!!!
artiepants's Avatar
Join Date: Jul 2002
Posts: 11,024
Location: Seattle, WA
Collection Count: a Lot. Probably Too many :p
News Credits: 3
Send a message via MSN to artiepants
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
artiepants is offline   Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyone here a Pro at Excel? Predakwon General Discussion 7 11-18-2007 03:49 PM
Do you watch Excel saga? cambaprecoz Video Games and Technology 21 09-05-2007 09:46 AM
Any Excel Gurus - I need help OmegaScourge General Discussion 3 04-25-2007 06:01 PM
alt/bt checklist KA Transformers General Discussion 27 04-19-2007 12:48 AM


Thread Tools

Posting Rules
Forum Jump

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.
All times are GMT -5. The time now is 11:45 AM.
Powered by vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0

TFSource.com