2018 Smoky Mountain Relay Finish Time Estimator.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOP
1
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
VAN # 1
6
LEGRUNNERLEG 1 DISTRATINGElevation gain/lossTOTAL MILEAGELEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
7
13.50Easy+419/-4193.504/19/2015 6:00:004/19/15 6:31 AM0:31:300:09:000:31:30
8
27.90Moderate
+1259/-2204
11.404/19/15 6:31 AM4/19/15 7:42 AM1:11:060:09:001:42:36
9
37.60Challenging+1589/-98619.004/19/15 7:42 AM4/19/15 8:51 AM1:08:240:09:002:51:00
10
43.70Easy+375/-37622.704/19/15 8:51 AM4/19/15 9:24 AM0:33:180:09:003:24:18
11
57.30Hard+1827/-93730.004/19/15 9:24 AM4/19/15 10:30 AM1:05:420:09:004:30:00
12
66.30Hard
+1554/-1437
36.304/19/15 10:30 AM4/19/15 11:26 AM0:56:420:09:005:26:42
13
36.30
14
VAN # 2
15
LEGRUNNERLEG 1 DISTRATINGTOTAL MILEAGELEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
16
73.90Hard+1595/-38940.204/19/15 11:26 AM4/19/15 12:01 PM0:35:060:09:006:01:48
17
84.00Moderate+1034/-83444.204/19/15 12:01 PM4/19/15 12:37 PM0:36:000:09:006:37:48
18
910.90Exhilarating
+2225/-5183
55.104/19/15 12:37 PM4/19/15 2:15 PM1:38:060:09:008:15:54
19
104.60Easy+294/-70359.704/19/15 2:15 PM4/19/15 2:57 PM0:41:240:09:008:57:18
20
114.30Easy+537/-55464.004/19/15 2:57 PM4/19/15 3:36 PM0:38:420:09:009:36:00
21
122.40Easy+615/-75166.404/19/15 3:36 PM4/19/15 3:57 PM0:21:360:09:009:57:36
22
30.10
23
VAN # 1
24
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
25
134.20Challenging+981/-25970.604/19/15 3:57 PM4/19/15 4:35 PM0:37:480:09:0010:35:24
26
149.80Challenging
+1577/-2326
80.404/19/15 4:35 PM4/19/15 6:03 PM1:28:120:09:0012:03:36
27
155.50Easy+402/-50685.904/19/15 6:03 PM4/19/15 6:53 PM0:49:300:09:0012:53:06
28
165.40Moderate+735/-56091.304/19/15 6:53 PM4/19/15 7:41 PM0:48:360:09:0013:41:42
29
174.00Easy+356/-47995.304/19/15 7:41 PM4/19/15 8:17 PM0:36:000:09:0014:17:42
30
184.30Easy+438/-26399.604/19/15 8:17 PM4/19/15 8:56 PM0:38:420:09:0014:56:24
31
33.20
32
VAN # 2
33
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
34
197.80OMG
+2552/-2266
107.404/19/15 8:56 PM4/19/15 10:06 PM1:10:120:09:0016:06:36
35
203.40Challenging+492/-689110.804/19/15 10:06 PM4/19/15 10:37 PM0:30:360:09:0016:37:12
36
213.40Easy+376/-624114.204/19/15 10:37 PM4/19/15 11:07 PM0:30:360:09:0017:07:48
37
224.20Moderate+484/-386118.404/19/15 11:07 PM4/19/15 11:45 PM0:37:480:09:0017:45:36
38
235.80OMG+2057/-186124.204/19/15 11:45 PM4/20/15 12:37 AM0:52:120:09:0018:37:48
39
244.20Rolling tough+1050/-699128.404/20/15 12:37 AM4/20/15 1:15 AM0:37:480:09:0019:15:36
40
28.80
41
42
VAN # 1
43
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
44
254.30Moderate
+1071/-1166
132.704/20/15 1:15 AM4/20/15 1:54 AM0:38:420:09:0019:54:18
45
268.70Challenging
+1459/-2662
141.404/20/15 1:54 AM4/20/15 3:12 AM1:18:180:09:0021:12:36
46
276.30Moderate
+1076/-1272
147.704/20/15 3:12 AM4/20/15 4:09 AM0:56:420:09:0022:09:18
47
286.70Challenging
+1442/-2153
154.404/20/15 4:09 AM4/20/15 5:09 AM1:00:180:09:0023:09:36
48
295.60Easy+628/-930160.004/20/15 5:09 AM4/20/15 6:00 AM0:50:240:09:0024:00:00
49
306.90Challenging
+1086/-1065
166.904/20/15 6:00 AM4/20/15 7:02 AM1:02:060:09:0025:02:06
50
38.50
51
52
VAN # 2
53
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
54
317.70Moderate+709/-670174.604/20/15 7:02 AM4/20/15 8:11 AM1:09:180:09:0026:11:24
55
325.90Moderate+593/-698180.504/20/15 8:11 AM4/20/15 9:04 AM0:53:060:09:0027:04:30
56
334.70Easy+573/-607185.204/20/15 9:04 AM4/20/15 9:46 AM0:42:180:09:0027:46:48
57
347.20Wicked Fun
+1862/-1606
192.404/20/15 9:46 AM4/20/15 10:51 AM1:04:480:09:0028:51:36
58
353.30Easy+628/-930195.704/20/15 10:51 AM4/20/15 11:21 AM0:29:420:09:0029:21:18
59
366.00Hard
+1820/-1949
201.704/20/15 11:21 AM4/20/15 12:15 PM0:54:000:09:0030:15:18
60
34.8093.70
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 AMAvg pace:12:09:00 AM
62
63
ONCE YOU HAVE RCVD YOUR OFFICIAL
START TIME, ENTER IT IN CELL J6 !
201.70
Loading...
Main menu