Sample Itinerary Spreedsheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	P
1	Stop #	Arrival Date	Destination	Camp Location	Reservation Info	# Nights	Total $	Activities	Cost per night	Miles From Previous Location	Hours Driving (according to Google Maps)	Miles From Previous Location (calculated)	Hours Driving (calculated)	Excursion	Cost
2	TOTALS:					10	$249.00	$24.90	$26.28	1099					$26.00

3	0	Mar. 1 (Wed.)	Broomfield, CO	Broomfield, CO
4	1	Mar. 1 (Wed.)	Colorado Springs, CO	Cheyenne Mountain State Park Campground 410 JL Ranch Heights Rd. Colorado Springs, CO 80926	<make info green after reservation is made or it's first come/first serve>	3	$123.00	Mar 1 - drive Mar 2 - hike the incline (requires a permit/reservation)? Mar 3 - Garden of the Gods?	$41.00	93	1.5	93	1.6	Tour of Olympic Center	$26.00
5	2	Mar. 4 (Sat.)	Black Mesa State Park, OK	Black Mesa State Park County Rd 325 Kenton, OK 73946	<make info red if action is required>	3	$76.00	Mar 4 - drive Mar 5 - Mar 6 -	$25.33	223	4.0	223	4.0
6	3	Mar. 7 (Tue.)	Little Sahara State Park, OK	Little Sahara State Park U.S. 281 Waynoka, OK 73860	<list info like when the reservation window opens up, add site number and any other info you want after reservation is made>	4	$50.00	Mar 7 - drive, find laundromat Mar 8 - Mar 9 - make reservation for ... Mar 10 -	$12.50	249	4.0	249	4.0
7	4	Mar. 11 (Sat.)	Broomfield, CO	Broomfield, CO						534	8.0	534	8.0
8
9						<a copy of the Apps Script used can be found in: https://docs.google.com/document/d/1GMOEunFD2PbD1RGM5GS930wuoN4r_bm1651BiFdBfnY/edit?usp=sharing >	<make amount green after it clears the bank/credit card>	<put activity ideas in this column, note excursion reservations in green along with required arrival times, note days to do laundry and where, note items in red where action is needed>		<once itinerary is set (or after changes), copy values only from columns L and M to columns J and K. This way the values will be available when you have no internet connection and cannot be calculated. >				<list excursions that cost money, list excursion in green once reservation is made, change cost to green after it is paid>
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100