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

There are two main worksheets in the excel file, one ofr recording the resutls of a single athlete, and another for the results of a class/team/squad. 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 (see FAQ below).

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


Some of the formula in this excel file refers to a worksheet that is hidden. How can I unhide the worksheet to view the data and make changes?

In your Excel workbook, right-click any sheet tab and select "Unhide". In the Unhide box, select the hidden sheet "Lookup Table" and click OK (or double-click the sheet name). Now you can see the data used for the calculations, and make changes if you wish.

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

To use the spreadsheet 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 (see above) and adjust the figures on the total distance column. It is not very simple but can be done.

I have data from my athletes on what I think is a good, average excellent etc rating. How can I change your "rating" column values to reflect my ratings?

It is possible to make changes so that a particular score has a different rating. First you have to "unhide" the hidden "lookup table" on the spreadsheet (see above). On the lookup table worksheet you will see a table for males and females, listing the rating for each score. You can adjust the ratings on the appropriate columns to whatever you want.

Is the VO2max calculation different for males and females?

It's the same formula for males and females. VO2max is dependent on the beep test level achieved, no matter who achieves it. See the beep test formula. If you select female on the spreadsheet, the VO2max score is the same, but the rating may change.

What are the VO2max calculations and ratings scores based on?

The formula used in the spreadsheet for calculating VO2max is based on the published tables in Ramsbottom et al. (1988) "A progressive shuttle run test to estimate maximal oxygen uptake." British Journal of Sports Medicine 22: 141-5. (See the beep calculator). The data values for the other columns are from these tables.


Related Pages


Beep Test Guide

Testing Extra

We have over 400 fitness tests listed, so it's not easy to choose the best one to use. You should consider the validity, reliability, costs and ease of use for each test. Use our testing guide to conducting, recording, and interpreting fitness tests. Any questions, please ask or search for your answer. To keep up with the latest in sport science and this website, subscribe to our newsletter. We are also on facebook and twitter.

How to Cite