How to Make a Readiness Monitoring Using a Simple Wellness Questionnaire [Part 3]

How to Make a Readiness Monitoring Using a Simple Wellness Questionnaire

Part 3

Click here to read the first part of the article »
Click here to read the second part of the article »

Although I promised I will show you how to visualize the data using screen cast – I won’t do it. I started taping the screen and it took me more than one hour to actually explain basics, without going into advanced techniques, like name references, dynamic graphs and  dash boarding (which involves a lot of use of functions like VLOOKUP, HLOOKUP, INDEX and MATCH).

Editing would take even longer, since I am not so comfortable with these advanced techniques yet and I would need to reference help files or websites for formulas, parameters, etc,  and  that would need to be cut from the video, or you would just need to endure my Directors cut version 🙂

What I did instead, is I created a template which Complementary Training members can download at the bottom. Here is the screen of the dashboard.


I’ve left more than 150 empty spaces for you to fill with your own data, and I have provided 5 example surveys just to show you the how the visualizations and dashboard works.

To create visualizations of  the data, I’ve used Excel 2010 sparkline function, that shows 10 last measurements for each player or whatever you decide in the “Show last” box (that’s the power of dynamic graph).

The problems with sparklines is that there is no absolute zero (and no axes), but rather it depicts range between two end-points, so a small change end up looking huge. That’s why it is important to check numbers as well.  

If you are interested in these topics you can check the following sources that will help you out:

Members Only! To Continue Reading, Please Join Complementary Training Community »

Limited offer!

With Complementary Training You Always Get More!

Enhance Your Knowledge and Perfect Your Skills

Reach the next level with our books


First 10 Premium members who join us get 1-year membership, ALL the Cool Bonuses + two paperback books

Premium Membership
$350 per year

Hurry Up


spots left!


Expand your library even more!

Sign up now and get a 40% lifetime discount on all orders from Ultimate Athlete Concepts!

Take a look at all the books and educational material that UAC offers


The best part is – it doesn’t end there!

All our Premium members ALSO get COURSES to elevate their performance & TOOLS to reduce their effort during every-day work!

‘An investment in knowledge always pays the best interest’

– Benjamin Franklin

Premium Membership
$350 per year

Don’t miss out! Only the first 10 new Premium Members get Bootstrap Magnitude-based Statistics for Sports Scientists and Strength Training Manual paperback books for FREE in addition to other bonuses!

I am a physical preparation coach from Belgrade, Serbia, grew up in Pula, Croatia (which I consider my home town). I was involved in physical preparation of professional, amateur and recreational athletes of various ages in sports such as basketball, soccer, volleyball, martial arts and tennis. Read More »