基于Excel程序自制的营养计算程序在危重烧伤患者膳食营养管理中的应用

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

笔者应用Excel程序编制营养计算程序,以《中国食物成分表(2002版)》《中国食文化学术研讨会论文集》和国家体育总局运动医学研究所运动营养研究中心常见食物营养成分表为数据源,有包装的食品营养成分以包装食品标签上的标识值为数据源,针对危重烧伤患者日常膳食建立营养成分数据库。根据食物净含量比例,采用公式计算危重烧伤患者日常膳食营养成分。采用电子秤对患者经口及胃管摄入的食物称质量,将质量数据输入Excel表格后可以迅速地较准确地自动生成患者膳食所含营养成分的值,且方便水分出入量计算,能较快捷、准确地为危重烧伤患者提供膳食状况评估;其不但可算出能量和水分摄入总量,还可逐日算出蛋白质摄入量、三大营养物质在能量供应中的比例,为进一步加强、改善营养支持提供了可信依据。

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.