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?
-------------------------------------------------------------------------------------------------------------------------------------------------
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?
-------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment