I have received a number of emails from coaches that are concerned about using a drop down box with all their athlete’s names available to choose from – some of these concerns are athlete’s picking the wrong names by mistake … Continue reading CREATE ATHLETE ID FOR GOOGLE DOCS QUESTIONNAIRE
This latest worksheet is based on the work of Sean Williams, Stephen West, Matthew Cross & Keith Stokes, where they examine if there is a better way to determine the acute:chronic workload ratio I’ll leave the debate on the best way … Continue reading EXPONENTIALLY WEIGHTED MOVING AVERAGE WORKSHEET
I’ve used google forms and docs extensively to build free questionnaires and spreadsheets to collect and display data I need to help monitor the wellbeing of my athletes. I’ve used this data to help build excel databases, such as the … Continue reading TRIAL GOOGLE FORMS FOR WORKLOADS & WELLNESS
Using a simple bar chart, playing around with how it’s formatted and presented and you can create some cool progress bars to display things like intensity or highlight any variable that has a beginning and end value! To create heart … Continue reading USING PROGRESS BAR CHARTS TO DISPLAY TESTING DATA
Nice little one that could be incorporated in wellness dashboards or physio reports if desired. Lots of potential with this type of creation and you could go into as much injury detail as possible. I’ve basically started out by combining … Continue reading HIGHLIGHT INJURIES ON HUMAN BODY
This is an incredibly simple and cool way to create a main dashboard that will take you to any tab within a given sheet. Not one I would have thought to do a post about but something that has been … Continue reading CREATING A PICTURE DASHBOARD
This is a nice little table I have made using the work of Mladen Jovanovic and his load exertion table, which is based off the work of Dan Baker. I’ve also combined this with a 1 rep max prediction equation I found courtesy … Continue reading 1RM PREDICTION/LOAD EXERTION TABLE.