Application of Excel Functions to the Information Data Statistics for Hospital Drugs / 中国药房

ABSTRACT

OBJECTIVE:To establish a fast,accurate,programmed and automatic mode for the statistical analysis of drug in-formation data so as to achieve the compatibility and the switching among multiple forms and the sharing of data information. METHODS:Common Excel commands and functions as well as their use methods were introduced and analyzed combined with drug information statistics cases. RESULTS & CONCLUSIONS:By taking steps such as exporting raw data,designing drug infor-mation sheets and summarizing drug raw data with the pivot table,the data of the drugs purchased by the hospital in a manner of centralized bidding and national essential drugs purchased can be calculated on the basis of different periods of time to fast and accu-rately search for drug data,facilitate data induction and processing and shorten statistics cycle. The above-mentioned steps are well applicable,easy to master,efficient and fast,reliable in the check of results and data,and suitable for the statistics for hospital drug information and other fields.