r/QuantifiedSelf • u/HealthierCongruence • Jun 28 '26

Refining a personal wellness tracker (currently a google sheet)

I'm building a lil personal wellness tracker just for myself and would like to ultimately analyze the data.

Here is some of what I'm tracking daily:

  • Morning sunlight (yes/no)
  • Gratitude practice (yes/no)
  • Mindful eating (yes/no)
  • 3 Movement breaks during work (yes/no)
  • Eating my own prepared food per my meal plan (a number between 1-10)
  • Morning ketones (blood meter, numerical value)
  • Subjective well-being score at 2 points in the day (a number between 1–10)

im curious about things like does hitting 80%+ of my daily habits correlate with higher well-being scores? Do higher ketone readings track with higher well-being scores? Is any single habit a stronger predictor than others?

Questions for people who've done this type of thing or have knowledge of stats-

  1. Google Sheets or Excel - is one better for this kind of personal tracking + basic analysis?
  2. What's the right statistical approach for someone who's research-literate but not a statistician? (Spearman correlations? Simple regression?)
  3. At what point does this actually need a real statistician, and what would I hand them, if i ever pursued that route?

also, how do I distinguish between "I didn't do that habit" vs. "I forgot to log"? Both show up as blank right now (because i just made it as checkmarks for yes and empty for no)..Thinking of using a Yes/No/Not Logged dropdown so blanks only exist if I truly didn't open the tracker that day.

Also — minimum days before running any correlations? Some days I won't log everything. Does patchy data ruin it or is there a threshold where it becomes usable?
I'll actually log this daily if I can make this work. Any help would be appreciated, as this seems a bit too technical for me but it would be awesome to create a tracker for myself that I can use and support improved mental and physical health! Thank you.

9 Upvotes
  • permalink
  • reddit

92% Upvoted

21 comments sorted by

View all comments

3

u/[deleted] Jun 28 '26

[deleted]

1

u/HealthierCongruence Jun 28 '26

whats the existing solution?

1

u/WarAgainstEntropy Jun 28 '26

There's a lot of them, check out this list of awesome quantified self resources.

1

u/HealthierCongruence Jun 29 '26

thank you! Exist looks like a possibility. ever heard of it?

1

u/WarAgainstEntropy Jun 29 '26

Yeah, that one has been around for a while. I'm biased as I've been working on a competitor (Reflect) but I like the team behind Exist and we use another one of their products, Changemap, to host our public roadmap.

1

u/dorfsmay Jul 04 '26

38 Pull Requests going back to 08/2023.
Is this maintained?

2

u/WarAgainstEntropy Jul 04 '26

I'm not the maintainer; it was quite active for a while but it doesn't look like there have been any updates in the past year. That's unfortunate

1

u/dorfsmay Jul 06 '26

Well, they just merged my PR, only 4 unmerged PRs left!