Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

ABCD2 TIA Score: An Educational Spreadsheet Example

Reproduce the point arithmetic of the ABCD2 score for an illustrative example, with input checks and important limits on its use.

A medical emergency, independent of a spreadsheet score

Sudden stroke-like symptoms are a medical emergency. Call local emergency services immediately, even if the symptoms disappear. Do not use this spreadsheet to decide whether or how urgently someone needs care.

The ABCD2 score was developed to study early stroke risk after a transient ischemic attack (TIA). This page demonstrates the point arithmetic using invented values, not diagnosis or individual risk prediction. NICE advises against using scores such as ABCD2 to determine the urgency of referral after suspected or confirmed TIA.

How the historical point scheme adds up

The five components are age at least 60 years (1); systolic pressure at least 140 or diastolic at least 90 mmHg (1); unilateral weakness (2), speech disturbance without weakness (1), or other symptoms (0); duration at least 60 minutes (2), 10 to under 60 minutes (1), or under 10 minutes (0); and diabetes history (1).

For the invented example below: age 68, blood pressure 152/88, weakness, duration 75 minutes and no diabetes give 1 + 1 + 2 + 2 + 0 = 6 points. This result does not prescribe treatment or establish an individual probability.

Illustrative factorExamplePoints
Age68 years1
Blood pressure152/88 mmHg1
Clinical featureUnilateral weakness2
Duration75 minutes2
Diabetes historyNo0
TotalArithmetic only6

Calculate points for valid illustrative inputs

Use a positive numeric age and blood pressures, a nonnegative duration in minutes, clinical code 0, 1 or 2, and diabetes code 0 or 1. Blank values, text and fractional codes return an input message. These checks cannot confirm whether the inputs or clinical interpretation are correct.

=IF(OR(NOT(ISNUMBER(B2)),NOT(ISNUMBER(B3)),NOT(ISNUMBER(B4)),NOT(ISNUMBER(B5)),NOT(ISNUMBER(B6)),NOT(ISNUMBER(B7))),"Invalid ABCD2 inputs",IF(OR(B2<=0,B3<=0,B4<=0,B5<0,B5>2,B5<>INT(B5),B6<0,B7<0,B7>1,B7<>INT(B7)),"Invalid ABCD2 inputs",--(B2>=60)+--(OR(B3>=140,B4>=90))+B5+IF(B6>=60,2,IF(B6>=10,1,0))+B7))

Limitations

The score alone cannot establish whether an event was a TIA, rule out a stroke or determine care. The risk estimates in the original research were derived from particular cohorts and should not be treated as a personalized prediction. Current assessment is a clinical task.

Try the example

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

Further reading