HR + Power Training Zone Calculator SPREADSHEET – Running, Cycling, Swimming, Triathlon

power-level-chart

Here is a rough and ready spreadsheet for working out your HR Zones based on simple tests.

This gives your HR zones for running and cycling and swimming (if available to you).

It also gives you power zones (if available to you) for cycling and running (STRYD). Look on the internet for DANIELS TABLES for running pace zones…that’s a bit more complex.

Don’t faff around just do the 30 minute tests.

The test is: Run or cycle (or swim or row) FLAT OUT for 30 minutes. That speed/pace/power for the entire duration is as good as doing it for an hour. That is your functional threshold power or speed/pace.

HR is a bit different. Ignore the first 5 or 10 minutes as it takes your heart a while to get your heartrate up to speed. So the average HR for the last 25/20 minutes is your LTHR. Stick it in the spreadsheet.

Simple. Just do the test.

20 minute estimates also exist but you must follow a slightly more complicated and stressful protocol. OR get it done at a university lab for about £130.

The spreadsheet also gives you notes to say what is happening in each zone when you train in that zone. IE what good it will do you. It’s a simple but poorly-looking information-rich resource, please use it for what it is.
Supporters: I am not a salaried journalist and rely on support from readers to keep the free content coming. If you want to support the work here then ad-free subscription starts at 49p (about 65c). Alternatively buying anything from my partners, below, also helps and may also get you a great discount. Thank you!

Support with 10% code: the5krunner10Support at your local country’s Amazon storefrontSupport with 10% code: the5krunner1010% Discount On Most Power Meters

Leave a Reply here

3 Comments on "HR + Power Training Zone Calculator SPREADSHEET – Running, Cycling, Swimming, Triathlon"

avatar
  Subscribe  
newest oldest most voted
Notify of
Andy Smith
Guest

Great info, thank you. Do you have a spreadsheet version for miles for distance and pace please?

Race Leader
Admin

sy no. you could maybe every cell dynamically on another spreadsheet and divide by 1.6093??? the ssheet was not mine originally I linked back to the original source (I hope)

J. Johnson
Guest

Very nice spreadsheet. Thanks!