Beep Test Spreadsheet

beep spreadsheetI have created a microsoft excel spreadsheet that can be used to record and analyze the results of your athletes or teams. There are two example sheets, one for single athlete results, the other for recording squad or team results.

The spreadsheet contains columns for determining the following, based on the standard 20m beep test:

Get Your Free Spreadsheet

Yes, it really is FREE! Enter your email address and you will be directed to a page where you can download the file.

* Submitting your email will also subscribe you (100% free) to the Topend Sports newsletter, containing top breaking news in sport, science, fitness and nutrition. Don't worry, you can easily unsubscribe at any time, but I don't think you will want to. As well as great information, you will get more freebies and other great offers!

Using the Spreadsheet

You can modify the athlete or squad sheet to suit your needs. Some of the columns refer to a (hidden) lookup table that needs to remain in the file for it to work correctly.

I would love your feedback on how you go using this spreadsheet, and welcome any suggestions on how it can be improved.

FAQ

Can the spreadsheet be used for a 15m beep test?

To use the speadsheet for a beep test over a distance other than 20m, you won't have to adjust the age, decimal values, total time, as that will be the same. You could make adjustments to correct total distance run. However, the ratings and VO2max calculation would not apply and is not something that can be adjusted easily. To correct the total distance run, you will first need to change the formula in that column, replacing 20 for whatever the distance run, then you would have to "unhide" the hidden lookup table on the spreadsheet and adjust the figures on the total distance column. It is not very simple but can be done.

Related Pages