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 input | Convention illustrated |
|---|---|
| Rebound tenderness or guarding | 0 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.