Arte SheetsLearn. Try. Understand.

Health & Fitness

Du Bois and Haycock Body Surface Area: A Spreadsheet Comparison

Compare two empirical body-surface-area estimates using fictional weight and height inputs. This example is not a medication-dose calculator.

Two empirical estimates, not a dosing protocol

Body surface area (BSA) may be estimated from weight and height using several empirical formulas. Du Bois and Du Bois and Haycock and colleagues used different datasets and coefficients; their outputs can differ. Neither result here is a direct measurement or a substitute for clinical judgment.

This is an educational spreadsheet exercise. It does not calculate, cap, prescribe, or verify a chemotherapy dose. Drug-specific maximum mass and a maximum body-surface-area rule are different constraints; one cannot be substituted for the other. Any medication dose must follow the applicable prescribed protocol and professional verification.

Illustrative comparison

For invented inputs of 75 kg and 175 cm, the Du Bois formula gives 1.9031 m² and the Haycock formula gives 1.9166 m² after rounding to four decimals. For 110 kg and 180 cm they give 2.2858 m² and 2.3814 m², respectively. These estimates are not interchangeable without considering the applicable use and method.

Illustrative weight and heightDu Bois estimateHaycock estimate
75 kg, 175 cm1.9031 m²1.9166 m²
110 kg, 180 cm2.2858 m²2.3814 m²

Du Bois estimate

With B2 in kilograms and B3 in centimetres, compute 0.007184 × weight^0.425 × height^0.725. Numeric, positive inputs are required; this check does not establish that the measurements are correct or appropriate.

=IF(COUNT(B2:B3)<>2,"Enter numeric weight and height",IF(OR(B2<=0,B3<=0),"Weight and height must be positive",ROUND(0.007184*B2^0.425*B3^0.725,4)))

Haycock estimate

With the same units, compute 0.024265 × weight^0.5378 × height^0.3964. Haycock and colleagues evaluated their geometric method across infants, children and adults; a calculation alone does not validate an individual result.

=IF(COUNT(B2:B3)<>2,"Enter numeric weight and height",IF(OR(B2<=0,B3<=0),"Weight and height must be positive",ROUND(0.024265*B2^0.5378*B3^0.3964,4)))

Try the example

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

Further reading