PCT Planner Spreadsheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	Stop	Section Start Point	Section End Point	Base Distance	Extra Distance	Section Distance	Base EG	Extra EG	Section EG	Base Hiking Days	Extra On-Trail Days	Section Hiking Days	Arrival Date	Arrival DOW	Town Layover Days	Departure Date	Departure DOW	Average Distance/day	Average EG/day	Pace	Hiking Hours	EG Comp	Exit Point	Exit Walk	Exit Ride	PrevSection

2	TRUE		US/Mexico Border												start date:	4/15/2014	Tue			2.5	8	45
3	TRUE	US/Mexico Border	Lake Morena Campground	20.6	0	20.6	2310	0	2310	1.2465625	0	1.2465625	4/16/2014	Wed	0.7534375	4/17/2014	Thu	16.52544497	1853.096014	2.5	8	45	Lake Morena Campground			2
4	TRUE	Lake Morena Campground	Highway 8	5.4	0	5.4	195	0	195	0.28828125	0	0.28828125	4/17/2014	Thu	0.71171875	4/18/2014	Fri	18.73170732	676.4227642	2.5	8	45	Highway 8 crossing			3
5	TRUE	Highway 8	Mt. Laguna	16.3	0	16.3	3065	0	3065	1.10234375	0	1.10234375	4/19/2014	Sat	0.89765625	4/20/2014	Sun	14.78667612	2780.439405	2.5	8	45	Desert View Picnic Area			4
6	TRUE	Mt. Laguna	Julian	35.3	0	35.3	934	0	934	1.8525625	0	1.8525625	4/21/2014	Mon	0.1474375	4/22/2014	Tue	19.05468776	504.1665261	2.5	8	45	Highway 78 crossing		12	5
7	TRUE	Julian	Warner Springs	32	0	32	2633	0	2633	1.84684375	0	1.84684375	4/23/2014	Wed	0.15315625	4/24/2014	Thu	17.32685832	1425.675561	2.5	8	45	Highway 79 (south crossing)		1.2	6
8	TRUE	Warner Springs	Anza	41.7	0	41.7	4935	0	4935	2.54765625	0	2.54765625	4/26/2014	Sat	0.45234375	4/27/2014	Sun	16.36798528	1937.074517	2.5	8	45	Highway 74 crossing		2	7
9	TRUE	Anza	Idyllwild	27.3	0	29.9	5276	0	5276	1.859625	0	1.859625	4/28/2014	Mon	0.140375	4/29/2014	Tue	16.07851045	2837.131142	2.5	8	45	Saddle Junction, Devil's Slide trail	2.6	2.6	8
10	TRUE	Idyllwild	Interstate 10	31	0	33.6	1860	0	1860	1.724375	0	1.724375	4/30/2014	Wed	0.275625	5/1/2014	Thu	19.48532077	1078.651685	2.5	8	45	Interstate 10 crossing			9
11	TRUE	Interstate 10	Ziggy and the Bear	1.5	0	1.7	330	0	330	0.1059375	0	0.1059375	5/1/2014	Thu	0.8940625	5/2/2014	Fri	16.04719764	3115.044248	2.5	8	45	(Near PCT)	0.2		10
12	TRUE	Ziggy and the Bear	Big Bear City	63	0	63.2	10117	0	10117	4.09846875	0	4.09846875	5/6/2014	Tue	0.90153125	5/7/2014	Wed	15.42039329	2468.482894	2.5	8	45	Highway 18 crossing		5.4	11
13	TRUE	Big Bear City	Highway 173 (south crossing)	39	0	39	880	0	880	2.0325	0	2.0325	5/9/2014	Fri	0.9675	5/10/2014	Sat	19.18819188	432.9643296	2.5	8	45	Highway 173 crossing			12
14	TRUE	Highway 173 (south crossing)	Highway 138 (near I-15)	15.5	0	15.5	855	0	855	0.85515625	0	0.85515625	5/10/2014	Sat	0.14484375	5/11/2014	Sun	18.12534259	999.8172849	2.5	8	45	Highway 138 crossing			13
15	TRUE	Highway 138 (near I-15)	Best Western Inn	13.5	0	13.5	1035	0	1035	0.77203125	0	0.77203125	5/11/2014	Sun	0.22796875	5/12/2014	Mon	17.4863388	1340.619308	2.5	8	45	Interstate 15 crossing		0.5	14
16	TRUE	Best Western Inn	Wrightwood	21.5	0	25.1	5320	0	5320	1.57375	0	1.57375	5/13/2014	Tue	0.42625	5/14/2014	Wed	15.949166	3380.460683	2.5	8	45	Acorn Trail Junction	3.6		15
17	TRUE	Wrightwood	Acton	80.6	0	84.2	9233	0	9233	4.89559375	0	4.89559375	5/18/2014	Sun	0.10440625	5/19/2014	Mon	17.19913953	1885.981654	2.5	8	45	Soledad Canyon Road crossing		5.9	16
18	TRUE	Acton	Agua Dulce	10.2	0	10.2	1382	0	1382	0.6395625	0	0.6395625	5/19/2014	Mon	0.3604375	5/20/2014	Tue	15.94840223	2160.852145	2.5	8	45	(on trail)			17
19	TRUE	Agua Dulce	Green Valley/Andersons	24.2	0	24.2	3120	0	3120	1.5025	0	1.5025	5/21/2014	Wed	0.4975	5/22/2014	Thu	16.10648918	2076.539101	2.5	8	45	San Francisquito Canyon Road crossing		2	18
20	TRUE	Green Valley/Andersons	Lake Hughes	7.7	0	7.7	890	0	890	0.4684375	0	0.4684375	5/22/2014	Thu	0.5315625	5/23/2014	Fri	16.43762508	1899.933289	2.5	8	45	Lake Hughes Road crossing		2.1	19
21	TRUE	Lake Hughes	Hiker Town	32.1	0	32.1	3555	0	3555	1.93828125	0	1.93828125	5/24/2014	Sat	0.06171875	5/25/2014	Sun	16.56106409	1834.099154	2.5	8	45	Highway 138 crossing			20
22	TRUE	Hiker Town	Mojave	39.9	0	39.9	3862	0	3862	2.3570625	0	2.3570625	5/27/2014	Tue	0.6429375	5/28/2014	Wed	16.92784981	1638.4801	2.5	8	45	Willow Springs Road crossing		11.5	21
23	TRUE	Mojave	Highway 58 (California)	8.3	0	8.3	701	0	701	0.48071875	0	0.48071875	5/28/2014	Wed	0.51928125	5/29/2014	Thu	17.26581291	1458.233114	2.5	8	45	Highway 58 crossing			22
24	TRUE	Highway 58 (California)	Onyx	85.4	0	85.4	8341	0	8341	5.05196875	0	5.05196875	6/3/2014	Tue	0.94803125	6/4/2014	Wed	16.90430092	1651.039508	2.5	8	45	Highway 178 crossing		17.7	23
25	TRUE	Onyx	Kennedy Meadows Store	50.8	0	50.8	6969	0	6969	3.19334375	0	3.19334375	6/7/2014	Sat	0.80665625	6/8/2014	Sun	15.90809007	2182.351963	2.5	8	45	Sherman Pass Road crossing		0.5	24
26	TRUE	Kennedy Meadows Store	Lone Pine	42	0	43.7	7512	0	7512	2.80425	0	2.80425	6/10/2014	Tue	0.19575	6/11/2014	Wed	15.58348935	2678.791121	2.5	8	45	Trail Pass Junction	1.7	18	25
27	TRUE	Lone Pine	Independence	45.4	0	54.4	6775	0	6775	2.90515625	0	2.90515625	6/13/2014	Fri	0.09484375	6/14/2014	Sat	18.72532674	2332.060453	2.5	8	45	Kearsarge Pass Trail Junction	7.3	13	26
28	TRUE	Independence	Muir Trail Ranch	66	0	74.8	10941	0	10941	4.32571875	0	4.32571875	6/18/2014	Wed	0.67428125	6/19/2014	Thu	17.29192403	2529.290653	2.5	8	45	Muir Trail Ranch (south junction)	1.5		27
29	TRUE	Muir Trail Ranch	Vermillion Valley Resort	21	0	24	3950	0	3950	1.4203125	0	1.4203125	6/20/2014	Fri	0.5796875	6/21/2014	Sat	16.89768977	2781.078108	2.5	8	45	Ferry Trail	1.5	4	28
30	TRUE	Vermillion Valley Resort	Reds Meadow	29.4	0	31.2	4484	0	4484	1.890375	0	1.890375	6/22/2014	Sun	0.109625	6/23/2014	Mon	16.50466177	2372.016134	2.5	8	45	Reds Meadow Trail	0.3		29
31	TRUE	Reds Meadow	Tuolumne Meadows	36.1	0	36.7	4626	0	4626	2.2386875	0	2.2386875	6/25/2014	Wed	0.7613125	6/26/2014	Thu	16.39353416	2066.389346	2.5	8	45	Highway 120 crossing	0.3		30
32	TRUE	Tuolumne Meadows	Bridgeport	75.6	0	75.9	12250	0	12250	4.9284375	0	4.9284375	6/30/2014	Mon	0.0715625	7/1/2014	Tue	15.40041849	2485.574789	2.5	8	45	via Highway 108 crossing (Sonora Pass)		31	31
33	TRUE	Bridgeport	Markleeville	31.6	0	31.6	3880	0	3880	1.94375	0	1.94375	7/2/2014	Wed	0.05625	7/3/2014	Thu	16.25723473	1996.141479	2.5	8	45	via Highway 4 crossing		17	32
34	TRUE	Markleeville	South Lake Tahoe	43.1	0	43.1	3470	0	3470	2.4803125	0	2.4803125	7/5/2014	Sat	0.5196875	7/6/2014	Sun	17.37684264	1399.017261	2.5	8	45	via Highway 50 crossing		12	33
35	TRUE	South Lake Tahoe	Echo Lake Resort	1.5	0	1.5	305	0	305	0.10359375	0	0.10359375	7/6/2014	Sun	0.89640625	7/7/2014	Mon	14.47963801	2944.193062	2.5	8	45	(on trail)			34
36	TRUE	Echo Lake Resort	Soda Springs	61.3	0	61.3	7746	0	7746	3.7911875	0	3.7911875	7/10/2014	Thu	0.2088125	7/11/2014	Fri	16.16907631	2043.1593	2.5	8	45	Highway 40 crossing		3.5	35
37	TRUE	Soda Springs	Interstate 80	3	0	3	100	0	100	0.159375	0	0.159375	7/11/2014	Fri	0.840625	7/12/2014	Sat	18.82352941	627.4509804	2.5	8	45	Interstate 80 crossing			36
38	TRUE	Interstate 80	Sierra City	38.8	0	38.8	3060	0	3060	2.226875	0	2.226875	7/14/2014	Mon	0.773125	7/15/2014	Tue	17.42351951	1374.12293	2.5	8	45	Highway 49 crossing		1.4	37
39	TRUE	Sierra City	Quincy	72.6	0	72.6	9397	0	9397	4.51096875	0	4.51096875	7/19/2014	Sat	0.48903125	7/20/2014	Sun	16.09410395	2083.144557	2.5	8	45	Bucks Lake Rd. crossing		12	38
40	TRUE	Quincy	Belden	19	0	19	1479	0	1479	1.08865625	0	1.08865625	7/21/2014	Mon	0.91134375	7/22/2014	Tue	17.45270833	1358.555559	2.5	8	45	(on trail)			39
41	TRUE	Belden	Highway 70	0.1	0	0.1	20	0	20	0.006875	0	0.006875	7/22/2014	Tue	0.993125	7/23/2014	Wed	14.54545455	2909.090909	2.5	8	45	Highway 70 crossing			40
42	TRUE	Highway 70	Chester	46.5	0	46.5	6905	0	6905	2.97234375	0	2.97234375	7/25/2014	Fri	0.02765625	7/26/2014	Sat	15.64422015	2323.082584	2.5	8	45	Highway 36 crossing		7.5	41
43	TRUE	Chester	Drakesbad Guest Ranch	17.5	0	17.5	2140	0	2140	1.075625	0	1.075625	7/27/2014	Sun	0.924375	7/28/2014	Mon	16.26961069	1989.540965	2.5	8	45	(on trail)			42
44	TRUE	Drakesbad Guest Ranch	Old Station	24.4	0	24.7	1265	0	1265	1.33859375	0	1.33859375	7/29/2014	Tue	0.66140625	7/30/2014	Wed	18.4522003	945.0215945	2.5	8	45	Old Station access trail	0.3		43
45	TRUE	Old Station	Highway 44	4.1	0	4.4	150	0	150	0.2190625	0	0.2190625	7/30/2014	Wed	0.7809375	7/31/2014	Thu	20.08559201	684.7360913	2.5	8	45	Highway 44 crossing			44
46	TRUE	Highway 44	Burney	34.1	0	34.1	1292	0	1292	1.826125	0	1.826125	8/1/2014	Fri	0.173875	8/2/2014	Sat	18.67342049	707.5090698	2.5	8	45	Highway 299 crossing		7.7	45
47	TRUE	Burney	Highway 89	6.7	0	6.7	15	0	15	0.33640625	0	0.33640625	8/2/2014	Sat	0.66359375	8/3/2014	Sun	19.91639573	44.58894566	2.5	8	45	Highway 89 crossing			46
48	TRUE	Highway 89	Burney Falls SP	1	0	1	0	0	0	0.05	0	0.05	8/3/2014	Sun	0.95	8/4/2014	Mon	20	0	2.5	8	45	(on trail)			47
49	TRUE	Burney Falls SP	Castella	82.9	0	82.9	8000	0	8000	4.895	0	4.895	8/8/2014	Fri	0.105	8/9/2014	Sat	16.93564862	1634.320735	2.5	8	45	Interstate 5 crossing		2	48
50	TRUE	Castella	Highway 3	59.7	0	59.7	6535	0	6535	3.59765625	0	3.59765625	8/12/2014	Tue	0.40234375	8/13/2014	Wed	16.59413681	1816.460369	2.5	8	45	Highway 3 crossing			49
51	TRUE	Highway 3	Etna	40.1	0	40.1	4609	0	4609	2.43709375	0	2.43709375	8/15/2014	Fri	0.56290625	8/16/2014	Sat	16.45402439	1891.186993	2.5	8	45	Sawyers Bar Road		10.4	50
52	TRUE	Etna	Seiad Valley	55.8	0	55.8	4165	0	4165	3.18046875	0	3.18046875	8/19/2014	Tue	0.81953125	8/20/2014	Wed	17.54458364	1309.555392	2.5	8	45	(on trail)			51
53	TRUE	Seiad Valley	Callahan's Lodge	64.2	0	64.2	10002	0	10002	4.1476875	0	4.1476875	8/24/2014	Sun	0.8523125	8/25/2014	Mon	15.47850459	2411.46422	2.5	8	45	Old Highway 99		0.8	52
54	TRUE	Callahan's Lodge	Ashland	0.3	0	0.3	0	0	0	0.015	0	0.015	8/25/2014	Mon	0.985	8/26/2014	Tue	20	0	2.5	8	45	Interstate 5 crossing		13	53
55	TRUE	Ashland	Highway 66	17.3	0	17.3	1710	0	1710	1.0253125	0	1.0253125	8/27/2014	Wed	0.9746875	8/28/2014	Thu	16.8729046	1667.784212	2.5	8	45	Green Springs Summit			54
56	TRUE	Highway 66	Hyatt Lake Resort (aka Camper's Cove)	6.3	0	6.3	939	0	939	0.40303125	0	0.40303125	8/28/2014	Thu	0.59696875	8/29/2014	Fri	15.63154222	2329.84415	2.5	8	45	East Hyatt Lake Rd.		0.8	55
57	TRUE	Hyatt Lake Resort (aka Camper's Cove)	Fish Lake Resort	30.2	0	32.2	2290	0	2290	1.7246875	0	1.7246875	8/30/2014	Sat	0.2753125	8/31/2014	Sun	18.67004892	1327.776771	2.5	8	45	Fish Lake Trail	2		56
58	TRUE	Fish Lake Resort	Highway 140	0.2	0	2.2	40	0	40	0.01375	0	0.01375	8/31/2014	Sun	0.98625	9/1/2014	Mon	160	2909.090909	2.5	8	45	Highway 140 crossing			57
59	TRUE	Highway 140	Crater Lake (Mazama Village)	49.8	0	49.8	4435	0	4435	2.90578125	0	2.90578125	9/3/2014	Wed	0.09421875	9/4/2014	Thu	17.1382481	1526.267678	2.5	8	45	Highway 62 crossing		2	58
60	TRUE	Crater Lake (Mazama Village)	Highway 138 (Oregon)	22.1	0	22.1	1912	0	1912	1.28425	0	1.28425	9/5/2014	Fri	0.71575	9/6/2014	Sat	17.20848744	1488.806697	2.5	8	45	Highway 138 crossing			59
61	TRUE	Highway 138 (Oregon)	Forest Road 60	30.4	0	30.4	2810	0	2810	1.7834375	0	1.7834375	9/7/2014	Sun	0.2165625	9/8/2014	Mon	17.04573331	1575.608901	2.5	8	45	Forest Road 60 crossing			60
62	TRUE	Forest Road 60	Shelter Cove Resort	29.3	0	31.5	2280	0	2280	1.67875	0	1.67875	9/9/2014	Tue	0.32125	9/10/2014	Wed	18.76396128	1358.153388	2.5	8	45	Shelter Cove Trail	2.2		61
63	TRUE	Shelter Cove Resort	Highway 58 (Oregon)	1.8	0	4	127	0	127	0.10190625	0	0.10190625	9/10/2014	Wed	0.89809375	9/11/2014	Thu	39.25176326	1246.243484	2.5	8	45	Highway 58 crossing			62
64	TRUE	Highway 58 (Oregon)	Elk Lake Resort	44.3	0	45.3	3374	0	3374	2.5313125	0	2.5313125	9/13/2014	Sat	0.4686875	9/14/2014	Sun	17.89585442	1332.90536	2.5	8	45	Elk Lake Trail Junction	1		63
65	TRUE	Elk Lake Resort	Sisters	31.2	0	32.2	2360	0	2360	1.78125	0	1.78125	9/15/2014	Mon	0.21875	9/16/2014	Tue	18.07719298	1324.912281	2.5	8	45	Highway 242 crossing		15	64
66	TRUE	Sisters	Big Lake Youth Camp	11.4	0	12.2	1300	0	1300	0.691875	0	0.691875	9/16/2014	Tue	0.308125	9/17/2014	Wed	17.633243	1878.952123	2.5	8	45	Big Lake Youth Camp trail	0.8		65
67	TRUE	Big Lake Youth Camp	Highway 20 (Oregon)	6	0	6.8	130	0	130	0.3121875	0	0.3121875	9/17/2014	Wed	0.6878125	9/18/2014	Thu	21.78178178	416.4164164	2.5	8	45	Highway 20 crossing			66
68	TRUE	Highway 20 (Oregon)	Olallie Lake	46.2	0	46.3	6040	0	6040	2.87625	0	2.87625	9/20/2014	Sat	0.12375	9/21/2014	Sun	16.09734898	2099.956541	2.5	8	45	Olallie Lake	0.1		67
69	TRUE	Olallie Lake	Forest Road 57	30.3	0	30.4	1650	0	1650	1.6696875	0	1.6696875	9/22/2014	Mon	0.3303125	9/23/2014	Tue	18.20699981	988.2088714	2.5	8	45	Forest Road 57 crossing			68
70	TRUE	Forest Road 57	Forest Road 58	8.9	0	8.9	640	0	640	0.505	0	0.505	9/23/2014	Tue	0.495	9/24/2014	Wed	17.62376238	1267.326733	2.5	8	45	Forest Road 58 crossing			69
71	TRUE	Forest Road 58	Highway 26	5	0	5	150	0	150	0.2640625	0	0.2640625	9/24/2014	Wed	0.7359375	9/25/2014	Thu	18.93491124	568.0473373	2.5	8	45	Highway 26 crossing			70
72	TRUE	Highway 26	Government Camp	5	0	5	640	0	640	0.31	0	0.31	9/25/2014	Thu	0.69	9/26/2014	Fri	16.12903226	2064.516129	2.5	8	45	Highway 35 crossing		4.8	71
73	TRUE	Government Camp	Timberline Lodge	5	0	5.2	1805	0	1805	0.41921875	0	0.41921875	9/26/2014	Fri	0.58078125	9/27/2014	Sat	12.40402534	4305.628028	2.5	8	45	Timberline Lodge Trail	0.2		72
74	TRUE	Timberline Lodge	Cascade Locks	47.8	0	48	4140	0	4140	2.778125	0	2.778125	9/29/2014	Mon	0.221875	9/30/2014	Tue	17.27784027	1490.213723	2.5	8	45	(on trail)			73
75	TRUE	Cascade Locks	Wind River Road	34	0	34	5580	0	5580	2.223125	0	2.223125	10/2/2014	Thu	0.776875	10/3/2014	Fri	15.2937869	2509.98032	2.5	8	45	Wind River Road crossing			74
76	TRUE	Wind River Road	Trout Lake	48.8	0	48.8	6790	0	6790	3.0765625	0	3.0765625	10/6/2014	Mon	0.9234375	10/7/2014	Tue	15.86185881	2207.008634	2.5	8	45	Road 23 crossing		13.8	75
77	TRUE	Trout Lake	White Pass	64.9	0	64.9	8452	0	8452	4.037375	0	4.037375	10/11/2014	Sat	0.962625	10/12/2014	Sun	16.07480108	2093.439425	2.5	8	45	Highway 12 crossing		0.5	76
78	TRUE	White Pass	Highway 410 (Chinook Pass)	29.5	0	29.5	3144	0	3144	1.76975	0	1.76975	10/13/2014	Mon	0.23025	10/14/2014	Tue	16.66902105	1776.522108	2.5	8	45	Highway 410 crossing			77
79	TRUE	Highway 410 (Chinook Pass)	Forest Road 52 (Tacoma Pass)	40.2	0	40.2	3646	0	3646	2.3518125	0	2.3518125	10/16/2014	Thu	0.6481875	10/17/2014	Fri	17.09319939	1550.293656	2.5	8	45	Forest Road 52			78
80	TRUE	Forest Road 52 (Tacoma Pass)	Snoqualmie Pass	29.3	0	29.3	2395	0	2395	1.68953125	0	1.68953125	10/18/2014	Sat	0.31046875	10/19/2014	Sun	17.34208823	1417.552946	2.5	8	45	Interstate 90 crossing		0.3	79
81	TRUE	Snoqualmie Pass	Skykomish	74.5	0	74.5	13450	0	13450	4.9859375	0	4.9859375	10/23/2014	Thu	0.0140625	10/24/2014	Fri	14.94202444	2697.586963	2.5	8	45	Highway 2 crossing		16.2	80
82	TRUE	Skykomish	Stehekin	97.8	0	97.8	16860	0	16860	6.470625	0	6.470625	10/30/2014	Thu	0.529375	10/31/2014	Fri	15.11445958	2605.621559	2.5	8	45	High Bridge Campground		11	81
83	TRUE	Stehekin	Highway 20 (Rainy Pass)	19.7	0	19.7	3900	0	3900	1.350625	0	1.350625	11/1/2014	Sat	0.649375	11/2/2014	Sun	14.58583989	2887.552059	2.5	8	45	Highway 20			82
84	TRUE	Highway 20 (Rainy Pass)	Hart's Pass	30.5	0	30.5	5045	0	5045	1.99796875	0	1.99796875	11/3/2014	Mon	0.00203125	11/4/2014	Tue	15.26550403	2525.064519	2.5	8	45	campground			83
85	TRUE	Hart's Pass	Manning Park	39.2	0	39.2	4408	0	4408	2.37325	0	2.37325	11/6/2014	Thu	0.62675	11/7/2014	Fri	16.5174339	1857.368587	2.5	8	45	Highway 3 crossing			84
86
87		Totals:	0	2663.5	0	2714.7	315313	0	315313	162.7355938	0	162.7355938			43.26440625			16.68166095	1937.578576							3569