Hiking Melbourne - DIN 33466 Calculation

	B	C	D	F	G	H	J	K	L	M	N	O
1	DIN 33466 - Calculation of Hiking Times

2
3	There are a bunch of ways out there in order the calculate a hiking trip might take: AMC Book Time, SAC, Swiss sign-posts and German sign-posts are all based on different formulas. You can find a couple of online tools which can calculate rough estimates for your hiking time, however they are always based on total distance and ascent. As soon as your hike goes up and down, you're stuffed. This Spreadsheet can calculate the hiking times based on the German Norm DIN 334466 sign-posts for trails. You only need to input a basic data-set which includes latitude, longitude and elevation per point. You can get that from recorded GPS tracks or Garmin Basecamp. If you have recorded tracks yourself, you can use them to fine-tune the parameters to your fitness. E.g. with a medium pack (17kg) I use Ascent 500 m/h, Descent 600 m/h and Speed 4.5 km/h which works very well. The summary is similar to the output of Garmin Basecamp for tracks and routes with some additional information
4
5	Summary
6
7	General			Time			Elevation
8	Points		152	Walking Time	[d:h:m]	13:33	Min	[m]	1118	Ascent	[m]	868.5
9	Distance Ascent	[km]	14422.71	Ascent	[d:h:m]	08:03	Max	[m]	1945	Descent	[m]	208.0
10	Distance Descent	[km]	14421.10	Descent	[d:h:m]	05:29	Grade	[%]	0.0%	(overall between 1st and last point)
11	Distance Total	[km]	28843.80				Avg Grade Ascent	[%]	0.0%
12				Speed			Avg Grade Descent	[%]	0.0%
13				Avg	[km/h]	4.00
14	Parameters			Avg Ascent	[km/h]	4.00
15		Ascent [m/h]	300	Avg Descent	[km/h]	4.00
16		Descent [m/h]	500
17		Horizontal [km/h]	4		Instructions
18					• Create a spreadsheet (csv, xlsx or similar) from your GPX
19					e.g. in Garmin Basecamp select the track >> File > Export > Export Selection
20					• Reduce it to the columns "Latitude [ddd.dddd], Longitude [ddd.dddd], Elevation [m]"
21					• Copy the data into the according columns A to C in the tab DATA INPUT
22					• Adjust parameters if required
23					DIN Standard is Ascent: 300 m/h, Descent: 500 m/h, Horizontal: 4 km/h
24
25					Notes
26					• Break times are NOT included
27					• The spreadsheet can handle up to 10000 points
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