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. For running alone, the free heart rate zone calculator does the same in your browser.

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 and power 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.

Last Updated on 2 November 2026 by tfk the5krunner


Small things I always use

Health, recovery and sleep

  • Kineon MOVE+: Red and infrared light for sore knees, Achilles and other joints after hard training. I use it.
  • FreeStyle Libre 3 Plus: Shows how my blood sugar responds to diet. Occasional use.
  • hDrop: Measures my sweat loss in summer and indoors. I use it.
  • Fourth Frontier Zone: Checks my heart under load in hard sessions.
  • Oura Ring 5: My partner’s recovery tracker of choice.
  • Eight Sleep: A cooling mattress cover my partner and I use nightly.

Watches and sensors

On the bike

Home and indoor training

  • NPE Runn: Makes my basic treadmill smart, sending more accurate speed and distance to my watch and Zwift. I use it.
  • Google Wifi: Keeps Zwift connected in my pain cave. I use it.
  • Apple TV 4K: Zwift on the big screen. I use two.
  • Google Nest Doorbell (wired, 2nd gen): My video doorbell, running in both Google Home and Apple Home via Starling. I use it.


Reader-Powered Content

Buy me a coffee

This content is not sponsored. It’s mostly me behind the labour of love, which is this site, and I appreciate everyone who supports it.

Support the site: Follow (free, fewer ads) · Subscribe (paid, ad-free) · Buy Me A Coffee

Written by real people, with AI assistance. Fact-checked and verified for originality. See the Editorial Policy. FTC: Affiliate Disclosure — some links pay commission. As an Amazon Associate, I earn from qualifying purchases.

5 thoughts on “HR + Power Training Zone Calculator SPREADSHEET – Running, Cycling, Swimming, Triathlon”

    1. 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)

    1. the spreadsheet has settings for many variables including age/gender

Comments are closed.