Arte SheetsLearn. Try. Understand.

Statistical & Clinical Analysis

ASTRAL Stroke Research: A Weighted Spreadsheet Sum

Explore the arithmetic behind a published stroke research score and understand the limits of predicting individual outcomes.

What the study investigated

Ntaios and colleagues developed the ASTRAL score in a cohort of previously independent patients with acute ischemic stroke, then evaluated it in other cohorts. It uses age, NIHSS, onset-to-admission delay, visual field, glucose and level of consciousness. Research-cohort performance is not a guaranteed prediction for a specific person.

For counseling critically ill patients with acute ischemic stroke or their surrogates, the 2026 neuroprognostication guideline suggests that ASTRAL not be considered a reliable predictor of poor functional outcome. Individual prognosis requires a broader assessment and an appropriate discussion of uncertainty.

Practice weighted arithmetic

This worksheet demonstrates the published scoring structure: one point per five complete years, one per NIHSS point, and weights of 2, 2, 1 and 3 for four preassigned flags. B2 and B3 are whole numbers; B4:B7 must each be numeric 0 or 1. The example is hypothetical and uses 72, 11, 1, 1, 1 and 0 to produce 30.

The numeric checks do not establish whether findings were assessed correctly, whether components are mutually consistent, or whether a study applies to a person. The worksheet does not estimate individual outcome probability or recommend care.

Illustrative inputCellContribution
Completed yearsB2INT(B2/5)
NIHSS pointsB3B3
Delay over three hours flagB42 × flag
Visual field defect flagB52 × flag
Abnormal glucose flagB61 × flag
Impaired consciousness flagB73 × flag
=IF(COUNT(B2:B7)<>6,"Enter all six numeric values",IF(OR(B2<0,B2>120,MOD(B2,1)<>0,B3<0,B3>42,MOD(B3,1)<>0,B4<0,B4>1,MOD(B4,1)<>0,B5<0,B5>1,MOD(B5,1)<>0,B6<0,B6>1,MOD(B6,1)<>0,B7<0,B7>1,MOD(B7,1)<>0),"Enter valid whole-number values",INT(B2/5)+B3+2*B4+2*B5+B6+3*B7))

Look up the full definitions

See the original study for the definitions, patient selection and model validation. Age 0–120 and NIHSS 0–42 are arithmetic input bounds in this exercise, not a statement that the research was validated for every age or clinical population.

Try the example

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

Further reading