Excel宏在地质样品分析数据快速处理中的应用

The Application of Excel Macro in the Rapid Processing of Geoanalyticai Data

摘要: Microsoft Excel是微软公司的一款优秀的数据管理软件,已经成为地质测试工作中主要的数据处理工具.作者根据实际工作经验,编制了几个Excel的VBA宏,用于常见分析仪器导出数据的日常处理,减少了输入错误,提高了数据处理的可靠程度和处理速度,可以部分地将质量管理员的数据输入和修约工作得到简化,从而把更多的精力投入到质量管理工作中去.

Abstract: Microsoft Excel is the popular software and can be used as a main tool to process geoanalytical data. A few Excel Macros based on the author′s experiences for processing of analytical data were introduced in this paper. Application of these Excel Macros has remarkably improved the reliability and efficiency of data processing and has simplified the quality control manager′s work.