Download Ideal Weight Chart Excel Template


Popular Categories in Excel Template
Trednding in Excel Template

Cash Flow Projection

A cash flow statement is a very critical tool for analyzing the current liquidity of …

Read More

Blood Sugar log

Our blood sugar log chart lets you track your blood sugar levels throughout the day. It also …

Read More

Monthly Class Attendance Sheet

Most schools and businesses track attendance using spreadsheets. Monthly class attendance sheet are helpful for  …

Read More

Startup Budget Template

These business startup budget template will help you track costs (e.g., fixed and variable) and …

Read More
Generic filters

Our ideal weight chart includes most common formulas and methods for calculating ideal weight. If you have interest in losing weight, you can use this weight zones in our charts (based on your BMI or Body Mass Index) as a guide for choosing your target weight. But, keep in mind that there are many different methods for estimating your ideal weight, and many factors besides height and gender that ought to be taken into account, such as frame size, age, and muscle tone.

Ideal body weight chart

This spreadsheet contains a tableideal weight charts, along with a calculator for finding your ideal weight, using either the Devine, Robinson, or Miller formulas. It also includes some “normal” weight zones associated with the standard BMI range 18.5-25.

Weight according to height

The three most popular formulas for calculating ideal weight are the DevineMiller and Robinson formulas. The above weight charts and the spreadsheet includes all these formulas so you can see the differences. They are primarily used for calculating medication dosages, and they don’t account for age, frame size, muscle tone, etc.

Another method for finding a range of ideal weight is to use the “Normal Weight” range determined by the standard Body Mass Index range of 18.5 – 25 [1]. The body mass index is only based on height and is the same both both men and women. It is important to note that BMI for children is not the same way as for adults.

Weight chart by age

In the Ideal Weight Calculator includes in the above spreadsheet, you will find two separate tables defining what BMI value is used to define Overweight. The standard value defined by the CDC is 25 for both Men and Women. I prefer to use the NHANES definition which defines Marginally Overweight as over 26.4 for Men and over 25.8 for Women.

Summary of ideal body weight chart

Listed below are the formulas we use to calculate weight in pounds W[lb] given height in inches H[in]. Multiple the weight in pounds by 0.45359237 to get weight in kilograms.

  • BMI Formula
    W[lb] = ( BMI * H[in]^2 ) / 703
  • Devine Formula
    Men: W[lb] = 110 + 5.06 * ( H[in]-60 )
    Women: W[lb] = 100.1 + 5.06 * ( H[in]-60 )
  • Robinson Formula
    Men: W[lb] = 114.4 + 4.18*(H[in]-60)
    Women: W[lb] = 107.8 + 3.74*(H[in]-60)
  • Miller Formula
    Men: W[lb] = 123.64 + 3.10*(H[in]-60)
    Women: W[lb] = 116.82 + 2.99*(H[in]-60)

Download Ideal Weight Chart Excel Template

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download Ideal Weight Chart Excel Template

Instruction :

All Excel templates and tools are sole property of User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: