Excel VBA在医院基本药物数据统计中的应用

陈海生; 彭峰; 刘玉国<sup>*</sup>

引用本文:	陈海生,彭峰,刘玉国.Excel VBA在医院基本药物数据统计中的应用[J].中国现代应用药学,2015,32(12):1494-1498.
	CHEN Haisheng,PENG Feng,LIU Yuguo.Application of Excel VBA in Essential Drugs Data Statistics in Hospital[J].Chin J Mod Appl Pharm(中国现代应用药学),2015,32(12):1494-1498.

【打印本页】【HTML】【下载PDF全文】【查看/发表评论】【EndNote】【RefMan】【BibTex】

←前一篇|后一篇→

过刊浏览高级检索

本文已被：浏览 2142次下载 1953次	码上扫一扫！
分享到：微信更多字体:加大+\|默认\|缩小-
Excel VBA在医院基本药物数据统计中的应用
陈海生¹, 彭峰², 刘玉国¹
1.山东省肿瘤医院药学部，济南 250117;2.山东师范大学附属小学，济南 250000

摘要:

目的介绍Excel VBA在医院基本药物数据统计中的应用。方法利用Excel VBA编写筛选宏程序，筛选出基本药物，运用数据透视表，分类统计基本药物使用率和销售金额比例。结果利用Excel VBA可实现基本药物自动筛选，数据透视表可快速完成基本药物使用率和销售金额比例的汇总计算，较人工操作快捷、简便、准确。结论基于Excel VBA建立的筛选、计算基本药物的新方法切实可行，大大提高了工作效率。

关键词: 基本药物 VBA 宏筛选数据透视表

DOI：

分类号:

基金项目:

Application of Excel VBA in Essential Drugs Data Statistics in Hospital

CHEN Haisheng¹, PENG Feng², LIU Yuguo¹

1.Department of Pharmacy, Shandong Tumor Hospital, Jinan 250117, China;2.Primary School Attached to Shandong Teachers’ University, Jinan 250000, China

Abstract:

OBJECTIVE To introduce the application of Visual Basic for Applications (VBA) in Microsoft Excel in essential drugs data statistics in hospital. METHODS The macro-program written in Excel VBA was built to selected essential drugs. Then, the use rate and sales ratio of essential drugs was calculated by PivotTable. RESULTS The macro-program based on VBA in Microsoft Excel could automatically screen essential drugs, and PivotTable could quickly calculate data of essential drugs. The whole process was faster, easier and more accurate compared with manual operation. CONCLUSION A new method of screening and calculating essential drugs based on Excel VBA is feasible, greatly improving the work efficiency.

Key words: essential drug VBA macro screening PivotTable