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
 
 
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.00788 / -7526/19/2015 8:00:006/19/15 8:42 AM0:42:000:07:000:42:00
8
2X5.20Moderate11.20247 / -6316/19/15 8:42 AM6/19/15 9:18 AM0:36:240:07:001:18:24
9
3X6.20Tough17.401238 / -2056/19/15 9:18 AM6/19/15 10:01 AM0:43:240:07:002:01:48
10
4X8.00Tough25.40399 / -14156/19/15 10:01 AM6/19/15 10:57 AM0:56:000:07:002:57:48
11
55.10Moderate30.50146 / -3796/19/15 10:57 AM6/19/15 11:33 AM0:35:420:07:003:33:30
12
66.20Challenging36.701041 / -11526/19/15 11:33 AM6/19/15 12:16 PM0:43:240:07:004:16:54
13
36.70
14
VAN # 2
15
LEGRUNNERLEG 1 DISTRATINGTOTAL MILEAGELEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
16
74.90Easy41.60190 / -3256/19/15 12:16 PM6/19/15 12:51 PM0:34:180:07:004:51:12
17
84.80Easy46.40326 / -2786/19/15 12:51 PM6/19/15 1:24 PM0:33:360:07:005:24:48
18
96.90Moderate53.30143 / -3416/19/15 1:24 PM6/19/15 2:13 PM0:48:180:07:006:13:06
19
108.80Challenging62.10351 / -4786/19/15 2:13 PM6/19/15 3:14 PM1:01:360:07:007:14:42
20
115.50Moderate67.60243 / -3006/19/15 3:14 PM6/19/15 3:53 PM0:38:300:07:007:53:12
21
128.80Challenging76.40687 / -6676/19/15 3:53 PM6/19/15 4:54 PM1:01:360:07:008:54:48
22
39.70
23
VAN # 1
24
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
25
136.00Moderate82.40431 / -5166/19/15 4:54 PM6/19/15 5:36 PM0:42:000:07:009:36:48
26
14X5.50Moderate87.90341 / -4186/19/15 5:36 PM6/19/15 6:15 PM0:38:300:07:0010:15:18
27
15X6.10Moderate94.00566 / -4966/19/15 6:15 PM6/19/15 6:58 PM0:42:420:07:0010:58:00
28
16X4.50OMG98.501509 / -2566/19/15 6:58 PM6/19/15 7:29 PM0:31:300:07:0011:29:30
29
17X6.40OMG104.901370 / -4436/19/15 7:29 PM6/19/15 8:14 PM0:44:480:07:0012:14:18
30
18X5.70Challenging110.60877 / -6056/19/15 8:14 PM6/19/15 8:54 PM0:39:540:07:0012:54:12
31
34.20
32
VAN # 2
33
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
34
19X4.70Challenging115.30662 / -4346/19/15 8:54 PM6/19/15 9:27 PM0:32:540:07:0013:27:06
35
20X5.30Challenging120.60419 / -6386/19/15 9:27 PM6/19/15 10:04 PM0:37:060:07:0014:04:12
36
21X8.80Challenging129.40917 / -18686/19/15 10:04 PM6/19/15 11:05 PM1:01:360:07:0015:05:48
37
22X8.30Challenging137.70458 / -6486/19/15 11:05 PM6/20/15 12:03 AM0:58:060:07:0016:03:54
38
23X6.00Moderate143.70212 / -12306/20/15 12:03 AM6/20/15 12:45 AM0:42:000:07:0016:45:54
39
24X4.60Challenging148.301303 / -596/20/15 12:45 AM6/20/15 1:18 AM0:32:120:07:0017:18:06
40
37.70
41
42
VAN # 1
43
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
44
25X4.90Moderate153.2073 / -9196/20/15 1:18 AM6/20/15 1:52 AM0:34:180:07:0017:52:24
45
26X6.60Moderate159.80237 / -15536/20/15 1:52 AM6/20/15 2:38 AM0:46:120:07:0018:38:36
46
27X6.60Challenging166.40808 / -2696/20/15 2:38 AM6/20/15 3:24 AM0:46:120:07:0019:24:48
47
28X6.00Moderate172.40410 / -5776/20/15 3:24 AM6/20/15 4:06 AM0:42:000:07:0020:06:48
48
29X5.30Moderate177.70391 / -7766/20/15 4:06 AM6/20/15 4:43 AM0:37:060:07:0020:43:54
49
30X6.90Challenging184.60640 / -7616/20/15 4:43 AM6/20/15 5:32 AM0:48:180:07:0021:32:12
50
36.30
51
52
VAN # 2
53
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
54
317.00Moderate191.60445 / -4856/20/15 5:32 AM6/20/15 6:21 AM0:49:000:07:0022:21:12
55
324.90Moderate196.50319 / -1996/20/15 6:21 AM6/20/15 6:55 AM0:34:180:07:0022:55:30
56
337.40Challenging203.90755 / -8466/20/15 6:55 AM6/20/15 7:47 AM0:51:480:07:0023:47:18
57
348.50Challenging212.40745 / -5156/20/15 7:47 AM6/20/15 8:46 AM0:59:300:07:0024:46:48
58
357.30Challenging219.70971 / -10136/20/15 8:46 AM6/20/15 9:37 AM0:51:060:07:0025:37:54
59
364.80Moderate224.50372 / -4036/20/15 9:37 AM6/20/15 10:11 AM0:33:360:07:0026:11:30
60
39.90
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 !
224.50
64
65
66
67
Loading...
 
 
 
Running Teams
Sheet1