岩矿测试2011，Vol.30Issue(1)：116-120,5.
EXCEL在气相色谱-质谱检测中的应用
Application of EXCEL in Gas Chromatography-Mass Spectrometic Analysis
摘要
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 ineorrect 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.关键词
气相色谱-质谱法/EXCEL应用/质量控制/分析方法长期性能/数据确认分类
数理科学引用本文复制引用
刘玉龙,王苏明,刘菲,陈宏坤,范俊欣..EXCEL在气相色谱-质谱检测中的应用[J].岩矿测试,2011,30(1):116-120,5.基金项目
水体污染控制与治理科技重大专项资助--地下水源城市饮用水安全保障共性技术研究与示范(2009ZX07424-002) （2009ZX07424-002）
国土资源地质大调查项目资助--地下水污染测试技术研究(1212010634607) （1212010634607）
