Page locked

This page is currently locked for editing by another user. You have to wait until this user finishes editing or the lock expires.
Currently locked by: 172.71.170.7,216.73.216.60
Lock expires at: 2026/02/22 06:47 (10 min)
This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
==== Overview ====
 
The Merlin AutoGC Xplorer (**MAX**) is a cloud-based database designed to ingest data generated by chromatographic equipment deployed into EPA Photochemical Assessment Monitoring Sites (**PAMS**) which are collecting and analyzing hourly concentrations of up to 60 volatile organic compounds (**VOC**).  MAX is a Structured Query Language (**SQL**) database of the data which includes the necessary information to allow users to view and graphically evaluate the hourly concentration data from these sites.

Orsat, LLC has developed and designed MAX to accommodate data originating from either PerkinElmer Ozone Precursor systems or Agilent systems using Markes International pre-concentration sampling system.  These analytical systems incorporate a thermal desorption sampling system, a gas chromatographic system capable of separating the VOCs of interest and an chromatographic data system to integrate and quantitate the resulting chromatographic output.  The format of the data from the chromatographic data system is generally an ASCII text output which has been formatted specifically for ingestion into the MAX system.  Currently data formats for ingestion into MAX are available for the PerkinElmer Totalchom and Agilent OpenLab EZChrom edition chromatographic data systems.

==== Features ====


The PAMS AutoGC systems collect not only hourly ambient air data but also have Quality Control samples which are outlined in the EPA PAMS Technical Assistance Guidance document (**TAD**).  While most agencies have large databases capable of accumulating ambient data for review by policy makers, they do not always have the ability to review large amounts of quality control data associated with these highly technical systems.  MAX was designed specifically to allow program managers, operators and data validators to review both the ambient data and the quality control samples to evaluate in near real-time the performance of their systems.  Multiple QC sample types are specified by the EPA TAD to reconcile the performance of each analyzer.
 === Quality Control Sample Types ===
  - Calibration Verification Standard (CVS) or Continuing Calibration Verification (CCV) Standard 
      * Required daily
      * Used to confirm system response daily; recoveries generally ± 30% specified in the Network configuration
  - System Blank (SB) or Method Blank
      * Required daily
      * Used to determine concentrations of target compounds which may be contributed by the analytical system
  - Laboratory Calibration Standard (LCS) or Second Source Calibration Verification (SSCV) Standard
      * Required weekly
      * Used to confirm original calibration by reference.
  - Retention Time Standard (RTS)
      * Required weekly
      * Used to verify correct target identification by retention time windows in method.

 QC.png - I don't have rights to upload documents.
=== Format for Incoming Data - ASCII Text ===
The output format for data generated by the analytical data system must adhere to a specific ASCII text format to enable MAX to be able to correctly interpret and store the data.  Orsat has generated output formats for both the Totalchrom and EZChrom data systems.  The user will not only need this format for the output but will need their analytical method to adhere to specific requirements such as target names, response factor format and calibration untis.  Orsat can assist by supplying methods for each analytical and help the user to implement any necessary changes that might be required.



==== Network and Site Configuration ====

In order to allow the evaluation of these QC samples each data set or //Site// has a definition which incorporates configuration parameters for the //Network// which defines information about incoming data such as a list of target VOCs, which targets will be in the QC samples and their concentrations and control limits.  These parameters will be used by the system to calculate and display QC recoveries and threshold exceedances.  A //Network// may have multiple sites or a single site depending on the agency and the number of PAMS sites they operate.  The Network configuration also includes information about the site which is required to generate the EPA required Air Quality System (**AQS**) data file which is submitted for each site to incorporate the ambient data into the EPA AQS system.  
=== Information Required for Network Configuration ===

  - Units (default is ppbC)
  - How Lost data will be displayed
  - How zero values will be displayed
  - Total Blank Maximum value
  - List of Target Compounds by Channel
  - List of Target Compounds in each of the required QC samples (LCS, CVS, RTS, Blank and MDL by channel including required limits or thresholds
  - List of applicable Null, Qualifier and Inform Flags available for use in AQS files.

Each Site also has unique information to identify it in the database.  In addition to a  specific 

=== Information Required for Site Configuration ===

  - Site name (defined in the incoming ASCII text file as "SITE-//x//" where //x// can be from 1-3 characters)
  - Type - designation of data system generating the data, PerkinElmer or EZChrom
  - Minimum display value - generally 0
  - Network assigned to the site
  - AQS number assigned to the site
  - POC if necessary
  - Short name - user entered text field
  - Formal name - user entered text field
  - Address, City and Zipcode
  - Latitude and Longitude
  - UTC offset
  - CAMS code (if available)
  - Interval, units code and method codes required for AQS file generation 


----

   *  Operator
      These rights are given to operators and do not include some features




  *   Validator 

----

**References**

EPA Technical Assistance Document (TAD)
----
https://www.epa.gov/sites/default/files/2019-11/documents/pams_technical_assistance_document_revision_2_april_2019.pdf
----
Orsatmax

User Tools

Site Tools

Page locked

Page Tools
