Power file correction

[albanygene]

I did a somewhat bizarre two-part 'cross race today: an uphill TT that was mostly on pavement (and for which I mounted 700x23s on my 'cross bike), followed by an off-road TT (for which I mounted my usual Michelin Jets, which measure out to ~700x35).

I reset my the wheel diameter in my PT head unit for the morning race, but didn't set it back for the afternoon race (which makes up the bulk of the file). Is it possible to correct the raw data from a specific point forward?

 

[jbvcoaching]

Sure, just export the file as a .csv, open it in Excel, and multiply every speed cell for the afternoon race by x/2096, where x is the circumference of the 35c tire (I'm too lazy to look it up).


That corrects speed for you, you can probably figure out a way to do the same for distance if that's important to you.

Then simply re-import the file and replace the existing one.

 

[albanygene]

Thanks. Just to confirm: the only values affected are speed and distance, not output, correct?

 

[jbvcoaching]

Thanks. Just to confirm: the only values affected are speed and distance, not output, correct?

Right, speed and distance. Power is unaffected.