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

Wardrobe Spreadsheet Analysis: Simple Metrics

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