Missing Log Entries

While reviewing my survey results (sleep log), I discovered that I am missing all entries between 8/18 7:30am through 8/20 2:55am; a total of 8 entries. I am certain beyond the shadow of a doubt that I properly submitted the entries, so this is very disappointing and annoying.

As I mentioned in a previous blog entry, I created a Google Drive form that captures interesting data about me and my state of mind after each time that I wake up, plus right before I go to (core) sleep. That data is then saved into a Google Drive spreadsheet.

Google warns that if you adjust the format of that spreadsheet or the form, that you can unwittingly break the connection with it to the form, and I did just that on August 14th. So that I didn't have to investigate what it would take to repair the "break", I decided to just create a new sheet in the same document, and connected the adjusted form to that.

Thinking back, around 8:00am on 8/18 I did muck around with creating a new chart in that spreadsheet that helps visualize trends (especially with weight). However, if that broke it, I don't understand why now when I have the spreadsheet open in another tab as I submit an survey, it immediately records correctly.

For now, I will begin confirming the record for each new entry, but further investigation and research into the topic will be warranted if I notice that entries are getting lost.

*Edit 08/20/2013 9:49PM

My survey for Day 8 - Post Nap 2 is not being saved in the spreadsheet, even within the same environment as the Post Nap 1 had worked. I am going to take this opportunity to add a few sleep deprivation symptoms that I have noticed, then re-connect the form with yet another sheet.