Recent Hikes: Difference between revisions
Jump to navigation
Jump to search
m (doesn't like forced units, no show) |
m (→Past Hikes: add unit removal notes) |
||
| Line 10: | Line 10: | ||
}} | }} | ||
== Past Hikes == | == Past Hikes == | ||
'''Note!''' If you plan to do data analysis (Pivot Tables, sums, math in general), edit the CSV in notepad to find & replace the units with nothing, then save it before opening in Excel. i.e. find " Hours" and replace with "". Ensure to include removing the space so Excel interprets it as a number. I tried to format the export but I can't combine a forced units selection for consistency (some may report 45m hike vs. 0.75hrs) along with omitting the units. | |||
<tab sep=semicolon head=top> | <tab sep=semicolon head=top> | ||
Year;Download | Year;Download | ||
Revision as of 15:17, 25 May 2021
Reported hikes since September 1st, 2024
| Date | Trail(s) | Hike Distance | # of Hikers | Tags | Reported By |
|---|
Past Hikes
Note! If you plan to do data analysis (Pivot Tables, sums, math in general), edit the CSV in notepad to find & replace the units with nothing, then save it before opening in Excel. i.e. find " Hours" and replace with "". Ensure to include removing the space so Excel interprets it as a number. I tried to format the export but I can't combine a forced units selection for consistency (some may report 45m hike vs. 0.75hrs) along with omitting the units.