Page 1 of 1
Data Analysis of Performance Measured by Erg
Posted: June 18th, 2020, 2:10 pm
by MiddleAgeCRISIS
Hi,
I have just started rowing and I am rowing to a set HR for 10km.
I am following a principle outlined by Phil Maffetone.
I wonder what software people are using to analyse their performance - are there any templates for tableau to show performance over time ?
I think my heart rate is improving for a given output however my results are a little bit scattered and id like to analyse the trend.
Re: Data Analysis of Performance Measured by Erg
Posted: June 18th, 2020, 10:54 pm
by Egastelump
IMO Concept'2's online logbook does 80% of what anyone would need when it comes to detailed progress tracking. You can even download it as a .csv file to visualize the data your own way. Other software that you might be able to use depends on your PM model and whether you're an Apple user. Here is a list that will probably get you something close to what you had in mind.
https://www.concept2.com/service/softwa ... #all-rower
Re: Data Analysis of Performance Measured by Erg
Posted: June 19th, 2020, 2:38 am
by MartinSH4321
MiddleAgeCRISIS wrote: ↑June 18th, 2020, 2:10 pm
Hi,
I have just started rowing and I am rowing to a set HR for 10km.
I am following a principle outlined by Phil Maffetone.
I wonder what software people are using to analyse their performance - are there any templates for tableau to show performance over time ?
I think my heart rate is improving for a given output however my results are a little bit scattered and id like to analyse the trend.
I use an Excel list where I put in a lot of data I have, about 20 columns, about half of them automatically calculated by the data I put in. For me this helps a lot to see progress. You can send me a PM with your email and I'll send you the file, maybe you can use it, at least as a base to build your own
Re: Data Analysis of Performance Measured by Erg
Posted: June 19th, 2020, 9:22 am
by MiddleAgeCRISIS
thank you . I will ping you a mail
Re: Data Analysis of Performance Measured by Erg
Posted: January 2nd, 2022, 1:05 am
by boerekos
MartinSH4321 wrote: ↑June 19th, 2020, 2:38 am
MiddleAgeCRISIS wrote: ↑June 18th, 2020, 2:10 pm
Hi,
I have just started rowing and I am rowing to a set HR for 10km.
I am following a principle outlined by Phil Maffetone.
I wonder what software people are using to analyse their performance - are there any templates for tableau to show performance over time ?
I think my heart rate is improving for a given output however my results are a little bit scattered and id like to analyse the trend.
I use an Excel list where I put in a lot of data I have, about 20 columns, about half of them automatically calculated by the data I put in. For me this helps a lot to see progress. You can send me a PM with your email and I'll send you the file, maybe you can use it, at least as a base to build your own
Martin, is it possible that you can send me a copy of the spreadsheet you have? offshoreafrica at gmail. Thank you!
Re: Data Analysis of Performance Measured by Erg
Posted: January 2nd, 2022, 11:50 am
by Tsnor
MartinSH4321 wrote: ↑June 19th, 2020, 2:38 am
I use an Excel list where I put in a lot of data I have, about 20 columns, about half of them automatically calculated by the data I put in. For me this helps a lot to see progress.
grin, got me interested. Can you post the
column headers here? Very interested in what you decided to track (example, i don't track RPE, probably should. I do have "legs felt dead" notes sometimes).
Re: Data Analysis of Performance Measured by Erg
Posted: January 2nd, 2022, 12:23 pm
by Dangerscouse
MartinSH4321 wrote: ↑June 19th, 2020, 2:38 am
I use an Excel list where I put in a lot of data I have, about 20 columns, about half of them automatically calculated by the data I put in. For me this helps a lot to see progress. You can send me a PM with your email and I'll send you the file, maybe you can use it, at least as a base to build your own
I must make it my only New Year's resolution to actually use your wonderful spreadsheet.
Re: Data Analysis of Performance Measured by Erg
Posted: January 2nd, 2022, 2:41 pm
by MartinSH4321
Tsnor wrote: ↑January 2nd, 2022, 11:50 am
MartinSH4321 wrote: ↑June 19th, 2020, 2:38 am
I use an Excel list where I put in a lot of data I have, about 20 columns, about half of them automatically calculated by the data I put in. For me this helps a lot to see progress.
grin, got me interested. Can you post the
column headers here? Very interested in what you decided to track (example, i don't track RPE, probably should. I do have "legs felt dead" notes sometimes).
Date
Sport
Description
Zone
Distance
Duration
W avg
HR
W/HR / int watts
Pace
Strokes
SPM
SPI
DF
Temp
Hum
Year
Mon
Day
Season
KW
RPE/RIR
Notes /Strength sets
Daily kcal (Polar)
Efficiency factor Training
Training kcal (formula or Polar)
Emphasis
There's also a Season overview with total time, k zone % etc and a PB/SB sheat
I can send it to you if you're interested
Re: Data Analysis of Performance Measured by Erg
Posted: January 2nd, 2022, 2:42 pm
by MartinSH4321
Dangerscouse wrote: ↑January 2nd, 2022, 12:23 pm
MartinSH4321 wrote: ↑June 19th, 2020, 2:38 am
I use an Excel list where I put in a lot of data I have, about 20 columns, about half of them automatically calculated by the data I put in. For me this helps a lot to see progress. You can send me a PM with your email and I'll send you the file, maybe you can use it, at least as a base to build your own
I must make it my only New Year's resolution to actually use your wonderful spreadsheet.
Looking at your improved fitness level I doubt you really need it
Re: Data Analysis of Performance Measured by Erg
Posted: January 3rd, 2022, 5:10 am
by Dangerscouse
MartinSH4321 wrote: ↑January 2nd, 2022, 2:42 pm
Looking at your improved fitness level I doubt you really need it
Thanks mate, but who knows what I'm missing by really interrogating the data
Re: Data Analysis of Performance Measured by Erg
Posted: January 4th, 2022, 4:49 am
by jamesg
I have just started rowing and I am rowing to a set HR for 10km.
I wonder what software people are using to analyse their performance
I use a single line in excel showing time, distance, rating and power, which is WHAT I did.
To see HOW I did it, I use Watts/Rating, the Work done in each stroke. This ratio is in Watt-minutes; most I believe, work in the range 6 to 12, as to style, age and size. I'm 6 to 7. Work is length x handle force so to some extent this is a Quality index.
This index clearly encourages the use of length and strength, which is what rowing is all about. Another Q index might be meters per stroke, seeing that boats are supposed to go somewhere. 10m was once considered a baseline.
Adding max HR and Average lets me see ratios such as Watts/Range in use; but a lot of data is needed to make sense of it, and it won't tell you how to row.
Re: Data Analysis of Performance Measured by Erg
Posted: January 16th, 2022, 5:50 pm
by tomsmith0611
Hi Martin
I would love to get a copy of your spreadsheet.
tomsmith0611@hotmail.com
Regards
Tom
Re: Data Analysis of Performance Measured by Erg
Posted: January 17th, 2022, 5:32 pm
by btlifter
Dangerscouse wrote: ↑January 3rd, 2022, 5:10 am
MartinSH4321 wrote: ↑January 2nd, 2022, 2:42 pm
Looking at your improved fitness level I doubt you really need it
Thanks mate, but who knows what I'm missing by really interrogating the data
Counterpoint: who knows what you're gaining by NOT interrogating the data!?
Horses for courses and what not. Clearly, some individuals will really benefit from digging into the minutiea, noticing subtle trends, and iterating accordingly. For others tho (eg. me) there is a strong susceptibility to "missing the forest for the trees" when I go deep on data.
I have no position on what anybody else ought to do. I just wouldn't be confident that what you're presently doing isn't already optimal for you!
Re: Data Analysis of Performance Measured by Erg
Posted: January 18th, 2022, 6:18 am
by Dangerscouse
btlifter wrote: ↑January 17th, 2022, 5:32 pm
Counterpoint: who knows what you're gaining by NOT interrogating the data!?
Horses for courses and what not. Clearly, some individuals will really benefit from digging into the minutiea, noticing subtle trends, and iterating accordingly. For others tho (eg. me) there is a strong susceptibility to "missing the forest for the trees" when I go deep on data.
I have no position on what anybody else ought to do. I just wouldn't be confident that what you're presently doing isn't already optimal for you!
You're like my conscience...always enjoy your alternative view