2017 Wild Rogue Relay Finish Time Estimator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQ
1
Wild Rogue Relay Finish Time Estimator
For planning purposes only
2
3
To use this spreadsheet, select File...Download As...and save a copy to your computer
OR select File... "Make a Copy" and edit directly in Google Docs. You will not be able to make changes to this spreadsheet.
4
Change data in orange highlighted fields only. You may wish to adjust runner paces by leg depending on leg difficulty.
5
VAN # 1
6
LEGNo cell serviceRUNNERLEG 1 DISTRATINGTOTAL MILEAGEElevation gain/lossLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
7
1X6.00Moderate6.00350 / -6736/17/2016 8:00:006/17/16 8:54 AM0:54:000:09:000:54:00
8
2X6.20Moderate12.201125 / -946/17/16 8:54 AM6/17/16 9:49 AM0:55:480:09:001:49:48
9
3X4.00Easy16.20337 / -10506/17/16 9:49 AM6/17/16 10:25 AM0:36:000:09:002:25:48
10
4X4.00Easy20.2086 / -3856/17/16 10:25 AM6/17/16 11:01 AM0:36:000:09:003:01:48
11
55.10Moderate25.30146 / -3796/17/16 11:01 AM6/17/16 11:47 AM0:45:540:09:003:47:42
12
66.20Challenging31.501041 / -11526/17/16 11:47 AM6/17/16 12:43 PM0:55:480:09:004:43:30
13
31.50
14
VAN # 2
15
LEGRUNNERLEG 1 DISTRATINGTOTAL MILEAGELEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
16
73.40Easy34.90127 / -1746/17/16 12:43 PM6/17/16 1:14 PM0:30:360:09:005:14:06
17
86.60Moderate41.50327 / -3596/17/16 1:14 PM6/17/16 2:13 PM0:59:240:09:006:13:30
18
96.90Moderate48.40143 / -3416/17/16 2:13 PM6/17/16 3:15 PM1:02:060:09:007:15:36
19
108.80Challenging57.20351 / -4786/17/16 3:15 PM6/17/16 4:34 PM1:19:120:09:008:34:48
20
115.50Moderate62.70243 / -3006/17/16 4:34 PM6/17/16 5:24 PM0:49:300:09:009:24:18
21
128.80Challenging71.50687 / -6676/17/16 5:24 PM6/17/16 6:43 PM1:19:120:09:0010:43:30
22
40.00
23
VAN # 1
24
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
25
136.00Moderate77.50431 / -5166/17/16 6:43 PM6/17/16 7:37 PM0:54:000:09:0011:37:30
26
14X5.50Moderate83.00341 / -4186/17/16 7:37 PM6/17/16 8:27 PM0:49:300:09:0012:27:00
27
15X6.10Moderate89.10566 / -4966/17/16 8:27 PM6/17/16 9:21 PM0:54:540:09:0013:21:54
28
16X4.50OMG93.601509 / -2566/17/16 9:21 PM6/17/16 10:02 PM0:40:300:09:0014:02:24
29
17X6.40OMG100.001370 / -4436/17/16 10:02 PM6/17/16 11:00 PM0:57:360:09:0015:00:00
30
18X5.70Challenging105.70877 / -6056/17/16 11:00 PM6/17/16 11:51 PM0:51:180:09:0015:51:18
31
34.20
32
VAN # 2
33
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
34
19X4.70Challenging110.40662 / -4346/17/16 11:51 PM6/18/16 12:33 AM0:42:180:09:0016:33:36
35
20X5.30Challenging115.70419 / -6386/18/16 12:33 AM6/18/16 1:21 AM0:47:420:09:0017:21:18
36
21X8.80Challenging124.50917 / -18686/18/16 1:21 AM6/18/16 2:40 AM1:19:120:09:0018:40:30
37
22X8.30Challenging132.80458 / -6486/18/16 2:40 AM6/18/16 3:55 AM1:14:420:09:0019:55:12
38
23X6.00Moderate138.80212 / -12306/18/16 3:55 AM6/18/16 4:49 AM0:54:000:09:0020:49:12
39
24X4.60Challenging143.401303 / -596/18/16 4:49 AM6/18/16 5:30 AM0:41:240:09:0021:30:36
40
37.70
41
42
VAN # 1
43
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
44
25X8.20Challenging151.60275 / -17506/18/16 5:30 AM6/18/16 6:44 AM1:13:480:09:0022:44:24
45
26X8.40Challenging160.00898 / -14016/18/16 6:44 AM6/18/16 8:00 AM1:15:360:09:0024:00:00
46
27X7.60Challenging167.60793 / -6026/18/16 8:00 AM6/18/16 9:08 AM1:08:240:09:0025:08:24
47
28X8.00Challenging175.60687 / -10316/18/16 9:08 AM6/18/16 10:20 AM1:12:000:09:0026:20:24
48
29X4.80Easy180.40403 / -5426/18/16 10:20 AM6/18/16 11:03 AM0:43:120:09:0027:03:36
49
30X7.60Challenging188.00424 / -4976/18/16 11:03 AM6/18/16 12:12 PM1:08:240:09:0028:12:00
50
44.60
51
52
VAN # 2
53
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
54
316.60Challenging194.60821 / -1216/18/16 12:12 PM6/18/16 1:11 PM0:59:240:09:0029:11:24
55
325.00Challenging199.60238 / -9256/18/16 1:11 PM6/18/16 1:56 PM0:45:000:09:0029:56:24
56
335.60Moderate205.20578 / -4266/18/16 1:56 PM6/18/16 2:46 PM0:50:240:09:0030:46:48
57
345.90Clown Puncher211.10935 / -9206/18/16 2:46 PM6/18/16 3:39 PM0:53:060:09:0031:39:54
58
353.50Easy214.60384 / -3396/18/16 3:39 PM6/18/16 4:11 PM0:31:300:09:0032:11:24
59
365.00Moderate219.60372 / -4036/18/16 4:11 PM6/18/16 4:56 PM0:45:000:09:0032:56:24
60
31.60
61
= DENOTES A CELL THAT CAN BE
ADJUSTED TO ENTER RUNNER'S NAME AND MIN/MILE PACE FOR EACH LEG !
KEEP MIN/MILE PACE IN
12:XX:XX TIME FORMAT
For a 9:30 pace, this looks like 12:09:30 AM
62
63
ONCE YOU HAVE RCVD YOUR OFFICIAL
START TIME, ENTER IT IN CELL J6 !
219.60
64
65
66
67
Loading...
 
 
 
Running Teams
Sheet1