文献速递重症综合管理与镇静镇痛

应用VBA编程实现高质量危重症评分

[Application of VBA programming to achieve high quality critical illness score].
PubMed 文献 · Zhonghua Wei Zhong Bing Ji Jiu Yi Xue · 2021-01-01
一句话结论通过VBA自编程可将危重症评分(含SOFA)的数据录入到出分总时间控制在2分钟以内,且重复性强。

该文介绍用Microsoft Excel的VBA编程将急性生理与慢性健康评估II(APACHE II)、逻辑器官功能障碍评分(LODS)和序贯器官衰竭评估(SOFA)整合为危重症评分程序。以文献已发表的病例数据为例,直接复制年龄、体重、体温、脉搏、血压、血常规、血生化、血气分析等数据,点击「粘贴数据」按钮自动填充并选择最差选项,再按情况输入去甲肾上腺素使用、机械通气、格拉斯哥昏迷评分(GCS)和24小时尿量,点击「评分」按钮即得SOFA评分。结果显示从数据输入到获得评分结果总时间小于2分钟,且重复性强。作者结论为应用VBA自编程可快速、准确地进行危重症评分。

要点

  • 用Microsoft Excel的VBA将APACHE II、LODS和SOFA整合为危重症评分程序。
  • 直接复制年龄、体重、体温、脉搏、血压、血常规、血生化、血气分析等数据后点击「粘贴数据」按钮可自动填充并选择最差选项。
  • 再按情况输入去甲肾上腺素使用、机械通气、GCS评分和24小时尿量后点击「评分」按钮即得SOFA评分。
  • 从数据输入到获得评分结果总时间小于2分钟,且重复性强。

处置流程与药物剂量

  • 第一步:直接复制患者数据,如年龄、体重、体温、脉搏、血压、血常规、血生化、血气分析等。
  • 第二步:返回程序,点击「粘贴数据」按钮,数据自动填充,并选择最差选项。
  • 第三步:按情况输入去甲肾上腺素使用、机械通气、GCS评分和24小时尿量。
  • 第四步:点击「评分」按钮,获得SOFA评分。

研究设计与关键结果

  • 以文献已发表的病例数据为例,将程序应用于SOFA评分,从数据输入到获得评分结果总时间小于2分钟,且重复性强。

证据类型、等级与局限

  • 证据类型:方法学描述性研究(以文献已发表病例数据为例演示程序应用)。
  • 局限:原文未报告局限性。

对床旁实践的改变

  • 原文结论认为,应用VBA自编程可快速、准确地执行危重症评分。

提炼说明

  • 本条依据论文摘要整理;摘要未涉及「适用人群与场景」「诊断标准与关键阈值」「红旗征与不能漏的情况」「指南或共识出处」,故未列出这些栏目;全文请点「阅读原文」。
英文原文(摘要)· 点击展开

OBJECTIVE: To establish a high-quality critical illness scoring program by VBA programming.

METHODS: The acute physiology and chronic health evaluatin II (APACHE II), Logistic organ dysfunction score (LODS) and sequential organ failure assessment (SOFA) were combined into a program with visual basic for applications (VBA) of Microsoft Excel. Taking the case data published in the literature as an example, the program was applied to SOFA score. First, directly copied the patient's data, such as age, body weight, body temperature, pulse, blood pressure, blood routine, blood biochemistry, blood gas analysis, etc. Then, returned to the program, clicked the "paste data" button, and the data would be automatically filled in, and selected the worst option. Then, the usage of norepinephrine, mechanical ventilation, Glasgow coma scale (GCS) score and 24-hour urine volume were input according to the situation. Finally, clicked the "score" button to get SOFA score.

RESULTS: Pasted the data directly into the critical illness scoring program and checked it accordingly. The total time from data input to abtaining scoring result was less than 2 minutes; and the repeatability was strong.

CONCLUSIONS: The application of VBA self-programming can quickly and accurately perform critical illness scoring.

来源:Zhonghua Wei Zhong Bing Ji Jiu Yi Xue,查看原文。版权归原作者所有。

参考来源

  1. Shi Z. [Application of VBA programming to achieve high quality critical illness score]. Zhonghua Wei Zhong Bing Ji Jiu Yi Xue. 2021. PMID: 34412761. doi:10.3760/cma.j.cn121430-20201215-00752

供执业医师抢救与诊疗参考,不替代临床判断;剂量请结合体重、肝肾功能和本院药品规格复核,以指南原文为准。