[Application of a self-made nutrition calculation program based on Excel program in dietary nutrition management of patients with critical burns]

Zhonghua Shao Shang Za Zhi. 2019 Aug 20;35(8):622-623. doi: 10.3760/cma.j.issn.1009-2587.2019.08.015.
[Article in Chinese]


We used Excel program to compile nutrition calculation program. A nutrition database for daily diet of patients with critical burns is established based on data sources of Chinese food composition table (2002 edition) , Chinese food culture academic symposium collection and common food nutrition table of the sports nutrition research center of Sports Medical Research Institute of General Administration of Sports of China, and label values of nutrition components of packaged food. According to the proportion of food net content, the formulas are adopted for calculating the dietary nutrition composition of patients with critical burns. An electronic scale is used to weigh the quality of food ingested through the mouth and gastric tube. After recording the weight into Excel scale, the value of nutrition content in patients' diet can be quickly and accurately generated automatically. It is convenient to calculate the water intake and output, which can quickly and accurately provide the dietary status assessment for patients with critical burns. It can not only calculate the total energy and water intake amount, but also calculate the daily protein intake and proportions of the three major nutrients in energy supply. Therefore, it provides a credible basis for further strengthening and improving nutritional support.


Keywords: Burns; Diet; Excel program; Nutritional support.

MeSH terms

  • Body Weight
  • Burns / therapy*
  • China
  • Diet
  • Humans
  • Nutritional Support*
  • Software