Categories
Productivity Quantified Self Technology

Nothing To See Here – Just Rescuing Time

I have gotten into a nice grove of writing a blog post a day – mostly describing some script, macro or hack that I have implemented. Today I have (rather belatedly) discovered RescueTime which will log and report on your online activities.

This has ironically distracted me from thinking about my blog whilst I install it on my phone and my chromebook. In return, I’ll investigate the API over the weekend and write up anything interesting that I find.

Let me know in the comments if you have any cool hint’s, tips or sample code that you would like to share with me.

Categories
Me Quantified Self Technology

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.

Categories
Quantified Self Technology

Quantified Self – Google And Android – Reporting

In the previous series I showed you how to

  • capture your data automatically,
  • collate and summarise your data.

Now it is time to show you how you can extract this information, with the final goal being the ability to get your (android in this case)phone polling for the data, and using it to make decisions.

In order to do this we will be using:

Google Apps Script (GAS) javascript functions to obtain values from the Google Spreadsheet where your data lives.

Google Web Services to provide a web interface to call the function and return the data over the internet.

Tasker to provide a programmatic interface on your phone to call the web service, handle the resulting data and do “something” with it.

Minimalistic Text to display the output on the home screen of your phone.

Categories
Quantified Self

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.

Categories
Quantified Self

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.

Categories
Quantified Self

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