• Core Journal of China
  • DOAJ
  • Scopus
  • Chinese Scientific and Technical Papers and Citations (CSTPC)
  • Chinese Science Citation Database (CSCD)
Advanced Search
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.
shu

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

More Information
  • Received Date: September 12, 2009
  • Revised Date: January 17, 2010
    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.
    • FullText(HTML)
    • References (8)
  • US EPA Method 8260b, Volatile organic compounds by gas chromatography/mass spectrometry (GC/MS)[S].1996.

    US EPA Method 8260b, Volatile organic compounds by gas chromatography/mass spectrometry (GC/MS)[S].1996.
    US EPA Method 8270d, Semivolatile organic compounds by gas chromatography/mass spectrometry (GC/MS)[S].2007.

    US EPA Method 8270d, Semivolatile organic compounds by gas chromatography/mass spectrometry (GC/MS)[S].2007.
    刘玉龙, 刘宏清, 陈萍, 张家祥, 张治军, 廖复东.仪器分析数据处理接口程序[J].岩矿测试,2006,25(3):291-293.
    刘玉龙,缪德仁,王苏明.气相色谱分析数据处理接口程序[J].岩矿测试,2008,27(6):467-469.
    张培新,周康民,高孝礼,胡英泉,王冰.国土资源部南京矿产资源监督检测中心实验室信息管理系统[J].岩矿测试, 2009, 28(1): 32-36.
    王向明, 伏晴艳, 刘红, 谢争.环境监测实验室信息管理系统建设——以上海市环境监测中心为例[J].环境监测管理与技术,2007,19(4): 4-8.
    国家质量技术监督局认证与实验室评审管理司.计量认证/审查认可(验收)评审准则宣贯指南[M].北京:中国计量出版社,2001:99.
    Hovind H, Magnusson B, Krysell M, Lund U, Mä kinen I. Internal quality control-handbook for chemical laboratories [Z].

    Hovind H, Magnusson B, Krysell M, Lund U, Mä kinen I. Internal quality control-handbook for chemical laboratories [Z].
    • Related Articles

  • Related Articles

    [1]Qing-ling ZHAO, Qing-cai LI, Jiang-kun XIE, Qi-peng SHI, Li-jiao CHEN. Health Risk Assessment of Carcinogenic and Non-carcingenic Substances in Underground Water from the Shuangcun Karst System of Central-Southern Shandong Province[J]. Rock and Mineral Analysis, 2016, 35(1): 90-97. DOI: 10.15898/j.cnki.11-2131/td.2016.01.015
    [2]Xiao-chen GUO, Zhu RAO, Ran GAO. Determination of 24 Pesticides including Pyrethroids, Organochlorines and Chlorothalonil in Underground Water by Gas Chromatography[J]. Rock and Mineral Analysis, 2014, 33(3): 406-412.
    [3]Xia WU, Lin-ling TU, Hui YANG, Hua WANG, Xiao-yan ZHU, Mei-liang ZHANG. Contrastive Study of Sample-pretreatment Effects on Analytical Results of Inorganic Carbon Isotopes in Water Sample[J]. Rock and Mineral Analysis, 2013, 32(4): 649-658.
    [4]SONG Xue-ying, JIN Cai-xia, HU Xiao-jun, LI Yu-shuang, LI Hui-ying, YANG Ji-song. Fuzzy Evaluation on the Water Quality of the Taizi River[J]. Rock and Mineral Analysis, 2011, 30(6): 705-708.
    [5]CUI De-song. Determination of Trace Hg in Underground Water by Inductively Coupled Plasma-Atomic Emission Spectrometry with Cu-[J]. Rock and Mineral Analysis, 2011, 30(3): 321-324.
    [6]LIU Xiao-wen. Development and Application of Quality Control System for Inorganic Analysis in Groundwater Contamination Survey[J]. Rock and Mineral Analysis, 2010, 29(5): 580-584.
    [7]LU Guohui, YANG Yongliang, LIU Xiaoduan, HUANG Yi, HE Jun, XU Qing, HUANG Yuanying. Contamination Characteristics of Halohydro-carbons in Surface Water and Ground Water from Shenyang Area[J]. Rock and Mineral Analysis, 2009, 28(4): 316-320.
    [8]YANG Guo-yun, TANG Pei-ying. Determination of Sulfate in Surface Water and Underground Water by Inductively Coupled Plasma-Atomic Emission Spectrometry[J]. Rock and Mineral Analysis, 2009, 28(2): 176-178.
    [9]Application of Quality Control in Water Analysis[J]. Rock and Mineral Analysis, 2008, 27(3): 239-240.
    [10]Rapid Determination of Chemical Oxygen Demand in Environmental Water Samples by Merging Zone Stop-Flow Injection Spectrophotometry[J]. Rock and Mineral Analysis, 2008, 27(2): 87-90.
    • Supplements (0)

Catalog

    Get Citation
    PDF
    XML
    Article views (1824) PDF downloads (1243) Cited by()
    Turn off MathJax
    Article Contents
    ABSTRACT
    References
    Related Articles

    Competent Authorities：China Association for Science and Technology

    Sponsored by：Geological Society of China; National Research Center for Geoanalysis

    Address：No. 26 Baiwanzhuang Road, Xicheng District, Beijing 100037, China Email：ykcs_zazhi@163.com Tel：010-68999562

    京公网安备 11010202008159号 京ICP备2022024991号

    Supported by: Beijing Renhe Information Technology Co., Ltd.  Baidu Analytics

    /

    DownLoad:  Full-Size Img  PowerPoint
    Return
    Return