Wednesday, September 16, 2009

Estimated run times!

Okay, this is often the funnest post to look at. I, the computer whiz that I am, have developed a spreadsheet that will predict each runner's running time, and the times that they will be starting and finishing each run. That's right, thanks to the miracle of Excel, I am pretty much able to see the future.

Of course, two assumptions were made in my estimations: 1) We are granted the start time we requested, which is 10 am. (If we get a different start time, I will adjust my ingenious spreadsheet accordingly); and 2) Each runner stays true to the pace they gave me. Of course, this NEVER happens, but it is still a blast to look at! Click to enlarge.

7 comments:

Anonymous said...

JB- Somethings wrong here. My middle leg is only 3.4 miles, yet the spreadsheet computes my run time as over an hour. If I run 3 miles in more than an hour, I'm graciously bowing out now and never running a lick anymore, and starting to drink and get fat, and eat lots of apple fritters from 7-11 everyday.

J.B. said...

Wow...your middle leg is "only" 3.4 miles? I'd have a doctor take a look at that.

J.B. said...

Fixed it.

Graham said...

Good work.

Graham said...

Good Work JB.

Belinda said...

Morgan, the longer your leg takes the later I run. I'll bring the apple fritters over tomorrow.

Morgan said...

Oh, how I love apple fritters.