How to build an RPE based powerlifting google sheet

No video

How to build an RPE based powerlifting google sheet | VLOOKUP and MROUND Explained

Рет қаралды 25,109

Күн бұрын

Jamie Smith has opened a Coach Development Program for Strength coaches to learn the necessary business and training fundamentals for success in the industry long term. It is an online program that runs for 12. The next intake begins in late MarchMore information can be found here: www.melbournes...
We are available for online coaching please email: jsmith@melbournestrengthculture.com
Instagram
➢ Strength Culture Gym: / melbournestrengthculture
➢ Jamie: / j.smith.culture
➢ Charlie: / quantum_lifting
Facebook
➢ Gym: / melbournestrengthculture
➢ Jamie: / jamie.smith.969300
➢ Charlie: / charlie.athanassiou
Website
➢ www.melbournes... #strengthculture #huntprogression

Пікірлер: 24

@jkbrwn 2 ай бұрын

For anyone else confused when he switches to the other sheet at 10:16... In N503 he says he's combined two formulas resulting in "233" - But he doesn't mention what formula to use in O503. The formula is: "=mround((N503),2.5)" or in my case since I use pounds "=mround((N503),5)"

@angusredfearn9275 2 жыл бұрын

Thanks for the video, i remember using this with Didier a few years back, getting back to training and its a blessing. thanks!

@MelbourneStrengthCulture 2 жыл бұрын

🤝🤝🤝

@marcovirtual 2 жыл бұрын

Loved the spreadsheet color design. I'm so gonna steal it for my training log xD

@MelbourneStrengthCulture 2 жыл бұрын

The colours help heaps

@rivercitybarbell7024 2 жыл бұрын

This help me heaps today legend

@MelbourneStrengthCulture 2 жыл бұрын

Weapon

@jkbrwn 2 ай бұрын

Is there any reason you've calculated the Low End and High End formulas the way you did? I have a cleaner method of using "=mround(I504*0.975,5)" or "=mround(I504*1.025,5)" for Low and High. Is there something I'm missing from your method?

@SnakeC666 4 жыл бұрын

really helpful thank you :)

@MelbourneStrengthCulture 4 жыл бұрын

SnakeY 🙌🙌

@susandpt 2 ай бұрын

Hi! I love the template for will crozier training but I'm unable to replicate it :( do you have a template I can use?

@TunnelVisionAthletic 4 жыл бұрын

This is good

@lucaheinrich7709 Жыл бұрын

how do i implement progressive overload into this spreadsheet?

@jasonraceles5007 Жыл бұрын

Is anyone running into a problem where it’s not reading the RPE value in the Vlookup equation?

@carlgongora3374 2 жыл бұрын

how do you make that low end and high end prescription, thank you.

@anwin4505 3 жыл бұрын

Im new to gym and powerlifting what is an rpe

@journeymans 3 жыл бұрын

Rate of percieved Effort

@MelbourneStrengthCulture 2 жыл бұрын

You can learn more about RPE with our online resources on the www.melbournestrengthculture.com/store

@angusredfearn9275 2 жыл бұрын

Question: How can i get my back off weight column to be rounded to 2.5 increments like the PDM column. my attempt at 'mround' failed. Thank you for your time and patience with your comments sections, leaders of strength in aus ;)

@MelbourneStrengthCulture 2 жыл бұрын

Ummm not sure. Mround has always worked for me. Not sure how to help

@MelbourneStrengthCulture 2 жыл бұрын

Thank you! 🙌🙌

@jkbrwn 2 ай бұрын

"=mround($O$503*H504,2.5)"