Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

Understanding PELD and Logarithms: An Educational Spreadsheet Example

See how positive-value logarithms work in a fictional example, and find the current official paediatric liver allocation calculator.

PELD has changed over time

The Pediatric End-Stage Liver Disease (PELD) model is used in the United States to help assign priority to most liver-transplant candidates younger than 12. The original research included age, bilirubin, INR, albumin and growth measures.

The US Organ Procurement and Transplantation Network updated PELD in July 2023, including creatinine and changes in how age and growth are represented. Older formulas and their scores are not the current allocation calculation. For current inputs and official calculations, consult the HRSA/OPTN PELD calculator linked below and the treating transplant team.

A separate logarithm exercise

This exercise shows how LN and MAX can be used together on three invented positive numbers. It is not a PELD formula, its inputs are not clinical measurements, and the result is not a transplant score or a basis for decisions.

For values 0.5, 2 and 5, replacing any value below 1 by 1 gives LN(1) + LN(2) + LN(5) = LN(10), approximately 2.3026. This mathematical floor is part of this example only and should not be confused with the rules of any clinical model.

Fictional inputAfter MAX(value, 1)
0.51
22
55

Add three natural logarithms

Enter three positive numeric values in B2:B4. COUNT detects missing or nonnumeric values, and MIN rejects zero or negative inputs.

=IF(COUNT(B2:B4)<>3,"Enter three numeric values",IF(MIN(B2:B4)<=0,"Enter positive values",ROUND(LN(MAX(B2,1))+LN(MAX(B3,1))+LN(MAX(B4,1)),4)))

Try the example

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

Further reading