Excel Templates | Excel Spreadsheets | Body Fat Calculator



Body Fat Calculator

Posted on November 1, 2009
Filed Under Health | 5 Comments

Pin It

The person’s total body-fat can make a tremendous difference to their body shape and health. Since muscle tissue is more compact than fat, any deposition of fat will cover a greater area than that of muscle. One of parameter that can be used to measure health status of a person is a body fat percentage, where it is defined as the total weight of the person’s fat divided by the person’s weight.

Body Fat Calculator

There are several methods to calculate body fat percentage, and usually the parameter for men and women also different. I choose two popular methods. The first method is Caliper method, which developed by A.S. Jackson, and M.L. Pollock in year 1985, that include weight in the calculation and the second method is developed by US Navy that include height in the calculation. You can read more information about Caliper method here.

Parameters based on US Navy method are :
- Weight (men and women),
- Waist (men and women),
- Wrist (women only),
- Hip (women only),
- Forearm (women only)

Parameters based on Caliper method are :
- Height (men and women),
- Neck (men and women),
- Abdomen (men and women),
- Hip (women only),

If you compare the results of both method, you will find that the variation of the body fat percentage for men are very high for some values. And there is no exact body fat range classification based on the calculated results. Different authorities have different classification based on their research. So, use this result as your brief reference. Always consult your doctor or your health advisor to give you a better objective valuation.

The guidance to use this spreadsheet is simple, just enter your body fat parameter measurement in the corresponding boxes, and the excel formula will give you the body fat percentage and the health classification range based on that percentage.

You can download the file here.



Tags: , , , ,

Comments

5 Responses to “Body Fat Calculator”

  1. Mahmoud Rashad on May 25th, 2010 10:53 am

    I need to add row by row in excel sheet2 automatically; while editing in sheet1, as these to sheets are linked together, and i don’t know how to make it.

    thanks for support

  2. Nick on March 8th, 2011 8:22 pm

    I downloaded your body fat calculator template.
    1 . very well done . but I would like to use Jason pollock’s Formula that is this one : Body Density = 1.10938 – (0.0008267 x sum of chest, abdomen and thigh skinfolds in mm ) + (0.0000016 x square of the sum of chest, abdomen and thigh) – (0.0002574 x age). then add this formula ;[(4.95/Bone Density) - 4.5] 100 to give me body fat percentage .

    Please Help me . or send me how to do it please.

  3. Terry on July 23rd, 2011 3:19 pm

    You say that you are using the caliper method but your parameters don’t include any caliper measurements. I don’t get it.

  4. Hung on May 22nd, 2013 2:55 pm

    These are really wonderful ideas in on the topic of blogging.

    You have touched some good points here. Any way keep up wrinting.

  5. somanabolic muscle maximizer on May 23rd, 2013 4:56 am

    I seriously love your site.. Very nice colors & theme.

    Did you create this site yourself? Please reply back as I’m wanting to create my own website and would love to know where you got this from or what the theme is called. Kudos!

Leave a Reply