刍议Excel在一体化住院药房盘点中的应用  

Discussion on the Application of Excel in Integrated Inpatient Pharmacy Inventory

作　　者：金涛 王彩云 钱晓萍[1] JIN Tao;WANG Caiyun;QIAN Xiaoping(Department of Pharmacy,the Affiliated Suzhou Hospital of Nanjing Medical University,Suzhou 215153,Jiangsu,China)

机构地区：[1]南京大学医学院附属苏州医院药学部,江苏苏州215153

出　　处：《中国卫生产业》2024年第9期143-147,共5页China Health Industry

基　　金：2019年度苏州市科技发展计划(民生科技—医疗卫生应用基础研究)科研项目(SYSD2019173)。

摘　　要：住院药房一体化是将住院药房与静脉用药调配中心(Pharmacy Intravenous Admixture Services,PIVAs)统一的管理模式。常规的一体化住院药房的盘点为线性流程,通常需要在药房系统停止发药后进行静态盘点,但在盘点时存在一个药品多位存储、数据需要手动计算、盘点误差率较高等缺点。南京大学医学院附属苏州医院根据一体化药房工作流程的特点,通过优化盘点中的流程,灵活使用Excel函数及VBA功能,降低药房人工成本,提高工作效率,并减少手动运算误差。The integration of inpatient pharmacy is a management mode of unified management of inpatient pharmacy and pharmacy intravenous admixture services(PIVAs).The inventory of the conventional integrated inpatient pharmacy is a linear process.It is usually necessary to perform a static inventory after the pharmacy system stops dispensing.However,there is a multi-bit storage of drugs during the inventory,the data needs to be manually calculated,and the inventory error rate is high.According to the characteristics of the integrated pharmacy workflow,Suzhou Hospital Affiliated to Nanjing University Medical College optimizes the process of inventory,flexibly uses Excel function and VBA function,reduces the labor cost of pharmacy,improves the work efficiency,and reduces the error caused by manual operation and statistics.

关 键 词：EXCEL 一体化住院药房 药品盘点 

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