Forum
Buying gear? Please use these links to help 14ers.com:

More info...

Other ways to help...

Excel spreadsheet of Colorado 14ers

Items that do not fit the categories above.
User avatar
Posts: 2128
Joined: Sun Nov 18, 2007 8:16 am
Location: Broomfield, Colorado

Re: Excel spreadsheet of Colorado 14ers

Postby d_baker » Mon Nov 04, 2013 8:04 am

Thanks again Bill!
Just one more function with your site that I didn't know about (or I just didn't notice).

Site Administrator
User avatar
Posts: 6368
Joined: Sun Jul 25, 2004 8:34 pm
Location: Breckenridge, CO

Re: Excel spreadsheet of Colorado 14ers

Postby BillMiddlebrook » Mon Nov 04, 2013 8:26 am

You bet!

I also added an Export Peak Names to File link under the "14ers" pull-down menu on the site. That page excludes "what I climbed" options and can be used by visitors who are not registered.

Current formats supported:
KML (Google Earth)
GPX (gps waypoints)
CSV (text/Excel)
"There's no recess and no rules in the school of life" - D. Mustaine

User avatar
Posts: 68
Joined: Mon Dec 05, 2011 9:53 am
Location: Denver

Re: Excel spreadsheet of Colorado 14ers

Postby B-Dog » Mon Nov 04, 2013 1:19 pm

I didn't know you could do that either, neat.

I looked a little more in the peak checklist area but didn't see anything to export/save the notes for each peak. Like many people, I use this site as a journal of sorts, adding in details of each climb. Is there a way to download all that information? I had a friend recently have all of his Sawatch notes disappear. Bill, you got most of it restored for him, but it still makes me nervous and I'd like to have a back-up just in case.

Thanks!

Site Administrator
User avatar
Posts: 6368
Joined: Sun Jul 25, 2004 8:34 pm
Location: Breckenridge, CO

Re: Excel spreadsheet of Colorado 14ers

Postby BillMiddlebrook » Mon Nov 04, 2013 1:55 pm

B-Dog wrote:I didn't know you could do that either, neat.

I looked a little more in the peak checklist area but didn't see anything to export/save the notes for each peak. Like many people, I use this site as a journal of sorts, adding in details of each climb. Is there a way to download all that information? I had a friend recently have all of his Sawatch notes disappear. Bill, you got most of it restored for him, but it still makes me nervous and I'd like to have a back-up just in case.

Thanks!

Good point! I'll add that option to the export on the Update Checklist page
"There's no recess and no rules in the school of life" - D. Mustaine

User avatar
Posts: 466
Joined: Sat Oct 10, 2009 2:26 pm
Location: Sao Paulo, Brazil

Re: Excel spreadsheet of Colorado 14ers

Postby Fisching » Mon Nov 04, 2013 2:30 pm

I shared the spreadsheet I use with the OP, but figured it might be worth uploading to Google Drive in case anyone else is looking for one. I cannot take credit for most of it as the climbing log was something Rob Jansen convinced me to do, and the 14er "grid" sheet was something I download (possibly from LoJ). I created the seasonal one with a few adjustments of the monthly grid and added the highpoints one since I'm in to that sort of thing. I haven't created any sheet for 13ers yet, so consider it a work in progress.

I left some old data in there so some of the equations will calculate for an example. Hope it's useful.

https://docs.google.com/spreadsheet/ccc?key=0AhDAJy6mJRpZdDN1Yk51TDFVYmpVXzIyRlprV1NvOWc&usp=sharing
Peter Aitchison on the risks of rock climbing and mountaineering: "That's life, isn't it? We think the challenge and satisfaction you get from doing this is worth the risks."

"Respect the mountain. Train hard. Hope you can sneak up when it isn't looking."

"The mind is always worried about consequences, but the heart knows no fear. The heart just does what it wants."

User avatar
Posts: 2128
Joined: Sun Nov 18, 2007 8:16 am
Location: Broomfield, Colorado

Re: Excel spreadsheet of Colorado 14ers

Postby d_baker » Mon Nov 04, 2013 6:20 pm

My wish for the export is that it include range and rank.

Site Administrator
User avatar
Posts: 6368
Joined: Sun Jul 25, 2004 8:34 pm
Location: Breckenridge, CO

Re: Excel spreadsheet of Colorado 14ers

Postby BillMiddlebrook » Mon Nov 04, 2013 6:35 pm

d_baker wrote:My wish for the export is that it include range and rank.

The page off the 14ers pull-down menu does include Rank but I'll add Range to it, too. And add both to the export option on the Edit Checklist page. Thanks!

http://www.14ers.com/php14ers/exportpeaks.php
"There's no recess and no rules in the school of life" - D. Mustaine

User avatar
Posts: 2128
Joined: Sun Nov 18, 2007 8:16 am
Location: Broomfield, Colorado

Re: Excel spreadsheet of Colorado 14ers

Postby d_baker » Mon Nov 04, 2013 6:48 pm

BillMiddlebrook wrote:
d_baker wrote:My wish for the export is that it include range and rank.

The page off the 14ers pull-down menu does include Rank but I'll add Range to it, too. And add both to the export option on the Edit Checklist page. Thanks!

http://www.14ers.com/php14ers/exportpeaks.php

I mean its own column for rank. Similar or the same as what the 14ers tab list shows.

Re: Excel spreadsheet of Colorado 14ers

Postby bergsteigen » Mon Nov 04, 2013 7:37 pm

Ahhh, a couple years too late for me. I downloaded from LOJ an HTML screen capture, then awked and scripted it into XML to create my personal list on my page. A lot of work, but fun in a geeky way :lol:

My 13er list with rank, sortable ranges and stats

Site Administrator
User avatar
Posts: 6368
Joined: Sun Jul 25, 2004 8:34 pm
Location: Breckenridge, CO

Re: Excel spreadsheet of Colorado 14ers

Postby BillMiddlebrook » Mon Nov 04, 2013 8:38 pm

d_baker wrote:
BillMiddlebrook wrote:
d_baker wrote:My wish for the export is that it include range and rank.

The page off the 14ers pull-down menu does include Rank but I'll add Range to it, too. And add both to the export option on the Edit Checklist page. Thanks!

http://www.14ers.com/php14ers/exportpeaks.php

I mean its own column for rank. Similar or the same as what the 14ers tab list shows.

That's what I meant to say - rank is a column in the exported file. Plus, I just added mountain range.
"There's no recess and no rules in the school of life" - D. Mustaine

User avatar
Posts: 2128
Joined: Sun Nov 18, 2007 8:16 am
Location: Broomfield, Colorado

Re: Excel spreadsheet of Colorado 14ers

Postby d_baker » Mon Nov 04, 2013 9:48 pm

Sweet! That's what I had in mind Bill! Thank you...I appreciate it. :)

EDIT: Deleted post. Sort & filter fixed "the problem" I thought I had. #-o

User avatar
Posts: 7157
Joined: Thu Jun 08, 2006 2:23 pm
Location: Colorado Springs

Re: Excel spreadsheet of Colorado 14ers

Postby Jim Davies » Tue Nov 05, 2013 9:52 am

The Roaches site has more lists than you could possibly climb in several lifetimes, as HTML pages for you screen-scrapers. Interesting notes and comments, too.
http://climb.mountains.com/Project_Island.shtml
Some people are afraid of heights. Not me, I'm afraid of widths. -- Steven Wright

Previous

Who is online

Users browsing this forum: Vincopotamus and 10 guests