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 region | Share of whole | Selected fraction | Contribution |
|---|---|---|---|
| A | 20% | 0.5 | 10% |
| B | 30% | 0.25 | 7.5% |
| C | 50% | 0.1 | 5% |
| Total | 100% | — | 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.