疫情数据统计中ExcelVBA代码的高效应用  

Efficient application of Excel VBA code in epidemic situation data statistics

作　　者：毛永峰 Mao Yongfeng(Primary School Affiliated to Nantong Higher Normal College,Nantong 226009)

机构地区：[1]南通高等师范学校附属小学,南通226009

出　　处：《现代计算机》2023年第4期100-104,共5页Modern Computer

摘　　要：利用ExcelVBA技术快速统计、汇总疫情数据,并根据上级模板自动生成格式规范的报表。应用Excel开发工具MicrosoftVisualBasicforApplication(下称VBA)功能,分析基层上报数据,进行字段提取、身份证有效性判断、性别年龄自动生成、管控状态分类、数据合并写入目标汇总表等自动操作,生成符合规范的统计报表,通过简便的操作就能实现疫情监测数据的高效处理,有效减轻基层数据统计的负担。Excel VBA technology is used to quickly count and summarize epidemic data,and automatically generate standardized reports according to the superior template.Microsoft Visual Basic for Application(hereinafter referred to as VBA),an Excel development tool,is used to analyze the data reported by the grassroots,perform automatic operations such as field extraction,ID card validity judgment,gender and age automatic generation,control status classification,data consolidation and writing into the target summary table,and generate standardized statistical reports.Through simple operations,the epidemic monitoring data can be efficiently processed,effectively reduce the burden of grassroots data statistics.

关 键 词：EXCEL VBA 数据统计 疫情数据处理 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术] C32[自动化与计算机技术—计算机科学与技术]