Microsoft Excel in the drug dynamic bidding application.docVIP

 PAGE \* MERGEFORMAT 11 Microsoft Excel in the drug dynamic bidding application Author: Wu-Lan Wang Dong Wang, Shouhui [Abstract] Objective: To explore the Microsoft Excel in the drug in the application of dynamic bidding value; Methods: Using Microsoft Excel the preparation of pharmaceutical dynamic bidding schedule in order to send an e-mail attachment dynamic bidding schedule drugs to pharmaceutical enterprises quote, quotes in the same way back after the drug dynamic bidding schedule, combining all the post offer drug dynamic bidding schedule to the same schedule in Microsoft Excel, select the column to sort the use of data to determine the business and winning bid price; Results: Using Microsoft Excel drugs after the merger offer dynamic bidding schedule, use of data sorting method is simple; Conclusion: The dynamic bidding in the drug use of Microsoft Excel can greatly improve work efficiency, with a high application value. [Keywords:] Microsoft Excel Data Sort drug Dynamic Bidding 1 Drug News Bidding is the drug concentration-governmental organizations, on the basis of bidding, bidding to follow the principles of medicine, in an open, fair and just before the title, by the use of a drug unit on short-term procurement plans for the implementation of drugs immediately tender procurement activities. As the drug-governmental organizations, centralized bidding and procurement of long lead times can not be a good drug prices in line with market changes, but the past two years the Government has not in favor of centralized bidding and procurement of medicines and medical institutions to take drugs is a dynamic bidding to make up centralized bidding and purchasing . 1.1 Drugs dynamic bidding method of procurement of medical institutions according to their own varieties of drugs, drug usage, medical business characteristics, the existing situation of drug supply units and other resources, to the public means short-term demand for drugs, bidding welcome