Here’s the official Madcow 5×5 spreadsheet v3 updated for 2023.
- It calculates your starting weights
- It automatically adds weight each week
- It adjust your weights if you miss reps
Tap the button below to download it for free:
Let me show you how to use the spreadsheet for Madcow 5×5.
Copy the Madcow 5×5 spreadsheet
The Madcow 5×5 spreadsheet is hosted on Google sheet. Before you can edit this file, you need to make a copy for yourself.
- Open the Madcow 5×5 spreadsheet
- Tap “File” in the top right corner
- Tap “Make a copy”
This will copy the Madcow 5×5 spreadsheet to your Google Drive. After that you can use it like this…
- Go to your Google Drive
- Open your copy of the Madcow 5×5 spreadsheet
- Use that spreadsheet to calculate your weights
Don’t request access to edit my Madcow 5×5 spreadsheet. If I did that, everyone would use the same sheet. Someone else would overwrite your data, making the spreadsheet unusable for all of us.
Make a copy of the spreadsheet for your own use.
How the Madcow 5×5 spreadsheet looks
Here’s a screenshot of the main workout area…
Your weights automatically increase every week. Your starting weights are calculated based off your best lifts. Here’s how to enter them in your copy of the Madcow 5×5 spreadsheet…
Enter your best lifts
Start by calculating your starting weights for Madcow 5×5.
You do this by entering your best lifts in the spreadsheet. These should be lifts you’ve done in the past 3-4 weeks (not a year ago or so).
- Select lb or kg in C15-19
- Enter how much weight you lifted in D15-D19
- Enter how for how many reps you lifted that weight in E15-E19.
- Enter the RPE for that set – how many more reps you could have done (0=10RPE, 1=9RPE, 2=8RPE, 3=7RPE).
Your spreadsheet does two things with that information:
- Estimate your one rep max at RPE10 – how much weight you could lift for one rep if you’d go all out.
- Estimate your five rep max at RPE9 – how much weight you could lift for 5 reps with one rep left in the tank.
Those two estimates show in the gray cells G15-H19.
Don’t change the gray cells G15-H19. If you do, your spreadsheet will break. It needs this data to calculate your starting weights.
Leave the default settings
The Madcow 5×5 spreadsheet has three settings you can change.
- Increments: how much weight you add per week (5lb is 2.5/side). Bench, Overhead Press and Row default to smaller increments because these lifts use smaller muscles.
- On-ramp: how many weeks it takes to match your previous best. This is set to 4 weeks by default. Shorter on-ramps will not make you stronger faster but plateau faster.
- Set intervals: the size of the weight jumps between sets. Smaller intervals add more hard sets and increase the volume. This makes each Madcow 5×5 workout harder.
These settings are in the yellow cells I15-K19.
The most common reasons for plateaus are increasing the increments and decreasing the on-ramp. Best is to leave the default settings the first time you do Madcow 5×5. Don’t change them.
Automatic weight calculation
The Madcow 5×5 spreadsheet automatically increases your weights for you each week. It also adjusts the weights if you fail to complete your reps. Example:
Here’s what happened:
- You Squatted 5x300lb on set five of week 11 (cell Y30, Z30).
- In week 12 you add 5lb and do 5x305lb. But you only get three reps instead of five (3x305lb – cell AA30, AB30).
- In week 13 the weight doesn’t increase but repeats. You get another try with 5x305lb (cell AC30, AD30).
The Stronglifts app does the same calculations for you when you do Madcow 5×5. And it does it a lot better than this spreadsheet.
Madcow 5×5 Spreadsheet vs Stronglifts app
Everyone used this spreadsheet until we added support for Madcow 5×5 to the Stronglifts app. It was our most requested feature and took a lot of work. But we did it and now the spreadsheet is obsolete.
The Stronglifts app does everything the spreadsheet does but better. It also does a lot more than the spreadsheet. Compare…
|Starting weight calculator||✓||✓|
|Workouts planned for you||✓||✓|
|Automatic weight increase||✓||✓|
|Repeat weight if fail||✓||✓|
|Rest timer between sets||✓|
|Workout duration timer||✓|
|Progress graphs weights||✓|
|Progress graphs volume||✓|
|Log with Apple watch||✓|
|Add assistance work||✓|
|Log any program||✓|
|Ease of use||★ ★ ★ ★☆||★ ★ ★ ★★|
If you print the spreadsheets, you better be good at math. You’ll need to calculate how much weight to add on each side of the bar. Madcow 5×5 uses ramp sets – different weights per set. That’s a lot of math on every set, every exercise and every workout. If you get it wrong and add 10lb too much, that will mess with your progress.
The Google Sheet app is a pain to use. It’s made for accounting on a big screen, not logging workouts on a phone. The cells are hard to tap. You need to zoom in and out all the time. There’s no rest timer. If you have bad internet, your workout sheet won’t load.
The Stronglifts app was made for lifting. Logging sets only takes a tap. The rest timer notifies you for your next set. You don’t need to switch between half a dozen apps during your workout. Everything you need is in the same app – warmup, plate calculator, history, graphs, history, videos, etc. It’s much easier to use than Google sheet.
Other workout apps don’t create your Madcow 5×5 workouts for you. Nor do they add weight automatically. You have to do that yourself. This wastes time better spent lifting and makes mistakes more likely. Some have tried copying us but got it wrong becuase they don’t understand how Madcow 5×5 works (they’re programmers not lifters).
Use the Stronglifts app to log your Madcow 5×5 workouts. If that’s not an option for you, then use the Madcow 5×5 spreadsheet.
My goal is to share the truth about lifting weights. Please contact me if you have questions, suggestions or corrections.