Inspired by Tabbyclaw’s familiar tracker. For the list of FR apparel, I used Eclipse’s Apparel Catalog, a modified version of their categories, & screencaps of the outfits with permission. (As of 7/2/2018, I have the How-To, Armor/Battle, Events, and Magic/Mysticism tabs done and have a couple more in progress).
How To Use: When it’s ready, go to File > Make a Copy!
There are several sheet tabs with categories of apparel (Adventure, Armor/Battle, Events, Finery, Flora/Fauna, General/Accessories, Magic/Mysticism, Tech/Science).
These are what the listings portion of a tab look like (this example Festivals/KS etc; It has images, the name of the items, and where you can obtain the items. Also, the where obtain column has the “where” in different colored cells!
Next, I have the actual tracking portion. You can specify which dragons you have an apparel item on and what projects you want items for. You can input how many you have on dragons, in your hoard/vault, how many you want generally, and how many you want for projects. Numbers such as 1, 2, 3 should be used for “# of” columns. These will add into the Total Copies/Total Wanted columns.
Reblog to get pinged on Tumblr!
Also, did I mention there’s conditional formatting and formulas to make it prettier, hopefully easier to read, and functional?
Conditional Formatting and Formulas (How it Works)
Slight Eyewing Tumblr Backup 