Author Topic: [HAMR] Visualizing the OYTT  (Read 221852 times)

Re: Visualizing the OYTT
« Reply #875 on: 13 November, 2015, 10:19:45 pm »
Inspired by Jo's magnificent visualisation of the Eddington numbers I had a go at recreating it in Google Sheets for my data. Pretty straightforward to do. I used the .csv datadump from VeloViewer to get all my rides then used MS Access to total up the daily mileages.

See it here...

https://docs.google.com/spreadsheets/d/1c3WkBdf4T9TsZ-mM254QHBsaqt7n4AguOxeTgJPxCBk/edit?usp=sharing

How did you generate the plot with (red) Edd line..?  :)
Cycle and recycle.   SS Wilson

red marley

Re: Visualizing the OYTT
« Reply #876 on: 14 November, 2015, 12:16:08 pm »
Day 317 / 98: Kurt journeys for 217 miles though Florida from Tallahassee south east towards the start his challenge in January. Steve passes the 20,000 mile reboot milestone on another Cambridgeshire loop in windy conditions completing 195 miles for the day. Nothing posted from Miles.


red marley

Re: Visualizing the OYTT
« Reply #877 on: 15 November, 2015, 09:16:56 am »
Day 318 / 99: Kurt spends the day on the Withalcohee trail in mid-Florida for some welcome relief from motor traffic and 210 miles added to his total. Steve facing yet another week of autumnal weather first heads into the wind riding to the Cotswolds then about turns with the wind all the way to Peterborough for a 222 mile day. Nothing again from Miles today.


red marley

Re: Visualizing the OYTT
« Reply #878 on: 15 November, 2015, 09:19:49 am »
Here are the average moving speeds of the three riders over the last few months:


red marley

Re: Visualizing the OYTT
« Reply #879 on: 16 November, 2015, 11:52:51 am »
Day 319 / 100: Miles announces his retirement from the official UMCA HAM'R citing 'prior problems' and 'recent events'. Nevertheless he his efforts have involved riding over 27,320 miles in 8 months, which only a tiny proportion of people have ever achieved making this a considerable achievement.

Kurt has a good day boosted by some company on the road and clocking up 235 miles on the Withalochee trail and Flatwoods area. Steve has a somewhat tougher one heading back from Peterborough's Audax AGM meet to MK into 177 miles of headwind. This leaves him around 80 below the Godwin line.


Re: Visualizing the OYTT
« Reply #880 on: 16 November, 2015, 01:43:40 pm »
Construct a spreadsheet of days and distances with day No. 1 in Row 1.
Sort on distance high to low.
Where distance is less than or equal to the Row No., that’s the E number.

Tomorrow, enter distance in next available Row and Sort again on distance, high to low. Check if E number has increased.

So far this year, my E number is 36.

Last year was 39.

2013 was 40.

2012 was 39.

2011 was 36.

Er... this all seems a bit OT.
The sound of one pannier flapping

Re: Visualizing the OYTT
« Reply #881 on: 16 November, 2015, 03:00:59 pm »
Can the Eddington posts not be split from Jo's excellent commentary on the current attempts?

Re: Visualizing the OYTT
« Reply #882 on: 16 November, 2015, 05:40:24 pm »
At my request the mods have already moved the earlier Eddington posts to the main Eddington thread, but new ones have started to be posted here again. Could I suggest that Ningishzidda and Whitedown Man copy their posts to that thread then delete them from this one?

* This message will (hopefully) self destruct once you have moved your posts *

Done  :thumbsup:
Eddington Number = 132

Re: Visualizing the OYTT
« Reply #883 on: 17 November, 2015, 07:00:05 am »
Deleted.
Is it possible for Jo to have exclusive rights to this thread?

Another 'comment' thread can be started.

Its so easy to get carried away  ;)

red marley

Re: Visualizing the OYTT
« Reply #884 on: 17 November, 2015, 07:12:29 am »
(I certainly don't want exclusive write rights to this thread. I think discussion on the progress of the OYTTers based on what the visualisation reveals or prompts is interesting and valuable.)

red marley

Re: Visualizing the OYTT
« Reply #885 on: 17 November, 2015, 07:20:08 am »
Day 320 / 101: Kurt does 28 repeats of a loop through Flatwoods with friends providing welcome relief from motor traffic and and 228 miles. He's now over 460 miles above the Godwin line. Steve heads though the Chilterns for a visit to Amersham and a shorter, hilly and windy day. His 147 miles leaves him around 140 miles below WR pace.


Re: Visualizing the OYTT
« Reply #886 on: 17 November, 2015, 08:08:35 am »

Is it possible for Jo to have exclusive rights to this thread?


Given the 300+ days of much appreciated effort Jo has  put into it and the number of people who start here to understand the progress of the protagonists, yes.


red marley

Re: Visualizing the OYTT
« Reply #887 on: 18 November, 2015, 07:01:05 am »
Day 321 / 102: Kurt repeats his repeats of yesterday looping through Flatwoods with friends for an impressive 241 miles. His recent progress is lifting him away from the Godwin line, having gained 100 miles in the last week now to sit at 500 miles ahead of WR pace. Steve faces some of the toughest weather since last winter with very strong winds. He heads to Cirencester and the comparatively sheltered if hilly Cotswolds for a 170 mile day. He is currently around 170 miles below the Godwin line.


Re: Visualizing the OYTT
« Reply #888 on: 18 November, 2015, 08:48:33 am »
The last few days remind us how much steeper the snakes are than the ladders on this event.  Steve will have fought very hard for those 170 miles yesterday but the scoreboard shows that a few days of windy weather has undone all the progress he had made vs Godwin in the last 7 weeks. 
And, as we all know, there will be more bad weather to come. 

Re: Visualizing the OYTT
« Reply #889 on: 18 November, 2015, 09:26:45 am »
The last few days remind us how much steeper the snakes are than the ladders on this event.  Steve will have fought very hard for those 170 miles yesterday but the scoreboard shows that a few days of windy weather has undone all the progress he had made vs Godwin in the last 7 weeks. 
And, as we all know, there will be more bad weather to come.

The interesting, other side of this is - what will Steve be capable of in his final couple of months as weather improves drastically through May, June & July?  He didn’t get a fair crack of the whip after being knocked off and through the summer was clearly not at 100% capacity. This time around, all being well, even if he’s as much as a couple of thousand miles behind at halfway, would it be unreasonable to expect a similar run to Kurt’s ~230 mile average at his best for a few weeks to make up the deficit?

Very much early days still I guess, the main challenge for the next 3-4 months(!) is to stay close enough to the line without worrying about being below it I guess.

Wowbagger

  • Former Sylph
    • Stuff mostly about weather
Re: Visualizing the OYTT
« Reply #890 on: 18 November, 2015, 10:55:21 am »
It is, as we all know, a massively tall order. Ice, wind, rain and darkness all add to the challenge. Add it the random factor of drunk moped riders and it's clear that even if Steve manages to avoid mishaps/stumbles related to any of them, he's still got to keep physically fit enough to be able to knock out at least 215/220 miles per day when the weather does take a turn for the better. Realistically, pretty well any day he hits or passes a Godwin between now and the end of February is going to be a massive bonus.
The loss of humanity I could live with.

Re: Visualizing the OYTT
« Reply #891 on: 19 November, 2015, 06:44:30 am »
The word that explains most is ‘Cotswolds’. Been there, done that and progress is V slow. Slow up hills and not fast enough to catch up time down the hills. The real disadvantage is the motorists there ( being neighbours of Jeremy Clarkson ) think its their god given right to knock down cyclists. Plus Gloucs. Council have done next to nothing about the potted roads, so slower descents are necessary.

red marley

Re: Visualizing the OYTT
« Reply #892 on: 20 November, 2015, 09:23:44 am »
Trivial fact of the day: This thread has just passed 75,065 views.

ianrauk

  • Tattooed Beat Messiah
Re: Visualizing the OYTT
« Reply #893 on: 20 November, 2015, 09:43:57 am »
And well deserved Jo. Thanks for your graphs.

Any updates for yesterday?

red marley

Re: Visualizing the OYTT
« Reply #894 on: 20 November, 2015, 09:44:39 am »
Day 322 / 103: Kurt sticks to central Florida passing through the appealingly named Green Swamp Wilderness. Some minor GPS problems don't prevent him from accumulating another 222.3 miles. Poor weather continues for Steve, although he largely benefits from a wind assisted trip to the Norfolk coast also for exactly 222.3 miles.


red marley

Re: Visualizing the OYTT
« Reply #895 on: 20 November, 2015, 09:52:48 am »
Day 323 / 104: Another 220 mile day for Kurt as he rides north to the east Florida coast at St Augustine. He is now within a gnat's whisker of overtaking Bernard Bennet's 1939 record of 65,127 miles. Steve battles his way back from Great Yarmouth to Milton Keynes. For every tailwind there is an unequal and opposite headwind. He eventually makes it home at 1:40am with 185 miles leaving him around 180 miles below the Godwin line.


red marley

Re: Visualizing the OYTT
« Reply #896 on: 20 November, 2015, 10:39:10 am »
Miles? Kilometres? What's the difference?

(Thanks and duly edited.)

Re: Visualizing the OYTT
« Reply #897 on: 21 November, 2015, 12:22:15 am »
JO  many thanks for all updates. Needless to say we're all sorry he has slipped that distance behind the Godwin Line.  It will be interesting to see his mileage at end of 7th December 4 months or 1/3 Rd year into new attempt.
 :thumbsup:

Mr Larrington

  • A bit ov a lyv wyr by slof standirds
  • Custard Wallah
    • Mr Larrington's Automatic Diary
Re: Visualizing the OYTT
« Reply #898 on: 21 November, 2015, 02:26:50 am »
Miles? Kilometres? What's the difference?

"Quite a lot" - M Smith, Australia
External Transparent Wall Inspection Operative & Mayor of Mortagne-au-Perche
Satisfying the Bloodlust of the Masses in Peacetime

red marley

Re: Visualizing the OYTT
« Reply #899 on: 22 November, 2015, 09:57:58 am »
Day 324 / 105: Kurt rides 216 miles back to the Green Swamp Wilderness (plus/minus 10 miles or so subject to GPS problems) and in the process passes Bernard Bennett's 1939 record. Only Tommy's distance to beat now. With a forecasted change in wind direction over the weekend, Steve heads north to Goole. He finds the going tough after a difficult week of windy, wet and cold weather, managing 185 miles before bedding down.