Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

HAPS Research Criteria: A Spreadsheet Boundary Exercise

Explore the three HAPS research criteria with fictional values, clear units, complete input checks, and an explicitly flagged ambiguous creatinine boundary.

What HAPS was designed to study

Lankisch and colleagues studied early identification of a nonsevere course after a first attack of acute pancreatitis using three admission findings: absence of rebound tenderness or guarding, hematocrit relative to sex-specific thresholds, and serum creatinine. In their initial and validation sets, 200 of 204 people classified as predicted nonsevere had the study-defined nonsevere course; this is a group-level positive predictive value, not a guarantee for an individual.

A later systematic review found that reported performance varied with the outcome definition: for studies predicting mild acute pancreatitis, the pooled positive predictive value was 83%. Early assessment cannot guarantee a particular course or determine disposition without clinical judgment and ongoing reassessment.

Research inputConvention illustrated
Rebound tenderness or guarding0 absent, 1 present
Hematocrit (%)Original paper reports >43% for men or >39.6% for women as increased
Creatinine (mg/dL)Paper is internally inconsistent at exactly 2 mg/dL; this exercise flags that boundary

Count adverse research flags without making a triage decision

Enter a binary peritoneal-sign flag and the original study’s hematocrit comparison group (1 for men, 0 for women), a positive hematocrit percentage, and a positive creatinine in mg/dL. This example counts the three adverse findings; the count is a teaching aid, not a validated graded severity scale.

The 2009 paper describes creatinine of at least 2 mg/dL as abnormal in its methods, but its Table 1 labels the comparison as at most 2 versus greater than 2 mg/dL. Because the exact boundary is inconsistent, this exercise flags exactly 2 mg/dL instead of silently choosing one interpretation. It does not diagnose, predict an individual course, or direct admission, imaging or treatment.

=IF(COUNT(B2:B5)<>4,"Enter all four numeric inputs",IF(OR(AND(B2<>0,B2<>1),AND(B3<>0,B3<>1),B4<=0,B4>100,B5<=0),"Check the flags, hematocrit and creatinine",IF(B5=2,"At 2 mg/dL, check the source definition",B2+IF(B3=1,IF(B4>43,1,0),IF(B4>39.6,1,0))+IF(B5>2,1,0))))

Try the example

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

Further reading