Removing unnecessary "Zero" Values from Excel

By Excel Tips

Heres a neat trick for you.  So anytime you go to multiply two cells together, using any of the multiplication variables (CEILING, MROUND, FLOOR), it will give you the number you are looking for: 5x5 = 25.But if one of the numbers is zero, or in the case of a strength coach that athlete has

Performance Reads of the Week - 7/24/16

By Performance Reads

This newsletter is focused on one thing: writing better programs.  We will not be discussing the usage of big data, analytics, GPS or fancy equipment.  I want to provide the information to you necessary to help your athletes get better with proper planning and programming. Periodization, exercise selection and variation, motor control, plyometrics, and more!The

Performance Reads of the Week - 7/17/16

By Performance Reads

Welcome to the first edition of "Performance Reads"!  This newsletter is focused on one thing: writing better programs.  We will not be discussing the usage of big data, analytics, GPS or fancy equipment.  I want to provide the information to you necessary to help your athletes get better with proper planning and programming. Periodization, exercise

Calculating multiple weights within one cell.

By Excel Tips

Hey everyone!Got a great excel tip for coaches to try on their strength and conditioning excel templates.  One issue we all run into is how strict % training can be.  Somedays, 80% just feels heavy!  So you get stuck in a conundrum: you want to give your athletes guidance on the weight to use, but

Calculating Volume in Excel

By Excel Tips

Calculating Volume in your excel strength and conditioning template is easy...if you know how to use helper cells! The first thing you need to decide is whether when you enter in your Sets and Reps, you are going to do it with an X in Front of the reps, like this:   If so, we

MROUND vs Ceiling

By Excel Tips

MROUND Vs Ceiling Formula These two formulas are the options you have for making your template calculate weights.  Both are entered into Excel the exact same way, but the difference is the MROUND formula will round up or down to the nearest determined decimal, whereas the CEILING formula will round up to the nearest determined