Triathlon Training Dashboard: Chart Two


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.

The Purpose

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?”

The Chart

Chart two for the triathlon training dashboard is “Average Workout Time Per Week” seen below:

Excel ChartAs 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 Wait…

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!

This entry was posted in analysis, Fitness, Tools, Training Charts, Triathlon Training Dashboard and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s