EXCEL在突发性环境事件应急监测数据处理中的应用  

Application of Excel in Emergency Monitoring Data Processing of Sudden Environmental Events

作　　者：解光武 罗剑花 王焕香 张金炜 XIE Guang-wu;LUO Jian-hua;WANG Huan-xiang;ZHANG Jin-wei(Guangdong Province Ecological Enviromnental Monitoring Center,Guangzhou 510038,China;Guangdong Zhongneng Testing Technology Co.,Ltd.,Qingyuan,Guangdong 511500,China)

机构地区：[1]广东省生态环境监测中心,广州510308 [2]广东中能检测技术有限公司,广东清远511500

出　　处：《四川环境》2022年第6期248-253,共6页Sichuan Environment

基　　金：广东省省级科技计划项目“协同创新与平台环境建设”(2019B020208006)。

摘　　要：为更好地发挥应急监测对突发环境事件处置的技术支撑作用,把大量应急监测数据直观、科学地展现给应急指挥者。使用公式法、条件格式法、数据透视图表法等,从监测源数据表的制作、数据统计与评价、综合分析等方面介绍了EXCEL在应急监测数据处理中的应用,为环境应急监测人员快速处理应急监测数据提供参考。In order to better play the technical supporting role of emergency monitoring in environmental emergencies handling,and provide a large amount of emergency monitoring data to the emergency commanders intuitively and scientifically,Using formula method,conditional format method,data perspective chart method,etc.,this paper introduced the application of EXCEL in emergency monitoring data processing from making monitoring source data tables,data statistics and evaluation,and comprehensive analysis,which can provide reference for environmental emergency monitoring personnel to quickly process emergency monitoring data.

关 键 词：突发环境事件 应急监测 数据处理 数据透视图表 

分 类 号：X83[环境科学与工程—环境工程]