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 X | Invented output | Use |
|---|---|---|
| 0 | 0.0180 | Arithmetic exercise |
| 10 | 0.2455 | Arithmetic exercise |
| 20 | 0.4142 | Arithmetic 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.