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 input | Points in this example | Reason |
|---|---|---|
| Female in the historical binary category | 1 | Historical scoring variable |
| Age 45 completed years | 3 | Age 41–60 |
| Inhalation injury / full-thickness burn | 1 + 1 | Each present in this invented example |
| TBSA 35% | 4 | More than 30% and up to 40% |
| Total | 10 | Arithmetic 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.