Arte SheetsLearn. Try. Understand.

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 categoryExample published weight
Congestive heart failure7
Renal failure5
Liver disease11
Metastatic cancer12
Pulmonary circulation disorders4
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.

Further reading