Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculations

Harvey-Bradshaw Index (HBI) for Crohn’s Disease Activity & Remission

Sum five Harvey–Bradshaw Index components and compare the result with commonly used Crohn’s disease activity ranges, with input checks and interpretation.

Five components of the Harvey–Bradshaw Index

The Harvey–Bradshaw Index (HBI) is a clinical activity measure for Crohn’s disease. It adds five components: general well-being (0–4), abdominal pain (0–3), number of liquid stools on the previous day, abdominal mass (0–3), and the number of listed complications (one point per complication; 0–8 in the cited protocol). All inputs in this example are whole numbers; the stool count has no fixed maximum.

The commonly used ranges in the cited trial protocol are <5 (clinical remission by this score), 5–7 (mild), 8–16 (moderate) and >16 (severe). The HBI is a clinical measure and cannot alone establish mucosal healing or determine treatment. Its bands should not be presented as exact conversions to CDAI bands: correlated scores are not necessarily interchangeable.

Clinical findings and complication points must be assessed using the relevant protocol. Consider symptoms, examination and objective tests as appropriate; this example provides arithmetic and does not prescribe therapy.

Example components: well-being + pain + liquid stools + mass + complicationsHBI totalCommonly used range
0 + 0 + 2 + 0 + 02Below 5
2 + 2 + 5 + 1 + 1118 to 16
3 + 3 + 10 + 1 + 118Above 16

Calculate the five-component total

Require all five numeric whole-number components; missing data are not silently scored as zero in this example. The complication field is the count of distinct listed complications in the referenced protocol.

=IF(COUNT(B2:B6)<>5,"Missing or nonnumeric input",IF(OR(B2<0,B2>4,MOD(B2,1)<>0,B3<0,B3>3,MOD(B3,1)<>0,B4<0,MOD(B4,1)<>0,B5<0,B5>3,MOD(B5,1)<>0,B6<0,B6>8,MOD(B6,1)<>0),"Invalid component",SUM(B2:B6)))

Compare the total with commonly used activity ranges

The labels below show the numerical bands. A score-defined range is not a complete assessment or an instruction to start or change medication.

=IF(COUNT(B2:B6)<>5,"Missing or nonnumeric input",IF(OR(B2<0,B2>4,MOD(B2,1)<>0,B3<0,B3>3,MOD(B3,1)<>0,B4<0,MOD(B4,1)<>0,B5<0,B5>3,MOD(B5,1)<>0,B6<0,B6>8,MOD(B6,1)<>0),"Invalid component",IF(SUM(B2:B6)<5,"Below 5",IF(SUM(B2:B6)<=7,"5 to 7",IF(SUM(B2:B6)<=16,"8 to 16","Above 16")))))

Try the example

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

Further reading