【摘要】 本研究利用Excel VBA技术设计门诊药房辅助库存盘点程序,以期提高门诊药房库存盘点效率。其间建立了药品基础数据库,对HIS系统导出的原始盘点表、自动发药机导出的发药机药品库存信息进行数学运算,得到最终的门诊药房库存盘点表。结果表明,单次盘点时间由原来的120min左右降至60min左右,门诊药房辅助库存盘点程序的应用能有效提高库存盘点效率。更多还原

【Abstract】 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 medicine database was established, and the original inventory table derived from the HIS system and the medicine inventory 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 about120 minutes to about 60 minutes. The application of the outpatient pharmacy-assisted inventory counting program can effectively improve the inventory counting efficiency.更多还原