Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

BASDAI: Six Ratings and Five Weighted Domains

Calculate an illustrative BASDAI value from six fictional 0–10 ratings, with complete input checks and context for clinical interpretation.

Why two stiffness ratings share one domain

The Bath Ankylosing Spondylitis Disease Activity Index (BASDAI) uses six self-reported ratings covering fatigue, spinal pain, peripheral joint pain or swelling, localized tenderness, morning stiffness severity and morning stiffness duration. To avoid counting stiffness twice, the last two ratings are averaged before adding them to the first four. The sum is divided by five, producing a score from 0 to 10.

BASDAI is a patient-reported measure, not a stand-alone diagnosis or treatment-eligibility test. ASAS–EULAR guidance also considers other clinical information, treatment history and objective signs of inflammation when assessing advanced treatment. More recent British guidance likewise evaluates the full clinical picture.

Fictional component ratingsArithmeticResult
5, 6, 3, 4, 7, 5(5 + 6 + 3 + 4 + (7 + 5)/2) / 54.8
2, 2.5, 1, 1.5, 3, 2(2 + 2.5 + 1 + 1.5 + (3 + 2)/2) / 51.9

Calculate from six complete ratings

Enter all six numeric values from 0 to 10. Decimal values are accepted for ratings recorded on a continuous scale. This example requires a complete set; any study-specific missing-data rule must be followed separately.

The result is rounded to two decimals for display. The example does not label a person as controlled or eligible for medication based on the number alone.

=IF(COUNT(B2:B7)<>6,"Enter all six numeric scores",IF(OR(MIN(B2:B7)<0,MAX(B2:B7)>10),"Each item must be from 0 to 10",ROUND((SUM(B2:B5)+(B6+B7)/2)/5,2)))

Try the example

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

Further reading