If you have ever tried to lose weight during a diet, you might have asked yourself how much effort should I put in to drop a certain amount of weight in my diet? Also during a diet, you might simply ask yourself how much weight I have lost so far? For the second question, you might answer: I would weigh myself everyday to find out the amount of weight I have lost so far but the problem is not that simple.

First of all the process of losing weight in a diet is not always gradual but instead it is sometimes a sudden process. In other words during your diet, you might experience 7-10 days with no weight loss and after that all of a sudden in a few days, you would experience a significant amount of weight loss in your diet. Second, if you scale yourself every morning to measure your weight loss, you might not always find the right answer. Your body might have extra body water or your stomach might not be completely empty and that makes a significant error in measuring your total weight loss during your diet.

**Theory of our calculations**

In this article, I am trying to introduce a method to calculate the amount of weight loss during someone’s diet using calorie counting. In order to maintain your weight in a day, someone’s intake calories should be equal to that person’s burning calories. In order to lose weight, your burning calories should be more than your intake calories and for gaining weight, your intake calories should be more than your burning calories. In our case, we definitely need to lose weight so our intake calories should be less than our burning calories but the main question here is how to find the calorie equivalent of everything in this process.

**Calorie calculations**

For your intake calories, the answer is simple. You might measure how many calories you consumed during each day. Your burning calories during each day contains two parts (and we have to add them up together to evaluate your total burning calories in each day). Your Basal Metabolic Rate (BMR) and the amount of calories you burn during your activities in a day.

Basal metabolic rate is the amount of calories your body needs to accomplish its most basic (basal) life-sustaining functions. One popular way to estimate BMR is through the Harris-Benedict formula, which takes into account weight, height, age, and gender (reference Here). Below is the BMR formula for women and men respectively: (you can alternatively use this website to calculate your BMR)

Women BMR = 655 + (9.6 × weight in kg) + (1.8 × height in cm) – (4.7 × age in years)

Men BMR = 66 + (13.7 × weight in kg) + (5 × height in cm) – (6.8 × age in years)

You also need to calculate your burning calories during your daily activities as well. That greatly depends on the source of your burning calories each day. Some fitness trackers estimate your burning calories so that’s an option. In my case my main source of burning calories during my diet is by walking so I found a way to estimate my burning calories each day using my total steps.

This website estimates your total burning calories using your age, gender, height, weight, speed and duration. I recommend calculating your burning calories for 100 minutes to minimize the approximation error. In my case my burning calories per 100 minutes was 621 calories i.e. 6.21 calories per minute. My walking cadence (number of steps in one minute) is usually 120 so my burning calories per each step is usually 6.21/120 calories. Therefore, my total burning calories for a certain number of steps is equal with steps*6.21/120 .

**Maximizing the accuracy of burning calories estimation**

Remember by means of time during your diet as you lose weight, both your BMR and your burning calories by your activities during the day would change so you’d better update your numbers in the websites I provided above once every month. For example my (BMR,100 minutes walking burning calories) when I was 79.5 kg were (1795,621) calories respectively but one month later when I dropped 3.5 kg the corresponding numbers were (1748, 607) calories respectively.

**Required calories for losing weight and the assumptions**

Now we have an idea about the calculation of intake and burning calories. For example, let’s assume at the beginning of my diet, I had 15000 steps in one day as the main source of my burning calories and my total intake calories in that day has been 1500 calories. The question is how much weight loss should I expect after that day so let’s do the calculation.

My BMR using the formula I provided above was 1795 calories. My burning calories for 15000 steps on that day using the formula above was 15000×6.21/120=776 calories. Therefore my total burning calories on that day is equal to 1795+776=2571. As a result my burning calories minus my intake calories is equal to 2576-1500=1076 calories. But how much weight loss should I expect for burning 1076 extra calories?

The answer depends on whether you are burning fat, muscle or LBM/protein. There are 3500 calories worth of energy in one pound of fat (7709 calories per kg) and 700 calories worth of energy in one pound of muscle tissue (reference Here). If a person creates a 3500 caloric deficit, that deficit does not come solely from fat but for simplicity of our calculation, we assume that person is solely burning fat. Of course that would lead to an error in our calculations but remember we are just doing an approximation for our calculation.

Back into our example and using the above assumption, a 1076 calorie deficit would lead to 1076/3500=0.307 lb or 1076/7709=0.139 kg of weight loss.

**Calculating weight loss for long term data using Google sheets **

Assume you have your intake calories data for one month and you have also stored your total daily steps as your main source of burning calories for one month. The question is how much weight loss you should expect during that month of your diet. I am answering that question using google sheets and I want to emphasize based on the above explanation, the accuracy of our method would decrease for data more than one month and you have to rebuild your table every month. I am using my own data for one month to show you my method and I will compare the results with my daily weight I measured every morning during that month. The final google sheets data is available in this file.

Let’s start with 7 days of data and we assume we would add each day’s data to the google sheets table at the end of each day. Our table starts with the following data:

A | B | C | |

1 | Intake Calories | Steps | Weight (kg) |

2 | 1490 | 0 | 78.2 |

3 | 2060 | 81 | 78.41 |

4 | 1730 | 22060 | 78.4 |

5 | 2100 | 15324 | 78.6 |

6 | 1160 | 0 | 78.4 |

7 | 1380 | 2641 | 78.3 |

8 | 1430 | 25698 | 79.2 |

Now our main goal is to see our weight loss each day and add them up together since day one to know our total weight loss. Therefore we would add two columns called weight loss and total weight loss in our google sheets file. The formula for my weight loss cell is as follows:

=(1795+B2*6.21/120-A2)/7709*1000 |

If you want to generate the above formula for yourself, you might replace 1795 by your BMR, 6.21 by the amount of calories you burn in one minute of walking and 120 by your walking cadence (your total walking steps per one minute). 7709 would remain the same (there are 7709 calories worth of energy in one kg of fat). We drag this formula in the google sheets file to generate the entire column and we would get a table like this:

A | B | C | D | |

1 | Intake Calories | Steps | Weight (kg) | Weight Loss (g) |

2 | 1490 | 0 | 78.2 | 40 |

3 | 2060 | 81 | 78.41 | -34 |

4 | 1730 | 22060 | 78.4 | 157 |

5 | 2100 | 15324 | 78.6 | 63 |

6 | 1160 | 0 | 78.4 | 82 |

7 | 1380 | 2641 | 78.3 | 72 |

8 | 1430 | 25698 | 79.2 | 220 |

Remember in that table negative weight loss means gaining weight. Now in the last column, we want to have the sum of elements of column D. In terms of google sheets formulas, in the last column, we want to have the following numbers respectively from the bottom: sum(D8:D8), sum(D7:D8), sum(D6:D8),…,sum(D2:D8). For that purpose we need to use the $ sign in order to keep one variable constant. Therefore use the following formula in the last column and drag it to the top to generate the formula for the entire column. The formula is:

=sum($D$8:D8) |

After generating the formula for the entire column we have:

A | B | C | D | E | |

1 | Intake Calories | Steps | Weight (kg) | Weight Loss (g) | Total Weight Loss (g) |

2 | 1490 | 0 | 78.2 | 40 | 599 |

3 | 2060 | 81 | 78.41 | -34 | 560 |

4 | 1730 | 22060 | 78.4 | 157 | 594 |

5 | 2100 | 15324 | 78.6 | 63 | 437 |

6 | 1160 | 0 | 78.4 | 82 | 374 |

7 | 1380 | 2641 | 78.3 | 72 | 291 |

8 | 1430 | 25698 | 79.2 | 220 | 220 |

Finally we would make the last column which is our approximation for each day’s weight using calorie counting and compare it to the actual weight of that day measured at the beginning of the day by scale. The formula for the last column is:

=$C$8-E8/1000 |

By dragging the formula in google sheets, making the last column and rearranging the columns we’ll have the following table:

A | B | C | D | E | F | |

1 | Intake Calories | Steps | Weight (kg) | Calorie Counting Weight (kg) | Weight Loss (g) | Total Weight Loss (g) |

2 | 1490 | 0 | 78.2 | 78.6 | 40 | 599 |

3 | 2060 | 81 | 78.41 | 78.6 | -34 | 560 |

4 | 1730 | 22060 | 78.4 | 78.8 | 157 | 594 |

5 | 2100 | 15324 | 78.6 | 78.8 | 63 | 437 |

6 | 1160 | 0 | 78.4 | 78.9 | 82 | 374 |

7 | 1380 | 2641 | 78.3 | 79.0 | 72 | 291 |

8 | 1430 | 25698 | 79.2 | 220 | 220 |

Now I will show the google sheet result for the entire 30 days:

Calorie Intake | Steps | Weight (kg) | Calorie Counting Weight (kg) | Weight Loss (g) | Total Weight Loss (g) |

2090 | 9332 | 76 | 76.1 | 24 | 3120 |

1710 | 22734 | 76.8 | 76.3 | 164 | 3096 |

1530 | 22260 | 76.7 | 76.5 | 184 | 2932 |

1165 | 26054 | 77.7 | 76.7 | 257 | 2748 |

660 | 27037 | 77.7 | 77.0 | 329 | 2491 |

3640 | 9170 | 77.2 | 76.9 | -178 | 2163 |

1685 | 0 | 76.8 | 76.9 | 14 | 2341 |

1560 | 22355 | 77.4 | 77.1 | 181 | 2326 |

1271 | 24926 | 77.7 | 77.3 | 235 | 2146 |

1410 | 0 | 77.4 | 77.3 | 50 | 1910 |

1990 | 22536 | 77.5 | 77.5 | 126 | 1860 |

740 | 24183 | 78.5 | 77.8 | 299 | 1734 |

3040 | 17717 | 77.8 | 77.7 | -43 | 1435 |

2026 | 22050 | 77.5 | 77.8 | 118 | 1478 |

1730 | 22269 | 77.4 | 78.0 | 158 | 1360 |

1870 | 25362 | 77.9 | 78.2 | 161 | 1202 |

1795 | 21853 | 78 | 78.3 | 147 | 1041 |

1800 | 15895 | 78.5 | 78.4 | 106 | 895 |

1690 | 21078 | 79 | 78.6 | 155 | 789 |

2110 | 7186 | 78.71 | 78.6 | 7 | 633 |

3230 | 22145 | 78.7 | 78.5 | -37 | 626 |

1940 | 0 | 78.5 | 78.5 | -19 | 664 |

2190 | 20004 | 78.21 | 78.6 | 83 | 682 |

1490 | 0 | 78.2 | 78.6 | 40 | 599 |

2060 | 81 | 78.41 | 78.6 | -34 | 560 |

1730 | 22060 | 78.4 | 78.8 | 157 | 594 |

2100 | 15324 | 78.6 | 78.8 | 63 | 437 |

1160 | 0 | 78.4 | 78.9 | 82 | 374 |

1380 | 2641 | 78.3 | 79.0 | 72 | 291 |

1430 | 25698 | 79.2 | 220 | 220 | |

Intake Calories | Steps | Weight (kg) | Calorie Counting Weight (kg) | Weight Loss (g) | Total Weight Loss (g) |

As you can see, the result is surprisingly accurate. After 30 days when I experienced my last sudden weight loss, my actual weight was 76.0 kg and my calorie counting weight was 76.1 kg and the error was literally negligible.