摘要
利用excel函数功能编写相应的公式,对环境统计数据的完整性、逻辑合理性以及历史变化幅度实现快速审核,进一步提高了数据质量,提升了数据审核的自动化、个性化程度,并在实际应用中取得了较好的效果。
Based on the function of excel, we wrote the formula to audit the environmental statistics in integrity, logical rationality and historical changes. The data of statistics are quickly reviewed, which has further improved data quality and enhanced the degree of automation and personalization of data auditing. It improved work efficiency and data veracity and took a better effect in practical application.
引文
[1]王晓霞.EXCEL在环境监测数据统计中的应用[J].环境与发展,2017(05):196-228.
[2]龙海燕.巧妙应用EXCEL相关功能高效统计气象资料[J].农业与技术,2017(10):216-225.
[3]黄文莉.Excel数据处理活用范例大辞典[M].北京:中国铁道出版社,2014:03.
[4]亓靓,宋传真,唐俊.Excel VBA对环境统计软件数据审核功能的改进[J].环境科学与管理,2010(11):36-37.
[5]刘英杰.浅论环境统计中数据的审核方法[J].中国环境监测,2007(3):40-44.