Monday, May 14, 2012

Tracking my push-ups

I am trying to increase the number of pushups I can preform.
A great site dedicated to this effort is calld http://hundredpushups.com/

Being a scientific oriented guy, and a geek, I wanted to track my progress.
I decided to use a great site for this documentation:

http://daytum.com/
"DAYTUM HELPS YOU COLLECT,CATEGORIZE AND COMMUNICATEYOUR EVERYDAY DATA."




DAYTUM main page
So I created a new category called "Exercise", added a new item called "pushups", and inserted 16 and 17 as my first attempts.
But I couldn't find an option to show me a trend chart, the closest I could get was a lousy filled graph which didn't tell me much.

So I decided a to use a different site.
I opened a new form in google docs, with only one text box, the amount of pushups I did.


Now each time I perform a set of push-ups, i enter this site which i bookmarked, and insert the new number.

behind the scenes is a spreadsheet which gets updated automatically with the new information.

I created a new trend chart, but I wanted my chart to update with each new entry,
so in the range, I changed it from 
"Sheet1!A2:B3" to "Sheet1!A2:B20"

It basically tells the chart to create a chart from my existing data, AND from additional colums which are blank at the moment.
The chart algorithm is smart enough to exclude the non-existing data, and when new data is added, it will be added to the chart. 


And this is exactly what I wanted!

No comments:

Post a Comment