I just started this program and have found what I think are two issues in the spreadsheet. It could be user error but I’d love some input.
The first is in the analysis sheets: “Supplemental Bench - Method 1,” “Supplemental Deadlift - Method 2,” “Supplemental Squat - Method 1,” and “Supplemental Squat - Method 2” all give errors. I’m guessing there’s an incorrect reference in the equation but what it is isn’t obvious to me. Anyone know what’s going on?
And the second is in Day 4 (in every week, as far as I can tell) “Intensity” is not registering correctly. I believe, in the equation, “E10x” (in supplemental Dead 1), “K10x” (in supplemental Bench 5), and “Q10x” (in supplemental Dead 2) should be divided by E, K, and Q$110, respectively. If that’s not correct please let me know!
Oh thanks for seeing this I was about to start 12 week str 2.0 next week. Yeah, looks like they’re messed up. Easy way to fix this is to fix the first one highlight it then drag the little auto fill square down. Then recolor them. Edit: Then select them all and copy and paste to the rest, google sheets should make the adjustments for you.
The analysis sheet looks a little more complicated.
If you tap on the cells for the lifts that show errors on the Analysis page, you’ll see !D5:J14
Change the 14 to 18
Edit: This won’t work for Supplemental Bench Method 1 because there isn’t one