P & A Criteria Pollutant Quality Indicator Summary Data Extraction Report (AMP255)

The P&A Criteria Pollutant Quality Indicator Summary standard report provides statistical estimates of the precision, bias, and accuracy of monitors for criteria air pollutants, and it summarizes the completeness of monitor checks from which the statistical estimates are derived. The module’s primary purpose is to produce a set of spreadsheets used by the Emissions, Monitoring, and Analysis Division of OAQPS to publish annual quality indicator reports for the criteria air pollutant monitoring networks operated by state, local, and tribal agencies.

P & A Criteria Pollutant Quality Indicator Summary Data Extraction Report (AMP255) User Guide

Report output consists of comma-delimited data files; there is no formatted (printable) report. Report output is delivered as a compressed archive (zip) file containing:

·       ·   35 Comma-delimited (CSV) files
The quality indicator summary values produced by the report. Each file contains pollutant-specific values. (See descriptions below.) All 35 files are included, even if some of them contain no data due to selection criteria or report options.

·       ·   1 Microsoft Excelä file (amp255.xls)
A "master" spreadsheet containing macros that automatically create six Excel workbooks and load quality indicator summary data into them from CSV files.

·       ·   1 PDF file – A description of the selection criteria and options used to run the report.

·       ·   1 Text file – A "README" file describing how to use the CSV data files.

Contents of CSV Files and Excel Spreadsheets

The table below lists the type of quality indicator summary data in each CSV file. CSV files are designated by a numeric file name suffix, listed in the first column of the table. The table also indicates how the data from CSV files are organized in Excel workbooks created automatically by the master spreadsheet, amp255.xls

CSV File Suffix

Excel Worksheet Tab Label

File / Worksheet Contents

0

 

Lists the pairings of CSV data files and template Excel worksheets. The file is used primarily for the automated loading process, but it also serves as a description of the CSV files for those not using the automated process.

 

Excel workbook: Gaseous QI Completeness Tables.xls

1

CO QC

Table A. Single Point Quality Check Completeness for CO

2

CO PEC

Table B. Performance Evaluation Check Completeness for CO

3

NO2 QC

Table C. Single Point Quality Check Completeness for NO2

4

NO2 PEC

Table D. Performance Evaluation Check Completeness for NO2

5

O3 QC

Table E. Single Point Quality Check Completeness for O3

6

O3 PEC

Table F. Performance Evaluation Check Completeness for O3

7

SO2 QC

Table G. Single Point Quality Check Completeness for SO2

8

SO2 PEC

Table H. Performance Evaluation Check Completeness for SO2

 

Excel workbook: Precision and Accuracy Tables.xls

9

CO NSP

Table I. Single Point Precision and Bias Estimates for CO NSP Sites

10

CO Other

Table K. Single Point Precision and Bias Estimates for CO Non-NSP Sites

11

CO ACC NSP

Table M. Reporting Org. Accuracy Summary for CO NSP Sites

12

CO ACC Other

Table N. Reporting Org. Accuracy Summary for CO Non-NSP Sites

13

NO2 NSP

Table O. Single Point Precision and Bias Estimates for NO2 NSP Sites

14

NO2 Other

Table Q. Single Point Precision and Bias Estimates for NO2 Non-NSP Sites

15

NO2 ACC NSP

Table S. Reporting Org. Accuracy Summary for NO2 NSP Sites

16

NO2 ACC Other

Table T. Reporting Org. Accuracy Summary for NO2 Non-NSP Sites

17

O3 NSP

Table U. Single Point Precision and Bias Estimates for O3 NSP Sites

18

O3 Other

Table W. Single Point Precision and Bias Estimates for O3 Non-NSP Sites

19

O3 ACC NSP

Table Y. Reporting Org. Accuracy Summary for O3 NSP Sites

20

O3 ACC Other

Table Z. Reporting Org. Accuracy Summary for O3 Non-NSP Sites

21

SO2 NSP

Table AA. Single Point Precision and Bias Estimates for SO2 NSP Sites

22

SO2 Other

Table CC. Single Point Precision and Bias Estimates for SO2 Non-NSP Sites

23

SO2 ACC NSP

Table EE. Reporting Org. Accuracy Summary for SO2 NSP Sites

24

SO2 ACC Other

Table FF. Reporting Org. Accuracy Summary for SO2 Non-NSP Sites

 

Excel workbook: PM10 Tables.xls

25

Automated Precision

Table II. Automated PM10 Precision Completeness

26

Automated Accuracy

Table JJ. Automated PM10 Accuracy Completeness

27

Manual Precision

Table KK. Manual PM10 Precision

28

Manual Accuracy

Table LL. Manual PM10 Accuracy Completeness

 

Excel workbook: PM2_5 Tables.xls

29

Collocation

Table GG. PM2.5 Collocation Summaries

30

FlowRate

Table HH. PM2.5 Flow Rate Completeness

 

Excel workbook: Lead Tables.xls

31

Collocation

Table MM. Pb Collocation Completeness

32

FlowRate

Table NN. Pb Flow Rate Completeness

33

FilterStrips

Table OO. Pb Filter Strip Completeness

 

Excel workbook: Agencies.xls

34

Agencies

Table PP. Reporting Agencies