Egl Wardrobe Airtable



Happy December ILD! It's winter here in the Northern hemisphere, so I've been enjoying the great indoors by making spreadsheets. I wanted to share an Airtable template I made for keeping track of one's egl wardrobe. Please feel free to make a copy of it for yourself and use it!

Link to my airtable wardrobe template

If you're unfamiliar with Airtable, it's similar to Excel but much more visual and friendly to use. Unfortunately a lot of the fun analytics are behind a paywall, so my personal technique is to use Airtable to keep my wardrobe updated and then move to Excel/Google Sheets for number crunching and data analysis. An Excel/Sheets template and formulas for wardrobe analysis will come in another post, as of writing this I need to start getting ready for my work's holiday party!

Here is my personal Airtable (probably not finished yet), for an example



Features of this template:

  • There is a checkbox field called 'Selling/Sold' that can be used to indicate if something is no longer in your wardrobe
    • There is a hidden field to note the date something was sold
  • The 'Color' field has data validation for colors. This prevents having one "Black" dress, and another "black" dress.

Comments

Post a Comment

Popular posts from this blog

Egl Wardrobe Spreadsheet

Image
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.
Read more

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