Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Formulas

WFNS subarachnoid hemorrhage grades: a spreadsheet exercise

Explore a WFNS grading table with GCS, assessed focal deficit and explicitly handled source differences.

Understand the scope of the original WFNS grades

The World Federation of Neurological Surgeons (WFNS) grading system describes the initial clinical severity of aneurysmal subarachnoid hemorrhage using the Glasgow Coma Scale (GCS) and, in the middle grades, an assessed major focal neurological deficit. This is a fictional spreadsheet exercise, not a diagnostic or treatment tool.

The 2023 American Heart Association/American Stroke Association guidance discusses clinical grades as one part of severity assessment and prognostic communication. A grade alone does not determine an individual outcome or whether treatment should be withheld.

GradeGCS and assessed deficit in this example
I15 and no deficit
II13–14 and no deficit
III13–14 with major focal deficit
IV7–12, with or without deficit
V3–6, with or without deficit

Calculate a grade from complete, assessed inputs

Enter a whole-number GCS from 3 to 15 and a pre-assessed deficit flag: 0 absent, 1 present. A blank or unassessed input is not the same as a zero. The sheet checks only the encoded values and cannot determine the GCS components or whether a deficit is present.

For GCS 13–14 the deficit distinguishes grades II and III; for 7–12 and 3–6, the ranges map to IV and V respectively. Some published tables give grade I as GCS 15 without specifying a deficit, while others explicitly require no deficit. Accordingly, this example does not assign a grade for GCS 15 with a deficit and instead asks the reader to check the source definition.

=IF(COUNT(B2:B3)<>2,"Complete both numeric inputs",IF(OR(B2<3,B2>15,B2<>INT(B2),AND(B3<>0,B3<>1)),"Invalid inputs",IF(AND(B2=15,B3=1),"Check source definition",IF(B2=15,1,IF(B2>=13,IF(B3=0,2,3),IF(B2>=7,4,5))))))

Display the grade in Roman numerals

The displayed numeral follows the numeric output; missing or ambiguous combinations retain their message. Modified WFNS grading is a different system and should not be mixed with this example. Clinical outcomes depend on much more than an initial grade.

=IF(ISNUMBER(E2),CHOOSE(E2,"I","II","III","IV","V"),E2)

Try the example

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

Further reading