Supplementary Materials for Publications

Height and Weight Correction for BMI Calculation

As per Hayes, A.J., Kortt, M.A., and Clarke, P.M., (2008) "Estimating equations to correct self-reported height and weight: implications for prevalence of overweight and obesity in Australia", Australian and New Zealand Journal of Public Health, Vol 32:6

This correction calculator estimates height and weight of Australians and their subsequent BMI. It corrects for the bias in self-reported data. The calculator is in the below excel file

Height and Weight Correction Calculator [Microsoft Excel]

Note: This Excel spreadsheet contains macros

Cost Calculator for Type 2 Diabetes Complications

As per Philip Clarke, Jose Leal, Chris Kelman, Merran Smith, Stephen Colagiuri, Estimating the Cost of Complications of Diabetes in Australia Using Administrative Health-Care Data. Value in Health, Vol. 11 Issue 2, pages 199-206.

This cost-calculator for estimating the health care associated with complications of Type 2 Diabetes based on equations reported in the above paper has been implemented in Excel. It is contained in the following zip file.

IMPORTANT: You will need Winzip, or a similar program to extract this file

download (Zip file size: 1.95MB. Final file size: 4.40MB)

Note: This Excel sheet contains macros.