Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Formulas

Original HACOR Score: Adding Five Component Points in a Spreadsheet

Learn to add the five published component point values using a fictional example and explicit input checks.

About the original HACOR score

The 2017 HACOR study examined heart rate, acidosis, consciousness, oxygenation and respiratory rate as predictors of noninvasive ventilation failure in a cohort of hypoxaemic patients. It assigned points to each component and added them. A later study proposed an updated HACOR model with additional variables.

This worksheet illustrates only the addition of already assigned point values in the original score. It does not assign points from clinical measurements, estimate an individual probability, determine when to intubate, or replace professional assessment. Study results depend on population and setting.

Allowed points in the original score

Use the original publication for the definitions and measurement ranges behind each component. In this example, the fictional component points 1, 2, 0, 4 and 2 add to 9; no clinical conclusion follows from the arithmetic alone.

Original componentPossible point values
Heart rate0, 1
Acidosis0, 2, 3, 4
Consciousness0, 2, 5, 10
Oxygenation0, 2, 3, 4, 5, 6
Respiratory rate0, 1, 2, 3, 4

Add the five assigned point values

Enter all five numbers in B2:B6. The formula rejects missing values, fractions and point values that are not available in the original component definitions. It cannot verify whether points were assigned correctly.

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

Try the example

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

Further reading