Egl Wardrobe Spreadsheet




I live my whole life in spreadsheets, and even started using them to plan parties instead of Facebook events. For some reason, though, it took me until now to actually put one together for my egl wardrobe. I spent a while tweaking mine so I would be able to capture, maintain, and later analyze information about my wardrobe. I'm happy with mine for my own personal use, so I made a template for you to use!



Find the template here

How to use


  • On mobile/the Google Sheets app 
    • Click the 3 dots on the top right.
    • Click "Share and Export"
    • Click "Make a copy"
  • On the web
    • Click "File"
    • Click "Make a copy"
  • Now you have your own copy!
  • Fill out the sheet for items in your wardrobe
  • Use the "Selling/Sold" column to mark whether or not something is still in your wardrobe
    • Make sure to always use the same mark here, it will come in handy if you want to do analysis later. Using a "1" or "x" would do.

Ways to modify the sheets


  • Add columns for things you want to keep track of. I've heard of people tracking wear-counts, for example.
  • Break the sheets into smaller pieces. For example, you could break "Main Pieces" into "JSKs", "OPs", etc.
  • Remove columns of stuff you don't care about
  • Hide the 'Date Sold' column
  • Put a filter on the "Selling/Sold" column to only show current pieces.
  • The columns with "Date" in them are "date" type columns, so the sheet will automatically format input like a date. 
    • You can add a "currency" type to the price columns to reflect your country's currency!
  • Analyze the data!
    • Using the information you capture, you can find all kinds of amazing things. Personally I'm looking forward to seeing how my wardrobe changed over time, both in volume and style. 

Comments

Post a Comment

Popular posts from this blog

3 Things that Make a Wardrobe Spreadsheet Good

Image
What does it take for a wardrobe tracking spreadsheet to be good for analysis? I have a few thoughts on how to keep your spreadsheet organized for easy analyzing. If you're familiar with relational databases, this will all sound very familiar! This is by no means inclusive, or ~ the rules ~, just some thoughts I have as a professional engineer about how I organize my wardrobe spreadsheet.
Read more

Wardrobe Spreadsheet Analysis: Getting Started

Image
I spent a non-trivial amount of time putting my wardrobe into an Airtable and then into a spreadsheet. After all the work of entering the data and formatting it in a somewhat normalized way, I want it to tell me things! In this post, we're going to explore how you can find out information about your wardrobe using Google Sheets/Excel calculations and analysis tools. I'm going to assume that you're unfamiliar with doing analysis in spreadsheets, so we'll start from the beginning with these. I'm also going to assume you're working with this template here , and have maybe read that post, but you can also adapt these techniques to your own spreadsheet. The "mood" of this post is exploring a method of analysis, maybe in a bit of a stream of consciousness way. This is an easy introduction, plus I hope it will help you feel comfortable exploring on your own, rather just giving the "answers" for things. This is a first step into getting fam...
Read more