• # Percent-Based to Velocity-Based Converter 2.0 [Excel Workbook + Video Tutorial]

“Nothing Is More Practical Than A Good Theory” – In the following video I am explaining how to use Excel converter to convert percent-based programs to velocity-based programs based on lifters load-velocity profile for a given movement.

• # How to Track 1RM Without Actually Testing It?

Introduction – There are two main methods for estimating 1RM of an exercise: (1) to build up to true 1RM lift and (2) to estimate 1RM from reps-to-(technical)-failure  with sub-max weight using various formulas and tables.

• # Optimizing Groups for Small Sided Games (SSGs)

In the following video I will show you how to: a) Calculate normal scores for any test/statistic (percentiles & z-scores) and the difference between them; b) Calculate composite scores using weighting factors and normal scores; c) Use one great Excel tool – SOLVER to provide optimized solution for groups;

• # Analyzing Time-Series of Individual Data – Part2: Using Harmful/Trivial/Beneficial Chances

Just a quick update – after a comment by John Fitzpatrick (@JFitz138) on the use of Will Hopkins’s approach of calculating chances I decided to give it a shot. For a Typical Error (used together with SWC to calculate chances) I used SD of the Rolling Average.

• # Analyzing Time-Series of Individual Data

If you haven’t been living in a cave for the last couple of years, you definitely noticed an increase in data collection, data mining and visualization. HRV tracking, jump output tracking, estimating 1RMs from velocity-load data, game statistics, performance analysis, various testing statistics, body weight, Run Keeper, Run Tracker, and all that quantified-self movement.

• # Some Great Findings and Ideas From Velocity-Based Strength Training

Some great findings and ideas from velocity-based strength training – I have been thinking more and more about velocity-based lifting recently as a method of prescribing load and volume for an individual. I have wrote couple of blog posts and article on this topic that you might want to read first:

• # MMA Training Classification Using Bondarchuk System

I decided to publish the following tables that I have created to guide my planning/programming for one  friend of mine and MMA athlete that asked for my advice last year.I have utilized Bondarchuk approach in classifying the drills for each training component (and goal) as I did in my Physical Preparation for Soccer manual and Periodization Confusion article.

• # Statistics 101: Two-Sample Hypothesis Testing

I am slowly going through Statistical Analysis with Excel book and I am making simulation worksheets to understand the concepts. I have created the the worksheet with two populations and two pulled samples to get my mind on standard error of the difference between means which is used in Two-Sample Hypothesis Testing. I have used both Z-Test (when populations…