Power file correction

Discussion in 'Power Training' started by albanygene, Sep 29, 2007.

  1. albanygene

    albanygene New Member

    Joined:
    Mar 18, 2006
    Messages:
    4
    Likes Received:
    0
    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?
     
    Tags:


  2. jbvcoaching

    jbvcoaching New Member

    Joined:
    Dec 28, 2005
    Messages:
    206
    Likes Received:
    0
    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.
     
  3. albanygene

    albanygene New Member

    Joined:
    Mar 18, 2006
    Messages:
    4
    Likes Received:
    0
    Thanks. Just to confirm: the only values affected are speed and distance, not output, correct?
     
  4. jbvcoaching

    jbvcoaching New Member

    Joined:
    Dec 28, 2005
    Messages:
    206
    Likes Received:
    0
    Right, speed and distance. Power is unaffected.
     
Loading...
Loading...