Editing Recent Hikes

Jump to navigation Jump to search

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
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
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}}
2019;{{#ask: [[Trip Date::>=2019/01/01]] [[Trip Date::<2020/01/01]]|?Hike Time#-n=Hike Time (hrs)|?How Many Hiked|?On the Hike|?Reported By|?TEHCC Organized ent|?Trail|?Trail distance round trip|?Trip Date|format=csv|limit=500|mainlabel=Report Name|offset=0|link=none|bom=yes}}
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}}
2020;{{#ask: [[Trip Date::>=2020/01/01]] [[Trip Date::<2021/01/01]]|?Hike Time#-n=Hike Time (hrs)|?How Many Hiked|?On the Hike|?Reported By|?TEHCC Organized ent|?Trail|?Trail distance round trip|?Trip Date|format=csv|limit=500|mainlabel=Report Name|offset=0|link=none|bom=yes}}
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}}
2021;{{#ask: [[Trip Date::>=2021/01/01]] [[Trip Date::<2022/01/01]]|?Hike Time#-n=Hike Time (hrs)|?How Many Hiked|?On the Hike|?Reported By|?TEHCC Organized ent|?Trail|?Trail distance round trip|?Trip Date|format=csv|limit=500|mainlabel=Report Name|offset=0|link=none|bom=yes}}
</tab>
</tab>
Please note that all contributions to TEHCC Wiki may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see TEHCC Wiki:Copyrights for details). Do not submit copyrighted work without permission!

To edit this page, please answer the question that appears below (more info):

Cancel Editing help (opens in new window)