Posts

Showing posts from 2019

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...

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. ...

Egl Wardrobe Airtable

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

End of Year Challenge Template

Image
Have you seen @candib3ar's End of the Year challenge going around Instagram? I love these challenges, and also love not forgetting my answers to each prompt. I made a spreadsheet template for keeping track of this challenge.