2022 Wild Rogue Relay Finish Time Estimator

	B	C	D	E	F	G	H	I	J	K	L	M
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	LEG	No cell service	RUNNER	LEG 1 DIST	RATING	TOTAL MILEAGE	Elevation gain/loss	LEG START TIME	LEG FINISH TIME	LEG TIME	MIN/MILE	TOTAL TIME
7	1	X		6.00	Moderate	6.00	350 / -673	6/18/2021 8:00:00	6/18/21 8:54 AM	0:54:00	0:09:00	0:54:00
8	2	X		6.20	Moderate	12.20	1125 / -94	6/18/21 8:54 AM	6/18/21 9:49 AM	0:55:48	0:09:00	1:49:48
9	3	X		4.00	Easy	16.20	337 / -1050	6/18/21 9:49 AM	6/18/21 10:25 AM	0:36:00	0:09:00	2:25:48
10	4	X		4.00	Easy	20.20	86 / -385	6/18/21 10:25 AM	6/18/21 11:01 AM	0:36:00	0:09:00	3:01:48
11	5			5.10	Moderate	25.30	146 / -379	6/18/21 11:01 AM	6/18/21 11:47 AM	0:45:54	0:09:00	3:47:42
12	6			6.20	Challenging	31.50	1041 / -1152	6/18/21 11:47 AM	6/18/21 12:43 PM	0:55:48	0:09:00	4:43:30
13				31.50
14	VAN # 2
15	LEG		RUNNER	LEG 1 DIST	RATING	TOTAL MILEAGE		LEG START TIME	LEG FINISH TIME	LEG TIME	MIN/MILE	TOTAL TIME
16	7			3.40	Easy	34.90	127 / -174	6/18/21 12:43 PM	6/18/21 1:14 PM	0:30:36	0:09:00	5:14:06
17	8			6.60	Moderate	41.50	327 / -359	6/18/21 1:14 PM	6/18/21 2:13 PM	0:59:24	0:09:00	6:13:30
18	9			6.90	Moderate	48.40	143 / -341	6/18/21 2:13 PM	6/18/21 3:15 PM	1:02:06	0:09:00	7:15:36
19	10			8.90	Challenging	57.30	351 / -478	6/18/21 3:15 PM	6/18/21 4:35 PM	1:20:06	0:09:00	8:35:42
20	11			5.60	Moderate	62.90	243 / -300	6/18/21 4:35 PM	6/18/21 5:26 PM	0:50:24	0:09:00	9:26:06
21	12			8.80	Challenging	71.70	687 / -667	6/18/21 5:26 PM	6/18/21 6:45 PM	1:19:12	0:09:00	10:45:18
22				40.20
23	VAN # 1
24	LEG		RUNNER	LEG 2 DIST	RATING			LEG START TIME	LEG FINISH TIME	LEG TIME	MIN/MILE	TOTAL TIME
25	13			6.00	Moderate	77.70	431 / -516	6/18/21 6:45 PM	6/18/21 7:39 PM	0:54:00	0:09:00	11:39:18
26	14	X		5.50	Moderate	83.20	341 / -418	6/18/21 7:39 PM	6/18/21 8:28 PM	0:49:30	0:09:00	12:28:48
27	15	X		6.10	Moderate	89.30	566 / -496	6/18/21 8:28 PM	6/18/21 9:23 PM	0:54:54	0:09:00	13:23:42
28	16	X		4.50	OMG	93.80	1509 / -256	6/18/21 9:23 PM	6/18/21 10:04 PM	0:40:30	0:09:00	14:04:12
29	17	X		6.40	OMG	100.20	1370 / -443	6/18/21 10:04 PM	6/18/21 11:01 PM	0:57:36	0:09:00	15:01:48
30	18	X		5.70	Challenging	105.90	877 / -605	6/18/21 11:01 PM	6/18/21 11:53 PM	0:51:18	0:09:00	15:53:06
31				34.20
32	VAN # 2
33	LEG		RUNNER	LEG 2 DIST	RATING			LEG START TIME	LEG FINISH TIME	LEG TIME	MIN/MILE	TOTAL TIME
34	19	X		4.70	Challenging	110.60	662 / -434	6/18/21 11:53 PM	6/19/21 12:35 AM	0:42:18	0:09:00	16:35:24
35	20	X		5.30	Challenging	115.90	419 / -638	6/19/21 12:35 AM	6/19/21 1:23 AM	0:47:42	0:09:00	17:23:06
36	21	X		8.80	Challenging	124.70	917 / -1868	6/19/21 1:23 AM	6/19/21 2:42 AM	1:19:12	0:09:00	18:42:18
37	22	X		8.30	Challenging	133.00	458 / -648	6/19/21 2:42 AM	6/19/21 3:57 AM	1:14:42	0:09:00	19:57:00
38	23	X		6.00	Moderate	139.00	212 / -1230	6/19/21 3:57 AM	6/19/21 4:51 AM	0:54:00	0:09:00	20:51:00
39	24	X		4.60	Challenging	143.60	1303 / -59	6/19/21 4:51 AM	6/19/21 5:32 AM	0:41:24	0:09:00	21:32:24
40				37.70
41
42	VAN # 1
43	LEG		RUNNER	DIST	RATING			LEG START TIME	LEG FINISH TIME	LEG TIME	MIN/MILE	TOTAL TIME
44	25	X		8.20	Challenging	151.80	275 / -1750	6/19/21 5:32 AM	6/19/21 6:46 AM	1:13:48	0:09:00	22:46:12
45	26	X		8.40	Challenging	160.20	898 / -1401	6/19/21 6:46 AM	6/19/21 8:01 AM	1:15:36	0:09:00	24:01:48
46	27	X		7.60	Challenging	167.80	793 / -602	6/19/21 8:01 AM	6/19/21 9:10 AM	1:08:24	0:09:00	25:10:12
47	28	X		8.00	Challenging	175.80	687 / -1031	6/19/21 9:10 AM	6/19/21 10:22 AM	1:12:00	0:09:00	26:22:12
48	29	X		4.80	Easy	180.60	403 / -542	6/19/21 10:22 AM	6/19/21 11:05 AM	0:43:12	0:09:00	27:05:24
49	30	X		7.60	Challenging	188.20	424 / -497	6/19/21 11:05 AM	6/19/21 12:13 PM	1:08:24	0:09:00	28:13:48
50				44.60
51
52	VAN # 2
53	LEG		RUNNER	DIST	RATING			LEG START TIME	LEG FINISH TIME	LEG TIME	MIN/MILE	TOTAL TIME
54	31			7.10	Challenging	195.30	821 / -121	6/19/21 12:13 PM	6/19/21 1:17 PM	1:03:54	0:09:00	29:17:42
55	32			4.50	Challenging	199.80	238 / -925	6/19/21 1:17 PM	6/19/21 1:58 PM	0:40:30	0:09:00	29:58:12
56	33			5.60	Moderate	205.40	578 / -426	6/19/21 1:58 PM	6/19/21 2:48 PM	0:50:24	0:09:00	30:48:36
57	34			5.90	Clown Puncher	211.30	935 / -920	6/19/21 2:48 PM	6/19/21 3:41 PM	0:53:06	0:09:00	31:41:42
58	35			3.50	Easy	214.80	384 / -339	6/19/21 3:41 PM	6/19/21 4:13 PM	0:31:30	0:09:00	32:13:12
59	36			5.00	Moderate	219.80	372 / -403	6/19/21 4:13 PM	6/19/21 4:58 PM	0:45:00	0:09:00	32:58:12
60				31.60
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 !	219.80
64
65
66
67