Recent Hikes: Difference between revisions
Jump to navigation
Jump to search
m (tweak date format) |
m (fix the query) |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
== Reported hikes since {{#time: F 1<sup>st</sup>, Y | - | == Reported hikes since {{#time: F 1"<sup>st</sup>", Y | -2 month}} == | ||
{{Trip Report Table | {{Trip Report Table | ||
|userreport = | |userreport = | ||
| Line 5: | Line 5: | ||
|park = | |park = | ||
|trail = | |trail = | ||
|dateStart = {{#time: 1 F Y | - | |dateStart = {{#time: 1 F Y | -2 month}} | ||
|dateEnd = | |dateEnd = | ||
|ShowClubOnly = | |ShowClubOnly = | ||
}} | }} | ||
== 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> | |||
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 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 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 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> | |||
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.