Excel Weight Tracker

Recording your weight goals and tracking your progress, are two major factors in achieving these goals. Tracking promotes a sense of accountability, and helps to illuminate trends in your gains and losses. As such, I am attaching an excel weight tracker that I’ve created in order to help you meet your goals — Excel Weight Tracker

Track Weight In Excel

 

 

 

 

 

In the screenshot above, you’ll see the only 4 inputs you’ll need to know to create your own weight tracker. I’ve protected the entire sheet (with the exception of these four cells (and your daily weight input cells)) to help avoid folks messing up the equations. If you feel comfortable in excel or want to make your own modifications, simply go to the “Review” tab and click “Unprotect Sheet”. There is no password, just clicking the button should make the entire file editable.

After filling in these 4 inputs, you’ll notice the spreadsheet will automatically change. It will display the dates until your goal deadline, and it will show a steady decrease in your current weight to the goal weight. Next to these projected weights, you’ll find a column for you to input your actual daily weights. At this point, your daily tracking should be fairly straight forward…see below:

Weight Tracker After Inputs

 

 

 

 

 

 

 

 

 

 

(the chart continues past this screenshot — this simply depicts the changes that occur to the document after filling in the first 4 inputs)

Once you’ve recorded a couple weeks or two worth of daily weights, you may want to see your progress in a chart form. In order to do this:

  1. Go to the “Review Tab”
  2. Click “Unprotect Sheet”
  3. Highlight all data from B6:D6 down to where the date column stops showing dates.
  4. Go to “Insert” Tab
  5. Click “Line” chart icon (pick the first one down in the dropdown)

Once completed it should (hopefully) look something like this.
Weight Tracker Chart

 

 

 

 

 

 

 

 

Now you can graphically see how awesome you’re progressing in meeting your goals. Good luck! Hope this helps!

To download the original template use this link: Weight Tracker

 

New One Rep Max App

FSL has finally released our mobile one rep max calculator!

The app is only available on Android devices, and you can find it here: Functional Strength Lab’s Mobile One Rep Max Calculator.

We still offer our web-based max calculators for:

(Tip: I’ve actually broken these lifts out into separate calculators, but in actuality the formulas are the same. They are based on well known one rep formulas that can be researched more in depth here.)

Don’t forget to contact us if you have any questions/suggestions:
functionalstrengthlab@gmail.com

How the One Rep Max is Calculated

Have you ever wondered how your one rep max is calculated? Before creating Functional Strength Lab’s 1RM calculator, I asked the same question. I visited many sites to determine the math and reasoning behind the various calculations. Some of my findings were very interesting:

  1. There are seven distinct formulas that have been proposed to calculate 1RM’s. Two have become the industry standards: Epley & Brzycki. The five other calculations are slightly more complicated and are less recognized: Lander, Lombardi, Mayhew et al., O’Conner et al., & Wathan
  2. All calculations can be used interchangeably for all of the big three lifts: Bench Press, Squat, Dead Lift.
  3. All calculations require a weight that you can rep out for more than two reps, but less than 10-12 to remain fairly accurate.
  4. These calculations can help you avoid injuries that often result from actually performing your One Rep Max. While it’s difficult to refrain from “proving” your strength through one rep maxes, it seems pointless when you can craft your workouts using the fairly accurate figures that these calculations will spit out.

 

Various Calculations (where “r” stands for reps and “w” stands for weight used):

***Most Commonly Recognized 1RM Formulas***

Epley Formula

1RM = w \left ( 1 + \frac{r}{30}\right )

 

Bryzicki Formula1RM = w \cdot \frac {36}{ \left ( 37 - r \right ) } = \frac{w}{ \left [ \frac{37}{36} - \left ( \frac{1}{36} \cdot r \right ) \right ] } \approx \frac{w}{ \left [ 1.0278 - \left ( 0.0278 \cdot r \right ) \right ] }

 

***Less Recognized 1RM Formulas***

 

Lander Formula

1RM = \frac{100 \cdot w}{101.3 - 2.67123 \cdot r}

 

Lombardi Formula 

1RM = w \cdot r^{0.1}

 

Mayhew, et al.

1RM = \frac{100 \cdot w}{52.2 + 41.9 \cdot e^{-0.055 \cdot r} }

 

– O’Conner et al.

1RM = w \cdot (1 + 0.025 \cdot r)

 

Wathan

1RM = \frac{100 \cdot w}{48.8 + 53.8 \cdot e^{-0.075 \cdot r}}

 

You can either crack open your notebook and start using these formulas yourself, or you can use these pre-crafted 1RM calculators created by Functional Strength Lab:

1RM Bench Calculator

1RM Squat Calculator

1RM Dead Lift Calculator

(Hint: As I’ve already mentioned, these are the same calculators!!!)

Quantified Self Worksheets

Fitness Measurements
Quantified Self Workbook

If you are looking for a quick and easy way to track your fitness progress, please sign up for my mailing list, and I will send you a FREE Quantified Self Worksheet. The worksheet will be in Excel format and will allow you to plug in information about yourself to generate your present fitness standing.

Sign up below, and I will personally email you the Free Quantified Self: Excel Workbook Attachment:




BMI Calculator

Brian Dick

Do you want to calculate your BMI? Type in your height and weight in the shaded boxes below:

The BMI Calculator Page includes more information on how the BMI is calculated and the controversies surrounding it. You can simply click on this link, or find the BMI Calculator along with many others under the Workout Calculators button on the top right. Hover over the button and select which calculator you want to try out.