100% day

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?
This is awesome, Keni. 

I also wished to do something similar to this. I once sent you a 
Youtube
video about 
Sam Ovens
sharing his 
War Calendar
in which he first lists out his larger goals for the year... and then he reverse engineers the tasks for the days in which he would need to fulfill to achieve the larger goals.

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.
2021-07-23 00:26:22
I actually have been very bad about measuring my day. Fearing the ultra-measuring that I think too many lifehacker people do these days who try to quantify everything, I shifted way too far onto the otherside, not measuring anything at all. 

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 
drewbaca_
shared with me is this idea of picking three bigger things that I'd like to do/accomplish on any given day. If you do thos three then don't beat yourself up... instead celebrate it as a good day. 

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.
2021-07-23 00:29:48
I have friends that kind of track their days with the bullet journals, then when they look back they can look at how they actually live their lives, more than what they think they do. I guess this is what you mean. But honestly I also don't track much, I think I would set my sights too high. I make very optimistic lists. So I usually make a to do list then rank the things. If they are on list too long and are not getting done then I just let them go. Its crazy some things you think you should do when there is really no need. 
abrahamKim
  so its kind of like the three things a day. Essentially at work I can only do about three things well. Or two on somedays, but as long as your moving in a direction it feels like a good day. I also have some activities I know will make my day feel better, like running or swimming or ice cream. So when I don't achieve or am not happy with my day I do a +1 thing like that. Usually days with a lot of meetings so no making time. It always reminds me that I can do little things that help a lot. But some people really like seeing it on a graph or spreadsheet so I think what ever works and you like enough to be sustainable.
2021-07-23 11:07:18
Sir Abe - I have tried a few combination of things myself. After reading books like 12 weeks a year, One thing, Get things done etc... there are many options. It is about finding what works for you. I focused on simplicity and the potential to get more insight when I created this. It started on paper and pen first and the questions kept changing ... It may continue to change as things in my life morph and my focus shifts. 

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. 
2021-07-23 22:31:48
drewbaca_
 - I have seen some of the bullet journals out there - very elaborate and people are dedicated to customize them to their needs. I have tried a few journals myself and I like writing on paper as well. But I find that having it on a spreadsheet makes it easy to do more analysis and view patterns faster. 
2021-07-23 22:33:44

Retrospective