There is much to share and just not enough time! :-)
I have been working on four lessons for one of the classes I teach on how to use Excel and FileMaker Pro. I wrote out the content because there is not a book that addresses how to use Excel and FileMaker Pro from a nursing perspective.
The good news, is that I believe I have FileMaker Pro figured out. I developed a Metabolic Syndrome Registry database and have incorporated calculations that:
- Calculate height in total inches height in feet and inches
- Calculate the BMI from height in inches and weight in pounds
- Analyze the BMI for World Health Organization Obesity classifications
- Analyze the weight goal based upon BMI classifications
The similarities between Excel formulas and FileMake Pro are remarkable. Where you use a comma in an Excel formula, you use a semicolon in FileMaker Pro. The creation of concatenation is identical. Concatenation is where you link two fields. For example if you have systolic blood pressure in one field and systolic blood pressure in another you can create a new field showing 120/80.
I really like the fact that FileMaker Pro does not use words that are so "techie." For example, the term layouts is used (the default is single form, running forms, and table view) for any table or queries. The term "queries" is not used - just a different layout. The term "script" is used instead of "macro."
Hi Jeanne,
ReplyDeleteI'm an RN currently working towards my pediatric NP. I just started working with FileMaker Pro and I've been trying to figure out how to write the script for calculating the BMI percentile for both the WHO and CDC data. I was wondering if you would be willing to share your expertise and offer some guidance? I'm able to calculate the BMI but I have been able to figure how to use the lookup tables (in xls format).
Kevin Bronson-Castain, RN
UCSF School of Nursing
Hello Kevin, I will post a blog with the formulas for calculating the BMI and classifying it with the WHO and CDC data. The formula is essentially the same as the one used in spreadsheet software. The difference is that it has to be created in a FileMaker Pro field.
ReplyDeleteWilliam Hill Betting Locations | Mapyro
ReplyDeleteFind William jancasino Hill sports betting locations febcasino.com in Maryland, West Virginia, 출장안마 Indiana, Pennsylvania, South Dakota, poormansguidetocasinogambling.com West Virginia and more. BetRivers.com.