Posts Tagged ‘log’

Logging steps via Google Docs

Thursday, September 15th, 2011

My employer, Pearson, provided the opportunity for its employees to participate in the 2011 Global Corporate Challenge. The GCC consisted of teams of 7 who tracked their daily steps counted with a pedometer for 16 weeks. The idea is to motivate people to become more active. The event started on May 19, 2011 and ended September 6, 2011. Being an engineering type of person, I liked the idea of gathering the daily step count as a metric for activity. The event suggested a goal of achieving 10,000 steps a day. I was pretty active recording my pedometer activity every morning via the SMS text message data entry technique: the GCC has an SMS short code and you entered the date and number of steps. Submitted text messages were recorded in your step log on the GCC web site. Being able to enter the data via my phone was very handy as it let me enter data while I was on vacation without missing a day. But, now that the event is over, I still wanted to keep track of my step counts. Here is the technique that I worked out using Google Docs to record my step counts.

I created a Google Docs Form to collect my daily step count. The collected data is stored in a Google Docs Spreadsheet. The form can be viewed in a web browser or in Google Docs for Android. Since I have an Android phone, the form lets me use my phone to still collect my daily step counts each morning. And since the data is stored in a spreadsheet, I can perform calculations on the data to get my total and average step counts and even graph my daily totals. Here is the process that I use.