Peakbagger spreadsheet!

[PA Ridgerunner]

Too cool, Steve!

Spent a couple hours adding hikes last night. Need to check my work, but the stats for my CAT3500 show 34, when I have only hiked 32 of the 39. I thought it might have to do with duplicates, but there are 5 that I've done twice, including 2 of those that you are required to climb twice.

[Dunbar]

Originally Posted by PA Ridgerunner

I thought it might have to do with duplicates, but there are 5 that I've done twice, including 2 of those that you are required to climb twice.

Glad you like it! For the Catskill stats, I made the % out of 39 - all the 35 plus the 4 you have to do in winter. So it counts the number of "X"s in each of the 35 cells of Column A (on the Cat3500 sheet). Then it looks at the specific cells in the Winter column (Column L) for the 4 peaks you have to climb in winter. So it needs to find a total of 39 "X"s for the Catskill list to reach 100%.

If you hike one of the 4 required "winter" peaks, you would actually receive two "X"s, one in the Completed column and one in the Winter column. So you could climb it once in winter but have it counted twice toward the 39 total. I don't recall what the actual rules are for the Catskill 3500 club - if you just hiked them all once in winter would you be eligible for the club? Or do you actually have to hike those 4 peaks twice no matter what?

I hope that makes sense...

[PA Ridgerunner]

Originally Posted by Dunbar

...If you hike one of the 4 required "winter" peaks, you would actually receive two "X"s, one in the Completed column and one in the Winter column. So you could climb it once in winter but have it counted twice toward the 39 total. I don't recall what the actual rules are for the Catskill 3500 club - if you just hiked them all once in winter would you be eligible for the club? Or do you actually have to hike those 4 peaks twice no matter what?

I hope that makes sense...

Yup. That's exactly why my total is inflated by two. I have climbed Panther and Slide one time each (in winter), but it is counting them each twice.

To answer your questions, you have to hike all four designated winter peaks twice (at least once in winter). You could do them all in winter, but would still need to hike the "four" twice.

Thanks again --awesome support of my hiking geekdom.

[Trail Boss]

There's an app for that.
http://www.onebadant.com/solutions/89-app-solutions/81

Not as comprehensive as Dunbar's excellent contribution but it does have a peak-finding feature I had described in my theoretical ”Hiking Assistant 2.0”.

I guess the next step is to slap a QR code on each summit so you can log it more conveniently.

[nangaparbat]

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.

Maybe they were working on a Grid.....

[Trail Boss]

Originally Posted by TFR

Yup.

And there are several patches that are not visible, or that need to be sewed on!

Precisely!

Your "spreadsheet" is your backpack. The sweet irony is its name, haiku. In this case, the 'visual haiku' of juxtaposing the images of a spreadsheet, filled with hard lifeless numbers, and a backpack lovingly covered in soft colorful mementos.

[PA Ridgerunner]

Originally Posted by Trail Boss

Precisely!

Your "spreadsheet" is your backpack. The sweet irony is its name, haiku. In this case, the 'visual haiku' of juxtaposing the images of a spreadsheet, filled with hard lifeless numbers, and a backpack lovingly covered in soft colorful mementos.

The pack actually belongs to Tom's lovely bride.

[Dunbar]

That's weird, Rik must have forgotten to hit the Thanks button.

[Raymond]

Now, how do we go about adding 3000-footers?

[Dunbar]

Originally Posted by Raymond

Now, how do we go about adding 3000-footers?

Given the amount of time it would take, I would get started with a bottle of rum.