Editing power meter data

DaveyL

Got myself a Quarq and a Garmin 500 a couple of weeks ago. It worked fine the first couple of rides, but I did a race at the weekend and it went a bit haywire in the middle - the power reading died for about an hour, save for a few spikes of several thousand Watts. As a result, from a 4.5 hour ride, I've ended up with a TSS of 800 and a NP of 450 W! Should be more like 250 ish TSS and about 240 W NP.

Is there any way I get into the raw data and edit out the bit in the middle, to come up with something a bit more sensible that won't skew the data in WKO+ PMC so much?

amaferanga

Open the .tcx file in notepad or similar and edit it. Golden Cheetah has a ride editor that makes it even easier - isn't there one in WKO+?

DaveyL

Oh jeez, yeah. So there is. Thanks for the tip!

In WKO+ it's dead easy: http://support.trainingpeaks.com/traini ... raw%20data

bahzob

An alternative in WKO if you want to do more complex editing of the data is to export the session as Powertap (.csv) which you can then open as a spreadsheet and apply any formulas etc that you want.

Depending on the spreadsheet tool you just need to be sure you also save in same .csv format so WKO will process it.

DaveyL

Thanks very much for that tip! It's going to be much faster to edit the file in Excel - WKO+ is one cell at a time and very laborious.

I did try converting the Garmin .fit file to a .csv using a tool in the Garmin software development kit, but had problems getting anything to recognise the resulting .csv file, and problems converting the .csv file back to a .fit file. So this could be the easiest way to do it.

liversedge

The editor in GC has a copy/paste function for working with excel and the like. it also has redo/undo and a search for finding anomalies etc. the tools menu has functions for fixing gps and power spikes etc.

its the bit of GC I am proudest of

bigpikle

wheres the editor in GC for mac? I always struggle with this and have a bad file I'm trying to sort...

doyler78

I don't see what is to be gained from editing the file. You are just going to be guessing. I'd split the file so that you have all the good data in there and then override the TSS on the bad data. The good data from the ride will likely give you a fairly good place from which to estimate the TSS you want to override.

amaferanga

doyler78 wrote:

I don't see what is to be gained from editing the file. You are just going to be guessing. I'd split the file so that you have all the good data in there and then override the TSS on the bad data. The good data from the ride will likely give you a fairly good place from which to estimate the TSS you want to override.

If you don't edit out the silly high numbers (or delete the file altogether) it messes with the performance manager chart.

doyler78

amaferanga wrote:

doyler78 wrote:

I don't see what is to be gained from editing the file. You are just going to be guessing. I'd split the file so that you have all the good data in there and then override the TSS on the bad data. The good data from the ride will likely give you a fairly good place from which to estimate the TSS you want to override.

If you don't edit out the silly high numbers (or delete the file altogether) it messes with the performance manager chart.

That's wrong surely. The PMC is composed of CTL, ATL & TSB. CTL & ATL use TSS and not any power data directly (save that which went into the calculation of TSS however what I suggested overrode the erroneous TSS Score). TSB is just one minus the other.

Now having said that it does have me wondering what about all the charts such as 5s power, 5 min power etc. Are those affected by the dud figures or does the fact that you have overridden the TSS on that ride mean that it ignores in those calculations? Don't know but would like to know.

amaferanga

Yeah sorry, I mean the CP chart.

doyler78

amaferanga wrote:

Yeah sorry, I mean the CP chart.

WKO+ doesn't have a CP chart however I'm still not sure on whether the high skewed data would affect anything other than the PMC if he just overrides TSS so I guess the safest option would be to delete the bad data and enter a manual ride and override the TSS on that. No potential for crud then apart from the TSS figure and in the grand scheme of all the other rides that go into his PMC it's unlikely to make any appreciable difference.

Just realised as soon as I posted that you are probably referring to the Mean Maximal Power Curve so deleting would be safest IMHO.

Alex_Simmons/RST

doyler78 wrote:

amaferanga wrote:

Yeah sorry, I mean the CP chart.

WKO+ doesn't have a CP chart however I'm still not sure on whether the high skewed data would affect anything other than the PMC if he just overrides TSS so I guess the safest option would be to delete the bad data and enter a manual ride and override the TSS on that. No potential for crud then apart from the TSS figure and in the grand scheme of all the other rides that go into his PMC it's unlikely to make any appreciable difference.

Just realised as soon as I posted that you are probably referring to the Mean Maximal Power Curve so deleting would be safest IMHO.

As you have realised, it screws with MMP charts - but don't forget that you can put MMP data on a Performance Manager Chart as well.

bahzob

As a general rule I tag any files I have edited for whatever reason as another sport, e.g. mountain bike.

It gives a quick reminder of which sessions may have suspect/atypical data and also provides you some more options on including/excluding from charts via the Sport tab

DaveyL

Just a quick note to say that TrainingPeaks are introducing the ability to edit files online:

http://blog.trainingpeaks.com/posts/201 ... e-web.html