In my first installment on the topic of creating a triathlon training dashboard, I discussed a few issues surrounding the data, some challenges with metrics such as tracking intensity and some feedback on a popular online workout tracking solution.
In the time since I published the last post, an entire triathlon season has gone by and I am a little more experienced on the fitness and triathlon analytics front. So much so, I created TrainingMetrix, LLC, a company dedicated to producing simple, yet sophisticated, analytics for athletes, triathletes, beginners, and anyone interested in fitness analytics in general.
Now that the shameless plug for my company has been accomplished, let’s get back to our second installment of building a training dashboard in Excel. The concept behind chart two is simply a check to see if the amount of time you are investing per day to accomplish your goals is appropriate. The question is, “How much time am I investing each day toward my triathlon goals?”
Chart two for the triathlon training dashboard is “Average Workout Time Per Week” seen below:
As you can see, the data shows that I only spend about 20 minutes per day training. What does this mean? Well, it means that my triathlon goal is only worth 20 minutes per day to me, at least according to my actual time since August 1.
Chart in Context
Of course, the question will come up regarding how much time should I spending working out per week? For a full distance triathlon, such as an Olympic, about 12 hours per week is normal. This translates to 1:42:51 per day. Compare this to my 0:20:26 average and it is clear that I won’t be finishing any Olympic distance triathlons anytime soon and the goal is to start increasing the daily workout time to a minimum sprint distance of 8:00:00 per week or 1:08:34 per day.
Note that I have not created a stacked series by sport, I am only looking at overall time per week. The high level metric wouldn’t show the same meaning broken down by sport, which make it difficult to conclude “yes” or “no” to the question of investment. In the context of sport, the “Weekly Training Summary” chart I discussed in the first installment is appropriate for more detailed sport analysis.
But, you might asking yourself why the “Weekly Training Summary” chart I presented in the first part of this series wouldn’t accomplish the same task. I thought about this as well and I think both charts deliver separate meaning. The Weekly Training Summary chart gives perspective on where I am spending time and how it is trending over time against distance. The “Average Workout Time Per Week” chart takes a simpler approach by asking “how much time am I investing in my training on a daily basis.” Both are similar, but they tell different stories.
The Next Installment Is…
With TrainingMetrix coming up to speed and I continue to experiment with fitness and workout analytics, there is a lot on this topic still to come. In fact, I would like to address the issue of tracking workout intensity over time in a simple, yet sophisticated way that anyone can do without expensive software.
Until later… Happy Triathloning!