Strength coach and also an Excel coach. Though I'm already well versed in Excel just wanna thank you for all the help you offer us with this video and your freebie spreadsheets. You're the man Bryce!
@ksenryo
9 жыл бұрын
I thought that I good at spreadsheets but your's Excel-fu is on completely another level. Keep this series up, I got some good tips from it.
@JonathonAndFriends
9 жыл бұрын
Received phone notification..read title..SO EXCITED
@brycebyte
9 жыл бұрын
Don Le lol I wondered if people were going to like it. Its mostly pretty boring but useful
@bardl9355
9 жыл бұрын
Bryce Lewis Holy shit, just got done doing some excel work, brb redoing it, thanks!
@quadsksmith
9 жыл бұрын
I was literally about to start a new spreadsheet and was going to research the formulas you used on the previous spreadsheet you uploaded. Thank you for this!!
@stewartstrengthtrain
9 жыл бұрын
Great idea Bryce, will be watching in full later.
@stefantholet4036
8 жыл бұрын
Knowledge of pure gold. Thank you mastah!
@eukleidesk6759
9 жыл бұрын
Excellent introduction. Thanks. Looking forward to more in this series.
@hiflyfitness
9 жыл бұрын
So much awesome in this video. Thanks Bryce, definitely learned a good amount especially about using If then statements for excel.
@teampride2355
9 жыл бұрын
Awesome video Bryce. I for one truly appreciate this help from you. I've been trying to setup templates for my clients but excel is sometimes so confusing.
@leedan481
9 жыл бұрын
INB4 this is better than the Excel portion of my Uni's IT module.
@jamiesmith1757
9 жыл бұрын
Unbelievable! thank you, more of this please!!!
@HeslinKim
8 жыл бұрын
WOW this is is so awesome. Thank you so much for putting this out there. Been looking for this for a while.
@Byukga99
9 жыл бұрын
Thank you so much for this! Exactly what I needed!
@blove8396
8 жыл бұрын
Learned so much from this video, and to think I thought my Excel skills where pretty pro! I just got schooled haha
@TunnelVisionAthletic
9 жыл бұрын
Seriously Bryce, just stop it, this is too good!
@basselkharsa5690
9 жыл бұрын
Damn, excel is just too tedious! Props to you for doing all the work man :)
@MrSLach123
8 жыл бұрын
Awesome stuff, downloaded the free DUP template and created my own from it. My last set is always an AMRAP for the 3 big lifts and I want regulate my next weeks weight from that. I came up with just a real long function to calculate my next weeks percentage depending on how many reps I get. Is there a standard formula for how many + or - reps you get for how much you should adjust?
@0800tony
9 жыл бұрын
Great video keep em coming!
@fortinfilms
9 жыл бұрын
very informative! great job
@anthonini66
3 жыл бұрын
Awesome work. I've gotten as far as day 1 but when i copy this for day 2,3,4 it is doing relative referencing. You don't seem to have used absolute references at this point, what have I missed?
@reynunez4997
9 жыл бұрын
Hey Bryce, awesome videos brother. If I shoot you a template, could you maybe help me improve it to make it better? The help is definitely needed.
@espenseverinsen229
8 жыл бұрын
Great stuff!
@matthew-tq7fj
9 жыл бұрын
Amazing video.
@christiansinger2497
9 жыл бұрын
Thanks for the content,really appreciate it :-)
@ianmcstruthers9937
9 жыл бұрын
BRYCE. The format painter. Use it.
@brycebyte
9 жыл бұрын
Ian Mcstruthers Oh I do!
@ianmcstruthers9937
9 жыл бұрын
Okay, good! Do you ever put any VBA in your spreadsheets (sorry in advance if you talk about this in the video, I didn't watch the whole thing)
@brycebyte
9 жыл бұрын
Ian Mcstruthers This one’s an intro video so I wouldn’t even touch that until much, much later on. I have a few things I’d love to use VBA for but I don’t want spreadsheets to be saved as .xlsm, mobile Excel apps don’t like VBA yet and we need athletes to be able to use and track on their phones.
@cormacshanoff6747
3 жыл бұрын
This is my first time trying to program so it was a learning experience to say the least. When I copied and pasted the format the formula did not work for the copies. I keep getting #VALUE! more and more as I make more copies. Do you know how to solve this?
@mattcronin9070
9 жыл бұрын
Only thing confusing me when doing this, is when you doing the If/then statement. When you drag in down along all the lifts of the week, why don't calculate if they're referencing all the correct cells?
@brycebyte
9 жыл бұрын
Matt Cronin Training I didn’t put any set/rep information in the boxes they are referencing
@mattcronin9070
9 жыл бұрын
Bryce Lewis No, I noticed that, but on my spreadsheet I entered information and still was getting no values. It may be because I was using google sheets.
@mulullama
9 жыл бұрын
what's the formula you used on the 1rm calculation cell?
@brycebyte
9 жыл бұрын
mulullama Its the same one from exrx.net, I believe also from Brzycki, Matt (1998). A Practical Approach To Strength Training. McGraw-Hill
Пікірлер: 44