Welcome to Complementary Training Community! › Forums › Products › Strength Card Builder › 3×5 Issue › Reply To: 3×5 Issue
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
