中国药房Issue(22)：3156-3158,3.DOI:10.6039/j.issn.1001-0408.2015.22.41
Excel函数在医院药品信息数据统计中的应用
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.关键词
Excel函数/数据透视表/药品信息数据统计Key words
Excel function/Pivot table/Statistics for drug information data分类
医药卫生引用本文复制引用
梁竹,魏玮,张永寿..Excel函数在医院药品信息数据统计中的应用[J].中国药房,2015,(22):3156-3158,3.
