Programs made by professionals are usually done in an Excel sheet; these programs are mostly based on the percentage of 1RM. In the Excel sheets, a cell can be created to input the 1RM of any exercise to automatically calculate the weight to be used based on the % of 1RM, e.g., squat, deadlift, and bench press. Once the 1RM is added to the routine, the exercises look as follows:

Enter Your Maxes Here:

Squat: 100 kg
Bench Press: 100 kg

Excercise | RM | Reps | Sets | Weight
Squat (50%) 4 1 50

Squat (60%) 4 4 60

Bench press (50%) 5 1 50

Bench press (60%) 4 1 60

Bench press (70%) 3 1 70

Bench press (75%) 2 4 75

Squat (55%) 3 1 55

Squat (65%) 3 1 65

Squat (75%) 2 4 75

The weight tab is automatically calculated based on the 1RM that the client added.As you can see, the weights the client should work with were automatically calculated as would be done in a program made in Excel.

If you need a reference on how this works, I recommend downloading a template from the famous powerlifting coach Boris Sheiko.

Regarding the exercises, all exercises created should have the option to be programmed based on the % of RM at the time of creation.

From 30% 1RM to 130% of 1RM.

The calculator can be at the top of each workout or on an extra tab, where all kinds of similar calculations can be made, and the 1RM of the exercises programmed by the coach can be added there.