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.
| Grade | GCS and assessed deficit in this example |
|---|---|
| I | 15 and no deficit |
| II | 13–14 and no deficit |
| III | 13–14 with major focal deficit |
| IV | 7–12, with or without deficit |
| V | 3–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.