I have sleep apnea and wanted to gain more insight into my sleep than what I am getting. I came to the realization that I could manually enter data into Excel from MS Health, recorded by my Band, to answer some questions that I have. For example:
Do I sleep better on certain days of the week than others?
(By the way, I typically work Sat & Sun and take off Wed and Thu, so this pattern kind of makes sense.)
I was also wondering if I slept better the day after exercising. For this one the spreadsheet classifies each of my exercise sessions by ave HR into Zone 1 - Zone 5 with my user defined parameters. I don't have very many zone 1 exercise sessions, so the sample size is small. It turns out that I do indeed get more restful sleep after exercising in Zone 2 or above:
I also wondered how much I was hurting myself by staying up late. I was hoping it didn't matter. Now I know:
I was also curious about the new sleep restoration classification that popped up on the recent update. My sleep restorations have been classified as moderate, good, or optimal. It turns out that amount of restful sleep and resting HR both vary a lot with these classifications:
I have a lot more of these, esp. showing sleep and exercise performance over time, but I still have not entered all the data to the present. All of these insights (and many more) could easily be added to MS's dashboard in the future, because all of the data came from there, after collection by my Band. All I did was enter it into excel and use formulas to automatically calculate a number of additional fields such as DOW, exercise zone, etc.
Do I sleep better on certain days of the week than others?
(By the way, I typically work Sat & Sun and take off Wed and Thu, so this pattern kind of makes sense.)
I was also wondering if I slept better the day after exercising. For this one the spreadsheet classifies each of my exercise sessions by ave HR into Zone 1 - Zone 5 with my user defined parameters. I don't have very many zone 1 exercise sessions, so the sample size is small. It turns out that I do indeed get more restful sleep after exercising in Zone 2 or above:
I also wondered how much I was hurting myself by staying up late. I was hoping it didn't matter. Now I know:
I was also curious about the new sleep restoration classification that popped up on the recent update. My sleep restorations have been classified as moderate, good, or optimal. It turns out that amount of restful sleep and resting HR both vary a lot with these classifications:
I have a lot more of these, esp. showing sleep and exercise performance over time, but I still have not entered all the data to the present. All of these insights (and many more) could easily be added to MS's dashboard in the future, because all of the data came from there, after collection by my Band. All I did was enter it into excel and use formulas to automatically calculate a number of additional fields such as DOW, exercise zone, etc.