Winter in the Woodlands
I dressed up twice this weekend for Winter in the Woodlands this weekend!
Popular posts from this blog
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...
Wardrobe Spreadsheet Analysis: Simple Metrics
Last time we talked about starting to do some simple analysis using tools built in to Google Sheets (and Excel) . Now that we're familiar with our friend the pivot table, we can do more. We're not going to go over everything you could possibly do with your wardrobe and a pivot table, instead we're going to go over a few specific things as a jumping off point to get our feet wet. Things we'll do in this post: Sums of each brand charts Most expensive main piece most expensive JSK, OP, Skirt Breakdown of types for each brand Let's get started Total spent per brand This is pretty similar to the "Average price per brand" that we did in the last post. What we're going to do now is set it up and add a chart to it so we can visualize the sums. Here is my result: Here is my pivot table editor: Add one row for "Brand" Add one value for "Price", and summarize by SUM Add a filter to filter out any...