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 )
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)
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 inches | Formula: 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/
Can you tell me that how to install this software thanks :)FileMaker Pro 16
ReplyDeleteBMI 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.
ReplyDeleteFilemake 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.
ReplyDeleteThe 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.
ReplyDeleteIf 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.
ReplyDeleteNice article.
ReplyDeleteBMI 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
ReplyDeleteRight 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.
ReplyDeleteI 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
ReplyDeleteNice post, Thanks for Sharing bro Download Tuxera NTFS 2018
ReplyDeleteDownload
Download
Download
Download
Download
Download
Download
Here is my favourite BMI calculator. This calculator help you in calculating your health and fitness.
ReplyDeleteThanks Jeanne. This worked perfectly in my solution!
ReplyDelete