|
|
Post by Yogicleo1 on Aug 16, 2015 16:11:28 GMT -7
Hi! Recently I "hit a wall" with climbing. My close friends use your method of training (repeaters) have called me out and dared me to train. So, I have. And I was curious...does anyone have or know how to use excel to set up a spreadsheet that could later output a graph for improvement? (line, bar, etc...)
I do well with visual guidance then I do by checking out last weeks couple HB workouts campared to this weeks HB workout. Has anyone done the work and have a template for EXCEL? or similar?
|
|
|
|
Post by tedwelser on Aug 16, 2015 19:39:17 GMT -7
I dont really have a template, but if you enter your HB data into excel you should use a structure where the rows are the grips and the columns are the workouts.
grip workout1 workout2 workout3 etc
warm up jug
LVDR
IMR
MRP
etc
after entering data you can highlight that range, say that you have column and row headers and then plot it.
hope that helps
|
|
|
|
Post by Will S on Aug 17, 2015 7:04:35 GMT -7
I'm very much a visual-spatial guy, always learned best that way, an engineer by profession.
But I do not chart my HB logs. The reason being, it's difficult to represent what really happened. You will see the hold and weight, but you won't see the rep-times on reps that didn't go to completion (e.g. you had a set that went 7,7,7,5,3), won't see the room temperature, humidity, any other workouts (weight room/bikes) you might have done the day before, any notes about whether you slept well, etc.
And over the years you will almost certainly change which holds you use, or which board you use. I've switched boards, holds, timing regimen, repeaters to singles and back, every 3rd day to 3-on/1-off, and my room temps vary between 58 and 80.
I do like checking out others' charts, just doesn't work for me personally.
|
|
|
|
Post by MarkAnderson on Aug 17, 2015 11:27:18 GMT -7
|
|
|
|
Post by slimshaky on Aug 17, 2015 15:27:45 GMT -7
couple quick thoughts-
i actually prefer to have my grips as the columns and the workouts as the rows. part of this is from an old issue with excel having a limited number of columns. i have a pretty good (i think) spreadsheet that plots my added weights, my total weights (body weight + added/subtracted weights), and other stuff. i find this really useful for a lot of reasons.
for graphing purposes, i use 'vertical' lines between cycles. i use different colored vertical lines if i make some sort of change to my workout (in terms of time on and off protocol). if i change holds for some reason, i use a really big 'marker'. if i am successful on my set, the marker is filled in - if i don't 'send' my set i make the center of the marker transparent so it looks 'hollow'. if for some odd reason i don't do the set at all, i remove the marker.
with all of this, i can look at everything pretty quickly and have a good understanding of all of the data.
|
|
|
|
Post by slimshaky on Aug 17, 2015 15:35:12 GMT -7
Here are some example PDF's. It takes a little bit of effort initially to set this all up, but then it is just copy a row, insert the copied row, edit a handful of numbers. HB plot 2.pdf (67.22 KB) HB plot 1.pdf (65.38 KB) HB table.pdf (54.47 KB) |
|
|
|
Post by yogicleo1 on Aug 19, 2015 11:21:44 GMT -7
So I'm not computer or EXCEL savy, however, I am resourceful! Good ol' ruler, highlighters and some free time i accomplished what I was looking for! The green or "WO #1" was ultimately my BW for each hold. This type of chart is only good for representing your increases in LBS for each grip at the end of the 2 set. It's coming up on 5 years now, and I've never taken on any type of training within that time period. Still learning everyday. And enjoying the push! WO #4 tomorrow! psyched! Thanks everyone for your resources  Happy Hangboarding!  |
|
|
|
Post by Lundy on Aug 19, 2015 11:42:13 GMT -7
Nice. I'll have to look and see how to pull that together in Excel tonight. I'm sure it can be done. Two thoughts: (1) You really work a lot of grips in one workout! And (2) there are a lot of people on here who are strong on pinches. I remember seeing this in another thread, that someone who was beginner-ish on other grips was quite strong on pinches. You're less extreme, but being -25 on the wide pinch seems really strong relative to your other grips. Or, an alternative hypothesis is that I really suck at pinches and my numbers are the ones that are askew...
|
|
|
|
Post by jessebruni on Aug 19, 2015 11:49:19 GMT -7
Or, an alternative hypothesis is that I really suck at pinches and my numbers are the ones that are askew... Welcome to the club. We should have t-shirts soon! |
|
|
|
Post by yogicleo1 on Aug 19, 2015 12:08:06 GMT -7
Nice. I'll have to look and see how to pull that together in Excel tonight. I'm sure it can be done. Two thoughts: (1) You really work a lot of grips in one workout! And (2) there are a lot of people on here who are strong on pinches. I remember seeing this in another thread, that someone who was beginner-ish on other grips was quite strong on pinches. You're less extreme, but being -25 on the wide pinch seems really strong relative to your other grips. Or, an alternative hypothesis is that I really suck at pinches and my numbers are the ones that are askew... So, before I acquired my RPTB, I was only able to work off of my Metolius board, that host no pinches...so I had to get creative again...Went to HD and went and purchased some railing toppers (?name?) and applied them to a 45degree surface, separate from the hangboard. Zero texture, so the thumb is QUITE active during the sets. And, i suppose that i could very well change over to the RPTB, but since i started with the Met, I want to finish with the Met. Not to mention, I am strictly training for a short 5-6 week period, for a short but sweet trip to the RRG! Then, it's back to the volcanic tuft out here at Smith. ...oh and yes, the pinches taper   |
|
|
|
Post by MarkAnderson on Aug 19, 2015 13:10:04 GMT -7
So I'm not computer or EXCEL savy, however, I am resourceful! Good ol' ruler, highlighters and some free time i accomplished what I was looking for! The green or "WO #1" was ultimately my BW for each hold. This type of chart is only good for representing your increases in LBS for each grip at the end of the 2 set. It's coming up on 5 years now, and I've never taken on any type of training within that time period. Still learning everyday. And enjoying the push! WO #4 tomorrow! psyched! Thanks everyone for your resources Happy Hangboarding! I love this chart, very cool! |
|
|
|
Post by daustin on Aug 19, 2015 13:20:42 GMT -7
If you are interested in creating such a chart in Excel, you should be able to using the radar chart feature: support.office.com/en-us/article/Present-your-data-in-a-radar-chart-16e20279-eed4-43c2-9bf5-29ff9b10601dThat said, I'm of the same ilk as Will S. I've tried numerous ways to graph my HB/training data, but it's never been satisfactory. Too many variables means it would require more effort than I'm willing to expend in order to manage the data in a way that would make visual representation easy and satisfactory. |
|
|
|
Post by slimshaky on Aug 19, 2015 13:39:44 GMT -7
love the graph yogi, definitely cool.
|
|
|
|
Post by MarkAnderson on Aug 19, 2015 14:00:25 GMT -7
That said, I'm of the same ilk as Will S. I've tried numerous ways to graph my HB/training data, but it's never been satisfactory. Too many variables means it would require more effort than I'm willing to expend in order to manage the data in a way that would make visual representation easy and satisfactory. Totally agree. I use a pencil and a log sheet (like those in the RCTM Logbook) to record my workouts. That's pretty much the end of the story. If I want to look backwards, I flip through the log sheets. The only reason I ever create graphs or charts is to draw attention to my mad Excel skillz. |
|
|
|
Post by yogicleo1 on Aug 19, 2015 17:55:24 GMT -7
So I'm not computer or EXCEL savy, however, I am resourceful! Good ol' ruler, highlighters and some free time i accomplished what I was looking for! The green or "WO #1" was ultimately my BW for each hold. This type of chart is only good for representing your increases in LBS for each grip at the end of the 2 set. It's coming up on 5 years now, and I've never taken on any type of training within that time period. Still learning everyday. And enjoying the push! WO #4 tomorrow! psyched! Thanks everyone for your resources Happy Hangboarding! I love this chart, very cool! That said, I'm of the same ilk as Will S. I've tried numerous ways to graph my HB/training data, but it's never been satisfactory. Too many variables means it would require more effort than I'm willing to expend in order to manage the data in a way that would make visual representation easy and satisfactory. Totally agree. I use a pencil and a log sheet (like those in the RCTM Logbook) to record my workouts. That's pretty much the end of the story. If I want to look backwards, I flip through the log sheets. The only reason I ever create graphs or charts is to draw attention to my mad Excel skillz. What's really going to make this chart a hit is that when you're done with this phase...put the graph in front as a sort of 'title page' of all your HB WO's and staple them together and then stash it! Although, I'm psyched to pull serveral of these out in the next few years, I am still a noob...and I am still ONLY on HB WO #3, with #4 tomorrow...a long, awesome and progressive road ahead! Oh, yes, btw, do you feel that I need to be training "so many holds"? Again, noob here...I'm trying to prep for a week at the RRG and then back to smith..? Dec1 will mark the beginning of my 1st REAL 17wk program. Gotta late start so I had a few 'seasoned' friends help guide me in consolidating the program to fit my 6wk schedule. |
|
Happy Hangboarding! 
