Bmi weight kg height m 2. If you want an ideal weight calculator you will need a template that suits the purpose.
Height Weight Chart Templates 12 Free Excel Pdf Documents
Height weight chart excel. First find your height in inches using the left most column. If you are 18 years old you will look in the 17 20 age group column. This makes it easy to collect height and weight in commonly used units in the united states and also show the metric amounts used in the calculation. Wlb 110 506 hin 60 women. A weight between the 5th and 95th percentile is considered within the healthy or normal range. Enter the start date and your initial weight into cells b25 and c25 in the bottom half of the screen.
To find you maximum weight go to the column corresponding to your age group. Multiple the weight in pounds by 045359237 to get weight in kilograms. In such cases a simple height. How do i plot a chart graph of height cm vs age date value. It is also very useful if. In order to use the above excel weight loss chart template to track your weight simply enter your height and if required your target weight into cells i2 and i3 of the spreadsheet.
I want to compare them at the same age ie when they were all five and on a separate chart to show their height relative to each other that is their height on the same date. You want to lose weight or just track your weight. Male height and weight standards. It will calculate you bmi body mass index of the moment and track it as the days go. You can see the bold black line with your babys name as its legend that will change based on your data input. Wlb 1001 506 hin 60 robinson formula.
Weight for age and body mass index are two growth charts used to assess teen weight. 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. Then use this great template to track your weight set target and add commentsit can be used as a weight loss template or diet excel sheet. There you will find the maximum weight allowed for your height in your age group. Choose height weight chart templates which allow you to incorporate your data in a tabular form. Then right next to it youll see the minimum weight allowed.
The spreadsheet will automatically display the recommended healthy weight range for your height based on bmi. Graphchart for age and height in excel hi. I have six children to compare. Weight tracking chart and table template. Bmi formula wlb bmi hin2 703 devine formula men. You can see the sample picture below.
A 115 pound 13 year old girl at the same height has a bmi equal to 225 which falls at the 85th percentile and is considered normal weight. You can print it or you can also change the layout and the look of this chart using excel chart menu. Go for height weight chart templates which can be. Columns and rows would. Before erasing those samples you can switch the worksheet into height and weight chart worksheet. Listed below are the formulas we used to calculate weight in pounds wlb given height in inches hin.
Gallery of Height Weight Chart Excel
