国家三级公立医院绩效考核背景下基于Excel VBA技术合理用药指标信息化系统的开发与应用  

Development and Application of Information System for Rational Drug Use Indexes Based on Excel VBA Technology under the Background of Performance Appraisal of National Tertiary Public Hospitals

作　　者：古文亮[1] 雒馨怡 何文统 火琴文 GU Wen-liang;LUO Xin-yi;HE Wen-tong;HUO Qin-wen(Department of Pharmacy,The First Hospital of Lanzhou University,Lanzhou 730000,China;Department of Pharmacy,Qingcheng County People′s Hospital,Qingyang 745100,China)

机构地区：[1]兰州大学第一医院药剂科,甘肃兰州730000 [2]庆城县人民医院药剂科,甘肃庆阳745100

出　　处：《海峡药学》2024年第11期122-125,共4页Strait Pharmaceutical Journal

摘　　要：目的 构建国家三级公立医院绩效考核合理用药指标信息化体系,提高考核数据统计效率,保障统计过程中重要数据的完整性和准确率。方法 分析国家三级公立医院绩效考核中合理用药评价指标的定义、计算方法、意义和内涵,信息药师基于Excel VBA编程技术编写考核指标自研计算器,通过历年数据比对验证,建立合理用药相关指标的信息化体系,比较6个月相关指标常规统计和自研程序统计两种方法的用时和准确度。结果 应用Excel VBA编程技术后,数据上报的准确性提高到100%,数据统计的时间缩短到10 min。结论 通过运用Excel VBA技术构建的国家三级公立医院绩效考核合理用药指标信息化体系,具有较高的工作效率和数据准确性,可以大幅度减少工作人员的工作量和工作强度,VBA语言作为医院信息管理系统的补充,也可以为药事管理的精细化水平提供更为切实的数据决策参考。OBJECTIVE To construct an information system for performance appraisal of rational drug use indicators in national tertiary public hospitals,improve the statistical efficiency of appraisal data,and ensure the integrity and accuracy of important data in the statistical process.METHODS Information pharmacist analyzed the definition,calculation method,significance and connotation of evaluation indexes of rational drug use in the performance appraisal of national tertiary public hospitals.And then,Information pharmacist wrote self-developed calculator of appraisal indexes based on Excel VBA programming technology,and established an information system of related indicators of rational drug use through the comparison and verification of data over the years.The time and accuracy of conventional statistical method and self-developed statistical method were compared for 6 months.RESULTS After the application of Excel VBA programming technology,the accuracy of data reporting was improved to 100%,and the time of data statistics was reduced to 10 minutes.CONCLUSION The information system for performance appraisal of rational drug use indexes of national tertiary public hospitals built by using Excel VBA technology has high work efficiency and data accuracy,which can greatly reduce the workload and work intensity of staff.VBA language is a supplement to the hospital information management system,also can provide more practical data decision-making reference for the refinement level of pharmacy administration.

关 键 词：Excel VBA 合理用药指标 药事管理 国家三级公立医院绩效考核 信息药师 

分 类 号：R969[医药卫生—药理学]