Interpretation of the rowpro cvs file

Thomas · Post by **Thomas** » May 31st, 2007, 2:28 am

I am looking to see if anyone knows how to interpret the cvs file from rowpro. It is kind of like the e-row file but, unlike e-row, it is not easy to read the pace from the data. Apparently, the data created is the same method that is use to display the file in the rowing log, so, I am trying to intpret what is presented in real data with what is created in the data file. To give you an idea, I think it is the third column of this comma delineated file. You can tell in that column where I stopped and got back on it. I tried some different things like using the log, ln, e to the x, and 10 to the x power but none of them seem to be the answer. It may also have something to do with the fourth column. This is the last 500 meters of a 10k I did on May 30, 2007.

2264750,9501.838,0.2210809,259.1222,636.4405,26,175,0.4,\par
2267038,9512.197,0.2208307,260.0037,637.191,26,175,0.4,\par
2269330,9522.48,0.223042,252.347,637.9293,26,175,0.4,\par
2271540,9532.302,0.2254414,244.375,638.6281,28,175,0.4,\par
2273729,9541.96,0.2268739,239.7751,639.3104,28,175,0.4,\par
2275937,9551.772,0.22513,245.3907,640.0083,27,175,0.4,\par
2278336,9562.49,0.223895,249.4738,640.775,25,175,0.4,\par
2280632,9572.677,0.2247504,246.6362,641.4983,25,174,0.4,\par
2283041,9583.319,0.2261898,241.9574,642.251,25,172,0.4,\par
2285423,9593.963,0.2239398,249.3241,643.0125,25,173,0.4,\par
2287838,9604.682,0.225131,245.3873,643.7741,25,173,0.4,\par
2290219,9615.249,0.2254464,244.3587,644.525,25,173,0.4,\par
2292537,9625.441,0.2279583,236.3697,645.2426,26,174,0.4,\par
2294724,9635.109,0.2260716,242.3372,645.9269,27,174,0.4,\par
2296924,9644.76,0.227286,238.4734,646.6047,27,174,0.4,\par
2299024,9653.973,0.2280795,235.9932,647.2517,29,175,0.4,\par
2306365,9675.256,0.4332653,34.42677,647.9684,166,174,0.4,\par
2308364,9680.707,0.3727758,54.05238,648.1156,31,173,0.4,\par
2310271,9688.05,0.2624978,154.8035,648.5585,31,172,0.4,\par
2312280,9696.961,0.2253006,244.8337,649.1911,29,172,0.4,\par
2314373,9706.73,0.2148138,282.4694,649.9189,29,171,0.4,\par
2316174,9715.348,0.2085849,308.5384,650.5751,33,171,0.4,\par
2318069,9724.627,0.2048153,325.8897,651.2953,33,171,0.4,\par
2319884,9733.366,0.2067803,316.6873,651.9643,32,172,0.4,\par
2321881,9742.951,0.2089225,307.0454,652.6961,31,172,0.4,\par
2323773,9751.928,0.2105048,300.1733,653.3746,31,173,0.4,\par
2325867,9761.532,0.2174674,272.2546,654.0788,28,173,0.4,\par
2327875,9770.755,0.2182265,269.4234,654.7561,31,173,0.4,\par
2329870,9779.983,0.2164524,276.1027,655.4382,30,174,0.4,\par
2331879,9789.354,0.2144736,283.8156,656.1361,30,174,0.4,\par
2333870,9798.578,0.2154513,279.9696,656.8186,29,174,0.4,\par
2335881,9807.945,0.2142886,284.5515,657.5156,29,174,0.4,\par
2338062,9818.145,0.2144666,283.8437,658.277,28,174,0.4,\par
2339981,9827.131,0.2129644,289.8923,658.9485,30,175,0.4,\par
2342066,9837.026,0.2112938,296.8232,659.6972,30,175,0.4,\par
2344068,9846.548,0.2102611,301.218,660.4188,30,175,0.4,\par
2346070,9856.065,0.2101673,301.6218,661.1396,30,176,0.4,\par
2348063,9865.497,0.2113979,296.385,661.8513,30,176,0.4,\par
2350065,9875.023,0.2100389,302.1751,662.5739,30,176,0.4,\par
2351979,9884.104,0.2103048,301.0303,663.2606,31,176,0.4,\par
2353974,9893.559,0.2111167,297.5706,663.9752,30,176,0.4,\par
2355889,9902.712,0.2090759,306.3698,664.672,31,176,0.4,\par
2357972,9912.705,0.2091261,306.1491,665.4353,30,177,0.4,\par
2359966,9922.229,0.2089926,306.7363,666.16,30,177,0.4,\par
2361891,9931.376,0.2100953,301.9319,666.853,31,176,0.4,\par
2363869,9940.74,0.2114687,296.0873,667.5599,31,176,0.4,\par
2365875,9950.169,0.212602,291.3775,668.2675,30,177,0.4,\par
2367873,9959.603,0.2119062,294.257,668.9784,30,177,0.4,\par
2369874,9969.035,0.2125751,291.4882,669.688,31,177,0.4,\par
2371768,9977.871,0.2136839,286.974,670.3466,31,177,0.4,\par
2373770,9987.242,0.214169,285.0283,671.0472,31,177,0.4,\par
2375774,9996.616,0.213962,285.8566,671.748,30,177,0.4,\par
2376491,10000,0.213962,285.8566,672.0029,30,177,0.4,\par

Thomas · Post by **Thomas** » May 31st, 2007, 2:37 am

Type,Time,Distance,AvgPace,AvgWatts,Cals,SPM,EndHR,Rowfile_Id,AvgHR\par
1,574500,2000,0.28725,118.1348,112.7572,21,150,,120\par
1,1027500,4000,0.2265,240.9647,142.1041,27,156,,155\par
1,1478200,6000,0.22535,244.6726,142.9802,26,164,,161\par
1,1926800,8000,0.2243,248.1248,143.7945,27,170,,168\par
1,2376500,10000,0.22485,246.3085,143.3663,27,177,,173\par

This is the summation data, and I see now the title bar shows the third column is average pace and the fourth column is average watts.

This helps a little but still not clear other than average watts what is the actual 500-meter pace

haboustak · Post by **haboustak** » May 31st, 2007, 9:27 am

Looks like the time column is thousandths of a second and the AvgPace column is just plain AvgPace in seconds per meter. 500m pace would be (AvgPace column * 500).

Mike

Thomas · Post by **Thomas** » June 1st, 2007, 10:32 pm

That's it!. AvgPace is the amount of time to cover one meter. I took a known time and bound it to be correct. So, looking at the data, I averaged one meter every .2243 second from 6001 to 8000 meters, which is a 1:52.15, 500-meter pace.

Thanks.