Peakbagger spreadsheet!

Dunbar · 04-11-2012, 04:44 PM

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.

AlpineLamb · 04-11-2012, 05:57 PM

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???

Trail Boss · 04-11-2012, 06:17 PM

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.

TFR · 04-11-2012, 06:38 PM

Quote:

Originally Posted by Trail Boss

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 being their own 'protection'.

And oh yeah, amazing effort Dunbar! I bow before your spreadsheet prowess!

TFR · 04-11-2012, 06:43 PM

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!

QuietHikergirlJ · 04-11-2012, 07:23 PM

Very Cool Spreadsheet, also lets me know what there are patches for.

Jeanne

DackerDan · 04-11-2012, 07:35 PM

Obsessive compulsive.

Foottraffic · 04-11-2012, 07:38 PM

Very cool.

Thanks for sharing

TFR · 04-11-2012, 08:02 PM

Quote:

Originally Posted by QuietHikergirlJ

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!

SendHelp · 04-11-2012, 08:56 PM

Nice effort

Quote:

Originally Posted by Trail Boss

Very thorough but it lacks the Mile-High list.

Which Mile-High list? Or is it club?

WinterWarlock · 04-12-2012, 06:32 AM

There should be a patch for simply creating the spreadsheet....nice job Dunbar, thanks.

veggielasagna · 04-12-2012, 07:17 AM

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

Trail Boss · 04-12-2012, 08:01 AM

Quote:

Originally Posted by SendHelp

Which Mile-High list? Or is it club?

Like a club but no one takes minutes at the meetings.

TFR · 04-12-2012, 08:49 AM

Quote:

Originally Posted by Trail Boss

Like a club but no one takes minutes at the meetings.

Did you think it would not exist!

PA Ridgerunner · 04-12-2012, 09:30 AM

Quote:

Originally Posted by TFR

Oh, there are a lot more patches than that!

Go to my Sig for starters!

Tom, you might recognize this, as well.

Trail Boss · 04-12-2012, 09:43 AM

"MHC" flanked by wings? How demure! I'm surprised they don't have a <ahem> cheekier rocker.

Trail Boss · 04-12-2012, 09:49 AM

Do I spy a Kelty Haiku under those rockers?

Quote:

Originally Posted by PA Ridgerunner

Dunbar · 04-12-2012, 10:21 AM

Quote:

Originally Posted by AlpineLamb

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

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

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.

Neil · 04-12-2012, 11:35 AM

Awesome job Dr. Dunbar!

(I bequeathed a PhD upon you for your work)

TFR · 04-12-2012, 12:26 PM

Quote:

Originally Posted by Trail Boss

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!

04-11-2012, 04:44 PM	#1
Dunbar Always Serious. Join Date: Jul 2007 Location: Lebanon, NH Posts: 922	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

04-11-2012, 05:57 PM	#2
AlpineLamb "her sister" Join Date: Jun 2009 Location: Essex County NY Posts: 799	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 !

04-11-2012, 06:43 PM	#5
TFR Peek-Bagger Join Date: Sep 2005 Location: Tillson, NY - Avatar: Whiteface Slide Posts: 5,383	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 - 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

04-11-2012, 07:23 PM	#6
QuietHikergirlJ Consultant Join Date: Mar 2011 Location: Schenectady Posts: 172	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"

04-11-2012, 07:35 PM	#7
DackerDan Commander Join Date: Jul 2011 Location: Nisky, NY Posts: 1,294	Obsessive compulsive. __________________ Enjoying the journey with my favorite hiking partner. Please visit ADKGurl's Blog: 46-High-Peaks

04-11-2012, 06:17 PM	#3
Trail Boss Ascender Join Date: Apr 2010 Location: Montreal, QC Posts: 1,885	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.

04-11-2012, 07:38 PM	#8
Foottraffic What's next? Join Date: Aug 2009 Location: Nothern New Jersey Posts: 322	Very cool. Thanks for sharing

04-12-2012, 06:32 AM	#11
WinterWarlock Commander Join Date: Jan 2007 Location: Rochester, NY Posts: 1,832	There should be a patch for simply creating the spreadsheet....nice job Dunbar, thanks. __________________ ADK High Peaks Wiki Enjoy Every Sandwich!

04-12-2012, 07:17 AM	#12
veggielasagna Consultant Join Date: May 2011 Posts: 207	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

04-12-2012, 09:43 AM	#16
Trail Boss Ascender Join Date: Apr 2010 Location: Montreal, QC Posts: 1,885	"MHC" flanked by wings? How demure! I'm surprised they don't have a <ahem> cheekier rocker.

04-12-2012, 11:35 AM	#19
Neil Enjoying Wellness Join Date: Apr 2005 Location: Montreal Posts: 8,377	Awesome job Dr. Dunbar! (I bequeathed a PhD upon you for your work)

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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode