IOMLIFET: A spreadsheet system for life-table calculations for Health Impact Assessment

IOMLIFET is a spreadsheet system for life-table calculations in the context of health impact assessments. These can be used for predictions of the patterns of mortality and life expectancy ensuing from a change in mortality rates, from whatever source or planned intervention.

There are three separate ZIP files that can be downloaded free of charge:

  • IOMLIFET_2008_LIFE_EXPECT.ZIP contains a simple spreadsheet that takes mortality hazard rates and calculates remaining life expectancy from any achieved age, and gains or losses in years of life expectancy when the hazard rates are changed.

    • Download IOMLIFET_2008_LIFE_EXPECT.ZIP here. (1.42 MB)

  • IOMLIFET_2008_ALL-CAUSE.ZIP contains the complete set of spreadsheets for doing similar calculations of the results of manipulating all-cause hazard rates in a population of different ages.

    • Download IOMLIFET_2008_ALL-CAUSE.ZIP here. (14.5 MB)

  • IOMLIFET_2008_MULTI-CAUSE.ZIP contains a development of the same spreadsheet system, expanded so that up to 6 specific causes of death may be manipulated independently.

    • Download IOM_LIFET_2008_MULTI-CAUSE.ZIP here. (17.7 MB)

    Each of the ZIP files contains a PDF copy of IOM Research Report TM/06/01, which describes the methodology and shows some examples, and a README guide to using the sheets. If you want to read more about what the spreadsheets do before downloading them, you can download these documents separately.

    Download IOM_TM0601.PDF here. (2.22 MB)

    Download IOMLIFET_2008_Readme.pdf here. (232 KB)

    These spreadsheets have been developed with funding from the UK Department of Health, and are distributed free of charge. If you use them in your work, please give an acknowledgement, preferably by referencing the Research Report.

    We want these sheets to be useful and error-free. Please let me know at brian.miller@iom-world.org if you spot any errors in the calculations, and I’ll fix the sheets.

    Dr Brian Miller,
    Principal Epidemiologist
    IOM

    IOM Headquarters

    Research Avenue North, Riccarton, Edinburgh, EH14 4AP | Tel: +44 (0) 131 449 8052 | Fax: 0870 850 5132

    © 2008 IOM