Sets x reps via excel
Posted: 27 April 2010 02:26 PM   [ Ignore ]
Sr. Member
Avatar
RankRankRankRank
Total Posts:  593
Joined  2009-03-25

I have really cool excel file with an ability to calculate many sets x reps combination by 1RM
It’s really useful.

http://rapidshare.com/files/380791958/weight_and_sets.zip.html

Profile
 
 
Posted: 28 April 2010 12:43 AM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  626
Joined  2008-07-28

Thanks Anatoly for posting it!

 Signature 

Anoop
Exercise Biology

Profile
 
 
Posted: 29 April 2010 06:53 PM   [ Ignore ]   [ # 2 ]
Jr. Member
RankRank
Total Posts:  35
Joined  2010-04-12

Thanks for posting, Anatoly.  I like this a lot grin

I am interested to know a little bit more about how you came up with these numbers.  Of course, there are equations that allow one to calculate a specific RM from a 1RM, but how did you calculate the percentages used for the “sets across” figures (IE how did you decide what percentage would equate to one’s best 3x6 performance)?  Did you use personal experience, estimation, or some other method?

Also, how much rest does this sheet assume between the sets?  For example, I was checking one of my exercises against this sheet, and I noticed that the weight listed for 3 sets of 12 was higher than I thought I could lift, but I usually perform 3 sets of 12 on 1 minute rest.  I know I would be able to lift more with a longer rest period.

Profile
 
 
Posted: 29 April 2010 07:05 PM   [ Ignore ]   [ # 3 ]
Sr. Member
Avatar
RankRankRankRank
Total Posts:  593
Joined  2009-03-25

Thanks, I’m glad you like it.

Well, its not mine.
A friend of mine build it and I have no idea how.
But since it works it doesn’t bother me.
smile

About calculation - I believe that he uses some known formulas for 1PR calculation

Profile
 
 
Posted: 28 May 2010 04:27 PM   [ Ignore ]   [ # 4 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  626
Joined  2008-07-28

I uploaded the excel file so people don’t have to download the zip file.

http://www.exercisebiology.com/images/uploads/miscellaneous/weight_and_sets.xls

 Signature 

Anoop
Exercise Biology

Profile