|
Post by erick on Dec 31, 2017 13:12:33 GMT -7
I have an excel spreadsheet that I use to track my climbs but I am wondering if any excel wizards out there have created one with any features? Like as you add routes in it stacks them into a actual pyramid shape with the hardest route centering and the next grade down centering under it. Or you can easily identify other info like what type of rock or style of climb vert/steep etc.
|
|
|
Post by Charlie S on Dec 31, 2017 14:33:53 GMT -7
Like this? It's far from a pyramid...but that's my fault, not the program. I have the capacity to break it down by trad sport. I could split it down into wall angle if that was data I recorded. Up front, it will be a lot easier for you to record data using a dedicated database software like Microsoft Access and then using Excel to make the charts. You might have to brush up on some querying language (like SQL) but it's no worse than Excel formulas. There's a lot of power in there. Also by cross linking into Excel, you can make Pivot Tables and Pivot Charts which are extremely flexible.
|
|
|
Post by scojo on Dec 31, 2017 14:35:24 GMT -7
Sounds a lot like what thecrag.com does.
|
|
|
Post by erick on Dec 31, 2017 17:59:46 GMT -7
Like this? It's far from a pyramid...but that's my fault, not the program. I have the capacity to break it down by trad sport. I could split it down into wall angle if that was data I recorded. Up front, it will be a lot easier for you to record data using a dedicated database software like Microsoft Access and then using Excel to make the charts. You might have to brush up on some querying language (like SQL) but it's no worse than Excel formulas. There's a lot of power in there. Also by cross linking into Excel, you can make Pivot Tables and Pivot Charts which are extremely flexible. Looks great, what type of program is this on? Can you link a copy of it?
|
|
|
Post by Charlie S on Jan 1, 2018 8:57:02 GMT -7
erick PM me your e-mail address and I'll add you to the Dropbox folder. If you haven't used Microsoft Access before, there's a bit of a learning curve.
|
|
|
Post by jetjackson on Jan 1, 2018 16:49:42 GMT -7
I just use thecrag, which does this pretty well - for those who use offline ways to record their progress, what are your reasons?
|
|
|
Post by Charlie S on Jan 1, 2018 19:11:00 GMT -7
So, I'm not aware of The Crag, which is probably reason #1 to be honest.
It's a journey to why I ended up doing it myself.
I started with Mountain Project. Well that only tells you so much.
Then I switched to Excel. Within the scope of a year, I had broken Excel with all the data and charts updating. Plus, I couldn't log OTHER types of workouts or events (lifting, hiking, trail running, etc.). So I switched to Access which is far more robust in its handling of data.
I have flexibility to record and report any data I want. Besides just difficulty, but other styles (pink point, aid, failed attempt, etc.), HR data, elevation gained, duration, calories burned...you name. If I want to add a field for it, I have the flexibility.
For most people, that's probably overkill. But I get some sort of pleasure out of nerding out over the data and programming as much as the exercise itself.
Besides, what happens when that site goes away? Or prices go up? I realize some of that is inevitable, but it's nice to have some control.
|
|
|
Post by jetjackson on Jan 1, 2018 19:36:28 GMT -7
Yeah, they are free - although they ask for a donation. They have been around a while, longer than the other sites that have been showing up lately. They have a lot of tracking options, but if you want the level of control you're talking about, and if you enjoy that, then I think you have to do your own thing.
They allow you to download your own data too. Which I think is a good thing.
Also, based on my experience with thecrag - they're not really trying to be a business, it's more of a hobby for the guys who run it, which I think is a good thing for longevity.
|
|