Arte SheetsLearn. Try. Understand.

Clinical Medicine & Physiology

Lund–Browder Charts and Weighted Percentages: A Spreadsheet Exercise

Explore how weighted percentages add up using imaginary regions, and find official resources on burn-size assessment.

Age and burn-size assessment

The Lund–Browder chart estimates burn extent using age-dependent body proportions. Clinicians assess the relevant body regions and burn depth using a suitable chart and the complete patient context; the American Burn Association and other authorities provide reference materials.

This worksheet is not a Lund–Browder chart and does not estimate a burn. The values below are imaginary regions of a generic whole, not human body proportions. The example cannot determine treatment or replace professional assessment.

A separate weighted-percentage example

Suppose imaginary regions A, B and C account for 20%, 30% and 50% of a whole. If the selected fractions are 0.5, 0.25 and 0.1, their contributions are 10, 7.5 and 5 percentage points, for a total of 22.5%.

The regions must sum to 100% in this example and each selected fraction must be between 0 and 1. These mathematical conditions do not validate any clinical assessment.

Imaginary regionShare of wholeSelected fractionContribution
A20%0.510%
B30%0.257.5%
C50%0.15%
Total100%—22.5%

Add weighted percentages

Enter three shares in B2:B4 and their selected fractions in C2:C4. COUNT checks all six values, then the formula validates the shares and fractions before multiplying and summing.

=IF(COUNT(B2:C4)<>6,"Enter six numeric values",IF(OR(MIN(B2:C4)<0,MAX(B2:B4)>100,MAX(C2:C4)>1,ABS(SUM(B2:B4)-100)>0.000001),"Check percentages and fractions",ROUND(SUMPRODUCT(B2:B4,C2:C4),2)))

Try the example

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

Further reading