[FOR COACHES] Creating A Dynamic Exercise Database With Google Sheets (With Video Links)
Вставка
- Опубліковано 12 вер 2024
- Having a solid database of exercises that you can use with your clients (in person or remotely) is a huge advantage as a personal trainer or S&C coach. And it’s even better when you have dynamically linked videos that save you all the hard copy/paste work!
In this video I explain how I setup my main exercise database along with exercise video links, how I import this databasefrom my client’s individual sheets, and then how I organise things with Google Sheets Funtions in order to make my life easier when I program. I don’t have to copy and paste youtube links anymore because the spreadsheet does all the work!
The clients also really enjoy having the video demonstrations on hand in the even that they don’t remember how to perform an exercise.
Donwload your own sheet: docs.google.co...
Enjoyed this video? leave a comment below!
--
► Subscribe for more videos here: bit.ly/1Xgr5y5
--
[FR] Sean est un coach sportif, préparateur physique et consultant à Nyon, en Suisse. Au fil des ans, Sean a pratiqué de nombreux sports de compétition, notamment le rugby, l’haltérophilie et le rameur.
--
[EN] Sean is a Personal Trainer/Coach Sportif in Nyon. He offers private coaching, online programming, group/team coaching, as well as workshops and seminars.
--
Lean more here: www.upsidestren...
Website: upsidestrength.com
Facebook: / upsidestrength
Twitter: / seanseale
Instagram: / upsidestrength
--
Music Credit: LAKEY INSPIRED
Track Name: "Watching The Clouds"
Music By: LAKEY INSPIRED @ / lakeyinspired
Original upload HERE - / . .
Official "LAKEY INSPIRED" UA-cam Channel HERE - www.youtube.co....
License for commercial use: Creative Commons Attribution 3.0 Unported "Share Alike" (CC BY-SA 3.0) License.
Full License HERE - creativecommon....
Music promoted by NCM goo.gl/fh3rEJ
You can download your own sheet here: docs.google.com/spreadsheets/d/1UqJwOxewTWBD4lAliCBzxr6l9jyqORHnbVeuLChivVY/edit?usp=sharing
This is unbelievable content - really appreciate what you've done here, has been seriously helpful in developing my own online coaching!!! Keep up the good work!
Happy to hear it Greg. Thanks for the connect and good luck!
So helpful, I’ve been struggling this past year. Tried business classes and they were not helpful!!! Thank you!!!
Glad to hear it! Google Sheets is amazing 🥰
Hello Sir. Thank you for this post. Your database looks detailed. It is obvious the time and effort that you put into this.
Thanks!
This is awesome!! I have a full list with video links so I'm looking at how to bring it all together for programming and this is perfect!! I'll pop you an email now! Thank you so much for sharing this gold!!
Done 👍
Very generous offering of time and resources. Very kind thank you. :)
You’re welcome!
Wow! Great job! Thank you for sharing it for free!
Glad you like it!
Hi! Sorry if this a dumb question but new to excel/sheets - but on the master sheet, in each individual category (ex. hor_pull) can you write in the other columns without affecting the drop downs? To give context you have the exercise name and video link in column A & B. I would like to write my cues for each exercise in column D just for my own reference so it's categorized and easy to find for quick reference. Would I be able to do this without affecting the drop downs generated by columns A & B? hope that makes sense.
Thanks for sharing such a valuable resource, I've been struggling to find a way to categorize exercise information. Gained a subscriber for sure!
Thanks mate! If you want the cue to be retrieved from the data base like the other cells, you’ll need to modify the. Sheet to allow this. But it’s fully possible yes
Awesome sheet! Thanks a lot. One question. In the macro calculator, which formula did you use for calculating BMR? Appreciate your reply!
I forget but you should find the formulas in the sheet
Wow, amazing, perfect job done here!
Much appreciated thank you!
Awesome tutorial. Highly valuable content. Thank you very much for your time and effort.
Quick question, when you send the file over to clients, which tabs do they actually have access to and are able to view? Also, do you expect / wish that clients fill in the sheet on their phones whilst they work out?
Thanks James, I share the whole document with them so they have access to the complete file through their mobile app (Google Sheets). I highlight the areas they need to fill out with colours, or in explanation videos (with screen share)
Awesome guidance thank you very much
You’re welcome!
This is unreal my friend thanks very much.
I have been using PDFs with hyperlinks to my Tutorial videos and people find it easy to use and understand.
Does this stuff look like a spreadsheet for clients?
Or how much of this stuff do they actually see??
Thanks for all the help I subscribed.
The see it as it is and can fill it out. Different approaches work!
Hi this is amazing, thank you so much! Is there another video explaining the other parts of the sheet?
Not currently. Maybe down the line I will
I love this!!!! Can you consider creating a template?
Email me I’ll share it
This is excellent! Although would you have to completely restructure the program if you had a client do more than 1 session a week?
I’ve got a bunch of sessions in each tab so they can complete multiple!
Wow this is amazing content! thank you for sharing. I am wondering how you continued after month 1, do you duplicate the p1m1 tab and copy the days movements for the following months from the database?
You got it I duplicate the original each time and rename it after it’s completed
This is great! :) Am I allowed to use your library with video links, create my own spreadsheets to sell to trainers?
If you’re going to sell it you should at least go through the effort of shooting your own videos 😉
Is it possible to attach the video links to the exercises inside of the drop down?
Or do I have to have a separate column for the links next to the exercise? I’d like to combine them
Hey Nic, not sure if that's actually possible. You'd have to google or youtube that and see what comes up. Good idea though!
Great work 😀💪
Thanks!
thank u a lot for this video! i prefer to use excel do u think I can do the same thing using excel? and would it take me a long time? i really want to do it by myself and not copy and paste I would've loved to see a step by step tutorial cuz I am also new to excel.
I made a video on French’s. While back explaining the process, but you might be able to figure it out using the sheet itself and looking at the functions used! Lots of excel tutorials on UA-cam 🙏
This is awesome man! Can I get in on this action for a template as well? Would also like to know how long it took?
Hit me up via email 👍 took me the last 7 years (on and off of course 😉)
kinda weird. none of the checkbox's are working on excel 365. i downloaded in xlsx format and not workin. but online shows as it should
Some setting don’t exist on other platforms unfortunately!
Wish I had these skills to make this. Is this downloadable?
Send me an email!
Unreal. Thanks
Anytime!