Application of Excel Functions to the Information Data Statistics for Hospital Drugs

VernacularTitle:Excel函数在医院药品信息数据统计中的应用
Author: Zhu LIANG ; Wei WEI ; Yongshou ZHANG
Publication Type:Journal Article
Keywords: Excel function; Pivot table; Statistics for drug information data
From: China Pharmacy 2015;(22):3156-3158
CountryChina
Language:Chinese
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.