Healthcare & Clinical Calculators
Elixhauser Comorbidity Research: Weighted Subtotal in Excel
Learn the purpose and limitations of the van Walraven administrative-data score and practice SUMPRODUCT using six illustrative weights.
What the weighted comorbidity index measures
In 2009, van Walraven and colleagues condensed Elixhauser comorbidity indicators derived from hospital administrative codes into a weighted summary for research on in-hospital death. This is a way to adjust for recorded comorbidity in datasets; codes, case mix, inclusion rules and model calibration matter. A later Swiss study compared the original weights with locally rederived weights and found differences.
Some published weights are negative. Those associations can reflect the source data and coding patterns; they are not evidence that a diagnosis protects an individual patient. The score by itself is not a validated individual mortality percentage. The six items shown below are only an illustration, not the full set of model variables.
| Illustrative recorded category | Example published weight |
|---|---|
| Congestive heart failure | 7 |
| Renal failure | 5 |
| Liver disease | 11 |
| Metastatic cancer | 12 |
| Pulmonary circulation disorders | 4 |
| Drug abuse | −7 |
Multiply six example weights by fictional flags
Enter six numeric weights in B2:B7 and six fictional 0-or-1 flags in C2:C7. SUMPRODUCT multiplies each pair and adds the products. For 1, 1, 0, 1, 0, 0, the subtotal is 7 + 5 + 12 = 24. Since the exercise omits other model variables and coding rules, this is an illustrative partial subtotal, not a complete index or a clinical prediction.
=IF(COUNT(B2:B7)<>6,"Enter all six numeric weights",IF(COUNT(C2:C7)<>6,"Enter all six numeric flags",IF(OR(MIN(C2:C7)<0,MAX(C2:C7)>1,MOD(C2,1)<>0,MOD(C3,1)<>0,MOD(C4,1)<>0,MOD(C5,1)<>0,MOD(C6,1)<>0,MOD(C7,1)<>0),"Each flag must be 0 or 1",SUMPRODUCT(B2:B7,C2:C7))))Try the example
Use the original values or change them to test your understanding.