Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

Abbreviated Burn Severity Index: A Historical Spreadsheet Example

Reproduce the arithmetic of the historical five-component ABSI with explicitly validated illustrative inputs; it is not a current patient prognosis.

What this historical score measures

The 1982 Abbreviated Burn Severity Index (ABSI) used five recorded variables: a binary sex category, age, inhalation injury, full-thickness burn, and percent of total body surface area (TBSA) burned. The original binary sex variable reflects the historical score; it is not a substitute for individualized assessment.

This page demonstrates spreadsheet arithmetic on invented inputs. Historical survival tables are not current individual prognoses: a later study in a German burn registry found that the original ABSI overestimated mortality in that cohort. Burn severity and care require qualified clinicians; do not use this example to make treatment, triage, or survival decisions.

Illustrative inputPoints in this exampleReason
Female in the historical binary category1Historical scoring variable
Age 45 completed years3Age 41–60
Inhalation injury / full-thickness burn1 + 1Each present in this invented example
TBSA 35%4More than 30% and up to 40%
Total10Arithmetic sum, not a survival estimate

Calculate the point total for valid illustrative inputs

For this exercise enter age as a nonnegative whole number of completed years; enter each binary field as 0 or 1 and TBSA as a number greater than 0 and at most 100. The calculation places fractional TBSA immediately above 10%, 20%, and subsequent thresholds into the next band. Invalid or blank entries return a message. The 81+ age category is capped at five points.

=IF(OR(NOT(ISNUMBER(B2)),NOT(ISNUMBER(B3)),NOT(ISNUMBER(B4)),NOT(ISNUMBER(B5)),NOT(ISNUMBER(B6))),"Invalid burn inputs",IF(OR(B2<>INT(B2),B2<0,B2>1,B3<0,B3<>INT(B3),B4<>INT(B4),B4<0,B4>1,B5<>INT(B5),B5<0,B5>1,B6<=0,B6>100),"Invalid burn inputs",B2+MIN(5,INT(MAX(0,B3-1)/20)+1)+B4+B5+ROUNDUP(B6/10,0)))

Interpretation and limits

The result is only a reproduction of the stated historical point scheme. It does not estimate an individual patient’s chance of survival, determine injury severity, or advise care. Clinical assessments and outcomes vary with case mix, setting, and changes in treatment.

Try the example

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

Further reading