• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
The BarBend Logo in white.

BarBend

The Online Home for Strength Sports

  • News
    • CrossFit
    • Strongman
    • Bodybuilding
    • Powerlifting
    • Weightlifting
    • HYROX
  • Reviews
    • Recovery
      • Best Cold Plunges
      • Best Saunas
      • Best Mini-Massage Guns
    • Supplements
      • Best Protein
        • Best Vegan Protein Powders
        • Best Whey Isolate Protein Powders
        • Best Mass Gainer
        • Best Protein Bars
      • Best Pre-Workouts
        • Best Pre-Workout for Women
        • Best Pre-Workouts for Men
        • Best Non-Stim Pre-Workouts
        • Strongest Pre-Workouts
      • Best Creatine
      • Best Electrolyte Supplements
      • Best Greens Powder
      • Best Meal Replacements
      • Best Nitric Oxide Supplements
      • Best Fat Burners
      • Individual Supplement Reviews
    • Cardio Equipment
      • Best Treadmills
      • Best Rowing Machines
      • Best Exercise Bikes
      • Best Ellipticals
      • Best Recumbent Bikes
      • Individual Cardio Equipment Reviews
    • Strength Equipment
      • Best Adjustable Dumbbells
      • Best Dumbbells
      • Best Kettlebells
      • Best Barbells
      • Best Squat Racks
      • Best Weight Benches
      • Best Resistance Bands
      • Best Leg Extension Machines
      • Individual Strength Equipment Reviews
    • Apparel
      • Best Weightlifting Shoes
      • Best Cross Training Shoes
      • Best Running Shoes
      • Best Gym Shorts
    • Fitness Tech
      • Best Running Apps
      • Best Fitness Trackers
      • Best Workout Apps
      • Best Smart Scales
    • Support Gear
      • Best Lifting Straps
      • Best Gym Bags
      • Best Lifting Gloves
      • Best Wrist Wraps
  • Nutrition
    • Diets
      • Carb Cycling
      • Vertical Diet
      • Reverse Dieting
      • Carnivore Diet
      • Ketogenic Diet
      • Intermittent Fasting
      • IIFYM Diet
    • Muscle Gain
      • How to Dirty Bulk
      • Go From Cutting to Bulking
      • Eat These Carbs
      • How to Eat for Muscle
    • Fat Loss
      • Macros for Fat Loss
      • Calorie Deficits
      • Natural Fat Burners
      • Cut 2 Pounds Weekly
    • Supplement Guides
      • Pre-Workout
      • Whey Protein
      • Mass Gainers
      • Greens Powders
      • Creatine
      • BCAAs
    • Daily Protein Needs
    • Pre- and Post-Workout Nutrition
    • Foods With Creatine
    • Bulking Tips
  • Training
    • Exercise Guides
      • Deadlift
      • Bench Press
      • Back Squat
      • Overhead Press
      • Lat Pulldown
      • Shoulder Exercises
      • Chest Exercises
      • Ab Exercises
      • Quad Exercises
      • Biceps Exercises
    • Training Guides
      • Beginner’s Guide to the Gym
      • How to Build Muscle
      • Guide to Muscle Hypertrophy
      • How to Train on a Cut
    • Workouts
      • Back Workouts
      • At-Home Workouts
      • Chest & Back Workouts
      • Full-Body Workout
      • HIIT Workouts
      • Bodybuilding Workouts
      • Farmer’s Carry Workouts
    • Programs
      • 5×5 Program
      • Bodybuilding Programs
      • Push-Up Program
      • Pull-Up Program
      • 5/3/1 Program
      • Powerbuilding Program
      • German Volume Training
      • Build Your Own Program
  • Calculators
    • Protein Intake Calculator
    • Macros Calculator
    • BMR Calculator
    • Squat Calculator
    • Calorie Calculator
  • Community Forum
Home » How to Build Your Own 1-Rep Max Calculator

How to Build Your Own 1-Rep Max Calculator

This tool can help you realize your training potential.

Written by Jake Boly, CSCS
Last updated on August 14th, 2023

A useful skill that every strength athlete, coach, and trainer should possess is how to build calculators in Excel. This provides one with the ability to find their 1-rep max and easily program percentages based off of those 1-rep maxes.

There are multiple ways to calculate a 1-rep max, which include a variety of 1-rep max estimations. Everyone has their favorite way of finding a 1-RM, but for the sake of brevity we’re going to use one, and that’s the NSCA’s calculations from their book Essentials of Strength and Conditioning 4th Edition.

Chart from Essentials of Strength and Conditioning 4th Edition.

Before we can begin to dive into the logistics of building spreadsheets that automatically pull training percentages, we must first understand how to build a basic 1-rep max calculator (so we have a number to create training percentages from).

1. Setting Up Your Spreadsheet

There are multiple ways to set up your spreadsheet and you can be as creative as you’d like with the surrounding colors, designs, and logos. Personally, I use three calculators for finding an athlete’s max, which include a 3-RM (elite), 5-RM (intermediate), and 8-RM (beginner). 

The reason I use these calculators is because most of my clients aren’t at a skill level to be testing a true 1-RM. For example, my younger athletes who play other sports won’t necessarily benefit from finding a true 1-RM deadlift (risk:reward ratio isn’t there in my eyes). Yet, that doesn’t mean you can’t use a 2-RM or 4-RM calculation, so keep in mind this is only my method for finding a client’s estimated 1-RM.

2. Plugging in the Calculations

This is the trickiest part, but also the easiest once you get the hang of it. If you have no experience with Excel, then you might have a bigger learning curve than someone who’s familiar with the program already.

Once you’ve decided on your 1-RM numbers, then now it’s time to plug them in. Below is an example of how you’re going to plug in formulas that correspond with the spreadsheet cells of your choosing. 

  • Start by selecting a cell that you’d want to write your final rep weight in, aka the weight you lifted (mine was B5 where I hit 275 for 3).
  • Next, choose a cell you want your 1-RM equation to show up in (mine was C5 for an estimated 3-RM equation).
  • From my example, you’d click on C5, which is where I want the final estimated 1-RM for 3-reps to display and I’d write “=B5*1.08” in the cell.
  • “=” tells Excel that I want a product, or answer to my written equation.
  • “B5” tells Excel to pull the number from the B5 cell into my written equation.
  • “*” tells Excel to multiply B5 by what I choose.
  • “1.08” (3-RM equation) is the number I’m telling Excel to multiple my B5 cell to for my final answer, which will show up automatically in C5.

Wrapping Up and Percentages

Once you’ve conquered calculating 1-RMs, then you can move onto programming training intensities. For percentages, you’d write similar formulas to the 1-RM calculation and manipulate intensities accordingly to your max.

For example, 80 percent would be .80 in Excel. You’d simply select the cell you’d want your training intensity to show up in and pull in the cell your 1-RM is represented in. If we used my example above, then we’d click our desired product cell, let’s say D5, and write something like “=C5*.80” if we wanted 80%. 

We’re telling Excel to take C5 (our 1-RM cell) and to multiply it by .8 to give us our 80% training intensity. 

Hopefully this article helped clear up some confusion around using Excel to calculate 1-rep maxes. It can be a useful tool when programming for yourself and others in a quick and easily understandable manner. Periodization made simple.

About Jake Boly, CSCS

Jake holds a Master's in Sports Science and a Bachelor's in Exercise Science. Jake formerly served as BarBend's Fitness and Training Editor.

View All Articles

Primary Sidebar

Latest Reviews

Featured image for the Ironmaster Super Bench Pro V2 Review

Ironmaster Super Bench Pro V2 Review (2025): Our Expert’s New Favorite FID Bench

Titan T3 Power Rack Review

Titan T3 Power Rack Review (2025): An Expert-Approved Rig Beckoning to Budget-Minded Athletes

Our tester works out at the beach in preparation for the Rogue Resistance Bands Review

Rogue Resistance Bands Review (2025): Tested by a Certified Personal Trainer

Barbend tester Jake Herod works out on a Force USA Trainer

Force USA G3 Review (2025): Our Experts Tested This Compact All-In-One Rack for Small Home Gyms

BarBend

BarBend is an independent website. The views expressed on this site may come from individual contributors and do not necessarily reflect the view of BarBend or any other organization. BarBend is the Official Media Partner of USA Weightlifting.

  • About Us
  • Advertise With Us
  • Contact Us
  • Facebook
  • Instagram
  • Twitter
  • YouTube
  • Pinterest

Sections

  • CrossFit
  • Strongman
  • Bodybuilding
  • Powerlifting
  • Weightlifting
  • Reviews
  • Nutrition
  • Training

More

  • BarBend Newsletter
  • BarBend Podcast
  • The Ripped Report
  • 1RM Calculator
  • BMR Calculator
  • Macros Calculator
  • Protein Calculator
  • Squat Calculator

Policies

  • Accessibility
  • Advice Disclaimer
  • Cookies Policy
  • Disclaimers
  • Disclosures
  • Editorial Policy
  • Privacy Policy
  • Terms of Use

Copyright © 2025 · BarBend Inc · Sitemap