Posts

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.

December ILD 2020

Image
Happy ILD! I ended up wearing two coords for two different Discord meet occasions: one for a meetup with the local Vermont community, and one for hanging out with my Bay Area crew.

EGL Lifestyle Things I Miss in Lockdown

Image
We've all had our lives on hold this year with the pandemic going on. We've missed almost a year's worth of normal activities and events. While I'm not eager to get back to a lot of things about the "before times", I'm looking forward to some normalcy in the future if we can manage that. Anyway, here are some of the things I miss doing while in lockdown.

Thanksgiving

Image
  I've had no energy to dress up recently, but I did have some energy on Thanksgiving, so I rolled with it. I haven't been on Instagram in (I think) over a month, and I'm really enjoying not using it. I still want to document my coords, however, so on the blog it is!

Lifestyle Ideas: Quarantine Edition

Image
All of us in the San Francisco community are on a shelter-in-place lockdown until April 7. We are allowed to run essential errands like getting groceries, we can take walks while keeping distance from others, and we still get mail, but cannot otherwise leave the house. That leaves many of us in isolation from our local communities. That being said, we can still find ways to keep each other company and indulge in the fashion. I made a list of 50 lifestyle ideas, inspired by  this Livejournal post from 2005. These are suited for those under quarantine or under a shelter in place order, and updated to include ideas for working lolitas and activities that use the technology we have 15 years later. I'd like to get to 101 ideas, so please comment, email , or message me on Instagram if you have any you'd like to share. 50 lifestyle ideas for those stuck at home: Host a fancy dinner for your housemates, or a romantic dinner for your significant other if you live togethe

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