2019 Smoky Mountain 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
 
 
ABCDEFGHIJKLMNOP
1
Full 206 Mile Smoky Mountain 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
LEGRUNNERLEG DISTRATINGElevation gain/lossTOTAL MILEAGELEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
6
1[Runner 1 - name]3.50Easy+419/-4193.504/26/2019 8:00:004/26/19 8:28 AM0:28:000:08:000:28:00
7
27.90Moderate
+1259/-2204
11.404/26/19 8:28 AM4/26/19 9:39 AM1:11:060:09:001:39:06
8
37.60Challenging+1589/-98619.004/26/19 9:39 AM4/26/19 10:51 AM1:12:120:09:302:51:18
9
43.70Easy+375/-37622.704/26/19 10:51 AM4/26/19 11:19 AM0:27:450:07:303:19:03
10
57.30Hard+1827/-93730.004/26/19 11:19 AM4/26/19 11:59 AM0:40:090:05:303:59:12
11
66.30Hard
+1554/-1437
36.304/26/19 11:59 AM4/26/19 12:52 PM0:53:330:08:304:52:45
12
36.30
13
LEGRUNNERLEG DISTRATINGTOTAL MILEAGELEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
14
7[Runner 7 - name]3.90Hard+1595/-38940.204/26/19 12:52 PM4/26/19 1:27 PM0:35:060:09:005:27:51
15
84.00Moderate+1034/-83444.204/26/19 1:27 PM4/26/19 2:01 PM0:34:000:08:306:01:51
16
910.90Exhilarating
+2225/-5183
55.104/26/19 2:01 PM4/26/19 4:01 PM1:59:540:11:008:01:45
17
104.60Easy+294/-70359.704/26/19 4:01 PM4/26/19 4:36 PM0:34:300:07:308:36:15
18
114.30Easy+537/-55464.004/26/19 4:36 PM4/26/19 5:10 PM0:34:240:08:009:10:39
19
122.40Easy+615/-75166.404/26/19 5:10 PM4/26/19 5:32 PM0:21:360:09:009:32:15
20
30.10
21
LEGRUNNERLEG DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
22
13[Runner 1 - name]4.20Challenging+981/-25970.604/26/19 5:32 PM4/26/19 6:10 PM0:37:480:09:0010:10:03
23
149.80Challenging
+1577/-2326
80.404/26/19 6:10 PM4/26/19 7:38 PM1:28:120:09:0011:38:15
24
155.50Easy+402/-50685.904/26/19 7:38 PM4/26/19 8:30 PM0:52:150:09:3012:30:30
25
165.40Moderate+735/-56091.304/26/19 8:30 PM4/26/19 9:19 PM0:48:360:09:0013:19:06
26
174.00Easy+356/-47995.304/26/19 9:19 PM4/26/19 9:55 PM0:36:000:09:0013:55:06
27
184.30Easy+438/-26399.604/26/19 9:55 PM4/26/19 10:31 PM0:36:330:08:3014:31:39
28
33.20
29
LEGRUNNERLEG DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
30
19[Runner 7 - name]7.80OMG
+2552/-2266
107.404/26/19 10:31 PM4/27/19 12:05 AM1:33:360:12:0016:05:15
31
203.40Challenging+492/-689110.804/27/19 12:05 AM4/27/19 12:39 AM0:34:000:10:0016:39:15
32
213.40Easy+376/-624114.204/27/19 12:39 AM4/27/19 1:09 AM0:30:360:09:0017:09:51
33
224.20Moderate+484/-386118.404/27/19 1:09 AM4/27/19 1:47 AM0:37:480:09:0017:47:39
34
235.80OMG+2057/-186124.204/27/19 1:47 AM4/27/19 2:51 AM1:03:480:11:0018:51:27
35
244.20Rolling tough+1050/-699128.404/27/19 2:51 AM4/27/19 3:22 AM0:31:300:07:3019:22:57
36
28.80
37
38
LEGRUNNERLEG DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
39
25[Runner 1 - name]4.30Moderate
+1071/-1166
132.704/27/19 3:22 AM4/27/19 4:03 AM0:40:510:09:3020:03:48
40
268.70Challenging
+1459/-2662
141.404/27/19 4:03 AM4/27/19 5:22 AM1:18:180:09:0021:22:06
41
276.30Moderate
+1076/-1272
147.704/27/19 5:22 AM4/27/19 6:21 AM0:59:510:09:3022:21:57
42
286.70Challenging
+1442/-2153
154.404/27/19 6:21 AM4/27/19 7:25 AM1:03:390:09:3023:25:36
43
295.60Easy+628/-930160.004/27/19 7:25 AM4/27/19 8:10 AM0:44:480:08:0024:10:24
44
306.90Challenging
+1086/-1065
166.904/27/19 8:10 AM4/27/19 9:12 AM1:02:060:09:0025:12:30
45
38.50
46
47
LEGRUNNERLEG DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
48
31[Runner 7 - name]7.70Moderate+709/-670174.604/27/19 9:12 AM4/27/19 10:21 AM1:09:180:09:0026:21:48
49
325.90Moderate+593/-698180.504/27/19 10:21 AM4/27/19 11:17 AM0:56:030:09:3027:17:51
50
334.70Easy+573/-607185.204/27/19 11:17 AM4/27/19 12:00 PM0:42:180:09:0028:00:09
51
347.20Wicked Fun
+1862/-1606
192.404/27/19 12:00 PM4/27/19 1:04 PM1:04:480:09:0029:04:57
52
353.30Easy+628/-930195.704/27/19 1:04 PM4/27/19 1:34 PM0:29:420:09:0029:34:39
53
366.00Hard
+1820/-1949
201.704/27/19 1:34 PM4/27/19 2:28 PM0:54:000:09:0030:28:39
54
34.8093.70
55
= 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 AMAvg pace:0:09:04
56
57
ONCE YOU HAVE RCVD YOUR OFFICIAL
START TIME, ENTER IT IN CELL J6 !
201.70
Loading...