Looking at some more Concept 2 rowing machine workout data – this time from a sprint/interval session (20 seconds @ 90% of max effort, 1 minute rest, repeat 20 times.)
The Concept 2 Performance Monitor only records a line record of data when a stroke is pulled, therefore it does not record anything during the 1 minute rest periods. It also only recorded six of the twenty sprints from the workout in the csv file I was looking at, so that file may have been somehow truncated, or the rest of the workout data was stored in one or more other files.
This data needs to be split up into the individual sprints so that they can be compared.
The stroke rate (number of strokes per minute) is 0 at the start of each sprint, so that information was used to automatically label each stroke record with the number of the sprint to which it related. This is shown in the new column ‘Sprint’.
I also gave each stroke record within each sprint an index – 1 for the first record of a sprint, 2 for the second, etc, and then made a helper column combining the Sprint number with the Index for every stroke (e.g. 6-12 uniquely identifies the 12th stroke of the 6th sprint) to make the lookups easier later.
Finally, I used xlookups (searching on the helper column values to split out columns of data for each of the sprints for the metrics such as heart rate, stroke rate, the time of each stroke, etc.
With the data now in a much more friendly format, I made some charts to compare the six sprints.
The below example shows the heart rate measured during each sprint. Click to view full size.
The next chart shows the measured power output during each of the six sprints, and also automatically labels the peak power output of each sprint. (The peak for each sprint is calculated and added to the chart as a data series of just one data point which is formatted to be the peak power data label.)
And, finally, below is shown the starting and ending heart rate for each of the six 20 second sprints.
