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/18/2021 8:00:006/18/21 8:54 AM0:54:000:09:000:54:00
8
2X6.20Moderate12.201125 / -946/18/21 8:54 AM6/18/21 9:49 AM0:55:480:09:001:49:48
9
3X4.00Easy16.20337 / -10506/18/21 9:49 AM6/18/21 10:25 AM0:36:000:09:002:25:48
10
4X4.00Easy20.2086 / -3856/18/21 10:25 AM6/18/21 11:01 AM0:36:000:09:003:01:48
11
55.10Moderate25.30146 / -3796/18/21 11:01 AM6/18/21 11:47 AM0:45:540:09:003:47:42
12
66.20Challenging31.501041 / -11526/18/21 11:47 AM6/18/21 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/18/21 12:43 PM6/18/21 1:14 PM0:30:360:09:005:14:06
17
86.60Moderate41.50327 / -3596/18/21 1:14 PM6/18/21 2:13 PM0:59:240:09:006:13:30
18
96.90Moderate48.40143 / -3416/18/21 2:13 PM6/18/21 3:15 PM1:02:060:09:007:15:36
19
108.90Challenging57.30351 / -4786/18/21 3:15 PM6/18/21 4:35 PM1:20:060:09:008:35:42
20
115.60Moderate62.90243 / -3006/18/21 4:35 PM6/18/21 5:26 PM0:50:240:09:009:26:06
21
128.80Challenging71.70687 / -6676/18/21 5:26 PM6/18/21 6:45 PM1:19:120:09:0010:45:18
22
40.20
23
VAN # 1
24
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
25
136.00Moderate77.70431 / -5166/18/21 6:45 PM6/18/21 7:39 PM0:54:000:09:0011:39:18
26
14X5.50Moderate83.20341 / -4186/18/21 7:39 PM6/18/21 8:28 PM0:49:300:09:0012:28:48
27
15X6.10Moderate89.30566 / -4966/18/21 8:28 PM6/18/21 9:23 PM0:54:540:09:0013:23:42
28
16X4.50OMG93.801509 / -2566/18/21 9:23 PM6/18/21 10:04 PM0:40:300:09:0014:04:12
29
17X6.40OMG100.201370 / -4436/18/21 10:04 PM6/18/21 11:01 PM0:57:360:09:0015:01:48
30
18X5.70Challenging105.90877 / -6056/18/21 11:01 PM6/18/21 11:53 PM0:51:180:09:0015:53:06
31
34.20
32
VAN # 2
33
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
34
19X4.70Challenging110.60662 / -4346/18/21 11:53 PM6/19/21 12:35 AM0:42:180:09:0016:35:24
35
20X5.30Challenging115.90419 / -6386/19/21 12:35 AM6/19/21 1:23 AM0:47:420:09:0017:23:06
36
21X8.80Challenging124.70917 / -18686/19/21 1:23 AM6/19/21 2:42 AM1:19:120:09:0018:42:18
37
22X8.30Challenging133.00458 / -6486/19/21 2:42 AM6/19/21 3:57 AM1:14:420:09:0019:57:00
38
23X6.00Moderate139.00212 / -12306/19/21 3:57 AM6/19/21 4:51 AM0:54:000:09:0020:51:00
39
24X4.60Challenging143.601303 / -596/19/21 4:51 AM6/19/21 5:32 AM0:41:240:09:0021:32:24
40
37.70
41
42
VAN # 1
43
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
44
25X8.20Challenging151.80275 / -17506/19/21 5:32 AM6/19/21 6:46 AM1:13:480:09:0022:46:12
45
26X8.40Challenging160.20898 / -14016/19/21 6:46 AM6/19/21 8:01 AM1:15:360:09:0024:01:48
46
27X7.60Challenging167.80793 / -6026/19/21 8:01 AM6/19/21 9:10 AM1:08:240:09:0025:10:12
47
28X8.00Challenging175.80687 / -10316/19/21 9:10 AM6/19/21 10:22 AM1:12:000:09:0026:22:12
48
29X4.80Easy180.60403 / -5426/19/21 10:22 AM6/19/21 11:05 AM0:43:120:09:0027:05:24
49
30X7.60Challenging188.20424 / -4976/19/21 11:05 AM6/19/21 12:13 PM1:08:240:09:0028:13:48
50
44.60
51
52
VAN # 2
53
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
54
317.10Challenging195.30821 / -1216/19/21 12:13 PM6/19/21 1:17 PM1:03:540:09:0029:17:42
55
324.50Challenging199.80238 / -9256/19/21 1:17 PM6/19/21 1:58 PM0:40:300:09:0029:58:12
56
335.60Moderate205.40578 / -4266/19/21 1:58 PM6/19/21 2:48 PM0:50:240:09:0030:48:36
57
345.90Clown Puncher211.30935 / -9206/19/21 2:48 PM6/19/21 3:41 PM0:53:060:09:0031:41:42
58
353.50Easy214.80384 / -3396/19/21 3:41 PM6/19/21 4:13 PM0:31:300:09:0032:13:12
59
365.00Moderate219.80372 / -4036/19/21 4:13 PM6/19/21 4:58 PM0:45:000:09:0032:58:12
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.80
64
65
66
67