2017 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

 
View only
 
 
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
74.20Hard+1595/-38940.504/19/15 11:26 AM4/19/15 12:04 PM0:37:480:09:006:04:30
17
87.20Challenging
+1878/-1476
47.704/19/15 12:04 PM4/19/15 1:09 PM1:04:480:09:007:09:18
18
910.20Exhilarating
+2225/-5183
57.904/19/15 1:09 PM4/19/15 2:41 PM1:31:480:09:008:41:06
19
105.30Easy+294/-70363.204/19/15 2:41 PM4/19/15 3:28 PM0:47:420:09:009:28:48
20
114.60Easy+537/-55467.804/19/15 3:28 PM4/19/15 4:10 PM0:41:240:09:0010:10:12
21
123.20Easy+615/-75171.004/19/15 4:10 PM4/19/15 4:39 PM0:28:480:09:0010:39:00
22
34.70
23
VAN # 1
24
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
25
134.20Challenging+981/-25975.204/19/15 4:39 PM4/19/15 5:16 PM0:37:480:09:0011:16:48
26
149.80Challenging
+1577/-2326
85.004/19/15 5:16 PM4/19/15 6:45 PM1:28:120:09:0012:45:00
27
155.50Easy+402/-50690.504/19/15 6:45 PM4/19/15 7:34 PM0:49:300:09:0013:34:30
28
165.40Moderate+735/-56095.904/19/15 7:34 PM4/19/15 8:23 PM0:48:360:09:0014:23:06
29
174.00Easy+356/-47999.904/19/15 8:23 PM4/19/15 8:59 PM0:36:000:09:0014:59:06
30
184.30Easy+438/-263104.204/19/15 8:59 PM4/19/15 9:37 PM0:38:420:09:0015:37:48
31
33.20
32
VAN # 2
33
LEGRUNNERLEG 2 DISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
34
197.80OMG
+2552/-2266
112.004/19/15 9:37 PM4/19/15 10:48 PM1:10:120:09:0016:48:00
35
203.40Challenging+492/-689115.404/19/15 10:48 PM4/19/15 11:18 PM0:30:360:09:0017:18:36
36
213.40Easy+376/-624118.804/19/15 11:18 PM4/19/15 11:49 PM0:30:360:09:0017:49:12
37
224.10Moderate+484/-386122.904/19/15 11:49 PM4/20/15 12:26 AM0:36:540:09:0018:26:06
38
235.80OMG+2057/-186128.704/20/15 12:26 AM4/20/15 1:18 AM0:52:120:09:0019:18:18
39
244.20Rolling tough+1050/-699132.904/20/15 1:18 AM4/20/15 1:56 AM0:37:480:09:0019:56:06
40
28.70
41
42
VAN # 1
43
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
44
254.30Moderate
+1071/-1166
137.204/20/15 1:56 AM4/20/15 2:34 AM0:38:420:09:0020:34:48
45
268.70Challenging
+1459/-2662
145.904/20/15 2:34 AM4/20/15 3:53 AM1:18:180:09:0021:53:06
46
276.30Moderate
+1076/-1272
152.204/20/15 3:53 AM4/20/15 4:49 AM0:56:420:09:0022:49:48
47
286.70Challenging
+1442/-2153
158.904/20/15 4:49 AM4/20/15 5:50 AM1:00:180:09:0023:50:06
48
295.60Easy+628/-930164.504/20/15 5:50 AM4/20/15 6:40 AM0:50:240:09:0024:40:30
49
306.90Challenging
+1086/-1065
171.404/20/15 6:40 AM4/20/15 7:42 AM1:02:060:09:0025:42:36
50
38.50
51
52
VAN # 2
53
LEGRUNNERDISTRATINGLEG
START TIME
LEG
FINISH TIME
LEG TIMEMIN/MILETOTAL
TIME
54
317.70Moderate+709/-670179.104/20/15 7:42 AM4/20/15 8:51 AM1:09:180:09:0026:51:54
55
325.90Moderate+593/-698185.004/20/15 8:51 AM4/20/15 9:45 AM0:53:060:09:0027:45:00
56
335.40Easy+677/-539190.404/20/15 9:45 AM4/20/15 10:33 AM0:48:360:09:0028:33:36
57
346.60Challenging
+1800/-1523
197.004/20/15 10:33 AM4/20/15 11:33 AM0:59:240:09:0029:33:00
58
353.30Easy+628/-930200.304/20/15 11:33 AM4/20/15 12:02 PM0:29:420:09:0030:02:42
59
366.00Hard
+1820/-1949
206.304/20/15 12:02 PM4/20/15 12:56 PM0:54:000:09:0030:56:42
60
34.9098.30
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 !
206.30
Loading...
 
 
 
Running Teams
Sheet1