Excel logbook pages and 1rm Calculator

[redguru]

Hello, Everyone

Thought I'd share a couple of excel files I set up. One is blank exercise log pages with a body fat measurement from calipers (seven measurement points). The other is a 1RM calculator for 5x5 exercises utilizing the Matt Brzycki (sic) formula as a basis but substituting your own lifts to calculate the delta. Take a look and use them or not as you will. The variation on the Bryzicki formula is shown in an equation editor box at the bottom.

 

[Madcow2]

Hello, Everyone

Thought I'd share a couple of excel files I set up. One is blank exercise log pages with a body fat measurement from calipers (seven measurement points). The other is a 1RM calculator for 5x5 exercises utilizing the Matt Brzycki (sic) formula as a basis but substituting your own lifts to calculate the delta. Take a look and use them or not as you will. The variation on the Bryzicki formula is shown in an equation editor box at the bottom.

As someone who uses excel quite a bit, I have to say these are really nice. Maybe the best excel based sheets I've seen.

 

[redguru]

Thanks MadCow,


I use excel continuously for manipulating electronic testing data, finding slopes and curves, so the 1RM calculator was easy. I had to take a course at a Penn State branch campus called Computer Solutions for Engineering Problems about 6 years back, half the semester was just excel. The body fat caliper excel file is based on a web page done by a guy I see on a newsgroup I frequent a lot, misc.fitness.weights.

If there is any interest I can do another logbook file, for women's bodyfat measurements, just need to change the pics out and the coefficients in the formula.

 

[redguru]

Here is another one for women, the bodyfat measurements reflect Jackson and Pollacks quadratic, for a seven point skinfold test.

 

[musketeer]

Nice,

to make it look really nice, select all of the cells and then use the fill tool to make all of the squares white. This just gets rid of all of the grey cell delineations, but it makes a good diference. (Obviously it will print without they grey anyway...)