Evidence map›Paper›PMID 34996364›Full record

ArticleBMC medical research methodology2022

Simple Excel and ICD-10 based dataset calculator for the Charlson and Elixhauser comorbidity indices.

Pärt Prommik, Kaspar Tootsi, Toomas Saluse, Eiki Strauss, Helgi Kolk, Aare Märtson

Abstract read
In one paragraph

Article in BMC medical research methodology, 2022. The graph could read no effect estimate from its abstract, so it casts no vote on the map. Cited by 17 papers.

0numbers the graph read from it
0cells of the map it votes in
17citing papers in PubMed
–field-weighted citation impact
1 · What the graph read from it

What it found

Each row is one number read from the abstract, on the scale the paper reported it, with its interval. Left of the dashed line favours the treatment, right favours the comparator. Under each row is the sentence it came from. New to these charts? A ten-minute tutorial.

The abstract states no effect estimate the extractor could read, or names no intervention and outcome on the map, so this paper lights no cell and moves no belief. It is still indexed, cited and linked below.

2 · The registry

The trial behind it

Trials whose registry record cites this paper, or whose number appears in the abstract. A trial that started after this paper was published is citing it as background, not reporting it.

Neither the registry nor the abstract names a trial number. If this is a trial report, that itself is worth knowing.

3 · Its place in the literature

Who cites it

17 citing papers in PubMed.

  1. Serratia Bacteraemia in the North Denmark Region: A Population-Based Study (2010-2024).APMIS : acta pathologica, microbiologica, et immunologica Scandinavica · 2026
    Article
  2. Article
  3. Article
  4. Association of endovascular thrombectomy volume and outcomes in acute ischemic stroke: A National Inpatient Sample Study.Interventional neuroradiology : journal of peritherapeutic neuroradiology, surgical procedures and related neurosciences · 2025
    Article
  5. Article
  6. Article
  7. Article
  8. Article
  9. Article
  10. Article
  11. Observational
  12. Article
  13. Article
  14. Article
  15. Postoperative hand therapy and the 2018 Medicare therapy cap repeal: Appraising cost and use changes.Journal of hand therapy : official journal of the American Society of Hand Therapists
    Article
  16. Article
  17. Review
4 · The record

Corrections and comments

PubMed lists nothing against this paper. Absence here is not a guarantee, only a check that was made.

5 · Who and what money

Authors and funding

6 authors.

Pärt Prommik *Department of Traumatology and Orthopaedics, University of Tartu, L. Puusepa 8, 50406, Tartu, Estonia. part.prommik@ut.ee.ORCID 0000-0003-3603-4918
Kaspar Tootsi *Department of Traumatology and Orthopaedics, University of Tartu, L. Puusepa 8, 50406, Tartu, Estonia.
Toomas SaluseTraumatology and Orthopaedics Clinic, Tartu University Hospital, L. Puusepa 8, 50406, Tartu, Estonia.
Eiki StraussTraumatology and Orthopaedics Clinic, Tartu University Hospital, L. Puusepa 8, 50406, Tartu, Estonia.
Helgi Kolk *Department of Traumatology and Orthopaedics, University of Tartu, L. Puusepa 8, 50406, Tartu, Estonia.
Aare Märtson *Department of Traumatology and Orthopaedics, University of Tartu, L. Puusepa 8, 50406, Tartu, Estonia.

Funding

No grant is acknowledged in the PubMed record.

6 · The paper itself

Abstract

backgroundThe Charlson and Elixhauser Comorbidity Indices are the most widely used comorbidity assessment methods in medical research. 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. 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. 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.

methodsThe 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. 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 calculator's output values and processing speed were compared to R- and SAS-based methods.

resultsA total of 11,491 hip fracture patients' comorbidities were used for validating the Excel-based calculator. 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 processing speed was slower but differing only from a few seconds up to four minutes with datasets including 6250-200,000 patients.

conclusionsThis study proposes a novel, validated, and non-programming-based method for calculating Charlson and Elixhauser Comorbidity Index scores. 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.

trial registrationretrospectively registered.

Indexed as

Hip FracturesInternational Classification of DiseasesComorbidityHospital MortalityHumansProgramming LanguagesCharlson comorbidity indexComorbidity calculatorElixhauser comorbidity indexICD-10Research methodology

Identifiers

PMID34996364
PMCPMC8742382

What OpenQuestion holds

Textmetadata
LicenceCC BY
Read underepoch 390

Registered trials

None linked

Read under generation 80e0d062 · epoch 390. Bibliography from PubMed, PubMed Central and OpenAlex; grants from NIH RePORTER; trial links from ClinicalTrials.gov; estimates, votes and beliefs from the OpenQuestion graph.