Quadrant analysis question

andrewrech

When I open up my .csv file from my powertap, I can't isolate the power values/cadence values because there are other comma seperated values in the same column, so I can't cut and paste the data into a the QA spreadsheet. Anyone know how to export a file from Cyclingpeaks so that power and cadence data can easily be cut and pasted into Coggan's QA spreadsheet?

RapDaddyo

I'm not sure I understand the problem you are having. I export workout files as PowerTap *.csv files all the time and open them directly in Excel for manipulation. I have had no problems with data (including cadence) being in the wrong column.

andrewrech

Here is an excerpt of what the "power" column looks like in the .csv (I think the problem is that I am exporting from Cyclingpeaks and not just getting the file from the Link software?)

1, 133, 06, 111, 02, 215, 03, 220, 05, 258, 05, 258, 05, 258, 0


that is c/p'd right out of that column - IOW it's all in the same column. see how there is extraneous data in there? Maybe cyclingpeaks adds that? There is not just *one* number there, so I can't cut and paste it into the QA spreeadsheet.

I hope this makes things more clear

__________________
A. Rech

Flatscan

My immediate guess is that you're not exporting in PT .csv format, but in another format, e.g. Polar or SRM. I just checked over an old exported .csv, and it looks exactly like the PT Link file from the same ride, except CP seems to have lost the interval IDs (all 0).

RapDaddyo

I still can't understand how you're getting that data. When I export a CP workout file as a PowerTap *.csv file, this is what I get (first few rows of the file). I didn't do anything to this file. I just opened it with Notepad and copied the first few rows. I can open this file in Excel and manipulate the data without any problems at all.

Minutes, Torq (N-m), Km/h, Watts, Km, Cadence, Hrate, ID
0.021, 7.6, 5.1, 32, 0.010, 0, 80, 0
0.042, 0.0, 10.0, 0, 0.013, 0, 78, 0
0.063, 0.0, 9.7, 0, 0.017, 0, 78, 0
0.084, 0.0, 9.2, 0, 0.021, 0, 78, 0
0.105, 0.0, 9.4, 0, 0.023, 0, 78, 0
0.126, 2.3, 9.5, 18, 0.027, 50, 78, 0
0.147, 12.9, 10.2, 109, 0.029, 54, 78, 0
0.168, 8.2, 11.5, 79, 0.036, 84, 78, 0
0.189, 6.9, 12.7, 73, 0.040, 87, 79, 0
0.210, 6.9, 12.7, 73, 0.044, 91, 79, 0
0.231, 3.4, 14.0, 40, 0.048, 98, 80, 0
0.252, 3.4, 14.0, 40, 0.052, 98, 80, 0
0.273, 0.0, 15.7, 0, 0.059, 98, 81, 0
0.294, 0.0, 15.3, 0, 0.063, 43, 79, 0
0.315, 1.6, 15.1, 20, 0.069, 100, 79, 0
0.336, 1.0, 14.9, 13, 0.073, 100, 79, 0
0.357, 4.4, 15.1, 55, 0.080, 102, 79, 0

So, I'm afraid I'm still perplexed as to how you are getting that kind of data. You say that is a column, but the exported csv file is by row.

andrewrech

Well, the wattage numbers I am interested in are listed in a vertical column, just like yours (when I pasted it previously the formating didn't come out right...). It is definitely a .csv file, and there are definitely extraneous data that you don't seem to have. I think the problem stems from my exporting from Cyclingpeaks. I'll try it from the Link software and see what happens...

__________________
A. Rech

RapDaddyo

Well, you are assuming that CP is not exporting the data correctly. There's a quick way to find out. If I go to the workout file graph in CP, I can scroll across the time line and see each of the rows in the csv file above, in the bottom left of the CP window. You should be able to do the same thing. If the numbers are identical to your csv file, then CP has exported the data correctly.

acoggan

Your problem isn't from the way CyclingPeaks exports the data, it's from the way that Excel imports it. Specifically, data from a .csv file will be read into Excel as text, filling just column A. Select that column, drop down the Data (or is it tools? I'm working from memory here) menu, select "Convert text to data...", and follow the commands to reformat the output as actual numbers. Once you do that, you can copy and paste the power and cadence numbers into the QA spreadsheet that you have.

andrewrech

That solves it!! Thanks a lot Andy, and everyone else who gave this problem a shot.

__________________
A. Rech

RapDaddyo

I'm still trying to figure out why I have no such problems. I just open the .csv files directly with Excel and the data are in the correct columns with no spaces or extraneous characters or data whatsoever.

acoggan

I think the explanation is that once you go through these steps the first time, Excel is smart enough to remember that you want the data imported as actual values, not text.

Flatscan

Excel might do this, and it would be very convenient if it does. I think Excel 2000 (the version I use) defaults to importing .csv as comma-separated values out of the box.

What threw me was that andrewrech's posted sample data looks nothing like PT data, as far as I can tell.

Spunout

Are you using the 'Data>Get External Data>import text' function or copy and paste? If pasting from the clipboard, use 'paste special' to maintain your cells.