[Construction of Abridged Life Table for Health Evaluation of Local Resident Using Excel Program]

Objective: To provide an easy computational tool for evaluating the health condition of local residents.

Methods: An abridged life table was programmed by applying mathematical functions and formula in Excel program and tested with the real study data to evaluate the results computed.

Results: The Excel was capable of computing group death probability of age in the life table ((n)q(x)), number of survivors (l(x)), number of death ((n)d(x)), survival per person-year ((n)L(x)), survival total per person-year (T(x)) and life expectancy (e(x)). The calculated results were consistent with those by SAS.

Conclusion: The abridged life table constructed using Microsoft Excel can conveniently and accurately calculate the relevant indices for evaluating the health condition of the residents.