Differences

This shows you the differences between two versions of the page.

--- start [2025/07/10 10:39]
172.69.67.114 old revision restored (2025/07/07 12:32)
+++ start [2025/07/10 10:40] (current)
172.69.67.115 old revision restored (2025/07/07 03:50)
@@ Line 1: / Line 1: @@
-**Overview**
+==== 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
+ QC.png - I don't have rights to upload documents.
+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
+   *  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

Differences

Page Tools