论文部分内容阅读
目的介绍Excel VBA在医院基本药物数据统计中的应用。方法利用Excel VBA编写筛选宏程序,筛选出基本药物,运用数据透视表,分类统计基本药物使用率和销售金额比例。结果利用Excel VBA可实现基本药物自动筛选,数据透视表可快速完成基本药物使用率和销售金额比例的汇总计算,较人工操作快捷、简便、准确。结论基于Excel VBA建立的筛选、计算基本药物的新方法切实可行,大大提高了工作效率。
Objective To introduce the application of Excel VBA in the statistics of hospital essential medicines. Methods Using Excel VBA to compile and filter the macro program, filter out the basic drugs, the use of PivotTable, classification statistics of the basic drug usage and the proportion of sales. Results Excel VBA can be used to automatically screen the essential drugs. The PivotTable can quickly sum up the ratio of the basic drug usage and the sales amount, which is faster, easier and more accurate than manual operation. Conclusion Based on the screening established by Excel VBA, the new method of calculating essential drugs is feasible and greatly improves the work efficiency.