|
|
|
| Application of VBA in the field of hospital statistics |
| Li Xinhao1，Zhou Huoming2，Lai Fuhu2，Xu Jun1，Deng Juanjuan1，Luo Yan1 |
1 The University of Hong Kong-Shenzhen Hospital, Shenzhen 518000; China;
2 Bao′an Authentic TCM Therapy Hospital, Shenzhen 518101; China
|
|
|
|
|
Abstract Objective To explore the application of VBA language in the field of hospital statistics. Methods By writing VBA language of Microsoft office software, the computer can efficiently complete daily basic medical data daily report of outpatients and inpatients, monthly department medical quality publicity data, multidimensional and multi index query department data. Results Through the use of VBA language, the hospital realized the automatic filling of daily outpatient and inpatient medical data template, the automatic verification of inpatient transfer data, and the rapid filling of daily template data; by collecting the medical quality control data of each major functional department every month, it can be automatically split into independent Excel files according to the specified format and sent to each clinical department; the access database visualization method is used to conveniently query the multi index data of clinical departments. Conclusion VBA language can make accurate statistics of data, reduce manual errors, improve the efficiency of data processing, improve the quality of data statistics, ensure the reliability of data statistics, and help hospital statisticians get rid of the daily repetitive boring work, so as to focus on higher quality of mental work.
|
|
Received: 10 May 2021
|
|
|
|
| ［1］陈海生，彭峰，刘玉国．Excel VBA在医院基本药物数据统计中的应用［J］．中国现代应用药学，2015，32(12)：1494-1498．
［2］金朝辉，顾锦建，郑明琳，等．VBA语言在我院药库智能化办公中的应用［J］．中国药房，2016，27(7)：987-989．
［3］朱俊，冯锦丽．Excel Visual Basic应用程序在医院医用耗材管理中的应用分析［J］．中国医学装备，2019，16(2)：84-89．
［4］刘坤彪，陈姝．基于Access VBA的医院门诊信息系统开发［J］．河北软件职业技术学院学报，2013，15(4)：43-48．
［5］赖伏虎，张铮，徐庆十，等．“统计机器人”在医院统计领域的应用［J］．中国医院统计，2020，27(5)：476-480．
［6］李爽，高兰兰，陈军，等．Excel VBA在投标计划及资料归档中的应用［J］．云南水力发电，2021，37(3)：210-212． |
| [1] |
Lin Jianchao. Realization and application of gray model in Excel [J]. journal1, 2021, 28(3): 286-288. |
| [2] |
Han Dong, Ye Yunshao . R markdown and its application in repetitive hospital statistical analysis report[J]. journal1, 2020, 27(6): 554-557. |
| [3] |
Jiang Suling,Sun Boxing,Deng Zhiyu,Li Dan.. Investigation on the current situation of hospital statistics in Sichuan Province under the background of big data[J]. journal1, 2020, 27(5): 455-459. |
| [4] |
Yang Yechun, He Jiajia, Hu Wei. . Current situation and countermeasures of hospital statistics in internet era[J]. journal1, 2020, 27(5): 439-441. |
| [5] |
Lai Fuhu, Zhang Zheng, Xu Qingshi, Zhuang Jiachuan, Chen Junying, Zhou Huoming, Ye Xizhan. . Application of "statistical robot" in hospital statistics field[J]. journal1, 2020, 27(5): 476-480. |
| [6] |
Lin Jianchao. Realization of entropy weight method to determine evaluation index weight in Excel[J]. journal1, 2020, 27(4): 362-364. |
|
|
|
|
