08 January, 2013

WDW Marathon Homemade Pace Calculator



When runDisney changed the course for the full marathon this year, they never updated the runner tracking area of their website to incorporate the different route.  I was trying to figure out where to tell my friends and family to cheer me on and I was having a hard time trying to keep track of where we'll be at what point in time.

So, what did I do?  I introduce to you....  my WDW Marathon Homemade Pace Calculator!  I got a little bored in Excel and tried to get slightly fancy.  The calculations take your start time (based on corral) and your pace into consideration.  Figured I'd share what I did for anyone else in the same predicament as me.

Here's a screen shot of what it looks like.  Basic Excel spread sheet.....



If anyone wants to test it out and stuff, you can download the file here (Link is to a file located on Dropbox).

Here's what you need to know/do:

1. Enter your pace in cell G1.  HOWEVER!  You need to enter it as =TIME(0,11,15) if you want a pace of 11:15 minutes per mile.  Typing in "11:15" will totally mess up everything.  

2.  Look at the Corral Start Times on the right hand side.  Copy and paste your corral's start time into cell B2.  

I also added in when and what I'm going to eat, just for my own reference!

Let me know if anyone has any questions!  Anything else you guys think I should add?

I can't believe the races are THIS WEEKEND!  

12 comments

  1. This is super awesome - thanks for sharing!

    ReplyDelete
  2. This is great! Thanks!!! Helps me visualize the course as this is my first marathon and first time running WDW.

    ReplyDelete
  3. Thank you, I am in coral C as well looking for finish under 5 as well. Good Luck!

    ReplyDelete
  4. Thank you so much! Off to share with my husband...

    ReplyDelete
  5. Thank you SO much. This was a gigantic help!!

    ReplyDelete
  6. Awesome tool! Just one note, you have a bug in your spreadsheet. The formula for B29 should be "=B28+($G$1*0.2)" and C29 should be "=C28+($G$1*0.2)". Otherwise, you end up adding the time for a whole mile to the Time, and a fixed 2 minutes to the Race Time.

    ReplyDelete
  7. For those of you who are slightly less adept at Excel, you need to type in =TIME(0,11,15), not just the 0,11,15 part. I thought I was going crazy!

    Thanks for an awesome spreadsheet! How would I go about editing for a HALF?

    ReplyDelete
  8. I'm in Corral C as well!! This is exactly the time I was thinking of finishing!! :D

    ReplyDelete
  9. Thank you for sharing this, it is very helpful!! We were hoping to time our race to ride Mount Everest in Animal Kingdom, and I was able to figure out the pace needed to get there right when it opens :)

    ReplyDelete
  10. Hi Jenn! I stumbled upon your site and you have great info! I ran the WDW Half on Saturday and I'm thinking about doing the Disneyland Half in Aug/Sep. I know you've done both so I wanted to ask you how they compare. Is the course in CA alot more hilly or is it like the one in Orlando? Thanks!

    ReplyDelete
    Replies
    1. Hey Aimee! Sorry it took so long to reply! I think both are pretty flat, nothing too crazy in terms of hills!

      Delete