基于Excel vba技术构建审核全肠外营养液处方的算法 点击下载
论文标题: 基于Excel vba技术构建审核全肠外营养液处方的算法
英文标题:
中文摘要: 目的:提高全肠外营养液(TPN)处方审核的效率和准确性。方法:采用Excel vba技术编写vba代码,构建TPN处方审核的算法,确定TPN处方审核的关键指标及其标准;将构建的算法用于审核我院静脉药物配置中心(PIVAS)2018年5月的处方,并将该审方结果与人工审方的结果(以钾离子浓度、一价阳离子浓度和丙氨酰谷氨酰胺配伍氨基酸是否合理为判断指标)进行比较。结果:通过确定TPN处方中的糖脂比、热氮比、一价阳离子浓度等17项关键指标及其审核标准等构建了TPN处方审核算法。采用该算法对我院PIVAS 1个月的 2 638条TPN处方进行审核,总用时为15 s,并标记出了其中449条不合理处方(药物超量、配伍不适宜、营养成分比例不适宜和体积不适宜等情况)及不合理原因;在选取的3个评价指标中,经人工审方发现不合理的处方分别为1、1、0例,构建的算法审核结果分别为4、12、4例。 结论:基于Excel vba技术构建的TPN处方审核算法能大批量审核TPN处方,并且可以自动对不符合标准的处方进行标记,提高了PIVAS审核TPN的效率和准确性。
英文摘要: OBJECTIVE: To improve the efficiency and accuracy of checking total parenteral mutrition (TPN) prescription. METHODS: Excel vba technology was used to edit vba code and construct TPN prescription algorithm. The key indicators and standard of TPN prescription checking were determined. Established algorithm was used to check the prescriptions from PIVAS of our hospital in May 2018, results of which was compared with the results of manual checking (using potassium concentration, monovalent cation concentration and alanyl-glutamine combined with amino acid as indexes). RESULTS: TPN prescription algorithm was established through confirming 17 key indicators as glycolipid ratio, heat-nitrogen ratio, monovalent cation concentration, the checking standard was set as. It took 15 seconds to check 2 638 TPN prescriptions received within one month in PIVAS of our hospital; 449 irrational prescriptions (excessive dose, incompatibility, inappropriate proportion and volume of nutrition) of them and reasons had been marked out. By comparing 3 evaluation indexes, 1, 1, 0 irrational prescriptions were checked by manually and 4, 12, 4 checked by established algorithm, respectively. CONCLUSIONS: TPN prescription algorithm can check prescription in batches based on Excel vba technology, and mark out the substandard prescription automatically. Hereby, it improves the efficiency and accuracy of TPN prescriptions by PIVAS.
期刊: 2019年第30卷第1期
作者: 王亚奇,庞成森,马妮,贺银丽,董卫华
英文作者: WANG Yaqi,PANG Chengsen,MA Ni,HE Yinli,DONG Weihua
关键字: Excel vba;算法;全肠外营养液;审方;合理用药
KEYWORDS: Excel vba; Algorithm; Total parenteral mutrition; Prescription checking; Rational drug use
总下载数: 81次
本日下载数: 2次
本月下载数: 81次
文件大小: 619.60Kb

* 注:未经本站明确许可,任何网站不得非法盗链资源下载连接及抄袭本站原创内容资源!在此感谢您的支持与合作!