A new method of classifying prognostic comorbidity in longitudinal studies: development and validation. As the comorbidity calculations can be conducted in Microsoft Excel's simple graphical point-and-click interface, the new method lowers the threshold for calculating these two widely used indices.Ĭharlson comorbidity index Comorbidity calculator Elixhauser comorbidity index ICD-10 Research methodology.Ĭharlson ME, Pompei P, Ales KL, MacKenzie CR. This study proposes a novel, validated, and non-programming-based method for calculating Charlson and Elixhauser Comorbidity Index scores. The Excel-based calculator's processing speed was slower but differing only from a few seconds up to four minutes with datasets including 6250-200,000 patients.
The Excel-based calculator's results were consistent, revealing no discrepancies, with R- and SAS-based methods while comparing 192,690 and 353,265 output values of Charlson and Elixhauser Comorbidity Index, respectively. The Excel-based calculator's output values and processing speed were compared to R- and SAS-based methods.Ī total of 11,491 hip fracture patients' comorbidities were used for validating the Excel-based calculator. Real, population-wide, nine-year spanning, index hip fracture data from the Estonian Health Insurance Fund was used for validating the calculator. The Excel-based dataset calculator was developed using the program's formulae, ICD-10 coding algorithms, and different weights of the Charlson and Elixhauser Comorbidity Index. This study aims to use Microsoft Excel to develop a non-programming and ICD-10 based dataset calculator for Charlson and Elixhauser Comorbidity Index and to validate its results with R- and SAS-based methods.
Available Charlson and Elixhauser Comorbidity Index calculating methods are limited to a few applications with command-line user interfaces, all requiring specific programming language skills. Both methods are adapted for use with the International Classification of Diseases, which 10th revision (ICD-10) is used by over a hundred countries in the world. The Charlson and Elixhauser Comorbidity Indices are the most widely used comorbidity assessment methods in medical research.
0 kommentar(er)
