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
74.90Easy36.40190 / -3256/17/16 12:43 PM6/17/16 1:27 PM0:44:060:09:005:27:36
17
84.80Easy41.20326 / -2786/17/16 1:27 PM6/17/16 2:10 PM0:43:120:09:006:10:48
18
96.90Moderate48.10143 / -3416/17/16 2:10 PM6/17/16 3:12 PM1:02:060:09:007:12:54
19
108.80Challenging56.90351 / -4786/17/16 3:12 PM6/17/16 4:32 PM1:19:120:09:008:32:06
20
115.50Moderate62.40243 / -3006/17/16 4:32 PM6/17/16 5:21 PM0:49:300:09:009:21:36
21
128.80Challenging71.20687 / -6676/17/16 5:21 PM6/17/16 6:40 PM1:19:120:09:0010:40:48
22
39.70
23
VAN # 1
24
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
25
136.00Moderate77.20431 / -5166/17/16 6:40 PM6/17/16 7:34 PM0:54:000:09:0011:34:48
26
14X5.50Moderate82.70341 / -4186/17/16 7:34 PM6/17/16 8:24 PM0:49:300:09:0012:24:18
27
15X6.10Moderate88.80566 / -4966/17/16 8:24 PM6/17/16 9:19 PM0:54:540:09:0013:19:12
28
16X4.50OMG93.301509 / -2566/17/16 9:19 PM6/17/16 9:59 PM0:40:300:09:0013:59:42
29
17X6.40OMG99.701370 / -4436/17/16 9:59 PM6/17/16 10:57 PM0:57:360:09:0014:57:18
30
18X5.70Challenging105.40877 / -6056/17/16 10:57 PM6/17/16 11:48 PM0:51:180:09:0015:48:36
31
34.20
32
VAN # 2
33
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
34
19X4.70Challenging110.10662 / -4346/17/16 11:48 PM6/18/16 12:30 AM0:42:180:09:0016:30:54
35
20X5.30Challenging115.40419 / -6386/18/16 12:30 AM6/18/16 1:18 AM0:47:420:09:0017:18:36
36
21X8.80Challenging124.20917 / -18686/18/16 1:18 AM6/18/16 2:37 AM1:19:120:09:0018:37:48
37
22X8.30Challenging132.50458 / -6486/18/16 2:37 AM6/18/16 3:52 AM1:14:420:09:0019:52:30
38
23X6.00Moderate138.50212 / -12306/18/16 3:52 AM6/18/16 4:46 AM0:54:000:09:0020:46:30
39
24X4.60Challenging143.101303 / -596/18/16 4:46 AM6/18/16 5:27 AM0:41:240:09:0021:27:54
40
37.70
41
42
VAN # 1
43
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
44
25X8.20Challenging151.30275 / -17506/18/16 5:27 AM6/18/16 6:41 AM1:13:480:09:0022:41:42
45
26X8.40Challenging159.70898 / -14016/18/16 6:41 AM6/18/16 7:57 AM1:15:360:09:0023:57:18
46
27X7.60Challenging167.30793 / -6026/18/16 7:57 AM6/18/16 9:05 AM1:08:240:09:0025:05:42
47
28X8.00Challenging175.30687 / -10316/18/16 9:05 AM6/18/16 10:17 AM1:12:000:09:0026:17:42
48
29X6.40Moderate181.70529 / -6996/18/16 10:17 AM6/18/16 11:15 AM0:57:360:09:0027:15:18
49
30X6.20Moderate187.90360 / -4026/18/16 11:15 AM6/18/16 12:11 PM0:55:480:09:0028:11:06
50
44.80
51
52
VAN # 2
53
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
54
316.60Challenging194.50821 / -1216/18/16 12:11 PM6/18/16 1:10 PM0:59:240:09:0029:10:30
55
325.00Challenging199.50238 / -9256/18/16 1:10 PM6/18/16 1:55 PM0:45:000:09:0029:55:30
56
335.60Moderate205.10578 / -4266/18/16 1:55 PM6/18/16 2:45 PM0:50:240:09:0030:45:54
57
345.90Clown Puncher211.00935 / -9206/18/16 2:45 PM6/18/16 3:39 PM0:53:060:09:0031:39:00
58
353.50Easy214.50384 / -3396/18/16 3:39 PM6/18/16 4:10 PM0:31:300:09:0032:10:30
59
364.80Moderate219.30372 / -4036/18/16 4:10 PM6/18/16 4:53 PM0:43:120:09:0032:53:42
60
31.40
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.30
64
65
66
67
Loading...
 
 
 
Running Teams
Sheet1