Excel VBA在康复治疗师数据统计中的应用

doi:10.3969/j.issn.1006-5253.2023.02.015

Abstract
Figure/Table
References (0)
Related Citation (15)

Download: PDF (5480 KB) HTML (1 KB)
Export: BibTeX | EndNote (RIS) Supporting Info

Guide

Abstract Objective To explore the application of Excel VBA in data statistics of rehabilitation therapists.Methods The Excel VBA program embedded in Microsoft office was used to compile the code, and the corresponding forms, engineering files and modules were designed to enable the computer to complete the statistics of rehabilitation assessment, rehabilitation treatment, clinical examination and other data by the rehabilitation therapists.Results Through Excel VBA programming, we designed a data statistics program that met the clinical work needs of rehabilitation therapists. In this study, we recorded the complete basic information and treatment process of 534 rehabilitation patients. It provided a window interface for query and patient information input, which was automatically saved in a format that occupied less memory, enabling the rehabilitation therapists to quickly query the patients′ treatment process data and quickly accumulate the basic data of rehabilitation clinical research.Conclusion Using Excel VBA programming can improve the data statistics efficiency of rehabilitation therapists, reduce the error rate, improve the reliability of data, so as to improve the daily work efficiency and provide strong support for clinical research.

Key words： Excel VBA rehabilitation data statistics

Received: 14 September 2022

PACS:

Fund:

	Service

	E-mail this article
	Add to my bookshelf
	Add to citation manager
	E-mail Alert
	RSS
	Articles by authors
	Mao Xiaoliang
	Cai Naixin
	Yuan Jieyang
	Wu Xiaoqing

Cite this article:

Mao Xiaoliang,Cai Naixin,Yuan Jieyang, et al. Application of Excel VBA in data statistics of rehabilitation therapists[J]. journal1, 2023, 30(2): 157-160.

URL:

http://manu58.magtech.com.cn/Jwk_zgyytj/EN/10.3969/j.issn.1006-5253.2023.02.015 OR http://manu58.magtech.com.cn/Jwk_zgyytj/EN/Y2023/V30/I2/157

［1］李敏盈，蒋蓓蓓，曾秋苑．基于SWOT分析的医院科研项目过程管理提升策略［J］．科技视界，2021(14)：180-181．DOI: 10.19694/j.cnki.issn2095-2457.2021.14.78.

［2］孙娟，卞希祥．支持医疗过程管理的电子病历设计思想与临床应用［J］．中国医疗器械信息，2020，26(23)：163-166．DOI: 10.15971/j.cnki.cmdi.2020.23.075.

［3］陈丽兰，莫英绪，罗世兴．新形势下住院医师临床实践能力的全过程管理［J］．中国继续医学教育，2021，13(23)：94-98．DOI: 10.3969/j.issn.1674-9308.2021.23.026.

［4］李昕昊，周火明，赖伏虎，等．VBA在医院统计领域的应用探讨［J］．中国医院统计，2021，28(4)：372-379．DOI: 10.3969/j.issn.1006-5253.2021.04.018.

［5］朱俊，冯锦丽．Excel Visual Basic应用程序在医院医用耗材管理中的应用分析［J］．中国医学装备，2019，16(2)：84-89．DOI: 10.3969/J.ISSN.1672-8270.2019.02.023.

［6］刘中文．基于VBA编程的砝码检定证书自动生成方法［J］．衡器，2021，50(11)：31-34．DOI: 10.3969/j.issn.1003-5729.2021.11.010.

［7］江心怡，陈敏．电子病历数据治理方法的研究［J］．中国医院管理，2020，40(8)：68-70．

［8］于海铸，王兴强．基于HIS的临床路径系统优化方法研究［J］．医疗卫生装备，2021，42(3)：77-80．DOI: 10.19745/j.1003-8868.2021059.

［9］段鹣李,陈廷寅.基于信息技术的临床科研数据平台建设［J］.中国现代医学杂志,2020,30(9):124128.

［10］孙仁华，刘景全，杨向红．急性肾损伤遇见大数据时代：为我们带来了什么［J］．中国急救医学，2018，38(2)：97-102．DOI: 10.3969/j.issn.1002-1949.2018.02.001.

［11］王海星，张靓，杨志清，等．医疗大数据在临床科研中的应用探讨［J］．中国医院，2020，24(7)：63-64．DOI: 10.19660/j.issn.1671-0592.2020.07.19.

［12］丁士锋，张鹏伟．Excel VBA标准教程［M］．北京：化学工业出版社，2011．

［13］李婷婷．基于VBA技术的医疗器械计量管理系统的设计与实现［J］．中国医疗设备，2022，37(1)：56-59．DOI: 10.3969/j.issn.1674-1633.2022.01.014.

［14］叶晨，金文忠．基于临床科研一体化随访系统的设计与应用［J］．中国卫生信息管理杂志，2021，18(3)：387-391．DOI: 10.3969/j.issn.1672-5166.2021.03.018.

［15］黄海樱，陈波，周强，等．利用Excel VBA函数在医学检验中进行四格表统计的教学尝试［J］．临床输血与检验，2021，23(6)：788-793．DOI: 10.3969/j.issn.1671-2587.2021.06.025.

［16］屠海锋，邢美园．基于Excel+VBA的SCIE文献批量处理方法［J］．电脑编程技巧与维护，2021(1)：95-97．DOI: 10.16184/j.cnki.comprg.2021.01.033.

［17］李爽，高兰兰，陈军，等．Excel VBA在投标计划及资料归档中的应用［J］．云南水力发电，2021，37(3)：210-212．