[FOR COACHES] Creating A Dynamic Exercise Database With Google Sheets (With Video Links)

[@Upsidestrength]

You can download your own sheet here: docs.google.com/spreadsheets/d/1UqJwOxewTWBD4lAliCBzxr6l9jyqORHnbVeuLChivVY/edit?usp=sharing

[@JessieD-j8u]

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!

[@Upsidestrength]

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

[@greglingard8658]

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!

[@Upsidestrength]

Happy to hear it Greg. Thanks for the connect and good luck!

[@TrainerMonaFit]

So helpful, I’ve been struggling this past year. Tried business classes and they were not helpful!!! Thank you!!!

[@Upsidestrength]

Glad to hear it! Google Sheets is amazing 🥰

[@joelguzman2590]

Hello Sir. Thank you for this post. Your database looks detailed. It is obvious the time and effort that you put into this.

[@Upsidestrength]

Thanks!

[@lukasmartens4421]

Awesome sheet! Thanks a lot. One question. In the macro calculator, which formula did you use for calculating BMR? Appreciate your reply!

[@Upsidestrength]

I forget but you should find the formulas in the sheet

[@mira_zen]

Wow! Great job! Thank you for sharing it for free!

[@Upsidestrength]

Glad you like it!

[@jamessinclairnutrition]

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?

[@Upsidestrength]

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)

[@movepauserestore]

Very generous offering of time and resources. Very kind thank you. :)

[@Upsidestrength]

You’re welcome!

[@moveyobodytoday]

Hi this is amazing, thank you so much! Is there another video explaining the other parts of the sheet?

[@Upsidestrength]

Not currently. Maybe down the line I will

[@frewen1705]

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!!

[@Upsidestrength]

Done 👍

[@deez9002]

This is excellent! Although would you have to completely restructure the program if you had a client do more than 1 session a week?

[@Upsidestrength]

I’ve got a bunch of sessions in each tab so they can complete multiple!

[@adicusbird3986]

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?

[@Upsidestrength]

You got it I duplicate the original each time and rename it after it’s completed

[@lanaa.6575]

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.

[@Upsidestrength]

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 KZbin 🙏

[@nicholasneuhoff]

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

[@Upsidestrength]

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!

[@TheJW0202]

This is great! :) Am I allowed to use your library with video links, create my own spreadsheets to sell to trainers?

[@Upsidestrength]

If you’re going to sell it you should at least go through the effort of shooting your own videos 😉

[@leibomsvairis]

Wow, amazing, perfect job done here!

[@Upsidestrength]

Much appreciated thank you!

[@janyeweri]

I love this!!!! Can you consider creating a template?

[@Upsidestrength]

Email me I’ll share it

[@cs9583]

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

[@Upsidestrength]

Some setting don’t exist on other platforms unfortunately!

[@dar540]

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.

[@Upsidestrength]

The see it as it is and can fill it out. Different approaches work!

[@mobilitytactics9877]

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?

[@Upsidestrength]

Hit me up via email 👍 took me the last 7 years (on and off of course 😉)

[@mostafataha7507]

Awesome guidance thank you very much

[@Upsidestrength]

You’re welcome!

[@dw7859]

Wish I had these skills to make this. Is this downloadable?

[@Upsidestrength]

Send me an email!

[@strengthbody7941]

Great work 😀💪

[@Upsidestrength]

Thanks!

[@Baileyooo7]

Unreal. Thanks

[@Upsidestrength]

Anytime!