Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculators

SAPS 3 Research and a Fictional Logarithmic Transform

Learn the context of the SAPS 3 admission research model and practice a separate fictional logarithmic formula.

The SAPS 3 research model

Moreno and colleagues developed an ICU admission model using patient data recorded around admission in a multinational cohort. It describes information about the patient before admission, the circumstances of admission and physiological abnormalities. The publication reports both an overall equation and region-specific equations.

The global relation in the original paper is z = −32.6659 + 7.3068 × LN(S + 20.5958), then 1 / (1 + EXP(−z)), where S is a correctly constructed SAPS 3 score. It is not enough to add arbitrary numbers and call the result a patient prognosis; scoring definitions, population and calibration matter.

A separate invented calculation

The worksheet below uses different, invented coefficients and a fictional input X. It does not calculate SAPS 3 or estimate hospital mortality. It demonstrates how a logarithm and a logistic transformation work in a spreadsheet.

Enter a numeric X from 0 to 100 in B2. With X = 10 the invented formula returns 0.2455; with X = 20 it returns 0.4142. Missing, text and out-of-range values produce a prompt.

Fictional XInvented outputUse
00.0180Arithmetic exercise
100.2455Arithmetic exercise
200.4142Arithmetic exercise
=IF(COUNT(B2)<>1,"Enter a numeric value",IF(OR(B2<0,B2>100),"Enter a value from 0 to 100",ROUND(1/(1+EXP(-(-4+1.2*LN(B2+1)))),4)))

Interpret studies with context

Risk-model results depend on the studied population and the available calibration. The exercise below cannot diagnose a condition, predict survival for an individual or determine the appropriate level of care.

Try the example

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

Further reading