Treadmill Simulation

[John Vomastic]

Below is a Treadmill Simulation.  It provides distances at checkpoints along the route for the PPA and the slope/grade between each of the points. 

Start          0 miles
3%
Ruxton Ave     0.45 miles
6%
Hydro St    1.25 miles
15%
Join Barr Trail AS     1.65 miles
15%
Incline overlook AS      2.8 miles
12%
Top of Ws      3.02 miles
12%
No Name Creek AS     4.3 miles
12%
Bob's Road AS     5.3 miles
3%
7.8 Mile Sign     5.9miles
7%
1/2 mile to Barr Camp Sign      7.0 miles
11%
Barr Camp AS     7.6 miles
12%
BP Sign     8.7 miles
13%
End of BP SB     9.4 miles
13%
A- Frame/3 to Go Sign  10.2 miles
14%
2 to Go Sign    11.3 miles
15%
Cirque AS    11.9 miles
11%
1 to Go Sign    12.2 miles
11%
16 Golden Stairs Sign     13.02 miles
15%
Finish      13.32 miles
-----------------------
AS = Aid Station
BP = Bottomless Pit

[Slim]

Hey John, Is this interpretation right?  I have run the race a few times but my wife is giving it a go this and wants more information, information, information .

Grade   Miles/Section   
0.03          0.45   Ruxton Ave
0.06           0.8   Hydro St
0.15           0.4   Join Barr Trail AS   
0.15           1.15   Incline overlook AS
0.12           0.22   Top of Ws
0.12           1.28   No Name Creek AS
0.12           1   Bob's Road AS
0.03           0.6   7.8 Mile Sign
0.07           1.1   1/2 mile to Barr Camp Sign
0.11           0.6   Barr Camp AS
0.12           1.1   BP Sign
0.13           0.7   End of BP SB
0.13           0.8   A- Frame/3 to Go Sign
0.14           1.1   2 to Go Sign
0.15           0.6   Cirque AS
0.11           0.3   1 to Go Sign
0.11          0.82   16 Golden Stairs Sign
0.15          0.3   Finish
         13.32   

[John Vomastic]

I have not checked your math and that is one way to present the information.  I formatted the chart so it would be easy to use on a treadmill.  I put the slope number in between the points because that is the slope for that leg.  At the start (0 miles) you push the start button and set the desired speed.  Between the start point and Ruxton Avenue the slope/grade is 3%.  At Ruxton Avenue (0.45 miles) set the slope to 6% and adjust the speed accordingly.  When you reach Hydro St (1.25 miles) reset the slope to 15%.  You  need the cumulative miles unless you want to stop the treadmill after each leg.  I will try to give you some more information on related stuff, but it would be better if I did it on a new post.

[Slim]

After reading your explanation, my alternative way of showing it sucks. Your method coupled with a column next to it showing the length would be advantageous. Its important to have so when my training partner starts yelling, "when is this section over. I hate you." I can immediately provide that information.
thank you.

[Slim]

So I took the simulation for a test ride. The drawback was that the treadmills at our local gym can only go 60 minutes before having to reset. Doing math sucks at hour 2 and at a 15% incline so I created a spreadsheet that anticipates these breaks at about every 3 miles or so and I reformatted the numbers to take the math out. . If anyone thinks its advantageous, I can post it or email it. 

[Seth Jayson]

I stole John's excellent info last year and used it to make a simulation/race day chart that can be easily customized and printed for your wrist, water bottle, etc.

You can try it out here: http://1drv.ms/1JjaaUp

Sj

[khgfun]

Seth...is it possible to repost your simulation so you don't have to log into Microsoft OneNote to view it?  Thanks.

[Seth Jayson]

That's an excel file, should work fine online in the web browser. It won't work if it's not an excel file, since it calculates the pace/times for the bracelet based on the input time. However, I just clicked that link and notice somehow the file shows as corrupted. I'll see if I can resurrect it.

Sj

[Seth Jayson]

OK, I tried cleaning things up.

Here is a treadmill simulation sheet, formatted to be readable when taped to the rafters in the dim man-cave.
http://1drv.ms/1I4Btxh

(This Saturday, I dispensed with the simulation and just ran the 13 at 15%. I went through a gallon of generic koolade down there and nearly flooded the basement with sweat. The thing this can't prepare you for, of course, is some of the big step-ups and other terrain. I suggest you have your kids randomly toss cardboard boxes or pumpkins or firewood onto the front of the treadmill as you run, say from Barr Camp up.)

Here is the personalized wristband-creator, which should be working. You should not need to sign in to access this. If you are using Chrome or another browser, you may need to hit an "edit in excel online" button at the top in order to start entering your own numbers.
http://1drv.ms/1MsmS3X

I think anyone can download these documents as well, though the excel sheet is protected where it matters so the math stays untouched.

Have fun, and I'll see you all soon.

Sj

[khgfun]

Seth...

Thanks for working on this.  The first link worked, but the second link still does not work.  I am opening it in Internet Explorer, but I get a message it may be corrupt and then it goes to the screen again that requires you to go into One Note.

[Seth Jayson]

wow, that is really strange. I opened the second link no problem on a non-logged-in chrome window. I've never heard of it trying to make someone open onenote!

[Seth Jayson]

I've recovered and re-saved it, and it no longer loads as corrupt for me. (I have not been able to replicate the one-note handoff... Wait, are you sure it's not prompting you to login to OneDRIVE? That, I've seen.)

Apparently, there have been some corruption issues on onedrive with excel. First I've ever seen of them (and I use it all the time).

Might be best to get it while it's hot. Download a copy if you can before it gets corrupted again!

I assume that it's getting corrupted if multiple people are editing it at once -- although online that's not supposed to be a problem. If folks are editing in excel on the desktop then re-saving somehow, that might mess it up.

[Seth Jayson]

Apologies, folks. That wristband creator keeps getting corrupted. Every time I fix it and test it, it works. Next time I check it, it's fried. I guess we're finding out just how great Microsoft's cloud services actually are. I will occasionally re-do the thing, but your best bet is to probably grab a crayon and use the existing tools mentioned in the thread above.

[Seth Jayson]

For what it's worth, the last couple days, each time I've tried the pacecard file, it's been fine, uncorrupted.