April 16th, 2012Top StoryFill Out This One-Minute Form Every Day and Find Out Why Your Life Sucks (or Doesn't)By Adam Dachis Click to view Ever wonder why you're having a bad day, or even a good one? Is there an ongoing problem in your life that you just can figure out? If you've got a free minute, just fill out this daily form to help you diagnose the problem by analyzing how you think, act, and feel. The aggregate of your moods from day to day is, to a large degree, your life. Whether you've had too many bad days in a row or you just want a better handle on what exactly makes your moods swing (for better or worse), this post's for you. Over time I've noticed that I'm at my worst when I don't eat. Hunger makes me an awful person to be around more than a lack of sleep or any other problem. A lack of food isn't the only reason I have bad days (or moments), however, but figuring out every problematic action in a particular day isn't exactly an easy thing to do. I realized I'd need a personal inventory—so I created one. I put together a form in Google Docs that asks a bunch of questions about basic issues that come up on a regular basis. This includes things like diet, exercise, sleep, and happiness in a variety of areas. It takes about a minute to fill out each day, and when you're done the data is saved in a spreadsheet that automatically takes the daily data and calculates a variety of scores. These scores, plus accompanying graphs, can give you a quick look at what you're doing right in life and where you can improve. This way you don't have to try and pay attention to everything you do—which is basically impossible—and can let this form figure out your problems for you. In this post we'll go over how to set up the form for yourself and what each score means. Watch the video above for a demonstration, or read on for a full written overview and setup instructions. How to Set Up the Daily Personal Inventory FormBefore you can get started, you'll need a Google Docs account because that's where this form lives. If you've got one, sign in. If you don't, sign up. Once you're all set, just follow these steps to set up the form for use:
That's all you have to do to get started. Before we move on, however, let's visit the other pages of the spreadsheet just to make sure they're working. Towards the bottom-left corner of the spreadsheet you'll see three tabs: Daily Inventory Data (the tab you're probably on right now), Score Card, and Score Card Graph. Click through each of those tabs and make sure the Score Card is filled with numbers (and not DIV#0 errors) and hte Score Card Graph looks like a graph (and not a blank white page). If everything looks good, you set up the form correctly. If not, you may want to read through these steps again and make sure you didn't miss something. Assuming you've made it through the setup process, read on to learn what your scores mean. Analyzing Your Inventory ScoresYour inventory scores are pretty straightforward. All scores are out of 100 and they break down much like a traditional grading system:
In general, you want to aim for a score of 75 or higher in every category. If you can manage that, you're doing pretty well. If not, you'll want to think about how you can improve in any relevant category. That's pretty much all you need to know to use this form, but if you want to learn more about how it works and how to make changes to better suit your needs, read on. (Warning: the need for some basic math and spreadsheet knowledge will be required!) Individual Category ScoresEach category in the spreadsheet gets a score assigned to it based on a few factors. On the "Daily Inventory Data" page, the second row (below the titles) provides a score for each specific category. Every score is out of 100 and is generally calculated by averaging your daily scores and comparing them to the highest possible score you could've earned. For example, if you filled out the form 5 times and rated your day a 3 each time, that means you'd earn 15 out of 25 possible points, resulting in a score of 60. Some scores are slightly more complex as they're not based on a simple 1 to 5 rating. For example, the form expects that you'll sleep 8 hours per night. As a result, you'll earn a perfect sleep hour score if you always sleep 8 hours. If you require more or less sleep to feel rested on a regular basis, you'll want to change how this score is calculated so it fits you better. You can do this easily by clicking on the score in the spreadsheet and looking at the current equation in the Google Docs function bar. It'll look like this:
The part you want to pay attention to is the number 8. Change that to how long you need to sleep to feel rested and your sleep hour score will adjust as a result. Other categories assume certain averages as well. For example, you're expected to drink eight glasses of water per day and exercise for 15 minutes per day (or any combination of time that adds up to 105 minutes per week). Feel free to adjust these averages as you wish, or just leave the defaults. Score Card ScoresThe Score Card, or the second page of the spreadsheet, calculates scores based on your overall performance in select categories. Here's a look at what each score means and what affects it. Eating Score Drinking Score Healthy Eating Score Overall Diet Score Sleep Score Exercise Score Emotional Score Procrastination Score Average Score Physical Average The Score Card GraphThe Score Card Graph is just a graphical representation of the Score Card page. It's often easier to see where you stand with the graph so you'll probably find yourself looking more at it than the numerical score card. This is just a general overview, however, so if you want more statistics you have a couple of options. First, you can take any of the data in either of the spreadsheet pages and create a graph of your own. Second, you can go to the Form menu and choose "Show summary of responses." This will bring up an analysis of your answers for each individual question and provides a great visual representation of your responses. Taking Your Personal Inventory FurtherThis personal inventory is just a set of broad questions to give you a basic understanding of possible problems in your life. It's not meant to be specific to anyone, so you may find that you want to add more questions to the form to collect data that is directly relevant to your life. To do that, just go to the Form menu and choose "Edit form." From there you can add questions and alter existing ones to make the daily inventory one that suits you perfectly. |
|
A destination on the Interweb to brighten your day (now get back to work!)
Monday, April 16, 2012
Fill Out This One-Minute Form Every Day and Find Out Why Your Life Sucks (or Doesn't)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment