Hacking Sleep – What Works For Me

The Problem

For a long while I have struggled with the amount a quality of sleep I get so I decided to address this. For years I was using a FitBit Ultra and this allowed me to track the quality and duration of my sleeping. I have made a number of changes to slowly address this problem.

I knew I had a problem when my really loud buzzy alarm clock and the TWO alarms set on my mobile phone failed to get me to wake in the morning.

Continue reading Hacking Sleep – What Works For Me

Quantified Self – Google And Android – Aggregation

In this post I’m going to show you how to consolidate and aggregate your data easily between Google SpreadSheets.

To implement this I’ll be using Google SpreadSheets and SQL.

Continue reading Quantified Self – Google And Android – Aggregation

Quantified Self – Google And Android – Capture

In this post I’m going to show you how to implement a data capture system that will allow you to get your data easily into Google SpreadSheets. In my case I need this to be enabled from my Android phone but once you see the method you will see how it can be extended to other applications.

To implement this I’ll be using Google Forms, Google SpreadSheets and Tasker.

Continue reading Quantified Self – Google And Android – Capture

Quantified Self – Google And Android

Working as a Business Intelligence consultant I work with numbers every day and have to deliver benefit from them. I also do the same in my personal life, I LOVE my FitBit, and have macros that pull my stats out using the FitBit API and store it in a Google SpreadSheet and then aggregate the data and publish it to my dashboard.

This works fine for my automatically captured data, I needed a solution for more manual data points. I wanted a way to be able to capture data on my phone, store the data in Google SpreadSheets so that I can integrate it with my existing data and then send a summary spreadsheet back to my Android phone.

I will break the steps down in the following series of posts:

Quantified Self – Google And Android – Capture

Quantified Self – Google And Android – Aggregation

Quantified Self – Google And Android – Reporting

 

InBox Zero And Quantified Self

I’m a huge fan of keeping my inbox empty, but not very good and keeping it that way.

I’m becoming more interested in the “Quantified Self” concept i.e. you can only fix things that you can measure.

The obvious answer is to monitor what my GMail inbox looks like on a daily basis. Continue reading InBox Zero And Quantified Self