Is there a trivial way to generate lists of the most popular routes at a given grade?
I want to end up with a list of the 50 most popular Mods, the 50 most popular Diffs, and so on, up to VS. I can't see an obvious way to do this from the logbook stats page but perhaps I'm missing something.
Or is there a way to download the number of ascents and manipulate it in Excel? That would be fairly straightforward.
Yeah, I have convinced myself that it's not possible for a normal user to get at it (I had hope it might be).
I wonder if one of the UKC elves might pick up on this? It's not critical but it would be helpful for a project I'm working on. And it would be interesting in general, I think. I'm sure I can guess quite a few of the top 50 at each grade but I bet there'll be some surprises as well.
Last hopeful bump and then I'll drop it. If anyone who has database access can help, that would be great - I would simply need an excel file containing route name / grade / number of logged ascents and I could do the rest.
More than 50% on grit I expect?
Christmas Crack at S
Flying buttress at VD
Inverted V at (grudgingly) VS
Sunset Slab or TPS at HVS or, just possibly, DoWH
Long Tall Sally at E1
Wuthering at E2?
Actually, change my bet to 90% drawn from Classic/Hard rock
Easy: High Neb Gully, Stanage (not in top 10)
Mod: Overhanging Buttress Arete, Burb N, or Martello Cracks, Stanage (No Mod will be in the Top 10)
Diff: Black Slab Right, Stanage (No Diff will be in the top 10)
VD: Flying Buttress Stanage (HVD in Rockfax) or Little Chamonix
HVD: Heather Wall (Froggatt...or Flying Buttress as above)
S: Black Hawk Hell Crack (Stanage)
HS: Christmas Crack (Stanage) or Sunset Crack (Froggatt)
VS: Hargreaves Original (Stanage)
..others from: Hollybush Crack, VD, Stanage; Heaven Crack, VD, Stanage; Manchester Buttress, HS, Stanage; Heather Wall, VS, Stanage; Inverted V, VS, Stanage,
Tricky if you leave the Grit because the best easier routes off-grit are mostly multi-pitch. That means fewer of these routes per person in a lifetime (because they take longer), which I think translates to fewer ascents, everything else being equal.
But I'd suggest Little Chamonix (with Offwidth), Middlefell Buttress, Flying Buttress (Cromlech) and Hope as possibles. If they had trad grades I think some of the popular southern sandstone routes might qualify. Likewise some sport routes at Horseshoe, although they may not have been around long enough.
So, thus far no-one has mentioned the second most popular multipitch in the UK. It caught me out, too.
But yes, it's massively dominated by grit, and frankly by Stanage. 21 of the top 30 are Stanage, and five of the remainder are grit. It becomes a bit more varied after the top 30.
I didn't include sport, but it looks like they are quite a long way down the list (there's an element of reporting bias here, I suspect). I've just looked up a couple of popular sport routes: Fallen Slab Arete would come in at #74, Reptile Smile #110, Pale Rider #117.
For those who wanted to see it - the most logged 100 mod to VS routes in the UK:
Yeah, I just thought that popular routes on Ogwen venues like Idwal, Tryfan East face, Milestone, would be ahead of it. Perhaps I have underestimated the magical climate of Tremadog!
I was intrigued as to whether the top pitch of Troutdale Pinnacle has seen more ascents than any other pitch It seems to fall just short of Little Cham. even if I assume no one abs off the pinnacle.
This week's Friday Night Video features 12-year-old Gianluca Vighetti, who in September 2021, climbed his hardest route to date with an ascent of TCT (9a), at Gravere, Italy. With his ascent, Gianluca became the youngest person to have climbed...