ADKHighPeaks  
Forum Rules Statement of Purpose Membership Disclaimer Site History
Adkhighpeaks Foundation Donations and Online Store Adkhighpeaks Wiki visit ADKForum.com

Go Back   ADKHighPeaks > Hiking > General Hiking Information
Register FAQ Members List Calendar Mark Forums Read

Reply
 
Thread Tools Search this Thread Display Modes
Old 04-11-2012, 04:44 PM   #1
Dunbar
Always Serious.
 
Dunbar's Avatar
 
Join Date: Jul 2007
Location: Lebanon, NH
Posts: 935
Peakbagger spreadsheet!

I know Rik has been eagerly awaiting the newest version of this spreadsheet, so here it is finally!

>> Download here! <<

What does it do?



It's an excel spreadsheet I made that can be used to record your hikes and track your progress on multiple peakbagging lists. I made it mostly for fun but have found it to be fairly useful when I'm working on a peak list. I figure there's some peakbagging types around here that might enjoy it also.

It's simple to use and since the information is stored as an Excel spreadsheet it is easy to manipulate it to get whatver statistics you might want.

To get started, open the spreadsheet and make sure that macros are enabled. Then click on one of the images to add a hike to the log:



Clicking on an image will bring up a new window - here you can enter information about the hike and select the peaks that you climbed.



After hitting the Add Peaks button, the hike is first recorded on the hike log tab:



The data from the newest entry is added to the bottom of the list. This just provides a general description of the hike or anything else you want to remember. Since this is Excel this information can then be manipulated however you want - for example you can see that I added a cell for the total mileage and elevation in 2011.

Now for the good part - for whatever peaks you selected earlier, the peak is marked as completed for all peak lists that the peak is on. So if you selected Mt Washington it is marked as completed on the NH48, New England 67, and NE115 lists. It also looks at what date you entered and records the season and month when you climbed the peak. Lastly it adds the actual ascent date to the spreadsheet.



This provides a nice visual layout of your hiking. Again, you can create custom fields for whatever statistic you want. In the picture below I added cells for Gridiot progress, total number of ascents, and progress on multiple rounds.



Lastly you can flip over to the statistics tab and enjoy all the delicious pies that you see in the first picture!

Some notes:
- Requires macros to run - these may not work on the Mac version of Excel (can anyone confirm?)
- Covers most of the major peakbagging lists in the Northeast
- When checking for what season the hike was in, this spreadsheet uses a fixed date which may not correspond to the rules for a particular list. So if you hiked Mt Washington on March 21st, it may be recorded as a "Winter" climb - however, AMC rules might state that the official "Winter" season ended on the 20th. If this happens, just manually edit the NH48 sheet to reflect the correct season.
__________________
Hike Always.
http://dunbarsm.wordpress.com
Dunbar is offline   Reply With Quote
The Following 19 Users Say Thank You to Dunbar For This Useful Post:
AdkWalrus (04-12-2012), Altbark (04-11-2012), ChrisCNY (04-12-2012), CPalmatier (04-13-2012), DackerDan (04-11-2012), Diane (03-06-2014), elkhiker (04-13-2012), Fiddlehead (04-11-2012), FoulHooked (04-13-2012), Greeneyezz (04-16-2012), JoeCedar (04-12-2012), nangaparbat (04-13-2012), PA Ridgerunner (04-12-2012), Photobug65 (04-15-2012), Scotzman (04-14-2012), SummitHat (04-11-2012), TBPDPTI (04-22-2012), TFR (04-16-2012), yvon (04-11-2012)
Old 04-11-2012, 05:57 PM   #2
AlpineLamb
"her sister"
 
AlpineLamb's Avatar
 
Join Date: Jun 2009
Location: Essex County NY
Posts: 993
I am a 46er
That's fun! a great visual, but wow...you must have dreamed all this up last May as you apparently don't hike in May???
__________________
Think outside...no box required !
AlpineLamb is offline   Reply With Quote
The Following User Says Thank You to AlpineLamb For This Useful Post:
Gandalph (08-29-2014)
Old 04-11-2012, 06:17 PM   #3
Trail Boss
Ascender
 
Trail Boss's Avatar
 
Join Date: Apr 2010
Location: Montreal, QC
Posts: 3,509
I am a 46er I cross post at ADKForum
Very thorough but it lacks the Mile-High list.

I've witnessed at least one couple attempting to achieve 46er MH status. Of course, it could've been Hundred Highest; I didn't ask.

I don't know if a Winter MH list is necessary but you never know. Hikers are a hardy and resourceful lot.
Trail Boss is offline   Reply With Quote
The Following User Says Thank You to Trail Boss For This Useful Post:
Gandalph (08-29-2014)
Old 04-11-2012, 06:38 PM   #4
TFR
Peek-Bagger
 
TFR's Avatar
 
Join Date: Sep 2005
Location: Tillson, NY - Avatar: Whiteface Slide
Posts: 6,166
I am a 46er I am a Catskill 35er I cross post at ADKForum
Quote:
Originally Posted by Trail Boss View Post
Very thorough but it lacks the Mile-High list.

I've witnessed at least one couple attempting to achieve 46er MH status. Of course, it could've been Hundred Highest; I didn't ask.

I don't know if a Winter MH list is necessary but you never know. Hikers are a hardy and resourceful lot.
There is a very limited set of places in NY for MH 'bagging'. All of them are quite 'exposed'. They might have to bring their own 'protection'.

And oh yeah, amazing effort Dunbar! I bow before your spreadsheet prowess!
__________________
Tom Rankin - 5444W "In the depths of Summer, I finally learned that there lay within me an invincible Winter"

Proud Member #0003 of ADKHP Foundation
Volunteer Balsam Lake Mountain
President Catskill 3500 Club
CEO Views And Brews!

Trail maintainer for the Dry Brook Ridge trail from Mill Brook Road to just past the Lean-to

Last edited by TFR; 07-11-2014 at 01:47 PM.
TFR is offline   Reply With Quote
The Following User Says Thank You to TFR For This Useful Post:
Scotzman (04-14-2012)
Old 04-11-2012, 06:43 PM   #5
TFR
Peek-Bagger
 
TFR's Avatar
 
Join Date: Sep 2005
Location: Tillson, NY - Avatar: Whiteface Slide
Posts: 6,166
I am a 46er I am a Catskill 35er I cross post at ADKForum
Looking a little more carefully, isn't that CHH patch non-standard, and that 48W as well?

If you want, I can send you the CHH Patch in digital format.

And there could also be a W67 and a W115 list. I hear there is a W115 patch in the works!
__________________
Tom Rankin - 5444W "In the depths of Summer, I finally learned that there lay within me an invincible Winter"

Proud Member #0003 of ADKHP Foundation
Volunteer Balsam Lake Mountain
President Catskill 3500 Club
CEO Views And Brews!

Trail maintainer for the Dry Brook Ridge trail from Mill Brook Road to just past the Lean-to
TFR is offline   Reply With Quote
Old 04-11-2012, 07:23 PM   #6
QuietHikergirlJ
Consultant
 
QuietHikergirlJ's Avatar
 
Join Date: Mar 2011
Location: Schenectady
Posts: 245
I am a 46er
Very Cool Spreadsheet, also lets me know what there are patches for.



Jeanne
__________________
As defined by Nietzsche in "Conquistadors of the Useless"; "The secret of knowing the most fertile experiences and the greatest joys in life is to live dangerously"
QuietHikergirlJ is offline   Reply With Quote
Old 04-11-2012, 07:35 PM   #7
DackerDan
Commander
 
DackerDan's Avatar
 
Join Date: Jul 2011
Location: Nisky, NY
Posts: 2,156
Obsessive compulsive.
__________________
Enjoying the journey with my favorite hiking partner.
Please visit ADKGurl's Blog: 46-High-Peaks
DackerDan is offline   Reply With Quote
Old 04-11-2012, 07:38 PM   #8
Foottraffic
What's next?
 
Foottraffic's Avatar
 
Join Date: Aug 2009
Location: Nothern New Jersey
Posts: 341
I am a 46er
Very cool.

Thanks for sharing
Foottraffic is offline   Reply With Quote
Old 04-11-2012, 08:02 PM   #9
TFR
Peek-Bagger
 
TFR's Avatar
 
Join Date: Sep 2005
Location: Tillson, NY - Avatar: Whiteface Slide
Posts: 6,166
I am a 46er I am a Catskill 35er I cross post at ADKForum
Quote:
Originally Posted by QuietHikergirlJ View Post
Very Cool Spreadsheet, also lets me know what there are patches for.
Oh, there are a lot more patches than that!

Go to my Sig for starters!
__________________
Tom Rankin - 5444W "In the depths of Summer, I finally learned that there lay within me an invincible Winter"

Proud Member #0003 of ADKHP Foundation
Volunteer Balsam Lake Mountain
President Catskill 3500 Club
CEO Views And Brews!

Trail maintainer for the Dry Brook Ridge trail from Mill Brook Road to just past the Lean-to
TFR is offline   Reply With Quote
Old 04-11-2012, 08:56 PM   #10
SendHelp
Elvis Lives!!!!!
 
SendHelp's Avatar
 
Join Date: Jul 2007
Location: Binghamton, NY
Posts: 484
I am a 46er I am a Catskill 35er
Nice effort


Quote:
Originally Posted by Trail Boss View Post
Very thorough but it lacks the Mile-High list.
Which Mile-High list? Or is it club?
__________________
Smile, things could be worse.
SendHelp is offline   Reply With Quote
Old 04-12-2012, 06:32 AM   #11
WinterWarlock
Commander
 
WinterWarlock's Avatar
 
Join Date: Jan 2007
Location: Rochester, NY
Posts: 1,882
adkhighpeaks Foundation Board of Directors I cross post at ADKForum
There should be a patch for simply creating the spreadsheet....nice job Dunbar, thanks.
__________________
ADK High Peaks Wiki

Enjoy Every Sandwich!
WinterWarlock is offline   Reply With Quote
Old 04-12-2012, 07:17 AM   #12
veggielasagna
Consultant
 
veggielasagna's Avatar
 
Join Date: May 2011
Posts: 252
I am a 46er I cross post at ADKForum
Thanks Dunbar! I have been using the previous version since I started hiking the ADK High Peaks. Great additions, I'll have to look at it more closely this evening
__________________
-veggielasagna
veggielasagna is offline   Reply With Quote
Old 04-12-2012, 08:01 AM   #13
Trail Boss
Ascender
 
Trail Boss's Avatar
 
Join Date: Apr 2010
Location: Montreal, QC
Posts: 3,509
I am a 46er I cross post at ADKForum
Quote:
Originally Posted by SendHelp View Post
Which Mile-High list? Or is it club?
Like a club but no one takes minutes at the meetings.
Trail Boss is offline   Reply With Quote
Old 04-12-2012, 08:49 AM   #14
TFR
Peek-Bagger
 
TFR's Avatar
 
Join Date: Sep 2005
Location: Tillson, NY - Avatar: Whiteface Slide
Posts: 6,166
I am a 46er I am a Catskill 35er I cross post at ADKForum
Quote:
Originally Posted by Trail Boss View Post
Like a club but no one takes minutes at the meetings.
Did you think it would not exist!
__________________
Tom Rankin - 5444W "In the depths of Summer, I finally learned that there lay within me an invincible Winter"

Proud Member #0003 of ADKHP Foundation
Volunteer Balsam Lake Mountain
President Catskill 3500 Club
CEO Views And Brews!

Trail maintainer for the Dry Brook Ridge trail from Mill Brook Road to just past the Lean-to
TFR is offline   Reply With Quote
Old 04-12-2012, 09:30 AM   #15
PA Ridgerunner
Lovin' Life!
 
PA Ridgerunner's Avatar
 
Join Date: Jun 2008
Location: Jay, NY
Posts: 2,947
adkhighpeaks Site Supporter I am a 46er I am a Catskill 35er I cross post at ADKForum
Quote:
Originally Posted by TFR View Post
Oh, there are a lot more patches than that!

Go to my Sig for starters!
Tom, you might recognize this, as well.

__________________
Nature we have always with us, an inexhaustible storehouse of that which moves the heart, appeals to the mind, and fires the imagination - health to the body, a stimulus to the intellect, and a joy to the soul. - John Burroughs
PA Ridgerunner is offline   Reply With Quote
Old 04-12-2012, 09:43 AM   #16
Trail Boss
Ascender
 
Trail Boss's Avatar
 
Join Date: Apr 2010
Location: Montreal, QC
Posts: 3,509
I am a 46er I cross post at ADKForum
"MHC" flanked by wings? How demure! I'm surprised they don't have a <ahem> cheekier rocker.
Trail Boss is offline   Reply With Quote
Old 04-12-2012, 09:49 AM   #17
Trail Boss
Ascender
 
Trail Boss's Avatar
 
Join Date: Apr 2010
Location: Montreal, QC
Posts: 3,509
I am a 46er I cross post at ADKForum
Do I spy a Kelty Haiku under those rockers?

Quote:
Originally Posted by PA Ridgerunner View Post
Trail Boss is offline   Reply With Quote
Old 04-12-2012, 10:21 AM   #18
Dunbar
Always Serious.
 
Dunbar's Avatar
 
Join Date: Jul 2007
Location: Lebanon, NH
Posts: 935
Quote:
Originally Posted by AlpineLamb View Post
That's fun! a great visual, but wow...you must have dreamed all this up last May as you apparently don't hike in May???
I don't hike in May cuz I is skeered of black flies.

Quote:
Originally Posted by WinterWarlock View Post
There should be a patch for simply creating the spreadsheet....nice job Dunbar, thanks.
I don't need a patch. Rik's continued thanks is all the satisfaction I need.

Quote:
Originally Posted by veggielasagna View Post
Thanks Dunbar! I have been using the previous version since I started hiking the ADK High Peaks. Great additions, I'll have to look at it more closely this evening
I don't remember all of what is included in the old version, but you should be able to just copy over the data from the old sheets to the new ones without a problem.
__________________
Hike Always.
http://dunbarsm.wordpress.com
Dunbar is offline   Reply With Quote
The Following User Says Thank You to Dunbar For This Useful Post:
WinterWarlock (04-12-2012)
Old 04-12-2012, 11:35 AM   #19
Neil
Administrator
 
Neil's Avatar
 
Join Date: Apr 2005
Location: Montreal
Posts: 9,762
adkhighpeaks Foundation Board of Directors adkhighpeaks Site Supporter I am a 46er I cross post at ADKForum
Awesome job Dr. Dunbar!

(I bequeathed a PhD upon you for your work)
Neil is offline   Reply With Quote
Old 04-12-2012, 12:26 PM   #20
TFR
Peek-Bagger
 
TFR's Avatar
 
Join Date: Sep 2005
Location: Tillson, NY - Avatar: Whiteface Slide
Posts: 6,166
I am a 46er I am a Catskill 35er I cross post at ADKForum
Quote:
Originally Posted by Trail Boss View Post
Do I spy a Kelty Haiku under those rockers?
Yup.

And there are several patches that are not visible, or that need to be sewed on!
__________________
Tom Rankin - 5444W "In the depths of Summer, I finally learned that there lay within me an invincible Winter"

Proud Member #0003 of ADKHP Foundation
Volunteer Balsam Lake Mountain
President Catskill 3500 Club
CEO Views And Brews!

Trail maintainer for the Dry Brook Ridge trail from Mill Brook Road to just past the Lean-to
TFR is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 02:41 AM.


Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.

DISCLAIMER: Use of these forums, and information found herein, is at your own risk. Use of this site by members and non-members alike is only granted by the Adkhighpeaks Foundation provided the terms and conditions found in the FULL DISCLAIMER have been read. Continued use of this site implies that you have read, understood and agree to the terms and conditions of this site. Any questions can be directed to the Administrator of this site.