![]() |
View
New Forum Topics Today's Forum Topics Set as homepage |
|
|||||||
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. |
|
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
#1 |
|
Registered User
Join Date: Mar 2004
Posts: 1,781
|
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...
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 |
|
|
|
|
|
#2 |
|
Registered User
Join Date: Aug 2005
Location: Canada
Posts: 1,234
|
That's awsome.
It'd be nice if this remains available somewhere (in the articles maybe) for upcoming members. |
|
|
|
|
|
#3 | |
|
Registered User
Join Date: Mar 2004
Posts: 1,781
|
Quote:
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. ![]() |
|
|
|
|
|
|
#4 | |
|
Community Team
Join Date: Nov 2002
Location: Brackla, South Wales
Posts: 3,827
|
Quote:
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 |
|
|
|
|
|
|
#5 |
|
Registered User
Join Date: Sep 2005
Posts: 134
|
I suppose the accuracy of the calculator wouldn't decrease even the number of decimals shown were decreased...
Antti |
|
|
|
|
|
#6 | |
|
Registered User
Join Date: Mar 2004
Posts: 1,781
|
Quote:
|
|
|
|
|
|
|
#7 |
|
Registered User
Join Date: Mar 2004
Posts: 1,781
|
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. |
|
|
|
|
|
#8 |
|
Registered User
Join Date: Apr 2006
Posts: 9
|
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 |
|
|
|
|
|
#9 | |
|
Registered User
Join Date: Mar 2004
Posts: 1,781
|
Quote:
|
|
|
|
|
|
|
#10 | |
|
Registered User
Join Date: Mar 2006
Location: Brisbane
Posts: 23
|
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:
|
|
|
|
|
|
|
#11 |
|
Registered User
Join Date: Jul 2005
Location: Jungles of the North
Posts: 10
|
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? |
|
|
|
|
|
#12 | |
|
Registered User
Join Date: Mar 2004
Posts: 1,781
|
Quote:
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. |
|
|
|
|
|
|
#13 |
|
Registered User
Join Date: Jul 2004
Location: Georgia
Posts: 109
|
nice little file!
|
|
|
|
|
|
#14 |
|
Registered User
Join Date: Jan 2006
Posts: 18
|
nice
__________________
0,5*d*v^2*A*Cw + m*g*cos(ß)*Cr |
|
|
|
|
|
#15 |
|
Registered User
Join Date: Mar 2004
Posts: 1,781
|
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.
|
|
|
|