基于Excel编程建立湖北省荆州市COVID-19疫情分析报告模板  

Establish A Report Template of COVID-19 Data Analysis Based on Excel Programming

作　　者：蔺茂文 刘天[1] 江鸿 田克卿[1] 曾旻敏 姚梦雷[1] 黄继贵[1] LIN Maowen;LIU Tian;JIANG Hong;TIAN Keqing;ZENG Minmin;YAO Menglei;HUANG Jigui(Jingzhou Municipal Center for Disease Control and Prevention,Jingzhou 434000,Hubei Province y China)

机构地区：[1]荆州市疾病预防控制中心,湖北荆州434000

出　　处：《预防医学情报杂志》2021年第2期175-180,共6页Journal of Preventive Medicine Information

摘　　要：目的基于Excel软件编程建立COVID-19疫情分析报告模板。方法利用Excel 2019软件编程建立COVID-19疫情分析报告模板,分析COVID-19流行特征,用ArcGIS 10.0制作COVID-19发病率专题地图。结果建立了COVID-19流行曲线、人群分布等流行特征的自动化模板,实现了COVID-19流行特征的自动化。结论基于Excel建立的COVID-19疫情分析报告模板具有及时、快速、准确的特点,在疫情防控期间发挥了重要作用,提高了工作效率,值得同行借鉴应用。Objective To establish a report template of COVID-19 data analysis based on Excel programming.Methods A report template of COVID-19 data analysis was established with Excel 2019 programming to analyze epidemic characteristics of COVID-19.Thematic map of COVID-19 incidence rate was drawn by software ArcGIS 10.Result The automatic template of COVID-19 epidemic curve,population distribution and other epidemic characteristics was established,and the analysis of COVID-19 epidemic characteristics was realized automatically.Conclusion The report template of COVID-19 data analysis based on Excel was timely,fast and accurate.This template played an important role in epidemic prevention and control,improved efficiency of work,and merited attention and application.

关 键 词：COVID-19 EXCEL 模板 疫情分析 自动化 

分 类 号：R181[医药卫生—流行病学]