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

Application of VBA programming to achieve high quality critical illness score

作　　者：施宗驱 Shi Zongqu(Department of Traumatic Surgery,Ninghai First Hospital,Ninghai 315600,Zhejiang,China)

机构地区：[1]宁海县第一医院创伤外科,浙江宁海315600

出　　处：《中华危重病急救医学》2021年第7期876-877,共2页Chinese Critical Care Medicine

摘　　要：目的应用VBA编程,建立一个高质量的危重症评分程序。方法选用Excel软件自带的VBA语言,将急性生理学与慢性健康状况评分Ⅱ(APACHEⅡ)、Logistic器官功能障碍评分(LODS)、序贯器官衰竭评分(SOFA)的评分标准编成一个程序。以文献中公布的病例数据为例,应用该程序进行SOFA评分。首先,直接复制患者数据,如年龄、体质量、体温、脉搏、血压、血常规、血生化、血气分析等,返回程序点击"粘贴数据"按钮,数据即自动填入,选择最差值选项;然后根据情况输入去甲肾上腺素用法、机械通气情况、格拉斯哥昏迷评分(GCS)、24 h尿量等;最后点击"评分"按钮,即可得出SOFA评分。结果将数据直接粘贴到危重症评分程序中,进行相应勾选,从数据输入到得出评分结果的总用时不到2 min;并且可重复性强。结论应用VBA自编程,可快速、准确进行危重病评分。Objective To establish a high-quality critical illness scoring program by VBA programming.Methods The acute physiology and chronic health evaluatinⅡ(APACHEⅡ),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.Conclusion The application of VBA self-programming can quickly and accurately perform critical illness scoring.

关 键 词：危重症评分 VBA程序 编程 

分 类 号：R459.7[医药卫生—急诊医学]