I created a spreadsheet to help sort the videos.
Posted: Wed Jan 04, 2017 9:57 am
Hi, All:
I'm a new user and just purchased all the videos on a hard drive. Choosing the best video for my workouts amongst all these videos is difficult using the application or the web site. For example, if I want to do a ride that is x miles with x amount of climbing requires scrolling through a long list to try to find an appropriate ride.
In an effort to help me sort the videos, I created a spreadsheet from the the data on the VeloReality web site. In the spreadsheet I can sort the videos alphabetically, by distance, elevation, difficulty, etc. Very useful for me to help choose a video for my desired workout.
I thought this may also be helpful for other users so I've had the spreadsheet files uploaded here where you can download them:
http://veloreality.exsotron.com/forum/p ... videos.zip
The spreadsheet was created on my iPad using Numbers (Mac OS/iOS app). I've included that file as well as exported csv and xlsx versions. The Numbers version includes images for the elevation profile and screen-cap. The images did not transfer to the other versions, though. Also, the Numbers version allows me to easily select a column, such as "distance" and sort all of the videos from the header. Not sure if this ability will also transfer to the other files automatically. If not, you may have to adjust a few things after opening, but at least this will get you 99% there.
Note also, that the KM entries for distance and climbing are manual entries and the Miles entries for distance and climbing are calculated using a formula. As an American, kilometers don't mean much to me so I added this conversion for my convenience.
Additionally, I've included a PDF version. If you want to add the images in the "Photo" and "Elevation Profile" fields you can grab them from the PDF.
Hopefully all the data is correct, but I imagine I may have made a mistake or two. I've proofread casually, but not intensely. If anyone notices an error, please notify me.
Thanks, and hope this helps some.
I'm a new user and just purchased all the videos on a hard drive. Choosing the best video for my workouts amongst all these videos is difficult using the application or the web site. For example, if I want to do a ride that is x miles with x amount of climbing requires scrolling through a long list to try to find an appropriate ride.
In an effort to help me sort the videos, I created a spreadsheet from the the data on the VeloReality web site. In the spreadsheet I can sort the videos alphabetically, by distance, elevation, difficulty, etc. Very useful for me to help choose a video for my desired workout.
I thought this may also be helpful for other users so I've had the spreadsheet files uploaded here where you can download them:
http://veloreality.exsotron.com/forum/p ... videos.zip
The spreadsheet was created on my iPad using Numbers (Mac OS/iOS app). I've included that file as well as exported csv and xlsx versions. The Numbers version includes images for the elevation profile and screen-cap. The images did not transfer to the other versions, though. Also, the Numbers version allows me to easily select a column, such as "distance" and sort all of the videos from the header. Not sure if this ability will also transfer to the other files automatically. If not, you may have to adjust a few things after opening, but at least this will get you 99% there.
Note also, that the KM entries for distance and climbing are manual entries and the Miles entries for distance and climbing are calculated using a formula. As an American, kilometers don't mean much to me so I added this conversion for my convenience.
Additionally, I've included a PDF version. If you want to add the images in the "Photo" and "Elevation Profile" fields you can grab them from the PDF.
Hopefully all the data is correct, but I imagine I may have made a mistake or two. I've proofread casually, but not intensely. If anyone notices an error, please notify me.
Thanks, and hope this helps some.
