Modeling Weight Loss Maintenance
Dr. Hall recently proposed a mathematical model to calculate the changes of dietary energy intake and physical activity required to maintain a given body weight change and prevent weight regain.This page contains the MS Excel Spreadsheet files described in the following publication:
K.D. Hall and P. N. Jordan. 'Modeling Weight Loss Maintenance to Help Prevent Body Weight Regain.' Am J Clin Nutr. 88:1495-1503 (2008).
After setting up MS Excel to properly run the model, follow the instructions provided at the top of each spreadsheet to make calculations. Note that this information is for general research use only and is not intended to provide personal medical advice or substitute for the advice of a physician or weight management professional. If you have specific questions about the information presented, concerns about individual health matters or body weight management, please consult your physician.
Click here for instructions to set up MS Excel to properly run the model
Click here for set-up instructions for the Office 2007 version of MS Excel
Click here for descriptions of the various spreadsheets
Click here for the spreadsheet that predicts the change in dietary energy intake required to maintain a specified change in body weight. This version is particularly useful when the initial body fat mass is known and the model parameters are input directly.
Click here for the spreadsheet that predicts the change in dietary energy intake required to maintain a specified change in body weight when the initial body fat is not known. This spreadsheet uses regression equations to calculate the initial body composition at the beginning of the weight change period, and does not require the user to provide the values of the physical activity parameters. Instead, the user is asked to estimate the physical activity level (PAL) at the beginning and the end of the weight change period according to a table of values provided in the spreadsheet.
Click here for the spreadsheet that predicts the steady-state change in body weight that is expected from a specified change in dietary energy intake and physical activity. This version requires the user to specify the initial body fat mass and the model parameters are input directly.
Click here for the spreadsheet that predicts the steady-state change in body weight that is expected from a specified change in dietary energy intake and physical activity. This spreadsheet uses regression equations to calculate the initial body composition at the beginning of the weight change period.
Should you have any accessibility issues with the xls spreadsheets or anything else on this page, please contact Dr. Hall directly at Tel: 301-402-8248 or Email: Kevinh@niddk.nih.gov
* Documents in PDF format require the free Adobe Acrobat Reader 
application for viewing.
* Documents in Excel format require the free Excel Viewer for viewing.
