Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Formulas

ATRIA Bleeding Risk Study: Adding the Published Point Weights

Explore the five published ATRIA point weights using fictional binary inputs and complete-data checks.

What the ATRIA study measured

Fang and colleagues developed an ATRIA bleeding-risk score in a cohort of people with atrial fibrillation receiving warfarin. The published scheme assigns 3 points each to anemia and severe renal disease, 2 to age at least 75, and 1 each to prior bleeding and hypertension. These points are model weights; three points do not mean exactly three times the hazard of a one-point factor.

The worksheet only adds already assigned fictional flags. It does not diagnose any condition, give an individual bleeding probability or recommend changing an anticoagulant. Bleeding-risk scores should not be used alone to decide eligibility for anticoagulation; clinical decisions require a qualified professional and the full context.

A fictional arithmetic example

With five invented flags 1, 0, 1, 0 and 1, the weighted sum is 3 + 0 + 2 + 0 + 1 = 6. The total is a point calculation only, not a treatment instruction or an individualized risk estimate.

Published factorPoints when present
Anemia3
Severe renal disease3
Age at least 752
Prior bleeding1
Hypertension1

Validate and sum the flags

Enter all five numeric 0/1 flags in B2:B6. The formula checks for missing, text and nonbinary values; it cannot verify the original clinical definitions or whether any flag is correct.

=IF(COUNT(B2:B6)<>5,"Enter five numeric flags",IF(SUMPRODUCT((B2:B6<>0)*(B2:B6<>1))>0,"Flags must be 0 or 1",3*B2+3*B3+2*B4+B5+B6))

Try the example

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

Further reading