摘要
目的 :探索效期药品的智能化管理方法。方法 :建立药品目录表格 ,利用Excel“粘贴函数”功能自动筛选出接近失效期的药品。结果 :所有药品的失效期一目了然。结论 :利用Excel管理效期药品科学、准确、方便。
OBJECTIVE:To explore the intelligent management of drugs within expiry dates.METHODS:Table of drug categories was established;those categories near expiry date were screened out automatically through the paste function of Excel.RESULTS:Expiry dates of all drugs were seen clearly.CONCLUSION:It is accurate and simple by applying excel in the intelligent management of drugs within expiry dates.
出处
《中国药房》
CAS
CSCD
北大核心
2005年第3期185-186,共2页
China Pharmacy
关键词
效期药品
EXCEL
粘贴函数
条件格式
管理
Drugs within expiry dates
Excel
Paste function
Conditional format
Management