Emergency public health event monitoring data processing method based on VBA module

• Main Authors: HE JIBO, GAO HUXING, YANG ZUSHUN, ZHAO SHIWEN, CHEN LIHUA
• Format: Patent
• Language: Chinese; English
• Published: 23.06.2023
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; HEALTHCARE INFORMATICS, i.e. INFORMATION AND COMMUNICATIONTECHNOLOGY [ICT] SPECIALLY ADAPTED FOR THE HANDLING ORPROCESSING OF MEDICAL OR HEALTHCARE DATA; INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTEDFOR SPECIFIC APPLICATION FIELDS; PHYSICS

The invention relates to the technical field of emergent public health events, in particular to an emergent public health event monitoring data processing method based on a VBA module. The method comprises the following steps: S1, establishing a VBA data processing module; s2, newly establishing an EXCEL summary file, wherein the file name is set to be monthly analysis of an emergent public health event and the date of the current month; s3, calling data in the emergency public health event folder and arranging the data into a required format; s4, needed data are selected according to work needs; s5, converting the extracted data into texts according to work needs, and outputting the texts; and S6, arranging the data, output in the step S5, of each folder into required formats. According to the emergent public health event monitoring data processing method based on the VBA module provided by the invention, the automatic processing of the cyclic monitoring data of the event type is realized, and the efficiency