• Creating Team Workout Using Excel

    By Mladen Jovanovic on 30/11/2012

    Creating Team Workout Using Excel Here is the screen cast of a rather simple solution in Excel for creating individualized team strength training workouts. Make sure to increase quality before watching.  

  • Estimating 1RM Using Load-Velocity Relationship

    By Mladen Jovanovic on 16/11/2012

    Estimating 1RM Using Load-Velocity Relationship This article is originally written and published for Kinetic website. I wanted to thank Rob Shugg for posting it and the whole Kinetic Performance company for creating such an amazing tool – PowerTool/GymAware. Also, I hope that the article will bring some more  food for thought and stimulate more work in this direction. There...

  • Player and Test Report/Dashboard Screencast

    By Mladen Jovanovic on 12/11/2012

    Player and Test Report/Dashboard Screencast Just a quick heads up for the screen cast of the Excel Dashboard/Reports and Database workbook I did. You can find more info here » Below the video Complementary Training members can find and download the Excel workbook(Player Profiles). The Player Profiles was a product before, but I removed it since Annual Planner for...

  • Player and Test Report/Dashboard

    By Mladen Jovanovic on 11/11/2012

    During the last couple of weeks I have been reading a lot on VBA (Visual Basic for Applications) for Excel since I haven’t found PivotTable enough to fulfill my needs. Luckily I have a programming background (yup, a nerd – been using Qbasic, C/C++, MATLAB and Assemblerduring the days of 486) so I had the basic skills and all...

  • Player profiles Dashboard – Template

    By Mladen Jovanovic on 31/10/2012

    At the moment I am working on an Excel database and dashboard for tracking performance and screening data and creating a player profiles (dashboards). Theoretically, this should help me devise individualized training focus (does this guys need more core work, more mobility, speed, etc… how is he ranking to other guys… did he improved since last testing?). What I...

  • Excel Tricks for Sports

    By Mladen Jovanovic on 30/10/2012

    Excel Tricks for Sports (YouTube channel) I don’t know why and how I haven’t stumbled on this channel before – it is full of Excel tips for everyday sport coaches problems. Make sure to check it out. I want to thank Darcy Norman for giving me a heads up. YouTube Channel:  

  • Olympic Lifting Matrix

    By Mladen Jovanovic on 28/10/2012

    Olympic Lifting Matrix I was training with a friend of mine, playing with GymAware Pro (with a Web support and BTW I am AMAZED how powerful this tool is) while doing olympic lifts. We were talking about different variations of the Olympic lifting (excluding the jerk) and I tried to explain to my friend the two criteria for the...

  • Excel Text Functions with John Lythe

    By on 26/10/2012

    This is the fundamental skills video in which John Lythe demonstrates basic text functions, such as: LEFT, RIGHT, MID, &, LEN, TRIM, CLEAN, UPPER, LOWER, PROPER.

  • How to Create Fitness Programme with Excel – Part 1

    By on 15/10/2012

    In this video tutorial, John Lythe is demostrating how to create Fitness Programe with Excel. This tutorial is very useful if you want to learn how to create your own Fitness Programm using Excel.

  • Individualizing HIIT in Intermittent Sport Athletes with the 30-15 Intermittent Fitness Test

    By Mladen Jovanovic on 14/10/2012

    I just got the following full paper which is very interesting. If you have access you should definitely check this one out. I would love to see a third experimental group too – combined approach