Arte SheetsLearn. Try. Understand.

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 percentageApplied percentageResult 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.

Further reading