Saturday, December 28, 2013

yogi_Set Up Table And Calc For Multiple Repeats Of Specified Percentage Of Weight for 1 rep max

                                          Google Spreadsheet   Post  #1455
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-28, 2013
question by doublezebra (http://productforums.google.com/forum/?zx=ym0xgc9fgk0f#!category-topic/docs/spreadsheets/zsy8AoYHy_M)
How to set a variable in formulas
'm setting up a spreadsheet to track my weightlifting progression. For certain lifts, I have to calculate my 1-rep max and then do reps based as a percentage of that.  For example:

1 rep max = 200
75% 1RMx5 = 5 reps of 150
80% 1RMx5 = 5 reps of 160
85% 1RMx5 = 5 reps of 170

Every week, the value of the 1RM variable will go up. It'd be nice to be able to simply set a variable so that x=200 so that next week all I have to do is change the variable so that x=205 or x=210 so I don't have to edit each cell manually. Is there a way to do this?

-------------------------------------------------------------------------------------------------------------------------------------------------