I have shared on this blog some info about my Daily Questions practice.
- Original Daily Questions post where I explain what they are and where the practice came from.
- 2017 in Review post where I took the 52 weeks of daily questions data from 2017 and created a graph to illustrate how I did.
- Looking ahead for 2018 post where I set my goals and intentions for the year, and introduced a new model for my daily questions.
At least 2 people have asked me about the tool I use to capture my life data. With this high level of enthusiasm for the nitty gritty details, I'll happily share.
I keep mentioning in these posts that I use a spreadsheet with some conditional formatting. I still got a few questions about what tool I used. It's homegrown!
This post will go through how I set up those spreadsheets in excruciating detail.
First, let's get an orientation of what they look like...
Screencast Orientation of the 2017 Daily Questions Worksheet
Screencast Orientation of the 2018 Daily Questions Worksheet
Now that you are familiar with what the tool looks like, let's explore how I set up the conditional formatting that allows me to fill in the answers to my 10 daily questions each day and automatically generate a daily and weekly score and grade. This is how I'm able to analyze my behavior over time - like in the graph I created via the free tool time.graphics for my 2017 in Review. With the data structured in this way, I can also analyze whether I am having trouble getting to yes on a certain day of week so that I can find the root cause/blocker and figure out how to change my behavior.
Without further ado, here's the video that explains the conditional formatting. If you're not interested in learning all this but want to try out this method, I have made both my previous year's spreadsheet as well as 2018's spreadsheet available. If you use this, please make a copy to your own files and leave the templates alone.
Screencast explanation of 2018 Daily Questions conditional formatting:
No comments:
Post a Comment