How do I tell if my torque wasn't zero'd from my PT data download?

shawndoggy

I had an anomalously high power reading on Saturday's time trial. How do I tell whether my torque was out of wack?

Woofer

Did you coast before or afterwards? One would see a non zero torque reading during those times if there was the specific issue you think you had. I assume you meant overall just too high and not just a one time spike.

shawndoggy

like I'd be seeing a torque reading at zero watts or zero torque with a watts reading? There do seem to be a couple of instances where torque is "--" but there is a watts reading (like 8 or 22 watts... barely anything).

rmur17

non-zero torque and watts while COASTING (i.e. not pedalling) is the key point. Very easy to detect on a PT....

__________________
rmur

shawndoggy

Well, I'm apparently still too brain dead to be able to tell... can you guys make sense of this file?

Attached Files

Madera TT.zip (17.5 KB, 21 views)

peterpen

To my uneducated eye, it looks easiest to spot in interval #5 - there are periods with 0 rpm cadence but watts and torque readings. You can also see this at each of the turns.

Not sure when your TT was, but for mine at 10:30am, it looked like it was a rare case of going hardest from the gun producing the best times. We had a strong headwind on the first section which turned into a cross-head after the first turn. Tailwind was very welcome after turn #2.

shawndoggy

Argh. As suspected. Is there a way to glean "corrected" data?

Ours was exactly opposite... wind out of the NW, so tailwind out, xwind on second leg, headwind on third, and dead on into the wind on the last leg.

rmur17

yes if the offset was constant or reasonably so. i don't have access to wko here but if you dumped a .csv I could take a look for me. I've corrected a couple of my own files over the years.

This assumes your speed sensor was working correctly. With rear wheel speed, reported torque and a constant torque offset, one can easily correct torque and power on a per-record basis in .csv format. If your offset torque is all over the place, all bets are off.

__________________
rmur

shawndoggy

Cool! I'll resave as csv and post-up when I get home tonight.

rmur17

http://www.midweekclub.ca/powerFAQ.htm#Q46

here's a link if you want to do it yourself. Not that much to it really. then re-import the new .csv and get rid of the old 'inflated' file.

__________________
rmur

shawndoggy

Wow, I read that and I understand the concept, but I have no idea how to make that happen in excel. The csv file is attached. It looks like it is reading "high" by 1.6 nm. If someone could fix, I'd be eternally grateful!

Attached Files

Copy of pearson_shawn_4_28_2007a.zip (29.6 KB, 4 views)

jbvcoaching

I wrote these out (more detailed instructions) on the wattage list (formerly on Topica, now on google) in 2004:

1) Open the PT file in Excel.

2) Sort it by torque (ascending) so you find the lowest torque value (or, as

chris says, just look for periods of coasting and observe the torque there).

3) Click Edit -> Undo to put the file back in it's original order (or

re-sort by time).

4) Create a column that is a formula, you want to subtract the lowest

observed torque value from the torque column. Column should be as long as

the file itself.

5) Calculate power using the new torque using the instructions Rick Sladkey

gives in the FAQ. That is, power = 1746*recalculated torque*(speed/2093).

Adjust the 2093 number (which is wheel circumference) if using other than a

700x23 wheel/tire.

6) Copy the new power cells and paste -> special (values) over the original

power column. Do the same with the new torque values.

7) Delete the now extraneous recalculated columns, save the file as a .csv

again, and now import into CPSoft.

8) Lobby Hunter & company to add the torque-zero-fix to CPSoft (along with

an SRM slope fix). :-)

shawndoggy

THIS is the part I don't know how to do... I'm an excel doofus.

bliksimpie

In the midweek reference http://www.midweekclub.ca/powerFAQ.htm#Q46 they refer to an excell spreadsheet. Does anyone have the following spreadsheet

Chris Mayhew has posted a spreadsheet at http://users.icubed.com/~mayhew/mayhew.xls to perform these calculations.