All of my training spreadsheets use grouping to hide the control panels, as well as % columns, to save space. In order to access the control panels, simply click the + sign above the columns. Remember to close those columns before printing the sheets, however!
In order to make exercises properly add to your list and be visible in dropdowns, you need to make sure they "enter the table". Here is a picture of an exercise list that is not properly formatted: Steps to fix this: Close and reopen then sheet, and make sure you have macros enabled. Go back
The platinum level template allows you to create up to 20 of your own exercise categories. Simply type in the category name and press the save disk, and the template will activate your categories!
The platinum level template supports 10 rosters per workbook. Simply type in your roster name and press the save disk button, and the platinum template will active those 10 rosters!
First, go to the athlete max sheet and make sure your sports names do not have any spaces or special characters. Second, press the blue save disk button on the sports page. Then go back, and re-select the sport that you want to show from the dropdown list!
This template is unlike every template we have made before. It is entirely adaptable to YOU! The settings you can change are: 1. Bulk change exercise categories 2. Individual change exercise categories 3. Bulk change roster names 4. Individual change roster names 5. Change program / set and rep category names Dial these in before
You will need to have an active version of outlook on your computer. On the athlete max sheet, assign an email to every athlete. From there, after creating your team program, go to the batch print popup and press the email. On the next popup screen, type in the email subject and body, and press
Sometimes excel does this randomly. Try running the same code again and see if it works. If it does not and you feel it is in error, shoot me an email and let me know!
On the platinum template, there are several factors that go into calculating a weight for an athlete: 1. The global percentage regulator 2. The daily % regulator (in yellow) 3. The set and rep scheme % 4. The exercise % and alt max (When saving exercises, you must assign a % of an exercise to
When creating your exercise categories, sports or program categories, remember you cannot use spaces or special characters. So instead of trying to save something as Horizontal Push, save it as Horizontal_push. Same thing with sport rosters, save them as Mens_Tennis, with the underscore. If all the categories are correctly written, go to the database pages