基于Excel VBA技术的门诊药房辅助库存盘点程序设计  

Design of Outpatient Pharmacy Assisted Inventory CountingProgram Based on Excel VBA Technology

作　　者：闫冰洋 李洁 李维凤 YAN Bingyang;LI Jie;LI Weifeng(Xinxiang First People's Hospital,Xinxiang Henan 453000;School of Pharmacy,Health Science Center,Xi'an Jiaotong University,Xi'an Shaanxi 710061)

机构地区：[1]新乡市第一人民医院,河南新乡453000 [2]西安交通大学医学部药学院,陕西西安710061

出　　处：《河南科技》2020年第2期38-40,共3页Henan Science and Technology

摘　　要：本研究利用Excel VBA技术设计门诊药房辅助库存盘点程序,以期提高门诊药房库存盘点效率。其间建立了药品基础数据库,对HIS系统导出的原始盘点表、自动发药机导出的发药机药品库存信息进行数学运算,得到最终的门诊药房库存盘点表。结果表明,单次盘点时间由原来的120min左右降至60min左右,门诊药房辅助库存盘点程序的应用能有效提高库存盘点效率。Excel VBA technology was used to design an outpatient pharmacy-assisted inventory counting program in order to improve the outpatient pharmacy inventory inventory efficiency in this study. In the meantime, a basic medi cine database was established, and the original inventory table derived from the HIS system and the medicine invento ry information of the dispenser issued by the automatic dispenser were mathematically calculated to obtain the final outpatient pharmacy inventory inventory table. The results show that the single inventory time is reduced from about 120 minutes to about 60 minutes. The application of the outpatient pharmacy-assisted inventory counting program can effectively improve the inventory counting efficiency.

关 键 词：门诊药房 EXCELVBA 药品盘点 

分 类 号：TP311.11[自动化与计算机技术—计算机软件与理论]