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 factor | Weight |
|---|---|
| Prior bleeding | 2 points |
| Each other original factor | 1 point |
| Possible arithmetic total | 0 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.