Sunday 14 April 2013

Strava Excel Analysis - V1.1

UPDATE Dec 2016 - there's a new version with a different approach here: http://midlandscyclist.blogspot.co.uk/2016/12/strava-data-analysis-pc-based-visual-c.html

Update4 Jan 2014: Please see here: Strava API 1 withdrawn

I have made a small update to the Excel sheet for ride analysis.

There is a now an additional chart to plot average speed vs. date for segments:


Example of my average speed over a segment over the past 28 months

Sheet: "Efforts" - filtered by "Effort Name"
The new sheet is here: https://docs.google.com/file/d/0B3SjSCZb92myUXpLdWw5a0F6dlU/edit?usp=sharing

Google have changed Drive again. Sowhen you click on the link you will see:



Click on the Download button in the bottom right and save the .xls file.


I am still working on some of the other changes.

2 comments:

  1. also this 1.1 its not working for me :(

    ReplyDelete
  2. Not sure if this is a double reply, but..
    There is no solution to this as Strava have closed/withdrawn support for the V1 APIs that my application used. I did document this here: http://midlandscyclist.blogspot.co.uk/2013/07/strava-excel-analysis.html
    There is nothing I can do about this
    veloviewer.com seems to offer this functionality (its an excellent site) although the export to cvs has never worked for me either in Firefox or IE

    ReplyDelete