Your Data Can Improve Your Life

I've developed a few tools and spreadsheets to help manage my life and its data. These can help with life decisions or sort out complicated feelings on a subject. These can make it easier to live a happy, healthy, and fulfilling life.

Decisions Helper

This is a tool I use to make decisions about my life: where to live, which schools to attend, what to research, and where to relax. These kinds of decisions usually involve considering a variety of factors between competing options.

Using a statistical tool called Root-Mean-Square analysis, we can determine which of an array of options should maximize the factors you care about.

The Decisions Helper Spreadsheet

How to use this:

  1. Open the Decisions Helper Spreadsheet
  2. Under Google Spreadsheets' "File" menu, select "Make a copy..."
  3. Name it according to the choice you're making. Now you can make changes to your copy.
  4. Each row is an option you're considering. Fill in the "Option" column based on your options.
  5. Each column is a factor that's common among those options. Fill in the first row based on what factors you're considering.
  6. Feel free to add and remove rows and columns as needed.
  7. For each factor of each option, fill in a numeric value—one to five, one to ten, one to 100—how you rank these should be consistent to you and between each option and factor.
  8. Sort by the "Score" column to find the option that, on average, maximizes the factors you're considering.

Emotions and Feelings Helper

Plutchik Wheel

People are squishy and hard to measure—even more so our feelings and emotions about things. Those can overlap, conflict, harmonize, and dissonate in ways that make it hard to understand where things are coming from or heading towards.

This spreadsheet helps sort all of that out, using a model of emotions called the Plutchik Wheel.

The Emotions and Feelings Helper Spreadsheet

How to use this:

  1. Open the Emotions and Feelings Helper Spreadsheet
  2. Under Google Spreadsheets' "File" menu, select "Make a copy..."
  3. Name it according to today's date. Now you can make changes to your copy.
  4. For each thing that you have feelings about, clone the template and name the new worksheet accordingly—'home', 'work', 'partner', etc.
  5. Under "Weak", "Baseline", and "Strong", rank your feelings on the matter in a consistent, numeric way. I use a scale of one to ten.
  6. Add a short description of your feelings on the matter.
  7. This spreadsheet will calculate the total score for each feeling, and generate the composite values for the derived emotions (e.g. love = trust * joy, optimism = joy * anticipation, etc) so you can sort out where overlapping feelings are coming from.

Written by Danne Stayskal on 2016-04-08