Bread First Search

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

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