Sunday, December 2, 2012

FileMaker Pro - Calculating BMI

Kevin asked about calculating and classifying a BMI using FileMaker Pro.  The two formulas will be included in the tutorials for the eBook I am writing.  In this blog, I will describe how to calculate the BMI.  In the Metabolic Syndrome Database the patient's height in feet and inches are separate fields in the Patient table.  Generally, the height of an adult does not change.  However, Kevin, as a pediatric nursing practitioner student, should include height in the visit table.   A child's height will change with age.

Use the CDC BMI calculation appropriate for the client.  According to the CDC, the adult BMI formula is (Source: http://www.cdc.gov/healthyweight/assessing/bmi/adult_bmi/index.html )
Measurement Units
Formula and Calculation
Kilograms and meters (or centimeters)Formula: weight (kg) / [height (m)]2
With the metric system, the formula for BMI is weight in kilograms divided by height in meters squared. Since height is commonly measured in centimeters, divide height in centimeters by 100 to obtain height in meters.
Example: Weight = 68 kg, Height = 165 cm (1.65 m)
Calculation: 68 ÷ (1.65)2 = 24.98
Pounds and inchesFormula: weight (lb) / [height (in)]2 x 703
Calculate BMI by dividing weight in pounds (lbs) by height in inches (in) squared and multiplying by a conversion factor of 703.
Example: Weight = 150 lbs, Height = 5'5" (65")
Calculation: [150 ÷ (65)2] x 703 = 24.96

I prefer to create and edit FileMaker Pro tables from the File > Manage > Database view.  The first step is to instruct FileMaker that the field is a calculated value.  That instruction opens a window to enter the formula.  A really easy way to create the formula is to choose the fields from the pertinent tables from the tables drop-down menu.  You do not need to insert an equals sign (=) before a formula because FileMaker does that for you.



Next, I had to create a calculated field to determine height in inches.  The formula noted below in the Visit table is
(Patient::HtFt*12)+Patient::HtIn

The two :: tells FileMaker to obtain the value from the Patient table. HtFt and HtIn are two fields in the Patient table. The caret (^) is used to instruct FileMaker to square the height in inches.

The formula for BMI is (Weight * 703)/(Height In^2)


That is all there is to creating the BMI formula.  Kevin would need to use the BMI formula for children.  It can be adapted from http://apps.nccd.cdc.gov/dnpabmi/ 

12 comments :

  1. Can you tell me that how to install this software thanks :)FileMaker Pro 16

    ReplyDelete
  2. BMI is the relationship of weight to height. A bmi of 20-24.9 is normal, 25-29.9 overweight, and above 30 is obese. Below 20 is considered underweight, can be at risk for many diseases (also if obese).I also have many suggestions about the BMI through this BMI calculator If your BMI is about 21, you must be slim. That is on the lower end of the healthy range.

    ReplyDelete
  3. Filemake is good especially for those who like to make their math or other subjects related assignments which involve formulas on computer. Those students must use this software. Before using such software must be aware about the use and get the facts related to it which help to use easily.

    ReplyDelete
  4. The camculation of bmi is not that tough but somehow you need to do it. In this weblink there has lots of example for personal statement on your course.

    ReplyDelete
  5. If file maker can do such kin dof thigns then he is useful in a better way . www.optometry.tips/useful-tips-for-oat-test-prep/ to get some tips on optometry school time.

    ReplyDelete
  6. BMI is an important formula of maintaining height and weight for a human life. Here you have shared great services of filemaker pro which should useful to maintain height and weight in right format. Also you can visit here to get sports medical fellowship personal statement writing services. This service should useful for medical services education. Thanks

    ReplyDelete
  7. Right here you've discussed excellent providers associated with filmmaker professional that ought to helpful to preserve elevation as well as pounds within correct structure. You can also go here http://www.fellowshippersonalstatements.com/best-fellowship-personal-statement-sample/ to obtain sports activities healthcare fellowship individual declaration composing providers. This particular support ought to helpful for healthcare providers training.

    ReplyDelete
  8. I was just scrutinizing through the web hunting down a few information and kept running over your blog. I am motivated by the information that you have on this blog. It exhibits how well you appreciate this subject. Bookmarked this page, will return for extra.bmi calculator for kids

    ReplyDelete
  9. Here is my favourite BMI calculator. This calculator help you in calculating your health and fitness.

    ReplyDelete
  10. Thanks Jeanne. This worked perfectly in my solution!

    ReplyDelete