EXCEL在气相色谱-质谱检测中的应用

刘玉龙; 王苏明; 刘菲; 陈宏坤; 范俊欣

EXCEL在气相色谱-质谱检测中的应用

1.
中国石油集团安全环保技术研究院, 北京 100085
2.
中国地质大学(北京)水资源与环境工程北京市重点实验室, 北京 100083
3.
国家地质实验测试中心, 北京 100037
4.
中国地质大学(北京)水资源与环境工程北京市重点实验室, 北京 100083
5.
中国石油集团安全环保技术研究院, 北京 100085
6.
中国石油集团安全环保技术研究院, 北京 100085

基金项目:

国土资源地质大调查项目资助——地下水污染测试技术研究(1212010634607)

水体污染控制与治理科技重大专项资助——地下水源城市饮用水安全保障共性技术研究与示范(2009ZX07424-002)

计量
- 文章访问数: 1824
- HTML全文浏览量: 4
- PDF下载量: 1243
出版历程
- 收稿日期: 2009-09-12
- 修回日期: 2010-01-17

Application of EXCEL in Gas Chromatography-Mass Spectrometic Analysis

1.
Research Institute of Safety and Environmental Technology, China National Petroleum Corporation (CNPC), Beijing 100085, China
2.
Beijing Key Laboratory of Water Resources and Environmental Engineering, China University of Geosciences (Beijing), Beijing 100083, China
3.
National Research Center for Geoanalysis, Beijing 100037, China
4.
Beijing Key Laboratory of Water Resources and Environmental Engineering, China University of Geosciences (Beijing), Beijing 100083, China
5.
Research Institute of Safety and Environmental Technology, China National Petroleum Corporation (CNPC), Beijing 100085, China
6.
Research Institute of Safety and Environmental Technology, China National Petroleum Corporation (CNPC), Beijing 100085, China

摘要

摘要: 为了实现自动处理有机色谱分析数据,以Agilent 6890/5973N气相色谱-质谱仪检测地下水中挥发性有机化合物和多环芳烃的数据源为基础,编写了EXCEL应用程序,按批进行数据自动汇总、定性确认和结果计算,设置了对误确认数据的可逆恢复功能;对实验室空白、野外空白、实验室空白加标、实验室平行样、样品基体加标和质控样品回收率等各项质量控制指标进行统计和评价,并对分析方法长期性能的稳定性进行评价;同时生成质量控制报告,提供向数据库录入数据功能。
- 气相色谱-质谱法 /
- /
- EXCEL应用 /
- /
- 质量控制 /
- /
- 分析方法长期性能 /
- /
- 数据确认
Abstract: An EXCEL program for data processing and quality evaluation in determination of volatile organic compounds and polycyclic aromatic hydrocarbons in groundwater by gas chromatography-mass spectrometry (GC-MS) based on the Macros (VBA) was completed. The program provides the functions of source-data gathering from an Agilent 6890-5973N GC-MS, qualitative identification of compounds, calculation of results and reversibly dealing with incorrect confirmed data based on Q-value limits (as a measurement of qualifier ratio). The program also provides the functions of statistics and evaluation for various quality control indexes, such as laboratory reagent blanks, field reagent blanks, reproducibility deviations of laboratory duplicates, recovery of standard addition of the samples, recovery of quality control samples and long-term performance of the analytical method. It also provides functions of forming quality control reports and transferring the data to a database.
- gas /
- chromatography-mass /
- spectrometry /
- /
- EXCEL /
- application /
- /
- quality /
- control