Small “bug” in Strength Card Builder

Mladen Jovanović August 25, 2014

0 Comments

Thanks to Nathan Young [Forum LINK] for reporting a small bug in Strength Card Builder. The bug is in 3×5 tab under Tier4 exercise. It pulls the wrong references from the Set & Rep scheme (it pulls from the top which is reference 0, instead of pulling from 3rd set).

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. (see the picture)

Sorry for the inconvenience and I hope it didn’t cause you any troubles.

Categories: Non-Membership Content

Tagged: Notice

Mladen Jovanović

Mladen Jovanovic is a physical preparation coach from Belgrade, Serbia, grew up in Pula, Croatia (which he considers his home town). He was involved in physical preparation of professional, amateur and recreational athletes of various ages in sports such as basketball, soccer, volleyball, martial arts and tennis. Email | LinkedIn | Twitter | Facebook

FREE Annual Planner for Sports and Strength Card Builder Print Out

FREE Annual Planner for Sports and Strength Card Builder Print Out I would love to rise an awareness on the two tools for coaches. Yes, coaches – not only strength and conditioning coaches and sport scientists, but coaches in general. Strength Card Builder This tool works under Microsoft Excel 2011 and later, both on Mac and Windows. It allows…

Mladen Jovanović April 20, 2014

0 Comments

How to Make a Readiness Monitoring Using a Simple Wellness Questionnaire [Part 3]

Although I promised I will show you how to visualize the data using screen cast – I won’t do it. I started taping the screen and it took me more than one hour to actually explain basics, without going into advanced techniques, like name references, dynamic graphs and dash boarding (which involves a lot of use of functions like…

Mladen Jovanović September 22, 2012

0 Comments

Adjusting High-Reps Percentages for Lower Body Lifts

A little piece of me dies every time I see someone prescribing same percentage for high reps sets (i.e. 70% x 10reps) for upper (e.g. bench press) and lower body (e.g. back squat) lifts. This is much harder to be completed for the lower body exercises, and in my opinion because we don’t take into account the bodyweight lifted.

Mladen Jovanović June 23, 2015

0 Comments

Set and Rep Schemes (Part 5): Grinding Schemes

In this final instalment of the Set and Rep schemes video series I am walking you through an Excel workbook that allows you to create your own set and rep schemes based on the ideas presented in the previous videos and Perc Drop and RIR Inc progression approaches.

Mladen Jovanović May 7, 2020

0 Comments

Small “bug” in Strength Card Builder

Responses

NEWSLETTER

Sign Up and Stay in the Loop

Claim Your Free Copy of Home Workout Builder

About Us

Contact

Terms of Use

Privacy Policy

Cancel Membership

Related Articles

Responses

NEWSLETTER

Sign Up and Stay in the Loop

Claim Your Free Copy of Home Workout Builder

Cancel Membership