3×5 Issue - Complementary Training

# 3×5 Issue

This topic contains 1 reply, has 2 voices, and was last updated by  Mladen Jovanovic 9 years, 9 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
• 25/08/2014 at 15:48 #15706

I noticed on the 3×5 card that Tier 4 does not pull the sets and reps over properly. If you choose a 2×10-8-6 program there are only 3 sets pulled over instead of 6 and some are even more messed up. Any idea how I can fix the formula? I want to keep all of the additions I have made to the builder I just need to change the formula for that tier.

Thanks

25/08/2014 at 22:36 #15707

Hi Nathan,

Damn, there is an error. Thanks for notifying me. Must have slipped through the crack. The solution is simple:

1. Unprotect the sheet (right click on the tab at the bottom of the screen)
2. In column AN in Tier 4, select first cell (%). It should write

=IFERROR(IF(ISBLANK(INDEX(‘Set & Rep Schemes’!\$E:\$L, MATCH(\$AM38, ‘Set & Rep Schemes’!\$B:\$B, 0)+0, ((MATCH(AN\$13, WeekList, 0)-1)*2)+1)), “”,INDEX(‘Set & Rep Schemes’!\$E:\$L, MATCH(\$AM38, ‘Set & Rep Schemes’!\$B:\$B, 0)+0, ((MATCH(AN\$13, WeekList, 0)-1)*2)+1)), “”)

You see those “+0”? There are two. Please change them to “+3”. Select the cell below, change to “+4” and so forth. Compare to Tier3.

3. Do the same for the AP column.
4. Repeat that for each “box” [week] for each workout in Tier 4.

Let me know if you find anything else. I will update the bug soon. Thanks again

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.