Spreadsheet to help with the Concept2.co.uk heart training

General discussion on Training. How to get better on your erg, how to use your erg to get better at another sport, or anything else about improving your abilities.
JasonZ MIT
Paddler
Posts: 1
Joined: February 1st, 2012, 12:10 pm

Re: Spreadsheet to help with the Concept2.co.uk heart traini

Post by JasonZ MIT » February 25th, 2012, 12:22 pm

Hi Randy,

Sorry to bother you with what may be a frequently repeated question, but ...

The spreadsheet you've posted (which BTW, I had no problem downloading and is a wonderful aid) does its calculations in terms of %MHRR; the UK interactive guides, as of this date, still provide their guidance in terms of %MHR. Did I understand you correctly back in your 2008 posts that the UK programmes were going to switch to %MHRR also, so everything would be compatible?

I ask because I'm getting a bit confused with the spreadsheet showing (for example) UT2 as 65-70% MHRR, while the UK guides for Interactive Weight Loss and Rapid Fitness Training show UT2 (in the Training Band Key) as 55-70% MHR.

I'm a 63 yo male, with a RHR of 72, so I get the following numbers:

RHR 72
MHR 163
HRR 91
Spreadsheet: UT2 65-70% MHRR 131-136
UK Guides: UT2 55-70% MHR 90-114

That's a fairly significant difference ... any suggestions on what to change so that they spreadsheet and the guides (both for weight and for fitness training) are consistent?

Regards,

JasonZ

BetaMO
Paddler
Posts: 17
Joined: April 28th, 2012, 3:46 am

Re: Spreadsheet to help with the Concept2.co.uk heart traini

Post by BetaMO » May 5th, 2012, 3:43 am

Citroen wrote:
Bill wrote:Hey Citroen,

How did you put that spreadsheet out onto the web again as rowing.servebeer.com/Heart_Rate.xl ?
rowing.servebeer.com is a virtual host on my webserver running on my Ubuntu computer that sits under the desk in my home office.

If you want a place to play build a blog on http://wordpress.com, http://posterous.com or http://blogger.com - you can host file attachments on most blogging services.

If you want to play with a personal website try webs.com
hahaha - rocking man!

Love it, but I have a question like JasonZ MIT - the calcs?

jamesg
Half Marathon Poster
Posts: 4186
Joined: March 18th, 2006, 3:44 am
Location: Trentino Italy

Re: Spreadsheet to help with the Concept2.co.uk heart traini

Post by jamesg » May 6th, 2012, 12:50 am

The Interactive 2k uses HRReserve saying:

HRR% = Heart Rate Reserve (HRR) is the term used to describe the difference between a person's maximum (MHR) and resting heart rate (RHR). To calculate the training zones we use the following formula: Heart rate = (HRR * percentage) + RHR.


The fast-track and the weight-loss schedules say MHR, but show no values; so use Reserve as above.

HR training is dodgy anyway: a max test is needed as average formulae are not applicable to single persons; I doubt whether bands drop with age, although MHR certainly does; HR drift. So once we've learnt to row, we can use the other guides (paces, sensations, sweat, rating etc), although HR would have the advantage of automatic update.
08-1940, 183cm, 83kg.
2024: stroke 5.5W-min@20-21. ½k 190W, 1k 145W, 2k 120W. Using Wods 4-5days/week. Fading fast.

marshfieldman
Paddler
Posts: 1
Joined: August 8th, 2012, 11:14 am

Re: Spreadsheet to help with the Concept2.co.uk heart traini

Post by marshfieldman » August 8th, 2012, 11:47 am

Hi
Plaese can you help
this is my first post

How do I get hold of the spreadsheet you are talking about I would like to use it as I have just started training again
after 15 years
Just got concept2 model C out of the basement
It worked first time just by simply adding a bit of oil onto the chain
PM2 monitor needed new batteries !!
Is The PM3 monitor worth investing in?
Thanks

User avatar
Citroen
SpamTeam
Posts: 8008
Joined: March 16th, 2006, 3:28 pm
Location: A small cave in deepest darkest Basingstoke, UK

Re: Spreadsheet to help with the Concept2.co.uk heart traini

Post by Citroen » August 8th, 2012, 12:12 pm

marshfieldman wrote: How do I get hold of the spreadsheet you are talking about I would like to use it as I have just started training again
after 15 years
The copy I snagged is still here: http://rowing.servebeer.com/Heart_Rate.xls

Hugh Hamilton
Paddler
Posts: 1
Joined: March 16th, 2013, 11:32 am

Re: Spreadsheet to help with the Concept2.co.uk heart traini

Post by Hugh Hamilton » March 16th, 2013, 11:39 am

I have just had my first look at the online interactive planner and I love it! However I'm a 49 year old interested in joining fellow university alumni in a head race, so my training goal is 5k, not 2k. Is it possible to make some basic changes to the math of the planner to allow for the 5k training goal, or is it more complicated than that?

Thank you!

Fusiform
Paddler
Posts: 4
Joined: August 5th, 2013, 7:36 am

Re: Spreadsheet to help with the Concept2.co.uk heart traini

Post by Fusiform » August 5th, 2013, 7:40 am

hi all,

I was using the interactive training page on the C2 website for my training. But I just saw that the site has been upgraded and the Interactive training page removed. Worse, it does not seem to be included in the new website.

Any ideas? Is there anyone I can contact to ask to bring it back? It has helped me a lot achieve my goals, without spending hours looking for training protocols on the internet or hiring a coach.

Many thanks

frederick
Paddler
Posts: 1
Joined: August 5th, 2013, 9:32 am

Re: Spreadsheet to help with the Concept2.co.uk heart traini

Post by frederick » August 5th, 2013, 9:34 am

I was looking for it myself.

Finally found it here:
http://therowingcompany.com/training/interactive

Fusiform
Paddler
Posts: 4
Joined: August 5th, 2013, 7:36 am

Re: Spreadsheet to help with the Concept2.co.uk heart traini

Post by Fusiform » August 5th, 2013, 10:18 am

Oh thanks so much!! what happened there? What is this website?

User avatar
gregsmith01748
10k Poster
Posts: 1359
Joined: January 8th, 2010, 2:17 pm
Location: Hopkinton, MA

Re: Spreadsheet to help with the Concept2.co.uk heart traini

Post by gregsmith01748 » August 5th, 2013, 11:30 am

Apparently, concept2 has changed their structure in the uk. The old team of concept2 folds have formed a company that sells concept2 ergs and other gear, and concept2 has its own direct website. Not sure why it changed.
Greg
Age: 55 H: 182cm W: 90Kg
Image

User avatar
sharp_rower
2k Poster
Posts: 215
Joined: April 2nd, 2006, 1:45 pm
Location: Boston, Massachusetts, USA

Re: Spreadsheet to help with the Concept2.co.uk heart traini

Post by sharp_rower » January 6th, 2014, 11:36 pm

I started following this training plan to train for the 2014 CRASH-Bs on February 16. I'm really not used to heart rate training and find it hard to target particular heart rates; I'm much more used to targeting particular 500 meter splits.
Mid-30s, 6'0", 230lbs (working on that.......), 6:54.8 2k PB (1:43.7, March 2015). Occasional OTW rower.
Don't believe everything you read on the internet!
Other PBs: 1k @ 1:39.9 (March 2015).

Post Reply