Healthcare & Clinical
Modified Fisher and Hunt-Hess scales: an educational spreadsheet example
Explore an illustrative Modified Fisher mapping and a separately assigned Hunt-Hess grade using fictional inputs; this is not a clinical decision tool.
Two scales with different inputs and purposes
The Modified Fisher scale describes CT-visible subarachnoid hemorrhage (SAH) and intraventricular hemorrhage (IVH); Hunt-Hess is a separate clinical grading system assigned by a qualified clinician. This example uses fictional inputs and is for spreadsheet practice only. It must not be used to diagnose, estimate an individual prognosis, choose medication or decide treatment.
In the Modified Fisher reference below, grade 0 means no SAH and no IVH; grades 1–4 distinguish thin or thick SAH and the absence or presence of IVH. The original study reported group-level associations with symptomatic vasospasm in a specific cohort, not a guaranteed individual risk or a diagnosis of delayed cerebral ischemia. This example does not classify isolated IVH without SAH.
| SAH input | IVH input | Illustrative Modified Fisher grade |
|---|---|---|
| None | Absent | 0 |
| Thin | Absent | 1 |
| Thin | Present | 2 |
| Thick | Absent | 3 |
| Thick | Present | 4 |
| None | Present | Not classified in this example |
Illustrative Modified Fisher mapping
Enter B2 as 0 (no SAH), 1 (thin SAH) or 2 (thick SAH), and B3 as 0 (IVH absent) or 1 (IVH present). The thickness category and presence of IVH are assumed to have been assessed separately; the formula does not interpret a scan. Blank, nonnumeric, fractional and out-of-range inputs are rejected.
=IF(COUNT(B2:B3)<>2,"Invalid CT inputs",IF(OR(B2<>INT(B2),B3<>INT(B3),B2<0,B2>2,B3<0,B3>1),"Invalid CT inputs",IF(B2=0,IF(B3=0,0,"Isolated IVH: not classified"),IF(B2=1,IF(B3=0,1,2),IF(B3=0,3,4)))))Display a separately assigned Hunt-Hess grade
Enter a whole-number grade from 1 to 5 in B4. The formula groups a grade already assigned by a qualified clinician; it does not assess the patient, choose a treatment or determine an individual outcome.
=IF(COUNT(B4)<>1,"Invalid Hunt-Hess grade",IF(OR(B4<>INT(B4),B4<1,B4>5),"Invalid Hunt-Hess grade",IF(B4<=2,"Hunt-Hess grades 1-2",IF(B4=3,"Hunt-Hess grade 3","Hunt-Hess grades 4-5"))))Try the example
Use the original values or change them to test your understanding.