Attached is an Excel spreadsheet showing how to calculate BMI, both using meters/kilograms and using pounds/inches. Nothing fancy. Just multiplication and division.
BMI is just a fraction with the person's weight in kilograms in the numerator and his/her height-in-meters squared in the denominator.
Alternatively, BMI is a fraction where the numerator is a person's weight in pounds times a multiplier of 703; the person's height-in-inches squared is the denominator.
I found the multiplier in some article on the internet, but now I cannot remember where I got this.
Take the case of "Mary," a woman described on line 9 who is five feet tall, weighs 170 pounds, has a BMI of 33.2, and is therefore obese.
I have "solved" for Mary's BMI index numbers on lines 16 thru 33. I think this presents in effect a very straightforward plan of weight loss goals if Mary could lower her BMI by one index number per month until she reaches her goal weight, i.e., losing 5.1 pounds per month.
P.S. I had to put the spreadsheet inside a .ZIP file since this board does not allow uploading of a file with an .XLS extension.