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 input | After MAX(value, 1) |
|---|---|
| 0.5 | 1 |
| 2 | 2 |
| 5 | 5 |
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.