Friday 25 January 2013

How do I use Excel, part #1: Training diary

I'm active sports enthusiast. I have been using Excel based training diary since year 2001. My every single sport activity is marked in Excel. Today I have 2806 activities recorded.

A single activity includes e.g. following information:

  • Date
  • Sport (e.g. running, volleyball, gym, walking, skiing, ...)
  • Duration
  • Type (aerobic, strength training, ball games, ...)
  • Distance
  • Heart rate
  • Calorie consumption
  • ...

Using this data I can analyse what ever information I ever need. It is interesting for example to check how my weekly sporting hours have changed during years. Or how my running pace is now much slower than ten years ago :-)

No comments:

Post a Comment