100% day

keni  •  22 Jul 2021

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?


Sounds really compelling, this dashboard. I can almost imagine this being a Notion template for sale! (Notion being so hawt right now…)

jasonleow  •  23 Jul 2021, 3:00 am

Thanks Jason. I have not used Notion much but I can look into it. I want to keep things as simple as possible for now

keni  •  23 Jul 2021, 10:37 pm