Hey all. I like SleepCycle’s sleep notes function and I’m wondering how to create that in a spreadsheet tracking pain levels (I’m using Google Sheets).
Every night before I go to bed, I select a handful of “factors” from the sleep notes list. For instance, if it’s a cold night, I select “Cold Night”. If I worked out that day, I select “Worked Out”.
This is a way of getting data about the correlation between presence/absence of these factors and overall sleep quality.
Here are some examples of how the data is interpreted (sorry - Google Drive won’t rotate them):
So, basically I want a spreadsheet that correlates whether I did certain things in a day to percent increase or decrease in pain levels. I want to be able to display a graph of overall pain levels and various factors effect on those levels.
I know how to create the sheets, but I don’t know how to do the math. Any ideas on what the math is behind the sleep notes function on SleepCycle and how to replicate it in a spreadsheet?
Thanks in advance!