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.
| Component | Possible points |
|---|---|
| Temperature | 0, 1, 2 |
| Hypotension | 0, 2 |
| Mechanical ventilation | 0, 2 |
| Cardiac arrest | 0, 4 |
| Mental status | 0, 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.