Application of EXCEL in Gas Chromatography-Mass Spectrometic Analysis

LIU Yu-long; WANG Su-ming; LIU Fei; CHEN Hong-kun; FAN Jun-xin

2011 Vol. 30, No. 1

Article Contents

Article navigation > Rock and Mineral Analysis > 2011 > 30(1): 116-120

Next Article Previous Article

LIU Yu-long, WANG Su-ming, LIU Fei, CHEN Hong-kun, FAN Jun-xin. Application of EXCEL in Gas Chromatography-Mass Spectrometic Analysis[J]. Rock and Mineral Analysis, 2011, 30(1): 116-120.

Citation:

LIU Yu-long, WANG Su-ming, LIU Fei, CHEN Hong-kun, FAN Jun-xin. Application of EXCEL in Gas Chromatography-Mass Spectrometic Analysis[J]. Rock and Mineral Analysis, 2011, 30(1): 116-120.

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

Received Date: 13 September 2009

Revised Date: 18 January 2010

Publish Date: 28 February 2011

Abstract

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