Since the last excel file I posted on doing weight adjusted erg scores proved to be our most read post to date I decided to post a couple of more example sheets for you. They are not necessarily ready to be used at a local event tomorrow, but they provide good examples of going beyond basic excel functionality to enhance your coaching. Athletes may well be interested too if only to gain a better understanding of some things coaches often talk about.While I liked using ZoHo for posting the last online spreadsheet it didn't perfectly recreate my work in Excel and the next two examples are more complex. So, I have posted them to a free file sharing site called "4Shared.com." Please go there and download your own copies of these two examples. As always, feedback is most welcomed and if you find them useful I would love to hear from you. I am also happy to make some changes if you need anything different but aren't up to speed with Excel.
Pair Matrix.xls
This file allows for easy calculations used in a traditional "pair matrix" for seat racing. It is limited to 4 port rowers and 4 starboard rowers, but simply putting in the name of the athletes and the times for each trial will rank each athlete. Scroll to the right of the matrix to see the ordered ranking of athletes. Of course not everyone feels that crew selection in a pair is the best way to select a larger crew, but that is for another post.
Time Trial.xls
This is for using Excel to calculate times in a time trial or head race. It is far more detailed than a simple calculation of (finish time - start time) as it reports perecentages of gold standards and percentages of winning times, and it also ranks crews on a separate worksheet without the need for doing any sorting. It's probably well suited for a coach to use with several crews in his/her club, but would need a bit of work to run a whole head race. I hope that it does provide some useful examples.
Download the files at 4Shared.com
If you enjoyed this post or other information on the site, subscribe to the Rowing Science Newsletter for regular updates and exclusive insider information for subscribers only.
or subscribe to the RSS Feed
