Healthcare & Clinical Calculators
ASDAS-CRP Spreadsheet Example: ASAS Formula and CRP Floor
Explore the ASAS ASDAS-CRP formula with fictional symptom scores, a 2 mg/L CRP floor, and checks for complete numeric inputs.
ASAS formula and input conventions
The Assessment of SpondyloArthritis international Society (ASAS) describes ASDAS-CRP using four 0–10 symptom or global ratings and C-reactive protein in mg/L. Its published online calculator uses 0.12 × back pain + 0.06 × duration of morning stiffness + 0.11 × patient global + 0.07 × peripheral pain/swelling + 0.58 × LN(CRP + 1).
For a CRP value below 2 mg/L, ASAS uses 2 mg/L in the calculation. Enter actual reported CRP in mg/L; this formula applies the same floor. Some study protocols publish coefficients to three decimal places; those are a distinct precision convention and can produce slightly different results. Use the convention specified by the relevant instrument or study.
| Fictional inputs | ASAS two-decimal-coefficient result |
|---|---|
| Back pain 6, stiffness 5, global 6, peripheral 4, CRP 14 mg/L | 3.53 (rounded to 2 decimals) |
| Back pain 1, stiffness 1, global 1, peripheral 0, CRP 0.8 mg/L | 0.93 (CRP floored to 2 mg/L) |
Calculate a rounded illustrative value
Enter all four numeric ratings between 0 and 10 and a nonnegative CRP in mg/L. The formula rejects missing, text and out-of-range inputs. The score is rounded for this example; rounding can obscure which side of a cutoff the unrounded value falls on.
The result is not a diagnosis or a treatment directive. Consult the ASAS instrument and a qualified clinician for clinical interpretation; a score alone does not determine whether to start or change medication.
=IF(COUNT(B2:B6)<>5,"Enter all five numeric inputs",IF(OR(MIN(B2:B5)<0,MAX(B2:B5)>10,B6<0),"Check symptom scores and CRP",ROUND(0.12*B2+0.06*B3+0.11*B4+0.07*B5+0.58*LN(MAX(B6,2)+1),2)))Try the example
Use the original values or change them to test your understanding.