运用Excel 表改进我院药品的有效期管理.pdfVIP

运用Excel 表改进我院药品的有效期管理 ＊ 林 琳 （浙江省台州医院，浙江临海 317000） 中图分类号 R95 文献标志码 A 文章编号 1001-0408（2013）37-3492-04 DOI 10.6039/j.issn.1001-0408.2013.37.14 摘 要 目的：加强药品有效期管理。方法：介绍医院药房药品有效期管理改进措施，即利用Excel 表中的条件查找VLOOKUP 函 数功能，将单个“药品使用量、有效期、库存量”等Excel 表格整合到同一Excel 表格中并计算效期周转率，根据效期周转率确定高危 效期药品并对其重新检查，以此加强“高危效期”药品检查力度，改进药品有效期管理方法。结果与结论：通过对“高危效期”药品 的二次检查，促进了管理“高危效期”药品的针对性、全面性，减少了隐患。因此，借助Excel 表的相应功能有助于提升药品有效期 管理的质量和效率。 关键词 Excel 表；药房；药品；有效期管理；改进；高危效期 Improvement of Validity Period Management of Medicines in Our Hospital by Excel Table LIN Lin （Taizhou Hospital of Zhejiang Province ，Zhejiang Linhai 317000，China ） ABSTRACT OBJECTIVE ：To strengthen the management of validity period of medicine. METHODS ：The improvement mea- sures for validity period management of medicines were introduced. By using VLOOKUP function of Excel software ，the spread- sheets of “medicine amount ，period of validity and inventory level”were integrated into one Excel spreadsheets ，and the turnover rate of validity period was calculated. According to the turnover rate of validity period ，high risk validity medicines were confirmed and rechecked to strengthen the inspection of high risk validity medicines and improve the management of validity period. RE- SULTS CONCLUSIONS ：Through the secondary inspection for the high risk validity medicines ，the pointed and comprehensive management of validity medicines has been improved ，and hidden risk has been reduced. The application of Excel is helpful to im- prove the quality and efficiency of the management of validity period. KEY WORDS Excel table ；Pharmacy ；Medicine ；Validity period management ；Improvement ；High risk validity 药品有效期是指药品在规定的贮存条件下保证其质量的 以掌握，故往往产生滞销。而滞销药品的种类和数量又会对 期限。超过有效期的药品，不仅会含量下降而降低疗效，甚至 药品的效期管理带来影响，存在潜在隐患。 [1] 可能会产生有毒的物质，对人体健康产