Health tip – How to use Google Sheets to help stay motivated about your fitness

Fitness-motivation-google-sheets-feature-image

It’s February, and the appeal of the New Year’s resolution to improve your fitness and work on your health has lost a bit of its luster. As this occurs, it’s difficult to regain momentum and then maintain it throughout the year. I’m going to share a few tips for how I’ve been successful at keeping fitness a priority, including how to use Google Sheets to help stay motivated about your fitness. This is personal advice, and am obliged to say that you should consult a physician before beginning an exercise or diet regimen.

Set goals

We all know the importance of setting goals, but here are a few pieces of advice:

  • Weight loss goals are good but bear in mind two things. First, be realistic about how fast you can safely lose weight. According to the Mayo Clinic, you can safely lose about 1-2 pounds per week.1 Second, when you resume training, avoid getting discouraged if you immediately gain weight, particularly if you are doing resistance training. Skeletal muscles are more than 70% water. Weight training may immediately increase water retention which could cause your weight to go up.2 Give it at least a few weeks if not a month or two to see your weight and fat begin to decline. 
  • Set a goal for how often you want to exercise. I’ve found it useful to set an annual, monthly, and short-term goal. My short-term goal is to exercise 2 out of 3 days. In the past, I used a weekly goal such as 4 out of 7 days. However, I found it easy to push things off into weekends, and then once the weekend arrives, I would “struggle to find time” to exercise.
  • Consider setting a goal that will help you balance the number of times you eat out versus eating at home, and likewise set a goal for the frequency of “cheat” meals.

How to use Google Sheets to help stay motivated about your fitness

Years ago, I would check-in at the YMCA and proceed to the filing cabinet to get my workout card. In college, members of our lacrosse team had booklets to track our workouts which we would then hand over to our strength and conditioning coaches. Over the last several years, I’ve begun to use Google Sheets to help track my workouts and stay motivated.  

Nearly everyone at the gym has their phone out between sets, but I wonder how many of them are utilizing their phones to track their fitness progress. Google Sheets has become much easier to use on mobile devices, and those improvements have made it simple for me to track my workouts and progress toward my fitness goals. Here’s what I do. 

I have 2 sheets within the same Google Sheets file:

Sheet 1: Tracks weight and exercise frequency goals

The first sheet has six columns. Of those, I only regularly input information into the three that are highlighted in yellow (Screenshot 1). This sheet also includes a chart that visualizes the data (Screenshot 2).

Screenshot 1
Goal Tracker

Column A: Date

Column B: Wgt (current weight) – I don’t weigh myself daily so I will fill in the missing days using my most recent weight.

Column C: Goal (goal weight) – If I’m attempting to attain a goal weight, I will place it in this column.

Column D: Wrkout (workout) – In this column I place a numerical value that is used for the formulas in columns “E” and “F”. I use a number that is around my typical weight so that the data points will be visible in the accompanying chart for these data as shown in Screenshot 2.

Column E: MTD (month to date) – This column calculates the percentage of days that I have exercised in the month.

Column F: YTD (year to date) – This column calculates the percentage of days that I have exercised in the year.

Screenshot 2

Exercise and Weight Chart

The chart uses the dates in column “A” as the X-axis and it displays the data from columns “B”, “C”, and “D”. This allows me to quickly see my weight vs. my goal weight as well as see how often I have been exercising. For me, it’s been interesting to see the correlation between my weight and the frequency of my workouts.

Sheet 2: Tracks the exercises that I complete during a workout

Each time I workout I record my exercises. This allows me to track my progress over time to see how I’ve increased my strength and endurance. It also helps me avoid doing the same exercises too frequently.

Screenshot 3

Exercise Tracker

To explain the sheet we’ll look at rows 129–134. In row 129, I capture the date and location of my workout. In rows 130–134, I capture the various exercises and the number of reps and the weight used for each set. For instance, in row 131 the exercise I completed was the cable press, and in my first set, I did 12 reps of 135 pounds, columns “B” and “C” respectively. Columns “D” and “E” are set two, columns “F” and “G” are set three, and so forth. And in case you’re wondering, the number next to “run” is the number of calories burned.

Here is a template Google Sheet that you may use

It’s not only about exercise

While this article shares how to use Google Sheets to help stay motivated about your fitness, it’s just as, or more important to be conscious of your diet. A single serving of three Oreo cookies contains 160 calories. These are the cookies that can be inhaled with almost a single bite each. To offset those calories, it would require someone like me to run for about 10 minutes.

Running Calorie Calculator

Source: https://caloriesburnedhq.com/calories-burned-running/

My fitness background

As previously noted, this article is based on personal experience and is meant to provide some ideas to help maintain a healthy lifestyle. My interest in this topic stems from heavy involvement in athletics throughout my life. In high school I lettered in three varsity sports and in college I played lacrosse at the Division I level. More recently I had the opportunity to spend some time in my career working for the National Academy of Sports Medicine.

Have ideas or tips that you’d like to share? Please leave a comment.

One Response

Leave a Reply

Your email address will not be published. Required fields are marked *

Resources
  1. https://www.mayoclinic.org/healthy-lifestyle/weight-loss/in-depth/weight-loss/art-20047752#:~:text=Over%20the%20long%20term%2C%20it’s,diet%20and%20regular%20physical%20activity.
  2. https://www.ooma.com/home-phone/cell-phone-cost-comparison/

Cover photo: Photo by juan pablo rodriguez on Unsplash

Share The Article

Facebook
Twitter
LinkedIn

You might also enjoy

Elevate your career. Get AMLR-PME certified.

The comprehensive marketing certification built by and for business professionals.