Introductory: Organzing [Your Collection] with an Microsoft Excel Spreadsheet

Discussion in 'Tutorials and How Tos' started by snkeyes069, Nov 24, 2010.

Thread Status:
Not open for further replies.
  1. snkeyes069, Nov 24, 2010
    #1
    snkeyes069

    snkeyes069 Legend in his own mind TFW2005 Supporter

    Joined:
    Apr 25, 2003
    Posts:
    805
    News Credits:
    1
    Trophy Points:
    257
    Likes:
    +55
    Ebay:
    I created the following Excel Spreadsheet:

    http://jason.theriondna.com/Tfs_coll.xls

    It allows me to fill in the number of each toy I have, and get a package count, toy count (G1 Prime I consider as 1 package but 3 toys), purchase value of collection and a rough current value of collection based on the toy's condition (package & toy).

    The original prices (especially for the G1s) should be 100% correct, as I took them from the price tags still on most of my G1 boxes.

    Enjoy!

    [​IMG]

    (While this thread is certainly a "collections" type of thread, I've often found spreadsheets useful for keeping ideas together for artwork, especially customs. Also, most kitbashers have TF collections to keep track of, too; I know I do! ~Superquad7)
     

    Attached Files:

    Last edited by a moderator: Apr 6, 2011
Thread Status:
Not open for further replies.