Beep Test Spreadsheet - FAQ
I have created a Microsoft Excel spreadsheet that can be used to record and analyze the beep test results of your athletes or teams. You can purchase the file, or get it as part of the beep test package. If you have purchased the file already, and you have any problems or questions, they may be answered below. Otherwise, drop me a line.
Using the Spreadsheet
There are two main worksheets in the excel file, one for recording the results 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 lookup table that needs to remain in the file for it to work correctly.
FAQ
Some of the formula in this excel file refers to another worksheet. Can I make changes to that worksheet?
In earlier versions of the spreadsheet, the lookup table was on a hidden tab, but that is not the case now. If it is hidden, 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 any changes 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 no different. 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.
BEEP TEST PACKAGE - only $10
The 20m Beep Test (male & female voices) + Training Levels + 'Beeps Only' track + Excel Spreadsheet + eBook Guide (PARQ, consent form, test recording sheet, warm-up, tips, norms + much more!)
The ultimate beep test package, including two versions of the beep test audio file (male and female voice), an audio track with only the beeps (no voices), 8 audio tracks for training at specific test levels, an Excel spreadsheet with an offline calculator and tables for recording, analyzing and presenting results, a 12-page eBook beep test guide which includes a PARQ, informed consent form, and test recording sheet plus much more. All these files are available individually for $5 each, or even better get them all for $10. Check out the details.
Related Pages
- Other beep test downloads
- Calculating Your Score — calculator to determine your VO2max equivalent score.
- Beep Test Software — provides the standard Multistage Fitness Test or Bleep Test right on your PC or Laptop, which you can also modify to create your own beep test version.
- See the Beep Test Table which has all the timings and speeds for this test
- Maximizing Your Score — to get the most out of the beep test.
- Test Procedure — Detailed instructions for conducting the beep test. Also video examples.
- Purchasing the cd.
Any comments, suggestions, or corrections? Please let us know.
Current Events