Quadrant analysis question

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.😕

RapDaddyo said:

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.😕

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?)

[font=Arial]1, 133, 0[/font][font=Arial]6, 111, 0[/font][font=Arial]2, 215, 0[/font][font=Arial]3, 220, 0[/font][font=Arial]5, 258, 0[/font][font=Arial]5, 258, 0[/font][font=Arial]5, 258, 0[/font]

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 🙂

andrewrech said:

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?)

[font=Arial]1, 133, 0[/font][font=Arial]6, 111, 0[/font][font=Arial]2, 215, 0[/font][font=Arial]3, 220, 0[/font][font=Arial]5, 258, 0[/font][font=Arial]5, 258, 0[/font][font=Arial]5, 258, 0[/font]

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 🙂

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).

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.😕

RapDaddyo said:

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.😕

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...🙁

andrewrech said:

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...🙁

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.

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.

acoggan said:

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.

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

andrewrech said:

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

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.😕

RapDaddyo said:

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.😕

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.

acoggan said:

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.

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.

Flatscan said:

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.

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.

Spunout said:

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.

I don't use either method. I just open the .csv file directly with Excel and get numbers, not text, and no extraneous data. I have Excel 2000.