I created a simple google spreadsheet some time back. I shared some of the details on 200WaD. It is basically a set of questions that are conditionally formatted. The default answer to the questions is NO and the background color is red.
It took me a few months to finetune the set of questions that captures what I want to check on in any given day. My approach was to simplify the process of checking in to see if I am keeping some of my core goals in mind. Sometimes, I have such grand goals that it seems too far off to remember each day. Having a checklist to see if I am working towards something is a great system for me to remind myself.
There is a simple tally at the end of the questions. It tells me the percent of my answers that are YES. Most good days are 80%+. Most average days are between 60-80%. An excellent day is 95% or more. On and off, I have been doing this for about 2 years now. I had completely stopped when I was out sick. I have been back at it along with my writings the past 100 days.
It is a great way to see what I am consistently struggling with. And also what is now a habit and easy to do regularly. The key to all this is the brutal honestly the data collection requires. There is no point in lying about some things cause when I do make the effort, I wont be able to tell the difference.
I have not seen a 100% day in a while. One thing or the other is acting up. But I have been on a better than average streak for a while. I am looking into creating some nice dashboards with my data. Look at some patterns and insights. Make is fancy. Who knows - maybe this will be a nice tool worth sharing.
How do you measure your day?
It took me a few months to finetune the set of questions that captures what I want to check on in any given day. My approach was to simplify the process of checking in to see if I am keeping some of my core goals in mind. Sometimes, I have such grand goals that it seems too far off to remember each day. Having a checklist to see if I am working towards something is a great system for me to remind myself.
There is a simple tally at the end of the questions. It tells me the percent of my answers that are YES. Most good days are 80%+. Most average days are between 60-80%. An excellent day is 95% or more. On and off, I have been doing this for about 2 years now. I had completely stopped when I was out sick. I have been back at it along with my writings the past 100 days.
It is a great way to see what I am consistently struggling with. And also what is now a habit and easy to do regularly. The key to all this is the brutal honestly the data collection requires. There is no point in lying about some things cause when I do make the effort, I wont be able to tell the difference.
I have not seen a 100% day in a while. One thing or the other is acting up. But I have been on a better than average streak for a while. I am looking into creating some nice dashboards with my data. Look at some patterns and insights. Make is fancy. Who knows - maybe this will be a nice tool worth sharing.
How do you measure your day?
I also wished to do something similar to this. I once sent you a
I think your approach would be more helpful for me because I have less clarity on concrete larger goals for the annual duration. And your approach feels more conducive to exploring what we are becoming curious to rather than top-down defining our goals and trying to force our daily-selves to produce accordingly.
I think I already know the answer to this, but are you willing to share this spreadsheet? Or at least a segment of it? lol. You could even censor out some of the items when you share so I don't know what they are.
I really find promise in your approach because it seems like a great middleground that provides both clarity-through-auditing and at the same time learning-through-exploration with flexibility-to-change-it-while-discovering.
For the most part I didn't like measuring my days because it would show too obviously how much I slacked.
One thing I did do since a few years ago because of what
I've been able to live like that for awhile, and i've been doing well with it. But now I'd like to move onto something with a bit more high resolution. Something similar to your spreadsheet.
I created a public version of the spreadsheet. https://docs.google.com/spreadsheets/d/19nvvHI-O-cU03QIPoFBw-fhfu8dkIfhYtUDq1Yi9b3Y/edit?usp=sharing
Please give me your feedback when you get a chance to see it. I learnt a lot after talking to two people about the spreadsheet and I am sure your insights would help me. It would be great if you start to use it as well. I was considering making this as an addition to the journal if it continues to work for me.