Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

SIRS Criteria: A Historical Four-Part Spreadsheet Example

Count the four historical SIRS criteria in a complete example and understand why the result alone cannot diagnose or exclude sepsis.

Historical criteria and their limits

The 1992 ACCP/SCCM consensus described systemic inflammatory response syndrome (SIRS) using at least two of four criteria. Infection is one possible cause of a systemic inflammatory response, but noninfectious conditions can also produce the criteria.

The Sepsis-3 consensus defines sepsis in terms of life-threatening organ dysfunction caused by a dysregulated response to infection. Two or more SIRS criteria do not by themselves establish sepsis; fewer than two do not exclude it. A count is not a diagnosis, treatment plan or substitute for clinical assessment. Pediatric criteria differ.

The spreadsheet below is a complete-data arithmetic exercise: it requires respiratory rate and PaCO2 as well as WBC and bands for simplicity, although each pair represents alternatives in the historical criteria. Missing measurements must not be treated as normal.

Historical criterionThresholdPoints in this example
TemperatureAbove 38°C or below 36°C1 if either condition is met
Heart rateAbove 90 beats/min1
RespiratoryAbove 20 breaths/min or arterial PaCO2 below 32 mmHgAt most 1
White blood cellsAbove 12 or below 4 × 10⁹/L, or immature bands above 10%At most 1

Count the recorded criteria

Enter all six numerical values in B2:B7, in the units shown. COUNT checks completeness; the second guard rejects negative inputs, nonpositive temperature or PaCO2, and bands above 100%. A zero heart rate or respiratory rate is not treated as an invalid number here, but could represent an emergency and this arithmetic exercise cannot evaluate it. The formula returns a count from 0 to 4, not a sepsis diagnosis.

=IF(COUNT(B2:B7)<>6,"Enter all six numeric inputs",IF(OR(B2<=0,B3<0,B4<0,B5<=0,B6<0,B7<0,B7>100),"Check inputs",IF(OR(B2>38,B2<36),1,0)+IF(B3>90,1,0)+IF(OR(B4>20,B5<32),1,0)+IF(OR(B6>12,B6<4,B7>10),1,0)))

Try the example

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

Further reading