Microsoft Excel工作表在医院药品管理中的应用  

Application of Microsoft Excel Worksheet to Management of Drugs in Hospital

作　　者：曾明艺[1] 黄春[1] 

机构地区：[1]广西医科大学第一附属医院,南宁市530021

出　　处：《中国药房》2009年第1期42-43,共2页China Pharmacy

摘　　要：目的:强化医院药品管理。方法:借助Microsoft Excel工作表的排序、计算、高级筛选等功能,补充和完善医院信息系统(HIS)对药品的管理。结果:利用Microsoft Excel工作表参与HIS中药品的库存控制及入库、缺药、滞销药品和失效期的监控,从数量到质量方面都促进了我院药品管理的有效控制。结论:可以利用Microsoft Excel工作表完善以HIS为基础的医院药品电子化管理。OBJECTIVE： To strengthen drug management in hospital. METHODS： Hospital Information System （HIS） - based drug management was supplemented and consummated with the help of Microsoft Excel worksheet＇ s functions such as ranking, computing and advanced screening etc. RESULTS： Using the Microsoft Excel worksheet to help monitor inventory control, warehousing, and shortage of drug supply, unsalable drugs and expiration date in HIS based drug management has facilitated the effective management on both the quality and the quantity of drugs in our hospital. CONCLUSIONS： Microsoft Excel worksheet can be utilized to consummate HIS- based electronic management of drugs in hospital.

关 键 词：MICROSOFT EXCEL工作表 药品 管理 

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