![]() There are other formulas for measuring body fat. There is no argument that a hydrostatic or underwater test is by far the most accurate tool for body fat test tool, but it is not a practical tool to measure ongoing progress due to cost and availability. No body fat percent calculator will be very accurate for people with a very muscular build. I haven’t been able to verify this, but I would guess the Navy’s body fat test was developed decades ago by men and during a time when it was only used on male recruits because female servicewomen were not in combat roles. Please keep in mind that we did not develop the Navy fitness criteria, we just created this Body Fat Navy Calculator using their formulas and interpreted from their body fat chart as a way to help people who are monitoring and measuring body fat. The comments show passionate emotions and controversial discussions over this Body Fat Navy Calculator! Whether you like the results or not, we’ve had a couple of recruiters tell us they use it all the time. The Body Fat Navy Calculator is a Good Tool for Measuring Body Fat and Navy Fitness Level The water displacement test is the most accurate way to determine body fat percent, but the Navy Body Fat test or YMCA formula is accurate within 1-3% for most people. (You can see the Navy Body Fat Chart by clicking the down arrow icon right under the results.) Use a tape measure then enter your waist, hip, and neck measurements.Ĭombine these measurements with your gender and height and this navy calculator will estimate body fat percent, lean mass, fat mass, and your general navy fitness category. Navy fitness formula to get an estimated measuring of body fat percent. This Body Fat Navy Calculator uses the U.S. The key point is that you are free to nest other calculations directly in a function argument.What is my navy fitness level when measuring body fat using the Navy Body Fat Test and Navy Body Fat Chart? Similarly, we could convert inches to feet inside CONVERT like this: =CONVERT(B5+C5/12,"ft","m") Note: Excel's order of operations makes it unnecessary to wrap B5*12 in parentheses. When Excel evaluates the formula, this operation happens before the CONVERT function runs. In other words, we convert feet to inches directly inside CONVERT's number argument. To calculate height, we can use a single CONVERT function like this: =CONVERT(B5*12+C5,"in","m") The formulas used above can be simplified somewhat. To square height, we use Excel's operator for exponentiation, the caret (^). The formula in H5 is: =G5/F5^2 // calculate BMI To calculate weight in kilograms, we use CONVERT again in cell G5: =CONVERT(D5,"lbm","kg") // pounds to kilogramsįinally, we are ready to apply the standard BMI formula. Then the two values are simply added together to get a total height in meters. The second converts inches to meters: =CONVERT(C5,"in","m") // inches to meters The first CONVERT converts feet to meters: =CONVERT(B5,"ft","m") // feet to meters Then, to calculate height in meters, we use the CONVERT function twice in cell F5: =CONVERT(B5,"ft","m")+CONVERT(C5,"in","m") This is done in columns B (feet) C (inches) and D (pounds). ![]() The first step, therefore, is to capture this information in commonly used units. The main challenge in this example is that most people in the United States still use the US customary measurement system to record height and weight, not the metric system. This makes it easy to collect height and weight in commonly used units (in the United States), and also shows the metric amounts used in the calculation. The approach used here is to first convert height in inches and feet to meters, and weight in pounds to kilograms, then use the standard metric formula for BMI. This example shows one way to calculate BMI (Body Mass Index) in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |