ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Ryan Jordan's Trip Planning Spreadsheet NotesNote: License to download an exact copy of this spreadsheet is available to enrolled masterclass participants.
2
3
Source:by Ryan Jordan
4
Copyright (C) 2019 by Beartooth Media Group, Inc. (dba Backpacking Light / backpackinglight.com); OK to use and modify for noncommercial personal use but please don't distribute without attribution and a link back to this URL.
5
Description:This spreadsheet describes a case study for a mixed on/off trail trek through the high mountains of the Absaroka-Beartooth Wilderness in Montana during the fall season in inclement conditions.
6
7
Create your own version of this: on any sheet, "Select All" > "Copy" > paste into your own Google Sheet, or click File > Download > ExcelMasterclass participants are welcome to submit comments and interact with me. Sign up for the Masterclass, support online education that is authoritative and truthful, and learn some advanced skills that will make you a smarter hiker, especially in inclement conditions.
8
Shaded cells contain calculated values, don't enter data into any shaded cells.Hover over cells that have a little triangle marker in the top right corner to see more commentary.
9
10
Tab NameDescription
11
12
Trip Infolocale, weather, and snowpack information
13
Routedetailed route information for each leg incl mileage, elevation, terrain, energy requirements, and hiking time
14
Itineraryday-by-day itinerary information
15
Gear Listtotal gear inventory with kit selectors for this trip
16
Food Planningfood ingredient inventory, quantities, caloric density, macronutrients
17
Body Fat Analysisusing body fat as a predictor for caloric reserves, double-checking food planning with expected body weight loss
18
Pack Weight Summarysummary of worn/carried, base, consumables, skin out weight, etc.
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