Arte SheetsLearn. Try. Understand.

Clinical Medicine & Physiology

Penn State Energy-Estimation Research and a Fictional Formula Switch

Read about Penn State energy-expenditure studies and practice selecting between two fictional spreadsheet formulas.

Study context and limitations

Penn State energy-estimation equations have been studied in mechanically ventilated critically ill adults. A later study evaluated a modified equation in a specific group of older adults with obesity. Accuracy figures are properties of the studied cohorts and do not ensure that an estimate is accurate for an individual.

The 2023 ESPEN intensive-care nutrition guideline discusses indirect calorimetry and alternatives when it is unavailable. A predicted resting energy expenditure is not automatically a nutrition prescription, and appropriate clinical assessment and monitoring are necessary.

Practice switching fictional models

This worksheet demonstrates IF using two invented weighted expressions. It does not implement either Penn State equation or calculate patient calorie needs. Enter nonnegative numbers in B2:B4 and select model 1 or 2 in B5.

For inputs 100, 20 and 8, fictional model 1 returns 174 and model 2 returns 176. All inputs are required and the model selector accepts only numeric 1 or 2.

Fictional inputCellExample
BaseB2100
First factorB320
Second factorB48
Model selectorB51 or 2
=IF(COUNT(B2:B5)<>4,"Enter all four numeric values",IF(OR(B2<0,B3<0,B4<0,AND(B5<>1,B5<>2)),"Check values and choose model 1 or 2",ROUND(IF(B5=1,1.1*B2+2*B3+3*B4,0.8*B2+4*B3+2*B4),2)))

Read the original evidence

The references describe the study populations, equations and clinical context. This exercise cannot determine feeding targets, compare individual treatment options or replace dietetic and medical judgment.

Try the example

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

Further reading