Organzing [Your Collection] with an Microsoft Excel Spreadsheet

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!



(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 Thumbnails

 

*TFW2005 FEATURED COLLECTION 8/19/2005*

Link 1: Discuss my collection at the 2005 Boards

Link 2: View my collection (last updated 5/17/2011 with Dark of the Moon).