Objective: to solve the problems of nonstandard drug management in primary medical institutions and the waste of drugs and funds caused by a large number of drugs exceeding their expiry dates. Taking university hospit...Objective: to solve the problems of nonstandard drug management in primary medical institutions and the waste of drugs and funds caused by a large number of drugs exceeding their expiry dates. Taking university hospitals as an example, based on the previous management experience, the method of drug expiry date management is improved to achieve accurate control. Methods: with the help of Excels powerful data statistics and analysis capabilities and the functions of IF and TODAY functions, the effective combination of qualitative early warning and accurate early warning of drug expiry date was achieved. The macro recording function in Excel is used to realize the automatic sorting function of the warning information of the drug validity period. Results: after the implementation of the Excel validity period warning information management method, the quantity of drugs exceeding the validity period can be effectively reduced, the working efficiency of the management personnel is improved, and the errors in the work are reduced, and the decision-making basis can be provided for the purchase of drugs and the reasonable placement of drugs in the near term. Conclusion: with the help of Excel information management method in the period of validity management of drugs in primary medical institutions, safety accidents can be effectively reduced, medication safety of patients can be ensured, and doctor-patient relationship can be relieved.展开更多
文摘Objective: to solve the problems of nonstandard drug management in primary medical institutions and the waste of drugs and funds caused by a large number of drugs exceeding their expiry dates. Taking university hospitals as an example, based on the previous management experience, the method of drug expiry date management is improved to achieve accurate control. Methods: with the help of Excels powerful data statistics and analysis capabilities and the functions of IF and TODAY functions, the effective combination of qualitative early warning and accurate early warning of drug expiry date was achieved. The macro recording function in Excel is used to realize the automatic sorting function of the warning information of the drug validity period. Results: after the implementation of the Excel validity period warning information management method, the quantity of drugs exceeding the validity period can be effectively reduced, the working efficiency of the management personnel is improved, and the errors in the work are reduced, and the decision-making basis can be provided for the purchase of drugs and the reasonable placement of drugs in the near term. Conclusion: with the help of Excel information management method in the period of validity management of drugs in primary medical institutions, safety accidents can be effectively reduced, medication safety of patients can be ensured, and doctor-patient relationship can be relieved.
