Number of crags climbed

New Topic
This topic has been archived, and won't accept reply postings.
 petegunn 29 Aug 2019

Probably one for the mods?

Is it possible to use the log books to see the number of different crags that I or others have climbed at over the years?

We were discussing it the other day where someone said they had climbed at 5 different crags whereas we probably would be nearer to 500. Would be good to see either way.

 BStar 29 Aug 2019
In reply to petegunn:

You can do it by downloading your logbook into excel, create a pivot table with crag name as a data field, from there you can count the number of rows or do more excel wizardry to get a formula to do that for you.  

OP petegunn 29 Aug 2019
In reply to BStar:

Thanks for that, so I think that the total is 601 different crags but some of these are probably just summits of hills rather than actual crags.

I wonder if the mods could add this onto the graphs section in logbooks somehow?

1
 spenser 29 Aug 2019
In reply to petegunn:

In the spreadsheet you can sort by grade and then delete out the summits before you set up the pivot table.


New Topic
This topic has been archived, and won't accept reply postings.
Loading Notifications...