Announcement

Collapse
No announcement yet.

Peakbagger spreadsheet!

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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 !

    Comment


    • #3
      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.
      Looking for Views!

      Comment


      • #4
        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!
        Last edited by TFR; 07-11-2014, 02:47 PM.
        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
        Past 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

        Comment


        • #5
          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
          Past 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

          Comment


          • #6
            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"

            Comment


            • #7
              Obsessive compulsive.
              Enjoying the journey with my favorite hiking partner.
              Please visit ADKGurl's Blog: 46-High-Peaks

              Comment


              • #8
                Very cool.

                Thanks for sharing

                Comment


                • #9
                  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
                  Past 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

                  Comment


                  • #10
                    Nice effort


                    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.

                    Comment


                    • #11
                      There should be a patch for simply creating the spreadsheet....nice job Dunbar, thanks.
                      Eventually, all things merge into one, and a river runs through it.The river was cut by the world's great flood and runs over rocks from the basement of time. On some of the rocks are timeless raindrops. Under the rocks are the words, and some of the words are theirs. I am haunted by waters.

                      Comment


                      • #12
                        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

                        Comment


                        • #13
                          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.
                          Looking for Views!

                          Comment


                          • #14
                            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
                            Past 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

                            Comment


                            • #15
                              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

                              Comment

                              Working...
                              X