First of all I want to thank you for all of your free stuff.
I started today with ‘the bridge’ and I am still struggling with the RPE-calculations/feelings, but my first training went pretty well.
Now to my question:
Could anyone provide me with an excel for the bride? If not, I will have to write down every training. It would be great to have an excel with all the calculations and where I can write in my weight. It could be my log as well.
Each week has it’s own tab sheet, and it should print out on both UK and US paper sizes. I haven’t tested it on mobile devices though
Jordan has previewed it, so i’m assuming it’s not totally borked
Take a look, download it, i hope you find it useful. If it doesn’t do the trick, let me know if you have any suggestions for improvements
I have a separate spreadsheet for generating target weights based on my e1RM, the required Reps and RPE. i’d be happy to share this but i think it oughta be vetted by the Docs first. Let me know what you think
Awesome! I was just wondering about this, and particularly the weight calculations because I’m awful at math and it takes me a lot of paper and pencils to work things out. Being able to type it in and calculate it ahead of time, for the most part, is pretty helpful.
Thank you very much for your Excel-Sheet. This is, what I was talking about. What do you mean by ‘Stack’? (sorry, I am not a native English-speaker)
What I am missing are those target weights (1RM based) you already mentioned to use BEFORE the training.
Second thing that would be great:
I’m sure it is possible to insert the RPE/Rep table and make a calculation with those percentages, the RPE, the reps and the weight used. So we will need one column to calculate the 1RM after you inserted the weight used in the training. This shows your calculated 1RM (AFTER training) and helps to compare your performance on this given exercise.
When we manage it, to insert those two functions, I am sure, we have the perfect Excel-Sheet for this training program.
I keep on trying to fix it, but I am not an Excel-pro.
I’m using “Stack” to mean the weight-plates that i load onto EACH end of the bar. So i don’t waste time at the gym scratchin’ me head, trying to work it out
Could you pls check it out and confirm that it’s OK to use;
Instructions:
On the calculator sheet, enter the smallest weight-plate value into <Inc.>, and then your e1RM for the lift, and the number of Reps from the programme. It’ll then spit out ‘target’ weights for each of the RPE levels, and then round it UP in increments so you’ll have your actual bar weight in the column
On each of the PR tabs, just log the date you made the lift, the weight, number of Reps and your estimation of the RPE on the day. It’ll then give you your e1RM
You’ll need to add in some more rows for each of the lift variants as you do them, but that’s just copy ‘n’ paste, innit?
BTW - it doesn’t care about lbs or Kgs, as long as you use just ONE system throughout
If you’re OK with us using this, pls give it good thrashing and report any defects
Okey, this makes sense!
BUT: I am still getting used to the RPE sets, so I always start with warm up weight and go up to the weight I feel the RPE number required. So I have a weight in my mind I want to hit, but don’t go straight to that number. So it’s not really important to find the fastest way to bring those plates on the barbell. But still nice to know.
I took a look at your calc and I like it. Trying the next days to implement it into the other Excel-File. Thank you very much for your help.