CSV file data error
Posted: Mon Feb 13, 2023 4:39 pm
Hello,
I have recently uploaded 4 rides in Lanzarote. I think they are excellent. However on 3 of the rides the length of data on the CSV file is shorter than the length of the video. For example ride 81797317 has data for 4522 seconds but the ride is 1hr30m30s or 5430 seconds. I have amended the CSV file by putting a formula in column J of =round(I1*(5430/4522),0). I copied this formula all the way down and then pasted the whole column into column I as values. Then I deleted the formulas out and resaved the CSV file. Today I rerode the ride and it's perfect. Now all the climbs are in the right place and the ride ends when the video does.
I have done the same thing with rides 81036975 and 81836201.
Could I either send you the revised CSV files for you to put on the server or can you amend them in the same way?
They are much more enjoyable when everything is in sync.
Thanks Graeme
I have recently uploaded 4 rides in Lanzarote. I think they are excellent. However on 3 of the rides the length of data on the CSV file is shorter than the length of the video. For example ride 81797317 has data for 4522 seconds but the ride is 1hr30m30s or 5430 seconds. I have amended the CSV file by putting a formula in column J of =round(I1*(5430/4522),0). I copied this formula all the way down and then pasted the whole column into column I as values. Then I deleted the formulas out and resaved the CSV file. Today I rerode the ride and it's perfect. Now all the climbs are in the right place and the ride ends when the video does.
I have done the same thing with rides 81036975 and 81836201.
Could I either send you the revised CSV files for you to put on the server or can you amend them in the same way?
They are much more enjoyable when everything is in sync.
Thanks Graeme