Athlete Monitoring 1.0

Athlete Monitoring 1.0

This is the MS Excel 2010+ (Windows) workbook designed for data collection and quick analysis and visualization using Pivot Table. The workbook is already set up for quick start-up with data collection such as athlete attendance, sRPE, Wellness, Injuries and Illness details and lot more. In the video at the bottom of the page you can see all the features and how-to of Athlete Monitoring 1.0.

This workbook is designed for small staff usage and sharing. High-end statistical analysis and data mining is possible by exporting the data to R or SPSS software, while the simple (visual) analysis is possible using Pivot Table and Chart.

To use this workbook successfully, users should have basic knowledge of how Pivot Table works and it would be highly recommended for the users to have at least some background in maintaining simple training database themselves.

For further customizations please contact me on my mail. 

The price for this workbook is $35

NOTE: If you don't receive the file immediately upon payment, please be free to send me the email and I will forward it ASAP. 

Strength Card Builder 2.0

Strength Card Builder 2.0

This is the new and updated version of Strength Card Builder with two new templates designed with the influence from Joe Kenn's Tier System workout cards.

The 3x5 Workout Card

Group workout card [LINK] (Produced on Mac)
Tier 3x5 (3 workouts, 5 exercises) [LINK]
Tier 4x5 (4 workouts, 5 exercises) [LINK]


This Excel workbook (both MAC and Windows) allows you to set up your athletes list, their 1RMs in key exercises, set up all other exercises and their relationships with 1RMs, up to 55 set & rep schemes that could easily be used by simple clicking. This way it takes matter of minutes to set up group or individual workouts using your predefined athletes, exercises and set & rep schemes. This is the SIMPLEST way to implement percent based approach to strength training (and it could be modified to be used with RPE approach, velocity based, etc). 

In the video below you can see all the features of this workbook. The video is made with the old version of the file, but all the workflow is the same with the new version PLUS two new beautiful individual templates that are ready to be used with your athletes with minimal set up.

For additional features and customizations please contact me on my mail.

The price for this workbook is $45

NOTE: If you don't receive file IMMEDIATELY after purchase please send me the email and I will send you the copy ASAP.

Strength Card Builder 1.1

Strength Card Builder 1.1

Because of the interest, I decided to modify and update my Excel workbook I have been using for creating strength programs for groups and individuals. 

In the video below you can see all the features of this workbook. One of the key features is the ability to create GROUP workout cards based on players 1RMs in core/key exercises, along with writing your own set & rep schemes.

This product is not available any more. Please look for the new version

Player Profiles v1.0

Player Profiles v1.0

In November 2012 I have created this Excel workbook to manage testing data or any other statistic one would love to keep track of for individual athlete.  You can find more info in the following links:

Finally done – Player and Test Report/Dashboard

Player and Test Report/Dashboard Screencast

The aim of this workbook is the following:

•          To manage tests and statistics and provide context for the data (poor, average, excellent score)
•          To manage player information
•         To visualize the data using bullet graphs (which provide context for the scores), trend lines  (history of scores), compare players to other within the squat and to identify strong and weak aspects
•          To create a one page report for each player
•          To  create testing report

 Here is the screenshot and the screencast is at the end of the page 

Since I ceased to develop this product I will not be providing any  type of support beyond the screencast above. There are some things you need to keep in mind before using it:

•         Always have a copy of the file with your data. Always
•         When you refresh the database, make sure to close all other open workbooks in Excel (I am not sure what it report an error when other workbooks are open, but it works perfectly when it is the only one workbook open)
•         If you change the test from more-is-better to less-is-better, you will need to adjust the bullet graphs manually and this involves setting up the x-axes (making them reverse) and changing the colors of the zones. This involves some knowledge of Excel though and trial and error.

Taking all these shortcomings into consideration I am still offering this workbook for intermediate Excel users since they might be able to modify it and maybe use some of the ideas to make their own templates.  Because I stopped the development of it and because I am not offering any support for it the price is  $25.  Also, to run it you would need to have Excel 2010 or later.

Annual Plan for Team Sports v1.0

Annual Plan for Team Sports v1.0

This is the Excel workbook aimed at helping team sport coaches setting up the annual plan and weekly/monthly calendar. 

The workbook is organized in couple of tabs. Two main tabs are Annual Plan and Training Sessions. All other tabs are related to components of the annual plan and include drop down lists and weighting factors used to calculate training load.

The worksheet utilize some VBA code for estimating training load. For example, if one uses 1x4x4’ R:3’ small sided game (4v4), that represents doing one set of four reps of 4 minutes interval with 3 minutes rest. VBA code is used to parse the data from the string and calculate load in A.U. (arbitrary units). Using weighting factors one could assign different weight to different components and calculate total load.

Visualizing workloads using sparklines is a neat way to see the progression (overall, or within the components – use check boxes to select what you want to be calculated and visualized) in load over time and see the differences between weeks. The formula for load in A.U. is quite simple: it is Load = Work_Time * Density, where Density is Work_Time / Total_Time. Not perfect, but get's the job done. For this reason it is crucial to assign different weighting factors for different drills within each training component (strength, speed, power...) and for each component in the total load. I have set up a table for Strength, Specific conditioning and General conditioning tab where one could see calculated loads. Using Solver tool (add-in) in Excel or Goal Seek one could select certain drills to have certain load. I will cover this in one of the how-to videos. 

The annual plan (Annual Plan tab) and daily calendar (Training Sessions tab) are connected in a way that you can see key constraints (games related data, camps, travel, vacation and testing) devised in the annual plan in the daily calendar for a given week. This allows for easier planning of a given week (microcycle).

The basic version is set up to be used in soccer, but by modifying the names of the boxes in the Annual plan and drop down lists for each training component one can adjust if for their own needs and their sports. 

On the bottom of the page I posted four instructional videos on how to use the Annual Plan for Team Sports v1.0, although I believe that most of it is quite intuitive especially for coached used to plan/work in Excel. 

Because the whole Excel book is not protected, that means you can customize it anyway you want, but it also means you can screw things up. Thus, I suggest making a copy of the workbook as soon as you download it.

For further customizations of the workbook please be free to contact me.

I am offering the Annual Plan for Team Sports workbook at  $45

Instructional videos - please use full screen and HD option

NOTE: If you do not receive the file immediately after the purchase please be free to contact me on my email. PayPal is supposed to work, but I had couple of customers reporting not getting the file.