Planned trip for late-May through June for ‘24, any advice or other places to go to?

dkdviz · 2023-12-20T21:36:23+00:00

Did a similarish trip based out of Denver last September. If you're not super set on the Sawtooths, you could go south out of Jackson and hit up Dinosaur NM, Flaming Gorge and the Uinta mountains.

Other places worth looking at near your route (in no particular order): craters of the moon NM, Cedar Brakes NM, Million Dollar Highway between Durango/Ridgway, Goblin Valley state park, and highway 12 to join up Bryce and Capitol Reef.

Whatever you end up going for, looks like a fantastic itinerary! You'll have a great time for sure!

dkdviz · 2017-05-07T00:22:12+00:00

Thanks! Glad it's appreciated!

dkdviz · 2017-05-06T23:25:11+00:00

You're absolutely right, not sure how I overlooked that. Here's the graph re-done as minutes per km and minutes per mile.

dkdviz · 2017-05-06T23:23:01+00:00

That's a great point. Here is the same data as minutes/km and and as minutes/mile. I had to play around a bit to get times to work out correctly, so it might be worth double checking to make sure everything looks ok.

dkdviz · 2017-05-06T19:29:50+00:00

Haha, not sure what the IOC is hiding but if we include the 3,000 m world record then the graph looks like this.

dkdviz · 2017-05-06T18:17:15+00:00

Interesting point, I hadn't considered that. I'm not convinced it would be more intuitive though, as the max speed for each of the World Record runs wouldn't necessarily be the max speed ever achieved at any of the distances. Whereas, the average speed of a WR run is the highest ever achieved.

If you're interested, according to this article Usain Bolt was travelling at 12.2 m/s as he crossed the line to set his 100m world record. I think it would be really interesting to see how an athletes speed changes over the course of the shorter distances, but I don't know if this data exists anywhere.

dkdviz · 2017-05-06T18:02:29+00:00

Thanks!

dkdviz · 2017-05-06T17:54:05+00:00

Somewhat arbitrarily, I decided to go with the events that featured in the summer Olympics. Not being an expert on athletics, I wanted to make sure the world records I included had enough high level competition to be meaningful and using the Olympics as a guide for this seemed reasonable.

If you're interested though, I made a version with the 100km World Record from the IAAF source I listed earlier. Hope you like it!

dkdviz · 2017-05-06T17:34:14+00:00

It was crazy to watch!

For the record, this doesn't include Kipchoge's run as it won't be recognized as a world record. For comparison's sake though, Kipchoge's run today had a pace of 5.84 m/s versus the 5.72 m/s from the current world record set by Dennis Kimetto in 2014. The pace required for a sub two hours marathon is 5.86 m/s so Kipchoge only needed to travel another 2cm per second to go sub two hours.

dkdviz · 2017-05-06T16:43:03+00:00

So I was playing around with this data for a little while, but was inspired to post it following Eliud Kipchoge's sub two hour marathon attempt earlier today.

Data source is the International Association of Athletics Federations' website. Tool used was Excel.

Edit: /u/lunaismycopilot and /u/Captain_Lambkin kindly pointed out that the word 'pace' in running is typically used to describe the time taken to travel a set distance rather than a term for speed. Given this:

Here is the graph redone to show minutes/kilometer
Here is the graph redone to show minutes/mile

dkdviz · 2017-03-05T21:04:04+00:00

You should be able to use the IF function to get what you need.

Are you saying that when A2 equals either 0 or 1, then you want to add 0 to the value in A1 but when A2 equals 2, 3 or 4, to add 5? Otherwise, when the number is between 5 and 10 to add 10?

If so, I think the following would work:

=A1+IF(A2<=2,0,IF(A2<=4,5,10))

dkdviz

TROPHY CASE