Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

HEMORR2HAGES Study: Checking and Adding Weighted Binary Flags

Explore a fictional point-summing example based on the published HEMORR2HAGES factor weights.

The original risk scheme

Gage and colleagues published HEMORR2HAGES in 2006 using a registry of patients with atrial fibrillation. The original point scheme assigns two points to prior bleeding and one point to each of ten other listed factors, including a combined liver-or-renal-disease factor. Definitions and study population matter when interpreting the research.

This worksheet adds fictional, already assigned flags. It does not diagnose risk factors, estimate an individual bleeding probability or make anticoagulant or other treatment decisions. A bleeding score should not be the sole basis for deciding on anticoagulation; treatment requires professional assessment.

An illustrative weighted sum

In the fictitious example, the liver-or-renal flag, age flag and anemia flag are 1 point each, and the prior-bleeding flag is 2 points: 1 + 1 + 1 + 2 = 5. Every other flag is zero. These are arithmetic inputs, not patient observations.

Type of factorWeight
Prior bleeding2 points
Each other original factor1 point
Possible arithmetic total0 to 12 points

Validate and add eleven flags

Enter one numeric 0/1 flag for each original factor in B2:B12. The formula adds the prior-bleeding flag a second time to give it weight 2. It checks input type and values but cannot verify whether a flag was assigned correctly.

=IF(COUNT(B2:B12)<>11,"Enter eleven numeric flags",IF(SUMPRODUCT((B2:B12<>0)*(B2:B12<>1))>0,"Flags must be 0 or 1",SUM(B2:B12)+B7))

Try the example

Use the original values or change them to test your understanding.

Further reading