The participation ride 2006 - post-ride analysis and comment

Raising money for ruralnet|uk's Participation Fund

Categories

  • 00: Sponsorship (6)
  • 01: Diary: Pre-Ride (40)
  • 02: Diary: The Ride (40)
  • 03: Diary: Reflection (8)
  • 04: Stages 1-5 (10)
  • 05: Stages 6-10 (11)
  • 06: Stages 11-16 (12)
  • 07: Days 1-2 (6)
  • 08: Days 3-4 (6)
  • 09: Days 5-6 (7)
  • 10: Days 7-10 (14)
  • 11: The Route & Itinerary (9)
  • 12: The Analysis (18)
  • FAQs (4)
  • Puzzles (4)
  • Supporters (9)
  • The bike (6)
  • The gadgets (5)
  • Video clips (4)
See More

Quicklinks

  • Homepage
  • THE GOOD CAUSE
  • Training log
  • ruralnet|uk homepage

Donate Here

  • PLEASE DONATE HERE
    (if you can)

Vertical profile tool finalised

Excellogo_1This is an update to the Excel spreadsheet discussed previously here.

The spreadsheet takes 'Track Log' files created by the Magellan eXplorist 600, derives 'distance covered' data and then generates a vertical profile chart. The spreadsheet contains instructions and a sample set of data. It can be downloaded here. If you download the file and find it useful please consider making a donation to the good cause here. Many thanks.

If you have any questions about the use of the spreadsheet please leave a comment.

June 25, 2006 in Puzzles, The gadgets | Permalink | Comments (0)

Fruits of the puzzle

ProfiletestJoe (of Rob & Joe fame) and I have been bouncing an Excel spreadsheet between us since Joe sent a solution to the challenge to produce a verticle profile chart from the data generated by my GPS. Here is the result! This exercise has led to a recalibration of my bike computer and revealed that I was not cycling as far or as fast as I thought I was :-| See my training log. This spreadsheet will be used to post the profile data to this blog as the actual ride progresses.

If you like a copy of this spreadsheet. Please leave a comment by clicking on the 'Comments' link below.

May 14, 2006 in 01: Diary: Pre-Ride, Puzzles | Permalink | Comments (0)

New PUZZLES section

PuzzleI am facing various challenges during the preparation of this ride so I have started a puzzles section to see if I can get some help. The first puzzle to solve will require a Navigator with Excel skills >more

May 11, 2006 in 01: Diary: Pre-Ride, Puzzles | Permalink | Comments (1)

Wanted: Navigator with Excel Expertise

Navigator

ExcellogoThe challenge is: During the ride I want to be able to publish stage-by-stage data on the ride. I want this to include a chart showing the contours of the ride so people can see how hilly it actually was.

My GPS stores data as you travel along into a 'Track Log' file. Everytime you change direction the GPS writes a line of data to the Track Log file. This data is separated by commas which makes it easy to load into Excel. This is a typical Track Log file imported into Excel. To this file I have added the field names from the information provided by the GPS manufacturer in this document.

Can anyone help me by using the data in each line of the spreadsheet to: 1) calculate the distance between each set of data and then 2) produce a chart showing the contours. Thanks in anticipation.

*STOP PRESS* I have received a solution to this from a supporter - >more

[This is a back-dated post. Actual posting date was 11/5/06]

April 18, 2006 in 01: Diary: Pre-Ride, Puzzles | Permalink | Comments (0)

P-ride hits 2006

Video Clips 2006

p-Ride Photos

  • The hands and legs

Archives

  • June 2007
  • February 2007
  • October 2006
  • July 2006
  • June 2006
  • May 2006
  • April 2006
  • March 2006
Subscribe to this blog's feed

Recent Comments

  • Cruninov on Training log from 13/4/06
  • rofovnifo on 'Fat Nick' was right about Chris Boardman
  • Simon on The next project . . .
  • Graham Brown on The next project . . .
  • Stu from Scotland on The next project . . .
  • Joe on Vertical profiles on their way
  • Joe on 45 to go - Stage 16
  • Joe on We made it! - Stage 16
  • Nick on We made it! - Stage 16
  • Jennie Sutton on Messages of support