Show power at a given heart rate

516 views
Skip to first unread message

CR

unread,
Jul 15, 2019, 4:43:12 AM7/15/19
to golden-cheetah-users
Hi,

I asked a similar question a while back but didn't seem to get any replies, so trying again in case it slipped through the net.

Is it possible to get GC to show you your power at a given heart rate for a specific ride?
Is it possible to show how the power at this heart rate has changed over a specific time period (multiple rides)?

I know there is the Hr:Pw tab, but that just seems to give you power at 150bpm, while the rest of the plotted data are just single data points of Hr:Pw rather than an average at a given heart rate.

If anyone is interested, I'm trying to see how my power at aerobic (not anaerobic) threshold has changed over time, which means in my case I'd like to know power around 141bpm.

Hope you can help.

Calum

Ale Martinez - No direct email please

unread,
Jul 15, 2019, 9:37:35 AM7/15/19
to golden-cheetah-users
El lunes, 15 de julio de 2019, 5:43:12 (UTC-3), CR escribió:
Hi,

I asked a similar question a while back but didn't seem to get any replies, so trying again in case it slipped through the net.

If you search this forum you will find previous discussions about this topic.

Is it possible to get GC to show you your power at a given heart rate for a specific ride?
Is it possible to show how the power at this heart rate has changed over a specific time period (multiple rides)?

I know there is the Hr:Pw tab, but that just seems to give you power at 150bpm, while the rest of the plotted data are just single data points of Hr:Pw rather than an average at a given heart rate.

If anyone is interested, I'm trying to see how my power at aerobic (not anaerobic) threshold has changed over time, which means in my case I'd like to know power around 141bpm.

Power@150 is based on the power/HR regression curve plotted in that chart, the line equation is showed in the line above as: slope*x+intercept, the R value and the dots dispersion are indicators of how represetative that value can be. Following the same reasoning you could compute Power@141=(141-intercept)/slope.

It is possible to automate this using a Python or R chart although probably Power@LTHR would be a nice addition to (or replacement for) Power@150.

Currently there is no quick-and-easy way to track that across rides. It would be possible to create a custom metric for this, but I have not tried.

Remco Boerwinkel

unread,
Jul 15, 2019, 11:16:18 AM7/15/19
to golden-cheetah-users
Hi,

I created a chart that shows avg power at certain hr over rides (seasons)

Uploaded it in trend charts.
Try en test (warning it get slow with a lot of activities)

Kind regards,
RB


Op ma 15 jul. 2019 10:43 schreef CR <calum...@gmail.com>:
--
_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en
---
You received this message because you are subscribed to the Google Groups "golden-cheetah-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/golden-cheetah-users/29c66fa3-9db1-4e53-9603-9518f124cfe9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RB

unread,
Jul 15, 2019, 11:54:14 AM7/15/19
to golden-cheetah-users
Hi,

I see that i only shared the Python chart
Here are both charts.
Any feedback is welcome.

RB
Average pwr by hr (Python).gchart
Average pwr by hr (R).gchart

Calum Riach

unread,
Jul 16, 2019, 12:44:14 PM7/16/19
to RB, golden-cheetah-users
Hello,

many thanks to you both! Sorry for the late reply, I just went on holiday and have limited wifi access. 

Ale, thank you for the info about existing questions on the forum, I will take a look.

Remco, that's very kind of you to make those charts. However, I have no idea how to use them! Would you mind telling me how I get these to do something in Golden Cheetah? I've only ever used it in the most basic way, by uploading rides and looking at metrics like xPower.

Cheers guys,

Calum


--
_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en
---
You received this message because you are subscribed to the Google Groups "golden-cheetah-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/golden-cheetah-users/b641cd24-ce70-47e6-b9d5-be71cc2c9056%40googlegroups.com.

RB

unread,
Jul 16, 2019, 12:56:48 PM7/16/19
to golden-cheetah-users
Hi Calum,

Via the menu you can download charts.
So when in the Trends view go to menu "View->Download Chart" (reminder select Uncurated charts) find the chart and download :)

Other method is download the .gchart (attachment in previous post)
and drag and drop it on the part where all tabs are located (tabs like Summary, Tracker, CP, ...)

Hope this helps

On Monday, 15 July 2019 10:43:12 UTC+2, CR wrote:

RB

unread,
Jul 16, 2019, 1:07:01 PM7/16/19
to golden-cheetah-users

Marco1967

unread,
Jul 16, 2019, 2:56:50 PM7/16/19
to golden-cheetah-users

HI, I CONGRATULATE FOR THE EXCELLENT METRICS !!! I ask you if it was possible to have the answers with R? I thank you again for your work.


Il giorno lunedì 15 luglio 2019 17:16:18 UTC+2, RB ha scritto:
Hi,

I created a chart that shows avg power at certain hr over rides (seasons)

Uploaded it in trend charts.
Try en test (warning it get slow with a lot of activities)

Kind regards,
RB


Op ma 15 jul. 2019 10:43 schreef CR <calum...@gmail.com>:
Hi,

I asked a similar question a while back but didn't seem to get any replies, so trying again in case it slipped through the net.

Is it possible to get GC to show you your power at a given heart rate for a specific ride?
Is it possible to show how the power at this heart rate has changed over a specific time period (multiple rides)?

I know there is the Hr:Pw tab, but that just seems to give you power at 150bpm, while the rest of the plotted data are just single data points of Hr:Pw rather than an average at a given heart rate.

If anyone is interested, I'm trying to see how my power at aerobic (not anaerobic) threshold has changed over time, which means in my case I'd like to know power around 141bpm.

Hope you can help.

Calum

--
_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en
---
You received this message because you are subscribed to the Google Groups "golden-cheetah-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-users+unsub...@googlegroups.com.

Calum Riach

unread,
Jul 17, 2019, 3:27:21 PM7/17/19
to Marco1967, golden-cheetah-users
Hi Remco,

thanks so much, I'm just going through the links now as this is all new to me.

Calum

To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-u...@googlegroups.com.

--
_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en
---
You received this message because you are subscribed to the Google Groups "golden-cheetah-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/golden-cheetah-users/2d8a7785-1216-463c-a448-df2b4eed508c%40googlegroups.com.

Steve Mansfield

unread,
Jul 28, 2019, 7:14:20 AM7/28/19
to golden-cheetah-users
What's the use case for wanting to know this?

For steady state  riding eg time trial it would be useful, however for eg a crit which can be surge-y, maybe less so.

Also, its well known that there is a delay in HR rising/falling due to power requirements.

To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-users+unsub...@googlegroups.com.

--
_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en
---
You received this message because you are subscribed to the Google Groups "golden-cheetah-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-users+unsub...@googlegroups.com.

RB

unread,
Jul 28, 2019, 8:08:16 AM7/28/19
to golden-cheetah-users
Hi Steve,

First of all i wanted to know if it is possible to create such a chart :).
Secondly for me it is tracking fitness over seasons (years) if my power raises at certain heart rate most likely your fitness also increased

Also, its well known that there is a delay in HR rising/falling due to power requirements.
I'm not a scientist, but in this case it doesn't needs to be an exact value I evaluate the trend.


Kind Regards,
RB

Steve Mansfield

unread,
Aug 11, 2019, 12:48:43 AM8/11/19
to golden-cheetah-users
This thread prompted me to update some charts that I had previously created to see if there was a trackable trend.

I converted every Garmin .fit to .csv. Then I joined them all, and got about 1.2Gb of data, and about 10M data samples, with HR and power data (among others) for each. I did some filtering to remove nulls and other non-relevant data, which left me about 8M rows.

Anyways when I query for HR vs Power and aggregate on power, for each calendar year I get the chart below.

At a glance you might think that I am fittest in 2019 and least fit in 2016, however, not so. I was fittest in 2017 before some injuries.

My actual order of fitness In descending order:

2017 most fit
2019
2018
2016
2015 least fit

If its of interest, currently VO2Max is 430W and FTP is 350

HR and Power (1).png

Steve Mansfield

unread,
Aug 14, 2019, 5:29:38 AM8/14/19
to golden-cheetah-users
Some more data for y'all

First up, power vs hr is quite different for different bikes. You might think I am fittest on GreenMachine, but really that's because that's the commuter, so lots of stop/start traffic which means lower HR overall 

Boxer, GreenMachine, Joker, Moose, MrRed….png

Second, power vs HR for the same bike with different crank lengths.

Power vs HR for 2 cranks same bike 172.5 and 175.png


So I think that HR vs Power doesn't tell you much

Calum Riach

unread,
Aug 14, 2019, 5:32:44 AM8/14/19
to Steve Mansfield, golden-cheetah-users
Interesting. Could I ask how you measured power on the bike where you used different crank lengths?

--
_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en
---
You received this message because you are subscribed to the Google Groups "golden-cheetah-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/golden-cheetah-users/c791752e-a94c-4d4f-8f0f-51790fd436b5%40googlegroups.com.

Steve Mansfield

unread,
Aug 14, 2019, 10:37:59 PM8/14/19
to golden-cheetah-users
PowerTap hub - so basically exact same bike just moved to shorter crank. Which I did to improve my position on the bike

To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-users+unsub...@googlegroups.com.

Calum Riach

unread,
Aug 15, 2019, 7:27:50 AM8/15/19
to Steve Mansfield, golden-cheetah-users
Ah ok, that's really interesting that there's such a difference.

Also, you're doing 400W at 130bpm which is pretty crazy :)

To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-u...@googlegroups.com.

--
_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en
---
You received this message because you are subscribed to the Google Groups "golden-cheetah-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/golden-cheetah-users/b62175c5-8da7-44b2-bc06-7b9646e42b84%40googlegroups.com.

Steve Mansfield

unread,
Aug 16, 2019, 2:23:46 AM8/16/19
to golden-cheetah-users
Yeah me and Froome, hardly tell us apart <joke>! My resting is not that low, in the high 30s, and my max is about 173. If only I had his FTP!

"Froome’s 2007 test shows a resting heart rate of 32, which is spectacularly low. His maximum heart rate in the test is also low, 161 beats per minute, particularly compared with the maximum figure of 174 beats recorded on the La Pierre-Saint-Martin climb"


To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-users+unsub...@googlegroups.com.

--
_______________________________________________
Golden-Cheetah-Users mailing list
golden-che...@googlegroups.com
http://groups.google.com/group/golden-cheetah-users?hl=en
---
You received this message because you are subscribed to the Google Groups "golden-cheetah-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to golden-cheetah-users+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages