Cycling and bicycle racing discussion forums.   View New Forum Topics
Today's Forum Topics

Set as homepage


Go Back   Cycling Forums > Tech Corner > Cycling Training
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read


Welcome to CyclingForums.com

You are currently viewing our website as a guest which gives you limited access to view most discussions. You will have to register before you can post to this thread.

By joining our free online community you will have access to post new topics, communicate privately with other cyclingforums.com members (PM), respond to polls, upload photos and access other special features like product reviews and classifieds.


Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

Reply
 
Thread Tools Search this Thread Display Modes
Old 12-05.-2006, 12:01 PM   #1
Doctor Morbius
Registered User
 
Doctor Morbius's Avatar
 
Join Date: Mar 2004
Posts: 1,781
Default Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

I've noticed a few recent threads asking questions about heart rate training zones. Since it's that time of year again when everyone gets out their trusty steed and start logging miles I thought this would be useful.

It's a heart rate calculator for those of you that still train using obsolete methods (like me). It's an Excel spreadsheet and you will need to know your age, resting HR, LT via Friel's test and LT via Coggan's test should you want to use those features. I'm sure most of you will already know your max heart rate but there are a couple of ways to estimate it should you need to.

You will find heart rate training zones from the following orgs/coaches...
  • Joe Friel
  • Andy Coggan
  • British Cycling Fed
  • Peter Keen (original BCF guidelines)
  • Sally Edwards
  • Karnoven Formula
  • Ric Stern
  • Dr. Peter Kanopka
  • ACSM guidelines

The information in BLUE is what you will need to enter. It currently has my info so just type over it. The pages following the calculator give more in depth detail of the coache's guidlines.

Unzip and have at it. If you don't have Excel you can download a free Excel viewer from Micro$oft. I used Excel 2003 to type it up.

Don't worry, the file has been tested several times for viruses. That's the last thing I would do to you guys. If you don't have an anti-virus package I highly recommend Avast. It is free for personal use. www.avast.com
Attached Files
File Type: zip Morbius Heart Rate Zone Calculator.zip (20.2 KB, 5703 views)
Doctor Morbius is offline  
Reply With Quote
Old 12-05.-2006, 12:24 PM   #2
SolarEnergy
Registered User
 
SolarEnergy's Avatar
 
Join Date: Aug 2005
Location: Canada
Posts: 1,234
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

That's awsome.

It'd be nice if this remains available somewhere (in the articles maybe) for upcoming members.
SolarEnergy is offline  
Reply With Quote
Old 12-05.-2006, 12:47 PM   #3
Doctor Morbius
Registered User
 
Doctor Morbius's Avatar
 
Join Date: Mar 2004
Posts: 1,781
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

Quote:
Originally Posted by SolarEnergy
That's awsome.

It'd be nice if this remains available somewhere (in the articles maybe) for upcoming members.
Thanks. PM Ric. Maybe he'll do that or have a suggestion.

It should be noted that I didn't ask for permission from any of these coaches to put their schema into this calculator. I am hoping it is OK with them.
Doctor Morbius is offline  
Reply With Quote
Old 12-05.-2006, 06:19 PM   #4
ric_stern/RST
Community Team
 
Join Date: Nov 2002
Location: Brackla, South Wales
Posts: 3,827
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

Quote:
Originally Posted by Doctor Morbius
Thanks. PM Ric. Maybe he'll do that or have a suggestion.

It should be noted that I didn't ask for permission from any of these coaches to put their schema into this calculator. I am hoping it is OK with them.


i'll make it a sticky soon. however, Dr M can you PM me -- there's a couple mistakes i've spotted that i guess should be rectified

cheers
ric
__________________
http://www.cyclecoach.com
ric_stern/RST is offline  
Reply With Quote
Old 12-05.-2006, 08:32 PM   #5
sidewind
Registered User
 
Join Date: Sep 2005
Posts: 134
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

I suppose the accuracy of the calculator wouldn't decrease even the number of decimals shown were decreased...

Antti
sidewind is offline  
Reply With Quote
Old 14-05.-2006, 09:18 AM   #6
Doctor Morbius
Registered User
 
Doctor Morbius's Avatar
 
Join Date: Mar 2004
Posts: 1,781
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

Quote:
Originally Posted by sidewind
I suppose the accuracy of the calculator wouldn't decrease even the number of decimals shown were decreased...
Yes, rounding the fractions up or down is perfectly acceptable. HR training isn't that accurate anyway compared to using a power meter/wattage.
Doctor Morbius is offline  
Reply With Quote
Old 14-05.-2006, 09:23 AM   #7
Doctor Morbius
Registered User
 
Doctor Morbius's Avatar
 
Join Date: Mar 2004
Posts: 1,781
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

OK, with Ric's help I've updated his and Peter Keen's zones so they are more current and/or accurate.

If I get the notion or if there are enough responses I will add Chris Charmichael's older and newer zones. I have a text with his older zones based on MaxHR, but I don't have his newer zones based on his 3 minute or 8 mile threshold test. I believe those are in "The Ultimate Ride" text, which I don't have. Not sure.

Anyway, there should be plenty of HR zones and info to get started. Have a healthy and safe season on the bike.

Edit: Note that although I have a desktop support and help desk background, I am not an Excel guru. If you have suggestions feel free to PM me. I usually log in every few days.
Attached Files
File Type: zip Morbius Heart Rate Zone Calculator.zip (20.6 KB, 1109 views)
Doctor Morbius is offline  
Reply With Quote
Old 01-06.-2006, 12:41 PM   #8
Dirty Digger
Registered User
 
Join Date: Apr 2006
Posts: 9
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

DM,
Fantastic s/s.
Have you included the Zones which come as pdf on CD with some (most?) Polar HRM for cycling. 'Performance Cycling' by Adrie van Diemen and Jabik-Jan Bastiaans 2002?
DD
Dirty Digger is offline  
Reply With Quote
Old 02-06.-2006, 03:11 AM   #9
Doctor Morbius
Registered User
 
Doctor Morbius's Avatar
 
Join Date: Mar 2004
Posts: 1,781
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

Quote:
Originally Posted by Dirty Digger
DM,
Fantastic s/s.
Have you included the Zones which come as pdf on CD with some (most?) Polar HRM for cycling. 'Performance Cycling' by Adrie van Diemen and Jabik-Jan Bastiaans 2002?
DD
Check your PM's.
Doctor Morbius is offline  
Reply With Quote
Old 26-06.-2006, 06:05 AM   #10
smithsr
Registered User
 
smithsr's Avatar
 
Join Date: Mar 2006
Location: Brisbane
Posts: 23
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

This is an excellent tool. I had done this to alimited extent, but this is great for those of us who like a lot of comparative info.



Quote:
Originally Posted by Doctor Morbius
OK, with Ric's help I've updated his and Peter Keen's zones so they are more current and/or accurate.

If I get the notion or if there are enough responses I will add Chris Charmichael's older and newer zones. I have a text with his older zones based on MaxHR, but I don't have his newer zones based on his 3 minute or 8 mile threshold test. I believe those are in "The Ultimate Ride" text, which I don't have. Not sure.

Anyway, there should be plenty of HR zones and info to get started. Have a healthy and safe season on the bike.

Edit: Note that although I have a desktop support and help desk background, I am not an Excel guru. If you have suggestions feel free to PM me. I usually log in every few days.
smithsr is offline  
Reply With Quote
Old 02-07.-2006, 07:19 AM   #11
rippitupp
Registered User
 
rippitupp's Avatar
 
Join Date: Jul 2005
Location: Jungles of the North
Posts: 10
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

I just had a look at the HR Zone Calculator. Some very useful information for anyone who is training. i am just starting to train again after a knee injury, and i have little, quite possibly none of the endurance i had before my injury.

Most of the information i can figure out, but for the LT, where or how would i go about figuring that out? I didn't see anything inthe spreadsheet that detailed that. Maybe i just didn't look carefully? Any advice?
rippitupp is offline  
Reply With Quote
Old 06-07.-2006, 09:16 AM   #12
Doctor Morbius
Registered User
 
Doctor Morbius's Avatar
 
Join Date: Mar 2004
Posts: 1,781
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

Quote:
Originally Posted by rippitupp
...

Most of the information i can figure out, but for the LT, where or how would i go about figuring that out? I didn't see anything in the spreadsheet that detailed that. Maybe i just didn't look carefully? Any advice?
It depends on who's definition you are wanting to use for LT.

If it's the Friel test, warm up thoroughly and do a 30 minute time trial. Start your HRM (or hit the lap counter) 10 minutes into the ride. Use the average of the last 20 minutes.

If it's A. Coggan's test, warm up thoroughly and do a 60 minute time trial. Use the average HR for the entire 60 minutes.

Since these LT values are based on HR they are only "estimates" without using any special monitoring equipment. They are useful for guidelines for the coache's zones and training protocols. You may notice if you do the tests in May and again in July or August you will obtain different HR values due to the Summer heat.
Doctor Morbius is offline  
Reply With Quote
Old 07-07.-2006, 10:46 AM   #13
tehpr3chr
Registered User
 
Join Date: Jul 2004
Location: Georgia
Posts: 109
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

nice little file!
tehpr3chr is offline  
Reply With Quote
Old 15-07.-2006, 04:44 AM   #14
CUBE
Registered User
 
Join Date: Jan 2006
Posts: 18
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

nice
__________________
0,5*d*v^2*A*Cw + m*g*cos(ß)*Cr
CUBE is offline  
Reply With Quote
Old 15-07.-2006, 07:33 AM   #15
Doctor Morbius
Registered User
 
Doctor Morbius's Avatar
 
Join Date: Mar 2004
Posts: 1,781
Default Re: Here's a fairly extensive HR Zone calculator. Yes it's FREE!!

Thanks. I had no idea that this thead would get over 3500 hits. I'm planning to add some more coache's zones to it. Am currently waiting on some other information to come in so I can make all the changes at once.
Doctor Morbius is offline  
Reply With Quote

Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT +10. The time now is 01:04 AM.


Powered by: vBulletin Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2006 cyclingforums.com

Links to websites we like:
Pezcyclingnews | Cyclingnews.com | Wine Zone | iinet