Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculators

CLIF-C ACLF Research: A Logarithmic Spreadsheet Example

Work through the published model expression with fictional inputs and explicit numeric checks.

The published research model

Jalan and colleagues developed the CLIF-C ACLF prognostic score in a study of acute-on-chronic liver failure. Its published expression combines an already assessed CLIF-C organ-failure score, age and the natural logarithm of the white blood cell count. The original research defines the population, measurements and appropriate context.

This worksheet illustrates the expression using invented numbers. It does not calculate organ-failure components, verify a diagnosis, predict an individual outcome or determine ICU treatment or transplant decisions. Interpretation requires qualified professionals and the full clinical context.

Work through invented values

For an illustrative organ-failure total of 11, age input of 56 and white blood cell count input of 14.5 × 10⁹/L, the published expression 10 × (0.33 × 11 + 0.04 × 56 + 0.63 × LN(14.5) − 2) is approximately 55.5. The values are fictional and the result is not an individualized prognosis.

Use the stated WBC units; logarithms require a positive input. The score cannot be interpreted without correct component assessment and model applicability.

Fictional model inputValue
Organ-failure total11
Age in completed years56
White blood cell count14.5 × 10⁹/L
Arithmetic result, one decimal55.5

Evaluate the expression

Enter an integer organ-failure total from 6 to 18, an adult age in completed years and a positive numeric WBC value in B2:B4. These guards check numeric form only, not clinical validity.

=IF(COUNT(B2:B4)<>3,"Enter three numeric model inputs",IF(OR(B2<6,B2>18,B2<>INT(B2),B3<18,B3<>INT(B3),B4<=0),"Invalid model inputs",ROUND(10*(0.33*B2+0.04*B3+0.63*LN(B4)-2),1)))

Try the example

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

Further reading