Arte SheetsLearn. Try. Understand.

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 inputIVH inputIllustrative Modified Fisher grade
NoneAbsent0
ThinAbsent1
ThinPresent2
ThickAbsent3
ThickPresent4
NonePresentNot 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.

Further reading