Clinical Medicine & Physiology
Burn Research and Percentage Caps: A Spreadsheet Exercise
Explore a fictional percentage cap and read specialist sources on the limits of burn-fluid and nutrition formulas.
Burn resuscitation and nutrition require clinical context
Published burn-care research describes several approaches to estimating initial fluids. The American Burn Association’s burn-shock guideline addresses adults with burns affecting at least 20% of total body surface area; treatment must be adjusted by the clinical team to the individual and local protocol.
Older nutrition equations such as Curreri are estimates, not guaranteed safe feeding targets. Research has reported that the formula can overestimate measured energy expenditure. This page does not calculate fluid volumes, infusion rates, calorie requirements or patient-specific treatment.
A separate fictional percentage cap
In an invented inventory example, start with 120 units and apply 65%, capped at 50%. The capped percentage is 50%, so the result is 120 × 50/100 = 60 units. With a 35% input, the result is 42 units.
The 50% ceiling here is an arbitrary mathematical illustration. It is not a burn-size rule and does not prevent overfeeding or determine a clinical treatment.
| Invented input percentage | Applied percentage | Result from 120 units |
|---|---|---|
| 35% | 35% | 42 units |
| 50% | 50% | 60 units |
| 65% | 50% | 60 units |
Apply the example cap
Enter a nonnegative quantity in B2 and a percentage between 0 and 100 in B3. MIN applies the fictional 50% cap before multiplication.
=IF(COUNT(B2:B3)<>2,"Enter two numeric values",IF(OR(B2<0,B3<0,B3>100),"Enter a nonnegative quantity and a percentage from 0 to 100",ROUND(B2*MIN(B3,50)/100,2)))Try the example
Use the original values or change them to test your understanding.