EXCEL表格分析法在医院近效期药品管理中的实践

EXCEL analysis in the commodity management of drugs close to expiration date

目的探索运用EXCEL表格分析法对近效期药品进行管理。方法定人、定时、定期对近效期(≤6个月)药品信息进行汇总,建立格式化的近效期药品管理电子表格,通过比较近期药品每月各部门的库存情况动态观察药品的使用情况,及时调整采购量,并将其在使用较多的部门间调度使用。结果利用EXCEL表格分析法可实现对近效期药品情况的动态了解并在有效期内得到充分使用。结论 EXCEL表格分析法是近效期药品管理的很好的方法。

Objective To explore EXCEL analysis in the commodity management of drugs close to expiration date.Methods We collected information of drugs, and established EXCEL data, evaluated and analysed the drug dynamic information and timely adjusted the purchase quantity. Results EXCEL analysis helped to know about the dynamic information of drugs close to expiration date. Conclusion EXCEL analysis is helpful in the management of drugs close to expiration date.