Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculations

Pitt Bacteremia Score Research: Adding Five Component Points

Practice adding published Pitt bacteremia component points with fictional inputs and discrete-value checks.

The Pitt bacteremia score in research

The Pitt bacteremia score is used in studies of infection severity and includes temperature, blood pressure, ventilation, cardiac arrest and mental-status components. Published studies define the observations, timing and component points used in their analyses.

This worksheet adds already assigned fictional point values. It does not assess a patient, predict an individual outcome, determine antibiotic treatment or decide a level of care. Clinical interpretation depends on the patient, the study context and professional judgment.

A fictional point example

The published component-point sets shown below can be added arithmetically. For fictional component points 1, 2, 2, 0 and 1, the total is 6. This number is not a patient assessment.

ComponentPossible points
Temperature0, 1, 2
Hypotension0, 2
Mechanical ventilation0, 2
Cardiac arrest0, 4
Mental status0, 1, 2, 4

Validate and add component points

Enter five numeric component points in B2:B6. The check rejects missing, fractional and unavailable point values; it cannot verify whether observations were assessed correctly.

=IF(COUNT(B2:B6)<>5,"Enter five numeric component points",IF(OR(AND(B2<>0,B2<>1,B2<>2),AND(B3<>0,B3<>2),AND(B4<>0,B4<>2),AND(B5<>0,B5<>4),AND(B6<>0,B6<>1,B6<>2,B6<>4)),"Invalid component points",SUM(B2:B6)))

Try the example

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

Further reading