Weight Loss Spreadsheet in Stones and Pounds

Tracking weight loss is essential for keeping fit. Fortunately, Microsoft Excel allows us to easily track our weight loss in a spreadsheet. With this intention, this article demonstrates how to create a weight loss spreadsheet in stones and pounds.


Download Practice Workbook

You can download the practice workbook from the link below.


What Is a Stone?

Firstly, let’s familiarize ourselves with stone. A stone is a measurement of weight that is approximately equal to 6.35 kg or 14 pounds. In fact, this unit of measurement is used to measure human body weight.

1 stone = 14 lbs

1 stone = 6.35 kg


2 Examples of Weight Loss Spreadsheet in Stones and Pounds 

Now, let’s assume the following dataset where you have the Starting Weight, Target Weight, Start Date, End Date, Gender, Age, and a Weight Loss Tracker for a month. So, without further delay, let’s explore the process of tracking weight loss step-by-step.

Dataset 1


1. Calculating Weight Loss in Stones and Pounds with MOD Function

Let’s say you want to track your weekly weight loss in stones and pounds. Then, you’ve come to the right place. Right now, follow these steps to track your weekly weight loss in stones and pounds for a month.

Steps:

  • At the very beginning, insert a column with the heading Weight Loss.
  • Next, insert the following formula to convert pounds to stones and pounds.

=CONCATENATE(ROUNDDOWN((D9-E9)/14,0)," st & ",MOD((D9-E9),14)," lbs")

Here, the D9 and the E9 cells refer to the Previous and the Current Weights respectively.

Formula Breakdown

  • In the above formula, the (D9-E9)/14 (number argument) and 0 (num_digits argument) are rounded to the nearest integer with the ROUNDDOWN function.
  • Then, D9-E9 (number argument) and 14 (divisor argument) of the MOD function return the remainder after the division.
  • Lastly, the ROUNDDOWN((D9-E9)/14,0),” st & “ (text1 argument) and MOD((D9-E9),14),” lbs” (text2 argument) are combined with the CONCATENATE function.

Weight Loss Spreadsheet in Stones and Pounds Using MOD Function

  • Then, drag the Fill Handle tool to copy the formula in the cells below.

Using Fill Handle Tool

Finally, the results appear as shown in the picture below.

Weight Loss Spreadsheet in Stones and Pounds Using MOD Function

Read More: How to Use Formula for Tracking Weight Loss in Excel (2 Examples)


2. Applying CONVERT Function to Calculate Weight Loss in Stones and Pounds

In case you want to track your weight loss from kilogram to stones and pounds, our next example has you covered. In a similar fashion, Dataset 2 represents the weights in kilograms instead of pounds.

Dataset 2

Steps:

  • Firstly, make a column for Weight Loss.
  • Then, insert the following formula to convert kg to stones and pounds.

=INT(CONVERT((D9-E9),"kg","lbm")/14)&"st"&ROUND(MOD(CONVERT((D9-E9),"kg","lbm"),14),0)&" lbs "

Formula Breakdown

  • In the formula above, the D9-E9 is the number argument, next “kg” is the from_unit argument, and lastly, “lbm” is the to_unit argument.
  • Following, the CONVERT function uses these 3 arguments to convert the kg to pounds.
  • Secondly, the INT function takes CONVERT((D9-E9),”kg”,”lbm”)/14 as the number argument and returns only the integer value.
  • Thirdly, CONVERT((D9-E9)),”kg”,”lbm” (number argument), and 14 (divisor argument) of the MOD function give the remainder of the division.
  • Then, the ROUND function rounds the above value to the nearest integer.
  • Eventually, the “st” and “lbs” strings are joined with their corresponding values using the Ampersand (&) operator.

Weight Loss Spreadsheet in Stones and Pounds Using CONVERT Function

Lastly, the results should look like the picture shown below.

Weight Loss Spreadsheet in Stones and Pounds Using CONVERT Function

Read More: How to Use the CONVERT Function in Excel and creating a BMI Calculator template


Conclusion

To conclude, I hope this article helped you understand how to create a weight loss spreadsheet in stones and pounds in Excel. If you have any queries, please leave a comment below. Also, if you want to read more articles like this, you can visit our website ExcelDemy.


Related Articles

Eshrak Kader

Eshrak Kader

Hello! Welcome to my Profile. I completed my BSc. at Bangladesh University of Engineering & Technology from the Department of Naval Architecture & Marine Engineering. Currently, I am conducting research & posting articles related to Microsoft Excel. I am passionate about research & development and finding innovative solutions to problems.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo