| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 4 | |||||||||
2 | ||||||||||
3 | Only change yellow highlighted cells! Do not edit other fields! To use this spreadsheet, select File..."Download As"...and save a copy to your computer, OR select File..."Make a copy" and edit it directly in Google Docs | |||||||||
4 | VAN # 1 | |||||||||
5 | LEG | RUNNER | DIST | RATING | LEG START TIME | LEG FINISH TIME | LEG TIME | MIN/MILE | TOTAL TIME | |
6 | 1 | 7.3 | Moderate | 6/21/24 7:00 AM | 6/21/24 8:10 AM | 1:10:00 | 0:09:00 | 1:10:00 | Time Trial | |
7 | 2 | 11.0 | WTH | 6/21/24 8:10 AM | 6/21/24 9:49 AM | 1:39:00 | 0:09:00 | 2:49:00 | ||
8 | 3 | 7.7 | Moderate | 6/21/24 9:49 AM | 6/21/24 10:58 AM | 1:09:18 | 0:09:00 | 3:58:18 | ||
9 | 4 | 7.1 | Hard | 6/21/24 10:58 AM | 6/21/24 12:02 PM | 1:03:54 | 0:09:00 | 5:02:12 | ||
10 | 5 | 7.0 | Hard* | 6/21/24 12:02 PM | 6/21/24 1:05 PM | 1:03:00 | 0:09:00 | 6:05:12 | Exchange 6 has an open 2 mile exchange window. Leg 5 & 6 distances dependent on where teams make exchange. | |
11 | 6 | 7.0 | Hard* | 6/21/24 1:05 PM | 6/21/24 2:08 PM | 1:03:00 | 0:09:00 | 7:08:12 | ||
12 | ||||||||||
13 | VAN # 2 | |||||||||
14 | LEG | RUNNER | DIST | RATING | LEG START TIME | LEG FINISH TIME | LEG TIME | MIN/MILE | TOTAL TIME | |
15 | 7 | 5.5 | Moderate | 6/21/24 2:08 PM | 6/21/24 2:57 PM | 0:49:30 | 0:09:00 | 7:57:42 | ||
16 | 8 | 3.8 | Easy | 6/21/24 2:57 PM | 6/21/24 3:31 PM | 0:34:12 | 0:09:00 | 8:31:54 | ||
17 | 9 | 7.0 | Hard | 6/21/24 3:31 PM | 6/21/24 4:34 PM | 1:03:00 | 0:09:00 | 9:34:54 | ||
18 | 10 | 8.4 | Very Hard | 6/21/24 4:34 PM | 6/21/24 5:50 PM | 1:15:36 | 0:09:00 | 10:50:30 | ||
19 | 11 | 7.0 | Hard | 6/21/24 5:50 PM | 6/21/24 6:53 PM | 1:03:00 | 0:09:00 | 11:53:30 | ||
20 | 12 | 5.3 | Moderate | 6/21/24 6:53 PM | 6/21/24 7:41 PM | 0:47:42 | 0:09:00 | 12:41:12 | ||
21 | ||||||||||
22 | VAN # 1 | |||||||||
23 | LEG | RUNNER | DIST | RATING | LEG START TIME | LEG FINISH TIME | LEG TIME | MIN/MILE | TOTAL TIME | |
24 | 13 | 7.4 | Moderate | 6/21/24 7:41 PM | 6/21/24 8:47 PM | 1:06:36 | 0:09:00 | 13:47:48 | ||
25 | 14 | 8.8 | Very Hard | 6/21/24 8:47 PM | 6/21/24 10:07 PM | 1:19:12 | 0:09:00 | 15:07:00 | ||
26 | 15 | 4.4 | Easy | 6/21/24 10:07 PM | 6/21/24 10:46 PM | 0:39:36 | 0:09:00 | 15:46:36 | ||
27 | 16 | 5.5 | Moderate | 6/21/24 10:46 PM | 6/21/24 11:36 PM | 0:49:30 | 0:09:00 | 16:36:06 | ||
28 | 17 | 7.1 | Hard | 6/21/24 11:36 PM | 6/22/24 12:40 AM | 1:03:54 | 0:09:00 | 17:40:00 | ||
29 | 18 | 5.2 | Moderate | 6/22/24 12:40 AM | 6/22/24 1:26 AM | 0:46:48 | 0:09:00 | 18:26:48 | ||
30 | ||||||||||
31 | VAN # 2 | |||||||||
32 | LEG | RUNNER | DIST | RATING | LEG START TIME | LEG FINISH TIME | LEG TIME | MIN/MILE | TOTAL TIME | |
33 | 19 | 7.3 | Hard | 6/22/24 1:26 AM | 6/22/24 2:32 AM | 1:05:42 | 0:09:00 | 19:32:30 | ||
34 | 20 | 6.9 | Moderate | 6/22/24 2:32 AM | 6/22/24 3:34 AM | 1:02:06 | 0:09:00 | 20:34:36 | ||
35 | 21 | 6.3 | Moderate | 6/22/24 3:34 AM | 6/22/24 4:31 AM | 0:56:42 | 0:09:00 | 21:31:18 | ||
36 | 22 | 4.7 | Moderate | 6/22/24 4:31 AM | 6/22/24 5:13 AM | 0:42:18 | 0:09:00 | 22:13:36 | ||
37 | 23 | 6.5 | Moderate | 6/22/24 5:13 AM | 6/22/24 6:12 AM | 0:58:30 | 0:09:00 | 23:12:06 | ||
38 | 24 | 6.3 | Moderate | 6/22/24 6:12 AM | 6/22/24 7:08 AM | 0:56:42 | 0:09:00 | 24:08:48 | ||
39 | ||||||||||
40 | ||||||||||
41 | VAN # 1 | |||||||||
42 | LEG | RUNNER | DIST | RATING | LEG START TIME | LEG FINISH TIME | LEG TIME | MIN/MILE | TOTAL TIME | |
43 | 25 | 7.3 | Hard | 6/22/24 7:08 AM | 6/22/24 8:14 AM | 1:05:42 | 0:09:00 | 25:14:30 | ||
44 | 26 | 7.0 | Moderate | 6/22/24 8:14 AM | 6/22/24 9:17 AM | 1:03:00 | 0:09:00 | 26:17:30 | ||
45 | 27 | 6.0 | Moderate | 6/22/24 9:17 AM | 6/22/24 10:11 AM | 0:54:00 | 0:09:00 | 27:11:30 | ||
46 | 28 | 2.1 | Easy | 6/22/24 10:11 AM | 6/22/24 10:30 AM | 0:18:54 | 0:09:00 | 27:30:24 | ||
47 | 29 | 4.2 | Hard | 6/22/24 10:30 AM | 6/22/24 11:08 AM | 0:37:48 | 0:09:00 | 28:08:12 | ||
48 | 30 | 7.1 | WTH | 6/22/24 11:08 AM | 6/22/24 12:12 PM | 1:03:54 | 0:09:00 | 29:12:06 | ||
49 | ||||||||||
50 | ||||||||||
51 | VAN # 2 | |||||||||
52 | LEG | RUNNER | DIST | RATING | LEG START TIME | LEG FINISH TIME | LEG TIME | MIN/MILE | TOTAL TIME | |
53 | 31 | 5.8 | Hard | 6/22/24 12:12 PM | 6/22/24 1:04 PM | 0:52:12 | 0:09:00 | 30:04:18 | ||
54 | 32 | 2.2 | Easy | 6/22/24 1:04 PM | 6/22/24 1:24 PM | 0:19:48 | 0:09:00 | 30:24:06 | ||
55 | 33 | 4.7 | Moderate | 6/22/24 1:24 PM | 6/22/24 2:06 PM | 0:42:18 | 0:09:00 | 31:06:24 | ||
56 | 34 | 3.1 | Easy | 6/22/24 2:06 PM | 6/22/24 2:34 PM | 0:27:54 | 0:09:00 | 31:34:18 | ||
57 | 35 | 5.1 | Moderate | 6/22/24 2:34 PM | 6/22/24 3:20 PM | 0:45:54 | 0:09:00 | 32:20:12 | ||
58 | 36 | 3.5 | Easy | 6/22/24 3:20 PM | 6/22/24 3:51 PM | 0:31:30 | 0:09:00 | 32:51:42 | Time Trial | |
59 | Projected Total Time | |||||||||
60 | = 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 | ||||||||
61 | ||||||||||
62 | * | ONCE YOU HAVE RCVD YOUR OFFICIAL START TIME, ENTER IT IN CELL D6 ! | ||||||||