ok, after an hour of trying I am asking for help- this is hopefully a problem other weight lifters have encountered:
So I am using Excel to record my sessions, and now, months later, I got the idea to calculate the volume but I don’t know how to make Excel actually calculate it.
This is an example row:
so 3 sets of 6 reps of 100 pounds so the volume would be 1800.
So 3x6x100 is in the wrong format for excel to calulate it.
I Find and replace x with * to make it 36100
then I concatenate("=",cell) where cell is the cell containing 36100
and I do indeed get =36100
but I can’t get Excel to actually calculate the result. Manually I need to go in there and hit “enter” at the end of the line.
arg I really am curious to see what the volumes are but I can’t go through it manually- too much.
I tried changing the format of the cell, I tried copy, paste special values
I can’t get it to work.
and please no one make fun of me for using Excel! Whatever it takes to lift weights, right? For me, I like to see my progression etc.