Spreadsheets + Organization

What Makes a Good Spreadsheet

More Wardrobe Spreadsheet Analysis

Introduction to Wardrobe Spreadsheet Analysis

Wardrobe Spreadsheet Template

Wardrobe Airtable Template

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