Recent Hikes: Difference between revisions
Jump to navigation
Jump to search
m (→Past Hikes: add unit removal notes) |
m (fix the query) |
||
| Line 13: | Line 13: | ||
<tab sep=semicolon head=top> | <tab sep=semicolon head=top> | ||
Year;Download | Year;Download | ||
2019;{{#ask: [[Trip Date::>=2019/01/01]] [[Trip Date::<2020/01/01]]|?Hike Time#Hours=Hike Time (hrs)|?How Many Hiked|?On the Hike|?Reported By|?TEHCC Organized | 2019;{{#ask: [[Trip Date::>=2019/01/01]] [[Trip Date::<2020/01/01]]|?Hike Time#Hours=Hike Time (hrs)|?How Many Hiked|?On the Hike|?Reported By|?TEHCC Organized event|?Trail|?Trail distance round trip#mi=Hike Distance (mi)|?Trip Date|format=csv|limit=500|mainlabel=Report Name|offset=0|link=none|bom=yes|filename=2019 TEHCC Hike Reports.csv}} | ||
2020;{{#ask: [[Trip Date::>=2020/01/01]] [[Trip Date::<2021/01/01]]|?Hike Time#Hours=Hike Time (hrs)|?How Many Hiked|?On the Hike|?Reported By|?TEHCC Organized | 2020;{{#ask: [[Trip Date::>=2020/01/01]] [[Trip Date::<2021/01/01]]|?Hike Time#Hours=Hike Time (hrs)|?How Many Hiked|?On the Hike|?Reported By|?TEHCC Organized event|?Trail|?Trail distance round trip#mi=Hike Distance (mi)|?Trip Date|format=csv|limit=500|mainlabel=Report Name|offset=0|link=none|bom=yes|filename=2020 TEHCC Hike Reports.csv}} | ||
2021;{{#ask: [[Trip Date::>=2021/01/01]] [[Trip Date::<2022/01/01]]|?Hike Time#Hours=Hike Time (hrs)|?How Many Hiked|?On the Hike|?Reported By|?TEHCC Organized | 2021;{{#ask: [[Trip Date::>=2021/01/01]] [[Trip Date::<2022/01/01]]|?Hike Time#Hours=Hike Time (hrs)|?How Many Hiked|?On the Hike|?Reported By|?TEHCC Organized event|?Trail|?Trail distance round trip#mi=Hike Distance (mi)|?Trip Date|format=csv|limit=500|mainlabel=Report Name|offset=0|link=none|bom=yes|filename=2021 TEHCC Hike Reports.csv}} | ||
</tab> | </tab> | ||
Latest revision as of 15:46, 25 May 2021
Reported hikes since September 1st, 2024[edit]
| Date | Trail(s) | Hike Distance | # of Hikers | Tags | Reported By |
|---|
Past Hikes[edit]
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.